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
ProgramId Data Exchange: Program identifier, Code NN

An identifier for a unique program record in the Data Exchange, represented by a number.

NUMBERSTRING NN
NAME Organisation: Organisation Name, Text X(200)

The full title of an organisation's name by which it trades or is recognised, as represented by text.


Specific Information:
  • NSW - Family and Community Services
  • NSW - Department of Communities and Justice
ALPHANUMERICSTRING X(200)
GPSPROGRAMID Organisation: SystemID, String X(14)

A persistent system generated identifier.


Specific Information:

The program ID within the Grants Payment System (GPS).

  • EXT-1-DCJ
  • EXT-1-FACS
CHARACTERSTRING X(14)
AgencyCode Data Exchange: Agency, Code A(10)

The type of agency responsible for managing service delivery, as represented by a code.

ALPHASTRING A(10)
SYSSTARTTIME 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)
SYSENDTIME 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)
CURRENTRECORD Record: Current Record Indicator, No/Yes Code N

Whether a record is current or active, recorded as a code set representing 'no' and 'yes'.

NUMBERSTRING N
RECORDSEQNBR Record: Sequence Number, NNN

A system generated sequence of numbers that locates a client's historical record who attended one or more services funded to improve wellbeing. This number ensures a record is unique.

INTEGERNUMBER NNN
CreatedDateTime 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)
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)
etl_run_dt 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)