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 2013-07-31
All EntryProfiles at providers in Northern Ireland where (EntryProfile.PERMADDCOUNTRY = XF, XG, XH, XI, XL, GG, JE or IM) and (Qualification.QUALCAT starts with H, I, J or C or is M0002, M0016 or M0018).
All EntryProfiles at providers in Scotland where (EntryProfile.PERMADDCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM) and Engagement.INCOMINGEXCHANGE does not exist and the first Engagement.ENGSTARTDATE for the Engagement is between 2013-07-31 and 2014-08-01.
All EntryProfiles at providers in Wales where (EntryProfile.PERMADDCOUNTRY = XL, XK, XI, XH, XG, XF, IM, GG, JE, AT, AX, BE, BG, CZ, DE, DK, EE, ES, EU, FI, FR, GF, GI, GP, GR, HR, HU, IC, IE, IT, LT, LU, LV, MQ, MT, NL, PL, PT, RE, RO, SE, SI, SK, XA, XC or YT) and the first Engagement.ENGSTARTDATE for the Engagement is after 2014-07-31.
All EntryProfiles at providers in Wales where EntryProfile.UCASSCHEMECODE exists and (Qualification.QUALCAT starts with H, I, J or C or is M0002, M0016 or M0018) and Engagement.ENGSTARTDATE is after 2013-07-31.