UPDATE [RiskSysSum of Source ClaimType]

SET FinLagCatagory =

(CASE

WHEN ClaimType IN ('OP','SPU') THEN 'OP/SPU'

WHEN ClaimType IN ('SNF','RHB') THEN 'SUBACUTE'

WHEN ClaimType IN ('PCP', 'PH', 'SP', 'SPI', 'SPO') THEN 'Spec'

WHEN ClaimType IN ('IP', 'SBC', 'SC') THEN 'IP'

WHEN ClaimType IN ('EM', 'ER') THEN 'EREM'

WHEN ClaimType IN ('DME', 'HC', 'OTA', 'TSP', '') THEN 'Other'

WHEN ClaimType IN ('Man') THEN 'Manual Check'

ELSE 'UNK-' + ClaimType

END)