Skip to content Learn about the access keys available for Metadata.NSW
A NSW Government website
Metadata.NSW (beta)

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)

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

Element Meaning
YYYY A four digit year
MM A zero-padded month between 01 and 12
DD A zero-padded day between 01 and 31
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,

Related content

Relation Count
Input in Derivations 0
Output in Derivations 0
Inclusion in Data Set Specifications 0
Inclusion in Data Distributions 2
As a numerator in an Indicator 3
As a denominator in an Indicator 0
As a disaggregation in an Indicator 0