PERANCANGAN SISTEM INFORMASI MANAJEMEN RUMAH SAKIT MODUL HUMAN RESOURCE DEVELOPMENT DAN PAYROLL (STUDI KASUS RUMAH SAKIT PTN UDAYANA)
TUGAS AKHIR Diajukan guna memenuhi sebagian persyaratan dalam rangka menyelesaikan Pendidikan Sarjana Strata Satu (S1) Program Studi Teknologi Informasi
ANAK AGUNG PRIMANINGRAT GITA PUSPITA NIM. 1104505066
JURUSAN TEKNOLOGI INFORMASI FAKULTAS TEKNIK UNIVERSITAS UDAYANA 2015
PERNYATAAN
Dengan ini saya menyatakan bahwa dalam tugas akhir ini tidak terdapat karya yang pernah diajukan untuk memperoleh gelar kesarjanaan di suatu perguruan tinggi dan sepanjang pengetahuan saya juga tidak terdapat karya atau pendapat yang pernah ditulis atau diterbitkan oleh orang lain, kecuali yang secara tertulis diacu dalam naskah ini dan disebutkan dalam daftar pustaka.
Denpasar, Juni 2015
Anak Agung Primaningrat Gita Puspita
ii
KATA PENGANTAR
Puji syukur ke hadirat Tuhan Yang Maha Esa, karena atas rahmat-Nya tugas akhir yang berjudul ”Perancangan Sistem Informasi Manajemen Rumah Sakit Modul Human Resource Development dan Payroll (Studi Kasus Rumah Sakit PTN Udayana)” ini dapat terselesaikan. Hambatan yang ditemui dapat dilewati berkat dukungan dari berbagai pihak, terima kasih disampaikan kepada: 1.
Bapak Prof. Ir. Ngakan Putu Gede Suardana, M.T.,Ph.D, selaku Dekan Fakultas Teknik Universitas Udayana.
2.
Bapak Dr. Eng. I Putu Agung Bayupati, S.T., M.T. selaku Ketua Jurusan Teknologi Informasi Fakultas Teknik Universitas Udayana.
3.
Bapak I Made Sukarsa, S.T., M.T., selaku Dosen Pembimbing I dan Bapak A.A. Kompiang Oka Sudana, S.Kom., M.T. selaku Dosen Pembimbing II yang telah memberikan bimbingan dalam penyelesaian tugas akhir ini.
4.
Bapak I Ketut Adi Purnawan, S.T., M.Eng., selaku Dosen Pembimbing Akademik, Bapak/Ibu dosen pengajar dan pegawai di Jurusan Teknologi Informasi yang telah membimbing dan membantu selama perkuliahan.
5.
Pihak Manajemen Rumah Sakit PTN UNUD dan RSUD Badung Bagian Kepegawaian yang telah memberi informasi mengenai SIMRS.
6.
Rekan TA SIMRS Kevin, Tantoni, Alit, Erna, dan Primanggara serta rekan perkuliahan Dharmawan, Sundari, Mentari, Febe, Adi, Yudi, Anindya, Putri, Dhanan, dan segenap civitas TI lainnya.
7.
Orang tua dan saudari yang telah memberi dukungan moral dan materi.
Semoga laporan ini dapat bermanfaat dalam pengembangan ilmu pengetahuan dan teknologi kepada khalayak luas. Denpasar, Juni 2015
Anak Agung Primaningrat Gita Puspita
v
ABSTRAK
Sumber daya manusia pada Rumah Sakit Pendidikan terdiri dari berbagai bidang keilmuan dan profesi yang dibedakan menjadi Tenaga Medis dan Non Medis. Sistem Informasi Manajemen Modul Kepegawaian diperlukan untuk mempercepat pengolahan data kepegawaian dan memudahkan pihak manajemen dalam pengambilan keputusan. Modul Kepegawaian juga perlu terintegrasi dengan Modul Payroll untuk memudahkan proses penggajian dan remunerasi di rumah sakit. Tahap pembuatan rancangan sistem dilakukan dengan metode TAS (Total Architecture Syntesis), yaitu penentuan initial scope, penentuan kebutuhan, penentuan bisnis proses, perancangan sistem, dan evaluasi. Modul Human Resource Development berisi proses pendataan, perpindahan, penilaian kinerja, absensi, penjadwalan kerja, penerimaan pegawai, hingga pelaporan kepegawaian. Modul Payroll berisi proses penggajian dan remunerasi. Perancangan ini dibuat dalam bentuk Diagram Alir Data, Struktur Basisdata, dan Desain User Interface. Rancangan ini dapat dijadikan pedoman bagi programmer dalam pembuatan Sistem Informasi Rumah Sakit yang terintegrasi. Kata Kunci: Sistem Informasi Rumah Sakit, Total Architecture Syntesis, Kepegawaian, Penggajian
vi
ABSTRACT
Human resources at the hospital consists of many kind of disciplines and professions that can be divided into Medical and Non-Medical Personnel. Management Information System Human Resource Development Module needed to accelerate and facilitate the processing of employee data and helpful for management decision making. The module also needs to be integrated with the Payroll Module to facilitate the process of Payroll and remuneration in the hospital. Stage of the system design was conducted by TAS (Total Architecture Syntesis), they are the determination of initial scope, determination of needs, determination of business processes, system design, and evaluation. Human Resource Development Module contains the data collection process, transfer, performance assessment, absences, schedulin, hiring, and reporting. Payroll module contains Payroll and remuneration. This work described by Data Flow Diagrams, Database Structure, and User Interface Design. This design can be used as guidelines for programmers in the manufacture of Hospital Information System are integrated. Keywords: Hospital Information System, Total Architecture Syntesis, Human Resource Development, Payroll
vii
DAFTAR ISI
HALAMAN JUDUL .............................................................................................. i PERNYATAAN ..................................................................................................... ii LEMBAR PENGESAHAN TUGAS AKHIR .................................................... iii BERITA ACARA TUGAS AKHIR .................................................................... iv KATA PENGANTAR ........................................................................................... v ABSTRAK ............................................................................................................ vi ABSTRACT ......................................................................................................... vii DAFTAR ISI ....................................................................................................... viii DAFTAR GAMBAR ............................................................................................. x DAFTAR TABEL .............................................................................................. xiii BAB I PENDAHULUAN ...................................................................................... 1 1.1 Latar Belakang ......................................................................................... 1 1.2 Rumusan Masalah .................................................................................... 2 1.3 Batasan Masalah ....................................................................................... 2 1.4 Tujuan ....................................................................................................... 3 1.5 Manfaat ..................................................................................................... 3 1.6 Sistematika Penulisan ............................................................................... 4 BAB II TINJAUAN PUSTAKA........................................................................... 5 2.1 State of the Art .......................................................................................... 5 2.2 Pengertian Rumah Sakit Perguruan Tinggi .............................................. 7 2.3 Profil Rumah Sakit Perguruan Tinggi Negeri Universitas Udayana ........ 8 2.3.1 Visi Misi Rumah Sakit PTN Universitas Udayana ........................... 8 2.4 Pokok-pokok Kepegawaian .................................................................... 10 2.4.1 Manajeman Kepangkatan PNS ....................................................... 10 2.4.2 Manajemen Daftar Urut Kepangkatan ............................................ 21 2.4.3 Manajemen Penilaian Kinerja PNS ................................................. 22 2.4.4 Manajemen Pengangkatan Jabatan ................................................. 27 2.4.5 Manajemen Cuti PNS...................................................................... 31 2.4.6 Manajemen Gaji Berkala................................................................. 34 2.4.7 Eselonisasi ....................................................................................... 35 2.5 Sistem Informasi Human Resource Development .................................. 35 2.6 Sistem Informasi Manajemen ................................................................. 36 2.7 Gaji dan Upah ......................................................................................... 37 2.7.1 Dasar Pengenaan Pajak Penghasilan 21 .......................................... 38 2.7.2 Tunjangan Kinerja Tenaga Kesehatan ............................................ 42 2.7.3 Penghasilan Tidak Kena Pajak ........................................................ 49 2.7.4 Tarif Pajak Penghasilan Pasal 21 .................................................... 50 2.8 Badan Penyelenggara Jaminan Sosial (BPJS) ........................................ 51 2.8.1 Jaminan Hari Tua (JHT).................................................................. 51 2.8.2 Jaminan Kecelakaan Kerja (JKK) ................................................... 52 2.8.3 Jaminan Kematian (JK) ................................................................... 53 2.8.4 Jaminan Kesehatan (BPJS Kesehatan) ............................................ 53 2.9 Remunerasi ............................................................................................. 54 viii
2.10 Perangkat Pemodelan Sistem Informasi ................................................. 55 2.10.1 Data Flow Diagram ........................................................................ 55 2.10.2 Entity Relational Diagram .............................................................. 58 2.11 Standar Operating Procedure ................................................................ 61 2.11.1 Flowmap.......................................................................................... 62 2.11.2 Simbol-simbol Flowmap ................................................................. 63 2.12 Tipe Data MYSQL ................................................................................. 64 2.13 Metode Peracangan TAS (Total Architecture Syntesis) ......................... 66 BAB III METODE PENELITIAN DAN PENGUMPULAN DATA .............. 67 3.1 Alur Penelitian ........................................................................................ 67 3.2 Tempat dan Waktu Penelitian ................................................................ 69 3.3 Data ........................................................................................................ 70 3.3.1 Sumber Data .................................................................................... 70 3.3.2 Jenis Data ........................................................................................ 70 3.3.3 Metode Pengumpulan Data ............................................................. 70 3.4 Perangkat Pemodelan Sistem ................................................................. 71 3.5 Analisis Sistem yang Berjalan di Rumah Sakit ...................................... 71 3.5.1 Analisis Dokumen ........................................................................... 71 3.5.2 SOP yang Berjalan di Rumah Sakit Negeri .................................... 74 BAB IV PERANCANGAN SISTEM................................................................. 80 4.1 Gambaran Umum SIMRS ...................................................................... 80 4.1.1 Diagram Konteks SIMRS ............................................................... 90 4.1.2 Overview Diagram SIMRS ............................................................. 92 4.2 Statement of Purpose Subsistem Human Resource Development ......... 94 4.2.1 SOP (Standard Operating Procedure) Sistem Informasi HRD ...... 94 4.2.2 Data Flow Diagram (DFD) Subsistem HRD ............................... 129 4.3 Statement of Purpose Subsistem Payroll ............................................. 153 4.3.1 SOP (Standard Operating Procedure) SIM Payroll..................... 153 4.3.2 Data Flow Diagram (DFD) Subsistem Payroll ............................. 170 4.4 Perancangan Database ......................................................................... 181 4.4.1 Entity Relational Diagram ............................................................ 181 4.4.2 Normalisasi ................................................................................... 185 4.4.3 Struktur Data ................................................................................. 190 4.4.4 Physical Data Model ..................................................................... 256 4.4.5 Desain User Interface ................................................................... 265 BAB V SIMPULAN DAN SARAN .................................................................. 271 5.1 Simpulan ............................................................................................... 271 5.2 Saran ..................................................................................................... 272 DAFTAR PUSTAKA ........................................................................................ 273 CURICULUM VITAE ...................................................................................... 276
ix
DAFTAR GAMBAR
Gambar 2.1 Struktur Organisasi Rumah Sakit PTN Universitas Udayana ............. 9 Gambar 2.2 Contoh Diagram Konteks Sistem Informasi ..................................... 56 Gambar 2.3 Notasi Entitas ERD ........................................................................... 58 Gambar 2.4 Notasi Atribut ERD ........................................................................... 58 Gambar 2.5 Contoh Penggunaan Atribut .............................................................. 59 Gambar 2.6 Notasi Relasi ERD ............................................................................ 59 Gambar 2.7 Relasi Satu ke Satu ............................................................................ 60 Gambar 2.8 Relasi Satu ke Banyak ....................................................................... 60 Gambar 2.9 Relasi Banyak ke Banyak .................................................................. 61 Gambar 3.1 Flowchart Langkah Penelitian .......................................................... 68 Gambar 3.2 Metode TAS ...................................................................................... 69 Gambar 3.3 SOP Usulan Kebutuhan Pegawai ...................................................... 74 Gambar 3.4 SOP Pendataan Pegawai.................................................................... 75 Gambar 3.5 SOP Kenaikan Pangkat ..................................................................... 76 Gambar 3.6 SOP Kenaikan Gaji Berkala .............................................................. 77 Gambar 3.7 SOP Diklat ........................................................................................ 78 Gambar 3.8 SOP Penilaian Kinerja ....................................................................... 79 Gambar 4.1 Diagram Blok SIMRS ....................................................................... 81 Gambar 4.2 Blok Diagram Integrasi Data SIMRS ............................................... 89 Gambar 4.3 Diagram Konteks Umum SIMRS ..................................................... 91 Gambar 4.4 Overvie Diagram SIMRS .................................................................. 93 Gambar 4.5 SOP Pengajuan Kebutuhan Pegawai ................................................. 95 Gambar 4.6 SOP Mutasi internal .......................................................................... 96 Gambar 4.7 SOP Pengajuan Kebutuhan SDM ke Rektorat .................................. 97 Gambar 4.8 SOP Permohonan Penerimaan Pegawai ............................................ 98 Gambar 4.9 SOP Pendataan Calon Pegawai ......................................................... 99 Gambar 4.10 SOP Seleksi Calon Pegawai .......................................................... 100 Gambar 4.11 SOP Penerimaan Pegawai Baru .................................................... 101 Gambar 4.12 SOP Orientasi Pegawai ................................................................. 102 Gambar 4.13 SOP Penempatan Pegawai ............................................................ 103 Gambar 4.14 SOP Pengangkatan CPNS ............................................................. 104 Gambar 4.15 SOP Pengangkatan PNS ................................................................ 105 Gambar 4.16 SOP Pendataan Pegawai................................................................ 106 Gambar 4.17 SOP Permohonan Kenaikan Pangkat ............................................ 107 Gambar 4.18 SOP Kenaikan Pangkat ................................................................. 108 Gambar 4.19 SOP Permohonan Cuti .................................................................. 109 Gambar 4.20 SOP Konfirmasi Cuti .................................................................... 110 Gambar 4.21 SOP Konfirmasi Cuti .................................................................... 112 Gambar 4.22 Konfirmasi Cuti Bersalin .............................................................. 113 Gambar 4.23 Konfirmasi Cuti Alasan Penting ................................................... 114 x
Gambar 4.24 Konfirmasi Cuti Alasan Penting ................................................... 115 Gambar 4.25 SOP Kenaikan Gaji Berkala .......................................................... 116 Gambar 4.26 SOP Pengajuan SKP ..................................................................... 117 Gambar 4.27 SOP Penilaian DP3 ....................................................................... 118 Gambar 4.28 SOP Penetapan Angka Kredit ....................................................... 119 Gambar 4.29 SOP Pelatihan ................................................................................ 120 Gambar 4.30 SOP Pencatatan Pelatihan ............................................................. 121 Gambar 4.31 SOP Izin Belajar ............................................................................ 122 Gambar 4.32 SOP Penjadwalan Kerja ................................................................ 123 Gambar 4.33 SOP Absensi.................................................................................. 124 Gambar 4.34 SOP Pensiun .................................................................................. 125 Gambar 4.35 SOP Pengunduran Diri .................................................................. 127 Gambar 4.36 SOP Pemecatan ............................................................................. 128 Gambar 4.37 Diagram Konteks Subsistem HRD................................................ 129 Gambar 4.38 Bagan Bejenjang Subsistem HRD ................................................ 132 Gambar 4.39 Overview Diagram Subsistem HRD ............................................. 134 Gambar 4.40 DFD Level 1 Manajemen Data Pegawai ....................................... 136 Gambar 4.41 DFD Level 1 Manajemen Riwayat Pegawai ................................. 137 Gambar 4.42 DFD Level 1 Mutasi Pegawai ....................................................... 138 Gambar 4.43 DFD Level 1 Penilaian Kinerja ..................................................... 139 Gambar 4.44 DFD Level 1 Penjadwalan Kerja dan Absensi .............................. 140 Gambar 4.45 DFD Level 1 Pelaporan ................................................................. 142 Gambar 4.46 DFD Level 1 Penerimaan Pegawai ................................................ 143 Gambar 4.47 DFD Level 2 Mutasi Status ........................................................... 144 Gambar 4.48 DFD Level 2 Mutasi Pangkat ........................................................ 144 Gambar 4.49 Diagram Level 2 Mutasi Gaji Berkala ........................................... 145 Gambar 4.50 DFD Level 2 Mutasi Jabatan ......................................................... 145 Gambar 4.51 DFD Level 2 Mutasi ...................................................................... 146 Gambar 4.52 DFD Level 2 Penilaian Prestasi Kerja ........................................... 147 Gambar 4.53 DFD Level 2 Penilaian Angka Kredit ........................................... 147 Gambar 4.54 DFD Level 2 Pencatatan Sanksi dan Pelanggaran ......................... 148 Gambar 4.55 DFD Level 2 Penjadwalan Kerja ................................................... 149 Gambar 4.56 DFD Level 2 Absensi .................................................................... 149 Gambar 4.57 DFD Level 2 Cuti .......................................................................... 150 Gambar 4.58 DFD Level 2 Izin ........................................................................... 150 Gambar 4.59 DFD Level 3 Mutasi Internal ......................................................... 151 Gambar 4.60 DFD Level 3 Mutasi Eksternal ...................................................... 151 Gambar 4.61 DFD Level 3 Pengunduran Diri ..................................................... 152 Gambar 4.62 DFD Level 3 Pemecatan ................................................................ 152 Gambar 4.63 SOP Input Grade Gaji ................................................................... 153 Gambar 4.64 SOP Input Upah Lembur ............................................................... 156 Gambar 4.65 SOP Premi BPJS ........................................................................... 158 Gambar 4.66 SOP Perhitungan Score Index Poin ............................................... 159 Gambar 4.67 SOP Remunerasi ........................................................................... 162 Gambar 4.68 SOP Penggajian ............................................................................. 164 Gambar 4.69 SOP Pajak ...................................................................................... 167 xi
Gambar 4.70 Contoh Pajak Dokter ..................................................................... 168 Gambar 4.71 SOP Rekonsiliasi ........................................................................... 169 Gambar 4.72 Diagram Konteks Subsistem Payroll ............................................ 170 Gambar 4.73 Diagram Berjenjang Subsistem Payroll ........................................ 172 Gambar 4.74 Overview Diagram Subsistem Payroll .......................................... 173 Gambar 4.75 DFD Level 1 Manajemen Data Master .......................................... 174 Gambar 4.76 DFD Level 1 Penggajian ............................................................... 175 Gambar 4.77 DFD Level 1 Perampungan ........................................................... 176 Gambar 4.78 DFD Level 1 Pelaporan ................................................................. 177 Gambar 4.79 DFD Level 2 Manajemen Gaji Pokok ........................................... 178 Gambar 4.80 DFD Level 2 Remunerasi .............................................................. 178 Gambar 4.81 DFD Level 2 Penggajian ............................................................... 179 Gambar 4.82 DFD Level 2 Perampungan SPT ................................................... 180 Gambar 4.83 DFD Level 3 Perhitungan Gaji Tetap ........................................... 181 Gambar 4.84 DFD Level 3 Perhitungan Lembur ................................................ 181 Gambar 4.85 ERD Subsistem HRD Rumah Sakit .............................................. 183 Gambar 4.86 Entity Relational Diagram Payroll ................................................ 184 Gambar 4.87 Tahap 1NF Normalisasi Tabel m_pegawai ................................... 185 Gambar 4.88 Normalisasi 2NF Tabel m_pegawai .............................................. 186 Gambar 4.89 Normalisasi 1NF Tabel m_pendidikan ......................................... 187 Gambar 4.90 Normalisasi 2NF Tabel m_pendidikan ......................................... 187 Gambar 4.91 Normalisasi 1NF Tabel tb_riwayat_keluarga ............................... 187 Gambar 4.92 Normalisasi 2NF Tabel tb_riwayat_keluarga ............................... 188 Gambar 4.93 Normalisasi 1NF Tabel m_diklat .................................................. 188 Gambar 4.94 Normalisasi 2NF Tabel m_diklat ................................................. 189 Gambar 4.95 Normalisasi 1NF Tabel m_subunsur ............................................ 189 Gambar 4.96 Normalisasi 2NF Tabel m_subunsur ............................................ 189 Gambar 4.97 Relasi Tabel Data Diri Pegawai .................................................... 256 Gambar 4.98 Relasi Tabel Riwayat Keluarga, Diklat, Cuti, Penghargaan, dan Seminar ............................................................................................................... 257 Gambar 4.99 Relasi Tabel Riwayat Jabatan, Pendidikan, dan Kepangkatan...... 258 Gambar 4.100 Relasi Tabel Penjadwalan Kerja dan Penilaian Kinerja .............. 259 Gambar 4.101 Relasi Tabel Mutasi Berkala dan Mutasi Pangkat ...................... 260 Gambar 4.102 Relasi Tabel Mutasi Jabatan dan Mutasi ..................................... 261 Gambar 4.103 Relasi Tabel sanksi, surat, dan penerimaan pegawai .................. 262 Gambar 4.104 Relasi Tabel Penggajian .............................................................. 263 Gambar 4.105 Relasi Tabel Remunerasi ............................................................. 264 Gambar 4.106 Form Login SIMRS..................................................................... 265 Gambar 4.107 Tampilan Form Home SIMRS .................................................... 266 Gambar 4.108 Form Home Modul HRD dan Payroll ......................................... 266 Gambar 4.109 Form Input Data Pegawai ........................................................... 267 Gambar 4.110 Tampilan Form Cari Data Pegawai ............................................. 268 Gambar 4.111 Tampilan Menu Manajemen Data Master Modul Payroll .......... 268 Gambar 4.112 Tampilan Menu Penggajian Pegawai .......................................... 269 Gambar 4.113 Tampilan Menu Insentif Remunerasi Pegawai ........................... 270
xii
DAFTAR TABEL
Tabel 2.1 Tabel Pengurangan Tunjangan Kinerja Akibat Terlambat Masuk ....... 42 Tabel 2.2 Tabel Pengurangan Tunjangan Kinerja Akibat Pulang Waktu ............. 42 Tabel 2.3 Tabel Tunjangan Kinerja Jabatan Fungsional Tertentu ........................ 42 Tabel 2.4 Tabel Tunjangan Kinerja Jabatan Fungsional Umum .......................... 47 Tabel 2.5 Tarif PPh 17 .......................................................................................... 50 Tabel 2.6 Simbol-simbol pada DFD menurut Yourdan dan deMarco .................. 57 Tabel 2.7 Simbol-simbol pada DFD menurut Gene dan Serson ........................... 58 Tabel 2.8 Simbol-simbol pada Flowmap .............................................................. 63 Tabel 2.9 Tipe Data Numerik................................................................................ 64 Tabel 2.10 Tipe Tanggal dan Waktu ..................................................................... 65 Tabel 2.11 Tipe Data String .................................................................................. 65 Tabel 4. 1 Tabel Gaji Pokok PNS ....................................................................... 154 Tabel 4. 2 Grade Gaji UMR Kabupaten Badung................................................ 154 Tabel 4. 3 Grade Gaji Tenaga Kesehatan Kontrak ............................................. 155 Tabel 4. 4 Tabel Competency Index ................................................................... 160 Tabel 4. 5 Tabel Nilai Position Index ................................................................. 161 Tabel 4. 6 Struktur Tabel m_agama .................................................................... 190 Tabel 4. 7 Contoh Data Tabel m_agama ............................................................. 190 Tabel 4. 8 Struktur Tabel m_bahasa ................................................................... 190 Tabel 4. 9 Contoh Data Tabel m_bahasa ............................................................ 190 Tabel 4. 10 Struktur Tabel m_angka kredit ........................................................ 191 Tabel 4. 11 Contoh Data Tabel m_angka kredit ................................................. 191 Tabel 4. 12 Struktur Tabel m_kegiatan ............................................................... 191 Tabel 4. 13 Contoh Data Tabel m_kegiatan........................................................ 191 Tabel 4. 14 Struktur Tabel m_sub_unsur ............................................................ 192 Tabel 4. 15 Contoh Data Tabel m_sub_unsur ..................................................... 192 Tabel 4. 16 Struktur Tabel m_unsur ................................................................... 192 Tabel 4. 17 Contoh Data Tabel m_unsur ............................................................ 192 Tabel 4. 18 Struktur Tabel tb_jenjang................................................................. 193 Tabel 4. 19 Contoh Data Tabel m_jenjang ......................................................... 193 Tabel 4. 20 Struktur Tabel m_jenis_jenjang ....................................................... 193 Tabel 4. 21 Contoh DataTabel m_jenis_jenjang ................................................. 193 Tabel 4. 22 Struktur Tabel m_calon_pegawai .................................................... 194 Tabel 4. 23 Contoh Data Tabel m_calon_pegawai ............................................. 194 Tabel 4. 24 Struktur m_status_nikah .................................................................. 194 Tabel 4. 25 Contoh Data Tabel m_status_nikah ................................................. 195 Tabel 4. 26 Struktur Tabel m_jurusan................................................................. 195 Tabel 4. 27 Contoh Data Tabel m_jurusan ......................................................... 195 Tabel 4. 28 Struktur Tabel m_pendidikan.......................................................... 195 Tabel 4. 29 Contoh Data Tabel m_pendidikan ................................................... 195 Tabel 4. 30 Struktur Tabel m_diklat ................................................................... 196 Tabel 4. 31 Contoh Data Tabel m_diklat ............................................................ 196 xiii
Tabel 4. 32 Struktur Tabel m_jenis diklat........................................................... 196 Tabel 4. 33 Contoh Data Tabel m_jenis diklat ................................................... 197 Tabel 4. 34 Struktur Tabel m_eselon .................................................................. 197 Tabel 4. 35 Contoh Data Tabel m_eselon ........................................................... 197 Tabel 4. 36 Struktur Tabel m_gaji_pokok .......................................................... 197 Tabel 4. 37 Contoh Data Tabel m_gaji_pokok ................................................... 198 Tabel 4. 38 Struktur Tabel m_status_kepegawaian ............................................ 198 Tabel 4. 39 Contoh Data Tabel m_status_kepegawaian ..................................... 198 Tabel 4. 40 Struktur Tabel m_golongan ............................................................. 199 Tabel 4. 41 Contoh Data Tabel m_golongan ...................................................... 199 Tabel 4. 42 Struktur Tabel m_peraturan_pemerintah ......................................... 200 Tabel 4. 43 Contoh Data Tabel m_peraturan_pemerintah .................................. 200 Tabel 4. 44 Struktur Tabel m_grupkerja ............................................................. 200 Tabel 4. 45 Contoh Data Tabel m_grupkerja ...................................................... 200 Tabel 4. 46 Struktur Tabel m_sub_unitkerja...................................................... 201 Tabel 4. 47 Contoh Data Tabel m_sub_unitkerja ............................................... 201 Tabel 4. 48 Struktur Tabel m_unit_kerja ............................................................ 201 Tabel 4. 49 Contoh Data Tabel m_unit_kerja ..................................................... 201 Tabel 4. 50 Struktur Tabel m_hub_keluarga....................................................... 202 Tabel 4. 51 Contoh Data Tabel m_hub_keluarga ............................................... 202 Tabel 4. 52 Struktur Tabel m_jabatan ................................................................. 202 Tabel 4. 53 Contoh Data Tabel m_jabatan.......................................................... 202 Tabel 4. 54 Struktur Tabel m_jenis_jabatan ....................................................... 202 Tabel 4. 55 Contoh Data Tabel m_jenis_jabatan ................................................ 203 Tabel 4. 56 Struktur Tabel tb_jadwal_kerja ........................................................ 203 Tabel 4. 57 Contoh Data Tabel tb_jadwal_kerja ................................................ 203 Tabel 4. 58 Struktur Tabel m_jenis_cuti ............................................................. 203 Tabel 4. 59 Contoh DataTabel m_jenis_cuti....................................................... 204 Tabel 4. 60 Struktur Tabel m_jenis_mutasi ........................................................ 204 Tabel 4. 61 Contoh Data Tabel m_jenis_mutasi ................................................. 204 Tabel 4. 62 Struktur Tabel m_jenis_naikpangkat ............................................... 204 Tabel 4. 63 Contoh Data Tabel m_jenis_naikpangkat ........................................ 205 Tabel 4. 64 Struktur Tabel m_kedudukan ........................................................... 205 Tabel 4. 65 Contoh Data Tabel m_kedudukan.................................................... 205 Tabel 4. 66 Struktur Tabel m_keg_tugasjab ....................................................... 205 Tabel 4. 67 Contoh Data Tabel m_keg_tugasjab ................................................ 206 Tabel 4. 68 Struktur Tabel m_orientasi............................................................... 206 Tabel 4. 69 Contoh Data Tabel m_orientasi ....................................................... 206 Tabel 4. 70 Struktur Tabel m_pegawai ............................................................... 207 Tabel 4. 71 Contoh Data Tabel m_pegawai ........................................................ 207 Tabel 4. 72 Struktur Tabel m_tugaspokok .......................................................... 208 Tabel 4. 73 Contoh Data Tabel m_tugaspokok ................................................... 208 Tabel 4. 74 Struktur Tabel m_pekerjaan ............................................................. 209 Tabel 4. 75 Contoh Data Tabel m_pekerjaan...................................................... 209 Tabel 4. 76 Struktur Tabel m_penghargaan ....................................................... 209 Tabel 4. 77 Contoh Data Tabel m_penghargaan ................................................. 209 xiv
Tabel 4. 78 Struktur Tabel m_pelanggaran ........................................................ 210 Tabel 4. 79 Contoh Data Tabel m_pelanggaran.................................................. 210 Tabel 4. 80 Struktur Tabel m_sanksi ................................................................. 210 Tabel 4. 81 Contoh Data Tabel m_sanksi ........................................................... 210 Tabel 4. 82 Struktur Tabel m_user...................................................................... 211 Tabel 4. 83 Contoh Data Tabel m_user .............................................................. 211 Tabel 4. 84 Struktur Tabel m_grup_user ............................................................ 211 Tabel 4. 85 Contoh Data Tabel m_grup_user ..................................................... 211 Tabel 4. 86 Struktur Tabel m_tujuansurat........................................................... 212 Tabel 4. 87 Contoh Data Tabel m_grup_user ..................................................... 212 Tabel 4. 88 Struktur Tabel m_tunjangan_jabatan ............................................... 212 Tabel 4. 89 Contoh Data Tabel m_tunjangan_jabatan ........................................ 212 Tabel 4. 90 Struktur Tabel m_iuran .................................................................... 213 Tabel 4. 91 Contoh Data Tabel m_iuran ............................................................. 213 Tabel 4. 92 Struktur Tabel m_jenis_index .......................................................... 213 Tabel 4. 93 Contoh Data Tabel m_jenis_index ................................................... 213 Tabel 4. 94 Struktur Tabel m_index ................................................................... 214 Tabel 4. 95 Contoh Data Tabel m_index ............................................................ 214 Tabel 4. 96 Struktur Tabel m_ptkp ..................................................................... 214 Tabel 4. 97 Contoh Data Tabel m_ptkp .............................................................. 214 Tabel 4. 98 Struktur Tabel m_insentif ................................................................ 215 Tabel 4. 99 Contoh Data Tabel m_insentif ......................................................... 215 Tabel 4. 100 Struktur Tabel m_tunjangan........................................................... 215 Tabel 4. 101 Contoh Data Tabel m_tunjangan ................................................... 215 Tabel 4. 102 Struktur Tabel m_potongan_wajib................................................. 216 Tabel 4. 103 Contoh Data Tabel m_potongan_wajib ......................................... 216 Tabel 4. 104 Struktur Tabel m_klp_remunerasi ................................................. 216 Tabel 4. 105 Contoh Data Tabel m_klp_remunerasi .......................................... 216 Tabel 4. 106 Struktur Tabel tb_distribusi ........................................................... 217 Tabel 4. 107 Contoh Data Tabel tb_distribusi .................................................... 217 Tabel 4. 108 Struktur Tabel tb_porsi .................................................................. 217 Tabel 4. 109 Contoh Data Tabel tb_porsi ........................................................... 217 Tabel 4. 110 Struktur Tabel tb_absensi............................................................... 218 Tabel 4. 111 Contoh Data Tabel tb_absensi ....................................................... 218 Tabel 4. 112 Struktur Tabel tb_det_file_riwkel .................................................. 219 Tabel 4. 113 Contoh Data tb_det_file_riwkel ..................................................... 219 Tabel 4. 114 Struktur Tabel tb_det_sik ............................................................... 219 Tabel 4. 115 Contoh Data Tabel tb_det_sik ....................................................... 219 Tabel 4. 116 Struktur Tabel tb_det_sip ............................................................... 220 Tabel 4. 117 Contoh Data Tabel tb_det_sip ....................................................... 220 Tabel 4. 118 Struktur Tabel tb_detail_dupak ...................................................... 220 Tabel 4. 119 Contoh Data Tabel tb_detail_dupak .............................................. 221 Tabel 4. 120 Struktur Tabel tb_dupak................................................................. 221 Tabel 4. 121 Contoh Data Tabel tb_dupak ......................................................... 221 Tabel 4. 122 Struktur Tabel tb_pak..................................................................... 222 Tabel 4. 123 Contoh Data Tabel tb_pak ............................................................. 222 xv
Tabel 4. 124 Struktur Tabel tb_hasilselesksi ...................................................... 222 Tabel 4. 125 Contoh Data Tabel tb_hasilselesksi ............................................... 222 Tabel 4. 126 Struktur Tabel tb_izin .................................................................... 223 Tabel 4. 127 Contoh Data Tabel tb_izin ............................................................. 223 Tabel 4. 128 Struktur Tabel tb_jadwal_grupkerja .............................................. 224 Tabel 4. 129 Contoh Data Tabel tb_jadwal_grupkerja ....................................... 224 Tabel 4. 130 Struktur Tabel tb_lap_absensi ........................................................ 224 Tabel 4. 131 Contoh Data Tabel tb_lap_absensi ................................................ 225 Tabel 4. 132 Struktur Tabel tb_usulan_mpangkat .............................................. 225 Tabel 4. 133 Contoh Data Tabel tb_usulan_mpangkat ....................................... 225 Tabel 4. 134 Struktur Tabel tb_mutasi_pangkat ................................................. 226 Tabel 4. 135 Contoh Data Tabel tb_mutasi_pangkat .......................................... 227 Tabel 4. 136 Struktur Tabel tb_usulan_mjabatan ............................................... 227 Tabel 4. 137 Contoh Data Tabel tb_usulan_mjabatan ........................................ 227 Tabel 4. 138 Struktur Tabel tb_mutasi_jabatan .................................................. 228 Tabel 4. 139 Contoh Data Tabel tb_mutasi_jabatan ........................................... 228 Tabel 4. 140 Struktur Tabel tb_mutasi_berkala .................................................. 229 Tabel 4. 141 Contoh Data Tabel tb_mutasi_berkala ........................................... 229 Tabel 4. 142 Struktur Tabel tb_usulan_mutasi ................................................... 229 Tabel 4. 143 Contoh Data Tabel tb_usulan_mutasi ............................................ 230 Tabel 4. 144 Struktur Tabel tb_mutasi................................................................ 230 Tabel 4. 145 Contoh Data Tabel tb_mutasi ........................................................ 231 Tabel 4. 146 Struktur Tabel tb_peg_grupkerja ................................................... 232 Tabel 4. 147 Contoh Data Tabel tb_peg_grupkerja ............................................ 232 Tabel 4. 148 Struktur Tabel tb_penilaian_prestasikerja ..................................... 232 Tabel 4. 149 Contoh Data Tabel tb_penilaian_prestasikerja .............................. 233 Tabel 4. 150 Struktur Tabel tb_skp ..................................................................... 234 Tabel 4. 151 Contoh Data Tabel tb_skp ............................................................. 234 Tabel 4. 152 Struktur Tabel tb_peserta_orientasi ............................................... 235 Tabel 4. 153 Contoh Data Tabel tb_peserta_orientasi ........................................ 235 Tabel 4. 154 Struktur Tabel tb_peg_bahasa ........................................................ 235 Tabel 4. 155 Contoh Data Tabel tb_peg_bahasa ................................................ 235 Tabel 4. 156 Struktur Tabel tb_sanksipeg........................................................... 236 Tabel 4. 157 Contoh DataTabel tb_sanksipeg .................................................... 236 Tabel 4. 158 Struktur Tabel tb_riwayat_cuti ...................................................... 236 Tabel 4. 159 Contoh Data Tabel tb_riwayat_cuti ............................................... 237 Tabel 4. 160 Struktur Tabel tb_riwayat_diklat ................................................... 237 Tabel 4. 161 Contoh Data Tabel tb_riwayat_diklat ............................................ 238 Tabel 4. 162 Struktur Tabel tb_riwayat_jabatan ................................................. 238 Tabel 4. 163 Contoh Data Tabel tb_riwayat_jabatan.......................................... 239 Tabel 4. 164 Struktur Tabel tb_riwayat_kepangkatan ........................................ 239 Tabel 4. 165 Contoh Data Tabel tb_riwayat_kepangkatan ................................. 240 Tabel 4. 166 Struktur Tabel tb_riwayat_keluarga............................................... 240 Tabel 4. 167 Contoh Data Tabel tb_riwayat_keluarga ....................................... 241 Tabel 4. 168 Struktur Tabel tb_riwayat_pendidikan........................................... 241 Tabel 4. 169 Contoh Data Tabel tb_riwayat_pendidikan ................................... 241 xvi
Tabel 4. 170 Struktur Tabel tb_riwayat_penghargaan ....................................... 242 Tabel 4. 171Contoh Data Tabel tb_riwayat_penghargaan .................................. 242 Tabel 4. 172 Struktur Tabel tb_riwayat_seminar ................................................ 243 Tabel 4. 173 Contoh DataTabel tbriwayat_seminar ........................................... 243 Tabel 4. 174 Struktur Tabel tb_surat ............................................................ 243 Tabel 4. 175 Contoh Data Tabel tb_surat ........................................................... 244 Tabel 4. 176 Struktur Tabel tb_insentif_rem ...................................................... 244 Tabel 4. 177 Contoh Data Tabel tb_insentif_rem ............................................... 244 Tabel 4. 178 Struktur Tabel tb_det_rem ............................................................. 245 Tabel 4. 179 Contoh Data Tabel tb_det_rem ...................................................... 245 Tabel 4. 180 Struktur Tabel tb_det_score ........................................................... 245 Tabel 4. 181 Contoh Data Tabel tb_score .......................................................... 246 Tabel 4. 182 Struktur Tabel tb_thr ...................................................................... 246 Tabel 4. 183 Contoh Data Tabel tb_thr ............................................................... 246 Tabel 4. 184 Struktur Tabel tb_form_lembur ..................................................... 246 Tabel 4. 185 Contoh Data Tabel tb_form_lembur .............................................. 247 Tabel 4. 186 Struktur Tabel tb_lembur ............................................................... 247 Tabel 4. 187 Contoh Data Tabel tb_lembur ........................................................ 247 Tabel 4. 188 Struktur Tabel tb_peginsentif......................................................... 247 Tabel 4. 189 Contoh Data Tabel tb_peginsentif ................................................. 248 Tabel 4. 190 Struktur Tabel tb_tunjangan_makan .............................................. 248 Tabel 4. 191 Contoh Data Tabel tb_ tunjangan_makan ...................................... 248 Tabel 4. 192 Struktur Tabel tb_detail_tunjangan ................................................ 248 Tabel 4. 193 Contoh Data Tabel tb_detail_tunjangan ........................................ 249 Tabel 4. 194 Struktur Tabel tb_rapel .................................................................. 249 Tabel 4. 195 Contoh Data Tabel tb_rapel ........................................................... 249 Tabel 4. 196 Struktur Tabel tb_iuranpeg ............................................................ 250 Tabel 4. 197 Contoh Data Tabel tb_iuranpeg ..................................................... 250 Tabel 4. 198 Struktur Tabel tb_det_potwajib ..................................................... 250 Tabel 4. 199 Contoh Data Tabel tb_det_potwajib .............................................. 250 Tabel 4. 200 Struktur Tabel tb_det_potlain ........................................................ 251 Tabel 4. 201 Contoh Data Tabel tb_det_potwajib .............................................. 251 Tabel 4. 202 Struktur Tabel tb_ gaji ................................................................... 251 Tabel 4. 203 Contoh Data Tabel tb _gaji ............................................................ 252 Tabel 4. 204 Struktur Tabel tb_ 1721a................................................................ 252 Tabel 4. 205 Contoh Data Tabel tb_ 1721a ........................................................ 252 Tabel 4. 206 Struktur Tabel tb_ 1721a1.............................................................. 253 Tabel 4. 207 Contoh Data Tabel tb_1721a1 ....................................................... 254 Tabel 4. 208 Struktur Tabel tb_ 1721a2.............................................................. 254 Tabel 4. 209 Contoh Data Tabel tb_1721a2 ....................................................... 255
xvii
