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

Definition

Data source details

Path name Data Element Definition Data Type Format
BATCHID Record: Batch Id, Text X(200)

System generated identification generated when (data) ingested into BigQuery, represented by text.

ALPHANUMERICSTRING X(200)
CLIENTREFNO Person: Client Reference, Number N(7)

A system-generated identifier for an individual who is a client of an organisation or service provider, as represented by a number.

NUMBERSTRING N(7)
EXTRACT_DATE Record: Report Extraction Date, YYYY-MM-DD

The date represented as year, month, day on which a report was extracted from a data source.

DATETIME YYYY-MM-DD(T00:00:00)
EXTRACT_ID Record: Identifier, N(8)

A sequence of characters represented as a numeric string which uniquely identifies a data warehouse record.

NUMBERSTRING N(8)
FILENAME Record: Filename, Text X(200)

File name (data) ingested into BigQuery, represented by text.

ALPHANUMERICSTRING X(200)
INCOMEENDDATE Person: Income Effective To Date, YYYY-MM-DD

The date the client income is effective to.

DATETIME YYYY-MM-DD(T00:00:00)
INCOMEREFERENCE Person: Income, Identifier N(8)

An individual's income, as represented by a unique numeric identifier.

NUMBERSTRING N(8)
INCOMESTARTDATE Person: Income Effective From Date, YYYY-MM-DD

The date the client income is effective from.

DATETIME YYYY-MM-DD(T00:00:00)
INCOMESTATUS Person: Income Status, Verified/Unverified Code XXX

A code that represents whether the income status of a person has been verified.

ALPHASTRING XXX
INCOMETYPE Person: Source of Income, Code X(10)

The source of income for an individual., represented by a code.

CHARACTERSTRING X(10)
INCOMETYPEDESCRIPTION Person: Source of Income, Code X(10)

The source of income for an individual., represented by a code.

CHARACTERSTRING X(10)
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)
TOTALWEEKLYINCOME Person: Gross Income, Total Australian Currency N(8)

The total value of an individual's income per week from all sources before any deductions such as income tax and superannuation, expressed as dollars and cents.

INTEGERNUMBER N(8)