-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Waktu pembuatan: 29 Jul 2023 pada 23.35
-- Versi server: 10.4.28-MariaDB
-- Versi PHP: 8.2.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `dbklinik`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `tbl_tarif`
--

CREATE TABLE `tbl_tarif` (
  `kode_kelompok` varchar(10) NOT NULL,
  `kelompok_tindakan` varchar(30) NOT NULL,
  `kode_tindakan` varchar(30) NOT NULL,
  `nama_tindakan` varchar(255) DEFAULT NULL,
  `biaya` double DEFAULT NULL,
  `jasa` double DEFAULT NULL,
  `tarif` double DEFAULT NULL,
  `jt_pelaksana` double DEFAULT NULL,
  `jt_asisten` double DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data untuk tabel `tbl_tarif`
--

INSERT INTO `tbl_tarif` (`kode_kelompok`, `kelompok_tindakan`, `kode_tindakan`, `nama_tindakan`, `biaya`, `jasa`, `tarif`, `jt_pelaksana`, `jt_asisten`) VALUES
('K005', 'Laboratorium', 'TE2001', 'Protein Total', 28000, 7000, 35000, 3500, 3500),
('K005', 'Laboratorium', 'TE1014', 'Waktu Pembekuan (CT)', 20000, 5000, 25000, 2500, 2500),
('K005', 'Laboratorium', 'TE1013', 'Waktu Perdarahan (BT)', 20000, 5000, 25000, 2500, 2500),
('K005', 'Laboratorium', 'TE1012', 'Golongan Darah ABO', 16000, 4000, 20000, 2000, 2000),
('K005', 'Laboratorium', 'TE1011', 'Sediaan Darah Tepi', 80000, 20000, 100000, 10000, 10000),
('K005', 'Laboratorium', 'TE1010', 'Hitung Jenis', 32000, 8000, 40000, 4000, 4000),
('K005', 'Laboratorium', 'TE1009', 'Laju Endap Darah (LED)', 25000, 5000, 30000, 2500, 2500),
('K005', 'Laboratorium', 'TE1008', 'Hematokrit', 20000, 5000, 25000, 2500, 2500),
('K005', 'Laboratorium', 'TE1007', 'Trombosit', 28000, 7000, 35000, 3500, 3500),
('K005', 'Laboratorium', 'TE1006', 'Lekosit', 20000, 5000, 25000, 2500, 2500),
('K005', 'Laboratorium', 'TE1005', 'Eritrosit', 20000, 5000, 25000, 2500, 2500),
('K005', 'Laboratorium', 'TE1004', 'Hematokrit', 20000, 5000, 25000, 2500, 2500),
('K005', 'Laboratorium', 'TE1003', 'Hemoglobin', 24000, 6000, 30000, 3000, 3000),
('K005', 'Laboratorium', 'TE1002', 'Darah Lengkap (DL)', 98000, 22000, 120000, 11000, 11000),
('K005', 'Laboratorium', 'TE1001', 'Darah Rutin (DR)', 83000, 17000, 100000, 8500, 8500),
('K004', 'Kebidanan', 'TD007', 'Pasang Infus Kamar Bersalin', 18000, 12000, 30000, 10500, 1500),
('K004', 'Kebidanan', 'TD006', 'Persalinan Normal - BPJS', 0, 100000, 100000, 60000, 40000),
('K004', 'Kebidanan', 'TD005', 'Hecting Perineum', 100000, 53000, 153000, 34450, 18550),
('K004', 'Kebidanan', 'TD004', 'Gurah Vagina', 100000, 55000, 155000, 38500, 16500),
('K004', 'Kebidanan', 'TD003', 'Tindakan Resiko Persalinan', 140000, 65000, 205000, 45500, 19500),
('K004', 'Kebidanan', 'TD002', 'Tindakan HPP', 140000, 65000, 205000, 45500, 19500),
('K004', 'Kebidanan', 'TD001', 'Persalinan Normal', 1470000, 180000, 1650000, 108000, 72000),
('K003', 'Rawat Inap', 'TC504', 'Asuhan Perawatan Kelas VIP', 20000, 40000, 60000, 22000, 18000),
('K003', 'Rawat Inap', 'TC503', 'Asuhan Perawatan Kelas I', 18000, 32000, 50000, 18000, 14000),
('K003', 'Rawat Inap', 'TC502', 'Asuhan Perawatan Kelas III', 15000, 25000, 40000, 15000, 10000),
('K003', 'Rawat Inap', 'TC501', 'Asuhan Perawatan R. Observasi', 11000, 14000, 25000, 10000, 4000),
('K003', 'Rawat Inap', 'TC404', 'Visite Dokter Kelas VIP', 25000, 15000, 40000, 15000, 0),
('K003', 'Rawat Inap', 'TC403', 'Visite Dokter Kelas I', 20000, 15000, 35000, 15000, 0),
('K003', 'Rawat Inap', 'TC402', 'Visite Dokter Kelas III', 15000, 15000, 30000, 15000, 0),
('K003', 'Rawat Inap', 'TC401', 'Visite Dokter R. Observasi', 10000, 15000, 25000, 15000, 0),
('K003', 'Rawat Inap', 'TC304', 'Biaya Kamar Kelas VIP', 550000, 0, 550000, 0, 0),
('K003', 'Rawat Inap', 'TC303', 'Biaya Kamar Kelas I', 450000, 0, 450000, 0, 0),
('K003', 'Rawat Inap', 'TC302', 'Biaya Kamar Kelas III', 350000, 0, 350000, 0, 0),
('K003', 'Rawat Inap', 'TC301', 'Biaya Kamar R. Observasi (Maks 6 Jam)', 75000, 0, 75000, 0, 0),
('K003', 'Rawat Inap', 'TC204', 'Jasa Rujukan Pasien Rawat Inap Kelas VIP', 0, 150000, 150000, 150000, 0),
('K003', 'Rawat Inap', 'TC203', 'Jasa Rujukan Pasien Rawat Inap Kelas I', 0, 125000, 125000, 125000, 0),
('K003', 'Rawat Inap', 'TC202', 'Jasa Rujukan Pasien Rawat Inap Kelas III', 0, 100000, 100000, 100000, 0),
('K003', 'Rawat Inap', 'TC201', 'Jasa Rujukan Pasien Observasi', 0, 50000, 50000, 50000, 0),
('K003', 'Rawat Inap', 'TC106', 'Cetak Ulang Kartu Pasien Elektronik', 5000, 0, 5000, 0, 0),
('K003', 'Rawat Inap', 'TC105', 'Cetak Kartu Pasien Elektronik', 10000, 0, 10000, 0, 0),
('K003', 'Rawat Inap', 'TC104', 'Pendaftaran Rawat Inap Kelas Vip', 150000, 0, 150000, 0, 0),
('K003', 'Rawat Inap', 'TC103', 'Pendaftaran Rawat Inap Kelas I', 125000, 0, 125000, 0, 0),
('K003', 'Rawat Inap', 'TC102', 'Pendaftaran Rawat Inap Kelas III', 100000, 0, 100000, 0, 0),
('K003', 'Rawat Inap', 'TC101', 'Pendaftaran Observasi', 50000, 0, 50000, 0, 0),
('K002', 'Tindakan', 'TB078', 'Paket Fisioterapi Lengkap', 50000, 10000, 60000, 6000, 4000),
('K002', 'Tindakan', 'TB077', 'Bantal Pijat Punggung (15 Menit)', 28000, 7000, 35000, 4000, 3000),
('K002', 'Tindakan', 'TB076', 'Terapi Infra Red (15 Menit)', 28000, 7000, 35000, 4000, 3000),
('K002', 'Tindakan', 'TB075', 'Imunisasi Hb0', 25000, 5000, 30000, 2500, 2500),
('K002', 'Tindakan', 'TB074', 'Imunisasi Campak', 30000, 5000, 35000, 2500, 2500),
('K002', 'Tindakan', 'TB073', 'Imunisasi BCG - BPJS', 30000, 5000, 35000, 2500, 2500),
('K002', 'Tindakan', 'TB072', 'Imunisasi DPT - Polio + Obat', 30000, 5000, 35000, 2500, 2500),
('K002', 'Tindakan', 'TB071', 'Imunisasi TT - Bpjs', 30000, 5000, 35000, 2500, 2500),
('K002', 'Tindakan', 'TB070', 'Suntik KB 3 Bulan', 25000, 5000, 30000, 2500, 2500),
('K002', 'Tindakan', 'TB069', 'Suntik KB 1 Bulan', 20000, 5000, 25000, 2500, 2500),
('K002', 'Tindakan', 'TB068', 'Cetak Buku USG Pasien Baru', 10000, 0, 10000, 0, 0),
('K002', 'Tindakan', 'TB067', 'USG Kandungan', 55000, 15000, 70000, 15000, 0),
('K002', 'Tindakan', 'TB066', 'One Touch - Hemoglobin (Hb) Ibu Hamil', 5000, 5000, 10000, 2500, 2500),
('K002', 'Tindakan', 'TB065', 'One Touch - Cholesterol', 10000, 5000, 15000, 2500, 2500),
('K002', 'Tindakan', 'TB064', 'One Touch - Asam Urat', 8000, 5000, 13000, 2500, 2500),
('K002', 'Tindakan', 'TB063', 'One Touch - Gula Darah Sewaktu (GDS)', 8000, 5000, 13000, 2500, 2500),
('K002', 'Tindakan', 'TB062', 'Rapid Test Antigen - Group/Kelompok', 12000, 8000, 20000, 4000, 4000),
('K002', 'Tindakan', 'TB061', 'Rapid Test Antigen Umum', 15000, 10000, 25000, 5000, 5000),
('K002', 'Tindakan', 'TB060', 'Perlengkapan Partus Dengan Rujukan', 265200, 0, 265200, 0, 0),
('K002', 'Tindakan', 'TB059', 'Perlengkapan Partus Tanpa Rujukan', 175200, 0, 175200, 0, 0),
('K002', 'Tindakan', 'TB058', 'Pelayanan Ambulance', 108000, 72000, 180000, 63000, 9000),
('K002', 'Tindakan', 'TB057', 'Jasa Home Care > 1 Km (Maks 10 Km)', 108000, 72000, 180000, 63000, 9000),
('K002', 'Tindakan', 'TB056', 'Jasa Home Care < 1 Km', 54000, 36000, 90000, 31500, 4500),
('K002', 'Tindakan', 'TB055', 'Bekam Seluruh Badan', 47520, 31680, 79200, 27720, 3960),
('K002', 'Tindakan', 'TB054', 'Bekam', 34560, 23040, 57600, 20160, 2880),
('K002', 'Tindakan', 'TB053', 'Circumsisi Dewasa', 294480, 196320, 490800, 171780, 24540),
('K002', 'Tindakan', 'TB052', 'Circumsisi Anak', 261360, 174240, 435600, 152460, 21780),
('K002', 'Tindakan', 'TB051', 'Suntik ATS', 210960, 140640, 351600, 123060, 17580),
('K002', 'Tindakan', 'TB050', 'Tampon Behavior', 17280, 11520, 28800, 10080, 1440),
('K002', 'Tindakan', 'TB049', 'Tindik Bayi + Sunat', 37440, 24960, 62400, 21840, 3120),
('K002', 'Tindakan', 'TB048', 'Bidai', 104400, 69600, 174000, 60900, 8700),
('K002', 'Tindakan', 'TB047', 'Tindakan Penyakit GO', 360000, 240000, 600000, 210000, 30000),
('K002', 'Tindakan', 'TB046', 'Massage Bayi', 52560, 35040, 87600, 30660, 4380),
('K002', 'Tindakan', 'TB045', 'Tindik Telinga', 23760, 15840, 39600, 13860, 1980),
('K002', 'Tindakan', 'TB044', 'Terapi Suppositoria', 15840, 10560, 26400, 9240, 1320),
('K002', 'Tindakan', 'TB043', 'Terapi Oksigen', 36000, 0, 36000, 0, 0),
('K002', 'Tindakan', 'TB042', 'Rawat Combutio > 50%', 89280, 59520, 148800, 52080, 7440),
('K002', 'Tindakan', 'TB041', 'Rawat Combutio 10-50%', 69840, 46560, 116400, 40740, 5820),
('K002', 'Tindakan', 'TB040', 'Rawat Combutio < 10%', 49680, 33120, 82800, 28980, 4140),
('K002', 'Tindakan', 'TB039', 'Pasang Spalk', 17280, 11520, 28800, 10080, 1440),
('K002', 'Tindakan', 'TB038', 'Pasang Infus Dewasa', 18000, 12000, 30000, 10500, 1500),
('K002', 'Tindakan', 'TB037', 'Pasang Infus Anak', 21600, 14400, 36000, 12600, 1800),
('K002', 'Tindakan', 'TB036', 'Pasang Infus Bayi', 25200, 16800, 42000, 14700, 2100),
('K002', 'Tindakan', 'TB035', 'Lepas Cateter', 54000, 36000, 90000, 31500, 4500),
('K002', 'Tindakan', 'TB034', 'Pasang Cateter', 54000, 36000, 90000, 31500, 4500),
('K002', 'Tindakan', 'TB033', 'Nebulizer', 22500, 19500, 42000, 4500, 15000),
('K002', 'Tindakan', 'TB032', 'Irigasi Telinga', 25200, 16800, 42000, 14700, 2100),
('K002', 'Tindakan', 'TB031', 'Irigasi Mata', 25200, 16800, 42000, 14700, 2100),
('K002', 'Tindakan', 'TB030', 'Insisi / Eksisi', 54000, 36000, 90000, 31500, 4500),
('K002', 'Tindakan', 'TB029', 'Corpus Alienum Dewasa', 39600, 26400, 66000, 23100, 3300),
('K002', 'Tindakan', 'TB028', 'Corpus Alienum Anak', 43200, 28800, 72000, 25200, 3600),
('K002', 'Tindakan', 'TB027', 'Ektraksi Kuku', 86400, 57600, 144000, 50400, 7200),
('K002', 'Tindakan', 'TB026', 'Ekstirpasi', 54000, 36000, 90000, 31500, 4500),
('K002', 'Tindakan', 'TB025', 'Bedah Lipoma > 2 Cm', 169200, 112800, 282000, 98700, 14100),
('K002', 'Tindakan', 'TB024', 'Bedah Lipoma < 2 Cm', 100800, 67200, 168000, 58800, 8400),
('K002', 'Tindakan', 'TB023', 'Angkat Clavus > 2 Cm', 86400, 57600, 144000, 50400, 7200),
('K002', 'Tindakan', 'TB022', 'Angkat Clavus < 2 Cm', 72000, 48000, 120000, 42000, 6000),
('K002', 'Tindakan', 'TB021', 'Ganti Balutan Luka Besar', 25200, 16800, 42000, 14700, 2100),
('K002', 'Tindakan', 'TB020', 'Ganti Balutan Luka Sedang', 21600, 14400, 36000, 12600, 1800),
('K002', 'Tindakan', 'TB019', 'Ganti Balutan Luka Kecil', 18000, 12000, 30000, 10500, 1500),
('K002', 'Tindakan', 'TB018', 'Debridement Luka Besar', 57600, 38400, 96000, 33600, 4800),
('K002', 'Tindakan', 'TB017', 'Debridement Luka Sedang', 36000, 24000, 60000, 21000, 3000),
('K002', 'Tindakan', 'TB016', 'Debridement Luka Kecil', 21600, 14400, 36000, 12600, 1800),
('K002', 'Tindakan', 'TB015', 'WT Cross Insisi', 57600, 38400, 96000, 33600, 4800),
('K002', 'Tindakan', 'TB014', 'WT Luka Besar', 25200, 16800, 42000, 14700, 2100),
('K002', 'Tindakan', 'TB013', 'WT Luka Sedang', 21600, 14400, 36000, 12600, 1800),
('K002', 'Tindakan', 'TB012', 'WT Luka Kecil', 18000, 12000, 30000, 10500, 1500),
('K002', 'Tindakan', 'TB011', 'Angkat Jahitan > 30', 43200, 28800, 72000, 25200, 3600),
('K002', 'Tindakan', 'TB010', 'Angkat Jahitan 6-10', 36000, 24000, 60000, 21000, 3000),
('K002', 'Tindakan', 'TB009', 'Angkat Jahitan 1-5', 18000, 12000, 30000, 10500, 1500),
('K002', 'Tindakan', 'TB008', 'Jahit Luka  > 30', 115200, 76800, 192000, 67200, 9600),
('K002', 'Tindakan', 'TB007', 'Jahit Luka  21-30', 104400, 69600, 174000, 60900, 8700),
('K002', 'Tindakan', 'TB006', 'Jahit Luka  11-20', 97200, 64800, 162000, 56700, 8100),
('K002', 'Tindakan', 'TB005', 'Jahit Luka  7-10', 82800, 55200, 138000, 48300, 6900),
('K002', 'Tindakan', 'TB004', 'Jahit Luka  4-6', 64800, 43200, 108000, 37800, 5400),
('K002', 'Tindakan', 'TB003', 'Jahit Luka  1-3', 50400, 33600, 84000, 29400, 4200),
('K002', 'Tindakan', 'TB002', 'Tindakan Injeksi Khusus Pasien Bpjs', 15000, 10000, 25000, 8750, 1250),
('K002', 'Tindakan', 'TB001', 'Tindakan Injeksi', 18000, 12000, 30000, 10500, 1500),
('K001', 'Pemeriksaan', 'TA010', 'Cetak Ulang Kartu Pasien Elektronik', 5000, 0, 5000, 0, 0),
('K001', 'Pemeriksaan', 'TA009', 'Cetak Kartu Pasien Elektronik', 10000, 0, 10000, 0, 0),
('K001', 'Pemeriksaan', 'TA008', 'Jasa Driver - Muhajirin', 0, 10000, 10000, 10000, 0),
('K001', 'Pemeriksaan', 'TA007', 'Kunjungan Bidan Mandiri - Muhajirin', 0, 40000, 40000, 20000, 20000),
('K001', 'Pemeriksaan', 'TA006', 'Kunjungan Bidan Pendamping - Muhajirin', 0, 20000, 20000, 20000, 0),
('K001', 'Pemeriksaan', 'TA005', 'Kunjungan Dokter - Muhajirin', 0, 50000, 50000, 50000, 0),
('K001', 'Pemeriksaan', 'TA004', 'Surat Keterangan Sehat', 20000, 5000, 25000, 5000, 0),
('K001', 'Pemeriksaan', 'TA003', 'Pemeriksaan Bidan', 25000, 5000, 30000, 5000, 0),
('K001', 'Pemeriksaan', 'TA002', 'Pemeriksaan Dokter Gigi', 25000, 10000, 35000, 10000, 0),
('K001', 'Pemeriksaan', 'TA001', 'Pemeriksaan Dokter Umum', 30000, 10000, 40000, 10000, 0),
('K005', 'Laboratorium', 'TE2002', 'Albumin', 28000, 7000, 35000, 3500, 3500),
('K005', 'Laboratorium', 'TE2003', 'Globulin', 28000, 7000, 35000, 3500, 3500),
('K005', 'Laboratorium', 'TE2004', 'Bilirubin Total', 28000, 7000, 35000, 3500, 3500),
('K005', 'Laboratorium', 'TE2005', 'Bilirubin Direk', 28000, 7000, 35000, 3500, 3500),
('K005', 'Laboratorium', 'TE2006', 'Bilirubin Indirek', 28000, 7000, 35000, 3500, 3500),
('K005', 'Laboratorium', 'TE2007', 'SGOT', 24000, 6000, 30000, 3000, 3000),
('K005', 'Laboratorium', 'TE2008', 'SGPT', 24000, 6000, 30000, 3000, 3000),
('K005', 'Laboratorium', 'TE2009', 'Ureum', 28000, 7000, 35000, 3500, 3500),
('K005', 'Laboratorium', 'TE2010', 'Kreatinin', 28000, 7000, 35000, 3500, 3500),
('K005', 'Laboratorium', 'TE2011', 'Asam Urat', 28000, 7000, 35000, 3500, 3500),
('K005', 'Laboratorium', 'TE2012', 'Total - Cholesterol', 30000, 7500, 37500, 3750, 3750),
('K005', 'Laboratorium', 'TE2013', 'HDL - Cholesterol', 30000, 7500, 37500, 3750, 3750),
('K005', 'Laboratorium', 'TE2014', 'LDL - Cholesterol', 30000, 7500, 37500, 3750, 3750),
('K005', 'Laboratorium', 'TE2015', 'Triglyceride', 30000, 7500, 37500, 3750, 3750),
('K005', 'Laboratorium', 'TE2016', 'Gula Darah Sewaktu (GDS)', 30000, 5000, 35000, 2500, 2500),
('K005', 'Laboratorium', 'TE2017', 'Gula Darah Puasa (GDP)', 30000, 5000, 35000, 2500, 2500),
('K005', 'Laboratorium', 'TE2018', 'Gula Darah 2 Jam Pp (GD2JPP)', 30000, 5000, 35000, 2500, 2500),
('K005', 'Laboratorium', 'TE3001', 'Urin Rutin', 52000, 8000, 60000, 4000, 4000),
('K005', 'Laboratorium', 'TE3002', 'Urin Lengkap', 100000, 15000, 115000, 10000, 5000),
('K005', 'Laboratorium', 'TE3003', 'Beta HCG Test Pack', 60000, 15000, 75000, 7500, 7500),
('K005', 'Laboratorium', 'TE4001', 'HBsAg', 64000, 16000, 80000, 8000, 8000),
('K005', 'Laboratorium', 'TE4002', 'Widal', 56000, 14000, 70000, 7000, 7000),
('K005', 'Laboratorium', 'TE4003', 'Tes HIV', 80000, 20000, 100000, 10000, 10000),
('K005', 'Laboratorium', 'TE5001', 'Administrasi Lab Kiriman Dari Luar', 20000, 0, 20000, 0, 0),
('K006', 'Pelayanan BPJS', 'TF001', 'Pemeriksaan Dokter Umum - BPJS', 0, 0, 0, 2000, 0),
('K006', 'Pelayanan BPJS', 'TF002', 'Pemeriksaan Dokter Gigi - BPJS', 0, 0, 0, 2000, 0),
('K006', 'Pelayanan BPJS', 'TF003', 'Pemeriksaan Bidan - BPJS', 0, 0, 0, 2000, 0),
('K006', 'Pelayanan BPJS', 'TF005', 'Imunisasi TT - BPJS', 0, 2000, 2000, 2000, 0),
('K006', 'Pelayanan BPJS', 'TF006', 'Imunisasi DpPT - Polio + Obat - BPJS', 0, 2000, 2000, 2000, 0),
('K006', 'Pelayanan BPJS', 'TF007', 'Imunisasi BCG - BPJS', 0, 2000, 2000, 2000, 0),
('K006', 'Pelayanan BPJS', 'TF008', 'Imunisasi Campak - BPJS', 0, 2000, 2000, 2000, 0),
('K006', 'Pelayanan BPJS', 'TF009', 'Imunisasi Hb0 - BPJS', 0, 2000, 2000, 2000, 0),
('K006', 'Pelayanan BPJS', 'TF010', 'Suntik KB - BPJS', 0, 2000, 2000, 2000, 0),
('K006', 'Pelayanan BPJS', 'TF011', 'Usg Kandungan - BPJS', 40000, 10000, 50000, 10000, 0);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `tbl_tarif`
--
ALTER TABLE `tbl_tarif`
  ADD PRIMARY KEY (`kode_tindakan`);
COMMIT;

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