Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field Name
UFTotal FTE of applicants who have an offer / response that contains "UF" based on the filter selections detailed above
UF Pre-confTotal FTE of applicants who have an offer / response that contains "UF" based on the filter selections detailed above and ( decision/date 1, 2 or 3 on the caps record (cap_dec1/cap_decd, cap_dec2/cap_dcd2, cap_dec2/cap_dcd2 is 'U' and before 8th August 2019 or the response / date 3 (cap_rsd3) is prior to 8th August 2019
CFUF/CFUTotal FTE of applicants who have a Dec/Rsp (cap_idrc) value of CFUF (or CFU) and it is not the case that ( decision/date 1, 2 or 3 on the caps record (cap_dec1/cap_decd, cap_dec2/cap_dcd2, cap_dec2/cap_dcd2 is 'U' and before 8th August 2019 or the response / date 3 (cap_rsd3) is prior to 8th August 2019

CIUF

Total FTE of applicants who have a Dec/Rsp (cap_idrc) value of CIUF and it is not the case that ( decision/date 1, 2 or 3 on the caps record (cap_dec1/cap_decd, cap_dec2/cap_dcd2, cap_dec2/cap_dcd2 is 'U' and before 8th August 2019 or the response / date 3 (cap_rsd3) is prior to 8th August 2019
ClearingTotal FTE of applicants who have a UCAS choice (cap_ucho) value of '0' or '7' and they do not have a value in EXTRA round no (cap_ernd) and their App. status (cap_stac) is not 'RAT' and it is not the case that ( decision/date 1, 2 or 3 on the caps record (cap_dec1/cap_decdcap_dec2/cap_dcd2cap_dec2/cap_dcd2 is 'U' and before 8th August 2019 or the response / date 3 (cap_rsd3) is prior to 8th August 2019
AdjustmentTotal FTE of applicants who have a UCAS choice (cap_ucho) value of '6' and it is not the case that ( decision/date 1, 2 or 3 on the caps record (cap_dec1/cap_decd, cap_dec2/cap_dcd2, cap_dec2/cap_dcd2 is 'U' and before 8th August 2019 or the response / date 3 (cap_rsd3) is prior to 8th August 2019
UF Reg for AdjTotal UF value (see above) of applicants who have an App. status (cap_stac) of 'ADR'
UF Adjusted Away (now UD)Total FTE of applicants that have an Adjustment status (cap_adju) value of 'D' and who have an App. status (cap_stac) of 'ADAE'
CFTotal FTE of applicants who have an offer / response that is 'CF' based on the filter selections detailed above. And, if 'Unconditional Inclusion Method' of 'In Progress + Finalised (CNF + CAP) Unconditional' is selected in the Tableau filters there is an additional requirement that CNF Recommended Action (cnf_reca) is not 'U' or 'A' and that the S1 Second Check Dec (cnf_udf3) value is not 'UAU' (Met Conditions)
CITotal FTE of applicants who have an offer / response that contains "CI" based on the filter selections detailed above and the 6th and 7th characters of the DSC code (cap_dscc) are also 'CI' (representing the original offer /response)
UITotal FTE of applicants who have an offer / response that contains "UI" based on the filter selections detailed above