Definition
Each time the client is being assessed will be given an Assessment ID and the score the client received for each Outcome Domain will have a unique ScoreID. There are 20 different Outcome Domains across 3 Outcome Type that a client can be scored against. A client can also be assessed for the same domain before and after the session.
Although the variable ‘Assessment Type’ exist with values of ‘Pre’ and ‘Post’ Score, it is not a current indicator whether the client is assessed pre and post. This field was being used prior to August 2018. The determination of pre and post is assessed by a series of algorithm including the Session conducted date, Session ID, the type of Outcome being assessed and Assessment Order.
Despite the complexities of Assessment Order, the Client Assessment table contains Client ID, Attendance ID, Activity ID, DeliveryOrgID and Outlet ID that can be linked to Attendance, Activity, Client and other tables.
The TEI_Client_Assessment table to contain the following data elements.
Data source details
Provenance records
Generated distributions
-
Target early intervention: _2018_29_4_ti_assessment
Statuses: UnregisteredA1.5:TEI Assessment data
| 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: Client outcome assessment identifier, X(19) |
A system-generated identifier for a unique client outcome assessment record in the Data Exchange, represented by a number. |
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 NN |
A number that represents an identifier for a unique program activity record in the Data Exchange. |
NUMBERSTRING | NN |
| 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) |
| ASSESSEDDATE | Client Outcome Assessment: Created Date, YYYYMMDD |
The date represented as year, month, day that a given client outcome assessment was entered into a system. |
DATE | YYYYMMDD |
| 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 A(17) |
A description of the specific focus of a clients wellbeing measured by a given client outcome assessment. |
ALPHASTRING | A(17) |
| OUTCOMEDOMAINSCORE | Client outcome assessment: Domain rating, Five-point scale code N |
A 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 |
| PARTICIPATIONTYPE | Person: Participation type, Label A(10) |
The code that represents the role of a given person at a session. |
ALPHASTRING | A(10) |
| AGEATSESSION | Person: Age, Total Years NNN |
The age of the person in (completed) years at a specific point in time. |
NUMBERSTRING | NNN |
| SESSIONCREATEDDATE | 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) |
| SERVICETYPEID | Session: Service Type, Code N(4) |
The code that represents the main focus of service delivery at a given session. |
NUMBERSTRING | N(4) |
| BATCHID | Record: Batch Id, Text X(200) |
System generated identification generated when (data) ingested into BigQuery, represented by text. |
ALPHANUMERICSTRING | X(200) |