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

Definition

The Activity table is a lookup table for the activity ID and gives you the description of the activity ID. There are 5 current TEI Activities, each with their own activity ID. A current record flag exist to indicate which activity is currently active.

The ACTIVITY table to contain the following data elements.

Data source details

Provenance records

Generated distributions

Path name Data Element Definition Data Type Format
ACTIVITYID Data Exchange: Program activity identifier, Code NNN

A number that represents an identifier for a unique program activity record in the Data Exchange.

NUMBERSTRING NNN
NAME Data Exchange: Program Activity Name, Label X(40)

The label that represents the type of program aimed at supporting vulnerable children, young people, families and communities in NSW, early in life and early in need, to minimise the escalation of vulnerabilities, and reduce the likelihood of children entering the child protection system.

CHARACTERSTRING Text X(40)
PROGRAMID Data Exchange: Program identifier, Code NN

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


Specific Information:

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

NUMBERSTRING NN
GPSPROGRAMID Organisation: SystemID, String X(14)

A persistent system generated identifier.

CHARACTERSTRING X(14)
STARTDATE Organisation: Start Date, YYYYMMDD

The funding start date in relation to a service provider, recorded as a day of a month of a year, represented as YYYYMMDD.

DATE YYYYMMDD
ENDDATE Organisation: End Date, Date YYYYMMDD

The funding end date in relation to a service provider, recorded as a day of a month of a year, represented as YYYYMMDD.

DATE YYYYMMDD
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)
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.


Specific Information:

The date the data warehouse Extract transform & Load (ETL) run last updated.

DATETIME YYYY-MM-DD(T00:00:00)