Definition
This distribution represents the Client Attendance table in the Data Exchange curated dataset.
Data source details
Path name | Data Element | Definition | Data Type | Format |
---|---|---|---|---|
AttendanceId | Data Exchange: Attendance identifier, ID number |
A system-generated identifier for a unique attendance record in the Data Exchange, represented by a number.
Specific Information:
Organisations are strongly encouraged to create individual client records for as many of their clients as possible, however in some circumstances including when it is impractical to collect information about individual participants the aggregate number of unidentified clients is recorded. The DEX application only generates attendance IDs for individual clients (either attending as a client or support person - Participation Type in ('CLIENT’,‘SUPPORT’)). We add unidentified client attendances to the attendance table and set AttendanceId to the negative of SessionId, and Participation Type to ‘GROUP’. Further, because unidentified client attendances are not linked to individual client records, ClientId and CaseClientId are coded as 0. Unidentified client numbers captured at the case level estimate the total number of unidentified clients who are anticipated to attend services. In contrast, the unidentified client attendance numbers captured at the session level records how many unidentified clients actually attended that instance of service. This prevents double counting. For example, if the unidentified client total at the case level is 100, and there are two sessions each with 100 unidentified clients; the total specified at the case level indicates that there may be up to 100 unique unidentified clients for each session, and not 200 in total. For more information on the reporting of unidentified clients refer to sections 2.6-2.7 of The Data Exchange Protocols. |
Number | N[N(18)] |
SessionId | Data Exchange: Session identifier, ID number |
A system-generated identifier for a unique session record in the Data Exchange, represented by a number. |
Number | N[N(18)] |
ClientId | Client: Identifier, ID number |
A system-generated identifier for a unique client record in the Data Exchange, represented by a number. |
Number | N[N(18)] |
CaseClientId | You don't have permission to see this Data Element. | - | - | - |
OrganisationActivityId | You don't have permission to see this Data Element. | - | - | - |
OutletId | Data Exchange: Outlet identifier, ID number |
A system-generated identifier for a unique outlet record in the Data Exchange, represented by a number. |
Number | N[N(18)] |
LeadOrgId | You don't have permission to see this Data Element. |
-
Specific Information:
Organisations that directly receive funding from grants. These organisations may also deliver the service, or allocate the funding to other Delivery Organisations. |
- | - |
DeliveryOrgId | You don't have permission to see this Data Element. |
-
Specific Information:
Organisations delivering services directly to clients. These organisations may receive funding directly or through a Funding Recipient (Lead Organisation) |
- | - |
ActivityId | Data Exchange: Program activity identifier, ID number |
An identifier for a unique program activity record in the Data Exchange, represented by a number. |
Number | N[NN] |
ServiceTypeId | Data Exchange: Program activity identifier, ID number |
An identifier for a unique program activity record in the Data Exchange, represented by a number. |
Number | N[NN] |
ParticipationType | Client: Participation type, Label |
The role of a given client at a session, represented by a label. |
String | AAAAA[AA] |
AttendanceCount | You don't have permission to see this Data Element. | - | - | - |
ConductedDate | Session: Conducted date, DDMMYYYY |
The date a given session took place, represented by DDMMYYYY. |
Date/Time | DDMMYYYY |
AgeAtSession | You don't have permission to see this Data Element. | - | - | - |
AssistanceNeededKey | You don't have permission to see this Data Element. | - | - | - |
PrimaryAssistanceNeededKey | You don't have permission to see this Data Element. | - | - | - |
ReferralFromSource | You don't have permission to see this Data Element. | - | - | - |
ReferralToExternalKey | You don't have permission to see this Data Element. | - | - | - |
ReferralToExternalDate | You don't have permission to see this Data Element. | - | - | - |
ReferralToInternalKey | You don't have permission to see this Data Element. | - | - | - |
ReferralToInternalDate | You don't have permission to see this Data Element. | - | - | - |
ExitReasonCode | You don't have permission to see this Data Element. | - | - | - |