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
-
Target early intervention: _2018_29_4_ti_activity
Statuses: UnregisteredA1.5:TEI Activity data
| 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) |