KIM Technical Admin. role Deactivation Process

select * from KRIM_ROLE_MBR_T where ROLE_ID='63' and isnull(ACTV_TO_DT) and MBR_TYP_CD=='P'

select * from KRIM_GRP_MBR_T where GRP_ID='10061' and isnull(ACTV_TO_DT)

update KRIM_GRP_MBR_T set ACTV_TO_DT=CURRENT_DATE, LAST_UPDT_DT=CURRENT_DATE 
where MBR_ID=$UUID and MBR_TYP_CD='P';
update KRIM_ROLE_MBR_T set ACTV_TO_DT=CURRENT_DATE, LAST_UPDT_DT=CURRENT_DATE
where MBR_ID=$UUID;