# Entry for A.K.CONSTRUTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('akconstructionprojects002@gmail.com', 'PPE 2', 'A.K.CONSTRUTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'akconstructionprojects002', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2105'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2105'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2105'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2105'); # Entry for AARMAN UDYOG INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('aarman.udyog@gmail.com', 'PPE 3', 'AARMAN UDYOG', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'aarman.udyog', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2323'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2123'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2123'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2123'); # Entry for AARVI ENCON LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('janasanjaykumar@yahoo.in', 'PPE 4', 'AARVI ENCON LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'janasanjaykumar', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2107'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2107'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2107'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2107'); # Entry for AASHA INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ashaa201040@gmail.com', 'PPE 5', 'AASHA', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ashaa201040', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2324'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2324'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2324'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2324'); # Entry for AAXIS NANO TECHNOLOGIES PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('service.east@aaxisnano.com', 'PPE 6', 'AAXIS NANO TECHNOLOGIES PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'service.east', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2325'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2325'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2325'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2325'); # Entry for ABB INDIA LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sanjoy.adhikary@in.abb.com', 'PPE 7', 'ABB INDIA LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sanjoy.adhikary', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2110'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2110'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2110'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2110'); # Entry for AFG COMBUSTION PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info@afgcombustion.com', 'PPE 8', 'AFG COMBUSTION PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2111'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2111'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2111'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2111'); # Entry for AGASTI TANK WORKS PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('projects@agasticorporation.com', 'PPE 9', 'AGASTI TANK WORKS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'projects', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2112'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2112'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2112'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2112'); # Entry for ALERT SERVICES INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('subham.nayak@cotecna.co.in', 'PPE 10', 'ALERT SERVICES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'subham.nayak', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2113'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2113'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2113'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2113'); # Entry for ALGODEX SYSTEMS PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sandip.chavan@algodex.net', 'PPE 11', 'ALGODEX SYSTEMS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sandip.chavan', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2114'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2114'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2114'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2114'); # Entry for ALMEISAN ENERGY INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('iamsuman.mallik@gmail.com', 'PPE 12', 'ALMEISAN ENERGY', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'iamsuman.mallik', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2115'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2115'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2115'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2115'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('dhritinandang@gmail.com', 'PPE 13', 'AMAR DYUTI X RAY CLINIC', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'dhritinandang', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2116'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2116'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2116'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2116'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('logistics@ame.net.in', 'PPE 14', 'AME INFRALOGISTICS PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'logistics', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2117'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2117'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2117'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2117'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info@anasyssolutions.com', 'PPE 15', 'ANASYS SOLUTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2118'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2118'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2118'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2118'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pradipb@anguil.com', 'PPE 16', 'ANGUIL ENVIRONMENTAL SYSTEMS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pradipb', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2119'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2119'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2119'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2119'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('anikethhaldia@rediffmail.com', 'PPE 17', 'ANIKETH ENGINEERING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'anikethhaldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2120'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2120'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2120'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2120'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('hr@arcreation.co.in', 'PPE 18', 'ARCREATION DESIGN PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'hr', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2121'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2121'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2121'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2121'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ardhendubikasdas@yahoo.com', 'PPE 19', 'ARDHENDU BIKAS DAS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ardhendubikasdas', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2122'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2122'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2122'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2122'); # Entry for ARUDRA ENGINEERS PRIVATE LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ajithkumar34725@gmail.com', 'PPE 20', 'ARUDRA ENGINEERS PRIVATE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ajithkumar34725', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2123'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2123'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2123'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2123'); # Entry for ASIATICS INFRATECHH PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info@asiaticsinfratechh.com', 'PPE 21', 'ASIATICS INFRATECHH PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2124'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2124'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2124'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2124'); # Entry for B.N.P. ENGINEERING INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info.bnp2015@gmail.com', 'PPE 22', 'B.N.P. ENGINEERING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info.bnp2015', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2125'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2125'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2125'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2125'); # Entry for B.P.ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kalyansinharoy@yahoo.co.in', 'PPE 23', 'B.P.ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kalyansinharoy', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2126'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2126'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2126'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2126'); # Entry for BAPI ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sukumardolai7@gmail.com', 'PPE 24', 'BAPI ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sukumardolai7', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2127'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2127'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2127'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2127'); # Entry for BEAUTY OF NATURE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('tapan_beautyofnature@rediffmail.com', 'PPE 25', 'BEAUTY OF NATURE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'tapan_beautyofnature', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2128'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2128'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2128'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2128'); # Entry for BERA ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bera.enterprise@yahoo.in', 'PPE 26', 'BERA ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bera.enterprise', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2129'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2129'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2129'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2129'); # Entry for BHARAT ENGINEERING CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bechplproject18@gmail.com', 'PPE 27', 'BHARAT ENGINEERING CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bechplproject18', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2130'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2130'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2130'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2130'); # Entry for BHARAT MOTOR INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bharatmotor2@gmail.com', 'PPE 28', 'BHARAT MOTOR', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bharatmotor2', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2131'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2131'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2131'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2131'); # Entry for BISTECH SOLUTIONS INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pijushgolui1995@gmail.com', 'PPE 29', 'BISTECH SOLUTIONS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pijushgolui1995', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2132'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2132'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2132'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2132'); # Entry for BONACE ENGINEERS PVT. LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('vivek.gautam@bonace.org', 'PPE 30', 'BONACE ENGINEERS PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'vivek.gautam', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2133'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2133'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2133'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2133'); # Entry for BRIDGE & ROOF CO. (INDIA) LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bandr61026@gmail.com', 'PPE 31', 'BRIDGE & ROOF CO. (INDIA) LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bandr61026', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2134'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2134'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2134'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2134'); # Entry for BSS TECH CP (INDIA) PVT. LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('anjan.elct@gmail.com', 'PPE 32', 'BSS TECH CP (INDIA) PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'anjan.elct', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2135'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2135'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2135'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2135'); # Entry for BURCKHARDT COMPRESSION INDIA PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('amitkumar.singh@burckhardtcompression.com', 'PPE 33', 'BURCKHARDT COMPRESSION INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'amitkumar.singh', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2136'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2136'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2136'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2136'); # Entry for BUSCH VACUUM INDIA PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('manash.sarkar@buschindia.com', 'PPE 34', 'BUSCH VACUUM INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'manash.sarkar', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2137'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2137'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2137'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2137'); # Entry for CARRION AIR COOLING INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('gm.carrionaircooling@gmail.com', 'PPE 35', 'CARRION AIR COOLING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'gm.carrionaircooling', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2138'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2138'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2138'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2138'); # Entry for CHEMBON WATER TECHNOLOGIES LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('soumik.banerjee@chembondwater.com', 'PPE 36', 'CHEMBON WATER TECHNOLOGIES LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'soumik.banerjee', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2139'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2139'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2139'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2139'); # Entry for CHETAN CORPORATION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('chetancorpo@gmail.com', 'PPE 37', 'CHETAN CORPORATION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'chetancorpo', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2140'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2140'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2140'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2140'); # Entry for CIRIA INDIA LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Ajeet.Singh@morganplc.com', 'PPE 38', 'CIRIA INDIA LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Ajeet.Singh', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2141'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2141'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2141'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2141'); # Entry for CITY CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('citycons.haldia@gmail.com', 'PPE 39', 'CITY CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'citycons.haldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2142'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2142'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2142'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2142'); # Entry for CONVERGENCE SOLUTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sankalan@convergencesolutions.in', 'PPE 40', 'CONVERGENCE SOLUTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sankalan', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2143'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2143'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2143'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2143'); # Entry for COOLING POINT INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rajumaity7890@gmail.com', 'PPE 41', 'COOLING POINT', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rajumaity7890', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2144'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2144'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2144'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2144'); # Entry for COTECNA INSPECTION (I) PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Siddhartha.Mondal@cotecna.co.in', 'PPE 42', 'COTECNA INSPECTION (I) PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Siddhartha.Mondal', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2145'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2145'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2145'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2145'); # Entry for D.M.P. NIRMAN PRIVATE LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('dmpnirman@yahoo.co.in', 'PPE 43', 'D.M.P. NIRMAN PRIVATE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'dmpnirman', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2146'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2146'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2146'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2146'); # Entry for DEBRAJ SURVEY CONSULTANCY INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('debraj.survey@gmail.com', 'PPE 44', 'DEBRAJ SURVEY CONSULTANCY', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'debraj.survey', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2147'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2147'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2147'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2147'); # Entry for DEMECH CHEMICAL PRODUCTS PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bimal@demechchemical.com', 'PPE 45', 'DEMECH CHEMICAL PRODUCTS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bimal', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2148'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2148'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2148'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2148'); # Entry for DES TECHNICO LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mrigankadtpl16@gmail.com', 'PPE 46', 'DES TECHNICO LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mrigankadtpl16', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2149'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2149'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2149'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2149'); # Entry for DEVELOPMENT CONSULTANT PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jayantashil88@gmail.com', 'PPE 47', 'DEVELOPMENT CONSULTANT PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jayantashil88', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2150'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2150'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2150'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2150'); # Entry for DHOON AUDIO VISUAL PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('support@dhoon.in', 'PPE 48', 'DHOON AUDIO VISUAL PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'support', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2151'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2151'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2151'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2151'); # Entry for DHP HEAVYLIFT SOLUTIONS PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('chandrakant.rathod@dhpheavy.com', 'PPE 49', 'DHP HEAVYLIFT SOLUTIONS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'chandrakant.rathod', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2152'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2152'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2152'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2152'); # Entry for DK ENGINEERING CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('msdkenggconshaldia@rediffmail.com', 'PPE 50', 'DK ENGINEERING CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'msdkenggconshaldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2153'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2153'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2153'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2153'); # Entry for DORF KETAL CHEMICAL (I) PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('priyanka.bhattacharjee@dorfketal.com', 'PPE 51', 'DORF KETAL CHEMICAL (I) PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'priyanka.bhattacharjee', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2154'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2154'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2154'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2154'); # Entry for ELECTROMECH ENGINEERING (THERMAX LTD) INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('cs.enterprises1695@gmail.com', 'PPE 52', 'ELECTROMECH ENGINEERING (THERMAX LTD)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'cs.enterprises1695', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2155'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2155'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2155'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2155'); # Entry for EMDADIYA INFRA PROJECTS PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('eminfra123@gmail.com', 'PPE 53', 'EMDADIYA INFRA PROJECTS PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'eminfra123', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2156'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2156'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2156'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2156'); # Entry for ENDRESS HAUSER INDIA PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sourabh.bag@endress.com', 'PPE 54', 'ENDRESS HAUSER INDIA PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sourabh.bag', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2157'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2157'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2157'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2157'); # Entry for ENVEA INDIA PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('s.ghosh@envea.global', 'PPE 55', 'ENVEA INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 's.ghosh', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2158'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2158'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2158'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2158'); # Entry for EQUINOX SOFTWARE AND SERVICES PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sachinpawar45@gmail.com', 'PPE 56', 'EQUINOX SOFTWARE AND SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sachinpawar45', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2159'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2159'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2159'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2159'); # Entry for ERNST & YOUNG LLP INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('om.nagumantri@in.ey.com', 'PPE 57', 'ERNST & YOUNG LLP', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'om.nagumantri', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2160'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2160'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2160'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2160'); # Entry for ESTEEM PROJECTS PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('269@esteem.co.in', 'PPE 58', 'ESTEEM PROJECTS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', '269', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2161'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2161'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2161'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2161'); # Entry for ETEK ENGINEERING INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jsk926496@gmail.com', 'PPE 59', 'ETEK ENGINEERING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jsk926496', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2162'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2162'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2162'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2162'); # Entry for EXIDE INDUSTRIES LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Prosenjit.R@exide.co.in', 'PPE 60', 'EXIDE INDUSTRIES LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Prosenjit.R', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2163'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2163'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2163'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2163'); # Entry for FLOWSERVE SANMAR PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pd13@sanmargroup.com', 'PPE 61', 'FLOWSERVE SANMAR PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pd13', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2164'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2164'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2164'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2164'); # Entry for FORAYS SERVICES & CONSTRUCTIONS PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('venugopal@forays.co.in', 'PPE 62', 'FORAYS SERVICES & CONSTRUCTIONS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'venugopal', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2165'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2165'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2165'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2165'); # Entry for FORBES MARSHALL INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('lokeshsingh@forbesmarshall.com', 'PPE 63', 'FORBES MARSHALL', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'lokeshsingh', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2166'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2166'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2166'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2166'); # Entry for FORTUNA IMPEX PVT.LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('timeoffice.support@hpl.co.in', 'PPE 64', 'FORTUNA IMPEX PVT.LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'timeoffice.support', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2167'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2167'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2167'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2167'); # Entry for FOX SOLUTION PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sudipto.sardar@foxindia.net', 'PPE 65', 'FOX SOLUTION PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sudipto.sardar', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2168'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2168'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2168'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2168'); # Entry for G4S SECURE SOLUTIONS (I) PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bappa.maulik@in.g4s.com', 'PPE 66', 'G4S SECURE SOLUTIONS (I) PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bappa.maulik', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2169'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2169'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2169'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2169'); # Entry for GAINWELL COMMOSALES PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('somnath.mondal@gainwellindia.com', 'PPE 67', 'GAINWELL COMMOSALES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'somnath.mondal', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2170'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2170'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2170'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2170'); # Entry for GARDNER DENVER ENGINEERED PRODUCTS INDIA PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('dwaipayan.das@irco.com', 'PPE 68', 'GARDNER DENVER ENGINEERED PRODUCTS INDIA PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'dwaipayan.das', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2171'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2171'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2171'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2171'); # Entry for GARUDA POWER LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('surojit.manna@garudapower.com', 'PPE 69', 'GARUDA POWER LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'surojit.manna', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2172'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2172'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2172'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2172'); # Entry for GEE BEE NETWORK PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pgbagari@gbnetwork.co.in', 'PPE 70', 'GEE BEE NETWORK PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pgbagari', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2173'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2173'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2173'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2173'); # Entry for GIRISH CHANDRA GHOSH & GGS INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('gcg.ggs.kol@gmail.com', 'PPE 71', 'GIRISH CHANDRA GHOSH & GGS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'gcg.ggs.kol', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2174'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2174'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2174'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2174'); # Entry for GLOBAL INTREGATED SYSTEMS INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('diliphazra87@gmail.com', 'PPE 72', 'GLOBAL INTREGATED SYSTEMS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'diliphazra87', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2175'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2175'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2175'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2175'); # Entry for GOUTAM TRADING INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('goutamtrading@gmail.com', 'PPE 73', 'GOUTAM TRADING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'goutamtrading', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2176'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2176'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2176'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2176'); # Entry for GRIP CONSULTING ENGINEERS LLP INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('utpal.ray@gripconsultant.com', 'PPE 74', 'GRIP CONSULTING ENGINEERS LLP', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'utpal.ray', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2177'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2177'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2177'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2177'); # Entry for GRIVETY GLOBAL PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('subhankarkarmakar023@gmail.com', 'PPE 75', 'GRIVETY GLOBAL PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'subhankarkarmakar023', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2178'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2178'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2178'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2178'); # Entry for HAL OFFSHORE LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('admin.haldia@haloffshore.com', 'PPE 76', 'HAL OFFSHORE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'admin.haldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2179'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2179'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2179'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2179'); # Entry for HALDIA SEVA SADAN INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('tarunpal2011@gmail.com', 'PPE 77', 'HALDIA SEVA SADAN', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'tarunpal2011', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2180'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2180'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2180'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2180'); # Entry for HALDIA SHEET METAL WORKS INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('haldia.sheet.2009@gmail.com', 'PPE 78', 'HALDIA SHEET METAL WORKS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'haldia.sheet.2009', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2181'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2181'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2181'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2181'); # Entry for HBL ENGINEERING LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('skarimullah@hbl.in', 'PPE 79', 'HBL ENGINEERING LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'skarimullah', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2182'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2182'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2182'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2182'); # Entry for HIMOYA CORROSION TECHNOLOGY PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('himoyacorrosion@gmail.com', 'PPE 80', 'HIMOYA CORROSION TECHNOLOGY PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'himoyacorrosion', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2183'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2183'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2183'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2183'); # Entry for HONEYWELL AUTOMATION INDIA LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('team.haldia@gmail.com', 'PPE 81', 'HONEYWELL AUTOMATION INDIA LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'team.haldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2184'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2184'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2184'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2184'); # Entry for HRITI ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('monig@eisec.com', 'PPE 82', 'HRITI ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'monig', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2185'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2185'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2185'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2185'); # Entry for IBM INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('arunray@in.ibm.com', 'PPE 83', 'IBM', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'arunray', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2186'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2186'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2186'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2186'); # Entry for IBM - CREATIVE INFO LINK PRIVATE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Projectmanager.ifms@hpl.co.in', 'PPE 84', 'IBM - CREATIVE INFO LINK PRIVATE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Projectmanager.ifms', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2187'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2187'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2187'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2187'); # Entry for IFB AGRO INDUSTRIES LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rajesh_mehra@ifbagro.in', 'PPE 85', 'IFB AGRO INDUSTRIES LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rajesh_mehra', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2188'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2188'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2188'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2188'); # Entry for INDUSTRIAL PLANT & SERVICE MALAYSIA BERHAD (MHI) INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('saya.kobayashi@mcm.mitsubishicorp.com', 'PPE 86', 'INDUSTRIAL PLANT & SERVICE MALAYSIA BERHAD (MHI)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'saya.kobayashi', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2189'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2189'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2189'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2189'); # Entry for INDUSTRIAL SERVICES INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('indus_8@yahoo.com', 'PPE 87', 'INDUSTRIAL SERVICES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'indus_8', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2190'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2190'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2190'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2190'); # Entry for INSPECTION SURVEY & SURVELLANCE(INDIA)PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('insurvey1980@gmail.com', 'PPE 88', 'INSPECTION SURVEY & SURVELLANCE(INDIA)PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'insurvey1980', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2191'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2191'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2191'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2191'); # Entry for INSPECTORATE GRIFTH INDIA PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ganesh.bera@bureauveritas.com', 'PPE 89', 'INSPECTORATE GRIFTH INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ganesh.bera', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2192'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2192'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2192'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2192'); # Entry for INSULREF TECHNOLOGIES PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('khatua.arindam@gmail.com', 'PPE 90', 'INSULREF TECHNOLOGIES PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'khatua.arindam', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2193'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2193'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2193'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2193'); # Entry for INTERTEK INDIA PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('monig@eisec.com', 'PPE 91', 'INTERTEK INDIA PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'monig', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2194'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2194'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2194'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2194'); # Entry for INVINCIBLE INDIAN CONSTRUCTION PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('iicpl.project@gmail.com', 'PPE 92', 'INVINCIBLE INDIAN CONSTRUCTION PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'iicpl.project', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2195'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2195'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2195'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2195'); # Entry for ION EXCHANGE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mailmearnabroy79@rediffmail.com', 'PPE 93', 'ION EXCHANGE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mailmearnabroy79', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2196'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2196'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2196'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2196'); # Entry for IR TECHNOLOGY SERVICES PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('u_das@irtech.in', 'PPE 94', 'IR TECHNOLOGY SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'u_das', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2197'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2197'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2197'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2197'); # Entry for JANA INDUSTRIES & CO. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('subhaschandrajana.2012@gmail.com', 'PPE 95', 'JANA INDUSTRIES & CO.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'subhaschandrajana.2012', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2198'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2198'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2198'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2198'); # Entry for JMD ENTERPRISES INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pipeproject-bomsupport@isgecynr.com', 'PPE 96', 'JMD ENTERPRISES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pipeproject-bomsupport', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2199'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2199'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2199'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2199'); # Entry for JOHNNY & ROHNNY INFRA. PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('obidur.r@johnnyrohnny.com', 'PPE 97', 'JOHNNY & ROHNNY INFRA. PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'obidur.r', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2200'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2200'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2200'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2200'); # Entry for JOY MAA TARA ENTERPRISE (DCPL) INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jayantashil88@gmail.com', 'PPE 98', 'JOY MAA TARA ENTERPRISE (DCPL)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jayantashil88', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2201'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2201'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2201'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2201'); # Entry for KARAN CONSTRUCTION COMPANY INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kcchpl123@gmail.com', 'PPE 99', 'KARAN CONSTRUCTION COMPANY', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kcchpl123', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2202'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2202'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2202'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2202'); # Entry for KONE ELEVATOR INDIA PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kartikchandra.senapati@kone.com', 'PPE 100', 'KONE ELEVATOR INDIA PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kartikchandra.senapati', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2203'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2203'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2203'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2203'); # Entry for LEAK PROOF ENGINEERING (I) PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kolkata@leakproofseals.com', 'PPE 101', 'LEAK PROOF ENGINEERING (I) PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kolkata', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2204'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2204'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2204'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2204'); # Entry for LLOYD INSULATIONS ( I ) LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('chandansinghh65@gmail.com', 'PPE 102', 'LLOYD INSULATIONS ( I ) LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'chandansinghh65', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2205'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2205'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2205'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2205'); # Entry for LTC INFRASTRUCTURE PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('hpl.ltc@gmail.com', 'PPE 103', 'LTC INFRASTRUCTURE PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'hpl.ltc', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2206'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2206'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2206'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2206'); # Entry for LUMMUS TECHNOLOGY INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('riazur.rahman@lummustech.com', 'PPE 104', 'LUMMUS TECHNOLOGY', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'riazur.rahman', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2207'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2207'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2207'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2207'); # Entry for M M CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mmchaldia@gmail.com', 'PPE 105', 'M M CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mmchaldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2208'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2208'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2208'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2208'); # Entry for M S CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('msconstructionhpl@yahoo.com', 'PPE 106', 'M S CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'msconstructionhpl', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2209'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2209'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2209'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2209'); # Entry for M.M. POWER INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('prosenjitchanda1985@gmail.com', 'PPE 107', 'M.M. POWER', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'prosenjitchanda1985', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2210'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2210'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2210'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2210'); # Entry for M.S ENGINEERING INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mse.haldia@gmail.com', 'PPE 108', 'M.S ENGINEERING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mse.haldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2211'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2211'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2211'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2211'); # Entry for M/S ENGINEERS INDIA LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pronay.naskar@hpl.co.in', 'PPE 109', 'M/S ENGINEERS INDIA LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pronay.naskar', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2212'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2212'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2212'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2212'); # Entry for M/S HALDIA TRAVELS INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('haldiatravels@gmail.com', 'PPE 110', 'M/S HALDIA TRAVELS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'haldiatravels', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2213'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2213'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2213'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2213'); # Entry for MAA ENTERPRISES (ION EXCHANGE) INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('maa.enterprises2222@gmail.com', 'PPE 111', 'MAA ENTERPRISES (ION EXCHANGE)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'maa.enterprises2222', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2214'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2214'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2214'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2214'); # Entry for MACO CORPORATION (INDIA) PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('gcde@macocorporation.com', 'PPE 112', 'MACO CORPORATION (INDIA) PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'gcde', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2215'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_key`, `user_key`) VALUES ('1110', '2215'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2215'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2215'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pmsudhanshu@magicrot.com', 'PPE 113', 'MAGICROT INDUSTRIAL SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pmsudhanshu', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2216'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2216'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2216'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2216'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mahamayaconstn@gmail.com', 'PPE 114', 'MAHAMAYA CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mahamayaconstn', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2217'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2217'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2217'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2217'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('indus_8@yahoo.com', 'PPE 115', 'MANDAYS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'indus_8', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2218'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2218'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2218'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2218'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sumit.shil@rotostat.in', 'PPE 116', 'MANPOWERGROUP SERVICES INDIA PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sumit.shil', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2219'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2219'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2219'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2219'); INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mastek.haldiap123@mastekengineering.com', 'PPE 117', 'MASTEK ENGINEERING PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mastek.haldiap123', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2220'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2220'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2220'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2220'); # Entry for MATRI ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('subhasdas74@gmail.com', 'PPE 118', 'MATRI ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'subhasdas74', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2221'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2221'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2221'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2221'); # Entry for MATRI PROJECTS INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('matriproject2021@gmail.com', 'PPE 119', 'MATRI PROJECTS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'matriproject2021', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2222'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2222'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2222'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2222'); # Entry for MAXIML LABS PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rohit.nowal@maximl.com', 'PPE 120', 'MAXIML LABS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rohit.nowal', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2223'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2223'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2223'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2223'); # Entry for MBS ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bghoshmbs@yahoo.com', 'PPE 121', 'MBS ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bghoshmbs', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2224'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2224'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2224'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2224'); # Entry for MICRO CLINICAL LABORATORY & DIAGNOSTIC CENTRE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('microclinicallab@gmail.com', 'PPE 122', 'MICRO CLINICAL LABORATORY & DIAGNOSTIC CENTRE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'microclinicallab', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2225'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2225'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2225'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2225'); # Entry for MKS ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('aftabansarisbd15@gmail.com', 'PPE 123', 'MKS ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'aftabansarisbd15', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2226'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2226'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2226'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2226'); # Entry for N G CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ng.construction76@gmail.com', 'PPE 124', 'N G CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ng.construction76', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2227'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2227'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2227'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2227'); # Entry for NALCO WATER INDIA LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jsaini@ecolab.com', 'PPE 125', 'NALCO WATER INDIA LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jsaini', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2228'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2228'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2228'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2228'); # Entry for NBC ASSOCIATES INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sbalvinder654@gmail.com', 'PPE 126', 'NBC ASSOCIATES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sbalvinder654', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2229'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2229'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2229'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2229'); # Entry for NICCO ENGINEERING SERVICES LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mrthander79@gmail.com', 'PPE 127', 'NICCO ENGINEERING SERVICES LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mrthander79', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2230'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2230'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2230'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2230'); # Entry for NMD ENGG. WORKS INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('nmdengwork@gmail.com', 'PPE 128', 'NMD ENGG. WORKS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'nmdengwork', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2231'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2231'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2231'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2231'); # Entry for ONSHORE CONTRUCTION CO. PVT. LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('onshore.hpl@onshoreconstruction.com', 'PPE 129', 'ONSHORE CONTRUCTION CO. PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'onshore.hpl', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2232'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2232'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2232'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2232'); # Entry for PAHARPUR COOLING TOWERS LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('krishnaprasad.maity@paharpur.com', 'PPE 130', 'PAHARPUR COOLING TOWERS LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'krishnaprasad.maity', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2233'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2233'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2233'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2233'); # Entry for PARISHRAM RESOURCES PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('alok.gupta@sarens.in', 'PPE 131', 'PARISHRAM RESOURCES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'alok.gupta', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2234'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2234'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2234'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2234'); # Entry for PARTHA ENGINEERS INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('newparthaengineers@gmail.com', 'PPE 132', 'PARTHA ENGINEERS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'newparthaengineers', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2235'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2235'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2235'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2235'); # Entry for PETROCHEM ENGINEERING CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('petrochem_construction@rediffmail.com', 'PPE 133', 'PETROCHEM ENGINEERING CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'petrochem_construction', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2236'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2236'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2236'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2236'); # Entry for PETRODEK SYSTEM INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('dk.raj0563@gmail.com', 'PPE 134', 'PETRODEK SYSTEM', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'dk.raj0563', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2237'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2237'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2237'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2237'); # Entry for PHILS HEAVY ENGINEERING PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('site@philsengg.com', 'PPE 135', 'PHILS HEAVY ENGINEERING PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'site', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2238'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2238'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2238'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2238'); # Entry for PIONEER SAFETY INDUSTRIES INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pioneersafetyindustries@gmail.com', 'PPE 136', 'PIONEER SAFETY INDUSTRIES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pioneersafetyindustries', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2239'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2239'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2239'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2239'); # Entry for PLANT TECHNOLOGY SERVICES (INDIA) PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sales.in@pts.group', 'PPE 137', 'PLANT TECHNOLOGY SERVICES (INDIA) PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sales.in', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2240'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2240'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2240'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2240'); # Entry for PNP ENGINEERING WORKS PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pnpiso@yahoo.in', 'PPE 138', 'PNP ENGINEERING WORKS PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pnpiso', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2241'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2241'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2241'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2241'); # Entry for PORTEX INDUSTRIAL SERVICES INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('akarshadey83@gmail.com', 'PPE 139', 'PORTEX INDUSTRIAL SERVICES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'akarshadey83', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2242'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2242'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2242'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2242'); # Entry for POWER ENGINEERING INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('power.engineering08@gmail.com', 'PPE 140', 'POWER ENGINEERING', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'power.engineering08', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2243'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2243'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2243'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2243'); # Entry for POWERGAIN ENGINEERS INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sumanroy@powergainengineers.com', 'PPE 141', 'POWERGAIN ENGINEERS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sumanroy', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2244'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2244'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2244'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2244'); # Entry for PRABHA CONTINUOUS UTILITY SERVICE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('hpl.pcus@gmail.com', 'PPE 142', 'PRABHA CONTINUOUS UTILITY SERVICE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'hpl.pcus', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2245'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2245'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2245'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2245'); # Entry for PREMIUM PEST MANAGEMENT SERVICES INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('premiumpest19@gmail.com', 'PPE 143', 'PREMIUM PEST MANAGEMENT SERVICES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'premiumpest19', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2246'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2246'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2246'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2246'); # Entry for PRESIDENCY RUBBER MILLS PVT. LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('prmrubber@gmail.com', 'PPE 144', 'PRESIDENCY RUBBER MILLS PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'prmrubber', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2247'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2247'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2247'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2247'); # Entry for PROFICIENT KILN SERVICES PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('manoj.pandey@proficientkiln.com', 'PPE 145', 'PROFICIENT KILN SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'manoj.pandey', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2248'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2248'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2248'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2248'); # Entry for PROSAFE AUTOMATION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('bablu03052015@gmail.com', 'PPE 146', 'PROSAFE AUTOMATION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'bablu03052015', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2249'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2249'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2249'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2249'); # Entry for PVS INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('haldia@pvspl.net', 'PPE 147', 'PVS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'haldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2250'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2250'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2250'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2250'); # Entry for RADHE RADHE ENTERPRISE (THERMAX LTD) INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sudip.mondal357@gmail.com', 'PPE 148', 'RADHE RADHE ENTERPRISE (THERMAX LTD)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sudip.mondal357', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2251'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2251'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2251'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2251'); # Entry for RAJ CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rajconstruction.haldia.1@gmail.com', 'PPE 149', 'RAJ CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rajconstruction.haldia.1', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2252'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2252'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2252'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2252'); # Entry for RAMESHWAR ENTERPRISES INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ms.wahidkhan786@gmail.com', 'PPE 150', 'RAMESHWAR ENTERPRISES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ms.wahidkhan786', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2253'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2253'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2253'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2253'); # Entry for RANDSTAD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('soumen.cni@gmail.com', 'PPE 151', 'RANDSTAD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'soumen.cni', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2254'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2254'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2254'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2254'); # Entry for RSM ASTUTE CONSULTING PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ashok.nat@rsmindia.in', 'PPE 152', 'RSM ASTUTE CONSULTING PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ashok.nat', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2255'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2255'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2255'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2255'); # Entry for S & IB SERVICES PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('operations.rob@sibservices.in', 'PPE 153', 'S & IB SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'operations.rob', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2256'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2256'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2256'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2256'); # Entry for S B ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('brihaspatipradhan130@gmail.com', 'PPE 154', 'S B ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'brihaspatipradhan130', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2257'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2257'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2257'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2257'); # Entry for S B S CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sbscon94@gmail.com', 'PPE 155', 'S B S CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sbscon94', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2258'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2258'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2258'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2258'); # Entry for S S POWER (THERMAX LTD) INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sr.sspower@gmail.com', 'PPE 156', 'S S POWER (THERMAX LTD)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sr.sspower', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2259'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2259'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2259'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2259'); # Entry for S. SAYERS & CO. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ssayersandco@gmail.com', 'PPE 157', 'S. SAYERS & CO.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ssayersandco', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2260'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2260'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2260'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2260'); # Entry for S.E. CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('se.construction2018@gmail.com', 'PPE 158', 'S.E. CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'se.construction2018', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2261'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2261'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2261'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2261'); # Entry for S.K.S ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('suvankarbera3@gmail.com', 'PPE 159', 'S.K.S ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'suvankarbera3', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2262'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2262'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2262'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2262'); # Entry for S.M. ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sumanhaldia82@gmail.com', 'PPE 160', 'S.M. ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sumanhaldia82', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2263'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2263'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2263'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2263'); # Entry for SAFECON INDIA INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('safeconin@gmail.com', 'PPE 161', 'SAFECON INDIA', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'safeconin', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2264'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2264'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2264'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2264'); # Entry for SANTRA ENTERPRISE & CO. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sec_hal@rediffmail.com', 'PPE 162', 'SANTRA ENTERPRISE & CO.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sec_hal', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2265'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2265'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2265'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2265'); # Entry for SARENS HEAVY LIFT INDIA PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('biswajit.nayak@sarens.in', 'PPE 163', 'SARENS HEAVY LIFT INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'biswajit.nayak', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2266'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2266'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2266'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2266'); # Entry for SB TANKSERVE PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sbtankserve@gmail.com', 'PPE 164', 'SB TANKSERVE PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sbtankserve', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2267'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2267'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2267'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2267'); # Entry for SCHNEIDER ELCTRIC INDIA PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('goutam3.dutta@se.com', 'PPE 165', 'SCHNEIDER ELCTRIC INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'goutam3.dutta', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2268'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2268'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2268'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2268'); # Entry for SCHNEIDER ELECTRIC INSFRASTRUCTURE LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('TANMOYRAKSHIT00028@GMAIL.COM', 'PPE 166', 'SCHNEIDER ELECTRIC INSFRASTRUCTURE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'TANMOYRAKSHIT00028', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2269'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2269'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2269'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2269'); # Entry for SCHNEIDER ELECTRICAL INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('tirtha.das@se.com', 'PPE 167', 'SCHNEIDER ELECTRICAL', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'tirtha.das', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2270'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2270'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2270'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2270'); # Entry for SEAFOLK DIVING PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rajendra@seafolkdive.com', 'PPE 168', 'SEAFOLK DIVING PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rajendra', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2271'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2271'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2271'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2271'); # Entry for SGS INDIA PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('suprabhat.dutta@sgs.com', 'PPE 169', 'SGS INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'suprabhat.dutta', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2272'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2272'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2272'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2272'); # Entry for SHAKTI ENGINEERING CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('shaktiengghplhaldia@gmail.com', 'PPE 170', 'SHAKTI ENGINEERING CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'shaktiengghplhaldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2273'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2273'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2273'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2273'); # Entry for SHARP TANK & STRUCTURALS PVT LTD (ZETWERK) INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('hipalash9@gmail.com', 'PPE 171', 'SHARP TANK & STRUCTURALS PVT LTD (ZETWERK)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'hipalash9', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2274'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2274'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2274'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2274'); # Entry for SHIVHARE ROAD LINES INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('srlhaldia@gmail.com', 'PPE 172', 'SHIVHARE ROAD LINES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'srlhaldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2275'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2275'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2275'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2275'); # Entry for SHOW & SONS ENTERPRISES INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('senanup669@gmail.com', 'PPE 173', 'SHOW & SONS ENTERPRISES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'senanup669', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2276'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2276'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2276'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2276'); # Entry for SHREE BUS SERVICE (TKUIPL) INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sreebusservice@gmail.com', 'PPE 174', 'SHREE BUS SERVICE (TKUIPL)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sreebusservice', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2277'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2277'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2277'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2277'); # Entry for SIEMENS LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sandipan.mukhopadhyay@siemens.com', 'PPE 175', 'SIEMENS LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sandipan.mukhopadhyay', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2278'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2278'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2278'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2278'); # Entry for SIMO RESEARCH ENGINEERS PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('research.simo@gmail.com', 'PPE 176', 'SIMO RESEARCH ENGINEERS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'research.simo', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2279'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2279'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2279'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2279'); # Entry for SINCLUS ENGINEERING & CONSULTING PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('roneswarsingha@gmail.com', 'PPE 177', 'SINCLUS ENGINEERING & CONSULTING PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'roneswarsingha', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2280'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2280'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2280'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2280'); # Entry for SKYLINE ENGINEERS INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('skyline.engineers17@gmail.com', 'PPE 178', 'SKYLINE ENGINEERS', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'skyline.engineers17', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2281'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2281'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2281'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2281'); # Entry for SKYTECH SYSTEMS (INDIA) PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('hiranmoy.dewan@skytechindia.com', 'PPE 179', 'SKYTECH SYSTEMS (INDIA) PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'hiranmoy.dewan', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2282'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2282'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2282'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2282'); # Entry for SM COMPREHENSIVE SERVICE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('smcomprehensiveservice@gmail.com', 'PPE 180', 'SM COMPREHENSIVE SERVICE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'smcomprehensiveservice', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2283'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2283'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2283'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2283'); # Entry for SM ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('smenterprisehal@gmail.com', 'PPE 181', 'SM ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'smenterprisehal', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2284'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2284'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2284'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2284'); # Entry for SMART SERVICE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('smartservicero@gmail.com', 'PPE 182', 'SMART SERVICE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'smartservicero', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2285'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2285'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2285'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2285'); # Entry for SPEED PRINT INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('speedprintdigital@gmail.com', 'PPE 183', 'SPEED PRINT', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'speedprintdigital', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2286'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2286'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2286'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2286'); # Entry for SREE GANESH ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('smillingganesh@gmail.com', 'PPE 184', 'SREE GANESH ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'smillingganesh', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2287'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2287'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2287'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2287'); # Entry for SRL INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Environmental.Laboratory@hpl.co.in', 'PPE 185', 'SRL', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Environmental.Laboratory', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2288'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2288'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2288'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2288'); # Entry for STEAG ENERGY SERVICES (INDIA) PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sidhartha.roy@steag.in', 'PPE 186', 'STEAG ENERGY SERVICES (INDIA) PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sidhartha.roy', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2289'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2289'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2289'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2289'); # Entry for SULABH INTERNATIONAL INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kpvermapatna@gmail.com', 'PPE 187', 'SULABH INTERNATIONAL', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kpvermapatna', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2290'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2290'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2290'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2290'); # Entry for SULZER INDIA PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('manish.pandey@sulzer.com', 'PPE 188', 'SULZER INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'manish.pandey', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2291'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2291'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2291'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2291'); # Entry for SULZER PUMPS INDIA PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('manish.pandey@sulzer.com', 'PPE 189', 'SULZER PUMPS INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'manish.pandey', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2292'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2292'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2292'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2292'); # Entry for SUPERTECH ENGINEERING ENTERPRISES INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('supertecheng14@gmail.com', 'PPE 190', 'SUPERTECH ENGINEERING ENTERPRISES', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'supertecheng14', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2293'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2293'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2293'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2293'); # Entry for SUREFLO TECHCON PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('rutuja@sureflo.in', 'PPE 191', 'SUREFLO TECHCON PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'rutuja', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2294'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2294'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2294'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2294'); # Entry for SUREWORKS INFOTECH PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('aixadmin.haldia@hpl.co.in', 'PPE 192', 'SUREWORKS INFOTECH PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'aixadmin.haldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2295'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2295'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2295'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2295'); # Entry for TEAM LEASE (THERMAX LIMITED) INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('guptamahesh732@gmail.com', 'PPE 193', 'TEAM LEASE (THERMAX LIMITED)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'guptamahesh732', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2296'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2296'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2296'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2296'); # Entry for TEAM WARRIOR PVT LTD (THERMAX LTD) INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sureshk68527@gmail.com', 'PPE 194', 'TEAM WARRIOR PVT LTD (THERMAX LTD)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sureshk68527', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2297'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2297'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2297'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2297'); # Entry for TECHMECH ENGINEERING (HAL OFFSHORE LTD) INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('techmechhaldia@gmail.com', 'PPE 195', 'TECHMECH ENGINEERING (HAL OFFSHORE LTD)', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'techmechhaldia', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2298'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2298'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2298'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2298'); # Entry for TECHNOFINE CALIBRATION SERVICES PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info@finecalibration.in', 'PPE 196', 'TECHNOFINE CALIBRATION SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2299'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2299'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2299'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2299'); # Entry for TEST METAL CORPORATION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('tmc@tmcgroupindia.com', 'PPE 197', 'TEST METAL CORPORATION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'tmc', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2300'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2300'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2300'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2300'); # Entry for THERMAX LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('kajal.de@thermaxglobal.com', 'PPE 198', 'THERMAX LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'kajal.de', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2301'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2301'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2301'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2301'); # Entry for THYSSENKRUPP UDHE INDIA PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jagabandhu.lenka@thyssenkrupp.com', 'PPE 199', 'THYSSENKRUPP UDHE INDIA PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jagabandhu.lenka', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2302'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2302'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2302'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2302'); # Entry for TK ELEVATOR INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('shuvendu.golder@tkelevator.com', 'PPE 200', 'TK ELEVATOR', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'shuvendu.golder', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2303'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2303'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2303'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2303'); # Entry for TQ CERT SERVICES PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mandal_priyabrata@yahoo.com', 'PPE 201', 'TQ CERT SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mandal_priyabrata', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2304'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2304'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2304'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2304'); # Entry for TRACTEBEL ENGINEERING PRIVATE LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('aswini.kabi@tractebel.engie.com', 'PPE 202', 'TRACTEBEL ENGINEERING PRIVATE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'aswini.kabi', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2305'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2305'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2305'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2305'); # Entry for TRINITY TRADEX PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sales@trinitytradex.com', 'PPE 203', 'TRINITY TRADEX PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sales', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2306'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2306'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2306'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2306'); # Entry for TRISTAR CHEMICALS & COATINGS PVT. LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('tristar.engg@yahoo.com', 'PPE 204', 'TRISTAR CHEMICALS & COATINGS PVT. LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'tristar.engg', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2307'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2307'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2307'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2307'); # Entry for TRIVENI ENGINEERING & INDUSTRIES LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('mktg@ptb.trivenigroup.com', 'PPE 205', 'TRIVENI ENGINEERING & INDUSTRIES LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'mktg', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2308'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2308'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2308'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2308'); # Entry for TRIVENI TURBINE LIMITED INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('jiteshgupta@triveniturbines.com', 'PPE 206', 'TRIVENI TURBINE LIMITED', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'jiteshgupta', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2309'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2309'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2309'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2309'); # Entry for TUV INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('gsudam@tuv-nord.com', 'PPE 207', 'TUV', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'gsudam', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2310'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2310'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2310'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2310'); # Entry for TUV RHEINLAND INDIA PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('Rakesh.Tiwari@ind.tuv.com', 'PPE 208', 'TUV RHEINLAND INDIA PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'Rakesh.Tiwari', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2311'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2311'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2311'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2311'); # Entry for U K ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ak466d@gmail.com', 'PPE 209', 'U K ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ak466d', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2312'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2312'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2312'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2312'); # Entry for UDYOGI PLASTIC PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('project1@udyogi.net', 'PPE 210', 'UDYOGI PLASTIC PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'project1', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2313'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2313'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2313'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2313'); # Entry for UJALA T. P. SERVICE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('anuj.mjk54@gmail.com', 'PPE 211', 'UJALA T. P. SERVICE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'anuj.mjk54', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2314'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2314'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2314'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2314'); # Entry for UNIMARK HI­TECH SOLUTIONS LLP INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('anis@unimark.in', 'PPE 212', 'UNIMARK HI­TECH SOLUTIONS LLP', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'anis', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2315'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2315'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2315'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2315'); # Entry for UNIQUE CONSTRUCTION INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('gmaiti472@gmail.com', 'PPE 213', 'UNIQUE CONSTRUCTION', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'gmaiti472', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2316'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2316'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2316'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2316'); # Entry for UNIVERSAL ENTERPRISE INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('enteruniversal.in@gmail.com', 'PPE 214', 'UNIVERSAL ENTERPRISE', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'enteruniversal.in', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2317'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2317'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2317'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2317'); # Entry for VERTIV INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('sagar.mondal@vertiv.com', 'PPE 215', 'VERTIV', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'sagar.mondal', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2318'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2318'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2318'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2318'); # Entry for VIJAY TANKS & VESSELS PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('s3350admin@vijaytanks.com', 'PPE 216', 'VIJAY TANKS & VESSELS PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 's3350admin', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2319'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2319'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2319'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2319'); # Entry for WRIGHT & COMPANY INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('info@wrightnco.com', 'PPE 217', 'WRIGHT & COMPANY', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'info', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2320'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2320'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2320'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2320'); # Entry for YOUNG ENGG.& CALIBRATION SERVICES PVT LTD INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('ujjal@nablcalibration.com', 'PPE 218', 'YOUNG ENGG.& CALIBRATION SERVICES PVT LTD', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'ujjal', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2321'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2321'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2321'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2321'); # Entry for ZETWERK MANUFACTURING BUSINESSESS PVT. LTD. INSERT INTO `hpldb`.`USER_DETAILS` (`email`, `employee_id`, `first_name`, `isactive`, `last_name`, `location`, `manager`, `birthday`, `password`, `phone`, `username`, `salary_grade`, `work_level`) VALUES ('pratik.m@zetwerk.com', 'PPE 219', 'ZETWERK MANUFACTURING BUSINESSESS PVT. LTD.', 1, '', 'SPC', 0, '1999-12-12 00:00:00', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=$TgbJwsuLCB4Y9XjH2Tr+u8C/6EtmiuOnkNqQIBOINiM=', '123456989', 'pratik.m', 'A 04', 'WORK LEVEL - 5'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1113', '2322'); INSERT INTO `hpldb`.`USER_ROLE_MAPPING` (`role_id`, `user_key`) VALUES ('1110', '2322'); UPDATE `hpldb`.`USER_DETAILS` SET `manager` = '0' WHERE (`userKey` = '2322'); UPDATE `hpldb`.`USER_DETAILS` SET `designation` = '2007', `organization` = '1915' WHERE (`userKey` = '2322');