INSERT INTO `receipt_info` (`receipt_info_id`, `receipt_number`, `receipt_date`, `receipt_type`, `particulars`, `paid_by`, `payment_type`, `amount`, `received_by`, `s_personal_info_id`, `fee_info_id`, `bank`, `chq_dd_no`, `ptotal`, `s_standard`, `s_academic_year`, `bus_stop_name`, `stop_from`, `stop_to`, `status`, `cash_amount`) VALUES
 (153597,'AES E-3912','07-03-2019','Late Fee','Exam Fee Receipt','Kajal Dattatraya Deshmukh','Cash','0','Vishal','17181241',NULL,'','',NULL,'Second','2018-19','SECONDMBA2018-19','Regular',NULL,NULL,NULL),
 (153598,'AES E-3912','07-03-2019','Supper Late Fee','Exam Fee Receipt','Kajal Dattatraya Deshmukh','Cash','0','Vishal','17181241',NULL,'','',NULL,'Second','2018-19','SECONDMBA2018-19','Regular',NULL,NULL,NULL),
 (153599,'AES-E-3913-MBA-2018-19','2019-03-11','University Exam Form','EXAM RECEIPT','Ajay  Balaji  Chavan','Cash','30','Vishal','',NULL,NULL,NULL,'2395','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153600,'AES-E-3913-MBA-2018-19','2019-03-11','University Exam Fee','EXAM RECEIPT','Ajay  Balaji  Chavan','Cash','1600','Vishal','',NULL,NULL,NULL,'2395','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153601,'AES-E-3913-MBA-2018-19','2019-03-11','St. Of Marks Fee','EXAM RECEIPT','Ajay  Balaji  Chavan','Cash','145','Vishal','',NULL,NULL,NULL,'2395','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153602,'AES-E-3913-MBA-2018-19','2019-03-11','C.A.P. Fee','EXAM RECEIPT','Ajay  Balaji  Chavan','Cash','290','Vishal','',NULL,NULL,NULL,'2395','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153603,'AES-E-3913-MBA-2018-19','2019-03-11','Project Fee','EXAM RECEIPT','Ajay  Balaji  Chavan','Cash','0','Vishal','',NULL,NULL,NULL,'2395','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153604,'AES-E-3913-MBA-2018-19','2019-03-11','Passing Certificate Fee','EXAM RECEIPT','Ajay  Balaji  Chavan','Cash','0','Vishal','',NULL,NULL,NULL,'2395','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153605,'AES-E-3913-MBA-2018-19','2019-03-11','Internal Marks Fee','EXAM RECEIPT','Ajay  Balaji  Chavan','Cash','180','Vishal','',NULL,NULL,NULL,'2395','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153606,'AES-E-3913-MBA-2018-19','2019-03-11','Late Fee','EXAM RECEIPT','Ajay  Balaji  Chavan','Cash','150','Vishal','',NULL,NULL,NULL,'2395','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153607,'AES-E-3913-MBA-2018-19','2019-03-11','Supper Late Fee','EXAM RECEIPT','Ajay  Balaji  Chavan','Cash','0','Vishal','',NULL,NULL,NULL,'2395','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153608,'AES-E-3914-MBA-2018-19','2019-03-11','University Exam Form','EXAM RECEIPT','Rupesh  Vankat  Kothare','Cash','30','Vishal','',NULL,NULL,NULL,'2680','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153609,'AES-E-3914-MBA-2018-19','2019-03-11','University Exam Fee','EXAM RECEIPT','Rupesh  Vankat  Kothare','Cash','970','Vishal','',NULL,NULL,NULL,'2680','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153610,'AES-E-3914-MBA-2018-19','2019-03-11','St. Of Marks Fee','EXAM RECEIPT','Rupesh  Vankat  Kothare','Cash','145','Vishal','',NULL,NULL,NULL,'2680','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153611,'AES-E-3914-MBA-2018-19','2019-03-11','C.A.P. Fee','EXAM RECEIPT','Rupesh  Vankat  Kothare','Cash','580','Vishal','',NULL,NULL,NULL,'2680','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153612,'AES-E-3914-MBA-2018-19','2019-03-11','Project Fee','EXAM RECEIPT','Rupesh  Vankat  Kothare','Cash','510','Vishal','',NULL,NULL,NULL,'2680','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153613,'AES-E-3914-MBA-2018-19','2019-03-11','Passing Certificate Fee','EXAM RECEIPT','Rupesh  Vankat  Kothare','Cash','145','Vishal','',NULL,NULL,NULL,'2680','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153614,'AES-E-3914-MBA-2018-19','2019-03-11','Internal Marks Fee','EXAM RECEIPT','Rupesh  Vankat  Kothare','Cash','150','Vishal','',NULL,NULL,NULL,'2680','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153615,'AES-E-3914-MBA-2018-19','2019-03-11','Late Fee','EXAM RECEIPT','Rupesh  Vankat  Kothare','Cash','150','Vishal','',NULL,NULL,NULL,'2680','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153616,'AES-E-3914-MBA-2018-19','2019-03-11','Supper Late Fee','EXAM RECEIPT','Rupesh  Vankat  Kothare','Cash','0','Vishal','',NULL,NULL,NULL,'2680','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153617,'AES-E-3915-MBA-2018-19','2019-03-11','University Exam Form','EXAM RECEIPT','Ganesh  Suresh  Jadhav','Cash','30','Vishal','',NULL,NULL,NULL,'1955','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153618,'AES-E-3915-MBA-2018-19','2019-03-11','University Exam Fee','EXAM RECEIPT','Ganesh  Suresh  Jadhav','Cash','680','Vishal','',NULL,NULL,NULL,'1955','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153619,'AES-E-3915-MBA-2018-19','2019-03-11','St. Of Marks Fee','EXAM RECEIPT','Ganesh  Suresh  Jadhav','Cash','145','Vishal','',NULL,NULL,NULL,'1955','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153620,'AES-E-3915-MBA-2018-19','2019-03-11','C.A.P. Fee','EXAM RECEIPT','Ganesh  Suresh  Jadhav','Cash','145','Vishal','',NULL,NULL,NULL,'1955','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153621,'AES-E-3915-MBA-2018-19','2019-03-11','Project Fee','EXAM RECEIPT','Ganesh  Suresh  Jadhav','Cash','510','Vishal','',NULL,NULL,NULL,'1955','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153622,'AES-E-3915-MBA-2018-19','2019-03-11','Passing Certificate Fee','EXAM RECEIPT','Ganesh  Suresh  Jadhav','Cash','145','Vishal','',NULL,NULL,NULL,'1955','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153623,'AES-E-3915-MBA-2018-19','2019-03-11','Internal Marks Fee','EXAM RECEIPT','Ganesh  Suresh  Jadhav','Cash','150','Vishal','',NULL,NULL,NULL,'1955','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153624,'AES-E-3915-MBA-2018-19','2019-03-11','Late Fee','EXAM RECEIPT','Ganesh  Suresh  Jadhav','Cash','150','Vishal','',NULL,NULL,NULL,'1955','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153625,'AES-E-3915-MBA-2018-19','2019-03-11','Supper Late Fee','EXAM RECEIPT','Ganesh  Suresh  Jadhav','Cash','0','Vishal','',NULL,NULL,NULL,'1955','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153626,'AES E-3916','11-03-2019','University Exam Form','Exam Fee Receipt','AmritpalSingh Lakhawindharsingh Siddu','Cash','30','Vishal','16171227',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153627,'AES E-3916','11-03-2019','University Exam Fee','Exam Fee Receipt','AmritpalSingh Lakhawindharsingh Siddu','Cash','230','Vishal','16171227',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153628,'AES E-3916','11-03-2019','St. Of Marks Fee','Exam Fee Receipt','AmritpalSingh Lakhawindharsingh Siddu','Cash','145','Vishal','16171227',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153629,'AES E-3916','11-03-2019','C.A.P. Fee','Exam Fee Receipt','AmritpalSingh Lakhawindharsingh Siddu','Cash','145','Vishal','16171227',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153630,'AES E-3916','11-03-2019','Project Fee','Exam Fee Receipt','AmritpalSingh Lakhawindharsingh Siddu','Cash','0','Vishal','16171227',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153631,'AES E-3916','11-03-2019','Passing Certificate Fee','Exam Fee Receipt','AmritpalSingh Lakhawindharsingh Siddu','Cash','0','Vishal','16171227',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153632,'AES E-3916','11-03-2019','Internal Marks Fee','Exam Fee Receipt','AmritpalSingh Lakhawindharsingh Siddu','Cash','0','Vishal','16171227',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153633,'AES E-3916','11-03-2019','Late Fee','Exam Fee Receipt','AmritpalSingh Lakhawindharsingh Siddu','Cash','150','Vishal','16171227',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153634,'AES E-3916','11-03-2019','Supper Late Fee','Exam Fee Receipt','AmritpalSingh Lakhawindharsingh Siddu','Cash','0','Vishal','16171227',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153635,'AES-E-3917-MBA-2018-19','2019-03-11','University Exam Form','EXAM RECEIPT','Shubham  Diliprao  Choudhari','Cash','30','Vishal','',NULL,NULL,NULL,'1330','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153636,'AES-E-3917-MBA-2018-19','2019-03-11','University Exam Fee','EXAM RECEIPT','Shubham  Diliprao  Choudhari','Cash','680','Vishal','',NULL,NULL,NULL,'1330','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153637,'AES-E-3917-MBA-2018-19','2019-03-11','St. Of Marks Fee','EXAM RECEIPT','Shubham  Diliprao  Choudhari','Cash','145','Vishal','',NULL,NULL,NULL,'1330','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153638,'AES-E-3917-MBA-2018-19','2019-03-11','C.A.P. Fee','EXAM RECEIPT','Shubham  Diliprao  Choudhari','Cash','145','Vishal','',NULL,NULL,NULL,'1330','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153639,'AES-E-3917-MBA-2018-19','2019-03-11','Project Fee','EXAM RECEIPT','Shubham  Diliprao  Choudhari','Cash','0','Vishal','',NULL,NULL,NULL,'1330','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153640,'AES-E-3917-MBA-2018-19','2019-03-11','Passing Certificate Fee','EXAM RECEIPT','Shubham  Diliprao  Choudhari','Cash','0','Vishal','',NULL,NULL,NULL,'1330','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153641,'AES-E-3917-MBA-2018-19','2019-03-11','Internal Marks Fee','EXAM RECEIPT','Shubham  Diliprao  Choudhari','Cash','180','Vishal','',NULL,NULL,NULL,'1330','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153642,'AES-E-3917-MBA-2018-19','2019-03-11','Late Fee','EXAM RECEIPT','Shubham  Diliprao  Choudhari','Cash','150','Vishal','',NULL,NULL,NULL,'1330','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153643,'AES-E-3917-MBA-2018-19','2019-03-11','Supper Late Fee','EXAM RECEIPT','Shubham  Diliprao  Choudhari','Cash','0','Vishal','',NULL,NULL,NULL,'1330','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153644,'AES-E-3918-MBA-2018-19','2019-03-11','University Exam Form','EXAM RECEIPT','Shubham  Vasantrao  Wanve','Cash','30','Vishal','',NULL,NULL,NULL,'3435','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153645,'AES-E-3918-MBA-2018-19','2019-03-11','University Exam Fee','EXAM RECEIPT','Shubham  Vasantrao  Wanve','Cash','1870','Vishal','',NULL,NULL,NULL,'3435','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153646,'AES-E-3918-MBA-2018-19','2019-03-11','St. Of Marks Fee','EXAM RECEIPT','Shubham  Vasantrao  Wanve','Cash','145','Vishal','',NULL,NULL,NULL,'3435','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153647,'AES-E-3918-MBA-2018-19','2019-03-11','C.A.P. Fee','EXAM RECEIPT','Shubham  Vasantrao  Wanve','Cash','435','Vishal','',NULL,NULL,NULL,'3435','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153648,'AES-E-3918-MBA-2018-19','2019-03-11','Project Fee','EXAM RECEIPT','Shubham  Vasantrao  Wanve','Cash','510','Vishal','',NULL,NULL,NULL,'3435','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153649,'AES-E-3918-MBA-2018-19','2019-03-11','Passing Certificate Fee','EXAM RECEIPT','Shubham  Vasantrao  Wanve','Cash','145','Vishal','',NULL,NULL,NULL,'3435','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153650,'AES-E-3918-MBA-2018-19','2019-03-11','Internal Marks Fee','EXAM RECEIPT','Shubham  Vasantrao  Wanve','Cash','150','Vishal','',NULL,NULL,NULL,'3435','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153651,'AES-E-3918-MBA-2018-19','2019-03-11','Late Fee','EXAM RECEIPT','Shubham  Vasantrao  Wanve','Cash','150','Vishal','',NULL,NULL,NULL,'3435','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153652,'AES-E-3918-MBA-2018-19','2019-03-11','Supper Late Fee','EXAM RECEIPT','Shubham  Vasantrao  Wanve','Cash','0','Vishal','',NULL,NULL,NULL,'3435','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153653,'AES-E-3919-MBA-2018-19','2019-03-11','University Exam Form','EXAM RECEIPT','Mayur  Vishnu  Kumbhar','Cash','30','Vishal','',NULL,NULL,NULL,'2755','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153654,'AES-E-3919-MBA-2018-19','2019-03-11','University Exam Fee','EXAM RECEIPT','Mayur  Vishnu  Kumbhar','Cash','1190','Vishal','',NULL,NULL,NULL,'2755','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153655,'AES-E-3919-MBA-2018-19','2019-03-11','St. Of Marks Fee','EXAM RECEIPT','Mayur  Vishnu  Kumbhar','Cash','145','Vishal','',NULL,NULL,NULL,'2755','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153656,'AES-E-3919-MBA-2018-19','2019-03-11','C.A.P. Fee','EXAM RECEIPT','Mayur  Vishnu  Kumbhar','Cash','435','Vishal','',NULL,NULL,NULL,'2755','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153657,'AES-E-3919-MBA-2018-19','2019-03-11','Project Fee','EXAM RECEIPT','Mayur  Vishnu  Kumbhar','Cash','510','Vishal','',NULL,NULL,NULL,'2755','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153658,'AES-E-3919-MBA-2018-19','2019-03-11','Passing Certificate Fee','EXAM RECEIPT','Mayur  Vishnu  Kumbhar','Cash','145','Vishal','',NULL,NULL,NULL,'2755','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153659,'AES-E-3919-MBA-2018-19','2019-03-11','Internal Marks Fee','EXAM RECEIPT','Mayur  Vishnu  Kumbhar','Cash','150','Vishal','',NULL,NULL,NULL,'2755','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153660,'AES-E-3919-MBA-2018-19','2019-03-11','Late Fee','EXAM RECEIPT','Mayur  Vishnu  Kumbhar','Cash','150','Vishal','',NULL,NULL,NULL,'2755','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153661,'AES-E-3919-MBA-2018-19','2019-03-11','Supper Late Fee','EXAM RECEIPT','Mayur  Vishnu  Kumbhar','Cash','0','Vishal','',NULL,NULL,NULL,'2755','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153662,'AES E-3920','11-03-2019','University Exam Form','Exam Fee Receipt','Junaidaalam Mazhar Khan','Cash','30','Vishal','16171176',NULL,'','',NULL,'FIRST','2018-19','FIRSTMBA','Regular',NULL,NULL,NULL),
 (153663,'AES E-3920','11-03-2019','University Exam Fee','Exam Fee Receipt','Junaidaalam Mazhar Khan','Cash','1360','Vishal','16171176',NULL,'','',NULL,'FIRST','2018-19','FIRSTMBA','Regular',NULL,NULL,NULL),
 (153664,'AES E-3920','11-03-2019','St. Of Marks Fee','Exam Fee Receipt','Junaidaalam Mazhar Khan','Cash','145','Vishal','16171176',NULL,'','',NULL,'FIRST','2018-19','FIRSTMBA','Regular',NULL,NULL,NULL),
 (153665,'AES E-3920','11-03-2019','C.A.P. Fee','Exam Fee Receipt','Junaidaalam Mazhar Khan','Cash','145','Vishal','16171176',NULL,'','',NULL,'FIRST','2018-19','FIRSTMBA','Regular',NULL,NULL,NULL),
 (153666,'AES E-3920','11-03-2019','Project Fee','Exam Fee Receipt','Junaidaalam Mazhar Khan','Cash','510','Vishal','16171176',NULL,'','',NULL,'FIRST','2018-19','FIRSTMBA','Regular',NULL,NULL,NULL),
 (153667,'AES E-3920','11-03-2019','Passing Certificate Fee','Exam Fee Receipt','Junaidaalam Mazhar Khan','Cash','145','Vishal','16171176',NULL,'','',NULL,'FIRST','2018-19','FIRSTMBA','Regular',NULL,NULL,NULL),
 (153668,'AES E-3920','11-03-2019','Internal Marks Fee','Exam Fee Receipt','Junaidaalam Mazhar Khan','Cash','150','Vishal','16171176',NULL,'','',NULL,'FIRST','2018-19','FIRSTMBA','Regular',NULL,NULL,NULL),
 (153669,'AES E-3920','11-03-2019','Late Fee','Exam Fee Receipt','Junaidaalam Mazhar Khan','Cash','150','Vishal','16171176',NULL,'','',NULL,'FIRST','2018-19','FIRSTMBA','Regular',NULL,NULL,NULL),
 (153670,'AES E-3920','11-03-2019','Supper Late Fee','Exam Fee Receipt','Junaidaalam Mazhar Khan','Cash','0','Vishal','16171176',NULL,'','',NULL,'FIRST','2018-19','FIRSTMBA','Regular',NULL,NULL,NULL),
 (153671,'AES-E-3921-MBA-2018-19','2019-03-11','University Exam Form','EXAM RECEIPT','Akhila  Aditya  Moholkar','Cash','30','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153672,'AES-E-3921-MBA-2018-19','2019-03-11','University Exam Fee','EXAM RECEIPT','Akhila  Aditya  Moholkar','Cash','1590','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153673,'AES-E-3921-MBA-2018-19','2019-03-11','St. Of Marks Fee','EXAM RECEIPT','Akhila  Aditya  Moholkar','Cash','145','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153674,'AES-E-3921-MBA-2018-19','2019-03-11','C.A.P. Fee','EXAM RECEIPT','Akhila  Aditya  Moholkar','Cash','290','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153675,'AES-E-3921-MBA-2018-19','2019-03-11','Project Fee','EXAM RECEIPT','Akhila  Aditya  Moholkar','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153676,'AES-E-3921-MBA-2018-19','2019-03-11','Passing Certificate Fee','EXAM RECEIPT','Akhila  Aditya  Moholkar','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153677,'AES-E-3921-MBA-2018-19','2019-03-11','Internal Marks Fee','EXAM RECEIPT','Akhila  Aditya  Moholkar','Cash','180','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153678,'AES-E-3921-MBA-2018-19','2019-03-11','Late Fee','EXAM RECEIPT','Akhila  Aditya  Moholkar','Cash','150','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153679,'AES-E-3921-MBA-2018-19','2019-03-11','Supper Late Fee','EXAM RECEIPT','Akhila  Aditya  Moholkar','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153680,'AES-E-3922-MBA-2018-19','2019-03-12','University Exam Form','EXAM RECEIPT','Durgesh  Jhinku  Pal','Cash','30','Vishal','',NULL,NULL,NULL,'1355','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153681,'AES-E-3922-MBA-2018-19','2019-03-12','University Exam Fee','EXAM RECEIPT','Durgesh  Jhinku  Pal','Cash','740','Vishal','',NULL,NULL,NULL,'1355','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153682,'AES-E-3922-MBA-2018-19','2019-03-12','St. Of Marks Fee','EXAM RECEIPT','Durgesh  Jhinku  Pal','Cash','145','Vishal','',NULL,NULL,NULL,'1355','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153683,'AES-E-3922-MBA-2018-19','2019-03-12','C.A.P. Fee','EXAM RECEIPT','Durgesh  Jhinku  Pal','Cash','290','Vishal','',NULL,NULL,NULL,'1355','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153684,'AES-E-3922-MBA-2018-19','2019-03-12','Project Fee','EXAM RECEIPT','Durgesh  Jhinku  Pal','Cash','0','Vishal','',NULL,NULL,NULL,'1355','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153685,'AES-E-3922-MBA-2018-19','2019-03-12','Passing Certificate Fee','EXAM RECEIPT','Durgesh  Jhinku  Pal','Cash','0','Vishal','',NULL,NULL,NULL,'1355','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153686,'AES-E-3922-MBA-2018-19','2019-03-12','Internal Marks Fee','EXAM RECEIPT','Durgesh  Jhinku  Pal','Cash','0','Vishal','',NULL,NULL,NULL,'1355','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153687,'AES-E-3922-MBA-2018-19','2019-03-12','Late Fee','EXAM RECEIPT','Durgesh  Jhinku  Pal','Cash','150','Vishal','',NULL,NULL,NULL,'1355','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153688,'AES-E-3922-MBA-2018-19','2019-03-12','Supper Late Fee','EXAM RECEIPT','Durgesh  Jhinku  Pal','Cash','0','Vishal','',NULL,NULL,NULL,'1355','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153689,'AES-E-3923-MBA-2018-19','2019-03-12','University Exam Form','EXAM RECEIPT','Samadhan  Sopan  Kokare','Cash','30','Vishal','',NULL,NULL,NULL,'2240','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153690,'AES-E-3923-MBA-2018-19','2019-03-12','University Exam Fee','EXAM RECEIPT','Samadhan  Sopan  Kokare','Cash','970','Vishal','',NULL,NULL,NULL,'2240','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153691,'AES-E-3923-MBA-2018-19','2019-03-12','St. Of Marks Fee','EXAM RECEIPT','Samadhan  Sopan  Kokare','Cash','145','Vishal','',NULL,NULL,NULL,'2240','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153692,'AES-E-3923-MBA-2018-19','2019-03-12','C.A.P. Fee','EXAM RECEIPT','Samadhan  Sopan  Kokare','Cash','435','Vishal','',NULL,NULL,NULL,'2240','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153693,'AES-E-3923-MBA-2018-19','2019-03-12','Project Fee','EXAM RECEIPT','Samadhan  Sopan  Kokare','Cash','510','Vishal','',NULL,NULL,NULL,'2240','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153694,'AES-E-3923-MBA-2018-19','2019-03-12','Passing Certificate Fee','EXAM RECEIPT','Samadhan  Sopan  Kokare','Cash','0','Vishal','',NULL,NULL,NULL,'2240','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153695,'AES-E-3923-MBA-2018-19','2019-03-12','Internal Marks Fee','EXAM RECEIPT','Samadhan  Sopan  Kokare','Cash','0','Vishal','',NULL,NULL,NULL,'2240','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153696,'AES-E-3923-MBA-2018-19','2019-03-12','Late Fee','EXAM RECEIPT','Samadhan  Sopan  Kokare','Cash','150','Vishal','',NULL,NULL,NULL,'2240','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153697,'AES-E-3923-MBA-2018-19','2019-03-12','Supper Late Fee','EXAM RECEIPT','Samadhan  Sopan  Kokare','Cash','0','Vishal','',NULL,NULL,NULL,'2240','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153698,'AES-F-3490-2018-19','2019-03-01','Developement Fee','Fee Receipt','Ajay Balaji Chavan','Cheque','0','BankOfMaharasta','18191201819',NULL,'BankofMaharastra','566203','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153699,'AES-F-3490-2018-19','2019-03-01','interim Fee','Fee Receipt','Ajay Balaji Chavan','Cheque','0','BankOfMaharasta','18191201819',NULL,'BankofMaharastra','566203','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153700,'AES-F-3490-2018-19','2019-03-01','Tution Fee','Fee Receipt','Ajay Balaji Chavan','Cheque','19433','BankOfMaharasta','18191201819',NULL,'BankofMaharastra','566203','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153701,'AES-F-3491-2018-19','2019-03-01','Developement Fee','Fee Receipt','Rohit Shavareppa Andodgi','Cheque','0','BankOfMaharasta','1819161702512',NULL,'BankofMaharastra','573222','12864','SECOND','2018-19','SECONDMBA','Regular','fee_receipt_counter',' ',' '),
 (153702,'AES-F-3491-2018-19','2019-03-01','interim Fee','Fee Receipt','Rohit Shavareppa Andodgi','Cheque','0','BankOfMaharasta','1819161702512',NULL,'BankofMaharastra','573222','12864','SECOND','2018-19','SECONDMBA','Regular','fee_receipt_counter',' ',' '),
 (153703,'AES-F-3491-2018-19','2019-03-01','Tution Fee','Fee Receipt','Rohit Shavareppa Andodgi','Cheque','12864','BankOfMaharasta','1819161702512',NULL,'BankofMaharastra','573222','12864','SECOND','2018-19','SECONDMBA','Regular','fee_receipt_counter',' ',' '),
 (153704,'AES-F-3492-2018-19','2019-03-01','Developement Fee','Fee Receipt','Ajay Ashok Zanjurne','Cheque','0','BankOfMaharasta','17181405',NULL,'BankofMaharastra','573222','12864','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153705,'AES-F-3492-2018-19','2019-03-01','interim Fee','Fee Receipt','Ajay Ashok Zanjurne','Cheque','0','BankOfMaharasta','17181405',NULL,'BankofMaharastra','573222','12864','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153706,'AES-F-3492-2018-19','2019-03-01','Tution Fee','Fee Receipt','Ajay Ashok Zanjurne','Cheque','12864','BankOfMaharasta','17181405',NULL,'BankofMaharastra','573222','12864','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153707,'AES E-3924','13-03-2019','University Exam Form','Exam Fee Receipt','Indranil Balkrusna Jade','Cash','30','Vishal','16171216',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153708,'AES E-3924','13-03-2019','University Exam Fee','Exam Fee Receipt','Indranil Balkrusna Jade','Cash','460','Vishal','16171216',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153709,'AES E-3924','13-03-2019','St. Of Marks Fee','Exam Fee Receipt','Indranil Balkrusna Jade','Cash','145','Vishal','16171216',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153710,'AES E-3924','13-03-2019','C.A.P. Fee','Exam Fee Receipt','Indranil Balkrusna Jade','Cash','145','Vishal','16171216',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153711,'AES E-3924','13-03-2019','Project Fee','Exam Fee Receipt','Indranil Balkrusna Jade','Cash','0','Vishal','16171216',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153712,'AES E-3924','13-03-2019','Passing Certificate Fee','Exam Fee Receipt','Indranil Balkrusna Jade','Cash','0','Vishal','16171216',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153713,'AES E-3924','13-03-2019','Internal Marks Fee','Exam Fee Receipt','Indranil Balkrusna Jade','Cash','0','Vishal','16171216',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153714,'AES E-3924','13-03-2019','Late Fee','Exam Fee Receipt','Indranil Balkrusna Jade','Cash','150','Vishal','16171216',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153715,'AES E-3924','13-03-2019','Supper Late Fee','Exam Fee Receipt','Indranil Balkrusna Jade','Cash','0','Vishal','16171216',NULL,'','',NULL,'Second','2018-19','SECONDMBA2017-18','Regular',NULL,NULL,NULL),
 (153716,'AES-E-3925-MBA-2018-19','2019-03-13','University Exam Form','EXAM RECEIPT','Nilima  Samprati  Balsane','Cash','30','Vishal','',NULL,NULL,NULL,'2615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153717,'AES-E-3925-MBA-2018-19','2019-03-13','University Exam Fee','EXAM RECEIPT','Nilima  Samprati  Balsane','Cash','1820','Vishal','',NULL,NULL,NULL,'2615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153718,'AES-E-3925-MBA-2018-19','2019-03-13','St. Of Marks Fee','EXAM RECEIPT','Nilima  Samprati  Balsane','Cash','145','Vishal','',NULL,NULL,NULL,'2615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153719,'AES-E-3925-MBA-2018-19','2019-03-13','C.A.P. Fee','EXAM RECEIPT','Nilima  Samprati  Balsane','Cash','290','Vishal','',NULL,NULL,NULL,'2615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153720,'AES-E-3925-MBA-2018-19','2019-03-13','Project Fee','EXAM RECEIPT','Nilima  Samprati  Balsane','Cash','0','Vishal','',NULL,NULL,NULL,'2615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153721,'AES-E-3925-MBA-2018-19','2019-03-13','Passing Certificate Fee','EXAM RECEIPT','Nilima  Samprati  Balsane','Cash','0','Vishal','',NULL,NULL,NULL,'2615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153722,'AES-E-3925-MBA-2018-19','2019-03-13','Internal Marks Fee','EXAM RECEIPT','Nilima  Samprati  Balsane','Cash','180','Vishal','',NULL,NULL,NULL,'2615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153723,'AES-E-3925-MBA-2018-19','2019-03-13','Late Fee','EXAM RECEIPT','Nilima  Samprati  Balsane','Cash','150','Vishal','',NULL,NULL,NULL,'2615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153724,'AES-E-3925-MBA-2018-19','2019-03-13','Supper Late Fee','EXAM RECEIPT','Nilima  Samprati  Balsane','Cash','0','Vishal','',NULL,NULL,NULL,'2615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153725,'AES-E-3926-MBA-2018-19','2019-03-14','University Exam Form','EXAM RECEIPT','Vinod  Dattatray  Kendre','Cash','30','Vishal','',NULL,NULL,NULL,'3515','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153726,'AES-E-3926-MBA-2018-19','2019-03-14','University Exam Fee','EXAM RECEIPT','Vinod  Dattatray  Kendre','Cash','2720','Vishal','',NULL,NULL,NULL,'3515','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153727,'AES-E-3926-MBA-2018-19','2019-03-14','St. Of Marks Fee','EXAM RECEIPT','Vinod  Dattatray  Kendre','Cash','145','Vishal','',NULL,NULL,NULL,'3515','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153728,'AES-E-3926-MBA-2018-19','2019-03-14','C.A.P. Fee','EXAM RECEIPT','Vinod  Dattatray  Kendre','Cash','290','Vishal','',NULL,NULL,NULL,'3515','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153729,'AES-E-3926-MBA-2018-19','2019-03-14','Project Fee','EXAM RECEIPT','Vinod  Dattatray  Kendre','Cash','0','Vishal','',NULL,NULL,NULL,'3515','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153730,'AES-E-3926-MBA-2018-19','2019-03-14','Passing Certificate Fee','EXAM RECEIPT','Vinod  Dattatray  Kendre','Cash','0','Vishal','',NULL,NULL,NULL,'3515','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153731,'AES-E-3926-MBA-2018-19','2019-03-14','Internal Marks Fee','EXAM RECEIPT','Vinod  Dattatray  Kendre','Cash','180','Vishal','',NULL,NULL,NULL,'3515','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153732,'AES-E-3926-MBA-2018-19','2019-03-14','Late Fee','EXAM RECEIPT','Vinod  Dattatray  Kendre','Cash','150','Vishal','',NULL,NULL,NULL,'3515','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153733,'AES-E-3926-MBA-2018-19','2019-03-14','Supper Late Fee','EXAM RECEIPT','Vinod  Dattatray  Kendre','Cash','0','Vishal','',NULL,NULL,NULL,'3515','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153734,'AES-E-3927-MBA-2018-19','2019-03-14','University Exam Form','EXAM RECEIPT','Sneha  Arjun  Gadhire','Cash','30','Vishal','',NULL,NULL,NULL,'3895','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153735,'AES-E-3927-MBA-2018-19','2019-03-14','University Exam Fee','EXAM RECEIPT','Sneha  Arjun  Gadhire','Cash','1820','Vishal','',NULL,NULL,NULL,'3895','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153736,'AES-E-3927-MBA-2018-19','2019-03-14','St. Of Marks Fee','EXAM RECEIPT','Sneha  Arjun  Gadhire','Cash','145','Vishal','',NULL,NULL,NULL,'3895','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153737,'AES-E-3927-MBA-2018-19','2019-03-14','C.A.P. Fee','EXAM RECEIPT','Sneha  Arjun  Gadhire','Cash','435','Vishal','',NULL,NULL,NULL,'3895','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153738,'AES-E-3927-MBA-2018-19','2019-03-14','Project Fee','EXAM RECEIPT','Sneha  Arjun  Gadhire','Cash','1020','Vishal','',NULL,NULL,NULL,'3895','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153739,'AES-E-3927-MBA-2018-19','2019-03-14','Passing Certificate Fee','EXAM RECEIPT','Sneha  Arjun  Gadhire','Cash','145','Vishal','',NULL,NULL,NULL,'3895','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153740,'AES-E-3927-MBA-2018-19','2019-03-14','Internal Marks Fee','EXAM RECEIPT','Sneha  Arjun  Gadhire','Cash','150','Vishal','',NULL,NULL,NULL,'3895','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153741,'AES-E-3927-MBA-2018-19','2019-03-14','Late Fee','EXAM RECEIPT','Sneha  Arjun  Gadhire','Cash','150','Vishal','',NULL,NULL,NULL,'3895','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153742,'AES-E-3927-MBA-2018-19','2019-03-14','Supper Late Fee','EXAM RECEIPT','Sneha  Arjun  Gadhire','Cash','0','Vishal','',NULL,NULL,NULL,'3895','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153743,'AES E-3928','15-03-2019','University Exam Form','Exam Fee Receipt','Swati Lahu Bhosale','Cash','30','Vishal','17181242',NULL,'','',NULL,'Second','2018-19','SECONDMBA2018-19','New',NULL,NULL,NULL),
 (153744,'AES E-3928','15-03-2019','University Exam Fee','Exam Fee Receipt','Swati Lahu Bhosale','Cash','1920','Vishal','17181242',NULL,'','',NULL,'Second','2018-19','SECONDMBA2018-19','New',NULL,NULL,NULL),
 (153745,'AES E-3928','15-03-2019','St. Of Marks Fee','Exam Fee Receipt','Swati Lahu Bhosale','Cash','145','Vishal','17181242',NULL,'','',NULL,'Second','2018-19','SECONDMBA2018-19','New',NULL,NULL,NULL),
 (153746,'AES E-3928','15-03-2019','C.A.P. Fee','Exam Fee Receipt','Swati Lahu Bhosale','Cash','290','Vishal','17181242',NULL,'','',NULL,'Second','2018-19','SECONDMBA2018-19','New',NULL,NULL,NULL),
 (153747,'AES E-3928','15-03-2019','Project Fee','Exam Fee Receipt','Swati Lahu Bhosale','Cash','510','Vishal','17181242',NULL,'','',NULL,'Second','2018-19','SECONDMBA2018-19','New',NULL,NULL,NULL),
 (153748,'AES E-3928','15-03-2019','Passing Certificate Fee','Exam Fee Receipt','Swati Lahu Bhosale','Cash','145','Vishal','17181242',NULL,'','',NULL,'Second','2018-19','SECONDMBA2018-19','New',NULL,NULL,NULL),
 (153749,'AES E-3928','15-03-2019','Internal Marks Fee','Exam Fee Receipt','Swati Lahu Bhosale','Cash','150','Vishal','17181242',NULL,'','',NULL,'Second','2018-19','SECONDMBA2018-19','New',NULL,NULL,NULL),
 (153750,'AES E-3928','15-03-2019','Late Fee','Exam Fee Receipt','Swati Lahu Bhosale','Cash','150','Vishal','17181242',NULL,'','',NULL,'Second','2018-19','SECONDMBA2018-19','New',NULL,NULL,NULL),
 (153751,'AES E-3928','15-03-2019','Supper Late Fee','Exam Fee Receipt','Swati Lahu Bhosale','Cash','0','Vishal','17181242',NULL,'','',NULL,'Second','2018-19','SECONDMBA2018-19','New',NULL,NULL,NULL),
 (153752,'AES-E-3929-MBA-2018-19','2019-03-15','University Exam Form','EXAM RECEIPT','pravin  Sudhir  Telkar','Cash','30','Vishal','',NULL,NULL,NULL,'4845','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153753,'AES-E-3929-MBA-2018-19','2019-03-15','University Exam Fee','EXAM RECEIPT','pravin  Sudhir  Telkar','Cash','2610','Vishal','',NULL,NULL,NULL,'4845','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153754,'AES-E-3929-MBA-2018-19','2019-03-15','St. Of Marks Fee','EXAM RECEIPT','pravin  Sudhir  Telkar','Cash','145','Vishal','',NULL,NULL,NULL,'4845','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153755,'AES-E-3929-MBA-2018-19','2019-03-15','C.A.P. Fee','EXAM RECEIPT','pravin  Sudhir  Telkar','Cash','580','Vishal','',NULL,NULL,NULL,'4845','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153756,'AES-E-3929-MBA-2018-19','2019-03-15','Project Fee','EXAM RECEIPT','pravin  Sudhir  Telkar','Cash','1020','Vishal','',NULL,NULL,NULL,'4845','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153757,'AES-E-3929-MBA-2018-19','2019-03-15','Passing Certificate Fee','EXAM RECEIPT','pravin  Sudhir  Telkar','Cash','145','Vishal','',NULL,NULL,NULL,'4845','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153758,'AES-E-3929-MBA-2018-19','2019-03-15','Internal Marks Fee','EXAM RECEIPT','pravin  Sudhir  Telkar','Cash','165','Vishal','',NULL,NULL,NULL,'4845','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153759,'AES-E-3929-MBA-2018-19','2019-03-15','Late Fee','EXAM RECEIPT','pravin  Sudhir  Telkar','Cash','150','Vishal','',NULL,NULL,NULL,'4845','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153760,'AES-E-3929-MBA-2018-19','2019-03-15','Supper Late Fee','EXAM RECEIPT','pravin  Sudhir  Telkar','Cash','0','Vishal','',NULL,NULL,NULL,'4845','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153761,'AES-E-3930-MBA-2018-19','2019-03-16','University Exam Form','EXAM RECEIPT','Monica  Vishakhadatta  Jadhav','Cash','30','Vishal','',NULL,NULL,NULL,'2010','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153762,'AES-E-3930-MBA-2018-19','2019-03-16','University Exam Fee','EXAM RECEIPT','Monica  Vishakhadatta  Jadhav','Cash','1360','Vishal','',NULL,NULL,NULL,'2010','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153763,'AES-E-3930-MBA-2018-19','2019-03-16','St. Of Marks Fee','EXAM RECEIPT','Monica  Vishakhadatta  Jadhav','Cash','145','Vishal','',NULL,NULL,NULL,'2010','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153764,'AES-E-3930-MBA-2018-19','2019-03-16','C.A.P. Fee','EXAM RECEIPT','Monica  Vishakhadatta  Jadhav','Cash','145','Vishal','',NULL,NULL,NULL,'2010','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153765,'AES-E-3930-MBA-2018-19','2019-03-16','Project Fee','EXAM RECEIPT','Monica  Vishakhadatta  Jadhav','Cash','0','Vishal','',NULL,NULL,NULL,'2010','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153766,'AES-E-3930-MBA-2018-19','2019-03-16','Passing Certificate Fee','EXAM RECEIPT','Monica  Vishakhadatta  Jadhav','Cash','0','Vishal','',NULL,NULL,NULL,'2010','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153767,'AES-E-3930-MBA-2018-19','2019-03-16','Internal Marks Fee','EXAM RECEIPT','Monica  Vishakhadatta  Jadhav','Cash','180','Vishal','',NULL,NULL,NULL,'2010','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153768,'AES-E-3930-MBA-2018-19','2019-03-16','Late Fee','EXAM RECEIPT','Monica  Vishakhadatta  Jadhav','Cash','150','Vishal','',NULL,NULL,NULL,'2010','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153769,'AES-E-3930-MBA-2018-19','2019-03-16','Supper Late Fee','EXAM RECEIPT','Monica  Vishakhadatta  Jadhav','Cash','0','Vishal','',NULL,NULL,NULL,'2010','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153770,'AES-E-3931-MBA-2018-19','2019-03-16','University Exam Form','EXAM RECEIPT','Amol  Umraosing  Patil','Cash','30','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153771,'AES-E-3931-MBA-2018-19','2019-03-16','University Exam Fee','EXAM RECEIPT','Amol  Umraosing  Patil','Cash','1590','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153772,'AES-E-3931-MBA-2018-19','2019-03-16','St. Of Marks Fee','EXAM RECEIPT','Amol  Umraosing  Patil','Cash','145','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153773,'AES-E-3931-MBA-2018-19','2019-03-16','C.A.P. Fee','EXAM RECEIPT','Amol  Umraosing  Patil','Cash','290','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153774,'AES-E-3931-MBA-2018-19','2019-03-16','Project Fee','EXAM RECEIPT','Amol  Umraosing  Patil','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153775,'AES-E-3931-MBA-2018-19','2019-03-16','Passing Certificate Fee','EXAM RECEIPT','Amol  Umraosing  Patil','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153776,'AES-E-3931-MBA-2018-19','2019-03-16','Internal Marks Fee','EXAM RECEIPT','Amol  Umraosing  Patil','Cash','180','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153777,'AES-E-3931-MBA-2018-19','2019-03-16','Late Fee','EXAM RECEIPT','Amol  Umraosing  Patil','Cash','150','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153778,'AES-E-3931-MBA-2018-19','2019-03-16','Supper Late Fee','EXAM RECEIPT','Amol  Umraosing  Patil','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153779,'AES-E-3932-MBA-2018-19','2019-03-15','University Exam Form','EXAM RECEIPT','Shital  Umraosing  Kandalkar','Cash','30','Vishal','',NULL,NULL,NULL,'2845','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153780,'AES-E-3932-MBA-2018-19','2019-03-15','University Exam Fee','EXAM RECEIPT','Shital  Umraosing  Kandalkar','Cash','2050','Vishal','',NULL,NULL,NULL,'2845','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153781,'AES-E-3932-MBA-2018-19','2019-03-15','St. Of Marks Fee','EXAM RECEIPT','Shital  Umraosing  Kandalkar','Cash','145','Vishal','',NULL,NULL,NULL,'2845','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153782,'AES-E-3932-MBA-2018-19','2019-03-15','C.A.P. Fee','EXAM RECEIPT','Shital  Umraosing  Kandalkar','Cash','290','Vishal','',NULL,NULL,NULL,'2845','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153783,'AES-E-3932-MBA-2018-19','2019-03-15','Project Fee','EXAM RECEIPT','Shital  Umraosing  Kandalkar','Cash','0','Vishal','',NULL,NULL,NULL,'2845','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153784,'AES-E-3932-MBA-2018-19','2019-03-15','Passing Certificate Fee','EXAM RECEIPT','Shital  Umraosing  Kandalkar','Cash','0','Vishal','',NULL,NULL,NULL,'2845','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153785,'AES-E-3932-MBA-2018-19','2019-03-15','Internal Marks Fee','EXAM RECEIPT','Shital  Umraosing  Kandalkar','Cash','180','Vishal','',NULL,NULL,NULL,'2845','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153786,'AES-E-3932-MBA-2018-19','2019-03-15','Late Fee','EXAM RECEIPT','Shital  Umraosing  Kandalkar','Cash','150','Vishal','',NULL,NULL,NULL,'2845','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153787,'AES-E-3932-MBA-2018-19','2019-03-15','Supper Late Fee','EXAM RECEIPT','Shital  Umraosing  Kandalkar','Cash','0','Vishal','',NULL,NULL,NULL,'2845','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153788,'AES-E-3933-MBA-2018-19','2019-03-18','University Exam Form','EXAM RECEIPT','Kiran   Ashok  Ahire','Cash','30','Vishal','',NULL,NULL,NULL,'2855','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153789,'AES-E-3933-MBA-2018-19','2019-03-18','University Exam Fee','EXAM RECEIPT','Kiran   Ashok  Ahire','Cash','910','Vishal','',NULL,NULL,NULL,'2855','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153790,'AES-E-3933-MBA-2018-19','2019-03-18','St. Of Marks Fee','EXAM RECEIPT','Kiran   Ashok  Ahire','Cash','145','Vishal','',NULL,NULL,NULL,'2855','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153791,'AES-E-3933-MBA-2018-19','2019-03-18','C.A.P. Fee','EXAM RECEIPT','Kiran   Ashok  Ahire','Cash','290','Vishal','',NULL,NULL,NULL,'2855','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153792,'AES-E-3933-MBA-2018-19','2019-03-18','Project Fee','EXAM RECEIPT','Kiran   Ashok  Ahire','Cash','1020','Vishal','',NULL,NULL,NULL,'2855','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153793,'AES-E-3933-MBA-2018-19','2019-03-18','Passing Certificate Fee','EXAM RECEIPT','Kiran   Ashok  Ahire','Cash','145','Vishal','',NULL,NULL,NULL,'2855','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153794,'AES-E-3933-MBA-2018-19','2019-03-18','Internal Marks Fee','EXAM RECEIPT','Kiran   Ashok  Ahire','Cash','165','Vishal','',NULL,NULL,NULL,'2855','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153795,'AES-E-3933-MBA-2018-19','2019-03-18','Late Fee','EXAM RECEIPT','Kiran   Ashok  Ahire','Cash','150','Vishal','',NULL,NULL,NULL,'2855','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153796,'AES-E-3933-MBA-2018-19','2019-03-18','Supper Late Fee','EXAM RECEIPT','Kiran   Ashok  Ahire','Cash','0','Vishal','',NULL,NULL,NULL,'2855','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153797,'AES-E-3934-MBA-2018-19','2019-03-18','University Exam Form','EXAM RECEIPT','Supriya  Bhairu  Nare','Cash','30','Vishal','',NULL,NULL,NULL,'700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153798,'AES-E-3934-MBA-2018-19','2019-03-18','University Exam Fee','EXAM RECEIPT','Supriya  Bhairu  Nare','Cash','230','Vishal','',NULL,NULL,NULL,'700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153799,'AES-E-3934-MBA-2018-19','2019-03-18','St. Of Marks Fee','EXAM RECEIPT','Supriya  Bhairu  Nare','Cash','145','Vishal','',NULL,NULL,NULL,'700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153800,'AES-E-3934-MBA-2018-19','2019-03-18','C.A.P. Fee','EXAM RECEIPT','Supriya  Bhairu  Nare','Cash','145','Vishal','',NULL,NULL,NULL,'700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153801,'AES-E-3934-MBA-2018-19','2019-03-18','Project Fee','EXAM RECEIPT','Supriya  Bhairu  Nare','Cash','0','Vishal','',NULL,NULL,NULL,'700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153802,'AES-E-3934-MBA-2018-19','2019-03-18','Passing Certificate Fee','EXAM RECEIPT','Supriya  Bhairu  Nare','Cash','0','Vishal','',NULL,NULL,NULL,'700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153803,'AES-E-3934-MBA-2018-19','2019-03-18','Internal Marks Fee','EXAM RECEIPT','Supriya  Bhairu  Nare','Cash','0','Vishal','',NULL,NULL,NULL,'700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153804,'AES-E-3934-MBA-2018-19','2019-03-18','Late Fee','EXAM RECEIPT','Supriya  Bhairu  Nare','Cash','150','Vishal','',NULL,NULL,NULL,'700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153805,'AES-E-3934-MBA-2018-19','2019-03-18','Supper Late Fee','EXAM RECEIPT','Supriya  Bhairu  Nare','Cash','0','Vishal','',NULL,NULL,NULL,'700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153806,'AES-E-3935-MBA-2018-19','2019-03-18','University Exam Form','EXAM RECEIPT','Jagdish  Ravindra  Shetty','Cash','30','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153807,'AES-E-3935-MBA-2018-19','2019-03-18','University Exam Fee','EXAM RECEIPT','Jagdish  Ravindra  Shetty','Cash','1590','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153808,'AES-E-3935-MBA-2018-19','2019-03-18','St. Of Marks Fee','EXAM RECEIPT','Jagdish  Ravindra  Shetty','Cash','145','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153809,'AES-E-3935-MBA-2018-19','2019-03-18','C.A.P. Fee','EXAM RECEIPT','Jagdish  Ravindra  Shetty','Cash','290','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153810,'AES-E-3935-MBA-2018-19','2019-03-18','Project Fee','EXAM RECEIPT','Jagdish  Ravindra  Shetty','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153811,'AES-E-3935-MBA-2018-19','2019-03-18','Passing Certificate Fee','EXAM RECEIPT','Jagdish  Ravindra  Shetty','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153812,'AES-E-3935-MBA-2018-19','2019-03-18','Internal Marks Fee','EXAM RECEIPT','Jagdish  Ravindra  Shetty','Cash','180','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153813,'AES-E-3935-MBA-2018-19','2019-03-18','Late Fee','EXAM RECEIPT','Jagdish  Ravindra  Shetty','Cash','150','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153814,'AES-E-3935-MBA-2018-19','2019-03-18','Supper Late Fee','EXAM RECEIPT','Jagdish  Ravindra  Shetty','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153815,'AES-E-3936-MBA-2018-19','2019-03-18','University Exam Form','EXAM RECEIPT','Sachin  Kumar  Singh','Cash','30','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153816,'AES-E-3936-MBA-2018-19','2019-03-18','University Exam Fee','EXAM RECEIPT','Sachin  Kumar  Singh','Cash','1590','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153817,'AES-E-3936-MBA-2018-19','2019-03-18','St. Of Marks Fee','EXAM RECEIPT','Sachin  Kumar  Singh','Cash','145','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153818,'AES-E-3936-MBA-2018-19','2019-03-18','C.A.P. Fee','EXAM RECEIPT','Sachin  Kumar  Singh','Cash','290','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153819,'AES-E-3936-MBA-2018-19','2019-03-18','Project Fee','EXAM RECEIPT','Sachin  Kumar  Singh','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153820,'AES-E-3936-MBA-2018-19','2019-03-18','Passing Certificate Fee','EXAM RECEIPT','Sachin  Kumar  Singh','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153821,'AES-E-3936-MBA-2018-19','2019-03-18','Internal Marks Fee','EXAM RECEIPT','Sachin  Kumar  Singh','Cash','180','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153822,'AES-E-3936-MBA-2018-19','2019-03-18','Late Fee','EXAM RECEIPT','Sachin  Kumar  Singh','Cash','150','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153823,'AES-E-3936-MBA-2018-19','2019-03-18','Supper Late Fee','EXAM RECEIPT','Sachin  Kumar  Singh','Cash','0','Vishal','',NULL,NULL,NULL,'2385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153824,'AES-E-3937-MBA-2018-19','2019-03-18','University Exam Form','EXAM RECEIPT','Gaurav  Krishna  Davari','Cash','30','Vishal','',NULL,NULL,NULL,'3615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153825,'AES-E-3937-MBA-2018-19','2019-03-18','University Exam Fee','EXAM RECEIPT','Gaurav  Krishna  Davari','Cash','1820','Vishal','',NULL,NULL,NULL,'3615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153826,'AES-E-3937-MBA-2018-19','2019-03-18','St. Of Marks Fee','EXAM RECEIPT','Gaurav  Krishna  Davari','Cash','145','Vishal','',NULL,NULL,NULL,'3615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153827,'AES-E-3937-MBA-2018-19','2019-03-18','C.A.P. Fee','EXAM RECEIPT','Gaurav  Krishna  Davari','Cash','290','Vishal','',NULL,NULL,NULL,'3615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153828,'AES-E-3937-MBA-2018-19','2019-03-18','Project Fee','EXAM RECEIPT','Gaurav  Krishna  Davari','Cash','0','Vishal','',NULL,NULL,NULL,'3615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153829,'AES-E-3937-MBA-2018-19','2019-03-18','Passing Certificate Fee','EXAM RECEIPT','Gaurav  Krishna  Davari','Cash','0','Vishal','',NULL,NULL,NULL,'3615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153830,'AES-E-3937-MBA-2018-19','2019-03-18','Internal Marks Fee','EXAM RECEIPT','Gaurav  Krishna  Davari','Cash','180','Vishal','',NULL,NULL,NULL,'3615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153831,'AES-E-3937-MBA-2018-19','2019-03-18','Late Fee','EXAM RECEIPT','Gaurav  Krishna  Davari','Cash','150','Vishal','',NULL,NULL,NULL,'3615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153832,'AES-E-3937-MBA-2018-19','2019-03-18','Supper Late Fee','EXAM RECEIPT','Gaurav  Krishna  Davari','Cash','1000','Vishal','',NULL,NULL,NULL,'3615','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153833,'AES-E-3938-MBA-2018-19','2019-03-18','University Exam Form','EXAM RECEIPT','Suraj  Sampat  Borde','Cash','30','Vishal','',NULL,NULL,NULL,'2465','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153834,'AES-E-3938-MBA-2018-19','2019-03-18','University Exam Fee','EXAM RECEIPT','Suraj  Sampat  Borde','Cash','680','Vishal','',NULL,NULL,NULL,'2465','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153835,'AES-E-3938-MBA-2018-19','2019-03-18','St. Of Marks Fee','EXAM RECEIPT','Suraj  Sampat  Borde','Cash','145','Vishal','',NULL,NULL,NULL,'2465','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153836,'AES-E-3938-MBA-2018-19','2019-03-18','C.A.P. Fee','EXAM RECEIPT','Suraj  Sampat  Borde','Cash','145','Vishal','',NULL,NULL,NULL,'2465','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153837,'AES-E-3938-MBA-2018-19','2019-03-18','Project Fee','EXAM RECEIPT','Suraj  Sampat  Borde','Cash','1020','Vishal','',NULL,NULL,NULL,'2465','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153838,'AES-E-3938-MBA-2018-19','2019-03-18','Passing Certificate Fee','EXAM RECEIPT','Suraj  Sampat  Borde','Cash','145','Vishal','',NULL,NULL,NULL,'2465','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153839,'AES-E-3938-MBA-2018-19','2019-03-18','Internal Marks Fee','EXAM RECEIPT','Suraj  Sampat  Borde','Cash','150','Vishal','',NULL,NULL,NULL,'2465','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153840,'AES-E-3938-MBA-2018-19','2019-03-18','Late Fee','EXAM RECEIPT','Suraj  Sampat  Borde','Cash','150','Vishal','',NULL,NULL,NULL,'2465','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153841,'AES-E-3938-MBA-2018-19','2019-03-18','Supper Late Fee','EXAM RECEIPT','Suraj  Sampat  Borde','Cash','0','Vishal','',NULL,NULL,NULL,'2465','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153842,'AES-E-3939-MBA-2018-19','2019-03-18','University Exam Form','EXAM RECEIPT','Devendra  Sampat  Borde','Cash','30','Vishal','',NULL,NULL,NULL,'1935','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153843,'AES-E-3939-MBA-2018-19','2019-03-18','University Exam Fee','EXAM RECEIPT','Devendra  Sampat  Borde','Cash','1140','Vishal','',NULL,NULL,NULL,'1935','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153844,'AES-E-3939-MBA-2018-19','2019-03-18','St. Of Marks Fee','EXAM RECEIPT','Devendra  Sampat  Borde','Cash','145','Vishal','',NULL,NULL,NULL,'1935','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153845,'AES-E-3939-MBA-2018-19','2019-03-18','C.A.P. Fee','EXAM RECEIPT','Devendra  Sampat  Borde','Cash','290','Vishal','',NULL,NULL,NULL,'1935','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153846,'AES-E-3939-MBA-2018-19','2019-03-18','Project Fee','EXAM RECEIPT','Devendra  Sampat  Borde','Cash','0','Vishal','',NULL,NULL,NULL,'1935','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153847,'AES-E-3939-MBA-2018-19','2019-03-18','Passing Certificate Fee','EXAM RECEIPT','Devendra  Sampat  Borde','Cash','0','Vishal','',NULL,NULL,NULL,'1935','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153848,'AES-E-3939-MBA-2018-19','2019-03-18','Internal Marks Fee','EXAM RECEIPT','Devendra  Sampat  Borde','Cash','180','Vishal','',NULL,NULL,NULL,'1935','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153849,'AES-E-3939-MBA-2018-19','2019-03-18','Late Fee','EXAM RECEIPT','Devendra  Sampat  Borde','Cash','150','Vishal','',NULL,NULL,NULL,'1935','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153850,'AES-E-3939-MBA-2018-19','2019-03-18','Supper Late Fee','EXAM RECEIPT','Devendra  Sampat  Borde','Cash','0','Vishal','',NULL,NULL,NULL,'1935','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153851,'AES-F-3493-2018-19','2019-03-18','Tution Fee','Government Fee Receipt','Ashwini Dilip Nangare','Scholorship','19433','EBC','18191201827',0,'','','19433','FIRST','2018-19','FIRSTMBA',' ','fee_receipt_counter',' ',' '),
 (153852,'AES-F-3493-2018-19','2019-03-18',' Developement Fee','Government Fee Receipt','Ashwini Dilip Nangare','Scholorship',' 0','EBC','18191201827',0,'','','19433','FIRST','2018-19','FIRSTMBA',' ',' fee_receipt_counter',' ',' '),
 (153853,'AES-F-3493-2018-19','2019-03-18',' interim Fee','Government Fee Receipt','Ashwini Dilip Nangare','Scholorship',' 0','EBC','18191201827',0,'','','19433','FIRST','2018-19','FIRSTMBA',' ',' fee_receipt_counter',' ',' '),
 (153854,'AES-F-3494-2018-19','2019-03-18','Tution Fee','Government Fee Receipt','Kailas Maruti Khandale','Scholorship','19433','EBC','18191201837',0,'','','19433','FIRST','2018-19','FIRSTMBA',' ','fee_receipt_counter',' ',' '),
 (153855,'AES-F-3494-2018-19','2019-03-18',' Developement Fee','Government Fee Receipt','Kailas Maruti Khandale','Scholorship',' 0','EBC','18191201837',0,'','','19433','FIRST','2018-19','FIRSTMBA',' ',' fee_receipt_counter',' ',' '),
 (153856,'AES-F-3494-2018-19','2019-03-18',' interim Fee','Government Fee Receipt','Kailas Maruti Khandale','Scholorship',' 0','EBC','18191201837',0,'','','19433','FIRST','2018-19','FIRSTMBA',' ',' fee_receipt_counter',' ',' '),
 (153857,'AES-F-3495-2018-19','2019-03-18','Developement Fee','Fee Receipt','Swati Lahu Bhosale','Cheque','0','EBCBankOfMaharastra','17181242',NULL,'BankofMaharastra','965798','12863','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153858,'AES-F-3495-2018-19','2019-03-18','interim Fee','Fee Receipt','Swati Lahu Bhosale','Cheque','0','EBCBankOfMaharastra','17181242',NULL,'BankofMaharastra','965798','12863','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153859,'AES-F-3495-2018-19','2019-03-18','Tution Fee','Fee Receipt','Swati Lahu Bhosale','Cheque','12863','EBCBankOfMaharastra','17181242',NULL,'BankofMaharastra','965798','12863','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153860,'AES-F-3496-2018-19','2019-03-18','Developement Fee','Fee Receipt','Priyanka Shashikant kedge','Cheque','0','EBCBankOfMaharastra','18191201842',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153861,'AES-F-3496-2018-19','2019-03-18','interim Fee','Fee Receipt','Priyanka Shashikant kedge','Cheque','0','EBCBankOfMaharastra','18191201842',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153862,'AES-F-3496-2018-19','2019-03-18','Tution Fee','Fee Receipt','Priyanka Shashikant kedge','Cheque','19433','EBCBankOfMaharastra','18191201842',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153863,'AES-F-3497-2018-19','2019-03-15','Developement Fee','Fee Receipt','Sagar  Shankarrao Khurd','Cheque','0','BankOfMaharasta','17181455',NULL,'BankofMaharastra','426575','10000','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153864,'AES-F-3497-2018-19','2019-03-15','interim Fee','Fee Receipt','Sagar  Shankarrao Khurd','Cheque','0','BankOfMaharasta','17181455',NULL,'BankofMaharastra','426575','10000','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153865,'AES-F-3497-2018-19','2019-03-15','Tution Fee','Fee Receipt','Sagar  Shankarrao Khurd','Cheque','10000','BankOfMaharasta','17181455',NULL,'BankofMaharastra','426575','10000','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153866,'AES-E-3940-MBA-2018-19','2019-03-25','University Exam Form','EXAM RECEIPT','Santoshi  Vitthalrao  Solapure','Cash','30','Vishal','',NULL,NULL,NULL,'4385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153867,'AES-E-3940-MBA-2018-19','2019-03-25','University Exam Fee','EXAM RECEIPT','Santoshi  Vitthalrao  Solapure','Cash','1590','Vishal','',NULL,NULL,NULL,'4385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153868,'AES-E-3940-MBA-2018-19','2019-03-25','St. Of Marks Fee','EXAM RECEIPT','Santoshi  Vitthalrao  Solapure','Cash','145','Vishal','',NULL,NULL,NULL,'4385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153869,'AES-E-3940-MBA-2018-19','2019-03-25','C.A.P. Fee','EXAM RECEIPT','Santoshi  Vitthalrao  Solapure','Cash','290','Vishal','',NULL,NULL,NULL,'4385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153870,'AES-E-3940-MBA-2018-19','2019-03-25','Project Fee','EXAM RECEIPT','Santoshi  Vitthalrao  Solapure','Cash','0','Vishal','',NULL,NULL,NULL,'4385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153871,'AES-E-3940-MBA-2018-19','2019-03-25','Passing Certificate Fee','EXAM RECEIPT','Santoshi  Vitthalrao  Solapure','Cash','0','Vishal','',NULL,NULL,NULL,'4385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153872,'AES-E-3940-MBA-2018-19','2019-03-25','Internal Marks Fee','EXAM RECEIPT','Santoshi  Vitthalrao  Solapure','Cash','180','Vishal','',NULL,NULL,NULL,'4385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153873,'AES-E-3940-MBA-2018-19','2019-03-25','Late Fee','EXAM RECEIPT','Santoshi  Vitthalrao  Solapure','Cash','150','Vishal','',NULL,NULL,NULL,'4385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153874,'AES-E-3940-MBA-2018-19','2019-03-25','Supper Late Fee','EXAM RECEIPT','Santoshi  Vitthalrao  Solapure','Cash','2000','Vishal','',NULL,NULL,NULL,'4385','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153875,'AES-E-3941-MBA-2018-19','2019-03-25','University Exam Form','EXAM RECEIPT','Sagar  Rohidas  Rathod','Cash','30','Vishal','',NULL,NULL,NULL,'5075','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153876,'AES-E-3941-MBA-2018-19','2019-03-25','University Exam Fee','EXAM RECEIPT','Sagar  Rohidas  Rathod','Cash','2280','Vishal','',NULL,NULL,NULL,'5075','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153877,'AES-E-3941-MBA-2018-19','2019-03-25','St. Of Marks Fee','EXAM RECEIPT','Sagar  Rohidas  Rathod','Cash','145','Vishal','',NULL,NULL,NULL,'5075','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153878,'AES-E-3941-MBA-2018-19','2019-03-25','C.A.P. Fee','EXAM RECEIPT','Sagar  Rohidas  Rathod','Cash','290','Vishal','',NULL,NULL,NULL,'5075','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153879,'AES-E-3941-MBA-2018-19','2019-03-25','Project Fee','EXAM RECEIPT','Sagar  Rohidas  Rathod','Cash','0','Vishal','',NULL,NULL,NULL,'5075','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153880,'AES-E-3941-MBA-2018-19','2019-03-25','Passing Certificate Fee','EXAM RECEIPT','Sagar  Rohidas  Rathod','Cash','0','Vishal','',NULL,NULL,NULL,'5075','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153881,'AES-E-3941-MBA-2018-19','2019-03-25','Internal Marks Fee','EXAM RECEIPT','Sagar  Rohidas  Rathod','Cash','180','Vishal','',NULL,NULL,NULL,'5075','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153882,'AES-E-3941-MBA-2018-19','2019-03-25','Late Fee','EXAM RECEIPT','Sagar  Rohidas  Rathod','Cash','150','Vishal','',NULL,NULL,NULL,'5075','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153883,'AES-E-3941-MBA-2018-19','2019-03-25','Supper Late Fee','EXAM RECEIPT','Sagar  Rohidas  Rathod','Cash','2000','Vishal','',NULL,NULL,NULL,'5075','First','2018-19','FIRSTMBA',NULL,NULL,NULL,'R'),
 (153884,'AES-E-3942-MBA-2018-19','2019-03-25','University Exam Form','EXAM RECEIPT','Devilal  Mhasu  Aher','Cash','30','Vishal','',NULL,NULL,NULL,'1700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153885,'AES-E-3942-MBA-2018-19','2019-03-25','University Exam Fee','EXAM RECEIPT','Devilal  Mhasu  Aher','Cash','230','Vishal','',NULL,NULL,NULL,'1700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153886,'AES-E-3942-MBA-2018-19','2019-03-25','St. Of Marks Fee','EXAM RECEIPT','Devilal  Mhasu  Aher','Cash','145','Vishal','',NULL,NULL,NULL,'1700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153887,'AES-E-3942-MBA-2018-19','2019-03-25','C.A.P. Fee','EXAM RECEIPT','Devilal  Mhasu  Aher','Cash','145','Vishal','',NULL,NULL,NULL,'1700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153888,'AES-E-3942-MBA-2018-19','2019-03-25','Project Fee','EXAM RECEIPT','Devilal  Mhasu  Aher','Cash','0','Vishal','',NULL,NULL,NULL,'1700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153889,'AES-E-3942-MBA-2018-19','2019-03-25','Passing Certificate Fee','EXAM RECEIPT','Devilal  Mhasu  Aher','Cash','0','Vishal','',NULL,NULL,NULL,'1700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153890,'AES-E-3942-MBA-2018-19','2019-03-25','Internal Marks Fee','EXAM RECEIPT','Devilal  Mhasu  Aher','Cash','0','Vishal','',NULL,NULL,NULL,'1700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153891,'AES-E-3942-MBA-2018-19','2019-03-25','Late Fee','EXAM RECEIPT','Devilal  Mhasu  Aher','Cash','150','Vishal','',NULL,NULL,NULL,'1700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153892,'AES-E-3942-MBA-2018-19','2019-03-25','Supper Late Fee','EXAM RECEIPT','Devilal  Mhasu  Aher','Cash','1000','Vishal','',NULL,NULL,NULL,'1700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153893,'AES-F-3498-2018-19','2019-03-26','Developement Fee','Fee Receipt','Vinayak Maruti Pwar','Cheque','0','BankOfMaharasta','18191201806',NULL,'BankofMaharastra','34869','10000','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153894,'AES-F-3498-2018-19','2019-03-26','interim Fee','Fee Receipt','Vinayak Maruti Pwar','Cheque','0','BankOfMaharasta','18191201806',NULL,'BankofMaharastra','34869','10000','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153895,'AES-F-3498-2018-19','2019-03-26','Tution Fee','Fee Receipt','Vinayak Maruti Pwar','Cheque','10000','BankOfMaharasta','18191201806',NULL,'BankofMaharastra','34869','10000','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153896,'AES-F-3499-2017-18','2019-03-25','Developement Fee','Fee Receipt','Junaidaalam Mazhar Khan','Cheque','0','BankOfMaharasta','16171176',NULL,'BankofMaharastra','665813','25000','Second','2017-18','SECONDMBA2017-18','Regular','fee_receipt_counter',' ',' '),
 (153897,'AES-F-3499-2017-18','2019-03-25','interim Fee','Fee Receipt','Junaidaalam Mazhar Khan','Cheque','0','BankOfMaharasta','16171176',NULL,'BankofMaharastra','665813','25000','Second','2017-18','SECONDMBA2017-18','Regular','fee_receipt_counter',' ',' '),
 (153898,'AES-F-3499-2017-18','2019-03-25','Tution Fee','Fee Receipt','Junaidaalam Mazhar Khan','Cheque','25000','BankOfMaharasta','16171176',NULL,'BankofMaharastra','665813','25000','Second','2017-18','SECONDMBA2017-18','Regular','fee_receipt_counter',' ',' '),
 (153899,'AES-E-3943-MBA-2018-19','2019-03-26','University Exam Form','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'25000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153900,'AES-E-3943-MBA-2018-19','2019-03-26','University Exam Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'25000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153901,'AES-E-3943-MBA-2018-19','2019-03-26','St. Of Marks Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'25000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R');
INSERT INTO `receipt_info` (`receipt_info_id`, `receipt_number`, `receipt_date`, `receipt_type`, `particulars`, `paid_by`, `payment_type`, `amount`, `received_by`, `s_personal_info_id`, `fee_info_id`, `bank`, `chq_dd_no`, `ptotal`, `s_standard`, `s_academic_year`, `bus_stop_name`, `stop_from`, `stop_to`, `status`, `cash_amount`) VALUES
 (153902,'AES-E-3943-MBA-2018-19','2019-03-26','C.A.P. Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','25000','Accounts','',NULL,NULL,NULL,'25000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153903,'AES-E-3943-MBA-2018-19','2019-03-26','Project Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'25000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153904,'AES-E-3943-MBA-2018-19','2019-03-26','Passing Certificate Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'25000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153905,'AES-E-3943-MBA-2018-19','2019-03-26','Internal Marks Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'25000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153906,'AES-E-3943-MBA-2018-19','2019-03-26','Late Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'25000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153907,'AES-E-3943-MBA-2018-19','2019-03-26','Supper Late Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'25000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153908,'AES-E-3944-MBA-2018-19','2019-03-26','University Exam Form','EXAM RECEIPT','Dashrath  Bikhu  Bhoite','Cash','0','Accounts','',NULL,NULL,NULL,'10000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153909,'AES-E-3944-MBA-2018-19','2019-03-26','University Exam Fee','EXAM RECEIPT','Dashrath  Bikhu  Bhoite','Cash','0','Accounts','',NULL,NULL,NULL,'10000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153910,'AES-E-3944-MBA-2018-19','2019-03-26','St. Of Marks Fee','EXAM RECEIPT','Dashrath  Bikhu  Bhoite','Cash','0','Accounts','',NULL,NULL,NULL,'10000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153911,'AES-E-3944-MBA-2018-19','2019-03-26','C.A.P. Fee','EXAM RECEIPT','Dashrath  Bikhu  Bhoite','Cash','10000','Accounts','',NULL,NULL,NULL,'10000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153912,'AES-E-3944-MBA-2018-19','2019-03-26','Project Fee','EXAM RECEIPT','Dashrath  Bikhu  Bhoite','Cash','0','Accounts','',NULL,NULL,NULL,'10000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153913,'AES-E-3944-MBA-2018-19','2019-03-26','Passing Certificate Fee','EXAM RECEIPT','Dashrath  Bikhu  Bhoite','Cash','0','Accounts','',NULL,NULL,NULL,'10000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153914,'AES-E-3944-MBA-2018-19','2019-03-26','Internal Marks Fee','EXAM RECEIPT','Dashrath  Bikhu  Bhoite','Cash','0','Accounts','',NULL,NULL,NULL,'10000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153915,'AES-E-3944-MBA-2018-19','2019-03-26','Late Fee','EXAM RECEIPT','Dashrath  Bikhu  Bhoite','Cash','0','Accounts','',NULL,NULL,NULL,'10000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153916,'AES-E-3944-MBA-2018-19','2019-03-26','Supper Late Fee','EXAM RECEIPT','Dashrath  Bikhu  Bhoite','Cash','0','Accounts','',NULL,NULL,NULL,'10000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153917,'AES-F-3500-2018-19','2019-03-26','Developement Fee','Fee Receipt','Devendra Sampatrao Borde','Cheque','7268','BankOfMaharasta','18191201808',NULL,'BankofMaharastra','965798','20000','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153918,'AES-F-3500-2018-19','2019-03-26','interim Fee','Fee Receipt','Devendra Sampatrao Borde','Cheque','0','BankOfMaharasta','18191201808',NULL,'BankofMaharastra','965798','20000','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153919,'AES-F-3500-2018-19','2019-03-26','Tution Fee','Fee Receipt','Devendra Sampatrao Borde','Cheque','12732','BankOfMaharasta','18191201808',NULL,'BankofMaharastra','965798','20000','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153920,'AES-F-3501-2018-19','2019-03-27','Developement Fee','Fee Receipt','Mayur Kisan Bhargude','Cheque','0','BankOfMaharasta','18191201812',NULL,'BankofMaharastra','965798','5134','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153921,'AES-F-3501-2018-19','2019-03-27','interim Fee','Fee Receipt','Mayur Kisan Bhargude','Cheque','0','BankOfMaharasta','18191201812',NULL,'BankofMaharastra','965798','5134','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153922,'AES-F-3501-2018-19','2019-03-27','Tution Fee','Fee Receipt','Mayur Kisan Bhargude','Cheque','5134','BankOfMaharasta','18191201812',NULL,'BankofMaharastra','965798','5134','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153923,'AES-F-3502-2018-19','2019-03-28','Developement Fee','Fee Receipt','Chitrali Dnyandev Ingale','Cheque','0','BankOfMaharasta','17181233',NULL,'BankofMaharastra','012548','20872','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153924,'AES-F-3502-2018-19','2019-03-28','interim Fee','Fee Receipt','Chitrali Dnyandev Ingale','Cheque','0','BankOfMaharasta','17181233',NULL,'BankofMaharastra','012548','20872','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153925,'AES-F-3502-2018-19','2019-03-28','Tution Fee','Fee Receipt','Chitrali Dnyandev Ingale','Cheque','20872','BankOfMaharasta','17181233',NULL,'BankofMaharastra','012548','20872','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153926,'AES-E-3945-MBA-2018-19','2019-04-09','University Exam Form','EXAM RECEIPT','Vijaykumar  Shivananad  Rathod','Cash','30','Vishal','',NULL,NULL,NULL,'3700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153927,'AES-E-3945-MBA-2018-19','2019-04-09','University Exam Fee','EXAM RECEIPT','Vijaykumar  Shivananad  Rathod','Cash','230','Vishal','',NULL,NULL,NULL,'3700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153928,'AES-E-3945-MBA-2018-19','2019-04-09','St. Of Marks Fee','EXAM RECEIPT','Vijaykumar  Shivananad  Rathod','Cash','145','Vishal','',NULL,NULL,NULL,'3700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153929,'AES-E-3945-MBA-2018-19','2019-04-09','C.A.P. Fee','EXAM RECEIPT','Vijaykumar  Shivananad  Rathod','Cash','145','Vishal','',NULL,NULL,NULL,'3700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153930,'AES-E-3945-MBA-2018-19','2019-04-09','Project Fee','EXAM RECEIPT','Vijaykumar  Shivananad  Rathod','Cash','0','Vishal','',NULL,NULL,NULL,'3700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153931,'AES-E-3945-MBA-2018-19','2019-04-09','Passing Certificate Fee','EXAM RECEIPT','Vijaykumar  Shivananad  Rathod','Cash','0','Vishal','',NULL,NULL,NULL,'3700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153932,'AES-E-3945-MBA-2018-19','2019-04-09','Internal Marks Fee','EXAM RECEIPT','Vijaykumar  Shivananad  Rathod','Cash','0','Vishal','',NULL,NULL,NULL,'3700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153933,'AES-E-3945-MBA-2018-19','2019-04-09','Late Fee','EXAM RECEIPT','Vijaykumar  Shivananad  Rathod','Cash','150','Vishal','',NULL,NULL,NULL,'3700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153934,'AES-E-3945-MBA-2018-19','2019-04-09','Supper Late Fee','EXAM RECEIPT','Vijaykumar  Shivananad  Rathod','Cash','3000','Vishal','',NULL,NULL,NULL,'3700','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (153935,'AES-F-3503-2018-19','2019-04-10','Developement Fee','Fee Receipt','Shubham  Diliprao Choudhari','Cheque','0','BankOfMaharasta','18191201823',NULL,'BankofMaharastra','081156','10000','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153936,'AES-F-3503-2018-19','2019-04-10','interim Fee','Fee Receipt','Shubham  Diliprao Choudhari','Cheque','0','BankOfMaharasta','18191201823',NULL,'BankofMaharastra','081156','10000','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153937,'AES-F-3503-2018-19','2019-04-10','Tution Fee','Fee Receipt','Shubham  Diliprao Choudhari','Cheque','10000','BankOfMaharasta','18191201823',NULL,'BankofMaharastra','081156','10000','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153938,'AES-F-3504-2018-19','2019-04-10','Developement Fee','Fee Receipt','Ganesh Suresh Jadhav','Cheque','0','BankOfMaharasta','17181150',NULL,'StateBankOfIndia','086474','15872','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153939,'AES-F-3504-2018-19','2019-04-10','interim Fee','Fee Receipt','Ganesh Suresh Jadhav','Cheque','0','BankOfMaharasta','17181150',NULL,'StateBankOfIndia','086474','15872','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153940,'AES-F-3504-2018-19','2019-04-10','Tution Fee','Fee Receipt','Ganesh Suresh Jadhav','Cheque','15872','BankOfMaharasta','17181150',NULL,'StateBankOfIndia','086474','15872','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153941,'AES-F-3505-2018-19','2019-04-10','Tution Fee','Government Fee Receipt','Ankit Sunil Shaha','Cheque','0','EBC','17181164',0,'CentralBankofIndia','063222','15000','Second','2018-19','SECONDMBA2018-19',' ','fee_receipt_counter',' ',' '),
 (153942,'AES-F-3505-2018-19','2019-04-10',' Developement Fee','Government Fee Receipt','Ankit Sunil Shaha','Cheque',' 0','EBC','17181164',0,'CentralBankofIndia','063222','15000','Second','2018-19','SECONDMBA2018-19',' ',' fee_receipt_counter',' ',' '),
 (153943,'AES-F-3505-2018-19','2019-04-10',' interim Fee','Government Fee Receipt','Ankit Sunil Shaha','Cheque',' 15000','EBC','17181164',0,'CentralBankofIndia','063222','15000','Second','2018-19','SECONDMBA2018-19',' ',' fee_receipt_counter',' ',' '),
 (153944,'AES-F-3506-2018-19','2019-04-10','Developement Fee','Fee Receipt','Mithun Eknath Bhilare','Cheque','0','BankOfMaharasta','17181240',NULL,'BanOfBaroda','000069','15672','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153945,'AES-F-3506-2018-19','2019-04-10','interim Fee','Fee Receipt','Mithun Eknath Bhilare','Cheque','0','BankOfMaharasta','17181240',NULL,'BanOfBaroda','000069','15672','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153946,'AES-F-3506-2018-19','2019-04-10','Tution Fee','Fee Receipt','Mithun Eknath Bhilare','Cheque','15672','BankOfMaharasta','17181240',NULL,'BanOfBaroda','000069','15672','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153947,'AES-F-3507-2018-19','2019-04-10','Developement Fee','Fee Receipt','Pranali Parshuram Dumbare','Cheque','0','BankOfMaharasta','17181407',NULL,'IciciBank','012774','10000','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153948,'AES-F-3507-2018-19','2019-04-10','interim Fee','Fee Receipt','Pranali Parshuram Dumbare','Cheque','0','BankOfMaharasta','17181407',NULL,'IciciBank','012774','10000','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153949,'AES-F-3507-2018-19','2019-04-10','Tution Fee','Fee Receipt','Pranali Parshuram Dumbare','Cheque','10000','BankOfMaharasta','17181407',NULL,'IciciBank','012774','10000','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153950,'AES-F-3508-2018-19','2019-05-06','Developement Fee','Fee Receipt','Mayur Vishnu Kumbhar','Cheque','0','PuneUrban','17181097',NULL,'PuneUrban','30299','6000','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153951,'AES-F-3508-2018-19','2019-05-06','interim Fee','Fee Receipt','Mayur Vishnu Kumbhar','Cheque','0','PuneUrban','17181097',NULL,'PuneUrban','30299','6000','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153952,'AES-F-3508-2018-19','2019-05-06','Tution Fee','Fee Receipt','Mayur Vishnu Kumbhar','Cheque','6000','PuneUrban','17181097',NULL,'PuneUrban','30299','6000','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153953,'AES-F-3509-2018-19','2019-05-06','Developement Fee','Fee Receipt','Prajakta Sanjay Bhosale','Cheque','0','BankOfMaharasta','18191201820',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153954,'AES-F-3509-2018-19','2019-05-06','interim Fee','Fee Receipt','Prajakta Sanjay Bhosale','Cheque','0','BankOfMaharasta','18191201820',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153955,'AES-F-3509-2018-19','2019-05-06','Tution Fee','Fee Receipt','Prajakta Sanjay Bhosale','Cheque','19433','BankOfMaharasta','18191201820',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153956,'AES-F-3510-2018-19','2019-05-06','Developement Fee','Fee Receipt','Ganesh Suresh Jadhav','Cheque','0','BankOfMaharasta','17181150',NULL,'BankofMaharastra','965798','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153957,'AES-F-3510-2018-19','2019-05-06','interim Fee','Fee Receipt','Ganesh Suresh Jadhav','Cheque','0','BankOfMaharasta','17181150',NULL,'BankofMaharastra','965798','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153958,'AES-F-3510-2018-19','2019-05-06','Tution Fee','Fee Receipt','Ganesh Suresh Jadhav','Cheque','12864','BankOfMaharasta','17181150',NULL,'BankofMaharastra','965798','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153959,'AES-F-3511-2018-19','2019-05-06','Developement Fee','Fee Receipt','Mithun Eknath Bhilare','Cheque','0','EBCBankOfMaharastra','17181240',NULL,'BankofMaharastra','965798','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153960,'AES-F-3511-2018-19','2019-05-06','interim Fee','Fee Receipt','Mithun Eknath Bhilare','Cheque','0','EBCBankOfMaharastra','17181240',NULL,'BankofMaharastra','965798','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153961,'AES-F-3511-2018-19','2019-05-06','Tution Fee','Fee Receipt','Mithun Eknath Bhilare','Cheque','12864','EBCBankOfMaharastra','17181240',NULL,'BankofMaharastra','965798','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153962,'AES-F-3512-2018-19','2019-05-06','Developement Fee','Fee Receipt','Shubham  Diliprao Choudhari','Cheque','0','EBCBankOfMaharastra','18191201823',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153963,'AES-F-3512-2018-19','2019-05-06','interim Fee','Fee Receipt','Shubham  Diliprao Choudhari','Cheque','0','EBCBankOfMaharastra','18191201823',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153964,'AES-F-3512-2018-19','2019-05-06','Tution Fee','Fee Receipt','Shubham  Diliprao Choudhari','Cheque','19433','EBCBankOfMaharastra','18191201823',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153965,'AES-F-3513-2018-19','2019-04-20','Developement Fee','Fee Receipt','Shubham  Diliprao Choudhari','Cheque','0','EBCBankOfMaharastra','18191201823',NULL,'BankofMaharastra','9008','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153966,'AES-F-3513-2018-19','2019-04-20','interim Fee','Fee Receipt','Shubham  Diliprao Choudhari','Cheque','0','EBCBankOfMaharastra','18191201823',NULL,'BankofMaharastra','9008','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153967,'AES-F-3513-2018-19','2019-04-20','Tution Fee','Fee Receipt','Shubham  Diliprao Choudhari','Cheque','19433','EBCBankOfMaharastra','18191201823',NULL,'BankofMaharastra','9008','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153968,'AES-F-3514-2018-19','2019-05-20','Developement Fee','Fee Receipt','Ankit Sunil Shaha','Cheque','0','EBCBankOfMaharastra','17181164',NULL,'BankofMaharastra','87333','12863','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153969,'AES-F-3514-2018-19','2019-05-20','interim Fee','Fee Receipt','Ankit Sunil Shaha','Cheque','0','EBCBankOfMaharastra','17181164',NULL,'BankofMaharastra','87333','12863','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153970,'AES-F-3514-2018-19','2019-05-20','Tution Fee','Fee Receipt','Ankit Sunil Shaha','Cheque','12863','EBCBankOfMaharastra','17181164',NULL,'BankofMaharastra','87333','12863','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153971,'AES-F-3515-2018-19','2019-04-15','Developement Fee','Fee Receipt','Rekha Sahebrao Jadhav','Cheque','0','EBCBankOfMaharastra','18191201838',NULL,'BankofMaharastra','47521','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153972,'AES-F-3515-2018-19','2019-04-15','interim Fee','Fee Receipt','Rekha Sahebrao Jadhav','Cheque','0','EBCBankOfMaharastra','18191201838',NULL,'BankofMaharastra','47521','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153973,'AES-F-3515-2018-19','2019-04-15','Tution Fee','Fee Receipt','Rekha Sahebrao Jadhav','Cheque','19433','EBCBankOfMaharastra','18191201838',NULL,'BankofMaharastra','47521','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153974,'AES-F-3516-2018-19','2019-04-22','Developement Fee','Fee Receipt','Vinayak Maruti Pwar','Cheque','0','EBCBankOfMaharastra','18191201806',NULL,'BankofMaharastra','52803','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153975,'AES-F-3516-2018-19','2019-04-22','interim Fee','Fee Receipt','Vinayak Maruti Pwar','Cheque','0','EBCBankOfMaharastra','18191201806',NULL,'BankofMaharastra','52803','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153976,'AES-F-3516-2018-19','2019-04-22','Tution Fee','Fee Receipt','Vinayak Maruti Pwar','Cheque','19433','EBCBankOfMaharastra','18191201806',NULL,'BankofMaharastra','52803','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153977,'AES-F-3517-2018-19','2019-04-22','Developement Fee','Fee Receipt','suraj  Sampat Borade','Cheque','0','EBCBankOfMaharastra','181910001',NULL,'BankofMaharastra','12564','12864','SECOND','2018-19','SECONDMBA','New','fee_receipt_counter',' ',' '),
 (153978,'AES-F-3517-2018-19','2019-04-22','interim Fee','Fee Receipt','suraj  Sampat Borade','Cheque','0','EBCBankOfMaharastra','181910001',NULL,'BankofMaharastra','12564','12864','SECOND','2018-19','SECONDMBA','New','fee_receipt_counter',' ',' '),
 (153979,'AES-F-3517-2018-19','2019-04-22','Tution Fee','Fee Receipt','suraj  Sampat Borade','Cheque','12864','EBCBankOfMaharastra','181910001',NULL,'BankofMaharastra','12564','12864','SECOND','2018-19','SECONDMBA','New','fee_receipt_counter',' ',' '),
 (153980,'AES-F-3518-2018-19','2019-04-22','Developement Fee','Fee Receipt','Mithun Eknath Bhilare','Cheque','0','EBCBankOfMaharastra','17181240',NULL,'BankofMaharastra','36616','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153981,'AES-F-3518-2018-19','2019-04-22','interim Fee','Fee Receipt','Mithun Eknath Bhilare','Cheque','0','EBCBankOfMaharastra','17181240',NULL,'BankofMaharastra','36616','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153982,'AES-F-3518-2018-19','2019-04-22','Tution Fee','Fee Receipt','Mithun Eknath Bhilare','Cheque','12864','EBCBankOfMaharastra','17181240',NULL,'BankofMaharastra','36616','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153983,'AES-F-3519-2018-19','2019-04-30','Developement Fee','Fee Receipt','Priyanka Shashikant kedge','Cheque','0','EBCBankOfMaharastra','18191201842',NULL,'BankofMaharastra','15550','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153984,'AES-F-3519-2018-19','2019-04-30','interim Fee','Fee Receipt','Priyanka Shashikant kedge','Cheque','0','EBCBankOfMaharastra','18191201842',NULL,'BankofMaharastra','15550','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153985,'AES-F-3519-2018-19','2019-04-30','Tution Fee','Fee Receipt','Priyanka Shashikant kedge','Cheque','19433','EBCBankOfMaharastra','18191201842',NULL,'BankofMaharastra','15550','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153986,'AES-F-3520-2018-19','2019-04-15','Developement Fee','Fee Receipt','Abhijit Ashok Salunkhe','Cheque','0','EBCBankOfMaharastra','17181404',NULL,'BankofMaharastra','56430','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153987,'AES-F-3520-2018-19','2019-04-15','interim Fee','Fee Receipt','Abhijit Ashok Salunkhe','Cheque','0','EBCBankOfMaharastra','17181404',NULL,'BankofMaharastra','56430','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153988,'AES-F-3520-2018-19','2019-04-15','Tution Fee','Fee Receipt','Abhijit Ashok Salunkhe','Cheque','12864','EBCBankOfMaharastra','17181404',NULL,'BankofMaharastra','56430','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (153989,'AES-F-3521-2018-19','2019-05-09','Developement Fee','Fee Receipt','Pranali Parshuram Dumbare','Cheque','0','EBCBankOfMaharastra','17181407',NULL,'BankofMaharastra','67843','12863','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153990,'AES-F-3521-2018-19','2019-05-09','interim Fee','Fee Receipt','Pranali Parshuram Dumbare','Cheque','0','EBCBankOfMaharastra','17181407',NULL,'BankofMaharastra','67843','12863','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153991,'AES-F-3521-2018-19','2019-05-09','Tution Fee','Fee Receipt','Pranali Parshuram Dumbare','Cheque','12863','EBCBankOfMaharastra','17181407',NULL,'BankofMaharastra','67843','12863','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153992,'AES-F-3522-2018-19','2019-05-09','Developement Fee','Fee Receipt','Monica Vishakhadatta Jadhav','Cheque','0','EBCBankOfMaharastra','18191201821',NULL,'BankofMaharastra','40047','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153993,'AES-F-3522-2018-19','2019-05-09','interim Fee','Fee Receipt','Monica Vishakhadatta Jadhav','Cheque','0','EBCBankOfMaharastra','18191201821',NULL,'BankofMaharastra','40047','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153994,'AES-F-3522-2018-19','2019-05-09','Tution Fee','Fee Receipt','Monica Vishakhadatta Jadhav','Cheque','19433','EBCBankOfMaharastra','18191201821',NULL,'BankofMaharastra','40047','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153995,'AES-F-3523-2018-19','2019-05-07','Developement Fee','Fee Receipt','Ajay Ashok Zanjurne','Cheque','0','EBCBankOfMaharastra','17181405',NULL,'BankofMaharastra','61660','12864','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153996,'AES-F-3523-2018-19','2019-05-07','interim Fee','Fee Receipt','Ajay Ashok Zanjurne','Cheque','0','EBCBankOfMaharastra','17181405',NULL,'BankofMaharastra','61660','12864','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153997,'AES-F-3523-2018-19','2019-05-07','Tution Fee','Fee Receipt','Ajay Ashok Zanjurne','Cheque','12864','EBCBankOfMaharastra','17181405',NULL,'BankofMaharastra','61660','12864','Second','2018-19','SECONDMBA2018-19','Regular','fee_receipt_counter',' ',' '),
 (153998,'AES-F-3524-2018-19','2019-05-07','Developement Fee','Fee Receipt','Mayur Kisan Bhargude','Cheque','0','EBCBankOfMaharastra','18191201812',NULL,'BankofMaharastra','38931','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (153999,'AES-F-3524-2018-19','2019-05-07','interim Fee','Fee Receipt','Mayur Kisan Bhargude','Cheque','0','EBCBankOfMaharastra','18191201812',NULL,'BankofMaharastra','38931','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (154000,'AES-F-3524-2018-19','2019-05-07','Tution Fee','Fee Receipt','Mayur Kisan Bhargude','Cheque','19433','EBCBankOfMaharastra','18191201812',NULL,'BankofMaharastra','38931','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (154001,'AES-F-3525-2018-19','2019-05-13','Developement Fee','Fee Receipt','Kanchan  Narayan Nanaware','Cheque','0','EBCBankOfMaharastra','18191201807',NULL,'BankofMaharastra','09677','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (154002,'AES-F-3525-2018-19','2019-05-13','interim Fee','Fee Receipt','Kanchan  Narayan Nanaware','Cheque','0','EBCBankOfMaharastra','18191201807',NULL,'BankofMaharastra','09677','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (154003,'AES-F-3525-2018-19','2019-05-13','Tution Fee','Fee Receipt','Kanchan  Narayan Nanaware','Cheque','19433','EBCBankOfMaharastra','18191201807',NULL,'BankofMaharastra','09677','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (154004,'AES-F-3526-2018-19','2019-05-10','Developement Fee','Fee Receipt','Ganesh Suresh Jadhav','Cheque','0','EBCBankOfMaharastra','17181150',NULL,'BankofMaharastra','54736','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (154005,'AES-F-3526-2018-19','2019-05-10','interim Fee','Fee Receipt','Ganesh Suresh Jadhav','Cheque','0','EBCBankOfMaharastra','17181150',NULL,'BankofMaharastra','54736','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (154006,'AES-F-3526-2018-19','2019-05-10','Tution Fee','Fee Receipt','Ganesh Suresh Jadhav','Cheque','12864','EBCBankOfMaharastra','17181150',NULL,'BankofMaharastra','54736','12864','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (154007,'AES-E-3946-MBA-2018-19','2019-05-28','University Exam Form','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'20000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (154008,'AES-E-3946-MBA-2018-19','2019-05-28','University Exam Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'20000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (154009,'AES-E-3946-MBA-2018-19','2019-05-28','St. Of Marks Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'20000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (154010,'AES-E-3946-MBA-2018-19','2019-05-28','C.A.P. Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','20000','Accounts','',NULL,NULL,NULL,'20000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (154011,'AES-E-3946-MBA-2018-19','2019-05-28','Project Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'20000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (154012,'AES-E-3946-MBA-2018-19','2019-05-28','Passing Certificate Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'20000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (154013,'AES-E-3946-MBA-2018-19','2019-05-28','Internal Marks Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'20000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (154014,'AES-E-3946-MBA-2018-19','2019-05-28','Late Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'20000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (154015,'AES-E-3946-MBA-2018-19','2019-05-28','Supper Late Fee','EXAM RECEIPT','Nandkishor  Ghanshyam  Sarode','Cash','0','Accounts','',NULL,NULL,NULL,'20000','Second','2018-19','SECONDMBA',NULL,NULL,NULL,'R'),
 (154016,'AES-F-3527-2018-19','2019-05-23','Developement Fee','Fee Receipt','Akhila Aditya  Moholkar','Cheque','0','EBCBankOfMaharastra','18191201804',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (154017,'AES-F-3527-2018-19','2019-05-23','interim Fee','Fee Receipt','Akhila Aditya  Moholkar','Cheque','0','EBCBankOfMaharastra','18191201804',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (154018,'AES-F-3527-2018-19','2019-05-23','Tution Fee','Fee Receipt','Akhila Aditya  Moholkar','Cheque','19433','EBCBankOfMaharastra','18191201804',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (154019,'AES-F-3528-2018-19','2019-05-20','Developement Fee','Fee Receipt','Swati Lahu Bhosale','Cheque','0','EBCBankOfMaharastra','17181242',NULL,'BankofMaharastra','965798','12863','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (154020,'AES-F-3528-2018-19','2019-05-20','interim Fee','Fee Receipt','Swati Lahu Bhosale','Cheque','0','EBCBankOfMaharastra','17181242',NULL,'BankofMaharastra','965798','12863','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (154021,'AES-F-3528-2018-19','2019-05-20','Tution Fee','Fee Receipt','Swati Lahu Bhosale','Cheque','12863','EBCBankOfMaharastra','17181242',NULL,'BankofMaharastra','965798','12863','Second','2018-19','SECONDMBA2018-19','New','fee_receipt_counter',' ',' '),
 (154022,'AES-F-3529-2018-19','2019-05-24','Developement Fee','Fee Receipt','Rohit Shavareppa Andodgi','Cheque','0','EBCBankOfMaharastra','1819161702512',NULL,'BankofMaharastra','965798','12864','SECOND','2018-19','SECONDMBA','Regular','fee_receipt_counter',' ',' '),
 (154023,'AES-F-3529-2018-19','2019-05-24','interim Fee','Fee Receipt','Rohit Shavareppa Andodgi','Cheque','0','EBCBankOfMaharastra','1819161702512',NULL,'BankofMaharastra','965798','12864','SECOND','2018-19','SECONDMBA','Regular','fee_receipt_counter',' ',' '),
 (154024,'AES-F-3529-2018-19','2019-05-24','Tution Fee','Fee Receipt','Rohit Shavareppa Andodgi','Cheque','12864','EBCBankOfMaharastra','1819161702512',NULL,'BankofMaharastra','965798','12864','SECOND','2018-19','SECONDMBA','Regular','fee_receipt_counter',' ',' '),
 (154025,'AES-F-3530-2018-19','2019-05-27','Developement Fee','Fee Receipt','Kailas Maruti Khandale','Cheque','0','EBCBankOfMaharastra','18191201837',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (154026,'AES-F-3530-2018-19','2019-05-27','interim Fee','Fee Receipt','Kailas Maruti Khandale','Cheque','0','EBCBankOfMaharastra','18191201837',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' '),
 (154027,'AES-F-3530-2018-19','2019-05-27','Tution Fee','Fee Receipt','Kailas Maruti Khandale','Cheque','19433','EBCBankOfMaharastra','18191201837',NULL,'BankofMaharastra','965798','19433','FIRST','2018-19','FIRSTMBA','New','fee_receipt_counter',' ',' ');
-- --------------------------------------------------------

--
-- Table structure for table `receipt_number_total`
--

CREATE TABLE IF NOT EXISTS `receipt_number_total` (
  `rnt_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `rnt_number` varchar(45) NOT NULL,
  `rnt_total` varchar(45) NOT NULL,
  `rnt_chq_number` varchar(45) DEFAULT NULL,
  `s_section` varchar(45) NOT NULL,
  `particulars` varchar(45) NOT NULL,
  PRIMARY KEY (`rnt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `receipt_sub_head`
--

CREATE TABLE IF NOT EXISTS `receipt_sub_head` (
  `receipt_sub_head_id` int(11) NOT NULL AUTO_INCREMENT,
  `receipt_head` varchar(45) DEFAULT NULL,
  `receipt_sub_head` varchar(45) DEFAULT NULL,
  `sub_head_amount` varchar(45) DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `sub_head_no` varchar(45) DEFAULT NULL,
  `receipt_head_total` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`receipt_sub_head_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `receipt_title`
--

CREATE TABLE IF NOT EXISTS `receipt_title` (
  `receipt_title_id` int(11) NOT NULL AUTO_INCREMENT,
  `receipt_title` varchar(100) NOT NULL,
  `receipt_head_name` varchar(200) DEFAULT NULL,
  `amount` varchar(45) DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `receipt_title_total` varchar(45) DEFAULT NULL,
  `counter_name` varchar(100) DEFAULT NULL,
  `academic_year` varchar(100) DEFAULT NULL,
  `sequence_no_of_head` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`receipt_title_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `receipt_title` (`receipt_title_id`,`receipt_title`,`receipt_head_name`,`sequence_no_of_head`,`academic_year`,`amount`,`s_section`,`s_standard`,`counter_name`,`receipt_title_total`) VALUES 
 (56,'EXAM RECEIPT','University Exam Form','No','Yes','0','MBA','Second','misc_receipt_counter','0'),
 (57,'EXAM RECEIPT','University Exam Fee','Yes','Yes','0','MBA','Second','misc_receipt_counter','0'),
 (58,'EXAM RECEIPT','St. Of Marks Fee','Yes','Yes','0','MBA','Second','misc_receipt_counter','0'),
 (59,'EXAM RECEIPT','C.A.P. Fee','Yes','Yes','0','MBA','Second','misc_receipt_counter','0'),
 (60,'EXAM RECEIPT','Project Fee','Yes','Yes','0','MBA','Second','misc_receipt_counter','0'),
 (61,'EXAM RECEIPT','Passing Certificate Fee','Yes','Yes','0','MBA','Second','misc_receipt_counter','0'),
 (62,'EXAM RECEIPT','Internal Marks Fee','Yes','Yes','0','MBA','Second','misc_receipt_counter','0'),
 (63,'EXAM RECEIPT','Late Fee','Yes','Yes','0','MBA','Second','misc_receipt_counter','0'),
 (64,'EXAM RECEIPT','Supper Late Fee','Yes','Yes','0','MBA','Second','misc_receipt_counter','0'),
 (85,'MISCELLANEOUS RECEIPT','Library Fee','Yes','Yes','300','MBA','First','misc_receipt_counter','19460'),
 (86,'MISCELLANEOUS RECEIPT','Admission Form','Yes','Yes','1000','MBA','First','misc_receipt_counter','19460'),
 (87,'MISCELLANEOUS RECEIPT','Eligibility Form Fee','Yes','Yes','50','MBA','First','misc_receipt_counter','19460'),
 (88,'MISCELLANEOUS RECEIPT','Eligibility Fee','Yes','Yes','1000','MBA','First','misc_receipt_counter','19460'),
 (89,'MISCELLANEOUS RECEIPT','University Exam Form','Yes','Yes','30','MBA','First','misc_receipt_counter','19460'),
 (90,'MISCELLANEOUS RECEIPT','University Exam Fee','Yes','Yes','5000','MBA','First','misc_receipt_counter','19460'),
 (91,'MISCELLANEOUS RECEIPT','St. Of Marks Fee','Yes','Yes','180','MBA','First','misc_receipt_counter','19460'),
 (92,'MISCELLANEOUS RECEIPT','C.A.P. Fee','Yes','Yes','500','MBA','First','misc_receipt_counter','19460'),
 (93,'MISCELLANEOUS RECEIPT','Bonafied Certificate Fee','Yes','Yes','20','MBA','First','misc_receipt_counter','19460'),
 (94,'MISCELLANEOUS RECEIPT','T.C. Fee','Yes','Yes','100','MBA','First','misc_receipt_counter','19460'),
 (95,'MISCELLANEOUS RECEIPT','Project Fee','Yes','Yes','480','MBA','First','misc_receipt_counter','19460'),
 (96,'MISCELLANEOUS RECEIPT','Passing Certificate Fee','Yes','Yes','180','MBA','First','misc_receipt_counter','19460'),
 (97,'MISCELLANEOUS RECEIPT','Internal Marks Fee','Yes','Yes','180','MBA','First','misc_receipt_counter','19460'),
 (98,'MISCELLANEOUS RECEIPT','Late Fee','Yes','Yes','140','MBA','First','misc_receipt_counter','19460'),
 (99,'MISCELLANEOUS RECEIPT','Supper Late Fee','Yes','Yes','300','MBA','First','misc_receipt_counter','19460'),
 (100,'MISCELLANEOUS RECEIPT','Library Fee','Yes','Yes','300','MBA','Second','misc_receipt_counter','19460'),
 (101,'MISCELLANEOUS RECEIPT','Admission Form','Yes','Yes','1000','MBA','Second','misc_receipt_counter','19460'),
 (102,'MISCELLANEOUS RECEIPT','Eligibility Form Fee','Yes','Yes','50','MBA','Second','misc_receipt_counter','19460'),
 (103,'MISCELLANEOUS RECEIPT','Eligibility Fee','Yes','Yes','1000','MBA','Second','misc_receipt_counter','19460'),
 (104,'MISCELLANEOUS RECEIPT','University Exam Form','Yes','Yes','30','MBA','Second','misc_receipt_counter','19460'),
 (105,'MISCELLANEOUS RECEIPT','University Exam Fee','Yes','Yes','5000','MBA','Second','misc_receipt_counter','19460'),
 (106,'MISCELLANEOUS RECEIPT','St. Of Marks Fee','Yes','Yes','180','MBA','Second','misc_receipt_counter','19460'),
 (107,'MISCELLANEOUS RECEIPT','C.A.P. Fee','Yes','Yes','500','MBA','Second','misc_receipt_counter','19460'),
 (108,'MISCELLANEOUS RECEIPT','Bonafied Certificate Fee','Yes','Yes','20','MBA','Second','misc_receipt_counter','19460'),
 (109,'MISCELLANEOUS RECEIPT','T.C. Fee','Yes','Yes','100','MBA','Second','misc_receipt_counter','19460'),
 (110,'MISCELLANEOUS RECEIPT','Project Fee','Yes','Yes','480','MBA','Second','misc_receipt_counter','19460'),
 (111,'MISCELLANEOUS RECEIPT','Passing Certificate Fee','Yes','Yes','180','MBA','Second','misc_receipt_counter','19460'),
 (112,'MISCELLANEOUS RECEIPT','Internal Marks Fee','Yes','Yes','180','MBA','Second','misc_receipt_counter','19460'),
 (113,'MISCELLANEOUS RECEIPT','Late Fee','Yes','Yes','140','MBA','Second','misc_receipt_counter','19460'),
 (114,'MISCELLANEOUS RECEIPT','Supper Late Fee','Yes','Yes','300','MBA','Second','misc_receipt_counter','19460'),
 (115,'MISCELLANEOUS RECEIPT','other','Yes','Yes','10000','MBA','Second','misc_receipt_counter','19460'),
 (116,'MISCELLANEOUS RECEIPT','other','Yes','Yes','10000','MBA','First','misc_receipt_counter','19460'),
 (117,'MISCELLANEOUS RECEIPT','Uni Revaluation And Photo Copy Form Fee','Yes','Yes','100','MBA','First','misc_receipt_counter','2100'),
 (118,'MISCELLANEOUS RECEIPT','Uni Revaluation And Photo Copy Fee','Yes','Yes','2000','MBA','First','misc_receipt_counter','2100'),
 (119,'MISCELLANEOUS RECEIPT','Uni Revaluation And Photo Copy Form Fee','Yes','Yes','100','MBA','Second','misc_receipt_counter','2100'),
 (120,'MISCELLANEOUS RECEIPT','Uni Revaluation And Photo Copy Fee','Yes','Yes','2000','MBA','Second','misc_receipt_counter','2100');

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

--
-- Table structure for table `receipt_title_head`
--

CREATE TABLE IF NOT EXISTS `receipt_title_head` (
  `receipt_title_head_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `receipt_title` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`receipt_title_head_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `receipt_type`
--

CREATE TABLE IF NOT EXISTS `receipt_type` (
  `receipt_type_id` int(10) NOT NULL AUTO_INCREMENT,
  `receipt_type_name` varchar(100) NOT NULL,
  `budget_percent` varchar(10) DEFAULT NULL,
  `particular_exp` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`receipt_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `receipt_type`
--

INSERT INTO `receipt_type` (`receipt_type_id`, `receipt_type_name`, `budget_percent`, `particular_exp`) VALUES
 (1,'Fee Receipt','0',NULL),
 (2,'Tution Fee',NULL,NULL),
 (3,'Developement Fee',NULL,NULL),
 (4,'Internet & E-mail Charges',NULL,NULL),
 (5,'Gymkhana Fees',NULL,NULL),
 (6,'Gathering & Cluteral Fee',NULL,NULL),
 (7,'Library Fee',NULL,NULL),
 (8,'interim Fee',NULL,NULL),
 (9,'Admission Form Fee',NULL,NULL),
 (10,'Admission Form',NULL,NULL),
 (11,'Eligibility Form Fee',NULL,NULL),
 (12,'Eligibility Fee',NULL,NULL),
 (13,'University Exam Form',NULL,NULL),
 (14,'University Exam Fee',NULL,NULL),
 (15,'St. Of Marks Fee',NULL,NULL),
 (16,'C.A.P. Fee',NULL,NULL),
 (17,'Bonafied Certificate Fee',NULL,NULL),
 (18,'T.C. Fee',NULL,NULL),
 (19,'Project Fee',NULL,NULL),
 (20,'Passing Certificate Fee',NULL,NULL),
 (21,'Internal Marks Fee',NULL,NULL),
 (22,'Late Fee',NULL,NULL),
 (23,'Supper Late Fee',NULL,NULL),
 (24,'Student Welfare Fee',NULL,NULL),
 (25,'Student Insurance Fee',NULL,NULL),
 (26,'Accident Fee',NULL,NULL),
 (27,'Ashwamedh Fee',NULL,NULL),
 (28,'other','',NULL),
 (29,'Uni. Addmission Fee',NULL,NULL),
 (30,'Computer Fee',NULL,NULL),
 (31,'Uni. Development Fee',NULL,NULL),
 (32,'Refund Fee',NULL,NULL),
 (33,'other',NULL,NULL),
 (34,'Uni Revaluation And Photo Copy Form Fee',NULL,NULL),
 (35,'Uni Revaluation And Photo Copy Fee',NULL,NULL);

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

--
-- Table structure for table `religion`
--

CREATE TABLE IF NOT EXISTS `religion` (
  `religion_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `religion_name` varchar(45) NOT NULL,
  PRIMARY KEY (`religion_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `religion`
--

INSERT INTO `religion` (`religion_id`, `religion_name`) VALUES
(5, 'HINDU'),
(6, 'MUSLIM'),
(7, 'Sikh'),
(8, 'CHRISTIAN'),
(9, 'jain'),
(11, 'buddhist');

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

--
-- Table structure for table `resolution`
--

CREATE TABLE IF NOT EXISTS `resolution` (
  `resolution_id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_no` int(11) DEFAULT NULL,
  `resolution_no` varchar(100) DEFAULT NULL,
  `resolution_discussion` varchar(5000) DEFAULT NULL,
  `sr_no_of_meeting` int(11) DEFAULT NULL,
  PRIMARY KEY (`resolution_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `role_info`
--

CREATE TABLE IF NOT EXISTS `role_info` (
  `role_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `role_name` varchar(45) NOT NULL,
  `student` varchar(3) DEFAULT NULL,
  `faculty` varchar(3) DEFAULT NULL,
  `accounts` varchar(3) DEFAULT NULL,
  `reports` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`role_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `route_details`
--

CREATE TABLE IF NOT EXISTS `route_details` (
  `route_id` int(11) NOT NULL AUTO_INCREMENT,
  `route_name` varchar(100) DEFAULT NULL,
  `distance` varchar(10) DEFAULT NULL,
  `bus_no` int(11) DEFAULT NULL,
  `bus_driver` varchar(20) DEFAULT NULL,
  `bus_attendant` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`route_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `route_details`
--


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

--
-- Table structure for table `scanned_docs`
--

CREATE TABLE IF NOT EXISTS `scanned_docs` (
  `scanned_docs_id` int(11) NOT NULL AUTO_INCREMENT,
  `doc_name` varchar(100) DEFAULT NULL,
  `doc_desc` varchar(500) DEFAULT NULL,
  `doc` longblob,
  PRIMARY KEY (`scanned_docs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `section_info`
--

CREATE TABLE IF NOT EXISTS `section_info` (
  `section_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `section_name` varchar(45) NOT NULL,
  `section_no` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`section_info_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `section_info`
--

INSERT INTO `section_info` (`section_info_id`, `section_name`, `section_no`) VALUES
(7, 'MBA', NULL);

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

--
-- Table structure for table `skipped_receipt_info`
--

CREATE TABLE IF NOT EXISTS `skipped_receipt_info` (
  `skipped_receipt_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `receipt_number` varchar(45) NOT NULL,
  `receipt_date` varchar(45) DEFAULT NULL,
  `receipt_type` varchar(100) DEFAULT NULL,
  `particulars` varchar(45) DEFAULT NULL,
  `paid_by` varchar(45) DEFAULT NULL,
  `payment_type` varchar(45) DEFAULT NULL,
  `amount` varchar(45) DEFAULT NULL,
  `received_by` varchar(45) DEFAULT NULL,
  `s_personal_info_id` varchar(15) DEFAULT NULL,
  `fee_info_id` int(10) UNSIGNED DEFAULT NULL,
  `bank` varchar(300) DEFAULT NULL,
  `chq_dd_no` varchar(15) DEFAULT NULL,
  `ptotal` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_academic_year` varchar(45) DEFAULT NULL,
  `bus_stop_name` varchar(45) DEFAULT NULL,
  `stop_from` varchar(45) DEFAULT NULL,
  `stop_to` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`skipped_receipt_info_id`),
  KEY `FK_receipt_info_1` (`s_personal_info_id`),
  KEY `FK_receipt_info_2` (`fee_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `society_bus_fee`
--

CREATE TABLE IF NOT EXISTS `society_bus_fee` (
  `bus_fees_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(25) DEFAULT NULL,
  `route_id` int(11) DEFAULT NULL,
  `bus_stop_id` int(11) DEFAULT NULL,
  `total_fee` float DEFAULT NULL,
  `paid_fee` float DEFAULT NULL,
  `pending_fee` float DEFAULT NULL,
  `term` int(11) DEFAULT NULL,
  `oldpending` float DEFAULT NULL,
  `is_concession` varchar(10) DEFAULT NULL,
  `concession_amount` float DEFAULT NULL,
  `s_bus_no` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`bus_fees_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `society_bus_fee_receipt`
--

CREATE TABLE IF NOT EXISTS `society_bus_fee_receipt` (
  `society_bus_fee_id` int(11) NOT NULL AUTO_INCREMENT,
  `receipt_number` varchar(45) DEFAULT NULL,
  `first_name` varchar(45) DEFAULT NULL,
  `middel_name` varchar(45) DEFAULT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  `standard` varchar(45) DEFAULT NULL,
  `academic_year` varchar(45) DEFAULT NULL,
  `date` varchar(45) DEFAULT NULL,
  `route` varchar(255) DEFAULT NULL,
  `stop` varchar(255) DEFAULT NULL,
  `term1_fee` varchar(45) DEFAULT NULL,
  `term2_fee` varchar(45) DEFAULT NULL,
  `pyment_type` varchar(45) DEFAULT NULL,
  `received_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`society_bus_fee_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `society_bus_receipt_info`
--

CREATE TABLE IF NOT EXISTS `society_bus_receipt_info` (
  `receipt_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `receipt_number` varchar(45) NOT NULL,
  `receipt_date` varchar(45) DEFAULT NULL,
  `receipt_type` varchar(100) DEFAULT NULL,
  `particulars` varchar(45) DEFAULT NULL,
  `paid_by` varchar(45) DEFAULT NULL,
  `payment_type` varchar(45) DEFAULT NULL,
  `amount` varchar(45) DEFAULT NULL,
  `received_by` varchar(45) DEFAULT NULL,
  `s_personal_info_id` varchar(15) DEFAULT NULL,
  `fee_info_id` int(10) UNSIGNED DEFAULT NULL,
  `bank` varchar(300) DEFAULT NULL,
  `chq_dd_no` varchar(15) DEFAULT NULL,
  `ptotal` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_academic_year` varchar(45) DEFAULT NULL,
  `bus_stop_name` varchar(45) DEFAULT NULL,
  `stop_from` varchar(45) DEFAULT NULL,
  `stop_to` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `cash_amount` varchar(45) DEFAULT NULL,
  `trf_no` varchar(45) DEFAULT NULL,
  `trf_narration` varchar(45) DEFAULT NULL,
  `rtgs_no` varchar(45) DEFAULT NULL,
  `rtgs_narration` varchar(45) DEFAULT NULL,
  `refund_description` varchar(350) DEFAULT NULL,
  `is_canceled` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`receipt_info_id`),
  KEY `FK_receipt_info_1` (`s_personal_info_id`),
  KEY `FK_receipt_info_2` (`fee_info_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `society_fee_receipt`
--

CREATE TABLE IF NOT EXISTS `society_fee_receipt` (
  `society_fee_receipt_id` int(11) NOT NULL AUTO_INCREMENT,
  `receipt_number` varchar(45) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `first_name` varchar(45) DEFAULT NULL,
  `middel_name` varchar(45) DEFAULT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  `section` varchar(45) DEFAULT NULL,
  `standard` varchar(45) DEFAULT NULL,
  `branch` varchar(45) DEFAULT NULL,
  `academic_year` varchar(45) DEFAULT NULL,
  `admission_type` varchar(45) DEFAULT NULL,
  `received_by` varchar(45) DEFAULT NULL,
  `payment_type` varchar(45) DEFAULT NULL,
  `fee_head` varchar(45) DEFAULT NULL,
  `amount` varchar(45) DEFAULT NULL,
  `total` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`society_fee_receipt_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `society_voucher`
--

CREATE TABLE IF NOT EXISTS `society_voucher` (
  `sv_number` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sv_name` varchar(100) NOT NULL,
  `sv_date` varchar(20) DEFAULT NULL,
  `sv_paid_to` varchar(100) DEFAULT NULL,
  `sv_amount` varchar(10) DEFAULT NULL,
  `sv_towards` varchar(200) DEFAULT NULL,
  `sv_is_cash_or_cheque` varchar(50) DEFAULT NULL,
  `sv_cheque_number` varchar(50) DEFAULT NULL,
  `sv_cash_amount` varchar(10) DEFAULT NULL,
  `sv_total` varchar(10) DEFAULT NULL,
  `sv_received_by` varchar(100) DEFAULT NULL,
  `is_paid_received` varchar(45) DEFAULT NULL,
  `sv_particulars` varchar(45) DEFAULT NULL,
  `sv_bankname` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`sv_number`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `society_voucher`
--

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

--
-- Table structure for table `society_voucher_head`
--

CREATE TABLE IF NOT EXISTS `society_voucher_head` (
  `svh_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `svh_name` varchar(45) NOT NULL,
  PRIMARY KEY (`svh_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `society_voucher_type`
--

CREATE TABLE IF NOT EXISTS `society_voucher_type` (
  `society_voucher_type_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `society_voucher_type_name` varchar(100) NOT NULL,
  PRIMARY KEY (`society_voucher_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `society_voucher_type`
--



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

--
-- Table structure for table `standard_info`
--

CREATE TABLE IF NOT EXISTS `standard_info` (
  `standard_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `standard_name` varchar(100) DEFAULT NULL,
  `section_name` varchar(45) DEFAULT NULL,
  `standard_no` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`standard_info_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `standard_info`
--

INSERT INTO `standard_info` (`standard_info_id`, `standard_name`, `section_name`, `standard_no`) VALUES
(1, 'FIRST', 'MBA', NULL),
(2, 'SECOND', 'MBA', NULL);
-- --------------------------------------------------------

--
-- Table structure for table `standard_report`
--

CREATE TABLE IF NOT EXISTS `standard_report` (
  `standard_report_id` int(11) NOT NULL AUTO_INCREMENT,
  `standard_report_name` varchar(400) DEFAULT NULL,
  `table_names` varchar(50) DEFAULT NULL,
  `column_names` varchar(500) DEFAULT NULL,
  `conditions` varchar(400) DEFAULT NULL,
  PRIMARY KEY (`standard_report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `stationary_receipt_head`
--

CREATE TABLE IF NOT EXISTS `stationary_receipt_head` (
  `stationary_receipt_head_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `head_name` varchar(100) NOT NULL,
  `amount` varchar(20) NOT NULL,
  `stationary_receipt_title_id` int(10) UNSIGNED NOT NULL,
  `quantity` varchar(20) NOT NULL,
  `tax_amount` varchar(20) NOT NULL,
  `head_total` varchar(20) NOT NULL,
  PRIMARY KEY (`stationary_receipt_head_id`),
  KEY `FK_stationary_receipt_head_1` (`stationary_receipt_title_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `stationary_receipt_title`
--

CREATE TABLE IF NOT EXISTS `stationary_receipt_title` (
  `stationary_receipt_title_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `total_amount` varchar(20) NOT NULL,
  `section_name` varchar(50) NOT NULL,
  `standard_name` varchar(50) NOT NULL,
  `academic_year` varchar(50) NOT NULL,
  PRIMARY KEY (`stationary_receipt_title_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `store_issue`
--

CREATE TABLE IF NOT EXISTS `store_issue` (
  `store_issue_id` int(11) NOT NULL AUTO_INCREMENT,
  `issue_date` date DEFAULT NULL,
  `issue_item_name` varchar(45) DEFAULT NULL,
  `issue_item_qty` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`store_issue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `store_requirement`
--

CREATE TABLE IF NOT EXISTS `store_requirement` (
  `store_req_id` int(11) NOT NULL AUTO_INCREMENT,
  `req_number` varchar(45) NOT NULL,
  `req_by` varchar(45) DEFAULT NULL,
  `req_by_designation` varchar(45) DEFAULT NULL,
  `req_item_name` varchar(45) NOT NULL,
  `req_qty` varchar(45) NOT NULL,
  `req_date` datetime DEFAULT NULL,
  `req_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`store_req_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `store_stock`
--

CREATE TABLE IF NOT EXISTS `store_stock` (
  `store_stock_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_name` varchar(45) DEFAULT NULL,
  `item_qty` varchar(45) DEFAULT NULL,
  `item_desc` varchar(45) DEFAULT NULL,
  `store_date` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`store_stock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_bonafide`
--

CREATE TABLE IF NOT EXISTS `student_bonafide` (
  `bonafide_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(45) NOT NULL,
  `generated_date` date DEFAULT NULL,
  `place` varchar(100) DEFAULT NULL,
  `bdateinwords` varchar(100) DEFAULT NULL,
  `bonafied_number` varchar(25) DEFAULT NULL,
  `address` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`bonafide_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_notice`
--

CREATE TABLE IF NOT EXISTS `student_notice` (
  `student_notice_id` int(11) NOT NULL AUTO_INCREMENT,
  `notice_id` varchar(45) DEFAULT NULL,
  `student_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`student_notice_id`)
) ENGINE=MyISAM AUTO_INCREMENT=40489 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_photo`
--

CREATE TABLE IF NOT EXISTS `student_photo` (
  `student_photo_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `image` longblob,
  PRIMARY KEY (`student_photo_id`),
  KEY `FK_student_photo_1` (`s_personal_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `student_stationary`
--

CREATE TABLE IF NOT EXISTS `student_stationary` (
  `student_stationary_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` varchar(50) DEFAULT NULL,
  `subcategory` varchar(50) DEFAULT NULL,
  `product` varchar(100) NOT NULL,
  `price` varchar(20) NOT NULL,
  `tax_percent` varchar(5) NOT NULL,
  PRIMARY KEY (`student_stationary_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------

--
-- Table structure for table `subject_info`
--

CREATE TABLE IF NOT EXISTS `subject_info` (
  `subject_code` varchar(10) NOT NULL,
  `subject_name` varchar(50) DEFAULT NULL,
  `course_no` varchar(50) DEFAULT NULL,
  `theory_marks` varchar(5) DEFAULT NULL,
  `tw_marks` varchar(5) DEFAULT NULL,
  `practical_viva_marks` varchar(5) DEFAULT NULL,
  `section` varchar(45) DEFAULT NULL,
  `standard` varchar(15) DEFAULT NULL,
  `branch_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`subject_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `sudent_notice_old`
--

CREATE TABLE IF NOT EXISTS `sudent_notice_old` (
  `sudent_notice_old_id` int(11) NOT NULL AUTO_INCREMENT,
  `notice_id` varchar(45) DEFAULT NULL,
  `student_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`sudent_notice_old_id`)
) ENGINE=MyISAM AUTO_INCREMENT=36483 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_academic_info`
--

CREATE TABLE IF NOT EXISTS `s_academic_info` (
  `s_academic_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_is_repeat_year` varchar(3) DEFAULT NULL,
  `s_previous_school_attended` varchar(100) DEFAULT NULL,
  `s_last_class_attended` varchar(45) DEFAULT NULL,
  `s_last_exam_percentage` varchar(45) DEFAULT NULL,
  `s_last_exam_grade` varchar(45) DEFAULT NULL,
  `s_school_name` varchar(200) DEFAULT NULL,
  `s_ssc_seatno` varchar(200) DEFAULT NULL,
  `s_ssc_month` varchar(200) DEFAULT NULL,
  `s_ssc_year` varchar(200) DEFAULT NULL,
  `s_ssc_center` varchar(200) DEFAULT NULL,
  `s_marks1` varchar(4) DEFAULT NULL,
  `s_marks1_total` varchar(4) DEFAULT NULL,
  `s_percentage1` varchar(5) DEFAULT NULL,
  `s_jrcollege_name` varchar(200) DEFAULT NULL,
  `s_marks2` varchar(4) DEFAULT NULL,
  `s_marks2_total` varchar(4) DEFAULT NULL,
  `s_percentage2` varchar(5) DEFAULT NULL,
  `s_achievements` varchar(100) DEFAULT NULL,
  `s_academic_year` varchar(45) DEFAULT NULL,
  `s_is_gap` varchar(20) DEFAULT NULL,
  `no_gap_years` varchar(20) DEFAULT NULL,
  `gap_reason` varchar(100) DEFAULT NULL,
  `s_repeat_year` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_academic_info_id`),
  KEY `FK_s_academic_info_1` (`s_personal_info_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `s_academic_info`
--

INSERT INTO `s_academic_info` (`s_academic_info_id`, `s_personal_info_id`, `s_is_repeat_year`, `s_previous_school_attended`, `s_last_class_attended`, `s_last_exam_percentage`, `s_last_exam_grade`,
 `s_school_name`, `s_ssc_seatno`, `s_ssc_month`, `s_ssc_year`, `s_ssc_center`, `s_marks1`, `s_marks1_total`,`s_jrcollege_name`) VALUES
 (2,'141511001','No','Regular',NULL,'','','','','','','','','','Management'),
 (3,'141511002','No','Regular',NULL,NULL,NULL,'','','',NULL,'','','','Management'),
 (4,'141511003',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (5,'141511004',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (6,'141511005',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (7,'141511006',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (8,'141511007',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (9,'141511008',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (10,'141511009',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (11,'141511010',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (12,'141511011',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (13,'141511012',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (14,'141511013',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (15,'14151016',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (16,'14151010',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (17,'14151011',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (18,'14151020',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (19,'14151028',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (20,'14151014',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (21,'14151001',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (22,'141510119',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (23,'1415100121',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (24,'141510202',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (25,'141512117',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (26,'14151008',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (27,'141512550',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (28,'141512551',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (29,'14151303',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (30,'14151315',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (31,'14151316',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (32,'14151141',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Not Selected'),
 (33,'14151191',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (34,'14151552',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (35,'14151556',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (36,'14151825',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (37,'1415122255',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (38,'141512266',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (39,'14151585',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (40,'14151555',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4th Round'),
 (41,'14151447',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (42,'14151559',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (43,'14151777',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (44,'14151225',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (45,'14151558',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3rd Round'),
 (46,'141515486',NULL,'Regular',NULL,NULL,'ABHINAV',NULL,NULL,NULL,'',NULL,NULL,NULL,'3rd Round'),
 (47,'141514584',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (48,'1415145684',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (49,'141515648',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (50,'141514595',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (51,'14151458',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (52,'1415145894',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (53,'141514518',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (54,'141514589',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (55,'141514568',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Not Selected'),
 (56,'1415145895',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (57,'1415145896',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (58,'14151458964',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (59,'14151459654',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (60,'1415145847',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3rd Round'),
 (61,'14151458794',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (62,'10111032',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (63,'161715001',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (64,'16171512',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (65,'16171209',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (66,'16171104',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4th Round'),
 (67,'16171219',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (68,'16171222',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (69,'16171216',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (71,'16171211',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (72,'16171160',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (73,'16171189',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (74,'16171206',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (75,'16171193',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (76,'16171210',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (77,'16171218',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (79,'16171227',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (80,'16171196',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4th Round'),
 (81,'16171212',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (82,'16171199',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (83,'16171514',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (84,'16171188',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (85,'16171163',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4th Round'),
 (86,'16171201',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (87,'16171213',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (88,'16171200',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (89,'16171162',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4th Round'),
 (90,'16171159',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (91,'16171182',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4th Round'),
 (92,'16171161',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (93,'16171174',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (94,'16171195',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (95,'1617179',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (96,'16171205',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (97,'16171190',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (98,'16171207',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (99,'16171183',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (100,'16171176',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (101,'16171191',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (102,'16171202',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (103,'16171194',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (104,'16171203',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (105,'16171223',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (106,'16171175',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (107,'16171192',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (108,'16171180',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (109,'16171208',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (110,'16171197',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (111,'16171181',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (112,'16171204',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (113,'16171185',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (115,'16171224',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (116,'16171230',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (117,'16171229',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (118,'16171198',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (119,'16171521',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (120,'16171498',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (121,'16171156',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (122,'16171500',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (123,'16171517',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (124,'16171518',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (125,'16171519',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (126,'16171510',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (127,'16171507',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (128,'16171483',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (129,'16171495',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (130,'16171485',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (131,'16171490',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (132,'16171493',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3rd Round'),
 (133,'16171492',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3rd Round'),
 (134,'16171513',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (135,'16171499',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (136,'16171481',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (137,'16171497',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (138,'16171509',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (139,'16171516',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (140,'16171478',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (141,'16171496',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (142,'16171486',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (143,'16171488',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (144,'16171225',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (145,'16171320',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (146,'1617145',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (147,'1617122',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (148,'1617155',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (149,'1617156',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (150,'1617124',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (151,'1617131',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (152,'1617132',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (153,'1617133',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (154,'1617134',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (155,'1617135',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (156,'1617136',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (157,'1617137',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (158,'1617138',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (159,'1617139',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (160,'1617140',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (161,'1617141',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (162,'1617146',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (163,'16171305',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (164,'16171351',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (165,'16171352',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3rd Round'),
 (166,'16171354',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (167,'16171355',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (168,'17181232',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (169,'17181233',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (171,'17181234',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (172,'17181236',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (173,'17181235',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (174,'17181245',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (175,'17181238',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (176,'17181242',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (177,'17181241',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (178,'17181164',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (179,'17181097',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (182,'17181239',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (183,'17181302',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (184,'17181279',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (185,'17181165',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (186,'17181303',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (187,'17181304',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (188,'171810165',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (189,'17181240',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (190,'17181149',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (191,'17181150',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (192,'17181166',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (193,'17181403',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (194,'17181404',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (195,'17181401',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (196,'17181402',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (197,'17181406',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (198,'17181407',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (199,'17181405',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (200,'17181411',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (201,'17181412',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (202,'17181409',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (203,'17181410',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (204,'17181413',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (205,'17181045',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (206,'16171010',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (207,'17181414',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (208,'17181148',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (210,'17181158',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (211,'171810411',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (212,'17181621',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (213,'17181231',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (214,'17181214',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (215,'17181443',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (216,'17181444',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (217,'17181445',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (218,'17181446',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (219,'17181447',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (220,'17181448',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (221,'17181449',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2nd Round'),
 (222,'17181455',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Management'),
 (223,'17181056',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (224,'171810056',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (225,'17181031',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (226,'171810031',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (227,'18191201801',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (228,'18191201802',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (229,'18191201803',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (230,'18191201804',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (231,'18191201805',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (232,'18191201806',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (233,'18191201807',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (234,'18191201808',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (235,'18191201809',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (236,'18191201810',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (237,'18191201811',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (238,'18191201812',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (239,'18191201813',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (240,'18191201814',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (241,'18191201815',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (242,'18191201816',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (243,'18191201817',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (244,'18191201818',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (245,'18191201819',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (246,'18191201820',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (247,'18191201821',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (248,'18191201822',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (249,'18191201823',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (250,'18191201824',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (251,'18191201825',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (252,'18191201826',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (253,'18191201827',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (254,'18191201850',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (255,'18191201837',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (256,'18191201838',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (257,'18191201839',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (258,'18191201840',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (259,'18191201841',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (260,'18191201842',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (261,'16171201617',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (262,'181910001',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (263,'18191617025',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round'),
 (264,'1819161702512',NULL,'Regular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1st Round');

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

--
-- Table structure for table `s_attendance`
--

CREATE TABLE IF NOT EXISTS `s_attendance` (
  `s_attendance_id` int(10) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(45) DEFAULT NULL,
  `attendance_date` date DEFAULT NULL,
  `is_present` varchar(20) DEFAULT NULL,
  `teacher_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_attendance_id`)
) ENGINE=MyISAM AUTO_INCREMENT=224918 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_division`
--

CREATE TABLE IF NOT EXISTS `s_division` (
  `s_division_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) DEFAULT NULL,
  `division_info_id` varchar(50) NOT NULL,
  PRIMARY KEY (`s_division_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `s_division`
--

INSERT INTO `s_division` (`s_division_id`, `s_personal_info_id`, `division_info_id`) VALUES
 (2,'141511001','SECONDMBA'),
 (3,'141511002','SECONDMBA'),
 (4,'141511003','SECONDMBA'),
 (5,'141511004','SECONDMBA'),
 (6,'141511005','SECONDMBA'),
 (7,'141511006','SECONDMBA'),
 (8,'141511007','SECONDMBA'),
 (9,'141511008','Not Selected'),
 (10,'141511009','SECONDMBA'),
 (11,'141511010','SECONDMBA'),
 (12,'141511011','SECONDMBA'),
 (13,'141511012','SECONDMBA'),
 (14,'141511013','SECONDMBA'),
 (15,'14151016','FIRSTMBA'),
 (16,'14151010','FIRSTMBA'),
 (17,'14151011','FIRSTMBA'),
 (18,'14151020','FIRSTMBA'),
 (19,'14151028','FIRSTMBA'),
 (20,'14151014','FIRSTMBA'),
 (21,'14151001','FIRSTMBA'),
 (22,'141510119','FIRSTMBA'),
 (23,'1415100121','SECONDMBA'),
 (24,'141510202','SECONDMBA'),
 (25,'141512117','FIRSTMBA'),
 (26,'14151008','FIRSTMBA'),
 (27,'141512550','FIRSTMBA'),
 (28,'141512551','FIRSTMBA'),
 (29,'14151303','FIRSTMBA'),
 (30,'14151315','FIRSTMBA'),
 (31,'14151316','SECONDMBA'),
 (32,'14151141','FIRSTMBA'),
 (33,'14151191','FIRSTMBA'),
 (34,'14151552','FIRSTMBA'),
 (35,'14151556','FIRSTMBA'),
 (36,'14151825','FIRSTMBA'),
 (37,'1415122255','FIRSTMBA'),
 (38,'141512266','FIRSTMBA'),
 (39,'14151585','FIRSTMBA'),
 (40,'14151555','FIRSTMBA'),
 (41,'14151447','FIRSTMBA'),
 (42,'14151559','FIRSTMBA'),
 (43,'14151777','FIRSTMBA'),
 (44,'14151225','FIRSTMBA'),
 (45,'14151558','FIRSTMBA'),
 (46,'141515486','FIRSTMBA'),
 (47,'141514584','FIRSTMBA'),
 (48,'1415145684','FIRSTMBA'),
 (49,'141515648','SECONDMBA'),
 (50,'141514595','FIRSTMBA'),
 (51,'14151458','SECONDMBA'),
 (52,'1415145894','FIRSTMBA'),
 (53,'141514518','SECONDMBA'),
 (54,'141514589','FIRSTMBA'),
 (55,'141514568','FIRSTMBA'),
 (56,'1415145895','FIRSTMBA'),
 (57,'1415145896','FIRSTMBA'),
 (58,'14151458964','FIRSTMBA'),
 (59,'14151459654','FIRSTMBA'),
 (60,'1415145847','FIRSTMBA'),
 (61,'14151458794','FIRSTMBA'),
 (62,'10111032','FIRSTMBA'),
 (63,'161715001','FIRSTMBA'),
 (64,'16171512','SECONDMBA2017-18'),
 (65,'16171209','SECONDMBA2017-18'),
 (66,'16171104','SECONDMBA2017-18'),
 (67,'16171219','FIRSTMBA'),
 (68,'16171222','SECONDMBA2017-18'),
 (69,'16171216','SECONDMBA2017-18'),
 (71,'16171211','SECONDMBA2017-18'),
 (72,'16171160','FIRSTMBA'),
 (73,'16171189','SECONDMBA2017-18'),
 (74,'16171206','FIRSTMBA'),
 (75,'16171193','SECONDMBA2017-18'),
 (76,'16171210','SECONDMBA2017-18'),
 (77,'16171218','SECONDMBA2017-18'),
 (79,'16171227','SECONDMBA2017-18'),
 (80,'16171196','SECONDMBA2017-18'),
 (81,'16171212','SECONDMBA2017-18'),
 (82,'16171199','SECONDMBA2017-18'),
 (83,'16171514','SECONDMBA2017-18'),
 (84,'16171188','SECONDMBA2017-18'),
 (85,'16171163','FIRSTMBA'),
 (86,'16171201','SECONDMBA2017-18'),
 (87,'16171213','SECONDMBA2017-18'),
 (88,'16171200','SECONDMBA2017-18'),
 (89,'16171162','FIRSTMBA'),
 (90,'16171159','SECONDMBA2017-18'),
 (91,'16171182','SECONDMBA2017-18'),
 (92,'16171161','FIRSTMBA'),
 (93,'16171174','SECONDMBA2017-18'),
 (94,'16171195','FIRSTMBA'),
 (95,'1617179','FIRSTMBA'),
 (96,'16171205','SECONDMBA2017-18'),
 (97,'16171190','SECONDMBA2017-18'),
 (98,'16171207','SECONDMBA2017-18'),
 (99,'16171183','SECONDMBA2017-18'),
 (100,'16171176','SECONDMBA2017-18'),
 (101,'16171191','FIRSTMBA'),
 (102,'16171202','SECONDMBA2017-18'),
 (103,'16171194','SECONDMBA2017-18'),
 (104,'16171203','SECONDMBA2017-18'),
 (105,'16171223','SECONDMBA2017-18'),
 (106,'16171175','SECONDMBA2017-18'),
 (107,'16171192','SECONDMBA2017-18'),
 (108,'16171180','SECONDMBA2017-18'),
 (109,'16171208','SECONDMBA2017-18'),
 (110,'16171197','SECONDMBA2017-18'),
 (111,'16171181','SECONDMBA2017-18'),
 (112,'16171204','FIRSTMBA'),
 (113,'16171185','SECONDMBA2017-18'),
 (115,'16171224','FIRSTMBA'),
 (116,'16171230','Not Selected'),
 (117,'16171229','FIRSTMBA'),
 (118,'16171198','SECONDMBA2017-18'),
 (119,'16171521','FIRSTMBA'),
 (120,'16171498','SECONDMBA'),
 (121,'16171156','SECONDMBA'),
 (122,'16171500','SECONDMBA'),
 (123,'16171517','SECONDMBA'),
 (124,'16171518','SECONDMBA'),
 (125,'16171519','SECONDMBA'),
 (126,'16171510','SECONDMBA'),
 (127,'16171507','SECONDMBA'),
 (128,'16171483','SECONDMBA'),
 (129,'16171495','SECONDMBA'),
 (130,'16171485','SECONDMBA'),
 (131,'16171490','SECONDMBA'),
 (132,'16171493','SECONDMBA'),
 (133,'16171492','SECONDMBA'),
 (134,'16171513','SECONDMBA'),
 (135,'16171499','SECONDMBA'),
 (136,'16171481','SECONDMBA'),
 (137,'16171497','SECONDMBA'),
 (138,'16171509','SECONDMBA'),
 (139,'16171516','SECONDMBA'),
 (140,'16171478','SECONDMBA'),
 (141,'16171496','SECONDMBA'),
 (142,'16171486','SECONDMBA'),
 (143,'16171488','SECONDMBA'),
 (144,'16171225','SECONDMBA'),
 (145,'16171320','FIRSTMBA'),
 (146,'1617145','FIRSTMBA'),
 (147,'1617122','FIRSTMBA'),
 (148,'1617155','FIRSTMBA'),
 (149,'1617124','SECONDMBA2017-18'),
 (150,'1617131','FIRSTMBA'),
 (151,'1617132','FIRSTMBA'),
 (152,'1617133','SECONDMBA2017-18'),
 (153,'1617134','SECONDMBA2017-18'),
 (154,'1617135','SECONDMBA2017-18'),
 (155,'1617136','FIRSTMBA'),
 (156,'1617137','SECONDMBA'),
 (157,'1617138','SECONDMBA'),
 (158,'1617139','SECONDMBA'),
 (159,'1617140','SECONDMBA2017-18'),
 (160,'1617141','SECONDMBA'),
 (161,'1617146','SECONDMBA'),
 (162,'16171305','SECONDMBA'),
 (163,'16171351','SECONDMBA'),
 (164,'16171352','SECONDMBA'),
 (165,'16171354','SECONDMBA2017-18'),
 (166,'16171355','SECONDMBA'),
 (167,'17181232','SECONDMBA2018-19'),
 (168,'17181233','SECONDMBA2018-19'),
 (170,'17181234','FIRSTMBA'),
 (171,'17181236','SECONDMBA2018-19'),
 (172,'17181235','FIRSTMBA'),
 (173,'17181245','FIRSTMBA'),
 (174,'17181238','FIRSTMBA'),
 (175,'17181242','SECONDMBA2018-19'),
 (176,'17181241','SECONDMBA2018-19'),
 (177,'17181164','SECONDMBA2018-19'),
 (178,'17181097','SECONDMBA2018-19'),
 (181,'17181239','FIRSTMBA'),
 (182,'17181302','FIRSTMBA'),
 (183,'17181279','SECONDMBA2018-19'),
 (184,'17181165','SECONDMBA2018-19'),
 (185,'17181303','SECONDMBA2018-19'),
 (186,'17181304','SECONDMBA2018-19'),
 (187,'171810165','FIRSTMBA'),
 (188,'17181240','SECONDMBA2018-19'),
 (189,'17181149','FIRSTMBA'),
 (190,'17181150','SECONDMBA2018-19'),
 (191,'17181166','SECONDMBA2018-19'),
 (192,'17181403','SECONDMBA2018-19'),
 (193,'17181404','SECONDMBA2018-19'),
 (194,'17181401','FIRSTMBA'),
 (195,'17181402','FIRSTMBA'),
 (196,'17181406','FIRSTMBA'),
 (197,'17181407','SECONDMBA2018-19'),
 (198,'17181405','SECONDMBA2018-19'),
 (199,'17181411','SECONDMBA2018-19'),
 (200,'17181412','SECONDMBA2018-19'),
 (201,'17181409','FIRSTMBA'),
 (202,'17181410','FIRSTMBA'),
 (203,'17181413','FIRSTMBA'),
 (204,'16171010','FIRSTMBA'),
 (205,'17181414','FIRSTMBA'),
 (206,'17181148','FIRSTMBA'),
 (208,'17181158','SECONDMBA'),
 (209,'171810411','SECONDMBA2018-19'),
 (210,'17181621','FIRSTMBA'),
 (211,'17181231','FIRSTMBA'),
 (212,'17181214','SECONDMBA'),
 (213,'17181443','SECONDMBA2018-19'),
 (214,'17181444','FIRSTMBA'),
 (215,'17181445','FIRSTMBA'),
 (216,'17181446','SECONDMBA2018-19'),
 (217,'17181447','FIRSTMBA'),
 (218,'17181448','FIRSTMBA'),
 (219,'17181449','FIRSTMBA'),
 (220,'17181455','SECONDMBA2018-19'),
 (221,'17181056','FIRSTMBA'),
 (222,'171810056','FIRSTMBA'),
 (223,'17181031','FIRSTMBA'),
 (224,'171810031','FIRSTMBA'),
 (225,'18191201801','FIRSTMBA'),
 (226,'18191201804','FIRSTMBA'),
 (227,'18191201805','FIRSTMBA'),
 (228,'18191201806','FIRSTMBA'),
 (229,'18191201807','FIRSTMBA'),
 (230,'18191201808','FIRSTMBA'),
 (231,'18191201810','FIRSTMBA'),
 (232,'18191201811','FIRSTMBA'),
 (233,'18191201812','FIRSTMBA'),
 (234,'18191201813','FIRSTMBA'),
 (235,'18191201817','FIRSTMBA'),
 (236,'18191201818','FIRSTMBA'),
 (237,'18191201819','FIRSTMBA'),
 (238,'18191201820','FIRSTMBA'),
 (239,'18191201821','FIRSTMBA'),
 (240,'18191201822','FIRSTMBA'),
 (241,'18191201823','FIRSTMBA'),
 (242,'18191201824','FIRSTMBA'),
 (243,'18191201825','FIRSTMBA'),
 (244,'18191201826','FIRSTMBA'),
 (245,'18191201827','FIRSTMBA'),
 (246,'18191201850','FIRSTMBA'),
 (247,'18191201837','FIRSTMBA'),
 (248,'18191201838','FIRSTMBA'),
 (249,'18191201839','FIRSTMBA'),
 (250,'18191201840','FIRSTMBA'),
 (251,'18191201841','FIRSTMBA'),
 (252,'18191201842','FIRSTMBA'),
 (253,'16171201617','FIRSTMBA'),
 (254,'181910001','SECONDMBA'),
 (255,'18191617025','SECONDMBA'),
 (256,'1819161702512','SECONDMBA');

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

--
-- Table structure for table `s_fee_history`
--

CREATE TABLE IF NOT EXISTS `s_fee_history` (
  `s_fee_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_total_fee` float DEFAULT NULL,
  `s_paid_fee` float DEFAULT NULL,
  `s_pending_fee` float DEFAULT NULL,
  `s_payment_date` date DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_academic_year` varchar(45) DEFAULT NULL,
  `division_info_id` varchar(45) DEFAULT NULL,
  `s_concession` varchar(45) DEFAULT NULL,
  `give_concession` varchar(45) DEFAULT NULL,
  `concession_reason` varchar(200) DEFAULT NULL,
  `scholarship` varchar(45) DEFAULT NULL,
  `scholarship_pending` varchar(45) DEFAULT NULL,
  `s_admission_type` varchar(45) DEFAULT NULL,
  `is_rte_student` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_fee_info_id`),
  KEY `FK_s_fee_info_id_1` (`s_personal_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;


INSERT INTO `s_fee_history` (`s_fee_info_id`,`s_personal_info_id`,`s_total_fee`,`s_paid_fee`,`s_pending_fee`,`s_payment_date`,`s_section`,`s_concession`,`s_academic_year`,`division_info_id`,`scholarship`,`s_standard`,`scholarship_pending`,`s_admission_type`) VALUES 
 (2,'16171104',38891,2891,36000,NULL,'FIRST','0.0',NULL,NULL,'0','0','0','0'),
 (3,'16171213',38891,13891,25000,NULL,'FIRST','0.0',NULL,NULL,'0','0','0','0'),
 (5,'16171209',71300,41300,30000,NULL,'FIRST','0.0',NULL,NULL,'0','0','0','0'),
 (6,'16171200',71300,56300,15000,NULL,'FIRST','0.0',NULL,NULL,'0','0','0','0'),
 (8,'16171183',71300,11300,60000,NULL,'FIRST','0.0',NULL,NULL,'0','0','0','0'),
 (9,'1617124',71300,0,71300,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (10,'16171222',71300,11300,60000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (11,'16171185',6482,6482,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (12,'16171203',6482,0,6482,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (13,'16171159',71300,55300,16000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (14,'16171212',38891,13891,25000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (15,'16171175',71300,61300,10000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (16,'16171207',71300,71300,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (17,'16171181',6482,0,6482,NULL,'FIRST','0.0','2016-17','Not Selected','0','0','0','0'),
 (18,'16171512',71300,36409,34891,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (19,'1617135',71300,0,71300,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (20,'1617133',6482,6482,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (21,'16171223',38891,22891,16000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (22,'16171216',71300,25300,46000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (23,'16171354',71300,19300,52000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (24,'16171201',71300,60300,11000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (25,'16171199',71300,49300,22000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (26,'16171198',71300,6482,64818,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (27,'16171205',6482,6482,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (28,'16171197',6482,6482,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (29,'16171188',71300,51300,20000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (30,'16171514',71300,71300,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (31,'16171182',6482,6482,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (32,'16171211',71300,65300,6000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (33,'16171202',0,0,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (34,'16171193',6482,0,6482,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (35,'1617134',6482,0,6482,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (36,'16171192',6482,6482,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (37,'16171189',71300,63800,7500,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (38,'16171190',6482,6482,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (39,'16171210',6482,2532,3950,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (40,'16171227',71300,56300,15000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (41,'16171196',6482,0,6482,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (42,'16171174',6482,4000,2482,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (43,'16171194',6482,6482,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (44,'1617140',6482,6482,0,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (45,'16171180',71300,68300,3000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (46,'16171218',71300,55300,16000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (47,'16171208',71300,53540,17760,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (48,'17181405',56600,56600,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (49,'17181455',56600,56600,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (50,'17181232',30873,20380,10493,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (51,'17181411',30873,30872,1,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (52,'17181165',56600,26872,29728,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (53,'17181233',30873,29112,1761,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (54,'17181446',56600,56000,600,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (55,'171810411',56600,30872,25728,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (56,'17181240',56600,56600,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (57,'17181279',30873,30872,1,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (58,'17181443',56600,56600,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (59,'17181403',30873,30872,1,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (60,'17181303',5145,5145,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (61,'17181407',56600,56600,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (62,'17181236',5145,5145,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (63,'17181241',56600,56600,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (64,'17181150',56600,56600,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (65,'17181242',56600,56600,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (66,'17181166',5145,5145,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (67,'17181097',30873,30872,1,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (68,'17181164',56600,30872,25728,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (69,'17181412',5145,5145,0,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (70,'17181304',30873,29322,1551,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0'),
 (71,'16171176',71300,60300,11000,NULL,'FIRST','0.0','2016-17','FIRSTMBA','0','0','0','0'),
 (72,'17181404',56600,45364,11236,NULL,'FIRST','0.0','2017-18','FIRSTMBA','0','0','0','0');
-- --------------------------------------------------------

--
-- Table structure for table `s_fee_history_old`
--

CREATE TABLE IF NOT EXISTS `s_fee_history_old` (
  `s_fee_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_total_fee` float DEFAULT NULL,
  `s_paid_fee` float DEFAULT NULL,
  `s_pending_fee` float DEFAULT NULL,
  `s_payment_date` date DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_academic_year` varchar(45) DEFAULT NULL,
  `division_info_id` varchar(45) DEFAULT NULL,
  `s_concession` varchar(45) DEFAULT NULL,
  `give_concession` varchar(45) DEFAULT NULL,
  `concession_reason` varchar(200) DEFAULT NULL,
  `scholarship` varchar(45) DEFAULT NULL,
  `scholarship_pending` varchar(45) DEFAULT NULL,
  `s_admission_type` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_fee_info_id`),
  KEY `FK_s_fee_info_id_1` (`s_personal_info_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `s_lc`
--

CREATE TABLE IF NOT EXISTS `s_lc` (
  `id_s_LC` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `reg_no` varchar(45) DEFAULT NULL,
  `lc_no` varchar(45) DEFAULT NULL,
  `s_personal_info_id` varchar(45) DEFAULT NULL,
  `last_school_att` varchar(100) DEFAULT NULL,
  `last_jrcollege_att` varchar(100) DEFAULT NULL,
  `progress` varchar(100) DEFAULT NULL,
  `conduct` varchar(45) DEFAULT NULL,
  `s_dol` date DEFAULT NULL,
  `s_class_and_year` varchar(60) DEFAULT NULL,
  `lc_reason` varchar(100) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `lc_remarks` varchar(100) DEFAULT NULL,
  `date_of_lc` varchar(45) DEFAULT NULL,
  `is_all_dues_clear` varchar(45) DEFAULT NULL,
  `head_mistress_remarks` varchar(100) DEFAULT NULL,
  `date_of_application` varchar(45) DEFAULT NULL,
  `bdateinwords` varchar(200) DEFAULT NULL,
  `section` varchar(45) DEFAULT NULL,
  `mothertongue` varchar(45) DEFAULT NULL,
  `exam_attended` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_s_LC`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_medical_info`
--

CREATE TABLE IF NOT EXISTS `s_medical_info` (
  `s_medical_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_height` varchar(3) DEFAULT NULL,
  `s_weight` varchar(3) DEFAULT NULL,
  `s_blood_group` varchar(50) DEFAULT NULL,
  `s_allergies` varchar(200) DEFAULT NULL,
  `s_vaccination_taken` varchar(500) DEFAULT NULL,
  `s_medical_history` varchar(500) DEFAULT NULL,
  `s_family_doctor` varchar(500) DEFAULT NULL,
  `s_family_doc_phno` varchar(500) DEFAULT NULL,
  `s_identification_marks` varchar(500) DEFAULT NULL,
  `s_regular_medication` varchar(500) DEFAULT NULL,
  `s_reason_for_medication` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`s_medical_info_id`),
  KEY `FK_s_medical_info_1` (`s_personal_info_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `s_medical_info`
--

INSERT INTO `s_medical_info` (`s_medical_info_id`, `s_personal_info_id`, `s_height`, `s_weight`, `s_blood_group`, `s_allergies`, `s_medical_history`) VALUES
(2,'141511001',NULL,NULL,NULL,NULL,NULL),
 (3,'141511002',NULL,NULL,NULL,NULL,NULL),
 (4,'141511003',NULL,NULL,NULL,NULL,NULL),
 (5,'141511004',NULL,NULL,NULL,NULL,NULL),
 (6,'141511005',NULL,NULL,NULL,NULL,NULL),
 (7,'141511006',NULL,NULL,NULL,NULL,NULL),
 (8,'141511007',NULL,NULL,NULL,NULL,NULL),
 (9,'141511008',NULL,NULL,NULL,NULL,NULL),
 (10,'141511009',NULL,NULL,NULL,NULL,NULL),
 (11,'141511010',NULL,NULL,NULL,NULL,NULL),
 (12,'141511011',NULL,NULL,NULL,NULL,NULL),
 (13,'141511012',NULL,NULL,NULL,NULL,NULL),
 (14,'141511013',NULL,NULL,NULL,NULL,NULL),
 (15,'14151016',NULL,NULL,NULL,NULL,NULL),
 (16,'14151010',NULL,NULL,NULL,NULL,NULL),
 (17,'14151011',NULL,NULL,NULL,NULL,NULL),
 (18,'14151020',NULL,NULL,NULL,NULL,NULL),
 (19,'14151028',NULL,NULL,NULL,NULL,NULL),
 (20,'14151014',NULL,NULL,NULL,NULL,NULL),
 (21,'14151001',NULL,NULL,NULL,NULL,NULL),
 (22,'141510119',NULL,NULL,NULL,NULL,NULL),
 (23,'1415100121',NULL,NULL,NULL,NULL,NULL),
 (24,'141510202',NULL,NULL,NULL,NULL,NULL),
 (25,'141512117',NULL,NULL,NULL,NULL,NULL),
 (26,'14151008',NULL,NULL,NULL,NULL,NULL),
 (27,'141512550',NULL,NULL,NULL,NULL,NULL),
 (28,'141512551',NULL,NULL,NULL,NULL,NULL),
 (29,'14151303',NULL,NULL,NULL,NULL,NULL),
 (30,'14151315',NULL,NULL,NULL,NULL,NULL),
 (31,'14151316',NULL,NULL,NULL,NULL,NULL),
 (32,'14151141',NULL,NULL,NULL,NULL,NULL),
 (33,'14151191',NULL,NULL,NULL,NULL,NULL),
 (34,'14151552',NULL,NULL,NULL,NULL,NULL),
 (35,'14151556',NULL,NULL,NULL,NULL,NULL),
 (36,'14151825',NULL,NULL,NULL,NULL,NULL),
 (37,'1415122255',NULL,NULL,NULL,NULL,NULL),
 (38,'141512266',NULL,NULL,NULL,NULL,NULL),
 (39,'14151585',NULL,NULL,NULL,NULL,NULL),
 (40,'14151555',NULL,NULL,NULL,NULL,NULL),
 (41,'14151447',NULL,NULL,NULL,NULL,NULL),
 (42,'14151559',NULL,NULL,NULL,NULL,NULL),
 (43,'14151777',NULL,NULL,NULL,NULL,NULL),
 (44,'14151225',NULL,NULL,NULL,NULL,NULL),
 (45,'14151558',NULL,NULL,NULL,NULL,NULL),
 (46,'141515486',NULL,NULL,NULL,NULL,NULL),
 (47,'141514584',NULL,NULL,NULL,NULL,NULL),
 (48,'1415145684',NULL,NULL,NULL,NULL,NULL),
 (49,'141515648',NULL,NULL,NULL,NULL,NULL),
 (50,'141514595',NULL,NULL,NULL,NULL,NULL),
 (51,'14151458',NULL,NULL,NULL,NULL,NULL),
 (52,'1415145894',NULL,NULL,NULL,NULL,NULL),
 (53,'141514518',NULL,NULL,NULL,NULL,NULL),
 (54,'141514589',NULL,NULL,NULL,NULL,NULL),
 (55,'141514568',NULL,NULL,NULL,NULL,NULL),
 (56,'1415145895',NULL,NULL,NULL,NULL,NULL),
 (57,'1415145896',NULL,NULL,NULL,NULL,NULL),
 (58,'14151458964',NULL,NULL,NULL,NULL,NULL),
 (59,'14151459654',NULL,NULL,NULL,NULL,NULL),
 (60,'1415145847',NULL,NULL,NULL,NULL,NULL),
 (61,'14151458794',NULL,NULL,NULL,NULL,NULL),
 (62,'10111032',NULL,NULL,NULL,NULL,NULL),
 (63,'161715001',NULL,NULL,NULL,NULL,NULL),
 (64,'16171512',NULL,NULL,NULL,NULL,NULL),
 (65,'16171209',NULL,NULL,NULL,NULL,NULL),
 (66,'16171104',NULL,NULL,NULL,NULL,NULL),
 (67,'16171219',NULL,NULL,NULL,NULL,NULL),
 (68,'16171222',NULL,NULL,NULL,NULL,NULL),
 (69,'16171216',NULL,NULL,NULL,NULL,NULL),
 (71,'16171211',NULL,NULL,NULL,NULL,NULL),
 (72,'16171160',NULL,NULL,NULL,NULL,NULL),
 (73,'16171189',NULL,NULL,NULL,NULL,NULL),
 (74,'16171206',NULL,NULL,NULL,NULL,NULL),
 (75,'16171193',NULL,NULL,NULL,NULL,NULL),
 (76,'16171210',NULL,NULL,NULL,NULL,NULL),
 (77,'16171218',NULL,NULL,NULL,NULL,NULL),
 (79,'16171227',NULL,NULL,NULL,NULL,NULL),
 (80,'16171196',NULL,NULL,NULL,NULL,NULL),
 (81,'16171212',NULL,NULL,NULL,NULL,NULL),
 (82,'16171199',NULL,NULL,NULL,NULL,NULL),
 (83,'16171514',NULL,NULL,NULL,NULL,NULL),
 (84,'16171188',NULL,NULL,NULL,NULL,NULL),
 (85,'16171163',NULL,NULL,NULL,NULL,NULL),
 (86,'16171201',NULL,NULL,NULL,NULL,NULL),
 (87,'16171213',NULL,NULL,NULL,NULL,NULL),
 (88,'16171200',NULL,NULL,NULL,NULL,NULL),
 (89,'16171162',NULL,NULL,NULL,NULL,NULL),
 (90,'16171159',NULL,NULL,NULL,NULL,NULL),
 (91,'16171182',NULL,NULL,NULL,NULL,NULL),
 (92,'16171161',NULL,NULL,NULL,NULL,NULL),
 (93,'16171174',NULL,NULL,NULL,NULL,NULL),
 (94,'16171195',NULL,NULL,NULL,NULL,NULL),
 (95,'1617179',NULL,NULL,NULL,NULL,NULL),
 (96,'16171205',NULL,NULL,NULL,NULL,NULL),
 (97,'16171190',NULL,NULL,NULL,NULL,NULL),
 (98,'16171207',NULL,NULL,NULL,NULL,NULL),
 (99,'16171183',NULL,NULL,NULL,NULL,NULL),
 (100,'16171176',NULL,NULL,NULL,NULL,NULL),
 (101,'16171191',NULL,NULL,NULL,NULL,NULL),
 (102,'16171202',NULL,NULL,NULL,NULL,NULL),
 (103,'16171194',NULL,NULL,NULL,NULL,NULL),
 (104,'16171203',NULL,NULL,NULL,NULL,NULL),
 (105,'16171223',NULL,NULL,NULL,NULL,NULL),
 (106,'16171175',NULL,NULL,NULL,NULL,NULL),
 (107,'16171192',NULL,NULL,NULL,NULL,NULL),
 (108,'16171180',NULL,NULL,NULL,NULL,NULL),
 (109,'16171208',NULL,NULL,NULL,NULL,NULL),
 (110,'16171197',NULL,NULL,NULL,NULL,NULL),
 (111,'16171181',NULL,NULL,NULL,NULL,NULL),
 (112,'16171204',NULL,NULL,NULL,NULL,NULL),
 (113,'16171185',NULL,NULL,NULL,NULL,NULL),
 (115,'16171224',NULL,NULL,NULL,NULL,NULL),
 (116,'16171230',NULL,NULL,NULL,NULL,NULL),
 (117,'16171229',NULL,NULL,NULL,NULL,NULL),
 (118,'16171198',NULL,NULL,NULL,NULL,NULL),
 (119,'16171521',NULL,NULL,NULL,NULL,NULL),
 (120,'16171498',NULL,NULL,NULL,NULL,NULL),
 (121,'16171156',NULL,NULL,NULL,NULL,NULL),
 (122,'16171500',NULL,NULL,NULL,NULL,NULL),
 (123,'16171517',NULL,NULL,NULL,NULL,NULL),
 (124,'16171518',NULL,NULL,NULL,NULL,NULL),
 (125,'16171519',NULL,NULL,NULL,NULL,NULL),
 (126,'16171510',NULL,NULL,NULL,NULL,NULL),
 (127,'16171507',NULL,NULL,NULL,NULL,NULL),
 (128,'16171483',NULL,NULL,NULL,NULL,NULL),
 (129,'16171495',NULL,NULL,NULL,NULL,NULL),
 (130,'16171485',NULL,NULL,NULL,NULL,NULL),
 (131,'16171490',NULL,NULL,NULL,NULL,NULL),
 (132,'16171493',NULL,NULL,NULL,NULL,NULL),
 (133,'16171492',NULL,NULL,NULL,NULL,NULL),
 (134,'16171513',NULL,NULL,NULL,NULL,NULL),
 (135,'16171499',NULL,NULL,NULL,NULL,NULL),
 (136,'16171481',NULL,NULL,NULL,NULL,NULL),
 (137,'16171497',NULL,NULL,NULL,NULL,NULL),
 (138,'16171509',NULL,NULL,NULL,NULL,NULL),
 (139,'16171516',NULL,NULL,NULL,NULL,NULL),
 (140,'16171478',NULL,NULL,NULL,NULL,NULL),
 (141,'16171496',NULL,NULL,NULL,NULL,NULL),
 (142,'16171486',NULL,NULL,NULL,NULL,NULL),
 (143,'16171488',NULL,NULL,NULL,NULL,NULL),
 (144,'16171225',NULL,NULL,NULL,NULL,NULL),
 (145,'16171320',NULL,NULL,NULL,NULL,NULL),
 (146,'1617145',NULL,NULL,NULL,NULL,NULL),
 (147,'1617122',NULL,NULL,NULL,NULL,NULL),
 (148,'1617155',NULL,NULL,NULL,NULL,NULL),
 (149,'1617124',NULL,NULL,NULL,NULL,NULL),
 (150,'1617131',NULL,NULL,NULL,NULL,NULL),
 (151,'1617132',NULL,NULL,NULL,NULL,NULL),
 (152,'1617133',NULL,NULL,NULL,NULL,NULL),
 (153,'1617134',NULL,NULL,NULL,NULL,NULL),
 (154,'1617135',NULL,NULL,NULL,NULL,NULL),
 (155,'1617136',NULL,NULL,NULL,NULL,NULL),
 (156,'1617137',NULL,NULL,NULL,NULL,NULL),
 (157,'1617138',NULL,NULL,NULL,NULL,NULL),
 (158,'1617139',NULL,NULL,NULL,NULL,NULL),
 (159,'1617140',NULL,NULL,NULL,NULL,NULL),
 (160,'1617141',NULL,NULL,NULL,NULL,NULL),
 (161,'1617146',NULL,NULL,NULL,NULL,NULL),
 (162,'16171305',NULL,NULL,NULL,NULL,NULL),
 (163,'16171351',NULL,NULL,NULL,NULL,NULL),
 (164,'16171352',NULL,NULL,NULL,NULL,NULL),
 (165,'16171354',NULL,NULL,NULL,NULL,NULL),
 (166,'16171355',NULL,NULL,NULL,NULL,NULL),
 (167,'17181232',NULL,NULL,NULL,NULL,NULL),
 (168,'17181233',NULL,NULL,NULL,NULL,NULL),
 (170,'17181234',NULL,NULL,NULL,NULL,NULL),
 (171,'17181236',NULL,NULL,NULL,NULL,NULL),
 (172,'17181235',NULL,NULL,NULL,NULL,NULL),
 (173,'17181245',NULL,NULL,NULL,NULL,NULL),
 (174,'17181238',NULL,NULL,NULL,NULL,NULL),
 (175,'17181242',NULL,NULL,NULL,NULL,NULL),
 (176,'17181241',NULL,NULL,NULL,NULL,NULL),
 (177,'17181164',NULL,NULL,NULL,NULL,NULL),
 (178,'17181097',NULL,NULL,NULL,NULL,NULL),
 (181,'17181239',NULL,NULL,NULL,NULL,NULL),
 (182,'17181302',NULL,NULL,NULL,NULL,NULL),
 (183,'17181279',NULL,NULL,NULL,NULL,NULL),
 (184,'17181165',NULL,NULL,NULL,NULL,NULL),
 (185,'17181303',NULL,NULL,NULL,NULL,NULL),
 (186,'17181304',NULL,NULL,NULL,NULL,NULL),
 (187,'171810165',NULL,NULL,NULL,NULL,NULL),
 (188,'17181240',NULL,NULL,NULL,NULL,NULL),
 (189,'17181149',NULL,NULL,NULL,NULL,NULL),
 (190,'17181150',NULL,NULL,NULL,NULL,NULL),
 (191,'17181166',NULL,NULL,NULL,NULL,NULL),
 (192,'17181403',NULL,NULL,NULL,NULL,NULL),
 (193,'17181404',NULL,NULL,NULL,NULL,NULL),
 (194,'17181401',NULL,NULL,NULL,NULL,NULL),
 (195,'17181402',NULL,NULL,NULL,NULL,NULL),
 (196,'17181406',NULL,NULL,NULL,NULL,NULL),
 (197,'17181407',NULL,NULL,NULL,NULL,NULL),
 (198,'17181405',NULL,NULL,NULL,NULL,NULL),
 (199,'17181411',NULL,NULL,NULL,NULL,NULL),
 (200,'17181412',NULL,NULL,NULL,NULL,NULL),
 (201,'17181409',NULL,NULL,NULL,NULL,NULL),
 (202,'17181410',NULL,NULL,NULL,NULL,NULL),
 (203,'17181413',NULL,NULL,NULL,NULL,NULL),
 (204,'16171010',NULL,NULL,NULL,NULL,NULL),
 (205,'17181414',NULL,NULL,NULL,NULL,NULL),
 (206,'17181148',NULL,NULL,NULL,NULL,NULL),
 (208,'17181158',NULL,NULL,NULL,NULL,NULL),
 (209,'171810411',NULL,NULL,NULL,NULL,NULL),
 (210,'17181621',NULL,NULL,NULL,NULL,NULL),
 (211,'17181231',NULL,NULL,NULL,NULL,NULL),
 (212,'17181214',NULL,NULL,NULL,NULL,NULL),
 (213,'17181443',NULL,NULL,NULL,NULL,NULL),
 (214,'17181444',NULL,NULL,NULL,NULL,NULL),
 (215,'17181445',NULL,NULL,NULL,NULL,NULL),
 (216,'17181446',NULL,NULL,NULL,NULL,NULL),
 (217,'17181447',NULL,NULL,NULL,NULL,NULL),
 (218,'17181448',NULL,NULL,NULL,NULL,NULL),
 (219,'17181449',NULL,NULL,NULL,NULL,NULL),
 (220,'17181455',NULL,NULL,NULL,NULL,NULL),
 (221,'17181056',NULL,NULL,NULL,NULL,NULL),
 (222,'171810056',NULL,NULL,NULL,NULL,NULL),
 (223,'17181031',NULL,NULL,NULL,NULL,NULL),
 (224,'171810031',NULL,NULL,NULL,NULL,NULL),
 (225,'18191201801',NULL,NULL,NULL,NULL,NULL),
 (226,'18191201804',NULL,NULL,NULL,NULL,NULL),
 (227,'18191201805',NULL,NULL,NULL,NULL,NULL),
 (228,'18191201806',NULL,NULL,NULL,NULL,NULL),
 (229,'18191201807',NULL,NULL,NULL,NULL,NULL),
 (230,'18191201808',NULL,NULL,NULL,NULL,NULL),
 (231,'18191201810',NULL,NULL,NULL,NULL,NULL),
 (232,'18191201811',NULL,NULL,NULL,NULL,NULL),
 (233,'18191201812',NULL,NULL,NULL,NULL,NULL),
 (234,'18191201813',NULL,NULL,NULL,NULL,NULL),
 (235,'18191201817',NULL,NULL,NULL,NULL,NULL),
 (236,'18191201818',NULL,NULL,NULL,NULL,NULL),
 (237,'18191201819',NULL,NULL,NULL,NULL,NULL),
 (238,'18191201820',NULL,NULL,NULL,NULL,NULL),
 (239,'18191201821',NULL,NULL,NULL,NULL,NULL),
 (240,'18191201822',NULL,NULL,NULL,NULL,NULL),
 (241,'18191201823',NULL,NULL,NULL,NULL,NULL),
 (242,'18191201824',NULL,NULL,NULL,NULL,NULL),
 (243,'18191201825',NULL,NULL,NULL,NULL,NULL),
 (244,'18191201826',NULL,NULL,NULL,NULL,NULL),
 (245,'18191201827',NULL,NULL,NULL,NULL,NULL),
 (246,'18191201850',NULL,NULL,NULL,NULL,NULL),
 (247,'18191201837',NULL,NULL,NULL,NULL,NULL),
 (248,'18191201838',NULL,NULL,NULL,NULL,NULL),
 (249,'18191201839',NULL,NULL,NULL,NULL,NULL),
 (250,'18191201840',NULL,NULL,NULL,NULL,NULL),
 (251,'18191201841',NULL,NULL,NULL,NULL,NULL),
 (252,'18191201842',NULL,NULL,NULL,NULL,NULL),
 (253,'16171201617',NULL,NULL,NULL,NULL,NULL),
 (254,'181910001',NULL,NULL,NULL,NULL,NULL),
 (255,'18191617025',NULL,NULL,NULL,NULL,NULL),
 (256,'1819161702512',NULL,NULL,NULL,NULL,NULL);

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

--
-- Table structure for table `s_office_info`
--

CREATE TABLE IF NOT EXISTS `s_office_info` (
  `s_office_info_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_total_fee` float DEFAULT NULL,
  `s_paid_fee` float DEFAULT NULL,
  `s_pending_fee` float DEFAULT NULL,
  `s_payment_date` date DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_concession` varchar(45) DEFAULT NULL,
  `give_concession` varchar(45) DEFAULT NULL,
  `concession_reason` varchar(200) DEFAULT NULL,
  `scholarship` varchar(45) DEFAULT NULL,
  `scholarship_pending` varchar(45) DEFAULT NULL,
  `admission_status` varchar(45) DEFAULT NULL,
  `admission_date` date DEFAULT NULL,
  `admission_type` varchar(45) DEFAULT NULL,
  `transfer_narration` varchar(500) DEFAULT NULL,
  `paid_fee_per` varchar(45) DEFAULT NULL,
  `is_rte_student` varchar(45) DEFAULT NULL,
  `caste_wise_fee` varchar(45) DEFAULT NULL,
  `caste_fee_details_id` int(10) DEFAULT NULL,
  `is_scholarship` varchar(45) DEFAULT NULL,
  `scholarship_amount` varchar(45) DEFAULT NULL,
  `scholarship_student_amount` varchar(45) DEFAULT NULL,
  `scholarship_pending_student_amount` varchar(45) DEFAULT NULL,
  `goverment_pending_amount` varchar(45) DEFAULT NULL,
  `scholarship_paid_student_amount` varchar(45) DEFAULT NULL,
  `goverment_paid_amount` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_office_info_id`),
  KEY `FK_s_office_info_1` (`s_personal_info_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `s_office_info`
--
INSERT INTO `s_office_info` (`s_office_info_id`, `s_personal_info_id`, `s_total_fee`, `s_paid_fee`, `s_pending_fee`, `s_payment_date`, `s_standard`,
 `s_concession`, `give_concession`, `concession_reason`,`scholarship`, `admission_date`,  `scholarship_pending`, `admission_status`, `admission_type`, `scholarship_pending_student_amount`,
 `scholarship_amount`,`goverment_paid_amount`, `goverment_pending_amount`,`scholarship_student_amount`) VALUES
 (2,'141511001',74000,0,74000,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (3,'141511002',74000,0,74000,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (4,'141511003',74000,0,74000,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (5,'141511004',74000,0,74000,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (6,'141511005',74000,0,74000,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (7,'141511006',74000,-623,74623,NULL,'SECOND','0.0',NULL,NULL,'0','2016-11-22','EBC','Not Selected','Regular','First Shift','0','0','0','0'),
 (8,'141511007',74000,0,74000,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (9,'141511008',74000,0,74000,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (10,'141511009',74000,3830,70170,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (11,'141511010',74000,5755,68245,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (12,'141511011',74000,0,74000,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (13,'141511012',74000,0,74000,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (14,'141511013',74000,25000,49000,NULL,'SECOND','0.0',NULL,NULL,'0','2014-06-13','Not Selected','Not Selected','New','First Shift','0','0','0','0'),
 (15,'14151016',74000,10000,64000,NULL,'FIRST','0.0',NULL,NULL,NULL,NULL,NULL,NULL,'New','First Shift','0','0','0','0'),
 (16,'14151010',74000,16630,57370,NULL,'FIRST','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (17,'14151011',74000,9630,64370,NULL,'FIRST','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (18,'14151020',74000,0,74000,NULL,'FIRST','0.0',NULL,NULL,'0','2014-07-19','EBC','Not Applicable',NULL,NULL,'0','0','0','0'),
 (19,'14151028',37000,21630,15370,NULL,'FIRST','0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Shift','0','0','0','0'),
 (20,'14151014',74000,1630,72370,NULL,'FIRST','0','No','',NULL,NULL,'Not Applicable','Not Applicable',NULL,'First Shift','0','0','0','0'),
 (21,'14151001',0,1280,-1280,NULL,'FIRST','0.0',NULL,NULL,'74000.0','09-07-2012','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (22,'141510119',74000,780,73220,NULL,'FIRST','0.0',NULL,NULL,'0','02-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (23,'1415100121',74000,780,73220,NULL,'SECOND','0.0',NULL,NULL,'0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (24,'141510202',74000,530,73470,NULL,'FIRST','0.0',NULL,NULL,'0','03-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (25,'141512117',74000,1030,72970,NULL,'FIRST','0.0',NULL,NULL,'0','07-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (26,'14151008',74000,1630,72370,NULL,'FIRST','0.0',NULL,NULL,'0','07-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (27,'141512550',37000,530,36470,NULL,'FIRST','0.0',NULL,NULL,'37000.0','02-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (28,'141512551',0,780,-780,NULL,'FIRST','0.0',NULL,NULL,'74000.0','01-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (29,'14151303',0,0,0,NULL,'FIRST','0.0',NULL,NULL,'74000.0','03-08-2014','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (30,'14151315',0,1555,-1555,NULL,'SECOND','0.0',NULL,NULL,'74000.0','05-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (31,'14151316',0,1555,-1555,NULL,'SECOND','0.0',NULL,NULL,'74000.0','03-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (32,'14151141',74000,8260,65740,NULL,'FIRST','0.0',NULL,NULL,'0','05-10-2014','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (33,'14151191',74000,1630,72370,NULL,'FIRST','0.0',NULL,NULL,'0','08-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (34,'14151552',74000,1630,72370,NULL,'FIRST','0.0',NULL,NULL,'0','09-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (35,'14151556',37000,1630,35370,NULL,'FIRST','0.0',NULL,NULL,'37000.0','09-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (36,'14151825',37000,1630,35370,NULL,'FIRST','0.0',NULL,NULL,'37000.0','09-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (37,'1415122255',74000,2230,71770,NULL,'FIRST','0.0',NULL,NULL,'0','09-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (38,'141512266',37000,1630,35370,NULL,'FIRST','0.0',NULL,NULL,'37000.0','17-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (39,'14151585',74000,1555,72445,NULL,'FIRST','0.0',NULL,NULL,'0','06-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (40,'14151555',74000,1630,72370,NULL,'FIRST','0.0',NULL,NULL,'0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (41,'14151447',74000,21630,52370,NULL,'FIRST','0.0',NULL,NULL,'0','09-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (42,'14151559',74000,26630,47370,NULL,'FIRST','0.0',NULL,NULL,'0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (43,'14151777',0,1630,-1630,NULL,'FIRST','0.0',NULL,NULL,'74000.0','2016-11-22','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (44,'14151225',0,2100,-2100,NULL,'FIRST','0.0',NULL,NULL,'74000.0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (45,'14151558',74000,1630,72370,NULL,'FIRST','0.0',NULL,NULL,'0','03-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (46,'141515486',0,1630,-1630,NULL,'FIRST','0.0',NULL,NULL,'74000.0','2016-11-22','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (47,'141514584',37000,1630,35370,NULL,'FIRST','0.0',NULL,NULL,'37000.0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (48,'1415145684',37000,1630,35370,NULL,'FIRST','0.0',NULL,NULL,'37000.0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (49,'141515648',74000,1480,72520,NULL,'SECOND','0.0',NULL,NULL,'0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (50,'141514595',74000,1480,72520,NULL,'FIRST','0.0',NULL,NULL,'0','16-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (51,'14151458',74000,1480,72520,NULL,'FIRST','0.0',NULL,NULL,'0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (52,'1415145894',37000,1630,35370,NULL,'FIRST','0.0',NULL,NULL,'37000.0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (53,'141514518',74000,0,74000,NULL,'FIRST','0.0','No',NULL,'0','03-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (54,'141514589',74000,1630,72370,NULL,'FIRST','0.0',NULL,NULL,'0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (55,'141514568',74000,1630,72370,NULL,'FIRST','0.0',NULL,NULL,'0','11-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (56,'1415145895',74000,1630,72370,NULL,'FIRST','0.0',NULL,NULL,'0','29-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (57,'1415145896',74000,1630,72370,NULL,'FIRST','0.0',NULL,NULL,'0','10-10-2014','Not Selected','Not Selected',NULL,'First Shift','0','0','0','0'),
 (58,'14151458964',74000,0,74000,NULL,'FIRST','0.0',NULL,NULL,'0','17-10-2014','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (59,'14151459654',0,0,0,NULL,'FIRST','0.0',NULL,NULL,'74000.0','15-10-2014','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (60,'1415145847',74000,10000,64000,NULL,'FIRST','0.0',NULL,NULL,'0','16-10-2014','Not Selected','Not Selected','New','First Shift','0','0','0','0'),
 (61,'14151458794',74000,0,74000,NULL,'FIRST','0.0',NULL,NULL,'0','10-10-2014','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (62,'10111032',76500,76500,0,NULL,'FIRST','0.0',NULL,NULL,'0','06-09-2010','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (63,'161715001',1400,100,1300,NULL,'FIRST','0.0',NULL,NULL,'0','2016-11-21','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (64,'16171512',71300,52409,53782,NULL,'Second','0','No',NULL,'0','08-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (65,'16171209',71300,68482,32818,NULL,'Second','0','No',NULL,'0','13-08-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (66,'16171104',38891,36000,38891,NULL,'Second','0','No',NULL,'35650.0','04-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (67,'16171219',71300,0,71300,NULL,'FIRST','0.0',NULL,NULL,'0','13-08-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (68,'16171222',71300,60000,71300,NULL,'Second','0','No',NULL,'0','13-08-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (69,'16171216',71300,52000,65300,NULL,'Second','0','No',NULL,'0','13-08-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (71,'16171211',71300,48409,28891,NULL,'Second','0','No',NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (72,'16171160',38891,17891,21000,NULL,'FIRST','0.0',NULL,NULL,'35650.0','06-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (73,'16171189',71300,52409,26391,NULL,'Second','0','No',NULL,'0','06-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (74,'16171206',71300,0,71300,NULL,'FIRST','0.0',NULL,NULL,'0','09-08-2016','EBC','Apply',NULL,NULL,'0','0','0','0'),
 (75,'16171193',6482,0,12964,NULL,'Second','0','No',NULL,'0','06-08-2016','Scholorship','Apply',NULL,NULL,'0','0','0','0'),
 (76,'16171210',6482,6482,3950,NULL,'Second','0','No',NULL,'0','09-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (77,'16171218',71300,52409,34891,NULL,'Second','0','No',NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (79,'16171227',71300,60000,26300,NULL,'Second','0','No',NULL,'0','09-08-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (80,'16171196',6482,6482,6482,NULL,'Second','0','No',NULL,'0','08-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (81,'16171212',38891,25000,38891,NULL,'Second','0','No',NULL,'0','09-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (82,'16171199',71300,48409,44891,NULL,'Second','0','No',NULL,'0','08-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (83,'16171514',71300,0,71300,NULL,'Second','0','No',NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (84,'16171188',71300,45000,46300,NULL,'Second','0','No',NULL,'0','05-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (85,'16171163',71300,0,71300,NULL,'FIRST','0.0',NULL,NULL,'0','06-08-2016','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (86,'16171201',71300,48409,33891,NULL,'Second','0','No',NULL,'0','08-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (87,'16171213',38891,25000,38891,NULL,'Second','0','No',NULL,'35650.0','09-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (88,'16171200',71300,52409,33891,NULL,'Second','0','No',NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (89,'16171162',38891,0,38891,NULL,'FIRST','0.0',NULL,NULL,'35650.0','04-08-2016','Scholorship','Apply',NULL,NULL,'0','0','0','0'),
 (90,'16171159',71300,52409,34891,NULL,'Second','0','No',NULL,'0','06-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (91,'16171182',6482,6482,0,NULL,'Second','0','No','','0','04-0--2-16','Scholarship','Approved','New','First Shift','0','0','0','0'),
 (92,'16171161',71300,22891,48409,NULL,'FIRST','0.0',NULL,NULL,'0','06-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (93,'16171174',6482,6482,2482,NULL,'Second','0','No',NULL,'0','04-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (94,'16171195',6482,0,6482,NULL,'FIRST','0.0',NULL,NULL,'71300.0','09-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (95,'1617179',71300,65300,6000,NULL,'FIRST','0.0',NULL,NULL,'0','04-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (96,'16171205',6482,6482,0,NULL,'Second','0','No',NULL,'0','09-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (97,'16171190',6482,6482,0,NULL,'Second','0','No',NULL,'0','06-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (98,'16171207',71300,52409,18891,NULL,'Second','0','No',NULL,'0','06-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (99,'16171183',71300,60000,71300,NULL,'Second','0','No',NULL,'0','04-08-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (100,'16171176',71300,25000,57300,NULL,'Second','0','No',NULL,'0','06-08-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (101,'16171191',6482,0,6482,NULL,'FIRST','0.0',NULL,NULL,'71300.0','06-08-2016','Scholorship','Apply',NULL,NULL,'0','0','0','0'),
 (102,'16171202',0,0,0,NULL,'Second','0','No',NULL,'0','09-08-2016','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (103,'16171194',6482,6482,0,NULL,'Second','0','No',NULL,'0','06-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (104,'16171203',6482,6482,6482,NULL,'Second','0','No',NULL,'0','09-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (105,'16171223',38891,0,54891,NULL,'Second','0','No',NULL,'0','09-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (106,'16171175',71300,47409,33891,NULL,'Second','0','No',NULL,'0','04-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (107,'16171192',6482,6482,0,NULL,'Second','0','No',NULL,'0','2016-08-06','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (108,'16171180',71300,32409,41891,NULL,'Second','0','No',NULL,'0','04-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (109,'16171208',71300,32409,56651,NULL,'Second','0','No',NULL,'0','','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (110,'16171197',6482,6482,0,NULL,'Second','0','No',NULL,'0','08-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (111,'16171181',6482,6482,6482,NULL,'Second','0','No',NULL,'0','04-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (112,'16171204',6482,0,6482,NULL,'FIRST','0.0',NULL,NULL,'71300.0','04-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (113,'16171185',6482,6482,0,NULL,'Second','0','No',NULL,'0','05-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (115,'16171224',71300,36409,34891,NULL,'FIRST','0.0',NULL,NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (116,'16171230',71300,22891,48409,NULL,'FIRST','0.0',NULL,NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (117,'16171229',71300,55300,16000,NULL,'FIRST','0.0',NULL,NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (118,'16171198',6482,6482,64818,NULL,'Second','0','No',NULL,'0','06-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (119,'16171521',77004,56998,20006,NULL,'SECOND','0.0',NULL,NULL,'0','14-10-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (120,'16171498',7000,2000,5000,NULL,'SECOND','0.0',NULL,NULL,'71300.0','14-10-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (121,'16171156',77004,22002,55002,NULL,'SECOND','0.0',NULL,NULL,'0','10-10-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (122,'16171500',77004,46998,30006,NULL,'SECOND','0.0',NULL,NULL,'0','10-10-2016','EBC','Not Applicable','Regular','First Shift','0','0','0','0'),
 (123,'16171517',77004,24283,52721,NULL,'SECOND','0.0',NULL,NULL,'0','24-10-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (124,'16171518',77004,57004,20000,NULL,'SECOND','0.0',NULL,NULL,'0','14-10-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (125,'16171519',77004,0,77004,NULL,'SECOND','0.0',NULL,NULL,'0','14-10-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (126,'16171510',77004,32004,45000,NULL,'SECOND','0.0',NULL,NULL,'0','14-10-2016','Not Selected','Not Applicable','Regular','First Shift','0','0','0','0'),
 (127,'16171507',77004,66998,10006,NULL,'SECOND','0.0',NULL,NULL,'0','08-10-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (128,'16171483',42002,17002,25000,NULL,'SECOND','0.0',NULL,NULL,'35650.0','14-11-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (129,'16171495',42002,22002,20000,NULL,'SECOND','0.0',NULL,NULL,'35650.0','14-10-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (130,'16171485',77004,66998,10006,NULL,'SECOND','0.0',NULL,NULL,'0','27-09-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (131,'16171490',77004,17004,60000,NULL,'SECOND','0.0',NULL,NULL,'0','14-10-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (132,'16171493',42002,17002,25000,NULL,'SECOND','0.0',NULL,NULL,'35650.0','14-10-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (133,'16171492',42002,22004,19998,NULL,'SECOND','0.0',NULL,NULL,'35650.0','18-10-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (134,'16171513',42002,10000,32002,NULL,'SECOND','0.0',NULL,NULL,'35650.0','08-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (135,'16171499',77004,53408,23596,NULL,'SECOND','0.0',NULL,NULL,'0','16-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (136,'16171481',77004,66998,10006,NULL,'SECOND','0.0',NULL,NULL,'0','31-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (137,'16171497',77004,57004,20000,NULL,'SECOND','0.0',NULL,NULL,'0','14-10-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (138,'16171509',42002,22002,20000,NULL,'SECOND','0.0',NULL,NULL,'35650.0','14-10-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (139,'16171516',77004,22004,55000,NULL,'SECOND','0.0',NULL,NULL,'0','14-10-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (140,'16171478',77004,15702,61302,NULL,'SECOND','0.0',NULL,NULL,'0','14-10-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (141,'16171496',42002,17002,25000,NULL,'SECOND','0.0',NULL,NULL,'35650.0','20-10-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (142,'16171486',77004,62004,15000,NULL,'SECOND','0.0',NULL,NULL,'0','27-09-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (143,'16171488',7000,0,7000,NULL,'SECOND','0.0',NULL,NULL,'71300.0','28-09-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (144,'16171225',77004,66848,10156,NULL,'SECOND','0.0',NULL,NULL,'0','25-11-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (145,'16171320',77004,57004,20000,NULL,'SECOND','0.0',NULL,NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (146,'1617145',42002,31696,10306,NULL,'SECOND','0.0',NULL,NULL,'35650.0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (147,'1617122',7000,0,7000,NULL,'SECOND','0.0',NULL,NULL,'71300.0','09-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (148,'1617155',77004,59504,17500,NULL,'SECOND','0.0',NULL,NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (149,'1617124',71300,38891,103709,NULL,'Second','0','No',NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (150,'1617131',NULL,0,NULL,NULL,'FIRST','0.0',NULL,NULL,NULL,'09-08-2016','Scholorship','Apply',NULL,NULL,'0','0','0','0'),
 (151,'1617132',77004,66998,10006,NULL,'SECOND','0.0',NULL,NULL,'0','09-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (152,'1617133',6482,6482,0,NULL,'Second','0','No',NULL,'0','09-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (153,'1617134',6482,6482,6482,NULL,'Second','0','No',NULL,'0','09-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (154,'1617135',71300,0,142600,NULL,'Second','0','No',NULL,'0','04-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (155,'1617136',77004,67004,10000,NULL,'SECOND','0.0',NULL,NULL,'0','04-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (156,'1617137',77004,77004,0,NULL,'SECOND','0.0',NULL,NULL,'0','06-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (157,'1617138',7000,0,7000,NULL,'SECOND','0.0',NULL,NULL,'71300.0','06-08-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (158,'1617139',77004,9055,67949,NULL,'SECOND','0.0',NULL,NULL,'0','04-08-2016','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (159,'1617140',6482,6482,0,NULL,'Second','0','No',NULL,'0','14-10-2016','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (160,'1617141',77004,57004,20000,NULL,'SECOND','0.0',NULL,NULL,'0','06-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (161,'1617146',77004,57004,20000,NULL,'SECOND','0.0',NULL,NULL,'0','04-08-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (162,'16171305',77004,62002,15002,NULL,'SECOND','0.0',NULL,NULL,'0','17-07-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (163,'16171351',77004,56998,20006,NULL,'SECOND','0.0',NULL,NULL,'0','17-07-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (164,'16171352',77004,77004,0,NULL,'SECOND','0.0',NULL,NULL,'0','18-07-2016','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (165,'16171354',71300,52000,71300,NULL,'Second','0','No',NULL,'0','13-08-2016','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (166,'16171355',77004,71998,5006,NULL,'SECOND','0.0',NULL,NULL,'0','18-07-2016','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (167,'17181232',30873,20000,21366,NULL,'Second','0','No',NULL,'0','19-07-2017','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (168,'17181233',30873,30872,1762,NULL,'Second','0','No',NULL,'0','19-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (170,'17181234',56600,40000,16600,NULL,'FIRST','0.0',NULL,NULL,'0','20-07-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (171,'17181236',5145,5145,0,NULL,'Second','0','No',NULL,'0','21-07-2017','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (172,'17181235',56600,19000,37600,NULL,'FIRST','0.0',NULL,NULL,'0','21-07-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (173,'17181245',56600,56600,0,NULL,'FIRST','0.0',NULL,NULL,'0','22-07-2017','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (174,'17181238',30873,29272,1601,NULL,'FIRST','0.0',NULL,NULL,'28300.0','22-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (175,'17181242',56600,40726,15874,NULL,'Second','0','No',NULL,'0','24-07-2017','EBC','Not Applicable','New','First Shift','0','0','0','0'),
 (176,'17181241',56600,45601,10999,NULL,'Second','0','No',NULL,'0','24-07-2017','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (177,'17181164',56600,56455,25873,NULL,'Second','0','No',NULL,'0','24-07-2017','EBC','Apply','Regular','First Shift','0','15000','0','0'),
 (178,'17181097',30873,16000,14874,NULL,'Second','0','No',NULL,'0','24-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (181,'17181239',5145,5145,0,NULL,'FIRST','0.0',NULL,NULL,'56600.0','24-07-2017','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (182,'17181302',5145,3595,1550,NULL,'FIRST','0.0',NULL,NULL,'56600.0','24-07-2017','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (183,'17181279',30873,15200,15674,NULL,'Second','0','No',NULL,'0','24-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (184,'17181165',56600,45728,40600,NULL,'Second','0','No',NULL,'0','24-07-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (185,'17181303',5145,5145,0,NULL,'Second','0','No',NULL,'0','24-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (186,'17181304',30873,30872,1552,NULL,'Second','0','No',NULL,'0','24-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (187,'171810165',56600,4000,52600,NULL,'FIRST','0.0',NULL,NULL,'0','24-07-2017','EBC','Apply','New','First Shift','0','0','0','0'),
 (188,'17181240',56600,56600,0,NULL,'Second','0','No',NULL,'0','24-07-2017','EBC','Apply','New','First Shift','0','0','0','0'),
 (189,'17181149',5145,5145,0,NULL,'FIRST','0.0',NULL,NULL,'56600.0','24-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (190,'17181150',56600,56600,0,NULL,'Second','0','No',NULL,'0','24-07-2017','EBC','Apply','New','First Shift','0','0','0','0'),
 (191,'17181166',5145,5145,0,NULL,'Second','0','No',NULL,'0','24-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (192,'17181403',30873,30872,2,NULL,'Second','0','No',NULL,'0','25-07-2017','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (193,'17181404',56600,12864,54972,NULL,'Second','0','No',NULL,'0','25-07-2017','EBC','Apply','New','First Shift','0','0','0','0'),
 (194,'17181401',56600,-1550,58150,NULL,'FIRST','0.0',NULL,NULL,'0','25-07-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (195,'17181402',0,-1365,1365,'2017-08-01','FIRST','0.0',NULL,NULL,NULL,'25-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (196,'17181406',5145,5145,0,NULL,'FIRST','0.0',NULL,NULL,'56600.0','25-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (197,'17181407',56600,41727,14873,NULL,'Second','0','No',NULL,'0','25-07-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (198,'17181405',56600,42728,13872,NULL,'Second','0','No',NULL,'0','25-07-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (199,'17181411',30873,5000,25874,NULL,'Second','0','No',NULL,'0','25-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (200,'17181412',5145,5000,145,NULL,'Second','0','No',NULL,'0','25-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (201,'17181409',56600,4000,52600,NULL,'FIRST','0.0',NULL,NULL,'0','25-07-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (202,'17181410',56600,4000,52600,NULL,'FIRST','0.0',NULL,NULL,'0','25-07-2017','EBC','Apply','Regular','First Shift','0','0','0','0'),
 (203,'17181413',30873,10450,20423,NULL,'FIRST','0.0',NULL,NULL,'28300.0','25-07-2017','Scholorship','Apply','New','First Shift','0','0','0','0'),
 (204,'16171010',77004,35002,42002,NULL,'SECOND','0.0',NULL,NULL,'0','09-08-2016','EBC','Apply','New','First Shift','0','0','0','0'),
 (205,'17181414',56600,56600,0,NULL,'FIRST','0.0',NULL,NULL,'0','25-07-2017','EBC','Not Applicable','Regular','First Shift','0','0','0','0'),
 (206,'17181148',56600,56600,0,NULL,'FIRST','0.0',NULL,NULL,'0','16-08-2017','EBC','Not Applicable','Regular','First Shift','0','0','0','0'),
 (208,'17181158',6482,3377,3105,NULL,'SECOND','0.0',NULL,NULL,'56600.0','31-08-2017','Scholorship','Apply','Regular','First Shift','0','0','0','0'),
 (209,'171810411',56600,43736,38592,NULL,'Second','0','No',NULL,'0','24-08-2017','EBC','Not Applicable','Regular','First Shift','0','0','0','0'),
 (210,'17181621',56600,55000,1600,NULL,'FIRST','0.0',NULL,NULL,'0.0','24-08-2017','Not Selected','Not Selected','New','First Shift','0','0','0','0'),
 (211,'17181231',56600,56600,0,NULL,'FIRST','0.0',NULL,NULL,'0.0','26-08-2017','Not Selected','Not Selected','New','First Shift','0','0','0','0'),
 (212,'17181214',38891,25000,13891,NULL,'SECOND','0.0',NULL,NULL,'64818','14-07-2016','Scholorship','Apply','Regular','First Shift','32409','0','32409','38891.0'),
 (213,'17181443',56600,56600,0,NULL,'Second','0','No',NULL,'0','23-08-2017','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (214,'17181444',56600,0,56600,NULL,'FIRST','0.0',NULL,NULL,'0.0','23-08-2017','Not Selected','Not Selected',NULL,NULL,'0','0','0','0'),
 (215,'17181445',56600,56600,0,NULL,'FIRST','0.0',NULL,NULL,'0.0','23-08-2017','Not Selected','Not Selected','New','First Shift','0','0','0','0'),
 (216,'17181446',56600,56600,600,NULL,'Second','0','No',NULL,'0','23-08-2017','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (217,'17181447',5145,0,5145,NULL,'FIRST','0.0',NULL,NULL,'51455','24-07-2017','Scholorship','Apply','New','First Shift','51455','0','51455','56600.0'),
 (218,'17181448',56600,40000,16600,NULL,'FIRST','0.0',NULL,NULL,'0.0','23-08-2017','Not Selected','Not Selected','Regular','First Shift','0','0','0','0'),
 (219,'17181449',6482,0,6482,NULL,'SECOND','0.0',NULL,NULL,'64818','19-07-2017','Scholorship','Apply','New','First Shift','64818','0','64818','71300.0'),
 (220,'17181455',56600,45000,11600,NULL,'Second','0','No',NULL,'0','18-08-2017','Not Selected','Not Selected','New','First Shift','0','0','0','0'),
 (221,'17181056',56600,4000,52600,NULL,'FIRST','0.0',NULL,NULL,'0.0','02-08-2017','EBC','Not Applicable','New','First Shift','0','0','0','0'),
 (222,'171810056',56600,4000,52600,NULL,'FIRST','0.0',NULL,NULL,'0.0','29-07-2017','EBC','Not Applicable','New','First Shift','0','0','0','0'),
 (223,'17181031',56600,4000,52600,NULL,'FIRST','0.0',NULL,NULL,'0.0','02-08-2017','EBC','Not Applicable','New','First Shift','0','0','0','0'),
 (224,'171810031',5145,4000,1145,NULL,'FIRST','0.0',NULL,NULL,'51455','31-07-2017','Scholorship','Apply','New','First Shift','51455','0','51455','56600.0'),
 (225,'18191201801',7268,7268,0,NULL,'FIRST','0.0',NULL,NULL,'77732','13-07-2018','Scholorship','Apply','New','First Shift','77732','0','77732','85000.0'),
 (226,'18191201804',85000,85000,0,NULL,'FIRST','0.0',NULL,NULL,'77732','16-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (227,'18191201805',7268,7268,0,NULL,'FIRST','0.0',NULL,NULL,'77732','19-07-2018','Scholorship','Apply','New','First Shift','77732','0','77732','85000.0'),
 (228,'18191201806',85000,75000,10000,NULL,'FIRST','0.0',NULL,NULL,'77732','19-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (229,'18191201807',85000,85000,0,NULL,'FIRST','0.0',NULL,NULL,'77732','21-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (230,'18191201808',85000,20000,65000,NULL,'FIRST','0.0',NULL,NULL,'77732','18-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (231,'18191201810',7268,7268,0,NULL,'FIRST','0.0',NULL,NULL,'77732','16-07-2018','Scholorship','Apply','New','First Shift','77732','0','77732','85000.0'),
 (232,'18191201811',7268,7268,0,NULL,'FIRST','0.0',NULL,NULL,'77732.0','13-07-2018','Not Selected','Apply','New','First Shift','0','0','0','0'),
 (233,'18191201812',85000,85000,0,NULL,'FIRST','0.0',NULL,NULL,'77732','16-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (234,'18191201813',85000,46134,38866,NULL,'FIRST','0.0',NULL,NULL,'77732','25-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (235,'18191201817',7268,7268,0,NULL,'FIRST','0.0',NULL,NULL,'77732','24-07-2018','Scholorship','Apply','New','First Shift','77732','0','77732','85000.0'),
 (236,'18191201818',7268,7268,0,NULL,'FIRST','0.0',NULL,NULL,'77732','24-07-2018','Scholorship','Apply','New','First Shift','77732','0','77732','85000.0'),
 (237,'18191201819',85000,67117,17883,NULL,'FIRST','0.0',NULL,NULL,'77732','24-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (238,'18191201820',85000,49433,35567,NULL,'FIRST','0.0',NULL,NULL,'77732','24-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (239,'18191201821',85000,38866,46134,NULL,'FIRST','0.0',NULL,NULL,'77732','25-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (240,'18191201822',7268,7268,0,NULL,'FIRST','0.0',NULL,NULL,'77732','27-07-2018','Scholorship','Apply','New','First Shift','77732','0','77732','85000.0'),
 (241,'18191201823',85000,58866,26134,NULL,'FIRST','0.0',NULL,NULL,'77732','26-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (242,'18191201824',7268,0,7268,NULL,'FIRST','0.0',NULL,NULL,'77732','26-07-2018','Scholorship','Apply','New','First Shift','77732','0','77732','85000.0'),
 (243,'18191201825',85000,0,85000,NULL,'FIRST','0.0',NULL,NULL,'77732','26-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (244,'18191201826',7268,7268,0,NULL,'FIRST','0.0',NULL,NULL,'77732','26-07-2018','Scholorship','Apply','New','First Shift','77732','0','77732','85000.0'),
 (245,'18191201827',85000,46134,38866,NULL,'FIRST','0','No','',NULL,'2018-07-27','EBC','Apply',NULL,NULL,'38866','19433','0','46134.0'),
 (246,'18191201850',7268,7268,0,NULL,'FIRST','0.0',NULL,NULL,'77732','16-07-2018','Scholorship','Apply','New','First Shift','77732','0','77732','85000.0'),
 (247,'18191201837',85000,19433,65567,NULL,'FIRST','0.0',NULL,NULL,'77732','16-07-2018','Scholorship','Apply','New','First Shift','77732','19433','0','85000.0'),
 (248,'18191201838',85000,38866,46134,NULL,'FIRST','0.0',NULL,NULL,'77732','16-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (249,'18191201839',85000,23450,61550,NULL,'FIRST','0.0',NULL,NULL,'0.0','16-07-2018','EBC','Not Applicable','New','First Shift','0','0','0','0'),
 (250,'18191201840',85000,17883,67117,NULL,'FIRST','0.0',NULL,NULL,'77732','16-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (251,'18191201841',46134,-1550,47684,NULL,'FIRST','0.0',NULL,NULL,'77732','16-07-2018','Scholorship','Apply','New','First Shift','38866','0','38866','46134.0'),
 (252,'18191201842',85000,38866,46134,NULL,'FIRST','0.0',NULL,NULL,'77732','16-07-2018','EBC','Apply','New','First Shift','38866','0','38866','85000'),
 (253,'16171201617',71300,10000,61300,NULL,'FIRST','0.0',NULL,NULL,'0','13-09-2016','Scholorship','Apply','New','First Shift',NULL,'0',NULL,'0.0'),
 (254,'181910001',56600,38592,18008,NULL,'SECOND','0.0',NULL,NULL,'51455','19-09-2018','EBC','Apply','New','First Shift','25727','0','25727','56600'),
 (255,'18191617025',56600,38592,18008,NULL,'SECOND','0.0',NULL,NULL,'0','09-07-2018','Scholorship','Apply','Regular','First Shift',NULL,'0',NULL,'0.0'),
 (256,'1819161702512',56600,38592,18008,NULL,'SECOND','0.0',NULL,NULL,'51455','16-07-2018','EBC','Apply','Regular','First Shift','25727','0','25727','56600');
-- --------------------------------------------------------

--
-- Table structure for table `s_other_fee`
--

CREATE TABLE IF NOT EXISTS `s_other_fee` (
  `s_other_fee_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) NOT NULL,
  `s_total_fee` float DEFAULT NULL,
  `s_paid_fee` float DEFAULT NULL,
  `s_pending_fee` float DEFAULT NULL,
  `s_payment_date` date DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `academic_year` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_other_fee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_other_fee_history`
--

CREATE TABLE IF NOT EXISTS `s_other_fee_history` (
  `s_other_fee_history_id` int(10) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) DEFAULT NULL,
  `s_total_fee` float DEFAULT NULL,
  `s_paid_fee` float DEFAULT NULL,
  `s_pending_fee` float DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `academic_year` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_other_fee_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_promoted`
--

CREATE TABLE IF NOT EXISTS `s_promoted` (
  `s_promoted_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(15) DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_current_standard` varchar(15) DEFAULT NULL,
  `s_next_standard` varchar(15) DEFAULT NULL,
  `is_promoted` varchar(15) DEFAULT NULL,
  `academic_year` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`s_promoted_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `s_promoted` (`s_promoted_id`,`s_personal_info_id`,`s_current_standard`,`s_next_standard`,`is_promoted`,`academic_year`,`s_section`) VALUES 
(1,'16171158','FIRST','Second','Promoted',NULL,'pass 1st year'),
 (2,'16171104','FIRST','Second','Promoted',NULL,'pass 1st year'),
 (3,'16171213','FIRST','Second','Promoted',NULL,'pass 1st year'),
 (4,'16171214','FIRST','Second','Promoted',NULL,'pass 1st year'),
 (5,'16171209','FIRST','Second','Promoted',NULL,'pass 1st year'),
 (6,'16171200','FIRST','Second','Promoted',NULL,'pass 1st year'),
 (7,'16171158','Second','','Promoted',NULL,'pass 1st year'),
 (8,'16171183','FIRST','Second','Promoted',NULL,'pass 1st year'),
 (9,'1617124','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (10,'16171222','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (11,'16171185','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (12,'16171203','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (13,'16171159','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (14,'16171212','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (15,'16171175','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (16,'16171207','FIRST','Second','Promoted','2016-17','1st year passed'),
 (17,'16171181','FIRST','Second','Promoted','2016-17','1st year passed'),
 (18,'16171512','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (19,'1617135','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (20,'1617133','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (21,'16171223','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (22,'16171216','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (23,'16171354','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (24,'16171201','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (25,'16171199','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (26,'16171198','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (27,'16171205','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (28,'16171197','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (29,'16171188','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (30,'16171514','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (31,'16171182','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (32,'16171211','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (33,'16171202','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (34,'16171193','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (35,'1617134','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (36,'16171192','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (37,'16171189','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (38,'16171190','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (39,'16171210','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (40,'16171227','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (41,'16171196','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (42,'16171174','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (43,'16171194','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (44,'1617140','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (45,'16171180','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (46,'16171218','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (47,'16171208','FIRST','Second','Promoted','2016-17','pass 1st year'),
 (48,'17181405','FIRST','Second','Promoted','2017-18','first year passed'),
 (49,'17181455','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (50,'17181232','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (51,'17181411','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (52,'17181165','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (53,'17181233','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (54,'17181446','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (55,'171810411','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (56,'17181240','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (57,'17181279','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (58,'17181443','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (59,'17181403','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (60,'17181303','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (61,'17181407','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (62,'17181236','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (63,'17181241','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (64,'17181150','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (65,'17181242','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (66,'17181166','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (67,'17181097','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (68,'17181164','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (69,'17181412','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (70,'17181304','FIRST','Second','Promoted','2017-18','Iyear passed'),
 (71,'16171176','FIRST','Second','Promoted','2016-17','Iyear passed'),
 (72,'17181404','FIRST','Second','Promoted','2017-18','Iyear passed');
-- --------------------------------------------------------

--
-- Table structure for table `s_results`
--

CREATE TABLE IF NOT EXISTS `s_results` (
  `s_results_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_personal_info_id` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_on` datetime DEFAULT NULL,
  PRIMARY KEY (`s_results_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_result_info`
--

CREATE TABLE IF NOT EXISTS `s_result_info` (
  `s_result_info_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_results_id` varchar(45) DEFAULT NULL,
  `s_section` varchar(45) DEFAULT NULL,
  `s_standard` varchar(45) DEFAULT NULL,
  `s_division` varchar(45) DEFAULT NULL,
  `s_branch_type` varchar(45) DEFAULT NULL,
  `exam_name` varchar(100) DEFAULT NULL,
  `exam_date` varchar(45) DEFAULT NULL,
  `subject_name` varchar(100) DEFAULT NULL,
  `internal_marks_out_of` varchar(45) DEFAULT NULL,
  `external_marks_out_of` varchar(45) DEFAULT NULL,
  `s_internal_marks` varchar(45) DEFAULT NULL,
  `s_external_marks` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_result_info_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `s_stationary_receipt`
--

CREATE TABLE IF NOT EXISTS `s_stationary_receipt` (
  `s_stationary_receipt_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `stationary_receipt_title_id` int(10) UNSIGNED NOT NULL,
  `s_personal_info_id` varchar(45) NOT NULL,
  `s_date` varchar(45) NOT NULL,
  `receipt_number` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`s_stationary_receipt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user_groups`
--

CREATE TABLE IF NOT EXISTS `user_groups` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(11) UNSIGNED NOT NULL,
  `group_id` int(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_user_groups_1_idx` (`user_id`),
  KEY `index3` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `voucher`
--

CREATE TABLE IF NOT EXISTS `voucher` (
  `voucher_number` varchar(20) NOT NULL,
  `voucher_type_name` varchar(100) NOT NULL,
  `voucher_date` date DEFAULT NULL,
  `paid_to` varchar(100) DEFAULT NULL,
  `amount` varchar(10) DEFAULT NULL,
  `towards` varchar(200) DEFAULT NULL,
  `is_cash_or_cheque` varchar(50) DEFAULT NULL,
  `cheque_number` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `cash_amount` varchar(10) DEFAULT NULL,
  `total` varchar(10) DEFAULT NULL,
  `received_by` varchar(100) DEFAULT NULL,
  `section` varchar(45) DEFAULT NULL,
  `particulars` varchar(45) DEFAULT NULL,
  `is_paid_received` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`voucher_number`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `voucher`
--



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

--
-- Table structure for table `voucher_type`
--

CREATE TABLE IF NOT EXISTS `voucher_type` (
  `voucher_type_id` int(10) NOT NULL AUTO_INCREMENT,
  `voucher_type_name` varchar(100) DEFAULT NULL,
  `budget_percent` varchar(10) DEFAULT NULL,
  `particular_exp` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`voucher_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `voucher_type`
--

INSERT INTO `voucher_type` (`voucher_type_id`, `voucher_type_name`, `budget_percent`, `particular_exp`) VALUES
(1, 'Advance Cash', NULL, NULL);

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

--
-- Table structure for table `working_days`
--

CREATE TABLE IF NOT EXISTS `working_days` (
  `working_days_id` int(10) NOT NULL AUTO_INCREMENT,
  `is_monday_open` varchar(20) DEFAULT NULL,
  `is_tuesday_open` varchar(20) DEFAULT NULL,
  `is_wednesday_open` varchar(20) DEFAULT NULL,
  `is_thursday_open` varchar(20) DEFAULT NULL,
  `is_friday_open` varchar(20) DEFAULT NULL,
  `is_saturday_open` varchar(20) DEFAULT NULL,
  `is_sunday_open` varchar(20) DEFAULT NULL,
  `is_first_third_open` varchar(20) DEFAULT NULL,
  `is_sec_third_open` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`working_days_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `daily_incoming_cash_info`
--
ALTER TABLE `daily_incoming_cash_info`
  ADD CONSTRAINT `FK_daily_cash_id` FOREIGN KEY (`daily_cash_id`) REFERENCES `daily_cash` (`daily_cash_id`);

--
-- Constraints for table `exam_timetable`
--
ALTER TABLE `exam_timetable`
  ADD CONSTRAINT `m_subject_info_id` FOREIGN KEY (`m_subject_info_id`) REFERENCES `m_subject` (`m_subject_info_id`);

--
-- Constraints for table `stationary_receipt_head`
--
ALTER TABLE `stationary_receipt_head`
  ADD CONSTRAINT `FK_stationary_receipt_head_1` FOREIGN KEY (`stationary_receipt_title_id`) REFERENCES `stationary_receipt_title` (`stationary_receipt_title_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
COMMIT;

