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
(880, '880', 'Jan Suraksha', 'E', 0, 1, 1,
1, 12, 20, 0, 0, 0, 1,
0, 'Oct 15, 2025', 0, null, null, 
1, null, 'N', 0, 
0, 1, 0, null, 1,
1, 1, 100000, null, 18, 0, 8800, 
5000, 0, 'E', 0, 0, 0, 'LIC')

insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8801, 880, 'Y')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8802, 880, 'H')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8803, 880, 'Q')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8804, 880, 'E')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8805, 880, 'S')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (880, 88001, 12, 20, 1, 1,  'Y', 10, 0.0)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (880, 88002, 12, 20, 2, 99,  'Y', 6, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (880, 88006, 12, 20, 1, 1,  'H', 10, 0.0)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (880, 88007, 12, 20, 2, 99,  'H', 6, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (880, 88011, 12, 20, 1, 1,  'Q', 10, 0.0)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (880, 88012, 12, 20, 2, 99,  'Q', 6, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (880, 88016, 12, 20, 1, 1,  'E', 10, 0.0)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (880, 88017, 12, 20, 2, 99,  'E', 6, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (880, 88021, 12, 20, 1, 1,  'S', 10, 0.0)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (880, 88022, 12, 20, 2, 99,  'S', 6, 0.00)

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (880, 'Jan Suraksha', 'ENG')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (880, 'tu lqj{kk', 'MAR')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (880, 'tu lqj{kk', 'HIN')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (880, 'W{ K', 'GUJ')

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (880, 88001, 6)
Update InsurancePlan Set HighlightColor = '$00FCFBE0' where PlanInternalNo = 880
