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 isUku')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (879, 'GUJ', ' ~{')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (879, 'HIN', 'LekVZ isUku')

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', 'isaku/kkjd dh 75 o"kZ vk;q ij 50 frkr dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (161, 'MAR', 'isUku/kkjdkP;k o; o"kZ 75 yk [kjsnh eqY;kP;k 50% ijrkok')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (161, 'GUJ', 'B75 ~ 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', 'isaku/kkjd dh 75 o"kZ vk;q ij 100 frkr dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (162, 'MAR', 'isUku/kkjdkP;k o; o"kZ 75 yk [kjsnh eqY;kP;k 100% ijrkok')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (162, 'GUJ', 'B75 ~ 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', 'isaku/kkjd dh 80 o"kZ vk;q ij 50 frkr dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (163, 'MAR', 'isUku/kkjdkP;k o; o"kZ 80 yk [kjsnh eqY;kP;k 50% ijrkok')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (163, 'GUJ', 'B80 ~ 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', 'isaku/kkjd dh 80 o"kZ vk;q ij 100 frkr dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (164, 'MAR', 'isUku/kkjdkP;k o; o"kZ 80 yk [kjsnh eqY;kP;k 100% ijrkok')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (164, 'GUJ', 'B80 ~ 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', 'isaku/kkjd dh 76 o"kZ ls 95 vk;q rd 5 frkr dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (165, 'MAR', 'isUku/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', 'B76 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 isUku')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (166, 'GUJ', 'q ɺ 6 I o Pl +Y{ ~{{')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (167, 'ENG', 'Return of Balance Purchase Price')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (167, 'HIN', 'isaku/kkjd dh e`R;q ij cph gqbZ dz; ewY; okilh')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (167, 'MAR', 'isUku/kkjdkP;k e`R;quarj fkYyd vlysY;k [kjsnh eqY;kP;k ijrkok')
insert into AnnuityOptionDescription(AnnuityOptionInternalNo, Language, Name) Values (167, 'GUJ', 'Lx{ l" x  Lx Hl{ SHi')
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 Pl ~{{ W{ ҩ qG { i x oq { ~{{ { 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 Pl ~{{ W{ ҩ qG { i x oq { ~{{ { 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 Pl ~{{ W{ ҩ qG { i x oq { ~{{ { 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 Pl ~{{ W{ ҩ qG { i x oq { ~{{ { 100 I')

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