-- Table structure for table `approval_thresholds`
--

CREATE TABLE `approval_thresholds` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(100) NOT NULL COMMENT 'e.g. Minor, Small, Medium, Major',
  `min_value` decimal(15,2) NOT NULL DEFAULT 0.00 COMMENT 'band lower bound, inclusive (JMD)',
  `max_value` decimal(15,2) DEFAULT NULL COMMENT 'band upper bound, inclusive; null = and above',
  `required_approvals` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'ordered role keys that must approve' CHECK (json_valid(`required_approvals`)),
  `notes` varchar(255) DEFAULT NULL,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `approval_thresholds_is_active_min_value_index` (`is_active`,`min_value`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `approval_thresholds`
--

INSERT INTO `approval_thresholds` VALUES (2,'Pal Approval Threshold',0.00,100000.00,'[\"pal\"]','Band set for approval at the PAL Offices',0,1,'2026-07-10 19:56:11','2026-07-10 19:56:11');

--
-- Table structure for table `areas`
--

CREATE TABLE `areas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pal_office_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(150) NOT NULL,
  `code` varchar(30) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `areas_code_unique` (`code`),
  KEY `areas_pal_office_id_foreign` (`pal_office_id`),
  CONSTRAINT `areas_pal_office_id_foreign` FOREIGN KEY (`pal_office_id`) REFERENCES `pal_offices` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `areas`
--

INSERT INTO `areas` VALUES (1,1,'Kingston Metropolitan','AREA-KMA',1,'2026-06-16 03:19:13','2026-06-16 05:09:33'),(2,2,'Western','AREA-WST',1,'2026-06-16 03:19:13','2026-06-16 05:09:33');

--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pal_office_id` bigint(20) unsigned NOT NULL,
  `item_id` bigint(20) unsigned DEFAULT NULL,
  `requisition_id` bigint(20) unsigned DEFAULT NULL,
  `uom_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(200) NOT NULL,
  `asset_tag` varchar(60) DEFAULT NULL COMMENT 'label/serial',
  `description` text DEFAULT NULL,
  `quantity` decimal(15,2) NOT NULL DEFAULT 1.00,
  `unit_value` decimal(15,2) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'in_stock' COMMENT 'in_stock|in_use|maintenance|retired',
  `acquired_at` date DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assets_item_id_foreign` (`item_id`),
  KEY `assets_requisition_id_foreign` (`requisition_id`),
  KEY `assets_uom_id_foreign` (`uom_id`),
  KEY `assets_pal_office_id_status_index` (`pal_office_id`,`status`),
  CONSTRAINT `assets_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assets_pal_office_id_foreign` FOREIGN KEY (`pal_office_id`) REFERENCES `pal_offices` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `assets_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`) ON DELETE SET NULL,
  CONSTRAINT `assets_uom_id_foreign` FOREIGN KEY (`uom_id`) REFERENCES `units_of_measure` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=602 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assets`
--

INSERT INTO `assets` VALUES (486,1,12,595,1,'Chairs - Office Standard',NULL,NULL,4.00,1750.00,'in_stock','2026-06-17',NULL,'2026-06-17 08:03:39','2026-06-17 08:03:39',NULL),(600,1,43,2363,1,'Table',NULL,NULL,5.00,35.71,'in_stock','2026-06-19',NULL,'2026-06-19 21:34:45','2026-06-19 21:34:45',NULL),(601,1,12,2363,1,'Chairs - Office Standard',NULL,NULL,1.00,71.43,'in_stock','2026-06-19',NULL,'2026-06-19 21:34:45','2026-06-19 21:34:45',NULL);

--
-- Table structure for table `attachments`
--

CREATE TABLE `attachments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `attachable_type` varchar(191) NOT NULL,
  `attachable_id` bigint(20) unsigned NOT NULL,
  `uploaded_by` bigint(20) unsigned DEFAULT NULL,
  `file_path` varchar(255) NOT NULL,
  `original_name` varchar(255) NOT NULL,
  `document_type` varchar(50) DEFAULT NULL COMMENT 'invoice|quote|po|grn|approval|other',
  `version_number` smallint(5) unsigned NOT NULL DEFAULT 1,
  `is_confidential` tinyint(1) NOT NULL DEFAULT 0,
  `access_level` varchar(30) DEFAULT NULL COMMENT 'all|pal|procurement|finance|restricted',
  `retention_period` varchar(40) DEFAULT NULL COMMENT 'e.g. 7 years',
  `mime_type` varchar(100) DEFAULT NULL,
  `size` int(10) unsigned DEFAULT NULL COMMENT 'bytes',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attachments_attachable_type_attachable_id_index` (`attachable_type`,`attachable_id`),
  KEY `attachments_uploaded_by_foreign` (`uploaded_by`),
  CONSTRAINT `attachments_uploaded_by_foreign` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attachments`
--


--
-- Table structure for table `budgets`
--

CREATE TABLE `budgets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cost_centre_id` bigint(20) unsigned NOT NULL,
  `fiscal_year` varchar(9) NOT NULL COMMENT 'e.g. 2026-2027 (GOJ Apr–Mar)',
  `allocation` decimal(15,2) NOT NULL DEFAULT 0.00,
  `committed` decimal(15,2) NOT NULL DEFAULT 0.00 COMMENT 'encumbered at PO issue',
  `spent` decimal(15,2) NOT NULL DEFAULT 0.00 COMMENT 'paid out',
  `notes` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `budgets_cost_centre_id_fiscal_year_unique` (`cost_centre_id`,`fiscal_year`),
  CONSTRAINT `budgets_cost_centre_id_foreign` FOREIGN KEY (`cost_centre_id`) REFERENCES `cost_centres` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `budgets`
--


--
-- Table structure for table `cost_centres`
--

CREATE TABLE `cost_centres` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(40) NOT NULL COMMENT 'budget/cost-centre code',
  `name` varchar(150) NOT NULL,
  `formation_id` bigint(20) unsigned DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cost_centres_code_unique` (`code`),
  KEY `cost_centres_formation_id_foreign` (`formation_id`),
  KEY `cost_centres_is_active_index` (`is_active`),
  CONSTRAINT `cost_centres_formation_id_foreign` FOREIGN KEY (`formation_id`) REFERENCES `formations` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cost_centres`
--

INSERT INTO `cost_centres` VALUES (4,'HQ-STORES','HEADQUATERS STORES',1250,NULL,1,'2026-07-10 19:59:23','2026-07-10 19:59:23'),(5,'TECH-BRANCH','TECHNOLOGY BRANCH',1268,NULL,1,'2026-07-10 20:00:12','2026-07-10 20:00:12'),(6,'PMMD','PROPERTY MANAGEMENT',1258,NULL,1,'2026-07-10 20:00:40','2026-07-10 20:00:40');

--
-- Table structure for table `delegations`
--

CREATE TABLE `delegations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `delegator_id` bigint(20) unsigned NOT NULL,
  `delegate_id` bigint(20) unsigned NOT NULL,
  `starts_on` date NOT NULL,
  `ends_on` date NOT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `delegations_delegator_id_foreign` (`delegator_id`),
  KEY `delegations_delegate_id_is_active_index` (`delegate_id`,`is_active`),
  KEY `delegations_starts_on_ends_on_index` (`starts_on`,`ends_on`),
  CONSTRAINT `delegations_delegate_id_foreign` FOREIGN KEY (`delegate_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `delegations_delegator_id_foreign` FOREIGN KEY (`delegator_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delegations`
--


--
-- Table structure for table `deliveries`
--

CREATE TABLE `deliveries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_number` varchar(40) NOT NULL COMMENT 'e.g. GRN-2026-00078',
  `purchase_order_id` bigint(20) unsigned NOT NULL,
  `requisition_id` bigint(20) unsigned NOT NULL,
  `supplier_id` bigint(20) unsigned NOT NULL,
  `delivered_at` datetime NOT NULL COMMENT 'step 13',
  `received_by` bigint(20) unsigned DEFAULT NULL,
  `inspection_status` varchar(15) NOT NULL DEFAULT 'pending' COMMENT 'pending|accepted|rejected|partial',
  `inspection_notes` text DEFAULT NULL,
  `confirmed_by` bigint(20) unsigned DEFAULT NULL,
  `confirmed_at` datetime DEFAULT NULL,
  `delivery_note_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `deliveries_delivery_number_unique` (`delivery_number`),
  KEY `deliveries_purchase_order_id_foreign` (`purchase_order_id`),
  KEY `deliveries_requisition_id_foreign` (`requisition_id`),
  KEY `deliveries_supplier_id_foreign` (`supplier_id`),
  KEY `deliveries_received_by_foreign` (`received_by`),
  KEY `deliveries_confirmed_by_foreign` (`confirmed_by`),
  KEY `deliveries_inspection_status_index` (`inspection_status`),
  CONSTRAINT `deliveries_confirmed_by_foreign` FOREIGN KEY (`confirmed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `deliveries_purchase_order_id_foreign` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_orders` (`id`),
  CONSTRAINT `deliveries_received_by_foreign` FOREIGN KEY (`received_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `deliveries_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`),
  CONSTRAINT `deliveries_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=877 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deliveries`
--

INSERT INTO `deliveries` VALUES (630,'GRN-2026-00002',829,595,8,'2026-06-17 02:35:00',4,'accepted',NULL,4,'2026-06-17 03:03:39',NULL,'2026-06-17 07:35:00','2026-06-17 08:03:39'),(876,'GRN-2026-00003',1172,2363,2,'2026-06-19 16:32:55',4,'accepted',NULL,4,'2026-06-19 16:34:45',NULL,'2026-06-19 21:32:55','2026-06-19 21:34:45');

--
-- Table structure for table `delivery_issues`
--

CREATE TABLE `delivery_issues` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_id` bigint(20) unsigned NOT NULL,
  `raised_by` bigint(20) unsigned NOT NULL,
  `issue_type` varchar(20) NOT NULL COMMENT 'damaged|short|wrong_item|quality|other',
  `description` text NOT NULL,
  `resolution` text DEFAULT NULL,
  `status` varchar(15) NOT NULL DEFAULT 'open' COMMENT 'open|resolving|resolved',
  `resolved_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `delivery_issues_delivery_id_foreign` (`delivery_id`),
  KEY `delivery_issues_raised_by_foreign` (`raised_by`),
  CONSTRAINT `delivery_issues_delivery_id_foreign` FOREIGN KEY (`delivery_id`) REFERENCES `deliveries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `delivery_issues_raised_by_foreign` FOREIGN KEY (`raised_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delivery_issues`
--


--
-- Table structure for table `delivery_items`
--

CREATE TABLE `delivery_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_id` bigint(20) unsigned NOT NULL,
  `purchase_order_item_id` bigint(20) unsigned NOT NULL,
  `quantity_delivered` decimal(15,2) NOT NULL,
  `quantity_accepted` decimal(15,2) NOT NULL DEFAULT 0.00,
  `quantity_rejected` decimal(15,2) NOT NULL DEFAULT 0.00,
  `condition_notes` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `delivery_items_delivery_id_foreign` (`delivery_id`),
  KEY `delivery_items_purchase_order_item_id_foreign` (`purchase_order_item_id`),
  CONSTRAINT `delivery_items_delivery_id_foreign` FOREIGN KEY (`delivery_id`) REFERENCES `deliveries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `delivery_items_purchase_order_item_id_foreign` FOREIGN KEY (`purchase_order_item_id`) REFERENCES `purchase_order_items` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=854 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delivery_items`
--

INSERT INTO `delivery_items` VALUES (630,630,829,4.00,4.00,0.00,NULL,'2026-06-17 07:35:00','2026-06-17 08:03:07'),(852,876,1172,5.00,5.00,0.00,NULL,'2026-06-19 21:32:55','2026-06-19 21:32:55'),(853,876,1173,1.00,1.00,0.00,NULL,'2026-06-19 21:32:55','2026-06-19 21:32:55');

--
-- Table structure for table `delivery_locations`
--

CREATE TABLE `delivery_locations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `code` varchar(30) DEFAULT NULL,
  `station_id` bigint(20) unsigned DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `parish` varchar(80) DEFAULT NULL,
  `contact_person` varchar(150) DEFAULT NULL,
  `contact_number` varchar(30) DEFAULT NULL,
  `instructions` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `delivery_locations_code_unique` (`code`),
  KEY `delivery_locations_station_id_foreign` (`station_id`),
  KEY `delivery_locations_is_active_index` (`is_active`),
  CONSTRAINT `delivery_locations_station_id_foreign` FOREIGN KEY (`station_id`) REFERENCES `stations` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delivery_locations`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `formations`
--

CREATE TABLE `formations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) unsigned DEFAULT NULL,
  `pal_office_id` bigint(20) unsigned DEFAULT NULL,
  `level` varchar(20) NOT NULL COMMENT 'portfolio|area|division|station',
  `name` varchar(150) NOT NULL,
  `code` varchar(40) DEFAULT NULL,
  `location` varchar(100) DEFAULT NULL COMMENT 'parish / zone, e.g. Kingston',
  `cost_centre` varchar(40) DEFAULT NULL,
  `officer_in_charge` varchar(150) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `formations_parent_id_foreign` (`parent_id`),
  KEY `formations_level_parent_id_index` (`level`,`parent_id`),
  KEY `formations_is_active_index` (`is_active`),
  KEY `formations_pal_office_id_foreign` (`pal_office_id`),
  CONSTRAINT `formations_pal_office_id_foreign` FOREIGN KEY (`pal_office_id`) REFERENCES `pal_offices` (`id`) ON DELETE SET NULL,
  CONSTRAINT `formations_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `formations` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=1641 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `formations`
--

INSERT INTO `formations` VALUES (302,NULL,NULL,'portfolio','Strategic Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:20','2026-07-10 01:01:20'),(303,302,NULL,'area','Strategic Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 18:01:25'),(304,303,NULL,'division','Strategic Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(305,304,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(306,305,NULL,'station','HEADQUARTERS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(307,306,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(308,302,NULL,'area','AREA 1',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(309,308,NULL,'division','HEADQUARTERS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(310,309,NULL,'zone','ST. JAMES',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(311,310,NULL,'station','HEADQUARTERS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(312,311,NULL,'unit','AIRU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(313,311,NULL,'unit','Crime Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(314,311,NULL,'unit','CSS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(315,311,NULL,'unit','Garage',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(316,311,NULL,'unit','General Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(317,311,NULL,'unit','Operational Team',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(318,311,NULL,'unit','PECC',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(319,311,NULL,'unit','St. James ZOSO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(320,311,NULL,'unit','Telecom',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(321,311,NULL,'unit','Training & Recruiting',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(322,308,NULL,'division','HANOVER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(323,322,NULL,'zone','HANOVER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(324,323,NULL,'station','GREEN ISLAND',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(325,324,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(326,323,NULL,'station','HOPEWELL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(327,326,NULL,'unit','CSS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(328,326,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(329,322,NULL,'zone','LUCEA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(330,329,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(331,330,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(332,330,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(333,330,NULL,'unit','Detention and Courts',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(334,330,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(335,330,NULL,'unit','Operations Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(336,330,NULL,'unit','PIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(337,330,NULL,'unit','Process',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(338,330,NULL,'unit','Traffic and BOPD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(339,330,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(340,330,NULL,'unit','Transport',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(341,323,NULL,'station','KINGSVALE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(342,341,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(343,323,NULL,'station','LUCEA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(344,343,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(345,323,NULL,'station','RAMBLE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(346,345,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(347,323,NULL,'station','SANDY BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(348,347,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(349,308,NULL,'division','ST. JAMES',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(350,349,NULL,'zone','ST. JAMES',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(351,350,NULL,'station','ADELPHI',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(352,351,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(353,350,NULL,'station','AMITY HALL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(354,353,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(355,350,NULL,'station','ANCHOVY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(356,355,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(357,350,NULL,'station','BARNETT STREET',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(358,357,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(359,350,NULL,'station','BARRETT TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(360,359,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(361,350,NULL,'station','CORAL GARDENS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(362,361,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(363,350,NULL,'station','GRANVILLE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(364,363,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(365,349,NULL,'zone','MONTEGO BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(366,365,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(367,366,NULL,'unit','Admin',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(368,366,NULL,'unit','BOPD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(369,366,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(370,366,NULL,'unit','CISOCA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(371,366,NULL,'unit','CSSB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(372,366,NULL,'unit','Detention and Courts',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(373,366,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(374,366,NULL,'unit','Operation',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(375,366,NULL,'unit','Ops Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(376,366,NULL,'unit','PIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(377,366,NULL,'unit','Quick Response',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(378,366,NULL,'unit','Special Ops',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(379,366,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(380,350,NULL,'station','MAROON TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(381,380,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(382,350,NULL,'station','MEADOWS OF IRWIN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(383,382,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(384,350,NULL,'station','MONTEGO BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(385,384,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(386,350,NULL,'station','MONTEGO HILLS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(387,386,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(388,350,NULL,'station','MOUNT SALEM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(389,388,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(390,350,NULL,'station','SPRING MOUNT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(391,390,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(392,308,NULL,'division','TRELAWNY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(393,392,NULL,'zone','TRELAWNY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(394,393,NULL,'station','CLARKS TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(395,394,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(396,393,NULL,'station','DUNCANS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(397,396,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(398,393,NULL,'station','FALMOUTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(399,398,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(400,392,NULL,'zone','FALMOUTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(401,400,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(402,401,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(403,401,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(404,401,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(405,401,NULL,'unit','CSSB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(406,401,NULL,'unit','Detention and Courts',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(407,401,NULL,'unit','General Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(408,401,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(409,401,NULL,'unit','Operations Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(410,401,NULL,'unit','PIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(411,401,NULL,'unit','Praedial Larceny',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(412,401,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(413,393,NULL,'station','RIO BUENO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(414,413,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(415,393,NULL,'station','STEWART TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(416,415,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(417,393,NULL,'station','ULSTERS SPRING',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(418,417,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(419,393,NULL,'station','WAIT-A-BIT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(420,419,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(421,393,NULL,'station','WAKEFIELD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(422,421,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(423,393,NULL,'station','WARSOP',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(424,423,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(425,308,NULL,'division','WESTMORELAND',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(426,425,NULL,'zone','WESTMORELAND',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(427,426,NULL,'station','BETHEL TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(428,427,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(429,426,NULL,'station','BLUEFIELDS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(430,429,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(431,426,NULL,'station','DARLISTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(432,431,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(433,426,NULL,'station','FROME',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(434,433,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(435,425,NULL,'zone','SAVANNA-LA-MAR',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(436,435,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(437,436,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(438,436,NULL,'unit','BOPU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(439,436,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(440,436,NULL,'unit','CSS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(441,436,NULL,'unit','OST',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(442,436,NULL,'unit','PIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(443,436,NULL,'unit','Quick Response',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(444,436,NULL,'unit','Shift Clerks',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(445,436,NULL,'unit','Town Enforcement',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(446,436,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(447,436,NULL,'unit','TRT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(448,436,NULL,'unit','ZOSO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(449,426,NULL,'station','LITTLE LONDON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(450,449,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(451,426,NULL,'station','MORGANS BRIDGE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(452,451,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(453,426,NULL,'station','NEGRIL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(454,453,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(455,426,NULL,'station','SAVANNA-LA-MAR',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(456,455,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(457,426,NULL,'station','WHITEHOUSE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(458,457,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(459,426,NULL,'station','WHITHORN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(460,459,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(461,302,NULL,'area','AREA 2',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(462,461,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(463,462,NULL,'zone','ST. MARY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(464,463,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(465,464,NULL,'unit','AIRU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(466,464,NULL,'unit','Court of Enquiry',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(467,464,NULL,'unit','CRIME',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(468,464,NULL,'unit','GARAGE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(469,464,NULL,'unit','General Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(470,464,NULL,'unit','GUARDROOM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(471,464,NULL,'unit','Highway Patrol',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(472,464,NULL,'unit','OPERATIONS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(473,464,NULL,'unit','PECC',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(474,464,NULL,'unit','TELECOM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(475,464,NULL,'unit','Training and Recruiting',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(476,461,NULL,'division','PORTLAND',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(477,476,NULL,'zone','PORTLAND',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(478,477,NULL,'station','BUFF BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(479,478,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(480,477,NULL,'station','CASTLE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(481,480,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(482,476,NULL,'zone','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(483,482,NULL,'station','PORT ANTONIO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(484,483,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(485,483,NULL,'unit','BOP',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(486,483,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(487,483,NULL,'unit','CSSB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(488,483,NULL,'unit','Detention and Courts',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(489,483,NULL,'unit','Divisional Duty Officers',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(490,483,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(491,483,NULL,'unit','Operations Clerk',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(492,483,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(493,483,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(494,477,NULL,'station','HOPE BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(495,494,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(496,477,NULL,'station','MANCHIONEAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(497,496,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(498,477,NULL,'station','MILL BANK',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(499,498,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(500,477,NULL,'station','ORANGE BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(501,500,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(502,477,NULL,'station','PORT ANTONIO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(503,502,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(504,477,NULL,'station','SAN SAN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(505,504,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(506,477,NULL,'station','SPRING HILL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(507,506,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(508,461,NULL,'division','ST. MARY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(509,508,NULL,'zone','ST. MARY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(510,509,NULL,'station','ANNOTTO BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(511,510,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(512,509,NULL,'station','BELFIELD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(513,512,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(514,509,NULL,'station','CASTLETON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(515,514,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(516,509,NULL,'station','GAYLE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(517,516,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(518,508,NULL,'zone','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(519,518,NULL,'station','ST. MARY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(520,519,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(521,519,NULL,'unit','Armoury',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(522,519,NULL,'unit','BOP',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(523,519,NULL,'unit','CCN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(524,519,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(525,519,NULL,'unit','CISOCA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(526,519,NULL,'unit','Command Centre',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(527,519,NULL,'unit','CSSB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(528,519,NULL,'unit','Detention & Courts',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(529,519,NULL,'unit','Domestic Violence',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(530,519,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(531,519,NULL,'unit','PIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(532,519,NULL,'unit','Process',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(533,519,NULL,'unit','Registry',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(534,519,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(535,519,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(536,519,NULL,'unit','Transport',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(537,509,NULL,'station','HIGHGATE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(538,537,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(539,509,NULL,'station','ISLINGTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(540,539,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(541,509,NULL,'station','ORACABESSA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(542,541,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(543,509,NULL,'station','PORT MARIA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(544,543,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(545,509,NULL,'station','PROSPECT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(546,545,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(547,509,NULL,'station','RETREAT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(548,547,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(549,509,NULL,'station','RICHMOND',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(550,549,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(551,461,NULL,'division','ST. ANN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(552,551,NULL,'zone','ST. ANN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(553,552,NULL,'station','ALEXANDRA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(554,553,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(555,552,NULL,'station','BAMBOO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(556,555,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(557,552,NULL,'station','BROWNS TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(558,557,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(559,552,NULL,'station','CAVE VALLEY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(560,559,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(561,552,NULL,'station','CLAREMONT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(562,561,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(563,552,NULL,'station','DISCOVERY BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(564,563,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(565,551,NULL,'zone','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(566,565,NULL,'station','ST. ANN\'S BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(567,566,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(568,566,NULL,'unit','CISOCA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(569,566,NULL,'unit','CSSB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(570,566,NULL,'unit','Detention and Court',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(571,566,NULL,'unit','Domestic Violence',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(572,566,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(573,566,NULL,'unit','PIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(574,566,NULL,'unit','Process',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(575,566,NULL,'unit','Registry',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(576,566,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(577,566,NULL,'unit','Zone 3 CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(578,552,NULL,'station','MONEAGUE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(579,578,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(580,552,NULL,'station','OCHO RIOS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(581,580,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(582,580,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(583,552,NULL,'station','RUNAWAY BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(584,583,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(585,583,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(586,552,NULL,'station','ST. ANN\'S BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(587,586,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(588,586,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(589,586,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(590,552,NULL,'station','WATT TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(591,590,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(592,302,NULL,'area','AREA 3',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(593,592,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(594,593,NULL,'zone','MANDEVILLE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(595,594,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(596,595,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(597,595,NULL,'unit','AFAT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(598,595,NULL,'unit','AIRU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(599,595,NULL,'unit','Court of Enquiry',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(600,595,NULL,'unit','Crime',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(601,595,NULL,'unit','CSSB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(602,595,NULL,'unit','Highway Patrol',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(603,595,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(604,595,NULL,'unit','Operations Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(605,595,NULL,'unit','PECC',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(606,595,NULL,'unit','Recruiting',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(607,595,NULL,'unit','Telecom',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(608,592,NULL,'division','CLARENDON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(609,608,NULL,'zone','CLARENDON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(610,609,NULL,'station','CHAPELTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(611,610,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(612,609,NULL,'station','CROFT\'S HILL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(613,612,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(614,609,NULL,'station','FOUR PATHS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(615,614,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(616,609,NULL,'station','FRANKFIELD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(617,616,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(618,609,NULL,'station','HAYES',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(619,618,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(620,608,NULL,'zone','MAY PEN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(621,620,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(622,621,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(623,621,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(624,621,NULL,'unit','CISOCA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(625,621,NULL,'unit','CSSB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(626,621,NULL,'unit','Detention - Courts',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(627,621,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(628,621,NULL,'unit','PIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(629,621,NULL,'unit','Quick Response',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(630,621,NULL,'unit','BOP',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(631,609,NULL,'station','LIONEL TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(632,631,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(633,609,NULL,'station','LONGVILLE PARK',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(634,633,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(635,609,NULL,'station','MAY PEN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(636,635,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(637,635,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(638,609,NULL,'station','MILK RIVER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(639,638,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(640,609,NULL,'station','MOCHO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(641,640,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(642,609,NULL,'station','ROCK RIVER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(643,642,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(644,592,NULL,'division','MANDEVILLE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(645,644,NULL,'zone','MANDEVILLE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(646,645,NULL,'station','ALLIGATOR POND',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(647,646,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(648,645,NULL,'station','ASIA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(649,648,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(650,645,NULL,'station','CHRISTIANA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(651,650,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(652,645,NULL,'station','COTTAGE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(653,652,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(654,645,NULL,'station','CROSS KEYS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(655,654,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(656,645,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(657,656,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(658,656,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(659,656,NULL,'unit','CSSB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(660,656,NULL,'unit','Detention and Court',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(661,656,NULL,'unit','OST - Central',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(662,656,NULL,'unit','OST - North',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(663,656,NULL,'unit','OST - South',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(664,656,NULL,'unit','Operations - Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(665,656,NULL,'unit','Parish Court',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(666,656,NULL,'unit','Operations - QR',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(667,656,NULL,'unit','Operations - Specialized',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(668,656,NULL,'unit','Operations - Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(669,656,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(670,656,NULL,'unit','BOP',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(671,645,NULL,'station','KENDAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(672,671,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(673,645,NULL,'station','MANDEVILLE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(674,673,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(675,645,NULL,'station','NEWPORT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(676,675,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(677,645,NULL,'station','PORUS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(678,677,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(679,645,NULL,'station','SPAULDING',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(680,679,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(681,645,NULL,'station','WILLIAMSFIELD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(682,681,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(683,592,NULL,'division','ST. ELIZABETH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(684,683,NULL,'zone','ST. ELIZABETH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(685,684,NULL,'station','ASIA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(686,685,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(687,684,NULL,'station','BALACLAVA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(688,687,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(689,684,NULL,'station','BLACK RIVER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(690,689,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(691,683,NULL,'zone','BLACK RIVER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(692,691,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(693,692,NULL,'unit','Case Registry',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(694,692,NULL,'unit','CCTV',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(695,692,NULL,'unit','Compliance Officer',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(696,692,NULL,'unit','Detention Courts',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(697,692,NULL,'unit','DVI Care Centre',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(698,692,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(699,692,NULL,'unit','Operations - K OST 1',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(700,692,NULL,'unit','Operations - K OST 2',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(701,692,NULL,'unit','Operations - K OST 3',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(702,692,NULL,'unit','Operations - K OST 4',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(703,692,NULL,'unit','Motorized Traffic Section',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(704,692,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(705,692,NULL,'unit','Operations Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(706,692,NULL,'unit','Process',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(707,692,NULL,'unit','Operations - QR',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(708,692,NULL,'unit','Transport',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(709,684,NULL,'station','JUNCTION',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(710,709,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(711,684,NULL,'station','LACOVIA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(712,711,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(713,684,NULL,'station','MAGGOTTY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(714,713,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(715,684,NULL,'station','MALVERN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(716,715,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(717,684,NULL,'station','NAIN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(718,717,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(719,684,NULL,'station','NEW MARKET',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(720,719,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(721,684,NULL,'station','PEDRO PLAINS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(722,721,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(723,684,NULL,'station','SANTA CRUZ',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(724,723,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(725,723,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(726,684,NULL,'station','SILOAH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(727,726,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(728,302,NULL,'area','AREA 4',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(729,728,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(730,729,NULL,'zone','SPECIALIZED OPERATIONS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(731,730,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(732,731,NULL,'unit','AFAT ALPHA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(733,731,NULL,'unit','AFAT BRAVO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(734,731,NULL,'unit','AFAT CHARLIE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(735,731,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(736,731,NULL,'unit','CSS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(737,731,NULL,'unit','FOB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(738,731,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(739,731,NULL,'unit','OPS AND TRANSPORT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(740,731,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(741,731,NULL,'unit','WMS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(742,728,NULL,'division','KINGSTON EAST',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(743,742,NULL,'zone','KINGSTON EAST',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(744,743,NULL,'station','BULL BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(745,744,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(746,743,NULL,'station','ELLESTON ROAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(747,746,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:21','2026-07-10 01:01:21'),(748,743,NULL,'station','FRANKLYN TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(749,748,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(750,743,NULL,'station','HARBOUR VIEW',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(751,750,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(752,742,NULL,'zone','ELLETSON ROAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(753,752,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(754,753,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(755,753,NULL,'unit','CSS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(756,753,NULL,'unit','DTSO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(757,753,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(758,753,NULL,'unit','Operations - OST Alpha',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(759,753,NULL,'unit','Operations - OST Bravo',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(760,753,NULL,'unit','Operations - OST Charlie',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(761,753,NULL,'unit','Operations - OST Delta',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(762,753,NULL,'unit','PIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(763,753,NULL,'unit','Operations - Team 1',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(764,753,NULL,'unit','Operations - Team 2',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(765,753,NULL,'unit','Operations - Team 3',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(766,753,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(767,743,NULL,'station','MOUNTAIN VIEW',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(768,767,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(769,743,NULL,'station','PORT ROYAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(770,769,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(771,743,NULL,'station','PROCESS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(772,771,NULL,'unit','Process',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(773,743,NULL,'station','ROCKFORT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(774,773,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(775,743,NULL,'station','ROLLINGTON TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(776,775,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(777,743,NULL,'station','VINEYARD TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(778,777,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(779,728,NULL,'division','KINGSTON WEST',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(780,779,NULL,'zone','KINGSTON WEST',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(781,780,NULL,'station','ADMIRAL TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(782,781,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(783,780,NULL,'station','DARLING STREET',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(784,783,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(785,780,NULL,'station','DENHAM TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(786,785,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(787,779,NULL,'zone','DENHAM TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(788,787,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(789,788,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(790,788,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(791,788,NULL,'unit','Lock Up',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(792,788,NULL,'unit','ZOSO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(793,788,NULL,'unit','General Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(794,788,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(795,788,NULL,'unit','PIU Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(796,788,NULL,'unit','Tivoli Police Post',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(797,780,NULL,'station','TRENCH TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(798,797,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(799,728,NULL,'division','KINGSTON CENTRAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(800,799,NULL,'zone','KINGSTON CENTRAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(801,800,NULL,'station','ALLMAN TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(802,801,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(803,800,NULL,'station','KINGSTON CENTRAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(804,803,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(805,800,NULL,'station','CITY CENTRE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(806,805,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(807,800,NULL,'station','FLETCHERS LAND',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(808,807,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(809,800,NULL,'station','GOLD STREET',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(810,809,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(811,800,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(812,811,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(813,811,NULL,'unit','Compliance',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(814,811,NULL,'unit','Court',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(815,811,NULL,'unit','CSS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(816,811,NULL,'unit','Lock Up',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(817,811,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(818,728,NULL,'division','ST. ANDREW CENTRAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(819,818,NULL,'zone','ST. ANDREW CENTRAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(820,819,NULL,'station','AUGUST TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(821,820,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(822,819,NULL,'station','CROSS ROAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(823,822,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(824,819,NULL,'station','HALF-WAY TREE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(825,824,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(826,824,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(827,824,NULL,'unit','Lock Up',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(828,818,NULL,'zone','HALF-WAY-TREE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(829,828,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(830,829,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(831,829,NULL,'unit','CSS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(832,829,NULL,'unit','Court - KSA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(833,829,NULL,'unit','OST',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(834,829,NULL,'unit','Special Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(835,819,NULL,'station','MATILDAS CORNER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(836,835,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(837,819,NULL,'station','MONA POLICE POST',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(838,837,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(839,819,NULL,'station','NATIONAL STADIUM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(840,839,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(841,819,NULL,'station','NEW KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(842,841,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(843,819,NULL,'station','PAPINE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(844,843,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(845,728,NULL,'division','ST. ANDREW SOUTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(846,845,NULL,'zone','ST. ANDREW SOUTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(847,846,NULL,'station','DUHANEY PARK',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(848,847,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(849,845,NULL,'zone','HUNT\'S BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(850,849,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(851,850,NULL,'unit','CIB OFFICE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(852,850,NULL,'unit','Compliance',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(853,850,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(854,850,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(855,850,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(856,850,NULL,'unit','Lockups',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(857,850,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(858,850,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(859,850,NULL,'unit','Transport',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(860,846,NULL,'station','HUNTS BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(861,860,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(862,846,NULL,'station','OLYMPIC GARDENS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(863,862,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(864,846,NULL,'station','SEAVIEW GARDENS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(865,864,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(866,302,NULL,'area','AREA 5',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(867,866,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(868,867,NULL,'zone','CONSTANT SPRING',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(869,868,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(870,869,NULL,'unit','AFAT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(871,869,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(872,869,NULL,'unit','Transport',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(873,869,NULL,'unit','Crime Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(874,866,NULL,'division','ST. ANDREW NORTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(875,874,NULL,'zone','ST. ANDREW NORTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(876,875,NULL,'station','CONSTANT SPRING',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(877,876,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(878,875,NULL,'station','GORDON TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(879,878,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(880,875,NULL,'station','GRANTS PEN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(881,880,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(882,874,NULL,'zone','CONSTANT SPRING',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(883,882,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(884,883,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(885,883,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(886,883,NULL,'unit','CSS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(887,883,NULL,'unit','Highway Patrol',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(888,883,NULL,'unit','Operations Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(889,883,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(890,883,NULL,'unit','Special Foot Patrol Team',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(891,883,NULL,'unit','Special Operations Team',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(892,883,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(893,875,NULL,'station','IRISH TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(894,893,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(895,875,NULL,'station','LAWRENCE TAVERN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(896,895,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(897,875,NULL,'station','MAVIS BANK',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(898,897,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(899,875,NULL,'station','RED HILLS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(900,899,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(901,875,NULL,'station','STONY HILL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(902,901,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(903,866,NULL,'division','ST. CATHERINE SOUTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(904,903,NULL,'zone','ST. CATHERINE SOUTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(905,904,NULL,'station','BRIDGEPORT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(906,905,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(907,904,NULL,'station','CAYMANAS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(908,907,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(909,904,NULL,'station','CENTRAL VILLAGE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(910,909,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(911,904,NULL,'station','HELLSHIRE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(912,911,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(913,903,NULL,'zone','PORTMORE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(914,913,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(915,914,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(916,914,NULL,'unit','Children\'s Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(917,914,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(918,914,NULL,'unit','CISOCA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(919,914,NULL,'unit','Compliance & Stores',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(920,914,NULL,'unit','CSS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(921,914,NULL,'unit','Detention & Courts',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(922,914,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(923,914,NULL,'unit','PIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(924,914,NULL,'unit','Registry',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(925,914,NULL,'unit','Sudden Death & Transport',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(926,914,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(927,914,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(928,904,NULL,'station','OLD HARBOUR',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(929,928,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(930,928,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(931,928,NULL,'unit','OST',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(932,904,NULL,'station','OLD HARBOUR BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(933,932,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(934,904,NULL,'station','PORTMORE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(935,934,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(936,866,NULL,'division','ST. CATHERINE NORTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(937,936,NULL,'zone','ST. CATHERINE NORTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(938,937,NULL,'station','ABOVE ROCKS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(939,938,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(940,937,NULL,'station','BOG WALK',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(941,940,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(942,937,NULL,'station','BROWN\'S HALL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(943,942,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(944,937,NULL,'station','EWARTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(945,944,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(946,937,NULL,'station','GLENGOFFE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(947,946,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(948,937,NULL,'station','GREEN ACRES',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(949,948,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(950,937,NULL,'station','GUANOBOA VALE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(951,950,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(952,937,NULL,'station','GUYS HILL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(953,952,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(954,936,NULL,'zone','SPANISH TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(955,954,NULL,'station','HQ - SPANISH TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(956,955,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(957,955,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(958,955,NULL,'unit','CISOCA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(959,955,NULL,'unit','Compliance',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(960,955,NULL,'unit','Court',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(961,955,NULL,'unit','CSSB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(962,955,NULL,'unit','Detention',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(963,955,NULL,'unit','Jamaica Eye',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(964,955,NULL,'unit','Missing Person',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(965,955,NULL,'unit','NSI',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(966,955,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(967,955,NULL,'unit','PIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(968,955,NULL,'unit','Process',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(969,955,NULL,'unit','Registry',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(970,955,NULL,'unit','Sudden Death',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(971,955,NULL,'unit','Traffic',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(972,955,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(973,955,NULL,'unit','Transport',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(974,937,NULL,'station','LINSTEAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(975,974,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(976,937,NULL,'station','POINT HILL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(977,976,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(978,937,NULL,'station','RIVERSDALE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(979,978,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(980,937,NULL,'station','SHADY GROVE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(981,980,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(982,937,NULL,'station','SLIGOVILLE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(983,982,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(984,937,NULL,'station','SPANISH TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(985,984,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(986,866,NULL,'division','ST. THOMAS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(987,986,NULL,'zone','ST. THOMAS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(988,987,NULL,'station','BATH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(989,988,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(990,987,NULL,'station','CEDAR VALLEY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(991,990,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(992,987,NULL,'station','GOLDEN GROVE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(993,992,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(994,986,NULL,'zone','MORANT BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(995,994,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(996,995,NULL,'unit','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(997,995,NULL,'unit','CSS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(998,995,NULL,'unit','DDO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(999,995,NULL,'unit','Detention and Court',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1000,995,NULL,'unit','DFAT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1001,995,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1002,995,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1003,995,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1004,995,NULL,'unit','ODU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1005,995,NULL,'unit','Process',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1006,995,NULL,'unit','Traffic & Highway',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1007,995,NULL,'unit','Transport Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1008,987,NULL,'station','LLANDEWEY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1009,1008,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1010,987,NULL,'station','MORANT BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1011,1010,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1012,987,NULL,'station','PORT MORANT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1013,1012,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1014,987,NULL,'station','STAPLEE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1015,1014,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1016,987,NULL,'station','TRINITYVILLE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1017,1016,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1018,987,NULL,'station','YALLAHS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1019,1018,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1020,302,NULL,'area','Agricultural Protection Branch',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1021,1020,NULL,'division','Agricultural Protection',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1022,1021,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1023,1022,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1024,1023,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1025,1021,NULL,'zone','AREA 1',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1026,1025,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1027,1026,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1028,1021,NULL,'zone','AREA 2',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1029,1028,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1030,1029,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1031,1021,NULL,'zone','AREA 3',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1032,1031,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1033,1032,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1034,1021,NULL,'zone','AREA 5',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1035,1034,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1036,1035,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1037,302,NULL,'area','Community Safety and Security Branch',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1038,1037,NULL,'division','Community Safety and Security Branch',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1039,1038,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1040,1039,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1041,1040,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1042,1037,NULL,'division','BAND',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1043,1042,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1044,1043,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1045,1044,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1046,302,NULL,'area','Border Security Branch',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1047,1046,NULL,'division','Border Security Branch',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1048,1047,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1049,1048,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1050,1049,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1051,1046,NULL,'division','CANINE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1052,1051,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1053,1052,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1054,1053,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1055,1046,NULL,'division','MARINE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1056,1055,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1057,1056,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1058,1057,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1059,1055,NULL,'zone','OLD HARBOUR BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1060,1059,NULL,'station','OLD HARBOUR BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1061,1060,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1062,1055,NULL,'zone','BLACK RIVER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1063,1062,NULL,'station','BLACK RIVER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1064,1063,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1065,1055,NULL,'zone','BLUEFIELDS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1066,1065,NULL,'station','BLUEFIELDS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1067,1066,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1068,1055,NULL,'zone','NEGRIL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1069,1068,NULL,'station','NEGRIL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1070,1069,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1071,1055,NULL,'zone','MONTEGO BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1072,1071,NULL,'station','MONTEGO BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1073,1072,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1074,1055,NULL,'zone','FALMOUTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1075,1074,NULL,'station','FALMOUTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1076,1075,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1077,1055,NULL,'zone','OCH RIOS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1078,1077,NULL,'station','OCH RIOS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1079,1078,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1080,1055,NULL,'zone','ORACABESSA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1081,1080,NULL,'station','ORACABESSA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1082,1081,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1083,1055,NULL,'zone','PORT ANTONIO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1084,1083,NULL,'station','PORT ANTONIO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1085,1084,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1086,1055,NULL,'zone','BOWDEN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1087,1086,NULL,'station','BOWDEN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1088,1087,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1089,1055,NULL,'zone','ST. THOMAS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1090,1089,NULL,'station','ST. THOMAS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1091,1090,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1092,1046,NULL,'division','PORTS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1093,1092,NULL,'zone','ST. JAMES',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1094,1093,NULL,'station','Freeport',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1095,1094,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1096,1092,NULL,'zone','ST. MARY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1097,1096,NULL,'station','Ian Flemming',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1098,1097,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1099,1092,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1100,1099,NULL,'station','Newport West',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1101,1100,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1102,1099,NULL,'station','NMIA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1103,1102,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1104,1093,NULL,'station','SIA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1105,1104,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1106,302,NULL,'area','Strategic Operations (HQ)',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1107,1106,NULL,'division','Protective Services',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1108,1107,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1109,1108,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1110,1109,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1111,1109,NULL,'unit','Static',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1112,1108,NULL,'station','CPO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1113,1112,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1114,1108,NULL,'station','GG',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1115,1114,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1116,1108,NULL,'station','GORDON HOUSE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1117,1116,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1118,1108,NULL,'station','JAMAICA HOUSE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1119,1118,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1120,1108,NULL,'station','JUDICIARY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1121,1120,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1122,1108,NULL,'station','KINGS HOUSE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1123,1122,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1124,1108,NULL,'station','LOP',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1125,1124,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1126,1108,NULL,'station','MHPM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1127,1126,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1128,1108,NULL,'station','MNS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1129,1128,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1130,1108,NULL,'station','SOU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1131,1130,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1132,1106,NULL,'division','Visual Identification Unit',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1133,1132,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1134,1133,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1135,1134,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1136,1132,NULL,'zone','AREA 2',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1137,1136,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1138,1137,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1139,1132,NULL,'zone','AREA 3',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1140,1139,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1141,1140,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1142,1132,NULL,'zone','AREA 4',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1143,1142,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1144,1143,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1145,1132,NULL,'zone','AREA 5',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1146,1145,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1147,1146,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1148,1106,NULL,'division','Police Emergency Communication Centre',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1149,1148,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1150,1149,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1151,1150,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1152,302,NULL,'area','Public Safety & Traffic Enforcement Branch',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1153,1152,NULL,'division','PSTEB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1154,1153,NULL,'zone','ELLETSON ROAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1155,1154,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1156,1155,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1157,1155,NULL,'unit','AIRU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1158,1155,NULL,'unit','BOPD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1159,1155,NULL,'unit','Case Registry',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1160,1155,NULL,'unit','CIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1161,1155,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1162,1155,NULL,'unit','FM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1163,1155,NULL,'unit','Health & Wellness',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1164,1152,NULL,'division','HSPD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1165,1164,NULL,'zone','ELLETSON ROAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1166,1165,NULL,'station','HSPD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1167,1166,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1168,1152,NULL,'division','BOPD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1169,1168,NULL,'zone','ELLETSON ROAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1170,1169,NULL,'station','BOPD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1171,1170,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1172,1152,NULL,'division','PUBLIC SAFETY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1173,1172,NULL,'zone','ELLETSON ROAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1174,1173,NULL,'station','PUBLIC SAFETY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1175,1174,NULL,'unit','Metro QR',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1176,1174,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1177,1174,NULL,'unit','Public Order',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1178,1152,NULL,'division','RESORT AREA DIVISION',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1179,1178,NULL,'zone','Falmouth',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1180,1179,NULL,'station','Falmouth',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1181,1180,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1182,1178,NULL,'zone','Ocho Rios',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1183,1182,NULL,'station','Ocho Rios',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1184,1183,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1185,1178,NULL,'zone','Portland',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1186,1185,NULL,'station','Portland',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1187,1186,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1188,1178,NULL,'zone','St. Elizabeth',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1189,1188,NULL,'station','St. Elizabeth',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1190,1189,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1191,1178,NULL,'zone','St. James',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1192,1191,NULL,'station','St. James',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1193,1192,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1194,1178,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1195,1194,NULL,'station','Westmoreland',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1196,1195,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1197,1152,NULL,'division','MOUNTED TROOPS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1198,1197,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1199,1198,NULL,'station','MOUNTED TROOPS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1200,1199,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1201,1152,NULL,'division','TRAFFIC ENFORCEMENT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1202,1201,NULL,'zone','ELLETSON ROAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1203,1202,NULL,'station','TRAFFIC ENFORCEMENT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1204,1203,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1205,302,NULL,'area','Specialized Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1206,1205,NULL,'division','Specialized Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1207,1206,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1208,1207,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1209,1208,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1210,1208,NULL,'unit','Alpha',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1211,1208,NULL,'unit','Bravo',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1212,1208,NULL,'unit','Charlie',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1213,1208,NULL,'unit','SWAT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1214,NULL,NULL,'portfolio','FDLP',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1215,1214,NULL,'area','FDLP',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1216,1215,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1217,1216,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1218,1217,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1219,1218,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1220,1214,NULL,'area','Corporate & Special Services Branch',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1221,1220,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1222,1221,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1223,1222,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1224,1223,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1225,1220,NULL,'division','CRO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1226,1225,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1227,1226,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1228,1227,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1229,1225,NULL,'zone','MAY PEN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1230,1229,NULL,'station','CRO - MAY PEN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1231,1230,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1232,1225,NULL,'zone','ST. MARY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1233,1232,NULL,'station','CRO - ST. MARY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1234,1233,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1235,1225,NULL,'zone','ST. JAMES',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1236,1235,NULL,'station','CRO - ST. JAMES',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:22','2026-07-10 01:01:22'),(1237,1236,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1238,1214,NULL,'area','Support Services Branch',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1239,1238,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1240,1239,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1241,1240,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1242,1241,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1243,1241,NULL,'unit','Asset Management',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1244,1241,NULL,'unit','Conservation',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1245,1241,NULL,'unit','Finance and Procurement',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1246,1238,NULL,'division','ARMOURY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1247,1246,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1248,1247,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1249,1248,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1250,1238,NULL,'division','STORES',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1251,1250,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1252,1251,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1253,1252,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1254,1238,NULL,'division','TMMD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1255,1254,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1256,1255,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1257,1256,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1258,1238,NULL,'division','PMMD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1259,1258,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1260,1259,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1261,1260,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1262,1214,NULL,'area','Planning Research & Development Branch',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1263,1262,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1264,1263,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1265,1264,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1266,1265,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1267,1214,NULL,'area','TECHNOLOGY BRANCH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1268,1267,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1269,1268,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1270,1269,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1271,1270,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1272,1269,NULL,'station','TELECOMMUNICATIONS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1273,1272,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1274,1269,NULL,'station','ICTD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1275,1274,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1276,NULL,NULL,'portfolio','IPROB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1277,1276,NULL,'area','IPROB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1278,1277,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1279,1278,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1280,1279,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1281,1280,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1282,1280,NULL,'unit','ACIO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1283,1280,NULL,'unit','CIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1284,1280,NULL,'unit','Ethics',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1285,1280,NULL,'unit','IIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1286,1280,NULL,'unit','QAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1287,1280,NULL,'unit','Reception',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1288,1280,NULL,'unit','SIT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1289,NULL,NULL,'portfolio','Crime & Security',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1290,1289,NULL,'area','Crime & Security',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1291,1290,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1292,1291,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1293,1292,NULL,'station','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1294,1293,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1295,1289,NULL,'area','CIB',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1296,1295,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1297,1296,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1298,1297,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1299,1298,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1300,1298,NULL,'unit','Analyst',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1301,1298,NULL,'unit','Investigations & Review',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1302,1298,NULL,'unit','Justice Support',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1303,1298,NULL,'unit','Legal Unit',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1304,1298,NULL,'unit','SIMU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1305,1298,NULL,'unit','SRMS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1306,1296,NULL,'zone','AREA 4',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1307,1306,NULL,'station','ST. CATHERINE NORTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1308,1307,NULL,'unit','PLO TEAM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1309,1306,NULL,'station','ST. CATHERINE SOUTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1310,1309,NULL,'unit','PLO TEAM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1311,1296,NULL,'zone','AREA 5',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1312,1311,NULL,'station','ST. ANDREW NORTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1313,1312,NULL,'unit','PLO TEAM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1314,1311,NULL,'station','ST. ANDREW CENTRAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1315,1314,NULL,'unit','PLO TEAM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1316,1307,NULL,'unit','DDI TEAM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1317,1309,NULL,'unit','DDI TEAM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1318,1312,NULL,'unit','DDI TEAM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1319,1314,NULL,'unit','DDI TEAM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1320,1295,NULL,'division','CISOCA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1321,1320,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1322,1321,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1323,1322,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1324,1295,NULL,'division','MID',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1325,1324,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1326,1325,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1327,1326,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1328,1326,NULL,'unit','Inspectors',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1329,1326,NULL,'unit','Team Alpha',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1330,1326,NULL,'unit','Team Bravo',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1331,1326,NULL,'unit','Team Charlie',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1332,1326,NULL,'unit','Team Delta',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1333,1326,NULL,'unit','Team Echo',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1334,1326,NULL,'unit','Team Foxtrot',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1335,1326,NULL,'unit','Team Golf',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1336,1326,NULL,'unit','Team Hotel',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1337,1326,NULL,'unit','Team India',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1338,1324,NULL,'zone','AREA 1',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1339,1338,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1340,1339,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1341,1324,NULL,'zone','AREA 2',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1342,1341,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1343,1342,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1344,1295,NULL,'division','FNID',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1345,1344,NULL,'zone','Area 1',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1346,1345,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1347,1346,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1348,1344,NULL,'zone','Area 2',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1349,1348,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1350,1349,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1351,1344,NULL,'zone','Area 3',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1352,1351,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1353,1352,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1354,1344,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1355,1354,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1356,1355,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1357,1355,NULL,'unit','FIT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1358,1355,NULL,'unit','Intel',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1359,1355,NULL,'unit','Investigations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1360,1355,NULL,'unit','Monitoring & Evaluation',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1361,1355,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1362,1355,NULL,'unit','Special Assignment',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1363,1355,NULL,'unit','Stores',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1364,1344,NULL,'zone','NMIA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1365,1364,NULL,'station','NMIA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1366,1365,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1367,1344,NULL,'zone','Ports',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1368,1367,NULL,'station','Ports',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1369,1368,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1370,1289,NULL,'area','CTOC',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1371,1370,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1372,1371,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1373,1372,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1374,1373,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1375,1373,NULL,'unit','CMU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1376,1373,NULL,'unit','Statistics & Analysis',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1377,1373,NULL,'unit','CEIGU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1378,1373,NULL,'unit','IPRU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1379,1373,NULL,'unit','CTSIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1380,1373,NULL,'unit','TIP',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1381,1373,NULL,'unit','SMVU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1382,1370,NULL,'division','FRAUD SQUAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1383,1382,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1384,1383,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1385,1384,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1386,1370,NULL,'division','NSAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1387,1386,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1388,1387,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1389,1388,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1390,1373,NULL,'unit','Special Operation',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1391,1373,NULL,'unit','Training & WMS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1392,1289,NULL,'area','FORENSIC SERVICES BRANCH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1393,1392,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1394,1393,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1395,1394,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1396,1395,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1397,1395,NULL,'unit','FIBAU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1398,1395,NULL,'unit','Operations',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1399,1395,NULL,'unit','Quality Assurance',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1400,1392,NULL,'division','CFCD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1401,1400,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1402,1401,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1403,1402,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1404,1402,NULL,'unit','Communications',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1405,1402,NULL,'unit','Digital Forensics',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1406,1392,NULL,'division','TSD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1407,1406,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1408,1407,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1409,1408,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1410,1408,NULL,'unit','Ballistic Unit',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1411,1408,NULL,'unit','Fingerprint Bureau',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1412,1408,NULL,'unit','Procurement',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1413,1408,NULL,'unit','Question Documents',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1414,1408,NULL,'unit','Training & Imaging',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1415,1406,NULL,'zone','AREA 1',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1416,1415,NULL,'station','SOC - BETHEL TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1417,1416,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1418,1415,NULL,'station','SOC - FALMOUTH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1419,1418,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1420,1415,NULL,'station','SOC - LUCEA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1421,1420,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1422,1415,NULL,'station','SOC - SUMMIT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1423,1422,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1424,1406,NULL,'zone','AREA 2',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1425,1424,NULL,'station','SOC - ST. MARY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1426,1425,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1427,1406,NULL,'zone','AREA 3',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1428,1427,NULL,'station','SOC - JUNCTION',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1429,1428,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1430,1427,NULL,'station','SOC - MAY PEN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1431,1430,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1432,1427,NULL,'station','SOC - WILLIAMSFIELD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1433,1432,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1434,1406,NULL,'zone','AREA 4',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1435,1434,NULL,'station','SOC - KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1436,1435,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1437,1406,NULL,'zone','AREA 5',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1438,1437,NULL,'station','SOC - ST. CATHERINE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1439,1438,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1440,1437,NULL,'station','SOC - ST. THOMAS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1441,1440,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1442,1289,NULL,'area','INTELLIGENCE BRANCH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1443,1442,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1444,1443,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1445,1444,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1446,1445,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1447,1445,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1448,1442,NULL,'division','NATIONAL INTELLIGENCE BUREAU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1449,1448,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1450,1449,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1451,1450,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1452,1450,NULL,'unit','CAR',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1453,1450,NULL,'unit','CME',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1454,1450,NULL,'unit','DIRC',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1455,1450,NULL,'unit','Duty Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1456,1450,NULL,'unit','Field and Covert',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1457,1450,NULL,'unit','IIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1458,1450,NULL,'unit','Interpol',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1459,1450,NULL,'unit','IPU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1460,1450,NULL,'unit','ISSU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1461,1450,NULL,'unit','JALU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1462,1450,NULL,'unit','SAD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1463,1450,NULL,'unit','SIT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1464,1450,NULL,'unit','SOCIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1465,1450,NULL,'unit','SPU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1466,1450,NULL,'unit','Training',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1467,1450,NULL,'unit','Transport',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1468,1449,NULL,'station','NMIA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1469,1468,NULL,'unit','Aircop',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1470,1468,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1471,1449,NULL,'station','SIA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1472,1471,NULL,'unit','Aircop',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1473,1448,NULL,'zone','AREA 1',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1474,1473,NULL,'station','Hanover',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1475,1474,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1476,1473,NULL,'station','MONTEGO BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1477,1476,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1478,1473,NULL,'station','SIA',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1479,1478,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1480,1473,NULL,'station','St James',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1481,1480,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1482,1473,NULL,'station','Trelawny',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1483,1482,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1484,1473,NULL,'station','Westmoreland',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1485,1484,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1486,1448,NULL,'zone','AREA 2',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1487,1486,NULL,'station','ST. ANN\'S BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1488,1487,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1489,1486,NULL,'station','Portland',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1490,1489,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1491,1486,NULL,'station','St Ann',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1492,1491,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1493,1486,NULL,'station','St Mary',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1494,1493,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1495,1448,NULL,'zone','AREA 3',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1496,1495,NULL,'station','Clarendon',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1497,1496,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1498,1495,NULL,'station','HQ - MANDEVILLE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1499,1498,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1500,1495,NULL,'station','Manchester',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1501,1500,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1502,1495,NULL,'station','St Elizabeth',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1503,1502,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1504,1448,NULL,'zone','AREA 4',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1505,1504,NULL,'station','AFAT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1506,1505,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1507,1504,NULL,'station','Denham Town ZOSO',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1508,1507,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1509,1504,NULL,'station','HQ - Kingston',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1510,1509,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1511,1504,NULL,'station','Central',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1512,1511,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1513,1504,NULL,'station','Elletson Road',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1514,1513,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1515,1504,NULL,'station','Denham Town',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1516,1515,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1517,1504,NULL,'station','Half Way Tree',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1518,1517,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1519,1504,NULL,'station','Hunts Bay',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1520,1519,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1521,1448,NULL,'zone','AREA 5',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1522,1521,NULL,'station','HQ - Kingston',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1523,1522,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1524,1521,NULL,'station','Constant Spring',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1525,1524,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1526,1521,NULL,'station','Spanish Town',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1527,1526,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1528,1521,NULL,'station','Portmore',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1529,1528,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1530,1521,NULL,'station','St. Thomas',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1531,1530,NULL,'unit','DIU',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1532,NULL,NULL,'portfolio','Administration & Support Services',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1533,1532,NULL,'area','DCP ADMINISTRATION',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1534,1533,NULL,'division','DCP ADMINISTRATION',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1535,1534,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1536,1535,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1537,1536,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1538,1533,NULL,'division','ACP ADMINISTRATION',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1539,1538,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1540,1539,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1541,1540,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1542,1533,NULL,'division','DETENTION & COURTS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1543,1542,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1544,1543,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1545,1544,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1546,1539,NULL,'station','COURT OF ENQUIRY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1547,1546,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1548,1539,NULL,'station','Personnel',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1549,1548,NULL,'unit','Establishment',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1550,1548,NULL,'unit','General Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1551,1548,NULL,'unit','Registry',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1552,1533,NULL,'division','CHAPLAINCY SERVICES BRANCH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1553,1552,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1554,1553,NULL,'station','Area 4',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1555,1554,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1556,1553,NULL,'station','CHAPLAINCY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1557,1556,NULL,'unit','HQ - Kingston',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1558,1553,NULL,'station','Non-Geo 2',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1559,1558,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1560,1553,NULL,'station','Non-Geo 3',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1561,1560,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1562,1552,NULL,'zone','MANCHESTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1563,1562,NULL,'station','Area 3',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1564,1563,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1565,1552,NULL,'zone','SPANISH TOWN',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1566,1565,NULL,'station','Area 5',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1567,1566,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1568,1552,NULL,'zone','ST. CATHERINE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1569,1568,NULL,'station','Non-Geo 1',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1570,1569,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1571,1552,NULL,'zone','ST. JAMES',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1572,1571,NULL,'station','Area 1',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1573,1572,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1574,1552,NULL,'zone','ST. MARY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1575,1574,NULL,'station','Area 2',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1576,1575,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1577,1533,NULL,'division','MEDICAL SERVICES BRANCH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1578,1577,NULL,'zone','ST. CATHERINE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1579,1578,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1580,1579,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1581,1533,NULL,'division','WELFARE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1582,1581,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1583,1582,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1584,1583,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1585,1533,NULL,'division','TRAINING BRANCH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1586,1585,NULL,'zone','ST. CATHERINE',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1587,1586,NULL,'station','CAMP VERLY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1588,1587,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1589,1585,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1590,1589,NULL,'station','HARMAN BARRACKS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1591,1590,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1592,1585,NULL,'zone','ST. ELIZABETH',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1593,1592,NULL,'station','TRANQUILITY BAY',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1594,1593,NULL,'unit','General',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1595,1586,NULL,'station','NPCJ',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1596,1595,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1597,1595,NULL,'unit','Cafeteria',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1598,1595,NULL,'unit','CDCD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1599,1595,NULL,'unit','DCIT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1600,1595,NULL,'unit','DDT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1601,1595,NULL,'unit','Dept. of Academic Studies',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1602,1595,NULL,'unit','DSM',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1603,1595,NULL,'unit','DWTT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1604,1595,NULL,'unit','Finance Unit',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1605,1595,NULL,'unit','FIPT',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1606,1595,NULL,'unit','FLPD - Special Programs',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1607,1595,NULL,'unit','FLPD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1608,1595,NULL,'unit','FOMST - Search Centre',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1609,1595,NULL,'unit','FOMST - Transport',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1610,1595,NULL,'unit','Food & Beverage',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:23','2026-07-10 01:01:23'),(1611,1595,NULL,'unit','IT Department',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1612,1595,NULL,'unit','JCF Promotional Programme',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1613,1595,NULL,'unit','Monitoring & Compliance Department',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1614,1595,NULL,'unit','PMLD',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1615,1595,NULL,'unit','Polygraph Unit',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1616,1595,NULL,'unit','Procurement Unit',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1617,1595,NULL,'unit','Special Projects',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1618,1595,NULL,'unit','Student Registry',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1619,1595,NULL,'unit','The Cadet Academy',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1620,1595,NULL,'unit','Training Branch',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1621,1595,NULL,'unit','Training Division',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1622,1595,NULL,'unit','WMS',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1623,1595,NULL,'unit','Dept. of Force Recruiting',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1624,NULL,NULL,'portfolio','CP Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1625,1624,NULL,'area','CP Office',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1626,1625,NULL,'division','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1627,1626,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1628,1627,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1629,1628,NULL,'unit','Administration',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1630,1628,NULL,'unit','Sentry',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1631,1628,NULL,'unit','Crime Stop',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1632,1628,NULL,'unit','Security Detail',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1633,1625,NULL,'division','LEGAL AFFAIRS DIVISION',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1634,1633,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1635,1634,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1636,1635,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1637,1625,NULL,'division','CONSTABULARY COMMUNICATION NETWORK',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1638,1637,NULL,'zone','KINGSTON',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1639,1638,NULL,'station','HEADQUARTER',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24'),(1640,1639,NULL,'unit','GENERAL',NULL,NULL,NULL,NULL,1,'2026-07-10 01:01:24','2026-07-10 01:01:24');

--
-- Table structure for table `invoice_items`
--

CREATE TABLE `invoice_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `purchase_order_item_id` bigint(20) unsigned DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `unit_price` decimal(15,2) NOT NULL,
  `line_total` decimal(15,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_items_invoice_id_foreign` (`invoice_id`),
  KEY `invoice_items_purchase_order_item_id_foreign` (`purchase_order_item_id`),
  CONSTRAINT `invoice_items_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_items_purchase_order_item_id_foreign` FOREIGN KEY (`purchase_order_item_id`) REFERENCES `purchase_order_items` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=447 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoice_items`
--

INSERT INTO `invoice_items` VALUES (444,444,829,'Chairs - Office Standard',4.00,1750.00,7000.00,'2026-06-19 20:55:12','2026-06-19 20:55:12'),(445,445,1172,'Table',5.00,35.71,178.57,'2026-06-19 21:36:34','2026-06-19 21:36:34'),(446,445,1173,'Chairs - Office Standard',1.00,71.43,71.43,'2026-06-19 21:36:34','2026-06-19 21:36:34');

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_number` varchar(40) NOT NULL COMMENT 'system ref',
  `supplier_invoice_no` varchar(60) DEFAULT NULL COMMENT 'supplier''s own number',
  `requisition_id` bigint(20) unsigned NOT NULL,
  `purchase_order_id` bigint(20) unsigned NOT NULL,
  `supplier_id` bigint(20) unsigned NOT NULL,
  `invoice_date` date NOT NULL,
  `due_date` date DEFAULT NULL,
  `currency` char(3) NOT NULL DEFAULT 'JMD',
  `subtotal` decimal(15,2) NOT NULL DEFAULT 0.00,
  `tax_total` decimal(15,2) NOT NULL DEFAULT 0.00,
  `total` decimal(15,2) NOT NULL DEFAULT 0.00,
  `attachment_path` varchar(255) DEFAULT NULL,
  `original_sighted_signature` longtext DEFAULT NULL,
  `original_sighted_by_name` varchar(191) DEFAULT NULL,
  `original_sighted_at` datetime DEFAULT NULL,
  `payment_approved_signature` longtext DEFAULT NULL,
  `payment_approved_by_name` varchar(191) DEFAULT NULL,
  `payment_approved_at` datetime DEFAULT NULL,
  `received_by_pal_at` datetime DEFAULT NULL COMMENT 'step 17',
  `verified_by` bigint(20) unsigned DEFAULT NULL,
  `verified_at` datetime DEFAULT NULL,
  `verification_status` varchar(15) NOT NULL DEFAULT 'pending' COMMENT 'pending|matched|discrepancy',
  `discrepancy_notes` text DEFAULT NULL,
  `received_by_procurement_at` datetime DEFAULT NULL COMMENT 'step 19',
  `sent_to_finance_at` datetime DEFAULT NULL COMMENT 'step 20',
  `status` varchar(20) NOT NULL DEFAULT 'submitted' COMMENT 'submitted|pal_verified|with_procurement|with_finance|paid|disputed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoices_invoice_number_unique` (`invoice_number`),
  KEY `invoices_requisition_id_foreign` (`requisition_id`),
  KEY `invoices_purchase_order_id_foreign` (`purchase_order_id`),
  KEY `invoices_supplier_id_foreign` (`supplier_id`),
  KEY `invoices_verified_by_foreign` (`verified_by`),
  KEY `invoices_status_index` (`status`),
  CONSTRAINT `invoices_purchase_order_id_foreign` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_orders` (`id`),
  CONSTRAINT `invoices_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`),
  CONSTRAINT `invoices_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`),
  CONSTRAINT `invoices_verified_by_foreign` FOREIGN KEY (`verified_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=446 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` VALUES (444,'INV-2026-00001','123',595,829,8,'2026-06-19','2026-06-19','JMD',7000.00,78.00,7078.00,'invoices/X1fw9HI1tkWiQKdzdpwkxQ7VizBUZxWQoVZCYAWQ.pdf',NULL,NULL,NULL,NULL,NULL,NULL,'2026-06-19 15:55:17',NULL,NULL,'pending',NULL,NULL,NULL,'submitted','2026-06-19 20:55:12','2026-06-19 20:55:17'),(445,'INV-2026-00002','123',2363,1172,2,'2026-06-19','2026-06-22','JMD',250.00,25.00,275.00,'invoices/0ahOmEL1N1UjfQRmchD3RaamA2MHkmmzezBC0fIW.pdf','data:image/png;base64,[BLOB]','Paula PAL','2026-06-19 16:38:25','data:image/png;base64,[BLOB]','Pierre Procure','2026-06-19 16:39:25','2026-06-19 16:38:09',4,'2026-06-19 16:38:25','matched',NULL,'2026-06-19 16:39:25','2026-06-19 16:39:25','paid','2026-06-19 21:36:34','2026-06-19 21:41:15');

--
-- Table structure for table `item_categories`
--

CREATE TABLE `item_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(150) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `item_categories_parent_id_foreign` (`parent_id`),
  CONSTRAINT `item_categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `item_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `item_categories`
--

INSERT INTO `item_categories` VALUES (1,NULL,'Office Supplies','2026-06-16 03:19:13','2026-06-16 03:19:13'),(2,NULL,'IT Equipment','2026-06-16 03:19:13','2026-06-16 03:19:13'),(3,NULL,'Facilities','2026-06-16 03:19:13','2026-06-16 03:19:13'),(4,NULL,'Services','2026-06-16 03:19:13','2026-06-16 03:19:13');

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `subcategory` varchar(150) DEFAULT NULL,
  `uom_id` bigint(20) unsigned NOT NULL,
  `name` varchar(200) NOT NULL,
  `sku` varchar(50) DEFAULT NULL,
  `type` varchar(10) NOT NULL DEFAULT 'good' COMMENT 'good|service',
  `description` text DEFAULT NULL,
  `standard_specification` text DEFAULT NULL,
  `estimated_unit_cost` decimal(15,2) DEFAULT NULL,
  `last_purchase_price` decimal(15,2) DEFAULT NULL,
  `preferred_supplier_id` bigint(20) unsigned DEFAULT NULL,
  `alternative_suppliers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'array of supplier ids' CHECK (json_valid(`alternative_suppliers`)),
  `is_stock` tinyint(1) NOT NULL DEFAULT 0,
  `is_asset` tinyint(1) NOT NULL DEFAULT 0,
  `is_restricted` tinyint(1) NOT NULL DEFAULT 0,
  `approval_level` varchar(50) DEFAULT NULL COMMENT 'required authorisation level',
  `warranty_requirement` varchar(150) DEFAULT NULL,
  `min_order_quantity` decimal(15,2) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `items_sku_unique` (`sku`),
  KEY `items_category_id_foreign` (`category_id`),
  KEY `items_uom_id_foreign` (`uom_id`),
  KEY `items_preferred_supplier_id_foreign` (`preferred_supplier_id`),
  CONSTRAINT `items_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `item_categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `items_preferred_supplier_id_foreign` FOREIGN KEY (`preferred_supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE SET NULL,
  CONSTRAINT `items_uom_id_foreign` FOREIGN KEY (`uom_id`) REFERENCES `units_of_measure` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `items`
--

INSERT INTO `items` VALUES (1,1,'Printers',6,'A4 Bond Paper (80gsm)','OS-A4-80','good',NULL,NULL,950.00,45000.00,NULL,NULL,0,1,0,NULL,'1yr',1.00,1,'2026-06-16 03:19:13','2026-07-09 22:32:58'),(2,1,NULL,2,'Ballpoint Pen (Blue)','OS-PEN-BL','good',NULL,NULL,480.00,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,1,'2026-06-16 03:19:13','2026-06-16 03:19:13'),(3,1,NULL,1,'Stapler Heavy Duty','OS-STP-HD','good',NULL,NULL,1850.00,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,1,'2026-06-16 03:19:13','2026-06-16 03:19:13'),(4,2,NULL,1,'Laptop 14\" i5 16GB','IT-LT-I5','good',NULL,NULL,165000.00,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,1,'2026-06-16 03:19:13','2026-06-16 03:19:13'),(5,2,NULL,1,'Wireless Mouse','IT-MS-WL','good',NULL,NULL,2400.00,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,1,'2026-06-16 03:19:13','2026-06-16 03:19:13'),(6,2,NULL,1,'USB-C Hub','IT-HUB-C','good',NULL,NULL,6800.00,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,1,'2026-06-16 03:19:13','2026-06-16 03:19:13'),(7,3,NULL,1,'Cleaning Detergent 5L','FC-DET-5L','good',NULL,NULL,1450.00,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,1,'2026-06-16 03:19:13','2026-06-16 03:19:13'),(8,4,NULL,11,'Air-Conditioning Servicing','SV-AC-SVC','service',NULL,NULL,12000.00,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,1,'2026-06-16 03:19:13','2026-06-16 03:19:13'),(12,1,NULL,1,'Chairs - Office Standard','Standard Office Chair','good','Use by Lower managers',NULL,20000.00,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,1,'2026-06-16 07:15:58','2026-07-09 23:43:34'),(43,1,NULL,1,'Table',NULL,'good',NULL,NULL,500.00,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,1,'2026-06-19 21:01:53','2026-06-19 21:01:53'),(44,1,NULL,1,'Map',NULL,'good',NULL,NULL,100.00,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,1,'2026-07-10 19:50:09','2026-07-10 19:50:09'),(45,1,NULL,2,'Bucket',NULL,'good',NULL,NULL,0.00,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,1,'2026-07-10 19:50:52','2026-07-10 19:50:52');

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` VALUES (1,'default','{\"uuid\":\"7cf1d16d-47c5-437c-b485-5b907b197622\",\"displayName\":\"App\\\\Jobs\\\\AnalyzeRequisitionQuotes\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\AnalyzeRequisitionQuotes\",\"command\":\"O:33:\\\"App\\\\Jobs\\\\AnalyzeRequisitionQuotes\\\":1:{s:13:\\\"requisitionId\\\";i:595;}\",\"batchId\":null},\"createdAt\":1781584016,\"delay\":null}',0,NULL,1781584016,1781584016),(2,'default','{\"uuid\":\"06193a58-c043-4fa8-9d65-401c033987e3\",\"displayName\":\"App\\\\Jobs\\\\AnalyzeRequisitionQuotes\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\AnalyzeRequisitionQuotes\",\"command\":\"O:33:\\\"App\\\\Jobs\\\\AnalyzeRequisitionQuotes\\\":1:{s:13:\\\"requisitionId\\\";i:2363;}\",\"batchId\":null},\"createdAt\":1781885900,\"delay\":null}',0,NULL,1781885900,1781885900),(3,'default','{\"uuid\":\"2cdc3903-7d5e-42cb-94a6-9e0ac7bfe941\",\"displayName\":\"App\\\\Jobs\\\\AnalyzeRequisitionQuotes\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\AnalyzeRequisitionQuotes\",\"command\":\"O:33:\\\"App\\\\Jobs\\\\AnalyzeRequisitionQuotes\\\":1:{s:13:\\\"requisitionId\\\";i:2363;}\",\"batchId\":null},\"createdAt\":1781885929,\"delay\":null}',0,NULL,1781885929,1781885929);

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2026_06_15_130001_create_areas_table',2),(6,'2026_06_15_130002_create_stations_table',2),(7,'2026_06_15_130003_create_suppliers_table',2),(8,'2026_06_15_130004_add_pal_fields_to_users_table',2),(9,'2026_06_15_130005_create_item_categories_table',2),(10,'2026_06_15_130006_create_units_of_measure_table',2),(11,'2026_06_15_130007_create_items_table',2),(12,'2026_06_15_130008_create_requisitions_table',2),(13,'2026_06_15_130009_create_requisition_items_table',2),(14,'2026_06_15_130010_create_requisition_approvals_table',2),(15,'2026_06_15_130011_create_quotes_table',2),(16,'2026_06_15_130012_create_quote_items_table',2),(17,'2026_06_15_130013_create_purchase_orders_table',2),(18,'2026_06_15_130014_create_purchase_order_items_table',2),(19,'2026_06_15_130015_create_deliveries_table',2),(20,'2026_06_15_130016_create_delivery_items_table',2),(21,'2026_06_15_130017_create_delivery_issues_table',2),(22,'2026_06_15_130018_create_invoices_table',2),(23,'2026_06_15_130019_create_invoice_items_table',2),(24,'2026_06_15_130020_create_payments_table',2),(25,'2026_06_15_130021_create_supplier_ratings_table',2),(26,'2026_06_15_130022_create_workflow_logs_table',2),(27,'2026_06_15_130023_create_attachments_table',2),(28,'2026_06_15_140001_create_pal_offices_table',3),(29,'2026_06_15_140002_create_assets_table',4),(30,'2026_06_15_150001_add_signature_to_requisition_approvals',5),(31,'2026_06_15_160001_create_jobs_table',6),(32,'2026_06_15_160002_create_quote_analyses_table',6),(33,'2026_06_16_120001_add_attachment_to_purchase_orders',7),(34,'2026_06_16_120002_add_preparer_threshold_to_pal_offices',8),(35,'2026_06_16_130001_create_org_units_table',9),(36,'2026_06_16_140001_add_username_and_password_change_to_users',10),(37,'2026_06_16_150001_create_supplier_surveys_table',11),(38,'2026_06_16_160001_create_followups_and_sla_tables',12),(39,'2026_06_17_090001_add_certification_to_invoices',13),(40,'2026_06_19_100001_create_procurement_methods_table',14),(41,'2026_06_19_100002_add_procurement_method_to_requisitions',14),(42,'2026_07_08_100001_create_approval_thresholds_table',15),(43,'2026_07_08_100002_create_formations_table',16),(44,'2026_07_08_100003_create_budgets_tables',17),(45,'2026_07_09_100001_add_approval_limits_and_delegations',18),(46,'2026_07_09_100002_add_compliance_to_suppliers',19),(47,'2026_07_09_100003_create_reason_codes_table',20),(48,'2026_07_09_100004_create_activity_logs_table',21),(49,'2026_07_09_100005_enrich_items_table',22),(50,'2026_07_09_100006_enrich_stations_table',22),(51,'2026_07_09_100007_create_notifications_table',23),(52,'2026_07_09_100008_add_metadata_to_attachments',24),(53,'2026_07_09_100009_create_delivery_locations_table',25),(54,'2026_07_09_100010_add_formation_to_requisitions',26),(55,'2026_07_09_120000_make_supplier_type_multi',27),(56,'2026_07_10_090000_add_pal_office_to_formations',28);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(191) NOT NULL,
  `notifiable_type` varchar(191) NOT NULL,
  `notifiable_id` bigint(20) unsigned NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` VALUES ('16619641-7966-4365-a69c-fa616c7b24ef','App\\Notifications\\RequisitionActionRequired','App\\Models\\User',4,'{\"requisition_id\":2363,\"reference_no\":\"REQ-2026-00002\",\"title\":\"Table\",\"status\":\"pal_processing\",\"status_label\":\"Pal Processing\",\"action\":\"record quotes and submit to Procurement\",\"variant\":\"info\",\"url\":\"http:\\/\\/localhost\\/requisitions\\/2363\"}',NULL,'2026-07-10 04:56:07','2026-07-10 04:56:07'),('200f1ca0-ec59-4468-b0a1-bf8b78a2e0b1','App\\Notifications\\RequisitionActionRequired','App\\Models\\User',13,'{\"requisition_id\":2363,\"reference_no\":\"REQ-2026-00002\",\"title\":\"Table\",\"status\":\"pal_processing\",\"status_label\":\"Pal Processing\",\"action\":\"record quotes and submit to Procurement\",\"variant\":\"info\",\"url\":\"http:\\/\\/localhost\\/requisitions\\/2363\"}',NULL,'2026-07-10 04:56:07','2026-07-10 04:56:07'),('4362da20-7c2e-441a-aa78-d54b701bf318','App\\Notifications\\RequisitionActionRequired','App\\Models\\User',3,'{\"requisition_id\":2364,\"reference_no\":\"REQ-2026-00003\",\"title\":\"Request for Stations Supplies\",\"status\":\"submitted\",\"status_label\":\"Submitted\",\"action\":\"review and approve the requisition\",\"variant\":\"info\",\"url\":\"http:\\/\\/localhost\\/pal\\/pal-app\\/public\\/requisitions\\/2364\"}',NULL,'2026-07-10 19:53:14','2026-07-10 19:53:14'),('79fbcb01-e5ce-41de-bed1-c54b0052b27b','App\\Notifications\\RequisitionActionRequired','App\\Models\\User',5,'{\"requisition_id\":2363,\"reference_no\":\"REQ-2026-00002\",\"title\":\"Table\",\"status\":\"submitted_to_procurement\",\"status_label\":\"Submitted To Procurement\",\"action\":\"review quotes and issue the Purchase Order\",\"variant\":\"info\",\"url\":\"http:\\/\\/localhost\\/requisitions\\/2363\"}',NULL,'2026-07-10 04:56:23','2026-07-10 04:56:23'),('93fc0a8d-e818-473c-80ce-4394280e8994','App\\Notifications\\RequisitionActionRequired','App\\Models\\User',3,'{\"requisition_id\":2363,\"reference_no\":\"REQ-2026-00002\",\"title\":\"Table\",\"status\":\"submitted\",\"status_label\":\"Submitted\",\"action\":\"review and approve the requisition\",\"variant\":\"info\",\"url\":\"http:\\/\\/localhost\\/requisitions\\/2363\"}',NULL,'2026-07-10 18:10:07','2026-07-10 18:10:07'),('b58014f3-ffc9-4583-85cd-4f1b3a52d005','App\\Notifications\\RequisitionActionRequired','App\\Models\\User',4,'{\"requisition_id\":595,\"reference_no\":\"REQ-2026-00001\",\"title\":\"Office Supplies\",\"status\":\"invoice_received\",\"status_label\":\"Invoice Received\",\"action\":\"verify the invoice against the PO and delivery\",\"variant\":\"info\",\"url\":\"http:\\/\\/localhost\\/requisitions\\/595\"}',NULL,'2026-07-09 23:04:17','2026-07-09 23:04:17'),('c033cf7a-132e-49eb-b09c-32a9d717ea2f','App\\Notifications\\RequisitionActionRequired','App\\Models\\User',4,'{\"requisition_id\":2363,\"reference_no\":\"REQ-2026-00002\",\"title\":\"Table\",\"status\":\"pal_received\",\"status_label\":\"Pal Received\",\"action\":\"receive and start processing\",\"variant\":\"info\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/requisitions\\/2363\"}',NULL,'2026-07-10 18:10:24','2026-07-10 18:10:24'),('dbb5f287-f48c-41b6-acda-68d0cff6aac9','App\\Notifications\\RequisitionActionRequired','App\\Models\\User',3,'{\"requisition_id\":595,\"reference_no\":\"REQ-2026-00001\",\"title\":\"Office Supplies\",\"status\":\"submitted\",\"status_label\":\"Submitted\",\"action\":\"review and approve the requisition\",\"variant\":\"info\",\"url\":\"http:\\/\\/localhost\\/requisitions\\/595\"}',NULL,'2026-07-09 23:04:17','2026-07-09 23:04:17');

--
-- Table structure for table `org_units`
--

CREATE TABLE `org_units` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL COMMENT 'portfolio|branch|division|station',
  `name` varchar(150) NOT NULL,
  `code` varchar(30) DEFAULT NULL,
  `area_id` bigint(20) unsigned DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `org_units_code_unique` (`code`),
  KEY `org_units_area_id_foreign` (`area_id`),
  KEY `org_units_type_index` (`type`),
  CONSTRAINT `org_units_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `org_units`
--

INSERT INTO `org_units` VALUES (1,'portfolio','Operations Portfolio','OU-0001',1,1,'2026-06-17 05:01:02','2026-06-17 05:01:02'),(2,'branch','Corporate & Special Services Branch','OU-0002',1,1,'2026-06-17 05:01:02','2026-06-17 05:01:02'),(3,'division','Kingston Central Division','OU-0003',1,1,'2026-06-17 05:01:02','2026-06-17 05:01:02'),(4,'division','St. James Division','OU-0004',2,1,'2026-06-17 05:01:02','2026-06-17 05:01:02'),(5,'station','Half Way Tree Station','OU-0005',1,1,'2026-06-17 05:01:02','2026-06-17 05:01:02'),(6,'station','Montego Bay Station','OU-0006',2,1,'2026-06-17 05:01:02','2026-06-17 05:01:02');

--
-- Table structure for table `pal_offices`
--

CREATE TABLE `pal_offices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `code` varchar(30) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `preparer_threshold` decimal(15,2) NOT NULL DEFAULT 100000.00,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pal_offices_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pal_offices`
--

INSERT INTO `pal_offices` VALUES (1,'Kingston PAL Office','PAL-KGN','101 Old Hope Rd, Kingston 6',100000.00,1,'2026-06-16 05:09:33','2026-06-16 05:09:33'),(2,'Western PAL Office','PAL-WST','40 Barnett St, Montego Bay',100000.00,1,'2026-06-16 05:09:33','2026-06-16 05:09:33');

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `payment_reference` varchar(40) NOT NULL,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `requisition_id` bigint(20) unsigned NOT NULL,
  `supplier_id` bigint(20) unsigned NOT NULL,
  `processed_by` bigint(20) unsigned NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `currency` char(3) NOT NULL DEFAULT 'JMD',
  `method` varchar(20) NOT NULL COMMENT 'bank_transfer|cheque|cash|other',
  `transaction_ref` varchar(80) DEFAULT NULL COMMENT 'bank/cheque no.',
  `payment_date` date NOT NULL,
  `status` varchar(15) NOT NULL DEFAULT 'processing' COMMENT 'processing|confirmed|received|failed',
  `confirmed_by` bigint(20) unsigned DEFAULT NULL,
  `confirmed_at` datetime DEFAULT NULL,
  `receipt_confirmed_at` datetime DEFAULT NULL COMMENT 'supplier, step 23',
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payments_payment_reference_unique` (`payment_reference`),
  KEY `payments_invoice_id_foreign` (`invoice_id`),
  KEY `payments_requisition_id_foreign` (`requisition_id`),
  KEY `payments_supplier_id_foreign` (`supplier_id`),
  KEY `payments_processed_by_foreign` (`processed_by`),
  KEY `payments_confirmed_by_foreign` (`confirmed_by`),
  KEY `payments_status_index` (`status`),
  CONSTRAINT `payments_confirmed_by_foreign` FOREIGN KEY (`confirmed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `payments_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`),
  CONSTRAINT `payments_processed_by_foreign` FOREIGN KEY (`processed_by`) REFERENCES `users` (`id`),
  CONSTRAINT `payments_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`),
  CONSTRAINT `payments_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=262 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` VALUES (261,'PAY-2026-00001',445,2363,2,7,275.00,'JMD','bank_transfer','6755','2026-06-19','received',7,'2026-06-19 16:41:15','2026-06-19 16:41:17',NULL,'2026-06-19 21:41:12','2026-06-19 21:41:17');

--
-- Table structure for table `procurement_methods`
--

CREATE TABLE `procurement_methods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL COMMENT 'e.g. PM-RFQ',
  `name` varchar(120) NOT NULL,
  `short_name` varchar(30) DEFAULT NULL COMMENT 'e.g. RFQ, NCB',
  `description` text DEFAULT NULL,
  `min_quotes` tinyint(3) unsigned NOT NULL DEFAULT 1 COMMENT '0 = open/advertised, no fixed count',
  `requires_justification` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'e.g. sole source / emergency',
  `threshold_min` decimal(15,2) DEFAULT NULL COMMENT 'indicative GOJ value band (JMD)',
  `threshold_max` decimal(15,2) DEFAULT NULL,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `procurement_methods_code_unique` (`code`),
  KEY `procurement_methods_is_active_index` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `procurement_methods`
--

INSERT INTO `procurement_methods` VALUES (1,'PM-RFQ','Request for Quotation','RFQ','Low-value purchases — obtain written quotations from at least three suppliers.',3,0,NULL,NULL,1,1,'2026-06-19 19:43:15','2026-06-19 19:43:15'),(2,'PM-LT','Limited / Restricted Tender','LT','Invite a shortlist of pre-qualified suppliers (minimum three) to bid.',3,0,NULL,NULL,2,1,'2026-06-19 19:43:15','2026-06-19 19:43:15'),(3,'PM-NCB','Open Tender — National Competitive Bidding','NCB','Publicly advertised competitive tender open to all eligible local suppliers.',0,0,NULL,NULL,3,1,'2026-06-19 19:43:15','2026-06-19 19:43:15'),(4,'PM-ICB','International Competitive Bidding','ICB','Publicly advertised tender open internationally for high-value procurements.',0,0,NULL,NULL,4,1,'2026-06-19 19:43:15','2026-06-19 19:43:15'),(5,'PM-RFP','Request for Proposal','RFP','Proposal-based selection for complex requirements / consulting services.',0,0,NULL,NULL,5,1,'2026-06-19 19:43:15','2026-06-19 19:43:15'),(6,'PM-FA','Framework Agreement','FA','Draw down against a pre-established framework / standing arrangement.',1,0,NULL,NULL,6,1,'2026-06-19 19:43:15','2026-06-19 19:43:15'),(7,'PM-SS','Sole Source / Direct Contracting','Sole','Single supplier (proprietary / no alternative). Requires written justification.',1,1,NULL,NULL,7,1,'2026-06-19 19:43:15','2026-06-19 19:43:15'),(8,'PM-EMG','Emergency Procurement','Emerg.','Urgent procurement to address an emergency. Requires written justification.',1,1,NULL,NULL,8,1,'2026-06-19 19:43:15','2026-06-19 19:43:15');

--
-- Table structure for table `purchase_order_items`
--

CREATE TABLE `purchase_order_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_order_id` bigint(20) unsigned NOT NULL,
  `requisition_item_id` bigint(20) unsigned DEFAULT NULL,
  `item_id` bigint(20) unsigned DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `quantity` decimal(15,2) NOT NULL COMMENT 'ordered qty',
  `uom_id` bigint(20) unsigned NOT NULL,
  `unit_price` decimal(15,2) NOT NULL,
  `tax_rate` decimal(5,2) DEFAULT NULL COMMENT 'percent',
  `line_total` decimal(15,2) NOT NULL,
  `quantity_received` decimal(15,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `purchase_order_items_purchase_order_id_foreign` (`purchase_order_id`),
  KEY `purchase_order_items_requisition_item_id_foreign` (`requisition_item_id`),
  KEY `purchase_order_items_item_id_foreign` (`item_id`),
  KEY `purchase_order_items_uom_id_foreign` (`uom_id`),
  CONSTRAINT `purchase_order_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE SET NULL,
  CONSTRAINT `purchase_order_items_purchase_order_id_foreign` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `purchase_order_items_requisition_item_id_foreign` FOREIGN KEY (`requisition_item_id`) REFERENCES `requisition_items` (`id`) ON DELETE SET NULL,
  CONSTRAINT `purchase_order_items_uom_id_foreign` FOREIGN KEY (`uom_id`) REFERENCES `units_of_measure` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1174 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_order_items`
--

INSERT INTO `purchase_order_items` VALUES (370,370,634,12,'Chairs - Office Standard',4.00,1,1750.00,NULL,7000.00,0.00,'2026-06-17 04:01:35','2026-06-17 07:12:44'),(829,829,634,12,'Chairs - Office Standard',4.00,1,1750.00,NULL,7000.00,4.00,'2026-06-17 07:33:07','2026-06-17 08:03:39'),(1172,1172,2466,43,'Table',5.00,1,35.71,NULL,178.57,5.00,'2026-06-19 21:21:31','2026-06-19 21:34:45'),(1173,1172,2467,12,'Chairs - Office Standard',1.00,1,71.43,NULL,71.43,1.00,'2026-06-19 21:21:31','2026-06-19 21:34:45');

--
-- Table structure for table `purchase_orders`
--

CREATE TABLE `purchase_orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `po_number` varchar(40) NOT NULL COMMENT 'e.g. PO-2026-00045',
  `requisition_id` bigint(20) unsigned NOT NULL,
  `supplier_id` bigint(20) unsigned NOT NULL,
  `quote_id` bigint(20) unsigned DEFAULT NULL,
  `issued_by` bigint(20) unsigned NOT NULL,
  `issue_date` date NOT NULL,
  `expected_delivery_date` date DEFAULT NULL,
  `currency` char(3) NOT NULL DEFAULT 'JMD',
  `subtotal` decimal(15,2) NOT NULL DEFAULT 0.00,
  `tax_total` decimal(15,2) NOT NULL DEFAULT 0.00,
  `total` decimal(15,2) NOT NULL DEFAULT 0.00,
  `delivery_address` varchar(255) DEFAULT NULL,
  `terms` text DEFAULT NULL,
  `attachment_path` varchar(255) DEFAULT NULL,
  `prepared_signature` longtext DEFAULT NULL,
  `prepared_by_name` varchar(150) DEFAULT NULL,
  `prepared_by_designation` varchar(150) DEFAULT NULL,
  `authorized_signature` longtext DEFAULT NULL,
  `authorized_by_name` varchar(150) DEFAULT NULL,
  `authorized_by_designation` varchar(150) DEFAULT NULL,
  `status` varchar(25) NOT NULL DEFAULT 'issued' COMMENT 'issued|sent|acknowledged|partially_received|received|closed|cancelled',
  `sent_to_supplier_at` datetime DEFAULT NULL,
  `acknowledged_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `purchase_orders_po_number_unique` (`po_number`),
  KEY `purchase_orders_requisition_id_foreign` (`requisition_id`),
  KEY `purchase_orders_supplier_id_foreign` (`supplier_id`),
  KEY `purchase_orders_quote_id_foreign` (`quote_id`),
  KEY `purchase_orders_issued_by_foreign` (`issued_by`),
  KEY `purchase_orders_status_index` (`status`),
  CONSTRAINT `purchase_orders_issued_by_foreign` FOREIGN KEY (`issued_by`) REFERENCES `users` (`id`),
  CONSTRAINT `purchase_orders_quote_id_foreign` FOREIGN KEY (`quote_id`) REFERENCES `quotes` (`id`) ON DELETE SET NULL,
  CONSTRAINT `purchase_orders_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`),
  CONSTRAINT `purchase_orders_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1173 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_orders`
--

INSERT INTO `purchase_orders` VALUES (370,'PO-2026-00001',595,8,530,5,'2026-06-16','2026-06-17','JMD',7000.00,78.00,7078.00,'5 Harbour St, Kingston','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'cancelled','2026-06-17 00:35:48','2026-06-17 00:57:09','2026-06-17 04:01:35','2026-06-17 07:44:02'),(829,'PO-2026-00002',595,8,530,5,'2026-06-17','2026-06-17','JMD',7000.00,78.00,7078.00,'5 Harbour St, Kingston','tst',NULL,'data:image/png;base64,[BLOB]','Paula PAL','PAL','data:image/png;base64,[BLOB]','Pierre Procure','Procurement Officer','received','2026-06-17 02:34:03','2026-06-17 02:34:12','2026-06-17 07:33:07','2026-06-17 08:03:39'),(1172,'PO-2026-00003',2363,2,1825,5,'2026-06-19',NULL,'JMD',250.00,25.00,275.00,'12 Constant Spring Rd, Kingston 10','test',NULL,'data:image/png;base64,[BLOB]','Paula PAL','PAL','data:image/png;base64,[BLOB]','Pierre Procure','Procurement Officer','received','2026-06-19 16:28:07','2026-06-19 16:31:19','2026-06-19 21:21:31','2026-06-19 21:34:45');

--
-- Table structure for table `quote_analyses`
--

CREATE TABLE `quote_analyses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `requisition_id` bigint(20) unsigned NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'pending' COMMENT 'pending|processing|complete|failed',
  `recommended_quote_id` bigint(20) unsigned DEFAULT NULL,
  `summary` text DEFAULT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`data`)),
  `generated_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `quote_analyses_requisition_id_unique` (`requisition_id`),
  KEY `quote_analyses_recommended_quote_id_foreign` (`recommended_quote_id`),
  CONSTRAINT `quote_analyses_recommended_quote_id_foreign` FOREIGN KEY (`recommended_quote_id`) REFERENCES `quotes` (`id`) ON DELETE SET NULL,
  CONSTRAINT `quote_analyses_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quote_analyses`
--

INSERT INTO `quote_analyses` VALUES (8,595,'complete',530,'Compared 2 quotes. Lowest price: jats at JMD 7,078.00; highest JMD 9,900.00 (spread JMD 2,822.00, 28.5%). Recommended best value: jats (JMD 7,078.00) — lowest price, supporting document attached. Based on price plus internal quality signals (supplier rating, quote validity, supporting document).','{\"method\":\"Local comparative analysis (cost + internal quality signals)\",\"count\":2,\"currency\":\"JMD\",\"lowest\":7078,\"highest\":9900,\"average\":8489,\"savings\":2822,\"quotes\":[{\"quote_id\":530,\"supplier\":\"jats\",\"currency\":\"JMD\",\"total\":7078,\"rating\":null,\"has_document\":true,\"cost_score\":1,\"quality_score\":0.7199999999999999733546474089962430298328399658203125,\"value_score\":0.87399999999999999911182158029987476766109466552734375,\"flags\":[\"lowest price\"],\"rank\":1},{\"quote_id\":529,\"supplier\":\"jer\",\"currency\":\"JMD\",\"total\":9900,\"rating\":null,\"has_document\":true,\"cost_score\":0,\"quality_score\":0.7199999999999999733546474089962430298328399658203125,\"value_score\":0.324000000000000010214051826551440171897411346435546875,\"flags\":[],\"rank\":2}]}','2026-06-16 04:27:11','2026-06-16 09:26:56','2026-06-16 09:27:11'),(109,2363,'pending',1825,'Compared 2 quotes. Lowest price: TechPoint Solutions at JMD 275.00; highest JMD 770.00 (spread JMD 495.00, 64.3%). Recommended best value: TechPoint Solutions (JMD 275.00) — lowest price, supporting document attached. Based on price plus internal quality signals (supplier rating, quote validity, supporting document).','{\"method\":\"Local comparative analysis (cost + internal quality signals)\",\"count\":2,\"currency\":\"JMD\",\"lowest\":275,\"highest\":770,\"average\":522.5,\"savings\":495,\"quotes\":[{\"quote_id\":1825,\"supplier\":\"TechPoint Solutions\",\"currency\":\"JMD\",\"total\":275,\"rating\":null,\"has_document\":true,\"cost_score\":1,\"quality_score\":0.7199999999999999733546474089962430298328399658203125,\"value_score\":0.87399999999999999911182158029987476766109466552734375,\"flags\":[\"lowest price\"],\"rank\":1},{\"quote_id\":1826,\"supplier\":\"jer\",\"currency\":\"JMD\",\"total\":770,\"rating\":null,\"has_document\":true,\"cost_score\":0,\"quality_score\":0.7199999999999999733546474089962430298328399658203125,\"value_score\":0.324000000000000010214051826551440171897411346435546875,\"flags\":[],\"rank\":2}]}','2026-06-19 16:18:33','2026-06-19 21:18:20','2026-06-19 21:18:49');

--
-- Table structure for table `quote_items`
--

CREATE TABLE `quote_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quote_id` bigint(20) unsigned NOT NULL,
  `requisition_item_id` bigint(20) unsigned DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `unit_price` decimal(15,2) NOT NULL,
  `line_total` decimal(15,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quote_items_quote_id_foreign` (`quote_id`),
  KEY `quote_items_requisition_item_id_foreign` (`requisition_item_id`),
  CONSTRAINT `quote_items_quote_id_foreign` FOREIGN KEY (`quote_id`) REFERENCES `quotes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quote_items_requisition_item_id_foreign` FOREIGN KEY (`requisition_item_id`) REFERENCES `requisition_items` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quote_items`
--


--
-- Table structure for table `quotes`
--

CREATE TABLE `quotes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `requisition_id` bigint(20) unsigned NOT NULL,
  `supplier_id` bigint(20) unsigned NOT NULL,
  `quote_reference` varchar(60) DEFAULT NULL COMMENT 'supplier''s quote no.',
  `quote_date` date NOT NULL,
  `valid_until` date DEFAULT NULL,
  `currency` char(3) NOT NULL DEFAULT 'JMD',
  `subtotal` decimal(15,2) NOT NULL DEFAULT 0.00,
  `tax_total` decimal(15,2) NOT NULL DEFAULT 0.00,
  `total` decimal(15,2) NOT NULL DEFAULT 0.00,
  `is_selected` tinyint(1) NOT NULL DEFAULT 0,
  `attachment_path` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quotes_requisition_id_foreign` (`requisition_id`),
  KEY `quotes_supplier_id_foreign` (`supplier_id`),
  CONSTRAINT `quotes_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `quotes_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1827 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quotes`
--

INSERT INTO `quotes` VALUES (529,595,7,'j89','2026-06-16','2026-06-17','JMD',9000.00,900.00,9900.00,0,'quotes/zyNzTs3iY51KAfj1HancN1HuaKRbtcKNho7NNvit.pdf','test','2026-06-16 09:24:13','2026-06-16 09:26:56'),(530,595,8,'test','2026-06-16','2026-06-25','JMD',7000.00,78.00,7078.00,1,'quotes/SUkcJbjQrEXPwJgJfZxq9Cze07gNxl43GYUqbEBk.pdf','test','2026-06-16 09:26:56','2026-06-16 09:26:56'),(1825,2363,2,'123','2026-06-19','2026-06-21','JMD',250.00,25.00,275.00,1,'quotes/tpfgfG9xtZpFEbRz2IfQA8SKiKN2sNiFfqpOjwZz.pdf',NULL,'2026-06-19 21:17:46','2026-06-19 21:18:49'),(1826,2363,7,'321','2026-06-19','2026-06-20','JMD',700.00,70.00,770.00,0,'quotes/GxNaKd4UCt9lz1pxgDQSANxsznKXTgKRaeoseIoR.pdf','test','2026-06-19 21:18:20','2026-06-19 21:18:49');

--
-- Table structure for table `reason_codes`
--

CREATE TABLE `reason_codes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `label` varchar(200) NOT NULL,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reason_codes_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reason_codes`
--

INSERT INTO `reason_codes` VALUES (1,'R01','Incomplete requisition',1,1,'2026-07-09 21:44:54','2026-07-09 21:44:54'),(2,'R02','Insufficient justification',2,1,'2026-07-09 21:44:54','2026-07-09 21:44:54'),(3,'R03','Incorrect item/category',3,1,'2026-07-09 21:44:54','2026-07-09 21:44:54'),(4,'R04','Excessive quantity',4,1,'2026-07-09 21:44:54','2026-07-09 21:44:54'),(5,'R05','Budget unavailable',5,1,'2026-07-09 21:44:54','2026-07-09 21:44:54'),(6,'R06','Missing supporting documents',6,1,'2026-07-09 21:44:54','2026-07-09 21:44:54'),(7,'R07','Duplicate request',7,1,'2026-07-09 21:44:54','2026-07-09 21:44:54'),(8,'R08','Supplier or quotation issue',8,1,'2026-07-09 21:44:54','2026-07-09 21:44:54'),(9,'R09','Procurement compliance issue',9,1,'2026-07-09 21:44:54','2026-07-09 21:44:54'),(10,'R10','Specification or delivery clarification needed',10,1,'2026-07-09 21:44:54','2026-07-09 21:44:54');

--
-- Table structure for table `requisition_approvals`
--

CREATE TABLE `requisition_approvals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `requisition_id` bigint(20) unsigned NOT NULL,
  `approver_id` bigint(20) unsigned NOT NULL,
  `level` varchar(20) NOT NULL COMMENT 'area|procurement',
  `decision` varchar(20) NOT NULL COMMENT 'approved|rejected|returned',
  `reason_code` varchar(10) DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `signature` longtext DEFAULT NULL,
  `signed_name` varchar(150) DEFAULT NULL,
  `designation` varchar(150) DEFAULT NULL,
  `decided_at` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `requisition_approvals_requisition_id_foreign` (`requisition_id`),
  KEY `requisition_approvals_approver_id_foreign` (`approver_id`),
  CONSTRAINT `requisition_approvals_approver_id_foreign` FOREIGN KEY (`approver_id`) REFERENCES `users` (`id`),
  CONSTRAINT `requisition_approvals_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4526 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `requisition_approvals`
--

INSERT INTO `requisition_approvals` VALUES (988,595,3,'area','approved',NULL,NULL,'data:image/png;base64,[BLOB]','Aaron Area','Area','2026-06-16 03:35:03','2026-06-16 08:35:03','2026-06-16 08:35:03'),(1237,595,4,'pal','approved',NULL,'good','data:image/png;base64,[BLOB]','Paula PAL','PAL','2026-06-16 22:59:23','2026-06-17 03:59:23','2026-06-17 03:59:23'),(1238,595,5,'procurement','approved',NULL,'test',NULL,NULL,NULL,'2026-06-16 23:01:35','2026-06-17 04:01:35','2026-06-17 04:01:35'),(3137,595,4,'pal','approved',NULL,NULL,'data:image/png;base64,[BLOB]','Paula PAL','PAL','2026-06-17 02:30:56','2026-06-17 07:30:56','2026-06-17 07:30:56'),(3138,595,5,'procurement','approved',NULL,'test',NULL,NULL,NULL,'2026-06-17 02:33:07','2026-06-17 07:33:07','2026-06-17 07:33:07'),(4522,2363,3,'area','approved',NULL,'made','data:image/png;base64,[BLOB]','Aaron Area','Area','2026-06-19 16:06:29','2026-06-19 21:06:29','2026-06-19 21:06:29'),(4523,2363,4,'pal','approved',NULL,'lowest win','data:image/png;base64,[BLOB]','Paula PAL','PAL','2026-06-19 16:19:35','2026-06-19 21:19:35','2026-06-19 21:19:35'),(4524,2363,5,'procurement','approved',NULL,'comment',NULL,NULL,NULL,'2026-06-19 16:21:31','2026-06-19 21:21:31','2026-06-19 21:21:31'),(4525,2363,3,'area','approved',NULL,'EMERGENCY FAST-TRACK — Operational emergency — safety-critical equipment needed for active deployment.','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAQAAAC1HAwCAAAAC0lEQVR42mNk+M9QDwADhgGAWjR9awAAAABJRU5ErkJggg==','Area Officer',NULL,'2026-07-10 13:10:24','2026-07-10 18:10:24','2026-07-10 18:10:24');

--
-- Table structure for table `requisition_items`
--

CREATE TABLE `requisition_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `requisition_id` bigint(20) unsigned NOT NULL,
  `item_id` bigint(20) unsigned DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL COMMENT 'free-text fallback',
  `quantity` decimal(15,2) NOT NULL,
  `uom_id` bigint(20) unsigned NOT NULL,
  `estimated_unit_cost` decimal(15,2) DEFAULT NULL,
  `estimated_line_total` decimal(15,2) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `requisition_items_requisition_id_foreign` (`requisition_id`),
  KEY `requisition_items_item_id_foreign` (`item_id`),
  KEY `requisition_items_uom_id_foreign` (`uom_id`),
  CONSTRAINT `requisition_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE SET NULL,
  CONSTRAINT `requisition_items_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `requisition_items_uom_id_foreign` FOREIGN KEY (`uom_id`) REFERENCES `units_of_measure` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2474 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `requisition_items`
--

INSERT INTO `requisition_items` VALUES (634,595,12,'Chairs - Office Standard',4.00,1,20000.00,80000.00,NULL,'2026-06-16 07:16:34','2026-06-16 07:16:34'),(2466,2363,43,'Table',5.00,1,500.00,2500.00,NULL,'2026-06-19 21:03:52','2026-06-19 21:03:52'),(2467,2363,12,'Chairs - Office Standard',1.00,1,1000.00,1000.00,NULL,'2026-06-19 21:03:52','2026-06-19 21:03:52'),(2472,2364,44,'Map',1.00,1,100.00,100.00,NULL,'2026-07-10 19:53:14','2026-07-10 19:53:14'),(2473,2364,45,'Bucket',1.00,2,0.00,0.00,NULL,'2026-07-10 19:53:14','2026-07-10 19:53:14');

--
-- Table structure for table `requisitions`
--

CREATE TABLE `requisitions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(40) NOT NULL COMMENT 'e.g. REQ-2026-00012',
  `station_id` bigint(20) unsigned NOT NULL,
  `formation_id` bigint(20) unsigned DEFAULT NULL,
  `end_user_id` bigint(20) unsigned DEFAULT NULL,
  `area_id` bigint(20) unsigned NOT NULL,
  `cost_centre_id` bigint(20) unsigned DEFAULT NULL,
  `budget_overridden` tinyint(1) NOT NULL DEFAULT 0,
  `budget_override_reason` varchar(255) DEFAULT NULL,
  `pal_office_id` bigint(20) unsigned DEFAULT NULL,
  `pal_id` bigint(20) unsigned DEFAULT NULL,
  `procurement_id` bigint(20) unsigned DEFAULT NULL,
  `supplier_id` bigint(20) unsigned DEFAULT NULL,
  `procurement_method_id` bigint(20) unsigned DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `title` varchar(200) NOT NULL,
  `description` text DEFAULT NULL,
  `justification` text DEFAULT NULL,
  `procurement_justification` text DEFAULT NULL COMMENT 'required when the method requires justification (sole source / emergency)',
  `priority` varchar(10) NOT NULL DEFAULT 'normal' COMMENT 'low|normal|high|urgent',
  `needed_by_date` date DEFAULT NULL,
  `estimated_total` decimal(15,2) NOT NULL DEFAULT 0.00,
  `status` varchar(40) NOT NULL DEFAULT 'draft' COMMENT 'see DATA_MODEL.md state machine',
  `current_stage` tinyint(3) unsigned NOT NULL DEFAULT 1 COMMENT '1-6',
  `rejection_reason` text DEFAULT NULL,
  `submitted_at` datetime DEFAULT NULL,
  `closed_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `requisitions_reference_no_unique` (`reference_no`),
  KEY `requisitions_station_id_foreign` (`station_id`),
  KEY `requisitions_area_id_foreign` (`area_id`),
  KEY `requisitions_pal_id_foreign` (`pal_id`),
  KEY `requisitions_procurement_id_foreign` (`procurement_id`),
  KEY `requisitions_supplier_id_foreign` (`supplier_id`),
  KEY `requisitions_created_by_foreign` (`created_by`),
  KEY `requisitions_status_index` (`status`),
  KEY `requisitions_current_stage_index` (`current_stage`),
  KEY `requisitions_pal_office_id_foreign` (`pal_office_id`),
  KEY `requisitions_end_user_id_foreign` (`end_user_id`),
  KEY `requisitions_procurement_method_id_foreign` (`procurement_method_id`),
  KEY `requisitions_cost_centre_id_foreign` (`cost_centre_id`),
  KEY `requisitions_formation_id_foreign` (`formation_id`),
  CONSTRAINT `requisitions_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`),
  CONSTRAINT `requisitions_cost_centre_id_foreign` FOREIGN KEY (`cost_centre_id`) REFERENCES `cost_centres` (`id`) ON DELETE SET NULL,
  CONSTRAINT `requisitions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `requisitions_end_user_id_foreign` FOREIGN KEY (`end_user_id`) REFERENCES `org_units` (`id`) ON DELETE SET NULL,
  CONSTRAINT `requisitions_formation_id_foreign` FOREIGN KEY (`formation_id`) REFERENCES `formations` (`id`) ON DELETE SET NULL,
  CONSTRAINT `requisitions_pal_id_foreign` FOREIGN KEY (`pal_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `requisitions_pal_office_id_foreign` FOREIGN KEY (`pal_office_id`) REFERENCES `pal_offices` (`id`) ON DELETE SET NULL,
  CONSTRAINT `requisitions_procurement_id_foreign` FOREIGN KEY (`procurement_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `requisitions_procurement_method_id_foreign` FOREIGN KEY (`procurement_method_id`) REFERENCES `procurement_methods` (`id`) ON DELETE SET NULL,
  CONSTRAINT `requisitions_station_id_foreign` FOREIGN KEY (`station_id`) REFERENCES `stations` (`id`),
  CONSTRAINT `requisitions_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2365 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `requisitions`
--

INSERT INTO `requisitions` VALUES (595,'REQ-2026-00001',2,NULL,NULL,1,NULL,0,NULL,1,4,5,8,NULL,8,'Office Supplies','Request is hereby sought for 4 Office Chairs for use in the Corporate and Special Services Branch','Office chairs has been EOL',NULL,'high','2026-07-12',80000.00,'invoice_received',5,NULL,'2026-06-16 02:16:34',NULL,'2026-06-16 07:16:34','2026-07-10 03:19:41',NULL),(2363,'REQ-2026-00002',1,NULL,5,1,NULL,0,NULL,1,4,5,2,NULL,2,'Table','Details of request','information',NULL,'normal','2026-06-26',3500.00,'closed',1,NULL,'2026-06-19 16:03:52','2026-06-19 16:43:31','2026-06-19 21:03:52','2026-07-10 18:10:41',NULL),(2364,'REQ-2026-00003',1,1223,NULL,1,NULL,0,NULL,1,NULL,NULL,NULL,NULL,2,'Request for Stations Supplies','Maps, Buckets and things needed','Maps Worn out',NULL,'normal','2026-07-31',100.00,'submitted',1,NULL,'2026-07-10 14:53:14',NULL,'2026-07-10 19:51:42','2026-07-10 19:53:14',NULL);

--
-- Table structure for table `sla_targets`
--

CREATE TABLE `sla_targets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `stage` varchar(40) NOT NULL,
  `label` varchar(100) NOT NULL,
  `target_days` smallint(5) unsigned NOT NULL DEFAULT 5,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sla_targets_stage_unique` (`stage`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sla_targets`
--


--
-- Table structure for table `stations`
--

CREATE TABLE `stations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `area_id` bigint(20) unsigned NOT NULL,
  `name` varchar(150) NOT NULL,
  `station_type` varchar(50) DEFAULT NULL COMMENT 'Police Station, Divisional HQ, Depot, …',
  `division` varchar(150) DEFAULT NULL,
  `parish` varchar(80) DEFAULT NULL,
  `code` varchar(30) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `mailing_address` varchar(255) DEFAULT NULL,
  `officer_in_charge` varchar(150) DEFAULT NULL,
  `contact_person` varchar(150) DEFAULT NULL,
  `contact_number` varchar(30) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `cost_centre_id` bigint(20) unsigned DEFAULT NULL,
  `default_approval_route` varchar(150) DEFAULT NULL,
  `delivery_instructions` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stations_code_unique` (`code`),
  KEY `stations_area_id_foreign` (`area_id`),
  KEY `stations_cost_centre_id_foreign` (`cost_centre_id`),
  CONSTRAINT `stations_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `stations_cost_centre_id_foreign` FOREIGN KEY (`cost_centre_id`) REFERENCES `cost_centres` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stations`
--

INSERT INTO `stations` VALUES (1,1,'Half Way Tree Station','police_station','Kingston Central','Kingston','STN-HWT','12 Constant Spring Rd, Kingston 10',NULL,'Insp. Brown',NULL,'876-000-0000',NULL,NULL,NULL,NULL,1,'2026-06-16 03:19:13','2026-07-09 22:32:58'),(2,1,'Downtown Station',NULL,NULL,NULL,'STN-DTN','5 Harbour St, Kingston',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2026-06-16 03:19:13','2026-06-16 03:19:13'),(3,2,'Montego Bay Station',NULL,NULL,NULL,'STN-MBJ','40 Barnett St, Montego Bay',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2026-06-16 03:19:13','2026-06-16 03:19:13');

--
-- Table structure for table `supplier_followups`
--

CREATE TABLE `supplier_followups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `supplier_id` bigint(20) unsigned NOT NULL,
  `requisition_id` bigint(20) unsigned DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `assigned_to` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(200) NOT NULL,
  `notes` text DEFAULT NULL,
  `priority` varchar(10) NOT NULL DEFAULT 'normal' COMMENT 'low|normal|high',
  `due_date` date DEFAULT NULL,
  `status` varchar(12) NOT NULL DEFAULT 'open' COMMENT 'open|done',
  `completed_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `supplier_followups_supplier_id_foreign` (`supplier_id`),
  KEY `supplier_followups_requisition_id_foreign` (`requisition_id`),
  KEY `supplier_followups_created_by_foreign` (`created_by`),
  KEY `supplier_followups_assigned_to_foreign` (`assigned_to`),
  KEY `supplier_followups_status_due_date_index` (`status`,`due_date`),
  CONSTRAINT `supplier_followups_assigned_to_foreign` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `supplier_followups_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `supplier_followups_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`) ON DELETE SET NULL,
  CONSTRAINT `supplier_followups_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `supplier_followups`
--

INSERT INTO `supplier_followups` VALUES (20,2,NULL,4,NULL,'delivery','test','normal',NULL,'done','2026-07-09 14:01:15','2026-06-19 21:45:53','2026-07-09 19:01:15');

--
-- Table structure for table `supplier_ratings`
--

CREATE TABLE `supplier_ratings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `requisition_id` bigint(20) unsigned NOT NULL,
  `supplier_id` bigint(20) unsigned NOT NULL,
  `rated_by` bigint(20) unsigned NOT NULL,
  `quality_rating` tinyint(3) unsigned NOT NULL COMMENT '1-5',
  `timeliness_rating` tinyint(3) unsigned NOT NULL COMMENT '1-5',
  `price_rating` tinyint(3) unsigned NOT NULL COMMENT '1-5',
  `communication_rating` tinyint(3) unsigned NOT NULL COMMENT '1-5',
  `overall_rating` decimal(3,2) NOT NULL COMMENT 'average',
  `comments` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `supplier_ratings_requisition_id_foreign` (`requisition_id`),
  KEY `supplier_ratings_supplier_id_foreign` (`supplier_id`),
  KEY `supplier_ratings_rated_by_foreign` (`rated_by`),
  CONSTRAINT `supplier_ratings_rated_by_foreign` FOREIGN KEY (`rated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `supplier_ratings_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `supplier_ratings_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `supplier_ratings`
--

INSERT INTO `supplier_ratings` VALUES (88,2363,2,4,5,2,3,4,3.50,'tst','2026-06-19 21:42:42','2026-06-19 21:42:42');

--
-- Table structure for table `supplier_surveys`
--

CREATE TABLE `supplier_surveys` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `requisition_id` bigint(20) unsigned DEFAULT NULL,
  `supplier_id` bigint(20) unsigned NOT NULL,
  `sentiment` varchar(10) DEFAULT NULL COMMENT 'up|down',
  `rating` tinyint(3) unsigned DEFAULT NULL COMMENT '1-5',
  `comment` text DEFAULT NULL,
  `status` varchar(12) NOT NULL DEFAULT 'pending' COMMENT 'pending|completed',
  `source` varchar(12) DEFAULT NULL COMMENT 'supplier|pal',
  `submitted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `supplier_surveys_requisition_id_unique` (`requisition_id`),
  KEY `supplier_surveys_supplier_id_foreign` (`supplier_id`),
  KEY `supplier_surveys_status_sentiment_index` (`status`,`sentiment`),
  CONSTRAINT `supplier_surveys_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`) ON DELETE SET NULL,
  CONSTRAINT `supplier_surveys_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `supplier_surveys`
--

INSERT INTO `supplier_surveys` VALUES (191,595,8,NULL,NULL,NULL,'pending',NULL,NULL,'2026-06-19 20:55:17','2026-06-19 20:55:17'),(192,2363,2,'up',5,NULL,'completed','supplier','2026-06-19 16:43:11','2026-06-19 21:38:09','2026-06-19 21:43:11');

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `trading_name` varchar(200) DEFAULT NULL,
  `supplier_type` text DEFAULT NULL,
  `code` varchar(30) NOT NULL,
  `contact_name` varchar(150) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `tax_id` varchar(50) DEFAULT NULL COMMENT 'TRN / tax registration',
  `business_reg_no` varchar(60) DEFAULT NULL,
  `payment_terms` varchar(100) DEFAULT NULL COMMENT 'e.g. Net 30',
  `bank_name` varchar(150) DEFAULT NULL,
  `bank_account` varchar(50) DEFAULT NULL,
  `bank_branch` varchar(150) DEFAULT NULL,
  `tax_compliance_status` varchar(20) NOT NULL DEFAULT 'unknown' COMMENT 'compliant|non_compliant|unknown',
  `compliance_expiry_date` date DEFAULT NULL COMMENT 'expiry of statutory docs (TCC etc.)',
  `insurance_status` varchar(20) NOT NULL DEFAULT 'unknown' COMMENT 'valid|expired|not_required|unknown',
  `contract_status` varchar(20) NOT NULL DEFAULT 'none' COMMENT 'none|active|framework',
  `is_blacklisted` tinyint(1) NOT NULL DEFAULT 0,
  `is_suspended` tinyint(1) NOT NULL DEFAULT 0,
  `compliance_note` varchar(255) DEFAULT NULL COMMENT 'blacklist/suspension reason',
  `rating_avg` decimal(3,2) DEFAULT NULL COMMENT 'denormalized from supplier_ratings',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `suppliers_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` VALUES (1,'Island Office Supplies Ltd',NULL,NULL,'SUP-0001','Marsha Brown','sales@islandoffice.jm','876-555-0101','22 Trade Way, Kingston 11','001-234-567',NULL,'Net 30','NCB','1234567890',NULL,'unknown',NULL,'unknown','none',0,0,NULL,4.00,1,'2026-06-16 03:19:13','2026-06-16 06:04:05',NULL),(2,'TechPoint Solutions',NULL,NULL,'SUP-0002','Andre Clarke','orders@techpoint.jm','876-555-0102','8 Technology Dr, Kingston 5','002-345-678',NULL,'Net 45','Scotiabank','2345678901',NULL,'unknown',NULL,'unknown','none',0,0,NULL,5.00,1,'2026-06-16 03:19:13','2026-06-19 21:43:11',NULL),(3,'CleanPro Facilities Services',NULL,NULL,'SUP-0003','Keisha Reid','info@cleanpro.jm','876-555-0103','15 Industrial Tce, Montego Bay','003-456-789',NULL,'Net 30','NCB','3456789012',NULL,'unknown',NULL,'unknown','none',0,0,NULL,NULL,1,'2026-06-16 03:19:13','2026-06-16 03:19:13',NULL),(7,'jer',NULL,NULL,'SUP-0004','jer','jerome@pal.test','8769979189','home',NULL,NULL,'1 month',NULL,NULL,NULL,'unknown',NULL,'unknown','none',0,0,NULL,NULL,1,'2026-06-16 09:23:26','2026-06-16 09:23:26',NULL),(8,'jats',NULL,NULL,'SUP-0005','test','test@pal.test','18769979189','test','119',NULL,'1 month',NULL,NULL,NULL,'unknown',NULL,'unknown','none',0,0,NULL,NULL,1,'2026-06-16 09:26:27','2026-07-10 04:56:36',NULL);

--
-- Table structure for table `units_of_measure`
--

CREATE TABLE `units_of_measure` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `abbreviation` varchar(10) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `units_of_measure`
--

INSERT INTO `units_of_measure` VALUES (1,'Each','ea','2026-06-16 03:19:13','2026-06-16 03:19:13'),(2,'Box','box','2026-06-16 03:19:13','2026-06-16 03:19:13'),(3,'Pack','pk','2026-06-16 03:19:13','2026-06-16 03:19:13'),(4,'Carton','ctn','2026-06-16 03:19:13','2026-06-16 03:19:13'),(5,'Dozen','dz','2026-06-16 03:19:13','2026-06-16 03:19:13'),(6,'Ream','rm','2026-06-16 03:19:13','2026-06-16 03:19:13'),(7,'Litre','L','2026-06-16 03:19:13','2026-06-16 03:19:13'),(8,'Kilogram','kg','2026-06-16 03:19:13','2026-06-16 03:19:13'),(9,'Metre','m','2026-06-16 03:19:13','2026-06-16 03:19:13'),(10,'Hour','hr','2026-06-16 03:19:13','2026-06-16 03:19:13'),(11,'Service','svc','2026-06-16 03:19:13','2026-06-16 03:19:13');

--
-- Table structure for table `workflow_logs`
--

CREATE TABLE `workflow_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `requisition_id` bigint(20) unsigned NOT NULL,
  `step_number` varchar(5) NOT NULL COMMENT '1, 1A, 7A, 14A ... matches diagram',
  `stage` tinyint(3) unsigned NOT NULL COMMENT '1-6',
  `actor_role` varchar(30) NOT NULL COMMENT 'station|area|pal|procurement|supplier|budget_finance',
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `action` varchar(150) NOT NULL,
  `from_status` varchar(40) DEFAULT NULL,
  `to_status` varchar(40) DEFAULT NULL,
  `reason_code` varchar(10) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `workflow_logs_user_id_foreign` (`user_id`),
  KEY `workflow_logs_requisition_id_created_at_index` (`requisition_id`,`created_at`),
  CONSTRAINT `workflow_logs_requisition_id_foreign` FOREIGN KEY (`requisition_id`) REFERENCES `requisitions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `workflow_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=20573 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `workflow_logs`
--

INSERT INTO `workflow_logs` VALUES (5184,595,'1',1,'station',8,'Created and submitted requisition',NULL,'submitted',NULL,NULL,'2026-06-16 02:16:34'),(5899,595,'2',1,'area',3,'Area approved requisition','submitted','pal_received',NULL,NULL,'2026-06-16 03:35:03'),(5900,595,'4',2,'pal',4,'PAL received and began validating the request','pal_received','pal_processing',NULL,NULL,'2026-06-16 03:37:40'),(7021,595,'5',2,'pal',4,'Recorded quote from jer (JMD 9,900.00)',NULL,'pal_processing',NULL,NULL,'2026-06-16 04:24:13'),(7022,595,'5',2,'pal',4,'Recorded quote from jats (JMD 7,078.00)',NULL,'pal_processing',NULL,NULL,'2026-06-16 04:26:56'),(7023,595,'6',2,'pal',4,'Validated and submitted request to Procurement','pal_processing','submitted_to_procurement',NULL,NULL,'2026-06-16 22:59:23'),(7024,595,'7',3,'procurement',5,'Procurement reviewed and approved the submission','submitted_to_procurement','po_issued',NULL,'test','2026-06-16 23:01:35'),(7025,595,'8',3,'procurement',5,'Issued Purchase Order PO-2026-00001',NULL,'po_issued',NULL,NULL,'2026-06-16 23:01:35'),(9126,595,'9',3,'pal',4,'Received Purchase Order PO-2026-00001 from Procurement','po_issued','po_sent',NULL,NULL,'2026-06-17 00:35:49'),(9127,595,'10',3,'pal',4,'Sent PO PO-2026-00001 and confirmed order with supplier',NULL,'po_sent',NULL,NULL,'2026-06-17 00:35:49'),(10016,595,'11',4,'supplier',4,'Supplier received and acknowledged the Purchase Order','po_sent','awaiting_delivery',NULL,NULL,'2026-06-17 00:57:09'),(12020,595,'12',4,'supplier',4,'Supplier prepared the goods/services','awaiting_delivery',NULL,NULL,NULL,'2026-06-17 01:47:51'),(12021,595,'13',4,'supplier',4,'Delivered against PO (GRN-2026-00001)',NULL,'delivered',NULL,'1 foot broken','2026-06-17 01:47:51'),(15012,595,'R3',2,'pal',4,'Returned to PAL Processing for correction','delivered','pal_processing',NULL,'test','2026-06-17 02:30:39'),(15013,595,'6',2,'pal',4,'Validated and submitted request to Procurement','pal_processing','submitted_to_procurement',NULL,NULL,'2026-06-17 02:30:56'),(15014,595,'7',3,'procurement',5,'Procurement reviewed and approved the submission','submitted_to_procurement','po_issued',NULL,'test','2026-06-17 02:33:07'),(15015,595,'8',3,'procurement',5,'Issued Purchase Order PO-2026-00002',NULL,'po_issued',NULL,NULL,'2026-06-17 02:33:07'),(15016,595,'9',3,'pal',4,'Received Purchase Order PO-2026-00002 from Procurement','po_issued','po_sent',NULL,NULL,'2026-06-17 02:34:03'),(15017,595,'10',3,'pal',4,'Sent PO PO-2026-00002 and confirmed order with supplier',NULL,'po_sent',NULL,NULL,'2026-06-17 02:34:03'),(15018,595,'11',4,'supplier',4,'Supplier received and acknowledged the Purchase Order','po_sent','awaiting_delivery',NULL,NULL,'2026-06-17 02:34:12'),(15019,595,'12',4,'supplier',4,'Supplier prepared the goods/services','awaiting_delivery',NULL,NULL,NULL,'2026-06-17 02:35:00'),(15020,595,'13',4,'supplier',4,'Delivered against PO (GRN-2026-00002)',NULL,'delivered',NULL,NULL,'2026-06-17 02:35:00'),(17431,595,'14',4,'pal',4,'Delivery inspected and accepted','delivered','delivered',NULL,NULL,'2026-06-17 03:03:07'),(17432,595,'15',4,'pal',4,'Confirmed delivery GRN-2026-00002 against the PO','delivered','delivery_confirmed',NULL,NULL,'2026-06-17 03:03:39'),(20542,595,'16',5,'supplier',4,'Submitted invoice INV-2026-00001 to PAL','delivery_confirmed','invoice_pending',NULL,NULL,'2026-06-19 15:55:12'),(20543,595,'17',5,'pal',4,'PAL received the supplier invoice','invoice_pending','invoice_received',NULL,NULL,'2026-06-19 15:55:17'),(20544,2363,'1',1,'station',2,'Created and submitted requisition',NULL,'submitted',NULL,NULL,'2026-06-19 16:03:52'),(20545,2363,'2',1,'area',3,'Area approved requisition','submitted','pal_received',NULL,'made','2026-06-19 16:06:29'),(20546,2363,'4',2,'pal',4,'PAL received and began validating the request','pal_received','pal_processing',NULL,NULL,'2026-06-19 16:14:11'),(20547,2363,'5',2,'pal',4,'Recorded quote from TechPoint Solutions (JMD 275.00)',NULL,'pal_processing',NULL,NULL,'2026-06-19 16:17:46'),(20548,2363,'5',2,'pal',4,'Recorded quote from jer (JMD 770.00)',NULL,'pal_processing',NULL,NULL,'2026-06-19 16:18:20'),(20549,2363,'6',2,'pal',4,'Validated and submitted request to Procurement','pal_processing','submitted_to_procurement',NULL,NULL,'2026-06-19 16:19:35'),(20550,2363,'7',3,'procurement',5,'Procurement reviewed and approved the submission','submitted_to_procurement','po_issued',NULL,'comment','2026-06-19 16:21:32'),(20551,2363,'8',3,'procurement',5,'Issued Purchase Order PO-2026-00003',NULL,'po_issued',NULL,NULL,'2026-06-19 16:21:32'),(20552,2363,'9',3,'pal',4,'Received Purchase Order PO-2026-00003 from Procurement','po_issued','po_sent',NULL,NULL,'2026-06-19 16:28:07'),(20553,2363,'10',3,'pal',4,'Sent PO PO-2026-00003 and confirmed order with supplier',NULL,'po_sent',NULL,NULL,'2026-06-19 16:28:07'),(20554,2363,'11',4,'supplier',4,'Supplier received and acknowledged the Purchase Order','po_sent','awaiting_delivery',NULL,NULL,'2026-06-19 16:31:19'),(20555,2363,'12',4,'supplier',4,'Supplier prepared the goods/services','awaiting_delivery',NULL,NULL,NULL,'2026-06-19 16:32:55'),(20556,2363,'13',4,'supplier',4,'Delivered against PO (GRN-2026-00003)',NULL,'delivered',NULL,NULL,'2026-06-19 16:32:55'),(20557,2363,'14',4,'pal',4,'Delivery inspected and accepted on receipt','delivered','delivered',NULL,NULL,'2026-06-19 16:32:55'),(20558,2363,'15',4,'pal',4,'Confirmed delivery GRN-2026-00003 against the PO','delivered','delivery_confirmed',NULL,NULL,'2026-06-19 16:34:45'),(20559,2363,'16',5,'supplier',4,'Submitted invoice INV-2026-00002 to PAL','delivery_confirmed','invoice_pending',NULL,NULL,'2026-06-19 16:36:34'),(20560,2363,'17',5,'pal',4,'PAL received the supplier invoice','invoice_pending','invoice_received',NULL,NULL,'2026-06-19 16:38:09'),(20561,2363,'18',5,'pal',4,'Invoice verified against PO and delivery (matched)','invoice_received','invoice_verified',NULL,NULL,'2026-06-19 16:38:25'),(20562,2363,'19',5,'procurement',5,'Procurement received the verified invoice','invoice_verified','with_finance',NULL,NULL,'2026-06-19 16:39:25'),(20563,2363,'20',5,'procurement',5,'Approved for payment & sent to Budget / Finance',NULL,'with_finance',NULL,NULL,'2026-06-19 16:39:25'),(20564,2363,'21',5,'budget_finance',7,'Budget/Finance processed the supplier payment','with_finance','payment_processing',NULL,NULL,'2026-06-19 16:41:12'),(20565,2363,'22',5,'budget_finance',7,'Budget/Finance confirmed the payment','payment_processing','payment_confirmed',NULL,NULL,'2026-06-19 16:41:15'),(20566,2363,'23',5,'supplier',7,'Supplier confirmed payment received','payment_confirmed','payment_received',NULL,NULL,'2026-06-19 16:41:17'),(20567,2363,'24',6,'pal',4,'Rated supplier (3.5/5)','payment_received','pending_review',NULL,NULL,'2026-06-19 16:42:42'),(20568,2363,'25',6,'pal',4,'Requisition completed and archived','pending_review','closed',NULL,NULL,'2026-06-19 16:43:31'),(20569,2363,'2E',1,'area',3,'Emergency fast-track — routine Area review bypassed and routed straight to PAL','submitted','pal_received',NULL,'Operational emergency — safety-critical equipment needed for active deployment.','2026-07-10 13:10:24'),(20570,2364,'1',1,'station',2,'Saved requisition draft',NULL,'draft',NULL,NULL,'2026-07-10 14:51:42'),(20571,2364,'1',1,'station',2,'Updated requisition draft','draft','draft',NULL,NULL,'2026-07-10 14:52:26'),(20572,2364,'1',1,'station',2,'Submitted requisition','draft','submitted',NULL,NULL,'2026-07-10 14:53:14');


