| Distribution/Table | Path/Column |
| TEI_Community_Assessment Table | OUTCOMEDOMAINSCORE |
| SESSIONCONDUCTEDDATE |
The average Community SCORE for sessions where a single Community SCORE was recorded, in the reporting period.
Single community SCOREs is used for a one-off session, for example, community events, information nights or forums and a one-off class or workshop. It can also be used to report SCOREs across multiple sessions when different group of clients attended the services e.g. drop-in centre, breakfast club and weekly classes. It measures changes in client outcomes for groups or communities using a 5-point rating scale at the end of the session. Each session can be rated in one outcome domain or across multiple outcome domains.
| Distribution/Table | Path/Column |
| TEI_Community_Assessment Table | OUTCOMEDOMAINSCORE |
| SESSIONCONDUCTEDDATE |
| Distribution/Table | Path/Column |
| TEI_Community_Assessment Table | SESSIONID |
| SESSIONCONDUCTEDDATE |
The sum of Outcome Domain SCORE for each of the sessions with a single Community SCORE, divided by the count of distinct Session IDs, in the reporting period.
| Distribution/Table | Path/Column | Filter |
| TEI_Community_Assessment Table | SERVICETYPEID | Service Type |
| ACTIVITYID | Program Activity | |
| TEI_Outlet Table | OUTLETPOSTCODE | DCJ District* |
The sum of Outcome Domain SCORE for each of the sessions with a single Community SCORE, divided by the count of distinct Session IDs, in the reporting period.
| Distribution/Table | Path/Column |
| TEI_Community_Assessment Table | OUTCOMEDOMAINSCORE |
| SESSIONCONDUCTEDDATE |
SESSIONCONDUCTEDDATE is not 'null'
Where the SESSIONCONDUCTEDDATE is within the reporting period (eg financial year)
A sum of Outcome Domain Scores (where the value is not missing).
| Distribution/Table | Path/Column |
| TEI_Community_Assessment Table | SESSIONID |
| SESSIONCONDUCTEDDATE |
SESSIONCONDUCTEDDATE is not 'null'
Where the SESSIONCONDUCTEDDATE is within the reporting period (eg financial year)
DISTINCT SESSIONID
| Distribution/Table | Path/Column | Filter |
| TEI_Community_Assessment 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 |