I am struggling with implementing two ‘flag’ columns to show whether an applicant has been through a process called ‘Clearing’ or not, and whether that applicant had a prior standard application to University – and then went through Clearing. These two flags are called ‘In Clearing?’ and ‘Prior standard application?’