--Update all address types expect home and perm to non-system data
UPDATE PS_ADDRESS_TYP_TBL
SET DATA_TYPE_CD = 'S'
WHERE ADDRESS_TYPE NOT IN ('HOME', 'PERM')
UPDATE PS_ADDRESS_TYP_TBL
SET DATA_TYPE_CD = 'S'
WHERE ADDRESS_TYPE NOT IN ('HOME', 'PERM')