Skip to content Learn about the access keys available for Employment and Workplace Relations metadata registry

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: 

  • a.       Government programs, such as Employability Skills Training (EST), Career Transition Assistance (CTA), Work for the Dole (WfD) and Skills for Education and Employment (SEE)
  • b.       Accredited and Non-Accredited Education and Training
  • c.       Informal Activities such as resume building, interview training and soft skills development
  • d.       Interventions such as counselling, drug and alcohol treatment, and health related services including mental health.
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: 

  • a.       Government programs, such as Employability Skills Training (EST), Career Transition Assistance (CTA), Work for the Dole (WfD) and Skills for Education and Employment (SEE)
  • b.       Accredited and Non-Accredited Education and Training
  • c.       Informal Activities such as resume building, interview training and soft skills development
  • d.       Interventions such as counselling, drug and alcohol treatment, and health related services including mental health.
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]