Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

it is not the case that ( decision/date 1, 2 or 3

on the

caps record

cap record:

  • decision is not 'U' (cap_dec1/cap_
decd, cap_
  • dec2/cap_
dcd2,
  • dec3) or decision is U and the corresponding date is 8th August 2019 or later (cap_
dec2
  • decd/cap_dcd2
is 'U' and before
  • /cap_dcd3) or
  • response date 3 is 8th August 2019 or
the response / date 3
  • later (cap_rsd3)
is prior to 8th August 2019
  • .
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

 it is not the case that ( decision/date 1, 2 or 3 

 

on the

caps record

cap record:

  • decision is not 'U' (cap_dec1/
cap_decd
  • cap_dec2/cap_
dcd2, cap_dec2/cap_dcd2 is 'U' and before
  • 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
the response / date 3 
  • later (cap_rsd3)
is prior to 8th August 2019
  • .
Adjustment

Total 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 record:

  • decision is not 'U' (cap_dec1/
cap_decd,
  • cap_dec2/cap_
dcd2,
  • dec3) or decision is U and the corresponding date is 8th August 2019 or later (cap_
dec2
  • decd/cap_dcd2
is 'U' and before
  • /cap_dcd3) or
  • response date 3 is 8th August 2019 or
the response / date 3
  • later (cap_rsd3)
is prior to 8th August 2019
  • .
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