Page Comparison

...

No.	Table Name	Column Name	Comments
1	vw_VacancyList	ClosingDateTime
2	vw_VacancyList	Grade
3	vw_VacancyList	GradeAbbreviation
4	vw_VacancyList	NationalVacancyId
5	vw_VacancyList	OpeningDateTime
6	vw_VacancyList	OrganisationRecruitingForList
7	vw_VacancyList	PostType
8	vw_VacancyList	PreferencingRegion
9	vw_VacancyList	PreferencingSubRegion
10	vw_VacancyList	ProgrammeStatus
11	vw_VacancyList	SpecialtyProgramme
12	vw_VacancyList	StaffGroup
13	vw_VacancyList	VacancyId
14	vw_VacancyList	VacancyTitle
15	vw_VacancyDetails	AdvertDescription
16	vw_VacancyDetails	ClosingDateTime
17	vw_VacancyDetails	CommencingFrom
18	vw_VacancyDetails	EnquiryEmailAddress
19	vw_VacancyDetails	EnquiryWebsite
20	vw_VacancyDetails	Grade
21	vw_VacancyDetails	GradeAbbreviation
22	vw_VacancyDetails	NationalVacancyId
23	vw_VacancyDetails	OpeningDateTime
24	vw_VacancyDetails	OrganisationRecruitingForList
25	vw_VacancyDetails	PostType
26	vw_VacancyDetails	PreferencingRegion
27	vw_VacancyDetails	PreferencingSubRegion
28	vw_VacancyDetails	RecruitmentOffice
29	vw_VacancyDetails	SpecialtyProgramme
30	vw_VacancyDetails	StaffGroup
31	vw_VacancyDetails	VacancyId
32	vw_VacancyDetails	VacancyTitle
33	vw_VacancyDetails	VacancyURL
34	vw_VacancyDetails	HierarchyDeadlineDate	To know the cutoff date for all offer accepted.
35	vw_VacancyDetails	UpgradeDeadlineDate	To know the cutoff date for potential upgrades.
36	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
37	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
38	vw_VacancyDetails	Round	To not have to deconcatenate this value from the National Vacancy ID
39	vw_VacancyDetails	RecruitmentYear	To not have to deconcatenate this value from the National Vacancy ID
40	vw_VacancyDetails	RecruitmentType	To not have to deconcatenate this value from the National Vacancy ID
41	vw_VacancyDetails	AdvertNumber	To not have to deconcatenate this value from the National Vacancy ID
42	vw_PreferenceDetails	ClosingDateTime
43	vw_PreferenceDetails	CompetitionRatio
44	vw_PreferenceDetails	Employer
45	vw_PreferenceDetails	NationalVacancyId
46	vw_PreferenceDetails	OfferCode
47	vw_PreferenceDetails	OpeningDateTime
48	vw_PreferenceDetails	PlacementSite
49	vw_PreferenceDetails	PlacesAvailable
50	vw_PreferenceDetails	PreferenceLevel
51	vw_PreferenceDetails	PreferenceUniqueCode
52	vw_PreferenceDetails	ProgrammeDuration
53	vw_PreferenceDetails	ProgrammeName
54	vw_PreferenceDetails	ProgrammeNumber
55	vw_PreferenceDetails	SpecialtyProgramme
56	vw_PreferenceDetails	VacancyId

View file

name	Oriel2_HEE_RecruitmentNationalReporting_Proposal_5458_V3 - Signed (1).pdf

Reporting Requirements -

Include Protective Characteristics in all reports relevant

No.	Report Name/Summary	Detailed Description	Report Type - Dynamic - Static	Priority (L/M/H)	Target Users/ Audience/ Nations National Specialty Local Office	Aggregate/ Row-level data	Columns to be included	Filters/ Sortable by	Comments
1.	Core vacancies/posts advertised - by Specialty/ Grade/Nation/Region/Round/ Rounds/ Demographics/ Competition ratios	Posts filled, comparisons over the years Posts re-advertised (avoid double counting) Dual training programme sub-specialty etc.	Static - after recruitment round ended Dynamic - before recruitment round closes	Highest (for fill rates April 2024 potentially)
2.	Application Status/Window at any point during the Recruitment Round By specialty	Track progress of applications from Applied> Longlisted > Declined > Shortlisted > Offered > Offer Accepted Pseudonymised applicant data	Static - after recruitment round ended Dynamic - before recruitment round closes	High
23.	Historical Application Status trends after the Recruitment Round that is currently available via Scotland reporting system.	Lift and shift Scotland system. Pseudonymised applicant data	Static - after recruitment round ended	Dependent on having UK reporting	3.	Evidence of Recruitment Activity	Cumulative count of applicants per status Non-cumulative count of applicants per status Pseudonymised applicant data	Applicants behaviours during the application window Just around application numbers rather than the stage of application (1)	Pseudonymised applicant data How many applications? How many unique applications by specialty? How many cross-overs? Include applications in progress, i.e. not submitted Include Protective Characteristics	Static - after recruitment round ended Dynamic - before recruitment round closes	Low - No current functionality	Overseas Sponsorship Team National Local Office	Training Programme Date advertised Date opened Date closed Number of applicants applied Number of applicants longlisted Number of applicants shortlisted Number of applicants offered	4.	Core recruitment data by applicant demographics/protected characteristics - by Specialty/ Grade/Nation/Region/Round/ Rounds/ Demographics	Pseudonymised applicant data		High (for medical)	MDRS - Useful throughout the application window to try to estimate numbers without going to Oriel	Date submitted field (ability to look at applications submitted per day)
4.	Equality and Diversity Monitoring - applicable for all applicants and their reports	Pseudonymised applicant data Flag for investigation by any of the EDI pertinent information Specialty/Local Office/Nation/Region/CoQ	Static - after recruitment round ended Dynamic - before recruitment round closes	Medium - Only currently have nationality and CoQHigh	MDRS - Used most often for FOIs			Specialty Vacancy (to discount local vacancies) Unique applicants Recruitment round	Doesn’t exist in UK reporting so FOIs only past 2 years of data.
5.	Table showing count of crossover applications within and across rounds for each vacancy, this can be filtered: by Specialty/ Grade/Nation/Region/Round/ Rounds/ Demographics	Pseudonymised applicant data Crossover count at application Crossover at application as a percentage Crossover count of those who accept Each of the above reports also have the count of applicants, applications (generally the same as applicants other than where devolved nations run their own recruitment eg. NI CST) and unique applicants by specialty (potentially using the Oriel Applicant ID as the pseudonymised unique identifier)	Static - after recruitment round ended Dynamic - before recruitment round closes	Medium - High (will be re recruitment reform next years)	Used to inform changing recruitment processes.				Included in 9 3 as well. Either keep it separate or include in 9.
6.	Core vacancies/posts advertised - by Specialty/ Grade/Nation/Region/Round/ Rounds/ Demographics/ Competition ratios	Posts filled, comparisons over the years Posts re-advertised (avoid double counting) Dual training programme sub-specialty etc.	Static - after recruitment round ended Dynamic - before recruitment round closes	Highest (for fill rates April 2024 potentially)	7.	Equality and Diversity Monitoring - applicable for all applicants and their reports	Pseudonymised applicant data Flag for investigation by any of the EDI pertinent information Specialty/Local Office/Nation/Region/CoQ	Static - after recruitment round ended Dynamic - before recruitment round closes	High	MDRS - Used most often for FOIs	Specialty Vacancy (to discount local vacancies) Unique applicants Recruitment round	Doesn’t exist in UK reporting so FOIs only past 2 years of data.	8.	Where are people applying from? where people are geographically based and where they are applying to where people are qualified from and where they are applying to	Pseudonymised applicant data By address fields By Country of Qualification By previous work History By Preferences (region, sub-regions, sectors etc.)	Static - after recruitment round ended Dynamic - before recruitment round closes	Medium	National team mostly Some FOIs
9.	Applicants behaviours during the application window Just around application numbers rather than the stage of application (1)	Pseudonymised applicant data How many applications? How many unique applications by specialty? How many cross-overs? Include applications in progress, i.e. not submitted Include Protective Characteristics 7.	Core recruitment data by applicant demographics/protected characteristics - by Specialty/ Grade/Nation/Region/Round/ Rounds/ Demographics	Pseudonymised applicant data	Static - after recruitment round ended Dynamic - before recruitment round closes	Medium - Only currently have nationality and CoQ
8.	Historical Application Status trends after the Recruitment Round that is currently available via Scotland reporting system.	Lift and shift Scotland system. Pseudonymised applicant data	Static - after recruitment round ended	Dependent on having UK reporting
9.	Evidence of Recruitment Activity	Cumulative count of applicants per status Non-cumulative count of applicants per status Pseudonymised applicant data	Static - after recruitment round ended Dynamic - before recruitment round closes	High (for medical)	MDRS - Useful throughout the application window to try to estimate numbers without going to Oriel	Date submitted field (ability to look at applications submitted per day)	Low - No current functionality	Overseas Sponsorship Team National Local Office	Training Programme Date advertised Date opened Date closed Number of applicants applied Number of applicants longlisted Number of applicants shortlisted Number of applicants offered			Used for UKVI audit. Number required for each cohort (August 2024, etc).

Questions / Assumptions for Discussion

...

Versions Compared

Old Version 15

New Version Current

Key

Reporting Requirements -

Questions / Assumptions for Discussion