You are viewing an old version of this page. View the current version.
Compare with Current
View Version History
Version 1
Next »
The Tableau report this page accompanies aims to identify current students who are commuters, as well as identify current applicants who may become commuter students when they enrol.
Commuter Students → https://tableau.york.ac.uk/#/workbooks/4502/views
Background
This work was requested by Becki Harrington in March 2024, to help inform the work of the Student Commuter Task and Finish group.
Tableau Development Log
Date | Main Development | Notes |
|---|
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 | |
October 2024 | New rule for identifying commuter applicants | CAP_LATH field added to report to help identify UGH applicants as potential commuters. |
Report Logic
Applicants
Currently in use? | Date supersceded | Code | Notes |
|---|
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 | | 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' | |