Definition
The Vacancy Placements tables provide data on Vacancy Placements, also known as job placements, for Workforce Australia Services (Provider Services), Workforce Australia Broome Employment Services (Broome Services), and Workforce Australia Transition to Work (TtW) participants.
The tables include information on vacancy type and tenure, employer and provider site.
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| dbo.t_Vacancy_Placements.DataAsAt | System: Data As At, Date | Date the information was extracted from the source system. | Date | YYYY-MM-DD |
| dbo.t_Vacancy_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_Vacancy_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_Vacancy_Placements.CharacteristicsLinkageKey | Vacancy Placements: Characteristics Linkage Key |
Linkage key used to join to Participant Characteristics table to source characteristics at Vacancy Placement Date. |
VarChar | X[100] |
| dbo.t_Vacancy_Placements.VacancyReferralId | Vacancy Placements: Vacancy Referral Id, Identifier |
The unique numeric characters assigned to a Participant’s referral to a specific job opportunity recorded as a Vacancy in the Department’s IT Systems, represented as a number. |
BigInt | - |
| dbo.t_Vacancy_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_Vacancy_Placements.ProgramTypeCode | Vacancy Placements: Program Type Code, Code |
Code that identifies the program type of the provider site related to the Vacancy Placement. |
VarChar | AAA[N] |
| dbo.t_Vacancy_Placements.ProgramTypeDesc | Vacancy Placements: Program Type Description, Text |
Description of the program type of the provider site related to the Vacancy Placement. |
VarChar | X[500] |
| dbo.t_Vacancy_Placements.VacancyPlacementDate | Vacancy Placements: Vacancy Placement Date |
The date that a Participant formally begins paid employment through a recorded Vacancy Placement in the Department’s IT Systems, under Workforce Australia Services, represented as a date. |
Date | YYYY-MM-DD |
| dbo.t_Vacancy_Placements.OccupationLevel1Code | Vacancy Placements: Occupation Level 1, Code |
Occupation category of an identified vacancy. Occupation category is defined per the Australian and New Zealand Standard Classification of Occupations (ANZSCO). |
Small Integer | N[1] |
| dbo.t_Vacancy_Placements.OccupationLevel1Desc | Vacancy Placements: Occupation Level 1 Description, Text |
The ANZSCO (Australian and New Zealand Standard Classification of Occupations) describes occupations based on skill level and specialization, with a hierarchical structure. |
VarChar | X[500] |
| dbo.t_Vacancy_Placements.OccupationLevel2Code | Vacancy Placements: Occupation Level 2 Code, Code |
Code that identifies the sub major group occupation category of the vacancy, defined as per the Australian and New Zealand Standard Classification of Occupations (ANZSCO). Occupations that require skills commensurate with an Associate Degree, Advanced Diploma, or Diploma, or at least three years of relevant experience. In some cases, relevant experience and/or on-the-job training may be needed in addition to the formal qualification. |
VarChar | X[2] |
| dbo.t_Vacancy_Placements.OccupationLevel2Desc | Vacancy Placements: Occupation Level 2 Description, Text |
ANZSCO Skill Level 2 lists sub major group occupations that require skills commensurate with an Associate Degree, Advanced Diploma, or Diploma, or at least three years of relevant experience. In some cases, relevant experience and/or on-the-job training may be needed in addition to the formal qualification. |
VarChar | X[500] |
| dbo.t_Vacancy_Placements.OccupationCode | Vacancy Placements: Occupation Code, Code |
ANZSCO Skill Level 4 indicates an occupation that requires skills acquired through a Certificate II or III qualification, or at least one year of relevant experience. This level is below the skill levels typically associated with tradespersons or professionals, but it does require more than just on-the-job training. |
VarChar | N[6] |
| dbo.t_Vacancy_Placements.OccupationDesc | Vacancy Placements: Occupation Description, Text |
ANZSCO Skill Level 4 indicates an occupation that requires skills acquired through a Certificate II or III qualification, or at least one year of relevant experience. This level is below the skill levels typically associated with tradespersons or professionals, but it does require more than just on-the-job training. |
VarChar | N[6] |
| dbo.t_Vacancy_Placements.VacancyTenureCode | Vacancy Placements: Vacancy Tenure Code, Code |
Indication of the employment tenure type associated with a Participant’s job placement, represented as a code. |
VarChar | A[1] |
| dbo.t_Vacancy_Placements.VacancyTenureDesc | Vacancy Placements: Vacancy Tenure Description, Text |
Identifying the nature of a Participant’s scheduled work hours in a job placement, distinguishing between full-time and part-time arrangements. |
VarChar | X[500] |
| dbo.t_Vacancy_Placements.VacancyFullPartCode | Vacancy Placements: Vacancy FullPart Code, Code |
Identifying the nature of a Participant’s scheduled work hours in a job placement, distinguishing between full-time and part-time arrangements, represented as a code. |
VarChar | A[1] |
| dbo.t_Vacancy_Placements.VacancyFullPartDesc | Vacancy Placements: Vacancy FullPart Description, Text |
Description identifying the nature of a Participant’s scheduled work hours in a job placement, distinguishing between full-time and part-time arrangements |
VarChar | X[500] |
| dbo.t_Vacancy_Placements.WageSubsidyEligibility | Vacancy Placements: Wage Subsidy Eligibility, Indicator |
The eligibility status for Wage Subsidy support in relation to a Participant’s job placement. |
Small Integer | N[1] |