Skip to content Learn about the access keys available for Metadata.NSW
A NSW Government website
Metadata.NSW (beta)

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.

  1. means no change in group/organisation/community capacity to address or respond to their own needs
  2. 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
  3. 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
  4. means moderate change in group/organisation/community capacity to address or respond to their own needs
  5. 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)