Definition
Data source details
Provenance records
Source distributions
-
Source Distributions
-
TEI_Session Table
Statuses: [FACSIAR Data Governance Committee: Standard, May 26, 2021]A session in the Targeted Earlier Intervention program records what service was delivered on a particular date within a reporting period,...
Release Date No release date suppliedGeneration -
TEI_Session Table
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| SessionID_hashed | 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:
Data Type: Text free
Field Description: Data Exchange: Session identifier, X(19) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
CHARACTERSTRING | X(18) |
| CaseId_hashed | Person: Case Identifier, X(10) |
A system-generated identifier for a case associated with a person in receipt of services.
Specific Information:
Data Type: Text free
Field Description: Person: Case Identifier, X(10) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
CHARACTERSTRING | X(14) |
| AssistanceQuantity | Session: Assistance Quantity, Text X(50) |
Assistance Quantity for a Session (TEI - legacy system)
Specific Information:
Data Type: Text category
Field Description: Session: Assistance Quantity, Text X(50) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
ALPHANUMERICSTRING | X(50) |
| AssistanceMinutes | Session: Assistance Minutes, Text X(180) |
Assistance Minutes for a Session (TEI - legacy system)
Specific Information:
Data Type: Text category
Field Description: Session: Assistance Minutes, Text X(180) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
CHARACTERSTRING | X(180) |
| AssistanceCostAmount | Session: Assistance Cost, Total Australian currency N(8) |
Assistance Cost for a Session (TEI - legacy system)
Specific Information:
Data Type: Text category
Field Description: Session: Assistance Cost, Total Australian currency N(8) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
INTEGERNUMBER | N(8) |
| FeeChargedAmount | Session: Fee Charged, Total Australian currency N(8) |
Fee Charged for a Session (TEI - legacy system)
Specific Information:
Data Type: Text category
Field Description: Session: Fee Charged, Total Australian currency N(8) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
INTEGERNUMBER | N(8) |
| InterpreterPresent | Session: Interpreter Present, code N |
A code that represents whether an Interpreter was present during a session.
Specific Information:
Data Type: Text category
Field Description: Session: Interpreter Present, code N Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
NUMBERSTRING | N |
| CertificateIssuedDate | Session: Certificate, Date YYYYMMDD |
The issue date represented as year, month, day of certificate for a given session.
Specific Information:
Data Type: Text category
Field Description: Session: Certificate, Date YYYYMMDD Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
DATE | YYYYMMDD |
| CertificateTypeCode | Session: Certificate, type code A(12) |
A code that represents the type of certificate for a given session.
Specific Information:
Data Type: Text category
Field Description: Session: Certificate, type code A(12) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
ALPHASTRING | A(12) |
| ParentingAgreementLegalHelp | Session: Parenting agreement legal help, Text XXX |
Parenting agreement legal help indicator - legacy system
Specific Information:
Data Type: Text category
Field Description: Session: Parenting agreement legal help, Text XXX Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
ALPHANUMERICSTRING | XXX |
| ParentingAgreementDate | Session: Parenting Agreement, Date YYYYMMDD |
Parenting agreement date, represented as year, month, day for a given session.
Specific Information:
Data Type: Text category
Field Description: Session: Parenting Agreement, Date YYYYMMDD Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
DATE | YYYYMMDD |
| ParentingAgreementCode | Session: Parenting agreement, Code A(10) |
A code that represents a parenting agreement for a given session.
Specific Information:
Data Type: Text category
Field Description: Session: Parenting agreement, Code A(10) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
ALPHASTRING | A(10) |
| ServiceSettingCode | Session: Service setting, code X(15) |
A code that represents the category of physical location or delivery method for a given session.
Specific Information:
Data Type: Text category
Field Description: Session: Service setting, code X(15) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
ALPHASTRING | X(15) |
| MoneyWorkshopCode | Session: Money management course, code X(5) |
A code that represents the type of money workshop delivered at a given session.
Specific Information:
Data Type: Numeric category
Field Description: Session: Money management course, code X(5) Field Start Date: No data after dropping nulls Field End DateNo data after dropping nulls |
ALPHANUMERICSTRING | X(5) |
| TopicCode | Session: Topic, code A(18) |
A code that represents the main focus of service delivery at a given session.
Specific Information:
Data Type: Numeric category
Field Description: Session: Topic, code A(18) Field Start Date: No data after dropping nulls Field End DateNo data after dropping nulls |
ALPHASTRING | A(18) |
| 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.
Specific Information:
Data Type: Numeric integer
Field Description: Session: Attendance Capacity, Number NNN Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
INTEGERNUMBER | NNN |
| UnidentifiedClientAttendance | Session: Attendance count, Number NNN |
The total (count) of attendees at a session.
Specific Information:
Data Type: Numeric integer
Field Description: Session: Attendance count, Number NNN Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-25 00:00:00 |
INTEGERNUMBER | NNN |
| AttendanceProfileCode | Session: Attendance profile, Code A(11) |
A code that represents the type of instance of services someone has been present for.
Specific Information:
Data Type: Text category
Field Description: Session: Attendance profile, Code A(11) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
ALPHASTRING | A(11) |
| CaseEndDate | Person: Case Identifier End Date, YYYYMMDD |
The date represented as year, month, day associated with the end of a person's case identifier.
Specific Information:
Data Type: Date
Field Description: Person: Case Identifier End Date, YYYYMMDD Field Start Date: 2019-07-01 00:00:00 Field End Date2020-09-30 00:00:00 |
DATE | YYYYMMDD |