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

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)