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);
