...
Field Name | |
---|---|
UF | Total 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 Adj | Total 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' |
CF | Total 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) |
CI | Total 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) |
UI | Total 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:
|