CASE
                   WHEN pm.plevel = 'plc' and MTYPE = 'added' and
                        MSUBTYPE is NULL then
                    'PLCY_PREM_ADD'
                   WHEN pm.plevel = 'plc' and
                        MTYPE = 'returned' and MSUBTYPE is NULL then
                    'PLCY_PREM_RET'
                   WHEN pm.plevel = 'plc' and
                        MTYPE = 'reversed' and
                        MSUBTYPE = 'added' then
                    'PLCY_PREM_RVRSD_ADD'
                   WHEN pm.plevel = 'plc' and
                        MTYPE = 'reversed' and
                        MSUBTYPE = 'returned' then
                    'PLCY_PREM_RVRSD_RET'
                   WHEN pm.plevel = 'plc' and
                        MTYPE = 'reversed' and
                        MSUBTYPE = 'reversed' then
                    'PLCY_PREM_RVRSD_RVRSD'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NOT NULL and
                        cv.driveroid is NULL and MTYPE = 'added' and
                        MSUBTYPE is NULL then
                    'PLCY_COV_PREM_ADD'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NOT NULL and
                        cv.driveroid is NULL and MTYPE = 'returned' and
                        MSUBTYPE is NULL then
                    'PLCY_COV_PREM_RET'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NOT NULL and
                        cv.driveroid is NULL and MTYPE = 'reversed' and
                        MSUBTYPE = 'added' then
                    'PLCY_COV_PREM_RVRSD_ADD'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NOT NULL and
                        cv.driveroid is NULL and MTYPE = 'reversed' and
                        MSUBTYPE = 'returned' then
                    'PLCY_COV_PREM_RVRSD_RET'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NOT NULL and
                        cv.driveroid is NULL and MTYPE = 'reversed' and
                        MSUBTYPE = 'reversed' then
                    'PLCY_COV_PREM_RVRSD_RVRSD'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NOT NULL and
                        cv.driveroid is NOT NULL and MTYPE = 'added' and
                        MSUBTYPE is NULL then
                    'DRVR_COV_PREM_ADD'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NOT NULL and
                        cv.driveroid is NOT NULL and MTYPE = 'returned' and
                        MSUBTYPE is NULL then
                    'DRVR_COV_PREM_RET'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NOT NULL and
                        cv.driveroid is NOT NULL and MTYPE = 'reversed' and
                        MSUBTYPE = 'added' then
                    'DRVR_COV_PREM_RVRSD_ADD'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NOT NULL and
                        cv.driveroid is NOT NULL and MTYPE = 'reversed' and
                        MSUBTYPE = 'returned' then
                    'DRVR_COV_PREM_RVRSD_RET'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NOT NULL and
                        cv.driveroid is NOT NULL and MTYPE = 'reversed' and
                        MSUBTYPE = 'reversed' then
                    'DRVR_COV_PREM_RVRSD_RVRSD'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NULL and MTYPE = 'added' and
                        MSUBTYPE is NULL then
                    'RSK_COV_PREM_ADD'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NULL and
                        MTYPE = 'returned' and MSUBTYPE is NULL then
                    'RSK_COV_PREM_RET'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NULL and
                        MTYPE = 'reversed' and
                        MSUBTYPE = 'added' then
                    'RSK_COV_PREM_RVRSD_ADD'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NULL and
                        MTYPE = 'reversed' and
                        MSUBTYPE = 'returned' then
                    'RSK_COV_PREM_RVRSD_RET'
                   WHEN pm.plevel <> 'plc' and
                        cv.plcdetail_id is NULL and
                        MTYPE = 'reversed' and
                        MSUBTYPE = 'reversed' then
                    'RSK_COV_PREM_RVRSD_RVRSD'
                   else
                    Null
                 END as CLM_N