|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/03/000043' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP017' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-03' AND `detail_periksa_lab`.`jam` = '14:51:20' AND `detail_periksa_lab`.`id_template` = 958
|
2022/10/03/000043 |
BP017 |
2022-10-03 |
14:51:20 |
958 |
|
|
|
18950 |
0 |
0 |
0 |
0 |
18950 |
0 |
37900 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/04/000141' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP012' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-04' AND `detail_periksa_lab`.`jam` = '18:55:39' AND `detail_periksa_lab`.`id_template` = 924
|
2022/10/04/000141 |
BP012 |
2022-10-04 |
18:55:39 |
924 |
|
|
|
23000 |
0 |
0 |
0 |
0 |
23000 |
0 |
46000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/04/000232' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP001' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-06' AND `detail_periksa_lab`.`jam` = '18:42:46' AND `detail_periksa_lab`.`id_template` = 752
|
2022/10/04/000232 |
BP001 |
2022-10-06 |
18:42:46 |
752 |
14.2 |
14 - 18 |
- |
23160 |
0 |
0 |
0 |
0 |
34740 |
0 |
57900 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/04/000232' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP001' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-06' AND `detail_periksa_lab`.`jam` = '18:42:46' AND `detail_periksa_lab`.`id_template` = 753
|
2022/10/04/000232 |
BP001 |
2022-10-06 |
18:42:46 |
753 |
8.200 |
5.000 - 10,000 |
|
27255 |
0 |
0 |
0 |
0 |
27255 |
0 |
54510 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/04/000232' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP015' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-06' AND `detail_periksa_lab`.`jam` = '18:55:00' AND `detail_periksa_lab`.`id_template` = 945
|
2022/10/04/000232 |
BP015 |
2022-10-06 |
18:55:00 |
945 |
230 |
|
|
23750 |
0 |
0 |
0 |
0 |
23750 |
0 |
47500 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/04/000232' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP015' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-06' AND `detail_periksa_lab`.`jam` = '18:55:00' AND `detail_periksa_lab`.`id_template` = 946
|
2022/10/04/000232 |
BP015 |
2022-10-06 |
18:55:00 |
946 |
185 |
|
|
23000 |
0 |
0 |
0 |
0 |
23000 |
0 |
46000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/04/000232' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP015' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-06' AND `detail_periksa_lab`.`jam` = '18:55:00' AND `detail_periksa_lab`.`id_template` = 947
|
2022/10/04/000232 |
BP015 |
2022-10-06 |
18:55:00 |
947 |
45 |
|
|
27600 |
0 |
0 |
0 |
0 |
27600 |
0 |
55200 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/04/000232' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP015' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-06' AND `detail_periksa_lab`.`jam` = '18:55:00' AND `detail_periksa_lab`.`id_template` = 948
|
2022/10/04/000232 |
BP015 |
2022-10-06 |
18:55:00 |
948 |
|
|
|
41975 |
0 |
0 |
0 |
0 |
41975 |
0 |
83950 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/10/000100' AND `detail_periksa_lab`.`kd_jenis_prw` = 'tarif TK lama1' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-18' AND `detail_periksa_lab`.`jam` = '12:08:34' AND `detail_periksa_lab`.`id_template` = 1102
|
2022/10/10/000100 |
tarif TK lama1 |
2022-10-18 |
12:08:34 |
1102 |
|
1 - 3 |
|
9000 |
0 |
0 |
0 |
0 |
0 |
0 |
9000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/10/000100' AND `detail_periksa_lab`.`kd_jenis_prw` = 'tarif TK lama1' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-18' AND `detail_periksa_lab`.`jam` = '12:08:34' AND `detail_periksa_lab`.`id_template` = 1103
|
2022/10/10/000100 |
tarif TK lama1 |
2022-10-18 |
12:08:34 |
1103 |
|
3 - 6 |
|
9000 |
0 |
0 |
0 |
0 |
0 |
0 |
9000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/10/000100' AND `detail_periksa_lab`.`kd_jenis_prw` = 'tarif TK lama17' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-18' AND `detail_periksa_lab`.`jam` = '12:14:00' AND `detail_periksa_lab`.`id_template` = 1299
|
2022/10/10/000100 |
tarif TK lama17 |
2022-10-18 |
12:14:00 |
1299 |
|
|
|
8500 |
0 |
0 |
0 |
0 |
3500 |
0 |
12000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/10/000100' AND `detail_periksa_lab`.`kd_jenis_prw` = 'tarif TK lama26' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-18' AND `detail_periksa_lab`.`jam` = '12:07:11' AND `detail_periksa_lab`.`id_template` = 1425
|
2022/10/10/000100 |
tarif TK lama26 |
2022-10-18 |
12:07:11 |
1425 |
|
|
|
33000 |
0 |
0 |
0 |
0 |
13000 |
0 |
46000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/10/000100' AND `detail_periksa_lab`.`kd_jenis_prw` = 'tarif TK lama26' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-18' AND `detail_periksa_lab`.`jam` = '12:15:17' AND `detail_periksa_lab`.`id_template` = 1425
|
2022/10/10/000100 |
tarif TK lama26 |
2022-10-18 |
12:15:17 |
1425 |
|
|
|
33000 |
0 |
0 |
0 |
0 |
13000 |
0 |
46000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/11/000053' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP001' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-11' AND `detail_periksa_lab`.`jam` = '11:56:56' AND `detail_periksa_lab`.`id_template` = 753
|
2022/10/11/000053 |
BP001 |
2022-10-11 |
11:56:56 |
753 |
54 |
5.000 - 10,000 |
|
27255 |
0 |
0 |
0 |
0 |
27255 |
0 |
54510 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/11/000053' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP001' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-11' AND `detail_periksa_lab`.`jam` = '11:56:56' AND `detail_periksa_lab`.`id_template` = 754
|
2022/10/11/000053 |
BP001 |
2022-10-11 |
11:56:56 |
754 |
87 |
150.000 - 450.000 |
|
29325 |
0 |
0 |
0 |
0 |
29325 |
0 |
58650 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/11/000053' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP001' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-11' AND `detail_periksa_lab`.`jam` = '11:56:56' AND `detail_periksa_lab`.`id_template` = 755
|
2022/10/11/000053 |
BP001 |
2022-10-11 |
11:56:56 |
755 |
|
40 - 48 |
|
27255 |
0 |
0 |
0 |
0 |
27255 |
0 |
54510 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/12/000083' AND `detail_periksa_lab`.`kd_jenis_prw` = 'tarif TK lama28' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-14' AND `detail_periksa_lab`.`jam` = '11:47:54' AND `detail_periksa_lab`.`id_template` = 1449
|
2022/10/12/000083 |
tarif TK lama28 |
2022-10-14 |
11:47:54 |
1449 |
|
|
|
85000 |
0 |
0 |
0 |
0 |
0 |
0 |
85000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/14/000022' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP003' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-14' AND `detail_periksa_lab`.`jam` = '12:35:11' AND `detail_periksa_lab`.`id_template` = 792
|
2022/10/14/000022 |
BP003 |
2022-10-14 |
12:35:11 |
792 |
68 |
< 200 |
|
9000 |
0 |
0 |
0 |
0 |
9000 |
0 |
18000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/14/000042' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP003' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-14' AND `detail_periksa_lab`.`jam` = '12:33:35' AND `detail_periksa_lab`.`id_template` = 792
|
2022/10/14/000042 |
BP003 |
2022-10-14 |
12:33:35 |
792 |
246 |
< 200 |
|
9000 |
0 |
0 |
0 |
0 |
9000 |
0 |
18000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/14/000050' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP003' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-14' AND `detail_periksa_lab`.`jam` = '12:37:29' AND `detail_periksa_lab`.`id_template` = 774
|
2022/10/14/000050 |
BP003 |
2022-10-14 |
12:37:29 |
774 |
7.9 |
3,4 - 7,0 |
|
15000 |
0 |
0 |
0 |
0 |
15000 |
0 |
30000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/14/000050' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP003' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-14' AND `detail_periksa_lab`.`jam` = '12:37:29' AND `detail_periksa_lab`.`id_template` = 787
|
2022/10/14/000050 |
BP003 |
2022-10-14 |
12:37:29 |
787 |
274 |
< 200 |
|
15000 |
0 |
0 |
0 |
0 |
15000 |
0 |
30000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/14/000050' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP003' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-14' AND `detail_periksa_lab`.`jam` = '12:37:29' AND `detail_periksa_lab`.`id_template` = 792
|
2022/10/14/000050 |
BP003 |
2022-10-14 |
12:37:29 |
792 |
115 |
< 200 |
|
9000 |
0 |
0 |
0 |
0 |
9000 |
0 |
18000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/14/000051' AND `detail_periksa_lab`.`kd_jenis_prw` = 'BP003' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-14' AND `detail_periksa_lab`.`jam` = '12:36:19' AND `detail_periksa_lab`.`id_template` = 792
|
2022/10/14/000051 |
BP003 |
2022-10-14 |
12:36:19 |
792 |
173 |
< 200 |
|
9000 |
0 |
0 |
0 |
0 |
9000 |
0 |
18000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/14/000052' AND `detail_periksa_lab`.`kd_jenis_prw` = 'tarif TK lama1' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-16' AND `detail_periksa_lab`.`jam` = '08:37:21' AND `detail_periksa_lab`.`id_template` = 1097
|
2022/10/14/000052 |
tarif TK lama1 |
2022-10-16 |
08:37:21 |
1097 |
|
150.000 - 450.000 |
|
36000 |
0 |
0 |
0 |
0 |
0 |
0 |
36000 |
|
Edit
|
Copy
|
Delete
DELETE FROM detail_periksa_lab WHERE `detail_periksa_lab`.`no_rawat` = '2022/10/14/000052' AND `detail_periksa_lab`.`kd_jenis_prw` = 'tarif TK lama1' AND `detail_periksa_lab`.`tgl_periksa` = '2022-10-16' AND `detail_periksa_lab`.`jam` = '08:37:21' AND `detail_periksa_lab`.`id_template` = 1098
|
2022/10/14/000052 |
tarif TK lama1 |
2022-10-16 |
08:37:21 |
1098 |
|
40 - 48 |
|
36000 |
0 |
0 |
0 |
0 |
0 |
0 |
36000 |