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
(892, 892, 'New Jeevan Dhara-II', 'A', 0, 1, 1,
0, 1, 15, 0, 0, 0, 1,
0, 'Oct 19, 2026', 0, NULL, NULL, 
0, null, 'N', 0, 
0, 1, 0, null, 1,
1, 1, 0, null, 30, 70, 8920,
null, 0, 'A', 0, 0, 0, 'LIC')

Insert into AnnuityOption Values (892, 141, 'Remainder of Life', 0)
Insert into AnnuityOption Values (892, 149, 'Return of Purchase Price (RPP)', 1)
Insert into AnnuityOption Values (892, 160, '100% to Joint Holder with RPP', 1)
Insert into AnnuityOption Values (892, 161, '50% Return of Premium At Age 75', 0)
Insert into AnnuityOption Values (892, 162, '100% Return of Premium At Age 75', 0)
Insert into AnnuityOption Values (892, 163, '50% Return of Premium At Age 80', 0)
Insert into AnnuityOption Values (892, 164, '100% Return of Premium At Age 80', 0)
Insert into AnnuityOption Values (892, 165, '5% Return of Premium At From Age 76 to 95', 0)
Insert into AnnuityOption Values (892, 148, '100% to Joint Holder on death)', 0)

insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8921, 892, 'Y')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8922, 892, 'H')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8923, 892, 'Q')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8924, 892, 'E')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8925, 892, 'S')
insert into Mode (ModeInternalNo, PlanInternalNo, Mode) Values (8926, 892, 'P')

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89201, 5, 15, 1, 1,  'Y', 7.5, 0.0)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89202, 5, 15, 2, 99,  'Y', 2, 0.0)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89203, 5, 15, 1, 1,  'H', 7.5, 0.0)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89204, 5, 15, 2, 99,  'H', 2, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89205, 5, 15, 1, 1,  'Q', 7.5, 0.0)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89206, 5, 15, 2, 99,  'Q', 2, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89207, 5, 15, 1, 1,  'E', 7.5, 0.0)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89208, 5, 15, 2, 99,  'E', 2, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89209, 5, 15, 1, 1,  'S', 7.5, 0.0)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89210, 5, 15, 2, 99,  'S', 2, 0.00)

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

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89212, 2, 4, 1, 99,  'Y', 2, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89213, 2, 4, 1, 99,  'H', 2, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89214, 2, 4, 1, 99,  'Q', 2, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89215, 2, 4, 1, 99,  'E', 2, 0.00)

insert into commissionrate(
PlanInternalNo, CommissionRateInternalNo, FromTerm, ToTerm, FromPolicyYear,
ToPolicyYear, Mode, Percentage, BonusRate)
Values (892, 89216, 2, 4, 1, 99,  'S', 2, 0.00)

Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (892, 'ENG', 'New Jeevan Dhara - II')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (892, 'MAR', 'U;w thou /kkjk - 2')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (892, 'GUJ', 'Y{ Y{ y - 2')
Insert Into PlanDescription (PlanInternalNo, Language, PlanName) Values (892, 'HIN', 'U;w thou /kkjk - 2')

Delete From Underwritting Where IndexNo in (394, 395, 396, 397, 398, 399)

Insert into Underwritting values (394, 'Invalid Joint Holder Age', 'Joint Holder Age must be >= 20')
Insert into Underwritting values (395, 'Invalid Holder Age', 'Max Age At Entry allowed is 80 minus Deferment Period')
Insert into Underwritting values (396, 'Invalid Holder Age', 'Max Age At Entry allowed is 70 minus Deferment Period')
Insert into Underwritting values (397, 'Invalid Holder Age', 'Max Age At Entry allowed is 65 minus Deferment Period')
Insert into Underwritting values (398, 'Invalid Min Vesting Age', 'Minimum Vesting Age allowed is 35 Years')
Insert into Underwritting values (399, 'Invalid Min Vesting Age', 'Minimum Vesting Age allowed is 31 Years')

Insert into Underwritting values (429, 'Invalid Min Vesting Age', 'Minimum Vesting Age allowed is 30 Years')
Insert into Underwritting values (430, 'Invalid Min Vesting Age', 'Max Vesting Age allowed is 70 Years')
Insert into Underwritting values (431, 'Invalid Min Vesting Age', 'Max Vesting Age allowed is 65 Years')

Insert into Underwritting values (432, 'Invalid Premium', 'Invalid Minimum Premium')

Update InsurancePlan Set HighlightColor = '$0079D5FF' where PlanInternalNo = 892
update InsurancePlan Set ExpiryDate = 'Sep, 27, 2026' where PlanInternalno = 955
