[select distinct PRSN_UNIV_ID,
        CHKL_CD,
        CHKL_STAT_CD,
        CHKL_DESC,
        FA_ACAD_YR,
        CHKL_CRT_TS,
        CHKL_RESP_PRSN_FULL_NM
   from (select distinct PRSN_UNIV_ID,
                CHKL_CD,
                CHKL_STAT_CD,
                CHKL_DESC,
                FA_ACAD_YR,
                CHKL_CRT_TS,
                CHKL_RESP_PRSN_FULL_NM
           from dss_rds.fa_chkl_gt
          where CHKL_CD like 'F9%'
            and FA_ACAD_YR <> '2019'
            and CHKL_CRT_TS > to_date('01/01/2015', 'mm/dd/yyyy')
            and INST_CD = 'IUBLA'
            and chkl_cd <> 'F0FWVB'
         UNION
         select distinct PRSN_UNIV_ID,
                CHKL_CD,
                CHKL_STAT_CD,
                CHKL_DESC,
                FA_ACAD_YR,
                CHKL_CRT_TS,
                CHKL_RESP_PRSN_FULL_NM
           from dss_rds.fa_chkl_gt
          where CHKL_CD like 'F0%'
            and FA_ACAD_YR <> '2020'
            and CHKL_CRT_TS > to_date('01/01/2015', 'mm/dd/yyyy')
            and INST_CD = 'IUBLA'
            and chkl_cd <> 'F0FWVB'
         UNION
         SELECT DISTINCT PRSN_UNIV_ID,
                CHKL_CD,
                CHKL_STAT_CD,
                CHKL_DESC,
                FA_ACAD_YR,
                CHKL_CRT_TS,
                CHKL_RESP_PRSN_FULL_NM
           from dss_rds.fa_chkl_gt
          where CHKL_CD not like 'F9%'
            and FA_ACAD_YR = '2019'
            and CHKL_CRT_TS > to_date('01/01/2015', 'mm/dd/yyyy')
            and INST_CD = 'IUBLA'
            and chkl_cd <> 'F0FWVB'
            and chkl_cd not like ('FA%')
            and CHKL_CD not like ('FO%')
         UNION
         Select distinct PRSN_UNIV_ID,
                CHKL_CD,
                CHKL_STAT_CD,
                CHKL_DESC,
                FA_ACAD_YR,
                CHKL_CRT_TS,
                CHKL_RESP_PRSN_FULL_NM
           from dss_rds.fa_chkl_gt
          where CHKL_CD not like 'F0%'
            and FA_ACAD_YR = '2020'
            and CHKL_CRT_TS > to_date('01/01/2015', 'mm/dd/yyyy')
            and INST_CD = 'IUBLA'
            and chkl_cd <> 'F0FWVB'
            and chkl_cd not like ('FA%')
            and chkl_cd not like ('FO%'))];