Distribution/Table | Path/Column |
TEI_Attendance Table | CLIENTID |
PARTICIPATIONTYPE | |
CONDUCTEDDATE | |
DELIVERYORGID | |
TEI_Organisation Table | ORGANISATIONID |
TEI_Client Table | CLIENTID |
ATSICODE | |
CURRENTRECORD |
A count of individual Aboriginal clients who received a Targeted Early Intervention (TEI) service that was delivered by an Aboriginal Community-Controlled Organisation (ACCO), during the reporting period.
Distribution/Table | Path/Column |
TEI_Attendance Table | CLIENTID |
PARTICIPATIONTYPE | |
CONDUCTEDDATE | |
DELIVERYORGID | |
TEI_Organisation Table | ORGANISATIONID |
TEI_Client Table | CLIENTID |
ATSICODE | |
CURRENTRECORD |
A count of distinct Client Identifiers with a related ATSI Code where the Participation Type is equal to client who received a TEI Service (assessed by confirming the Conducted Date) by a Delivery Organisation (identified as being an ACCO), in the reporting period.
This indicator may be disaggregated by:
Indicator Specific Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
TEI_Attendance Table | SERVICETYPEID | Service type |
TEI_Attendance Table | DELIVERYORGID | Delivery organisation |
TEI_Attendance Table | REFERRALFROMSOURCE | Referral source |
Geographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
TEI_Outlet Table | MB2016BOUNDARYCODE | District (outlet)* |
TEI_Outlet Table | MB2016BOUNDARYCODE | LGA (outlet)* |
TEI_Outlet Table | OUTLETPOSTCODE | Remoteness Area (outlet)* |
MB2016BOUNDARYCODE | District (client)* | |
MB2016BOUNDARYCODE | LGA (client)* |
*The TEI Mesh Block is used with a geographical conversion table to calculate into DCJ Districts and Local …
The Targeted Early Intervention Program dashboard reports annually.
NSW Government is required to report ACCO funding and service delivery for the purposes of tracking against measures for Closing the Gap and Aboriginal Outcomes.
Alignment: This aligns with NSW Government's commitment to the National Agreement for Closing the Gap and to shared decision-making as a fundamentally new way of working in partnership with Aboriginal and Torres Strait Islander people.
A count of distinct Client Identifiers with a related ATSI Code where the Participation Type is equal to client who received a TEI Service (assessed by confirming the Conducted Date) by a Delivery Organisation (identified as being an ACCO), in the reporting period.
Distribution/Table | Path/Column |
TEI_Attendance Table | CLIENTID |
PARTICIPATIONTYPE | |
CONDUCTEDDATE | |
DELIVERYORGID | |
TEI_Organisation Table | ORGANISATIONID |
TEI_Client Table | CLIENTID |
ATSICODE | |
CURRENTRECORD |
DELIVERYORGID is identified as being an Aboriginal Community-Controlled Organisation (ACCO)
Where the value of ATSICODE is equal to 'Aboriginal', 'TSI' (Torres Strait Islander) or Both (Aboriginal and Torres Strait Islander).
CURRENTRECORD = '1'
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 that the CURRENTRECORD flag is set to 1. Note, a CURRENTRECORD of 0 means the record is historical.
CONDUCTEDDATE is not 'null'
Where the CONDUCTEDDATE is within the reporting period (eg financial year)
DISTINCT CLIENTID
PARTICIPATIONTYPE is 'CLIENT'
Where Participation type is equal to 'Client'.
This indicator may be disaggregated by:
Indicator Specific Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
TEI_Attendance Table | SERVICETYPEID | Service type |
TEI_Attendance Table | DELIVERYORGID | Delivery organisation |
TEI_Attendance Table | REFERRALFROMSOURCE | Referral source |
Geographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
TEI_Outlet Table | MB2016BOUNDARYCODE | District (outlet)* |
TEI_Outlet Table | MB2016BOUNDARYCODE | LGA (outlet)* |
TEI_Outlet Table | OUTLETPOSTCODE | Remoteness Area (outlet)* |
MB2016BOUNDARYCODE | District (client)* | |
MB2016BOUNDARYCODE | LGA (client)* |
*The TEI Mesh Block is used with a geographical conversion table to calculate into DCJ Districts and Local Government Area. The Outlet Postcode is used with a geographical conversion table to calculate into Remoteness Areas.
Demographic Breakdown
Distribution/Table | Path/Column | Dashboard Filter Label |
TEI_Attendance Table | AGEATSESSION | Age |
TEI_Attendance Table | AGEATSESSION | 0 - 5 year olds |
TEI_Attendance Table | AGEATSESSION | 0-18 year old clients affected by mental health* |
TEI_Attendance Table | PRIMARYASSISTANCENEEDEDKEY | |
TEI_Attendance Table | ASSISTANCENEEDEDKEY | |
TEI_Client_Disability Table | DISABILITYCODE | Disability status |
TEI_Client Table | GENDERCODE | Gender |
TEI_Client Table | HOMELESSCODE | Homelessness status |
TEI_Client Table | HOUSEHOLDCOMPOSITIONCODE | Household Composition |
* For the 0-18 year old clients affected by mental health the Primary Assistance Needed Key and the Assistance Needed Key from the from the Attendance Table connect to the Reference Assistance Needed Table, where the value for MENTAL is equal to '1', and the value for Age At Session is 0 - 18.
The Targeted Earlier Intervention Program dashboard does not disaggregate.
Data ageing:
Relation | Count |
---|---|
Indicator Sets that include this Indicator | 1 |
Data Sets that are used in this Indicator | 1 |