Definition
The Client table stores the demographic details of each individual client including their date of birth, Aboriginal status, Culturally and Linguistically Diverse status, home postcode etc. You can also get the Statistical Linkage Key (SLK) from the Client table. Some of the fields in the Client table are optional such as Education Level, Employment Status and Primary Source of income. A Current Record flag exist to indicate whether the client is currently active.
The Client ID in the Client table can be linked with other tables which also has the client ID.
CLIENT table to contain the following data elements.
Data source details
Provenance records
Generated distributions
-
Target early intervention: _2018_29_4_ti_client
Statuses: UnregisteredA1.5:TEI client data
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| 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) |
| DELIVERYORGID | Data Exchange: Delivery Organisation identifier, X(19) |
A number that represents a system-generated identifier for a unique service provider record in the Data Exchange of an organisation that has been directed to provide services. |
CHARACTERSTRING | X(18) |
| SLK | Record: Linkage key, code 581 XXXXXDDMMYYYYX |
A key that enables two or more records belonging to the same individual to be brought together. It is represented by a code consisting of the second, third and fifth characters of a person’s family name, the second and third letters of the person’s given name, the day, month and year when the person was born and the sex of the person, concatenated in that order. |
ALPHANUMERICSTRING | XXXXXDDMMYYYYX |
| ISPSEUDONYM | Person: Pseudonym Indicator, No/Yes Code N |
Whether the name used is fictitious or an alias of a human being, recorded as a numeric code representing 'true' or 'false'. |
NUMBERSTRING | N |
| BIRTHDATE | Person: Date of Birth, YYYYMMDD |
The date of birth of the person, expressed as YYYYMMDD. |
DATE | YYYYMMDD |
| BIRTHDATEESTIMATED | Date: Estimate indicator, No/Yes Code N |
An indicator of whether any component of a reported date was estimated. |
NUMBERSTRING | N |
| BIRTHMONTH | Person: Date of birth, Month MM |
The month a given client was born, represented by MM. |
DATE | MM |
| BIRTHYEAR | Person: Date of birth, Year YYYY |
The year a given client was born, represented by YYYY. |
DATE | YYYY |
| GENDERCODE | Person: Sex, Gender Label A(8) |
The gender identified by a person, as represented by a label. |
ALPHASTRING | A(9) |
| CLIENTLOCALITY | Person: Locality Name, Text X(50) |
The full name of the locality, suburb or town contained within the specific address of a person, as represented by text. |
ALPHANUMERICSTRING | X(50) |
| CLIENTSTATE | Person: Australian State/Territory Identifier, Code X(3) |
The code that represents the Australian state or territory where a person can be located. |
ALPHASTRING | X(3) |
| CLIENTPOSTCODE | Person: Australian Postcode, Code NNNN |
The numeric descriptor for an Australian postal delivery area, aligned with locality, suburb or place for the address of a person. |
NUMBERSTRING | NNNN |
| ANCESTRYCODE | Person: Ancestral cultural and ethnic group, (ASCCEG) code |
The ancestral, cultural, and/or ethnic origin identified by a given client, represented by a code. |
NUMBERSTRING | NNNN |
| ATSICODE | Person: Indigenous Status, Label A(10) |
The Aboriginal and/or Torres Strait Islander origin identified by a given client, represented by a label. |
ALPHASTRING | A(10) |
| BIRTHCOUNTRYCODE | Person: Country of birth, code (SACC 2016) NNNN |
The country in which the person was born, as represented by a code. |
NUMBERSTRING | NNNN |
| MAINLANGUAGECODE | Person: Main language spoken at home, Australian Standard Classification of Languages (ASCL) code |
The main language spoken at home by an individual, represented by a code. |
NUMBERSTRING | NNNN |
| CALDSTATUS | Person: Culturally and Linguistically Diverse Indicator, label A(8) |
An indication of the cultural and linguistic background, based on whether or not an individual was born in a country other than Australia, has a cultural background other than Australian, can speak languages other than English, recorded as a label set representing 'CALD' and 'not CALD'. |
ALPHASTRING | A(8) |
| MIGRATIONVISACODE | Person: Migration visa type, label |
The migration visa category granted by Australia to a person, represented by a label. |
ALPHASTRING | A(12) |
| MIGRATIONARRIVALMONTH | Person: Date of first arrival in Australia, Month MM |
The calendar month a person emigrated to Australia with the intention of staying at least one year. |
DATE | MM |
| MIGRATIONARRIVALYEAR | Person: Date of first arrival in Australia, Year YYYY |
The calendar year a person emigrated to Australia with the intention of staying at least one year. |
DATE | YYYY |
| EDUCATIONLEVELCODE | Person: Highest level of education or qualification, Label X(50) |
The highest level of education or qualification achieved by a person, represented by a label. |
ALPHASTRING | A(14) |
| EMPLOYMENTSTATUSCODE | Person: Employment status, Label |
The employment status of a person, whether employed or another role, represented by a label. |
ALPHASTRING | A(17) |
| DVACARDSTATUSCODE | Person: Department of Veterans Affairs (DVA) Card Status, Code X(6) |
The DVA Card status linked to a person, as represented by a code. If this element is provided then it is must have value. Mandatory based on Activity Specific Requirement with Code as “DVACARDSTATUS” |
ALPHANUMERICSTRING | X(6) |
| INCOMESOURCECODE | Person: Main source of income, Label |
The main source of income for a person, represented by a label. |
ALPHASTRING | A(12) |
| INCOMEAMOUNT | Person: Assessable income, Total Australian currency N(8) |
The value of income per week from all sources as specified and used by the agency to establish eligibility of a person for receipt of housing assistance expressed as dollars and cents. |
INTEGERNUMBER | N(8) |
| INCOMEFREQUENCYCODE | Person: Income Frequency, Label |
A measure of a period of time for which an amount is being paid to a person, recorded as the code set representing the frequency of recurrence. |
CHARACTERSTRING | X(11) |
| ACCOMMODATIONTYPECODE | Person: Accommodation setting, label |
The accommodation setting that best describes the living arrangement or lodging situation of person, represented by a label. |
ALPHASTRING | A(13) |
| HOMELESSCODE | Person: Homelessness status, Label |
The experience of unstable, inadequate or non-permanent housing identified by person, represented by a label. |
ALPHASTRING | A(6) |
| HOUSEHOLDCOMPOSITIONCODE | Person: Household Composition, Label A(10) |
The household composition for a person, represented by a label. |
ALPHASTRING | A(10) |
| ISCARER | Person: Is a carer, Flag |
Whether a person is a carer in a carer relationship, represented by a flag. |
NUMBERSTRING | N |
| HASCARER | Person: Has a carer, Flag |
Whether a person is the care recipient in a carer relationship, represented by a flag. |
NUMBERSTRING | N |
| NDISELIGIBILITYCODE | Person: Disability group, code N |
The disability group that most clearly expresses the experience of disability by a person as represented by a code. |
NUMBERSTRING | N |
| IDENTIFIEDCONSENTGIVEN | Record: Consent Indicator, No/Yes Code N |
Whether consent is given or not, recorded as a code set representing 'no' and 'yes'. (0 and 1) |
NUMBERSTRING | N |
| CONTACTCONSENTGIVEN | Record: Consent Indicator, No/Yes Code N |
Whether consent is given or not, recorded as a code set representing 'no' and 'yes'. (0 and 1) |
NUMBERSTRING | N |
| 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 |
| INSERTMETHODCODE | Record: Insert Method, Code A(2) |
A number that ensures a record is unique. |
ALPHASTRING | A(2) |
| MB2016BOUNDARYCODE | Person: Area of usual residence, Mesh Block (MB) code (ASGS 2016) N(11) |
The geographical region represented by a Mesh Block (MB) code set in which a person or group of people usually reside.
Specific Information:
No-longer used. Data captured from 31/12/2019 to 31/12/2021. |
NUMBERSTRING | N(11) |
| SA12016BOUNDARYCODE | Person: Area of usual residence, Statistical area level 1 (SA1) code (ASGS 2016) N(11) |
The geographical region represented by a Statistical area level 1 (SA1) code set in which a person or group of people usually reside.
Specific Information:
No-longer used. Data captured from 31/12/2019 to 30/06/2024. |
NUMBERSTRING | N(11) |
| SA22016BOUNDARYCODE | Person: Area of usual residence, Statistical area level 2 (SA2) code (ASGS 2016) N(9) |
The geographical region represented by a Statistical area level 2 (SA2) code set in which a person or group of people usually reside.
Specific Information:
No-longer used. Data captured from 31/12/2019 to 30/06/2024. |
NUMBERSTRING | N(9) |
| SA32016BOUNDARYCODE | Person: Area of usual residence, Statistical area level 3 (SA3) code (ASGS 2016) N(5) |
The geographical region represented by a Statistical area level 3 (SA3) code set in which a person or group of people usually reside.
Specific Information:
No-longer used. Data captured from 31/12/2019 to 30/06/2024. |
NUMBERSTRING | N(5) |
| SA42016BOUNDARYCODE | Person: Area of usual residence, Statistical area level 4 (SA4) code (ASGS 2016) NNN |
The geographical region represented by a Statistical area level 4 (SA4) code set in which a person or group of people usually reside.
Specific Information:
No-longer used. Data captured from 31/12/2019 to 30/06/2024. |
NUMBERSTRING | NNN |
| STE2016BOUNDARYCODE | Person: Australian State/Territory Identifier, Code X(3) |
The code that represents the Australian state or territory where a person can be located.
Specific Information:
No-longer used. Data captured from 31/12/2019 to 30/06/2024. |
ALPHASTRING | X(3) |
| ACPR2015BOUNDARYCODE | Person: Area of usual residence, Aged Care Planning Region Code N(9) |
The geographical region represented by an Aged Care Planning Region in which a person is usually resides.
Specific Information:
No-longer used. Data captured from 31/12/2019 to 30/06/2024. |
NUMBERSTRING | N(9) |
| SA12021BOUNDARYCODE | You don't have permission to see this Data Element. |
-
Specific Information:
Data captured from 01/07/2024 onwards |
- | - |
| SA22021BOUNDARYCODE | You don't have permission to see this Data Element. |
-
Specific Information:
Data captured from 01/07/2024 onwards |
- | - |
| SA32021BOUNDARYCODE | Person: Area of usual residence, Statistical area level 3 (SA3) code (ASGS 2016) N(5) |
The geographical region represented by a Statistical area level 3 (SA3) code set in which a person or group of people usually reside.
Specific Information:
Data captured from 01/07/2024 onwards |
NUMBERSTRING | N(5) |
| SA42021BOUNDARYCODE | Person: Area of usual residence, Statistical area level 4 (SA4) code (ASGS 2016) NNN |
The geographical region represented by a Statistical area level 4 (SA4) code set in which a person or group of people usually reside.
Specific Information:
Data captured from 01/07/2024 onwards |
NUMBERSTRING | NNN |
| STE2021BOUNDARYCODE | Person: Australian State/Territory Identifier, Code N |
The code that represents the Australian state or territory where a person can be located.
Specific Information:
Data captured from 01/07/2024 onwards |
INTEGERNUMBER | N |
| ACPR2018BOUNDARYCODE | Person: Area of usual residence, Aged Care Planning Region Code N(9) |
The geographical region represented by an Aged Care Planning Region in which a person is usually resides.
Specific Information:
Data captured from 01/07/2024 onwards |
NUMBERSTRING | N(9) |
| LGA2021BOUNDARYCODE | Person: Area of usual residence, LGA Code N(5) |
A code that represents the NSW Local Government Area in which a person or group of people usually reside.
Specific Information:
Data captured from 01/07/2024 onwards |
NUMBERSTRING | N(5) |
| 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) |
| 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) |
| AECFED2016BOUNDARYCODE | Person: Area of usual residence, Federal Electorate Label X(50) |
The Australian Electoral Commission (Federal) electoral division boundaries in which a person or group of people usually reside, as represented by a label.
Specific Information:
No-longer used. Data captured up to 30/06/2023 |
CHARACTERSTRING | - |
| LGA2016BOUNDARYCODE | Person: Area of usual residence, LGA Code N(5) |
A code that represents the NSW Local Government Area in which a person or group of people usually reside.
Specific Information:
No-longer used. Data captured from 30/06/2023 to 30/06/2024. |
NUMBERSTRING | N(5) |
| DCJ_NAME_2019 | Organisation: NSW Department of Communities and Justice District, Label A(25) |
A label that represents the area where the NSW Department of Communities and Justice (DCJ) are responsible for the delivery of DCJ services across Community Services and Housing of an organisation that provides services and/or care. |
ALPHASTRING | A(25) |
| SERVICEAREATYPE | Data Exchange: Service Area Type, Name X(18) |
The type or category of area within which a service is being delivered, as represented by a label. |
CHARACTERSTRING | X(18) |
| SERVICEAREANAME | Organisation: NSW Department of Communities and Justice District, Label A(25) |
A label that represents the area where the NSW Department of Communities and Justice (DCJ) are responsible for the delivery of DCJ services across Community Services and Housing of an organisation that provides services and/or care. |
ALPHASTRING | A(25) |
| MIGRATIORRIVALYEAR | Person: Date of first arrival in Australia, Year YYYY |
The calendar year a person emigrated to Australia with the intention of staying at least one year. |
DATE | YYYY |
| 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) |