Definition
Data source details
Provenance records
Source distributions
-
Source Distributions
-
TEI_Attendance Table
Statuses: [FACSIAR Data Governance Committee: Standard, May 20, 2021]The Attendance table records all attendance, sessions, activity and service type details. Each of these are associated with the Client...
Release Date No release date suppliedGeneration -
TEI_Attendance 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-06-30 00:00:00 |
CHARACTERSTRING | X(18) |
| ServiceTypeId_hashed | Session: Service Type, Code N(4) |
The code that represents the main focus of service delivery at a given session.
Specific Information:
Data Type: Text category
Field Description: Session: Service Type, Code N(4) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
NUMBERSTRING | N(4) |
| OutletId_hashed | Data Exchange: Outlet identifier, X(19) |
A number that represents a system-generated identifier for a unique outlet record in the Data Exchange.
Specific Information:
Data Type: Text free
Field Description: Data Exchange: Outlet identifier, X(19) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
CHARACTERSTRING | X(18) |
| OrganisationActivityId_hashed | Data Exchange: Organisation Activity, identifier X(19) |
A number that represents a system-generated identifier for a unique Organisation Activity record in the Data Exchange.
Specific Information:
Data Type: Text free
Field Description: Data Exchange: Organisation Activity, identifier X(19) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
CHARACTERSTRING | X(18) |
| LeadOrgId_hashed | 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.
Specific Information:
Data Type: Text category
Field Description: Data Exchange: Lead Organisation identifier, X(19) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
CHARACTERSTRING | X(18) |
| DeliveryOrgId_hashed | 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.
Specific Information:
Data Type: Text category
Field Description: Data Exchange: Delivery Organisation identifier, X(19) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
CHARACTERSTRING | X(18) |
| ClientId_hashed | Data Exchange: Client identifier, X(19) |
A number that represents a system-generated identifier for a unique client record in the Data Exchange.
Specific Information:
Data Type: Text free
Field Description: Data Exchange: Client identifier, X(19) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
CHARACTERSTRING | X(18) |
| CaseClientId_hashed | Data Exchange: Case Client identifier, identifier X(19) |
A number that represents a system-generated identifier for a unique Client Case record in the Data Exchange.
Specific Information:
Data Type: Text free
Field Description: Data Exchange: Case Client identifier, identifier X(19) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
CHARACTERSTRING | X(18) |
| AttendanceId_hashed | Data Exchange: Attendance identifier, X(19) |
A number that represents a system-generated identifier for a unique attendance record in the Data Exchange.
Specific Information:
Data Type: Text free
Field Description: Data Exchange: Attendance identifier, X(19) Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
CHARACTERSTRING | X(18) |
| ActivityId_hashed | Data Exchange: Program activity identifier, Code NN |
A number that represents an identifier for a unique program activity record in the Data Exchange.
Specific Information:
Data Type: Text category
Field Description: Data Exchange: Program activity identifier, Code NN Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
NUMBERSTRING | NN |
| ExitReasonCode | Service episode: Service cessation reason, TEI Exit Code X(16) |
The reason a client exited or is no longer receiving a service, as represented by a label.
Specific Information:
Data Type: Numeric category
Field Description: Field Start Date: No data after dropping nulls Field End DateNo data after dropping nulls |
ALPHANUMERICSTRING | X(16) |
| ReferralToInternalDate | Session: Referral Date, YYYYMMDD |
A date represented as year, month, day of a referral for the receipt of an instance of service.
Specific Information:
Data Type: Date
Field Description: Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
DATE | YYYYMMDD |
| ReferralToInternalKey | Session: Referral To Internal Key, Identifier N(5) |
A code recorded as a logical combination of alphanumeric characters of the type of service/s selected for referral to providers internal to the organisation.
Specific Information:
Data Type: Numeric integer
Field Description: Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
NUMBERSTRING | N(5) |
| ReferralToExternalDate | Session: Referral Date, YYYYMMDD |
A date represented as year, month, day of a referral for the receipt of an instance of service.
Specific Information:
Data Type: Date
Field Description: Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
DATE | YYYYMMDD |
| ReferralToExternalKey | Session: Referral To External Key, Identifier N(5) |
A code recorded as a logical combination of alphanumeric characters of the type of service/s selected for referral to providers external to the organisation.
Specific Information:
Data Type: Numeric integer
Field Description: Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
NUMBERSTRING | N(5) |
| ReferralFromSource | Service Event: Referral Source, TEI code X(20) |
A code that represents a person or organisation from which a person or group of people is referred for Targeted Earlier Intervention services.
Specific Information:
Data Type: Text category
Field Description: Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
ALPHANUMERICSTRING | X(12) |
| PrimaryAssistanceNeededKey | Person: Primary assistance needed, Service Type TEI Code X(20) |
A code that represents the Targeted Earlier Intervention service of chief importance that is required by a person.
Specific Information:
Data Type: Numeric category
Field Description: Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
ALPHANUMERICSTRING | X(20) |
| AssistanceNeededKey | Person: Assistance needed, Service Type TEI Code X(20) |
A code that represents the Targeted Earlier Intervention service that is required by a person.
Specific Information:
Data Type: Numeric integer
Field Description: Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
ALPHANUMERICSTRING | X(20) |
| AgeAtSession | Person: Age, Total Years NNN |
The age of the person in (completed) years at a specific point in time.
Specific Information:
Data Type: Numeric category
Field Description: Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
NUMBERSTRING | NNN |
| ConductedDate | Session: Conducted Date, YYYYMMDD |
The date represented as year, month, day on which a given session took place.
Specific Information:
Data Type: Date
Field Description: Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
DATE | YYYYMMDD |
| AttendanceCount | Session: Attendance count, Number NNN |
The total (count) of attendees at a session.
Specific Information:
Data Type: Numeric category
Field Description: Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
INTEGERNUMBER | NNN |
| ParticipationType | Person: Participation type, Label A(10) |
The code that represents the role of a given person at a session.
Specific Information:
Data Type: Text category
Field Description: Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
ALPHASTRING | A(10) |
| ppn | - |
-
Specific Information:
Data Type: Numeric integer
Field Description: Personal Identification Number Field Start Date: 2019-07-01 00:00:00 Field End Date2020-06-30 00:00:00 |
- | - |