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
(887, 887, 'Bima Kavach', 'E', 0, 1, 1,
0, 10, 82, 0, 0, 0, 0,
0, 'Dec 3, 2025', 0, NULL, NULL, 
0, Null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 20000000, null, 0, 0, 8870,
500000, 0, 'T', 0, 0, 0, 'LIC')

Insert Into Mode values (8871, 887, 'Y')
Insert Into Mode values (8872, 887, 'H')
Insert Into Mode values (8873, 887, 'P')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (887, 88701, 5, 82, 1, 1,  'Y', 10, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (887, 88702, 5, 82, 2, 99,  'Y', 6, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (887, 88704, 5, 82, 1, 1,  'H', 10, 0.40)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (887, 88705, 5, 82, 2, 99,  'H', 6, 0.00)
insert into commissionrate(PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (887, 88719, 1, 1, 1, 1,  'P', 3, 0)

Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (887, 'ENG', 'Bima Kavach')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (887, 'MAR', 'chek dop')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (887, 'HIN', 'chek dop')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (887, 'GUJ', 'ҩ GS')


Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo) Values (887, 88701, 6)

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

insert into Underwritting(IndexNo, ShortRemark, LongRemark) values (418, 'Invalid Rider Term', 'Term for Rider should be Minimum of (75 - Age At Entry) or 35 years or base plan term')
insert into Underwritting(IndexNo, ShortRemark, LongRemark) values (419, 'Invalid Rider SA', 'SA for Rider should be between 1,00,000 & 4,00,000')
insert into Underwritting(IndexNo, ShortRemark, LongRemark) values (420, 'Invalid Rider SA', 'Female Critical Illness Rider must be mutiple of 10,000')
insert into Underwritting(IndexNo, ShortRemark, LongRemark) values (421, 'Invalid Rider Age', 'Max Age at entry for Female Critical-3 must be 40 years')
insert into Underwritting(IndexNo, ShortRemark, LongRemark) values (422, 'Invalid Rider Term', 'Term For Female Critical-3 should be minimum of (45 - Age At Entry) or base plan term ')
insert into Underwritting(IndexNo, ShortRemark, LongRemark) values (423, 'Invalid Rider SA', 'SA for Female Critical-3 Rider should be between 1,00,000 & 2,00,000')

insert into Underwritting(IndexNo, ShortRemark, LongRemark) values (424, 'Invalid SA', 'Sum Assured cannot be less than 2,00,00,000');
