Clients reason for seeking assistance
Distribution/Table | Path/Column |
TEI_Attendance Table | REFERRALTOINTERNALKEY/ REFFERALTOEXTERNALKEY |
PARTICIPATIONTYPE | |
TEI_Client Table | CURRENTRECORD |
A count of the internal and external referrals out of the Targeted Early Intervention (TEI) program in the reporting period. This reflects a client’s need for help outside the scope of TEI funded activities.
Internal referrals are referrals made to another service offered within the same organisation while external referrals were made to a service that is provided by another organisation.
A single TEI individual client can have multiple reasons for a referral out of the TEI service.
Clients reason for seeking assistance
Distribution/Table | Path/Column |
TEI_Attendance Table | REFERRALTOINTERNALKEY/ REFFERALTOEXTERNALKEY |
PARTICIPATIONTYPE | |
TEI_Client Table | CURRENTRECORD |
A client may be referred to other services by a TEI provider, which are grouped into 14 categories in the TEI_Referral_To table. Each category is a binary code (i.e. 1 or 0) to indicate whether the respective reason(s) are referred. The ReferralToKey is an integer that shows the different combination of the 14 categories in the table. For example, ReferralToKey of 2 means clients' are referred due to Employment reasons as there is 1 against Employment category. ReferralToKey of 6 …
This is disaggregated by internal and external referrals in the TEI program. Internal referrals are calculated by where referraltointernalkey = TEI_Referral_To. External referrals are calculated by referraltoexternalkey = TEI_Referral_To.
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 referred to other services by a TEI provider, which are grouped into 14 categories in the TEI_Referral_To table. Each category is a binary code (i.e. 1 or 0) to indicate whether the respective reason(s) are referred. The ReferralToKey is an integer that shows the different combination of the 14 categories in the table. For example, ReferralToKey of 2 means clients' are referred due to Employment reasons as there is 1 against Employment category. ReferralToKey of 6 means clients' are referred due to Employment & Caring reasons as there is a 1 against Employment and Caring category.
The ReferralToKey is joined to ReferralToExternalKey or ReferralToInternalKey in the TEI Attendance table. When joined to ReferralToExternalKey, the categories are the reasons clients' are referred to other services externally. When joined to ReferralToInternalKey, the categories are the reasons clients' are referred to other services internally.
The summary total of primary reasons clients' seek assistance is therefore : : AGE, MATERIAL, FAMILY, MONEY, PHYSICAL, COMMUNITY, MENTAL, PERSONAL, HOUSING, TRAINING, EMPLOYMENT, EDUCEMPL where it equals = 1.
Clients reason for seeking assistance
Distribution/Table | Path/Column |
TEI_Attendance Table | REFERRALTOINTERNALKEY/ REFFERALTOEXTERNALKEY |
PARTICIPATIONTYPE | |
TEI_Client Table | CURRENTRECORD |
Where PARTICIPATIONTYPE is equal to "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.
Where CURRENTRECORD = 1.
This is disaggregated by internal and external referrals in the TEI program. Internal referrals are calculated by where referraltointernalkey = TEI_Referral_To. External referrals are calculated by referraltoexternalkey = TEI_Referral_To.
Data ageing:
Relation | Count |
---|---|
Indicator Sets that include this Indicator | 1 |
Data Sets that are used in this Indicator | 1 |