CREATE TABLE `psi_kpi_ip_indicators` (
  `kpiipi_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kpiipi_pos` int(10) unsigned DEFAULT '0',
  `kpiipi_letter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `kpiipi_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kpiipi_label` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `kpiipi_show_type` tinyint(3) unsigned DEFAULT '0',
  `kpiipi_indent` tinyint(3) unsigned DEFAULT '0',
  `kpiipi_subcat` tinyint(3) unsigned DEFAULT '0',
  `kpiipi_label_only` tinyint(1) unsigned DEFAULT '0',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  PRIMARY KEY (`kpiipi_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_kpi_ip_indicators (kpiipi_id, kpiipi_pos, kpiipi_letter, kpiipi_number, kpiipi_label, kpiipi_show_type, kpiipi_indent, kpiipi_subcat, kpiipi_label_only, region_id, synched, sync_date) VALUES
(1, 1, 'A', NULL, 'Ensure continual improvement of work processes', 0, 0, 0, 1, 6, 0, NULL),
(2, 2, 'A', '', 'No. of work-process innovations implemented', 0, 0, 0, 1, 6, 0, NULL),
(3, 3, 'A', '', 'Work Instruction', 0, 1, 0, 0, 6, 0, NULL),
(4, 4, 'A', '', 'Procedures', 0, 1, 0, 0, 6, 0, NULL),
(5, 5, 'A', '', 'Systems', 0, 1, 0, 0, 6, 0, NULL),
(6, 6, 'B', NULL, 'Enhance office operation efficiency through harmonized Information systems', 0, 0, 0, 1, 6, 0, NULL),
(7, 7, 'B', '', 'Using the following IT systems: (Y/N)', 0, 0, 0, 1, 6, 0, NULL),
(8, 8, 'B', 'A', 'TRACE', 4, 1, 0, 0, 6, 0, NULL),
(9, 9, 'B', 'B', 'TOMS', 4, 1, 0, 0, 6, 0, NULL),
(10, 10, 'B', 'C', 'Information & Monitoring of Projects, Services & S&T Interventions (IMPRESSION)', 4, 1, 0, 0, 6, 0, NULL),
(11, 11, 'B', 'D', 'Supplies Management Database', 4, 1, 0, 0, 6, 0, NULL),
(12, 12, 'B', 'E', 'S&T Scholarship Information Management System (STSIMS)', 4, 1, 0, 0, 6, 0, NULL),
(13, 13, 'B', 'F', 'Human Resource Management Information System (HRMIS)', 4, 1, 0, 0, 6, 0, NULL),
(14, 14, 'C', NULL, 'Establish risk analysis mechanisms for business/ quality mgt. processes', 0, 0, 0, 1, 6, 0, NULL),
(15, 15, 'C', '', '% of programs/projects with risk analysis (n/n)', 0, 0, 0, 0, 6, 0, NULL),
(16, 16, 'E', NULL, 'Sustain QMS and other recognitions/accreditation', 0, 0, 0, 1, 6, 0, NULL),
(17, 17, 'E', '', 'ISO 9001 certification maintained', 4, 0, 0, 0, 6, 0, NULL),
(18, 18, 'E', '', 'ISO 17025 accreditation maintained', 4, 0, 0, 0, 6, 0, NULL),
(19, 19, 'E', '', 'FDA accreditation maintained', 4, 0, 0, 0, 6, 0, NULL),
(20, 20, 'E', '', 'EMB recognition maintained', 4, 0, 0, 0, 6, 0, NULL),
(21, 21, 'E', '', 'DOH accreditation maintained', 4, 0, 0, 0, 6, 0, NULL),
(22, 22, 'E', '', 'PQA award conferred', 4, 0, 0, 0, 6, 0, NULL),
(23, 23, 'F', NULL, 'Ensure compliance to good governance requirements', 0, 0, 0, 1, 6, 0, NULL),
(24, 24, 'F', '', 'GAD', 4, 0, 0, 0, 6, 0, NULL),
(25, 25, 'F', '', 'Senior Citizen Law', 4, 0, 0, 0, 6, 0, NULL),
(26, 26, 'F', '', 'PWD', 4, 0, 0, 0, 6, 0, NULL),
(27, 27, 'F', '', 'FOI', 4, 0, 0, 0, 6, 0, NULL),
(28, 28, 'F', '', 'Data Privacy Act', 4, 0, 0, 0, 6, 0, NULL),
(29, 29, 'F', '', 'ARTA', 4, 0, 0, 0, 6, 0, NULL);
