CREATE TABLE `psi_kpi_indicators` (
  `kpiind_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kpiind_pos` int(10) unsigned DEFAULT '0',
  `kpiind_letter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `kpiind_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kpiind_label` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `kpiind_value_format` tinyint(3) unsigned DEFAULT '0',
  `kpiind_indent` tinyint(3) unsigned DEFAULT '0',
  `kpiind_row_format` tinyint(3) unsigned DEFAULT '0',
  `kpiind_label_only` tinyint(3) unsigned DEFAULT '0',
  `kpiind_acc_format` tinyint(3) unsigned DEFAULT '0',
  `kpiind_regional` tinyint(3) unsigned DEFAULT '0',
  `kpiind_provincial` tinyint(3) unsigned DEFAULT '0',
  `kpiind_municipal` tinyint(3) unsigned DEFAULT '0',
  `kpiind_notarget` tinyint(3) unsigned DEFAULT '0',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  PRIMARY KEY (`kpiind_id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_kpi_indicators (kpiind_id, kpiind_pos, kpiind_letter, kpiind_number, kpiind_label, kpiind_value_format, kpiind_indent, kpiind_row_format, kpiind_label_only, kpiind_acc_format, kpiind_regional, kpiind_provincial, kpiind_municipal, kpiind_notarget, region_id, synched, sync_date) VALUES
(1, 1, 'A', NULL, 'Outcome 1: Innovation stimulated', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(2, 2, 'A', NULL, 'Align regional R&D agenda to the harmonized national R&D agenda', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(3, 3, 'A', NULL, 'Regional  R&D Agenda formulated', 4, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(4, 4, 'A', NULL, 'No. of R&D proposals evaluated and/or endorsed (total)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(5, 5, 'A', 'A', 'Agriculture', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(6, 6, 'A', 'B', 'Health', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(7, 7, 'A', 'C', 'Industry and Energy', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(8, 8, 'A', 'D', 'DRRM', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(9, 9, 'A', 'E', 'Others', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(10, 10, 'A', NULL, 'No. of endorsed R&D proposals funded (total)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(11, 11, 'A', 'A', 'Agriculture', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(12, 12, 'A', 'B', 'Health', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(13, 13, 'A', 'C', 'Industry and Energy', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(14, 14, 'A', 'D', 'DRRM', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(15, 15, 'A', 'E', 'Others', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(16, 16, 'B', NULL, 'Outcome 2: Technology Adoption promoted/accelerated', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(17, 17, 'B', NULL, 'Promote adoption/utilization of technologies from publicly funded R&D', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(18, 18, 'B', NULL, 'No. of technologies promoted', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(19, 19, 'B', NULL, 'No. of technologies adopted/utilized/commercialized', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(20, 20, 'B', NULL, 'No. of technology adoptors (total)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(21, 21, 'B', 'A', 'Individuals', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(22, 22, 'B', 'B', 'MSMEs/Firms', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(23, 23, 'B', 'C', 'Academe', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(24, 24, 'B', 'D', 'LGUs', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(25, 25, 'B', 'E', 'Cooperatives', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(26, 26, 'C', NULL, 'Outcome 4: Productivity and efficiency of communities and the production sector, Particularly MSMEs improved', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(27, 27, 'C', NULL, 'Provide support mechanisms for startups, MSMEs  industries, and others in the region', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(28, 28, 'C', NULL, 'No. of S&T interventions provided (total)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(29, 29, 'C', 'A', 'Trainings', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(30, 30, 'C', 'B', 'Consultancy', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(31, 31, 'C', 'C', 'Testing/Calibration (non-paying)', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(32, 32, 'C', 'D', 'Packaging and labelling design', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(33, 33, 'C', 'E', 'S&T information and referral', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(34, 34, 'C', 'F', 'Innovation Enabling Fund', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(35, 35, 'C', NULL, 'No. of start-ups/enterprises/spin-offs assisted/created', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(36, 36, 'C', NULL, 'No. of customers assisted (total)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(37, 37, 'C', 'A', 'Trainings', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(38, 38, 'C', 'B', 'Consultancy', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(39, 39, 'C', 'C', 'Testing/Calibration (non-paying)', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(40, 40, 'C', 'D', 'Packaging and labelling design', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(41, 41, 'C', 'E', 'S&T information and referral', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(42, 42, 'C', 'F', 'Innovation Enabling Fund', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(43, 43, 'C', NULL, 'No. of jobs generated', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(44, 44, 'C', NULL, '% improvement in productivity', 1, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(45, 45, 'C', NULL, 'Amount of gross sales generated', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(46, 46, 'C', NULL, 'Establish and promote innovation hubs and other similar mechanisms', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(47, 47, 'C', NULL, 'No. of Innovation Centers established/maintained', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(48, 48, 'C', NULL, 'Strengthen Regional Standards and Testing Laboratory services', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(49, 49, 'C', NULL, 'No. of testing and calibration services provided (paying) (total)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(50, 50, 'C', NULL, 'Samples received by the Region\'s RSTL', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(51, 51, 'C', 'A', 'Physico-Chemical and Microbiological tests', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(52, 52, 'C', 'B', 'Calibration services', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(53, 53, 'C', 'C', 'Halal testing', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(54, 54, 'C', NULL, 'Samples referred by other RSTLs under OneLab', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(55, 55, 'C', 'A', 'Physico-Chemical and Microbiological tests', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(56, 56, 'C', 'B', 'Calibration services', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(57, 57, 'C', 'C', 'Halal testing', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(58, 58, 'C', NULL, '% of testing/calibration services delivered within the agreed time', 1, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(59, 59, 'C', NULL, 'No. of customers served', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(60, 60, 'C', NULL, 'No. of referred samples to another RSTL under OneLab', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(61, 61, 'C', NULL, 'Income generated by the RSTL (Php \'000)/fees collected & remitted to the National Treasury', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(62, 62, 'C', NULL, 'Enhance customer satisfaction', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(63, 63, 'C', NULL, '% of customers whose rating is VS or better', 1, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(64, 64, 'D', NULL, 'Outcome 5: Resiliency to disaster risks and climate change ensured', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(65, 65, 'D', NULL, 'Intensify provisions of information, products and services for  DRR-CCAM', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(66, 66, 'D', NULL, 'No. of measures on disaster risk reduction and mitigation implemented (total)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(67, 67, 'D', 'A', 'Activities', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(68, 68, 'D', 'B', 'IEC materials', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(69, 69, 'D', NULL, 'Intensify collaboration with DRR-CCAM stakeholders', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(70, 70, 'D', NULL, 'No. of DRRM-related collaborations with stakeholders', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(71, 71, 'E', NULL, 'OUTCOME 6: Inequality in STI capacities and opportunities reduced', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(72, 72, 'E', NULL, 'Provide equitable access to STI capacities and opportunities', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(73, 73, 'E', NULL, 'No. of R&D Centers/NICERs established/maintained', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(74, 74, 'E', NULL, 'Foster STI culture', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(75, 75, 'E', NULL, 'No. of S&T promotional activities conducted (total)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL),
(79, 79, 'E', NULL, 'Intensify int\'l collaboration', 0, 0, 0, 1, 0, 0, 0, 0, 0, 6, 0, NULL),
(80, 80, 'E', NULL, 'No. of international collaborations established', 0, 1, 0, 0, 0, 0, 0, 0, 0, 6, 0, NULL);
