Definition
A calculated/constructed field based on an SQL process to assign a label identifying a period of time a particular segment/batch of data covers, as represented by a label in the Month - Year format.
Components
Data Element (this item)
-
Data Element ConceptFAP_PROCESS: Date
-
Object ClassFAP_PROCESS
-
PropertyDate
-
-
Value DomainMonth-Year Period Label X
Representation
This representation is based on the value domain for this data element, more information is available at " Month-Year Period Label X ".| Description | This format may be represented with or without separating symbols and in upper or lower case. For example:
|
|---|---|
| Data Type | DATE |
| Format | X |
| Representation Class | Date |
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,