File Manager

X7ROOT File Manager

Current Path: /var/www/html

📁 ..
📄 adminer.php(349.5 KB)
📄 app_29122023.tar.gz(390.11 KB)
📄 data.php(180.51 KB)
📄 emasdirlist.txt(10.02 KB)
📄 emasdirlist_run.sh(410.59 KB)
📄 emasdirlist_run_c3.sh(592.39 KB)
📄 emasdirlist_run_v2.sh(615.42 KB)
📄 emaspermohonandirlist.txt(12.43 KB)
📄 history_18012021.txt(12.12 KB)
📄 iggers(122.98 MB)
📁 mpc_emas
📁 mpc_emas_01072024
📄 mpc_emas_01072025_0830.tar.gz(1.86 GB)
📁 mpc_emas_01072025_maybecorrupt
📄 mpc_emas_02102025_1700.tar.gz(3.61 GB)
📄 mpc_emas_04042023.tar.gz(866.29 MB)
📄 mpc_emas_18092024_1840.zip(19.28 MB)
📄 mpc_emas_26012024_1130.tar.gz(1.24 GB)
📄 mpc_emas_28022023_2330.tar.gz(820.73 MB)
📄 mpc_emas_29052025.tar.gz(1.83 GB)
📄 mpc_emas_31122022_0006.tar.gz(674.25 MB)
📄 mpc_emas_copy_index_robot.sh(479.78 KB)
📄 mpc_emas_prod_01012025_0000.zip(21.09 MB)
📄 mpc_emas_prod_02102025_1700.zip(27.54 MB)
📄 mpc_emas_prod_04082025_2330.zip(26.21 MB)
📄 mpc_emas_prod_05072024.zip(17.72 MB)
📄 mpc_emas_prod_09012024_1000.zip(13.91 MB)
📄 mpc_emas_prod_09012024_1420.zip(13.95 MB)
📄 mpc_emas_prod_10012024_2335.zip(14.08 MB)
📄 mpc_emas_prod_10072024_1040.zip(17.77 MB)
📄 mpc_emas_prod_10092025_0400.zip(26.99 MB)
📄 mpc_emas_prod_12012024_1720.zip(14.21 MB)
📄 mpc_emas_prod_15022024_0020.tar.gz(15.08 MB)
📄 mpc_emas_prod_15052024_1018.zip(16.68 MB)
📄 mpc_emas_prod_20062025_2000.tar.gz(1.86 GB)
📄 mpc_emas_prod_21052024_0950.zip(16.83 MB)
📄 mpc_emas_prod_24052024_1100.zip(16.91 MB)
📄 mpc_emas_prod_28122024_2310.zip(21.07 MB)
📄 mpc_emas_prod_29052025_1500.zip(24.68 MB)
📄 mpc_emas_prod_29062025_1230.zip(25.36 MB)
📄 mpc_emas_prod_30062025_1000.zip(25.36 MB)
📄 mpc_emas_rename_filename.sh(583.63 KB)
📁 mpc_kiso
📄 mpc_kiso_31122022_0004.tar.gz(251.21 MB)
📄 mpcemas_allocation_year_forgolive2024.sql(237.81 KB)
📄 mpcemas_base_config_forgolive2024.sql(17.28 KB)
📄 mpcemas_permohonan_cost_forgolive2024.sql(8.78 MB)
📄 mpcemas_ref_sub_allocation_forgolive2024.sql(27.51 KB)
📄 phpinfo.php(20 B)
📄 stp_prod_06012020_datalamabulam102019.sql(6.1 MB)

Editing: mpcemas_ref_sub_allocation_forgolive2024.sql

-- MySQL dump 10.16  Distrib 10.1.37-MariaDB, for Win32 (AMD64)
--
-- Host: localhost    Database: mpc_emas_prod
-- ------------------------------------------------------
-- Server version	10.1.37-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping routines for database 'mpc_emas_prod'
--
/*!50003 DROP FUNCTION IF EXISTS `SPLIT_STR` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'NO_AUTO_VALUE_ON_ZERO' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `SPLIT_STR`(
  x VARCHAR(255),
  delim VARCHAR(12),
  pos INT
) RETURNS varchar(255) CHARSET latin1
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos),
       LENGTH(SUBSTRING_INDEX(x, delim, pos -1)) + 1),
       delim, '') ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;

--
-- Table structure for table `ref_sub_allocation`
--

DROP TABLE IF EXISTS `ref_sub_allocation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ref_sub_allocation` (
  `sub_allocation_id` int(11) NOT NULL AUTO_INCREMENT,
  `allocation_id` int(11) NOT NULL,
  `allocation_code` varchar(50) DEFAULT NULL,
  `sub_allocation_code` varchar(50) DEFAULT NULL,
  `sub_allocation_desc` varchar(255) DEFAULT NULL,
  `has_budget` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '1',
  `auditor_access` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`sub_allocation_id`),
  KEY `idx_refsuballocation_allocationid` (`allocation_id`),
  KEY `idx_refsuballocation_createdby` (`created_by`),
  KEY `idx_refsuballocation_updatedby` (`updated_by`),
  KEY `idx_refsuballocation_allocation` (`has_budget`),
  KEY `idx_refsuballocation_allocationcode` (`allocation_code`),
  KEY `idx_refsuballocation_suballocationcode` (`sub_allocation_code`),
  KEY `idx_refsuballocation_budget` (`has_budget`),
  KEY `idx_refsuballocation_auditoraccess` (`auditor_access`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ref_sub_allocation`
--

LOCK TABLES `ref_sub_allocation` WRITE;
/*!40000 ALTER TABLE `ref_sub_allocation` DISABLE KEYS */;
INSERT INTO `ref_sub_allocation` VALUES (1,2,'P-NPC-RP20-0005XX10-NPCX','KLEMS-TFP','CAPITAL, LABOR, ENERGY, MATERIAL AND SERVICES - TOTAL FACTOR PRODUCTIVITY',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:10:49',NULL),(2,2,'P-NPC-RK10-0007XX11-NPCX','MBR','MODERN BUSINESS REGULATION',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:25:23',NULL),(3,2,'P-NPC-RM10-0008XX11-NPCX','NPDIR','PELAKSANAAN NPDIR BAGI KERAJAAN NEGERI DAN KERAJAAN TEMPATAN',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:24:06',NULL),(4,2,'0006XX10-NPCX','EIIP','Enterprise Innovation Intervention Programmed',1,0,0,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42','2021-02-03 16:55:07'),(5,2,'P-NPC-LP10-0009XX11-NPCX','SPPE-MPB','SKIM PENINGKATAN PRODUKTIVITI ENTEPRIS SELARAS DENGAN MALAYSIA PROD BLUEPRINT',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:24:46',NULL),(6,2,'P-NPC-LP30-0010XX11-NPCX','MPB-EEPN','MALAYSIA PRODUCTIVITY BLUEPRINT - ELECTRICAL & ELECTRONIC',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:22:25',NULL),(7,2,'P-NPC-LP40-0011XX11-NPCX','MPB-CCPPN','MALAYSIA PRODUCTIVITY BLUEPRINT - CHEMICALS & CHEMICAL PRODUCTS',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:21:45',NULL),(8,2,'P-NPC-LP50-0012XX11-NPCX','MPB-RFBPN','MALAYSIA PRODUCTIVITY BLUEPRINT - RETAIL AND F&B',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:21:15',NULL),(9,2,'P-NPC-LP60-0013XX11-NPCX','MPB-TPN','MALAYSIA PRODUCTIVITY BLUEPRINT - TOURISM PRODUCTIVITY NEXUS',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:20:50',NULL),(10,2,'P-NPC-LP70-0014XX11-NPCX','MPB-AFPN','MALAYSIA PRODUCTIVITY BLUEPRINT - AGROFOOD PRODUCTIVITY NEXUS',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:20:10',NULL),(11,2,'P-NPC-LP80-0015XX11-NPCX','MPB-MEPN','MALAYSIA PRODUCTIVITY BLUEPRINT - MACHINERY & EQUIPMENT PRODUCTIVITY NEXUS',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:19:38',NULL),(12,2,'P-NPC-LB10-0016XX11-NPCX','MPB-PSPN','MALAYSIA PRODUCTIVITY BLUEPRINT - PROFESSIONAL SERVICES PRODUCTIVITY NEXUS',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:19:03',NULL),(13,2,'P-NPC-LB20-0017XX11-NPCX','MPB-ICT','MALAYSIA PRODUCTIVITY BLUEPRINT -ICT PRODUCTIVITY NEXUS',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:18:29',NULL),(14,2,'P-NPC-LB30-0018XX11-NPCX','MPB-PHPN','MALAYSIA PRODUCTIVITY BLUEPRINT - PRIVATE HEALTHCARE PRODUCTIVITY NEXUS',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:18:04',NULL),(15,2,'P-NPC-RK30-0019XX11-NPCX','T5 - MPB','MEMBENTUK MEKANISME PELAKSANAAN YANG PADU SELARAS DENGAN MPB-DMO',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:17:00',NULL),(16,2,'P-NPC-RK50-0020XX11-NPCX','PTPS','PROGRAM TRANSFORMASI PERATURAN SEDIA ADA',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:16:06',NULL),(17,2,'P-NPC-RK60-0021XX11-NPCX','NTM','MEMUDAHKAN PERATURAN PERNIAGAAN PERDAGANGAN ANTARABANGSA',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:15:24',NULL),(18,2,'P-NPC-RP50-0023XX11-NPCX','PKP','PENINGKATAN KUALITI PERATURAN',1,0,1,2,182,'2020-10-14 02:28:42','2023-07-21 03:14:47',NULL),(19,1,'M-NPC-SS20','Usahasama- MTCP/TCTP/JICA','MTCP/TCTP/JICA',1,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(20,1,'U60S0000-PP60','USAHASAMA- INDUSTRY 4.0 (RMK-11)','PROGRAM-INDUSTRY 4WRD (RMK-11)',1,0,1,2,31,'2020-10-14 02:28:42','2022-01-24 04:42:01',NULL),(21,1,'U70S0000-PP70','Usahasama- PPRN','Kajian Impak Pelaksanaan Inisiatif Public -Private Research Network (PPRN)',1,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(22,1,'U80S0000-PP80','Usahasama- HICoE','Kajian Impak Pelaksanaan Higher - Institutions Centre Of Excellence (HICOE)',1,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(23,1,'U90S0000-PP90','Usahasama- AKI','Anugerah Kecemerlangan Industri (AKI)',1,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(24,1,'M-NPC-SS20','Usahasama- PPV-MED','PPV-MED',1,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(25,1,'U11S0000-RP10','Usahasama- JPA','Kajian Pengukuran Produktiviti Perkhidmatan Awam (JPA)',1,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(26,1,'U12S0000-PP10','Usahasama- MEDAC 2020-LEAN','Kemudahan Latihan Prog Pembangunan Kapasiti Vendor 2019-2020',1,0,0,2,31,'2020-10-14 02:28:42','2022-02-18 03:19:21',NULL),(27,1,'U13S0000-RM10','Usahasama- HICoE (KEUSAHAWANAN)','Kajian Impak Perlaksanaan Prog Keusahawanan Institusi Pendidikan Tinggi',1,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(28,1,'M-NPC-SS20','Usahasama- DBKL','Kajian Pengukuran Prestasi (DBKL)',1,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(29,1,'U14S0000-LP10','Usahasama- MEDAC 2020-KAIZEN','Kemudahan Latihan Prog Pembangunan Kapasiti Vendor 2019-2020',1,0,0,2,31,'2020-10-14 02:28:42','2022-02-18 03:19:25',NULL),(30,1,'U15S0000-LP20','Usahasama- MEDAC 2020-I4.0','Kemudahan Latihan Prog Pembangunan Kapasiti Vendor 2019-2020',1,0,0,2,31,'2020-10-14 02:28:42','2022-02-18 03:19:30',NULL),(31,1,'K001N016-NPCX','Program Khas- NTEx','Konvensyen Team Excellence Kebangsaan',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(32,1,'K002N016-NPCX','Program Khas- RTEx (CRO)','Konvensyen Wilayah Tengah',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(33,1,'K003N016-NPCX','Program Khas- MTEx (CRO)','Mini Konvensyen Wilayah Tengah',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(34,1,'K004N016-WU0X','Program Khas- RTEx (NRO)','Konvensyen Team Excellence Wilayah Utara ',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(35,1,'K005N016-JB0X','Program Khas- RTEx (SRO)','Konvensyen Team Excellence Wilayah Selatan',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(36,1,'K015N016-KK0X','Program Khas- MTEx (SBO)','Mini Konvensyen Wilayah Sabah',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(37,1,'K006N016-PT0X','Program Khas- RTEx (ECR)','Konvensyen Team Excellence Wilayah P. Timur',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(38,1,'K007N016-KK0X','Program Khas- RTEx (SBO)','Konvensyen Team Excellence Sabah ',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(39,1,'K008N016-SW0X','Program Khas- RTEx (SKO)','Konvensyen Team Excellence Sarawak',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(40,1,'K011N016-JB0X','Program Khas- MTEx (SRO)','Mini Konvensyen Wilayah Selatan',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(41,1,'K012N016-PT0X','Program Khas- MTEx (ECR)','Mini Konvensyen Wilayah Pantai Timur',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(42,1,'K013N016-WU0X','Program Khas- MTEx (NRO)','Mini Konvensyen Wilayah Utara',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(43,1,'K014N016-SW0X','Program Khas- MTEx (SKO)','Mini Konvensyen Wilayah Sarawak',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(44,1,'K016N016-NPCX','Program Khas- PC','Productivity Conference',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(45,1,'K017N016-NPCX','PROGRAM KHAS- APIC','ANNUAL PRODUCTIVITY & INNOVATION CONFERENCE',0,0,1,2,201,'2020-10-14 02:28:42','2023-11-03 06:41:35',NULL),(46,1,'K018N016-NPCX','Program Khas- APQC','Asia Pacific Quality Conference',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(47,1,'S001N016-NPCX','ICQCC','International Convention on Quality Control Circles',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(48,1,'S003N009-NPCX','Seminar/Study Mission Luar Negara','Seminar/Study Mission Luar Negara',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(49,1,'S005N016-NPCX','IQPC','INTERNATIONAL QUALITY AND PRODUCTIVITY CONVENTION',0,0,1,2,31,'2020-10-14 02:28:42','2022-01-24 14:22:26',NULL),(50,1,'M-NPC-JB0','Mengurus-MPC SRO','Mengurus-MPC Wilayah Selatan',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(51,1,'M-NPC-WU0','Mengurus-MPC NRO','Mengurus-MPC Wilayah Utara',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(52,1,'M-NPC-SW0','Mengurus-MPC SKO','Mengurus-MPC Sarawak',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(53,1,'M-NPC-PT0','Mengurus-MPC ECR','Mengurus-MPC Wilayah Pantai Timur',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(54,1,'M-NPC-KK0','Mengurus-MPC SBO','Mengurus-MPC Sabah',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(55,1,'M-CR0-LP10','MENGURUS-PACS','MENGURUS-PACS',0,0,0,2,31,'2020-10-14 02:28:42','2021-04-06 06:17:40','2022-01-21 06:17:54'),(56,1,'M-NPC-KP01','MENGURUS-KP','MENGURUS - PEJABAT KETUA PENGARAH',0,0,1,2,31,'2020-10-14 02:28:42','2021-02-15 02:56:24',NULL),(57,1,'M-NPC-LB10','MENGURUS-OED','MENGURUS - OED',0,0,1,2,31,'2020-10-14 02:28:42','2021-02-15 02:46:43',NULL),(58,1,'M-NPC-UP30','MENGURUS-BTI','MENGURUS - INOVASI & TRANSFORMASI PERNIAGAAN',0,0,1,2,31,'2020-10-14 02:28:42','2021-02-15 02:55:35',NULL),(59,1,'M-NPC-RK10','MENGURUS-PCD','MENGURUS - PCD',0,0,1,2,182,'2020-10-14 02:28:42','2021-02-08 03:59:30',NULL),(60,1,'M-NPC-RM10','Mengurus-PCK','Mengurus-Pembangunan Prod & Daya Saing',0,0,0,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42','2021-02-14 18:45:27'),(61,1,'M-NPC-RP10','MENGURUS-PRODUCTIVITY GROWTH','MENGURUS - PRODUCTIVITY GROWTH',0,0,0,2,182,'2020-10-14 02:28:42','2021-02-08 03:59:00','2021-03-18 23:33:03'),(62,1,'M-NPC-SS10','Mengurus-MSF','Mengurus-Khidmat Pengurusan & Kewangan',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(63,1,'M-NPC-SS20','Mengurus-FIN','Mengurus-Unit Kewangan',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(64,1,'M-NPC-SS30','Mengurus-PCT','Mengurus-Unit Perolehan',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(65,1,'M-NPC-SS50','Mengurus-HRMD','Mengurus-Unit Pengurusan Sumber Manusia',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(66,1,'M-NPC-SS60','Mengurus-MIT','Mengurus-Unit Pengurusan Teknologi Maklumat',0,0,1,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42',NULL),(67,1,'M-NPC-TP02','MENGURUS-TKP PCD','MENGURUS-TKP PCD',0,0,1,2,31,'2020-10-14 02:28:42','2021-04-02 02:56:14',NULL),(68,1,'M-NPC-UP10','Mengurus-CSL/IA','Mengurus-Urusetia Perbadanan / Audit Dalam',0,0,0,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42','2022-02-28 07:41:19'),(69,1,'M-NPC-UP20','Mengurus-Unit Inovasi','Mengurus-Unit Inovasi',0,0,0,2,2,'2020-10-14 02:28:42','2020-10-14 02:28:42','2021-04-02 02:32:23'),(70,1,'M-NPC-UP20','MENGURUS-ITR','MENGURUS-UNIT PERHUBUNGAN ANTARABANGSA',0,0,1,2,31,'2020-10-14 02:28:42','2021-02-15 02:43:47',NULL),(71,2,'P-NPC-PP10-0022XX11-NPCX','SPN','SPN TOURISM',1,0,1,298,182,'2020-10-15 03:18:06','2023-07-21 06:58:05',NULL),(72,2,'P-NPC-RM30-0032XX11-NPCX','BI','BEHAVIORAL INSIGHTS',1,0,1,31,182,'2020-10-15 08:25:26','2023-07-21 03:26:52',NULL),(73,2,'P-NPC-SS50-0002XXX7-NPCX','HRD','PEMBANGUNAN SUMBER MANUSIA',1,0,1,31,182,'2020-11-03 04:29:36','2023-07-21 03:33:51',NULL),(74,2,'P-NPC-PP40-0035XX12-NPCX','FORE','MEMBENTUK EKOSISTEM PERATURAN PERNIAGAAN YANG TEGUH',1,0,1,298,182,'2021-01-17 05:42:06','2023-07-21 03:34:54',NULL),(75,2,'P-NPC-PP20-0033XX12-NPCX','SPC 2.0 (LPN)','INISIATIF PUSAT PRODUKTIVITI PERINGKAT SEKTOR',1,0,1,298,182,'2021-01-17 07:20:38','2023-07-21 03:35:53',NULL),(76,2,'P-NPC-PP30-0034XX12-NPCX','TWIP','TRANSFORMASI UPAH KE ARAH PENINGKATAN PRODUKTIVITI DAN PAMPASAN PEKERJA',1,0,1,298,182,'2021-01-18 03:30:15','2023-07-21 03:37:48',NULL),(77,2,'P-NPC-PP50-0032XX12-NPCX','BI 2.0','PENERAPAN KAEDAH BEHAVIOURAL INSIGHTS (BI) DALAM POLISI AWAM DAN PERATURAN DI MALAYSIA',1,0,1,91,182,'2021-01-22 00:24:24','2023-07-21 03:38:16',NULL),(78,2,'P-NPC-PP60-0009XX12-NPCX','SPPE 2.0','SKIM PENINGKATAN PRODUKTIVITI ENTERPRISE 2.0',1,0,1,182,182,'2021-02-04 01:58:34','2023-07-21 03:38:45',NULL),(79,1,'M-NPC-RP10','MENGURUS-PG','MENGURUS - PRODUCTIVITY GROWTH',0,0,1,31,31,'2021-02-15 02:53:59','2021-02-15 02:53:59',NULL),(80,1,'M-NPC-UP10','MENGURUS-CSL/IA','MENGURUS-CSL/INTERNAL AUDIT',0,0,1,31,31,'2021-03-19 07:35:25','2021-03-19 07:35:25',NULL),(81,1,'M-NPC-PP10','MENGURUS-CPD','MENGURUS-CPD',0,0,1,31,31,'2021-03-22 08:00:54','2021-03-22 08:00:54',NULL),(82,1,'M-NPC-TP01','MENGURUS-TKP OED','MENGURUS-TKP OED',0,0,1,31,31,'2021-04-02 02:57:02','2021-04-02 02:57:02',NULL),(83,1,'U23S0000-UP20','USAHASAMA-APO','APO',1,0,1,31,201,'2021-05-05 08:58:03','2022-10-06 08:17:31',NULL),(84,1,'U60S0000-PP60','USAHASAMA- INDUSTRY 4.0 2021','PROGRAM-INDUSTRY 4WRD',1,0,0,31,31,'2021-06-11 07:44:00','2021-06-11 07:44:00','2022-01-21 06:17:44'),(85,1,'U22S0000-RP40','USAHASAMA- KWC0-19','KUMPULAN WANG COVID',1,0,1,31,31,'2021-09-24 03:55:44','2021-09-24 10:09:21',NULL),(86,1,'M-NPC-RM40','MENGURUS-RM40','MENGURUS-RM40 DAYA SAING',1,0,1,31,31,'2022-01-17 01:56:31','2022-01-28 06:31:16',NULL),(87,1,'U61S0000-RM60','USAHASAMA-INDUSTRY 4.0 (RMK-12)','USAHASAMA-INDUSTRY 4.0 (RMK-12)',1,0,1,31,31,'2022-01-24 04:41:37','2022-01-24 04:41:37',NULL),(88,1,'M-NPC-RM40','P21101','TAMBANG PERJALANAN, TOP-UP DAN TOUCH N GO',0,0,0,201,201,'2022-04-09 23:44:49','2022-04-09 23:44:49','2022-04-09 15:47:02'),(89,1,'P23100','P23101','POS',1,0,0,201,201,'2022-04-14 01:15:24','2022-04-14 01:15:24','2022-05-26 22:36:41'),(90,1,'U24S0000','LB30','PENGGANTIAN PEKERJA ASING (KWC-RFW)',1,0,0,201,201,'2022-05-27 06:26:50','2022-05-27 06:26:50','2022-05-26 22:36:45'),(91,1,'USAHASAMA-KWC','U24S0000-LB30','PENGGANTIAN PEKERJA ASING (KWC-RFW)',1,0,0,201,201,'2022-05-27 06:31:44','2022-05-27 06:31:44','2022-05-26 22:36:48'),(92,1,'U25S0000-LB10','USAHASAMA (KWC-RFW)','KWC-RFW -  PENGGANTIAN PEKERJA ASING',1,0,1,201,182,'2022-05-27 06:40:39','2022-08-10 02:14:00',NULL),(93,1,'U26S0000-RM50','USAHASAMA (KWC-GIF)','KWC-GIF-GRADUATES IN FACTORY',1,0,1,182,182,'2022-08-10 02:17:06','2022-08-10 02:17:06',NULL),(94,1,'U28S0000-RP30','USAHASAMA (APO VISION 2025)','APO VISION 2025',1,0,1,201,201,'2022-09-20 06:15:31','2022-09-20 07:13:15',NULL),(95,1,'U27S0000-RP20','USAHASAMA (APO - KRITIKAL SEKTOR)','APO - KRITIKAL SEKTOR',1,0,1,201,201,'2022-09-23 03:44:59','2022-11-16 01:47:46',NULL),(96,2,'P-NPC-PP70-0036XX12-NPCX','E&E (AIF) DAN TRAIN & PLACE)','PROGRAM PEMBANGUNAN BAKAT TEMPATAN BAGI MENYOKONG INDUSTRI E&E (AIF DAN TRAIN AND PLACE)',1,0,1,201,182,'2022-11-16 01:50:36','2023-07-21 03:39:29',NULL),(97,1,'M-NPC-RM30','MENGURUS-RM30 MYMUDAH','MENGURUS-RM30 MYMUDAH',1,0,1,201,201,'2023-01-24 23:11:04','2023-01-25 01:32:27',NULL),(98,2,'0037XX12-NPCX','SPC 2.0 (COBEPN)','INISIATIF PUSAT PRODUKTIVITI PERINGKAT SEKTOR (NEXUS) - SPC 2.0 (COBEPN) - PEMBINAAN',1,0,1,201,182,'2023-02-02 07:08:23','2023-07-21 06:58:46',NULL),(99,1,'U61S0000-RM60','USAHASAMA - INDUSTRY 4.0','PROGRAM INDUSTRY 4WRD (RMK-12)',0,0,0,201,201,'2023-03-24 07:11:55','2023-03-24 07:11:55','2023-03-23 23:13:22'),(100,1,'P29100','P29118','PERKHIDMATAN PAKAR RUNDING LUAR NEGARA',0,0,0,201,201,'2023-08-24 07:02:10','2023-08-24 07:02:10','2023-08-23 23:02:44'),(101,2,'0038XX12-NPCX','AII - PROMOSI','AII - ACADEMY IN INDUSTRY - PROMOSI',1,0,1,201,201,'2023-08-31 00:01:45','2023-09-02 12:02:43',NULL),(102,2,'0039XX12-NPCX','AII - INSENTIF - SLDN','AII - ACADEMY IN INDUSTRY - INSENTIF - SLDN',1,0,1,201,201,'2023-08-31 00:02:43','2023-09-04 04:26:03',NULL),(103,2,'LP30-0010XX11-NPCX','MPB-EEPN','MALAYSIA PRODUCTIVITY BLUEPRINT - ELECTRICAL & ELECTRONIC',1,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(104,2,'LP40-0011XX11-NPCX','MPB-CCPPN','MALAYSIA PRODUCTIVITY BLUEPRINT - CHEMICALS & CHEMICAL PRODUCTS',1,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(105,2,'LP50-0012XX11-NPCX','MPB-RFBPN','MALAYSIA PRODUCTIVITY BLUEPRINT - RETAIL AND F&B',1,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(106,2,'LP60-0013XX11-NPCX','MPB-TPN','MALAYSIA PRODUCTIVITY BLUEPRINT - TOURISM PRODUCTIVITY NEXUS',1,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(107,2,'LP70-0014XX11-NPCX','MPB-AFPN','MALAYSIA PRODUCTIVITY BLUEPRINT - AGROFOOD PRODUCTIVITY NEXUS',1,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(108,2,'LP80-0015XX11-NPCX','MPB-MEPN','MALAYSIA PRODUCTIVITY BLUEPRINT - MACHINERY & EQUIPMENT PRODUCTIVITY NEXUS',1,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(109,2,'LB10-0016XX11-NPCX','MPB-PSPN','MALAYSIA PRODUCTIVITY BLUEPRINT - PROFESSIONAL SERVICES PRODUCTIVITY NEXUS',1,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(110,2,'LB20-0017XX11-NPCX','MPB-ICT','MALAYSIA PRODUCTIVITY BLUEPRINT -ICT PRODUCTIVITY NEXUS',1,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(111,2,'LB30-0018XX11-NPCX','MPB-PHPN','MALAYSIA PRODUCTIVITY BLUEPRINT - PRIVATE HEALTHCARE PRODUCTIVITY NEXUS',1,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(112,3,'PP90-U90S0000-PP90','USAHASAMA- AKI','Anugerah Kecemerlangan Industri (AKI)',1,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(113,1,'LP10-X-SRO','MENGURUS-MPC SRO','Mengurus-MPC Wilayah Selatan',0,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(114,1,'LP10-X-NRO','MENGURUS-MPC NRO','Mengurus-MPC Wilayah Utara',0,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(115,1,'LP10-X-SKO','MENGURUS-MPC SKO','Mengurus-MPC Sarawak',0,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(116,1,'LP10-X-ECR','MENGURUS-MPC ECR','Mengurus-MPC Wilayah Pantai Timur',0,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(117,1,'LP10-X-SBO','MENGURUS-MPC SBO','Mengurus-MPC Sabah',0,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(118,1,'KP01-X','MENGURUS-KP','MENGURUS - PEJABAT KETUA PENGARAH',0,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(119,1,'LB10-X','MENGURUS-PP','MENGURUS - Produktiviti Insan',0,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(120,1,'UP30-X','MENGURUS-BTI','MENGURUS - INOVASI & TRANSFORMASI PERNIAGAAN',0,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(121,1,'RK10-X','MENGURUS-PCD','MENGURUS - PCD',0,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(122,1,'RM10-X','MENGURUS-PCK','Mengurus-Pembangunan Prod & Daya Saing',0,1,0,2,2,'2024-01-01 23:24:47','2024-01-01 23:24:47',NULL),(123,1,'RP10-X','MENGURUS-PG','MENGURUS - PRODUCTIVITY GROWTH',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(124,1,'SS10-X','MENGURUS-MSF','Mengurus-Khidmat Pengurusan & Kewangan',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(125,1,'SS20-X','MENGURUS-FIN','Mengurus-Unit Kewangan',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(126,1,'SS30-X','MENGURUS-PCT','Mengurus-Unit Perolehan',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(127,1,'SS50-X','MENGURUS-HRMD','Mengurus-Unit Pengurusan Sumber Manusia',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(128,1,'SS60-X','MENGURUS-MIT','Mengurus-Unit Pengurusan Teknologi Maklumat',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(129,1,'TP02-X','MENGURUS-TKP PCD','MENGURUS-TKP PCD',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(130,1,'UP10-X-UP','MENGURUS-CSL/IA','Mengurus-Urusetia Perbadanan / Audit Dalam',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(131,1,'UP20-X','MENGURUS-ITR','MENGURUS-UNIT PERHUBUNGAN ANTARABANGSA',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(132,2,'PP10-0022XX11-NPCX','SPN','SPN TOURISM',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(133,2,'RM30-0032XX11-NPCX','BI','BEHAVIORAL INSIGHTS',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(134,2,'SS50-0002XXX7-NPCX','HRD','PEMBANGUNAN SUMBER MANUSIA',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(135,2,'PP40-0035XX12-NPCX','FORE','MEMBENTUK EKOSISTEM PERATURAN PERNIAGAAN YANG TEGUH',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(136,2,'PP20-0033XX12-NPCX','SPC 2.0 (LPN)','INISIATIF PUSAT PRODUKTIVITI PERINGKAT SEKTOR',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(137,2,'PP30-0034XX12-NPCX','TWIP','TRANSFORMASI UPAH KE ARAH PENINGKATAN PRODUKTIVITI DAN PAMPASAN PEKERJA',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(138,2,'PP50-0032XX12-NPCX','BI 2.0','PENERAPAN KAEDAH BEHAVIOURAL INSIGHTS (BI) DALAM POLISI AWAM DAN PERATURAN DI MALAYSIA',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(139,2,'PP60-0009XX12-NPCX','SPPE 2.0','SKIM PENINGKATAN PRODUKTIVITI ENTERPRISE 2.0',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(140,1,'UP10-X-CSL','MENGURUS-CSL/IA','MENGURUS-CSL/INTERNAL AUDIT',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(141,1,'PP10-X','MENGURUS-CPD','MENGURUS-CPD',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(142,1,'TP01-X','MENGURUS-TKP PP','MENGURUS-TKP PP',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(143,3,'UP20-U23S0000-UP20','USAHASAMA-APO','APO',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(144,3,'RP40-U22S0000-RP40','USAHASAMA- KWC0-19','KUMPULAN WANG COVID',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(145,1,'RM40-X','MENGURUS-RM40','MENGURUS-RM40 DAYA SAING',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(146,3,'LB30-U24S0000-LB30','USAHASAMA-KWC','PENGGANTIAN PEKERJA ASING (KWC-RFW)',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(147,3,'LB10-U25S0000-LB10','USAHASAMA (KWC-RFW)','KWC-RFW -  PENGGANTIAN PEKERJA ASING',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(148,3,'RM50-U26S0000-RM50','USAHASAMA (KWC-GIF)','KWC-GIF-GRADUATES IN FACTORY',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(149,3,'RP30-U28S0000-RP30','USAHASAMA (APO VISION 2025)','APO VISION 2025',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(150,3,'RP20-U27S0000-RP20','USAHASAMA (APO - KRITIKAL SEKTOR)','APO - KRITIKAL SEKTOR',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(151,2,'PP70-0036XX12-NPCX','E&E DAN (TRAIN & PLACE)','PROGRAM PEMBANGUNAN BAKAT TEMPATAN BAGI MENYOKONG INDUSTRI E&E (AIF DAN TRAIN AND PLACE)',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(152,1,'RM30-X','MENGURUS-RM30 MYMUDAH','MENGURUS-RM30 MYMUDAH',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(153,2,'PP20-0037XX12-NPCX','SPC 2.0 (COBEPN)','INISIATIF PUSAT PRODUKTIVITI PERINGKAT SEKTOR (NEXUS) - SPC 2.0 (COBEPN) - PEMBINAAN',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(154,3,'RM60-U61S0000-RM60','USAHASAMA - I4WRD (RMK-12)','PROGRAM INDUSTRY 4WRD (RMK-12)',0,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(155,2,'RK10-0038XX12-NPCX','AII - PROMOSI','ACADEMY IN INDUSTRY - PROMOSI',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL),(156,2,'RK20-0039XX12-NPCX','AII - INSENTIF - SLDN','ACADEMY IN INDUSTRY - INSENTIF - SLDN',1,1,0,2,2,'2024-01-01 23:24:48','2024-01-01 23:24:48',NULL);
/*!40000 ALTER TABLE `ref_sub_allocation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'mpc_emas_prod'
--
/*!50106 SET @save_time_zone= @@TIME_ZONE */ ;
/*!50106 DROP EVENT IF EXISTS `update_runningno` */;
DELIMITER ;;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;;
/*!50003 SET character_set_client  = utf8 */ ;;
/*!50003 SET character_set_results = utf8 */ ;;
/*!50003 SET collation_connection  = utf8_general_ci */ ;;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;;
/*!50003 SET sql_mode              = 'NO_AUTO_VALUE_ON_ZERO' */ ;;
/*!50003 SET @saved_time_zone      = @@time_zone */ ;;
/*!50003 SET time_zone             = '+00:00' */ ;;
/*!50106 CREATE*/ /*!50117 DEFINER=`root`@`localhost`*/ /*!50106 EVENT `update_runningno` ON SCHEDULE EVERY 1 YEAR STARTS '2020-10-13 18:11:53' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE ref_allocation SET running_no=0 */ ;;
/*!50003 SET time_zone             = @saved_time_zone */ ;;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;;
/*!50003 SET character_set_client  = @saved_cs_client */ ;;
/*!50003 SET character_set_results = @saved_cs_results */ ;;
/*!50003 SET collation_connection  = @saved_col_connection */ ;;
DELIMITER ;
/*!50106 SET TIME_ZONE= @save_time_zone */ ;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-01-02 11:06:51

X7ROOT File Manager

Editing: mpcemas_ref_sub_allocation_forgolive2024.sql

Upload File

Create Folder