text: -- Adminer 4.6.2 MySQL dump
  
  SET NAMES utf8;
  SET time_zone = '+00:00';
  SET foreign_key_checks = 0;
  SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  
  DROP TABLE IF EXISTS `copy_employee`;
  CREATE TABLE `copy_employee` (
    `employeecode` varchar(15) NOT NULL,
    `employeelast` varchar(20) DEFAULT NULL COMMENT 'Family Name',
    `employeefirst` varchar(20) DEFAULT NULL COMMENT 'Given Name',
    `employeemiddle` varchar(20) DEFAULT NULL COMMENT 'Mother''s Maiden Lastname',
    `groupname` varchar(40) DEFAULT NULL COMMENT 'Department Name',
    `designation` varchar(40) DEFAULT NULL COMMENT 'Position Title',
    `employmentcategory` varchar(15) DEFAULT NULL,
    `project` varchar(40) DEFAULT NULL COMMENT 'Name of project where the employee was assigned.',
    `tin_number` varchar(25) DEFAULT NULL,
    `sss_number` varchar(25) DEFAULT NULL,
    `phic_number` varchar(25) DEFAULT NULL,
    `hdmf_number` varchar(25) DEFAULT NULL,
    `basicsalary` decimal(7,2) DEFAULT NULL COMMENT 'Monthly',
    `allowances` decimal(7,2) DEFAULT NULL COMMENT 'Monthly',
    `contactperson` varchar(40) DEFAULT NULL,
    `contactnumber` varchar(20) DEFAULT NULL,
    `photoavailable` varchar(3) DEFAULT NULL,
    `signatureavailable` varchar(3) DEFAULT NULL,
    `hiredate` varchar(10) DEFAULT NULL COMMENT 'Date when employee was hired.',
    `terminationdate` varchar(10) DEFAULT NULL COMMENT 'If contract has been terminated, when it is terminated.',
    `suspensionremarks` text,
    `finalpay` varchar(3) DEFAULT NULL COMMENT 'Yes or No',
    `finalpayreleasedate` varchar(20) DEFAULT NULL COMMENT 'When is the final pay released.',
    `activeemployment` varchar(3) DEFAULT 'Yes' COMMENT 'Yes or No',
    `referencenumber` varchar(12) DEFAULT NULL,
    `regulartime_reference` bigint(20) DEFAULT NULL,
    `overtime_reference` bigint(20) DEFAULT NULL,
    `activitystatus` varchar(40) DEFAULT NULL,
    `printed` varchar(3) DEFAULT NULL,
    `phone` varchar(40) DEFAULT NULL,
    `email` varchar(60) DEFAULT NULL,
    `address` text,
    `username` varchar(20) DEFAULT NULL,
    `userpass` varchar(20) DEFAULT NULL,
    `payrollfrequency` varchar(15) DEFAULT NULL,
    `payrollcutoff` varchar(15) DEFAULT NULL,
    `employmentstatus` varchar(15) DEFAULT NULL,
    `accountnumber` varchar(15) DEFAULT NULL,
    `accountname` varchar(40) DEFAULT NULL,
    `suspensiondate` varchar(20) DEFAULT NULL,
    `salarytype` varchar(15) DEFAULT NULL,
    UNIQUE KEY `employeecode_unique` (`employeecode`),
    UNIQUE KEY `employeefirst_employeelast_employeemiddle` (`employeefirst`,`employeelast`,`employeemiddle`),
    KEY `employeecode` (`employeecode`),
    KEY `employeelast` (`employeelast`),
    KEY `employeefirst` (`employeefirst`),
    KEY `project` (`project`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `copy_employee` (`employeecode`, `employeelast`, `employeefirst`, `employeemiddle`, `groupname`, `designation`, `employmentcategory`, `project`, `tin_number`, `sss_number`, `phic_number`, `hdmf_number`, `basicsalary`, `allowances`, `contactperson`, `contactnumber`, `photoavailable`, `signatureavailable`, `hiredate`, `terminationdate`, `suspensionremarks`, `finalpay`, `finalpayreleasedate`, `activeemployment`, `referencenumber`, `regulartime_reference`, `overtime_reference`, `activitystatus`, `printed`, `phone`, `email`, `address`, `username`, `userpass`, `payrollfrequency`, `payrollcutoff`, `employmentstatus`, `accountnumber`, `accountname`, `suspensiondate`, `salarytype`) VALUES
  ('20180001',	'Rivera',	'Rhodel',	'Valerio',	'Management',	'President',	'Admin',	'Head Office',	NULL,	'33-0146624-3',	'01-025034845-8',	'1060-0104-0267',	NULL,	NULL,	NULL,	NULL,	'No',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180002',	'Rivera',	'Ronand',	'Valerio',	'Management',	'VP-Finance',	'Admin',	'Head Office',	NULL,	'33-9141489-4',	'01-025034835-0',	'1060-0104-0278',	NULL,	NULL,	NULL,	NULL,	'No',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180003',	'Rivera',	'Rhoame',	'Enriquez',	'Management',	'VP-Admin',	'Admin',	'Head Office',	'',	'34-4235012-4',	'',	'',	0.00,	0.00,	'',	'',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180004',	'Sadaya',	'Julius',	'Hapa',	'Operation',	'Operation Manager',	'Admin',	'Head Office',	NULL,	'06-1723953-6',	'03-050674326-1',	'1211-5487-5627',	30000.00,	15000.00,	'Vilma Sadaya',	'0923-155-6287',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180005',	'Padilla',	'Bernardo',	'Nañasca',	'Operation',	'Project Manager',	'Admin',	'Head Office',	NULL,	'33-0379659-7',	'19-025202060-1',	'1060-0104-3875',	40000.00,	NULL,	'Shirley Padilla',	'0906-254-2054',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180006',	'Valerio Jr.',	'Nicanor',	'Nerit',	'Engineering',	'Chief Estimator',	'Admin',	'Head Office',	NULL,	'03-7547394-8',	'03-050926978-1',	'9162-8089-6426',	20000.00,	5000.00,	'Eloisa Valerio',	'0933-451-0376',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180007',	'Medina',	'Joey',	'Pineda',	'Purchasing',	'Purchaser Head',	'Admin',	'Head Office',	NULL,	'33-0146628-5',	'01-025038688-0',	NULL,	11000.00,	6000.00,	'Eleanor Medina',	'0918-594-5546',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180008',	'Medina',	'Jacinto',	'Lapira',	'Accounting',	'Bookkeeper',	'Admin',	'Head Office',	NULL,	'03-3699050-9',	'03-050641347-4',	'1060-0104-3952',	20800.00,	5200.00,	'Selfa Medina',	'0995-651-2513',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180009',	'Valerio',	'Conrad',	'Valerio',	'Logistics',	'Logistic / Safety Head',	'Admin',	'Head Office',	NULL,	'02-1770464-9',	'07-051057483-2',	'9162-8198-7760',	15000.00,	3000.00,	'Aikon Valerio',	'0975-985-2615',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'ZZ6121225836',	20,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180010',	'Valerio',	'Darmo',	'Robles',	'Sales',	'Liason Officer',	'Admin',	'Head Office',	NULL,	'33-0146625-6',	'01-025038681-3',	'1060-0104-3941',	11000.00,	6000.00,	'Leonora Valerio',	'0910-849-7761',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'GV5258448206',	32,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180011',	'Kabigting',	'Cristan',	'Jurado',	'Information Technology',	'System Developer',	'Admin',	'Head Office',	'253-064-434',	'03-9641903-3',	'12-050491036-4',	'0019-4970-1411',	21000.00,	4000.00,	'Raquel Kabigting',	'09202233133',	'Yes',	'Yes',	'',	'',	'',	NULL,	'',	'Yes',	'',	0,	0,	'',	'Yes',	'',	'',	'',	'',	'',	'Weekly',	'Tuesday',	'Employed',	'',	'',	'',	'Monthly'),
  ('20180012',	'Buenviaje',	'Rodelio',	'Santos',	'Accounting',	'Accountant',	'Admin',	'Head Office',	'',	'03-5619547-8',	'19-050833462-5',	'',	15000.00,	12504.00,	'Ronidel Buenviaje',	'0923-229-7880',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'ZR8437421594',	22,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180013',	'Opon',	'Glenda',	'Angeles',	'Human Resource',	'Human Resource Officer',	'Admin',	'Head Office',	NULL,	'33-3224620-9',	'19-051605828-9',	'1210-4848-0895',	19200.00,	NULL,	'Imelda Opon',	'573-72-84',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180014',	'Bautista',	'Sarah Clarris',	'Cleofas',	'Accounting',	'Assistant Finance',	'Admin',	'Head Office',	NULL,	'34-5205234-4',	'07-051040173-3',	'1211-4700-8240',	12000.00,	3600.00,	'Clara Bautista',	'0933-195-8074',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'TA4227825682',	28,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180015',	'Ugalde',	'Klairie',	'Abestilla',	'Human Resource',	'Assistant Human Resource',	'Admin',	'Head Office',	'',	'34-5052738-9',	'03-025735545-0',	'',	14400.00,	4800.00,	'Sam Basil',	'0939-765-9578',	'Yes',	'Yes',	'2015-07-20',	'',	'',	NULL,	NULL,	'Yes',	'HT0463439179',	17,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180016',	'Rivera',	'Liwayway Trinidad',	'Cleofas',	'Human Resource',	'Assistant Human Resource',	'Admin',	'Head Office',	NULL,	'34-4507981-3',	'02-026220498-8',	'1211-1693-7419',	12000.00,	NULL,	'Clara Bautista',	'0933-195-8074',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'WX1156182367',	19,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180017',	'Pamiloza',	'Kathleen Ann',	'Padiernos',	'Engineering',	'QS Engineer',	'Admin',	'Head Office',	NULL,	'34-6148645-1',	'21-200266089-7',	'9160-2816-8432',	25000.00,	10800.00,	'Olga Pamiloza',	'0905-329-6524',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'KW7813160359',	9,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180018',	'Hapa',	'Raven James',	'Mendoza',	'Engineering',	'QS Engineer',	'Admin',	'Head Office',	NULL,	'34-2333613-8',	'21-050115637-4',	'1210-2288-9493',	16000.00,	4000.00,	'Bong Fandiño',	'0995-164-1432',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'GU1352714989',	24,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180019',	'Singma',	'Jennifer',	'Lining',	'Sales',	'Collection Officer / HR Procurement',	'Admin',	'Head Office',	NULL,	'34-1351835-1',	'01-050940843-8',	'9162-8092-4523',	12000.00,	3600.00,	'Mark Singma',	'0917-120-9524',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'MN9537895664',	27,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180020',	'Maniego',	'Ivy Lahar',	'Inocencion',	'Sales',	'Collection Officer',	'Admin',	'Head Office',	'',	'02-3734512-7',	'07-201535626-0',	'1211-3967-8068',	12000.00,	1200.00,	'Elvira Maniego',	'0975-413-8987',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'SP1676947335',	1,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180021',	'Barcelon',	'Darlene',	'Rodulfa',	'Purchasing',	'Purchasing Officer',	'Admin',	'Head Office',	NULL,	NULL,	NULL,	NULL,	9600.00,	NULL,	'Arlene Barcelon',	'0905-558-6749',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'ND1733751859',	26,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180022',	'Manlulu',	'Oliver',	'Manlulu',	'Purchasing',	'Purchasing Officer',	'Admin',	'Head Office',	NULL,	'02-2478806-9',	'07-050752527-8',	NULL,	14400.00,	NULL,	'Beth Manlulu',	'0923-535-2042',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'NT6301879887',	15,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180023',	'Dorado',	'Neil',	'Valerio',	'Sales',	'Liason Officer',	'Admin',	'Head Office',	NULL,	'02-1777461-1',	'19-089651984-4',	'9162-8086-3433',	12000.00,	1200.00,	'Ron Dorado',	'0945-324-9830',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'ZM5652453190',	16,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180024',	'Navarro',	'Jelmar',	'Samson',	'Sales',	'Messenger',	'Admin',	'Head Office',	NULL,	NULL,	NULL,	NULL,	10320.00,	1680.00,	'Adonica Navarro',	'0955-403-2933',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'XK2044160925',	25,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180025',	'Mesa',	'Rey',	'Medina',	'Logistics',	'Warehouseman',	'Admin',	'Head Office',	NULL,	'02-1320547-2',	NULL,	'9160-7709-0541',	12000.00,	3600.00,	'Clara Mesa',	'0918-287-8384',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'WY2098251656',	23,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180026',	'Espino',	'Van Halen',	'Ramos',	'Logistics',	'Assistant Warehouseman',	'Admin',	'Head Office',	'',	'02-4328495-5',	'07-251155193-6',	'',	12000.00,	2400.00,	'Jannine Espino',	'0956-142-4732',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'JW6825865767',	30,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180027',	'Punzalan',	'Jerome',	'Calalang',	'Logistics',	'Assistant Warehouseman',	'Admin',	'Head Office',	NULL,	NULL,	NULL,	NULL,	8400.00,	1200.00,	'Remedios Punzalan',	'0975-189-8798',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'YK0034655844',	31,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180028',	'Esplana',	'Jay-ar',	'Bequillo',	'Maintenance',	'Utility',	'Admin',	'Head Office',	NULL,	NULL,	'10-201766701-4',	NULL,	12000.00,	NULL,	'Jeniffer Bajado',	'0950-259-0901',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'EZ0875602440',	18,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180029',	'Al-aziz',	'Marcelo',	'Amerkhan',	'Maintenance',	'Painter',	'Admin',	'Head Office',	NULL,	NULL,	NULL,	NULL,	12000.00,	2400.00,	'Lechit',	'0955-946-8737',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180030',	'Flores',	'Marlon',	'Daquiz',	'Logistics',	'Driver',	'Admin',	'Head Office',	NULL,	'02-2498423-2',	'07-051040179-2',	'9163-0120-4288',	10800.00,	2400.00,	'Rosanna Flores',	'0935-953-3360',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180031',	'Macahilig',	'Ronnie',	'Dalida',	'Logistics',	'Driver',	'Admin',	'Head Office',	NULL,	'03-5959657-9',	'01-025109933-8',	'9160-4055-5545',	14400.00,	1200.00,	'Rosalina Macahilig',	'0927-482-6721',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180032',	'Castro',	'Jay',	'Silva',	'Logistics',	'Driver',	'Admin',	'Head Office',	NULL,	'33-0510902-7',	NULL,	NULL,	10800.00,	1200.00,	'Exie Guiala',	'0932-611-3273',	'Yes',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180033',	'Soliman',	'Michael',	'Karaan',	'Logistics',	'Driver',	'Admin',	'Head Office',	NULL,	'33-2501857-0',	'19-200579387-0',	NULL,	12000.00,	NULL,	'Lourdes Soliman',	'0906-720-4422',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180034',	'Mantilla',	'Gonzalo',	'Bactasa',	'Logistics',	'Driver',	'Admin',	'Head Office',	'',	'03-8681548-5',	'02-050194667-3',	'1211-2297-8939',	12000.00,	1200.00,	'Lete Mantilla',	'0928-899-0650',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180035',	'Mantilla',	'Nemesio',	'Amoguis',	'Logistics',	'Driver',	'Admin',	'Head Office',	'',	'33-1906665-1',	'19-052418442-0',	'',	12000.00,	1200.00,	'Jelyn Mantilla',	'0942-613-1232',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180036',	'Calalang',	'Luis',	'Yacat',	'Logistics',	'Driver',	'Admin',	'Head Office',	'',	'02-4042535-1',	'07-200467900-9',	'9160-2817-8235',	12000.00,	9600.00,	'Evelyn Calalang',	'0936-807-1712',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180037',	'Calalang',	'Darwin',	'Mojeno',	'Logistics',	'Helper',	'Admin',	'Head Office',	'',	'',	'',	'9160-2818-4242',	9600.00,	1200.00,	'Mary Joy Galang',	'0975-039-5661',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180038',	'Calalang',	'Andy',	'Mojeno',	'Logistics',	'Helper',	'Admin',	'Head Office',	'',	'',	'',	'9160-2818-0213',	9600.00,	1200.00,	'Cindy Calalang',	'0926-541-1400',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180039',	'Lazado',	'Regenor',	'',	'Logistics',	'Driver',	'Admin',	'Head Office',	'',	'02-3408443-6',	'',	'',	9600.00,	1200.00,	'Roxan Lazado',	'0975-436-5161',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180040',	'Valerio',	'Francisco',	'Nerit',	'Logistics',	'Collection Officer',	'Admin',	'Head Office',	NULL,	NULL,	NULL,	NULL,	15600.00,	NULL,	'Joselyn Valerio',	'0942-339-4207',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180041',	'Pantanilla',	'Bienvenido',	'Ciprez',	'Security',	'Guard',	'Admin',	'Head Office',	'',	'34-0415242-5',	'',	'',	19500.00,	0.00,	'Dinah Joy Pantanilla',	'239-30-43',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180042',	'Lucas',	'Albert',	'Dela Cruz',	'Security',	'Guard',	'Admin',	'Head Office',	'',	'34-1853178-6',	'03-050723938-9',	'',	19500.00,	0.00,	'Ria Lucas',	'0915-572-8231',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180043',	'Dela Cruz',	'Babylyne',	'Cawas',	'Accounting',	'Project Auditor',	'Admin',	'Head Office',	'441-801-380-000',	'01-0837382-0',	'01-025205765-5',	'1211-1469-9129',	12288.00,	0.00,	'Margie Romero',	'09163574491',	'Yes',	'Yes',	'2018-01-22',	'',	'',	NULL,	NULL,	'Yes',	'KN2255603645',	21,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180044',	'Calica',	'Richard',	'Ronquillo',	'Operation',	'Project in Charge',	'Admin',	'Jupiter & Mars',	'933-117-401',	'01-1562786-0',	'04-025074820-7',	'',	23000.00,	2000.00,	'Jocelyn Borbe',	'0905-1766-462',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180045',	'Mangulabnan',	'Odon',	'Sigua',	'Operation',	'Safety Officer',	'Admin',	'Jupiter & Mars',	'',	'02-3981761-1',	'',	'9163-0121-1362',	12000.00,	3600.00,	'Lilia Herno',	'0943-296-9587',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180046',	'Inocencion',	'Elmer',	'Quiambao',	'Operation',	'Timekeeper',	'Admin',	'Jupiter & Mars',	'',	'33-2845205-2',	'07-200434806-1',	'',	12000.00,	1200.00,	'Villa A. Inocencion',	'0998-918-1045',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180047',	'Lacanilao',	'Ramil',	'Abueg',	'Operation',	'Admin Staff',	'Admin',	'Jupiter & Mars',	'',	'33-0289195-6',	'03-025121309-3',	'12120827-1588',	10800.00,	2400.00,	'Candida Lacanilao',	'0915-152-8204',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180048',	'Remoto',	'Richard',	'Jansalin',	'Operation',	'Project Manager',	'Admin',	'MDC-Arca South',	'',	'33-0247597-4',	'19-089712053-8',	'',	20000.00,	30000.00,	'Mary Grace Remoto',	'0906-301-3297',	'Yes',	'Yes',	'2016-08-20',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180049',	'Bucu',	'Benigno',	'Lagazon',	'Operation',	'Project in Charge',	'Admin',	'MDC-Arca South',	'',	'33-0837434-1',	'',	'',	40000.00,	0.00,	'Marlyn P. Bucu',	'0928-930-7861',	'Yes',	'Yes',	'2016-04-16',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180050',	'Secundo',	'Benjamen',	'Carullo',	'Operation',	'Project in Charge',	'Admin',	'MDC-Arca South',	'',	'33-0686362-1',	'19-052374658-1',	'1070-0109-4587',	50000.00,	0.00,	'Violeta Secundo',	'0977-819-1853',	'Yes',	'Yes',	'2016-10-08',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180051',	'Pagar',	'Alberto',	'Lagao',	'Operation',	'Project Supervisor',	'Admin',	'MDC-Arca South',	'',	'33-0482820-2',	'19-089981788-8',	'1070-0133-0681',	20000.00,	0.00,	'Priscilla Pagar',	'0950-632-6591',	'Yes',	'Yes',	'2015-11-24',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180052',	'Camaña',	'Shannen Faye',	'Turaray',	'Operation',	'QS Engineer',	'Admin',	'MDC-Arca South',	'',	'34-4922558-2',	'03-051094944-3',	'1210-9442-7721',	20000.00,	7000.00,	'Canilo CamaÃ±a',	'0912-504-8004',	'Yes',	'Yes',	'2015-11-02',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180053',	'Nicolas',	'John Michael',	'Aliwanag',	'Operation',	'QA/QC Engineer',	'Admin',	'MDC-Arca South',	'',	'34-4835832-4',	'',	'1211-6033-7773',	25000.00,	0.00,	'Milagros Nicolas',	'0922-280-1259',	'Yes',	'Yes',	'2017-05-11',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180054',	'Abanes',	'Leslie',	'Vidallo',	'Operation',	'QA/QC Engineer',	'Admin',	'MDC-Arca South',	'',	'34-1046147-2',	'',	'0102-6062-4917',	13000.00,	2000.00,	'Neri Abanes',	'0946-415-9107',	'Yes',	'Yes',	'2017-01-13',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180055',	'Rosauro',	'Lucky Grace',	'',	'Operation',	'QA/QC Engineer',	'Admin',	'MDC-Arca South',	'',	'34-5307414-3',	'03-025819125-7',	'9152-0712-9903',	15000.00,	0.00,	'Nora Rosauro',	'0905-296-0022',	'Yes',	'Yes',	'2017-02-13',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180056',	'Aspa IV',	'Lorenzo',	'Villareal',	'Operation',	'Formworks Engineer',	'Admin',	'MDC-Arca South',	'',	'',	'',	'',	12000.00,	3000.00,	'Helen Grace Aspa',	'0915-496-1624',	'Yes',	'Yes',	'2017-07-11',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180057',	'Dugay',	'Jonna',	'Bauyon',	'Operation',	'Formworks Engineer',	'Admin',	'MDC-Arca South',	'',	'34-0894920-7',	'02-050452798-1',	'',	18000.00,	3600.00,	'Benita Dugay',	'405-27-29',	'Yes',	'Yes',	'2015-12-02',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180058',	'Tagufa',	'Christian',	'Flores',	'Operation',	'Rebar Engineer',	'Admin',	'MDC-Arca South',	'',	'34-6649094-7',	'',	'',	12000.00,	6000.00,	'Gina Tagufa',	'534-43-03',	'Yes',	'Yes',	'2015-12-08',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180059',	'Raynes',	'Raymon',	'Lopez',	'Operation',	'Rebar Engineer',	'Admin',	'MDC-Arca South',	'',	'05-0541808-7',	'',	'1211-098529018',	12000.00,	6000.00,	'Normita Raynes',	'0935-975-9917',	'Yes',	'Yes',	'2016-05-18',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180060',	'Alfonso',	'Kevin James',	'Aguilar',	'Operation',	'Site Architect',	'Admin',	'MDC-Arca South',	'',	'02-3589150-5',	'10-051928379-6',	'9163-0120-7551',	12000.00,	7200.00,	'Monico Alfonso',	'0927-463-3364',	'Yes',	'Yes',	'2017-04-18',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180061',	'Lopez',	'Erwin',	'Dela Vega',	'Operation',	'Surveyor',	'Admin',	'MDC-Arca South',	'',	'34-0138040-7',	'01-051409096-9',	'1040-0123-0841',	12000.00,	9000.00,	'Kristine Joanne Lopez',	'0943-254-2364',	'Yes',	'Yes',	'2016-01-18',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180062',	'Elen',	'Harold',	'Flores',	'Operation',	'Safety Officer',	'Admin',	'MDC-Arca South',	'',	'33-8531865-0',	'',	'',	12000.00,	3000.00,	'Jenny Rose Elen',	'0928-205-0244',	'Yes',	'No',	'2016-12-15',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180063',	'Dimatatac',	'Arnold',	'Hernandez',	'Operation',	'Safety Officer',	'Admin',	'MDC-Arca South',	'',	'04-2875194-4',	'09-050424553-4',	'1211-7000-8970',	12000.00,	1200.00,	'Marissa Dimatatac',	'0947-951-0309',	'Yes',	'Yes',	'2016-09-23',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180064',	'De Umania',	'Angelo',	'De Leon',	'Operation',	'Safety Officer',	'Admin',	'MDC-Arca South',	'',	'02-3841602-6',	'07-025803569-9',	'1211-8031-5923',	12000.00,	0.00,	'Luela De Umania',	'0930-836-6112',	'Yes',	'Yes',	'2017-09-12',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180065',	'Lorenzo',	'Alma',	'Pecha',	'Operation',	'Admin Assistant',	'Admin',	'MDC-Arca South',	'',	'07-2699190-1',	'01-025978350-5',	'1211-73995242',	12000.00,	1200.00,	'Leah Francisco',	'0999-704-2420',	'Yes',	'Yes',	'2016-08-11',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180066',	'Maglaqui',	'Maria Amor',	'Angeles',	'Operation',	'Document Controller',	'Admin',	'MDC-Arca South',	'',	'04-1757541-6',	'08-025225012-7',	'1010-0148-8633',	12000.00,	1200.00,	'Christina Maglaqui',	'0916-976-1096',	'Yes',	'Yes',	'2017-02-28',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180067',	'Gamboa',	'Rhyann',	'Valerio',	'Operation',	'Site Purchaser',	'Admin',	'MDC-Arca South',	'',	'',	'',	'',	12000.00,	2300.00,	'Ma. Theresa Guina',	'0908-341-5627',	'Yes',	'Yes',	'2015-11-18',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180068',	'Tabarangao',	'Jazel',	'Sadac',	'Operation',	'Timekeeper',	'Admin',	'MDC-Arca South',	'',	'34-4562339-5',	'03-200270480-2',	'',	12000.00,	0.00,	'Ma. Victoria Tabarangao',	'0998-284-4755',	'Yes',	'Yes',	'2017-05-26',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180069',	'Jorda',	'Edlyn Apple',	'Bernaldez',	'Operation',	'Timekeeper',	'Admin',	'MDC-Arca South',	'',	'33-6275395-3',	'01-025397541-0',	'',	10800.00,	0.00,	'Alfredo Baira Jr.',	'0916-430-4441',	'Yes',	'Yes',	'2017-08-26',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180070',	'Navales',	'Maricar',	'Delos Santos',	'Operation',	'Field Checker',	'Admin',	'MDC-Arca South',	'',	'34-1914136-6',	'03-025348170-2',	'',	10800.00,	1200.00,	'Marissa Monte',	'0977-642-0402',	'Yes',	'Yes',	'2016-09-15',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180071',	'Mariano Jr.',	'Celedonio',	'Suba',	'Operation',	'Project Manager',	'Admin',	'Mix Plant',	'',	'02-0928029-4',	'19-090426994-1',	'0070-4972-0609',	38000.00,	17000.00,	'Arlene Mariano',	'0917-721-8153',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180072',	'Cañonio',	'Fidel',	'Tantiado',	'Operation',	'Project Manager',	'Admin',	'Mix Plant',	'',	'06-0754557-3',	'19-200157592-5',	'1210-6380-1307',	55000.00,	0.00,	'Anita Canonio',	'0905-110-0740',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180073',	'Basil',	'Sam Zoren',	'Hamid',	'Operation',	'Project in Charge',	'Admin',	'Mix Plant',	'',	'34-3075307-6',	'03-050939838-7',	'1211-8536-6701',	35000.00,	0.00,	'Klairie Ugalde',	'0921-540-7985',	'Yes',	'Yes',	'2015-05-10',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180074',	'Mananghaya',	'Michael',	'Parico',	'Operation',	'Safety Officer',	'Admin',	'Mix Plant',	'',	'33-7175319-3',	'03-025889560-2',	'9153-6333-1346',	16224.00,	0.00,	'Irene Rea Soliven',	'0916-758-2479',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180075',	'Almario',	'Jeremias',	'Dapon',	'Operation',	'Safety Officer',	'Admin',	'Mix Plant',	'',	'03-8765524-6',	'19-090143115-2',	'1211-5483-4889',	12000.00,	2400.00,	'Jerico Jerry Almario',	'0929-390-0288',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180076',	'Ayuman',	'Ariel',	'Dimas',	'Operation',	'Safety Officer',	'Admin',	'Mix Plant',	'',	'34-1393997-1',	'01-051233587-5',	'1210-4044-3213',	12000.00,	2400.00,	'Cresame Aquino',	'0930-785-3232',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180077',	'Rublico',	'Dante',	'Perucho',	'Operation',	'Site Nurse',	'Admin',	'Mix Plant',	'',	'33-1198048-9',	'19-051593296-1',	'1210-7361-3996',	12000.00,	8000.00,	'Eva S. Cruz',	'0924-591-6457',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180078',	'Gannaban',	'Jaydee',	'Marcos',	'Operation',	'Rebar Engineer',	'Admin',	'Mix Plant',	NULL,	NULL,	NULL,	NULL,	12000.00,	6000.00,	NULL,	NULL,	'Yes',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180079',	'Valdez',	'Karl Gerard',	'Umoso',	'Operation',	'Formworks Engineer',	'Admin',	'Mix Plant',	'',	'01-2643926-7',	'06-025303235-1',	'1212-1069-4001',	12000.00,	4000.00,	'Maribel U. Valdez',	'0906-842-9400',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180080',	'Espiritu',	'Ma. Shaina',	'Mercado',	'Operation',	'Office/Site Engineer',	'Admin',	'Mix Plant',	'',	'04-3982906-9',	'',	'',	14400.00,	3000.00,	'Rodrigo H. Espiritu',	'0915-285-8923',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180081',	'Rivera',	'Shiela Jane',	'Panganiban',	'Operation',	'QC Architect',	'Admin',	'Mix Plant',	'',	'34-6195690-7',	'',	'9160-2819-6407',	12000.00,	5600.00,	'Jona Rivera',	'0921-312-3959',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180082',	'Baldoza',	'Aliza',	'Regala',	'Operation',	'QS Architect',	'Admin',	'Mix Plant',	'',	'02-3688111-6',	'03-025988225-2',	'1211-7484-7359',	12000.00,	7000.00,	'Zaldy R. Baldoza',	'0916-669-2869',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180083',	'Gal',	'Ruth',	'Castillo',	'Operation',	'AutoCad Operator',	'Admin',	'Mix Plant',	'',	'33-9219433-3',	'02-050124383-4',	'1212-1047-7171',	12000.00,	5000.00,	'Ruel Gal',	'0997-199-8537',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180084',	'Leonizo',	'Sahlma',	'Tejero',	'Operation',	'Document Controller',	'Admin',	'Mix Plant',	'',	'33-7979296-5',	'08-050504735-8',	'1210-1225-7135',	12000.00,	8000.00,	'Sandro Tejero',	'0908-736-2639',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180085',	'Ringor',	'Jonathan',	'Peru',	'Operation',	'Assistant Surveyor',	'Admin',	'Mix Plant',	'',	'',	'',	'',	14400.00,	0.00,	'Thelma Ringor',	'0921-810-0963',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180086',	'Hernandez',	'Rolando',	'Espino',	'Operation',	'Surveyor',	'Admin',	'Mix Plant',	'',	'',	'',	'',	12000.00,	17800.00,	'Dalton Hernandez',	'0950-879-1552',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180087',	'Sampang III',	'Gregorio',	'Baluyut',	'Operation',	'Timekeeper',	'Admin',	'Mix Plant',	'',	'02-4049788-4',	'07-0257937672',	'1211-8142-5173',	13200.00,	1200.00,	'Rodel Sampang',	'0933-855-0840',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180088',	'Santos',	'Jhon Rolan',	'Mariano',	'Operation',	'Site Purchaser',	'Admin',	'Mix Plant',	'',	'02-3297501-3',	'08-025845483-2',	'1211-2964-9362',	12000.00,	2400.00,	'Celedonio Mariao',	'0942-037-3360',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180089',	'Cañedo',	'Almer',	'Turin',	'Operation',	'Warehouseman',	'Admin',	'Mix Plant',	'',	'',	'02-026982304-1',	'',	12000.00,	0.00,	'Ailyn Quize',	'0998-186-1545',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180090',	'Frias',	'Rolando',	'Evangelista',	'Operation',	'Utility',	'Admin',	'Mix Plant',	'',	'33-8046225-5',	'',	'1040-0227-4202',	12000.00,	0.00,	'Teofilo Frias',	'0906-025-8588',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180091',	'Cruz',	'Cesar',	'Francisco',	'Operation',	'Driver',	'Admin',	'Mix Plant',	'',	'03-7631188-9',	'',	'',	10320.00,	1200.00,	'Remedios E. Cruz',	'0935-689-1971',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180092',	'Cuaresma',	'Danilo',	'Pioquinto',	'Operation',	'Driver',	'Admin',	'Mix Plant',	'',	'33-3204508-6',	'',	'',	12000.00,	0.00,	'Yolanda Cruz',	'0950-942-0287',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180093',	'Torres',	'Romeo',	'De Leon',	'Operation',	'Electrician',	'Admin',	'Mix Plant',	'',	'',	'',	'',	12000.00,	3600.00,	'Elisabeth Torres',	'0916-879-5314',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180094',	'Caigas',	'Yollene',	'De Caiman',	'Operation',	'QS Engineer',	'Admin',	'Mix Plant',	'',	'34-4690636-7',	'03-051225127-3',	'1212-0959-8254',	18000.00,	0.00,	'Lina D. Caigas',	'0906-519-1092',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180095',	'Sampang',	'Rodel',	'Baluyut',	'Operation',	'Project Manager',	'Admin',	'Petron - Intramuros',	'',	'02-2856700-8',	'02-050768165-5',	'',	20000.00,	18000.00,	'Laarni C. Sampang',	'0925-819-0812',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180096',	'Del Pilar',	'Edel Mira',	'Piadozo',	'Operation',	'Officer in Charge',	'Admin',	'Privato',	NULL,	'02-3798052-4',	'21-025299637-5',	'1211-3714-1363',	21600.00,	4800.00,	NULL,	NULL,	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180097',	'De Pano',	'Giancarlo Michele',	'Mendoza',	'Operation',	'Project in Charge',	'Admin',	'Privato',	'',	'02-4039702-3',	'',	'1211-8130-8417',	12000.00,	7000.00,	'',	'',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180098',	'Cabantac',	'Julious',	'Montoya',	'Operation',	'QA/QC Engineer',	'Admin',	'Privato',	'303-771-856-000',	'33-9032929-4',	'01-050339626-8',	'',	35000.00,	0.00,	'',	'',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180099',	'Toledo',	'Jeniffer',	'Laban',	'Operation',	'QS Engineer',	'Admin',	'Privato',	'',	'02-3864356-9',	'05-025520699-8',	'1211-8543-5452',	12000.00,	7000.00,	'Jefferson  Toledo',	'0922-293-1292',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180100',	'Clariz',	'Mariah Camille',	'Salvador',	'Operation',	'MEPF Engineer',	'Admin',	'Privato',	'',	'34-6119106-3',	'14-251122896-3',	'1210-8720-2198',	16000.00,	0.00,	'Emily Gonzales',	'0939-352-6820',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180101',	'Manlulu',	'Rosie Marie',	'Roncal',	'Operation',	'Document Controller',	'Admin',	'Privato',	'',	'02-2637462-0',	'07-050751704-6',	'',	14400.00,	4000.00,	'Rodrigo Manlulu',	'0956-829-8930',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180102',	'Delos Angeles',	'Shiela Ruby',	'Maisano',	'Operation',	'Timekeeper',	'Admin',	'Privato',	'',	'',	'',	'',	10800.00,	2400.00,	'Rachelle Gragasin',	'',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180103',	'Alcala',	'Robert Anthony',	'Portugal',	'Operation',	'Safety Officer',	'Admin',	'Privato',	'326-195-291-000',	'05-0949673-3',	'01-025852829-3',	'9152-7433-4016',	12000.00,	6000.00,	'Desiree Ann Alcala',	'0928-256-2522',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180104',	'Santos',	'Potenciano',	'Cordero',	'Operation',	'Utility',	'Admin',	'Privato',	'',	'',	'',	'',	10800.00,	1200.00,	'Juvilyn Dechosa',	'0910-918-4345',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180105',	'Naranja',	'Vilbert',	'Nivera',	'Operation',	'Surveyor',	'Admin',	'Privato',	'',	'02-3360860-6',	'05-200992061-7',	'',	16800.00,	0.00,	'Vhrint Jay Naranja',	'0995-335-4890',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180106',	'Naranja',	'Khristian Paul',	'Manuel',	'Operation',	'Survey Aide',	'Admin',	'Privato',	'',	'02-3453408-3',	'07-050859243-2',	'',	13200.00,	0.00,	'Gemma Naranja',	'0994-501-0474',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180107',	'Mahinal',	'Kim Anthony',	'Manzano',	'Operation',	'Site Nurse',	'Admin',	'Privato',	'',	'07-2840767-1',	'',	'1105-0672-0060',	12000.00,	2000.00,	'Albert Sajonia',	'0909-058-1170',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180108',	'Hapa',	'Noli',	'Miranda',	'Operation',	'Warehouseman',	'Admin',	'Privato',	'',	'03-6891175-0',	'',	'',	13200.00,	1200.00,	'Julius Sadaya',	'0932-560-3769',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180109',	'Moreno',	'Roel',	'Bernabe',	'Operation',	'Survey Aide',	'Admin',	'Privato',	'',	'',	'07-201448143-6',	'',	12000.00,	2400.00,	'Geraldine Moreno',	'0938-552-8990',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180110',	'Dunan',	'Jennifer',	'Lagsic',	'Operation',	'Site Engineer',	'Admin',	'Sky Bravo',	'',	'04-3796482-9',	'08-025082545-9',	'9161-8934-8161',	16800.00,	9000.00,	'Ramon Santos',	'0977-734-5617',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180111',	'Culala Jr.',	'Juan',	'Santiago',	'Operation',	'Warehouseman',	'Admin',	'Trees Residences',	NULL,	'02-1458944-3',	'01-025109935-4',	'1211-9436-4382',	NULL,	NULL,	NULL,	NULL,	'No',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180112',	'Mendoza',	'Donnabelle',	'Camiguing',	'Operation',	'Site Engineer',	'Admin',	'Sky Bravo',	'',	'34-6913675-8',	'03-026161213-1',	'',	12000.00,	9000.00,	'Annabelle Mendoza',	'0948-250-6208',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180113',	'Olea',	'Cristopher',	'Pauig',	'Operation',	'Site Engineer',	'Admin',	'Sky Bravo',	'',	'01-2729725-9',	'06-025325388-9',	'',	12000.00,	9000.00,	'Ruel Olea',	'0997-551-4769',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180114',	'De Leon',	'Robinson',	'Delos Reyes',	'Operation',	'CAD Operator',	'Admin',	'Sky Bravo',	'',	'01-115415478-8',	'',	'',	12000.00,	4000.00,	'Erlinda De Leon',	'0917-657-3986',	'Yes',	'Yes',	'',	'2018-02-05',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180115',	'Bataller',	'Lilian',	'Torzar',	'Operation',	'Document Controller',	'Admin',	'Sky Bravo',	'',	'33-6432277-7',	'01-502030432-7',	'1010-0014-1983',	12000.00,	3600.00,	'Leizel Torzar',	'0956-477-3411',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180116',	'Macasaol',	'Rudy',	'Cuajotor',	'Operation',	'General Foreman',	'Admin',	'Sky Bravo',	'',	'',	'',	'',	16800.00,	4800.00,	'Mailyn Bacor',	'0999-194-6963',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180117',	'Chua',	'Joseph Anthony',	'Nebres',	'Operation',	'Project in Charge',	'Admin',	'Aurora Suites - Subic',	NULL,	'01-1963387-6',	'05-025215913-1',	'1210-8618-7100',	NULL,	NULL,	'NESTOR CHUA ',	'0905-3691925',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180118',	'Bernal',	'Ana Marie',	'Sanchez',	'Operation',	'Office/Site Engineer',	'Admin',	'Aurora Suites - Subic',	NULL,	'02-3332072-2',	'07-025658190-4',	'1211-5991-3437',	NULL,	NULL,	'NORY BERNAL',	'0999-9079103',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180119',	'Esteban',	'Jheeno',	'Malonzo',	'Operation',	'Safety Officer',	'Admin',	'Aurora Suites - Subic',	'',	'02-2714402-4',	'02-025433425-2',	'1210-1091-1789',	0.00,	0.00,	'ROSIELYN ESTEBAN',	'0906-8077918',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180120',	'Dela Cruz',	'Rowell',	'Desosa',	'Operation',	'Site First Aider',	'Admin',	'Aurora Suites - Subic',	NULL,	'02-2766522-8',	'07-025588467-9',	'1212-0276-7574',	NULL,	NULL,	'MARIA LOURDES DELA CRUZ ',	'0995-3748858',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180121',	'Lucagbo',	'Mike Anthony',	'Oblina',	'Operation',	'Surveyor',	'Admin',	'Aurora Suites - Subic',	NULL,	'08-1415822-9',	'03-025586879-5',	'1211-1615-2188',	NULL,	NULL,	'JOAN LUCAGBO ',	'0935-2214221',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180122',	'Lendio',	'Franz Darryl',	'Ramos',	'Operation',	'Timekeeper',	'Admin',	'Aurora Suites - Subic',	NULL,	'04-2617818-9',	'22-000172375-8',	'1201-0805-1152',	NULL,	NULL,	'RAQUEL LENDIO ',	'0946-8831786',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180123',	'Valerio',	'Conrado',	'Nerit',	'Operation',	'Liason Officer',	'Admin',	'Aurora Suites - Subic',	'',	'03-3122296-8',	'07-175203828-1',	'',	0.00,	0.00,	'Norma Valerio',	'0929-7016678',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180124',	'Rivera',	'Henricson',	'Palomaria',	'Operation',	'Operator',	'Admin',	'Aurora Suites - Subic',	NULL,	'07-2316702-6',	'11-050298658-9',	NULL,	NULL,	NULL,	'REGINA DUMILI ',	'0921-6295038',	'No',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL);
  
  DROP TABLE IF EXISTS `designation`;
  CREATE TABLE `designation` (
    `designationtitle` varchar(40) NOT NULL,
    PRIMARY KEY (`designationtitle`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `designation` (`designationtitle`) VALUES
  ('Accountant'),
  ('Admin Assistant'),
  ('Admin Staff'),
  ('Apprentice'),
  ('Assistant Finance'),
  ('Assistant Human Resource'),
  ('Assistant Project Manager'),
  ('Assistant Surveyor'),
  ('Assistant Warehouseman'),
  ('Audit'),
  ('AutoCad Operator'),
  ('Bookkeeper'),
  ('Building Inspector'),
  ('CAD Operator'),
  ('Carpenter'),
  ('Chief Estimator'),
  ('Civil Engineer'),
  ('Collection Officer'),
  ('Collection Officer / HR Procurement'),
  ('Concrete Laborers'),
  ('Construction Assistant'),
  ('Construction Coordinator'),
  ('Construction Engineer'),
  ('Construction Foreman'),
  ('Construction Manager'),
  ('Construction Superintendent'),
  ('Construction Supervisor'),
  ('Construction Worker'),
  ('Contract Administrator'),
  ('Contract Manager'),
  ('Crane Operator'),
  ('Document Controller'),
  ('Driver'),
  ('Dry Wall Finisher'),
  ('Dry wall Installer'),
  ('Electrician'),
  ('Equipment Operator'),
  ('Estimator'),
  ('Field Checker'),
  ('Field Engineer'),
  ('Formworks Engineer'),
  ('Framing Carpenter'),
  ('General Foreman'),
  ('General Laborer'),
  ('Guard'),
  ('Helper'),
  ('Human Resource Officer'),
  ('Inspector'),
  ('Iron Worker'),
  ('Joiner'),
  ('Laborer'),
  ('Liason Officer'),
  ('Logistic / Safety Head'),
  ('Master Electrician'),
  ('Master Plumber'),
  ('MEPF Engineer'),
  ('Messenger'),
  ('Office/Site Engineer'),
  ('Officer in Charge'),
  ('Operation Manager'),
  ('Operator'),
  ('Painter'),
  ('Pipe Fitter'),
  ('Planner'),
  ('Plumber'),
  ('President'),
  ('Project Assistant'),
  ('Project in Charge'),
  ('Project Manager'),
  ('Project Supervisor'),
  ('Purchaser Head'),
  ('Purchasing Coordinator'),
  ('Purchasing Officer'),
  ('QA/QC Engineer'),
  ('QC Architect'),
  ('QS Architect'),
  ('QS Engineer'),
  ('Rebar Engineer'),
  ('Roofer'),
  ('Safety Director'),
  ('Safety Manager'),
  ('Safety Officer'),
  ('Scheduler'),
  ('Signal Worker'),
  ('Site Architect'),
  ('Site Engineer'),
  ('Site First Aider'),
  ('Site Manager'),
  ('Site Nurse'),
  ('Site Purchaser'),
  ('Superintendent'),
  ('Survey Aide'),
  ('Surveyor'),
  ('System Developer'),
  ('Timekeeper'),
  ('Utility'),
  ('VP-Admin'),
  ('VP-Finance'),
  ('Warehouseman'),
  ('Welder');
  
  DROP TABLE IF EXISTS `employee`;
  CREATE TABLE `employee` (
    `employeecode` varchar(15) NOT NULL,
    `employeelast` varchar(20) DEFAULT NULL COMMENT 'Family Name',
    `employeefirst` varchar(20) DEFAULT NULL COMMENT 'Given Name',
    `employeemiddle` varchar(20) DEFAULT NULL COMMENT 'Mother''s Maiden Lastname',
    `groupname` varchar(40) DEFAULT NULL COMMENT 'Department Name',
    `designation` varchar(40) DEFAULT NULL COMMENT 'Position Title',
    `employmentcategory` varchar(15) DEFAULT NULL,
    `project` varchar(40) DEFAULT NULL COMMENT 'Name of project where the employee was assigned.',
    `tin_number` varchar(25) DEFAULT NULL,
    `sss_number` varchar(25) DEFAULT NULL,
    `phic_number` varchar(25) DEFAULT NULL,
    `hdmf_number` varchar(25) DEFAULT NULL,
    `basicsalary` decimal(7,2) DEFAULT NULL COMMENT 'Monthly',
    `allowances` decimal(7,2) DEFAULT NULL COMMENT 'Monthly',
    `contactperson` varchar(40) DEFAULT NULL,
    `contactnumber` varchar(20) DEFAULT NULL,
    `photoavailable` varchar(3) DEFAULT NULL,
    `signatureavailable` varchar(3) DEFAULT NULL,
    `hiredate` varchar(10) DEFAULT NULL COMMENT 'Date when employee was hired.',
    `terminationdate` varchar(10) DEFAULT NULL COMMENT 'If contract has been terminated, when it is terminated.',
    `suspensionremarks` text,
    `finalpay` varchar(3) DEFAULT NULL COMMENT 'Yes or No',
    `finalpayreleasedate` varchar(20) DEFAULT NULL COMMENT 'When is the final pay released.',
    `activeemployment` varchar(3) DEFAULT 'Yes' COMMENT 'Yes or No',
    `referencenumber` varchar(12) DEFAULT NULL,
    `regulartime_reference` bigint(20) DEFAULT NULL,
    `overtime_reference` bigint(20) DEFAULT NULL,
    `activitystatus` varchar(40) DEFAULT NULL,
    `printed` varchar(3) DEFAULT NULL,
    `phone` varchar(40) DEFAULT NULL,
    `email` varchar(60) DEFAULT NULL,
    `address` text,
    `username` varchar(20) DEFAULT NULL,
    `userpass` varchar(20) DEFAULT NULL,
    `payrollfrequency` varchar(15) DEFAULT NULL,
    `payrollcutoff` varchar(15) DEFAULT NULL,
    `employmentstatus` varchar(15) DEFAULT NULL,
    `accountnumber` varchar(15) DEFAULT NULL,
    `accountname` varchar(40) DEFAULT NULL,
    `suspensiondate` varchar(20) DEFAULT NULL,
    `salarytype` varchar(15) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `employee` (`employeecode`, `employeelast`, `employeefirst`, `employeemiddle`, `groupname`, `designation`, `employmentcategory`, `project`, `tin_number`, `sss_number`, `phic_number`, `hdmf_number`, `basicsalary`, `allowances`, `contactperson`, `contactnumber`, `photoavailable`, `signatureavailable`, `hiredate`, `terminationdate`, `suspensionremarks`, `finalpay`, `finalpayreleasedate`, `activeemployment`, `referencenumber`, `regulartime_reference`, `overtime_reference`, `activitystatus`, `printed`, `phone`, `email`, `address`, `username`, `userpass`, `payrollfrequency`, `payrollcutoff`, `employmentstatus`, `accountnumber`, `accountname`, `suspensiondate`, `salarytype`) VALUES
  ('20180001',	'Rivera',	'Rhodel',	'Valerio',	'Management',	'President',	'Admin',	'Head Office',	NULL,	'33-0146624-3',	'01-025034845-8',	'1060-0104-0267',	NULL,	NULL,	NULL,	NULL,	'No',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180002',	'Rivera',	'Ronand',	'Valerio',	'Management',	'VP-Finance',	'Admin',	'Head Office',	NULL,	'33-9141489-4',	'01-025034835-0',	'1060-0104-0278',	NULL,	NULL,	NULL,	NULL,	'No',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180003',	'Rivera',	'Rhoame',	'Enriquez',	'Management',	'VP-Admin',	'Admin',	'Head Office',	'',	'34-4235012-4',	'',	'',	0.00,	0.00,	'',	'',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180004',	'Sadaya',	'Julius',	'Hapa',	'Operation',	'Operation Manager',	'Admin',	'Head Office',	NULL,	'06-1723953-6',	'03-050674326-1',	'1211-5487-5627',	30000.00,	15000.00,	'Vilma Sadaya',	'0923-155-6287',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180005',	'Padilla',	'Bernardo',	'Nañasca',	'Operation',	'Project Manager',	'Admin',	'Head Office',	NULL,	'33-0379659-7',	'19-025202060-1',	'1060-0104-3875',	40000.00,	NULL,	'Shirley Padilla',	'0906-254-2054',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180006',	'Valerio Jr.',	'Nicanor',	'Nerit',	'Engineering',	'Chief Estimator',	'Admin',	'Head Office',	NULL,	'03-7547394-8',	'03-050926978-1',	'9162-8089-6426',	20000.00,	5000.00,	'Eloisa Valerio',	'0933-451-0376',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180007',	'Medina',	'Joey',	'Pineda',	'Purchasing',	'Purchaser Head',	'Admin',	'Head Office',	NULL,	'33-0146628-5',	'01-025038688-0',	NULL,	11000.00,	6000.00,	'Eleanor Medina',	'0918-594-5546',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180008',	'Medina',	'Jacinto',	'Lapira',	'Accounting',	'Bookkeeper',	'Admin',	'Head Office',	NULL,	'03-3699050-9',	'03-050641347-4',	'1060-0104-3952',	20800.00,	5200.00,	'Selfa Medina',	'0995-651-2513',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180009',	'Valerio',	'Conrad',	'Valerio',	'Logistics',	'Logistic / Safety Head',	'Admin',	'Head Office',	NULL,	'02-1770464-9',	'07-051057483-2',	'9162-8198-7760',	15000.00,	3000.00,	'Aikon Valerio',	'0975-985-2615',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'RA6707866784',	20,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180010',	'Valerio',	'Darmo',	'Robles',	'Sales',	'Liason Officer',	'Admin',	'Head Office',	NULL,	'33-0146625-6',	'01-025038681-3',	'1060-0104-3941',	11000.00,	6000.00,	'Leonora Valerio',	'0910-849-7761',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'PZ3451823425',	32,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180011',	'Kabigting',	'Cristan',	'Jurado',	'Information Technology',	'System Developer',	'Admin',	'Head Office',	'253-064-434',	'03-9641903-3',	'12-050491036-4',	'0019-4970-1411',	21000.00,	4000.00,	'Raquel Kabigting',	'0920-223-3133',	'Yes',	'Yes',	'',	'',	'',	NULL,	'',	'Yes',	'IQ0228147395',	44,	0,	'Working Regular Time',	'Yes',	'',	'',	'',	'',	'',	'Weekly',	'Tuesday',	'Employed',	'',	'',	'',	'Monthly'),
  ('20180012',	'Buenviaje',	'Rodelio',	'Santos',	'Accounting',	'Accountant',	'Admin',	'Head Office',	'',	'03-5619547-8',	'19-050833462-5',	'',	15000.00,	12504.00,	'Ronidel Buenviaje',	'0923-229-7880',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'DM5809444778',	46,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180013',	'Opon',	'Glenda',	'Angeles',	'Human Resource',	'Human Resource Officer',	'Admin',	'Head Office',	NULL,	'33-3224620-9',	'19-051605828-9',	'1210-4848-0895',	19200.00,	NULL,	'Imelda Opon',	'573-72-84',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180014',	'Bautista',	'Sarah Clarris',	'Cleofas',	'Accounting',	'Assistant Finance',	'Admin',	'Head Office',	NULL,	'34-5205234-4',	'07-051040173-3',	'1211-4700-8240',	12000.00,	3600.00,	'Clara Bautista',	'0933-195-8074',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'TC3081527142',	38,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180015',	'Ugalde',	'Klairie',	'Abestilla',	'Human Resource',	'Assistant Human Resource',	'Admin',	'Head Office',	'',	'34-5052738-9',	'03-025735545-0',	'',	14400.00,	4800.00,	'Sam Basil',	'0939-765-9578',	'Yes',	'Yes',	'2015-07-20',	'',	'',	NULL,	NULL,	'Yes',	'AS7828815750',	48,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180016',	'Rivera',	'Liwayway Trinidad',	'Cleofas',	'Human Resource',	'Assistant Human Resource',	'Admin',	'Head Office',	NULL,	'34-4507981-3',	'02-026220498-8',	'1211-1693-7419',	12000.00,	NULL,	'Clara Bautista',	'0933-195-8074',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180017',	'Pamiloza',	'Kathleen Ann',	'Padiernos',	'Engineering',	'QS Engineer',	'Admin',	'Head Office',	NULL,	'34-6148645-1',	'21-200266089-7',	'9160-2816-8432',	25000.00,	10800.00,	'Olga Pamiloza',	'0905-329-6524',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'OG3500022029',	47,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180018',	'Hapa',	'Raven James',	'Mendoza',	'Engineering',	'QS Engineer',	'Admin',	'Head Office',	NULL,	'34-2333613-8',	'21-050115637-4',	'1210-2288-9493',	16000.00,	4000.00,	'Bong Fandiño',	'0995-164-1432',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'SZ0163119799',	40,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180019',	'Singma',	'Jennifer',	'Lining',	'Sales',	'Collection Officer / HR Procurement',	'Admin',	'Head Office',	NULL,	'34-1351835-1',	'01-050940843-8',	'9162-8092-4523',	12000.00,	3600.00,	'Mark Singma',	'0917-120-9524',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180020',	'Maniego',	'Ivy Lahar',	'Inocencion',	'Sales',	'Collection Officer',	'Admin',	'Head Office',	'',	'02-3734512-7',	'07-201535626-0',	'1211-3967-8068',	12000.00,	1200.00,	'Elvira Maniego',	'0975-413-8987',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180021',	'Barcelon',	'Darlene',	'Rodulfa',	'Purchasing',	'Purchasing Officer',	'Admin',	'Head Office',	NULL,	NULL,	NULL,	NULL,	9600.00,	NULL,	'Arlene Barcelon',	'0905-558-6749',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180022',	'Manlulu',	'Oliver',	'Manlulu',	'Purchasing',	'Purchasing Officer',	'Admin',	'Head Office',	NULL,	'02-2478806-9',	'07-050752527-8',	NULL,	14400.00,	NULL,	'Beth Manlulu',	'0923-535-2042',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180023',	'Dorado',	'Neil',	'Valerio',	'Sales',	'Liason Officer',	'Admin',	'Head Office',	NULL,	'02-1777461-1',	'19-089651984-4',	'9162-8086-3433',	12000.00,	1200.00,	'Ron Dorado',	'0945-324-9830',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'NA2398298563',	16,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180024',	'Navarro',	'Jelmar',	'Samson',	'Sales',	'Messenger',	'Admin',	'Head Office',	NULL,	NULL,	NULL,	NULL,	10320.00,	1680.00,	'Adonica Navarro',	'0955-403-2933',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180025',	'Mesa',	'Rey',	'Medina',	'Logistics',	'Warehouseman',	'Admin',	'Head Office',	NULL,	'02-1320547-2',	NULL,	'9160-7709-0541',	12000.00,	3600.00,	'Clara Mesa',	'0918-287-8384',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'WY2098251656',	23,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180026',	'Espino',	'Van Halen',	'Ramos',	'Logistics',	'Assistant Warehouseman',	'Admin',	'Head Office',	'',	'02-4328495-5',	'07-251155193-6',	'',	12000.00,	2400.00,	'Jannine Espino',	'0956-142-4732',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'JW6825865767',	30,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180027',	'Punzalan',	'Jerome',	'Calalang',	'Logistics',	'Assistant Warehouseman',	'Admin',	'Head Office',	NULL,	NULL,	NULL,	NULL,	8400.00,	1200.00,	'Remedios Punzalan',	'0975-189-8798',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'YK0034655844',	31,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180028',	'Esplana',	'Jay-ar',	'Bequillo',	'Maintenance',	'Utility',	'Admin',	'Head Office',	NULL,	NULL,	'10-201766701-4',	NULL,	12000.00,	NULL,	'Jeniffer Bajado',	'0950-259-0901',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'XR0175123277',	34,	0,	'Working Regular Time',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180029',	'Al-aziz',	'Marcelo',	'Amerkhan',	'Maintenance',	'Painter',	'Admin',	'Head Office',	NULL,	NULL,	NULL,	NULL,	12000.00,	2400.00,	'Lechit',	'0955-946-8737',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180030',	'Flores',	'Marlon',	'Daquiz',	'Logistics',	'Driver',	'Admin',	'Head Office',	NULL,	'02-2498423-2',	'07-051040179-2',	'9163-0120-4288',	10800.00,	2400.00,	'Rosanna Flores',	'0935-953-3360',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180031',	'Macahilig',	'Ronnie',	'Dalida',	'Logistics',	'Driver',	'Admin',	'Head Office',	NULL,	'03-5959657-9',	'01-025109933-8',	'9160-4055-5545',	14400.00,	1200.00,	'Rosalina Macahilig',	'0927-482-6721',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180032',	'Castro',	'Jay',	'Silva',	'Logistics',	'Driver',	'Admin',	'Head Office',	NULL,	'33-0510902-7',	NULL,	NULL,	10800.00,	1200.00,	'Exie Guiala',	'0932-611-3273',	'Yes',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180033',	'Soliman',	'Michael',	'Karaan',	'Logistics',	'Driver',	'Admin',	'Head Office',	NULL,	'33-2501857-0',	'19-200579387-0',	NULL,	12000.00,	NULL,	'Lourdes Soliman',	'0906-720-4422',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180034',	'Mantilla',	'Gonzalo',	'Bactasa',	'Logistics',	'Driver',	'Admin',	'Head Office',	'',	'03-8681548-5',	'02-050194667-3',	'1211-2297-8939',	12000.00,	1200.00,	'Lete Mantilla',	'0928-899-0650',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180035',	'Mantilla',	'Nemesio',	'Amoguis',	'Logistics',	'Driver',	'Admin',	'Head Office',	'',	'33-1906665-1',	'19-052418442-0',	'',	12000.00,	1200.00,	'Jelyn Mantilla',	'0942-613-1232',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180036',	'Calalang',	'Luis',	'Yacat',	'Logistics',	'Driver',	'Admin',	'Head Office',	'',	'02-4042535-1',	'07-200467900-9',	'9160-2817-8235',	12000.00,	9600.00,	'Evelyn Calalang',	'0936-807-1712',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180037',	'Calalang',	'Darwin',	'Mojeno',	'Logistics',	'Helper',	'Admin',	'Head Office',	'',	'',	'',	'9160-2818-4242',	9600.00,	1200.00,	'Mary Joy Galang',	'0975-039-5661',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180038',	'Calalang',	'Andy',	'Mojeno',	'Logistics',	'Helper',	'Admin',	'Head Office',	'',	'',	'',	'9160-2818-0213',	9600.00,	1200.00,	'Cindy Calalang',	'0926-541-1400',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180039',	'Lazado',	'Regenor',	'',	'Logistics',	'Driver',	'Admin',	'Head Office',	'',	'02-3408443-6',	'',	'',	9600.00,	1200.00,	'Roxan Lazado',	'0975-436-5161',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180040',	'Valerio',	'Francisco',	'Nerit',	'Logistics',	'Collection Officer',	'Admin',	'Head Office',	NULL,	NULL,	NULL,	NULL,	15600.00,	NULL,	'Joselyn Valerio',	'0942-339-4207',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180041',	'Pantanilla',	'Bienvenido',	'Ciprez',	'Security',	'Guard',	'Admin',	'Head Office',	'',	'34-0415242-5',	'',	'',	19500.00,	0.00,	'Dinah Joy Pantanilla',	'239-30-43',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180042',	'Lucas',	'Albert',	'Dela Cruz',	'Security',	'Guard',	'Admin',	'Head Office',	'',	'34-1853178-6',	'03-050723938-9',	'',	19500.00,	0.00,	'Ria Lucas',	'0915-572-8231',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180043',	'Dela Cruz',	'Babylyne',	'Cawas',	'Accounting',	'Project Auditor',	'Admin',	'Head Office',	'441-801-380-000',	'01-0837382-0',	'01-025205765-5',	'1211-1469-9129',	512.00,	0.00,	'Margie Romero',	'09163574491',	'Yes',	'Yes',	'2018-01-22',	'',	'',	NULL,	'',	'Yes',	'',	0,	0,	'',	'Yes',	'',	'',	'',	'',	'',	'Weekly',	'Tuesday',	'Employed',	'',	'',	'',	'Daily'),
  ('20180044',	'Calica',	'Richard',	'Ronquillo',	'Operation',	'Project in Charge',	'Admin',	'Jupiter & Mars',	'933-117-401',	'01-1562786-0',	'04-025074820-7',	'',	23000.00,	2000.00,	'Jocelyn Borbe',	'0905-1766-462',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180045',	'Mangulabnan',	'Odon',	'Sigua',	'Operation',	'Safety Officer',	'Admin',	'Jupiter & Mars',	'',	'02-3981761-1',	'',	'9163-0121-1362',	12000.00,	3600.00,	'Lilia Herno',	'0943-296-9587',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180046',	'Inocencion',	'Elmer',	'Quiambao',	'Operation',	'Timekeeper',	'Admin',	'Jupiter & Mars',	'',	'33-2845205-2',	'07-200434806-1',	'',	12000.00,	1200.00,	'Villa A. Inocencion',	'0998-918-1045',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180047',	'Lacanilao',	'Ramil',	'Abueg',	'Operation',	'Admin Staff',	'Admin',	'Jupiter & Mars',	'',	'33-0289195-6',	'03-025121309-3',	'12120827-1588',	10800.00,	2400.00,	'Candida Lacanilao',	'0915-152-8204',	'Yes',	'Yes',	'',	'',	'',	NULL,	'',	'Yes',	'',	0,	0,	'',	'Yes',	'',	'',	'',	'',	'',	'Weekly',	'Tuesday',	'Employed',	'',	'',	'',	'Monthly'),
  ('20180048',	'Remoto',	'Richard',	'Jansalin',	'Operation',	'Project Manager',	'Admin',	'MDC-Arca South',	'',	'33-0247597-4',	'19-089712053-8',	'',	20000.00,	30000.00,	'Mary Grace Remoto',	'0906-301-3297',	'Yes',	'Yes',	'2016-08-20',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180049',	'Bucu',	'Benigno',	'Lagazon',	'Operation',	'Project in Charge',	'Admin',	'MDC-Arca South',	'',	'33-0837434-1',	'',	'',	40000.00,	0.00,	'Marlyn P. Bucu',	'0928-930-7861',	'Yes',	'Yes',	'2016-04-16',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180050',	'Secundo',	'Benjamen',	'Carullo',	'Operation',	'Project in Charge',	'Admin',	'MDC-Arca South',	'',	'33-0686362-1',	'19-052374658-1',	'1070-0109-4587',	50000.00,	0.00,	'Violeta Secundo',	'0977-819-1853',	'Yes',	'Yes',	'2016-10-08',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180051',	'Pagar',	'Alberto',	'Lagao',	'Operation',	'Project Supervisor',	'Admin',	'MDC-Arca South',	'',	'33-0482820-2',	'19-089981788-8',	'1070-0133-0681',	20000.00,	0.00,	'Priscilla Pagar',	'0950-632-6591',	'Yes',	'Yes',	'2015-11-24',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180052',	'Camaña',	'Shannen Faye',	'Turaray',	'Operation',	'QS Engineer',	'Admin',	'MDC-Arca South',	'',	'34-4922558-2',	'03-051094944-3',	'1210-9442-7721',	20000.00,	7000.00,	'Canilo CamaÃ±a',	'0912-504-8004',	'Yes',	'Yes',	'2015-11-02',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180053',	'Nicolas',	'John Michael',	'Aliwanag',	'Operation',	'QA/QC Engineer',	'Admin',	'MDC-Arca South',	'',	'34-4835832-4',	'',	'1211-6033-7773',	25000.00,	0.00,	'Milagros Nicolas',	'0922-280-1259',	'Yes',	'Yes',	'2017-05-11',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180054',	'Abanes',	'Leslie',	'Vidallo',	'Operation',	'QA/QC Engineer',	'Admin',	'MDC-Arca South',	'',	'34-1046147-2',	'',	'0102-6062-4917',	13000.00,	2000.00,	'Neri Abanes',	'0946-415-9107',	'Yes',	'Yes',	'2017-01-13',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180055',	'Rosauro',	'Lucky Grace',	'',	'Operation',	'QA/QC Engineer',	'Admin',	'MDC-Arca South',	'',	'34-5307414-3',	'03-025819125-7',	'9152-0712-9903',	15000.00,	0.00,	'Nora Rosauro',	'0905-296-0022',	'Yes',	'Yes',	'2017-02-13',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180056',	'Aspa IV',	'Lorenzo',	'Villareal',	'Operation',	'Formworks Engineer',	'Admin',	'MDC-Arca South',	'',	'',	'',	'',	12000.00,	3000.00,	'Helen Grace Aspa',	'0915-496-1624',	'Yes',	'Yes',	'2017-07-11',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180057',	'Dugay',	'Jonna',	'Bauyon',	'Operation',	'Formworks Engineer',	'Admin',	'MDC-Arca South',	'',	'34-0894920-7',	'02-050452798-1',	'',	18000.00,	3600.00,	'Benita Dugay',	'405-27-29',	'Yes',	'Yes',	'2015-12-02',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180058',	'Tagufa',	'Christian',	'Flores',	'Operation',	'Rebar Engineer',	'Admin',	'MDC-Arca South',	'',	'34-6649094-7',	'',	'',	12000.00,	6000.00,	'Gina Tagufa',	'534-43-03',	'Yes',	'Yes',	'2015-12-08',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180059',	'Raynes',	'Raymon',	'Lopez',	'Operation',	'Rebar Engineer',	'Admin',	'MDC-Arca South',	'',	'05-0541808-7',	'',	'1211-098529018',	12000.00,	6000.00,	'Normita Raynes',	'0935-975-9917',	'Yes',	'Yes',	'2016-05-18',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180060',	'Alfonso',	'Kevin James',	'Aguilar',	'Operation',	'Site Architect',	'Admin',	'MDC-Arca South',	'',	'02-3589150-5',	'10-051928379-6',	'9163-0120-7551',	12000.00,	7200.00,	'Monico Alfonso',	'0927-463-3364',	'Yes',	'Yes',	'2017-04-18',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180061',	'Lopez',	'Erwin',	'Dela Vega',	'Operation',	'Surveyor',	'Admin',	'MDC-Arca South',	'',	'34-0138040-7',	'01-051409096-9',	'1040-0123-0841',	12000.00,	9000.00,	'Kristine Joanne Lopez',	'0943-254-2364',	'Yes',	'Yes',	'2016-01-18',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180062',	'Elen',	'Harold',	'Flores',	'Operation',	'Safety Officer',	'Admin',	'MDC-Arca South',	'',	'33-8531865-0',	'',	'',	12000.00,	3000.00,	'Jenny Rose Elen',	'0928-205-0244',	'Yes',	'No',	'2016-12-15',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180063',	'Dimatatac',	'Arnold',	'Hernandez',	'Operation',	'Safety Officer',	'Admin',	'MDC-Arca South',	'',	'04-2875194-4',	'09-050424553-4',	'1211-7000-8970',	12000.00,	1200.00,	'Marissa Dimatatac',	'0947-951-0309',	'Yes',	'Yes',	'2016-09-23',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180064',	'De Umania',	'Angelo',	'De Leon',	'Operation',	'Safety Officer',	'Admin',	'MDC-Arca South',	'',	'02-3841602-6',	'07-025803569-9',	'1211-8031-5923',	12000.00,	0.00,	'Luela De Umania',	'0930-836-6112',	'Yes',	'Yes',	'2017-09-12',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180065',	'Lorenzo',	'Alma',	'Pecha',	'Operation',	'Admin Assistant',	'Admin',	'MDC-Arca South',	'',	'07-2699190-1',	'01-025978350-5',	'1211-73995242',	12000.00,	1200.00,	'Leah Francisco',	'0999-704-2420',	'Yes',	'Yes',	'2016-08-11',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180066',	'Maglaqui',	'Maria Amor',	'Angeles',	'Operation',	'Document Controller',	'Admin',	'MDC-Arca South',	'',	'04-1757541-6',	'08-025225012-7',	'1010-0148-8633',	12000.00,	1200.00,	'Christina Maglaqui',	'0916-976-1096',	'Yes',	'Yes',	'2017-02-28',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180067',	'Gamboa',	'Rhyann',	'Valerio',	'Operation',	'Site Purchaser',	'Admin',	'MDC-Arca South',	'',	'',	'',	'',	12000.00,	2300.00,	'Ma. Theresa Guina',	'0908-341-5627',	'Yes',	'Yes',	'2015-11-18',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180068',	'Tabarangao',	'Jazel',	'Sadac',	'Operation',	'Timekeeper',	'Admin',	'MDC-Arca South',	'',	'34-4562339-5',	'03-200270480-2',	'',	12000.00,	0.00,	'Ma. Victoria Tabarangao',	'0998-284-4755',	'Yes',	'Yes',	'2017-05-26',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180069',	'Jorda',	'Edlyn Apple',	'Bernaldez',	'Operation',	'Timekeeper',	'Admin',	'MDC-Arca South',	'',	'33-6275395-3',	'01-025397541-0',	'',	10800.00,	0.00,	'Alfredo Baira Jr.',	'0916-430-4441',	'Yes',	'Yes',	'2017-08-26',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180070',	'Navales',	'Maricar',	'Delos Santos',	'Operation',	'Field Checker',	'Admin',	'MDC-Arca South',	'',	'34-1914136-6',	'03-025348170-2',	'',	10800.00,	1200.00,	'Marissa Monte',	'0977-642-0402',	'Yes',	'Yes',	'2016-09-15',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180071',	'Mariano Jr.',	'Celedonio',	'Suba',	'Operation',	'Project Manager',	'Admin',	'Mix Plant',	'',	'02-0928029-4',	'19-090426994-1',	'0070-4972-0609',	38000.00,	17000.00,	'Arlene Mariano',	'0917-721-8153',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180072',	'Cañonio',	'Fidel',	'Tantiado',	'Operation',	'Project Manager',	'Admin',	'Mix Plant',	'',	'06-0754557-3',	'19-200157592-5',	'1210-6380-1307',	55000.00,	0.00,	'Anita Canonio',	'0905-110-0740',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180073',	'Basil',	'Sam Zoren',	'Hamid',	'Operation',	'Project in Charge',	'Admin',	'Mix Plant',	'',	'34-3075307-6',	'03-050939838-7',	'1211-8536-6701',	35000.00,	0.00,	'Klairie Ugalde',	'0921-540-7985',	'Yes',	'Yes',	'2015-05-10',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180074',	'Mananghaya',	'Michael',	'Parico',	'Operation',	'Safety Officer',	'Admin',	'Mix Plant',	'',	'33-7175319-3',	'03-025889560-2',	'9153-6333-1346',	16224.00,	0.00,	'Irene Rea Soliven',	'0916-758-2479',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180075',	'Almario',	'Jeremias',	'Dapon',	'Operation',	'Safety Officer',	'Admin',	'Mix Plant',	'',	'03-8765524-6',	'19-090143115-2',	'1211-5483-4889',	12000.00,	2400.00,	'Jerico Jerry Almario',	'0929-390-0288',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180076',	'Ayuman',	'Ariel',	'Dimas',	'Operation',	'Safety Officer',	'Admin',	'Mix Plant',	'',	'34-1393997-1',	'01-051233587-5',	'1210-4044-3213',	12000.00,	2400.00,	'Cresame Aquino',	'0930-785-3232',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180077',	'Rublico',	'Dante',	'Perucho',	'Operation',	'Site Nurse',	'Admin',	'Mix Plant',	'',	'33-1198048-9',	'19-051593296-1',	'1210-7361-3996',	12000.00,	8000.00,	'Eva S. Cruz',	'0924-591-6457',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180078',	'Gannaban',	'Jaydee',	'Marcos',	'Operation',	'Rebar Engineer',	'Admin',	'Mix Plant',	NULL,	NULL,	NULL,	NULL,	12000.00,	6000.00,	NULL,	NULL,	'Yes',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180079',	'Valdez',	'Karl Gerard',	'Umoso',	'Operation',	'Formworks Engineer',	'Admin',	'Mix Plant',	'',	'01-2643926-7',	'06-025303235-1',	'1212-1069-4001',	12000.00,	4000.00,	'Maribel U. Valdez',	'0906-842-9400',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180080',	'Espiritu',	'Ma. Shaina',	'Mercado',	'Operation',	'Office/Site Engineer',	'Admin',	'Mix Plant',	'',	'04-3982906-9',	'',	'',	14400.00,	3000.00,	'Rodrigo H. Espiritu',	'0915-285-8923',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180081',	'Rivera',	'Shiela Jane',	'Panganiban',	'Operation',	'QC Architect',	'Admin',	'Mix Plant',	'',	'34-6195690-7',	'',	'9160-2819-6407',	12000.00,	5600.00,	'Jona Rivera',	'0921-312-3959',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180082',	'Baldoza',	'Aliza',	'Regala',	'Operation',	'QS Architect',	'Admin',	'Mix Plant',	'',	'02-3688111-6',	'03-025988225-2',	'1211-7484-7359',	12000.00,	7000.00,	'Zaldy R. Baldoza',	'0916-669-2869',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180083',	'Gal',	'Ruth',	'Castillo',	'Operation',	'AutoCad Operator',	'Admin',	'Mix Plant',	'',	'33-9219433-3',	'02-050124383-4',	'1212-1047-7171',	12000.00,	5000.00,	'Ruel Gal',	'0997-199-8537',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180084',	'Leonizo',	'Sahlma',	'Tejero',	'Operation',	'Document Controller',	'Admin',	'Mix Plant',	'',	'33-7979296-5',	'08-050504735-8',	'1210-1225-7135',	12000.00,	8000.00,	'Sandro Tejero',	'0908-736-2639',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180085',	'Ringor',	'Jonathan',	'Peru',	'Operation',	'Assistant Surveyor',	'Admin',	'Mix Plant',	'',	'',	'',	'',	14400.00,	0.00,	'Thelma Ringor',	'0921-810-0963',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180086',	'Hernandez',	'Rolando',	'Espino',	'Operation',	'Surveyor',	'Admin',	'Mix Plant',	'',	'',	'',	'',	12000.00,	17800.00,	'Dalton Hernandez',	'0950-879-1552',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180087',	'Sampang III',	'Gregorio',	'Baluyut',	'Operation',	'Timekeeper',	'Admin',	'Mix Plant',	'',	'02-4049788-4',	'07-0257937672',	'1211-8142-5173',	13200.00,	1200.00,	'Rodel Sampang',	'0933-855-0840',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180088',	'Santos',	'Jhon Rolan',	'Mariano',	'Operation',	'Site Purchaser',	'Admin',	'Mix Plant',	'',	'02-3297501-3',	'08-025845483-2',	'1211-2964-9362',	12000.00,	2400.00,	'Celedonio Mariao',	'0942-037-3360',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180089',	'Cañedo',	'Almer',	'Turin',	'Operation',	'Warehouseman',	'Admin',	'Mix Plant',	'',	'',	'02-026982304-1',	'',	12000.00,	0.00,	'Ailyn Quize',	'0998-186-1545',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180090',	'Frias',	'Rolando',	'Evangelista',	'Operation',	'Utility',	'Admin',	'Mix Plant',	'',	'33-8046225-5',	'',	'1040-0227-4202',	12000.00,	0.00,	'Teofilo Frias',	'0906-025-8588',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180091',	'Cruz',	'Cesar',	'Francisco',	'Operation',	'Driver',	'Admin',	'Mix Plant',	'',	'03-7631188-9',	'',	'',	10320.00,	1200.00,	'Remedios E. Cruz',	'0935-689-1971',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180092',	'Cuaresma',	'Danilo',	'Pioquinto',	'Operation',	'Driver',	'Admin',	'Mix Plant',	'',	'33-3204508-6',	'',	'',	12000.00,	0.00,	'Yolanda Cruz',	'0950-942-0287',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180093',	'Torres',	'Romeo',	'De Leon',	'Operation',	'Electrician',	'Admin',	'Mix Plant',	'',	'',	'',	'',	12000.00,	3600.00,	'Elisabeth Torres',	'0916-879-5314',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180094',	'Caigas',	'Yollene',	'De Caiman',	'Operation',	'QS Engineer',	'Admin',	'Mix Plant',	'',	'34-4690636-7',	'03-051225127-3',	'1212-0959-8254',	18000.00,	0.00,	'Lina D. Caigas',	'0906-519-1092',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180095',	'Sampang',	'Rodel',	'Baluyut',	'Operation',	'Project Manager',	'Admin',	'Petron - Intramuros',	'',	'02-2856700-8',	'02-050768165-5',	'',	20000.00,	18000.00,	'Laarni C. Sampang',	'0925-819-0812',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180096',	'Del Pilar',	'Edel Mira',	'Piadozo',	'Operation',	'Officer in Charge',	'Admin',	'Privato',	NULL,	'02-3798052-4',	'21-025299637-5',	'1211-3714-1363',	21600.00,	4800.00,	NULL,	NULL,	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180097',	'De Pano',	'Giancarlo Michele',	'Mendoza',	'Operation',	'Project in Charge',	'Admin',	'Privato',	'',	'02-4039702-3',	'',	'1211-8130-8417',	12000.00,	7000.00,	'',	'',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180098',	'Cabantac',	'Julious',	'Montoya',	'Operation',	'QA/QC Engineer',	'Admin',	'Privato',	'303-771-856-000',	'33-9032929-4',	'01-050339626-8',	'',	35000.00,	0.00,	'',	'',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180099',	'Toledo',	'Jeniffer',	'Laban',	'Operation',	'QS Engineer',	'Admin',	'Privato',	'',	'02-3864356-9',	'05-025520699-8',	'1211-8543-5452',	12000.00,	7000.00,	'Jefferson  Toledo',	'0922-293-1292',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180100',	'Clariz',	'Mariah Camille',	'Salvador',	'Operation',	'MEPF Engineer',	'Admin',	'Privato',	'',	'34-6119106-3',	'14-251122896-3',	'1210-8720-2198',	16000.00,	0.00,	'Emily Gonzales',	'0939-352-6820',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180101',	'Manlulu',	'Rosie Marie',	'Roncal',	'Operation',	'Document Controller',	'Admin',	'Privato',	'',	'02-2637462-0',	'07-050751704-6',	'',	14400.00,	4000.00,	'Rodrigo Manlulu',	'0956-829-8930',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180102',	'Delos Angeles',	'Shiela Ruby',	'Maisano',	'Operation',	'Timekeeper',	'Admin',	'Privato',	'',	'',	'',	'',	10800.00,	2400.00,	'Rachelle Gragasin',	'',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180103',	'Alcala',	'Robert Anthony',	'Portugal',	'Operation',	'Safety Officer',	'Admin',	'Privato',	'326-195-291-000',	'05-0949673-3',	'01-025852829-3',	'9152-7433-4016',	12000.00,	6000.00,	'Desiree Ann Alcala',	'0928-256-2522',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180104',	'Santos',	'Potenciano',	'Cordero',	'Operation',	'Utility',	'Admin',	'Privato',	'',	'',	'',	'',	10800.00,	1200.00,	'Juvilyn Dechosa',	'0910-918-4345',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180105',	'Naranja',	'Vilbert',	'Nivera',	'Operation',	'Surveyor',	'Admin',	'Privato',	'',	'02-3360860-6',	'05-200992061-7',	'',	16800.00,	0.00,	'Vhrint Jay Naranja',	'0995-335-4890',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180106',	'Naranja',	'Khristian Paul',	'Manuel',	'Operation',	'Survey Aide',	'Admin',	'Privato',	'',	'02-3453408-3',	'07-050859243-2',	'',	13200.00,	0.00,	'Gemma Naranja',	'0994-501-0474',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180107',	'Mahinal',	'Kim Anthony',	'Manzano',	'Operation',	'Site Nurse',	'Admin',	'Privato',	'',	'07-2840767-1',	'',	'1105-0672-0060',	12000.00,	2000.00,	'Albert Sajonia',	'0909-058-1170',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180108',	'Hapa',	'Noli',	'Miranda',	'Operation',	'Warehouseman',	'Admin',	'Privato',	'',	'03-6891175-0',	'',	'',	13200.00,	1200.00,	'Julius Sadaya',	'0932-560-3769',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180109',	'Moreno',	'Roel',	'Bernabe',	'Operation',	'Survey Aide',	'Admin',	'Privato',	'',	'',	'07-201448143-6',	'',	12000.00,	2400.00,	'Geraldine Moreno',	'0938-552-8990',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180110',	'Dunan',	'Jennifer',	'Lagsic',	'Operation',	'Site Engineer',	'Admin',	'Sky Bravo',	'',	'04-3796482-9',	'08-025082545-9',	'9161-8934-8161',	16800.00,	9000.00,	'Ramon Santos',	'0977-734-5617',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180111',	'Culala Jr.',	'Juan',	'Santiago',	'Operation',	'Warehouseman',	'Admin',	'Trees Residences',	NULL,	'02-1458944-3',	'01-025109935-4',	'1211-9436-4382',	NULL,	NULL,	NULL,	NULL,	'No',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180112',	'Mendoza',	'Donnabelle',	'Camiguing',	'Operation',	'Site Engineer',	'Admin',	'Sky Bravo',	'',	'34-6913675-8',	'03-026161213-1',	'',	12000.00,	9000.00,	'Annabelle Mendoza',	'0948-250-6208',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180113',	'Olea',	'Cristopher',	'Pauig',	'Operation',	'Site Engineer',	'Admin',	'Sky Bravo',	'',	'01-2729725-9',	'06-025325388-9',	'',	12000.00,	9000.00,	'Ruel Olea',	'0997-551-4769',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180114',	'De Leon',	'Robinson',	'Delos Reyes',	'Operation',	'CAD Operator',	'Admin',	'Sky Bravo',	'',	'01-115415478-8',	'',	'',	12000.00,	4000.00,	'Erlinda De Leon',	'0917-657-3986',	'Yes',	'Yes',	'',	'2018-02-05',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180115',	'Bataller',	'Lilian',	'Torzar',	'Operation',	'Document Controller',	'Admin',	'Sky Bravo',	'',	'33-6432277-7',	'01-502030432-7',	'1010-0014-1983',	12000.00,	3600.00,	'Leizel Torzar',	'0956-477-3411',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180116',	'Macasaol',	'Rudy',	'Cuajotor',	'Operation',	'General Foreman',	'Admin',	'Sky Bravo',	'',	'',	'',	'',	16800.00,	4800.00,	'Mailyn Bacor',	'0999-194-6963',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180117',	'Chua',	'Joseph Anthony',	'Nebres',	'Operation',	'Project in Charge',	'Admin',	'Aurora Suites - Subic',	NULL,	'01-1963387-6',	'05-025215913-1',	'1210-8618-7100',	NULL,	NULL,	'NESTOR CHUA ',	'0905-3691925',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180118',	'Bernal',	'Ana Marie',	'Sanchez',	'Operation',	'Office/Site Engineer',	'Admin',	'Aurora Suites - Subic',	NULL,	'02-3332072-2',	'07-025658190-4',	'1211-5991-3437',	NULL,	NULL,	'NORY BERNAL',	'0999-9079103',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180119',	'Esteban',	'Jheeno',	'Malonzo',	'Operation',	'Safety Officer',	'Admin',	'Aurora Suites - Subic',	'',	'02-2714402-4',	'02-025433425-2',	'1210-1091-1789',	0.00,	0.00,	'ROSIELYN ESTEBAN',	'0906-8077918',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180120',	'Dela Cruz',	'Rowell',	'Desosa',	'Operation',	'Site First Aider',	'Admin',	'Aurora Suites - Subic',	NULL,	'02-2766522-8',	'07-025588467-9',	'1212-0276-7574',	NULL,	NULL,	'MARIA LOURDES DELA CRUZ ',	'0995-3748858',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180121',	'Lucagbo',	'Mike Anthony',	'Oblina',	'Operation',	'Surveyor',	'Admin',	'Aurora Suites - Subic',	NULL,	'08-1415822-9',	'03-025586879-5',	'1211-1615-2188',	NULL,	NULL,	'JOAN LUCAGBO ',	'0935-2214221',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180122',	'Lendio',	'Franz Darryl',	'Ramos',	'Operation',	'Timekeeper',	'Admin',	'Aurora Suites - Subic',	NULL,	'04-2617818-9',	'22-000172375-8',	'1201-0805-1152',	NULL,	NULL,	'RAQUEL LENDIO ',	'0946-8831786',	'Yes',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180123',	'Valerio',	'Conrado',	'Nerit',	'Operation',	'Liason Officer',	'Admin',	'Aurora Suites - Subic',	'',	'03-3122296-8',	'07-175203828-1',	'',	0.00,	0.00,	'Norma Valerio',	'0929-7016678',	'Yes',	'Yes',	'',	'',	'',	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'Yes',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
  ('20180124',	'Rivera',	'Henricson',	'Palomaria',	'Operation',	'Operator',	'Admin',	'Aurora Suites - Subic',	NULL,	'07-2316702-6',	'11-050298658-9',	NULL,	NULL,	NULL,	'REGINA DUMILI ',	'0921-6295038',	'No',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	'Yes',	'',	0,	0,	'',	'No',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL);
  
  DROP TABLE IF EXISTS `employmentcategory`;
  CREATE TABLE `employmentcategory` (
    `categorytitle` varchar(15) NOT NULL,
    PRIMARY KEY (`categorytitle`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `employmentcategory` (`categorytitle`) VALUES
  ('Admin'),
  ('Direct Labor'),
  ('Subcon');
  
  DROP TABLE IF EXISTS `groupname`;
  CREATE TABLE `groupname` (
    `grouptitle` varchar(40) NOT NULL,
    `active` varchar(3) NOT NULL DEFAULT 'Yes',
    PRIMARY KEY (`grouptitle`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `groupname` (`grouptitle`, `active`) VALUES
  ('Accounting',	'Yes'),
  ('Engineering',	'Yes'),
  ('Human Resource',	'Yes'),
  ('Information Technology',	'Yes'),
  ('Labor',	'Yes'),
  ('Logistics',	'Yes'),
  ('Maintenance',	'Yes'),
  ('Management',	'Yes'),
  ('Operation',	'Yes'),
  ('Purchasing',	'Yes'),
  ('Sales',	'Yes'),
  ('Security',	'Yes');
  
  DROP TABLE IF EXISTS `logs`;
  CREATE TABLE `logs` (
    `log_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `logdate` varchar(10) NOT NULL,
    `logtime` varchar(20) NOT NULL,
    `logtimeUnix` varchar(20) NOT NULL,
    `scancode` varchar(15) NOT NULL,
    `logtype` varchar(10) NOT NULL,
    `firstname` varchar(20) NOT NULL,
    `lastname` varchar(20) NOT NULL,
    `messagestatus` text NOT NULL,
    PRIMARY KEY (`log_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `logs` (`log_id`, `logdate`, `logtime`, `logtimeUnix`, `scancode`, `logtype`, `firstname`, `lastname`, `messagestatus`) VALUES
  (1,	'2018-03-01',	'2018-03-01 02:58 PM',	'1519887480',	'20180011',	'RTIN',	'Cristan',	'Kabigting',	'<li class=\"media\"><img class=\"media-object\" src=\"assets/photos/20180011.jpg\" alt=\"...\"><div class=\"media-body\"><h4 class=\"media-heading\">Cristan Kabigting</h4><div class=\"media-heading-sub\">Head Office - System Developer</div><div class=\"media-heading-small\"> Regular Time Log IN 2018-03-01 02:58 PM</div></div></li>');
  
  DROP TABLE IF EXISTS `manual_adjustment`;
  CREATE TABLE `manual_adjustment` (
    `adjustmentid` bigint(20) NOT NULL AUTO_INCREMENT,
    `project` varchar(40) DEFAULT NULL,
    `employeecode` varchar(15) DEFAULT NULL,
    `employeefirst` varchar(20) DEFAULT NULL,
    `employeelast` varchar(20) DEFAULT NULL,
    `periodstart` varchar(10) DEFAULT NULL,
    `periodend` varchar(10) DEFAULT NULL,
    `adjustmentcode` varchar(10) DEFAULT NULL,
    `particular` varchar(120) DEFAULT NULL,
    `comment` varchar(60) DEFAULT NULL,
    `hourlyrate` varchar(10) DEFAULT NULL,
    `adjustmentfactor` varchar(10) DEFAULT NULL,
    `adjustmentrate` varchar(10) DEFAULT NULL,
    `hours` varchar(10) DEFAULT NULL,
    `income` varchar(10) DEFAULT NULL,
    `deduction` varchar(10) DEFAULT NULL,
    `deleted` varchar(3) NOT NULL DEFAULT 'No',
    `summarized` varchar(3) NOT NULL DEFAULT 'No',
    `logid` text,
    PRIMARY KEY (`adjustmentid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `manual_adjustment` (`adjustmentid`, `project`, `employeecode`, `employeefirst`, `employeelast`, `periodstart`, `periodend`, `adjustmentcode`, `particular`, `comment`, `hourlyrate`, `adjustmentfactor`, `adjustmentrate`, `hours`, `income`, `deduction`, `deleted`, `summarized`, `logid`) VALUES
  (1,	'Head Office',	'20180011',	'Cristan',	'Kabigting',	'2018-02-28',	'2018-03-06',	'RGRT',	'Regular Work Regular Time',	'Basic Salary for the whole week',	'109.375',	'1',	'109.375',	'48',	'5250',	NULL,	'No',	'No',	NULL);
  
  DROP TABLE IF EXISTS `manual_log`;
  CREATE TABLE `manual_log` (
    `logid` bigint(20) NOT NULL AUTO_INCREMENT,
    `employeecode` varchar(15) DEFAULT NULL,
    `periodstart` varchar(10) DEFAULT NULL,
    `periodend` varchar(10) DEFAULT NULL,
    `logdate` varchar(10) DEFAULT NULL,
    `login` varchar(20) DEFAULT NULL,
    `logout` varchar(20) DEFAULT NULL,
    `logtype` varchar(4) DEFAULT NULL,
    `particular` varchar(60) DEFAULT NULL,
    `processed` varchar(3) DEFAULT 'No',
    PRIMARY KEY (`logid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `manual_log` (`logid`, `employeecode`, `periodstart`, `periodend`, `logdate`, `login`, `logout`, `logtype`, `particular`, `processed`) VALUES
  (1,	'20180011',	'2018-02-28',	'2018-03-06',	'2018-03-01',	'2018-03-01 08:00 AM',	'2018-03-01 07:00 PM',	'RGRT',	'Regular Work Regular Time',	'Yes');
  
  DROP TABLE IF EXISTS `payrollsummary`;
  CREATE TABLE `payrollsummary` (
    `summaryid` bigint(20) NOT NULL AUTO_INCREMENT,
    `project` varchar(40) DEFAULT NULL,
    `employeecode` varchar(15) DEFAULT NULL,
    `employeefirst` varchar(20) DEFAULT NULL,
    `employeelast` varchar(20) DEFAULT NULL,
    `periodstart` varchar(10) DEFAULT NULL,
    `periodend` varchar(10) DEFAULT NULL,
    `income` decimal(10,2) DEFAULT NULL,
    `deduction` decimal(10,2) DEFAULT NULL,
    `rgrt` decimal(10,2) DEFAULT NULL,
    `rdrt` decimal(10,2) DEFAULT NULL,
    `lhrt` decimal(10,2) DEFAULT NULL,
    `shrt` decimal(10,2) DEFAULT NULL,
    `lrrt` decimal(10,2) DEFAULT NULL,
    `srrt` decimal(10,2) DEFAULT NULL,
    `rgot` decimal(10,2) DEFAULT NULL,
    `rdot` decimal(10,2) DEFAULT NULL,
    `lhot` decimal(10,2) DEFAULT NULL,
    `shot` decimal(10,2) DEFAULT NULL,
    `lrot` decimal(10,2) DEFAULT NULL,
    `srot` decimal(10,2) DEFAULT NULL,
    `dall` decimal(10,2) DEFAULT NULL,
    `fall` decimal(10,2) DEFAULT NULL,
    `bons` decimal(10,2) DEFAULT NULL,
    `incs` decimal(10,2) DEFAULT NULL,
    `m13f` decimal(10,2) DEFAULT NULL,
    `m13p` decimal(10,2) DEFAULT NULL,
    `sssc` decimal(10,2) DEFAULT NULL,
    `phic` decimal(10,2) DEFAULT NULL,
    `hdmf` decimal(10,2) DEFAULT NULL,
    `csad` decimal(10,2) DEFAULT NULL,
    `lded` decimal(10,2) DEFAULT NULL,
    `uded` decimal(10,2) DEFAULT NULL,
    PRIMARY KEY (`summaryid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  DROP TABLE IF EXISTS `payroll_input`;
  CREATE TABLE `payroll_input` (
    `periodstart` varchar(10) DEFAULT NULL,
    `periodend` varchar(10) DEFAULT NULL,
    `dummytext1` char(1) DEFAULT NULL,
    `employeecode` varchar(15) DEFAULT NULL,
    `project` varchar(40) DEFAULT NULL,
    `firstname` varchar(20) DEFAULT NULL,
    `lastname` varchar(20) DEFAULT NULL,
    `allowance_type` varchar(10) DEFAULT NULL,
    `dummytext2` char(1) DEFAULT NULL,
    `daily_allowance_day` varchar(5) DEFAULT NULL,
    `regular_day_work_day` varchar(10) DEFAULT NULL,
    `special_holiday_work_day` varchar(10) DEFAULT NULL,
    `legal_holiday_work_day` varchar(10) DEFAULT NULL,
    `restday_work_day` varchar(10) DEFAULT NULL,
    `special_restday_work_day` varchar(10) DEFAULT NULL,
    `legal_restday_work_day` varchar(10) DEFAULT NULL,
    `dummytext3` char(1) DEFAULT NULL,
    `paid_leave_day` varchar(10) DEFAULT NULL,
    `paid_holiday_day` varchar(10) DEFAULT NULL,
    `unpaid_absent_day` varchar(10) DEFAULT NULL,
    `dummytext4` char(1) DEFAULT NULL,
    `total_overtime` varchar(10) DEFAULT NULL,
    `regular_overtime` varchar(10) DEFAULT NULL,
    `restday_overtime` varchar(10) DEFAULT NULL,
    `special_holiday_overtime` varchar(10) DEFAULT NULL,
    `legal_holiday_overtime` varchar(10) DEFAULT NULL,
    `special_restday_overtime` varchar(10) DEFAULT NULL,
    `legal_restday_overtime` varchar(10) DEFAULT NULL,
    `dummytext5` char(1) DEFAULT NULL,
    `bonus_amount` varchar(10) DEFAULT NULL,
    `incentives_amount` varchar(10) DEFAULT NULL,
    `tm_amount` varchar(10) DEFAULT NULL,
    `dummytext6` char(1) DEFAULT NULL,
    `sss_amount` varchar(10) DEFAULT NULL,
    `phic_amount` varchar(10) DEFAULT NULL,
    `hdmf_amount` varchar(10) DEFAULT NULL,
    `dummytext7` char(1) DEFAULT NULL,
    `cash_advance_amount` varchar(10) DEFAULT NULL,
    `late_hours` varchar(10) DEFAULT NULL,
    `undertime_hours` varchar(10) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  DROP TABLE IF EXISTS `project`;
  CREATE TABLE `project` (
    `projecttitle` varchar(40) NOT NULL,
    `active` varchar(3) NOT NULL DEFAULT 'Yes',
    PRIMARY KEY (`projecttitle`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `project` (`projecttitle`, `active`) VALUES
  ('Aurora Suites - Subic',	'Yes'),
  ('Fields Residence',	'Yes'),
  ('Head Office',	'Yes'),
  ('Jupiter & Mars',	'Yes'),
  ('MDC-Arca South',	'Yes'),
  ('Mix Plant',	'Yes'),
  ('Petron - Intramuros',	'Yes'),
  ('Privato',	'Yes'),
  ('Sky Bravo',	'Yes'),
  ('Sun Valley',	'Yes'),
  ('Trees Residences',	'Yes'),
  ('Villa Maintenance',	'Yes'),
  ('Voyager',	'Yes');
  
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE `users` (
    `username` varchar(20) NOT NULL,
    `password` varchar(20) NOT NULL,
    `authorized` int(1) NOT NULL,
    `project` varchar(40) NOT NULL,
    `usertype` varchar(40) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `users` (`username`, `password`, `authorized`, `project`, `usertype`) VALUES
  ('admin',	'server0207',	1,	'Head Office',	'Payroll'),
  ('approver',	'GD3BATIE',	1,	'Head Office',	'Approver'),
  ('payroll',	'QKKZRSPQ',	1,	'Head Office',	'Payroll'),
  ('headoffice',	'1234567',	1,	'Head Office',	'Timekeeper'),
  ('jupiter',	'TYB1ZNUL',	1,	'Jupiter & Mars',	'Timekeeper'),
  ('privato',	'RYQHH1VI',	1,	'Privato',	'Timekeeper'),
  ('mixplant',	'EHKN3GYY',	1,	'Mix Plant',	'Timekeeper'),
  ('petroninramuros',	'QOO1H9FW',	1,	'Petron - Intramuros',	'Timekeeper'),
  ('voyager',	'XV5K4458',	1,	'Voyager',	'Timekeeper'),
  ('mdcarca',	'BE5DUVO2',	1,	'MDC-Arca South',	'Timekeeper'),
  ('aurorasuites',	'2AGOX1AD',	1,	'Aurora Suites - Subic',	'Timekeeper'),
  ('skybravo',	'CF5B9DNL',	1,	'Sky Bravo',	'Timekeeper'),
  ('sunvalley',	'IB0BTKW6',	1,	'Sun Valley',	'Timekeeper'),
  ('fieldsresidence',	'FIZ28UPJ',	1,	'Fields Residence',	'Timekeeper'),
  ('treesresidences',	'RWQMPVS6',	1,	'Trees Residences',	'Timekeeper');
  
  -- 2018-03-02 09:20:43
  