CAP records Decision and Response Codes:
| Decision: | C = Conditional Offer U = Unconditional Offer R = Reject | Response: | F = Firmly accept offer D = Decline offer I = Insurance |
Filter Options
| Name | Option | Filter Action |
|---|---|---|
| CFU Treatment | Include CFU in UF | If 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 UF | If 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 Method | Finalised (CAP) Unconditional | If 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' 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 |
| No | If this option is selected any records where the SRS Course (cap_crsc) is UMEDINT will be excluded from the results |
Derived Fields
| 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:
- 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).