All EntryProfiles at providers in England where (FundingBody.FUNDINGBODY = Office for Students or Department for Education) and (Qualification.QUALCAT has a HESA level of H, I, J or C or is M0002, M0016 or M0018 excluding H0009 and H0010) and Engagement.INCOMINGEXCHANGE does not exist and the first Engagement.ENGSTARTDATE for the Engagement is after 2007-07-31.
All EntryProfiles at providers in Wales where (EntryProfile.PERMADCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM) and (Qualification.QUALCAT with H, I, J or C or is M0002).
All EntryProfiles at providers in Northern Ireland where EntryProfile.PERMADCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM.
All EntryProfiles at providers in Scotland where (EntryProfile.PERMADCOUNTRY =XF, XG, XH, XI, XK, XL, GG, JE or IM) and (Qualification.QUALCAT equals M0002, H0003, H0004, H0005, I0001, J0000, J0001, J0002, J0003, C0000, C0001) and StudentCourseSession.INTERCALATION does not equal 01 and Engagement.INCOMINGEXCHANGE does not exist.