| Distribution/Table | Path/Column |
| TEI_Attendance Table | CLIENTID |
| ASSISTANCENEEDEDKEY/ PRIMARY ASSISTANCENEEDEDKEY |
|
| PARTICIPATIONTYPE | |
| ACTIVITYID | |
| TEI_Client Table | CLIENTID |
| CURRENTRECORD |
Definition
A count of reasons for Targeted Early Intervention (TEI) individual clients to seek assistance from the program in the reporting period.
Indicator Summary
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.
Reporting Information
The Targeted Early Intervention program dashboard reports annually.
Quality Statement
Targeted Earlier Intervention (TEI) Data Set Quality Statement 2019-20
Statuses:
[FACSIAR Data Governance Committee: Standard, April 8, 2021]
The Targeted Earlier Intervention (TEI) program delivers flexible support to children, young people, families and communities experiencing or at risk...
Framework Dimensions
Rationale
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).
Calculation rules
- Computation
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.
- Description
| Distribution/Table | Path/Column |
| TEI_Attendance Table | CLIENTID |
| ASSISTANCENEEDEDKEY/ PRIMARY ASSISTANCENEEDEDKEY |
|
| PARTICIPATIONTYPE | |
| ACTIVITYID | |
| TEI_Client Table | CLIENTID |
| CURRENTRECORD |
-
- Data Element
- Data Exchange: Client identifier, X(19)
- Data Set
- Targeted Earlier Intervention Data Set
-
- Data Element
- Person: Assistance needed, Service Type TEI Code X(20)
- Data Set
- Targeted Earlier Intervention Data Set
-
- Data Element
- Data Exchange: Program activity identifier, Code NN
- Guide for use
Where Activity ID = 80, 81, 82, 83, 84 (i.e. TEI Activity only)
- Data Set
- Targeted Earlier Intervention Data Set
-
- Data Element
- Record: Current Record Indicator, No/Yes Code N
- Description
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.
- Guide for use
Where CURRENTRECORD = 1.
- Data Set
- Targeted Earlier Intervention Data Set
-
- Data Element
- Person: Participation type, Label A(10)
- Guide for use
Where PARTICIPATIONTYPE is equal to "client".
- Data Set
- Targeted Earlier Intervention Data Set
| 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.
Comments
Data ageing:
- This indicator does not have any data ageing rules.
Custom Fields
DCJ - Domain
Earlier Intervention
Related content
| Relation | Count |
|---|---|
| Indicator Sets that include this Indicator | 2 |
| Data Sets that are used in this Indicator | 1 |