Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Filter Options
NameOptionFilter Action
CFU TreatmentInclude CFU in UFIf this option is selected the UF column will count applications with a Dec/Rsp (cap_idrc) value of either UF and CFUF
Exclude CFU from UFIf this option is selected the UF column will count applications with a Dec/Rsp (cap_idrc) value of UF only
Unconditional Inclusion MethodFinalised (CAP) UnconditionalIf this option is selected only the Dec/Rsp (cap_idrc) value is used taking account of the CFU treatment
In Progress + Finalised (CNF + CAP) Unconditional

If this option is selected, if the Dec/Rsp (cap_idrc) value contains 'UF'
and
S1 Second Check Dec (cnf_udf3) value is 'UAU' (Met Conditions) OR CNF Recommended Action (cnf_reca) value is 'U' (Accept unconditional) or 'A' (Auto Accept)

Then the record is included as UF

If the above is not the case, then the record is included based on just the Dec/Rsp (cap_idrc) taking account of the CFU treatment

Include Intercalaters

Yes

If this option is selected any records where the SRS Course (cap_crsc) is UMEDINT will be included in the results
NoIf this option is selected any records where the SRS Course (cap_crsc) is UMEDINT will be excluded from the results
Derived Fields
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 9th August or the response / date 3 (cap_rsd3) is prior to 9th August
CFUFTotal FTE of applicants who have a Dec/Rsp (cap_idrc) value of CFUF  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 9th August or the response / date 3 (cap_rsd3) is prior to 9th August
CFUF

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 9th August or the response / date 3 (cap_rsd3) is prior to 9th August
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 9th August or the response / date 3 (cap_rsd3) is prior to 9th August
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 9th August or the response / date 3 (cap_rsd3) is prior to 9th August
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