Definition
The Contract Referral Placements table provides data on contract referral placements 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.
A contract referral placement (CRP) is an occurrence of a participant receiving services through a provider’s site within an employment region in a particular employment service program. A new CRP is generated within a contract referral if a participant moves between the provider's sites within the employment region. Each contract referral will have at least one CRP.
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| dbo.t_Contract_Referral_Placements.DataAsAt | System: Data As At, Date | Date the information was extracted from the source system. | Date | YYYY-MM-DD |
| dbo.t_Contract_Referral_Placements.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_Contract_Referral_Placements.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_Contract_Referral_Placements.InitialRefCharacteristicsLinkageKey | Contract Referral Placements: Initial Referral Characteristics Identifier, Linkage Key |
Linkage key used to join to Participant Characteristics table to source characteristics at period of assistance POA Date where Initial Referral Count = 1. |
VarChar | X[100] |
| dbo.t_Contract_Referral_Placements.InitialComCharacteristicsLinkageKey | Contract Referral Placements: Initial Commencement Characteristics Identifier, Linkage Key |
Linkage key used to join to Participant Characteristics table to source characteristics at Commencement Date where Initial Commencement Count = 1. |
VarChar | X[100] |
| dbo.t_Contract_Referral_Placements.CaseloadCharacteristicsLinkageKey | Contract Referral Placement: Caseload Characteristics Identifier, Linkage Key |
Linkage key used to join to Participant Characteristics table to source characteristics at Caseload Date where Caseload Count = 1. |
VarChar | X[100] |
| dbo.t_Contract_Referral_Placements.ExitCharacteristicsLinkageKey | Contract Referral Placements: Exit Characteristics Identifier, Linkage Key |
Linkage key used to join to Participant Characteristics table to source characteristics at period of assistance POA End Date where Exit Count = 1. |
VarChar | X[100] |
| dbo.t_Contract_Referral_Placements.ProgramTypeCode | Contract Referral Placements: Program Type, Code |
The employment service program a participant has been referred to represented by a code set representing the program type.
|
VarChar | AAA[N] |
| dbo.t_Contract_Referral_Placements.ProgramTypeDesc | Contract Referral Placements: Program Type Description, Text |
A description of the type of employment service program a participant has been referred to. |
VarChar | X[500] |
| dbo.t_Contract_Referral_Placements.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_Contract_Referral_Placements.POADate | Contract Referral Placements: Period of Assistance (POA) Date | The point in time that a participant first commenced in an employment services program within a given period of assistance, as represented by a date. | Date | YYYY-MM-DD |
| dbo.t_Contract_Referral_Placements.POAEndDate | Contract Referral Placements: Period of Assistance (POA) End Date |
The point in time that a participant ceases in an employment services program within a given period of assistance, as represented by a date. |
Date | YYYY-MM-DD |
| dbo.t_Contract_Referral_Placements.PlacementDate | Contract Referral Placements: Placement Date | The point in time at which a contract referral placement occurred, represented as a date. | Date | YYYY-MM-DD |
| dbo.t_Contract_Referral_Placements.CommencementDate | Contract Referral Placements: Commencement Date | The point in time that the participant (that the contract referral placement relates to) has been recorded as attending their initial interview by their provider and has an approved job plan, represented as a date. | Date | YYYY-MM-DD |
| dbo.t_Contract_Referral_Placements.PlacementEndDate | Contract Referral Placement: Placement End Date |
The point in time that the contract referral placement ended or ceased, represented as a date. |
Date | YYYY-MM-DD |
| dbo.t_Contract_Referral_Placements.PlacementOutcomeCode | Contract Referral Placements: Placement Outcome, Code |
A code that identifies the end reason of the Contract Referral Placement.
|
VarChar | X[4] |
| dbo.t_Contract_Referral_Placements.PlacementOutcomeDesc | Contract Referral Placements: Placement Outcome Description, Text |
A description that identifies the end reason of the Contract Referral Placement.
|
VarChar | X[500] |
| dbo.t_Contract_Referral_Placements.PlacementStatusCode | Contract Referral Placements: Placement Status, Code |
A code set representing the system statuses that a contract referral placement can have based upon the current stage of service being received by the participant.
|
VarChar | A[3] |
| dbo.t_Contract_Referral_Placements.PlacementStatusDesc | Contract Referral Placements: Placement Status Description, Text |
A description defining the system statuses that a contract referral placement can have based upon the current stage of service being received by the participant.
|
VarChar | X[500] |
| dbo.t_Contract_Referral_Placements.InitialReferralCount | Contract Referral Placements: Initial Referral Count |
Indicates the first Contract Referral Placement for the participant within their Period of Assistance (POA). |
Small Integer | N[1] |
| dbo.t_Contract_Referral_Placements.InitialCommencementCount | Contract Referral Placements: Initial Commencement Count |
Indicates the first commenced Contract Referral Placement for the participant within their Period of Assistance (POA). |
Small Integer | N[1] |
| dbo.t_Contract_Referral_Placements.ExitCount | Contract Referral Placements: Exit Count |
Indicates the last Contract Referral Placement for the participant within their Period of Assistance (POA), where they have exited their POA. |
Small Integer | N[1] |
| dbo.t_Contract_Referral_Placements.CaseloadCount | Contract Referral Placements: Caseload Count |
Indicates the participant is commenced, pending or paused on an employment service program caseload on the date the information was extracted from the source system. |
Small Integer | N[1] |
| dbo.t_Contract_Referral_Placements.CaseloadDate | Contract Referral Placements: Caseload Date |
Extract date of information from the Employment Services Systems and a caseload count exists for caseload information. |
Date | YYYY-MM-DD |
| dbo.t_Contract_Referral_Placements.OptOutReasonCode | Contract Referral Placements: Opt Out Reason, Code |
The reason given that for a contract referral placement a participant has chosen to decline to engage with the Online Services component of Workforce Australia, represented as a code. |
VarChar | A[3] |
| dbo.t_Contract_Referral_Placements.OptOutReasonDesc | Contract Referral Placements: Opt Out Reason Description, Text |
The reason given that for a contract referral placement a participant has chosen to decline to engage with the Online Services component of Workforce Australia, represented as a description of the code. |
VarChar | X[500] |
| dbo.t_Contract_Referral_Placements.ExitCode | Contract Referral Placements: Exit, Code |
The reason the participant has exited an employment services program for a given contract referral placement within their Period of Assistance (POA), represented by a code.
|
VarChar | X[3] |
| dbo.t_Contract_Referral_Placements.ExitDesc | Contract Referral Placements: Exit Description, Text |
The reason the participant has exited an employment services program for a given contract referral placement within their Period of Assistance (POA).
|
VarChar | X[500] |
| dbo.t_Contract_Referral_Placements.ExitGroupProxy | Contract Referral Placements: Exit Group Proxy, Code |
Description of the group for the proxy reason why the Period of Assistance (POA) was exited. |
VarChar | X[500] |
| dbo.t_Contract_Referral_Placements.PausedReasonCode | Contract Referral Placements: Paused Reason, Code |
A code that identifies the reason, for a contract referral placement, the participant is temporarily not required to participate in employment services and/or complete their mutual obligations requirements while continuing to receive income support payments, selected based on the reason with the longest remaining duration.
|
VarChar | X[3] |
| dbo.t_Contract_Referral_Placements.PausedReasonDesc | Contract Referral Placements: Paused Reason Description, Text |
Identifies the reason for a contract referral placement, the participant is temporarily not required to participate in employment services and/or complete their mutual obligations requirements while continuing to receive income support payments, selected based on the reason with the longest remaining duration.
|
VarChar | X[500] |
| dbo.t_Contract_Referral_Placements.PausedGroup | Contract Referral Placements: Paused Group Description, Text | Description of the group of the reason why the participant is paused on the caseload, based on the reason with the longest duration remaining. | VarChar | X[500] |