Definition
Data source details
| 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.
Specific Information:
Organisations delivering services directly to clients. These organisations may receive funding directly or through a Funding Recipient. |
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'.
Specific Information:
Where a client does not wish to disclose their real name, the organisation should indicate that a pseudonym is being used and record a pseudonym that ideally is used again if the client returns for other services. |
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.
Specific Information:
Service Providers are given the option to record an estimated date of birth for clients. Where a provider selects to report an estimated birth date, as recorded by the BirthDateEstimated field, providers will only be asked to enter the year of birth. In this case, the date of birth will always be recorded as 1 January. The use of this varies by Service Provider |
NUMBERSTRING | N |
| BIRTHMONTH | Person: Date of birth, Month MM |
The month a given client was born, represented by MM.
Specific Information:
Null where BirthDateEstimated = 1 (TRUE), Service Providers have entered the year of month only - and date of birth is recorded as 1 January within the DEX database. Where providers record full date of birth rather than choosing to record an estimated date of birth, we still do observe large counts of values such as 1 Jan 1900 recorded for example although full date has been recorded, further judgement to determine data quality of such records might be considered. This practice varies by service provider, service delivery method and by activity BirthMonth = CASE when client.BirthDateEstimated = 0 then DATEPART(MONTH, client.BirthDate) else NULL END" |
DATE | MM |
| BIRTHYEAR | Person: Date of birth, Year YYYY |
The year a given client was born, represented by YYYY.
Specific Information:
BirthYear = DATEPART(YEAR, client.BirthDate) |
DATE | YYYY |
| GENDERCODE | Person: Sex, Gender Label A(8) |
The sex identified by a person, represented by a label. |
ALPHASTRING | A(9) |
| CLIENTLOCALITY | Person: Suburb/town/locality name, Text X(50) |
The full name of the locality 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) 2016 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) 2016 code |
The main language spoken at home by a given client, 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'.
Specific Information:
This is derived from BirthCountryCode & MainLanguageCode |
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.
Specific Information:
Records the date a client first arrived in Australia where appropriate for a funded activity. This field is primarily included as an eligibility indicator for the Settlement Engagement and Transition Support (SETS) Program. It can also be used as a potential indicator of disadvantage for other program activities. |
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.
Specific Information:
Clients nominate the accommodation setting category that best describes their situation. |
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.
Specific Information:
Household composition is classified into standard categories that are adapted from the data collection definitions used by AIHW. Household composition is adapted to include data on whether the client is homeless. |
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, NDIS Eligibility Code A(10) |
The status of a client's eligibility to access NDIS support who attended one or more services funded to improve their wellbeing, participation and/or independence, recorded as a code that represents a client's NDIS eligibility status. |
ALPHASTRING | A(10) |
| 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)
Specific Information:
An organisation using the Data Exchange as a client records system will need to: DSS will not store the client's name or pseudonym, and/or street-level address on the Data Exchange unless this consent is obtained. To meet DSS's obligations under the Privacy Act, the required consent is to be recorded in the Data Exchange. For organisations using the web-based portal, consent is recorded using the tick box provided when creating or editing a client. When reporting client-level records through bulk uploading of files or a system-to-system transfer, this consent is to be recorded in these files. Organisations are required to record that a client has consented in the Data Exchange, however they are not required to provide copies of the client's consent to DSS. Organisations should determine their own record keeping procedures in relation to client consent. Client first name and last name, address line 1 and line 2 are not stored on DEX database. Geo coding relies on client locality, suburb and state only." |
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)
Specific Information:
Funding agencies and third parties (such as universities) are interested in commissioning future research to better understand client needs and find opportunities to improve service delivery. Obtaining client consent to participate in research will create an indicative pool of willing participants for future research projects. |
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.
Specific Information:
The method by which the data was captured. |
ALPHASTRING | A(2) |
| 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. |
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. |
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. |
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. |
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. |
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. |
NUMBERSTRING | N(9) |
| SA12021BoundaryCode | - | - | - | - |
| SA22021BoundaryCode | - | - | - | - |
| SA32021BoundaryCode | - | - | - | - |
| SA42021BoundaryCode | - | - | - | - |
| STE2021BoundaryCode | - | - | - | - |
| ACPR2018BoundaryCode | - | - | - | - |
| LGA2021BoundaryCode | - | - | - | - |
| 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) |
| 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) |
| 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.
|
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. |
NUMBERSTRING | N(5) |
| DCJ_NAME_2019 | Person: NSW Department of Communities and Justice District, Label A(25) |
The area (district) where the NSW Department of Communities and Justice (DCJ) is responsible for the delivery of services to a child or young person, as represented by a label. |
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 | Person: NSW Department of Communities and Justice District, Label A(25) |
The area (district) where the NSW Department of Communities and Justice (DCJ) is responsible for the delivery of services to a child or young person, as represented by a label. |
ALPHASTRING | A(25) |
| 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) |