By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| ClaimID | Patient | Facility | ClaimFromDate | ClaimToDate | GroupID | flag | encounter |
|---|---|---|---|---|---|---|---|
| Claim1 | JOHN DOE | NURSING HOME | 01/01/2000 00:00:00 | 01/01/2000 00:00:00 | 1 | 0 | 1 |
| Claim2 | JOHN DOE | NURSING HOME | 01/01/2000 00:00:00 | 31/01/2000 00:00:00 | 1 | 0 | 1 |
| Claim3 | JOHN DOE | NURSING HOME | 01/01/2000 00:00:00 | 31/01/2000 00:00:00 | 1 | 0 | 1 |
| Claim4 | JOHN DOE | NURSING HOME | 01/01/2000 00:00:00 | 31/01/2000 00:00:00 | 1 | 0 | 1 |
| Claim5 | JOHN DOE | NURSING HOME | 01/02/2000 00:00:00 | 29/02/2000 00:00:00 | 1 | 0 | 1 |
| Claim6 | JOHN DOE | NURSING HOME | 01/03/2000 00:00:00 | 31/03/2000 00:00:00 | 1 | 0 | 1 |
| Claim7 | JOHN DOE | NURSING HOME | 01/04/2000 00:00:00 | 30/04/2000 00:00:00 | 1 | 0 | 1 |
| Claim8 | JOHN DOE | NURSING HOME | 01/08/2000 00:00:00 | 31/08/2000 00:00:00 | 1 | 1 | 2 |
| Claim9 | JOHN DOE | NURSING HOME | 01/09/2000 00:00:00 | 30/09/2000 00:00:00 | 1 | 0 | 2 |
| Claim10 | JANE DOE | HOME HEALTH | 01/02/2000 00:00:00 | 29/02/2000 00:00:00 | 2 | 0 | 1 |
| Claim11 | JANE DOE | HOME HEALTH | 01/03/2000 00:00:00 | 31/03/2000 00:00:00 | 2 | 0 | 1 |