CREATE TABLE `psi_kpi_fin_indicators` (
  `kpifini_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kpifini_pos` int(10) unsigned DEFAULT '0',
  `kpifini_letter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `kpifini_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kpifini_label` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `kpifini_show_type` tinyint(3) unsigned DEFAULT '0',
  `kpifini_indent` tinyint(3) unsigned DEFAULT '0',
  `kpifini_subcat` tinyint(3) unsigned DEFAULT '0',
  `kpifini_label_only` tinyint(1) unsigned DEFAULT '0',
  `kpifini_acc_format` 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 (`kpifini_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_kpi_fin_indicators (kpifini_id, kpifini_pos, kpifini_letter, kpifini_number, kpifini_label, kpifini_show_type, kpifini_indent, kpifini_subcat, kpifini_label_only, kpifini_acc_format, region_id, synched, sync_date) VALUES
(1, 1, 'A', NULL, 'Enhance cost-effectiveness and efficiency in resource allocation and utilization compliant to government rules and regulations', 0, 0, 0, 1, 0, 6, 0, NULL),
(2, 2, 'A', '', '% allotment obligated against allotment received', 1, 0, 0, 0, 0, 6, 0, NULL),
(3, 3, 'A', '', '% of COA findings addressed within prescribed period (n/n)', 1, 0, 0, 0, 0, 6, 0, NULL),
(4, 4, 'A', '', '% Non-conformities addressed (n/n)', 1, 0, 0, 0, 0, 6, 0, NULL),
(5, 5, 'B', NULL, 'Employ innovative resource generation strategies', 0, 0, 0, 1, 0, 6, 0, NULL),
(6, 6, 'B', '', 'Amount of external resources generated (in Php \'000)', 3, 0, 0, 0, 0, 6, 0, NULL);
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);
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);
CREATE TABLE `psi_kpi_lag_indicators` (
  `kpilagi_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kpilagi_pos` int(10) unsigned DEFAULT '0',
  `kpilagi_letter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `kpilagi_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kpilagi_label` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `kpilagi_show_type` tinyint(3) unsigned DEFAULT '0',
  `kpilagi_indent` tinyint(3) unsigned DEFAULT '0',
  `kpilagi_subcat` tinyint(3) unsigned DEFAULT '0',
  `kpilagi_label_only` tinyint(1) unsigned DEFAULT '0',
  `kpilagi_acc_format` 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 (`kpilagi_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_kpi_lag_indicators (kpilagi_id, kpilagi_pos, kpilagi_letter, kpilagi_number, kpilagi_label, kpilagi_show_type, kpilagi_indent, kpilagi_subcat, kpilagi_label_only, kpilagi_acc_format, region_id, synched, sync_date) VALUES
(1, 1, 'A', NULL, 'Enhance PERFORMANCE MANAGEMENT system', 0, 0, 0, 1, 0, 6, 0, NULL),
(2, 2, 'A', '', 'Office Performance Commitment and Review rating', 2, 0, 0, 0, 5, 6, 0, NULL),
(3, 3, 'A', '', 'No. of employees/units recognized for high performance & exemplary behavior', 0, 0, 0, 0, 0, 6, 0, NULL),
(4, 4, 'A', '', 'No. of employees recognized for innovative ideas/processes introduced', 0, 0, 0, 0, 0, 6, 0, NULL),
(5, 5, 'A', '', 'Overall morale value index', 1, 0, 0, 0, 0, 6, 0, NULL),
(6, 6, 'B', NULL, 'Enhance personnel capacities and responsiveness to global and technological development', 0, 0, 0, 1, 0, 6, 0, NULL),
(7, 7, 'B', '', '% of planned annual competency building intervention implemented', 1, 0, 0, 0, 0, 6, 0, NULL);
CREATE TABLE `psi_user_rights` (
  `ur_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ur_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date_encoded` datetime DEFAULT NULL,
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `last_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`ur_id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_user_rights (ur_id, ur_name, region_id, synched, sync_date, encoder, date_encoded, updater, last_updated) VALUES
(1, 'Projects', 6, 0, NULL, '', NULL, '', NULL),
(2, 'Cooperators', 6, 0, NULL, '', NULL, '', NULL),
(3, 'Service Providers', 6, 0, NULL, '', NULL, '', NULL),
(4, 'Planning', 6, 0, NULL, '', NULL, '', NULL),
(5, 'Consultancies', 6, 0, NULL, '', NULL, '', NULL),
(6, 'Packaging & Labeling', 6, 0, NULL, '', NULL, '', NULL),
(7, 'Packaging & Labeling Designs', 6, 0, NULL, '', NULL, '', NULL),
(8, 'Training', 6, 0, NULL, '', NULL, '', NULL),
(9, 'Training Documents', 6, 0, NULL, '', NULL, '', NULL),
(10, 'Testings & Calibrations', 6, 0, NULL, '', NULL, '', NULL),
(11, 'Scholarships', 6, 0, NULL, '', NULL, '', NULL),
(12, 'Scholarship Monitoring', 6, 0, NULL, '', NULL, '', NULL),
(13, 'S&T Fairs & Promotional Activities', 6, 0, NULL, '', NULL, '', NULL),
(14, 'Library Monitoring', 6, 0, NULL, '', NULL, '', NULL),
(15, 'S&T Activity Categories', 6, 0, NULL, '', NULL, '', NULL),
(16, 'Collaborating Agencies', 6, 0, NULL, '', NULL, '', NULL),
(17, 'Consultancy Categories', 6, 0, NULL, '', NULL, '', NULL),
(18, 'Document Categories', 6, 0, NULL, '', NULL, '', NULL),
(19, 'Equipment Names', 6, 0, NULL, '', NULL, '', NULL),
(20, 'Organization Categories', 6, 0, NULL, '', NULL, '', NULL),
(21, 'Project Categories', 6, 0, NULL, '', NULL, '', NULL),
(22, 'Course Categories', 6, 0, NULL, '', NULL, '', NULL),
(23, 'Courses', 6, 0, NULL, '', NULL, '', NULL),
(24, 'Scholarship Programs', 6, 0, NULL, '', NULL, '', NULL),
(25, 'Schools', 6, 0, NULL, '', NULL, '', NULL),
(26, 'Agency Profile', 6, 0, NULL, '', NULL, '', NULL),
(27, 'Project Monitoring', 6, 0, NULL, '', NULL, '', NULL),
(28, 'Project Documentation', 6, 0, NULL, '', NULL, '', NULL),
(29, 'Project Photos', 6, 0, NULL, '', NULL, '', NULL),
(30, 'Project Consultancies', 6, 0, NULL, '', NULL, '', NULL),
(31, 'Project Fora', 6, 0, NULL, '', NULL, '', NULL),
(32, 'Project Fora Documents', 6, 0, NULL, '', NULL, '', NULL),
(33, 'Project Equipment', 6, 0, NULL, '', NULL, '', NULL),
(34, 'Project Repayment', 6, 0, NULL, '', NULL, '', NULL),
(35, 'Users', 6, 0, NULL, '', NULL, '', NULL),
(36, 'UserGroups', 6, 0, NULL, '', NULL, '', NULL),
(37, 'Project PIS', 6, 0, NULL, '', NULL, '', NULL),
(38, 'Project Packaging & Labeling', 6, 0, NULL, '', NULL, '', NULL),
(39, 'Fora', 6, 0, NULL, '', NULL, '', NULL),
(40, 'Fora Documents', 6, 0, NULL, '', NULL, '', NULL),
(41, 'Consultancy Documents', 6, 0, NULL, '', NULL, '', NULL),
(42, 'Project Consultancy Documents', 6, 0, NULL, '', NULL, '', NULL),
(43, 'Project Packaging & Labeling Designs', 6, 0, NULL, '', NULL, '', NULL),
(44, 'Sectors', 6, 0, NULL, '', NULL, '', NULL),
(45, 'Project Sites', 6, 0, NULL, '', NULL, '', NULL),
(46, 'Location Listings', 6, 0, NULL, '', NULL, '', NULL),
(47, 'Product Units', 6, 0, NULL, '', NULL, '', NULL),
(48, 'Collaborating Agency Categories', 6, 0, NULL, '', NULL, '', NULL),
(49, 'Project Products', 6, 0, NULL, '', NULL, '', NULL),
(50, 'Project Liquidation', 6, 0, NULL, '', NULL, '', NULL),
(51, 'Technology Promotions', 6, 0, NULL, '', NULL, '', NULL),
(52, 'Technology Adoptions', 6, 0, NULL, '', NULL, '', NULL),
(53, 'Technologies', 6, 0, NULL, '', NULL, '', NULL),
(54, 'BSC Customer Perspective', 6, 0, NULL, '', NULL, '', NULL),
(55, 'BSC Financial Perspective', 6, 0, NULL, '', NULL, '', NULL),
(56, 'BSC Internal Process Perspective', 6, 0, NULL, '', NULL, '', NULL),
(57, 'Project Testings & Calibrations', 6, 0, NULL, '', NULL, '', NULL),
(58, 'Technology Adoption Documents', 6, 0, NULL, '', NULL, '', NULL),
(59, 'Project Videos', 6, 0, NULL, '', NULL, '', NULL),
(60, 'S & T Information And Referrals', 6, 0, NULL, '', NULL, '', NULL),
(61, 'SUC Assistance', 6, 0, NULL, '', NULL, '', NULL),
(62, 'ISO Accreditation', 6, 0, NULL, '', NULL, '', NULL),
(63, 'Customer Satisfaction Ratings', 6, 0, NULL, '', NULL, '', NULL),
(64, 'Innovation Hubs', 6, 0, NULL, '', NULL, '', NULL),
(65, 'International Collaborations', 6, 0, NULL, '', NULL, '', NULL),
(66, 'BSC Learning & Growth Perspective', 6, 0, NULL, '', NULL, '', NULL),
(67, 'DRR-CCAM', 6, 0, NULL, '', NULL, '', NULL),
(68, 'R & D Agenda', 6, 0, NULL, '', NULL, '', NULL),
(69, 'R & D Projects', 6, 0, NULL, '', NULL, '', NULL),
(70, 'Regional Communications Plan', 6, 0, NULL, '', NULL, '', NULL),
(71, 'Project S & T Interventions', 6, 0, NULL, '', NULL, '', NULL),
(72, 'BSC Customer Perspective Approval', 6, 0, NULL, '', NULL, '', NULL),
(73, 'BSC Financial Perspective Approval', 6, 0, NULL, '', NULL, '', NULL),
(74, 'BSC Internal Process Perspective Approval', 6, 0, NULL, '', NULL, '', NULL),
(75, 'BSC Learning & Growth Perspective Approval', 6, 0, NULL, '', NULL, '', NULL),
(84, 'User Logs', 6, 0, NULL, '', NULL, '', NULL);
