By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
1 rows affected
2 rows affected
Med_Rec_No | PtNo_Num | Adm_Date | Dsch_Date | hosp_svc | hosp_svc_name | Readmit Status | Event_Num | Keep_Flag |
---|---|---|---|---|---|---|---|---|
123456 | 123456748 | 18/12/2017 00:00:00 | 12/01/2018 00:00:00 | PSY | Pyschiatry | No | 1 | 1 |
123456 | 123456789 | 17/01/2018 00:00:00 | 18/01/2018 00:00:00 | EME | Emergency Department | No | 2 | 2 |
123456 | 123456889 | 19/01/2018 00:00:00 | 21/01/2018 00:00:00 | EME | Emergency Department | No | 3 | 3 |
123456 | 123478978 | 25/01/2018 00:00:00 | 25/01/2018 00:00:00 | EME | Emergency Department | No | 4 | 4 |
123456 | 123457979 | 21/05/2018 00:00:00 | 21/05/2018 00:00:00 | EME | Emergency Department | No | 5 | 5 |
123456 | 123458988 | 03/06/2018 00:00:00 | 04/06/2018 00:00:00 | EME | Emergency Department | No | 6 | 6 |
123456 | 123458989 | 27/07/2018 00:00:00 | 14/08/2018 00:00:00 | PSY | Pyschiatry | No | 7 | 7 |
123456 | 123458990 | 23/09/2018 00:00:00 | 24/09/2018 00:00:00 | EME | Emergency Department | Yes | 8 | 8 |
123456 | 123459999 | 25/09/2018 00:00:00 | 30/09/2018 00:00:00 | PSY | Pyschiatry | No | 9 | 9 |
Med_Rec_No | PtNo_Num | Adm_Date | Dsch_Date | hosp_svc | hosp_svc_name | Readmit Status | Event_Num | Keep_Flag |
---|---|---|---|---|---|---|---|---|
123456 | 123456748 | 18/12/2017 00:00:00 | 12/01/2018 00:00:00 | PSY | Pyschiatry | No | 1 | 1 |
123456 | 123456789 | 17/01/2018 00:00:00 | 18/01/2018 00:00:00 | EME | Emergency Department | No | 2 | 2 |
123456 | 123456889 | 19/01/2018 00:00:00 | 21/01/2018 00:00:00 | EME | Emergency Department | No | 3 | 3 |
123456 | 123478978 | 25/01/2018 00:00:00 | 25/01/2018 00:00:00 | EME | Emergency Department | No | 4 | 4 |
123456 | 123457979 | 21/05/2018 00:00:00 | 21/05/2018 00:00:00 | EME | Emergency Department | No | 5 | 5 |
123456 | 123458988 | 03/06/2018 00:00:00 | 04/06/2018 00:00:00 | EME | Emergency Department | No | 6 | 6 |
123456 | 123458989 | 27/07/2018 00:00:00 | 14/08/2018 00:00:00 | PSY | Pyschiatry | No | 7 | 7 |
123456 | 123458990 | 23/09/2018 00:00:00 | 24/09/2018 00:00:00 | EME | Emergency Department | Yes | 8 | 8 |
123456 | 123459999 | 25/09/2018 00:00:00 | 30/09/2018 00:00:00 | PSY | Pyschiatry | No | 9 | 9 |