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

Definition

A1.5:TEI Session data

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 supplied
    Generation
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