Average of the earliest and latest SCORE recorded in cases with a paired Community SCORE, in the reporting period.
Paired community SCOREs report initial and follow up Community SCOREs for multiple sessions. 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).
| Distribution/Table | Path/Column |
| TEI_Community_Assessment Table | SESSIONID |
| CASEID | |
| SESSIONCONDUCTEDDATE | |
| ACTIVITYID | |
| SERVICETYPEID | |
| OUTCOMETYPE | |
| OUTCOMEDOMAIN | |
| OUTCOMEDOMAINSCORE | |
| ASSESSMENTTYPE |
Earliest SCORE: The sum of valid earliest OUTCOMEDOMAINSCORE for each case with a paired Community SCORE.
Latest SCORE: The sum of valid latest OUTCOMEDOMAINSCORE for each case with a paired Community SCORE.
| Distribution/Table | Path/Column |
| TEI_Community_Assessment Table | ASSESSMENTID |
An average of the outcome domain SCOREs from the community assessment table, for the earliest and latest paired Community SCORE, in the reporting period.
A paired Community SCORE is made up of Assessment IDs that have Activity ID equal to 80,81,82,83, or 84, and Outcome Type = 'Group/Community.'
To get a paired Community SCORE, the Assessment IDs are grouped …
| Distribution/Table | Path/Column | Filter |
| TEI_Attendance Table | SERVICETYPEID | Service Type |
| ACTIVITYID | Program Activity | |
| TEI_Outlet Table | OUTLETPOSTCODE | DCJ District* |
An average of the outcome domain SCOREs from the community assessment table, for the earliest and latest paired Community SCORE, in the reporting period.
A paired Community SCORE is made up of Assessment IDs that have Activity ID equal to 80,81,82,83, or 84, and Outcome Type = 'Group/Community.'
To get a paired 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 SCORE takes the Assessment ID from the first Session Conducted Date, Session Id and where Assessment Type = 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 |
| CASEID | |
| SESSIONCONDUCTEDDATE | |
| ACTIVITYID | |
| SERVICETYPEID | |
| OUTCOMETYPE | |
| OUTCOMEDOMAIN | |
| OUTCOMEDOMAINSCORE | |
| ASSESSMENTTYPE |
Earliest SCORE: The sum of valid earliest OUTCOMEDOMAINSCORE for each case with a paired Community SCORE.
Latest SCORE: The sum of valid latest OUTCOMEDOMAINSCORE for each case with a paired Community SCORE.
Count Distinct SESSIONID
| Distribution/Table | Path/Column |
| TEI_Community_Assessment Table | ASSESSMENTID |
Count Distinct ASSESSMENTID
Use distinct ASSESSMENTID that corresponds to a valid Outcome Domain SCORE.
| Distribution/Table | Path/Column | Filter |
| TEI_Attendance Table | SERVICETYPEID | Service Type |
| ACTIVITYID | Program Activity | |
| TEI_Outlet Table | OUTLETPOSTCODE | DCJ District* |
* The OUTLETPOSTCODE from the TEI Outlet Table is used with a geographical conversion table to calculate DCJ District.
| Relation | Count |
|---|---|
| Indicator Sets that include this Indicator | 1 |
| Data Sets that are used in this Indicator | 1 |