-- MySQL dump 10.13  Distrib 8.0.22, for Win64 (x86_64)
--
-- Host: localhost    Database: keuangan_jayakarta
-- ------------------------------------------------------
-- Server version	5.7.32-0ubuntu0.18.04.1

/*!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 */;
/*!50503 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 */;

--
-- Table structure for table `tb_gaji_pegawai`
--

DROP TABLE IF EXISTS `tb_gaji_pegawai`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_gaji_pegawai` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pegawai_id` int(10) unsigned DEFAULT NULL,
  `nama_tunjangan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nominal` double(20,2) NOT NULL DEFAULT '0.00',
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status_tunjangan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tb_gaji_pegawai_pegawai_id_index` (`pegawai_id`)
) ENGINE=InnoDB AUTO_INCREMENT=336 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_gaji_pegawai`
--

LOCK TABLES `tb_gaji_pegawai` WRITE;
/*!40000 ALTER TABLE `tb_gaji_pegawai` DISABLE KEYS */;
INSERT INTO `tb_gaji_pegawai` VALUES (18,4,'TUNJANGAN JABATAN',500000.00,'Nominal Tetap',NULL,'2020-05-11 03:35:24','2020-05-11 03:35:24'),(19,4,'TUNJANGAN TRANSPORT',650000.00,'Nominal Tetap',NULL,'2020-05-11 03:35:24','2020-05-11 03:35:24'),(20,4,'TUNJANGAN KELUARGA',250000.00,'Nominal Tetap',NULL,'2020-05-11 03:35:24','2020-05-11 03:35:24'),(29,7,'TUNJANGAN JABATAN',500000.00,'Nominal Tetap',NULL,'2020-05-11 03:51:09','2020-05-11 03:51:09'),(30,7,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-11 03:51:09','2020-05-11 03:51:09'),(31,7,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-11 03:51:09','2020-05-11 03:51:09'),(32,7,'TUNJANGAN TUGAS',300000.00,'Nominal Tetap',NULL,'2020-05-11 03:51:09','2020-05-11 03:51:09'),(33,8,'TUNJANGAN JABATAN',500000.00,'Nominal Tetap',NULL,'2020-05-11 03:59:30','2020-05-11 03:59:30'),(34,8,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-11 03:59:30','2020-05-11 03:59:30'),(35,8,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-11 03:59:30','2020-05-11 03:59:30'),(36,8,'TUNJANGAN TUGAS',350000.00,'Nominal Tetap',NULL,'2020-05-11 03:59:30','2020-05-11 03:59:30'),(45,11,'TUNJANGAN JABATAN',1300000.00,'Nominal Tetap',NULL,'2020-05-11 04:08:42','2020-05-11 04:08:42'),(46,11,'TUNJANGAN TRANSPORT',1900000.00,'Nominal Tetap',NULL,'2020-05-11 04:08:42','2020-05-11 04:08:42'),(47,11,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-11 04:08:42','2020-05-11 04:08:42'),(48,11,'TUNJANGAN TUGAS',770000.00,'Nominal Tetap',NULL,'2020-05-11 04:08:42','2020-05-11 04:08:42'),(53,13,'TUNJANGAN JABATAN',440000.00,'Nominal Tetap',NULL,'2020-05-11 04:13:12','2020-05-11 04:13:12'),(54,13,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-11 04:13:12','2020-05-11 04:13:12'),(55,13,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-11 04:13:12','2020-05-11 04:13:12'),(56,13,'TUNJANGAN TUGAS',250000.00,'Nominal Tetap',NULL,'2020-05-11 04:13:12','2020-05-11 04:13:12'),(57,14,'TUNJANGAN JABATAN',450000.00,'Nominal Tetap',NULL,'2020-05-11 04:15:15','2020-05-11 04:15:15'),(58,14,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-11 04:15:15','2020-05-11 04:15:15'),(59,14,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-11 04:15:15','2020-05-11 04:15:15'),(60,14,'TUNJANGAN TUGAS',300000.00,'Nominal Tetap',NULL,'2020-05-11 04:15:15','2020-05-11 04:15:15'),(81,20,'TUNJANGAN TRANSPORT',250000.00,'Nominal Tetap',NULL,'2020-05-11 05:46:07','2020-05-11 05:46:07'),(82,21,'TUNJANGAN JABATAN',1600000.00,'Nominal Tetap',NULL,'2020-05-11 07:19:37','2020-05-11 07:19:37'),(83,21,'TUNJANGAN TRANSPORT',500000.00,'Nominal Tetap',NULL,'2020-05-11 07:19:37','2020-05-11 07:19:37'),(84,21,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-11 07:19:37','2020-05-11 07:19:37'),(85,22,'TUNJANGAN JABATAN',800000.00,'Nominal Tetap',NULL,'2020-05-11 07:27:35','2020-05-11 07:27:35'),(86,22,'TUNJANGAN TRANSPORT',350000.00,'Nominal Tetap',NULL,'2020-05-11 07:27:35','2020-05-11 07:27:35'),(87,22,'TUNJANGAN KELUARGA',100000.00,'Nominal Tetap',NULL,'2020-05-11 07:27:35','2020-05-11 07:27:35'),(88,23,'TUNJANGAN JABATAN',1900000.00,'Nominal Tetap',NULL,'2020-05-11 07:29:48','2020-05-11 07:29:48'),(89,23,'TUNJANGAN TRANSPORT',1700000.00,'Nominal Tetap',NULL,'2020-05-11 07:29:48','2020-05-11 07:29:48'),(90,23,'TUNJANGAN KELUARGA',600000.00,'Nominal Tetap',NULL,'2020-05-11 07:29:48','2020-05-11 07:29:48'),(91,23,'TUNJANGAN TUGAS',900000.00,'Nominal Tetap',NULL,'2020-05-11 07:29:48','2020-05-11 07:29:48'),(96,25,'TUNJANGAN JABATAN',1150000.00,'Nominal Tetap',NULL,'2020-05-11 07:33:38','2020-05-11 07:33:38'),(97,25,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-11 07:33:38','2020-05-11 07:33:38'),(98,25,'TUNJANGAN KELUARGA',250000.00,'Nominal Tetap',NULL,'2020-05-11 07:33:38','2020-05-11 07:33:38'),(99,25,'TUNJANGAN TUGAS',350000.00,'Nominal Tetap',NULL,'2020-05-11 07:33:38','2020-05-11 07:33:38'),(100,26,'TUNJANGAN JABATAN',800000.00,'Nominal Tetap',NULL,'2020-05-11 07:35:44','2020-05-11 07:35:44'),(101,26,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-11 07:35:44','2020-05-11 07:35:44'),(102,26,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-11 07:35:44','2020-05-11 07:35:44'),(103,26,'TUNJANGAN TUGAS',450000.00,'Nominal Tetap',NULL,'2020-05-11 07:35:44','2020-05-11 07:35:44'),(104,27,'TUNJANGAN TRANSPORT',500000.00,'Nominal Tetap',NULL,'2020-05-11 07:37:21','2020-05-11 07:37:21'),(105,27,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-11 07:37:21','2020-05-11 07:37:21'),(115,31,'TUNJANGAN JABATAN',1400000.00,'Nominal Tetap',NULL,'2020-05-11 07:43:55','2020-05-11 07:43:55'),(116,31,'TUNJANGAN TRANSPORT',1900000.00,'Nominal Tetap',NULL,'2020-05-11 07:43:55','2020-05-11 07:43:55'),(117,31,'TUNJANGAN KELUARGA',700000.00,'Nominal Tetap',NULL,'2020-05-11 07:43:55','2020-05-11 07:43:55'),(118,31,'TUNJANGAN TUGAS',800000.00,'Nominal Tetap',NULL,'2020-05-11 07:43:55','2020-05-11 07:43:55'),(123,33,'TUNJANGAN JABATAN',300000.00,'Nominal Tetap',NULL,'2020-05-11 07:48:11','2020-05-11 07:48:11'),(124,33,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-11 07:48:11','2020-05-11 07:48:11'),(125,33,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-11 07:48:11','2020-05-11 07:48:11'),(126,33,'TUNJANGAN TUGAS',370000.00,'Nominal Tetap',NULL,'2020-05-11 07:48:11','2020-05-11 07:48:11'),(131,32,'TUNJANGAN JABATAN',300000.00,'Nominal Tetap',NULL,'2020-05-11 07:55:20','2020-05-11 07:55:20'),(132,32,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-11 07:55:20','2020-05-11 07:55:20'),(133,32,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-11 07:55:20','2020-05-11 07:55:20'),(134,32,'TUNJANGAN TUGAS',370000.00,'Nominal Tetap',NULL,'2020-05-11 07:55:20','2020-05-11 07:55:20'),(154,1,'TUNJANGAN JABATAN',900000.00,'Nominal Tetap',NULL,'2020-05-11 08:35:49','2020-05-11 08:35:49'),(155,1,'TUNJANGAN TRANSPORT',500000.00,'Nominal Tetap',NULL,'2020-05-11 08:35:49','2020-05-11 08:35:49'),(156,1,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-11 08:35:49','2020-05-11 08:35:49'),(157,2,'TUNJANGAN JABATAN',1100000.00,'Nominal Tetap',NULL,'2020-05-12 23:27:06','2020-05-12 23:27:06'),(158,2,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-12 23:27:06','2020-05-12 23:27:06'),(159,2,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:27:06','2020-05-12 23:27:06'),(160,2,'TUNJANGAN TUGAS',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:27:06','2020-05-12 23:27:06'),(161,2,'TUNJANGAN HARI RAYA',5240000.00,'Nominal Tetap',NULL,'2020-05-12 23:27:06','2020-05-12 23:27:06'),(162,3,'TUNJANGAN JABATAN',500000.00,'Nominal Tetap',NULL,'2020-05-12 23:36:19','2020-05-12 23:36:19'),(163,3,'TUNJANGAN TRANSPORT',650000.00,'Nominal Tetap',NULL,'2020-05-12 23:36:19','2020-05-12 23:36:19'),(164,3,'TUNJANGAN KELUARGA',250000.00,'Nominal Tetap',NULL,'2020-05-12 23:36:19','2020-05-12 23:36:19'),(165,3,'TUNJANGAN HARI RAYA',2400000.00,'Nominal Tetap',NULL,'2020-05-12 23:36:19','2020-05-12 23:36:19'),(166,5,'TUNJANGAN JABATAN',750000.00,'Nominal Tetap',NULL,'2020-05-12 23:37:11','2020-05-12 23:37:11'),(167,5,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-12 23:37:11','2020-05-12 23:37:11'),(168,5,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:37:11','2020-05-12 23:37:11'),(169,5,'TUNJANGAN TUGAS',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:37:11','2020-05-12 23:37:11'),(170,5,'TUNJANGAN HARI RAYA',4600000.00,'Nominal Tetap',NULL,'2020-05-12 23:37:11','2020-05-12 23:37:11'),(171,6,'TUNJANGAN JABATAN',600000.00,'Nominal Tetap',NULL,'2020-05-12 23:37:46','2020-05-12 23:37:46'),(172,6,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-12 23:37:46','2020-05-12 23:37:46'),(173,6,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:37:46','2020-05-12 23:37:46'),(174,6,'TUNJANGAN TUGAS',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:37:46','2020-05-12 23:37:46'),(175,6,'TUNJANGAN HARI RAYA',4500000.00,'Nominal Tetap',NULL,'2020-05-12 23:37:46','2020-05-12 23:37:46'),(176,9,'TUNJANGAN JABATAN',1000000.00,'Nominal Tetap',NULL,'2020-05-12 23:38:29','2020-05-12 23:38:29'),(177,9,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-12 23:38:29','2020-05-12 23:38:29'),(178,9,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:38:29','2020-05-12 23:38:29'),(179,9,'TUNJANGAN TUGAS',450000.00,'Nominal Tetap',NULL,'2020-05-12 23:38:29','2020-05-12 23:38:29'),(180,9,'TUNJANGAN HARI RAYA',4930000.00,'Nominal Tetap',NULL,'2020-05-12 23:38:29','2020-05-12 23:38:29'),(181,10,'TUNJANGAN JABATAN',750000.00,'Nominal Tetap',NULL,'2020-05-12 23:39:15','2020-05-12 23:39:15'),(182,10,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-12 23:39:15','2020-05-12 23:39:15'),(183,10,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:39:15','2020-05-12 23:39:15'),(184,10,'TUNJANGAN TUGAS',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:39:15','2020-05-12 23:39:15'),(185,10,'TUNJANGAN HARI RAYA',4600000.00,'Nominal Tetap',NULL,'2020-05-12 23:39:15','2020-05-12 23:39:15'),(186,12,'TUNJANGAN JABATAN',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:39:59','2020-05-12 23:39:59'),(187,12,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-12 23:39:59','2020-05-12 23:39:59'),(188,12,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:39:59','2020-05-12 23:39:59'),(189,12,'TUNJANGAN TUGAS',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:39:59','2020-05-12 23:39:59'),(190,12,'TUNJANGAN HARI RAYA',4350000.00,'Nominal Tetap',NULL,'2020-05-12 23:39:59','2020-05-12 23:39:59'),(191,15,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-12 23:40:46','2020-05-12 23:40:46'),(192,15,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:40:46','2020-05-12 23:40:46'),(193,15,'TUNJANGAN TUGAS',250000.00,'Nominal Tetap',NULL,'2020-05-12 23:40:46','2020-05-12 23:40:46'),(194,15,'TUNJANGAN HARI RAYA',3170000.00,'Nominal Tetap',NULL,'2020-05-12 23:40:46','2020-05-12 23:40:46'),(195,18,'TUNJANGAN JABATAN',50000.00,'Nominal Tetap',NULL,'2020-05-12 23:41:22','2020-05-12 23:41:22'),(196,18,'TUNJANGAN TRANSPORT',600000.00,'Nominal Tetap',NULL,'2020-05-12 23:41:22','2020-05-12 23:41:22'),(197,18,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:41:22','2020-05-12 23:41:22'),(198,18,'TUNJANGAN TUGAS',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:41:22','2020-05-12 23:41:22'),(199,18,'LEMBUR',700000.00,'Nominal Tetap',NULL,'2020-05-12 23:41:22','2020-05-12 23:41:22'),(200,18,'TUNJANGAN HARI RAYA',2250000.00,'Nominal Tetap',NULL,'2020-05-12 23:41:22','2020-05-12 23:41:22'),(201,17,'TUNJANGAN TRANSPORT',700000.00,'Nominal Tetap',NULL,'2020-05-12 23:42:13','2020-05-12 23:42:13'),(202,17,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:42:13','2020-05-12 23:42:13'),(203,17,'TUNJANGAN TUGAS',250000.00,'Nominal Tetap',NULL,'2020-05-12 23:42:13','2020-05-12 23:42:13'),(204,17,'TUNJANGAN HARI RAYA',1800000.00,'Nominal Tetap',NULL,'2020-05-12 23:42:13','2020-05-12 23:42:13'),(205,16,'TUNJANGAN JABATAN',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:42:46','2020-05-12 23:42:46'),(206,16,'TUNJANGAN TRANSPORT',700000.00,'Nominal Tetap',NULL,'2020-05-12 23:42:46','2020-05-12 23:42:46'),(207,16,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:42:46','2020-05-12 23:42:46'),(208,16,'TUNJANGAN TUGAS',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:42:46','2020-05-12 23:42:46'),(209,16,'LEMBUR',165000.00,'Nominal Tetap',NULL,'2020-05-12 23:42:46','2020-05-12 23:42:46'),(210,16,'TUNJANGAN HARI RAYA',2200000.00,'Nominal Tetap',NULL,'2020-05-12 23:42:46','2020-05-12 23:42:46'),(211,19,'TUNJANGAN TRANSPORT',550000.00,'Nominal Tetap',NULL,'2020-05-12 23:43:28','2020-05-12 23:43:28'),(212,19,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:43:28','2020-05-12 23:43:28'),(213,19,'TUNJANGAN TUGAS',250000.00,'Nominal Tetap',NULL,'2020-05-12 23:43:28','2020-05-12 23:43:28'),(214,19,'TUNJANGAN HARI RAYA',1800000.00,'Nominal Tetap',NULL,'2020-05-12 23:43:28','2020-05-12 23:43:28'),(215,24,'TUNJANGAN JABATAN',1100000.00,'Nominal Tetap',NULL,'2020-05-12 23:44:21','2020-05-12 23:44:21'),(216,24,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-12 23:44:21','2020-05-12 23:44:21'),(217,24,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:44:21','2020-05-12 23:44:21'),(218,24,'TUNJANGAN TUGAS',350000.00,'Nominal Tetap',NULL,'2020-05-12 23:44:21','2020-05-12 23:44:21'),(219,24,'TUNJANGAN HARI RAYA',5220000.00,'Nominal Tetap',NULL,'2020-05-12 23:44:21','2020-05-12 23:44:21'),(220,28,'TUNJANGAN JABATAN',1600000.00,'Nominal Tetap',NULL,'2020-05-12 23:45:05','2020-05-12 23:45:05'),(221,28,'TUNJANGAN TRANSPORT',1900000.00,'Nominal Tetap',NULL,'2020-05-12 23:45:05','2020-05-12 23:45:05'),(222,28,'TUNJANGAN KELUARGA',750000.00,'Nominal Tetap',NULL,'2020-05-12 23:45:05','2020-05-12 23:45:05'),(223,28,'TUNJANGAN TUGAS',950000.00,'Nominal Tetap',NULL,'2020-05-12 23:45:05','2020-05-12 23:45:05'),(224,28,'TUNJANGAN HARI RAYA',9880000.00,'Nominal Tetap',NULL,'2020-05-12 23:45:05','2020-05-12 23:45:05'),(227,30,'TUNJANGAN JABATAN',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:46:32','2020-05-12 23:46:32'),(228,30,'TUNJANGAN TRANSPORT',1500000.00,'Nominal Tetap',NULL,'2020-05-12 23:46:32','2020-05-12 23:46:32'),(229,30,'TUNJANGAN KELUARGA',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:46:32','2020-05-12 23:46:32'),(230,30,'TUNJANGAN TUGAS',300000.00,'Nominal Tetap',NULL,'2020-05-12 23:46:32','2020-05-12 23:46:32'),(231,30,'TUNJANGAN HARI RAYA',4350000.00,'Nominal Tetap',NULL,'2020-05-12 23:46:32','2020-05-12 23:46:32'),(242,36,'TUNJANGAN JABATAN',100000.00,'Nominal Tetap',NULL,'2020-05-12 23:49:30','2020-05-12 23:49:30'),(243,36,'TUNJANGAN TRANSPORT',700000.00,'Nominal Tetap',NULL,'2020-05-12 23:49:30','2020-05-12 23:49:30'),(244,36,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:49:30','2020-05-12 23:49:30'),(245,36,'TUNJANGAN TUGAS',250000.00,'Nominal Tetap',NULL,'2020-05-12 23:49:30','2020-05-12 23:49:30'),(246,36,'LEMBUR',700000.00,'Nominal Tetap',NULL,'2020-05-12 23:49:30','2020-05-12 23:49:30'),(247,36,'TUNJANGAN HARI RAYA',2630000.00,'Nominal Tetap',NULL,'2020-05-12 23:49:30','2020-05-12 23:49:30'),(248,37,'TUNJANGAN JABATAN',100000.00,'Nominal Tetap',NULL,'2020-05-12 23:51:37','2020-05-12 23:51:37'),(249,37,'TUNJANGAN TRANSPORT',700000.00,'Nominal Tetap',NULL,'2020-05-12 23:51:37','2020-05-12 23:51:37'),(250,37,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:51:37','2020-05-12 23:51:37'),(251,37,'TUNJANGAN TUGAS',400000.00,'Nominal Tetap',NULL,'2020-05-12 23:51:37','2020-05-12 23:51:37'),(252,37,'LEMBUR',725000.00,'Nominal Tetap',NULL,'2020-05-12 23:51:37','2020-05-12 23:51:37'),(253,37,'TUNJANGAN HARI RAYA',2815000.00,'Nominal Tetap',NULL,'2020-05-12 23:51:37','2020-05-12 23:51:37'),(254,38,'TUNJANGAN JABATAN',150000.00,'Nominal Tetap',NULL,'2020-05-12 23:52:08','2020-05-12 23:52:08'),(255,38,'TUNJANGAN TRANSPORT',650000.00,'Nominal Tetap',NULL,'2020-05-12 23:52:08','2020-05-12 23:52:08'),(256,38,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:52:08','2020-05-12 23:52:08'),(257,38,'TUNJANGAN TUGAS',200000.00,'Nominal Tetap',NULL,'2020-05-12 23:52:08','2020-05-12 23:52:08'),(258,38,'LEMBUR',700000.00,'Nominal Tetap',NULL,'2020-05-12 23:52:08','2020-05-12 23:52:08'),(259,38,'TUNJANGAN HARI RAYA',2430000.00,'Nominal Tetap',NULL,'2020-05-12 23:52:08','2020-05-12 23:52:08'),(314,39,'TUNJANGAN TRANSPORT',500000.00,'Nominal Tetap',NULL,'2020-10-10 08:03:31','2020-10-10 08:03:31'),(325,34,'TUNJANGAN JABATAN',400000.00,'Nominal Tetap',NULL,'2020-10-24 18:45:07','2020-10-24 18:45:07'),(326,34,'TUNJANGAN TRANSPORT',1000000.00,'Nominal Tetap',NULL,'2020-10-24 18:45:07','2020-10-24 18:45:07'),(327,34,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-10-24 18:45:07','2020-10-24 18:45:07'),(328,34,'TUNJANGAN TUGAS',300000.00,'Nominal Tetap',NULL,'2020-10-24 18:45:07','2020-10-24 18:45:07'),(329,34,'LEMBUR',2915550.00,'Nominal Tetap',NULL,'2020-10-24 18:45:07','2020-10-24 18:45:07'),(330,29,'TUNJANGAN TRANSPORT',500000.00,'Nominal Tetap',NULL,'2020-10-24 18:45:42','2020-10-24 18:45:42'),(331,35,'TUNJANGAN JABATAN',350000.00,'Nominal Tetap',NULL,'2020-10-24 18:46:21','2020-10-24 18:46:21'),(332,35,'TUNJANGAN TRANSPORT',750000.00,'Nominal Tetap',NULL,'2020-10-24 18:46:21','2020-10-24 18:46:21'),(333,35,'TUNJANGAN KELUARGA',200000.00,'Nominal Tetap',NULL,'2020-10-24 18:46:21','2020-10-24 18:46:21'),(334,35,'TUNJANGAN TUGAS',200000.00,'Nominal Tetap',NULL,'2020-10-24 18:46:21','2020-10-24 18:46:21'),(335,35,'LEMBUR',413500.00,'Nominal Tetap',NULL,'2020-10-24 18:46:21','2020-10-24 18:46:21');
/*!40000 ALTER TABLE `tb_gaji_pegawai` 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 2020-12-07 11:34:03
