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

Definition

A1.5:TEI Activity data

Data source details

Provenance records

Source distributions

  • Source Distributions
    • TEI_Activity Table
      Statuses: [FACSIAR Data Governance Committee: Standard, April 8, 2021]
      The Activity table is a lookup table for the activity ID and gives you the description of the activity ID....
    Release Date No release date supplied
    Generation
Path name Data Element Definition Data Type Format
ProgramId_hashed Data Exchange: Program identifier, Code NN

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


Specific Information:
Data Type: Text category
Field Description: Data Exchange: Program identifier, Code NN
Field Start Date: 2018-11-27 00:00:00
Field End Date2019-08-31 00:00:00
NUMBERSTRING NN
GPSProgramId_hashed Organisation: SystemID, String X(14)

A persistent system generated identifier.


Specific Information:
Data Type: Text category
Field Description: Organisation: SystemID, String X(10)
Field Start Date: 2018-11-27 00:00:00
Field End Date2019-08-31 00:00:00
CHARACTERSTRING X(14)
ActivityId_hashed Data Exchange: Program activity identifier, Code NN

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


Specific Information:
Data Type: Text category
Field Description: Data Exchange: Program activity identifier, Code NN
Field Start Date: 2018-11-27 00:00:00
Field End Date2019-08-31 00:00:00
NUMBERSTRING NN
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.


Specific Information:
Data Type: Numeric category
Field Description: Record: Sequence Number, NNN
Field Start Date: 2018-11-27 00:00:00
Field End Date2019-08-31 00:00:00
INTEGERNUMBER NNN
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'.


Specific Information:
Data Type: Numeric category
Field Description: Record: Current Record Indicator, No/Yes Code N
Field Start Date: 2018-11-27 00:00:00
Field End Date2019-08-31 00:00:00
NUMBERSTRING N
SysEndTime - -
Specific Information:
Data Type: Date
Field Description: Record: DateTime Stamp, DateTime YYYY-MM-DD[Thh:mm:ss]
Field Start Date: 2018-11-27 00:00:00
Field End Date2019-08-31 00:00:00
- -
SysStartTime - -
Specific Information:
Data Type: Date
Field Description: Record: DateTime Stamp, DateTime YYYY-MM-DD[Thh:mm:ss]
Field Start Date: 2018-11-27 00:00:00
Field End Date2019-08-31 00:00:00
- -
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.


Specific Information:
Data Type: Date
Field Description: Organisation: End Date, Date YYYYMMDD
Field Start Date: No data after dropping nulls
Field End DateNo data after dropping nulls
DATE YYYYMMDD
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.


Specific Information:
Data Type: Date
Field Description: Organisation: Start Date, YYYYMMDD
Field Start Date: 2019-08-01 00:00:00
Field End Date2019-08-31 00:00:00
DATE YYYYMMDD
Name Targeted Earlier Intervention (TEI) Program: Program Activity Name, Code 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.


Specific Information:
Data Type: Text category
Field Description: Targeted Earlier Intervention (TEI) Program: Program Activity Name, Code X(40)
Field Start Date: 2018-11-27 00:00:00
Field End Date2019-08-31 00:00:00
CHARACTERSTRING Text X(40)