Definition
A set of files to help convert a date [day/week/month/year & reporting period] from DSS
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| TheDate | Record: Date, YYYY-MM-DD |
Calendar date relating to a record, represented by a sequence of numbers identifying a particular year (YYYY), month (MM), and day (DD) |
DATE | YYYY-MM-DD |
| TheDay | Record: Date, Day DD |
A sequence of numbers identifying a day |
DATE | DD |
| TheDayName | Record: Date, Day Label A(9) |
The name of a particular day of the week |
DATE | A(9) |
| TheWeek | Record: Date, Week NN |
Week number for a particular date |
DATE | NN |
| TheISOWeek | Record: Date, ISO Week NN |
Week number (according to the ISO-8601 standard) for a particular date |
DATE | NN |
| TheDayOfWeek | Record: Date, Day of week N |
A sequence of numbers identifying a day of the week |
DATE | N |
| TheMonth | Record: Date, Month MM |
A sequence of numbers identifying a particular month |
DATE | MM |
| TheMonthName | Record: Date, Month Label A(9) |
The name of a particular month |
DATE | A(9) |
| TheQuarter | Record: Reporting Quarter, Financial Year - Code XN |
A code that represents a quarter of a twelve month accounting period generated to represent the quarter to which the record relates. |
CODE | XN |
| TheYear | Record: Date, Year YYYY |
A sequence of numbers identifying a particular year |
DATE | YYYY |
| TheFirstOfMonth | Record: Date, YYYY-MM-DD |
Calendar date relating to a record, represented by a sequence of numbers identifying a particular year (YYYY), month (MM), and day (DD)
Specific Information:
The first date of a particular month |
DATE | YYYY-MM-DD |
| TheLastOfYear | Record: Date, YYYY-MM-DD |
Calendar date relating to a record, represented by a sequence of numbers identifying a particular year (YYYY), month (MM), and day (DD)
Specific Information:
The last date of a particular year |
DATE | YYYY-MM-DD |
| TheDayOfYear | Record: Date, Day of year NNN |
A sequence of numbers identifying a day (starting with day 1 on January 1st) |
DATE | NNN |
| TheFinancialYear | Record: Financial Year, YYYY-YY |
The fiscal year or twelve month accounting period, which in Australia commences 1 July of a given calendar year and ends 30 June of the following calendar year relating to a report. |
NUMBERSTRING | N(4)-N(2) |
| TheReportingPeriod | Record: Reporting Period, Date Range MMM-MMM YYYY |
The reporting period for a particular date |
CHARACTERSTRING | MMM-MMM YYYY |
| ReportingPeriodEndTime | Record: Reporting Period, DateTime YYYY-MM-DD[Thh:mm:ss] |
The end date and time of a reporting period for a particular date |
DATETIME | YYYY-MM-DD(T00:00:00) |
| INGESTTIME | Record: DateTime Stamp, YYYY-MM-DD |
A sequence of characters or encoded information identifying when a certain event occurred, on what day, and optionally including what particular time of day. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| INGESTTYPE | Record: Ingest Type, Label A(6) |
File (data) ingestion process type, represented by a label. |
ALPHASTRING | A(6) |
| FILENAME | Record: Filename, Text X(200) |
File name (data) ingested into BigQuery, represented by text. |
ALPHANUMERICSTRING | X(200) |
| BATCHID | Record: Batch Id, Text X(200) |
System generated identification generated when (data) ingested into BigQuery, represented by text. |
ALPHANUMERICSTRING | X(200) |