-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `spcf`
--

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

--
-- Table structure for table `sp_holidays`
--

CREATE TABLE `sp_holidays` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `days` varchar(20) NOT NULL,
  `name` varchar(200) NOT NULL,
  `type` varchar(200) NOT NULL,
  `details` varchar(200) NOT NULL,
  `added_by` varchar(50) NOT NULL,
  `updated_by` varchar(50) NOT NULL,
  `date_created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `remarks` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sp_holidays`
--

INSERT INTO `sp_holidays` (`id`, `date`, `days`, `name`, `type`, `details`, `added_by`, `updated_by`, `date_created`, `remarks`) VALUES
(1, '2019-11-01', 'Fri', 'All Saints\' Day', 'Holiday', 'All Saints\' Day', 'Jobert Bombay', '', '2019-11-05 18:57:32', ''),
(2, '2019-11-30', 'Sat', 'Bonifacio Day', 'Holiday', 'Bonifacio Day', 'Jobert Bombay', '', '2019-11-05 18:57:18', ''),
(3, '2019-11-02', 'Sat', 'All Saints\' Day Holiday', 'Holiday', 'All Saints\' Day Holiday', 'Jobert Bombay', '', '2019-11-05 18:57:42', ''),
(4, '2019-12-24', 'Tue', 'Christmas Holiday', 'Holiday', 'Christmas Holiday', 'Jobert Bombay', '', '2019-11-05 18:57:52', ''),
(5, '2019-12-25', 'Wed', 'Christmas Day', 'Holiday', 'Christmas Day', 'Jobert Bombay', '', '2019-11-05 18:56:59', ''),
(6, '2019-12-30', 'Mon', 'Rizal Day', 'Holiday', 'Rizal Day', 'Jobert Bombay', '', '2019-11-05 18:49:33', ''),
(7, '2019-12-31', 'Tue', 'New Year\'s Eve', 'Holiday', 'New Year\'s Eve', 'Jobert Bombay', '', '2019-11-05 18:49:33', ''),
(9, '2020-01-01', 'Wed', 'New Year\'s Day', 'Holiday', 'New Year\'s Day', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(10, '2020-01-25', 'Sat', 'Chinese New Year', 'Holiday', 'Chinese New Year', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(11, '2020-02-25', 'Tue', 'Edsa Anniversary', 'Holiday', 'Edsa Anniversary', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(12, '2020-04-09', 'Thu', 'Maundy Thursday', 'Holiday', 'Maundy Thursday', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(13, '2020-04-10', 'Fri', 'Good Friday', 'Holiday', 'Good Friday', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(14, '2020-04-11', 'Sat', 'Black Saturday', 'Holiday', 'Black Saturday', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(15, '2020-05-01', 'Fri', 'Labor Day', 'Holiday', 'Labor Day', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(16, '2020-06-12', 'Fri', 'Independence Day', 'Holiday', 'Independence Day', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(17, '2020-08-21', 'Fri', 'Ninoy Aquino Day', 'Holiday', 'Ninoy Aquino Day', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(18, '2020-08-31', 'Mon', 'National Heroes Day', 'Holiday', 'National Heroes Day', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(19, '2020-11-01', 'Sun', 'All Saints Day', 'Holiday', 'All Saints Day', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(20, '2020-11-02', 'Sun', 'All Souls Day', 'Holiday', 'All Souls Day', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(21, '2020-11-30', 'Sun', 'Bonifacio Day', 'Holiday', 'Bonifacio Day', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(22, '2020-12-08', 'Tue', 'Immaculate Conception', 'Holiday', 'Immaculate Conception', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(23, '2020-12-24', 'Thu', 'Christmas Eve', 'Holiday', 'Christmas Eve', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(24, '2020-12-25', 'Fri', 'Christmas Day', 'Holiday', 'Christmas Day', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(25, '2020-12-30', 'Fri', 'Rizal Day', 'Holiday', 'Rizal Day', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(26, '2020-12-31', 'Thu', 'New Year\'s Eve', 'Holiday', 'New Year\'s Eve', 'Jobert Bombay', '', '2020-01-06 17:10:34', ''),
(27, '2020-09-06', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(28, '2020-09-13', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(29, '2020-09-20', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(30, '2020-09-27', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(31, '2020-10-04', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(32, '2020-10-11', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(33, '2020-10-18', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(34, '2020-10-25', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(35, '2020-11-01', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(36, '2020-11-08', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(37, '2020-11-15', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(38, '2020-11-22', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(39, '2020-11-29', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(40, '2020-12-06', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(41, '2020-12-13', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(42, '2020-12-20', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(43, '2020-12-27', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2020-09-27 17:10:34', ''),
(44, '2022-01-01', 'Sat', 'New Year\'s Day', 'Holiday', 'New Year\'s Day', 'Jobert Bombay', '', '2022-01-06 07:37:23', ''),
(45, '2022-01-02', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(46, '2022-01-09', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(47, '2022-01-16', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(48, '2022-01-23', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(49, '2022-01-30', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(50, '2022-02-01', 'Tue', 'Chinese New Year', 'Holiday', 'Chinese New Year', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(55, '2022-02-25', 'Fri', 'Edsa Anniversary', 'Holiday', 'Edsa Anniversary', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(56, '2022-02-06', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:40:50', ''),
(57, '2022-02-13', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(58, '2022-02-20', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(59, '2022-02-27', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(60, '2022-04-09', 'Sat', 'Day of Valor', 'Holiday', 'Day of Valor', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(61, '2022-04-14', 'Thu', 'Maundy Thursday', 'Holiday', 'Maundy Thursday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(62, '2022-04-15', 'Fri', 'Good Friday', 'Holiday', 'Good Friday', 'Jobert Bombay', '', '2022-01-06 07:43:44', ''),
(63, '2022-04-16', 'Sat', 'Black Saturday', 'Holiday', 'Black Saturday', 'Jobert Bombay', '', '2022-03-09 08:31:57', ''),
(64, '2022-03-06', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-03-09 08:26:29', ''),
(65, '2022-03-13', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-03-14 04:42:06', ''),
(66, '2022-04-17', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(67, '2022-04-24', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(68, '2022-05-01', 'Sun', 'Labor Day', 'Holiday', 'Labor Day', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(69, '2022-05-08', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(70, '2022-05-15', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(71, '2022-05-22', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(72, '2022-05-29', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(73, '2022-06-05', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(74, '2022-06-12', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(75, '2022-06-19', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(76, '2022-06-26', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(77, '2022-07-03', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(78, '2022-07-10', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(79, '2022-07-17', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(80, '2022-07-24', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(81, '2022-07-31', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(82, '2022-08-07', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(83, '2022-08-14', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(84, '2022-08-21', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(85, '2022-08-28', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(86, '2022-08-29', 'Mon', 'National Heroes Day', 'Holiday', 'National Heroes Day', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(87, '2022-09-04', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(88, '2022-09-11', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(89, '2022-09-18', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(90, '2022-09-25', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(91, '2022-10-02', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(92, '2022-10-09', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(93, '2022-10-16', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(94, '2022-10-23', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(95, '2022-10-30', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(96, '2022-11-01', 'Tue', 'All Saint\'s Day', 'Holiday', 'All Saint\'s Day', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(97, '2022-11-06', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(98, '2022-11-13', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(99, '2022-11-20', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(100, '2022-11-27', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(101, '2022-11-30', 'Sun', 'Bonifacio Day', 'Holiday', 'Bonifacio Day', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(102, '2022-12-08', 'Thu', 'Immaculate Conception', 'Holiday', 'Immaculate Conception', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(103, '2022-12-30', 'Fri', 'Rizal Day', 'Holiday', 'Rizal Day', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(104, '2022-12-25', 'Fri', 'Christmas Day', 'Holiday', 'Christmas Day', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(105, '2022-12-04', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(106, '2022-12-11', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(107, '2022-12-18', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(108, '2022-03-20', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-03-14 04:42:17', ''),
(109, '2022-03-27', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-03-09 08:26:29', ''),
(110, '2022-04-10', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(111, '2022-04-03', 'Sun', 'Sunday', 'Sunday', 'Sunday', 'Jobert Bombay', '', '2022-01-06 07:37:14', ''),
(112, '2022-04-21', 'Thu', 'YULO DAY', 'Holiday', 'YULO DAY', 'Marilyn Lacandazo', '', '2022-04-10 16:00:00', ''),
(113, '2022-04-09', 'Sat', 'Election Day', 'Holiday', 'Election Day', 'Joan Almoros', '', '2022-04-28 16:00:00', ''),
(114, '2022-04-03', 'Sun', 'Eidl Adha', 'Holiday', 'Eidl Adha', 'Joan Almoros', '', '2022-04-28 16:00:00', ''),
(115, '2022-07-09', 'Sat', 'Edil Fitr', 'Holiday', 'Edil Fitr', 'Joan Almoros', '', '2022-04-28 16:00:00', ''),
(116, '2022-07-24', 'Sun', 'sunday', 'Holiday', 'sunday', 'Marivic Nagpala', '', '2022-07-20 16:00:00', ''),
(117, '2022-07-31', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Joan Almoros', '', '2022-07-20 16:00:00', ''),
(118, '2022-09-24', 'Sat', 'YULO DAY', 'Holiday', 'YULO DAY', 'Marilyn Lacandazo', '', '2022-09-04 16:00:00', ''),
(119, '2022-10-31', 'Mon', 'SPECIAL NON WORKING HOLIDAY', 'Holiday', 'SPECIAL NON WORKING HOLIDAY', 'Marilyn Lacandazo', '', '2022-10-19 16:00:00', ''),
(120, '2022-11-26', 'Sat', 'Swap Holiday', 'Holiday', 'Swap Holiday', 'Marilyn Lacandazo', '', '2022-11-20 16:00:00', ''),
(121, '2022-12-26', 'Mon', 'SWAP HOLIDAY', 'Holiday', 'SWAP HOLIDAY', 'Marilyn Lacandazo', '', '2022-11-28 16:00:00', ''),
(122, '2023-01-01', 'Sun', 'NEW YEAR', 'Holiday', 'NEW YEAR', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(123, '2023-01-08', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(124, '2023-01-15', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(125, '2023-01-22', 'Sun', 'CHINESE NEW YEAR', 'Holiday', 'CHINESE NEW YEAR', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(126, '2023-01-29', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(127, '2023-02-05', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(128, '2023-02-12', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(129, '2023-02-19', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(130, '2023-02-25', 'Sat', 'PEOPLE POWER', 'Holiday', 'PEOPLE POWER', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(131, '2023-02-26', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(132, '2023-03-05', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(133, '2023-03-12', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(134, '2023-03-19', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(135, '2023-03-26', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(136, '2023-04-06', 'Thu', 'MAUNDY THURSDAY', 'Holiday', 'MAUNDY THURSDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(137, '2023-04-07', 'Fri', 'GOOD FRIDAY', 'Holiday', 'GOOD FRIDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(138, '2023-04-08', 'Sat', 'BLACK SATURDAY', 'Holiday', 'BLACK SATURDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(140, '2023-04-16', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(141, '2023-04-22', 'Sat', 'EIDULN FITAR', 'Holiday', 'EIDULN FITAR', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(142, '2023-04-23', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(143, '2023-04-30', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(144, '2023-05-01', 'Mon', 'LABOR DAY', 'Holiday', 'LABOR DAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(145, '2023-05-07', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(146, '2023-05-14', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(147, '2023-05-21', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(148, '2023-05-28', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(149, '2023-06-04', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(150, '2023-06-11', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(151, '2023-06-12', 'Mon', 'INDEPENDENCE DAY', 'Holiday', 'INDEPENDENCE DAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(152, '2023-06-18', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(154, '2023-06-19', 'Mon', 'RIZAL DAY', 'Holiday', 'RIZAL DAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(155, '2023-06-25', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(156, '2023-06-28', 'Wed', 'EID AL-ADHA', 'Holiday', 'EID AL-ADHA', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(157, '2023-07-02', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(158, '2023-07-09', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(159, '2023-07-16', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(160, '2023-07-23', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(161, '2023-07-30', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(162, '2023-08-06', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(163, '2023-08-13', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(164, '2023-08-20', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(165, '2023-08-21', 'Mon', 'NINOY AQUINO DAY', 'Holiday', 'NINOY AQUINO DAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(166, '2023-08-27', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(167, '2023-08-28', 'Mon', 'NATIONAL HEROES DAY', 'Holiday', 'NATIONAL HEROES DAY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(168, '2022-12-17', 'Sat', 'CHRISTMAS PARTY', 'Holiday', 'CHRISTMAS PARTY', 'Marilyn Lacandazo', '', '2022-12-06 16:00:00', ''),
(169, '2023-01-02', 'Mon', 'SPECIAL NON WORKING HOLIDAY', 'Holiday', 'SPECIAL NON WORKING HOLIDAY', 'Marilyn Lacandazo', '', '2022-12-13 16:00:00', ''),
(170, '2022-12-24', 'Sat', 'CHRISTMAS EVE', 'Holiday', 'CHRISTMAS EVE', 'Adrian Vergara', '', '2022-12-14 16:00:00', ''),
(171, '2022-12-31', 'Sat', 'COMPANY HOLIDAY', 'Holiday', 'COMPANY HOLIDAY', 'Marilyn Lacandazo', '', '2022-12-19 16:00:00', ''),
(172, '2023-09-03', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(173, '2023-09-10', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(174, '2023-09-17', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(175, '2023-09-24', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(176, '2023-10-01', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(177, '2023-10-08', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(178, '2023-10-15', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(179, '2023-10-22', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(180, '2023-10-29', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(181, '2023-11-05', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(182, '2023-11-12', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(184, '2023-11-19', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(185, '2023-11-26', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(186, '2023-11-30', 'Thu', 'BONIFACIO DAY', 'Holiday', 'BONIFACIO DAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(187, '2023-12-03', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(188, '2023-12-08', 'Fri', 'FEAST OF THE IMMACULATE', 'Holiday', 'FEAST OF THE IMMACULATE', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(189, '2023-12-10', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(190, '2023-12-17', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(191, '2023-12-24', 'Sun', 'CHRISTMAS EVE', 'Holiday', 'CHRISTMAS EVE', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(192, '2023-12-25', 'Mon', 'CHRISTMAS DAY', 'Holiday', 'CHRISTMAS DAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(193, '2023-12-30', 'Sat', 'RIZAL DAY', 'Holiday', 'RIZAL DAY', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(194, '2023-12-31', 'Sun', 'NEW YEARS EVE', 'Holiday', 'NEW YEARS EVE', 'Marilyn Lacandazo', '', '2023-01-02 16:00:00', ''),
(195, '2023-04-29', 'Sat', 'COMPANY OUTING', 'Holiday', 'COMPANY OUTING', 'Marilyn Lacandazo', '', '2023-03-14 16:00:00', ''),
(197, '2023-04-09', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-03-14 16:00:00', ''),
(198, '2023-04-02', 'Sun', 'SUNDAY', 'Sunday', 'SUNDAY', 'Marilyn Lacandazo', '', '2023-03-20 16:00:00', ''),
(200, '2023-04-10', 'Mon', 'valor day', 'Holiday', 'valor day', 'Marilyn Lacandazo', '', '2023-03-28 16:00:00', ''),
(201, '2023-04-21', 'Fri', 'CITY HOOD OF CALAMBA', 'Holiday', 'CITY HOOD OF CALAMBA', 'Marilyn Lacandazo', '', '2023-03-30 16:00:00', '');

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

--
-- Table structure for table `tbl_accexpense`
--

CREATE TABLE `tbl_accexpense` (
  `expense_id` int(3) NOT NULL,
  `ex_name` varchar(51) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_accexpense`
--

INSERT INTO `tbl_accexpense` (`expense_id`, `ex_name`) VALUES
(1, 'ACCOUNTS PAYABLE - DEFERRED TAX LIABILITY'),
(2, 'ACCOUNTS PAYABLE - DEPOSIT FROM CUSTOMERS'),
(3, 'ACCOUNTS PAYABLE - EMPLOYEES TRAVEL EXPENSE PAYABLE'),
(4, 'ACCOUNTS PAYABLE - EXPANDED WITHHOLDING TAX'),
(5, 'ACCOUNTS PAYABLE - FRINGE TAX PAYABLE'),
(6, 'ACCOUNTS PAYABLE - INSURANCE PAYABLE'),
(7, 'ACCOUNTS PAYABLE - MEDICARE PREMIUM PAYABLE'),
(8, 'ACCOUNTS PAYABLE - NON-TRADE'),
(9, 'ACCOUNTS PAYABLE - OTHERS'),
(10, 'ACCOUNTS PAYABLE - OUTPUT TAX'),
(11, 'ACCOUNTS PAYABLE - PAG-IBIG PREMIUM PAYABLE'),
(12, 'ACCOUNTS PAYABLE - PAG-IBIG SALARY LOAN PAYABLE'),
(13, 'ACCOUNTS PAYABLE - RETENTION PAYABLE'),
(14, 'ACCOUNTS PAYABLE - SAVINGS FUND PAYABLE'),
(15, 'ACCOUNTS PAYABLE - SSS SALARY LOAN PAYABLE'),
(16, 'ACCOUNTS PAYABLE - SSS/MED. PREMIUM PAYABLE'),
(17, 'ACCOUNTS PAYABLE - TRADE'),
(18, 'ACCOUNTS PAYABLE - WITHHOLDING TAX PAYABLE'),
(19, 'ACCOUNTS RECEIVABLE - CREDITABLE WITHOLDING TAX'),
(20, 'ACCOUNTS RECEIVABLE - OTHERS'),
(21, 'ACCOUNTS RECEIVABLE - SOCIAL SECURITY SYTEM'),
(22, 'ACCOUNTS RECEIVABLES - NON TRADE'),
(23, 'ACCOUNTS RECEIVABLES - TRADE'),
(24, 'ACCRUED EXPENSE'),
(25, 'ACCRUED EXPENSE - 13TH MONTH PAY'),
(26, 'ACCRUED INTEREST EXPENSE'),
(27, 'ACCRUED RENT EXPENSE'),
(28, 'ADVANCES FROM AFFILIATES'),
(29, 'ADVANCES FROM EMPLOYEES'),
(30, 'ADVANCES FROM OFFICERS'),
(31, 'ADVANCES FROM SUPPLIERS'),
(32, 'ADVANCES TO AFFILLIATE'),
(33, 'ADVANCES TO CUSTOMERS'),
(34, 'ADVANCES TO EMPLOYEES'),
(35, 'ADVANCES TO EMPLOYEES-OPERATIONS'),
(36, 'ADVANCES TO OFFICERS'),
(37, 'ADVANCES TO SUPPLIER'),
(38, 'ADVERTISING EXPENSE'),
(39, 'AMORT. OF OTHER ASSET'),
(40, 'BAD DEBTS EXPENSE'),
(41, 'BANK CHARGES'),
(42, 'BUILDING AND IMPROVEMENT'),
(43, 'CASH ON HAND'),
(44, 'CIB-RCBC CARMELRAY (PESO)'),
(45, 'COMMISSION EXPENSE'),
(46, 'COMMUNICATION CHARGES'),
(47, 'CONSTRUCTION IN PROGRESS'),
(48, 'COST OF SALES'),
(49, 'DEFERRED TAX EXPENSE'),
(50, 'DEPOSITS'),
(51, 'DEPRECIATION.-BUILDINGS'),
(52, 'DEPRECIATION.-TOOLS'),
(53, 'DEPRECIATION-FURN,FIX. & EQUIP.'),
(54, 'DEPRECIATION-MACHINE & EQUIP.'),
(55, 'DEPRECIATION-MOTOR VEHICLE'),
(56, 'DIRECT LABOR'),
(57, 'DUES AND FEES'),
(58, 'EMPLOYEES SAVINGS EXPENSE'),
(59, 'EMPLOYEES TRAVEL EXPENSE'),
(60, 'ENTERTAINMENT EXPENSE'),
(61, 'ENVIRONMENTAL IMPROVEMENT'),
(62, 'FOREIGN EXCHANGE GAIN'),
(63, 'FOREIGN EXCHANGE LOSS'),
(64, 'FOREX TRANSLATION ADJUSTMENT'),
(65, 'FRINGE BENEFIT EXPENSE'),
(66, 'FRINGE BENEFIT TAX EXP.'),
(67, 'FURNITURE,FIXTURE & EQUIP'),
(68, 'GAIN ON DISPOSAL'),
(69, 'GASOLINE AND OIL'),
(70, 'INCOME TAX PAYABLE'),
(71, 'INSURANCE EXPENSE'),
(72, 'INTEREST EXPENSE'),
(73, 'INTEREST INCOME'),
(74, 'LOSS FROM DISPOSAL'),
(75, 'MACHINERIES & EQUIPMENT'),
(76, 'MEDICARE EXPENSE'),
(77, 'MISCELLANEOUS EXPENSE'),
(78, 'MOTOR, VEHICLE & TRANS.'),
(79, 'NOTES PAYABLE- CURRENT'),
(80, 'OFFICE SUPPLIES'),
(81, 'OFFICERS SALARIES/ADMIN'),
(82, 'OTHER ASSETS'),
(83, 'OTHER EXPENSES'),
(84, 'PACKING AND DELIVERY'),
(85, 'PAG-IBIG EXPENSE'),
(86, 'PENSION LIABILITY'),
(87, 'PETTY CASH FUND'),
(88, 'PEZA CASH FUND'),
(89, 'PREPAID EXPENSES'),
(90, 'PREPAID EXPENSES - PREPAID INSURANCE'),
(91, 'PREPAID EXPENSES - PREPAID RENT'),
(92, 'PRINTING'),
(93, 'PROCESSING FEE'),
(94, 'PROFESSIONAL FEE'),
(95, 'PROV. FOR 13TH MO./BONUS'),
(96, 'PROVISION FOR IMPAIRMENT LOSS'),
(97, 'PROVISION FOR INCOME TAX'),
(98, 'PUBLICATION'),
(99, 'PURCHASE DISCOUNT'),
(100, 'PURCHASES'),
(101, 'RENT EXPENSE'),
(102, 'RENT EXPENSE - RESIDENCE'),
(103, 'RENT INCOME'),
(104, 'REPAIRS AND MAINTENANCE'),
(105, 'RETIREMENT BENEFIT'),
(106, 'SALARIES-ADMIN-STAFF'),
(107, 'SECURITY SERVICES'),
(108, 'SSS AND MEDICARE EXPENSE'),
(109, 'SUPPLIES EXPENSE'),
(110, 'TAXES AND LICENSES'),
(111, 'TIME DEPOSIT'),
(112, 'TOOLS'),
(113, 'TRAVELLING AND TRANSPORT.'),
(114, 'WATER AND LIGHT'),
(115, 'WELFARE EXPENSE');

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

--
-- Table structure for table `tbl_cadetails`
--

CREATE TABLE `tbl_cadetails` (
  `ca_id` int(11) NOT NULL,
  `trans_branch` varchar(50) NOT NULL,
  `datereq` varchar(250) NOT NULL,
  `timereq` varchar(250) NOT NULL,
  `ctrl_num` varchar(250) NOT NULL,
  `reqname` varchar(250) NOT NULL,
  `department` varchar(250) NOT NULL,
  `emp_id` varchar(250) NOT NULL,
  `emp_type` varchar(250) NOT NULL,
  `branch` varchar(250) NOT NULL,
  `branch_code` varchar(250) NOT NULL,
  `type` varchar(250) NOT NULL,
  `amount` varchar(250) NOT NULL,
  `balance` varchar(250) NOT NULL,
  `closing_ref` varchar(250) NOT NULL,
  `date_close` varchar(250) NOT NULL,
  `status` varchar(250) NOT NULL,
  `trial` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tbl_cashadvance`
--

CREATE TABLE `tbl_cashadvance` (
  `cash_id` int(11) NOT NULL,
  `trans_branch` varchar(50) NOT NULL,
  `ctrl_num` varchar(250) NOT NULL,
  `dep_charge` varchar(250) NOT NULL,
  `purpose` varchar(250) NOT NULL,
  `amount` varchar(250) NOT NULL,
  `balance` varchar(250) NOT NULL,
  `liquidate` varchar(250) NOT NULL,
  `status` int(11) NOT NULL,
  `type` varchar(250) NOT NULL,
  `date_liquidated` varchar(250) NOT NULL,
  `actual_exp` varchar(250) NOT NULL,
  `change_am` varchar(250) NOT NULL,
  `remarks_am` varchar(250) NOT NULL,
  `trial` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tbl_daily`
--

CREATE TABLE `tbl_daily` (
  `d_id` int(11) NOT NULL,
  `date_cur` varchar(250) NOT NULL,
  `amount` varchar(250) NOT NULL,
  `released_amount` varchar(250) NOT NULL,
  `balance` varchar(250) NOT NULL,
  `stat` varchar(250) NOT NULL,
  `cashbalance` varchar(250) NOT NULL,
  `trans_branch` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tbl_employee`
--

CREATE TABLE `tbl_employee` (
  `reg_id` int(11) NOT NULL,
  `emp_name` varchar(250) DEFAULT NULL,
  `emp_id` varchar(250) DEFAULT NULL,
  `emp_type` varchar(250) DEFAULT NULL,
  `emp_location` varchar(250) DEFAULT NULL,
  `loc_code` varchar(100) DEFAULT NULL,
  `department` varchar(250) DEFAULT NULL,
  `expensetype` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_employee`
--

INSERT INTO `tbl_employee` (`reg_id`, `emp_name`, `emp_id`, `emp_type`, `emp_location`, `loc_code`, `department`, `expensetype`) VALUES
(0, 'Z', '0', 'DIRECT', 'LAGUNA', '001', 'SYSTEMS MANAGEMENT', 'ADM'),
(1, 'ABAYGAR, KIM CARLA', '19-108-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(2, 'ABE, MELENCIO C.', '20-004', 'DIRECT', 'LIMA', '004', 'IMS', 'ADM'),
(3, 'ABELARDO, EDILYN', '21-101-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(4, 'ABELLA, JOHN ROMEO P.', '17-051', 'DIRECT', 'FPIP', '005', 'LOGISTICS', 'MOH'),
(5, 'ABIERA, MARVIN R.', '21-031', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(6, 'ABORDO, DENNIS', '20-015-A', 'AGENCY', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(7, 'ABRENICA, JOHN LOUIE L.', '15-024', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(8, 'ACEJO, JOLITO M.', '18-055', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(9, 'ADARLO, ROVIC MANRIQUE', '21-030-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(10, 'AGUIRRE, ROMMEL DESCOTIDO', '21-068-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(11, 'ALAYAN, REYMARK', '21-110-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(12, 'ALCANICES, LEANDER O.', '16-024', 'DIRECT', 'FPIP', '005', 'WAREHOUSE', 'MOH'),
(13, 'ALCANTARA, DANIEL DEO', '20-049-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(14, 'ALCANTARA, PANFILO S., JR.', '17-022', 'DIRECT', 'LAGUNA', '001', 'ENGINEERING', 'MOH'),
(15, 'ALCURAN, FRANCISCO G., JR.', '17-045', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(16, 'ALMARIO, REXEL L.', '99-157', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(17, 'ALMOROS, JOAN C.', '20-017', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(18, 'ALONSAGAY, MICHAEL R.', '09-005', 'DIRECT', 'LAGUNA', '001', 'DESIGN AND TECHNOLOGY', 'ADM'),
(19, 'ALTAVANO, REYLAN', '21-161-A', 'AGENCY', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(20, 'ALVAREZ, MARVIN B.', '10-002', 'DIRECT', 'LAGUNA', '001', 'DESIGN AND TECHNOLOGY', 'ADM'),
(21, 'AMORES, GLEZYL S.', '15-018', 'DIRECT', 'CEBU', '002', 'MANUFACTURING PLANNING', 'ADM'),
(22, 'AN, SHANDREX JUNE ONA', '21-180-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(23, 'ANDEO, MARK ROLLY', '20-034-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(24, 'ANONUEVO, MELFORD A.', '19-025', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(25, 'ANONUEVO, RICHARD S.', '20-031', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(26, 'ANTOP, KYLIE PENARIO', '21-149-A', 'AGENCY', 'CEBU', '002', 'LOGISTICS', 'MOH'),
(27, 'APALLA, WEENA V.', '16-006', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(28, 'AQUINO, ARNOLD B.', '00-229', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(29, 'AQUINO, MICHELLE D.', '15-021', 'DIRECT', 'LAGUNA', '001', 'PURCHASING', 'ADM'),
(30, 'ARADA, CHRISTIAN R.', '21-016', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(31, 'ARAMBULO, CHRISTIAN RAYMOND PALIS', '21-156-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(32, 'ARCOIREZ, NORIEL MENDOZA', '21-050-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(33, 'AREVALO, CHERIE ANNE C.', '19-010', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(34, 'ARIOLA, RODERICK', '17-167-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(35, 'ARIOLA, ROY JOHN', '21-109-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(36, 'ARISGADO,LESTER', '21-142-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(37, 'ARPON, JERWIN C.', '20-012', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(38, 'ASPE, PAUL SYMON D.', '15-025', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(39, 'ATIENZA JOHN KENNETH', '20-067-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(40, 'ATIENZA, JONATHAN MALIBIRAN', '22-018-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(41, 'AUSTRIA, JOSEPHINE D.', '02-639', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(42, 'AVILES, LEI ANN MARIE V.', '20-015', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(43, 'AYAP, NELSON A.', '19-022', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(44, 'AZADA, RYAN', '17-079-A', 'AGENCY', 'FPIP', '005', 'LOGISTICS', 'MOH'),
(45, 'AZUCENA, ANGEL CLARICE D.', '21-001', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(46, 'BACTOL, JENNIFER U.', '19-031', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(47, 'BADURIA, JHOE-BHEN F.', '21-033', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(48, 'BALASAN, RENEBOY', '18-101-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(49, 'BALDEPENA, JAY-R RECTO', '19-086-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(50, 'BALISI, DEXTER', '18-200-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(51, 'BALLESTEROS, ERIC NEIL', '18-127-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(52, 'BALLIARAN, JESSIE JOSUE', '22-011-A', 'AGENCY', 'FPIP', '005', 'PRODUCTION', 'MOH'),
(53, 'BANATICLA, MAYLEEN SENORA', '19-131-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(54, 'BARACAEL, BENEDICK CRISPO', '22-016-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(55, 'BARTONICO, RENGIE CLEMENTE', '21-150-A', 'AGENCY', 'CEBU', '002', 'LOGISTICS', 'MOH'),
(56, 'BASCO, JUD', '20-066-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(57, 'BASQUINAS, ZANDRO A.', '11-014', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(58, 'BAUTISTA, ERNESTO D., JR.', '05-023', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(59, 'BAUTISTA, JOVEN JAY CALIZO', '22-048', 'DIRECT', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(60, 'BAYANI, MARK LOUIE', '21-051-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(61, 'BAYNA, JOHN KELVIN TOLENTINO', '21-031-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(62, 'BELARDO, CLEMAR B.', '18-012', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(63, 'BELLEN, DARREL RACINES', '20-041-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(64, 'BELLO, JUNNEL S.', '21-037', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(65, 'BELTRAN GERRY', '17-051-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(66, 'BELTRAN, JENELYN R.', '15-019', 'DIRECT', 'LAGUNA', '001', 'PURCHASING', 'ADM'),
(67, 'BELTRAN, JUSTINE ART R.', '19-008', 'DIRECT', 'LAGUNA', '001', 'ENGINEERING', 'MOH'),
(68, 'BENJAMIN, JESSIE A.', '18-016', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(69, 'BENOYO, ALVIN G.', '16-008', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(70, 'BERDIN, CLAUDIO T., III', '20-030', 'DIRECT', 'CEBU', '002', 'PRODUCTION', 'MOH'),
(71, 'BERDULAGA, ELAINE FOLINES', '21-132-A', 'AGENCY', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(72, 'BERINA, FRANCIS M.', '18-057', 'DIRECT', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(73, 'BERMUDEZ, CHRISTIAN DIONIO', '21-017-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(74, 'BERTIZ, NINO RUBEN B.', '18-011', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(75, 'BETCO, ANTHONY M.', '18-056', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(76, 'BIONAT, CARMELYN G.', '21-005', 'DIRECT', 'LAGUNA', '001', 'PURCHASING', 'ADM'),
(77, 'BONAOBRA, RAPHAEL NELMER C.', '18-058', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(78, 'BONAYON, DAVID RUPERT L.', '14-002', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(79, 'BRAVO, JOHN PATRICK GUERRA', '19-074-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(80, 'BREQUILLO, ROBERT B.', '16-017', 'DIRECT', 'LAGUNA', '001', 'ENGINEERING', 'MOH'),
(81, 'BRIZA, JERNICK B.', '18-039', 'DIRECT', 'LAGUNA', '001', 'ENGINEERING', 'MOH'),
(82, 'BUAL, JAYSON P.', '20-006', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(83, 'BUAN, RHOGEMER', '20-069-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(84, 'BUELA, VANESSA D.', '19-003', 'DIRECT', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(85, 'BUEN, RITCHE B.', '11-004', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING ENGINEERING', 'MOH'),
(86, 'BUENCAMINO, ROSEMARIE R.', '19-028', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(87, 'BUGAYONG, JONATHAN G.', '02-904', 'DIRECT', 'LAGUNA', '001', 'INFORMATION TECHNOLOGY', 'ADM'),
(88, 'BUNO, GUADALUPE M.', '11-003', 'DIRECT', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(89, 'BUNO, SEGUNDO M.', '19-030', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(90, 'CABADIN JR. ELADIO LOPEZ', '19-087-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(91, 'CABIGTING, EDMON LABRADOR', '21-036-A', 'AGENCY', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(92, 'CABILLO, RAIZEL O.', '18-069', 'DIRECT', 'LIMA', '004', 'GENERAL AFFAIRS', 'ADM'),
(93, 'CABRERA, JEFFREY', '19-101-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(94, 'CACAO, ELVIRA L.', '00-207', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(95, 'CADSAWAN, CATHERINE QUILAPIO', '21-168-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(96, 'CAFE, RODEL C.', '18-066', 'DIRECT', 'CEBU', '002', 'LOGISTICS', 'MOH'),
(97, 'CALABRIA, JOHN JERICK MALICAD', '19-038-A', 'AGENCY', 'FPIP', '005', 'PRODUCTION', 'MOH'),
(98, 'CALINGACION, REGINE', '17-122-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(99, 'CALVA, JESSIE JAMES D.', '21-013', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(100, 'CALVARIO, CARLO Z.', '16-009', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(101, 'CAMBLINDA, MARK DARELL', '20-079-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(102, 'CAMPANA, CLAUDINE P.', '18-032', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(103, 'CAMPOS, JANITO P.', '17-054', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(104, 'CANICULA, RON MICHAEL', '19-054-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(105, 'CANO, FRANCO B.', '15-026', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(106, 'CANTALEJO, JAYROUCEL CHELLO G.', '18-068', 'DIRECT', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(107, 'CANUA, CARLOS C.', '98-137', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(108, 'CARDONA, VINER CATER', '21-023-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(109, 'CARILLAS, PATERNO S.', '18-022', 'DIRECT', 'CEBU', '002', 'PRODUCTION', 'MOH'),
(110, 'CARINGAL, JEROME C.', '19-045', 'DIRECT', 'LIMA', '004', 'DESIGN AND TECHNOLOGY', 'ADM'),
(111, 'CARINO, FRANCIS GERALD A.', '19-060', 'DIRECT', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(112, 'CASILLANO, FLAVIANE D.', '11-017', 'DIRECT', 'LAGUNA', '001', 'ACCOUNTING', 'ADM'),
(113, 'CASILLANO, MICHAEL JINGZEL C.', '15-017', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING ENGINEERING', 'MOH'),
(114, 'CASIPIT, KRISTINE MAE V.', '13-005', 'DIRECT', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(115, 'CASTILLO, JOHN BLITZ R.', '17-011', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(116, 'CASTILLO, NOEL M.', '19-015', 'DIRECT', 'FPIP', '005', 'LOGISTICS', 'MOH'),
(117, 'CASUNDO, JOMAR', '21-107-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(118, 'CATAPANG, ZAIRON NUNEZ', '21-181-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(119, 'CATIBOG, DARIEL', '20-077-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(120, 'CEPEDA, NOEMI V.', '00-188', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(121, 'CEPILLO, MARINO ARGUELLES', '21-125-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(122, 'CHAVEZ, MICHELLE R.', '13-011', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(123, 'CHAVEZ, PEDRO P., JR.', '11-015', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(124, 'CLAVE, HENRY O.', '17-042', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(125, 'CODILLO, RHOMEL', '21-032-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(126, 'COLECHA, ERNESTO S., JR.', '20-008', 'DIRECT', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(127, 'COMENDADOR, LUCKY NINO', '17-109-A', 'AGENCY', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(128, 'COMIA, JONAS DIN', '22-006-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(129, 'CONDONAR, KHALID D.', '16-021', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(130, 'CONSEGRA, JHON MARK ACABADO', '22-012-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(131, 'CONSTANTINO, CHRIS JOHN E.', '18-059', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(132, 'CORNEJO, ANALIN', '13-63-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(133, 'CORNISTA, JOHN RYAN B.', '20-034', 'DIRECT', 'LIMA', '004', 'ENGINEERING', 'MOH'),
(134, 'CORTEZ, ALDRIN E.', '20-009', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(135, 'CORTEZ, JOSEPH P.', '19-026', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(136, 'CORTEZ, PHILIP O.', '19-023', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(137, 'CORUNO, LENARD C.', '21-011', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(138, 'COYOCA, FERDINAND', '21-116-A', 'AGENCY', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(139, 'CRISTOBAL, JOHN D.', '03-330', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(140, 'CUBACUB, PAUL G.', '19-049', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING ENGINEERING', 'MOH'),
(141, 'CUETO, JOHN ALBERT MANJARES', '19-008-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(142, 'CUETO, NESIER F.', '09-038', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(143, 'CUNANAN, GLORY ANN', '16-030-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(144, 'CUSTODIO, RALPH JOSEPH', '21-143-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(145, 'CUTAMORA, ALLAN F.', '08-022', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(146, 'DA JOSE, LADY LYN CAPUCHINO', '21-178-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(147, 'DACALCAP, CINDY', '17-095-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(148, 'DAELO, ANTONETTE GRACE B.', '19-012', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(149, 'DAET, ROSE ANNE S.', '22-004', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(150, 'DAET, ROSE-ANN', '21-130-A', 'AGENCY', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(151, 'DAGSINDAL, CARLO FLORA', '19-013-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(152, 'DALAODAO, DEXTER JOSEF CALINGASAN', '21-065-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(153, 'DARIO, ENGLEBERTH N.', '14-004', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(154, 'DAZA, MARLON', '17-113-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(155, 'DE CASTRO, ALMIRA C.', '19-067', 'DIRECT', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(156, 'DE CASTRO, PETRONIL P.', '11-016', 'DIRECT', 'FPIP', '005', 'LOGISTICS', 'MOH'),
(157, 'DE CHAVEZ, DERWIN', '21-108-A', 'AGENCY', 'FPIP', '005', 'PRODUCTION', 'MOH'),
(158, 'DE CLARO, SIDNEY C.', '18-009', 'DIRECT', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(159, 'DE GUIA, ROBERTO NAVARRO', '20-008-A', 'AGENCY', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(160, 'DE GUZMAN, CRSIZEL', '20-069-B', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(161, 'DE GUZMAN, GERALD D.', '01-427', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(162, 'DE GUZMAN, JHOANA MANTOS', '21-100-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(163, 'DE JESUS, MELISSA M.', '18-046', 'DIRECT', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(164, 'DE LEON, AIDEL N.', '20-002', 'DIRECT', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(165, 'DE LEON, JUAN GABRIEL', '19-046-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(166, 'DE OCAMPO, GENNELYN M.', '17-009', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(167, 'DE ROSALES, CYRA LOU E.', '21-051', 'DIRECT', 'LAGUNA', '001', 'ACCOUNTING', 'ADM'),
(168, 'DE ROXAS, ALGENE VEE KARL I.', '19-042', 'DIRECT', 'LAGUNA', '001', 'DESIGN AND TECHNOLOGY', 'ADM'),
(169, 'DE SILVA, JEFFREY LAJARA', '21-005-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(170, 'DE VERA, LARRY OBA', '20-056-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(171, 'DE VIVAR, FELIX JR. GRABILLO', '21-153-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(172, 'DEACOSTA, REYZON L.', '14-005', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(173, 'DECIAR, KENNETH JORDAN', '17-130-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(174, 'DEJITO, ROBERT F.', '09-028', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(175, 'DEL MONTE, SANNY BOY L.', '21-044', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(176, 'DEL PUSO, JOJO', '21-117-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(177, 'DELGADO, JHEYWARD R.', '20-026', 'DIRECT', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(178, 'DELUMEN, RENELO', '16-052-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(179, 'DEMDAM, AIRA L.', '21-029', 'DIRECT', 'LAGUNA', '001', 'PURCHASING', 'ADM'),
(180, 'DENA, ONALD R.', '17-007', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(181, 'DEQUITO, ANTONNETTE JOY B.', '19-047', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(182, 'DESUCATAN, MARIA CONNIE SERRA', '21-138-A', 'AGENCY', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(183, 'DEVELLES, EDDO S.', '15-004', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(184, 'DIAZ, DARWIN KIM MORALES', '21-124-A', 'AGENCY', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(185, 'DIAZ, ZEUS LACSAM', '21-039-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(186, 'DIMASUPIL, DAN MARCO', '19-084-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(187, 'DIMAYUGA, SUZETTE M.', '17-032', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(188, 'DINGLASAN, ALEX', '21-111-A', 'AGENCY', 'FPIP', '005', 'PRODUCTION', 'MOH'),
(189, 'DIZON, SAIRYL PEREZ', '19-128-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(190, 'DOROJA, JOEY G.', '15-005', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(191, 'DUGAN, MARK RYAN TRESVALLES', '21-146-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(192, 'DULO, JESSA MAY T.', '21-006', 'DIRECT', 'LIMA', '004', 'PURCHASING', 'ADM'),
(193, 'EBIO, RHEA MAE', '18-090-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(194, 'EDADES, JEFFREY MANREAL', '21-136-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(195, 'EMNACE, VICTOR RESUELO', '21-079-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(196, 'EMPERADOR, AMBEL B.', '17-010', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(197, 'ENDAYA, JOHN JERICK L.', '21-020', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(198, 'ENRIQUEZ, JAY MHEL', '21-160-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(199, 'ESGUERRA, RODERICK ALBA', '21-052-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(200, 'ESPANOL, JAIZELLE KATRIN G.', '17-027', 'DIRECT', 'LAGUNA', '001', 'PURCHASING', 'ADM'),
(201, 'ESPANOLA, MARJAY', '18-010-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(202, 'ESPIRITU, ALBERT PONCE', '20-004-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(203, 'ESQUIBEL, LEE JAY', '21-145-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(204, 'ESTAREJA, IRISH MAY L.', '18-002', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(205, 'ESTERON, JOHNNY T.', '96-140', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(206, 'ESTRANA, RENE B.', '15-006', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(207, 'ESTRELLA, LYKA JANE FRANCIA', '22-010-A', 'AGENCY', 'LAGUNA', '001', 'IMS', 'ADM'),
(208, 'EVANGELISTA, ROCHELLE C.', '20-020', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(209, 'FATALLO, WILBERT F.', '21-021', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(210, 'FELICIANO, EDUARDO', '20-063-A', 'AGENCY', 'LIMA', '004', 'GENERAL AFFAIRS', 'ADM'),
(211, 'FERNANDEZ, PRINCES CLAIRE FAMORCAN', '19-130-A', 'AGENCY', 'FPIP', '005', 'MANUFACTURING PLANNING', 'ADM'),
(212, 'FERRER, MELVIN G.', '20-011', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(213, 'FESTIN, EXZOR', '21-045', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(214, 'FILIPINAS, ANNA PAMELA L.', '02-523', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(215, 'FILIPINAS, MARVEN M.', '07-001', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(216, 'FLORES, CHARLENE JAN MARIE M.', '18-034', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(217, 'FLORES, HEMELEN A.', '00-282', 'DIRECT', 'CEBU', '002', 'PRODUCTION', 'MOH'),
(218, 'FLOTADO, PAUL ALVIN GARMA', '22-007-A', 'AGENCY', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(219, 'GALAROSA, JESSA FUENSALIDA', '21-014-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(220, 'GALLENITO, ARLENE VIGO', '21-127-A', 'AGENCY', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(221, 'GALLOS, JENIFFER O.', '02-711', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(222, 'GAMBOA, VEEJAY', '18-229-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(223, 'GAPASIN, GILBERT AGUILA', '21-091-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(224, 'GARCIA, ANNIE MAY CORDOVILLA', '21-191-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(225, 'GARCIA, MACKIE', '16-018', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(226, 'GARCIA, ROWEL D.', '18-018', 'DIRECT', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(227, 'GAYACAN, REGIE BOY ABREU', '21-175-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(228, 'GENABIA, LITO C., JR.', '21-043', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(229, 'GERNALE, APRIL JOY', '19-081-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(230, 'GETAPE, ROSMEL USTARIS', '21-137-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(231, 'GIDO, JASTINE JOY R.', '18-004', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(232, 'GIMENO, GORGONIO U., JR.', '15-027', 'DIRECT', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(233, 'GINES, ALBERT RASOS', '21-081-A', 'AGENCY', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(234, 'GIPULAN, JIEZA L.', '18-001', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(235, 'GISALA, DHON-DON O.', '21-042', 'DIRECT', 'LAGUNA', '001', 'ENGINEERING', 'MOH'),
(236, 'GLORI, PAULINE MAE ALUMAGA', '21-093-A', 'AGENCY', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(237, 'GOLTIA, ARIEL LLOYD MAGHANOY', '20-038-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(238, 'GONZALES, EDINO D.', '16-010', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING ENGINEERING', 'MOH'),
(239, 'GONZALES, JARREN MENDOZA', '22-008-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(240, 'MANABAT, GLESSIE G.', '21-046', 'DIRECT', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(241, 'GRENCIO, CARLO MONTEMOR', '22-004-AA', 'AGENCY', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(242, 'GUINTO, RAVEN CRUZ', '19-059-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(243, 'GUSI, JERIMIE V.', '19-053', 'DIRECT', 'FPIP', '005', 'WAREHOUSE', 'MOH'),
(244, 'HATIA, CARLO R.', '22-003', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(245, 'HATIA, CARLO RECIO', '21-006-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(246, 'HELERA, MARK ALLEN A.', '20-024', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(247, 'HERNANDEZ, ADRILAN A.', '05-017', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(248, 'HERNANDEZ, DAVE DAREL', '20-005-A', 'AGENCY', 'FPIP', '005', 'PRODUCTION', 'MOH'),
(249, 'HERNANDEZ, JESSIE ROM', '18-236-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(250, 'HICARO, MHARK', '16-045-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(251, 'HILAJAN, JOEL', '18-004-A', 'AGENCY', 'LAGUNA', '001', 'IMS', 'ADM'),
(252, 'HILARIO, MICHELLE T.', '19-035', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(253, 'HIRANG JR., REYNALDO F.', '17-044', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(254, 'IIJIMA, KAITO', '21-025', 'DIRECT', 'LAGUNA', '001', 'SALES', 'ADM'),
(255, 'INDOMA, RICK JAN DUGAYO', '21-166-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(256, 'INSIGNE, MARK JOSEPH REYES', '21-173-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(257, 'INTIA , ANTONIO II', '18-100-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(258, 'JABONIDO, D.J MARTIN GICO', '20-040-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(259, 'JACINTO, MICHAEL', '16-023-A', 'AGENCY', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(260, 'JACOB, LADY LEE B.', '19-066', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(261, 'JARITO, JESAMINE', '18-034-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(262, 'JAVIER, CHERRIE ANN C.', '99-220', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(263, 'JAVIER, CHERYROSE A.', '19-005', 'DIRECT', 'LAGUNA', '001', 'PURCHASING', 'ADM'),
(264, 'JAVIER, JASPER JOHN Q.', '18-026', 'DIRECT', 'LAGUNA', '001', 'IMS', 'ADM'),
(265, 'JAVIER, SHARLOTTE NICOLE ALAMER', '21-126-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(266, 'JISMUNDO, CHRISTIAN VELADO', '21-070-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(267, 'JOSE, RACHELLE C.', '18-020', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(268, 'JOVEN, JOY GONZALES', '22-014-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(269, 'JUANERIO, JOE VINCENT DEGUZMAN', '21-042-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(270, 'KANEHIRA, SAKUTARO', '01-001', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(271, 'KANEHIRA, YUJI', '15-003', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(272, 'LABAY, MENCHIE L.', '11-005', 'DIRECT', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(273, 'LABAYO, BRYAN CANCERAN', '21-083-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(274, 'LACANDAZO, MARILYN G.', '00-217', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(275, 'LADONGA, ALLAN A.', '09-035', 'DIRECT', 'CEBU', '002', 'PURCHASING', 'ADM'),
(276, 'LAGUBANA, JOHN JERWIN D.', '19-065', 'DIRECT', 'LAGUNA', '001', 'ENGINEERING', 'MOH'),
(277, 'LALICAN JR., RODANTE D.', '14-013', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(278, 'LALUSIN, IAN O.', '21-034', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(279, 'LAMSEN, BONIFACIO D.', '19-033', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(280, 'LAQUI, JOMARI BABADILLA', '22-004-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(281, 'LARA, MARLON G.', '18-060', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(282, 'LARAYOS, JHOVINREY UBAOB', '19-091-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(283, 'LATORRE, JOBELLE D.', '19-072', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(284, 'LAUREANO, MARK ALLAN C.', '18-015', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(285, 'LAVADO, MARK JOSEPH ABLES', '21-029-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(286, 'LAYSON, JOEL A.', '19-055', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(287, 'LEGASPI, FE JAY ACUNA', '21-171-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(288, 'LIMAN, LYCCA', '21-151-A', 'AGENCY', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(289, 'LIMAN, LYCCA S.', '22-005', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(290, 'LIMJOCO, RICHARDSON M.', '00-210', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(291, 'LINA, MARY ROSE', '21-104-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(292, 'LINGAL, JOEDEL ANTHONY', '18-193-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(293, 'LITARGO, DARLENE R.', '21-030', 'DIRECT', 'LIMA', '004', 'MANUFACTURING ENGINEERING', 'MOH'),
(294, 'LIZARDO, JACQUILINE T.', '09-007', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(295, 'LLANES, KIM TOM', '20-033-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(296, 'LLANITA, SHANE', '18-065-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(297, 'LLARENA, ANGELICA MARIE', '17-124-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(298, 'LOGMAO, RAYMART D.', '19-020', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(299, 'LOPEZ, JAYVEE J.', '21-017', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(300, 'LOQUITE, DIANA RICA T.', '17-058', 'DIRECT', 'CEBU', '002', 'SALES', 'ADM'),
(301, 'LORENZO, REYMIL B.', '16-020', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(302, 'LUBAG, SHEILA A.', '06-137', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(303, 'LUCILLO, MARK LOUIE', '21-112-A', 'AGENCY', 'FPIP', '005', 'LOGISTICS', 'MOH'),
(304, 'LUNA JR., BENJAMIN VIVAS', '22-013-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(305, 'LUNA, JOVEN LENDIO', '19-121-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(306, 'LUNAR, LOREN JAY CID', '21-0867-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(307, 'MABALOT, RACHEL H.', '19-029', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(308, 'MABILANGAN, ARWIN M.', '16-025', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(309, 'MACALLA, MARK', '21-114-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(310, 'MACASAET, JESTONIE', '21-102-A', 'AGENCY', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(311, 'MACATANGAY, EMAR S.', '18-067', 'DIRECT', 'LIMA', '004', 'ENGINEERING', 'MOH'),
(312, 'MADIN, JENNIN', '18-124-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(313, 'MADRIAGA, MARY JOY PERALTA', '22-003-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(314, 'MADRID, DARCEY D.', '21-035', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(315, 'MAGNAYE, ANNA CRISTINE MUTYA C.', '18-049', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(316, 'MAGPANTAY, JEXCEL L.', '21-047', 'DIRECT', 'LIMA', '004', 'PURCHASING', 'ADM'),
(317, 'MAGSAYSAY, REMEDIOS D.', '18-008', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(318, 'MAGSINO, GLENN DONALD M.', '12-011', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(319, 'MAGSINO, REX NINO', '20-051-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(320, 'MAGTANGOB, ANGELITO V.', '18-054', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(321, 'MAGTIBAY, MICHAEL', '21-140-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(322, 'MAIQUEZ, JANETH CAGUICLA', '21-015-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(323, 'MALABANAN, BRYAN Q.', '18-061', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(324, 'MALABANAN, SHERWIN C.', '17-043', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(325, 'MALAPIT, EDWIN MIRAMBIL', '21-076-A', 'AGENCY', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(326, 'MALIGALIG, JOEL O.', '09-032', 'DIRECT', 'LIMA', '004', 'LOGISTIC', ''),
(327, 'MALIGAYA, RICHARD G.', '19-027', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(328, 'MALINAO, AMANCIO JR.', '18-151-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(329, 'MALLORCA, RANDY B.', '14-014', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(330, 'MANACOP, GRACE B.', '02-975', 'DIRECT', 'LAGUNA', '001', 'ACCOUNTING', 'ADM'),
(331, 'MANAGA, DAREN DAVE LARA', '21-016-A', 'AGENCY', 'FPIP', '005', 'PRODUCTION', 'MOH'),
(332, 'MANAGO, NINO STANLEY TORRALBA', '21-133-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(333, 'MANAIG JR., PABLO NAPILI', '21-179-A', 'AGENCY', 'FPIP', '005', 'PRODUCTION', 'MOH'),
(334, 'MANAIG, REA V.', '19-048', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(335, 'MANALANG, JAN', '17-118-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(336, 'MANALO, ALVIN T.', '20-021', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(337, 'MANALO, JHONALYNN C.', '21-027', 'DIRECT', 'LIMA', '004', 'GENERAL AFFAIRS', 'ADM'),
(338, 'MANALO, ROLAND M.', '21-032', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(339, 'MANALO, RYAN N.', '14-006', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(340, 'MANGABAT, DARWIN M.', '14-015', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(341, 'MANZANERO, GLEN PAOLO S.', '21-038', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(342, 'MANZANILLA, GENESIS B.', '19-016', 'DIRECT', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(343, 'MAPALAD, JHON VERGEL', '22-017-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(344, 'MARANAN, JOHN MICHEL D.', '19-062', 'DIRECT', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(345, 'MARANAN, JOMARI C.', '17-035', 'DIRECT', 'LAGUNA', '001', 'DESIGN AND TECHNOLOGY', 'ADM'),
(346, 'MARASIGAN, ANGEL P.', '18-019', 'DIRECT', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(347, 'MARASIGAN, BRIDGETTE C.', '11-021', 'DIRECT', 'LAGUNA', '001', 'IMS', 'ADM'),
(348, 'MARCINAREZ, RAYMOND RASONABLE', '21-123-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(349, 'MARQUEZ, JOEY B.', '16-014', 'DIRECT', 'LIMA', '004', 'IMS', 'ADM'),
(350, 'MARTILLAN, JOSEPHINE B.', '97-206', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(351, 'MARTILLANO, ALDA GRACE D.', '96-278', 'DIRECT', 'CAVITE', '003', 'MANUFACTURING PLANNING', 'ADM'),
(352, 'MARTINEZ, ARVIN RADA', '22-005-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(353, 'MASANGCAY, ALEXANDER', '21-002-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(354, 'MASUCOL, FREGIE', '21-001-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(355, 'MATA, RENFREY', '17-004-A', 'AGENCY', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(356, 'MEDALLA, MARIA ALLIAH C.', '22-002', 'DIRECT', 'LAGUNA', '001', 'INFORMATION TECHNOLOGY', 'ADM'),
(357, 'MEDINA, ROSEMARIE L.', '18-052', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(358, 'MEER, MICHAEL JOHN M.', '18-038', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(359, 'MENCHERO, JETRIC HERRADURA', '20-014-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(360, 'MENDONEZ, JHEE ANN', '17-093-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(361, 'MENDOZA, JESIE G.', '21-039', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(362, 'MENDOZA, REMEDIOS M.', '98-219', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(363, 'MENDOZA, RODNEY', '17-044-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(364, 'MENDOZA, RONIEL L.', '20-022', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(365, 'MESA, JHUNAR M.', '09-025', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(366, 'MICOSA, REN VALINADO', '21-129-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(367, 'MIRANDA, RHODORA R.', '99-103', 'DIRECT', 'LIMA', '004', 'MANAGEMENT', 'ADM'),
(368, 'MOJICA, ARIEL M.', '20-014', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(369, 'MOLDON, JEROM A.', '21-010', 'DIRECT', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(370, 'MONTEALTO, WILLY D.', '21-019', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(371, 'MORALES, SYDEN ROBLES', '20-016-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(372, 'MORINAGA, MISA', '16-005', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(373, 'MOTILLA, WARREN M.', '10-037', 'DIRECT', 'FPIP', '005', 'SALES', 'ADM'),
(374, 'MULAR, EDWARDZON', '18-024-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(375, 'MUNOZ JR., MARTIN GUERRERO', '21-163-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(376, 'NAGPALA, MARIVIC N.', '15-023', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(377, 'NATIVIDAD, ELIZA MAE L.', '21-049', 'DIRECT', 'LAGUNA', '001', 'ACCOUNTING', 'ADM'),
(378, 'NAVARRO, IAN LEGUA', '21-046-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(379, 'NAVARRO, NIKKAEL JHOY PALITAYAN', '21-147-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(380, 'NAVEA, AVELINO SAMBOY B.', '20-027', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(381, 'NAVORRA, MARY JANE L.', '19-034', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(382, 'NECERIO, REYMUND A.', '00-259', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(383, 'NEMENZO, WINSTON', '16-047-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(384, 'NICOLAS, JEFF', '18-071-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(385, 'NIDO, CESAR R.', '09-034', 'DIRECT', 'LIMA', '004', 'MANUFACTURING ENGINEERING', 'MOH'),
(386, 'NIETO, MARK M.', '16-019', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(387, 'NOCIDO, PAULO', '20-073-A', 'AGENCY', 'LIMA', '004', 'GENERAL AFFAIRS', 'ADM'),
(388, 'NON, ALEX G.', '15-008', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(389, 'OBINA, REYNANTE B., JR.', '19-057', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(390, 'OBONG, RAMEL L.', '08-061', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(391, 'OCA, JHAYMELYN V.', '21-023', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(392, 'OCAMPO, ICOFEL O.', '15-029', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(393, 'ODEVILAS, AUBREY MAE B.', '21-050', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(394, 'OPENA, RON JERICK', '18-079-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(395, 'ORAYE, NANETTE', '18-121-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(396, 'ORLANDA, NICOLAS ANDREW B.', '19-004', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(397, 'ORTEGA, RANDY C.', '13-008', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(398, 'ORTEGA, STELA C.', '17-019', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(399, 'ORTILLA, JAMES RYAN R.', '19-024', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(400, 'ORTILLA, SHERYL M.', '12-005', 'DIRECT', 'LIMA', '004', 'SALES', 'ADM'),
(401, 'ORTILLO, EVANGELINE E.', '11-010', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(402, 'ORTIZ, JESSA C.', '20-038', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(403, 'OSI, SALVE B.', '11-024', 'DIRECT', 'LIMA', '004', 'PURCHASING', 'ADM'),
(404, 'OSTIA JR., AMANCIO M.', '17-047', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(405, 'OTTO, ANDRE ALEXIS U.', '17-040', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(406, 'PADILLA, GEAN LOUI V.', '15-009', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(407, 'PAGDAYUNAN, DOMINGO V., JR.', '16-022', 'DIRECT', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(408, 'PAITE JR., ROMULO HONA', '21-008-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(409, 'PAJE, MARVIN MORATILLO', '21-120-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(410, 'PALLERMO, ARLENE', '18-192-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(411, 'PAMBAGO, MICHAEL V.', '15-010', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(412, 'PAMBAGO, RAMIL D.', '19-032', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(413, 'PAMBAGO, RONALD MALABANAN', '21-099-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(414, 'PAMOTE, JHAZELLE ANNE M.', '22-001', 'DIRECT', 'LAGUNA', '001', 'IMS', 'ADM'),
(415, 'PAMPLONA, JAYVEE M.', '18-062', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(416, 'PAMULAKLAKIN, ALVIN M.', '08-001', 'DIRECT', 'LAGUNA', '001', 'ENGINEERING', 'MOH'),
(417, 'PAMULAKLAKIN, MARVIN G.', '20-025', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(418, 'PANESA, VANESSA B.', '20-001', 'DIRECT', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(419, 'PANGANIBAN, KRETCHENE M.', '17-037', 'DIRECT', 'LAGUNA', '001', 'DESIGN AND TECHNOLOGY', 'ADM'),
(420, 'PAPA, LAWRENCE TEJADA', '21-010-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(421, 'PAPICAP, HIZELYN', '18-131-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(422, 'PAR, JEFFREY MALABANAN', '21-184-A', 'AGENCY', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(423, 'PARUNGAO, ELMER U.', '21-015', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(424, 'PASAGUI, THOM HILL', '21-041', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(425, 'PAWA, ROMMEL D.', '10-032', 'DIRECT', 'CEBU', '002', 'PRODUCTION', 'MOH'),
(426, 'PAZ, MARVIN D.', '18-063', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(427, 'PEDRIGAL, DARWIN', '20-076-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(428, 'PEDUCHE, CLAIRE IRIS GAY', '21-189-A', 'AGENCY', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(429, 'PERALTA, RHANY MAC T.', '21-009', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING ENGINEERING', 'MOH'),
(430, 'PEREZ, JERICK OCBA', '22-002-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(431, 'PEREZ, MARK CLEMENCE MOTEL', '20-013-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(432, 'PEREZ, VERONICA R.', '19-038', 'DIRECT', 'LAGUNA', '001', 'SALES', 'ADM'),
(433, 'PERLAS, CRISTIAN B.', '17-053', 'DIRECT', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(434, 'PERLAS, JESSMAE', '21-014', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(435, 'PERNIA, VICTOR DIAZ', '19-004-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(436, 'PEROCHO, RONALDO BERENGER', '21-060-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(437, 'PESA, MARCO O.', '15-011', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(438, 'PESCADERO, JOHANNA', '21-131-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(439, 'PESIAO, MANRICO', '18-237-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(440, 'PETRASANTA, MARCO QUINITA', '21-118-A', 'AGENCY', 'CAVITE', '003', 'LOGISTICS', 'MOH'),
(441, 'PIAD, AARON BERNARD LARGADAS', '20-010-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(442, 'PIAMONTE, JOMARIE MARASIGAN', '22-020-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(443, 'PIDO, FRANTZ ALDRIN V.', '21-018', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(444, 'PLATON, ANGELO P.', '15-012', 'DIRECT', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(445, 'POLERO, ROLANDO', '21-190-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(446, 'PORCA, LEBERATO R.', '08-105', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(447, 'PRADO, TOMMY G.', '15-030', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(448, 'PRINCIPE, JEFFERSON L.', '20-023', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(449, 'QUARTEROS, BARRY JET ALFON', '22-019-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(450, 'QUIATCHON, CRISOSTOMO L.', '11-019', 'DIRECT', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(451, 'QUIGTAR, MICHAEL G.', '19-050', 'DIRECT', 'LAGUNA', '001', 'ENGINEERING', 'MOH'),
(452, 'QUITON, ANGELA JACHELLE M.', '12-010', 'DIRECT', 'LAGUNA', '001', 'ACCOUNTING', 'ADM'),
(453, 'RACAL, JENNIFER M.', '19-017', 'DIRECT', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(454, 'RAMBOYONG, REY Q.', '09-001', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(455, 'RAMOS, EDUARD A.', '14-008', 'DIRECT', 'FPIP', '005', 'MANUFACTURING PLANNING', 'ADM'),
(456, 'RAMOS, GILBERT S.', '18-021', 'DIRECT', 'CAVITE', '003', 'LOGISTICS', 'MOH'),
(457, 'RAMOS, LALAINE G.', '16-027', 'DIRECT', 'LAGUNA', '001', 'PURCHASING', 'ADM'),
(458, 'RAMOS, RIZZA M.', '05-090', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(459, 'RAMOS, RODERICK B.', '02-630', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(460, 'RANSUYO, RIC RYAN RAZALAN', '21-073-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(461, 'RAYMUNDO JR., NORBERTO SOLMIANO', '21-182-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(462, 'RECTO, WINNE LOU MONTEREY', '21-148-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(463, 'REFORMADO, WILMAR', '21-103-A', 'AGENCY', 'LAGUNA', '001', 'PURCHASING', 'ADM'),
(464, 'REGIDOR, MIKE LEO M.', '19-054', 'DIRECT', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(465, 'REGIDOR, ROGER P.', '99-185', 'DIRECT', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(466, 'REGONDOLA, RHEAGENE L.', '10-036', 'DIRECT', 'LIMA', '004', 'SALES', 'ADM'),
(467, 'REJOSO JR., JAIME C.', '17-041', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(468, 'REJOTO, JOHN MERCADO', '21-062-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(469, 'RELLORA, JUNMAR A.', '17-012', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(470, 'REMOROZA, REX O.', '00-194', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(471, 'REYES, GEROLD E.', '09-024', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(472, 'REYES, JIMWELL V.', '17-052', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(473, 'REYES, MARK ARVIN M.', '18-064', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(474, 'REYES, MARK RYELL PANCHO', '21-183-A', 'AGENCY', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(475, 'RILLERA, CARLO D.', '18-014', 'DIRECT', 'FPIP', '005', 'PRODUCTION', 'MOH'),
(476, 'ROBERTO, GREGGY', '21-188-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(477, 'ROBRIGADO, RICHARD N.', '14-017', 'DIRECT', 'LAGUNA', '001', 'DESIGN AND TECHNOLOGY', 'ADM'),
(478, 'ROCHA, JERICK V.', '17-013', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(479, 'RODELAS, MARK JHONE KEVIN', '21-035-A', 'AGENCY', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(480, 'RODRIGUEZ, NILDA ABELLO', '16-010-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(481, 'RONCALES, JENNIFER', '21-004-A', 'AGENCY', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(482, 'ROYALES, NEIL R.', '14-018', 'DIRECT', 'LIMA', '004', 'MANUFACTURING ENGINEERING', 'MOH'),
(483, 'SABLAN, BON DEXTER UNTALAN', '21-066-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(484, 'SACOPON, BOYET F.', '21-012', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(485, 'SALANGA, MARK JAMES TARECTECAN', '21-078-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(486, 'SALAZAR, JOSSA G.', '07-002', 'DIRECT', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(487, 'SALAZAR, REXNIER', '17-096-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(488, 'SALES, JAY AL', '21-106-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(489, 'SALVAGO, MARY GRACE A.', '19-019', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(490, 'SAMBAYON, JUNDIL S.', '17-050', 'DIRECT', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(491, 'SAN JOSE, DYNA FE CABAHUG', '19-123-A', 'AGENCY', 'LIMA', '004', 'GENERAL AFFAIRS', 'ADM'),
(492, 'SANDOVAL, RAY MARC', '20-050-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(493, 'SANGALANG, DARYLL ALVAREZ', '21-176-A', 'AGENCY', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(494, 'SANTIAGO, JHANINE S.', '19-011', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(495, 'SANTOS, EBINIZER M.', '17-049', 'DIRECT', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(496, 'SARMIENTO, ALDWIN T.', '20-028', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(497, 'SARMIENTO, JAIME B., JR.', '11-023', 'DIRECT', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(498, 'SARMIENTO, JUDY ANN B.', '18-045', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(499, 'SAYAT, DENNIS KRISTIAN', '21-128-A', 'AGENCY', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(500, 'SAZON, GUILLER S.', '21-036', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(501, 'SEGUENZA, JAYSON N.', '19-013', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING ENGINEERING', 'MOH'),
(502, 'SELDA, VICTOR', '19-093-A', 'AGENCY', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(503, 'SERDENA, LEO', '21-113-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(504, 'SILANG, MARINEL D.', '21-003', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(505, 'SILVA, JEMUEL KALAW', '21-063-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(506, 'SILVA, RYAN G.', '19-059', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(507, 'SIMONDAC, VLADIMIR O.', '17-002', 'DIRECT', 'LAGUNA', '001', 'IMS', 'ADM'),
(508, 'SOBERANO, MERABEL', '21-026-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(509, 'SOLANO, MARK', '21-027-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(510, 'SOLINAP, IRENEO', '21-105-A', 'AGENCY', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(511, 'SORIANO, NICO BOY F.', '16-001', 'DIRECT', 'NORTH', '006', 'SALES', 'ADM'),
(512, 'SULANGON, JOHN MARK M.', '15-032', 'DIRECT', 'LAGUNA', '001', 'DESIGN AND TECHNOLOGY', 'ADM'),
(513, 'SUMAGUI, DANNA CAMILLE D.', '18-043', 'DIRECT', 'LAGUNA', '001', 'IMS', 'ADM'),
(514, 'SUNGA, JAMIE L.', '21-052', 'DIRECT', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(515, 'SUNGAHID, MAGNOLIA M.', '15-033', 'DIRECT', 'CEBU', '002', 'MANUFACTURING PLANNING', 'ADM'),
(516, 'SUPERABLE, MARJOE CASAPAO', '21-064-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(517, 'SUZUKI, HIROYUKI', '19-063', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(518, 'TAGNIPIS, ALBERT', '18-231-A', 'AGENCY', 'CEBU', '002', 'PRODUCTION', 'MOH'),
(519, 'TALATALA, MIRASOL C.', '14-001', 'DIRECT', 'FPIP', '005', 'MANUFACTURING PLANNING', 'ADM'),
(520, 'TAMALA, CHARILVEN VALE', '19-120-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(521, 'TAMPOC, JEXTER R.', '21-040', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(522, 'TAPALLA, JOSHUA JAY', '21-115-A', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH'),
(523, 'TAPAY, DENNIS R.', '00-174', 'DIRECT', 'LIMA', '004', 'DESIGN AND TECHNOLOGY', 'ADM'),
(524, 'TAPAY, JOHN RONETH C.', '16-011', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING ENGINEERING', 'MOH'),
(525, 'TAPIRE, ARLENE A.', '18-005', 'DIRECT', 'LIMA', '004', 'MANUFACTURING PLANNING', 'ADM'),
(526, 'TEC, BENEDICT MANGUIAT', '21-071-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(527, 'TECSON, ANDREALYN', '20-019', 'DIRECT', 'LAGUNA', '001', 'SALES', 'ADM'),
(528, 'TENOSO, REYNANTE V.', '03-150', 'DIRECT', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(529, 'TERAZA, JOEL LEONA', '20-052-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(530, 'TIGCAL, JOHN EDIL CHRIST C.', '20-007', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(531, 'TIQUIS, JELICA RENEY A.', '19-002', 'DIRECT', 'FPIP', '005', 'MANUFACTURING PLANNING', 'ADM'),
(532, 'TOLENTINO, EDWIN D.', '99-254', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(533, 'TOLENTINO, GIL JR. N.', '19-058', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(534, 'TOLENTINO, JANE ERICA', '18-031-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(535, 'TOLENTINO, JARIE ROSE', '14-38-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(536, 'TOMBOC, DINA FE', '18-147-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(537, 'TOTING, PAMELA B.', '18-030', 'DIRECT', 'CAVITE', '003', 'MANUFACTURING PLANNING', 'ADM'),
(538, 'TUAZON, SEAN JULIUS PENA', '21-045-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(539, 'TUIZA, JECILLE', '17-092-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(540, 'TUIZA, ROBIN PRESNEDI', '22-009-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(541, 'TUSI, NOREA MAE G.', '21-007', 'DIRECT', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(542, 'UBALDE, GEOFREY EMMANUAL DULAY', '21-048-A', 'AGENCY', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(543, 'UBAY, MARY GRACE B.', '21-008', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(544, 'UMALI, ARLENE JOY MARTIN', '22-015-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(545, 'UMALI, CRISTOPHER F.', '19-014', 'DIRECT', 'LAGUNA', '001', 'PURCHASING', 'ADM'),
(546, 'UMANDAL, ARJAY G.', '11-012', 'DIRECT', 'LAGUNA', '001', 'DESIGN AND TECHNOLOGY', 'ADM'),
(547, 'UMEREZ, JOEL LIOBIT', '21-122-A', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(548, 'UNERA, ANTHONY A.', '20-013', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(549, 'URA, FUMIYA', '20-018', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(550, 'URTEZUELA, JEFREY MAQUILAN', '19-024-A', 'AGENCY', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(551, 'UWAY, BIENVENIDO M.', '08-106', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(552, 'VERGARA, ADRIAN MIGUEL A.', '17-028', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(553, 'VERGARA, DANILO L.', '19-061', 'DIRECT', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(554, 'VERGARA, JAYSON M.', '20-010', 'DIRECT', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(555, 'VILLANUEVA, JOEMAR V.', '21-022', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(556, 'VILLANUEVA, JOHN ADRIAN T.', '18-065', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING ENGINEERING', 'MOH');
INSERT INTO `tbl_employee` (`reg_id`, `emp_name`, `emp_id`, `emp_type`, `emp_location`, `loc_code`, `department`, `expensetype`) VALUES
(557, 'VILLANUEVA, LENARD KIM', '21-024-A', 'AGENCY', 'CEBU', '002', 'QUALITY ASSURANCE', 'MOH'),
(558, 'VILLANUEVA, NENE A.', '20-005', 'DIRECT', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(559, 'VILLANUEVA, RUSSELL P.', '17-014', 'DIRECT', 'LAGUNA', '001', 'SALES', 'ADM'),
(560, 'VILLAPANDO, VICMONROE D.', '19-056', 'DIRECT', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(561, 'VILLARUEL, DAVE', '19-100-A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(562, 'VINAS, GARRY S.', '09-022', 'DIRECT', 'LAGUNA', '001', 'ENGINEERING', 'MOH'),
(563, 'VISDA, JONNEL', '20-035-A', 'AGENCY', 'LIMA', '004', 'QUALITY ASSURANCE', 'MOH'),
(564, 'VISTRO, LAARNI C.', '08-024', 'DIRECT', 'LAGUNA', '001', 'ACCOUNTING', 'ADM'),
(565, 'VITERBO, MARY ANN D.', '18-003', 'DIRECT', 'LIMA', '004', 'PURCHASING', 'ADM'),
(566, 'VIVAS, DARWIN B.', '17-008', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(567, 'WAGAN, REY WALTER D.', '13-009', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(568, 'YABYABIN, CZARINAH P.', '21-028', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(569, 'YADAO, RONALD M.', '18-010', 'DIRECT', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(570, 'YAGI, SEIGO', '15-002', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(571, 'YSMAEL, MARIA LOU FATIMA S.', '19-040', 'DIRECT', 'CAVITE', '003', 'SALES', 'ADM'),
(576, 'OTHERS - ADM', '0000-00', '-', 'LAGUNA', '001', 'OTHERS-ADM', 'ADM'),
(577, 'OTHERS - MOH', '0000-00', '-', 'LAGUNA', '001', 'OTHERS-MOH', 'MOH'),
(578, 'PAGATPAT, NOEL', '17-02-025', 'DIRECT', 'LAGUNA', '001', 'INFORMATION TECHNOLOGY', 'ADM'),
(579, 'YAGI, PLDT - MR SEIGO INTERNET', '0271793251', '', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(580, 'INNOVE , MR YAGI', '876737840', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(581, 'BUSQUIT, ROGER', 'NO_ID_01', 'DIRECT', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(582, 'UMALI, EDSEL ANCHOREZ', 'NO_ID_02', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(583, 'ARGONCILLO, JOVERTH L.', 'NO_ID_03', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(584, 'FORTICH, FRANCIS A.', 'NO_ID_04', 'DIRECT', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(585, 'ARRIOLA, ARSENIO', '03', 'AGENCY', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(586, 'BUENSALIDA, SHERWIN', 'KPI-987', 'AGENCY', 'LIMA', '004', 'LOGISTICS', 'MOH'),
(587, 'ORUGA, RICHARD', '003', 'AGENCY', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(588, 'SALONGA, JOHN PAUL', 'KPI0000943', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(589, 'MORALES, JOANA MARIE', '22-006', 'DIRECT', 'LAGUNA', '001', 'ACCOUNTING', 'ADM'),
(590, 'IMPERIAL, CRIS', '22-01A', 'AGENCY', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(591, '., MERALCO', '001', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(592, '., MERALCO', '005', 'DIRECT', 'FPIP', '005', 'QUALITY ASSURANCE', 'MOH'),
(593, 'PALUPIT, NELSON', '22-033', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(594, 'BELLEN, RUEL', '1054', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(595, 'ANDALES, ARNOLD', '22-1058A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(596, 'JAYSON, DELA CRUZ', '22-039-A', 'AGENCY', 'LAGUNA', '001', 'IMS', 'ADM'),
(597, 'ICIES, FLORES', '22-033', 'DIRECT', 'CEBU', '002', 'MANUFACTURING PLANNING', 'ADM'),
(598, 'SINDAO, GILBERT', '22-059-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(599, 'CONTRERAS, AIRENE', '22-022', 'DIRECT', 'LAGUNA', '001', 'ACCOUNTING', 'ADM'),
(600, 'SERIOSO, MICHAEL', '22-897', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(601, 'PIZARRA, LOUBEN', '22-033A', 'AGENCY', 'LAGUNA', '001', 'GENERAL AFFAIRS', 'ADM'),
(603, 'PERIGRIN, REY JOEMAR', 'M10017', 'AGENCY', 'LAGUNA', '001', 'WAREHOUSE', 'MOH'),
(604, 'LEONAR, HAROLD', '22-1418-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(605, 'TEDRIA, ALLAN JAYSON', '1036-A', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(606, 'BONCALOS, MARIA CECILIA', '22-029', 'DIRECT', 'LAGUNA', '001', 'MANUFACTURING PLANNING', 'ADM'),
(607, 'NARVACAN, APPLE ASHLEY S.', '23-002', 'DIRECT', 'LAGUNA', '001', 'ACCOUNTING', 'ADM'),
(608, 'RUADERA, MICHAEL', 'LKP-10011', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(609, 'OBRADOR, NOLLIE', '22-001A', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(610, 'ISHII, KOHEI', '22-027', 'DIRECT', 'LAGUNA', '001', 'MANAGEMENT', 'ADM'),
(611, 'MONICA, PORTO', '23-001', 'DIRECT', 'LAGUNA', '001', 'ACCOUNTING', 'ADM'),
(612, 'IAN JOY, BENOSA', 'KPI00-1028', 'AGENCY', 'LAGUNA', '001', 'LOGISTICS', 'MOH'),
(613, 'CUETO, ERECA', '22-028', 'DIRECT', 'LIMA', '004', 'GENERAL AFFAIRS', 'ADM'),
(614, 'SIDLAO, ROB JEOMAR', '22-1002', 'AGENCY', 'LAGUNA', '001', 'QUALITY ASSURANCE', 'MOH'),
(615, 'SAN ANTONIO, RENZ LEE', '23-005', 'DIRECT', 'LAGUNA', '001', 'ENGINEERING', 'MOH'),
(616, 'SAYAS, GIELEN', '22-049', 'DIRECT', 'LIMA', '004', 'PRODUCTION', 'MOH'),
(617, 'ALIMARIO, KIER ', '22-002C', 'DIRECT', 'LAGUNA', '001', 'SALES', 'ADM'),
(618, 'BULGAR, MARY ANN', '23-001-D', 'AGENCY', 'LAGUNA', '001', 'PRODUCTION', 'MOH'),
(619, 'SAN BUENAVENTURA, ROSE ANN', 'KPI000974', 'AGENCY', 'LIMA', '004', 'WAREHOUSE', 'MOH');

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

--
-- Table structure for table `tbl_history`
--

CREATE TABLE `tbl_history` (
  `id` int(11) NOT NULL,
  `trans_branch` varchar(50) NOT NULL,
  `cnum` varchar(250) NOT NULL,
  `ca_cnum` varchar(250) NOT NULL,
  `typee` varchar(250) NOT NULL,
  `remarks` varchar(250) NOT NULL,
  `amount` varchar(250) NOT NULL,
  `transactedby` varchar(250) NOT NULL,
  `datetimee` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_increments`
--

CREATE TABLE `tbl_increments` (
  `inc_id` int(11) NOT NULL,
  `type` varchar(250) NOT NULL,
  `num` varchar(150) NOT NULL,
  `today_month` varchar(250) NOT NULL,
  `month_stat` varchar(250) NOT NULL,
  `status` varchar(250) NOT NULL,
  `trans_branch` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_increments`
--

INSERT INTO `tbl_increments` (`inc_id`, `type`, `num`, `today_month`, `month_stat`, `status`, `trans_branch`) VALUES
(1, 'fiscal', '28', '', '', 'Active', 'superflex'),
(34, 'all', '0', 'June', 'OPEN', 'Active', 'superflex');

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

--
-- Table structure for table `tbl_report`
--

CREATE TABLE `tbl_report` (
  `idd` int(11) NOT NULL,
  `trans_branch` varchar(50) NOT NULL,
  `ctrl_num` varchar(250) NOT NULL,
  `datee` varchar(250) NOT NULL,
  `accname` varchar(250) NOT NULL,
  `typee` varchar(250) NOT NULL,
  `location` varchar(250) NOT NULL,
  `payee` varchar(500) NOT NULL,
  `descirption` varchar(800) NOT NULL,
  `charged` varchar(250) NOT NULL,
  `credit` varchar(250) NOT NULL,
  `amount` varchar(250) NOT NULL,
  `balance` varchar(150) NOT NULL,
  `starting_amount` varchar(250) NOT NULL,
  `status` varchar(250) NOT NULL,
  `closingref` varchar(250) NOT NULL,
  `dateclosed` varchar(250) NOT NULL,
  `trial` varchar(250) NOT NULL,
  `semi` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tbl_voucher`
--

CREATE TABLE `tbl_voucher` (
  `voucher_id` int(11) NOT NULL,
  `trans_branch` varchar(50) NOT NULL,
  `ctrl_num` varchar(250) NOT NULL,
  `reqname` varchar(250) NOT NULL,
  `department` varchar(250) NOT NULL,
  `location` varchar(250) NOT NULL,
  `loc_code` varchar(250) NOT NULL,
  `type` varchar(250) NOT NULL,
  `tdate` varchar(250) NOT NULL,
  `ttime` varchar(250) NOT NULL,
  `total` varchar(250) NOT NULL,
  `remarks` varchar(250) NOT NULL,
  `status` varchar(250) NOT NULL,
  `cashid` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tbl_voucherdetails`
--

CREATE TABLE `tbl_voucherdetails` (
  `tbl_vd` int(11) NOT NULL,
  `trans_branch` varchar(50) NOT NULL,
  `ctrl_num` varchar(250) NOT NULL,
  `charged_dept` varchar(250) NOT NULL,
  `acctype` varchar(250) NOT NULL,
  `particular` varchar(500) NOT NULL,
  `amount` varchar(250) NOT NULL,
  `balance` varchar(250) NOT NULL,
  `type` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `sp_holidays`
--
ALTER TABLE `sp_holidays`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_accexpense`
--
ALTER TABLE `tbl_accexpense`
  ADD PRIMARY KEY (`expense_id`);

--
-- Indexes for table `tbl_cadetails`
--
ALTER TABLE `tbl_cadetails`
  ADD PRIMARY KEY (`ca_id`);

--
-- Indexes for table `tbl_cashadvance`
--
ALTER TABLE `tbl_cashadvance`
  ADD PRIMARY KEY (`cash_id`);

--
-- Indexes for table `tbl_daily`
--
ALTER TABLE `tbl_daily`
  ADD PRIMARY KEY (`d_id`);

--
-- Indexes for table `tbl_employee`
--
ALTER TABLE `tbl_employee`
  ADD PRIMARY KEY (`reg_id`);

--
-- Indexes for table `tbl_history`
--
ALTER TABLE `tbl_history`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_increments`
--
ALTER TABLE `tbl_increments`
  ADD PRIMARY KEY (`inc_id`);

--
-- Indexes for table `tbl_report`
--
ALTER TABLE `tbl_report`
  ADD PRIMARY KEY (`idd`);

--
-- Indexes for table `tbl_voucher`
--
ALTER TABLE `tbl_voucher`
  ADD PRIMARY KEY (`voucher_id`);

--
-- Indexes for table `tbl_voucherdetails`
--
ALTER TABLE `tbl_voucherdetails`
  ADD PRIMARY KEY (`tbl_vd`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `sp_holidays`
--
ALTER TABLE `sp_holidays`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=202;

--
-- AUTO_INCREMENT for table `tbl_accexpense`
--
ALTER TABLE `tbl_accexpense`
  MODIFY `expense_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116;

--
-- AUTO_INCREMENT for table `tbl_cadetails`
--
ALTER TABLE `tbl_cadetails`
  MODIFY `ca_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_cashadvance`
--
ALTER TABLE `tbl_cashadvance`
  MODIFY `cash_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_daily`
--
ALTER TABLE `tbl_daily`
  MODIFY `d_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_employee`
--
ALTER TABLE `tbl_employee`
  MODIFY `reg_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=620;

--
-- AUTO_INCREMENT for table `tbl_history`
--
ALTER TABLE `tbl_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_increments`
--
ALTER TABLE `tbl_increments`
  MODIFY `inc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `tbl_report`
--
ALTER TABLE `tbl_report`
  MODIFY `idd` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_voucher`
--
ALTER TABLE `tbl_voucher`
  MODIFY `voucher_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_voucherdetails`
--
ALTER TABLE `tbl_voucherdetails`
  MODIFY `tbl_vd` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

