Definition
A session in the Targeted Earlier Intervention program records what service was delivered on a particular date within a reporting period, the type of service delivered and which clients attended. A session is one or more individual instances or episodes of assistance within a reporting period that are delivered within a distinct case.
The TEI_Session table to contain the following data elements.
Data source details
Provenance records
Generated distributions
-
Target early intervention: _2018_29_4_ti_session
Statuses: UnregisteredA1.5:TEI Session data
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| 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) |
| CASEENDDATE | Person: Case Identifier End Date, YYYYMMDD |
The date represented as year, month, day associated with the end of a person's case identifier. |
DATE | YYYYMMDD |
| ATTENDANCEPROFILECODE | Session: Attendance profile, Code A(11) |
A code that represents the type of instance of services someone has been present for. |
ALPHASTRING | A(11) |
| UNIDENTIFIEDCLIENTATTENDANCE | Session: Attendance count, Number NNN |
The total (count) of attendees at a session.
Specific Information:
The total (count) of unidentified attendees at a session. |
INTEGERNUMBER | NNN |
| UNIDENTIFIEDCLIENTCASEMAX | Session: Attendance Capacity, Number NNN |
The number that indicates an event is as full as it can be or has reached capacity for an instance of service delivery within a reporting period. |
INTEGERNUMBER | NNN |
| TOPICCODE | Session: Topic, code A(18) |
A code that represents the main focus of service delivery at a given session. |
ALPHASTRING | A(18) |
| MONEYWORKSHOPCODE | Session: Money management course, code X(5) |
A code that represents the type of money workshop delivered at a given session. |
ALPHANUMERICSTRING | X(5) |
| SERVICESETTINGCODE | Session: Service setting, code X(15) |
A code that represents the category of physical location or delivery method for a given session. |
ALPHASTRING | X(15) |
| PARENTINGAGREEMENTCODE | Session: Parenting agreement, Code A(10) |
A code that represents a parenting agreement for a given session. |
ALPHASTRING | A(10) |
| PARENTINGAGREEMENTDATE | Session: Parenting Agreement, Date YYYYMMDD |
Parenting agreement date, represented as year, month, day for a given session. |
DATE | YYYYMMDD |
| PARENTINGAGREEMENTLEGALHELP | Session: Parenting agreement legal help, Text XXX |
Parenting agreement legal help indicator - legacy system |
ALPHANUMERICSTRING | XXX |
| PROPERTYAGREEMENTCODE | Session: Property Agreement, Code A(10) |
A code that represents a property agreement for a given session. |
ALPHASTRING | A(10) |
| PROPERTYAGREEMENTDATE | Session: Property Agreement, Date YYYYMMDD |
Property agreement date, represented as year, month, day for a given session. |
DATE | YYYYMMDD |
| PROPERTYAGREEMENTLEGALHELP | Session: Property agreement legal help, Text XXX |
Property agreement legal help indicator - legacy system |
ALPHANUMERICSTRING | XXX |
| CERTIFICATETYPECODE | Session: Certificate, type code A(12) |
A code that represents the type of certificate for a given session. |
ALPHASTRING | A(12) |
| CERTIFICATEISSUEDDATE | Session: Certificate, Date YYYYMMDD |
The issue date represented as year, month, day of certificate for a given session. |
DATE | YYYYMMDD |
| INTERPRETERPRESENT | Session: Interpreter Present, code N |
A code that represents whether an Interpreter was present during a session. |
NUMBERSTRING | N |
| FEECHARGEDAMOUNT | Session: Fee Charged, Total Australian currency N(8) |
Fee Charged for a Session (TEI - legacy system) |
INTEGERNUMBER | N(8) |
| ASSISTANCECOSTAMOUNT | Session: Assistance Cost, Total Australian currency N(8) |
Assistance Cost for a Session (TEI - legacy system) |
INTEGERNUMBER | N(8) |
| ASSISTANCEMINUTES | Session: Assistance Minutes, Text X(180) |
Assistance Minutes for a Session (TEI - legacy system) |
CHARACTERSTRING | X(180) |
| ASSISTANCEQUANTITY | Session: Assistance Quantity, Text X(50) |
Assistance Quantity for a Session (TEI - legacy system) |
ALPHANUMERICSTRING | X(50) |
| 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) |
| BATCHID | Record: Batch Id, Text X(200) |
System generated identification generated when (data) ingested into BigQuery, represented by text. |
ALPHANUMERICSTRING | X(200) |