/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.11.19-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: padanglawas_skp -- ------------------------------------------------------ -- Server version 10.11.19-MariaDB-ubu2404 /*!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 utf8mb4 */; /*!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 */; -- -- Table structure for table `tbl_notifikasi` -- DROP TABLE IF EXISTS `tbl_notifikasi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_notifikasi` ( `id_notifikasi` int(11) NOT NULL AUTO_INCREMENT, `nip` varchar(18) NOT NULL, `notifikasi` text DEFAULT NULL, `status` int(11) NOT NULL DEFAULT 0, `created` datetime DEFAULT NULL, `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_notifikasi`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_notifikasi` -- LOCK TABLES `tbl_notifikasi` WRITE; /*!40000 ALTER TABLE `tbl_notifikasi` DISABLE KEYS */; /*!40000 ALTER TABLE `tbl_notifikasi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_periode` -- DROP TABLE IF EXISTS `tbl_periode`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_periode` ( `id_periode` int(11) NOT NULL AUTO_INCREMENT, `kode_periode` varchar(25) NOT NULL, `id_opd_jabatan` int(11) NOT NULL, `nip` varchar(18) NOT NULL, `nama` varchar(100) NOT NULL, `pangkat` varchar(50) DEFAULT NULL, `golongan` varchar(5) NOT NULL, `jabatan` text NOT NULL, `unit_kerja` text NOT NULL, `nip_atasan` varchar(18) NOT NULL, `nama_atasan` varchar(100) NOT NULL, `pangkat_atasan` varchar(50) DEFAULT NULL, `golongan_atasan` varchar(5) NOT NULL, `jabatan_atasan` text NOT NULL, `unit_kerja_atasan` text NOT NULL, `tahun` year(4) NOT NULL, `dari` date DEFAULT NULL, `sampai` date DEFAULT NULL, `jpt` enum('yes','no') NOT NULL DEFAULT 'no', `created` datetime NOT NULL, `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_periode`), UNIQUE KEY `kode_periode` (`kode_periode`) ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_periode` -- LOCK TABLES `tbl_periode` WRITE; /*!40000 ALTER TABLE `tbl_periode` DISABLE KEYS */; INSERT INTO `tbl_periode` VALUES (1,'PQSHPAZATXUXMAIDLAKUCOVVZ',1609,'198006122010011027','AHMADI BATUBARA, S. Pd',NULL,'III/d','GURU PERTAMA','DINAS PENDIDIKAN DAN KEBUDAYAAN','196311011995121001','Drs. ABBER HAS',NULL,'IV/b','Pengawas Dikmen Dinas Dikbudpora Kab. Padang Lawas','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-09 17:10:18','2022-08-09 17:10:18',NULL), (2,'WOFSPTFZPJHVYFXFWZPGDPLJJ',1572,'198004232008012002','MASDELILAH PULUNGAN',NULL,'III/c','GURU MUDA','DINAS PENDIDIKAN DAN KEBUDAYAAN','196504121987121002','HASANUDDIN NST, S.Pd',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 02:43:28','2022-08-22 02:43:28',NULL), (3,'ZGDAGHKWNOOKANNTJCIFSAWEO',1568,'196405061986042002','NORMINASARI HASIBUAN',NULL,'IV/a','Guru Agama Islam','DINAS PENDIDIKAN DAN KEBUDAYAAN','196504121987121002','HASANUDDIN NST, S.Pd',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 02:44:58','2022-08-22 02:44:58',NULL), (4,'PWBWBNTKMZCNZVGRFXWTIAVHX',1570,'196410251986042003','RAHMITA',NULL,'IV/a','Guru Kelas','DINAS PENDIDIKAN DAN KEBUDAYAAN','196504121987121002','HASANUDDIN NST, S.Pd',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 02:48:23','2022-08-22 02:48:23',NULL), (5,'KJUKOMGRQTHFYGRNKQLBMPMEN',1593,'196310271984041001','INDRAGUNAWAN HASIBUAN',NULL,'IV/a','Guru Mapel','DINAS PENDIDIKAN DAN KEBUDAYAAN','196806011990071001','DARMAN PULUNGAN, S.Pd',NULL,'IV/a','Plt. Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 03:18:33','2022-08-22 03:18:33',NULL), (6,'EYUWNAXRREKGPIEKELCDROESY',1596,'197202052014121001','SARJANA SYAKIR NASUTION',NULL,'III/b','GURU PERTAMA','DINAS PENDIDIKAN DAN KEBUDAYAAN','196806011990071001','DARMAN PULUNGAN, S.Pd',NULL,'IV/a','Plt. Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 03:20:57','2022-08-22 03:20:57',NULL), (7,'HJIQRJKZTDBFPTOPHCYMOPIRH',1595,'198302142005022001','SALMIAH SIREGAR',NULL,'III/d','Guru Kelas','DINAS PENDIDIKAN DAN KEBUDAYAAN','196806011990071001','DARMAN PULUNGAN, S.Pd',NULL,'IV/a','Plt. Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 03:22:04','2022-08-22 03:22:04',NULL), (8,'BLYBFSZTIZHLLSGGWGMHFJWFP',1575,'198302142014122004','DAHLIA UTAMA HASIBUAN',NULL,'III/a','Guru Kelas','DINAS PENDIDIKAN DAN KEBUDAYAAN','196504121987121002','HASANUDDIN NST, S.Pd',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 03:22:05','2022-08-22 03:22:05',NULL), (9,'WEXSAKYQAFTLWXWXAZOVYTLTD',1597,'198411222009042008','PUSPA DAULAY',NULL,'III/b','Guru Kelas','DINAS PENDIDIKAN DAN KEBUDAYAAN','196806011990071001','DARMAN PULUNGAN, S.Pd',NULL,'IV/a','Plt. Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 03:23:09','2022-08-22 03:23:09',NULL), (10,'SLXDDDBIVBBPKPNSLNWWDDINN',1590,'196806011990071001','DARMAN PULUNGAN, S.Pd',NULL,'IV/a','Plt. Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN','196311011995121001','Drs. ABBER HAS',NULL,'IV/b','Pengawas Dikmen Dinas Dikbudpora Kab. Padang Lawas','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 07:30:57','2022-08-22 07:30:57',NULL), (11,'TTRVHOSULMLJQPEHPDFREYTWT',1564,'196504121987121002','HASANUDDIN NST, S.Pd',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN','196311011995121001','Drs. ABBER HAS',NULL,'IV/b','Pengawas Dikmen Dinas Dikbudpora Kab. Padang Lawas','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 07:37:50','2022-08-22 07:37:50',NULL), (12,'SKXKJVRXSJBHMSSYJEDHBWVYF',1569,'196407051986042003','ELLIDA MAHYAR HASIBUAN',NULL,'IV/a','Guru kelas','DINAS PENDIDIKAN DAN KEBUDAYAAN','196504121987121002','HASANUDDIN NST, S.Pd',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 07:58:05','2022-08-22 07:58:05',NULL), (13,'FQTNDJEKQCSBJHCBLCWCOKLDR',739,'197610312007012002','ROSNITA SIREGAR, S.Pd',NULL,'III/c','GURU MUDA','DINAS PENDIDIKAN DAN KEBUDAYAAN','196203061983041005','THAMRIN HASIBUAN',NULL,'IV/a','PERINGATAN ! ! ! Riwayat jabatan tidak ditemukan. ! ! ! ! !','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 11:01:30','2022-08-22 11:01:30',NULL), (14,'NJRYHSLARRRXJYKLNOWFGWNOE',709,'196903151993021001','MARHOT NASUTION, S.Pd',NULL,'IV/a','Guru Madya / Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN','196412101986041005','SURAPATI, S.pd I',NULL,'IV/b','PENGAWAS TK / SD PADA UPTD PENDIDIKAN KEC ULU BARUMUN KAB PADANG LAWAS','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 11:11:22','2022-08-22 11:11:22',NULL), (15,'HVWFPCFSQWFHWGIUZJVOBFRSM',8,'197702062010011010','ABDUL HAKIM HARAHAP, SP',NULL,'III/d','Kabid. Pengadaan, Pemberhentian , Informasi dan Penilaian Kinerja Aparatur','BADAN KEPEGAWAIAN DAN PENGEMBANGAN SUMBER DAYA MANUSIA','198108082009041005','ADI PUTRA HALOMOAN HASIBUAN, S.Si. M.Si',NULL,'IV/a','PERINGATAN ! ! ! Riwayat jabatan tidak ditemukan. ! ! ! ! !','BADAN KEPEGAWAIAN DAN PENGEMBANGAN SUMBER DAYA MANUSIA',2022,NULL,NULL,'no','2022-08-22 12:38:05','2022-08-22 12:38:05',NULL), (16,'GFVZNHJESTNQVJPKPOBNLPBAR',884,'197802062005022002','NUR HIDAYAH, S.Pd.SD',NULL,'III/c','PERINGATAN ! ! ! Riwayat jabatan tidak ditemukan. ! ! ! ! !','DINAS PENDIDIKAN DAN KEBUDAYAAN','197207012008012003','INSAN NASUTION, S.Pd',NULL,'III/c','PERINGATAN ! ! ! Riwayat jabatan tidak ditemukan. ! ! ! ! !','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 12:45:05','2022-08-22 12:45:05',NULL), (17,'KGWDFWCHBCCIPNWFDIGHOBKJX',675,'198107182011011010','HELMI GUNAWAN HARAHAP, M.M.',NULL,'III/d','Pl. INSPEKTUR PEMBANTU WILAYAH III','INSPEKTORAT','197708201995111001','HARJUSLI FAHRI SIREGAR, S.STP.M.SI',NULL,'IV/c','Inspektur Padang Lawas','INSPEKTORAT',2022,NULL,NULL,'no','2022-08-22 13:35:08','2022-08-22 13:35:08',NULL), (18,'ASKNNRUWLIFSZVUPFHZNGRJQT',744,'196901281996121001','MAHMUD NASUTION, S.Pd',NULL,'IV/a','Guru Madya','DINAS PENDIDIKAN DAN KEBUDAYAAN','196412101986041005','SURAPATI, S.pd I',NULL,'IV/b','PENGAWAS TK / SD PADA UPTD PENDIDIKAN KEC ULU BARUMUN KAB PADANG LAWAS','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 14:58:39','2022-08-22 14:58:39',NULL), (19,'FUDVJBVDFEMMZGCFWVXJHDHYA',1061,'196312311983042006','TETTI NIRWANA LUBIS',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN','196311011995121001','Drs. ABBER HAS',NULL,'IV/b','Pengawas Dikmen Dinas Dikbudpora Kab. Padang Lawas','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 15:39:35','2022-08-22 15:39:35',NULL), (20,'QTTSMEFJQIVFAOJRBQIHNBMIO',1065,'198509252009042006','SONIA AFALINA LUBIS, A.Ma.Pd',NULL,'III/c','GURU MUDA','DINAS PENDIDIKAN DAN KEBUDAYAAN','196312311983042006','TETTI NIRWANA LUBIS',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 16:19:36','2022-08-22 16:19:36',NULL), (21,'TPCGRYFAQLWELIRVDYHOEHBGG',1062,'196707102000031002','JUFRI NASUTION, S.Pd',NULL,'III/d','GURU KELAS','DINAS PENDIDIKAN DAN KEBUDAYAAN','196312311983042006','TETTI NIRWANA LUBIS',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 16:21:57','2022-08-22 16:21:57',NULL), (22,'CEMMKWKVGYSWXFEHCYBMBKIRI',1576,'197510122000031005','MUNTIR LAUT SIREGAR',NULL,'II/a','Penjaga Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN','196504121987121002','HASANUDDIN NST, S.Pd',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 16:23:08','2022-08-22 16:23:08',NULL), (23,'JQPDTZOVVBUMZXSTCJTCVQYDJ',1067,'196904111989092001','DERHANA HASIBUAN, SPd.I',NULL,'IV/b','GURU KELAS','DINAS PENDIDIKAN DAN KEBUDAYAAN','196312311983042006','TETTI NIRWANA LUBIS',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 16:25:23','2022-08-22 16:25:23',NULL), (24,'ITNCVQDYCFNRCPDOBAICYUUQH',1264,'196601081988032001','DELINA MURNI HASIBUAN, S.Pd',NULL,'IV/b','GURU KELAS','DINAS PENDIDIKAN DAN KEBUDAYAAN','196801232007012003','Dra. DRA MASSAIMA',NULL,'IV/a','Guru Madya','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 16:28:14','2022-08-22 16:28:14',NULL), (25,'PEABZCFGOWULPGYFPEZBMHSJR',1064,'198410122006042005','OKTA LANNA REZEKI',NULL,'III/b','GURU PERTAMA','DINAS PENDIDIKAN DAN KEBUDAYAAN','196312311983042006','TETTI NIRWANA LUBIS',NULL,'IV/a','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-22 16:34:07','2022-08-22 16:34:07',NULL), (26,'RMYLQJRERVRGZCPUKXTSYCODK',765,'197810042008011001','HUBBAN ANSHORI NASUTION, S.Pd',NULL,'III/d','Guru Kelas','DINAS PENDIDIKAN DAN KEBUDAYAAN','196903172000032004','SUTRIYANI, S.Pd',NULL,'III/d','Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-23 07:59:26','2022-08-23 07:59:26',NULL), (27,'DGDWONBWEBYWUZZUNQQPWGRLT',510,'196605021992031006','PANUSUNAN NST, S.Pd',NULL,'IV/a','GURU pada SDN NO.0304 SIUNDOL','DINAS PENDIDIKAN DAN KEBUDAYAAN','196310101983042002','ROSMALINI PULUNGAN, S.Pd',NULL,'IV/b','Kepala SDN No. 0304 Siundol Kecamatan Sosopan','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-23 08:17:48','2022-08-23 08:17:48',NULL), (28,'KEOPJSJQEEPDSXYVVYSCINYNN',710,'198409052006042006','YUSRO ZAKIAH HASIBUAN',NULL,'III/c','Guru Muda / Guru Kelas','DINAS PENDIDIKAN DAN KEBUDAYAAN','196903151993021001','MARHOT NASUTION, S.Pd',NULL,'IV/a','Guru Madya / Kepala Sekolah','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-08-23 16:45:37','2022-08-23 16:45:37',NULL), (29,'MGQEWWVQFCQQKARZZKXECYUGL',2374,'198610292019031007','MHD. VICTOREA HAREYAN, A.Md.Kep',NULL,'II/c','Perawat Terampil','DINAS KESEHATAN','198007282011011007','dr. AHMAD FAISAL',NULL,'III/d','Kepala Puskesmas Paringgonan','DINAS KESEHATAN',2022,NULL,NULL,'no','2022-08-24 19:37:27','2022-08-24 19:56:44',NULL), (30,'EZUVYYAGLMBMVJFJBTIDIVIDT',2671,'196501301993121001','Ir. ABDULLAH',NULL,'IV/c','STAF AHLI BUPATI BIDANG KEMASYARAKATAN DAN SUMBER DAYA MANUSIA','Sekretariat Daerah','196809131990031001','ARPAN NST, S.Sos',NULL,'IV/d','Sekretaris Daerah','Sekretariat Daerah',2022,NULL,NULL,'no','2022-08-25 03:05:11','2022-08-25 03:05:11',NULL), (31,'HUSOPFGPJMTQXEOYRBJGAQKUT',2673,'196603131986021001','BUSTAMI HARAHAP, S.sos',NULL,'IV/c','STAF AHLI BUPATI BIDANG HUKUM DAN POLITIK','Sekretariat Daerah','196809131990031001','ARPAN NST, S.Sos',NULL,'IV/d','Sekretaris Daerah','Sekretariat Daerah',2022,NULL,NULL,'no','2022-08-25 08:10:49','2022-08-25 08:10:49',NULL), (32,'NATNBVRVIIQNUYVHGEMDNADRV',117,'196806261987031002','HEFRIN SALEH HASIBUAN, SE',NULL,'III/d','Pengawas selaku Pj.Kasubbag Umum dan Kepegawaian','Dinas Pekerjaan Umum','198008072010011021','AMIRHAN HASIBUAN, ST, MM',NULL,'III/d','Plt. Administrator Selaku Sekretaris Dinas Pekerjaan Umum','Dinas Pekerjaan Umum',2022,NULL,NULL,'no','2022-08-30 01:00:20','2022-08-30 01:00:20',NULL), (33,'WDZJJXYOOECXXUEQQXMKDPNCI',1746,'198703172020121007','FAISAL MUSHADY HARAHAP, S.Kom',NULL,'III/a','ANALIS DATA DAN INFORMASI','DINAS KOMUNIKASI DAN INFORMATIKA','198309082011011007','AMRY SEPUTRA, S.Kom',NULL,'III/c','PERINGATAN ! ! ! Riwayat jabatan tidak ditemukan. ! ! ! ! !','DINAS KOMUNIKASI DAN INFORMATIKA',2022,NULL,NULL,'no','2022-09-18 10:52:03','2023-01-25 13:50:34',NULL), (34,'IDOSEGEZTDLOVGJSLIYGONBOL',2,'198108082009041005','ADI PUTRA HALOMOAN HASIBUAN, S.Si. M.Si',NULL,'IV/b','KEPALA BADAN KEPEGAWAIAN DAN PENGEMBANGAN SUMBER DAYA MANUSIA KABUPATEN PADANG LAWAS','BADAN KEPEGAWAIAN DAN PENGEMBANGAN SUMBER DAYA MANUSIA','196809131990031001','ARPAN NST, S.Sos',NULL,'IV/d','Sekretaris Daerah','Sekretariat Daerah',2022,NULL,NULL,'yes','2022-11-13 15:15:16','2022-11-13 15:15:16',NULL), (35,'KXPPBYFVUKOSRAWRQNLZOFPUT',1613,'196810101996012001','YARZUNA NASUTION, S.Pd',NULL,'IV/b','Kepala SMP Negeri 1 Lubuk Barumun','DINAS PENDIDIKAN DAN KEBUDAYAAN','196311011995121001','Drs. ABBER HAS',NULL,'IV/b','Pengawas Dikmen Dinas Dikbudpora Kab. Padang Lawas','DINAS PENDIDIKAN DAN KEBUDAYAAN',2022,NULL,NULL,'no','2022-12-28 04:28:32','2022-12-28 04:28:32',NULL), (36,'NYXADHJUMQUGJQCFBHDHDTNGI',178,'196408202007011034','SUNARMAN, SE',NULL,'III/b','KEPALA KASUBBANG UMUM DAN KEPEGAWAIAN','KANTOR CAMAT SOSA TIMUR','196708201993121001','KARTIM, S.Pd',NULL,'III/d','Plt.Camat Sosa Timur','KANTOR CAMAT SOSA TIMUR',2022,NULL,NULL,'yes','2023-02-21 04:52:34','2023-02-21 04:52:34',NULL), (37,'HEGEQYJEVAALXWVLCPUAXTXZU',127,'198205222010012023','NURHAWA SARI SIREGAR, SE',NULL,'III/d','KASUBBAG UMUM KEPEGAWAIAN','BADAN PENDAPATAN DAERAH','197612302010011010','LUTFI ELPANJIANSYAH, SE',NULL,'III/d','Pj.Sekretaris','BADAN PENDAPATAN DAERAH',2022,NULL,NULL,'no','2023-03-20 09:54:15','2023-03-20 09:54:15',NULL), (38,'JBRJNATVMJQZTAOWKXHNPSCCA',27,'197704082011011002','ACHMAD FAUZAN NASUTION, SH.I, M.Pd.I',NULL,'IV/a','Pejabat Pimpinan Tinggi Pratama Selaku Kepala Dinas Sosial Kabupaten Padang Lawas','DINAS SOSIAL','196809131990031001','ARPAN NST, S.Sos',NULL,'IV/d','Sekretaris Daerah','SEKRETARIAT DAERAH',2022,NULL,NULL,'yes','2023-06-24 05:28:25','2023-06-24 05:28:25',NULL); /*!40000 ALTER TABLE `tbl_periode` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_target` -- DROP TABLE IF EXISTS `tbl_target`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_target` ( `id_target` int(11) NOT NULL AUTO_INCREMENT, `kode_periode` varchar(25) NOT NULL, `kode_target` varchar(25) NOT NULL, `kode_target_atasan` varchar(25) DEFAULT NULL, `kode_target_aspek_atasan` varchar(25) DEFAULT NULL, `rencana_kinerja` text NOT NULL, `created` datetime NOT NULL, `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_target`), UNIQUE KEY `kode_target` (`kode_target`), KEY `fk_kode_periode` (`kode_periode`), CONSTRAINT `fk_kode_periode` FOREIGN KEY (`kode_periode`) REFERENCES `tbl_periode` (`kode_periode`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_target` -- LOCK TABLES `tbl_target` WRITE; /*!40000 ALTER TABLE `tbl_target` DISABLE KEYS */; INSERT INTO `tbl_target` VALUES (1,'IDOSEGEZTDLOVGJSLIYGONBOL','NIXVUKHKKOZHJZNZECOTQIIGC',NULL,NULL,'Mewujudkan ASN yang Profesional','2022-11-13 15:15:54','2022-11-13 15:15:54',NULL), (2,'IDOSEGEZTDLOVGJSLIYGONBOL','QNZTFNZGXMIHONEFLSWAIOOCU',NULL,NULL,'Meningkatnya Kualitas Pelayanan Publik dan Kinerja Penyelenggaraan Pemerintahan','2022-11-13 15:17:20','2022-11-13 15:17:20',NULL); /*!40000 ALTER TABLE `tbl_target` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_target_aspek` -- DROP TABLE IF EXISTS `tbl_target_aspek`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_target_aspek` ( `id_target_aspek` int(11) NOT NULL AUTO_INCREMENT, `kode_target` varchar(25) NOT NULL, `kode_target_aspek` varchar(25) DEFAULT NULL, `aspek` enum('kuantitas','kualitas','waktu') NOT NULL, `indikator` text NOT NULL, `target_min` varchar(20) DEFAULT NULL, `target_max` varchar(20) NOT NULL, `satuan` varchar(30) NOT NULL, `created` datetime NOT NULL, `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `deleted` datetime DEFAULT NULL, PRIMARY KEY (`id_target_aspek`), KEY `fk_kode_target` (`kode_target`), CONSTRAINT `fk_kode_target` FOREIGN KEY (`kode_target`) REFERENCES `tbl_target` (`kode_target`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_target_aspek` -- LOCK TABLES `tbl_target_aspek` WRITE; /*!40000 ALTER TABLE `tbl_target_aspek` DISABLE KEYS */; INSERT INTO `tbl_target_aspek` VALUES (1,'NIXVUKHKKOZHJZNZECOTQIIGC','NTBHEVQGFAKMXJAQFIJULXHAA','kuantitas','Persentase ASN yang memiliki kompetensi sesuai standar',NULL,'85','%','2022-11-13 15:16:20','2022-11-13 15:16:20',NULL), (2,'NIXVUKHKKOZHJZNZECOTQIIGC','QIDHEHFYFXUSXCKQSQTOXXSDM','kuantitas','Persentase ASN dengan Capaian Nilai Kinerja Kategori Baik',NULL,'80','%','2022-11-13 15:16:52','2022-11-13 15:18:51',NULL), (3,'QNZTFNZGXMIHONEFLSWAIOOCU','DRWUOCVCYNNRZSZXPSHWINBWP','kuantitas','Indek Kepuasan Masyarakat (IKM) BKPSDM',NULL,'84,61','index','2022-11-13 15:17:46','2022-11-13 15:17:46',NULL), (4,'QNZTFNZGXMIHONEFLSWAIOOCU','TVTBGLZBEHNQGQTBOWRWYZLRP','kuantitas','Nilai Evaluasi AKIP BKPSDM',NULL,'A','nilai','2022-11-13 15:18:05','2022-11-13 15:18:05',NULL); /*!40000 ALTER TABLE `tbl_target_aspek` ENABLE KEYS */; UNLOCK TABLES; /*!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 2026-08-22 11:44:12