Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This page captures the National Reporting Requirements for report to be built from the Oriel Recruitment Dataset.

Working Group

James Harris Ashley Ransoo Alana Martinez (Unlicensed) Clare Wright, Jonathan Howes, Alice Gagg

Oriel Dataset

Table Name

Column Name

Comments

vw_VacancyList

ClosingDateTime

vw_VacancyList

Grade

vw_VacancyList

GradeAbbreviation

vw_VacancyList

NationalVacancyId

vw_VacancyList

OpeningDateTime

vw_VacancyList

OrganisationRecruitingForList

vw_VacancyList

PostType

vw_VacancyList

PreferencingRegion

vw_VacancyList

PreferencingSubRegion

vw_VacancyList

ProgrammeStatus

vw_VacancyList

SpecialtyProgramme

vw_VacancyList

StaffGroup

vw_VacancyList

VacancyId

vw_VacancyList

VacancyTitle

vw_VacancyDetails

AdvertDescription

vw_VacancyDetails

ClosingDateTime

vw_VacancyDetails

CommencingFrom

vw_VacancyDetails

EnquiryEmailAddress

vw_VacancyDetails

EnquiryWebsite

vw_VacancyDetails

Grade

vw_VacancyDetails

GradeAbbreviation

vw_VacancyDetails

NationalVacancyId

vw_VacancyDetails

OpeningDateTime

vw_VacancyDetails

OrganisationRecruitingForList

vw_VacancyDetails

PostType

vw_VacancyDetails

PreferencingRegion

vw_VacancyDetails

PreferencingSubRegion

vw_VacancyDetails

RecruitmentOffice

vw_VacancyDetails

SpecialtyProgramme

vw_VacancyDetails

StaffGroup

vw_VacancyDetails

VacancyId

vw_VacancyDetails

VacancyTitle

vw_VacancyDetails

VacancyURL

vw_VacancyDetails

HierarchyDeadlineDate

To know the cutoff date for all offer accepted.

vw_VacancyDetails

UpgradeDeadlineDate

To know the cutoff date for potential upgrades.

vw_VacancyDetails

RoundID

To be able to filter vacancies to a particular round./To not have to deconcatenate this value from the National Vacancy ID

vw_VacancyDetails

RoundRO

To be able to filter vacancies to a particular round./To not have to deconcatenate this value from the National Vacancy ID

vw_VacancyDetails

Round

To not have to deconcatenate this value from the National Vacancy ID

vw_VacancyDetails

RecruitmentYear

To not have to deconcatenate this value from the National Vacancy ID

vw_VacancyDetails

RecruitmentType

To not have to deconcatenate this value from the National Vacancy ID

vw_VacancyDetails

AdvertNumber

To not have to deconcatenate this value from the National Vacancy ID

vw_PreferenceDetails

ClosingDateTime

vw_PreferenceDetails

CompetitionRatio

vw_PreferenceDetails

Employer

vw_PreferenceDetails

NationalVacancyId

vw_PreferenceDetails

OfferCode

vw_PreferenceDetails

OpeningDateTime

vw_PreferenceDetails

PlacementSite

vw_PreferenceDetails

PlacesAvailable

vw_PreferenceDetails

PreferenceLevel

vw_PreferenceDetails

PreferenceUniqueCode

vw_PreferenceDetails

ProgrammeDuration

vw_PreferenceDetails

ProgrammeName

vw_PreferenceDetails

ProgrammeNumber

vw_PreferenceDetails

SpecialtyProgramme

vw_PreferenceDetails

VacancyId

Reporting Requirements

No.

Report Name

Priority

Report Description

Target Users/Nations

Read/Write Access

Columns to be included

Filters/Sortable by

Comments

  • No labels