Distribution/Table | Path/Column |
TEI_Community_Assessment Table | SESSIONID |
ASSESSMENTID | |
CASEID | |
SESSIONCONDUCTEDDATE | |
ACTIVITYID | |
SERVICETYPEID | |
OUTCOMETYPE | |
OUTCOMEDOMAIN | |
ASSESSMENTTYPE | |
THEREPORTINGPERIOD |
A count of cases with a paired Community SCORE
A paired community SCORE reports initial and follow up Community SCOREs for multiple sessions within the case. For example: a series of workshops, forums, or information sessions. It is only to be recorded when the same group of clients attend 2 or more sessions, or it is not practical or relevant to collect information from individual clients (e.g. interagency).
It is measured at the beginning and the end of service provision. This could be at the beginning and end of a one-off session, or a series of recurring sessions. A group can be rated in one outcome domain or across multiple outcome domains. The average difference between the first and last score is shown to demonstrate change over the course of service provision.
Distribution/Table | Path/Column |
TEI_Community_Assessment Table | SESSIONID |
ASSESSMENTID | |
CASEID | |
SESSIONCONDUCTEDDATE | |
ACTIVITYID | |
SERVICETYPEID | |
OUTCOMETYPE | |
OUTCOMEDOMAIN | |
ASSESSMENTTYPE | |
THEREPORTINGPERIOD |
A count of distinct Case IDs with a paired Community SCORE, where an Assessment IDs is linked to a Activity ID (which is equal to 80, 81, 82, 83, or 84) and an Outcome Type (has the value 'Group/Community').
To get paired a Community SCORE, the Assessment IDs are grouped by Case ID, Activity ID, Service Type ID …
Distribution/Table | Path/Column | Dashboard Filter |
TEI_Attendance Table | SERVICETYPEID | Service Type |
ACTIVITYID | Program Activity | |
TEI_Outlet Table | OUTLETPOSTCODE | DCJ District* |
A count of distinct Case IDs with a paired Community SCORE, where an Assessment IDs is linked to a Activity ID (which is equal to 80, 81, 82, 83, or 84) and an Outcome Type (has the value 'Group/Community').
To get paired a Community SCORE, the Assessment IDs are grouped by Case ID, Activity ID, Service Type ID, Outcome Type and Outcome Domain. The earliest of the paired scores takes the Assessment ID from the first Session Conducted Date, Session ID and where Assessment Type has the value 'Pre-SCORE'.
The latest of the paired SCORE is calculated for each Reporting Period, within the same grouping of Case ID, Activity ID, Service Type ID, Outcome Type and Outcome Domain. If there is not a latest score paired with the earliest score in a Reporting Period for a particular grouping of Case ID, Activity ID, Service Type ID, Outcome Type and Outcome Domain, there is no earliest or latest paired community score for that Reporting Period.
Distribution/Table | Path/Column |
TEI_Community_Assessment Table | SESSIONID |
ASSESSMENTID | |
CASEID | |
SESSIONCONDUCTEDDATE | |
ACTIVITYID | |
SERVICETYPEID | |
OUTCOMETYPE | |
OUTCOMEDOMAIN | |
ASSESSMENTTYPE | |
THEREPORTINGPERIOD |
ACTIVITYID = (80 OR 81 OR 82 OR 83 OR 84)
ASSESSMENTTYPE = 'Pre-SCORE'.
OUTCOMETYPE = 'Group/Community'
Count Distinct CASEID
Distribution/Table | Path/Column | Dashboard Filter |
TEI_Attendance Table | SERVICETYPEID | Service Type |
ACTIVITYID | Program Activity | |
TEI_Outlet Table | OUTLETPOSTCODE | DCJ District* |
* 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 |