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
(911, '911', 'Nav Jeevan Shree Single Premium', 'E', 0, 1, 1,
1, 5, 20, 1, 0, 0, 1,
0, 'Jul 4, 2025', 85, null, null, 
1, null, 'N', 0, 
0, 1, 0, null, 1,
1, 1, 100000, null, 0, 0, 9110, 
10000, 0, 'E', 0, 0, 0, 'LIC')

Insert Into Mode values (91101, 911, 'P')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (911, 91101, 1, 99, 1, 1, 'P', 2, 0.00)

Insert Into PlanServiceTax (PlanInternalNo, PlanServiceTaxInternalNo, StartDate, EndDate, FromDuration, ToDuration, Tax, FromPremiumPayingTerm, ToPremiumPayingTerm)
Values (911, 9111, 'April 1, 2025', null, 1, 1, 4.5, 1, 100)

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (911, 91101, 11)

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (911, 'Nav Jeevan Shree Single Premium', 'ENG')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (911, 'uo thou Jh ,djdeh', 'MAR')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (911, 'uo thou Jh flaxy fizfe;e', 'HIN')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (911, '{'' Y''{ O - EN OEcc', 'GUJ')

Update InsurancePlan Set HighlightColor = '$00FCFBE0' where PlanInternalno in (911)
