INSERT INTO `txn_tickets` (`id`, `description`, `entity_id`, `ticket_manager_id`, `start_date`, `end_date`, `closed_date`, `total_hours`, `status_id`, `added_by`, `ticket_ref`, `created_at`, `updated_at`, `ticket_type_id`, `estimate_hours`, `repository`, `remarks`, `ticket_description`, `ticket_member_ids`) VALUES
(9582, 'DATA-SPT-Loewe Arrival Concern checking', NULL, 35, '2022-07-15', '2022-08-08', '2022-08-08', '3.5', 3, 'jlacaba', '2022-1674', '2022-07-15 13:26:59', '2022-08-08 13:05:20', 2, NULL, NULL, NULL, NULL, NULL),
(9583, 'DATA-SPT-Bottega Venetta Arrivals checking', NULL, 35, '2022-07-15', '2022-08-02', '2022-08-02', '3', 3, 'jlacaba', '2022-1675', '2022-07-15 14:08:07', '2022-08-02 12:57:58', 2, NULL, NULL, NULL, NULL, NULL),
(9584, 'IT-Eccom - Out of Office - 2022', NULL, 86, '2022-01-01', '2022-12-31', NULL, '112', 1, 'raisla', '2022-1676', '2022-07-18 06:29:25', '2022-08-30 02:26:21', 4, NULL, NULL, NULL, NULL, NULL),
(9585, 'ERP - PRJ - Batch Transfer Allocation Enhancement', NULL, 26, '2022-07-18', NULL, NULL, '13.5', 1, 'jsfrance', '2022-1677', '2022-07-18 07:23:30', '2022-07-22 08:19:08', 1, NULL, NULL, NULL, NULL, NULL),
(9586, 'DATA-SPT-Fused Arrival Summary Report - Voided PO', NULL, 35, '2022-07-18', '2022-08-08', '2022-08-08', NULL, 3, 'jlacaba', '2022-1678', '2022-07-18 10:10:14', '2022-08-08 13:07:06', 2, NULL, NULL, 'did not use', NULL, NULL),
(9587, 'ERP - SPT - SLCI Warehouse Floating Allocated Quantities', NULL, 11, '2022-07-18', '2022-07-18', '2022-07-18', '2.5', 3, 'rgomez', '2022-1679', '2022-07-18 10:40:04', '2022-08-16 04:29:36', 2, NULL, NULL, NULL, NULL, NULL),
(9588, 'DATA - SPT - SSI 2022 QS SOB Validation Concern', NULL, 35, '2022-07-18', '2022-09-20', '2022-09-20', '41.5', 3, 'jlacaba', '2022-1680', '2022-07-18 12:29:41', '2022-09-05 11:26:53', 2, NULL, NULL, NULL, NULL, NULL),
(9589, 'Dept Meeting', NULL, 82, '2022-07-19', NULL, NULL, '18.25', 1, 'dmvillanueva', '2022-1681', '2022-07-19 03:10:21', '2022-09-02 03:17:37', 2, NULL, NULL, NULL, NULL, NULL),
(9590, 'ITD-FSRI-EBG-Payless UX Site Audit Fixes', NULL, 71, '2022-06-16', NULL, NULL, '21.25', 1, 'casenci', '2022-1682', '2022-07-19 11:44:33', '2022-08-24 14:13:47', 1, NULL, NULL, NULL, NULL, NULL),
(9591, 'DATA-SPT-FSRI Automated Masterfile Onhand Extraction updates', NULL, 35, '2022-07-20', '2022-08-02', '2022-08-02', '0.25', 3, 'jlacaba', '2022-1683', '2022-07-20 12:10:09', '2022-08-02 12:57:15', 2, NULL, NULL, NULL, NULL, NULL),
(9592, 'ITD-SSIG-GEN-My SSI Life Mobile App Refresh', NULL, 71, '2022-05-10', '2023-01-09', NULL, '147.5', 1, 'casenci', '2022-1684', '2022-07-20 13:40:06', '2022-09-05 00:17:32', 1, NULL, NULL, NULL, NULL, NULL),
(9593, 'ITSysOps - ISCI - 2023 HIPOS and Credit Card Terminal Integration', NULL, 81, '2022-07-18', '2022-12-30', NULL, '1', 1, 'cccalma', '2022-1685', '2022-07-21 08:33:00', '2022-07-28 07:33:53', 2, NULL, NULL, NULL, NULL, NULL),
(9594, 'ERP - SPT - Generation of Master Hierarchy for SSI Merch', NULL, 11, '2022-07-04', '2022-07-05', '2022-07-05', '1.5', 3, 'rgomez', '2022-1686', '2022-07-21 08:45:35', '2022-08-16 04:29:16', 2, NULL, NULL, NULL, NULL, NULL),
(9595, 'DATA - SPT - IS Group Sales Polling to QDLS Concern', NULL, 35, '2022-07-21', NULL, NULL, '1', 3, 'malejandro', '2022-1687', '2022-07-21 09:59:29', '2022-08-08 13:03:00', 2, NULL, NULL, NULL, NULL, NULL),
(9596, 'DATA - SPT - Loewe End June 2022 Inventory Concern', NULL, 35, '2022-07-21', '2022-08-02', '2022-08-02', '15.5', 3, 'malejandro', '2022-1688', '2022-07-21 10:00:27', '2022-08-02 12:57:35', 2, NULL, NULL, NULL, NULL, NULL),
(9597, 'ERP - PRJ - MPC Make-up/Break-up Module Enhancement ', NULL, 11, '2022-07-22', '2022-07-28', '2022-07-28', '40', 3, 'rgomez', '2022-1689', '2022-07-22 08:06:30', '2022-08-16 04:28:49', 1, NULL, NULL, NULL, NULL, NULL),
(9598, 'ERP - SPT - AS400 Auto FTP', NULL, 11, '2022-07-22', '2022-09-02', '2022-09-02', '103', 3, 'rgomez', '2022-1690', '2022-07-22 08:08:15', '2022-09-06 00:38:38', 2, NULL, NULL, NULL, NULL, NULL),
(9599, 'ERP - SPT - Make-Up Extraction for RMSI ', NULL, 11, '2022-07-22', '2022-07-22', '2022-07-22', '3', 3, 'rgomez', '2022-1691', '2022-07-22 08:10:15', '2022-08-16 04:28:21', 2, NULL, NULL, NULL, NULL, NULL),
(9600, 'DATA - SPT - Pottery Barn Inventory - Missing cost prices', NULL, 35, '2022-07-22', '2022-08-08', '2022-08-08', '1', 3, 'malejandro', '2022-1692', '2022-07-22 09:42:00', '2022-08-08 13:03:46', 2, NULL, NULL, NULL, NULL, NULL),
(9601, 'DATA - SPT - Gap Transfer Data Concern', NULL, 35, '2022-07-25', '2022-08-08', '2022-08-08', '2', 3, 'malejandro', '2022-1693', '2022-07-25 10:05:45', '2022-08-08 13:04:50', 2, NULL, NULL, NULL, NULL, NULL),
(9602, 'ERP - SPT - Zara Floating POs ', NULL, 11, '2022-07-25', '2022-07-25', '2022-07-25', '2.5', 3, 'rgomez', '2022-1694', '2022-07-25 10:27:28', '2022-07-27 10:52:00', 2, NULL, NULL, NULL, NULL, NULL),
(9603, 'ERP - SPT - SLCI MTS Printing Issue', NULL, 11, '2022-07-25', '2022-07-25', '2022-07-25', '2', 3, 'rgomez', '2022-1695', '2022-07-25 10:29:45', '2022-07-25 10:30:57', 2, NULL, NULL, NULL, NULL, NULL),
(9604, 'BLD - SPT - Simple Mall Sending - Text File is Not Generated for Some POS', NULL, 13, '2022-07-25', '2022-09-29', '2022-09-29', '14.75', 3, 'jquijano', '2022-1696', '2022-07-25 11:18:40', '2022-08-05 12:32:13', 2, NULL, NULL, NULL, NULL, NULL),
(9605, 'DATA-SPT-R&D XML Extraction using Pentaho Stax Input Stream ', NULL, 35, '2022-07-25', '2022-08-08', '2022-08-08', '10.5', 3, 'jlacaba', '2022-1697', '2022-07-25 12:34:48', '2022-08-08 13:05:06', 2, NULL, NULL, NULL, NULL, NULL),
(9606, 'DATA - SPT - Lacoste JDA vs Pentaho Sales Concern', NULL, 35, '2022-07-26', '2022-08-08', NULL, '1.25', 3, 'malejandro', '2022-1698', '2022-07-26 09:10:37', '2022-08-08 13:02:44', 2, NULL, NULL, NULL, NULL, NULL),
(9607, 'ERP - SPT - Max&Co Mass Update of Style Code', NULL, 11, '2022-07-26', '2022-07-26', '2022-07-26', '7', 3, 'rgomez', '2022-1699', '2022-07-26 10:37:07', '2022-08-16 04:28:02', 2, NULL, NULL, NULL, NULL, NULL),
(9608, 'BLD - SPT - HiPOS Mall Sending - Transaction Count for Daily and Hourly Sales is Not Tally', NULL, 13, '2022-07-27', '2022-07-29', '2022-07-29', '5.5', 3, 'jquijano', '2022-1700', '2022-07-26 14:30:04', '2022-07-29 12:43:51', 2, NULL, NULL, NULL, NULL, NULL),
(9609, 'DATA - SPT - ISCI Copy Cost to JDA Concern', NULL, 35, '2022-07-27', '2022-09-20', NULL, '2', 3, 'malejandro', '2022-1701', '2022-07-27 09:37:47', '2022-07-27 09:38:13', 2, NULL, NULL, NULL, NULL, NULL),
(9610, 'DATA-SPT-Archiving of the POS reader data', NULL, 35, '2022-07-27', '2022-09-20', NULL, '5.5', 3, 'jlacaba', '2022-1702', '2022-07-27 12:56:13', '2022-08-17 09:50:12', 2, NULL, NULL, NULL, NULL, NULL),
(9611, 'ITSysOps - ISCI - 2022 eCommerce Warehouse Transfer', NULL, 81, '2022-07-28', '2022-11-30', NULL, '142.25', 3, 'cccalma', '2022-1703', '2022-07-28 07:29:06', '2022-09-06 10:34:53', 2, NULL, NULL, NULL, NULL, NULL),
(9612, 'DATA-SPT-SPT-HIPOS PB Extraction concern', NULL, 35, '2022-07-28', '2022-09-20', NULL, '7.5', 3, 'jlacaba', '2022-1704', '2022-07-28 08:28:50', '2022-07-28 09:54:37', 2, NULL, NULL, NULL, NULL, NULL),
(9613, 'ERP - SPT - Zara Duplicate PO Receiver Clean Up ', NULL, 11, '2022-07-28', '2022-07-28', '2022-07-28', '2.5', 3, 'rgomez', '2022-1705', '2022-07-28 08:32:56', '2022-08-16 03:23:27', 2, NULL, NULL, NULL, NULL, NULL),
(9614, 'DATA-SPT-RMSI UPC Concerns', NULL, 35, '2022-07-28', '2023-02-14', '2023-02-14', '59.75', 3, 'jlacaba', '2022-1706', '2022-07-28 08:33:27', '2022-08-10 11:00:46', 2, NULL, NULL, NULL, NULL, NULL),
(9615, 'BLD-PRJ-IT Blueyonder API hub.', NULL, 27, NULL, NULL, NULL, '211.75', 1, 'jgonzales', '2022-1707', '2022-07-28 15:40:47', '2022-08-26 14:13:22', 1, NULL, NULL, NULL, NULL, NULL),
(9616, 'ERP - SPT - BV Style Issue in Price Event Creation', NULL, 11, '2022-07-29', '2022-07-29', '2022-07-29', '2.5', 3, 'rgomez', '2022-1708', '2022-07-29 08:16:17', '2022-08-16 03:20:05', 2, NULL, NULL, NULL, NULL, NULL),
(9617, 'ERP - SPT - Brand Prefix for Deborah Lippmann, Diptyque, Mario Badescu ', NULL, 11, '2022-07-29', '2022-07-29', '2022-07-29', '1', 3, 'rgomez', '2022-1709', '2022-07-29 08:24:15', '2022-08-09 01:21:19', 2, NULL, NULL, NULL, NULL, NULL),
(9618, 'BLD - SPT - ICS - Application Has Error When Installing in the User', NULL, 13, '2022-07-29', '2022-09-19', '2022-09-19', '2.5', 3, 'jquijano', '2022-1710', '2022-07-29 12:56:28', '2022-08-09 11:53:44', 2, NULL, NULL, NULL, NULL, NULL),
(9619, 'BLD - SPT - Hamleys Sales Franchise Report - Changed the Database Where the Web Application is Extracting Data', NULL, 13, '2022-07-29', '2022-08-15', '2022-08-15', '30.5', 3, 'jquijano', '2022-1711', '2022-07-29 13:17:21', '2022-08-15 12:49:52', 2, NULL, NULL, NULL, NULL, NULL),
(9620, 'ITD-GEN-INFRA-Store Renovation Lacoste Magnolia', NULL, 1, '2022-07-20', '2022-09-30', NULL, '3', 1, 'flopez', '2022-1712', '2022-08-01 04:39:13', '2022-08-01 05:21:21', 1, NULL, NULL, NULL, NULL, NULL),
(9621, 'ERP - PRJ - Facility for Mass Update of Department for RMSI', NULL, 11, '2022-08-01', '2022-08-05', '2022-08-05', '41.5', 3, 'rgomez', '2022-1713', '2022-08-01 10:00:45', '2022-08-09 01:17:56', 1, NULL, NULL, NULL, NULL, NULL),
(9622, 'ERP - SPT - Mass Update of Extended Class of Clarks Items', NULL, 11, '2022-08-01', '2022-08-01', '2022-08-01', NULL, 3, 'rgomez', '2022-1714', '2022-08-01 10:29:50', '2022-08-01 10:29:50', 2, NULL, NULL, NULL, NULL, NULL),
(9623, 'BLD - SPT - Barcode Fused - Concern in Tags, Has Different Barcode Output', NULL, 13, '2022-08-02', '2022-08-04', '2022-08-04', '8.25', 3, 'jquijano', '2022-1715', '2022-08-02 12:13:05', '2022-08-04 11:47:53', 2, NULL, NULL, NULL, NULL, NULL),
(9624, 'DATA-SPT-ISWI-HIPOS For Strad', NULL, 35, '2022-08-03', '2022-09-20', NULL, '15.5', 3, 'jlacaba', '2022-1716', '2022-08-03 12:32:57', '2022-09-02 09:54:09', 2, NULL, NULL, NULL, NULL, NULL),
(9625, 'BLD - SPT - Omnirio - User Requested to Delete JSON File for July 31', NULL, 13, '2022-08-03', NULL, NULL, '4.25', 6, 'jquijano', '2022-1717', '2022-08-03 12:34:30', '2022-08-05 12:29:50', 2, NULL, NULL, NULL, NULL, NULL),
(9626, 'BLD - SPT - Sales Audit Parser - The Data is Not Tally', NULL, 13, '2022-08-03', '2022-08-04', '2022-08-04', '2.5', 3, 'jquijano', '2022-1718', '2022-08-03 12:49:55', '2022-08-04 12:50:53', 2, NULL, NULL, NULL, NULL, NULL),
(9627, 'BLD - SPT - CMT - Create New User', NULL, 13, '2022-08-03', '2022-08-03', '2022-08-03', '0.25', 3, 'jquijano', '2022-1719', '2022-08-03 12:57:49', '2022-08-04 12:51:20', 2, NULL, NULL, NULL, NULL, NULL),
(9628, 'BLD - SPT - ICS -  Error When Updating the Masterfile', NULL, 13, '2022-08-03', '2022-08-08', '2022-08-08', '2.25', 3, 'jquijano', '2022-1720', '2022-08-03 13:05:26', '2022-08-08 10:54:27', 2, NULL, NULL, NULL, NULL, NULL),
(9629, 'Warehouse Support', NULL, 82, '2022-08-04', NULL, NULL, '13.25', 1, 'dmvillanueva', '2022-1721', '2022-08-04 07:17:22', '2022-08-15 08:13:46', 2, NULL, NULL, NULL, NULL, NULL),
(9630, 'ERP - SPT - Mass UPC Update Facility for RMSI', NULL, 11, '2022-08-04', '2022-08-04', '2022-08-04', '4', 3, 'rgomez', '2022-1722', '2022-08-04 09:38:36', '2022-08-04 09:43:59', 2, NULL, NULL, NULL, NULL, NULL),
(9631, 'DATA-SPT-Fused Sale Transaction Types report creation', NULL, 35, '2022-08-04', '2022-08-16', '2022-08-16', '1.5', 3, 'jlacaba', '2022-1723', '2022-08-04 11:21:37', '2022-08-16 04:20:24', 2, NULL, 'https://drive.google.com/drive/folders/1KrG1iOR8AL74v6IzrgX2mrvJQ6s9W-u2', NULL, NULL, NULL),
(9632, 'APPSPT-SPT-ERIC SUPPORT - August 2022', NULL, 8, '2022-08-01', '2022-08-31', NULL, '13.5', 3, 'aibias', '2022-1724', '2022-08-05 01:48:52', '2022-09-01 01:47:00', 2, NULL, NULL, NULL, NULL, NULL),
(9633, 'APPSPT-SPT-FSRI EWMS SUPPORT - August 2022', NULL, 8, '2022-08-01', '2022-08-31', NULL, '50.75', 3, 'aibias', '2022-1725', '2022-08-05 01:49:37', '2022-09-01 01:47:19', 2, NULL, NULL, NULL, NULL, NULL),
(9634, 'APPSPT-SPT-Item Creation - August 2022', NULL, 8, '2022-08-01', '2022-08-31', NULL, '27.5', 3, 'aibias', '2022-1726', '2022-08-05 01:54:01', '2022-09-01 01:46:08', 2, NULL, NULL, NULL, NULL, NULL),
(9635, 'APPSPT-SPT-NAV SUPPORT - August 2022', NULL, 8, '2022-08-01', '2022-08-31', NULL, '9.75', 3, 'aibias', '2022-1727', '2022-08-05 01:54:33', '2022-09-01 01:47:41', 2, NULL, NULL, NULL, NULL, NULL),
(9636, 'APPSPT-SPT-PENTAHO MUJI SUPPORT - August 2022', NULL, 8, '2022-08-01', '2022-08-31', NULL, '29', 3, 'aibias', '2022-1728', '2022-08-05 01:55:15', '2022-09-01 01:47:55', 2, NULL, NULL, NULL, NULL, NULL),
(9637, 'APPSPT-SPT-PENTAHO SUPPORT - August 2022', NULL, 8, '2022-08-01', '2022-08-31', NULL, '83.25', 3, 'aibias', '2022-1729', '2022-08-05 01:55:39', '2022-09-01 01:48:13', 2, NULL, NULL, NULL, NULL, NULL),
(9638, 'APPSPT-SPT-QLIKSENSE SUPPORT - August 2022', NULL, 8, '2022-08-01', '2022-08-31', NULL, '7.5', 3, 'aibias', '2022-1730', '2022-08-05 01:56:38', '2022-09-01 01:48:36', 2, NULL, NULL, NULL, NULL, NULL),
(9639, 'ERP - SPT - Inventory Sets / Make Up / Break up', NULL, 11, '2022-08-05', '2022-08-05', '2022-08-05', '3', 3, 'rgomez', '2022-1731', '2022-08-05 10:39:27', '2022-08-05 10:40:40', 2, NULL, NULL, NULL, NULL, NULL),
(9640, 'APPSPT-SPT-PENTAHO-Fused Sales Refresh - August 2022', NULL, 8, '2022-08-01', '2022-08-31', NULL, '6.75', 3, 'yemagnaye', '2022-1732', '2022-08-06 07:30:55', '2022-09-01 01:48:26', 2, NULL, NULL, NULL, NULL, NULL),
(9641, 'EBG WH Support', NULL, 82, NULL, NULL, NULL, '1.5', 1, 'dmvillanueva', '2022-1733', '2022-08-08 05:19:50', '2022-08-08 08:16:08', 2, NULL, NULL, NULL, NULL, NULL),
(9642, 'ERP - PRJ - Transfer Quantity Control for RMSI', NULL, 11, '2022-08-08', '2022-08-12', '2022-08-12', '38', 3, 'rgomez', '2022-1734', '2022-08-08 07:58:56', '2022-08-16 03:23:54', 1, NULL, NULL, NULL, NULL, NULL),
(9643, 'ERP - SPT - PO Creation Issue of Samsonite Merch', NULL, 11, '2022-08-08', '2022-08-08', '2022-08-08', '2', 3, 'rgomez', '2022-1735', '2022-08-08 08:40:53', '2022-08-16 03:15:00', 2, NULL, NULL, NULL, NULL, NULL),
(9644, 'ERP - SPT - Count Uploading Issue of SSI Sys Ops', NULL, 11, '2022-08-08', '2022-08-08', '2022-08-08', '1.5', 3, 'rgomez', '2022-1736', '2022-08-08 08:42:59', '2022-08-16 03:14:37', 2, NULL, NULL, NULL, NULL, NULL),
(9645, 'DATA - SPT - ISRI HiPOS Report', NULL, 35, '2022-08-08', '2022-09-20', NULL, '2', 3, 'malejandro', '2022-1737', '2022-08-08 10:56:51', '2022-08-08 10:58:09', 2, NULL, NULL, NULL, NULL, NULL),
(9646, 'DATA - SPT - ISAI HiPOS Report', NULL, 35, '2022-08-08', '2022-09-20', NULL, '2', 3, 'malejandro', '2022-1738', '2022-08-08 10:57:17', '2022-08-08 10:58:19', 2, NULL, NULL, NULL, NULL, NULL),
(9647, 'BLD - SPT - EWMS - No RIAQ in the Report', NULL, 13, '2022-08-08', '2022-08-12', '2022-08-12', '5.25', 3, 'jquijano', '2022-1739', '2022-08-08 11:15:35', '2022-08-12 12:19:50', 2, NULL, NULL, NULL, NULL, NULL),
(9648, 'BLD - SPT - EWMS - The TL Status is Still on Queue', NULL, 13, '2022-08-09', '2022-08-12', '2022-08-12', '8.75', 3, 'jquijano', '2022-1740', '2022-08-09 11:43:35', '2022-08-16 12:07:15', 2, NULL, NULL, NULL, NULL, NULL),
(9649, 'DATA - SPT - Hamleys XML File Generation', NULL, 35, '2022-08-10', '2022-09-05', '2022-09-05', '3', 3, 'malejandro', '2022-1741', '2022-08-10 09:47:54', '2022-09-05 11:53:42', 2, NULL, NULL, NULL, NULL, NULL),
(9650, 'ERP - SPT - PO Creation by Style Concern of YSL', NULL, 11, '2022-08-10', '2022-08-10', '2022-08-10', '3.5', 3, 'rgomez', '2022-1742', '2022-08-10 10:55:59', '2022-08-11 08:07:50', 2, NULL, NULL, NULL, NULL, NULL),
(9651, 'APPSPT-SPT-PENTAHO SOB 2021-2022 Validation', NULL, 8, '2022-08-10', '2022-12-31', '2023-01-03', '54.75', 3, 'aibias', '2022-1743', '2022-08-10 10:58:49', '2022-08-31 07:07:37', 2, NULL, NULL, NULL, NULL, NULL),
(9652, 'ERP - SPT - Preparation of test data for the training', NULL, 11, '2022-08-10', '2022-08-10', '2022-08-10', '1', 3, 'rgomez', '2022-1744', '2022-08-10 10:58:54', '2022-08-10 10:59:25', 2, NULL, NULL, NULL, NULL, NULL),
(9653, 'ERP - SPT - EOD Backup Issue in PROD3 ', NULL, 11, '2022-08-11', '2022-08-11', '2022-08-11', '3', 3, 'rgomez', '2022-1745', '2022-08-11 08:08:33', '2022-08-16 03:14:20', 2, NULL, NULL, NULL, NULL, NULL),
(9654, 'BLD - SPT - Cyserv Report - Error When Checking the Report', NULL, 13, '2022-08-11', '2022-08-15', '2022-08-15', '4.25', 3, 'jquijano', '2022-1746', '2022-08-11 12:26:37', '2022-08-15 12:37:29', 2, NULL, NULL, NULL, NULL, NULL),
(9655, 'BLD - SPT - Transfer Screen Scrape - Request to Fix the Concerns in Transfer', NULL, 13, '2022-08-11', '2022-09-15', '2022-09-15', '75.5', 3, 'jquijano', '2022-1747', '2022-08-11 12:48:17', '2022-09-07 12:01:39', 2, NULL, NULL, NULL, NULL, NULL),
(9656, 'DATA-SPT-SPT-Brand.com sales concern', NULL, 35, '2022-08-12', '2022-08-26', '2022-08-26', '2.25', 3, 'jlacaba', '2022-1748', '2022-08-12 07:17:51', '2022-08-26 08:09:02', 2, NULL, NULL, NULL, NULL, NULL),
(9657, 'DATA-SPT-TENDAM-4R4 OnePOs Concern', NULL, 35, '2022-08-12', '2022-08-16', '2022-08-16', '1', 3, 'jlacaba', '2022-1749', '2022-08-12 08:07:06', '2022-08-16 04:16:38', 2, NULL, NULL, NULL, NULL, NULL),
(9658, 'DATA - SPT - Zara Mall Sending data Issue', NULL, 35, '2022-08-15', '2022-09-20', NULL, '4', 3, 'malejandro', '2022-1750', '2022-08-15 09:56:11', '2022-08-15 12:40:00', 2, NULL, NULL, NULL, NULL, NULL),
(9659, 'DATA - SPT - Zara Ecom XML Uploading Test', NULL, 35, '2022-08-15', '2022-09-20', NULL, '2', 3, 'malejandro', '2022-1751', '2022-08-15 09:56:44', '2022-08-15 09:59:35', 2, NULL, NULL, NULL, NULL, NULL),
(9660, 'ERP - SPT - WMS Job Errors in JDAPROD2', NULL, 11, '2022-08-15', '2022-08-15', '2022-08-15', '3.5', 3, 'rgomez', '2022-1752', '2022-08-15 10:45:27', '2022-08-15 10:47:53', 2, NULL, NULL, NULL, NULL, NULL),
(9661, 'ERP - SPT - YSL Price Event Creation by Style Issue', NULL, 11, '2022-08-15', '2022-08-15', '2022-08-15', '1', 3, 'rgomez', '2022-1753', '2022-08-15 10:51:07', '2022-08-15 10:51:37', 2, NULL, NULL, NULL, NULL, NULL),
(9662, 'BLD - SPT - HiPOS Mall Sending - Daily and Hourly Data is Not Tally', NULL, 13, '2022-08-15', '2022-08-17', '2022-08-17', '6.75', 3, 'jquijano', '2022-1754', '2022-08-15 12:51:09', '2022-08-17 12:03:13', 2, NULL, NULL, NULL, NULL, NULL),
(9663, 'DATA-SPT-11.33 Server issue', NULL, 35, '2022-08-15', '2022-08-16', '2022-08-16', '0.5', 3, 'jlacaba', '2022-1755', '2022-08-15 13:23:29', '2022-08-16 04:24:06', 2, NULL, NULL, NULL, NULL, NULL),
(9664, 'DATA - SPT - Pottery Barn Per Location Sales Report (By SKU) Concern', NULL, 35, '2022-08-16', '2022-09-20', NULL, '5.25', 3, 'malejandro', '2022-1756', '2022-08-16 09:48:41', '2022-08-17 12:13:35', 2, NULL, NULL, NULL, NULL, NULL),
(9665, 'DATA - SPT - Prada Sales Data Checking JDA Vs Pentaho', NULL, 35, '2022-08-16', '2022-09-05', '2022-09-05', '1', 3, 'malejandro', '2022-1757', '2022-08-16 09:50:37', '2022-09-05 11:54:24', 2, NULL, NULL, NULL, NULL, NULL),
(9666, 'RCC JV Brands FFS POS Reader Delta testing', NULL, 35, '2022-08-16', '2022-09-26', '2022-09-26', '59', 3, 'jlacaba', '2022-1758', '2022-08-16 10:00:22', '2022-09-07 10:59:52', 2, NULL, 'https://drive.google.com/drive/folders/1Jwt0T2qbnNh-iRhRUxkjMAX_ptoot2-6', NULL, NULL, NULL),
(9667, 'DATA-SPT-Data Refresh Model documentation update', NULL, 35, '2022-08-16', '2022-09-20', '2022-09-20', '2', 3, 'jlacaba', '2022-1759', '2022-08-16 10:43:23', '2022-08-16 10:44:33', 2, NULL, NULL, NULL, NULL, NULL),
(9668, 'ERP - SPT - Activation of Transfer Auto-Receive Feature for IS Group -', NULL, 11, '2022-08-16', '2022-09-02', '2022-09-02', '16', 3, 'rgomez', '2022-1760', '2022-08-16 11:02:53', '2022-09-06 00:39:32', 2, NULL, NULL, NULL, NULL, NULL),
(9669, 'ERP - SPT - PB and WE Average Cost Extraction', NULL, 11, '2022-08-16', '2022-08-16', '2022-08-16', '1.5', 3, 'rgomez', '2022-1761', '2022-08-16 11:04:51', '2022-08-16 11:05:32', 2, NULL, NULL, NULL, NULL, NULL),
(9670, 'BLD - SPT - Barcode Fused - Batch Code in the Tags', NULL, 13, '2022-08-16', '2022-08-16', '2022-08-16', '2', 3, 'jquijano', '2022-1762', '2022-08-16 12:11:44', '2022-08-17 11:03:16', 2, NULL, NULL, NULL, NULL, NULL),
(9671, 'ERP - SPT - FSRI Merchandising Training ', NULL, 11, '2022-08-17', '2022-08-31', '2022-08-31', '5', 3, 'rgomez', '2022-1763', '2022-08-17 06:30:23', '2022-08-30 11:54:51', 2, NULL, NULL, NULL, NULL, NULL),
(9672, 'SSI-SYSOPS-CMT-New Access Creation', NULL, 79, '2022-01-01', '2022-12-31', NULL, '0.5', 1, 'ahortega', '2022-1764', '2022-08-17 09:19:10', '2022-08-17 09:20:29', 2, NULL, NULL, NULL, NULL, NULL),
(9673, 'DATA - SPT - RMSI Restructures', NULL, 35, '2022-08-17', '2022-09-20', NULL, '3.5', 3, 'malejandro', '2022-1765', '2022-08-17 09:47:32', '2022-08-17 12:21:58', 2, NULL, NULL, NULL, NULL, NULL),
(9674, 'BLD - SPT - CYSERV Report - The Displayed Data is Incorrect', NULL, 13, '2022-08-17', '2022-08-17', '2022-08-17', '1.5', 3, 'jquijano', '2022-1766', '2022-08-17 11:41:40', '2022-08-18 10:58:27', 2, NULL, NULL, NULL, NULL, NULL),
(9675, 'DATA-SPT-MPC Polling and Price update Concern', NULL, 35, '2022-08-18', '2022-08-26', '2022-08-26', '3', 3, 'jlacaba', '2022-1767', '2022-08-18 07:57:51', '2022-08-26 08:08:02', 2, NULL, NULL, NULL, NULL, NULL),
(9676, 'APPSPT-SPT-INSYS SUPPORT - August 2022', NULL, 8, '2022-08-01', '2022-08-31', NULL, '0.75', 3, 'yemagnaye', '2022-1768', '2022-08-18 08:08:38', '2022-09-01 01:46:44', 2, NULL, NULL, NULL, NULL, NULL),
(9677, 'BLD - SPT - EWMS - Concerns in the Web Application', NULL, 13, '2022-08-18', '2022-08-18', '2022-08-18', '2', 3, 'jquijano', '2022-1769', '2022-08-18 10:59:28', '2022-08-19 11:36:13', 2, NULL, NULL, NULL, NULL, NULL),
(9678, 'DATA-SPT-Cresco Price update concern', NULL, 35, '2022-08-19', '2022-09-05', '2022-09-05', '25.75', 3, 'jlacaba', '2022-1770', '2022-08-19 07:50:29', '2022-09-05 11:54:03', 2, NULL, NULL, NULL, NULL, NULL),
(9679, 'ERP - PRJ - AS400 SFTP Utility Programs', NULL, 26, '2022-08-22', NULL, NULL, '21', 1, 'jsfrance', '2022-1771', '2022-08-22 06:44:30', '2022-08-30 06:12:58', 1, NULL, NULL, NULL, NULL, NULL),
(9680, 'ERP - SPT - ZARA Invoice Processing Issue', NULL, 11, '2022-08-22', '2022-08-22', '2022-08-22', '1.5', 3, 'rgomez', '2022-1772', '2022-08-22 09:56:12', '2022-08-22 09:56:53', 2, NULL, NULL, NULL, NULL, NULL),
(9681, 'DATA-SPT-Concessionaire Payment Types concern on Fused DB', NULL, 35, '2022-08-22', '2022-08-26', '2022-08-26', '11.5', 3, 'jlacaba', '2022-1773', '2022-08-22 09:56:55', '2022-08-26 08:08:21', 2, NULL, NULL, NULL, NULL, NULL),
(9682, 'DATA-SPT-Pentaho Native Javascript R&D', NULL, 35, '2022-08-22', '2022-09-20', '2022-09-20', '2', 3, 'jlacaba', '2022-1774', '2022-08-22 12:45:21', '2022-08-22 12:46:25', 2, NULL, NULL, NULL, NULL, NULL),
(9683, 'BLD - PRJ - Omnirio-Out onboarding brand', NULL, 27, '2022-08-22', '2022-08-31', '2023-01-05', '5.5', 3, 'jgonzales', '2022-1775', '2022-08-22 13:32:34', '2022-08-23 13:17:47', 2, NULL, NULL, NULL, NULL, NULL),
(9684, 'DATA-SPT-CK Monthly Reporting to Principal Report', NULL, 35, '2022-08-23', '2022-09-20', NULL, '42.5', 3, 'jlacaba', '2022-1776', '2022-08-23 11:03:37', '2022-09-07 13:27:10', 2, NULL, NULL, NULL, NULL, NULL),
(9685, 'ITD-ISCI-INFRA-Zara Ecom Warehouse Transfer/Expansion', NULL, 69, '2022-08-15', '2022-12-09', NULL, '23.5', 1, 'sopina', '2022-1777', '2022-08-24 05:47:00', '2022-08-25 09:19:36', 1, NULL, NULL, NULL, NULL, NULL),
(9686, 'ERP - SPT - PB Warehouse Manual Move Issue', NULL, 11, '2022-08-24', '2022-08-25', '2022-08-25', '1', 3, 'rgomez', '2022-1778', '2022-08-24 10:35:57', '2022-09-06 00:39:11', 2, NULL, NULL, NULL, NULL, NULL),
(9687, 'DATA - SPT - Zara ECom Transfer Concern', NULL, 35, '2022-08-25', '2022-09-20', NULL, '1', 3, 'malejandro', '2022-1779', '2022-08-25 09:22:22', '2022-08-30 07:55:26', 2, NULL, NULL, NULL, NULL, NULL),
(9688, 'ITSysOps-ISCI-2022- STRADIVARIUS HIPOS MIGRATION', NULL, 92, '2022-08-22', '2022-10-25', '2022-10-25', '76.25', 3, 'jpmontalbo', '2022-1780', '2022-08-26 05:08:29', '2022-09-02 03:14:42', 1, NULL, NULL, NULL, 'All Stradivarius store migrated to HIPOS', NULL),
(9689, 'DATA-SPT-WS Retail Price concern', NULL, 35, '2022-08-26', '2022-09-20', '2022-09-20', '1.25', 3, 'jlacaba', '2022-1781', '2022-08-26 07:59:38', '2022-08-26 08:01:18', 2, NULL, NULL, 'Advised Jomar to create another report in Qlik Sense that doesn\'t compute the retail of child SKUs', NULL, NULL),
(9690, 'ERP - PRJ -  Stock Take Final Posting Report for MPC', NULL, 26, '2022-08-30', NULL, NULL, '36.5', 1, 'jsfrance', '2022-1782', '2022-08-30 06:10:34', '2022-09-07 08:17:05', 1, NULL, NULL, NULL, NULL, NULL),
(9691, 'DATA - PRJ - SSI/WSI Outbound Data Integration', NULL, 35, '2022-08-30', '2022-12-19', '2022-12-19', '152.75', 3, 'malejandro', '2022-1783', '2022-08-30 07:59:04', '2022-09-07 13:05:06', 2, NULL, NULL, NULL, NULL, NULL),
(9692, 'Holiday', NULL, 122, '2022-08-29', '2022-08-29', '2022-08-29', '8', 1, 'amsalisi', '2022-1784', '2022-08-30 08:34:11', '2022-09-05 10:43:45', 4, NULL, NULL, NULL, NULL, NULL),
(9693, 'APPSPT-SPT-FSRI EWMS - September 2022', NULL, 8, '2022-09-01', '2022-09-30', NULL, '37.5', 3, 'aibias', '2022-1785', '2022-08-31 05:37:17', '2022-09-08 01:45:41', 2, NULL, NULL, NULL, NULL, NULL),
(9695, 'APPSPT-SPT-INSYS SUPPORT - September 2022', NULL, 8, '2022-09-01', '2022-09-30', NULL, NULL, 3, 'aibias', '2022-1787', '2022-08-31 05:37:54', '2022-08-31 05:37:54', 2, NULL, NULL, NULL, NULL, NULL),
(9696, 'APPSPT-SPT-Item Creation - September 2022', NULL, 8, '2022-09-01', '2022-09-30', NULL, '25.75', 3, 'aibias', '2022-1788', '2022-08-31 05:38:10', '2022-09-07 05:04:21', 2, NULL, NULL, NULL, NULL, NULL),
(9697, 'APPSPT-SPT-NAV SUPPORT - September 2022', NULL, 8, '2022-09-01', '2022-09-30', NULL, '18', 3, 'aibias', '2022-1789', '2022-08-31 05:38:26', '2022-09-08 01:44:23', 2, NULL, NULL, NULL, NULL, NULL),
(9698, 'APPSPT-SPT-PENTAHO MUJI SUPPORT - September 2022', NULL, 8, '2022-09-01', '2022-09-30', NULL, '32', 3, 'aibias', '2022-1790', '2022-08-31 05:38:43', '2022-09-07 11:19:32', 2, NULL, NULL, NULL, NULL, NULL),
(9699, 'APPSPT-SPT-PENTAHO SUPPORT - September 2022', NULL, 8, '2022-09-01', '2022-09-30', NULL, '89.75', 3, 'aibias', '2022-1791', '2022-08-31 05:38:58', '2022-09-08 01:46:24', 2, NULL, NULL, NULL, NULL, NULL),
(9700, 'APPSPT-SPT-QLIKSENSE SUPPORT - September 2022', NULL, 8, '2022-09-01', '2022-09-30', NULL, '3.75', 3, 'aibias', '2022-1792', '2022-08-31 05:39:16', '2022-09-08 01:46:57', 2, NULL, NULL, NULL, NULL, NULL),
(9701, 'ERP - PRJ - Sales Tagging of Trunc from Clerk ID in NAV', NULL, 11, '2022-08-31', '2022-09-06', '2022-09-06', '15.75', 3, 'rgomez', '2022-1793', '2022-08-31 10:44:30', '2022-09-07 10:51:38', 2, NULL, NULL, NULL, NULL, NULL),
(9702, 'ERP - SPT - Finance Menu Control for RMSI', NULL, 11, '2022-08-31', '2022-09-01', '2022-09-01', '0.5', 3, 'rgomez', '2022-1794', '2022-08-31 10:50:23', '2022-08-31 10:50:48', 2, NULL, NULL, NULL, NULL, NULL),
(9703, 'BLD - SPT - ICS - Error in the Reports', NULL, 13, '2022-08-31', '2023-02-17', '2023-02-17', '57.75', 3, 'jquijano', '2022-1795', '2022-08-31 12:06:01', '2022-09-07 12:10:48', 2, NULL, NULL, NULL, NULL, NULL),
(9704, 'DATA-SPT-MPC Data variance concern', NULL, 35, '2022-09-01', '2022-10-25', '2022-10-25', '33.25', 3, 'jlacaba', '2022-1796', '2022-09-01 08:27:36', '2022-09-07 13:02:20', 2, NULL, NULL, NULL, NULL, NULL),
(9705, 'DATA - SPT - ISCI XML Uploading Concern', NULL, 35, '2022-09-01', '2022-09-20', NULL, '7', 3, 'malejandro', '2022-1797', '2022-09-01 09:20:05', '2022-09-05 11:22:49', 2, NULL, NULL, NULL, NULL, NULL),
(9706, 'BLD - SPT - Sales Audit Parser - Trunc Sales Tagging in NAV by Sales Clerk ID', NULL, 13, '2022-09-01', '2023-01-06', '2023-01-06', '14.75', 3, 'jquijano', '2022-1798', '2022-09-01 10:44:07', '2022-09-02 13:57:17', 2, NULL, NULL, NULL, NULL, NULL),
(9707, 'DATA-SPT-Burberry report concerns', NULL, 35, '2022-09-02', '2022-09-26', '2022-09-26', '1.5', 3, 'jlacaba', '2022-1799', '2022-09-02 08:19:12', '2022-09-02 08:20:21', 2, NULL, NULL, NULL, NULL, NULL),
(9708, 'BLD - SPT - Retail Information - Enhance the Web Application', NULL, 13, '2022-09-02', '2022-12-29', '2022-12-29', '7.25', 3, 'jquijano', '2022-1800', '2022-09-02 14:06:40', '2022-09-07 11:37:11', 2, NULL, NULL, 'Remove the delete function and change into update of the delete tag.', NULL, NULL),
(9709, 'APPSPT-SPT-PENTAHO-Fused Sales Refresh - September 2022', NULL, 8, '2022-09-01', '2022-09-30', NULL, '7.5', 3, 'yemagnaye', '2022-1801', '2022-09-04 01:58:48', '2022-09-04 02:00:55', 2, NULL, NULL, NULL, NULL, NULL),
(9710, 'ITD-SSI-SYSDEV-eLeave/eTAF', NULL, 140, '2022-09-01', '2022-09-09', '2022-09-09', '43', 1, 'jssegun', '2022-1802', '2022-09-05 00:49:11', '2022-09-05 01:01:00', 1, NULL, NULL, NULL, NULL, NULL),
(9711, 'APPSPT-SPT-ERIC SUPPORT - September 2022', NULL, 8, '2022-09-01', '2022-09-30', NULL, '17.5', 3, 'aibias', '2022-1803', '2022-09-05 05:21:00', '2022-09-08 01:55:12', 2, NULL, NULL, NULL, NULL, NULL),
(9712, 'DATA-SPT-Longchamp switch to EBG warehouse', NULL, 35, '2022-09-05', '2022-09-16', '2022-09-16', '1.5', 3, 'jlacaba', '2022-1804', '2022-09-05 11:39:07', '2022-09-05 11:40:24', 2, NULL, NULL, NULL, NULL, NULL),
(9713, 'ITSysOps - ISCI - Taguig Warehouse DSL/SDWAN request', NULL, 81, '2022-09-05', '2022-10-14', NULL, '4.5', 6, 'cccalma', '2022-1805', '2022-09-06 10:16:22', '2022-09-07 09:40:36', 1, NULL, NULL, NULL, NULL, NULL),
(9714, 'BLD - SPT - WMS - Concerns in the Web Application', NULL, 13, '2022-09-06', NULL, NULL, '1', 6, 'jquijano', '2022-1806', '2022-09-06 12:36:12', '2022-09-06 12:40:43', 2, NULL, NULL, NULL, NULL, NULL),
(9715, 'DATA-PRJ-Roger Vivier Item Uploader using Pentaho', NULL, 35, '2022-09-06', '2022-10-18', '2022-10-18', '42', 3, 'jlacaba', '2022-1807', '2022-09-06 13:12:44', '2022-09-06 13:14:58', 2, NULL, NULL, NULL, NULL, NULL),
(9716, 'ERP - SPT - WSI Oracle Platform Migration to OCI', NULL, 11, '2022-09-07', '2022-09-07', '2022-09-07', '0.5', 3, 'rgomez', '2022-1808', '2022-09-07 10:56:09', '2022-09-07 10:56:31', 2, NULL, NULL, NULL, NULL, NULL),
(9717, 'ERP - SPT - FSRI Issue on the Loaded Sales File from OSTP', NULL, 11, '2022-09-07', '2022-09-09', '2022-09-09', '8.5', 3, 'rgomez', '2022-1809', '2022-09-07 10:57:07', '2022-09-07 11:04:41', 2, NULL, NULL, NULL, NULL, NULL),
(9718, 'APPSPT-SPT-Retail Information 2020', NULL, 8, '2022-09-07', '2022-12-31', '2023-01-03', '3', 6, 'aibias', '2022-1810', '2022-09-07 11:33:02', '2022-09-07 11:48:09', 2, NULL, NULL, NULL, NULL, NULL),
(9719, 'DATA-SPT-RMSI Invoice concern', NULL, 35, '2022-09-07', '2022-09-20', '2022-09-20', '1', 3, 'jlacaba', '2022-1811', '2022-09-07 13:06:21', '2022-09-07 13:07:59', 2, NULL, NULL, NULL, NULL, NULL),
(9720, 'BLD-IT-SPT-Sales monitoring System', NULL, 27, '2022-09-09', '2022-09-30', NULL, '3.5', 1, 'jgonzales', '2022-1812', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9721, 'DATA-SPT-SSI Inventory Adjustment Logging Report Concern', NULL, 35, '2022-09-09', '2022-09-20', NULL, '2', 3, 'malejandro', '2022-1813', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9722, 'ERP - PRJ -  Comestri SODI Build Enhancement', NULL, 26, '2022-09-12', NULL, NULL, '8', 1, 'jsfrance', '2022-1814', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9723, 'ITD-SSI-INFRA-Korres Rockwell Store Opening', NULL, 139, '2022-09-05', '2022-09-10', NULL, '3', 1, 'dpquinagoran', '2022-1815', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9724, 'ITD-SSI-INFRA-INFRA Alignment Meeting', NULL, 139, '2022-09-08', NULL, NULL, '12.899999976158', 1, 'dpquinagoran', '2022-1816', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(9725, 'ITD-SSI-INFRA-Zegna Greenbelt 3', NULL, 139, '2022-09-05', NULL, NULL, '14.600000023842', 1, 'dpquinagoran', '2022-1817', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9727, 'DATA-SPT-Muji Total Net Sales Issue', NULL, 35, '2022-09-12', '2022-09-20', NULL, '10', 3, 'malejandro', '2022-1819', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9728, 'ITD-SLCI-INFRA-Roger Vivier GB3', NULL, 139, '2022-09-12', NULL, NULL, '9.2000000476837', 1, 'dpquinagoran', '2022-1820', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9729, 'ITD-SSI-INFRA-Charriol Glorietta 3', NULL, 139, '2022-09-12', NULL, NULL, '6', 1, 'dpquinagoran', '2022-1821', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9730, 'BLD - SPT - Muji Sales Report - Concern in the Report', NULL, 13, '2022-09-12', '2022-09-13', '2022-09-13', '1', 3, 'jquijano', '2022-1822', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9731, 'ITD-SSI-INFRA-3F Acce additional node', NULL, 139, '2022-09-13', NULL, NULL, NULL, NULL, 'dpquinagoran', '2022-1823', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9732, 'ITD-SSI-INFRA-Tanyag whse 15 node additional', NULL, 139, '2022-09-09', NULL, NULL, '28', 1, 'dpquinagoran', '2022-1824', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9733, 'ITD-SSI-INFRA-3f NSB additional node', NULL, 139, '2022-09-13', NULL, NULL, '3.8000000119209', 1, 'dpquinagoran', '2022-1825', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9734, 'ITD-RMK-INFRA-RMK GF additional node', NULL, 139, '2022-09-13', NULL, NULL, '3', 1, 'dpquinagoran', '2022-1826', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9735, 'ERP - PRJ -  Auto-Item Creation Program for Roger Vivier', NULL, 26, '2022-09-13', NULL, NULL, '47.5', 1, 'jsfrance', '2022-1827', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9736, 'BLD - SPT - IAS - Check User Accessing the Application', NULL, 13, '2022-09-13', '2022-09-13', '2022-09-13', '2', 3, 'jquijano', '2022-1828', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9737, 'DATA-SPT-ISWI HiPOS Reports', NULL, 35, '2022-09-13', '2022-09-20', NULL, '2', 3, 'malejandro', '2022-1829', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9738, 'DATA-SPT-IS Group Hourly Report', NULL, 35, '2022-09-13', '2022-10-26', '2022-10-26', '4', 3, 'malejandro', '2022-1830', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9739, 'ERP - PRJ - Decommission of IAS', NULL, 11, '2022-09-14', '2022-12-31', '2022-12-31', '4', 3, 'rgomez', '2022-1831', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9740, 'ERP - SPT - PB Warehouse Stock Take (2022)', NULL, 11, '2022-09-14', '2022-09-14', '2022-09-14', '8.5', 3, 'rgomez', '2022-1832', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9741, 'DATA-SPT-Cost of Sales per UPC Issue', NULL, 35, '2022-09-14', '2022-09-20', NULL, '2', 3, 'malejandro', '2022-1833', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9742, 'DATA-SPT-CON Brands QDLS Concen', NULL, 35, '2022-09-14', '2022-09-20', NULL, '1', 3, 'malejandro', '2022-1834', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9743, 'BLD - SPT - Batch PO Create - There is No PO Created', NULL, 13, '2022-09-14', '2022-09-23', '2022-09-23', '42.5', 3, 'jquijano', '2022-1835', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9744, 'ITD-SSI-INFRA-Dune Megamall - Renovation', NULL, 139, '2022-08-26', NULL, NULL, '25', 1, 'dpquinagoran', '2022-1836', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9745, 'DATA-SPT-R&D for Google Analytics connector in Pentaho', NULL, 35, '2022-09-15', '2022-12-23', '2022-12-23', '3.25', 3, 'jlacaba', '2022-1837', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9746, 'DATA-SPT-Marc Jacob Inventory Concern', NULL, 35, '2022-09-15', '2022-09-20', NULL, '4.25', 3, 'malejandro', '2022-1838', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9747, 'DATA-SPT-SSI Price Event Uploading Concern', NULL, 35, '2022-09-15', '2022-09-20', NULL, '1', 3, 'malejandro', '2022-1839', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9748, 'DATA-SPT-ICG MPC WH Workforward concern', NULL, 35, '2022-09-16', '2022-09-20', NULL, '7', 3, 'jlacaba', '2022-1840', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9749, 'DATA-SPT-EBG Data Support concerns analysis', NULL, 35, '2022-09-16', '2022-09-26', '2022-09-26', '1', 3, 'jlacaba', '2022-1841', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9750, 'DATA-SPT-EBG 3MP Sales Checking', NULL, 35, '2022-09-16', '2022-11-23', '2022-11-23', '19.25', 3, 'jlacaba', '2022-1842', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9751, 'BLD - SPT - Screen Scrape - Concern When Executing', NULL, 13, '2022-09-16', '2022-09-19', '2022-09-19', '0.5', 3, 'jquijano', '2022-1843', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9752, 'ITD-SSI-SYSDEV-SSI WSI Data Integration', NULL, 140, '2022-09-13', '2022-09-30', NULL, '61.25', 1, 'jssegun', '2022-1844', NULL, NULL, 1, 30, NULL, NULL, NULL, NULL),
(9753, 'ITD-SSI-SYSDEV-Trunc Sales Tagging in NAV', NULL, 140, '2022-09-13', '2022-09-30', NULL, '77', 1, 'jssegun', '2022-1845', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9754, 'DATA-SPT-IS Group XML Uploading Destination ID Store New Condition', NULL, 35, '2022-09-20', '2022-10-03', '2022-10-03', '2', 3, 'malejandro', '2022-1846', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9755, 'ERP - SPT - MPC Warehouse JDA Connectivity Issue', NULL, 11, '2022-09-20', '2022-09-21', '2022-09-21', '2', 3, 'rgomez', '2022-1847', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9756, 'DATA-SPT-FSRI Masterfile support', NULL, 35, '2022-09-20', '2022-10-03', '2022-10-03', '11', 3, 'jlacaba', '2022-1848', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9757, 'DATA-SPT-SLCI B2B store outbound data exclusion', NULL, 35, '2022-09-13', '2022-10-26', '2022-10-26', '6.25', 3, 'jlacaba', '2022-1849', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9758, 'DATA-SPT-POS Reader data duplication checking', NULL, 35, '2022-09-20', '2022-11-08', '2022-11-08', '106', 3, 'jlacaba', '2022-1850', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9759, 'BLD - SPT - Screen Scrape Transfer - Request to Prioritize Specific Transfer', NULL, 13, '2022-09-20', '2022-10-17', '2022-10-17', '0.5', 3, 'jquijano', '2022-1851', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9760, 'DATA-SPT-ICG Request - JDA Transaction Report', NULL, 35, '2022-09-21', '2023-02-14', '2023-02-14', '1', 3, 'jlacaba', '2022-1852', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9761, 'DATA-SPT-IS Group-Manual PO Uploading', NULL, 35, '2022-09-22', '2022-11-08', '2022-11-08', '52', 3, 'jlacaba', '2022-1853', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9762, 'DATA-SPT-Calvin Klein Daily Report Concern', NULL, 35, '2022-09-22', '2022-10-25', '2022-10-25', '2', 3, 'malejandro', '2022-1854', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9763, 'DATA-SPT-Clarks QDLS Polling Concern', NULL, 35, '2022-09-22', '2022-09-26', '2022-09-26', '1', 3, 'malejandro', '2022-1855', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9764, 'APPSPT-SPT-NAV Trunc Sales Clerk Tagging', NULL, 8, '2022-09-01', NULL, NULL, '3', 6, 'aibias', '2022-1856', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9765, 'BLD - SPT - Barcode - Printing of Barcode for Price Event', NULL, 13, '2022-09-22', NULL, NULL, '49.25', 1, 'jquijano', '2022-1857', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9766, 'DATA-SPT-Lacoste Per Location Inventory Report Concern', NULL, 35, '2022-09-23', '2022-09-26', '2022-09-26', '2', 3, 'malejandro', '2022-1858', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9767, 'BLD - SPT - Screen Scrape - Allocate Transfer Screen Scrape Stopped', NULL, 13, '2022-09-23', '2022-10-17', '2022-10-17', '3', 3, 'jquijano', '2022-1859', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9768, 'BLD-IT-SPT- Pentaho report migration to PAT2', NULL, 27, '2022-09-24', '2022-11-15', '2022-11-15', '17', 3, 'jgonzales', '2022-1860', NULL, NULL, 2, NULL, NULL, 'Migrate the reports in pentaho to the pat application', NULL, NULL),
(9769, 'ERP - PRJ -  Store Use File Purge Enhancement', NULL, 26, '2022-09-26', NULL, NULL, '23.25', 1, 'jsfrance', '2022-1861', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9770, 'DATA-SPT-Drunk Elephant brand onboarding Item Creation and reports and polling development', NULL, 35, '2022-09-26', '2022-10-26', '2022-10-26', '25.25', 3, 'malejandro', '2022-1862', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9771, 'BLD - SPT - Sales Audit Parser - Error When Generating Poll Files for Zara', NULL, 13, '2022-09-27', '2022-09-29', '2022-09-29', '0.5', 3, 'jquijano', '2022-1863', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9772, 'DATA-SPT-Cortefiel Sales Refresh Concern', NULL, 35, '2022-09-28', '2022-09-28', '2022-09-28', '2', 3, 'malejandro', '2022-1864', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9773, 'ERP - PRJ - USRP Maintenance for Coach', NULL, 11, '2022-09-28', '2022-10-04', '2022-10-04', '2', 3, 'rgomez', '2022-1865', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9774, 'DATA-SPT-Lexer CRM DB Server Issue', NULL, 35, '2022-09-28', '2022-10-26', '2022-10-26', '2', 3, 'jlacaba', '2022-1866', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9775, 'DATA-SPT-BRAND COM Sales Checking', NULL, 35, '2022-09-28', '2022-11-08', '2022-11-08', '1.5', 3, 'jlacaba', '2022-1867', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9776, 'ERP - SPT - Transfer of Zegna GB4 Balance to GB3', NULL, 11, '2022-09-29', '2022-09-30', '2022-09-30', '3.25', 3, 'rgomez', '2022-1868', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9777, 'DATA-SPT-ISCI Updating of Sales query', NULL, 35, '2022-09-29', '2022-10-11', '2022-10-11', '4.5', 3, 'malejandro', '2022-1869', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9778, 'ITD-SSI-INFRA-LACOSTE MAGNOLIA -RENOVATION', NULL, 139, '2022-09-01', NULL, NULL, '62', 1, 'dpquinagoran', '2022-1870', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(9780, 'Diptyque CSQ Renovation', NULL, 139, '2022-09-01', NULL, NULL, '1.5', 1, 'dpquinagoran', '2022-1872', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9781, 'ITD-SSI-INFRA-Longchamp in GB5-Store Renovation', NULL, 139, '2022-09-01', NULL, NULL, '38.5', 1, 'dpquinagoran', '2022-1873', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9782, 'ITD-SSI-INFRA-ADMIN', NULL, 139, '2022-09-01', NULL, NULL, '2', 1, 'dpquinagoran', '2022-1874', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(9783, 'ITD-SSI-INFRA-Kate Spade Okada', NULL, 139, '2022-09-02', NULL, NULL, '31', 1, 'dpquinagoran', '2022-1875', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9784, 'ITD-SFRI-INFRA-Shake Shack MOA', NULL, 139, '2022-09-02', NULL, NULL, '9.75', 1, 'dpquinagoran', '2022-1876', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9785, 'ITD-SSI-INFRA-Montblanc Solaire', NULL, 139, '2022-09-05', NULL, NULL, '57.5', 1, 'dpquinagoran', '2022-1877', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9786, 'ITD-SSI-INFRA-3F Acce additional node for AP', NULL, 139, '2022-09-05', NULL, NULL, '3.5', 1, 'dpquinagoran', '2022-1878', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9787, 'ITD-SSI-INFRA- RMK GF additional node for AP', NULL, 139, '2022-09-05', NULL, NULL, '5', 1, 'dpquinagoran', '2022-1879', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9788, 'ITD-SSI-INFRA-2f Midland 3 nodes re cabling', NULL, 139, '2022-09-06', NULL, NULL, '5', 1, 'dpquinagoran', '2022-1880', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9790, 'APPSPT-SPT-FSRI EWMS - October 2022', NULL, 8, '2022-10-01', '2022-10-31', NULL, '63.25', 3, 'aibias', '2022-1882', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9791, 'APPSPT-SPT-INSYS SUPPORT - October 2022', NULL, 8, '2022-10-01', '2022-10-31', NULL, NULL, 3, 'aibias', '2022-1883', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9792, 'APPSPT-SPT-Item Creation - October 2022', NULL, 8, '2022-10-01', '2022-10-31', NULL, '36', 3, 'aibias', '2022-1884', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9793, 'APPSPT-SPT-NAV SUPPORT - October 2022', NULL, 8, '2022-10-01', '2022-10-31', NULL, '18.75', 3, 'aibias', '2022-1885', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9794, 'APPSPT-SPT-ERIC SUPPORT - October 2022', NULL, 8, '2022-10-01', '2022-10-31', NULL, '11', 3, 'aibias', '2022-1886', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9795, 'APPSPT-SPT-PENTAHO MUJI SUPPORT - October 2022', NULL, 8, '2022-10-01', '2022-10-31', NULL, '30.75', 3, 'aibias', '2022-1887', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9796, 'APPSPT-SPT-PENTAHO SUPPORT - October 2022', NULL, 8, '2022-10-01', '2022-10-31', NULL, '89', 3, 'aibias', '2022-1888', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9797, 'APPSPT-SPT-QLIKSENSE SUPPORT - October 2022', NULL, 8, '2022-10-01', '2022-10-31', NULL, '6.75', 3, 'aibias', '2022-1889', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9798, 'ERP - PRJ - USRP Maintenance for Coach', NULL, 26, '2022-10-03', NULL, NULL, '23.25', 1, 'jsfrance', '2022-1890', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9799, 'DATA-SPT-Zegna Inventory Report Support', NULL, 35, '2022-10-03', '2022-10-11', '2022-10-11', '2.5', 3, 'jlacaba', '2022-1891', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9800, 'ITD-SSI-INFRA-Givenchy GB4 Temp Store', NULL, 139, '2022-09-30', NULL, NULL, '0.5', 1, 'dpquinagoran', '2022-1892', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9801, 'DATA-SPT-MTC Tasks Monitoring', NULL, 35, '2022-10-03', NULL, NULL, '299', 1, 'jlacaba', '2022-1893', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9802, 'ITD-SSI-INFRA-Zara Greenbelt 5/Zara Warehouse Cabling', NULL, 139, '2022-09-16', NULL, NULL, '1', 1, 'dpquinagoran', '2022-1894', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9803, 'APPSPT-SPT-PENTAHO-Fused Sales Refresh - October 2022', NULL, 8, '2022-10-01', '2022-10-31', NULL, '14.25', 3, 'yemagnaye', '2022-1895', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9804, 'BLD - SPT - Sales Audit Parser - Add Store in the Database', NULL, 13, '2022-10-04', '2022-10-17', '2022-10-17', '0.5', 3, 'jquijano', '2022-1896', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9805, 'DATA-SPT-TENDAM EDI Support', NULL, 35, '2022-10-04', '2023-01-12', '2023-01-12', '18.5', 3, 'jlacaba', '2022-1897', NULL, NULL, 2, NULL, NULL, NULL, 'Closing ticket for 2022', NULL),
(9806, 'ERP - SPT - Unsuccessful Invoice Creation for Zara', NULL, 11, '2022-10-04', '2022-10-04', '2022-10-04', '1', 3, 'rgomez', '2022-1898', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9807, 'ERP - SPT - ETP Planning', NULL, 11, '2022-10-04', NULL, NULL, '9.75', 1, 'rgomez', '2022-1899', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9808, 'DATA-SPT-Lacoste Per Location Inventory Report Concern', NULL, 35, '2022-10-04', '2022-11-21', '2022-11-21', '7', 3, 'malejandro', '2022-1900', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9809, 'DATA-SPT-FSRI Item and Invoice uploading support', NULL, 35, '2022-10-04', '2022-11-02', '2022-11-02', '7', 3, 'jlacaba', '2022-1901', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9810, 'ITSysOps - ISCI - 2023 Stradivarius Cebu Store Opening', NULL, 81, '2022-10-05', '2023-03-15', NULL, '6.75', 1, 'cccalma', '2022-1902', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9811, 'DATA-SPT-Tiffany Consolidated Sales Report Concern', NULL, 35, '2022-10-06', '2022-11-08', '2022-11-08', '2', 3, 'malejandro', '2022-1903', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9812, 'DATA-SPT-Laura Mercier Item Creation Concern', NULL, 35, '2022-10-07', '2022-11-08', '2022-11-08', '2', 3, 'malejandro', '2022-1904', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9813, 'BLD - SPT - Barcode - Barcode Printing for Roger Vivier', NULL, 13, '2022-10-07', '2022-10-17', '2022-10-17', '17.75', 3, 'jquijano', '2022-1905', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9814, 'ITSysOps - ISCI - 2023 Zara Home Returns and RTS Project MOA', NULL, 81, '2022-10-10', '2022-12-30', NULL, '18.75', 1, 'cccalma', '2022-1906', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9815, 'DATA-SPT-JDA Migration of inactive brands 2022', NULL, 35, '2022-10-10', '2023-02-07', '2023-02-07', '106.5', 3, 'malejandro', '2022-1907', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9816, 'ERP - SPT - Prada Inventory Concern', NULL, 11, '2022-10-10', '2022-11-03', '2022-11-03', '12.75', 3, 'rgomez', '2022-1908', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9817, 'ERP - PRJ - TWG Migration to JDA', NULL, 11, '2022-10-10', NULL, NULL, '13.75', 1, 'rgomez', '2022-1909', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9818, 'BLD - SPT - Barcode - Barcode for New POS for NBS', NULL, 13, '2022-10-10', '2022-10-17', '2022-10-17', '5', 3, 'jquijano', '2022-1910', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9819, 'SSI-SYSOPS-Change of JDA Access', NULL, 79, '2022-01-01', '2022-12-31', NULL, '0.75', 1, 'ahortega', '2022-1911', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9820, 'ERP - SPT - MAHN WMS', NULL, 11, '2022-10-11', NULL, NULL, '2', 6, 'rgomez', '2022-1912', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9821, 'DATA-SPT-POS Reader Trunc Delta Orderhive concern', NULL, 35, '2022-10-11', '2022-10-25', '2022-10-25', '5', 3, 'jlacaba', '2022-1913', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9822, 'DATA-SPT-TWG Migration to JDA', NULL, 35, '2022-10-11', '2022-11-29', '2022-11-29', '5.5', 3, 'jlacaba', '2022-1914', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9823, 'ITSysOps - ISCI - 2023 PEOPLE COUNTER Implementation for Zara', NULL, 81, '2022-10-03', '2022-12-31', NULL, '14.5', 1, 'cccalma', '2022-1915', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9824, 'DATA-SPT-SSI Fused Daily Polling Issue', NULL, 35, '2022-10-12', '2022-10-25', '2022-10-25', '2', 3, 'malejandro', '2022-1916', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9825, 'DATA-SPT-Roger Vivier Daily Polling', NULL, 35, '2022-10-12', '2022-10-25', '2022-10-25', '7.25', 3, 'malejandro', '2022-1917', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9826, 'ERP - SPT - Migration of Old Polo Ralph items from 4R4 to Fused', NULL, 11, '2022-10-12', '2022-10-20', '2022-10-20', '7.5', 3, 'rgomez', '2022-1918', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9827, 'DATA-SPT-Coach Reports with USRP', NULL, 35, '2022-10-12', '2022-10-26', '2022-10-26', '16', 3, 'jlacaba', '2022-1919', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9828, 'DATA-SPT-Fused Polling generation concern', NULL, 35, '2022-10-12', '2022-10-25', '2022-10-25', '2.5', 3, 'jlacaba', '2022-1920', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9829, 'ERP - PRJ - Price Event Releasing Filter by USER ID in Hermes Environment', NULL, 11, '2022-10-13', '2022-10-21', '2022-10-21', '28.5', 3, 'rgomez', '2022-1921', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9830, 'ERP - SPT - SLCI OSTP', NULL, 11, '2022-10-13', '2022-11-01', '2022-11-01', '13.25', 3, 'rgomez', '2022-1922', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9831, 'DATA-SPT-Hermes Polling issue', NULL, 35, '2022-10-13', '2022-10-24', '2022-10-24', '3', 3, 'jlacaba', '2022-1923', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `txn_tickets` (`id`, `description`, `entity_id`, `ticket_manager_id`, `start_date`, `end_date`, `closed_date`, `total_hours`, `status_id`, `added_by`, `ticket_ref`, `created_at`, `updated_at`, `ticket_type_id`, `estimate_hours`, `repository`, `remarks`, `ticket_description`, `ticket_member_ids`) VALUES
(9832, 'DATA-SPT-GAP OSTP Report Testing', NULL, 35, '2022-10-13', '2022-11-07', '2022-11-07', '22', 3, 'jlacaba', '2022-1924', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9833, 'DATA-SPT-SPOC Reports inquiry', NULL, 35, '2022-10-13', '2022-12-19', '2022-12-19', '2', 3, 'jlacaba', '2022-1925', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9834, 'BLD - SPT - Barcode - Barcode is not Align in New Printer', NULL, 13, '2022-10-13', '2022-10-13', '2022-10-13', '1.5', 3, 'jquijano', '2022-1926', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9835, 'BLD - SPT - ICS - Error when Location has 5 digits', NULL, 13, '2022-10-13', '2022-10-17', '2022-10-17', '1.75', 3, 'jquijano', '2022-1927', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9836, 'BLD-IT-SPT- Pentaho to PHP integration', NULL, 27, '2022-10-13', NULL, NULL, '1', 1, 'jgonzales', '2022-1928', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9837, 'VL', NULL, 82, '2022-10-13', '2022-10-13', NULL, '8', 1, 'dmvillanueva', '2022-1929', NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL),
(9838, 'NAV Support', NULL, 82, '2022-10-14', '2022-10-14', NULL, NULL, NULL, 'dmvillanueva', '2022-1930', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9839, 'NAV Support', NULL, NULL, '2022-10-14', NULL, NULL, NULL, NULL, 'dmvillanueva', '2022-1931', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9840, 'NAV Support', NULL, 82, '2022-10-14', '2022-10-14', NULL, '3.5', 1, 'dmvillanueva', '2022-1932', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9841, 'DATA-SPT- JDA Fused Pentaho Data Streaming Updates', NULL, 35, '2022-10-14', '2022-11-21', '2022-11-21', '24', 3, 'jlacaba', '2022-1933', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9842, 'ITD-SSIG-GEN-HRIS', NULL, 140, '2022-10-01', '2023-04-30', NULL, '383', 1, 'jssegun', '2022-1934', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9843, 'ERP - SPT - Migration of Old CK Calvin items from 4R4 to Fused', NULL, 11, '2022-10-17', '2022-11-08', '2022-11-08', '6.5', 3, 'rgomez', '2022-1935', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9844, 'BLD - SPT - ICS - INA Checkbox is Enabled', NULL, 13, '2022-10-17', '2022-10-24', '2022-10-24', '7.25', 3, 'jquijano', '2022-1936', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9845, 'Admin', NULL, 140, '2022-10-01', '2023-12-31', NULL, '167.5', 1, 'jssegun', '2022-1937', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(9846, 'Principal Support', NULL, 82, '2022-10-18', NULL, NULL, '0.75', 1, 'dmvillanueva', '2022-1938', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9847, 'DATA-SPT-Pentaho Fused Server Activity', NULL, 35, '2022-10-18', '2022-10-26', '2022-10-26', '4', 3, 'malejandro', '2022-1939', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9848, 'BLD - SPT - EWMS - Data is Not Synched to Scanner', NULL, 13, '2022-10-18', '2022-10-24', '2022-10-24', '0.75', 3, 'jquijano', '2022-1940', NULL, NULL, 2, NULL, NULL, 'Checked with Arvin that this is now Ok.', NULL, NULL),
(9849, 'DATA-SPT-QS WS Sales Detailed Report concern', NULL, 35, '2022-10-19', '2022-10-20', '2022-10-20', '1.25', 3, 'jlacaba', '2022-1941', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9850, 'DATA-SPT-QS WS Inventory Data Variance', NULL, 35, '2022-10-20', '2022-11-14', '2022-11-14', '3', 3, 'jlacaba', '2022-1942', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9851, 'SSI-SYSOPS-New MOP', NULL, 79, '2022-01-01', '2022-12-31', NULL, '5', 1, 'ahortega', '2022-1943', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9852, 'ITSysOps - ISCI - 2023 Stradivarius Cebu Store Opening', NULL, 81, '2022-10-01', '2023-05-31', NULL, '2.25', 1, 'irlatube', '2022-1944', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9853, 'HO Meeting', NULL, 82, '2022-10-21', NULL, NULL, NULL, NULL, 'dmvillanueva', '2022-1945', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(9854, 'BLD - SPT - Barcode - Attend to the User Concern', NULL, 13, '2022-10-21', '2022-10-24', '2022-10-24', '0.5', 3, 'jquijano', '2022-1946', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9855, 'BLD-IT-SPT- Database Configuration', NULL, 27, '2022-10-21', '2022-10-31', NULL, '11.75', 1, 'jgonzales', '2022-1947', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9856, 'ITD-SSI-INFRA-ADMIN', NULL, 139, '2022-09-06', NULL, NULL, '136.5', 1, 'dpquinagoran', '2022-1948', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(9857, 'ITD-SFRI-INFRA-SDWAN', NULL, 139, '2022-09-09', NULL, NULL, '17.5', 1, 'dpquinagoran', '2022-1949', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9858, 'ITD-SSI-INFRA-Lacoste City of Dreams', NULL, 139, '2022-10-26', NULL, NULL, '0.5', 1, 'dpquinagoran', '2022-1950', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9859, 'ERP - SPT - Transfer of LM Items to Luxasia', NULL, 11, '2022-10-24', '2023-01-31', '2023-01-31', '9.75', 3, 'rgomez', '2022-1951', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9860, 'DATA-SPT-FSRI Polling Support', NULL, 35, '2022-10-24', '2022-10-25', '2022-10-25', '2', 3, 'jlacaba', '2022-1952', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9861, 'DATA-SPT-SSI Exploring Pentaho User Console Version 9.2', NULL, 35, '2022-10-25', '2023-01-16', '2023-01-16', '2', 3, 'malejandro', '2022-1953', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9862, 'BLD - SPT - EWMS - No Details Displayed in Let Down', NULL, 13, '2022-10-25', '2022-10-25', '2022-10-25', '1.5', 3, 'jquijano', '2022-1954', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9863, 'BLD-IT-SPT- Lexer API', NULL, 27, '2022-10-26', NULL, NULL, '6', 1, 'jgonzales', '2022-1955', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9864, 'ITD-SSI-INFRA-Rustan\'s Makati L1', NULL, 139, '2022-08-26', NULL, NULL, '0.5', 1, 'dpquinagoran', '2022-1956', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9865, 'ITD-SSI-INFRA-Coach GB5', NULL, 139, '2022-08-26', NULL, NULL, '3.5', 1, 'dpquinagoran', '2022-1957', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9866, 'ITD-SSI-INFRA-Pull & Bear Cebu  - RFID Cabling', NULL, 139, '2022-08-30', NULL, NULL, '1', 1, 'dpquinagoran', '2022-1958', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9867, 'ITD-SSI-INFRA-Stradivarius Shangrila - RFID Cabling Works', NULL, 139, '2022-08-30', NULL, NULL, '1', 1, 'dpquinagoran', '2022-1959', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9868, 'ITD-SSI-INFRA-Stradivarius Glorietta - RFID Cabling', NULL, 139, '2022-08-30', NULL, NULL, '0.5', 1, 'dpquinagoran', '2022-1960', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9869, 'DATA-SPT-SSI Fused Server Disk Log', NULL, 35, '2022-10-26', '2022-11-08', '2022-11-08', '3.75', 3, 'malejandro', '2022-1961', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9870, 'ERP - SPT - OMS Strategy', NULL, 11, '2022-10-26', '2022-10-26', '2022-10-26', '1', 3, 'rgomez', '2022-1962', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9871, 'ERP - SPT - PM Warehouse Stock Take (2022)', NULL, 11, '2022-10-26', '2022-10-26', '2022-10-26', '2.5', 3, 'rgomez', '2022-1963', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9872, 'APPSPT-ERIC Migration from 197 to 465', NULL, 8, '2022-10-26', '2022-12-31', '2023-01-03', '9.75', 3, 'aibias', '2022-1964', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9873, 'DATA-SPT-HERMES Polling concern', NULL, 35, '2022-10-26', '2022-11-08', '2022-11-08', '3', 3, 'jlacaba', '2022-1965', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9874, 'ERP - PRJ - Price Data Queues Enhancement in Fused', NULL, 26, '2022-10-27', NULL, NULL, '18', 1, 'jsfrance', '2022-1966', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9875, 'DATA-SPT-Trunc Transaction Type concern in JDA', NULL, 35, '2022-10-27', '2022-11-14', '2022-11-14', '2.5', 3, 'jlacaba', '2022-1967', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9876, 'ERP - SPT - AS/400 Systems\' ESB & PM for 3rd Qtr of 2022', NULL, 11, '2022-10-27', '2022-11-01', '2022-11-01', '0.25', 3, 'rgomez', '2022-1968', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9877, 'DATA-SPT-GAP SLCI Inventory Report', NULL, 35, '2022-10-27', NULL, '2022-12-13', '1.25', 3, 'jlacaba', '2022-1969', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9878, 'DATA-SPT-Roger Vivier polling concern', NULL, 35, '2022-10-27', '2022-11-21', '2022-11-21', '1.5', 3, 'jlacaba', '2022-1970', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9879, 'DATA-SPT-Drunk Elephant polling', NULL, 35, '2022-10-27', '2022-11-14', '2022-11-14', '1', 3, 'jlacaba', '2022-1971', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9880, 'DATA-SPT-Gap Missing Zero On-hand in Inventory Report', NULL, 35, '2022-10-27', '2022-11-21', '2022-11-21', '11', 3, 'malejandro', '2022-1972', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9881, 'BLD - SPT - ICS - Error in the Application', NULL, 13, '2022-10-27', '2022-11-08', '2022-11-08', '6.5', 3, 'jquijano', '2022-1973', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9882, 'BLD-IT-SPT- Lacoste Omni Process', NULL, 27, '2022-10-28', NULL, '2022-12-31', '9', 3, 'jgonzales', '2022-1974', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9883, 'ITD-SSI-INFRA-GIVENCHY GB4-New store', NULL, 139, '2022-10-27', NULL, NULL, '5', 1, 'dpquinagoran', '2022-1975', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9884, 'ITD-SSI-INFRA-GIVENCHY SOLAIRE-New store', NULL, 139, '2022-10-27', NULL, NULL, '44.5', 1, 'dpquinagoran', '2022-1976', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9885, 'DATA-SPT-FSRI Polling for Nov 1 Price Event', NULL, 35, '2022-10-28', '2022-11-02', '2022-11-02', '2.5', 3, 'jlacaba', '2022-1977', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9886, 'DATA-SPT-Masterfile refresh issues', NULL, 35, '2022-10-28', '2022-12-19', '2022-12-19', '6.5', 3, 'jlacaba', '2022-1978', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9887, 'DATA-SPT-Polo Ralph Lauren missing SKUs in the inventory report', NULL, 35, '2022-10-28', '2022-11-21', '2022-11-21', '2', 3, 'jlacaba', '2022-1979', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9888, 'BLD - SPT - ICS - Count is Not Posted in CyServ', NULL, 13, '2022-10-28', '2022-10-28', '2022-10-28', '0.5', 3, 'jquijano', '2022-1980', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9889, 'APPSPT-SPT-FSRI EWMS - November 2022', NULL, 8, '2022-11-01', '2022-11-30', NULL, '67.75', 3, 'aibias', '2022-1981', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9891, 'APPSPT-SPT-INSYS SUPPORT - November 2022', NULL, 8, '2022-11-01', '2022-11-30', NULL, '1.5', 3, 'aibias', '2022-1983', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9892, 'APPSPT-SPT-Item Creation - November 2022', NULL, 8, '2022-11-01', '2022-11-30', NULL, '25', 3, 'aibias', '2022-1984', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9893, 'APPSPT-SPT-NAV SUPPORT - November 2022', NULL, 8, '2022-11-01', '2022-11-30', NULL, '16.25', 3, 'aibias', '2022-1985', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9894, 'APPSPT-SPT-ERIC SUPPORT - November 2022', NULL, 8, '2022-11-01', '2022-11-30', NULL, '6.5', 3, 'aibias', '2022-1986', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9895, 'APPSPT-SPT-PENTAHO MUJI SUPPORT - November 2022', NULL, 8, '2022-11-01', '2022-11-30', NULL, '41', 3, 'aibias', '2022-1987', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9896, 'APPSPT-SPT-PENTAHO SUPPORT - November 2022', NULL, 8, '2022-11-01', NULL, NULL, '84.25', 3, 'aibias', '2022-1988', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9897, 'APPSPT-SPT-QLIKSENSE SUPPORT - November 2022', NULL, 8, '2022-11-01', '2022-11-30', NULL, '8.75', 3, 'aibias', '2022-1989', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9898, 'BLD-IT-SPT-PAT Reports 2022', NULL, 27, '2022-11-02', '2022-12-31', '2022-12-31', '6.75', 3, 'jgonzales', '2022-1990', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9899, 'BLD - SPT - End Of Month - Error in Executing End of Month for IAS', NULL, 13, '2022-11-02', '2022-11-02', '2022-11-02', '0.25', 3, 'jquijano', '2022-1991', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9900, 'DATA-SPT-MPC Sales Checking Oct 2022', NULL, 35, '2022-11-02', '2022-11-07', '2022-11-07', '4.5', 3, 'jlacaba', '2022-1992', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9901, 'DATA-SPT-FSRI Refresh Support', NULL, 35, '2022-11-02', '2022-11-21', '2022-11-21', '1', 3, 'jlacaba', '2022-1993', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9902, 'DATA-SPT-SLCI B2B Data Concern', NULL, 35, '2022-11-02', '2022-11-21', '2022-11-21', '2.5', 3, 'jlacaba', '2022-1994', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9903, 'HOLIDAY', NULL, 118, '2022-10-31', '2022-11-01', '2022-11-01', '16', 3, 'sbleria', '2022-1995', NULL, NULL, 4, 16, NULL, NULL, NULL, NULL),
(9904, 'ERP - SPT - Bally Sub Brand Update in Fused', NULL, 11, '2022-11-03', '2022-11-03', '2022-11-03', '1.5', 3, 'rgomez', '2022-1996', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9905, 'DATA-SPT-Zegna IMTC Report', NULL, 35, '2022-11-03', '2022-11-21', '2022-11-21', '6', 3, 'malejandro', '2022-1997', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9906, 'DATA-SPT-SSI Season Desc Concern', NULL, 35, '2022-11-03', '2022-11-21', '2022-11-21', '1', 3, 'malejandro', '2022-1998', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9907, 'DATA-SPT-SSI Price Event Concern', NULL, 35, '2022-11-03', '2022-11-21', '2022-11-21', '1', 3, 'malejandro', '2022-1999', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9908, 'BLD - SPT - EWMS - Letdown is not Synching to Scanner', NULL, 13, '2022-11-03', '2022-11-08', '2022-11-08', '6.5', 3, 'jquijano', '2022-2000', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9909, 'BLD - SPT - IAS - Request for a Script of a Report', NULL, 13, '2022-11-03', '2022-11-03', '2022-11-03', '0.5', 3, 'jquijano', '2022-2001', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9910, 'BLD-IT-SPT-SPRS Transformatoion 2022', NULL, 27, '2022-11-04', '2022-12-31', '2022-12-31', '23.5', 3, 'jgonzales', '2022-2002', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9911, 'BLD - PRJ- PAT v2 Web Application Enhancement - (2022-2023)', NULL, 27, '2022-11-04', NULL, NULL, '825.75', 1, 'jquijano', '2022-2003', NULL, NULL, 1, NULL, NULL, NULL, 'Enhance the web application UI/UX.', NULL),
(9912, 'ERP - SPT - SLCI eWMS Issue', NULL, 11, '2022-11-04', '2022-11-04', '2022-11-04', '2.25', 3, 'rgomez', '2022-2004', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9913, 'ERP - SPT - Total Inventory Balance and Retail Value of Trunc Show Brands', NULL, 11, '2022-11-04', '2022-11-04', '2022-11-04', '1.5', 3, 'rgomez', '2022-2005', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9914, 'APPSPT-SPT-PENTAHO-Fused Sales Refresh - November 2022', NULL, 8, '2022-11-01', '2022-11-30', NULL, '15', 3, 'yemagnaye', '2022-2006', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9915, 'ITSysOps - Support - 2022 Joint Store Rounds and Inspections', NULL, 81, '2022-11-03', '2022-11-30', NULL, '31', 1, 'cccalma', '2022-2007', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9916, 'ERP - PRJ - Store Use File Purge Prompt Enhancement in Fused', NULL, 26, '2022-11-07', NULL, NULL, '16', 1, 'jsfrance', '2022-2008', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9917, 'DATA-SPT-SLCI B2B ETL updates', NULL, 35, '2022-11-07', '2022-12-28', '2022-12-28', '8', 3, 'jlacaba', '2022-2009', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9918, 'DATA-SPT-Max & Co EDI Sales concerrn', NULL, 35, '2022-11-07', '2022-11-21', '2022-11-21', '4', 3, 'jlacaba', '2022-2010', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9919, 'ITD-SSIG-SYSDEV-ERIC Upgrade to version 465', NULL, 71, '2022-11-04', '2023-03-31', NULL, '47.75', 1, 'casenci', '2022-2011', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9920, 'ERP - SPT - SLCI BIR Requirements', NULL, 11, '2022-11-08', '2022-11-08', '2022-11-08', '0.75', 3, 'rgomez', '2022-2012', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9921, 'ERP - SPT - FSRI PSP Training', NULL, 11, '2022-11-08', '2022-11-08', '2022-11-08', '1.5', 3, 'rgomez', '2022-2013', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9922, 'DATA-SPT-SLCI New Feed Json concern', NULL, 35, '2022-11-08', '2022-11-18', '2022-11-18', '0.25', 3, 'jlacaba', '2022-2014', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9923, 'BLD - SPT - EWMS - Web Application Documentation', NULL, 13, '2022-11-08', '2022-11-15', '2022-11-15', '7.5', 3, 'jquijano', '2022-2015', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9924, 'BLD - SPT - JSON New Feed- Automating the Process', NULL, 13, '2022-11-08', '2023-01-06', '2023-01-06', '0.75', 3, 'jquijano', '2022-2016', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9925, 'ITD-SFRI-INFRA-2F URBAN BLDG', NULL, 139, '2022-10-06', NULL, NULL, '5.5', 1, 'dpquinagoran', '2022-2017', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9926, 'ITD-SSI-ENT-Transfer of TWG from NAV to JDA ERP', NULL, 71, '2022-10-25', '2023-03-31', NULL, '4.75', 1, 'casenci', '2022-2018', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9927, 'DATA-SPT-Muji Data Transfer Shift to New Server', NULL, 35, '2022-11-09', '2022-12-19', '2022-12-19', '17.5', 3, 'malejandro', '2022-2019', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9928, 'DATA-SPT-Cortefiel QDLS Polling file Concern', NULL, 35, '2022-11-09', '2022-11-21', '2022-11-21', '3.5', 3, 'malejandro', '2022-2020', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9929, 'ITSysOps - ISCI-Zara RFID Reader/Detacher Purchased', NULL, 81, '2022-10-03', '2022-12-30', NULL, '5.25', 1, 'cccalma', '2022-2021', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9930, 'DATA-SPT-The Specialist Transaction Type reports', NULL, 35, '2022-11-09', NULL, NULL, '5', 1, 'jlacaba', '2022-2022', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9931, 'DATA-SPT-Tommy Hilfiger Transfer Discrepancy concern', NULL, 35, '2022-11-09', '2022-11-21', '2022-11-21', '6', 3, 'jlacaba', '2022-2023', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9932, 'DATA-SPT-Tendam Group QS Inventory Concern', NULL, 35, '2022-11-10', '2022-11-21', '2022-11-21', '1.5', 3, 'jlacaba', '2022-2024', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9933, 'DATA-SPT-Samsonite Daily Sales Report Concern', NULL, 35, '2022-11-10', '2022-11-21', '2022-11-21', '2', 3, 'malejandro', '2022-2025', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9934, 'DATA-PRJ-JDA Data Marts', NULL, 35, '2022-11-11', NULL, NULL, '12.5', 1, 'jlacaba', '2022-2026', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9935, 'ERP - SPT - SLCI Warehouse Floating Slot Inventories', NULL, 11, '2022-11-11', '2022-11-11', '2022-11-11', '1.5', 3, 'rgomez', '2022-2027', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9936, 'ERP - PRJ - Batch Item Reprocessing Enhancement in Fused', NULL, 26, '2022-11-14', NULL, NULL, '21.5', 1, 'jsfrance', '2022-2028', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9937, 'ITSysOps - ISCI - 2023 NEW RFID SYSTEM Security / CHECKPOINT', NULL, 81, '2022-11-03', '2023-01-31', NULL, '15.5', 1, 'cccalma', '2022-2029', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9938, 'DATA-SPT-CK Jeans Incomplete Masterfile and Sales data Concern', NULL, 35, '2022-11-14', '2022-11-21', '2022-11-21', '1', 3, 'malejandro', '2022-2030', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9939, 'DATA-SPT-ISWI Mall Sending Data Concern', NULL, 35, '2022-11-14', NULL, NULL, NULL, NULL, 'malejandro', '2022-2031', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9940, 'DATA-SPT-ISWi HiPOS Mall Sending Data Concern', NULL, 35, '2022-11-14', '2022-11-21', '2022-11-21', '1.5', 3, 'malejandro', '2022-2032', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9941, 'DATA-SPT-FSRI-Local Item and Invoice Uploading Concern', NULL, 35, '2022-11-14', '2022-11-21', '2022-11-21', '3.75', 3, 'jlacaba', '2022-2033', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9942, 'BLD - SPT - HiPOS Mall Sending - Discrepancies in Sales', NULL, 13, '2022-11-14', '2022-11-16', '2022-11-16', '5.25', 3, 'jquijano', '2022-2034', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9943, 'ERP - SPT - Trunc SODI Issue of Lauren', NULL, 11, '2022-11-14', '2022-11-15', '2022-11-15', '2.5', 3, 'rgomez', '2022-2035', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9944, 'ERP - SPT - FSRI PSP Training', NULL, 11, '2022-11-14', '2022-11-14', '2022-11-14', '0.75', 3, 'rgomez', '2022-2036', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9945, 'BLD - PRJ - PAT2 UI/UX Enhancement', NULL, 27, '2022-11-14', NULL, '2023-01-05', '15.5', 3, 'jgonzales', '2022-2037', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9946, 'ERP - SPT - Muji - Shift to New Server', NULL, 11, '2022-11-15', '2022-11-15', '2022-11-15', '0.5', 3, 'rgomez', '2022-2038', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9947, 'DATA-SPT Clarks Sales variance concern', NULL, 35, '2022-11-15', '2022-11-21', '2022-11-21', '2', 3, 'jlacaba', '2022-2039', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9948, 'DATA-SPT-SSI 4R4 Transfer Transactions not updated in Fused Server Issue', NULL, 35, '2022-11-16', '2022-12-19', '2022-12-19', '17.5', 3, 'malejandro', '2022-2040', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9949, 'DATA-SPT-IS Group Deactivated Transactions Concern', NULL, 35, '2022-11-16', '2022-11-21', '2022-11-21', '8.75', 3, 'malejandro', '2022-2041', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9950, 'DATA-SPT-SLCI EDI Sales variance concern', NULL, 35, '2022-11-16', '2022-11-21', '2022-11-21', '7.5', 3, 'jlacaba', '2022-2042', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9951, 'DATA-SPT-FSRI Casepack checking', NULL, 35, '2022-11-17', '2022-11-21', '2022-11-21', '0.5', 3, 'jlacaba', '2022-2043', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9952, 'ERP - PRJ - Setup of DIM and FACTS Table in JDA', NULL, 11, '2022-11-17', NULL, NULL, NULL, NULL, 'rgomez', '2022-2044', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9953, 'ERP - PRJ - Setup of DIM and FACTS Table in JDA', NULL, 11, '2022-11-17', NULL, NULL, '3', 1, 'rgomez', '2022-2045', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9954, 'DATA-SPT-BURBERRY PO Report inquiry', NULL, 35, '2022-11-17', '2022-11-21', '2022-11-21', '2.25', 3, 'jlacaba', '2022-2046', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9955, 'DATA-SPT-FSRI ICG CasePack and Eaches inventory report concern', NULL, 35, '2022-11-18', '2022-12-13', '2022-12-13', '33.25', 3, 'jlacaba', '2022-2047', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9956, 'ERP - SPT - Charriol Trunc Balance for October and November (2021 and 2022)', NULL, 11, '2022-11-18', '2022-11-18', '2022-11-18', '1.5', 3, 'rgomez', '2022-2048', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9957, 'DATA-SPT-PRADA SKUS reclassification', NULL, 35, '2022-11-18', '2022-11-21', '2022-11-21', '2.5', 3, 'jlacaba', '2022-2049', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9958, 'DATA-SPT-SLCI Inventory Concern', NULL, 35, '2022-11-18', '2022-12-06', '2022-12-06', '1', 3, 'jlacaba', '2022-2050', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9959, 'BLD-IT-SPT- Start of the week meeting 2022', NULL, 27, '2022-11-18', '2022-12-31', '2023-01-05', '15', 3, 'jgonzales', '2022-2051', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9960, 'ITD-SSI-INFRA-LOEWE GREENBELT 3', NULL, 139, '2022-10-03', NULL, NULL, '6.5', 1, 'dpquinagoran', '2022-2052', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9961, 'ITD-RMSI-INFRA- M&S Malate-Recabling', NULL, 139, '2022-10-03', NULL, NULL, '1', 1, 'dpquinagoran', '2022-2053', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9962, 'ITD-RMSI-INFRA-M&S ATC-RFID', NULL, 139, '2022-10-03', NULL, NULL, '1', 1, 'dpquinagoran', '2022-2054', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9963, 'ITD-FSRI-INFRA-SDWAN-PLDT', NULL, 139, '2022-10-04', NULL, NULL, '14', 1, 'dpquinagoran', '2022-2055', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9964, 'ITD-SFRI-INFRA-SALADSTOP SOLENAD', NULL, 139, '2022-10-12', NULL, NULL, '13.5', 1, 'dpquinagoran', '2022-2056', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9965, 'ITD-SSI-INFRA-Jimmy Choo Greenbelt 3', NULL, 139, '2022-10-12', NULL, NULL, '1.5', 1, 'dpquinagoran', '2022-2057', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9966, 'ITD-SSI-INFRA-Clarks Megamall-tempo store', NULL, 139, '2022-10-17', NULL, NULL, '2.5', 1, 'dpquinagoran', '2022-2058', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9967, 'ITD-SSI-INFRA-Clarks Glorieta', NULL, 139, '2022-10-17', NULL, NULL, '3', 1, 'dpquinagoran', '2022-2059', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9968, 'ERP - PRJ - Reprint Vendor Return Authorization Report in Fused', NULL, 26, '2022-11-21', NULL, NULL, '20.5', 1, 'jsfrance', '2022-2060', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9969, 'ITSysOps - ISCI - 2023 HIPOS SELF CHECK OUT COUNTER (SCO)', NULL, 81, '2022-11-21', '2023-03-31', NULL, '7.75', 1, 'cccalma', '2022-2061', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9970, 'DATA-SPT-Marc Jacobs Weekly Sales data concern', NULL, 35, '2022-11-21', '2022-11-29', '2022-11-29', '1', 3, 'jlacaba', '2022-2062', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9971, 'BLD-IT-SPT-RMSI Batch Create PO', NULL, 27, '2022-11-21', '2022-12-27', '2022-12-27', '12', 3, 'jgonzales', '2022-2063', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9972, 'BLD - SPT - Classic Polling - Brand Migration to Fused', NULL, 13, '2022-11-22', '2022-12-29', '2022-12-29', '1', 3, 'jquijano', '2022-2064', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9973, 'BLD - SPT - Batch PO Create - PO is Not Creating for Two Invoices', NULL, 13, '2022-11-22', '2022-12-01', '2022-12-01', '6', 3, 'jquijano', '2022-2065', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9974, 'BLD - SPT - Delta Migration - Anne Klein Switch to EBGW', NULL, 13, '2022-11-23', '2022-12-01', '2022-12-01', '0.75', 3, 'jquijano', '2022-2066', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9975, 'BLD - SPT - Muji Pop Tag - Attend to the User Concern', NULL, 13, '2022-11-22', '2022-11-25', '2022-11-25', '0.5', 3, 'jquijano', '2022-2067', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9976, 'DATA-SPT-Fused Concessionaire sales polling concern', NULL, 35, '2022-11-22', NULL, NULL, NULL, NULL, 'jlacaba', '2022-2068', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9977, 'DATA-SPT-Fused Concessionaire sales polling concern', NULL, 35, '2022-11-22', '2022-11-29', '2022-11-29', '2', 3, 'jlacaba', '2022-2069', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9978, 'DATA-SPT-CKU Sales variance checking', NULL, 35, '2022-11-22', '2022-12-06', '2022-12-06', '1.5', 3, 'jlacaba', '2022-2070', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9979, 'DATA-SPT-Lacoste Price Event Concern', NULL, 35, '2022-11-23', '2022-11-29', '2022-11-29', '1.5', 3, 'malejandro', '2022-2071', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9980, 'DATA-SPT-FSRI Database issue', NULL, 35, '2022-11-23', '2022-11-29', '2022-11-29', '2', 3, 'jlacaba', '2022-2072', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9981, 'DATA-SPT-EBG Tendam Brands Sales concern', NULL, 35, '2022-11-23', '2022-12-06', '2022-12-06', '1', 3, 'jlacaba', '2022-2073', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9982, 'DATA-SPT-IS Group Transfer movement ETL updates', NULL, 35, '2022-11-24', NULL, NULL, '53.5', 1, 'jlacaba', '2022-2074', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9983, 'ITSysOps - ISCI - 2023 Zara Trinoma Renovation Store / Caballero and External WHSE Construction', NULL, 81, '2022-11-24', '2023-04-30', NULL, '10.25', 1, 'cccalma', '2022-2075', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9984, 'ITSysOps - ISCI - 2023 3rd Floor Enzo Head Office Additional Space', NULL, 81, '2022-11-14', '2023-01-31', NULL, '13.5', 1, 'cccalma', '2022-2076', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9985, 'BLD - SPT - EWMS - No Data on the Scanner', NULL, 13, '2022-11-24', '2022-11-25', '2022-11-25', '1', 3, 'jquijano', '2022-2077', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9986, 'DATA-SPT-SOB Checking', NULL, 35, '2022-11-25', '2022-12-23', '2022-12-23', '23', 3, 'jlacaba', '2022-2078', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9987, 'BLD - SPT - EWMS - The Scanner Name is Incorrect', NULL, 13, '2022-11-25', '2022-11-25', '2022-11-25', '0.75', 3, 'jquijano', '2022-2079', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9988, 'ERP - PRJ - Inquire Data Queue Entries Enhancement for MUJI', NULL, 26, '2022-11-28', NULL, NULL, '16.75', 1, 'jsfrance', '2022-2080', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(9989, 'BLD - SPT - EWMS - There are No Component SKUs in the Report', NULL, 13, '2022-11-28', '2022-12-01', '2022-12-01', '6', 3, 'jquijano', '2022-2081', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9990, 'DATA-SPT-Payless End of Week Consolidated Inventory Report Issue', NULL, 35, '2022-11-29', '2022-12-23', '2022-12-23', '4', 3, 'malejandro', '2022-2082', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9991, 'BLD - SPT - ICS - The Count Data Has Error When Converted', NULL, 13, '2022-11-29', '2022-12-01', '2022-12-01', '1.5', 3, 'jquijano', '2022-2083', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9992, 'HOLIDAY', NULL, 118, '2022-11-30', '2022-11-30', '2022-11-30', NULL, 3, 'sbleria', '2022-2084', NULL, NULL, 3, 8, NULL, NULL, NULL, NULL),
(9993, 'APPSPT-SPT-PENTAHO MUJI SUPPORT - December 2022', NULL, 8, '2022-12-01', '2022-12-31', NULL, '33.5', 3, 'yemagnaye', '2022-2085', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9994, 'APPSPT-SPT-PENTAHO SUPPORT - December 2022', NULL, 8, '2022-12-01', '2022-12-31', NULL, '88.25', 3, 'yemagnaye', '2022-2086', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9995, 'APPSPT-SPT-PENTAHO-Fused Sales Refresh - December 2022', NULL, 8, '2022-12-01', '2022-12-31', NULL, '10.5', 3, 'yemagnaye', '2022-2087', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9996, 'APPSPT-SPT-QLIKSENSE SUPPORT - December 2022', NULL, 8, '2022-12-01', '2022-12-31', NULL, '2.75', 3, 'yemagnaye', '2022-2088', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9997, 'APPSPT-SPT-NAV SUPPORT - December 2022', NULL, 8, '2022-12-01', '2022-12-31', NULL, '11.75', 3, 'yemagnaye', '2022-2089', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9998, 'APPSPT-SPT-ERIC SUPPORT - December 2022', NULL, 8, '2022-12-01', '2022-12-31', NULL, '20', 3, 'yemagnaye', '2022-2090', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(9999, 'APPSPT-SPT-INSYS SUPPORT - December 2022', NULL, 8, '2022-12-01', '2022-12-31', NULL, '4.75', 3, 'yemagnaye', '2022-2091', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10000, 'APPSPT-SPT-Item Creation - December 2022', NULL, 8, '2022-12-01', '2022-12-31', NULL, '30', 3, 'yemagnaye', '2022-2092', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10001, 'APPSPT-SPT-FSRI EWMS - December 2022', NULL, 8, '2022-12-01', '2022-12-31', NULL, '43.5', 3, 'yemagnaye', '2022-2093', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10002, 'DATA-SPT-Tod\'s Hierarchy update', NULL, 35, '2022-12-01', '2022-12-06', NULL, '1', 3, 'jlacaba', '2022-2094', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10003, 'DATA-PRJ-Roger Vivier Report Creation', NULL, 35, '2022-12-02', '2022-12-16', '2022-12-16', '1', 3, 'jlacaba', '2022-2095', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10004, 'DATA-SPT-FSRI Inventory concern', NULL, 35, '2022-12-02', '2022-12-20', '2022-12-20', '0.5', 3, 'jlacaba', '2022-2096', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10005, 'ITD-SFRI-INFRA-SALADSTOP GRAND CENTRAL', NULL, 139, '2022-11-17', NULL, NULL, '15', 1, 'dpquinagoran', '2022-2097', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10006, 'ITD-ISCI-INFRA-PPC ZARA', NULL, 139, '2022-11-16', NULL, NULL, '41.5', 1, 'dpquinagoran', '2022-2098', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10007, 'ITD-SSI-INFRA-Cartier GB3', NULL, 139, '2022-11-24', NULL, NULL, '5', 1, 'dpquinagoran', '2022-2099', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10008, 'ITSysOps - ISCI - 2022 ZARA Trinoma CRO Opening', NULL, 81, '2022-12-01', '2023-04-30', NULL, '12.75', 1, 'irlatube', '2022-2100', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10009, 'ERP - PRJ - Inquire by Store/Date/Register Report in Fused', NULL, 26, '2022-12-05', NULL, NULL, '18.5', 1, 'jsfrance', '2022-2101', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10010, 'DATA-SPT-Hermes and Roger Vivier Report Creation', NULL, 35, '2022-12-05', '2023-01-10', '2023-01-10', '63.25', 3, 'malejandro', '2022-2102', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10011, 'ERP - SPT - Trunc Overselling Issue', NULL, 11, '2022-12-05', '2022-12-08', '2022-12-08', '13.5', 3, 'rgomez', '2022-2103', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10012, 'BLD - SPT - Barcode - Barcode in Not Read by the Scanner', NULL, 13, '2022-12-05', '2022-12-29', '2022-12-29', '1.75', 3, 'jquijano', '2022-2104', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10013, 'DATA-SPT-3MP Sales Checking', NULL, 35, '2022-12-05', '2022-12-19', '2022-12-19', '10', 3, 'jlacaba', '2022-2105', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10014, 'BLD - SPT - SSI Document', NULL, 27, '2022-12-06', NULL, NULL, '8.5', 1, 'jgonzales', '2022-2106', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10015, 'DATA-SPT-IS Group Masterfile Uploading', NULL, 35, '2022-12-06', NULL, NULL, '18', 1, 'malejandro', '2022-2107', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10016, 'DATA-SPT-L\'Occitane Data Harvest concern', NULL, 35, '2022-12-06', NULL, NULL, '3.5', 1, 'jlacaba', '2022-2108', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10017, 'DATA-SPT-FSRI Onhand Masterfile transmission concern', NULL, 35, '2022-12-07', '2022-12-19', '2022-12-19', '7.5', 3, 'jlacaba', '2022-2109', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10018, 'DATA-SPT-RMSI Price event uploading concern', NULL, 35, '2022-12-07', '2022-12-19', '2022-12-19', '2.5', 3, 'jlacaba', '2022-2110', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10019, 'BLD - SPT - Swarovski EDI - Link Offsite Sales to MOA Store', NULL, 13, '2022-12-07', '2023-01-16', '2023-01-16', '31.25', 3, 'jquijano', '2022-2111', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10020, 'DATA-SPT-QS Brand Performance report request', NULL, 35, '2022-12-07', '2023-01-30', '2023-01-30', '3.5', 3, 'jlacaba', '2022-2112', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10021, 'ERP - SPT - CK Hierarchy Update', NULL, 11, '2022-12-07', '2022-12-22', '2022-12-22', '1.5', 3, 'rgomez', '2022-2113', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10022, 'DATA-SPT-MPC Price event checking', NULL, 35, '2022-12-09', '2022-12-20', '2022-12-20', '1.5', 3, 'jlacaba', '2022-2114', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10023, 'DATA-SPT-Max & Co Outbound Sales concern', NULL, 35, '2022-12-09', '2022-12-19', '2022-12-19', '6.5', 3, 'jlacaba', '2022-2115', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10024, 'BLD - SPT - ICS - Check the Updating of the Masterfile', NULL, 13, '2022-12-09', '2022-12-12', '2022-12-12', '7', 3, 'jquijano', '2022-2116', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10025, 'ERP - PRJ - Reprint Putaway Worksheet Enhancement', NULL, 26, '2022-12-12', NULL, NULL, '18.75', 1, 'jsfrance', '2022-2117', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10026, 'ITSysOps - ISCI - 2022 Zara and BSK Additional HIPOS', NULL, 81, '2022-12-05', '2022-12-27', NULL, '1.25', 1, 'cccalma', '2022-2118', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10027, 'DATA-SPT-Trunc Sales Report checking', NULL, 35, '2022-12-12', NULL, NULL, '2', 1, 'jlacaba', '2022-2119', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10028, 'BLD - PRJ - Swarovski EDI Revamp', NULL, 27, '2022-12-13', NULL, NULL, NULL, 6, 'jgonzales', '2022-2120', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10029, 'DATA-SPT-Clarks PO Summary Report Concern', NULL, 35, '2022-12-13', '2023-01-10', '2023-01-10', '3', 3, 'malejandro', '2022-2121', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10030, 'DATA-SPT Payless Inventory data Issue', NULL, 35, '2022-12-13', NULL, '2022-12-19', '2.5', 3, 'malejandro', '2022-2122', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10031, 'DATA-SPT-MPC Price Event concern', NULL, 35, '2022-12-13', '2022-12-23', '2022-12-23', '2', 3, 'jlacaba', '2022-2123', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10032, 'DATA-SPT-Cortefiel Inventory Report concern', NULL, 35, '2022-12-13', '2023-01-10', '2023-01-10', '2.5', 3, 'jlacaba', '2022-2124', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10033, 'DATA-SPT-ETP Planning', NULL, 35, '2022-12-14', NULL, NULL, '3', 1, 'jlacaba', '2022-2125', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10034, 'DATA-SPT-IS Group XML Data transmission to new servers', NULL, 35, '2022-12-14', '2023-01-30', '2023-01-30', '24', 3, 'jlacaba', '2022-2126', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10035, 'BLD - SPT - CMT - The File is Not Uploaded', NULL, 13, '2022-12-14', '2022-12-16', '2022-12-16', '11.5', 3, 'jquijano', '2022-2127', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10036, 'DATA-SPT-Trunc Consignment PO confirmation report concern', NULL, 35, '2022-12-15', '2022-12-20', '2022-12-20', '1.5', 3, 'jlacaba', '2022-2128', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10037, 'ERP - PRJ - PO Pending Report for Pottery Barn', NULL, 11, '2022-12-15', '2022-12-15', '2022-12-15', '0.75', 3, 'rgomez', '2022-2129', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10038, 'DATA-SPT-SSI - Stock Onhand Report ETL Issue', NULL, 35, '2022-12-16', '2022-12-20', '2022-12-20', '2', 3, 'malejandro', '2022-2130', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10039, 'BLD - SPT - Barcode - Attend to the User Concern Regarding Price Event Barcode Printing', NULL, 13, '2022-12-16', '2022-12-16', '2022-12-16', '2.25', 3, 'jquijano', '2022-2131', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10040, 'ADMIN', NULL, 67, '2022-12-19', NULL, NULL, NULL, 1, 'msarriba', '2022-2132', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10041, 'ERP - PRJ - Transfer Search Batch Update of Receipts Enhancement', NULL, 26, '2022-12-19', NULL, NULL, '20.75', 1, 'jsfrance', '2022-2133', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10042, 'ITD-SSIG-GEN-ETP POS Implementation', NULL, 23, '2022-11-29', '2024-12-31', NULL, '79.25', 1, 'mmagboo', '2022-2134', NULL, NULL, 1, NULL, 'https://drive.google.com/drive/folders/1geruC3RrwbXXSOAoiOWBCvq8JcZzZUWR?usp=share_link', NULL, NULL, NULL),
(10043, 'ERP - SPT - RMSI Setup of Items With Multiple Vendors', NULL, 11, '2022-12-19', '2022-12-20', '2022-12-20', '4', 3, 'rgomez', '2022-2135', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10044, 'DATA-SPT-SSI - Sell Thru Summary Report Concern', NULL, 35, '2022-12-20', '2023-01-10', '2023-01-10', '2', 3, 'malejandro', '2022-2136', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10045, 'DATA-SPT-SLCI Refresh Concerns', NULL, 35, '2022-12-20', '2022-12-23', '2022-12-23', '1', 3, 'jlacaba', '2022-2137', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10046, 'BLD - PRJ - Swarovski EDI Revamp 2023', NULL, 27, '2022-12-20', NULL, NULL, '6.5', 1, 'jgonzales', '2022-2138', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10047, 'BLD - SPT - Barcode - Provide Assistance to the User Concern', NULL, 13, '2022-12-20', '2022-12-29', '2022-12-29', '2.25', 3, 'jquijano', '2022-2139', NULL, NULL, 2, NULL, NULL, 'Tech checked the concern.', NULL, NULL),
(10048, 'BLD - SPT - Hamleys Franchise Reposting - No Sales Is Generated', NULL, 13, '2022-12-20', '2022-12-20', '2022-12-20', '1', 3, 'jquijano', '2022-2140', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10049, 'DATA-SPT-SSI - 172.16.1.175 Server Issue', NULL, 35, '2022-12-21', '2022-12-23', '2022-12-23', '4', 3, 'malejandro', '2022-2141', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10050, 'ERP - SPT - Warehouse management System for Lacoste Warehouse', NULL, 11, '2022-12-21', NULL, NULL, '2', 6, 'rgomez', '2022-2142', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10051, 'DATA-SPT Pentaho Services Directory', NULL, 35, '2022-12-22', NULL, NULL, '31.5', 1, 'jlacaba', '2022-2143', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10052, 'ITSysOps - ISCI - 2023 Zara Megamall External Warehouse', NULL, 81, '2022-12-19', '2023-03-31', NULL, '1.25', 1, 'cccalma', '2022-2144', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10053, 'ERP - SPT - Pending PO Report for Pottery Barn', NULL, 11, '2022-12-22', '2022-12-22', '2022-12-22', '3.5', 3, 'rgomez', '2022-2145', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10054, 'ERP - PRJ - Options Table Maintenance Enhancement', NULL, 26, '2022-12-27', NULL, NULL, '14.5', 1, 'jsfrance', '2022-2146', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10055, 'DATA-SPT-WSI Brands refresh concern', NULL, 35, '2022-12-27', '2023-01-10', '2023-01-10', '1', 3, 'jlacaba', '2022-2147', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10056, 'BLD - SPT - Pottery Barn XML Extraction - Attend to the User Concern', NULL, 13, '2022-12-27', '2022-12-29', '2022-12-29', '7.5', 3, 'jquijano', '2022-2148', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10057, 'DATA-SPT-FSRI Masterfile transmission', NULL, 35, '2022-12-27', '2022-12-29', '2022-12-29', '2', 3, 'jlacaba', '2022-2149', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10058, 'APPSPT-ERIC-Renewal of License for 2023', NULL, 8, '2022-12-28', NULL, NULL, '9', 3, 'yemagnaye', '2022-2150', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10059, 'DATA-SPT-Korres Style description concern', NULL, 35, '2022-12-28', '2023-02-07', '2023-02-07', '2.5', 3, 'jlacaba', '2022-2151', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10060, 'DATA-SPT SLCI Refresh concern', NULL, 35, '2022-12-28', '2023-01-30', '2023-01-30', '1.75', 3, 'jlacaba', '2022-2152', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10061, 'DATA-SPT-11.119 Server Issue', NULL, 35, '2022-12-28', '2023-02-07', '2023-02-07', '2', 3, 'jlacaba', '2022-2153', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10062, 'ERP - SPT - JDA Year End Activity (2022)', NULL, 11, '2022-12-28', '2023-01-02', '2023-01-02', '9.5', 3, 'rgomez', '2022-2154', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10063, 'DATA-SPT-Lexer file re-generation', NULL, 35, '2022-12-28', '2023-01-30', '2023-01-30', '2', 3, 'jlacaba', '2022-2155', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10064, 'BLD - SPT - 11.119 Applications - Error in Connection', NULL, 13, '2022-12-28', '2022-12-29', '2022-12-29', '4', 3, 'jquijano', '2022-2156', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10065, 'ERP - SPT - Bally Items for Depletion', NULL, 11, '2022-12-29', '2022-12-29', '2022-12-29', '3.5', 3, 'rgomez', '2022-2157', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10066, 'DATA-SPT-FSRI Inventory Workback issue', NULL, 35, '2022-12-29', '2023-01-10', '2023-01-10', '22.5', 3, 'jlacaba', '2022-2158', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10067, 'Nate New tickets', NULL, 105, '2022-12-31', '2022-12-31', NULL, NULL, NULL, 'jgonzales', '2022-2159', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10070, 'ITD-SSI-INFRA-CLARKS SLPI', NULL, 139, '2022-12-15', NULL, NULL, '11', 1, 'dpquinagoran', '2022-2162', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10071, 'ITD-SSI-INFRA-Globe SDWAN', NULL, 139, '2022-12-15', NULL, NULL, '1', 1, 'dpquinagoran', '2022-2163', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10072, 'BLD - SPT - PAT2 - Can\'t Add New Ticket', NULL, 13, '2023-01-03', '2023-01-04', '2023-01-04', '3.25', 3, 'jquijano', '2023-0001', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10073, 'ERP - PRJ - Menu File Maintenance Enhancement', NULL, 26, '2023-01-03', NULL, NULL, '19', 1, 'jsfrance', '2023-0002', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10074, 'SSI-SYSOPS- Administrative Tasks - 2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '577.5', 1, 'ahortega', '2023-0003', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10075, 'SSI-SYSOPS-000-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '78', 1, 'ahortega', '2023-0004', NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL),
(10078, 'SSI-SYSOPS-Change of JDA Access-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, NULL, 1, 'ahortega', '2023-0007', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10079, 'SSI-SYSOPS-CMT-New Access Creation-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, NULL, 1, 'ahortega', '2023-0008', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10080, 'SSI-SYSOPS-COS-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '350.25', 1, 'ahortega', '2023-0009', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10081, 'SSI-SYSOPS-ESB & PM for JDAProd Sys Activities-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, NULL, 1, 'ahortega', '2023-0010', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10082, 'SSI-SYSOPS-ETQ Report-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '9', 1, 'ahortega', '2023-0011', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10083, 'DATA-PRJ-Prada/Prada OS Consolidated Report', NULL, 35, '2023-01-03', NULL, NULL, '50.75', 1, 'jlacaba', '2023-0012', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10084, 'SSI-SYSOPS-Freezing of Inventory-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '12', 1, 'ahortega', '2023-0013', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10085, 'SSI-SYSOPS-FTP File Transfer-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '55.5', 1, 'ahortega', '2023-0014', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10086, 'SSI-SYSOPS-ITEM CREATION-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '14.5', 1, 'ahortega', '2023-0015', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10087, 'SSI-SYSOPS-JDA Access Creation-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '4.5', 1, 'ahortega', '2023-0016', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10088, 'SSI-SYSOPS-JDA Access Reactivation-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '1.75', 1, 'ahortega', '2023-0017', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10089, 'SSI-SYSOPS-JDA Fused Migration-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, NULL, 1, 'ahortega', '2023-0018', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10090, 'SSI-SYSOPS-Loading of Sales-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '775.5', 1, 'ahortega', '2023-0019', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10091, 'APPSPT-SPT-Lexer Daily Monitoring 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '9.25', 1, 'yemagnaye', '2023-0020', NULL, NULL, 2, 63, NULL, NULL, NULL, NULL),
(10092, 'SSI-SYSOPS-Meeting-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '11', 1, 'ahortega', '2023-0021', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10093, 'SSI-SYSOPS-Merchandise Table-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '20', 1, 'ahortega', '2023-0022', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10094, 'SSI-SYSOPS-New MOP-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '0.5', 1, 'ahortega', '2023-0023', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10095, 'SSI-SYSOPS-PB XML EXTRACTION-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '81.5', 1, 'ahortega', '2023-0024', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10096, 'SSI-SYSOPS-Pentaho Refresh-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '53', 1, 'ahortega', '2023-0025', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10097, 'SSI-SYSOPS-PIM-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '1', 1, 'ahortega', '2023-0026', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10098, 'SSI-SYSOPS-Polling-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '163.75', 1, 'ahortega', '2023-0027', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10099, 'SSI-SYSOPS-Posting of Inventory-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '23', 1, 'ahortega', '2023-0028', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10100, 'SSI-SYSOPS-Price Event-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '3.25', 1, 'ahortega', '2023-0029', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10101, 'SSI-SYSOPS-Sales Conversion-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '2', 1, 'ahortega', '2023-0030', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10102, 'SSI-SYSOPS-Shipment Pending-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '1.25', 1, 'ahortega', '2023-0031', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10103, 'SSI-SYSOPS-Support-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '398.75', 1, 'ahortega', '2023-0032', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10104, 'SSI-SYSOPS-Training/Demo-2023', NULL, 79, '2023-01-01', '2023-12-31', NULL, '12', 1, 'ahortega', '2023-0033', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10105, 'APPSPT-SPT-SODI File Monitoring 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '20.5', 1, 'yemagnaye', '2023-0034', NULL, NULL, 2, 150, NULL, NULL, NULL, NULL),
(10106, 'APPSPT-SPT-GAP/BR/ON SLCI New Feed System 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '12', 1, 'yemagnaye', '2023-0035', NULL, NULL, 2, 80, NULL, NULL, NULL, NULL),
(10107, 'APPSPT-SPT-IAS-End of the month for SSI and Transwell 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '12', 1, 'yemagnaye', '2023-0036', NULL, NULL, 2, 100, NULL, NULL, NULL, NULL),
(10108, 'APPSPT-ADM-Administrative Tasks 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '19.75', 1, 'yemagnaye', '2023-0037', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10109, 'APPSPT-ADM-Team Improvement/Training/Knowledge Sharing 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '13', 1, 'yemagnaye', '2023-0038', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10110, 'APPSPT-SPT-Database Backup NAV 2009 and 2017 ERIC and INSYS 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '40', 1, 'yemagnaye', '2023-0039', NULL, NULL, 2, 250, NULL, NULL, NULL, NULL),
(10111, 'APPSPT-SPT-PENTAHO MUJI SUPPORT - January 2023', NULL, 8, '2023-01-01', '2023-01-31', NULL, '26.75', 3, 'yemagnaye', '2023-0040', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10112, 'APPSPT-SPT-PENTAHO SUPPORT - January 2023', NULL, 8, '2023-01-01', '2023-01-31', NULL, '108.5', 3, 'yemagnaye', '2023-0041', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10113, 'APPSPT-SPT-PENTAHO-Fused Sales Refresh - January 2023', NULL, 8, '2023-01-01', '2023-01-31', NULL, '13', 3, 'yemagnaye', '2023-0042', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10114, 'APPSPT-SPT-QLIKSENSE SUPPORT - January 2023', NULL, 8, '2023-01-01', '2023-01-31', NULL, '1', 3, 'yemagnaye', '2023-0043', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10115, 'APPSPT-SPT-NAV SUPPORT - January 2023', NULL, 8, '2023-01-01', '2023-01-31', NULL, '30.25', 3, 'yemagnaye', '2023-0044', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `txn_tickets` (`id`, `description`, `entity_id`, `ticket_manager_id`, `start_date`, `end_date`, `closed_date`, `total_hours`, `status_id`, `added_by`, `ticket_ref`, `created_at`, `updated_at`, `ticket_type_id`, `estimate_hours`, `repository`, `remarks`, `ticket_description`, `ticket_member_ids`) VALUES
(10116, 'APPSPT-SPT-ERIC SUPPORT - January 2023', NULL, 8, '2023-01-01', '2023-01-31', NULL, '6', 3, 'yemagnaye', '2023-0045', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10117, 'APPSPT-SPT-INSYS SUPPORT - January 2023', NULL, 8, '2023-01-01', '2023-01-31', NULL, NULL, 3, 'yemagnaye', '2023-0046', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10118, 'APPSPT-SPT-Item Creation - January 2023', NULL, 8, '2023-01-01', '2023-01-31', NULL, '23.5', 3, 'yemagnaye', '2023-0047', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10119, 'APPSPT-SPT-FSRI EWMS - January 2023', NULL, 8, '2023-01-01', '2023-01-31', NULL, '19.5', 3, 'yemagnaye', '2023-0048', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10120, 'APPSPT-SPT-JSON File Monitoring 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '2.5', 1, 'yemagnaye', '2023-0049', NULL, NULL, 2, 26, NULL, NULL, NULL, NULL),
(10121, 'APPSPT-SPT-PAT SUPPORT 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '1', 1, 'yemagnaye', '2023-0050', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10122, 'APPSPT-SPT-IAS SUPPORT 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '4', 1, 'yemagnaye', '2023-0051', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10123, 'APPSPT-SPT-IAS Daily Task 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '26', 1, 'yemagnaye', '2023-0052', NULL, NULL, 2, 242, NULL, NULL, NULL, NULL),
(10124, 'APPSPT-SPT-ITSD Team Meeting 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '12', 1, 'yemagnaye', '2023-0053', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10125, 'ERP - SPT - JDA Functional Supports (2023)', NULL, 11, '2023-01-01', '2023-12-31', NULL, '78.75', 1, 'rgomez', '2023-0054', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10126, 'ERP - SPT - JDA Technical Supports (2023)', NULL, 11, '2023-01-01', '2023-12-31', NULL, NULL, NULL, 'rgomez', '2023-0055', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10127, 'ERP - SPT - JDA Technical Supports (2023)', NULL, 11, '2023-01-01', '2023-12-31', NULL, '142.5', 1, 'rgomez', '2023-0056', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10128, 'ITD-EBG-Trunc Marketplace Support 2023', NULL, 23, '2023-01-01', '2023-12-31', '2023-12-31', '789.5', 1, 'mmagboo', '2023-0057', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10129, 'ITD-SLCI-EBG-Gap/BR/ON Support  2023', NULL, 71, '2023-01-01', '2023-12-31', NULL, '2', 1, 'casenci', '2023-0058', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10130, 'ITD-SLCI-EBG-Old Navy Support 2023', NULL, 71, '2023-01-01', '2023-12-31', NULL, '95', 1, 'casenci', '2023-0059', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10131, 'ITD-SLCI-EBG-Gap Support 2023', NULL, 71, '2023-01-01', '2023-12-31', NULL, '86.25', 1, 'casenci', '2023-0060', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10132, '2023-SSI-TECHSUPPORT-ADMIN TASKS', NULL, 87, '2023-01-01', '2023-12-31', NULL, '45.25', 1, 'rsronquillo', '2023-0061', NULL, NULL, 3, NULL, NULL, 'ADMIN TASKS', NULL, NULL),
(10133, '2023-SSI-TECHSUPPORT-HEAD OFFICE SUPPORT', NULL, 87, '2023-01-01', '2023-12-31', NULL, '157.5', 1, 'rsronquillo', '2023-0062', NULL, NULL, 2, NULL, NULL, 'HEAD OFFICE SUPPORT', NULL, NULL),
(10134, 'ITD-SLCI-EBG-Banana Republic Support 2023', NULL, 71, '2023-01-01', '2023-12-31', NULL, '60.25', 1, 'casenci', '2023-0063', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10135, 'ITD-FSRI-Payless Support 2023', NULL, 71, '2023-01-01', '2023-12-31', NULL, '34.25', 1, 'casenci', '2023-0064', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10136, '2023-SSI-TECHSUPPORT-MEETING', NULL, 87, '2023-01-01', '2023-12-31', NULL, NULL, NULL, 'rsronquillo', '2023-0065', NULL, NULL, 2, NULL, NULL, 'MEETINGS', NULL, NULL),
(10137, 'ITD-SSIG-GEN-SSI Group Corporate Website Support 2023', NULL, 71, '2023-01-01', '2023-12-31', NULL, NULL, 1, 'casenci', '2023-0066', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10138, 'ITD-SSIG-GEN-SSI Life Website Support 2023', NULL, 71, '2023-01-01', '2023-12-31', NULL, '8', 1, 'casenci', '2023-0067', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10139, '2023-SSI-TECHSUPPORT-MEETING', NULL, 87, '2023-01-01', '2023-12-31', NULL, '16.5', 1, 'rsronquillo', '2023-0068', NULL, NULL, 3, NULL, NULL, 'MEETINGS', NULL, NULL),
(10140, 'ITD-SSIG-EBG-Lush Support 2023', NULL, 71, '2023-01-01', '2023-12-31', NULL, '37.25', 1, 'casenci', '2023-0069', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10141, '2023-SSI-TECHSUPPORT-OOO', NULL, 87, '2023-01-01', '2023-12-31', NULL, '86', 1, 'rsronquillo', '2023-0070', NULL, NULL, 4, NULL, NULL, 'OOO', NULL, NULL),
(10142, 'ITSD OOO 2023', NULL, 11, '2023-01-01', '2023-12-31', NULL, '316', 1, 'rgomez', '2023-0071', NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL),
(10143, '2023-SSI-TECHSUPPORT-STORE SUPPORT', NULL, 87, '2023-01-01', '2023-12-31', NULL, '748.5', 1, 'rsronquillo', '2023-0072', NULL, NULL, 2, NULL, NULL, 'STORE SUPPORT', NULL, NULL),
(10144, '2023-SSI-TECHSUPPORT-TRAINING', NULL, 87, '2023-01-01', '2023-12-31', NULL, NULL, NULL, 'rsronquillo', '2023-0073', NULL, NULL, 3, NULL, NULL, 'TRAINING', NULL, NULL),
(10145, '2023-SSI-TECHSUPPORT-PROJECTS', NULL, 87, '2023-01-01', '2023-12-31', NULL, '3.25', 1, 'rsronquillo', '2023-0074', NULL, NULL, 1, NULL, NULL, 'PROJECT SUPPORT', NULL, NULL),
(10146, 'ITD-SSI-ENT-Lexer Support 2023', NULL, 70, '2023-01-01', '2023-12-31', NULL, '0.5', 1, 'jtolentino', '2023-0075', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10147, 'ITD-SSIG-EBG-BeautyBar Support 2023', NULL, 70, '2023-01-01', '2023-12-31', NULL, '74.75', 1, 'jtolentino', '2023-0076', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10148, 'ITD-SSIG-EBG-Dune Support 2023', NULL, 70, '2023-01-01', '2023-12-31', NULL, '6.75', 1, 'jtolentino', '2023-0077', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10150, 'ITD-SSIG-EBG-Lacoste Support 2023', NULL, 70, '2023-01-01', '2023-12-31', NULL, '22.5', 1, 'jtolentino', '2023-0079', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10151, 'ITD-SSIG-EBG-Superga Support 2023', NULL, 70, '2023-01-01', '2023-12-31', NULL, '14.5', 1, 'jtolentino', '2023-0080', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10152, 'ITD-SSIG-RMSI-M&S Support 2023', NULL, 70, '2023-01-01', '2023-12-31', NULL, '55', 1, 'jtolentino', '2023-0081', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10154, 'DATA-Admin tasks, Meetings and Knowledge Sharing - 2023', NULL, 35, '2023-01-01', NULL, NULL, '63.75', 1, 'jlacaba', '2023-0083', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10155, 'DATA-SPT-EBG Sales Checking', NULL, 35, '2023-01-03', NULL, NULL, '15.5', 1, 'jlacaba', '2023-0084', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10156, 'DATA-SPT-General Inquiries and Support 2023', NULL, 35, '2023-01-03', NULL, NULL, '0.5', 1, 'jlacaba', '2023-0085', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10157, 'BLD - SPT - HiPOS Mall Sending - Data Issue in the Application', NULL, 13, '2023-01-03', '2023-01-06', '2023-01-06', '7', 3, 'jquijano', '2023-0086', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10158, 'EBG-AdminTasks-2023', NULL, 66, '2023-01-03', '2023-12-31', NULL, '246.5', 1, 'sbly', '2023-0087', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10159, 'EBG-OOO-2023', NULL, 66, '2023-01-03', '2023-12-31', NULL, '190.5', 1, 'sbly', '2023-0088', NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL),
(10160, 'EBG-PimCORE-Gen-Build-Support-2023', NULL, 66, '2023-01-03', '2023-12-31', NULL, '98.5', 1, 'sbly', '2023-0089', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10162, 'ITD-SSI-INFRA-LUSH ATC', NULL, 139, '2022-12-16', NULL, NULL, '5', 1, 'dpquinagoran', '2022-2164', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10163, 'SLCI Sales Refresh Concern 2023', NULL, 35, '2023-01-04', '2023-01-30', '2023-01-30', '9.75', 3, 'jlacaba', '2023-0091', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10164, 'DATA-SPT-3MP Sales Checking Nov 2022', NULL, 35, '2023-01-04', '2023-02-07', '2023-02-07', '18.5', 3, 'jlacaba', '2023-0092', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10165, 'DATA-SPT-Samsonite Inventory Report concern', NULL, 35, '2023-01-04', '2023-01-16', '2023-01-16', '2.5', 3, 'jlacaba', '2023-0093', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10166, 'DATA-SPT-Fused Brands Masterfile monitoring', NULL, 35, '2023-01-04', NULL, NULL, '4', 1, 'jlacaba', '2023-0094', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10167, 'BLD - SPT - Start of the week meeting 2023', NULL, 27, '2023-01-01', NULL, NULL, '26.5', 1, 'jgonzales', '2023-0095', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10168, 'BLD-SPT Team Projects Assistance/Clarification/QA/Research 2023', NULL, 27, '2023-01-05', NULL, NULL, '69.75', 1, 'jgonzales', '2023-0096', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10169, 'DATA-SPT-SOB Validation 2023', NULL, 35, '2023-01-05', NULL, NULL, '24', 1, 'jlacaba', '2023-0097', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10170, 'BLD - SPT - Pottery Barn XML Extraction - Error when Parsing', NULL, 13, '2023-01-03', '2023-01-06', '2023-01-06', '6', 3, 'jquijano', '2023-0098', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10171, 'BLD - SPT - Barcode - Provide Assistance to Tech in Fixing the Concern', NULL, 13, '2023-01-05', '2023-01-05', '2023-01-05', '0.75', 3, 'jquijano', '2023-0099', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10172, 'IT-CSQ OOO 2023', NULL, 83, '2023-01-01', NULL, NULL, '16', 1, 'emsantiago', '2023-0100', NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL),
(10173, 'BLD - SPT - Pottery Barn XML Extraction - Optimize the Query', NULL, 13, '2023-01-06', NULL, NULL, '13', 1, 'jquijano', '2023-0101', NULL, NULL, 2, NULL, NULL, NULL, 'When the application is parsing as a DAT file, it is too long to process, thus this application should be optimized. The DAT file consists of nested XML.', NULL),
(10175, 'ERP - PRJ - Piece Count Receipt Enhancement', NULL, 26, '2023-01-09', NULL, NULL, '24.5', 1, 'jsfrance', '2023-0103', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10176, 'DATA-SPT-Pottery Barn Item Creation Concern', NULL, 35, '2023-01-09', '2023-01-10', '2023-01-10', '4', 3, 'malejandro', '2023-0104', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10177, 'DATA-SPT-Bershka Document date Issue', NULL, 35, '2023-01-09', '2023-02-14', '2023-02-14', '2', 3, 'malejandro', '2023-0105', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10178, 'ERP - SPT - M&S Warehouse Stocktake (January 2023)', NULL, 11, '2023-01-09', '2023-01-09', '2023-01-09', '3.25', 3, 'rgomez', '2023-0106', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10179, 'DATA-SPT-Sales Report Per Brand Per Day', NULL, 35, '2023-01-09', NULL, NULL, '4.25', 1, 'jlacaba', '2023-0107', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10180, 'Store Support', NULL, 82, '2023-01-01', NULL, NULL, '85.75', 1, 'dmvillanueva', '2023-0108', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10181, 'BLD-SPT-ITSD Team Meeting 2023', NULL, 27, '2023-01-01', '2023-12-31', NULL, '11.5', 1, 'jgonzales', '2023-0109', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10182, 'DATA-SPT-FSRI Masterfile uploading concern', NULL, 35, '2023-01-10', '2023-01-16', '2023-01-16', '1', 3, 'jlacaba', '2023-0110', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10183, 'DATA-SPT-RMSI UPCs enrollment 2023', NULL, 35, '2023-01-10', NULL, NULL, '16.25', 1, 'jlacaba', '2023-0111', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10184, 'DATA-SPT-Lacoste CRM Data harvest monitoring 2023', NULL, 35, '2023-01-10', NULL, NULL, '51.5', 1, 'jlacaba', '2023-0112', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10185, 'ERP - SPT - MUJI Cafe MOSAIC System', NULL, 11, '2023-01-10', NULL, NULL, '2', 6, 'rgomez', '2023-0113', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10186, 'ITSysOps - ISCI - 2023 3rd floor - New office cabling', NULL, 81, '2023-01-09', NULL, NULL, '0.5', 1, 'irlatube', '2023-0114', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10187, 'DATA-SPT-Massimo Dutti Cost of Sales by UPC Concern', NULL, 35, '2023-01-11', '2023-02-07', '2023-02-07', '2', 3, 'malejandro', '2023-0115', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10188, 'DATA-SPT-Grupo Cortefiel Sales Report with Transaction Type', NULL, 35, '2023-01-11', '2023-01-30', '2023-01-30', '18', 3, 'malejandro', '2023-0116', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10189, 'DATA-SPT-RV and Hermes Data Issue', NULL, 35, '2023-01-11', '2023-01-30', '2023-01-30', '2.5', 3, 'jlacaba', '2023-0117', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10190, 'DATA-SPT-American Tourister Inventory Recompute request', NULL, 35, '2023-01-11', '2023-01-16', '2023-01-16', '1.5', 3, 'jlacaba', '2023-0118', NULL, NULL, 2, 3, NULL, NULL, NULL, NULL),
(10191, 'BLD - SPT - PAT2 - Enhancement Request in the Web Application', NULL, 27, '2023-01-11', NULL, NULL, '13.5', 1, 'jquijano', '2023-0119', NULL, NULL, 2, 8, NULL, NULL, 'This is the request for the web application to be added/modified. Entity Sharing - the file to be downloaded should be displayed on the new tab instead of the same URL. Tickets - The estimate should be required,  ticket description should be added, this is where the ticket details/comment will be inputted, fixed the inconsistency of redirecting back of the tickets (my tickets and my recent tickets) when it is edited on this page.', NULL),
(10192, 'BLD - ADM - Team Improvement/Training/Knowledge Sharing 2023', NULL, 27, '2023-01-02', NULL, NULL, '15', 1, 'jquijano', '2023-0120', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10193, 'DATA-SPT-Lexer Read Concern', NULL, 35, '2023-01-12', '2023-01-26', '2023-01-26', '12', 3, 'jlacaba', '2023-0121', NULL, NULL, 2, 12, NULL, NULL, 'Checking of Lexer Transactions that are not yet tagged as Lexer_read = 1.', NULL),
(10194, 'ISCI Store Support 2023', NULL, 92, '2023-01-01', '2023-12-31', NULL, '196', 1, 'jpmontalbo', '2023-0122', NULL, NULL, 2, NULL, NULL, NULL, 'SUPPORT STORE OPERATION for ZARA and BRANDS 2023', NULL),
(10195, 'DATA-SPT-Tendam Brands EDI Supports 2023', NULL, 35, '2023-01-12', NULL, NULL, '6', 1, 'jlacaba', '2023-0123', NULL, NULL, 2, 500, NULL, NULL, NULL, NULL),
(10196, 'ISCI HO Support 2023', NULL, 92, '2023-01-01', '2023-12-31', NULL, '60', 1, 'jpmontalbo', '2023-0124', NULL, NULL, 2, NULL, NULL, NULL, 'SUPPORT HEAD OFFICE 2023', NULL),
(10197, 'APPSPT-SPT-ERIC-Government Tables Update for 2023', NULL, 8, '2023-01-13', NULL, '2023-02-08', '17', 3, 'yemagnaye', '2023-0125', NULL, NULL, 2, 20, NULL, 'Completed', NULL, NULL),
(10198, 'DATA-SPT-GAP SOD Uploading concern', NULL, 35, '2023-01-13', NULL, '2023-01-16', '3', 3, 'jlacaba', '2023-0126', NULL, NULL, 2, 5, NULL, NULL, 'Checking on the SOD PO Detail uploading issue encountered by GAP Merch.', NULL),
(10199, 'ERP - SPT - Trunc Warehouse OOS', NULL, 11, '2023-01-13', NULL, NULL, '2.5', 1, 'rgomez', '2023-0127', NULL, NULL, 2, 4, NULL, NULL, NULL, NULL),
(10200, 'DATA-SPT-AX 4R4 Item Creation by SKU Issue', NULL, 35, '2023-01-13', '2023-01-16', '2023-01-16', '2', 3, 'malejandro', '2023-0128', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10201, 'BLD - SPT - ICS - The Data is Not Converted', NULL, 13, '2023-01-13', '2023-01-17', '2023-01-17', '3', 3, 'jquijano', '2023-0129', NULL, NULL, 2, 2, NULL, NULL, 'The count data for Zara BMS is not converting, it is not inserting into CYSERV in the blue yonder.', NULL),
(10202, 'ITSysOps- ISCI - 2023 - SO: IR', NULL, 81, '2023-01-01', '2023-12-31', '2023-12-31', '177.25', 1, 'irlatube', '2023-0130', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10203, 'ITSysOps- ISCI - 2023 - SO: DT', NULL, 81, '2023-01-01', '2023-12-31', '2023-12-31', '165.25', 1, 'irlatube', '2023-0131', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10204, 'ITSysOps - ISCI - Administrative Tasks - 2023', NULL, 81, '2023-01-01', '2023-12-31', '2023-12-31', '83.5', 1, 'irlatube', '2023-0132', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10205, 'ERP - PRJ - Workstation Defaults Maintenance Enhancement', NULL, 26, '2023-01-16', NULL, NULL, '21', 1, 'jsfrance', '2023-0133', NULL, NULL, 1, 40, NULL, NULL, NULL, NULL),
(10206, 'DATA-SPT-SLCI Workback concern', NULL, 35, '2023-01-16', '2023-01-16', '2023-01-16', '4.5', 3, 'jlacaba', '2023-0134', NULL, NULL, 2, 4, NULL, NULL, NULL, NULL),
(10207, 'BLD - SPT - TWL Masterfile Update - INVUPC is Not Updated', NULL, 13, '2023-01-16', '2023-01-16', '2023-01-16', '1.5', 3, 'jquijano', '2023-0135', NULL, NULL, 2, 2, NULL, NULL, 'the INVUPC in the UPC table (invupcsql) in MSSQL where the IAS is connected is not updated, resulting in missing a UPC in the report.', NULL),
(10208, 'DATA-SPT-Prada/Prada OS Sales data variance concern', NULL, 35, '2023-01-16', NULL, NULL, '1.5', 1, 'jlacaba', '2023-0136', NULL, NULL, 2, 10, NULL, NULL, 'Checking of the Sales data variance raised by SSI SysOps.', NULL),
(10209, 'ITSysOps - ISCI - 2023 Zara IVR with GSD', NULL, 81, '2023-01-16', '2023-01-31', NULL, '7.75', 1, 'cccalma', '2023-0137', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10210, 'ITSysOps - Support - 2023 DSL and SDWAN Upgrade for ALL Stores', NULL, 81, '2023-01-16', '2023-03-31', NULL, '11.5', 1, 'cccalma', '2023-0138', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10211, 'DATA-SPT-Tory Burch Transfer Batches missing in Pentaho', NULL, 35, '2023-01-17', NULL, NULL, '2', 1, 'jlacaba', '2023-0139', NULL, NULL, 2, 3, NULL, NULL, 'Checking of Tory Burch transfer batches not updated in Pentaho', NULL),
(10212, 'ERP - SPT - FSRI Online Store Negative Balances', NULL, 11, '2023-01-17', '2023-01-17', '2023-01-17', '3', 3, 'rgomez', '2023-0140', NULL, NULL, 2, 4, NULL, NULL, NULL, NULL),
(10213, 'DATA-SPT-Pull and Bear Inventory Concern', NULL, 35, '2023-01-17', '2023-02-07', '2023-02-07', '1', 3, 'jlacaba', '2023-0141', NULL, NULL, 2, 5, NULL, NULL, NULL, NULL),
(10214, 'DATA-SPT-IS Group BIR Report Concern', NULL, 35, '2023-01-18', '2023-01-30', '2023-01-30', '8.5', 3, 'malejandro', '2023-0142', NULL, NULL, 2, 20, NULL, NULL, NULL, NULL),
(10215, 'DATA-SPT-WMS End of Week Consolidated and Weekly Inventory Report Concern', NULL, 35, '2023-01-18', '2023-01-30', '2023-01-30', '8', 3, 'malejandro', '2023-0143', NULL, NULL, 2, 5, NULL, NULL, NULL, NULL),
(10216, 'ITSysOps - ISCI - 2023 WIFI Router Installation for Maya device', NULL, 81, '2023-01-16', '2023-03-31', NULL, '1.5', 1, 'cccalma', '2023-0144', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10217, '2023 IT Infrastructure Projects', NULL, 147, '2023-01-01', '2023-12-31', NULL, NULL, 1, 'gmbustamante', '2023-0145', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10218, '2023 IT Infrastructure: Support', NULL, 147, '2023-01-01', '2023-12-31', NULL, '2274', 1, 'gmbustamante', '2023-0146', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL),
(10219, '2023 IT Infrastructure OOO', NULL, 147, '2023-01-01', '2023-12-31', NULL, '40', 1, 'gmbustamante', '2023-0147', NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL),
(10220, '2023 IT Infrastructure Admin', NULL, 147, '2023-01-01', '2023-12-31', NULL, NULL, 1, 'gmbustamante', '2023-0148', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10221, 'ERP - SPT - JDA Emulator for Ipad', NULL, 26, '2023-01-19', NULL, NULL, '15', 1, 'rgomez', '2023-0149', NULL, NULL, 2, 40, NULL, NULL, NULL, NULL),
(10222, 'DATA-SPT-2023-Fused Brands Sales checking', NULL, 35, '2023-01-19', '2023-02-07', '2023-02-07', '4.5', 3, 'jlacaba', '2023-0150', NULL, NULL, 2, 500, NULL, NULL, NULL, NULL),
(10223, 'DATA-SPT-IS Group Nav Inventory vs JDA variance', NULL, 35, '2023-01-20', '2023-01-26', '2023-01-26', '37', 3, 'jlacaba', '2023-0151', NULL, NULL, 2, 100, NULL, NULL, NULL, NULL),
(10224, 'DATA-SPT-QS Data Checking 2023', NULL, 35, '2023-01-20', '2023-02-14', '2023-02-14', '1.5', 3, 'jlacaba', '2023-0152', NULL, NULL, 2, 300, NULL, NULL, NULL, NULL),
(10225, 'ERP - PRJ - TBLFLD Comparison Report Enhancement', NULL, 26, '2023-01-23', NULL, NULL, '20.75', 1, 'jsfrance', '2023-0153', NULL, NULL, 1, 40, NULL, NULL, NULL, NULL),
(10226, 'ERP - SPT - FSRI Warehouse Stocktake (Jan 2023)', NULL, 11, '2023-01-23', '2023-01-23', '2023-01-23', '4', 3, 'rgomez', '2023-0154', NULL, NULL, 2, 6, NULL, NULL, NULL, NULL),
(10227, 'BLD - SPT - Pottery Barn XML Extraction - Error Encountered When Parsing', NULL, 13, '2023-01-23', '2023-01-23', '2023-01-23', '3', 3, 'jquijano', '2023-0155', NULL, NULL, 2, 3, NULL, NULL, 'There is an error encountered when the application executed the store procedure when it is executing for parsing the DAT file.', NULL),
(10228, 'DATA-SPT-R&D on SnowFlakes SaaS', NULL, 35, '2023-01-23', NULL, NULL, '7.25', 1, 'jlacaba', '2023-0156', NULL, NULL, 2, 20, NULL, NULL, NULL, NULL),
(10229, 'ERP - SPT - RMSI Warehouse Stocktake  (January 2023)', NULL, 11, '2023-01-21', '2023-01-24', '2023-01-24', '1.75', 3, 'rgomez', '2023-0157', NULL, NULL, 2, 12, NULL, NULL, NULL, NULL),
(10230, 'DATA-SPT-Prada Sales and Arrival Concern', NULL, 35, '2023-01-24', '2023-01-30', '2023-01-30', '2', 3, 'malejandro', '2023-0158', NULL, NULL, 2, 10, NULL, NULL, NULL, NULL),
(10231, 'ITPMD-ADM 2023', NULL, 59, '2023-01-01', '2023-12-31', NULL, '180.5', 1, 'jtolentino', '2023-0159', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10232, 'ITPMD-OOO 2023', NULL, 59, '2023-01-01', '2023-12-31', NULL, '68', 1, 'jtolentino', '2023-0160', NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL),
(10233, 'ERP - PRJ - RTV Report Enhancement in Fused', NULL, 11, '2023-01-25', NULL, NULL, '1.75', 1, 'rgomez', '2023-0161', NULL, NULL, 1, 60, NULL, NULL, NULL, NULL),
(10234, 'ERP - SPT - Reclassification of Grupo Cortefiel items', NULL, 11, '2023-01-25', '2023-01-30', '2023-01-30', '2.5', 3, 'rgomez', '2023-0162', NULL, NULL, 2, 40, NULL, NULL, NULL, NULL),
(10235, 'DATA-SPT-QS 2023 QS Reports Request', NULL, 35, '2023-01-25', NULL, NULL, '1', 1, 'jlacaba', '2023-0163', NULL, NULL, 2, 300, NULL, NULL, NULL, NULL),
(10236, 'IT Ecomm Admin Tasks - 2023', NULL, 86, '2023-01-01', '2023-12-31', NULL, '10.5', 1, 'raisla', '2023-0164', NULL, NULL, 3, NULL, NULL, NULL, 'IT Ecomm Admin Tasks - 2023', NULL),
(10237, 'IT Ecomm Support Tasks - 2023', NULL, 86, '2023-01-01', '2023-12-31', NULL, '59', 1, 'raisla', '2023-0165', NULL, NULL, 2, NULL, NULL, NULL, 'IT Ecomm Support Tasks - 2023', NULL),
(10238, 'IT Ecomm Out of Office - 2023', NULL, 86, '2023-01-01', '2023-12-31', NULL, '16', 1, 'raisla', '2023-0166', NULL, NULL, 4, NULL, NULL, NULL, 'IT Ecomm Out of Office - 2023', NULL),
(10239, 'DATA-SPT-QS Cortefiel inventory Refresh', NULL, 35, '2023-01-26', '2023-01-30', '2023-01-30', '2.5', 3, 'jlacaba', '2023-0167', NULL, NULL, 2, 5, NULL, NULL, NULL, NULL),
(10240, 'ERP - SPT - Hermes Item Selection by Category in PE Creation', NULL, 11, '2023-01-26', NULL, NULL, '2.5', 1, 'rgomez', '2023-0168', NULL, NULL, 2, 10, NULL, NULL, NULL, NULL),
(10241, 'ERP - SPT - SAP Planning', NULL, 11, '2023-01-26', NULL, NULL, '1.5', 1, 'rgomez', '2023-0169', NULL, NULL, 2, 40, NULL, NULL, NULL, NULL),
(10242, 'DATA-SPT-POSReader Configuration for Delta setup 2023', NULL, 35, '2023-01-27', NULL, NULL, '9.75', 1, 'jlacaba', '2023-0170', NULL, NULL, 2, 500, NULL, NULL, NULL, NULL),
(10243, 'DATA-SPT-Superga Sales Data Issue', NULL, 35, '2023-01-27', '2023-01-30', '2023-01-30', '2', 3, 'malejandro', '2023-0171', NULL, NULL, 2, 5, NULL, NULL, NULL, NULL),
(10244, 'DATA-SPT-Burberry 5SS Season Issue', NULL, 35, '2023-01-27', '2023-02-14', '2023-02-14', '1', 3, 'malejandro', '2023-0172', NULL, NULL, 2, 5, NULL, NULL, NULL, NULL),
(10245, 'DATA-SPT-Dune Inventory Data Concern', NULL, 35, '2023-01-27', '2023-02-07', '2023-02-07', '1', 3, 'malejandro', '2023-0173', NULL, NULL, 2, 5, NULL, NULL, NULL, NULL),
(10246, '2023-SSI-TECHSUPPORT-TRAINING', NULL, 87, '2023-01-01', '2023-12-31', NULL, NULL, NULL, 'rsronquillo', '2023-0174', NULL, NULL, 3, NULL, NULL, 'TRAINING', NULL, NULL),
(10247, '2023-SSI-TECHSUPPORT-TRAINING', NULL, 87, '2023-01-01', '2023-12-31', NULL, '2', 1, 'rsronquillo', '2023-0175', NULL, NULL, 3, NULL, NULL, 'TRAINING', NULL, NULL),
(10248, 'ERP - PRJ - Timed Member Process Display Enhancement', NULL, 26, '2023-01-30', NULL, NULL, '21.5', 1, 'jsfrance', '2023-0176', NULL, NULL, 1, 40, NULL, NULL, NULL, NULL),
(10249, 'DATA-SPT-SSI ICG Inventory Workforward Concern', NULL, 35, '2023-01-30', '2023-02-07', '2023-02-07', '15', 3, 'malejandro', '2023-0177', NULL, NULL, 2, 100, NULL, NULL, NULL, NULL),
(10250, 'DATA-SPT-FSRI ICG Inventory Workback Concern', NULL, 35, '2023-01-30', '2023-02-07', '2023-02-07', '2', 3, 'malejandro', '2023-0178', NULL, NULL, 2, 10, NULL, NULL, NULL, NULL),
(10251, 'ERP - SPT - MUJI Spare Parts handling in JDA', NULL, 11, '2023-01-30', '2023-02-08', '2023-02-08', '2', 3, 'rgomez', '2023-0179', NULL, NULL, 2, 12, NULL, NULL, NULL, NULL),
(10252, 'ERP - PRJ - Receiver Authorization Document Enhancement', NULL, 11, '2023-01-30', NULL, NULL, '1', 1, 'rgomez', '2023-0180', NULL, NULL, 1, 40, NULL, NULL, NULL, NULL),
(10253, 'BLD - SPT - EWMS - Attend to the User Concern', NULL, 13, '2023-01-30', '2023-01-30', '2023-01-30', '0.5', 3, 'jquijano', '2023-0181', NULL, NULL, 2, 2, NULL, NULL, 'The TL is not synching in JDA.', NULL),
(10254, 'BLD - SPT -  Sales Monitoring Store Creation', NULL, 27, '2023-01-30', '2023-01-31', '2023-01-31', '6', 1, 'jgonzales', '2023-0182', NULL, NULL, 1, 4, NULL, NULL, 'Unable to create stores due to some data in JDA is not UTF8 encoded.', NULL),
(10255, 'ERP - SPT - SGV Requirements (2023)', NULL, 11, '2023-01-31', '2023-02-09', '2023-02-09', '3', 3, 'rgomez', '2023-0183', NULL, NULL, 2, 10, NULL, NULL, NULL, NULL),
(10256, 'DATA-SPT-IS Group New Paper Bags Issue', NULL, 35, '2023-01-31', '2023-02-14', '2023-02-14', '33', 3, 'malejandro', '2023-0184', NULL, NULL, 2, 50, NULL, NULL, NULL, NULL),
(10257, 'APPSPT-SPT-QLIKSENSE SUPPORT - February 2023', NULL, 8, '2023-02-01', '2023-02-28', NULL, '1', 1, 'yemagnaye', '2023-0185', NULL, NULL, 2, 5, NULL, NULL, NULL, NULL),
(10258, 'APPSPT-SPT-PENTAHO-Fused Sales Refresh - February 2023', NULL, 8, '2023-02-01', '2023-02-28', NULL, NULL, 1, 'yemagnaye', '2023-0186', NULL, NULL, 2, 10, NULL, NULL, NULL, NULL),
(10259, 'APPSPT-SPT-PENTAHO SUPPORT - February 2023', NULL, 8, '2023-02-01', '2023-02-28', NULL, '58.5', 1, 'yemagnaye', '2023-0187', NULL, NULL, 2, 50, NULL, NULL, NULL, NULL),
(10260, 'APPSPT-SPT-PENTAHO MUJI SUPPORT - February 2023', NULL, 8, '2023-02-01', '2023-02-28', NULL, '18', 1, 'yemagnaye', '2023-0188', NULL, NULL, 2, 20, NULL, NULL, NULL, NULL),
(10261, 'APPSPT-SPT-NAV SUPPORT - February 2023', NULL, 8, '2023-02-01', '2023-02-28', NULL, '6', 1, 'yemagnaye', '2023-0189', NULL, NULL, 2, 15, NULL, NULL, NULL, NULL),
(10262, 'APPSPT-SPT-Item Creation - February 2023', NULL, 8, '2023-02-01', '2023-02-28', NULL, '14.75', 1, 'yemagnaye', '2023-0190', NULL, NULL, 2, 20, NULL, NULL, NULL, NULL),
(10263, 'APPSPT-SPT-FSRI EWMS - February 2023', NULL, 8, '2023-02-01', '2023-02-28', NULL, '21', 1, 'yemagnaye', '2023-0191', NULL, NULL, 2, 20, NULL, NULL, NULL, NULL),
(10264, 'APPSPT-SPT-ERIC SUPPORT - February 2023', NULL, 8, '2023-02-01', '2023-02-28', NULL, '10.5', 1, 'yemagnaye', '2023-0192', NULL, NULL, 2, 10, NULL, NULL, NULL, NULL),
(10265, 'BLD - PRJ - Sales Monitoring Revamp', NULL, 27, '2023-02-01', NULL, NULL, NULL, NULL, 'jgonzales', '2023-0193', NULL, NULL, 1, 500, NULL, NULL, 'Revamp UI/UX and Process of SALMON app', NULL),
(10266, 'BLD - PRJ - Sales Monitoring Revamp', NULL, 27, '2023-02-01', NULL, NULL, NULL, NULL, 'jgonzales', '2023-0194', NULL, NULL, 1, 500, NULL, NULL, 'Revamp UI/UX and Process of SALMON app', NULL),
(10267, 'BLD - PRJ - Sales Monitoring Revamp', NULL, 27, '2023-02-01', NULL, NULL, '4', 1, 'jgonzales', '2023-0195', NULL, NULL, 1, 500, NULL, NULL, NULL, NULL),
(10268, 'BLD-PRJ-IT Comestri POSDELTA 2023', NULL, 27, '2023-02-01', NULL, NULL, '4.5', 1, 'jgonzales', '2023-0196', NULL, NULL, 2, 50, NULL, NULL, NULL, NULL),
(10269, 'SSI-SYSOPS-APE 2023', NULL, 79, '2023-01-01', '2023-02-28', NULL, '32.5', 1, 'ahortega', '2023-0197', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10270, 'ITD-SLCI-EBG-ON My Account Page Update', NULL, 71, '2023-01-27', '2023-03-31', NULL, NULL, 1, 'casenci', '2023-0198', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10271, 'DATA-SPT-Drunk Elephant Item Creation', NULL, 35, '2023-02-01', '2023-02-07', '2023-02-07', '2', 3, 'malejandro', '2023-0199', NULL, NULL, 2, 5, NULL, NULL, NULL, NULL),
(10272, 'DATA-SPT-IS Group Store Return Item Report', NULL, 35, '2023-02-01', NULL, NULL, '44.5', 1, 'malejandro', '2023-0200', NULL, NULL, 2, 50, NULL, NULL, NULL, NULL),
(10273, 'DATA-SPT-WSI-SSI Integration Support', NULL, 35, '2023-02-01', NULL, NULL, '6.75', 1, 'jlacaba', '2023-0201', NULL, NULL, 2, 300, NULL, NULL, NULL, NULL),
(10274, 'ITD-SSI-SYSDEV-SSI WSI Product Data Feed', NULL, 140, '2023-01-30', '2023-02-28', NULL, '26', 1, 'jssegun', '2023-0202', NULL, NULL, 1, 1, NULL, NULL, 'Product Data Feed is the inbound transfer of Data from WSI to SSI.', NULL),
(10275, 'DATA-SPT- Kate Spade QS Report Concern', NULL, 35, '2023-02-01', '2023-02-07', '2023-02-07', '3.5', 3, 'jlacaba', '2023-0203', NULL, NULL, 2, 20, NULL, NULL, NULL, NULL),
(10276, 'DATA-SPT-Lexer Concerns 2023', NULL, 35, '2023-02-01', NULL, NULL, '3', 1, 'jlacaba', '2023-0204', NULL, NULL, 2, 500, NULL, NULL, NULL, NULL),
(10277, 'BLD - SPT- GCP E-Payslip(2023)', NULL, 27, '2023-02-01', NULL, NULL, '5', 1, 'jgonzales', '2023-0205', NULL, NULL, 2, 50, NULL, NULL, 'Provide assessment for additional feature to download employee records in maintenanthe ce module', NULL),
(10278, 'DATA - SPT- FSRI Workforward Issue', NULL, 35, '2023-02-02', '2023-02-14', '2023-02-14', '6.5', 3, 'jlacaba', '2023-0206', NULL, NULL, 2, 80, NULL, NULL, NULL, NULL),
(10279, 'DATA-SPT-MPC Item Price Upate Concern', NULL, 35, '2023-02-02', '2023-02-07', '2023-02-07', '2', 3, 'jlacaba', '2023-0207', NULL, NULL, 2, 10, NULL, NULL, NULL, NULL),
(10280, 'DATA-SPT WSI Brands Workforward concern', NULL, 35, '2023-02-02', '2023-02-14', '2023-02-14', '20.25', 3, 'jlacaba', '2023-0208', NULL, NULL, 2, 80, NULL, NULL, NULL, NULL),
(10282, 'DATA-SPT-Nars Duplicate UPC Concern', NULL, 35, '2023-02-03', '2023-02-07', '2023-02-07', '2', 3, 'jlacaba', '2023-0210', NULL, NULL, 2, 30, NULL, NULL, NULL, NULL),
(10283, 'APPSPT-SPT- Pentaho SOB Validation 2023', NULL, 8, '2023-01-01', '2023-12-31', NULL, '8', 1, 'yemagnaye', '2023-0211', NULL, NULL, 2, 50, NULL, NULL, NULL, NULL),
(10284, 'ERP - PRJ - Print and Reset Menu Log File Enhancement', NULL, 26, '2023-02-06', NULL, NULL, '22.75', 1, 'jsfrance', '2023-0212', NULL, NULL, 1, 40, NULL, NULL, NULL, NULL),
(10285, 'ERP - SPT - MUJI Coffee BOM Setup', NULL, 11, '2023-02-06', NULL, NULL, '25', 1, 'rgomez', '2023-0213', NULL, NULL, 2, 40, NULL, NULL, NULL, NULL),
(10286, 'BLD - SPT - RMSI JDAX', NULL, 27, '2023-02-06', '2023-02-10', '2023-02-06', '3.75', 1, 'jgonzales', '2023-0214', NULL, NULL, 2, 100, NULL, NULL, NULL, NULL),
(10287, 'DATA-SPT-R&D on Talend Data Integration Tool', NULL, 35, '2023-02-07', NULL, NULL, '3', 1, 'jlacaba', '2023-0215', NULL, NULL, 2, 50, NULL, NULL, NULL, NULL),
(10288, 'DATA-SPT-SLCI Support for EDI Outbound', NULL, 35, '2023-02-07', NULL, NULL, '1.25', 1, 'jlacaba', '2023-0216', NULL, NULL, 2, 300, NULL, NULL, NULL, NULL),
(10289, 'BLD - PRJ - Google Application Script', NULL, 13, '2023-02-08', NULL, NULL, '26.75', 1, 'jgonzales', '2023-0217', NULL, NULL, 1, 50, NULL, NULL, NULL, NULL),
(10290, 'ITSysOps - ISCI - 2023 Zara Soft Tag Implementation', NULL, 81, '2023-02-06', '2023-12-31', NULL, '2', 1, 'cccalma', '2023-0218', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10291, 'DATA-SPT-Kate Spade Principal Report Sales Checking', NULL, 35, '2023-02-08', NULL, NULL, '3.75', 1, 'jlacaba', '2023-0219', NULL, NULL, 2, 5, NULL, NULL, NULL, NULL),
(10292, 'DATA-SPT-Cartier Count Concern', NULL, 35, '2023-02-08', '2023-02-14', '2023-02-14', '1.5', 3, 'jlacaba', '2023-0220', NULL, NULL, 2, 50, NULL, NULL, NULL, NULL),
(10293, 'DATA-SPT-WSI Brands Cost of Sales Report', NULL, 35, '2023-02-09', NULL, NULL, '1.5', 1, 'jlacaba', '2023-0221', NULL, NULL, 2, 5, NULL, NULL, NULL, NULL),
(10294, 'ITSysOps - ISCI - 2023 Store Mode payment thru Zara App', NULL, 81, '2023-02-06', '2023-04-30', NULL, '1.5', 1, 'cccalma', '2023-0222', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(10295, 'ERP - PRJ - RMSI Transfer Receiving Control', NULL, 11, '2023-02-09', NULL, NULL, '2', 1, 'rgomez', '2023-0223', NULL, NULL, 1, 40, NULL, NULL, NULL, NULL),
(10296, 'DATA-SPT-TOD\'s Sales Concern', NULL, 35, '2023-02-09', '2023-02-14', '2023-02-14', '1.25', 3, 'jlacaba', '2023-0224', NULL, NULL, 2, 30, NULL, NULL, NULL, NULL),
(10297, 'DATA-SPT-ICG Support 2023', NULL, 35, '2023-02-09', NULL, NULL, '12', 1, 'jlacaba', '2023-0225', NULL, NULL, 2, 600, NULL, NULL, NULL, NULL),
(10298, 'BLD - SPT - Trucn Orderhive Data Delivery - Brand Delta Migration', NULL, 13, '2023-02-09', '2023-02-17', '2023-02-17', '1', 3, 'jquijano', '2023-0226', NULL, NULL, 2, 1, NULL, NULL, NULL, NULL),
(10299, 'BLD - SPT - Barcode - Price Event Printing', NULL, 13, '2023-02-09', NULL, NULL, '2', 1, 'jquijano', '2023-0227', NULL, NULL, 2, 3, NULL, NULL, 'There is a price event tomorrow (Feb 10, 2023), but they want to print the barcode prior to the event, but the price is not reflecting.', NULL),
(10300, 'APPSPT-SPT-INSYS SUPPORT - February 2023', NULL, 8, '2023-02-01', '2023-02-28', NULL, '1', 1, 'yemagnaye', '2023-0228', NULL, NULL, 2, 5, NULL, NULL, NULL, NULL),
(10301, 'BLD-IT-SPT- SSI DTR System', NULL, 27, '2023-02-09', NULL, NULL, '4.5', 1, 'jgonzales', '2023-0229', NULL, NULL, 2, 20, NULL, NULL, NULL, NULL),
(10302, 'ERP - PRJ - Open Event Cost Inquiry Enhancement for RMS', NULL, 26, '2023-02-13', NULL, NULL, '22.5', 1, 'jsfrance', '2023-0230', NULL, NULL, 1, 40, NULL, NULL, NULL, NULL),
(10303, 'FTC Activity', NULL, 118, '2023-02-13', NULL, NULL, '5', 1, 'dmvillanueva', '2023-0231', NULL, NULL, 2, 100, NULL, NULL, 'FTC Activty', NULL),
(10304, 'DATA-SPT-WSI Brands Inventory Cost Concern', NULL, 35, '2023-02-13', NULL, NULL, '18.75', 1, 'jlacaba', '2023-0232', NULL, NULL, 2, 50, NULL, NULL, NULL, NULL),
(10305, 'APPSPT-SPT- Parked Issues', NULL, NULL, '2023-01-01', '2023-12-31', NULL, NULL, 6, 'aibias', '2023-0233', NULL, NULL, 2, NULL, NULL, 'Items that were put on hold', NULL, NULL),
(10306, 'APPSPT-SPT-Parked Issues', NULL, 8, '2023-02-01', '2023-12-31', NULL, NULL, 6, 'aibias', '2023-0234', NULL, NULL, 2, 1, NULL, 'Items that were put on hold', NULL, NULL),
(10307, 'BLD - SPT - Barcode - Price Event Printing Connected to JDA', NULL, 13, '2023-02-13', NULL, NULL, NULL, 1, 'jquijano', '2023-0235', NULL, NULL, 2, 10, NULL, NULL, NULL, NULL),
(10308, 'ERP - SPT - Nars Item Creation program Revision', NULL, 11, '2023-02-14', NULL, NULL, '2.5', 1, 'rgomez', '2023-0236', NULL, NULL, 2, 10, NULL, NULL, NULL, NULL),
(10309, 'ITSysOps - ISCI - 2023 e-Commerce Router Replacement', NULL, 81, '2023-02-13', '2023-05-31', NULL, '1.5', 1, 'cccalma', '2023-0237', NULL, NULL, 1, NULL, NULL, NULL, 'Replacement of Meraki MX68 to MX85', NULL),
(10310, 'DATA-SPT-IS Group Cost of Sale Per UPC Issue', NULL, 35, '2023-02-15', NULL, NULL, '21', 1, 'malejandro', '2023-0238', NULL, NULL, 2, 20, NULL, NULL, NULL, NULL),
(10311, 'DATA-SPT-SSI ICG Workback and Workforward Concern', NULL, 35, '2023-02-15', NULL, NULL, '7.75', 1, 'malejandro', '2023-0239', NULL, NULL, 2, 20, NULL, NULL, NULL, NULL),
(10312, 'ERP - SPT - LM Item Creation program Revision', NULL, 11, '2023-02-15', NULL, NULL, '2.75', 1, 'rgomez', '2023-0240', NULL, NULL, 2, 10, NULL, NULL, NULL, NULL),
(10313, 'ERP - ADM - Administrative Task 2023', NULL, 11, '2023-01-01', NULL, NULL, '4', 1, 'rgomez', '2023-0241', NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10314, 'BLD - PRJ - Batch PO Create - There is No PO Created for Two Invoices', NULL, 13, '2023-02-17', NULL, NULL, '3.25', 1, 'jquijano', '2023-0242', NULL, NULL, 2, 1, NULL, NULL, NULL, NULL),
(10315, 'VL', NULL, 82, '2023-02-16', '2023-02-16', NULL, '8', 1, 'dmvillanueva', '2023-0243', NULL, NULL, 4, 8, NULL, NULL, 'Vacation Leave', NULL),
(10316, 'ERP - PRJ - Maint Inv Trans Codes / Prod Activity Enhancement', NULL, 26, '2023-02-20', NULL, NULL, '4', 1, 'jsfrance', '2023-0244', NULL, NULL, 1, 40, NULL, NULL, NULL, NULL),
(10317, 'DATA-SPT-Prada Add EANCODE to all reports', NULL, 35, '2023-02-20', NULL, NULL, '2', 1, 'malejandro', '2023-0245', NULL, NULL, 2, 20, NULL, NULL, NULL, NULL),
(10318, 'DATA-SPT-SLCI Support 2023', NULL, 35, '2023-02-20', NULL, NULL, '1.75', 1, 'jlacaba', '2023-0246', NULL, NULL, 2, 500, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `firstname` varchar(45) DEFAULT NULL,
  `lastname` varchar(45) DEFAULT NULL,
  `middlename` varchar(45) DEFAULT NULL,
  `enabled` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `is_internal` tinyint(4) DEFAULT 0,
  `business_unit_id` int(11) DEFAULT NULL,
  `manager_id` int(11) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `profile_picture` varchar(255) DEFAULT NULL,
  `is_admin` int(11) DEFAULT NULL,
  `added_by` varchar(50) DEFAULT NULL,
  `is_deleted` int(11) DEFAULT 0,
  `is_login` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `firstname`, `lastname`, `middlename`, `enabled`, `created_at`, `updated_at`, `start_date`, `end_date`, `email`, `is_internal`, `business_unit_id`, `manager_id`, `username`, `password`, `profile_picture`, `is_admin`, `added_by`, `is_deleted`, `is_login`) VALUES
(1, 'Frederick', 'Lopez', '', 0, NULL, NULL, NULL, NULL, 'fdlopez@rgoc.com.ph', 1, 2, NULL, 'flopez', '$2y$10$c1SkEz6vU9UDA5D8poXl/u49S0N.v1E122kKSs1qObrWsoq33aBdm', NULL, 0, 'cvisaya', 0, '0'),
(2, 'Ma. Rova', 'Francisco', '', 0, NULL, NULL, NULL, NULL, 'mrcfrancisco@rgoc.com.ph', 1, 2, NULL, 'rfrancisco', '$2y$10$.qP4SmmQq.dvYv57qxSjee2znWQmNHy4pd6bIyDYQbuRd3fpcmud.', NULL, 0, 'cvisaya', 0, '0'),
(3, 'Aila', 'Caparas', '', 0, NULL, NULL, NULL, NULL, 'aglamigo@rgoc.com.ph', 1, 1, NULL, 'acaparas', '$2y$10$gSvJx28rV1kpRsnQuaSdhe55FRvpskEbI91m6eySJS3gvAG3qirYi', NULL, 0, 'jong', 0, '0'),
(4, 'Anthony', 'Siao', '', 0, NULL, NULL, NULL, '2019-08-31', 'amsiao@rgoc.com.ph', 1, 1, NULL, 'asiao', '$2y$10$0rq6anMbRJ4g6SSSZHdC1.fy0FWV/tmq1AkZxa/QMTlWjem7JN5ye', NULL, 0, 'cvisaya', 0, '0'),
(5, 'Junelito', 'Salugsugan', '', 0, NULL, NULL, '2016-05-01', '2021-04-20', 'jasalugsugan@rgoc.com.ph', 1, 1, 0, 'jong', '$2y$10$ta4Ctlld3ZAmuSg4jbjF5uv0QlPL8.UqT7Tk/BInw8CF5csW43eqa', NULL, 1, NULL, 0, '0'),
(6, 'Clark', 'Baltazar', '', 0, NULL, NULL, NULL, NULL, '', 0, 1, NULL, 'cbaltazar', '$2y$10$uah4oOqMeaEUpog5u9FYVeMa1RcvPBsuzFp48/U8ITjXdRv/l5siq', NULL, 0, 'cvisaya', 0, '0'),
(7, 'Lucas', 'Orgesvik', '', 0, NULL, NULL, NULL, NULL, '', 0, 2, NULL, 'lorgesvik', '$2y$10$nv29hYZdLu2Bz0P.nP2hUOHO1yWBWN4YbdJKxn9PhSN6P7lAiDmzu', NULL, 0, 'cvisaya', 0, '0'),
(8, 'Arvin', 'Ibias', '', 1, NULL, NULL, NULL, NULL, 'afibias@rgoc.com.ph', 1, 1, 13, 'aibias', '$2y$10$eiIzpfOMk2OqZhDDQ7Ia7urxcCh/MQ77Q68yFubtLq5RvpgEy.aVi', NULL, 1, 'cvisaya', 0, '0'),
(9, 'Nelcy', 'Dela Cruz', '', 0, NULL, NULL, NULL, NULL, '', 1, 1, NULL, 'ndelacruz', '$2y$10$OUtKT6G66G9ItXHFLSOcW.wGnUnTRHQMDFv61elRJo1iZTyrPF2O6', NULL, 0, 'cvisaya', 0, '0'),
(10, 'Jovie', 'Quijano', '', 1, NULL, NULL, NULL, NULL, 'jovie.quijano.myclick@rgoc.com.ph', 0, 1, 27, 'jquijano', '$2y$10$lHnnLwCznvEZew0na6y3a.ZUT7gKVM1Lw1Dth0GJt/Pm8rWsG.TIG', NULL, 1, 'cvisaya', 0, '0'),
(11, 'Rey', 'Gomez', '', 1, NULL, NULL, NULL, NULL, 'rigomez@rgoc.com.ph', 1, 1, 13, 'rgomez', '$2y$10$u7wAkuSwOHElUjTO5bRsYOZyGxP1tGwr8jIDGkqlIRBBR87DHrTXy', NULL, 1, 'jong', 0, '0'),
(12, 'Angelo', 'Balicano', '', 0, NULL, NULL, NULL, NULL, '', 0, 1, NULL, 'abalicano', '$2y$10$0sbNOVxiJVC98QPniFKg9.xVpFliPZ5EpYog7RvwhcrrtE1lVgyHu', NULL, 0, 'cvisaya', 0, '0'),
(13, 'Chris', 'Visaya', '', 1, NULL, NULL, '2016-08-02', NULL, 'clvisaya@rgoc.com.ph', 1, 1, NULL, 'cvisaya', '$2y$10$P3rBKtMm53lN1bwYKWjyS.eTDF/YZJd1ibjMq8heOMrqRFqEnsm1O', NULL, 1, 'jong', 0, '0'),
(14, 'Mike', 'Solis', '', 0, NULL, NULL, NULL, NULL, 'mmsolis@rgoc.com.ph', 1, 2, NULL, 'msolis', '$2y$10$5a8IShxCYRScKswvpwtKve5Fg7QV1kNRXrisOFhQR60XNYQz.Oe/K', NULL, 1, 'cvisaya', 0, '0'),
(15, 'Lester', 'Domingo', '', 0, NULL, NULL, NULL, NULL, '', 0, 1, NULL, 'ldomingo', '$2y$10$L1RsTm..Kf6fxzvp4jqlfukjpU32scQ.4tHNWTaatPdDSFyd3xWjm', NULL, 0, 'cvisaya', 0, '0'),
(16, 'Mark', 'Alejandro', '', 1, NULL, NULL, NULL, NULL, 'msalejandro.itgroupinc@rgoc.com.ph', 0, 1, 35, 'malejandro', '$2y$10$GM5t3ZgAruM61Rr8DmF2XOCu7PHt6rURH8AJzMd1Ntpro34SLkqFq', NULL, 0, 'cvisaya', 0, '0'),
(19, 'Miguel', 'Cruz', '', 1, NULL, NULL, '2017-01-01', NULL, 'cruzmg@rgoc.com.ph', 1, 6, NULL, 'mcruz', '$2y$10$1uvBtLFyMTLcjnAE1H.5me.doVPi7lFWHjpA59FF93x78loWF1vkS', NULL, 1, 'cvisaya', 0, '0'),
(22, 'Mary Jane', 'Rodriguez', '', 0, NULL, NULL, '2014-01-01', '2021-01-24', 'mprodriguez@rgoc.com.ph', 1, 1, NULL, 'jrodriguez', '$2y$10$1KUoc/Onb/b20j75bfcKAeKs2Ih4QuvlJwFrv2bF9p1ZNb5VdZbza', NULL, 1, 'cvisaya', 0, '0'),
(23, 'Melody ', 'Catapia-Magboo', '', 1, NULL, NULL, NULL, NULL, 'mccatapia@rgoc.com.ph', 1, 2, NULL, 'mmagboo', '$2y$10$jPWl4MyE8mJqDEQjQ0THF.e8lvKeRogeHXtWtJUm0O8elsBUNo0ty', NULL, 0, 'cvisaya', 0, '0'),
(24, 'Jess', 'Antonio', '', 1, NULL, NULL, NULL, NULL, 'jgantonio@rgoc.com.ph', 1, 2, NULL, 'jantonio', '$2y$10$crOGDPN5vTTYguy1dSkgfujT3.EjayiCfMrPClZFoFTHtNv71LbZ.', NULL, 0, 'cvisaya', 0, '0'),
(25, 'Constancio', 'Tudio', '', 0, NULL, NULL, NULL, NULL, '', 0, 1, NULL, 'ctudio', '$2y$10$mcKGqnsBU1eHrxa.pJCIWebbbwtpS6rhSAWZwfcGl3w0GNQoyxhsu', NULL, 0, 'cvisaya', 0, '0'),
(26, 'Jeffrey', 'France', '', 1, NULL, NULL, NULL, NULL, 'jsfrance@rgoc.com.ph', 1, 1, 11, 'apsantos', '$2y$10$ifVlY8E5/4ZwH6bd8Eh8BOH9pF/5jekosbT2xae0kmLxwl2VJ/LfC', NULL, 0, 'msolis', 0, '0'),
(27, 'Jonathan', 'Gonzales', '', 1, NULL, NULL, '2021-12-06', NULL, 'jgonzales.clicktek@rgoc.com.ph', 0, 1, 13, 'jgonzales', '$2y$10$..egEA1Rd8w5dVbKnDx4Q.pya0t3AQj1WD7BzXwq5Kb/N02SYfJK.', NULL, 1, 'cvisaya', 0, '0'),
(28, 'Nolan', 'Dornila', '', 0, NULL, NULL, NULL, NULL, '', 0, 0, NULL, 'ndornilla', '$2y$10$IjjPTQ1Mafs.ECiG5ASZhOlV6NngxSpMKfyUaGqLB2BYHrmSVJ1Ga', NULL, 0, 'jong', 0, '0'),
(29, 'Renz', 'Belardo', '', 0, NULL, NULL, NULL, NULL, 'rabelardo@rgoc.com.ph', 1, 2, NULL, 'rbelardo', '$2y$10$Y.KY0YrpeZ2B/jBUpOG7gOnXWUwpKMdEDII..0Am9Z.z4zgLvtJx6', NULL, 0, 'cvisaya', 0, '0'),
(30, 'Lito', 'Toledo', '', 1, NULL, NULL, NULL, NULL, 'ttoledo@rgoc.com.ph', 1, 3, NULL, 'jtoledo', '$2y$10$bK2nHtxeOPiqAIE0O6f/Xul2aTD5M51wN0cyL3Ctl3iZxMuJNBaCe', NULL, 0, 'cvisaya', 0, '0'),
(31, 'Ariel', 'Umayam', '', 1, NULL, NULL, NULL, NULL, 'ABUmayam@rgoc.com.ph', 1, 3, NULL, 'aumayam', '$2y$10$tFTGdvxztr8YSU5Yx39Ev.QloqSNOUkzH6N3alwHn1kDMR.M.tSMa', NULL, 0, 'cvisaya', 0, '0'),
(32, 'Arnold', 'Manalili', '', 0, NULL, NULL, NULL, NULL, '', 0, 3, NULL, 'amanalili', '$2y$10$DXtttVpXz.RYpYAZre7O5.acTqMhMB.Zv.6.2w0dEsQiCZikdNi/W', NULL, 0, 'cvisaya', 0, '0'),
(33, 'Franklin', 'Dondoyano', '', 0, NULL, NULL, NULL, NULL, '', 0, 0, NULL, 'fdondoyano', '$2y$10$0v.wp5YydAPo9IH8onm0QuyydEbTgXpsugdywVFItIJVHnuPOoh4y', NULL, 0, 'cvisaya', 0, '0'),
(34, 'Joshua', 'Brosas', '', 0, NULL, NULL, NULL, NULL, 'jbrosas.clicktek@rgoc.com.ph', 0, 1, NULL, 'jbrosas', '$2y$10$KvZvTVP7XZL19lXTnlG6n.ZTT8OoE35gShDYCuTx6FWInob6zs5zC', NULL, 0, 'cvisaya', 0, '0'),
(35, 'Jimmy', 'Lacaba', '', 1, NULL, NULL, '2018-05-01', NULL, 'jnlacaba@rgoc.com.ph', 1, 1, 13, 'jlacaba', '$2y$10$DJSv0GVQqLpm3VYK4l4y4eK1UoGAES1QJEEG2cstS4wHepx0/b.nC', NULL, 1, 'cvisaya', 0, '0'),
(36, 'John Lennart', 'Timbal', '', 1, NULL, NULL, NULL, NULL, 'jbtimbal.clicktek@rgoc.com.ph', 0, 3, NULL, 'jtimbal', '$2y$10$ME/spCBh/Eaoix3gyp8uHOiXDisyHY7Y.W5cHcybmHUnAunFw8IKa', NULL, 0, 'cvisaya', 0, '0'),
(37, 'Marlon', 'Ellazar', '', 0, NULL, NULL, NULL, NULL, 'mnellazar@rgoc.com.ph', 1, 2, NULL, 'mellazar', '$2y$10$.0Kz37vowSrvT6zo.jrTCem9GCGpDiiAtpYSggK8XYOK4xq3fjnJC', NULL, 1, 'cvisaya', 0, '0'),
(38, 'Audre', 'Barellano', '', 0, NULL, NULL, '2018-09-03', NULL, 'audre.barellano@mtc.com.ph', 0, 1, 0, 'abarellano', '$2y$10$vjXRZ1Y5yH8tpBfiE3ipNutZrpS7m8vxM.JZL.lat9pS0xa5VlmGW', NULL, 0, 'cvisaya', 0, '0'),
(39, 'Nina Angelica', 'Ainza', '', 0, NULL, NULL, NULL, NULL, 'nvainza@rgoc.com.ph', 1, 1, 0, 'nainza', '$2y$10$g0Thvr4ORoAPfLXFZ8o8gecX0An83j1cMrYimOMviP4Os/06Z0iLK', NULL, 1, 'cvisaya', 0, '0'),
(46, 'Maribel', 'Sedilla', 'C', 0, NULL, NULL, '2019-01-14', NULL, 'mcsedilla.radix@rgoc.com.ph ', 0, 1, 0, 'msedilla', '$2y$10$3DnCMTVmsNO1ghYrVY7zH.HsAG0j9T6iLHeVyXbV20ULFQY4yWBvS', NULL, 0, 'jong', 0, '0'),
(50, 'Edgar Luis', 'Paje', 'G', 1, NULL, NULL, '2019-01-28', NULL, 'egpaje.radix@rgoc.com.ph', 0, 1, 11, 'egpaje', '$2y$10$.W/C76sFrlY/m85zFEJeeODoKVVyFmvFmjfO9/Rv86MLhY8kTdn8K', NULL, 0, 'jong', 0, '0'),
(51, 'Mark Kevin', 'Masaga', '', 1, NULL, NULL, NULL, NULL, 'mcmasaga@rgoc.com.ph', 0, 3, NULL, 'mmasaga', '$2y$10$9Ygu0YSHGfZie02pxiGZGewjxaXbf1i/kJO45MYxnLdanEiYPn/jO', NULL, 0, 'jong', 0, '0'),
(52, 'Christian Eli', 'De Guzman', 'D', 0, NULL, NULL, '2019-04-25', NULL, 'CDDeGuzman.clicktek@rgoc.com.ph', 0, 1, 35, 'cdeguzman', '$2y$10$K4yE2N/TpZdjyR0TEhvfHurU9GTKfSCiFCSrXvxswF4L0J6SlSeAC', NULL, 0, 'cvisaya', 0, '0'),
(53, 'Nino', 'Bretana', '', 0, NULL, NULL, '2019-01-01', '2021-04-30', 'ntbretana@rgoc.com.ph', 1, 6, NULL, NULL, NULL, NULL, NULL, NULL, 0, '0'),
(54, 'Adran', 'Martin', '', 0, NULL, NULL, '2019-01-01', '2020-04-30', 'ASMartin@rgoc.com.ph', 1, 3, NULL, 'asmartin', '$2y$10$xT2vRGqbURzynCQ56VDbfO.j7XTKPqMBGIklJkrCuV.7nGjCoU.Rq', NULL, 0, 'mcruz', 0, '0'),
(55, 'Jomar', 'Ebonite', '', 1, NULL, NULL, NULL, NULL, '	jomar.ebonite@mtc.com.ph', 0, 1, NULL, 'jebonite', '$2y$10$4WmQ8UmxYN44RuZ4mvmSXu2jWEBi2Q6GPuIaJJ11DPjN/Lz97RUsS', NULL, 0, 'cvisaya', 0, '0'),
(56, 'Arnel', 'Alarcio', 'Trinidad', 1, NULL, NULL, '2019-09-26', NULL, 'atalarcio@rgoc.com.ph', 1, 3, NULL, 'atalarcio', '$2y$10$FD36E/bbFHKFmETRSici.efKvrCfPJvpZ76iQHh//XOMw.IS6oA5a', NULL, 0, 'mcruz', 0, '0'),
(57, 'Patrick', 'Rivera', 'D', 0, NULL, NULL, '2020-03-02', NULL, 'pdrivera.clicktek@rgoc.com.ph', 0, 1, 0, 'privera', '$2y$10$gT4WEVqHbVSQnh6wXur0SOLBMou3tIaB0BaZDrl6N2BxlBbajGETa', NULL, 0, 'cvisaya', 0, '0'),
(58, 'Cesar', 'Catalan', '', 0, NULL, NULL, NULL, NULL, 'clcatalan@rgoc.com.ph', 1, 6, NULL, NULL, NULL, NULL, NULL, NULL, 0, '0'),
(59, 'Tristan', 'De Jesus', '', 1, NULL, NULL, NULL, NULL, 'tmdejesus@rgoc.com.ph', 1, 6, NULL, 'tmdejesus', '$2y$10$DJTqxd.dZhh9irWyKDFrdeZp1ScRDtTOG5sBZJPjcEmYJPBYNJW8i', NULL, 1, 'clvisaya', 0, '0'),
(60, 'Fherleen ', 'Aragoncillo', 'Donato ', 1, NULL, NULL, '2021-04-22', NULL, 'fdaragoncillo.clicktek@rgoc.com.ph', 0, 5, NULL, 'fdarogoncillo', '$2y$10$McSZ2f6XnEU/JMa8XNU3fOP5lZQQq.pO1qpNe8TP54fZWDE9VqKFe', NULL, 0, 'clvisaya', 0, '0'),
(61, 'Swayze Jerome', 'Aguilar', 'L', 1, NULL, NULL, '2021-04-22', NULL, 'slaguilar.clicktek@rgoc.com.ph', 0, 5, NULL, 'slaguilar', '$2y$10$Hrx0eyQ4oCuN7cqyYZqCqOJ87A9CEy7QDLRRqxIpP4aaM1QA4js8.', NULL, 0, 'clvisaya', 0, '0'),
(62, 'Michael John', 'Mercado', 'M', 1, NULL, NULL, '2021-04-22', NULL, 'mmmercado.clicktek@rgoc.com.ph', 0, 5, NULL, 'mmmercado', '$2y$10$VAysX4Cwmr37JzHYq93W/uuUre14h9VJs0AZ0jvtFRreWzY0g7zj.', NULL, 0, 'clvisaya', 0, '0'),
(63, 'Jerwin ', 'Quinto', '', 1, NULL, NULL, '2021-05-03', NULL, 'jcquinto@rgoc.com.ph', 1, 5, NULL, 'jcquinto', '$2y$10$oxacHASW2NMWJKb9BFrEvO/2EVipF/BU5SrEYn9NhoTCga2q1GE9m', NULL, 0, 'clvisaya', 0, '0'),
(64, 'Hilbert ', 'Gutierrez', '', 1, NULL, NULL, '2021-05-03', NULL, 'hdgutierrez@rgoc.com.ph', 1, 5, NULL, 'hdgutierrez', '$2y$10$MIIqkv/Z/vsCtu2Z6S/hnu/VguQyOSAPuIOIFWFNLbaVDPDvAsI8W', NULL, 0, 'clvisaya', 0, '0'),
(65, 'Nelson ', 'Ferrer', '', 1, NULL, NULL, '2021-05-03', NULL, 'nsferrer@rgoc.com.ph', 1, 5, NULL, 'nsferrer', '$2y$10$xuEsyYuYVlnYNB93Lt3vIuGwHRt/90VdlyQ1.Dc.xb3hvxdNhRUaG', NULL, 0, 'clvisaya', 0, '0'),
(66, 'Steven ', 'Ly', '', 1, NULL, NULL, '2021-06-14', NULL, 'sbly@rgoc.com.ph', 1, 5, NULL, 'sbly', '$2y$10$sPtuY5X3DhJX0RTbhF79ku8tx88J.699ED1cfb7LQ06idFtwGlfC.', NULL, 1, 'clvisaya', 0, '0'),
(67, 'Ann Glen', 'Gregorio', '', 1, NULL, NULL, NULL, NULL, 'aggregorio@rgoc.com.ph', 1, 2, NULL, 'agregorio', '$2y$10$/NHmpn9EMKaIJox0fT5Bt.6jNpvioxiEBkA5OyFZ64hD7PsobIBDO', NULL, 0, 'privera', 0, '0'),
(68, 'Patrick Vincent', 'Padilla', '', 1, NULL, NULL, NULL, NULL, 'pppadilla@rgoc.com.ph', 1, 2, NULL, 'ppadilla', '$2y$10$wgJDtUgpJaEZp5Rqbi5jKOzY6P7uME4lQi6qvuavHjmVwe6T9QvHC', NULL, 0, 'privera', 0, '0'),
(69, 'Shirvan', 'Opina', '', 0, NULL, NULL, NULL, NULL, 'scopina@rgoc.com.ph', 1, 2, NULL, 'sopina', '$2y$10$ffMyC64Ku3TTgogrzMvLA.uw9AOGDn.HLn9qCoUcDda.ASmAYsyNO', NULL, 0, 'privera', 0, '0'),
(70, 'Jonelee', 'Tolentino', '', 1, NULL, NULL, NULL, NULL, 'jdtolentino@rgoc.com.ph', 1, 2, NULL, 'jtolentino', '$2y$10$YY3qK0Mwg8/rdA1IdhRJWefMDJPi44GMcaAjYSqFfjZopNi3Cx7Qm', NULL, 0, 'privera', 0, '0'),
(71, 'Claire', 'Asenci', '', 1, NULL, NULL, NULL, NULL, 'cmasenci@rgoc.com.ph', 1, 2, NULL, 'casenci', '$2y$10$cXOkbyYNBAvtywbq2DAI5.iTt6KtkV1cITpvm3l2BTf.3fBuLppoO', NULL, 0, 'privera', 0, '0'),
(72, 'Jason', 'Lozano', '', 1, NULL, NULL, '2021-09-13', NULL, 'jvlozano@rgoc.com.ph', 1, 2, NULL, 'jlozano', '$2y$10$DVjj8XGQjPxRw7mavGpZZO0w2TJwM30OLp9hOoB1iOHzQtI9oJ4Bm', NULL, 0, 'privera', 0, '0'),
(73, 'Igmedio', 'Atregenio', '', 1, NULL, NULL, '2021-10-11', NULL, 'idatregenio.clicktek@rgoc.com.ph', 0, 3, NULL, 'iatregenio', '$2y$10$ZdufQ.YkP2uixy66lgxYYuqHDeGCWDltei9WvVs1ilTTcNU3u/mSm', NULL, 0, 'privera', 0, '0'),
(74, 'Omar', 'Cerbito', '', 1, NULL, NULL, '2021-10-11', NULL, 'odcebrito.clicktek@rgoc.com.ph', 0, 3, NULL, 'ocerbito', '$2y$10$2nnWHpxC38o3coK8l4a9JO1o5z5J43n3VB04.8AhpXw8cS/ZnVBxe', NULL, 0, 'privera', 0, '0'),
(75, 'Elbert John', 'Laceda', '', 1, NULL, NULL, '2017-06-17', NULL, 'emlaceda@rgoc.com.ph', 1, 3, NULL, 'elaceda', '$2y$10$eTeEGSIocVNepB9Yiqs.NODBkdisB4KBVexhB4u1Xvd1DEZJoBmfq', NULL, 0, 'privera', 0, '0'),
(76, 'Raynel', 'Navarro', '', 1, NULL, NULL, '2021-10-11', NULL, 'rmnavarro.clicktek@rgoc.com.ph', 0, 5, NULL, 'rmnavarro', '$2y$10$hwSVt2pgIiN.Jf/rU/w5iODSXiOLobY5PJ5ali.qSPu1RR1FzCKcm', NULL, 0, 'sbly', 0, '0'),
(77, 'Jarom', 'Apor', '', 1, NULL, NULL, '2021-10-11', NULL, 'jrapor.clicktek@rgoc.com.ph', 0, 5, NULL, 'jrapor1', '$2y$10$KIDzKIrx0S2hqRkx3JEFpeWMwc.sNpf1vOr/ToClidqVXAhnlFS6a', NULL, 0, 'sbly', 0, '0'),
(78, 'Danielle', 'Posadas', '', 1, NULL, NULL, '2021-10-25', NULL, 'drposadas.clicktek@rgoc.com.ph', 0, 5, NULL, 'drposadas', '$2y$10$AP57VMx9kQVRy9uKS0FoUO91Z5loF6AEDJFjbBP3PxE960/XlNyn.', NULL, 0, 'sbly', 0, '0'),
(79, 'Arlene', 'Deguzman', 'Ortega', 1, NULL, NULL, NULL, NULL, 'ahortega@rgoc.com.ph', 1, 4, NULL, 'ahortega', '$2y$10$j73gR2HM7j5sMJt68sFNk.il90FbReQxiwoZAhmxaUd1RPLnP.fxC', NULL, 0, 'clvisaya', 0, '0'),
(80, 'Christian', 'Alvarez', '', 1, NULL, NULL, NULL, NULL, 'cbalvarez@rgoc.com.ph', 1, 4, NULL, 'cbalvarez', '$2y$10$B5nf4JUws2uade7FHADh9OZJStQu.oZI8q7jDbwQ4S.jRBwOp6Lwm', NULL, 0, 'clvisaya', 0, '0'),
(81, 'Boyet', 'Calma', '', 1, NULL, NULL, NULL, NULL, 'cccalma@rgoc.com.ph', 1, 4, NULL, 'cccalma', '$2y$10$TwkdfVOqLpzCM2BZoq9Sy..wVZ0peqYw91DDJNT/igFddzlmm/fKa', NULL, 0, 'clvisaya', 0, '0'),
(82, 'Dennis', 'Villanueva', '', 1, NULL, NULL, NULL, NULL, 'dmvillanueva@rgoc.com.ph', 1, 4, NULL, 'dmvillanueva', '$2y$10$v/VTKiSodGmQV25QC2gkleG20G5B3suvzWMTPUU5pgAQkw3sqyR1m', NULL, 0, 'clvisaya', 0, '0'),
(83, 'Enrico', 'Santiago', '', 1, NULL, NULL, NULL, NULL, 'emsantiago@rgoc.com.ph', 1, 4, NULL, 'emsantiago', '$2y$10$luxIQcIYhF4T/Hsb4G27SuyD8RijCdEr0lrhLEMhJHbKI8zQr6Zym', NULL, 0, 'clvisaya', 0, '0'),
(84, 'Michael Allan', 'De Villa', '', 1, NULL, NULL, NULL, NULL, 'mgdevilla@rgoc.com.ph', 1, 4, NULL, 'mgdevilla', '$2y$10$cGAOrL2b1N5y06t9KeQ/xOO1CGNdirgOorxYnBA.gOz1gqKtNpStS', NULL, 0, 'clvisaya', 0, '0'),
(86, 'Roland', 'Isla', '', 1, NULL, NULL, NULL, NULL, 'raisla@rgoc.com.ph', 1, 4, NULL, 'raisla', '$2y$10$x/TXbGex4hzrrng5ukKrxOAtaLPjGJ6yIpvv1.yW1rQxIq9dEA9Wy', NULL, 0, 'clvisaya', 0, '0'),
(87, 'Raymond', 'Ronquillo', '', 1, NULL, NULL, NULL, NULL, 'rsronquillo@rgoc.com.ph', 1, 4, NULL, 'rsronquillo', '$2y$10$xb4hVTd9.m.d300uIFw/1u6uOBzV/f6ModecvCqjgSRxaTgrsYRMO', NULL, 0, 'clvisaya', 0, '0'),
(88, 'Gabriel', 'Bustamante', '', 1, NULL, NULL, NULL, NULL, 'gmbustamante@rgoc.com.ph', 1, 4, NULL, 'gmbustamante', '$2y$10$gLwJNwcB8xYEtvlhBaFi/OaQY1Fx/qMXny2u5JR8BLPiFRLK5GvbW', NULL, 1, 'clvisaya', 0, '0'),
(89, 'Nikki', 'Descalzo', '', 1, NULL, NULL, NULL, NULL, 'nvdescalzo@rgoc.com.ph', 1, 10, NULL, 'nvdescalzo', '$2y$10$vZ2gbACYbKUx4bGW21lA3uamGgS2kKFcW4G71qalSwRBlJjQ2a7v6', NULL, 0, 'clvisaya', 0, '0'),
(90, 'Christian John', 'Poseo', '', 1, NULL, NULL, NULL, NULL, 'cdposeo@rgoc.com.ph', 1, 10, NULL, 'cdposeo', '$2y$10$M/TEaDiJcOm.muleATpIBO1tyBc8BreR2VtfV4/vRqu54e4a1HhmK', NULL, 0, 'clvisaya', 0, '0'),
(91, 'Ian', 'Latube', '', 1, NULL, NULL, NULL, NULL, 'irlatube@rgoc.com.ph', 1, 11, NULL, 'irlatube', '$2y$10$ZVGx9RS2kCDAa51Q4cpzn.11fkLDPRjeSp88onWDkhOm9dEBYkSMW', NULL, 0, 'clvisaya', 0, '0'),
(92, 'Jaypee', 'Montalbo', '', 1, NULL, NULL, NULL, NULL, 'jpmontalbo@rgoc.com.ph', 0, 11, NULL, 'jpmontalbo', '$2y$10$OP5GsjeazMoNeB9SfYn9yOzDtg7.bNz8nmdo1VLOpqk/BkeKh/BZ.', NULL, 0, 'clvisaya', 0, '0'),
(93, 'Lawrence', 'Deogracias', '', 1, NULL, NULL, NULL, NULL, 'lcdeogracias@rgoc.com.ph', 1, 11, NULL, 'lcdeogracias', '$2y$10$8yxAv8j6Yi7IGvUUeTB6MOLQX4XC4H91LZbWh9P0dqmNNvBuEjWFa', NULL, 0, 'clvisaya', 0, '0'),
(94, 'Jessie', 'Guangco', '', 1, NULL, NULL, NULL, NULL, 'jbguangco@rgoc.com.ph', 1, 13, NULL, 'jbguangco', '$2y$10$3bUaGSRjyAFeF0246T9R5OUd4rjctpigxPRIzXMB8HSnbdN97e/0C', NULL, 0, 'clvisaya', 0, '0'),
(95, 'Liby', 'Sacdalan', '', 1, NULL, NULL, NULL, NULL, 'lgsacdalan@rgoc.com.ph', 1, 13, NULL, 'lgsacdalan', '$2y$10$0qJAnWLdv72kgBcIUtSpSOFGp0QNA2iZdmiufGCwhESAyNAqEQdma', NULL, 0, 'clvisaya', 0, '0'),
(96, 'Kristine', 'Costelo', '', 1, NULL, NULL, NULL, NULL, 'kpcostelo@rgoc.com.ph', 1, 13, NULL, 'kpcostelo', '$2y$10$1aq3kJedOP9VpKD7EovQTOYX1/kBrCi52CYGs45XA9ZY3G5Xy73fi', NULL, 0, 'clvisaya', 0, '0'),
(97, 'Johne', 'Bernardo', '', 1, NULL, NULL, NULL, NULL, 'jfbernardo@rgoc.com.ph', 1, 13, NULL, 'jfbernardo', '$2y$10$EDZUOxxdHCEkjNmc1wkDWOUKk7/zTX55BEUWJDXH7YSUT01IGi2ya', NULL, 0, 'clvisaya', 0, '0'),
(98, 'Renz Marvin', 'Velarde', '', 1, NULL, NULL, NULL, NULL, 'rdvelarde@rgoc.com.ph', 1, 15, NULL, 'rdvelarde', '$2y$10$9dH1H8z98mUgHmoHzH6SV.vlk41Bfa0TxgqLvHhgwVmWI2IlCeFUO', NULL, 0, 'clvisaya', 0, '0'),
(99, 'Paolo', 'Sierras', '', 1, NULL, NULL, NULL, NULL, 'prsierras@rgoc.com.ph', 1, 15, NULL, 'prsierras', '$2y$10$dhwh8cAOhlThfPQbxyALrOp7eg0iQj29C7fopknuwEn1sM7fY.kmq', NULL, 0, 'clvisaya', 0, '0'),
(100, 'Jeffrey', 'Eusebio', '', 1, NULL, NULL, NULL, NULL, 'jleusebio@rgoc.com.ph', 1, 8, NULL, 'jleusebio', '$2y$10$1sPE/8UoG.rn5s9JngQE2uoqmAKmmyNYoPk8Ad/eSXjn7P7PpaXAm', NULL, 0, 'clvisaya', 0, '0'),
(101, 'Rene Roy', 'Calaguin', '', 1, NULL, NULL, NULL, NULL, 'rbcalaguin@rgoc.com.ph', 1, 7, NULL, 'rbcalaguin', '$2y$10$N4NQHMBGmyBH7isE0yb2neR4ergjDPS/PVuimzox9YbyBwGBtu8kO', NULL, 0, 'clvisaya', 0, '0'),
(102, 'Luis', 'de Guzman', '', 1, NULL, NULL, NULL, NULL, 'ladeguzman@rgoc.com.ph', 1, 7, NULL, 'ladeguzman', '$2y$10$JCNgwZjPXYLnWVuFL8MPxOLRKr7c3wDavcWZeiLxeg7Q.4X4c5HFy', NULL, 0, 'clvisaya', 0, '0'),
(103, 'Joshua Janus', 'Brun', '', 1, NULL, NULL, NULL, NULL, 'jhbrun@rgoc.com.ph', 1, 7, NULL, 'jhbrun', '$2y$10$q4tlsq9ut0HhWq68MOdhPOyQbxPTwgn9zbqaQOlb1.T66FAFavfLm', NULL, 0, 'clvisaya', 0, '0'),
(104, 'Yvette Mabey Rick', 'Magnaye', '', 1, NULL, NULL, NULL, NULL, 'yemagnaye@rgoc.com.ph', 1, 1, 8, 'yemagnaye', '$2y$10$6O723jPID3HibcYlnxybf.NQIGUsmBju9iV7oggLw/NIBTi/Hld9m', NULL, 1, 'clvisaya', 0, '0'),
(105, 'Albert', 'de Leon', '', 1, NULL, NULL, NULL, NULL, 'awdeleon.avasia@rgoc.com.ph', 1, 7, NULL, 'awdeleon.avasia', '$2y$10$lcG9Vim7WFAIkCwE6CLa0OnF8SGwq6Zc87/7otDgvVHbHVICqSStO', NULL, 0, 'clvisaya', 0, '0'),
(106, 'Vevencio', 'Rodriguez', '', 1, NULL, NULL, NULL, NULL, 'vyrodriguez@rgoc.com.ph', 1, 7, 88, 'vyrodriguez.avasia', '$2y$10$qpHk2SH/aPfEAyU5oWkUEOKoErJFQ8mKiUcJGyTuUVW4zwpTBZux6', NULL, 0, 'clvisaya', 0, '0'),
(107, 'Avasia', 'Helpdesk', '', 1, NULL, NULL, NULL, NULL, 'tsg.avasia@rgoc.com.ph', 0, 7, NULL, 'tsg.avasia', '$2y$10$kDDwxZUxXfEyN7FaHAm65OaVNgc.cgqP8n76176mRl7U5H6bev6MG', NULL, 0, 'clvisaya', 0, '0'),
(108, 'Kana', 'Bobis', '', 1, NULL, NULL, NULL, NULL, 'kabobis@rgoc.com.ph', 1, 16, NULL, 'kabobis', '$2y$10$zx7APl7kEJfVkoM4FBzLiOD/0uLSHaj9P/akC672zJz7n4u/je/GW', NULL, 0, 'clvisaya', 0, '0'),
(109, 'Maribeth', 'Distrajo', '', 1, NULL, NULL, NULL, NULL, 'mcdistrajo@rgoc.com.ph', 1, 9, NULL, 'mcdistrajo', '$2y$10$//T9tZrxipBCF38Q4X08behezSPrbaLq8WnwGcr1BBJagxMRHgGYC', NULL, 0, 'clvisaya', 0, '0'),
(110, 'Rodelia', 'Conde', '', 1, NULL, NULL, NULL, NULL, 'rrconde@rgoc.com.ph', 1, 9, NULL, 'rrconde', '$2y$10$WpSOL35rp/lEyROFHemJ4u9cKfcmbI81KjSBMlezbaXiDSAP1HjGS', NULL, 0, 'clvisaya', 0, '0'),
(111, 'Mark', 'Monillas', '', 1, NULL, NULL, NULL, NULL, 'mgmonillas@rgoc.com.ph', 1, 9, NULL, 'mgmonillas', '$2y$10$KRYgv0PhrDUZ9LtGhkUDZeU9CSbiJnVypEuOLTBNsf1yA65hmJ4Cq', NULL, 0, 'clvisaya', 0, '0'),
(112, 'Roland', 'Austria', '', 1, NULL, NULL, NULL, NULL, 'rraustria@rgoc.com.ph', 1, 9, NULL, 'rraustria', '$2y$10$Ah/kA4ekTIKK.GL9xrzqwuB1TBXspzzmU1FEy0TBxMZCFSDNob6C2', NULL, 0, 'nainza', 0, '0'),
(113, 'Keithleen', 'Anapi', '', 1, NULL, NULL, NULL, NULL, 'kbanapi.avasia@rgoc.com.ph', 0, 9, NULL, 'kbanapi.avasia', '$2y$10$zc.1VzZI2hUUJYPR8K4euOP7yPf1EJoTjg0mqcivMacRo8/eHsP8q', NULL, 0, 'clvisaya', 0, '0'),
(114, 'Mary Claire', 'Carbonell', '', 1, NULL, NULL, NULL, NULL, 'mpcarbonell.avasia@rgoc.com.ph', 0, 9, NULL, 'mpcarbonell.avasia', '$2y$10$3K4EgU.m39V7zTb7Zb4Cbe7HgXA6eRG2BMmi31cpYfoiXGWjGyGIq', NULL, 0, 'clvisaya', 0, '0'),
(115, 'Jhecca Jane', 'Miciano', '', 1, NULL, NULL, NULL, NULL, 'jimiciano.avasia@rgoc.com.ph', 0, 9, NULL, 'jimiciano.avasia', '$2y$10$ZsReCCOJqTu5SBx.c1.05efFpiX1rXDI5DZTk1A7lo/YqLvSxSo2O', NULL, 0, 'clvisaya', 0, '0'),
(116, 'Noel', 'Dacumos', '', 1, NULL, NULL, NULL, NULL, 'nmdacumos@rgoccom.ph', 1, 12, 0, 'nmdacumos', '$2y$10$z6xrhIDwADv2z1mGaHdQU.ptJfGvZQ3Uu1uog3TFHFq6RkulafmVW', NULL, 0, 'clvisaya', 0, '0'),
(117, 'Mark Jireh', 'Gonzales', '', 1, NULL, NULL, NULL, NULL, 'mmgonzales@rgoc.com.ph', 1, 16, 0, 'mmgonzales', '$2y$10$SmGeqEzXjvCRcS4DoRc0UeJYE2xwir7m75GRgm59OuYrJVDjipKMW', NULL, 0, 'clvisaya', 0, '0'),
(118, 'Sally', 'Leria', '', 1, NULL, NULL, NULL, NULL, 'sbleria@rgoc.com.ph', 1, 14, NULL, 'sbleria', '$2y$10$jsCefuXP/3aT8AvmwrGRC.FB7Zvxxp08sVPUxF/0ytMIPnFDijXlu', NULL, 0, 'nainza', 0, '0'),
(119, 'Jayson', 'Lizardo	', '', 1, NULL, NULL, NULL, NULL, 'jdlizardo@rgoc.com.ph', 1, 12, NULL, 'jdlizardo', '$2y$10$QxoH9hdV7fffjOZxW36HeedxXPpsy3YRKKf2GXmEC3wWXQU4g9pju', NULL, 0, 'clvisaya', 0, '0'),
(120, 'Jeffrey', 'Santos', '', 1, NULL, NULL, NULL, NULL, 'jasantos@rgoc.com.ph', 1, 12, NULL, 'jasantos', '$2y$10$4oKG5YBWP50AbMnZpaOOi.K.aIILrT4M0xsx/ENcbXhOZrLKklI2u', NULL, 0, 'clvisaya', 0, '0'),
(121, 'Mike Angelo', 'Dumalanta', '', 1, NULL, NULL, NULL, NULL, 'madumalanta@rgoc.com.ph', 1, 14, NULL, 'madumalanta', '$2y$10$j04IEsCncgz9gJetHzjGpes0qm2QVcX0sYR/xbbdqLdY5m3ObFCAO', NULL, 0, 'nainza', 0, '0'),
(122, 'Belle', 'Salisi', '', 1, NULL, NULL, NULL, NULL, 'amsalisi@rgoc.com.ph', 1, 14, NULL, 'amsalisi', '$2y$10$YPm1q8QiTJQWvR4yvIkHlOmRQ6d/CKYR6fIyL.PAE9./S1Hgy6dzO', NULL, 0, 'nainza', 0, '0'),
(123, 'Reon', 'Mercado', '', 1, NULL, NULL, NULL, NULL, 'rfmercado@rgoc.com.ph', 1, 14, NULL, 'rfmercado', '$2y$10$Qjrvr9b/liX3SprbUUHkKujMc3rX.kBOAZ85.9sSeYSO/ybVHbJku', NULL, 0, 'nainza', 0, '0'),
(124, 'yNoel', 'yDacumos', '', 0, NULL, NULL, NULL, NULL, 'nmdacumos@rgoc.com.ph', 1, 12, 0, NULL, NULL, NULL, NULL, NULL, 0, '0'),
(129, 'Sarah', 'Precilla', 'A.', 1, NULL, NULL, '2021-05-03', NULL, 'saprecilla@rgoc.com.ph', 1, 16, 79, 'saprecilla', '$2y$10$obN7vmpJ4pSwckiddAPVyessn0p0PT5zTOsV1Doaum1nzwe7GAC4m', NULL, 0, 'clvisaya', 0, '0'),
(131, 'Mary Jane', 'Ang', '', 1, NULL, NULL, '2022-04-11', NULL, 'mtang@rgoc.com.ph', 1, 2, 0, 'mtang', '$2y$10$KslIoGg2sWMPvxJEqY.b1OozlOaD4OD1ODZ3yVHhsDB/ddEviLKsC', NULL, 0, 'aibias', 0, '0'),
(132, 'Lalaine', 'Dela Cruz', 'B', 1, NULL, NULL, '2022-04-22', NULL, '	lbdelacruz@rgoc.com.ph', 1, 9, 88, 'lbdelacruz', '$2y$10$yVU3nzr2qPbAIYskk9pwBO9cei505k4SyrghermnyHQxtW5l1Kz.q', NULL, 0, 'aibias', 0, '0'),
(133, 'Reinalyn Mara', 'Timbol', '', 1, NULL, NULL, '2022-05-04', NULL, 'rotimbol@rgoc.com.ph', 1, 9, 88, 'rotimbol', '$2y$10$3mIZY4/X6nAubQptxV72hOE.PHu7qakTGM3aqZDAnsV4QiYWPLzkq', NULL, 0, 'aibias', 0, '0'),
(134, 'Engelbert', 'Reyes', 'Edralin', 1, NULL, NULL, '2022-05-24', NULL, 'eereyes.clickteck@rgoc.com.ph', 0, 1, 35, 'ereyes', '$2y$10$iWZCT4ZQYUm/pEck2AvccuzGL5fFkOgx8ehGJVPsUJXoYPE2pIrcO', NULL, 0, 'jlacaba', 0, '0'),
(135, 'Jeffrey', 'Pagmanoja', '', 1, NULL, NULL, '2022-06-03', NULL, 'jepagmanoja@rgoc.com.ph', 0, 5, 66, 'jepagmanoja', '$2y$10$sfPWpC9lB3mSj9s3/YfQwuqn6MH1Ku1hRXJWOLtOCQvVDsLqU.912', NULL, 0, 'sbly', 0, '0'),
(136, 'Cheene', 'Buniel', 'O.', 1, NULL, NULL, '2022-06-10', NULL, 'cobuniel@rgoc.com.ph', 1, 9, 88, 'cbuniel', '$2y$10$9D368j4WgCRNOkpuaEZw4Oy1S6H3oFwtUeDaOXUkX.0uRMmusdau2', NULL, 0, 'yemagnaye', 0, '0'),
(137, 'Ronald', 'Abello', '', 1, NULL, NULL, '2022-10-24', NULL, 'rabello.clicktek@rgoc.com.ph', 0, 1, 27, 'rabello', '$2y$10$2BaPryniQE81G4kh0/rMXOlAOevuj4oKKgB6O3MGb9hViZWmKXjcu', NULL, 0, 'aibias', 0, '0'),
(138, 'Niel', 'Zoleta', 'M', 1, NULL, NULL, NULL, NULL, 'nmzoleta@rgoc.com.ph', 1, 11, 81, 'nmzoleta', '$2y$10$11GoxYfav2Ls8G.RcMVVVOpeeLI5449/TxyicwArP4IjAIvfGNCMO', NULL, 0, 'aibias', 0, '0'),
(139, 'Dexter', 'Quinagoran', '', 1, NULL, NULL, '2022-08-24', NULL, 'dpquinagoran.clicktek@rgoc.com.ph', 0, 2, 59, 'dpquinagoran', '$2y$10$7G7Zs/BftZGdA9PR8ajgtuPJsZvaQZ43pTAl.LlASHdQLwUwaA6ki', NULL, 0, 'yemagnaye', 0, '0'),
(140, 'Julius', 'Segun', '', 1, NULL, NULL, '2022-08-24', NULL, 'jssegun.clicktek@rgoc.com.ph', 0, 2, 59, 'jssegun', '$2y$10$9EsyFi6K3zUo8UmiKHney.BtbOMCR7Gaac2lgsZNElIiMU4Tp6YKy', NULL, 0, 'yemagnaye', 0, '0'),
(141, 'Danizon', 'Montallana', '', 1, NULL, NULL, NULL, NULL, 'dumontallana@rgoc.com.ph', 1, 13, 80, 'dumantallana', '$2y$10$d3uFxQKEbgB5wq.1ZR/zDOWbCw.SbeAM3xLvVHjPM.3Cnkr9AychW', NULL, 0, 'aibias', 0, '0'),
(142, 'Danielle Louise', 'Yap', '', 1, NULL, NULL, '2022-11-03', NULL, 'dcyap@rgoc.com.ph', 1, 18, NULL, 'dcyap', '$2y$10$AAWoLwOxIQOZp75FPKhyW..H1DztiJYK6viv4etfGDPpCy0z1R3Mq', NULL, 0, 'jgonzales', 0, '0'),
(144, 'Michelle Llynne', 'Reyes', '', 1, NULL, NULL, '2022-12-05', NULL, 'mmreyes.clicktek@rgoc.com.ph', 0, 2, 59, 'mmreyes', '$2y$10$Mk5.sdmj2W2/yizPMN/KB.l1q9b0nq8pMheAPRAjeWA0oLzMfaEt.', NULL, 0, 'aibias', 0, '0'),
(145, 'Macky', 'Arriba', '', 1, NULL, NULL, '2022-12-19', NULL, 'msarriba.clicktek@rgoc.com.ph', 0, 2, 59, 'msarriba', '$2y$10$l/WVOUUSTmI31ailo4on2O.THDAATLoUulT7zgDniLfEyGtD/1IIC', NULL, 0, 'yemagnaye', 0, '0'),
(146, 'Francis Adrian', 'Aguirre', '', 1, NULL, NULL, '2022-12-19', NULL, 'ftaguirre@rgoc.com.ph', 1, 2, 59, 'ftaguirre', '$2y$10$AksqArfi01WK194yy0SlEe5cKAyiMfRZyZc/uxM0a2t3xHz5qMg/e', NULL, 0, 'yemagnaye', 0, '0'),
(147, 'Alexander Neil', 'Jusa', '', 1, NULL, NULL, '2023-01-19', NULL, 'aljusa@rgoc.com.ph', 1, 3, NULL, 'aljusa', '$2y$10$wg7JAB0jIdsBs2Kuj2pHv.jR.1mwVwnJC5yO721aLzG7fem1UWeyO', NULL, 0, 'yemagnaye', 0, '0'),
(148, 'Ritzie Edson', 'Lamina', '', 1, NULL, NULL, '2023-02-02', NULL, 'rvlamina.clicktek@rgoc.com.p', 0, 2, 59, 'rvlamina', '$2y$10$eSpWeTmAphuIeGK.cpkVJ.4eQYLLETIsQ0UWhzCqHGqP13v.FLTHu', NULL, 0, 'yemagnaye', 0, '0');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `txn_activities`
--
ALTER TABLE `txn_activities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_activities_idx` (`ticket_id`),
  ADD KEY `activity_type_idx` (`type_id`),
  ADD KEY `activity_resource_idx` (`resource_id`),
  ADD KEY `activity_entity_idx` (`entity_id`);

--
-- Indexes for table `txn_tickets`
--
ALTER TABLE `txn_tickets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_entity_idx` (`entity_id`),
  ADD KEY `project_mngr_resource_idx` (`ticket_manager_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `mnt_business_units`
--
ALTER TABLE `mnt_business_units`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

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

--
-- AUTO_INCREMENT for table `mnt_statuses`
--
ALTER TABLE `mnt_statuses`
  MODIFY `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `mnt_ticket_references`
--
ALTER TABLE `mnt_ticket_references`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10300;

--
-- AUTO_INCREMENT for table `mnt_ticket_types`
--
ALTER TABLE `mnt_ticket_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `txn_activities`
--
ALTER TABLE `txn_activities`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=200009;

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=149;
COMMIT;

