Skip to end of metadata
  • Created by Former user , last modified by Former user on 28 Jun, 2019
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 13 Next »

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 and CFU (along with any records that are included as a consequence of the selection of the Unconditional Inclusion Method parameter)
Exclude CFU from UFIf this option is selected the UF column will count applications with a Dec/Rsp (cap_idrc) value of UF only (along with any records that are included as a consequence of the selection of the Unconditional Inclusion Method parameter)
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 ends in 'F'
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-conf

Total FTE of applicants who have an offer / response that contains "UF" based on the filter selections detailed above and

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).
CFUF/CFU

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

on the cap record:

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

CIUF

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

on the cap record:

  • decision is not 'U' (cap_dec1/cap_dec2/cap_dec3) or decision is U and the corresponding date is 8th August 2019 or later (cap_decd/cap_dcd2/cap_dcd3) or
  • response date 3 is 8th August 2019 or later (cap_rsd3).
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 

on the cap record:

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

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

on the cap record:

  • decision is not 'U' (cap_dec1/cap_dec2/cap_dec3) or decision is U and the corresponding date is 8th August 2019 or later (cap_decd/cap_dcd2/cap_dcd3) or
  • response date 3 is 8th August 2019 or later (cap_rsd3).
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
  • No labels