Definition
A table collecting the specific types of services that are the basis of a session with a client, to be linked with other DEX tables in the data set.
Data source details
| Path name | Data Element | Definition | Data Type | Physical Data Type | Format |
|---|---|---|---|---|---|
| SERVICETYPEID | Session: Service Activity Type, Code N(4) |
The main focus of service delivery at a given session, as represented by a numeric code. |
NUMBERSTRING | - | N(4) |
| NAME | Session: Service Activity Type, Label X(50) |
The main focus of service delivery at a given session, as represented by a label. |
CHARACTERSTRING | - | X(50) |
| ISACTIVE | 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 |
| SERVICETYPEGROUPCODE | Session: Service Activity Type, GroupCode A(20) |
The grouped focus of service delivery, as represented by a label. |
ALPHASTRING | - | A |
| CREATEDBY | Person: Staff Identifier X(30) |
A label representing an individual who performed an action within a particular system, as generated by that system. |
CHARACTERSTRING | - | X |
| 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) |
| UPDATEDBY | Person: Staff Identifier X(30) |
A label representing an individual who performed an action within a particular system, as generated by that system. |
CHARACTERSTRING | - | X |
| UPDATEDDATETIME | 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) |
| DELETEDBY | Person: Staff Identifier X(30) |
A label representing an individual who performed an action within a particular system, as generated by that system. |
CHARACTERSTRING | - | X |
| 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) |
| INGESTYPE | 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) |