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 | 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) |