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

Definition

Yet to be defined

Data source details

Provenance records

Generated distributions

Path name Data Element Definition Data Type Format
CLIENT_REF_NO 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)
ADVICE_CASE_REF Person: Case Identifier, X(10)

A system-generated identifier for a case associated with a person in receipt of services.

CHARACTERSTRING X(14)
APPROACH_DATE Service Event: Assistance Request Date, YYYY-MM-DD

The date on which assistance from an agency is requested, expressed as DDMMYYYY.

DATETIME YYYY-MM-DD(T00:00:00)
ADVICE_CASE_CREATED_DATE Application: Created date, DateTime YYYY-MM-DD

The date recorded as the day of a particular month and year, on which an application for services or assistance was created.

DATETIME YYYY-MM-DD(T00:00:00)
HOUSING_OPTION_REF Household: Advice Case Option Reference, Identifier N(7)

A system-generated identifier for the housing option type associated with a household who has applied for housing assistance, as represented by a numeric string.

NUMBERSTRING N(7)
HOUSING_OPTION Household: Housing Option Type, Business Key Code X(10)

A system-generated identifier for the housing option type associated with a household who has applied for housing assistance, as represented by a code.

ALPHASTRING ALPHASTRING
HOUSING_OPTION_CREATED_DATE Household: Housing Option Type, Date YYYY-MM-DD

The date of the creation of the housing option associated with a household who has applied for housing assistance.

DATETIME YYYY-MM-DD(T00:00:00)
HOUSING_OPTION_STATUS Household: Housing Option Status, Code X(10)

The status of a housing option associated with a household who has applied for housing assistance, as represented by a code.

ALPHASTRING ALPHASTRING
HOUSING_OPTION_STATUS_DATE Household: Housing Option Status, Date YYYY-MM-DD

The date of the status of a housing option associated with a household who has applied for housing assistance.

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)
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)
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)