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 and CIUF (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) Note: the Tableau report will also include the status of CIUF when the exclude option is selected. There is no option that shows UF only. This should be reviewed after Confirmation and Clearing 2019. | |
| 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 |
on the cap record:
were *Pre-confirmation. | |
| CFUF/CFU | Total FTE of applicants who have a Dec/Rsp (cap_idrc) value of CFUF (or CFU) and |
on the cap record:
not *Pre-confirmation | |
CIUF | Total FTE of applicants who have a Dec/Rsp (cap_idrc) value of CIUF and |
on the cap record:
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 |
on the cap record:
not *Pre-confirmation | |
| Adjustment | Total FTE of applicants who have a UCAS choice (cap_ucho) value of '6' and |
on the cap record:
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).
The chart below shows how the source data fields and Tableau parameters contribute to the front-end values shown in the Tableau workbook:
| Lucidchart | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|