Definition
A calculated/constructed field based on an SQL process to assign an aged date relating to the financial year (start/end)
Components
Data Element (this item)
-
Data Element ConceptFAP_PROCESS: Date
-
Object ClassFAP_PROCESS
-
PropertyDate
-
-
Value DomainDate YYYY-MM-DD
Representation
This representation is based on the value domain for this data element, more information is available at " Date YYYY-MM-DD ".Description | Date YYYY-MM-DD Notation Elements, Meanings and Obligations
|
||||||||
---|---|---|---|---|---|---|---|---|---|
Data Type | DATE | ||||||||
Format | YYYY-MM-DD | ||||||||
Maximum character length | 10 |
Comments
DATE(EXTRACT(YEAR FROM DATE_ADD(DATE(DATE_SUB(ETL_RUN_DT, INTERVAL 3 MONTH)), INTERVAL 6 MONTH))-1,7,1) AS AGED_M_START_DT_FINANCIAL_YEAR_START_DATE,
DATE(EXTRACT(YEAR FROM DATE_ADD(DATE(DATE_SUB(ETL_RUN_DT, INTERVAL 3 MONTH)), INTERVAL 6 MONTH)),6,30) AS AGED_M_START_DT_FINANCIAL_YEAR_END_DATE,