Definition
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| ProgramId | Data Exchange: Program identifier, Code NN | An identifier for a unique program record in the Data Exchange, represented by a number. | NUMBERSTRING | NN |
| NAME | Organisation: Organisation Name, Text X(200) | The full title of an organisation's name by which it trades or is recognised, as represented by text. Specific Information:
| ALPHANUMERICSTRING | X(200) |
| 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) |
| AgencyCode | Data Exchange: Agency, Code A(10) | The type of agency responsible for managing service delivery, as represented by a code. | ALPHASTRING | A(10) |
| 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) |
| 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) |
| 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. | DATETIME | YYYY-MM-DD(T00:00:00) |