Definition
Data source details
| 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. |
NUMBERSTRING | NN |
| GPSPROGRAMID | Organisation: SystemID, String X(14) |
A persistent system generated identifier.
Specific Information:
The program ID within the Grants Payment System (GPS). |
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 |
| 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) |