PERANCANGAN SISTEM INFORMASI RUMAH SAKIT MODUL FRONT OFFICE STUDI KASUS RUMAH SAKIT PTN UNUD HALAMAN SAMPUL
TUGAS AKHIR
Diajukan guna memenuhi sebagian persyaratan dalam rangka menyelesaikan Pendidikan Sarjana Strata Satu (S1) Program Studi Teknologi Informasi
KEVIN WIJAYA NIM: 1104505005
JURUSAN TEKNOLOGI INFORMASI FAKULTAS TEKNIK UNIVERSITAS UDAYANA 2015
PERANCANGAN SISTEM INFORMASI RUMAH SAKIT MODUL FRONT OFFICE STUDI KASUS RUMAH SAKIT PTN UNUD HALAMAN JUDUL
TUGAS AKHIR
Diajukan guna memenuhi sebagian persyaratan dalam rangka menyelesaikan Pendidikan Sarjana Strata Satu (S1) Program Studi Teknologi Informasi
KEVIN WIJAYA NIM: 1104505005
JURUSAN TEKNOLOGI INFORMASI FAKULTAS TEKNIK UNIVERSITAS UDAYANA 2015
PERNYATAAN
Dengan ini saya menyatakan bahwa dalam Tugas Akhir ini 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, Juli 2015
Kevin Wijaya
iii
LEMBAR PENGESAHAN TUGAS AKHIR
iv
BERITA ACARA TUGAS AKHIR
v
KATA PENGANTAR
Puji syukur penulis panjatkan ke hadirat Tuhan Yang Maha Esa, karena atas berkat dan rahmat-Nya tugas akhir yang berjudul
Perancangan
Sistem Informasi Manajemen Rumah Sakit Modul Front Office Studi Kasus ini dapat terselesaikan. Penulis sampaikan ucapan terima kasih sebesar-besarnya kepada: 1.
Bapak Prof. Ir. Ngakan Putu Gede Suardana, MT., 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 Universitas Udayana.
3.
Bapak A.A. Kompiang Oka Sudana, S.Kom., M.T. selaku dosen pembimbing I yang telah memberikan petunjuk, arahan, dan bimbingan dalam penyelesaian Tugas Akhir ini.
4.
Ibu Ni Kadek Dwi Rusjayanthi, ST.,MT. selaku dosen pembimbing II yang telah memberikan petunjuk, arahan, dan bimbingan dalam penyelesaian Tugas Akhir ini.
5.
Bapak I Nyoman Piarsa, ST.,MT selaku Dosen Pembimbing Akademik yang telah rela mem bimbingan selama masa perkuliahan.
6.
Bapak/Ibu dosen pengajar dan pegawai di Jurusan Teknologi Informasi yang telah membimbing selama proses perkuliahan dan penyusunan Tugas Akhir.
7.
Semua pihak yang tidak dapat disebutkan namanya satu per satu yang telah berbagi pikiran dan bantuan dalam penyusunan Tugas Akhir ini. Akhir kata, semoga laporan ini dapat bermanfaat dalam pengembangan
ilmu pengetahuan dan teknologi kepada khalayak luas.
Denpasar, Juli 2015
Kevin Wijaya vi
ABSTRAK
Sistem informasi dapat digunakan untuk menyediakan informasi secara cepat, dapat digunakan manajemen dalam mengambil keputusan dan juga untuk menjalankan operasional rumah sakit. Kegiatan manual seperti contohnya mencari data pasien akan memakan waktu yang lama dan tempat untuk penyimpanan berkas. Perancangan Sistem informasi Rumah Sakit Modul Front Office dibangun dengan tujuan agar dapat dikembangkan untuk menunjang bisnis proses dalam rumah sakit. Rancangan diharapkan dapat menggantikan seluruh kegiatan yang masih dilakukan secara manual di bagian Front Office Rumah Sakit. Metode yang digunakan dalam perancangan sistem adalah Metode TAS (Total Architecture Synthesis). Motode TAS dibagi menjadi lima tahap perancangan. Lima tahap perancangan tersebut adalah menentukan lingkup penelitian atau batasan masalah, menentukan kebutuhan, mendesain arsitektur bisnis proses, mendisain sistem, dan evaluasi. Rancangan Sistem Informasi Rumah Sakit Modul Front Office terdiri dari enam proses utama yaitu Manajemen Master Data, Registrasi, Informasi, Marketing, Kasir, dan Pelaporan. Perancangan sistem dibuat terintegrasi dengan enam modul lainnya. Enam modul yang terintegrasi dengan Modul Front Office adalah Modul Layanan, Farmasi, Sarana & Prasarana, Human Resource Development, Payroll, dan Akunting & Keuangan. Hasil dari perancangan sistem ini adalah berupa rancangan Diagram Berjenjang, Diagram Konteks, Diagram Alir Data, Database, dan Graphical User Interface. Kata kunci: Sistem Informasi Rumah Sakit, Modul Front Office, Metode TAS.
vii
ABSTRACT
Information systems can be used to provide information quickly. It also can be used by management to make a decisions and to run the hospital operations. One of the manual activity that will take a lot of time is for example, searching the data of the patient. It will also waste a lot of space for the file storage. Blueprint of the Front Office module of Information System in Hospital was made to support the business processes in the hospital. It also made to replace all the activities that were still done manually in the Front Office Departement. The Method that used to make the system design is TAS (Total Arachitecture Synthesis). This method is devided into five steps. The steps are determine the intial scope, determine the needs of design, designing business process, designing system, and for evalutaion. The Design of Front Office Module of Hospital Information System consist of six main processes Master Data Management, Registration, Information, Marketing, Payment, and Reporting. The design of the system is integrated with six other modules. The six modules that integrated with Front Office Module are Hospital Service, Pharmacy, Infrastructure, Human Resource Development, Payroll, Accounting & Financial. Result of this system design is a design of Hierarchy Chart, Data Flow Diagram, Context Diagram, Database, and Graphical User Interface. Keywords: Hospital Information System, Front Office Module, TAS Method.
viii
DAFTAR ISI
HALAMAN SAMPUL ........................................................................................... i HALAMAN JUDUL ............................................................................................. ii PERNYATAAN .................................................................................................... iii LEMBAR PENGESAHAN TUGAS AKHIR .................................................... iv BERITA ACARA TUGAS AKHIR .................................................................... v KATA PENGANTAR .......................................................................................... vi ABSTRAK ........................................................................................................... vii ABSTRACT ........................................................................................................ viii DAFTAR ISI ......................................................................................................... ix DAFTAR GAMBAR .......................................................................................... xiii DAFTAR TABEL ............................................................................................... xv 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 .................................................................................. 3
BAB II TINJAUAN PUSTAKA .......................................................................... 5 2.1
State of the Art ............................................................................................. 5
2.2
Rumah Sakit Pendidikan Universitas Udayana ........................................... 7
2.2.1
Visi Misi Rumah Sakit PTN Udayana ................................................ 10
2.3
Konsep Dasar Sistem ................................................................................. 10
2.4
Konsep Dasar Informasi ............................................................................ 11
2.5
Konsep Sistem Informasi ........................................................................... 11
2.6
Elemen-Elemen Sistem Informasi ............................................................. 13
2.7
Arsitektur Sistem Informasi ....................................................................... 14
2.7.1
2.8
Jenis-jenis Arsitektur Sistem Informasi .............................................. 15
2.7.1.1
Arsitektur Tersentralisasi ............................................................ 15
2.7.1.2
Arsitektur Desentralisasi ............................................................. 16
2.7.1.3
Arsitektur Client Server .............................................................. 17
Klasifikasi Sistem Informasi ...................................................................... 18 ix
2.9
Database .................................................................................................... 19
2.9.1
2.9.1.1
Keuntungan DBMS ..................................................................... 20
2.9.1.2
Kerugian DBMS .......................................................................... 20
2.9.2 2.10
Sistem Manajemen Database (DBMS) .............................................. 19
Key ...................................................................................................... 20
MySQL ...................................................................................................... 22
2.10.1
Tipe Data MySQL .............................................................................. 22
2.10.1.1Tipe Data Numerik........................................................................... 22 2.10.1.2Jenis Tanggal dan Waktu ................................................................. 23 2.10.1.3Tipe String (Teks) ............................................................................ 24 2.10.1.4Tipe Blob (Biner) ............................................................................. 25 2.11
ERD............................................................................................................ 25
2.11.1
Komponen ERD.................................................................................. 25
2.11.2
Cardinality Rasio ................................................................................ 27
2.12
DFD............................................................................................................ 27
2.13
Standart Operational Procedure (SOP) .................................................... 28
2.14
Metode Peracangan TAS (Total Architecture Syntesis) ............................ 30
BAB III METODE PENELITIAN DAN PENGUMPULAN DATA ............. 32 3.1
Tempat dan Waktu Penelitian .................................................................... 32
3.2
Data ............................................................................................................ 32
3.2.1
Sumber Data ....................................................................................... 32
3.2.2
Jenis Data ............................................................................................ 32
3.2.3
Metode Pengumpulan Data................................................................. 32
3.2.4
Metode Pengolahan Data .................................................................... 33
3.2.5
Analisis Data....................................................................................... 33
3.3
Flowchart Langkah Penelitian .................................................................. 34
BAB IV PERANCANGAN SISTEM ................................................................ 36 4.1
Gambaran Umum SIMRS .......................................................................... 36
4.2
Hierarchy Chart ......................................................................................... 49
4.3
Rancangan Umum Sistem .......................................................................... 50
4.4
DFD Level 0 Sistem Front Office .............................................................. 53
4.4.1
DFD Level 1 Manajemen Master Data ............................................... 55
4.4.1.1 4.4.2
DFD Level 2 Master Data Pasien ................................................ 55
DFD Level 1 Registrasi ....................................................................... 56
x
4.4.2.1
DFD Level 2 Registrasi Rawat Inap ............................................ 57
4.4.2.2
DFD Level 2 Registrasi Rawat Jalan ........................................... 59
4.4.2.3
DFD Level 2 Request Surat ......................................................... 60
4.4.3
DFD Level 1 Informasi ....................................................................... 60
4.4.3.1
DFD Level 2 View Jadwal ........................................................... 61
4.4.4
DFD Level 1 Marketing ...................................................................... 62
4.4.5
DFD Level 1 Kasir .............................................................................. 63
4.4.6
DFD Level 1 Pelaporan ....................................................................... 65
4.5
Rancangan Database ................................................................................. 65
4.5.1
ERD .................................................................................................... 65
4.5.2
Normalisasi ......................................................................................... 67
4.5.2.1
Normalisasi Tabel Pasien ............................................................ 67
4.4.2.2
Normalisasi Tabel Registrasi ...................................................... 70
4.4.2.3
Normalisasi Tabel tb_detail_alergi_pasien ................. 72
4.4.2.4 Normalisasi Tabel tb_setup_inap ............................................... 74 4.5.3
Skema Database ................................................................................. 75
4.5.4
Struktur Data....................................................................................... 77
4.6
SOP .......................................................................................................... 136
4.6.1
SOP Daftar Pasien Baru.................................................................... 136
4.6.2
SOP Registrasi Pasien Rawat Jalan Pasien Umum........................... 137
4.6.3
SOP Registrasi Pasien Rawat Jalan Jaminan .................................... 138
4.6.4
SOP Registrasi Pasien Rawat Inap Umum ....................................... 139
4.6.5
SOP Registrasi Pasien Rawat Inap Jaminan ..................................... 140
4.6.6
SOP Cetak Form Rekam Medis ........................................................ 142
4.6.7
SOP Cetak Surat Keterangan ............................................................ 143
4.6.8
SOP Cetak Surat Rujukan................................................................. 143
4.6.9
SOP Pembayaran Transaksi.............................................................. 145
4.6.10
SOP Pembayaran Transaksi Jaminan ............................................... 146
4.6.11
SOP Pelaporan Kunjungan Pasien .................................................... 147
4.6.12
SOP Permohonan Kerjasama............................................................ 148
4.6.13
SOP Konfirmasi Kerjasama.............................................................. 149
4.6.14
SOP Pindah Kamar ........................................................................... 151
4.6.15
SOP Request Ambulance .................................................................. 152
4.7
Desain Graphical User Interface ............................................................. 153
xi
4.7.1
Desain Icon Aplikasi......................................................................... 153
4.7.2
Desain Form Login ........................................................................... 153
4.7.3
Desain Form Home ........................................................................... 154
4.7.4
Desain Form Front Office ................................................................ 154
4.7.5
Desain Form Daftar Pasien Baru ...................................................... 155
4.7.6
Desain Form Setup Alergi ................................................................ 156
4.7.7
Desain Form Registrasi Rawat Jalan ................................................ 157
4.7.8
Desain Form Registrasi Setup Inap .................................................. 158
4.7.9
Desain Form Registrasi Rawat Darurat ............................................ 159
4.7.10
Desain Form Setup Polis .................................................................. 160
4.7.11
Desain Form Setup Wali ................................................................... 161
4.7.12
Desain Form Cari Pasien .................................................................. 162
4.7.13
Desain Form Entri Perusahaan ......................................................... 163
4.7.14
Desain Form Entri Kontrak .............................................................. 164
4.7.15
Desain Form Entri Tanggungan ....................................................... 165
4.7.16
Desain Form Entri Registrasi Kamar ............................................... 166
4.7.17
Desain Form Entri Registrasi Keluar Kamar.................................... 167
4.7.18
Desain Form Entri Registrasi Keluar ............................................... 168
4.7.19
Desain Form Entri Surat Rujukan .................................................... 168
4.7.20
Desain Form Entri Surat Keterangan ............................................... 169
4.7.21
Desain Form Pembayaran................................................................. 170
4.7.22
Desain Form Bayar ........................................................................... 171
4.7.23
Desain Form Posting ........................................................................ 172
BAB V PENUTUP............................................................................................. 173 5.1
Simpulan .................................................................................................. 173
5.2
Saran ........................................................................................................ 173
DAFTAR PUSTAKA ........................................................................................ 175
xii
DAFTAR GAMBAR
Gambar 2.1 Struktur Organisasi Rumah Sakit Pendidikan Universitas Udayana .. 9 Gambar 2.2Arsitektur Tersentralisasi ................................................................... 15 Gambar 2.3Arsitektur Desentralisasi .................................................................... 17 Gambar 2.4Arsitektur Desentralisasi .................................................................... 18 Gambar 2.5 Hubungan Relationship dengan Entitas ............................................ 26 Gambar 2.6 Hubungan Relationship dengan Entitas ............................................ 26 Gambar 2.7 Simbol-simbol DFD .......................................................................... 27 Gambar 3.1 Flowchart Langkah Penelitian yang Dilakukan ................................ 34 Gambar 3.2 Flowchart Metode Arsitektur TAS ................................................... 35 Gambar 4.1 Diagram Blok SIMRS ....................................................................... 37 Gambar 4.2 Blok Diagram Integrasi Data SIMRS ............................................... 46 Gambar 4.3 Konteks Diagram .............................................................................. 47 Gambar 4.4 Overview Keseluruhan ...................................................................... 48 Gambar 4.5 Hierarchy Chart Sistem Informasi Front Office............................... 49 Gambar 4.6 Gambaran Umum Sistem .................................................................. 50 Gambar 4.7 DFD Level 0 Sistem Front Office ..................................................... 54 Gambar 4.8 DFD Level 1 Manajemen Master Data ............................................. 55 Gambar 4.9 DFD Level 2 Master Data Pasien ...................................................... 56 Gambar 4.10 DFD Level 1 Registrasi ................................................................... 57 Gambar 4.11 DFD Level 2 Registrasi Rawat Inap ................................................ 58 Gambar 4.12 DFD Level 2 Registrasi Rawat Jalan ............................................... 59 Gambar 4.13 DFD Level 2 Request Surat ............................................................. 60 Gambar 4.14 DFD Level 1 Informasi ................................................................... 61 Gambar 4.15 DFD Level 2 View Jadwal ............................................................... 62 Gambar 4.16 DFD Level 1 Marketing .................................................................. 63 Gambar 4.17 DFD Level 1 Pembayaran ............................................................... 64 Gambar 4.18 DFD Level 1 Pelaporan ................................................................... 65 Gambar 4.19 ERD Sistem Front Office ................................................................ 66 Gambar 4.20 Tabel m_pasien ........................................................................... 67 Gambar 4.21 Normalisasi m_pasien ................................................................. 68 Gambar 4.22 Pemecahan Tabel m_kota ............................................................ 69 Gambar 4.23 Pemecahan Tabel m_kecamatan ................................................ 70 Gambar 4.24 Rancangan tb_registrasi ....................................................... 70 Gambar 4.25 NormalisasiTabel tb_registrasi ............................................ 72 Gambar 4.26 Rancangan tb_detail_alergi_pasien ............................... 73 Gambar 4.27 NormalisasiTabel tb_detail_alergi_pasien .................... 73 Gambar 4.28 Pemecahan Tabel m_alergi ........................................................ 74 Gambar 4.29 Rancangan tb_setup_inap ....................................................... 74 Gambar 4.30 NormalisasiTabel tb_detail_alergi_pasien .................... 75 Gambar 4.31 Skema Database Sistem Informasi Front Office ............................ 76 Gambar 4.32 SOP Daftar Pasien Baru ................................................................ 136 Gambar 4.33 SOP Registrasi Pasien Umum ....................................................... 137
xiii
Gambar 4.34 SOP Registrasi Pasien Jaminan ..................................................... 138 Gambar 4.35 SOP Registrasi Pasien Inap Umum ............................................... 140 Gambar 4.36 SOP Registrasi Pasien Inap Jaminan............................................. 141 Gambar 4.37 SOP Cetak Form Rekam Medis .................................................... 142 Gambar 4.38 SOP Cetak Surat Keterangan ........................................................ 143 Gambar 4.39 SOP Cetak Surat Rujukan ............................................................. 144 Gambar 4.40 SOP Pembayaran Transaksi .......................................................... 145 Gambar 4.41 SOP Pembayaran Pasien Jaminan ................................................. 146 Gambar 4.42 SOP Pelaporan Kunjungan Pasien ................................................ 147 Gambar 4.43 SOP Permohonan Kerjasama ........................................................ 148 Gambar 4.44 SOP Konfirmasi Kerjasama .......................................................... 150 Gambar 4.45 SOP Pindah Kamar ....................................................................... 151 Gambar 4.46 SOP Pindah Kamar ....................................................................... 152 Gambar 4.47 Icon Aplikasi ................................................................................. 153 Gambar 4.48 Icon Aplikasi ................................................................................. 153 Gambar 4.49 Home ............................................................................................. 154 Gambar 4.50 Front Office Form ......................................................................... 155 Gambar 4.51 Daftar Pasien Baru ........................................................................ 156 Gambar 4.52 Setup Alergi................................................................................... 157 Gambar 4.53 Registrasi Rawat Jalan .................................................................. 158 Gambar 4.54 Setup Inap ...................................................................................... 159 Gambar 4.55 Registrasi Rawat Darurat .............................................................. 160 Gambar 4.56 Setup Polis ..................................................................................... 161 Gambar 4.57 Setup Wali ..................................................................................... 162 Gambar 4.58 Cari Pasien .................................................................................... 163 Gambar 4.59 Entri Perusahaan............................................................................ 164 Gambar 4.60 Entri Kontrak ................................................................................. 165 Gambar 4.61 Entri Tanggungan .......................................................................... 166 Gambar 4.62 Registrasi Kamar ........................................................................... 167 Gambar 4.63 Registrasi Keluar Kamar ............................................................... 167 Gambar 4.64 Registrasi Keluar ........................................................................... 168 Gambar 4.65 Surat Rujukan ................................................................................ 169 Gambar 4.66 Surat Keterangan ........................................................................... 169 Gambar 4.67 Pembayaran ................................................................................... 170 Gambar 4.68 Entri Pembayaran .......................................................................... 171 Gambar 4.69 Posting Pembayaran ...................................................................... 172
xiv
DAFTAR TABEL
Tabel 2.1 Simbol-simbol SOP .............................................................................. 29 Tabel 4.1 Struktur Data Tabel m_pasien........................................................... 77 Tabel 4.2 Contoh Data Tabel m_pasien ........................................................... 80 Tabel 4.3 Struktur Data Tabel m_agama ............................................................. 81 Tabel 4.4 Contoh Data Tabel m_agama ............................................................. 81 Tabel 4.5 Struktur Data Tabel m_jenis_inap ................................................. 82 Tabel 4.6 Contoh Data Tabel m_jenis_inap ................................................ 82 Tabel 4.7 Struktur Data Tabel m_jenis_layanan .......................................... 83 Tabel 4.8 Contoh Data Tabel m_jenis_layanan ........................................... 83 Tabel 4.9 Struktur Data Tabel m_provinsi ...................................................... 83 Tabel 4.10 Contoh Data Tabel Tabel m_provinsi ........................................... 84 Tabel 4.11 Struktur Data Tabel m_kecamatan ................................................. 84 Tabel 4.12 Contoh Data Tabel m_kecamatan ................................................... 85 Tabel 4.13 Struktur Data Tabel m_kota ............................................................. 85 Tabel 4.14 Contoh Data Tabel m_kota ............................................................... 86 Tabel 4.15 Struktur Data Tabel m_negara......................................................... 87 Tabel 4.16 Contoh Data Tabel m_negara .......................................................... 87 Tabel 4.17 Struktur Data Tabel m_tipe_rawat ............................................... 87 Tabel 4.18 Contoh Data Tabel m_tipe_rawat............................................... 88 Tabel 4.19 Struktur Data Tabel m_keluar......................................................... 88 Tabel 4.20 Contoh Data Tabel tb_tipe_rawat .............................................. 89 Tabel 4.21 Struktur Data Tabel m_jenis_surat............................................. 89 Tabel 4.22 Contoh Data Tabel m_jenis_surat .............................................. 90 Tabel 4.23 Struktur Data Tabel m_diagnosa .................................................... 90 Tabel 4.24 Contoh Data Tabel m_diagnosa ..................................................... 91 Tabel 4.25 Struktur Data Tabel m_alergi......................................................... 91 Tabel 4.26 Contoh Data Tabel m_alergi .......................................................... 92 Tabel 4.27 Struktur Data Tabel m_alergi......................................................... 92 Tabel 4.28 Contoh Data Tabel m_keterangan ................................................ 92 Tabel 4.29 Struktur Data Tabel m_jenis_alergi .......................................... 93 Tabel 4.30 Contoh Data Tabel m_jenis_alergi ........................................... 93 Tabel 4.31 Struktur Data Tabel tb_registrasi............................................. 94 Tabel 4.32 Contoh Data Tabel tb_registrasi ............................................. 97 Tabel 4.33 Struktur Data Tabel tb_detail_polis ........................................ 97 Tabel 4.34 Contoh Data Tabel tb_detail_polis ......................................... 98 Tabel 4.35 Struktur Data Tabel tb_perusahaan............................................. 99 Tabel 4.36 Contoh Data Tabel tb_perusahaan ............................................ 100 Tabel 4.37 Struktur Data Tabel tb_kontrak .................................................. 100 Tabel 4.38 Contoh Data Tabel tb_kontrak ................................................... 101 Tabel 4.39 Struktur Data Tabel tb_tanggungan_obat............................... 102
xv
Tabel 4.40 Contoh Data Tabel tb_tanggungan_obat .......................................... 103 Tabel 4.41 Struktur Data Tabel tb_tanggungan_tindakan ..................... 103 Tabel 4.42 Contoh Data Tabel Tabel tb_tanggungan_tindakan ............ 104 Tabel 4.43 Struktur Data Tabel tb_detail_kontrak_kelas................... 104 Tabel 4.44 Contoh Data Tabel tb_tanggungan_kelas ............................. 105 Tabel 4.45 Struktur Data Tabel tb_tanggungan_penunjang................... 106 Tabel 4.46 Contoh Data Tabel tb_tanggungan_penunjang .................... 107 Tabel 4.47 Struktur Data Tabel tb_detail_alergi ................................... 107 Tabel 4.48 Contoh Data Tabel tb_detail_alergi..................................... 108 Tabel 4.49 Struktur Data Tabel tb_diagnosa_awal ................................... 108 Tabel 4.50 Contoh Data Tabel tb_diagnosa_awal..................................... 109 Tabel 4.51 Struktur Data Tabel tb_reg_bed .................................................. 109 Tabel 4.52 Contoh Data Tabel tb_reg_kamar .............................................. 110 Tabel 4.53 Struktur Data Tabel tb_request .................................................. 111 Tabel 4.54 Contoh Data Tabel tb_request ................................................... 112 Tabel 4.55 Struktur Data Tabel tb_surat_rujukan ................................... 112 Tabel 4.56 Contoh Data Tabel tb_surat_rujukan..................................... 113 Tabel 4.57 Struktur Data Tabel tb_surat_keterangan ............................ 114 Tabel 4.58 Contoh Data Tabel tb_surat_keterangan ............................. 115 Tabel 4.59 Struktur Data Tabel tb_surat_kerjasama............................... 115 Tabel 4.60 Contoh Data Tabel tb_surat_kerjasama ................................ 117 Tabel 4.61 Struktur Data Tabel tb_pembayaran_transaksi................... 117 Tabel 4.62 Contoh Data Tabel tb_pembayaran_transaksi .................... 118 Tabel 4.63 Struktur Data Tabel tb_detail_terbayar............................... 119 Tabel 4.64 Contoh Data Tabel tb_detail_terbayar ................................ 120 Tabel 4.65 Struktur Data Tabel tb_jenis_pembayaran ............................ 120 Tabel 4.66 Contoh Data Tabel tb_jenis_pembayaran ............................. 121 Tabel 4.67 Struktur Data Tabel m_sumber_data........................................... 121 Tabel 4.68 Contoh Data Tabel m_sumber_data ......................................... 121 Tabel 4.69 Struktur Data Tabel tb_det_penyakit_bawaan ..................... 122 Tabel 4.70 Contoh Data Tabel tb_det_penyakit_pasien .................... 122 Tabel 4.71 Struktur Data Tabel tb_det_riwayat_operasi ..................... 123 Tabel 4.72 Contoh Data Tabel tb_det_riwayat_operasi .................... 123 Tabel 4.73 Struktur Data Tabel m_masuk ......................................................... 124 Tabel 4.74 Contoh Data Tabel m_masuk ........................................................ 124 Tabel 4.75 Struktur Data Tabel m_pendidikan ............................................. 124 Tabel 4.76 Contoh Data Tabel m_pendidikan ............................................ 125 Tabel 4.77 Struktur Data Tabel m_pekerjaan ............................................... 125 Tabel 4.78 Contoh Data Tabel m_pekerjaan .............................................. 126 Tabel 4.79 Struktur Data Tabel m_karcis....................................................... 126 Tabel 4.80 Contoh Data Tabel m_karcis ...................................................... 127 Tabel 4.81 Struktur Data Tabel tb_det_trans_karcis ............................ 127 Tabel 4.82 Contoh Data Tabel tb_det_trans_karcis ............................. 128
xvi
Tabel 4.83 Struktur Data Tabel m_kondisi .................................................... 128 Tabel 4.84 Contoh Data Tabel m_kondisi ..................................................... 128 Tabel 4.87 Struktur Data Tabel tb_request_ambulance .......................... 129 Tabel 4.88 Contoh Data Tabel tb_request_ambulance ........................... 130 Tabel 4.87 Struktur Data Tabel m_jenis_pasien ........................................ 130 Tabel 4.88 Contoh Data Tabel m_jenis_pasien ......................................... 130 Tabel 4.89 Struktur Data Tabel tb_trans_ambulance............................... 131 Tabel 4.90 Contoh Data Tabel tb_trans_ambulance ................................ 132 Tabel 4.91 Struktur Data Tabel tb_det_pegawai_ambulance ................ 132 Tabel 4.92 Contoh Data Tabel tb_det_pegawai_ambulance ................ 133 Tabel 4.93 Struktur Data Tabel tb_setup_inap........................................... 133 Tabel 4.94 Contoh Data Tabel tb_setup_inap ............................................ 135
xvii
