UPDATE VS4TPOPayPeriod Set TPPPTPPTCode='DP' WHERE TPPPTPPTCode='IP' 
GO
UPDATE VS4TPOPayPeriod Set TPPPTPPTCode='PP' WHERE TPPPTPPTCode='PD' 
GO
UPDATE VS4TSOPayPeriod Set TSPPTPPTCode='DP' WHERE TSPPTPPTCode='IP' 
GO
UPDATE VS4TSOPayPeriod Set TSPPTPPTCode='PP' WHERE TSPPTPPTCode='PD' 
GO