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-conf

Total FTE of applicants who have an offer / response that contains "UF" based on the filter selections detailed above and were *Pre-confirmation.

CFUF/CFU

Total FTE of applicants who have a Dec/Rsp (cap_idrc) value of CFUF (or CFU) and

not *Pre-confirmation

CIUF

Total FTE of applicants who have a Dec/Rsp (cap_idrc) value of CIUF and

not *Pre-confirmation

Clearing

Total 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 

not *Pre-confirmation

Adjustment

Total FTE of applicants who have a UCAS choice (cap_ucho) value of '6' and

not *Pre-confirmation

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
*Pre-confirmation logic

On the cap record:

  • decision is 'U' (cap_dec1/cap_dec2/cap_dec3) and corresponding date is before 8th August 2019 (cap_decd/cap_dcd2/cap_dcd3) or
  • response date 3 is before 8th August 2019 (cap_rsd3).