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