Distribution/Table | Path/Column |
TEI_Attendance Table | CLIENTID |
ASSISTANCENEEDEDKEY/ PRIMARY ASSISTANCENEEDEDKEY |
|
PARTICIPATIONTYPE | |
ACTIVITYID | |
TEI_Client Table | CLIENTID |
CURRENTRECORD |
A count of reasons for Targeted Early Intervention (TEI) individual clients to seek assistance from the program in the reporting period.
Distribution/Table | Path/Column |
TEI_Attendance Table | CLIENTID |
ASSISTANCENEEDEDKEY/ PRIMARY ASSISTANCENEEDEDKEY |
|
PARTICIPATIONTYPE | |
ACTIVITYID | |
TEI_Client Table | CLIENTID |
CURRENTRECORD |
A client may be in the TEI program for one or multiple reasons out of twelve. Each reason is a binary code (i.e. 1 or 0) in the TEI_Ref_Assistance_Needed table. The PrimaryAssistanceNeededKey is an integer that shows the different combination of the flag of the primary different reasons clients seek assistance for TEI. The The PrimaryAssistanceNeededKey is used to join with the AssistanceNeededKey in the TEI_Ref_Assistance_Needed table. For example, AssistanceNeededKey = 14 means the clients is seeking assistance for Housing, …
Distribution/Table | Path/Column | Filter |
TEI_Attendance Table | ASSISTANCENEEDEDKEY/ PRIMARY ASSISTANCENEEDEDKEY |
Primary/Secondary Assistance* |
*The primary assistance needed is calculated by PrimaryAssistanceNeededKey from TEI_Attendance = AssistanceNeededKey from TEI_Ref_Assistance_Need. The secondary assistance needed is calculated by AssistanceNeededKey from TEI_Attendance = AssistanceNeededKey from TEI_Ref_Assistance_Need.
The Targeted Early Intervention program dashboard reports annually.
The indicator provides practical information for managers and front-line staff to better understand their program.
Alignment: This aligns with reporting in Data Exchange by the Australian Government Department of Social Services (DSS).
A client may be in the TEI program for one or multiple reasons out of twelve. Each reason is a binary code (i.e. 1 or 0) in the TEI_Ref_Assistance_Needed table. The PrimaryAssistanceNeededKey is an integer that shows the different combination of the flag of the primary different reasons clients seek assistance for TEI. The The PrimaryAssistanceNeededKey is used to join with the AssistanceNeededKey in the TEI_Ref_Assistance_Needed table. For example, AssistanceNeededKey = 14 means the clients is seeking assistance for Housing, Training & Employment reasons. AssistanceNeededKey = 24 means it is seeking assistance for Personal and Housing reasons.
The criteria used in determining clients' primary and secondary reasons for seeking assistance include:
Activity ID = 80, 81, 82, 83, 84 (i.e. TEI Activity only)
Participation Type = 'CLIENT' (only Individual clients are included).
The summary total of primary reasons clients' seek assistance is therefore :
A sum of each of the following reasons for seeking assistance: AGE, MATERIAL, FAMILY, MONEY, PHYSICAL, COMMUNITY, MENTAL, PERSONAL, HOUSING, TRAINING, EMPLOYMENT, EDUCEMPL where it equals = 1.
Distribution/Table | Path/Column |
TEI_Attendance Table | CLIENTID |
ASSISTANCENEEDEDKEY/ PRIMARY ASSISTANCENEEDEDKEY |
|
PARTICIPATIONTYPE | |
ACTIVITYID | |
TEI_Client Table | CLIENTID |
CURRENTRECORD |
Where Activity ID = 80, 81, 82, 83, 84 (i.e. TEI Activity only)
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.
Where CURRENTRECORD = 1.
Where PARTICIPATIONTYPE is equal to "client".
Distribution/Table | Path/Column | Filter |
TEI_Attendance Table | ASSISTANCENEEDEDKEY/ PRIMARY ASSISTANCENEEDEDKEY |
Primary/Secondary Assistance* |
*The primary assistance needed is calculated by PrimaryAssistanceNeededKey from TEI_Attendance = AssistanceNeededKey from TEI_Ref_Assistance_Need. The secondary assistance needed is calculated by AssistanceNeededKey from TEI_Attendance = AssistanceNeededKey from TEI_Ref_Assistance_Need.
Data ageing:
Relation | Count |
---|---|
Indicator Sets that include this Indicator | 2 |
Data Sets that are used in this Indicator | 1 |