Definition
Organisations who participate in the partnership approach agree to report Community SCOREs for the majority of group or community activities where it is not feasible to record the changes for individual clients.
The Community SCORE is linked to four domains that reflect changes that may occur for a group or community rather than individual clients:
- Group/ Community Knowledge, skills, attitudes and behaviours for a group of clients participating in a service
- Organisational knowledge, skills and practices to better respond to the needs of targeted clients or communities
- Community infrastructure and networks to better respond to the needs of targeted clients and communities
- Social cohesion to demonstrate greater community cohesion and social harmony.
Similar to Client Assessment, Community SCORE is recorded on a 5 point scale. However the meaning of each Community SCORE is different to Client SCORE.
- means no change in group/organisation/community capacity to address or respond to their own needs
- means limited change in group/organisation/community capacity to address or respond to their own needs, but there is emerging engagement in addressing the issues
- means limited change in group/organisation/community capacity to address or respond to their own needs, but there is strong engagement in addressing the issues
- means moderate change in group/organisation/community capacity to address or respond to their own needs
- means significant change in group/organisation/community capacity to address or respond to their own needs
The TEI_Community_Assessment table to contain the following data elements.
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| SCOREID | Data Exchange: Outcome domain assessment identifier, X(19) |
A number that represents a system-generated identifier for a unique outcome domain assessment record in the Data Exchange. |
CHARACTERSTRING | X(18) |
| ASSESSMENTID | Data Exchange: Community outcome assessment identifier, X(19) |
A number that represents a system-generated identifier for a unique community outcome assessment record in the Data Exchange. |
CHARACTERSTRING | X(18) |
| ATTENDANCEID | Data Exchange: Attendance identifier, X(19) |
A number that represents a system-generated identifier for a unique attendance record in the Data Exchange. |
CHARACTERSTRING | X(18) |
| ACTIVITYID | Data Exchange: Program activity identifier, Code NNN |
A number that represents an identifier for a unique program activity record in the Data Exchange. |
NUMBERSTRING | NNN |
| ASSESSMENTTYPECODE | Client outcome assessment: Service phase, Code A(4) |
A code that represents the phase of service a given client outcome assessment relates to, whether the pre- or post-service phase. |
ALPHASTRING | A(4) |
| ASSESSMENTTYPE | Client outcome assessment: Service phase, Description A(10) |
A description for the phase of service a given client outcome assessment relates to, whether the pre- or post- score phase. Counting rule only uses this element |
CHARACTERSTRING | A(10) |
| ASSESSEDBYCODE | Client outcome assessment: Assessment phase, Assessed By Code X(15) |
The phase of service a given client outcome assessment relates to, recorded as a code set representing who conducted the assessment. |
ALPHANUMERICSTRING | X(15) |
| ASSESSEDBY | Client outcome assessment: Assessment phase, Assessed By Description X(50) |
The description of who conducted the assessment of the given client outcome assessment. |
CHARACTERSTRING | X(50) |
| ASSESSMENTCREATEDDATE | Record: DateTime Stamp, YYYY-MM-DD |
A sequence of characters or encoded information identifying when a certain event occurred, on what day, and optionally including what particular time of day. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| OUTCOMEDOMAINSCORECODE | Client outcome assessment: Domain rating, Outcome label X(18) |
A description of an outcome domain rating recorded for a given client outcome assessment. |
ALPHANUMERICSTRING | X(18) |
| OUTCOMETYPE | Client outcome assessment: Domain Group, Outcome label A(13) |
A description of the focus of a client's wellbeing measured by a given client outcome assessment. |
ALPHASTRING | A(13) |
| OUTCOMEDOMAIN | Client outcome assessment: Domain, label X(320) |
A description of the specific focus of a clients wellbeing measured by a given client outcome assessment. |
CHARACTERSTRING | X(320) |
| OUTCOMEDOMAINSCORE | Client outcome assessment: Domain rating, Community SCORE code N |
A community SCORE code that represents an outcome domain rating recorded for a given client outcome assessment. |
NUMBERSTRING | N |
| CREATEDDATETIME | Record: DateTime Stamp, YYYY-MM-DD |
A sequence of characters or encoded information identifying when a certain event occurred, on what day, and optionally including what particular time of day. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| CLIENTID | Data Exchange: Client identifier, X(19) |
A number that represents a system-generated identifier for a unique client record in the Data Exchange. |
CHARACTERSTRING | X(18) |
| SESSIONID | Data Exchange: Session identifier, X(19) |
A number that represents a system-generated identifier for a unique session record in the Data Exchange.
Specific Information:
Organisation’s Session Id. This is unique for a particular case within the organisation. SessionId and CaseId compound must be unique within the upload file. A client’s name, part of a client’s name, or other identifiable information should not be used as a Session Id under any circumstances. |
CHARACTERSTRING | X(18) |
| CASEID | Person: Case Identifier, X(10) |
A system-generated identifier for a case associated with a person in receipt of services. |
CHARACTERSTRING | X(14) |
| LEADORGID | Data Exchange: Lead Organisation identifier, X(19) |
A number that represents a system-generated identifier for a unique service provider record in the Data Exchange of an organisation that has charge over the services provided. |
CHARACTERSTRING | X(18) |
| DELIVERYORGID | Data Exchange: Delivery Organisation identifier, X(19) |
A number that represents a system-generated identifier for a unique service provider record in the Data Exchange of an organisation that has been directed to provide services. |
CHARACTERSTRING | X(18) |
| OUTLETID | Data Exchange: Outlet identifier, X(19) |
A number that represents a system-generated identifier for a unique outlet record in the Data Exchange. |
CHARACTERSTRING | X(18) |
| SESSIONCONDUCTEDDATE | Session: Conducted Date, YYYYMMDD |
The date represented as year, month, day on which a given session took place. |
DATE | YYYYMMDD |
| THEREPORTINGPERIOD | Session: Reporting Period, Date Range MMM-MMM YYYY |
The date measured in months of a year which is related of an instance of service. |
CHARACTERSTRING | MMM-MMM YYYY |
| SERVICETYPEID | Session: Service Activity Type, Code N(4) |
The main focus of service delivery at a given session, as represented by a numeric code. |
NUMBERSTRING | N(4) |
| INGESTTIME | Record: DateTime Stamp, YYYY-MM-DD |
A sequence of characters or encoded information identifying when a certain event occurred, on what day, and optionally including what particular time of day. |
DATETIME | YYYY-MM-DD(T00:00:00) |
| INGESTTYPE | Record: Ingest Type, Label A(6) |
File (data) ingestion process type, represented by a label. |
ALPHASTRING | A(6) |
| FILENAME | Record: Filename, Text X(200) |
File name (data) ingested into BigQuery, represented by text. |
ALPHANUMERICSTRING | X(200) |
| BATCHID | Record: Batch Id, Text X(200) |
System generated identification generated when (data) ingested into BigQuery, represented by text. |
ALPHANUMERICSTRING | X(200) |