insert into InsurancePlan (
PlanInternalNo, PlanNo, PlanName, PlanType, WithProfit, NonMedicalGeneral, NonMedicalSpecial, 
NearBirthday, MinimumTerm, MaximumTerm, TermRider, PremiumWaiver, CashOption, LoanGeneral, 
LoanHousing, StartDate, GuranteedAddition, BonusType, FinalAdditionalBonusType,
DeductLoanFromReturn, LoyaltyAdditionType, SurrenderTable, InBuiltAccident, 
AccidentDeathBenefit, NormalDeathBenefit, JointLife, ExpiryDate, UseInPresentation, 
ApplicableMale, ApplicableFemale, MinSA,  MaxSa, MinVestingAge, MaxVestingAge, OrderNo, 
MultipleOf, ChildTermRider, Category, IncomeBenefit, FemaleIllness, CongenitalDisability,
CompanyShortName)
Values
(879, 879, 'Smart Pension', 'A', 0, 1, 1,
0, 0, 0, 0, 0, 0, 1,
0, 'Feb 18, 2025', 0, NULL, NULL, 
0, null, 'N', 0, 
0, 1, 0, null, 1,
1, 1, 100000, null, 18, 100, 8790,
null, 0, 'A', 0, 0, 0, 'LIC')

Insert into AnnuityOption Values (879, 141, 'A - Remainder of Life', 0)
Insert into AnnuityOption Values (879, 142, 'B1 - 5 years certain', 0)
Insert into AnnuityOption Values (879, 143, 'B2 - 10 years certain', 0)
Insert into AnnuityOption Values (879, 144, 'B3 - 15 years certain', 0)
Insert into AnnuityOption Values (879, 145, 'B4 - 20 years certain', 0	)
Insert into AnnuityOption Values (879, 146, 'C1 - Increasing Yearly @ 3% p.a.', 0)
Insert into AnnuityOption Values (879, 147, 'G1 - 50% to Joint Holder on death', 0)
Insert into AnnuityOption Values (879, 148, 'G2 - 100% to Joint Holder on death', 0)
Insert into AnnuityOption Values (879, 149, 'F - Return of Purchase Price (RPP)', 1)
Insert into AnnuityOption Values (879, 160, 'J - 100% to Joint Holder with RPP', 1)
Insert into AnnuityOption Values (879, 161, 'E1 - 50% Return of Premium At Age 75', 0)
Insert into AnnuityOption Values (879, 162, 'E2 - 100% Return of Premium At Age 75', 0)
Insert into AnnuityOption Values (879, 163, 'E3 - 50% Return of Premium At Age 80', 0)
Insert into AnnuityOption Values (879, 164, 'E4 - 100% Return of Premium At Age 80', 0)
Insert into AnnuityOption Values (879, 165, 'E5 - 5% Return of Premium At From Age 76 to 95', 0)
Insert into AnnuityOption Values (879, 166, 'C2 - Increasing Yearly @ 6% p.a.', 0)
Insert into AnnuityOption Values (879, 167, 'D - Return of Balance Purchase Price', 0)
Insert into AnnuityOption Values (879, 168, 'H1 - Increasing 3% p.a. with 50% To Joint Holder', 0)
Insert into AnnuityOption Values (879, 169, 'H2 - Increasing 6% p.a. with 50% To Joint Holder', 0)
Insert into AnnuityOption Values (879, 170, 'I1 - Increasing 3% p.a. with 100% To Joint Holder', 0)
Insert into AnnuityOption Values (879, 171, 'I2 - Increasing 6% p.a. with 100% To Joint Holder', 0)

insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8791, 879, 'P')

Insert Into PlanServiceTax (PlanInternalNo, PlanServiceTaxInternalNo, StartDate, EndDate, FromDuration, ToDuration, Tax, FromPremiumPayingTerm, ToPremiumPayingTerm)
Values (879, 8791, 'April 1, 2024', null, 1, 1, 1.8, 1, 100)

insert into commissionrate(PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (879, 8790001, 1, 1, 1, 1,  'P', 2, 0)

Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (879, 'ENG', 'Smart Pension')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (879, 'MAR', 'LekVZ isU’ku')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (879, 'GUJ', '»©ÉÉ÷Ç ~Éàî¶É{É')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (879, 'HIN', 'LekVZ isU’ku')

insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (161, 'ENG', '50% Return of Premium At Age 75')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (161, 'HIN', 'isa’ku/kkjd dh 75 o"kZ vk;q ij 50 çfrkr dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (161, 'MAR', 'isU’ku/kkjdkP;k o; o"kZ 75 yk [kjsnh eqY;kP;k 50% ijrkok')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (161, 'GUJ', 'B©Éù75 ~Éù 50 ÷IÉ ¡ÉÒÊ©É«É©É ~ÉùlÉ')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (162, 'ENG', '100% Return of Premium At Age 75')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (162, 'HIN', 'isa’ku/kkjd dh 75 o"kZ vk;q ij 100 çfrkr dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (162, 'MAR', 'isU’ku/kkjdkP;k o; o"kZ 75 yk [kjsnh eqY;kP;k 100% ijrkok')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (162, 'GUJ', 'B©Éù75 ~Éù 100 ÷IÉ ¡ÉÒÊ©É«É©É ~ÉùlÉ')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (163, 'ENG', '50% Return of Premium At Age 80')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (163, 'HIN', 'isa’ku/kkjd dh 80 o"kZ vk;q ij 50 çfrkr dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (163, 'MAR', 'isU’ku/kkjdkP;k o; o"kZ 80 yk [kjsnh eqY;kP;k 50% ijrkok')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (163, 'GUJ', 'B©Éù80 ~Éù 50 ÷IÉ ¡ÉÒÊ©É«É©É ~ÉùlÉ')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (164, 'ENG', '100% Return of Premium At Age 80')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (164, 'HIN', 'isa’ku/kkjd dh 80 o"kZ vk;q ij 100 çfrkr dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (164, 'MAR', 'isU’ku/kkjdkP;k o; o"kZ 80 yk [kjsnh eqY;kP;k 100% ijrkok')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (164, 'GUJ', 'B©Éù80 ~Éù 100 ÷IÉ ¡ÉÒÊ©É«É©É ~ÉùlÉ')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (165, 'ENG', '5% Return of Premium At From Age 76 to 95')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (165, 'HIN', 'isa’ku/kkjd dh 76 o"kZ ls 95 vk;q rd 5 çfrkr dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (165, 'MAR', 'isU’ku/kkjdkP;k o; o"kZ 76 rs 95 i;Zar njo"khZ [kjsnh eqY;kP;k 5% ijrkok')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (165, 'GUJ', 'B©Éù76 oÉÒ 95 ~Éù 5 ÷IÉ ¡ÉÒÊ©É«É©É ~ÉùlÉ')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (166, 'ENG', 'Increasing Yearly @ 6% p.a.')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (166, 'HIN', 'gj lky 6 çfrkr C;ktnj ls c<r')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (166, 'MAR', 'njo"ksZ 6 VDD;kauh ok<r jgk.kkjh isU’ku')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (166, 'GUJ', 'qù ´ÉºÉâ 6 ÷IÉ oÉÒ ´ÉPÉlÉÒ +ÉY´É{É ~Éà{»É{É')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (167, 'ENG', 'Return of Balance Purchase Price')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (167, 'HIN', 'isa’ku/kkjd dh e`R;q ij cph gqbZ dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (167, 'MAR', 'isU’ku/kkjdkP;k e`R;quarj f’kYyd vlysY;k [kjsnh eqY;kP;k ijrkok')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (167, 'GUJ', 'LÉùÒxÉù{ÉÉ ©ÉÞl"ÉØ ¥ÉÉx ¶ÉàºÉ LÉùÒx ÊH©ÉlÉ{ÉÒ SÉÚH´ÉÉiÉÒ')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (168, 'ENG', 'Increasing 3% p.a. with 50% To Joint Holder')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (168, 'HIN', '3 çfrkr C;ktnj ls c<r ,oa çFke /kkjd dh e`R;q ij f}rh; /kkjd d¨ 50 çfrkr vkthou isUku')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (168, 'MAR', 'njlky 3% ljG O;ktkus ok<r tk.kkjs o fOnrh; /kkjdkyk eqG o"kkZlukP;k 50%')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (168, 'GUJ', '»ÉÉqÒ qùà 3 ÷IÉ oÉÒ ´ÉPÉlÉÒ ~Éà{»É{É «ÉÉàW{ÉÉ ´ÉÒ©ÉÉ qÉùG {ÉÖÅ ©ÉùiÉ ¥ÉÉx »ÉÉoÉÒqÉù {Éà ~Éà{»É{É {ÉÉ 50 ÷IÉ')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (169, 'ENG', 'Increasing 6% p.a. with 50% To Joint Holder')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (169, 'HIN', '6 çfrkr C;ktnj ls c<r ,oa çFke /kkjd dh e`R;q ij f}rh; /kkjd d¨ 50 çfrkr vkthou isUku')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (169, 'MAR', 'njlky 6% ljG O;ktkus ok<r tk.kkjs o fOnrh; /kkjdkyk eqG o"kkZlukP;k 50%')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (169, 'GUJ', '»ÉÉqÒ qùà 6 ÷IÉ oÉÒ ´ÉPÉlÉÒ ~Éà{»É{É «ÉÉàW{ÉÉ ´ÉÒ©ÉÉ qÉùG {ÉÖÅ ©ÉùiÉ ¥ÉÉx »ÉÉoÉÒqÉù {Éà ~Éà{»É{É {ÉÉ 50 ÷IÉ')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (170, 'ENG', 'Increasing 3% p.a. with 100% To Joint Holder')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (170, 'HIN', '3 çfrkr C;ktnj ls c<r ,oa çFke /kkjd dh e`R;q ij f}rh; /kkjd d¨ 100 çfrkr vkthou isUku')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (170, 'MAR', 'njlky 3% ljG O;ktkus ok<r tk.kkjs o fOnrh; /kkjdkyk eqG o"kkZlukP;k 100%')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (170, 'GUJ', '»ÉÉqÒ qùà 3 ÷IÉ oÉÒ ´ÉPÉlÉÒ ~Éà{»É{É «ÉÉàW{ÉÉ ´ÉÒ©ÉÉ qÉùG {ÉÖÅ ©ÉùiÉ ¥ÉÉx »ÉÉoÉÒqÉù {Éà ~Éà{»É{É {ÉÉ 100 ÷IÉ')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (171, 'ENG', 'Increasing 6% p.a. with 100% To Joint Holder')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (171, 'HIN', '6 çfrkr C;ktnj ls c<r ,oa çFke /kkjd dh e`R;q ij f}rh; /kkjd d¨ 100 çfrkr vkthou isUku')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (171, 'MAR', 'njlky 6% ljG O;ktkus ok<r tk.kkjs o fOnrh; /kkjdkyk eqG o"kkZlukP;k 100%')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (171, 'GUJ', '»ÉÉqÒ qùà 6 ÷IÉ oÉÒ ´ÉPÉlÉÒ ~Éà{»É{É «ÉÉàW{ÉÉ ´ÉÒ©ÉÉ qÉùG {ÉÖÅ ©ÉùiÉ ¥ÉÉx »ÉÉoÉÒqÉù {Éà ~Éà{»É{É {ÉÉ 100 ÷IÉ')

update InsurancePlan set HighlightColor = '$0079D5FF' Where PlanInternalNo in (879, 758, 872, 858, 857)
