...
| 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 |
...
- 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 | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|