SET @prevDate = 20220731;
--
-- Master table values for ClientMapMaster
--
DELETE FROM ClientMapMaster WHERE map_type_id IN (11, 12, 13, 14, 20);
INSERT INTO ClientMapMaster(map_type_id, name, ui_name, system_defined) VALUES
(11, 'College Graduate', 'College Graduate', 1),
(11, 'Secondary Education', 'Secondary Education', 1),
(11, 'Primary Education', 'Primary Education', 1),
(11, 'None', 'None', 1),
(12, 'Photo', 'Photo', 1),
(12, 'KYC Document', 'KYC Document', 1),
(12, 'Cheque', 'Cheque', 1),
(12, 'ECS Mandate', 'ECS Mandate', 1),
(12, 'Others', 'Others', 1),
(13, 'Bank', 'Bank', 1),
(13, 'Another MFI', 'Another MFI', 1),
(13, 'Informal sources', 'Informal sources', 1),
(14, 'Bad Credit Rating', 'Bad Credit Rating', 1),
(14, 'Delinquent Credit History', 'Delinquent Credit History', 1),
(14, 'Background Credit Unsucessful', 'Background Credit Unsucessful', 1),
(20, 'Customer Profile', 'Customer Profile', 1),
(20, 'Purpose', 'Purpose', 1),
(20, 'Stability/Ownership', 'Stability/Ownership', 1),
(20, 'Fleet', 'Fleet', 1),
(20, 'CIBIL', 'CIBIL', 1),
(20, 'Credit History', 'Credit History', 1),
(20, 'Field Investigation', 'Field Investigation', 1),
(20, 'Banking', 'Banking', 1),
(20, 'Proposal', 'Proposal', 1),
(20, 'Request for approval', 'Request for approval', 1);

--
-- Master table values for LoanPurposeCategoryMaster
--
DELETE FROM LoanPurposeCategoryMaster;
INSERT INTO LoanPurposeCategoryMaster(id, name) VALUES
(1, 'Agriculture'),
(2, 'Micro and Small Enterprises'),
(3, 'Educational Loans'),
(4, 'Housing Loans'),
(5, 'Others');

--
-- Master table values for LoanPurposeMaster
--
DELETE FROM LoanPurposeMaster;
INSERT INTO LoanPurposeMaster(id, name, category_id, type_id) VALUES
(1, 'Agriculture', 1, 1),
(2, 'Dairy', 1, 1),
(3, 'Fishery', 1, 1),
(4, 'Piggery', 1, 1),
(5, 'Poultry', 1, 1),
(6, 'Bee-keeping', 1, 1),
(7, 'Manufacture/Production', 2, 1),
(8, 'Processing or Preservation of Goods', 2, 1),
(9, 'Providing Service', 2, 1),
(10, 'Educational Purposes', 3, 2),
(11, 'Purchase/Construction/Repair of House', 4, 2),
(12, 'Emergency Purposes', 5, 2);

--
-- Master table values for EnrollmentTypeMaster
--
DELETE FROM EnrollmentTypeMaster;
INSERT INTO EnrollmentTypeMaster(id, name) VALUES
(1, 'MFI');

--
-- Master table values for EnrollSettingMaster
--
DELETE FROM EnrollSettingMaster;
INSERT INTO `EnrollSettingMaster` VALUES 
(1,'Legal Name','COMMON',1),
(2,'Alias','COMMON',1),
(3,'Date of Birth','COMMON',1),
(4,'Enrollment Date','COMMON',1),
(5,'Religious Group','COMMON',1),
(6,'Caste','COMMON',1),
(7,'Alternate Address','COMMON',1),
(8,'Property Type','COMMON',1),
(9,'Marital Status','COMMON',1),
(10,'Land Holding','COMMON',1),
(11,'Notation','COMMON',1),
(12,'Gender','COMMON',1),
(13,'Occupation','COMMON',1),
(14,'Telephone','COMMON',1),
(15,'Education Level','COMMON',1),
(16,'Address','COMMON',1),
(17,'Village/Town','COMMON',1),
(18,'Annual Income','COMMON',1),
(19,'Guarantor Address','COMMON',1),
(20,'Is Alive','COMMON',0),
(21,'Group','COMMON',1),
(22,'Bank Account Name','COMMON',1),
(23,'Bank Name','COMMON',1),
(24,'Bank Branch Name','COMMON',1),
(25,'Bank Account #','COMMON',1),
(26,'Account Type','COMMON',1),
(27,'Bank Code-1','COMMON',1),
(28,'Bank Code-2','COMMON',1),
(29,'Father Name','COMMON',1),
(30,'Pincode','COMMON',1),
(31,'Mother\'s Name','COMMON',1),
(32,'Father\'s Name','COMMON',1),
(33,'Loan Amount Requested','COMMON',1),
(34,'Applied Product','COMMON',1),
(35,'Applied Loan Purpose','COMMON',1),
(36,'Applied Disburse Mode','COMMON',1),
(37,'Is OTP Validation Mandatory?','COMMON',0),
(38,'Is Credit Bureau Mandatory?','COMMON',0),
(39,'Is Survey Mandatory?','COMMON',0),
(40,'Occupation Type','COMMON',1),
(41,'No Of Income Periods','COMMON',1),
(42,'Income Frequency','COMMON',1),
(43,'Income Per Period','COMMON',1),
(44,'Occupation Sector','COMMON',1);

SELECT @enrolmentSettingCategoryId := id FROM BusinessLogicTypeMaster WHERE name = 'Enrollment Setting Category';
SELECT @customerInfoCategoryId := id FROM BusinessLogicMaster WHERE name = 'Customer Information' AND type_id=@enrolmentSettingCategoryId;
SELECT @guarantorInfoCategoryId := id FROM BusinessLogicMaster WHERE name = 'Guarantor Information' AND type_id=@enrolmentSettingCategoryId;
SELECT @householdMemberInfoCategoryId := id FROM BusinessLogicMaster WHERE name = 'Household Members' AND type_id=@enrolmentSettingCategoryId;
SELECT @spouseInfoCategoryId := id FROM BusinessLogicMaster WHERE name = 'Spouse Information' AND type_id=@enrolmentSettingCategoryId;
SELECT @nomineeInfoCategoryId := id FROM BusinessLogicMaster WHERE name = 'Nominee Information' AND type_id=@enrolmentSettingCategoryId;

DELETE FROM EnrollSettingColumnMap;
INSERT INTO `EnrollSettingColumnMap` VALUES 
(1,@customerInfoCategoryId,1,'Entity','legal_name','Legal Name',0),
(2,@customerInfoCategoryId,2,'Entity','alias','Alias',0),
(3,@customerInfoCategoryId,3,'Entity','date_of_birth','Date of Birth',0),
(4,@customerInfoCategoryId,4,'Customer','enrollment_date','Enrollment Date',0),
(5,@customerInfoCategoryId,5,'CustomerInfo','religious_group_id','Religious Group',0),
(6,@customerInfoCategoryId,6,'CustomerInfo','caste_id','Caste',0),
(7,@customerInfoCategoryId,7,'CustomerInfo','alternate_address','Alternate Address',0),
(8,@customerInfoCategoryId,8,'CustomerInfo','property_type_id','Property Type',0),
(9,@customerInfoCategoryId,9,'IndividualInfo','marital_status_id','Marital Status',0),
(10,@customerInfoCategoryId,10,'CustomerInfo','land_holding','Land Holding',0),
(11,@customerInfoCategoryId,11,'CustomerInfo','notation','Notation',0),
(12,@customerInfoCategoryId,12,'IndividualInfo','gender','Gender',0),
(13,@customerInfoCategoryId,13,'EntityIncome','occupation_id','Occupation',0),
(14,@customerInfoCategoryId,14,'IndividualInfo','telephone','Telephone',0),
(15,@customerInfoCategoryId,15,'IndividualInfo','education_level_id','Education Level',0),
(16,@customerInfoCategoryId,16,'HouseholdInfo','address','Address',0),
(17,@customerInfoCategoryId,17,'HouseholdInfo','area_id','Village/Town',0),
(18,@customerInfoCategoryId,21,'CustomerGroup','group_id','Group',0),
(19,@customerInfoCategoryId,22,'EntityBankAccount','entity_id','Bank Account Name',0),
(20,@customerInfoCategoryId,23,'EntityBankAccount','countryBankId','Bank Name',0),
(21,@customerInfoCategoryId,24,'EntityBankAccount','bankBranchName','Bank Branch Name',0),
(22,@customerInfoCategoryId,25,'EntityBankAccount','account_no','Bank Account #',0),
(23,@customerInfoCategoryId,26,'EntityBankAccount','account_type','Account Type',0),
(24,@customerInfoCategoryId,27,'EntityBankAccount','bankCode1','Bank Code-1',0),
(25,@customerInfoCategoryId,28,'EntityBankAccount','bankCode2','Bank Code-2',0),
(26,@customerInfoCategoryId,30,'HouseholdInfo','pincode','Pincode',0),
(27,@customerInfoCategoryId,31,'Entity','motherName','Mother\'s Name',0),
(28,@customerInfoCategoryId,32,'Entity','fatherName','Father\'s Name',0),
(29,@customerInfoCategoryId,33,'Customer','loan_amount_requested','Loan Amount Requested',0),
(30,@customerInfoCategoryId,34,'CustomerAppliedLoanDetails','product_id','Applied Product',0),
(31,@customerInfoCategoryId,35,'CustomerAppliedLoanDetails','loan_purpose_id','Applied Loan Purpose',0),
(32,@customerInfoCategoryId,36,'CustomerAppliedLoanDetails','disburse_mode_id','Applied Disburse Mode',0),
(33,@guarantorInfoCategoryId,1,'Entity','legal_name','Legal Name',0),
(34,@guarantorInfoCategoryId,2,'Entity','alias','Alias',0),
(35,@guarantorInfoCategoryId,3,'Entity','date_of_birth','Date of Birth',0),
(36,@guarantorInfoCategoryId,12,'IndividualInfo','gender','Gender',0),
(37,@guarantorInfoCategoryId,13,'EntityIncome','occupation_id','Occupation',0),
(38,@guarantorInfoCategoryId,14,'IndividualInfo','telephone','Telephone',0),
(39,@guarantorInfoCategoryId,15,'IndividualInfo','education_level_id','Education Level',0),
(40,@guarantorInfoCategoryId,19,'CustomerRelation','guarantor_address','Guarantor Address',0),
(41,@guarantorInfoCategoryId,22,'EntityBankAccount','entity_id','Bank Account Name',0),
(42,@guarantorInfoCategoryId,23,'EntityBankAccount','countryBankId','Bank Name',0),
(43,@guarantorInfoCategoryId,24,'EntityBankAccount','bankBranchName','Bank Branch Name',0),
(44,@guarantorInfoCategoryId,25,'EntityBankAccount','account_no','Bank Account #',0),
(45,@guarantorInfoCategoryId,26,'EntityBankAccount','account_type','Account Type',0),
(46,@guarantorInfoCategoryId,27,'EntityBankAccount','bankCode1','Bank Code-1',0),
(47,@guarantorInfoCategoryId,28,'EntityBankAccount','bankCode2','Bank Code-2',0),
(48,@guarantorInfoCategoryId,29,'CustomerRelation','father_name','Father Name',0),
(49,@householdMemberInfoCategoryId,1,'Entity','legal_name','Legal Name',0),
(50,@householdMemberInfoCategoryId,2,'Entity','alias','Alias',0),
(51,@householdMemberInfoCategoryId,3,'Entity','date_of_birth','Date of Birth',0),
(52,@householdMemberInfoCategoryId,13,'EntityIncome','occupation_id','Occupation',0),
(53,@householdMemberInfoCategoryId,14,'IndividualInfo','telephone','Telephone',0),
(54,@householdMemberInfoCategoryId,15,'IndividualInfo','education_level_id','Education Level',0),
(56,@spouseInfoCategoryId,1,'Entity','legal_name','Legal Name',0),
(57,@spouseInfoCategoryId,2,'Entity','alias','Alias',0),
(58,@spouseInfoCategoryId,3,'Entity','date_of_birth','Date of Birth',0),
(59,@spouseInfoCategoryId,13,'EntityIncome','occupation_id','Occupation',0),
(60,@spouseInfoCategoryId,14,'IndividualInfo','telephone','Telephone',0),
(61,@spouseInfoCategoryId,15,'IndividualInfo','education_level_id','Education Level',0),
(62,@spouseInfoCategoryId,20,'IndividualInfo','is_alive','Is Alive',0),
(63,@spouseInfoCategoryId,29,'CustomerRelation','father_name','Father Name',0),
(64,@customerInfoCategoryId,37,'EntityContactOtp','id','Is OTP Validation Mandatory?',1),
(65,@customerInfoCategoryId,39,'CustomerSurvey','survey_id','Is Survey Mandatory?',1),
(66,@customerInfoCategoryId,38,'CreditBureauRequest','id','Is Credit Bureau Mandatory?',1),
(67,@guarantorInfoCategoryId,9,'IndividualInfo','marital_status_id','Marital Status',0),
(68,@householdMemberInfoCategoryId,9,'IndividualInfo','marital_status_id','Marital Status',0),
(69,@spouseInfoCategoryId,9,'IndividualInfo','marital_status_id','Marital Status',0),
(70,@customerInfoCategoryId,40,'EntityIncome','occupation_type_id','Occupation Type',0),
(71,@customerInfoCategoryId,41,'EntityIncome','num_income_periods','No Of Income Periods',0),
(72,@customerInfoCategoryId,42,'EntityIncome','income_frequency_id','Income Frequency',0),
(73,@customerInfoCategoryId,43,'EntityIncome','income_per_period','Income Per Period',0),
(74,@guarantorInfoCategoryId,40,'EntityIncome','occupation_type_id','Occupation Type',0),
(75,@guarantorInfoCategoryId,41,'EntityIncome','num_income_periods','No Of Income Periods',0),
(76,@guarantorInfoCategoryId,42,'EntityIncome','income_frequency_id','Income Frequency',0),
(77,@guarantorInfoCategoryId,43,'EntityIncome','income_per_period','Income Per Period',0),
(78,@householdMemberInfoCategoryId,40,'EntityIncome','occupation_type_id','Occupation Type',0),
(79,@householdMemberInfoCategoryId,41,'EntityIncome','num_income_periods','No Of Income Periods',0),
(80,@householdMemberInfoCategoryId,42,'EntityIncome','income_frequency_id','Income Frequency',0),
(81,@householdMemberInfoCategoryId,43,'EntityIncome','income_per_period','Income Per Period',0),
(82,@spouseInfoCategoryId,40,'EntityIncome','occupation_type_id','Occupation Type',0),
(83,@spouseInfoCategoryId,41,'EntityIncome','num_income_periods','No Of Income Periods',0),
(84,@spouseInfoCategoryId,42,'EntityIncome','income_frequency_id','Income Frequency',0),
(85,@spouseInfoCategoryId,43,'EntityIncome','income_per_period','Income Per Period',0),
(86,@nomineeInfoCategoryId,1,'Entity','legal_name','Legal Name',0),
(87,@nomineeInfoCategoryId,2,'Entity','alias','Alias',0),
(88,@nomineeInfoCategoryId,3,'Entity','date_of_birth','Date of Birth',0),
(89,@nomineeInfoCategoryId,12,'IndividualInfo','gender','Gender',0),
(90,@nomineeInfoCategoryId,13,'EntityIncome','occupation_id','Occupation',0),
(91,@nomineeInfoCategoryId,14,'IndividualInfo','telephone','Telephone',0),
(92,@nomineeInfoCategoryId,15,'IndividualInfo','education_level_id','Education Level',0),
(93,@nomineeInfoCategoryId,19,'CustomerRelation','guarantor_address','Guarantor Address',0),
(94,@nomineeInfoCategoryId,22,'EntityBankAccount','entity_id','Bank Account Name',0),
(95,@nomineeInfoCategoryId,23,'EntityBankAccount','countryBankId','Bank Name',0),
(96,@nomineeInfoCategoryId,24,'EntityBankAccount','bankBranchName','Bank Branch Name',0),
(97,@nomineeInfoCategoryId,25,'EntityBankAccount','account_no','Bank Account #',0),
(98,@nomineeInfoCategoryId,26,'EntityBankAccount','account_type','Account Type',0),
(99,@nomineeInfoCategoryId,27,'EntityBankAccount','bankCode1','Bank Code-1',0),
(100,@nomineeInfoCategoryId,28,'EntityBankAccount','bankCode2','Bank Code-2',0),
(101,@nomineeInfoCategoryId,29,'CustomerRelation','father_name','Father Name',0),
(102,@nomineeInfoCategoryId,9,'IndividualInfo','marital_status_id','Marital Status',0),
(103,@nomineeInfoCategoryId,40,'EntityIncome','occupation_type_id','Occupation Type',0),
(104,@nomineeInfoCategoryId,41,'EntityIncome','num_income_periods','No Of Income Periods',0),
(105,@nomineeInfoCategoryId,42,'EntityIncome','income_frequency_id','Income Frequency',0),
(106,@nomineeInfoCategoryId,43,'EntityIncome','income_per_period','Income Per Period',0),
(107,@nomineeInfoCategoryId,44,'IndividualInfo','occupation_sector_id','Occupation Sector',0),
(108,@spouseInfoCategoryId,44,'IndividualInfo','occupation_sector_id','Occupation Sector',0),
(109,@householdMemberInfoCategoryId,44,'IndividualInfo','occupation_sector_id','Occupation Sector',0),
(110,@guarantorInfoCategoryId,44,'IndividualInfo','occupation_sector_id','Occupation Sector',0),
(111,@customerInfoCategoryId,44,'IndividualInfo','occupation_sector_id','Occupation Sector',0);

DELETE FROM EnrollmentSetting;
INSERT INTO `EnrollmentSetting` VALUES 
(1,2,@customerInfoCategoryId,1,1,2,@prevDate,NULL),
(2,2,@customerInfoCategoryId,2,0,0,@prevDate,NULL),
(3,2,@customerInfoCategoryId,3,1,2,@prevDate,NULL),
(4,2,@customerInfoCategoryId,4,1,2,@prevDate,NULL),
(5,2,@customerInfoCategoryId,5,0,0,@prevDate,NULL),
(6,2,@customerInfoCategoryId,6,0,0,@prevDate,NULL),
(7,2,@customerInfoCategoryId,7,0,0,@prevDate,NULL),
(8,2,@customerInfoCategoryId,8,0,0,@prevDate,NULL),
(9,2,@customerInfoCategoryId,9,0,0,@prevDate,NULL),
(10,2,@customerInfoCategoryId,10,0,0,@prevDate,NULL),
(11,2,@customerInfoCategoryId,11,0,0,@prevDate,NULL),
(12,2,@customerInfoCategoryId,12,1,2,@prevDate,NULL),
(13,2,@customerInfoCategoryId,13,0,0,@prevDate,NULL),
(14,2,@customerInfoCategoryId,14,0,0,@prevDate,NULL),
(15,2,@customerInfoCategoryId,15,0,0,@prevDate,NULL),
(16,2,@customerInfoCategoryId,16,1,2,@prevDate,NULL),
(17,2,@customerInfoCategoryId,17,1,2,@prevDate,NULL),
(18,2,@customerInfoCategoryId,21,0,0,@prevDate,NULL),
(19,2,@customerInfoCategoryId,22,0,0,@prevDate,NULL),
(20,2,@customerInfoCategoryId,23,0,0,@prevDate,NULL),
(21,2,@customerInfoCategoryId,24,0,0,@prevDate,NULL),
(22,2,@customerInfoCategoryId,25,0,0,@prevDate,NULL),
(23,2,@customerInfoCategoryId,26,0,0,@prevDate,NULL),
(24,2,@customerInfoCategoryId,27,0,0,@prevDate,NULL),
(25,2,@customerInfoCategoryId,28,0,0,@prevDate,NULL),
(26,2,@customerInfoCategoryId,30,0,0,@prevDate,NULL),
(27,2,@customerInfoCategoryId,31,0,0,@prevDate,NULL),
(28,2,@customerInfoCategoryId,32,0,0,@prevDate,NULL),
(29,2,@customerInfoCategoryId,33,0,0,@prevDate,NULL),
(30,2,@customerInfoCategoryId,34,0,0,@prevDate,NULL),
(31,2,@customerInfoCategoryId,35,0,0,@prevDate,NULL),
(32,2,@customerInfoCategoryId,36,0,0,@prevDate,NULL),
(33,2,@customerInfoCategoryId,40,0,0,@prevDate,NULL),
(34,2,@customerInfoCategoryId,41,0,0,@prevDate,NULL),
(35,2,@customerInfoCategoryId,42,0,0,@prevDate,NULL),
(36,2,@customerInfoCategoryId,43,0,0,@prevDate,NULL),
(37,2,@guarantorInfoCategoryId,1,1,2,@prevDate,NULL),
(38,2,@guarantorInfoCategoryId,2,0,0,@prevDate,NULL),
(39,2,@guarantorInfoCategoryId,3,0,0,@prevDate,NULL),
(40,2,@guarantorInfoCategoryId,12,0,0,@prevDate,NULL),
(41,2,@guarantorInfoCategoryId,13,0,0,@prevDate,NULL),
(42,2,@guarantorInfoCategoryId,14,0,0,@prevDate,NULL),
(43,2,@guarantorInfoCategoryId,15,0,0,@prevDate,NULL),
(44,2,@guarantorInfoCategoryId,19,0,0,@prevDate,NULL),
(45,2,@guarantorInfoCategoryId,22,0,0,@prevDate,NULL),
(46,2,@guarantorInfoCategoryId,23,0,0,@prevDate,NULL),
(47,2,@guarantorInfoCategoryId,24,0,0,@prevDate,NULL),
(48,2,@guarantorInfoCategoryId,25,0,0,@prevDate,NULL),
(49,2,@guarantorInfoCategoryId,26,0,0,@prevDate,NULL),
(50,2,@guarantorInfoCategoryId,27,0,0,@prevDate,NULL),
(51,2,@guarantorInfoCategoryId,28,0,0,@prevDate,NULL),
(52,2,@guarantorInfoCategoryId,29,0,0,@prevDate,NULL),
(53,2,@guarantorInfoCategoryId,9,0,0,@prevDate,NULL),
(54,2,@guarantorInfoCategoryId,40,0,0,@prevDate,NULL),
(55,2,@guarantorInfoCategoryId,41,0,0,@prevDate,NULL),
(56,2,@guarantorInfoCategoryId,42,0,0,@prevDate,NULL),
(57,2,@guarantorInfoCategoryId,43,0,0,@prevDate,NULL),
(58,2,@householdMemberInfoCategoryId,1,1,2,@prevDate,NULL),
(59,2,@householdMemberInfoCategoryId,2,0,0,@prevDate,NULL),
(60,2,@householdMemberInfoCategoryId,3,1,2,@prevDate,NULL),
(61,2,@householdMemberInfoCategoryId,13,0,0,@prevDate,NULL),
(62,2,@householdMemberInfoCategoryId,14,0,0,@prevDate,NULL),
(63,2,@householdMemberInfoCategoryId,15,0,0,@prevDate,NULL),
(64,2,@householdMemberInfoCategoryId,9,0,0,@prevDate,NULL),
(65,2,@householdMemberInfoCategoryId,40,0,0,@prevDate,NULL),
(66,2,@householdMemberInfoCategoryId,41,0,0,@prevDate,NULL),
(67,2,@householdMemberInfoCategoryId,42,0,0,@prevDate,NULL),
(68,2,@householdMemberInfoCategoryId,43,0,0,@prevDate,NULL),
(69,2,@spouseInfoCategoryId,1,1,2,@prevDate,NULL),
(70,2,@spouseInfoCategoryId,2,0,0,@prevDate,NULL),
(71,2,@spouseInfoCategoryId,3,0,0,@prevDate,NULL),
(72,2,@spouseInfoCategoryId,13,0,0,@prevDate,NULL),
(73,2,@spouseInfoCategoryId,14,0,0,@prevDate,NULL),
(74,2,@spouseInfoCategoryId,15,0,0,@prevDate,NULL),
(75,2,@spouseInfoCategoryId,20,0,0,@prevDate,NULL),
(76,2,@spouseInfoCategoryId,29,0,0,@prevDate,NULL),
(77,2,@spouseInfoCategoryId,9,0,0,@prevDate,NULL),
(78,2,@spouseInfoCategoryId,40,0,0,@prevDate,NULL),
(79,2,@spouseInfoCategoryId,41,0,0,@prevDate,NULL),
(80,2,@spouseInfoCategoryId,42,0,0,@prevDate,NULL),
(81,2,@spouseInfoCategoryId,43,0,0,@prevDate,NULL),
(82,2,@nomineeInfoCategoryId,1,0,0,@prevDate,NULL),
(83,2,@nomineeInfoCategoryId,2,0,0,@prevDate,NULL),
(84,2,@nomineeInfoCategoryId,3,0,0,@prevDate,NULL),
(85,2,@nomineeInfoCategoryId,12,0,0,@prevDate,NULL),
(86,2,@nomineeInfoCategoryId,13,0,0,@prevDate,NULL),
(87,2,@nomineeInfoCategoryId,14,0,0,@prevDate,NULL),
(88,2,@nomineeInfoCategoryId,15,0,0,@prevDate,NULL),
(89,2,@nomineeInfoCategoryId,19,0,0,@prevDate,NULL),
(90,2,@nomineeInfoCategoryId,22,0,0,@prevDate,NULL),
(91,2,@nomineeInfoCategoryId,23,0,0,@prevDate,NULL),
(92,2,@nomineeInfoCategoryId,24,0,0,@prevDate,NULL),
(93,2,@nomineeInfoCategoryId,25,0,0,@prevDate,NULL),
(94,2,@nomineeInfoCategoryId,26,0,0,@prevDate,NULL),
(95,2,@nomineeInfoCategoryId,27,0,0,@prevDate,NULL),
(96,2,@nomineeInfoCategoryId,28,0,0,@prevDate,NULL),
(97,2,@nomineeInfoCategoryId,29,0,0,@prevDate,NULL),
(98,2,@nomineeInfoCategoryId,9,0,0,@prevDate,NULL),
(99,2,@nomineeInfoCategoryId,40,0,0,@prevDate,NULL),
(100,2,@nomineeInfoCategoryId,41,0,0,@prevDate,NULL),
(101,2,@nomineeInfoCategoryId,42,0,0,@prevDate,NULL),
(102,2,@nomineeInfoCategoryId,43,0,0,@prevDate,NULL),
(103,3,@customerInfoCategoryId,1,1,2,@prevDate,NULL),
(104,3,@customerInfoCategoryId,2,0,0,@prevDate,NULL),
(105,3,@customerInfoCategoryId,3,1,2,@prevDate,NULL),
(106,3,@customerInfoCategoryId,4,1,2,@prevDate,NULL),
(107,3,@customerInfoCategoryId,5,0,0,@prevDate,NULL),
(108,3,@customerInfoCategoryId,6,0,0,@prevDate,NULL),
(109,3,@customerInfoCategoryId,7,0,0,@prevDate,NULL),
(110,3,@customerInfoCategoryId,8,0,0,@prevDate,NULL),
(111,3,@customerInfoCategoryId,9,0,0,@prevDate,NULL),
(112,3,@customerInfoCategoryId,10,0,0,@prevDate,NULL),
(113,3,@customerInfoCategoryId,11,0,0,@prevDate,NULL),
(114,3,@customerInfoCategoryId,12,1,2,@prevDate,NULL),
(115,3,@customerInfoCategoryId,13,0,0,@prevDate,NULL),
(116,3,@customerInfoCategoryId,14,0,0,@prevDate,NULL),
(117,3,@customerInfoCategoryId,15,0,0,@prevDate,NULL),
(118,3,@customerInfoCategoryId,16,1,2,@prevDate,NULL),
(119,3,@customerInfoCategoryId,17,1,2,@prevDate,NULL),
(120,3,@customerInfoCategoryId,21,0,0,@prevDate,NULL),
(121,3,@customerInfoCategoryId,22,0,0,@prevDate,NULL),
(122,3,@customerInfoCategoryId,23,0,0,@prevDate,NULL),
(123,3,@customerInfoCategoryId,24,0,0,@prevDate,NULL),
(124,3,@customerInfoCategoryId,25,0,0,@prevDate,NULL),
(125,3,@customerInfoCategoryId,26,0,0,@prevDate,NULL),
(126,3,@customerInfoCategoryId,27,0,0,@prevDate,NULL),
(127,3,@customerInfoCategoryId,28,0,0,@prevDate,NULL),
(128,3,@customerInfoCategoryId,30,0,0,@prevDate,NULL),
(129,3,@customerInfoCategoryId,31,0,0,@prevDate,NULL),
(130,3,@customerInfoCategoryId,32,0,0,@prevDate,NULL),
(131,3,@customerInfoCategoryId,33,0,0,@prevDate,NULL),
(132,3,@customerInfoCategoryId,34,0,0,@prevDate,NULL),
(133,3,@customerInfoCategoryId,35,0,0,@prevDate,NULL),
(134,3,@customerInfoCategoryId,36,0,0,@prevDate,NULL),
(135,3,@customerInfoCategoryId,40,0,0,@prevDate,NULL),
(136,3,@customerInfoCategoryId,41,0,0,@prevDate,NULL),
(137,3,@customerInfoCategoryId,42,0,0,@prevDate,NULL),
(138,3,@customerInfoCategoryId,43,0,0,@prevDate,NULL),
(139,3,@guarantorInfoCategoryId,1,1,2,@prevDate,NULL),
(140,3,@guarantorInfoCategoryId,2,0,0,@prevDate,NULL),
(141,3,@guarantorInfoCategoryId,3,0,0,@prevDate,NULL),
(142,3,@guarantorInfoCategoryId,12,0,0,@prevDate,NULL),
(143,3,@guarantorInfoCategoryId,13,0,0,@prevDate,NULL),
(144,3,@guarantorInfoCategoryId,14,0,0,@prevDate,NULL),
(145,3,@guarantorInfoCategoryId,15,0,0,@prevDate,NULL),
(146,3,@guarantorInfoCategoryId,19,0,0,@prevDate,NULL),
(147,3,@guarantorInfoCategoryId,22,0,0,@prevDate,NULL),
(148,3,@guarantorInfoCategoryId,23,0,0,@prevDate,NULL),
(149,3,@guarantorInfoCategoryId,24,0,0,@prevDate,NULL),
(150,3,@guarantorInfoCategoryId,25,0,0,@prevDate,NULL),
(151,3,@guarantorInfoCategoryId,26,0,0,@prevDate,NULL),
(152,3,@guarantorInfoCategoryId,27,0,0,@prevDate,NULL),
(153,3,@guarantorInfoCategoryId,28,0,0,@prevDate,NULL),
(154,3,@guarantorInfoCategoryId,29,0,0,@prevDate,NULL),
(155,3,@guarantorInfoCategoryId,9,0,0,@prevDate,NULL),
(156,3,@guarantorInfoCategoryId,40,0,0,@prevDate,NULL),
(157,3,@guarantorInfoCategoryId,41,0,0,@prevDate,NULL),
(158,3,@guarantorInfoCategoryId,42,0,0,@prevDate,NULL),
(159,3,@guarantorInfoCategoryId,43,0,0,@prevDate,NULL),
(160,3,@householdMemberInfoCategoryId,1,1,2,@prevDate,NULL),
(161,3,@householdMemberInfoCategoryId,2,0,0,@prevDate,NULL),
(162,3,@householdMemberInfoCategoryId,3,1,2,@prevDate,NULL),
(163,3,@householdMemberInfoCategoryId,13,0,0,@prevDate,NULL),
(164,3,@householdMemberInfoCategoryId,14,0,0,@prevDate,NULL),
(165,3,@householdMemberInfoCategoryId,15,0,0,@prevDate,NULL),
(166,3,@householdMemberInfoCategoryId,9,0,0,@prevDate,NULL),
(167,3,@householdMemberInfoCategoryId,40,0,0,@prevDate,NULL),
(168,3,@householdMemberInfoCategoryId,41,0,0,@prevDate,NULL),
(169,3,@householdMemberInfoCategoryId,42,0,0,@prevDate,NULL),
(170,3,@householdMemberInfoCategoryId,43,0,0,@prevDate,NULL),
(171,3,@spouseInfoCategoryId,1,1,2,@prevDate,NULL),
(172,3,@spouseInfoCategoryId,2,0,0,@prevDate,NULL),
(173,3,@spouseInfoCategoryId,3,0,0,@prevDate,NULL),
(174,3,@spouseInfoCategoryId,13,0,0,@prevDate,NULL),
(175,3,@spouseInfoCategoryId,14,0,0,@prevDate,NULL),
(176,3,@spouseInfoCategoryId,15,0,0,@prevDate,NULL),
(177,3,@spouseInfoCategoryId,20,0,0,@prevDate,NULL),
(178,3,@spouseInfoCategoryId,29,0,0,@prevDate,NULL),
(179,3,@spouseInfoCategoryId,9,0,0,@prevDate,NULL),
(180,3,@spouseInfoCategoryId,40,0,0,@prevDate,NULL),
(181,3,@spouseInfoCategoryId,41,0,0,@prevDate,NULL),
(182,3,@spouseInfoCategoryId,42,0,0,@prevDate,NULL),
(183,3,@spouseInfoCategoryId,43,0,0,@prevDate,NULL),
(184,3,@nomineeInfoCategoryId,1,0,0,@prevDate,NULL),
(185,3,@nomineeInfoCategoryId,2,0,0,@prevDate,NULL),
(186,3,@nomineeInfoCategoryId,3,0,0,@prevDate,NULL),
(187,3,@nomineeInfoCategoryId,12,0,0,@prevDate,NULL),
(188,3,@nomineeInfoCategoryId,13,0,0,@prevDate,NULL),
(189,3,@nomineeInfoCategoryId,14,0,0,@prevDate,NULL),
(190,3,@nomineeInfoCategoryId,15,0,0,@prevDate,NULL),
(191,3,@nomineeInfoCategoryId,19,0,0,@prevDate,NULL),
(192,3,@nomineeInfoCategoryId,22,0,0,@prevDate,NULL),
(193,3,@nomineeInfoCategoryId,23,0,0,@prevDate,NULL),
(194,3,@nomineeInfoCategoryId,24,0,0,@prevDate,NULL),
(195,3,@nomineeInfoCategoryId,25,0,0,@prevDate,NULL),
(196,3,@nomineeInfoCategoryId,26,0,0,@prevDate,NULL),
(197,3,@nomineeInfoCategoryId,27,0,0,@prevDate,NULL),
(198,3,@nomineeInfoCategoryId,28,0,0,@prevDate,NULL),
(199,3,@nomineeInfoCategoryId,29,0,0,@prevDate,NULL),
(200,3,@nomineeInfoCategoryId,9,0,0,@prevDate,NULL),
(201,3,@nomineeInfoCategoryId,40,0,0,@prevDate,NULL),
(202,3,@nomineeInfoCategoryId,41,0,0,@prevDate,NULL),
(203,3,@nomineeInfoCategoryId,42,0,0,@prevDate,NULL),
(204,3,@nomineeInfoCategoryId,43,0,0,@prevDate,NULL);
