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
(907, 907, 'Health Shield', 'H', 0, 1, 1,
0, 15, 62, 1, 0, 0, 0,
0, 'Oct 19, 2026', 0, NULL, NULL, 
0, null, 'N', 0, 
1, 1, 0, null, 1,
1, 1, 250000, 1000000, 0, 0, 9070,
50000, 0, 'H', 0, 0, 0, 'LIC')

insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (907, 'Health Shield', 'ENG')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (907, 'gsYFk fkYM', 'MAR')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (907, 'gsYFk fkYM', 'HIN')
insert into PlanDescription (PlanInternalNo, PlanName, Language) Values (907, 'o ʶɱe', 'GUJ')

Insert Into Mode values (90701, 907, 'Y')
Insert Into Mode values (90702, 907, 'H')

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo)
Values (907, 9071, 11)

Insert into InsurancePlanRider (PlanInternalNo, InsurancePlanRiderInternalNo, RiderInternalNo)
Values (907, 9072, 6)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (907, 9071, 0, 99, 1, 1,  'Y', 20, 0.4)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (907, 9072, 0, 99, 2, 6,  'Y', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (907, 9073, 0, 99, 7, 10,  'Y', 6, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (907, 9074, 0, 99, 11, 99,  'Y', 5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (907, 9075, 0, 99, 1, 1,  'H', 20, 0.4)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (907, 9076, 0, 99, 2, 6,  'H', 7.5, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (907, 9077, 0, 99, 7, 10,  'H', 6, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (907, 9078, 0, 99, 11, 99,  'H', 5, 0.00)

Update InsurancePlan Set HighlightColor = '$00FFFFE7' where PlanInternalno in (907)

Insert into Underwritting values (434, 'Invalid Age', 'Child Age must be between 90 Days Completed and 20 years last birthday')
Insert into Underwritting values (435, 'Invalid New Term Rider Term', 'Term for New Term Rider would be Minimum of (75 - Age At Entry) or 15 years.')

Update InsurancePlan Set ExpiryDate = 'Jan 12, 2026' where PlanInternalno in (735, 764)
Update InsurancePlan Set ExpiryDate = 'Mar 31, 2026' where PlanInternalno = 911
