Definition
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 suppliedGeneration -
TEI_Activity Table
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) |