I could do with some assistance to create a new report for the three UK schools to have access to. Quite a bit of this I think I could make myself, but there are some fields that are based on our HESA field data, and some of them I can't find a way to link to through Advanced Queries yet.
At the moment I'm envisions an Excel download with the following:
1. Separate tabs for UG, PGT, and PGR (these can be seperated by College, I think).
2. On all three, columns to display:
b. Major Degree Track(s) for Degree Tracks without a Completed Date
c. Credits for the current academic year
d. EU/Non-EU (Student > Personal Info > Profile > Citizenship)
e. Start Date
f. QUALENT3 (Student > HESA > Student Engagement > Highest Qualification on Entry) for most recent entity.
Hopefully this makes sense - let me know if you need more information!