   `benf_identity_card_number` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
   `applied_date` datetime DEFAULT NULL,
   `accepted_date` datetime DEFAULT NULL,
-  `approved_or_rejected_date` datetime DEFAULT NULL
+  `approved_or_rejected_date` datetime DEFAULT NULL,
+  `rejection_reason` int(3) DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-
---
--- Dumping data for table `beneficiary_master`
---
-
-INSERT INTO `beneficiary_master` (`id`, `benf_first_name`, `benf_middle_name`, `benf_last_name`, `benf_mobile_no`, `benf_alternate_mobile_no`, `benf_date_of_birth`, `beneficiary_age`, `benf_sex`, `nationality`, `benf_caste`, `benf_martial_status`, `benf_blood_group`, `benf_local_address_line1`, `benf_local_address_line2`, `benf_local_address_taluk`, `benf_local_address_district`, `benf_local_address_state`, `benf_local_pincode`, `benf_prmt_address_line1`, `benf_prmt_address_line2`, `benf_prmt_address_taluk`, `benf_prmt_address_district`, `benf_prmt_address_state`, `benf_prmt_address_pincode`, `employer_full_name`, `emplr_address_line1`, `emplr_address_line2`, `emplr_address_taluk`, `emplr_address_district`, `emplr_address_state`, `emplr_address_pincode`, `benf_nature_of_work`, `benf_date_of_employment`, `benf_wages_per_day`, `benf_wages_per_month`, `benf_bank_account_number`, `benf_bank_account_type`, `benf_bank_name`, `benf_bank_branch`, `benf_bank_ifsc`, `created_date`, `created_by_user_id`, `updated_date`, `updated_by_user_id`, `benf_application_status`, `benf_application_number`, `benf_acknowledgement_number`, `benf_registration_number`, `benf_registration_old_number`, `admin_comments`, `benf_identity_card_type`, `benf_identity_card_number`, `applied_date`, `accepted_date`, `approved_or_rejected_date`) VALUES
-(1, 'Sravan', 'Vanteru', 'Kumar', 8892233720, NULL, '1991-07-26', 25, 'MALE', 'INDIAN', 'General (Others)', 'SINGLE', 'A+', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'Happiest Minds Techonologies', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'PLUMBING', '2014-02-07', 100, 3000, 2147483647, 'SAVINGS', 'ICIC Bank', 'ECity Bangalore', 'ICIC000020', '2017-03-24 07:17:10', 4, '2017-03-24 07:18:27', 4, 'APPROVED', '0000000001', 'BNG000000001', '0000000001', '', 'yes Approved', 'EPIC', '213131313', NULL, NULL, NULL),
-(2, 'Sravan', 'Vanteru', 'Kumar', 8892233720, NULL, '1991-07-26', 25, 'MALE', 'INDIAN', 'General (Others)', 'SINGLE', 'A+', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'Happiest Minds Techonologies', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'PLUMBING', '2014-02-07', 100, 3000, 2147483647, 'SAVINGS', 'ICIC Bank', 'ECity Bangalore', 'ICIC000020', '2017-03-24 07:22:59', 4, '2017-03-24 07:24:40', 4, 'APPROVED', '0000000002', 'BNG000000003', '0000000002', '', 'Yes Approved', 'EPIC', '213131313', NULL, NULL, NULL),
-(3, 'Sravan', 'Vanteru', 'Kumar', 8892233720, NULL, '1991-07-26', 25, 'MALE', 'INDIAN', 'General (Others)', 'SINGLE', 'A+', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'Happiest Minds Techonologies', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'PLUMBING', '2014-02-07', 100, 3000, 2147483647, 'SAVINGS', 'ICIC Bank', 'ECity Bangalore', 'ICIC000020', '2017-03-24 07:23:45', 4, '2017-03-24 07:24:50', 4, 'REJECTED', '0000000003', 'BNG000000002', '0000000003', '', 'Rejected', 'EPIC', '213131313', NULL, NULL, NULL),
-(4, 'Sravan', 'Vanteru', 'Kumar', 8892233720, NULL, '1991-07-26', 25, 'MALE', 'INDIAN', 'General (Others)', 'SINGLE', 'A+', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'Happiest Minds Techonologies', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'PLUMBING', '2014-02-07', 100, 3000, 2147483647, 'SAVINGS', 'ICIC Bank', 'ECity Bangalore', 'ICIC000020', '2017-03-24 07:28:39', 4, '2017-03-24 07:39:33', 4, 'APPROVED', '0000000004', 'BNG000000003', '0000000004', '', 'rwewr', 'EPIC', '213131313', '2017-03-24 08:28:57', '2017-03-24 13:09:10', '2017-03-24 13:09:33'),
-(5, 'Sravan', 'Vanteru', 'Kumar', 8892233720, NULL, '1991-07-26', 25, 'MALE', 'INDIAN', 'General (Others)', 'SINGLE', 'A+', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'Bangalore', 'Indiranagar S.O (Bangalore)', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560038, 'Happiest Minds Techonologies', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'PLUMBING', '2014-02-07', 100, 3000, 2147483647, 'SAVINGS', 'ICIC Bank', 'ECity Bangalore', 'ICIC000020', '2017-03-24 15:19:32', 4, '2017-03-24 15:19:32', 4, 'DRAFT', NULL, NULL, NULL, '', NULL, 'EPIC', '213131313', NULL, NULL, NULL),
-(6, 'Sravan', 'Vanteru', 'Kumar', 8892233720, NULL, '1991-07-26', 25, 'MALE', 'INDIAN', 'General (Others)', 'SINGLE', 'A+', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'Happiest Minds Techonologies', 'Bangalore', 'Bangalore', 'Bangalore North', 'Bangalore', 'KARNATAKA', 560037, 'PLUMBING', '2014-02-07', 100, 3000, 2147483647, 'SAVINGS', 'ICIC Bank', 'ECity Bangalore', 'ICIC000020', '2017-03-24 19:36:36', 4, '2017-03-24 20:02:54', 4, 'APPROVED', '0000000005', 'BNG000000004', '0000000005', '', 'Approved', 'EPIC', '213131313', '2017-03-25 01:07:07', '2017-03-25 01:07:13', '2017-03-25 01:32:54');
 
 -- --------------------------------------------------------
 

  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `benf_payments`
--

INSERT INTO `benf_payments` (`id`, `benf_master_id`, `payment_reference_id`, `payment_mode`, `payment_date`, `payment_status`, `amount`, `payment_for`, `chequeordd_no`, `bank_name`, `ifsc_code`, `notes`, `created_by_user_id`, `updated_by_user_id`, `created_date`, `updated_date`) VALUES
(1, 1, NULL, 3, '2017-03-09', 1, 2500, 2, 'jhbkjjkbkb', 'bjbjhb', NULL, 'gjgh', 4, 4, '2017-03-24 07:22:45', '2017-03-24 07:22:45'),
(14, 6, 1231, 1, '2017-03-16', 2, 25, 2, NULL, NULL, NULL, 'asddada', 4, 4, '2017-03-24 19:37:05', '2017-03-24 19:37:05'),
(15, 5, 123313, 3, '2017-03-02', 2, 25, 2, 'DD123456', 'HDFC', 'HDFC001234', 'gii', 4, 4, '2017-03-24 20:21:10', '2017-03-24 20:21:10'),
(16, 6, 212121, 2, '2017-03-25', 2, 250, 1, 'CC09919221', 'SBI', 'SBI000121', NULL, 4, 4, '2017-03-24 20:27:12', '2017-03-24 20:27:12');

-- --------------------------------------------------------

--

  `id` int(11) UNSIGNED NOT NULL,
  `entity_type` varchar(45) DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `entity_value` varchar(150) DEFAULT NULL,
  `created_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` varchar(45) DEFAULT NULL
