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