| id | int(10) unsigned |
|
|
|
| no_rawat | varchar(80) |
|
|
|
| no_rm | varchar(40) |
|
|
|
| nama_pasien | varchar(160) |
|
|
|
| tanggal_kunjungan | date |
|
|
|
| tanggal_kejadian | date |
|
|
|
| lokasi_kejadian | varchar(255) |
|
|
|
| jenis_kecelakaan | varchar(120) |
|
|
|
| no_laporan | varchar(120) |
|
|
|
| no_surat_jaminan | varchar(120) |
|
|
|
| no_berkas_klaim | varchar(120) |
|
|
|
| tanggal_pengajuan | date |
|
|
|
| tanggal_dibayar | date |
|
|
|
| diagnosa | text |
|
|
|
| tindakan | text |
|
|
|
| total_biaya | decimal(18,2) |
|
|
0.00
|
| nilai_dijamin | decimal(18,2) |
|
|
0.00
|
| nominal_dibayar | decimal(18,2) |
|
|
0.00
|
| selisih | decimal(18,2) |
|
|
0.00
|
| status_klaim | varchar(30) |
|
|
draft
|
| status_pembayaran | varchar(30) |
|
|
belum
|
| berkas_laporan_polisi | tinyint(1) |
|
|
0
|
| berkas_surat_jaminan | tinyint(1) |
|
|
0
|
| berkas_identitas | tinyint(1) |
|
|
0
|
| berkas_resume_medis | tinyint(1) |
|
|
0
|
| berkas_rincian_biaya | tinyint(1) |
|
|
0
|
| catatan | text |
|
|
|
| created_by | varchar(80) |
|
|
|
| created_at | datetime |
|
|
2026-08-05 20:48:39.000000
|
| updated_by | varchar(80) |
|
|
|
| updated_at | datetime |
|
|
2026-08-05 20:48:39.000000
|