Distribution/Table | Path/Column |
TEI_Attendance Table | CLIENTID |
PARTICIPATIONTYPE | |
CONDUCTEDDATE | |
TEI_Client Table | CLIENTID |
CURRENTRECORD |
A count of the number of distinct individual clients who received a service in the reporting period.
Distribution/Table | Path/Column |
TEI_Attendance Table | CLIENTID |
PARTICIPATIONTYPE | |
CONDUCTEDDATE | |
TEI_Client Table | CLIENTID |
CURRENTRECORD |
The number of individual clients receiving a TEI service is calculated as a count of current records where the participation type is client.
Distribution/Table | Path/Column |
TEI_Client Table | ATSICODE |
CALDSTATUS | |
GENDERCODE | |
HOMELESSCODE | |
HOUSEHOLDCOMPOSITIONCODE | |
TEI_Attendance Table | AGEATSESSION |
The number of individual clients receiving a TEI service is calculated as a count of current records where the participation type is client.
Distribution/Table | Path/Column |
TEI_Attendance Table | CLIENTID |
PARTICIPATIONTYPE | |
CONDUCTEDDATE | |
TEI_Client Table | CLIENTID |
CURRENTRECORD |
Where the conducted date is set for the desired financial year.
Participation type = 'Client'.
The CurrentRecord flag in a binary code (1 or 0) that indicates whether the record is current. 1 denotes current and 0 means it is inactive. It is important when running queries the current record flag is set to 1. CurrentRecord of 0 means the record is historical.
Current record = '1'.
Distribution/Table | Path/Column |
TEI_Client Table | ATSICODE |
CALDSTATUS | |
GENDERCODE | |
HOMELESSCODE | |
HOUSEHOLDCOMPOSITIONCODE | |
TEI_Attendance Table | AGEATSESSION |
The client’s age at the last session they attended before the end of the financial year is used to reflect their age in the financial year. The sum of all clients in every age group will match the unique number of TEI individual clients.
Age has been recoded into the following age groups: '0-4', '5-9', '10-14', '15-19', '20-24', '25-29', '30-34', '35-39', '40-44', '45-49', '50-59', '60-69', '70-79' and '80+'.
In order to identify as CALD, individual clients have to classify as being born overseas and to speak a language other than English at home. Individual clients with ‘unknown’ country of birth and/or ‘unknown’ language spoken at home are categorised as unknown CALD status. This unknown count is different and not comparable to the Data Exchange reports where individual clients who have ‘unknown’ country of birth and/or ‘unknown’ language spoken at home are automatically categorised as non-CALD.
Disability is a constructed variable for the dashboard. Where a client has a recorded disability in the DISABILITYCODE, they are recorded as "Yes" in the constructed variable; where they have no recorded disability, they are marked as "No".
Individual clients who self-identified as living with a disability, impairment or condition may have one or more disabilities, impairments or conditions recorded. The sum of reported disabilities, impairments or conditions will not match the number of individual clients who identified themselves as living with a disability, impairments or conditions.
Relation | Count |
---|---|
Indicator Sets that include this Indicator | 1 |
Data Sets that are used in this Indicator | 1 |