alter table bonus drop constraint CK__Bonus__BonusType__60A75C0F 

alter table insurancePlan drop constraint CK__Insurance__Bonus__02C769E9

alter Table Bonus add constraint CK__Bonus__BonusType__60A75C0F check 
([BonusType] = 'JMP' or [BonusType] = 'WLP' 
or [BonusType] = 'JSP' or [BonusType] = 'MBP' or [BonusType] = 'ENP' or [BonusType] = 'ANA' or [BonusType] = 'ANP' 
or [BonusType] = 'SNP' or [BonusType] = 'CBK' or [BonusType] = 'JRP' or [BonusType] = 'NJD' or [BonusType] = 'NJS' 
or [BonusType] = 'JAP' or [BonusType] = 'JTP' or [BonusType] = 'JMT' or [BonusType] = 'CCP' or [BonusType] = 'CFP'
or [BonusType] = 'JBP' or [BonusType] = 'JS1' or [BonusType] = 'JRP' or [BonusType] = 'JDP' or [BonusType] = 'JNP'
or [BonusType] = 'JPP' or [BonusType] = 'JAP' or [BonusType] = 'AMR' or [BonusType] = 'JB1' or [BonusType] = 'CMB'
or [BonusType] = '814' or [BonusType] = '817' or [BonusType] = '820' or [BonusType] = '048' or [BonusType] = '830'
or [BonusType] = '832' or [BonusType] = '833' or [BonusType] = '815' or  [BonusType] = '834' or [BonusType] = '836'
or [BonusType] = '838' or [BonusType] = '812' or [BonusType] = '845' or [BonusType] = '914' or [BonusType] = '917' 
or [BonusType] = '920' or  [BonusType] = '932' or [BonusType] = '933'
or [BonusType] = '915' or [BonusType] = '934' or [BonusType] = '936' or [BonusType] = '945' or [BonusType] = '745'
or [BonusType] = '714' or [BonusType] = '715' or [BonusType] = '717' or [BonusType] = '720' or [BonusType] = '732'
or [BonusType] = '733' or [BonusType] = '734' or [BonusType] = '736' 
)

alter Table InsurancePlan add constraint CK__Insurance__Bonus__02C769E9 check 
([BonusType] = 'JMP' or [BonusType] = 'WLP' 
or [BonusType] = 'JSP' or [BonusType] = 'MBP' or [BonusType] = 'ENP' or [BonusType] = 'ANA' or [BonusType] = 'ANP' 
or [BonusType] = 'SNP' or [BonusType] = 'CBK' or [BonusType] = 'JRP' or [BonusType] = 'NJD' or [BonusType] = 'NJS' 
or [BonusType] = 'JAP' or [BonusType] = 'JTP' or [BonusType] = 'JMT' or [BonusType] = 'CCP' or [BonusType] = 'CFP'
or [BonusType] = 'JBP' or [BonusType] = 'JS1' or [BonusType] = 'JRP' or [BonusType] = 'JDP' or [BonusType] = 'JNP'
or [BonusType] = 'JPP' or [BonusType] = 'JAP' or [BonusType] = 'AMR' or [BonusType] = 'JB1' or [BonusType] = 'CMB'
or [BonusType] = '814' or [BonusType] = '817' or [BonusType] = '820' or [BonusType] = '048' or [BonusType] = '830'
or [BonusType] = '832' or [BonusType] = '833' or [BonusType] = '815' or  [BonusType] = '834' or [BonusType] = '836'
or [BonusType] = '838' or [BonusType] = '812' or [BonusType] = '845' or [BonusType] = '914' or [BonusType] = '917' 
or [BonusType] = '920' or  [BonusType] = '932' or [BonusType] = '933'
or [BonusType] = '915' or [BonusType] = '934' or [BonusType] = '936' or [BonusType] = '945' or [BonusType] = '745'
or [BonusType] = '714' or [BonusType] = '715' or [BonusType] = '717' or [BonusType] = '720' or [BonusType] = '732'
or [BonusType] = '733' or [BonusType] = '734' or [BonusType] = '736' 
)


Update PlanServiceTax Set EndDate = 'Sep 21, 2025' where EndDate is null

Update InsurancePlan Set FinalAdditionalBonusType = 'ANA' where PlanInternalno in (715, 815, 915)

Update InsurancePlan Set BonusType = '714' where PlanInternalno = 714
Update InsurancePlan Set BonusType = '715' where PlanInternalno = 715
Update InsurancePlan Set BonusType = '717' where PlanInternalno = 717
Update InsurancePlan Set BonusType = '720' where PlanInternalno in (720, 721)
Update InsurancePlan Set BonusType = '732' where PlanInternalno = 732
Update InsurancePlan Set BonusType = '733' where PlanInternalno = 733
Update InsurancePlan Set BonusType = '734' where PlanInternalno = 734
Update InsurancePlan Set BonusType = '736' where PlanInternalno = 736
