Distribution/Table | Path/Column |
TEI_Client_Assessment Table | CLIENTID |
PARTICIPATIONTYPE | |
SESSIONCONDUCTEDDATE | |
OUTCOMETYPE | |
ASSESSMENTID | |
ASSESSEDDATE | |
TEI_Client Table | CLIENTID |
CURRENTRECORD |
A count of distinct TEI individual clients who have either Circumstances and/or Goals SCORE assessed in the reporting period. Each individual client with one or more Paired SCOREs (both Goals and Circumstances) recorded will only be counted once.
Clients will be unique within the service types even if that particular service types have been accessed multiple times.
The proportion of clients assessed is calculated out of all clients in the TEI program or each program activity and service type depending on the breakdown level.
Rationale for inclusion: As per the TEI Data Collection and Reporting guide, funded services should record Circumstances and/or Goals SCORE for at least 50% of their individual clients. This measure will track against the set target and will explore the supports required by TEI service providers to improve an understanding on how to measure client outcomes and how to use SCORE.
Distribution/Table | Path/Column |
TEI_Client_Assessment Table | CLIENTID |
PARTICIPATIONTYPE | |
SESSIONCONDUCTEDDATE | |
OUTCOMETYPE | |
ASSESSMENTID | |
ASSESSEDDATE | |
TEI_Client Table | CLIENTID |
CURRENTRECORD |
Count of distinct ClientID who have a corresponding assessmentID within the period, as defined by assesseddate. Outcome Type must equal "Circumstances" or "Goals." and participation type is client.
Distribution/Table | Path/Column |
TEI_Outlet Table | OUTLETPOSTCODE |
Count of distinct ClientID who have a corresponding assessmentID within the period, as defined by assesseddate. Outcome Type must equal "Circumstances" or "Goals." and participation type is client.
Distribution/Table | Path/Column |
TEI_Client_Assessment Table | CLIENTID |
PARTICIPATIONTYPE | |
SESSIONCONDUCTEDDATE | |
OUTCOMETYPE | |
ASSESSMENTID | |
ASSESSEDDATE | |
TEI_Client Table | CLIENTID |
CURRENTRECORD |
Where outcome type excludes 'satisfaction'.
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'.
A count of distinct client identifiers.
Where Participation type is equal to 'Client'.
Distribution/Table | Path/Column |
TEI_Outlet Table | OUTLETPOSTCODE |
The Outlet Postcode from the TEI Outlet Table is used with a geographical conversion table to calculate into DCJ Districts.
Relation | Count |
---|---|
Indicator Sets that include this Indicator | 1 |
Data Sets that are used in this Indicator | 1 |