Definition
The Activity Referrals table provides data on activity referrals for Workforce Australia Services (Provider Services), Workforce Australia Broome Employment Services (Broome Services), Workforce Australia Online (Online Services), and Workforce Australia Transition to Work (TtW) participants.
The Activity Referrals table provides activity referrals for participants from 2015. The table includes a range of information, including the contract the participant was in when referred to the activity, activity type and sub-type, activity location, hours credited for participation and attendance, and open activity referrals.
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| bo.t_Activity_Referrals.DataAsAt | System: Data As At, Date | Date the information was extracted from the source system. | Date | YYYY-MM-DD |
| dbo.t_Activity_Referrals.PLIDAId | Participant: PLIDA Id, Unique Identification Number |
Unique identifier assigned to the participant by the Employment Services System at registration, represented as a number. |
Integer | N[15] |
| dbo.t_Activity_Referrals.POAId | Contract Referral Placements: Period of Assistance Id, Identifier |
An identifier for the Period of Assistance that a given Contract Referral Placement relates to, represented by a number. |
Integer | N[50] |
| dbo.t_Activity_Referrals.CharacteristicsLinkageKey | Activity Referrals: Characteristics Linkage Key |
Linkage key used to join to participant characteristic dataset to source characteristics at Activity Referral Creation Date. |
VarChar | X[100] |
| dbo.t_Activity_Referrals.ActivityReferralId | Activity Referral: Activity Referral Id, Identifier |
A unique identifier assigned to an activity referral, represented as a number. |
Integer | X[10] |
| dbo.t_Activity_Referrals.ContractReferralPlacementId | Contract Referral Placement: ID, Identifier |
A unique identifier assigned to a specific instance where a participant engages in a service relationship with a provider’s site under a contract referral arrangement within a defined employment region, represented as a number. |
Integer | N[8] |
| dbo.t_Activity_Referrals.ActivityReferralCreationDate | Activity Referrals: Activity Referral Creation, Date |
The calendar date on which an activity referral was first recorded or established, represented as a date. |
Date | YYYY-MM-DD |
| dbo.t_Activity_Referrals.ActivityTypeCode | Activity Referral: Activity Type, Code |
The categorisation of an activity to which a participant is referred, such as a government program, formal or informal training, or intervention-based support, represented as a code. Activity types can include but are not limited to:
|
VarChar | A[4] |
| dbo.t_Activity_Referrals.ActivityTypeDesc | Activity Referral: Activity Type Description, Text |
The categorisation of an activity to which a participant is referred, such as a government program, formal or informal training, or intervention-based support, represented as a description. Activity types can include but are not limited to:
|
VarChar | X[500] |
| dbo.t_Activity_Referrals.ActivitySubTypeCode | Activity Referrals: Activity Sub Type, Code |
A secondary classification of an activity that identifies the specific format, delivery mode, or thematic focus of the activity within its broader type, represented as a code. |
VarChar | X[4] |
| dbo.t_Activity_Referrals.ActivitySubTypeDesc | Activity Referral: Activity Sub Type, Description |
A secondary classification of an activity that identifies the specific format, delivery mode, or thematic focus of the activity within its broader type, represented as a description. |
VarChar | X(500) |
| dbo.t_Activity_Referrals.ReferralProgramTypeCode | Activity Referrals: Referral Program Type, Code |
Code that identifies the referral program type Contract Referral Placement the participant was in at the time they were referred, or the provider site who created the referral, to the activity.
|
VarChar | AAA[N] |
| dbo.t_Activity_Referrals.ReferralProgramTypeDesc | Activity Referrals: Referral Program Type Description, Text |
Description that identifies the referral program type Contract Referral Placement the participant was in at the time they were referred, or the provider site who created the referral, to the activity.
|
VarChar | X[500] |
| dbo.t_Activity_Referrals.ActivityReferralStartDate | Activity Referral: Start, Date |
The calendar date on which an activity referral is initiated, marking the beginning of the participant’s commencement with the referred activity, represented as a date. |
Date | YYYY-MM-DD |
| dbo.t_Activity_Referrals.ActivityReferralEndDate | Activity Referral: Activity Referral End, Date |
The point in time that an activity referral placement ended or ceased or is expected to end, represented as a date. |
Date | YYYY-MM-DD |
| dbo.t_Activity_Referrals.ActivityOpenCount | Activity Referral: Activity Referral Open Indicator |
A status indicator that identifies whether an activity referral remains active and accessible for participant engagement, represented as an indicator. |
Small Integer | N[1] |
| dbo.t_Activity_Referrals.ActivityReferralStatusCode | Activity Referral: Status, Code |
The current state or stage of progress assigned to an activity referral, represented as a code. |
VarChar | A[3] |
| dbo.t_Activity_Referrals.ActivityReferralStatusDesc | Activity Referrals: Status, Description |
The current state or stage of progress assigned to an activity referral, represented as a description. |
VarChar | X[500] |
| dbo.t_Activity_Referrals.ActivityReferralStatusReasonCode | Activity Referral: Status Reason, Code |
The explanation recorded for assigning a specific status to an activity referral, identifying the condition, decision, or event that triggered change, represented as a code.
|
VarChar | X[4] |
| dbo.t_Activity_Referrals.ActivityReferralStatusReasonDesc | Activity Referral: Status Reason Description, Text |
The explanation recorded for assigning a specific status to an activity referral, identifying the condition, decision, or event that triggered the change.
|
VarChar | X[500] |