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
(894, 894, 'Jeevan Raksha', 'E', 0, 1, 1,
0, 15, 42, 0, 0, 0, 0,
0, 'Sep 7, 2026', 0, NULL, NULL, 
0, Null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 500000, 2400000, 0, 0, 8940,
100000, 0, 'T', 0, 0, 0, 'LIC')

Insert Into Mode values (8941, 894, 'Y')

Insert Into Mode values (8942, 894, 'H')
Insert Into Mode values (8943, 894, 'P')


insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (894, 89401, 10, 42, 1, 3,  'Y', 10, 0.40)


insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (894, 89402, 10, 42, 4, 99,  'Y', 6, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (894, 89403, 10, 42, 1, 3,  'H', 10, 0.40)


insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (894, 89404, 10, 42, 4, 99,  'H', 6, 0.00)

insert into commissionrate(PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (894, 89405, 1, 1, 1, 1,  'P', 3, 0)

Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (894, 'ENG', 'Jeevan Raksha')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (894, 'MAR', 'thou j{kk')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (894, 'HIN', 'thou j{kk')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (894, 'GUJ', ' Y{ K')

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (894, 89401, 6)

Update InsurancePlan Set HighlightColor = '$00EAEAF8' where PlanInternalno = 894

Insert into Underwritting values (427, 'Invaid Accident Only Benefit Rider SA', 'Maximum Allowed is 3 times of the Basic Sum Assured')
Insert into Underwritting values (428, 'Invaid SA', 'Maximum SA Allowed is 24,00,000')
