-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathRAWAT_INAP.sql
More file actions
40 lines (40 loc) · 6.13 KB
/
RAWAT_INAP.sql
File metadata and controls
40 lines (40 loc) · 6.13 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
INSERT INTO rawat_inap VALUES ('RI00000001','RM00000001','KMR0000001','PRW0000001',TO_DATE('2019-07-22', 'YYYY-MM-DD'),TO_DATE('2019-07-23', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000002','RM00000002','KMR0000002','PRW0000002',TO_DATE('2019-07-23', 'YYYY-MM-DD'),TO_DATE('2019-07-24', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000003','RM00000003','KMR0000003','PRW0000003',TO_DATE('2019-07-24', 'YYYY-MM-DD'),TO_DATE('2019-07-25', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000004','RM00000004','KMR0000004','PRW0000004',TO_DATE('2019-07-25', 'YYYY-MM-DD'),TO_DATE('2019-07-26', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000005','RM00000005','KMR0000005','PRW0000005',TO_DATE('2019-07-26', 'YYYY-MM-DD'),TO_DATE('2019-07-27', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000006','RM00000006','KMR0000006','PRW0000006',TO_DATE('2019-07-27', 'YYYY-MM-DD'),TO_DATE('2019-07-28', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000007','RM00000007','KMR0000007','PRW0000007',TO_DATE('2019-07-28', 'YYYY-MM-DD'),TO_DATE('2019-07-29', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000008','RM00000008','KMR0000008','PRW0000008',TO_DATE('2019-07-29', 'YYYY-MM-DD'),TO_DATE('2019-07-30', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000009','RM00000009','KMR0000009','PRW0000009',TO_DATE('2019-08-01', 'YYYY-MM-DD'),TO_DATE('2019-08-02', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000010','RM00000010','KMR0000010','PRW0000010',TO_DATE('2019-08-02', 'YYYY-MM-DD'),TO_DATE('2019-08-03', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000011','RM00000011','KMR0000011','PRW0000011',TO_DATE('2019-08-03', 'YYYY-MM-DD'),TO_DATE('2019-08-04', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000012','RM00000012','KMR0000012','PRW0000012',TO_DATE('2019-08-04', 'YYYY-MM-DD'),TO_DATE('2019-08-05', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000013','RM00000013','KMR0000013','PRW0000013',TO_DATE('2019-08-05', 'YYYY-MM-DD'),TO_DATE('2019-08-06', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000014','RM00000014','KMR0000014','PRW0000014',TO_DATE('2019-08-06', 'YYYY-MM-DD'),TO_DATE('2019-08-07', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000015','RM00000015','KMR0000015','PRW0000015',TO_DATE('2019-08-07', 'YYYY-MM-DD'),TO_DATE('2019-08-08', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000016','RM00000016','KMR0000016','PRW0000016',TO_DATE('2019-08-08', 'YYYY-MM-DD'),TO_DATE('2019-08-09', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000017','RM00000017','KMR0000017','PRW0000017',TO_DATE('2019-08-09', 'YYYY-MM-DD'),TO_DATE('2019-08-10', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000018','RM00000018','KMR0000018','PRW0000018',TO_DATE('2019-08-10', 'YYYY-MM-DD'),TO_DATE('2019-08-11', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000019','RM00000019','KMR0000019','PRW0000019',TO_DATE('2019-08-11', 'YYYY-MM-DD'),TO_DATE('2019-08-12', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000020','RM00000020','KMR0000020','PRW0000020',TO_DATE('2019-08-12', 'YYYY-MM-DD'),TO_DATE('2019-08-13', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000021','RM00000021','KMR0000021','PRW0000021',TO_DATE('2019-07-22', 'YYYY-MM-DD'),TO_DATE('2019-07-23', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000022','RM00000022','KMR0000022','PRW0000022',TO_DATE('2019-07-23', 'YYYY-MM-DD'),TO_DATE('2019-07-24', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000023','RM00000023','KMR0000023','PRW0000023',TO_DATE('2019-07-24', 'YYYY-MM-DD'),TO_DATE('2019-07-25', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000024','RM00000024','KMR0000024','PRW0000024',TO_DATE('2019-07-25', 'YYYY-MM-DD'),TO_DATE('2019-07-26', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000025','RM00000025','KMR0000025','PRW0000025',TO_DATE('2019-07-26', 'YYYY-MM-DD'),TO_DATE('2019-07-27', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000026','RM00000026','KMR0000026','PRW0000026',TO_DATE('2019-07-27', 'YYYY-MM-DD'),TO_DATE('2019-07-28', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000027','RM00000028','KMR0000027','PRW0000027',TO_DATE('2019-07-28', 'YYYY-MM-DD'),TO_DATE('2019-07-29', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000028','RM00000029','KMR0000028','PRW0000028',TO_DATE('2019-07-29', 'YYYY-MM-DD'),TO_DATE('2019-07-30', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000029','RM00000030','KMR0000029','PRW0000029',TO_DATE('2019-08-01', 'YYYY-MM-DD'),TO_DATE('2019-08-02', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000030','RM00000031','KMR0000030','PRW0000030',TO_DATE('2019-08-02', 'YYYY-MM-DD'),TO_DATE('2019-08-03', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000031','RM00000032','KMR0000031','PRW0000031',TO_DATE('2019-08-03', 'YYYY-MM-DD'),TO_DATE('2019-08-04', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000032','RM00000033','KMR0000032','PRW0000032',TO_DATE('2019-08-04', 'YYYY-MM-DD'),TO_DATE('2019-08-05', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000033','RM00000034','KMR0000033','PRW0000033',TO_DATE('2019-08-05', 'YYYY-MM-DD'),TO_DATE('2019-08-06', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000034','RM00000035','KMR0000034','PRW0000034',TO_DATE('2019-08-06', 'YYYY-MM-DD'),TO_DATE('2019-08-07', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000035','RM00000036','KMR0000035','PRW0000035',TO_DATE('2019-08-07', 'YYYY-MM-DD'),TO_DATE('2019-08-08', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000036','RM00000037','KMR0000036','PRW0000036',TO_DATE('2019-08-08', 'YYYY-MM-DD'),TO_DATE('2019-08-09', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000037','RM00000038','KMR0000037','PRW0000037',TO_DATE('2019-08-09', 'YYYY-MM-DD'),TO_DATE('2019-08-10', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000038','RM00000039','KMR0000038','PRW0000038',TO_DATE('2019-08-10', 'YYYY-MM-DD'),TO_DATE('2019-08-11', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000039','RM00000040','KMR0000039','PRW0000039',TO_DATE('2019-08-11', 'YYYY-MM-DD'),TO_DATE('2019-08-12', 'YYYY-MM-DD'));
INSERT INTO rawat_inap VALUES ('RI00000040','RM00000041','KMR0000040','PRW0000040',TO_DATE('2019-08-12', 'YYYY-MM-DD'),TO_DATE('2019-08-13', 'YYYY-MM-DD'));