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
(881, '881', 'Bima Lakshmi', 'M', 0, 1, 1,
1, 25, 25, 1, 0, 0, 1,
0, 'Oct 15, 2025', 0, null, null, 
1, null, 'N', 0, 
0, 1, 0, null, 1,
0, 1, 200000, null, 0, 0, 8810, 
10000, 0, 'M', 0, 0, 0, 'LIC')

insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8811, 881, 'Y')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8812, 881, 'H')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8813, 881, 'Q')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8814, 881, 'E')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8815, 881, 'S')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88101, 7, 9, 1, 1,  'Y', 10, 0.4)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88102, 7, 9, 2, 99,  'Y', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88103, 10, 14, 1, 1, 'Y', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88104, 10, 99, 2, 6, 'Y', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88105, 10, 99, 7, 99, 'Y', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88106, 15, 99, 1, 1, 'Y', 20, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88107, 7, 9, 1, 1,  'H', 10, 0.4)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88108, 7, 9, 2, 99,  'H', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88109, 10, 14, 1, 1, 'H', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88110, 10, 99, 2, 6, 'H', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88111, 10, 99, 7, 99, 'H', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88112, 15, 99, 1, 1, 'H', 20, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88113, 7, 9, 1, 1,  'Q', 10, 0.4)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88114, 7, 9, 2, 99,  'Q', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88115, 10, 14, 1, 1, 'Q', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88116, 10, 99, 2, 6, 'Q', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88117, 10, 99, 7, 99, 'Q', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88118, 15, 99, 1, 1, 'Q', 20, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88119, 7, 9, 1, 1,  'E', 10, 0.4)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88120, 7, 9, 2, 99,  'E', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88121, 10, 14, 1, 1, 'E', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88122, 10, 99, 2, 6, 'E', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88123, 10, 99, 7, 99, 'E', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88124, 15, 99, 1, 1, 'E', 20, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88125, 7, 9, 1, 1,  'S', 10, 0.4)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88126, 7, 9, 2, 99,  'S', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88127, 10, 14, 1, 1, 'S', 15, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88128, 10, 99, 2, 6, 'S', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88129, 10, 99, 7, 99, 'S', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (881, 88130, 15, 99, 1, 1, 'S', 20, 0.40)

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (881, 'Bima Lakshmi', 'ENG')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (881, 'chek y{eh', 'MAR')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (881, 'chek y{eh', 'HIN')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (881, 'ҩ K', 'GUJ')

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (881, 88101, 6)
Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (881, 88102, 11)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881001, 25, 24, 1)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881002, 25, 48, 2)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881003, 25, 72, 3)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881004, 25, 96, 4)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881005, 25, 120, 5)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881006, 25, 144, 6)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881007, 25, 168, 7)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881008, 25, 192, 8)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881009, 25, 216, 9)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881010, 25, 240, 10)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881011, 25, 264, 11)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881012, 25, 288, 12)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881013, 25, 84, 1)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881014, 25, 120, 1)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881015, 25, 132, 1)

insert into survivalBenefit (
PlanInternalNo, SurvivalBenefitInternalNo, Term, Month, Installment)
Values (881, 881016, 25, 156, 1)

Update InsurancePlan Set HighlightColor = '$00FDEAEE' where PlanInternalNo = 881
