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

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.
The first level of ANZSCO, Major Groups, are broad categories that group occupations based on the nature of work performed and the skill level required.

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]