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

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

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)