Page Comparison

5th March 2024

Report first published

Only contains information on enrolled students.

10th June 2024

Data on applicants included on new tabs

Enrolled and applicant data sources are separate.

26th June 2024

Applicant data ammended

• Apps data was not being filtered for ‘current’ record, so counts were far too high.

• 2024/5 apps added.

• Report brought in-line with new style.

25th September 2024

2024/5 enrolment figures added

31st October 2024

New rule for identifying commuter applicants

CAP_LATH field added to report to help identify UGH applicants as potential commuters.

Y

30/10/2024

select apps.*, demog.home_address_postcode, demog.home_address_latitude, demog.home_address_longtitude, sits.cap_lath
from apps_tracking_mv apps
left join apps_demog_mv demog
on demog.stu_code = apps.stu_code
and demog.academic_year_of_entry = apps.acyearentry
and demog.mcr_code = apps.cap_mcrc
left join srs_cap@sipr.yims.york sits
on sits.cap_stuc = apps.stu_code
and sits.cap_seqn = apps.cap_seqn
and sits.cap_apfs = apps.cap_apfs
where apps.acyearentry in ('2022/3', '2023/4', '2024/5', '2025/6')
and apps.home_overseas_flag = 'H'
and apps.admissions_entity != 'Hull York Medical School'
and apps.application_cycle_type in ('Standard', 'Deferred from previous year', 'Clearing')
and apps.application_source = 'YORK'
and apps.stu_level_4 in ('UG', 'PGT', 'PGR')
and apps.record_flag = 'Current'

CAP_LATH Live at Home indicator field added. This field comes from the UCAS application form and is stored in SITS for UG Home applicants. The field is either ‘H' or 'null’, where H indicates an applicant intends to live at home.

N

31/10/2024

select apps.*, demog.home_address_postcode, demog.home_address_latitude, demog.home_address_longtitude
from apps_tracking_mv apps
left join apps_demog_mv demog
on demog.stu_code = apps.stu_code
and demog.academic_year_of_entry = apps.acyearentry
and demog.mcr_code = apps.cap_mcrc
where apps.acyearentry in ('2022/3', '2023/4', '2024/5', '2025/6')
and apps.home_overseas_flag = 'H'
and apps.admissions_entity != 'Hull York Medical School'
and apps.application_cycle_type in ('Standard', 'Deferred from previous year', 'Clearing')
and apps.application_source = 'YORK'
and apps.stu_level_4 in ('UG', 'PGT', 'PGR')
and apps.record_flag = 'Current'