Skip to content Learn about the access keys available for Metadata.NSW
A NSW Government website
Metadata.NSW (beta)

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.
A service provider can delete a disability record, in which case CurrentRecord will be 0 and SYSENDTIME will be populated with the time that the service provider reported the disability was no longer current.

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)