Feb 07, 2024, 07:26 PM
14k entries
columns:
sample:
columns:
INSERT INTO `user_information` (`user_id`, `department`, `role_id`, `full_name`, `last_name`, `first_name`, `middle_name`, `suffix`, `phone_name`, `nick_name`, `maiden_name`, `telephone_number`, `mobile_number`, `personal_email`, `registered_address`, `province`, `barangay_address`, `city_municipality_address`, `province_address`, `mailing_address`, `religion`, `zip_code`, `birth_date`, `place_of_birth`, `gender`, `marital_status`, `blood_type`, `citizenship`, `tax_code`, `sss`, `phic`, `tin`, `hdmf`, `pag_ibig`, `spouse_last_name`, `spouse_first_name`, `spouse_middle_name`, `emergency_contact_relationship`, `emergency_contact_address`, `emergency_contact_name`, `emergency_contact_number`, `spouse_suffix`, `mother_maiden_name`, `previous_employer`, `father_name`, `date_ended`, `address`, `employment_number`, `date_started`, `date_start`, `client_started`, `date_hired`, `employment_type`, `contract_period`, `contract_period_start`, `contract_period_end`, `email`, `facebook_url`, `branch_site`, `department_id`, `immediate_superior`, `position`, `salary_type`, `payreg_names`, `bank_account_number`, `status`, `password`, `remarks`, `first_password`, `contract_type`, `track_late`, `flexi`, `schedule_type`, `allow_remote_time_in`, `last_modified`, `active_timetracker`, `tax_status`, `company_id`, `tier`, `newsfeed_access`, `profile_picture`, `lastpay`, `referral_id`, `is_signing_bonus_eligible`, `signing_bonus_amount`, `signature`, `firebase_token`) VALUESsample:
(7007, NULL, 5, 'Sarsalejo, Allen Marie S. ', 'Sarsalejo', 'Allen Marie', 'Sagarino', '', '', '', '', '', '9156878720', '', 'Prk 28 In front of Star Oil Sila Maa Davao City', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '06/28/1999', NULL, '2', 1, '1', '62', NULL, '', '16-252925264-1', '445-639-060', '', NULL, '', '', '', '1', '', '', '', '', '', '', '', '2019-07-06', '', 7917, '10/08/2018', '2018-10-08', NULL, NULL, '1', NULL, '', '', '[email protected]', '', 6, 168, 0, '118', '', '', '109653113122', '0', NULL, NULL, 'SjZIVJ0zjl', NULL, 1, 0, 1, 0, '2020-03-13 15:33:21', 1, 'S/M', 2, 0, 5, 'default.png', 0, NULL, NULL, NULL, NULL, NULL),
(7008, NULL, 5, 'Amamio, Maria Angeli D. ', 'Amamio', 'Maria Angeli', 'De Los Reyes', '', '', '', '', '', '9184938512', '', '10 Durian St Nova Tierra Vill Lanang Davao City', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '10/19/1994', NULL, '2', 1, '1', '62', NULL, '34-4814192-6', '03-051217124-5', '319-859-453', '1211-3007-5049', NULL, '', '', '', '3', '#10 Durian St., Nova Tierra Village, Lanang, Davao City 8000', 'Dina de los Reyes', '09174804600', '', '', '', '', '2021-03-27', '', 7903, '10/08/2018', '2018-10-08', NULL, NULL, '1', NULL, '', '', '[email protected]', '', 6, 168, 0, '54', '', '', '109653112944', '0', NULL, NULL, '5jxFLMRh5T', NULL, 1, 0, 1, 0, '2021-03-25 04:52:12', 1, 'S/M', 2, 0, 5, 'MariaAngeliAmamio.jpg', 0, NULL, NULL, NULL, NULL, NULL),
(7009, NULL, 5, 'Reyataza, Phoebe Sittie Zaira P. ', 'Reyataza', 'Phoebe Sittie Zaira', 'Pangato', '', '', '', '', '', '9494434696', '', 'Ph1 Prk4 San Jose Avenue Dona Asuncion Village Pampanga Davao City', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '02/10/1998', NULL, '2', 1, '1', '62', NULL, '09-4203244-0', '16-050741234-0', '335-162-195', '1211-9229-7840', NULL, '', '', '', '7', 'PH1 PRK4 San Jose Avenue, Dona Asuncion Vill. Pampanga, Davao City', 'Delia R. Into', '09209587853', '', '', '', '', NULL, '', 7913, '10/08/2018', '2018-10-08', NULL, NULL, '1', NULL, '', '', '[email protected]', '', 6, 72, 0, '326', '', '', '109653113109', '1', NULL, NULL, '0eXUV2BMZD', NULL, 1, 0, 1, 1, '2022-03-07 07:02:18', 1, 'S/M', 2, 0, 5, 'default.png', 0, NULL, NULL, NULL, NULL, NULL),
(7010, 'Back Office', 5, 'Deiparine, Jebie F. ', 'Deiparine', 'Jebie', 'Formentera', '', '', '', '', '', '9997222342', '', 'St Jude Village daliao Toril Davao City', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '03/12/1996', NULL, '1', 1, '1', '62', NULL, '09-3731034-2', '16-050608087-5', '317-055-952', '1211-1435-2545', NULL, '', '', '', '3', 'ST. JUDE VILLAGE, DALIAO, TORIL, DAVAO CITY', 'MERLITA F. DEIPARINE', '291-2438', '', '', '', '', '2020-03-12', '', 7906, '10/08/2018', '2018-10-08', NULL, NULL, '1', NULL, '', '', '[email protected]', '', 6, 168, 0, '223', '', '', '109652882158', '0', NULL, NULL, '3D4sVf9wT9', NULL, 1, 0, 1, 0, '2020-04-26 06:46:34', 1, 'S/M', 2, 0, 5, 'JebieDeiparine.JPEG', 0, NULL, NULL, NULL, NULL, NULL),
(7011, NULL, 5, 'Royo, Casandra Mae B. ', 'Royo', 'Casandra Mae', 'Bacolbas', '', '', '', '', '', '9473296650', '', 'Prk 14 Panacan Relocation Davao City', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '05/02/1995', NULL, '2', 1, '1', '62', NULL, '09-3478662-3', '16-050532749-4', '329-564-000\r\n', '', NULL, '', '', '', '3', 'A touch of Class Salon, Magallanes St. Davao City', 'SONIA B. ROYO', '09658872178', '', '', '', '', NULL, '', 7914, '10/08/2018', '2018-10-08', NULL, NULL, '1', NULL, '', '', '[email protected]', '', 6, 174, 0, '124', '', '', '109653339598', '1', NULL, NULL, '3Knxtq7QZt', NULL, 0, 0, 1, 1, '2021-04-24 05:53:52', 1, 'S/M', 2, 0, 5, 'CasandraMaeRoyo.jpg', 0, NULL, NULL, NULL, NULL, NULL),
(7012, NULL, 5, 'Bangaysiso, Jenny Lyn S. ', 'Bangaysiso', 'Jenny Lyn', 'Sangkula', '', '', '', '', '', '', '', '739-2 Tionko Avenue Davao City', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1985-10-26', NULL, '1', 2, '1', '62', NULL, '09-3021905-5', '16-050344886-3', '950-022-172', '1210-5974-2441', NULL, '', '', '', '43', 'Brgy Sinunuc, Zamboanga City.', 'Gerwin Bangaysiso', '09658145341', '', '', '', '', NULL, '', 7871, '09/28/2018', '2018-09-28', '2018-09-17', NULL, '1', NULL, '', '', '[email protected]', '', 6, 162, 0, '154', '', '', '109653784417', '1', NULL, NULL, 'rwbuyS5alw', NULL, 1, 0, 1, 1, '2020-05-19 22:37:09', 1, 'S/M', 2, 2, 5, 'JennBangaysiso.jpg', 0, NULL, NULL, NULL, NULL, NULL),
(7013, NULL, 5, 'Basanez, Cristine Jee T. ', 'Basanez', 'Cristine Jee', 'Toledo', '', '', '', '', '', '9099845526', '', 'Km5 Guadalupe Village Galay Comp Brgy 74A Matina Crossing Davao City', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '01/10/1993', NULL, '2', 2, '1', '62', NULL, '09-3656382-8', '16-025594180-9', '315-371-203', '1211-0162-3287', NULL, '', '', '', '1', '', '', '', '', '', '', '', '2020-01-01', '', 7890, '10/01/2018', '2018-10-01', NULL, NULL, '1', NULL, '', '', '[email protected]', '', 3, 169, 0, '176', '', '', '109653340023', '0', NULL, NULL, 'aH1QiJ4kQJ', NULL, 1, 0, 1, 0, '2020-01-03 02:01:20', 1, 'S/M', 1, 0, 5, 'cristinejeebasanez.jpg', 0, NULL, NULL, NULL, NULL, NULL),
(7014, NULL, 5, 'Alves, Allen Jason T. ', 'Alves', 'Allen Jason', 'Tan', '', '', '', '', '', '9398195280', '', 'Ph. 3 Blk. 75 Lt. 16 Everlasting St. Deca Homes Indangan, Davao City, Davao Del Sur, Philippines', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1990-11-06', NULL, '1', 2, '1', '62', NULL, '34-7850881-4', '16-050781527-5', '727-080-483', '1212-3374-6233', NULL, '', '', '', '43', 'Ph. 3 Blk. 75 Lt. 16 Everlasting St. Deca Homes Indangan, Davao City, Davao Del Sur, Philippines ', 'Blendz B. Llanto', '09504837728', '', '', '', '', '2021-11-02', '', 7843, '10/08/2018', '2018-10-08', NULL, NULL, '1', NULL, '', '', '[email protected]', '', 4, 169, 0, '202', '', '', '109652882067', '0', NULL, NULL, 'FlXMjuo2au', NULL, 0, 0, 1, 0, '2021-11-26 09:28:15', 1, 'S/M', 1, 0, 5, 'default.png', 0, NULL, NULL, NULL, NULL, NULL),
(7015, NULL, 5, 'Idris, Datu Marjuk Vito Hashemi ', 'Idris', 'Datu Marjuk Vito Hashemi', '', '', '', '', '', '', '9192101422', '', 'B5 L9and 12 8Th Avenue Fortune Exec HOmes Lanang Davao City', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1989-10-31', NULL, '1', 1, '1', '62', NULL, '09-3490744-4', '17-025418877-0', '320-724-841', '1211-3656-6508', NULL, '', '', '', '1', '', '', '', '', '', '', '', '2019-11-14', '', 7995, '10/09/2018', '2018-10-09', NULL, NULL, '1', NULL, '', '', '[email protected]', '', 6, 168, 0, '118', '', '', '109653113031', '8', NULL, NULL, 'OWI1fPlLtC', NULL, 1, 0, 1, 0, '2019-11-21 05:23:55', 1, 'S/M', 2, 0, 5, 'default.png', 0, NULL, NULL, NULL, NULL, NULL),
(7016, NULL, 5, 'Lomantas, Miguel Paulo G. ', 'Lomantas', 'Miguel Paulo', 'Galleros', '', '', '', '', '', '9104730605', '', 'B6 L19 Mt Parker St Dinnaville Subd Maa Davao City', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '05/16/1995', NULL, '1', 1, '1', '62', NULL, '', '16-250431795-1', '327-787-345', '', NULL, '', '', '', '1', '', '', '', '', '', '', '', NULL, '', 7996, '10/08/2018', '2018-10-08', NULL, NULL, '1', NULL, '', '', '[email protected]', '', 4, 164, 0, '191', '', '', '109653171766', '1', NULL, NULL, 'cfwOzgVJXG', NULL, 1, 0, 1, 1, '2021-11-03 17:17:44', 1, 'S/M', 1, 0, 5, 'default.png', 0, NULL, NULL, NULL, NULL, NULL),




