Definition
Each client with stated disability is recorded in the Client Disability table. There are 5 disability type recorded in the ‘disabilitycode’ column and each Client ID in the table have at least one disability code. A current record flag exist to indicate whether the disabled client is currently active.
Note that if you do an inner join of other tables such as Client table with Client Disability table, the result will only give you clients that are disabled because clients in the Client Disability table only contains disabled clients.
The CLIENT DISABILITY table to contain the following data elements.
Data source details
Provenance records
Generated distributions
-
Target early intervention: _2018_29_4_ti_disability
Statuses: UnregisteredA1.5:TEI disability data
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| CLIENTDISABILITYID | Data Exchange: Client disability identifier, X(19) |
A system-generated identifier for a unique client disability record in the Data Exchange, represented by a number. |
CHARACTERSTRING | X(18) |
| CLIENTID | Data Exchange: Client identifier, X(19) |
A number that represents a system-generated identifier for a unique client record in the Data Exchange. |
CHARACTERSTRING | X(18) |
| DISABILITYCODE | Person: Disability Status, Category A(11) |
The experience of disability, impairment or condition identified by a given person, represented by a label. |
ALPHASTRING | A(11) |
| 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 |
| BATCHID | Record: Batch Id, Text X(200) |
System generated identification generated when (data) ingested into BigQuery, represented by text. |
ALPHANUMERICSTRING | X(200) |