Definition
The client disability table will contain records for any disability that has ever been reported and any number of these different disability types can still be current or not for a given client. 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.
Data source details
| 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'.
Specific Information:
Used as a flag to filter reported disabilities that have not been deleted. Clients may have more than one current record where multiple disability types are recorded. |
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) |