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

TEI_Client Table

Download CSV
Logical Path Data Element Number of Unique Values Uniqueness Score Min Max Average
CLIENTID Data Exchange: Client identifier, X(19) - - - - -
DELIVERYORGID Data Exchange: Delivery Organisation identifier, X(19) - - - - -
SLK Record: Linkage key, code 581 XXXXXDDMMYYYYX - - - - -
ISPSEUDONYM Person: Pseudonym Indicator, No/Yes Code N - - - - -
BIRTHDATE Person: Date of Birth, YYYYMMDD - - - - -
BIRTHDATEESTIMATED Date: Estimate indicator, No/Yes Code N - - - - -
BIRTHMONTH Person: Date of birth, Month MM - - - - -
BIRTHYEAR Person: Date of birth, Year YYYY - - - - -
GENDERCODE Person: Sex, Gender Label A(8) - - - - -
CLIENTLOCALITY Person: Locality Name, Text X(50) - - - - -
CLIENTSTATE Person: Australian State/Territory Identifier, Code X(3) - - - - -
CLIENTPOSTCODE Person: Australian Postcode, Code NNNN - - - - -
ANCESTRYCODE Person: Ancestral cultural and ethnic group, (ASCCEG) code - - - - -
ATSICODE Person: Indigenous Status, Label A(10) - - - - -
BIRTHCOUNTRYCODE Person: Country of birth, code (SACC 2016) NNNN - - - - -
MAINLANGUAGECODE Person: Main language spoken at home, Australian Standard Classification of Languages (ASCL) code - - - - -
CALDSTATUS Person: Culturally and Linguistically Diverse Indicator, label A(8) - - - - -
MIGRATIONVISACODE Person: Migration visa type, label - - - - -
MIGRATIONARRIVALMONTH Person: Date of first arrival in Australia, Month MM - - - - -
MIGRATIONARRIVALYEAR Person: Date of first arrival in Australia, Year YYYY - - - - -
EDUCATIONLEVELCODE Person: Highest level of education or qualification, Label X(50) - - - - -
EMPLOYMENTSTATUSCODE Person: Employment status, Label - - - - -
DVACARDSTATUSCODE Person: Department of Veterans Affairs (DVA) Card Status, Code X(6) - - - - -
INCOMESOURCECODE Person: Main source of income, Label - - - - -
INCOMEAMOUNT Person: Assessable income, Total Australian currency N(8) - - - - -
INCOMEFREQUENCYCODE Person: Income Frequency, Label - - - - -
ACCOMMODATIONTYPECODE Person: Accommodation setting, label - - - - -
HOMELESSCODE Person: Homelessness status, Label - - - - -
HOUSEHOLDCOMPOSITIONCODE Person: Household Composition, Label A(10) - - - - -
ISCARER Person: Is a carer, Flag - - - - -
HASCARER Person: Has a carer, Flag - - - - -
NDISELIGIBILITYCODE Person: Disability group, code N - - - - -
IDENTIFIEDCONSENTGIVEN Record: Consent Indicator, No/Yes Code N - - - - -
CONTACTCONSENTGIVEN Record: Consent Indicator, No/Yes Code N - - - - -
CURRENTRECORD Record: Current Record Indicator, No/Yes Code N - - - - -
RECORDSEQNBR Record: Sequence Number, NNN - - - - -
INSERTMETHODCODE Record: Insert Method, Code A(2) - - - - -
MB2016BOUNDARYCODE Person: Area of usual residence, Mesh Block (MB) code (ASGS 2016) N(11) - - - - -
SA12016BOUNDARYCODE Person: Area of usual residence, Statistical area level 1 (SA1) code (ASGS 2016) N(11) - - - - -
SA22016BOUNDARYCODE Person: Area of usual residence, Statistical area level 2 (SA2) code (ASGS 2016) N(9) - - - - -
SA32016BOUNDARYCODE Person: Area of usual residence, Statistical area level 3 (SA3) code (ASGS 2016) N(5) - - - - -
SA42016BOUNDARYCODE Person: Area of usual residence, Statistical area level 4 (SA4) code (ASGS 2016) NNN - - - - -
STE2016BOUNDARYCODE Person: Australian State/Territory Identifier, Code X(3) - - - - -
ACPR2015BOUNDARYCODE Person: Area of usual residence, Aged Care Planning Region Code N(9) - - - - -
SA12021BOUNDARYCODE Person: Area of usual residence, Statistical area level 1 (SA1) code N(11) - - - - -
SA22021BOUNDARYCODE Person: Area of usual residence, Statistical area level 2 (SA2) code N(9) - - - - -
SA32021BOUNDARYCODE Person: Area of usual residence, Statistical area level 3 (SA3) code (ASGS 2016) N(5) - - - - -
SA42021BOUNDARYCODE Person: Area of usual residence, Statistical area level 4 (SA4) code (ASGS 2016) NNN - - - - -
STE2021BOUNDARYCODE Person: Australian State/Territory Identifier, Code N - - - - -
ACPR2018BOUNDARYCODE Person: Area of usual residence, Aged Care Planning Region Code N(9) - - - - -
LGA2021BOUNDARYCODE Person: Area of usual residence, LGA Code N(5) - - - - -
SYSSTARTTIME Record: DateTime Stamp, YYYY-MM-DD - - - - -
SYSENDTIME Record: DateTime Stamp, YYYY-MM-DD - - - - -
CREATEDDATETIME Record: DateTime Stamp, YYYY-MM-DD - - - - -
AECFED2016BOUNDARYCODE Person: Area of usual residence, Federal Electorate Label X(50) - - - - -
LGA2016BOUNDARYCODE Person: Area of usual residence, LGA Code N(5) - - - - -
DCJ_NAME_2019 Organisation: NSW Department of Communities and Justice District, Label A(25) - - - - -
SERVICEAREATYPE Data Exchange: Service Area Type, Name X(18) - - - - -
SERVICEAREANAME Organisation: NSW Department of Communities and Justice District, Label A(25) - - - - -
MIGRATIORRIVALYEAR Person: Date of first arrival in Australia, Year YYYY - - - - -
FILENAME Record: Filename, Text X(200) - - - - -
BATCHID Record: Batch Id, Text X(200) - - - - -
etl_run_dt Record: DateTime Stamp, YYYY-MM-DD - - - - -