By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
19 rows affected
| Id | AuthFromDate | AuthThruDate | IneligibleFromDate | IneligibleThruDate |
|---|---|---|---|---|
| 118206307 | 2023-08-30 | 2024-02-17 | 2023-10-01 | 2023-10-19 |
| 121212121 | 2024-01-01 | 2024-01-31 | 2024-01-01 | 2024-01-01 |
| 121212121 | 2024-01-01 | 2024-01-31 | 2024-01-31 | 2024-01-31 |
| 222222222 | 2024-01-01 | 2024-01-31 | 2024-01-01 | 2024-01-04 |
| 222222222 | 2024-01-01 | 2024-01-31 | 2024-01-11 | 2024-01-14 |
| 222222222 | 2024-01-01 | 2024-01-31 | 2024-01-21 | 2024-01-24 |
| 222222222 | 2024-01-01 | 2024-01-31 | 2024-01-31 | 2024-01-31 |
| 333333333 | 2024-03-01 | 2024-03-31 | 2024-03-11 | 2024-03-14 |
| 333333333 | 2024-03-01 | 2024-03-31 | 2024-03-21 | 2024-03-24 |
| Id | FromDate | ToDate | AuthFromDate | AuthToDate | EligFromDate | EligToDate |
|---|---|---|---|---|---|---|
| 118206307 | null | 2022-04-22 | null | null | null | null |
| 118206307 | 2022-04-22 | 2023-01-02 | null | null | 2022-04-22 | 2023-10-01 |
| 118206307 | 2023-01-02 | 2023-06-08 | 2023-01-02 | 2023-06-08 | 2022-04-22 | 2023-10-01 |
| 118206307 | 2023-06-08 | 2023-08-30 | null | null | 2022-04-22 | 2023-10-01 |
| 118206307 | 2023-08-30 | 2023-10-01 | 2023-08-30 | 2024-02-18 | 2022-04-22 | 2023-10-01 |
| 118206307 | 2023-10-01 | 2023-10-20 | 2023-08-30 | 2024-02-18 | null | null |
| 118206307 | 2023-10-20 | 2024-02-18 | 2023-08-30 | 2024-02-18 | 2023-10-20 | 9999-12-31 |
| 118206307 | 2024-02-18 | 9999-12-31 | null | null | 2023-10-20 | 9999-12-31 |
| 121212121 | null | 2024-01-01 | null | null | null | null |
| 121212121 | 2024-01-01 | 2024-01-02 | 2024-01-01 | 2024-02-01 | null | null |
| 121212121 | 2024-01-02 | 2024-01-31 | 2024-01-01 | 2024-02-01 | 2024-01-02 | 2024-01-31 |
| 121212121 | 2024-01-31 | 2024-02-01 | 2024-01-01 | 2024-02-01 | null | null |
| 222222222 | null | 2024-01-01 | null | null | null | null |
| 222222222 | 2024-01-01 | 2024-01-05 | 2024-01-01 | 2024-02-01 | null | null |
| 222222222 | 2024-01-05 | 2024-01-11 | 2024-01-01 | 2024-02-01 | 2024-01-05 | 2024-01-11 |
| 222222222 | 2024-01-11 | 2024-01-15 | 2024-01-01 | 2024-02-01 | null | null |
| 222222222 | 2024-01-15 | 2024-01-21 | 2024-01-01 | 2024-02-01 | 2024-01-15 | 2024-01-21 |
| 222222222 | 2024-01-21 | 2024-01-25 | 2024-01-01 | 2024-02-01 | null | null |
| 222222222 | 2024-01-25 | 2024-01-31 | 2024-01-01 | 2024-02-01 | 2024-01-25 | 2024-01-31 |
| 222222222 | 2024-01-31 | 2024-02-01 | 2024-01-01 | 2024-02-01 | null | null |
| 333333333 | null | 2024-01-01 | null | null | null | null |
| 333333333 | 2024-01-01 | 2024-03-01 | null | null | 2024-01-01 | 2024-03-11 |
| 333333333 | 2024-03-01 | 2024-03-11 | 2024-03-01 | 2024-04-01 | 2024-01-01 | 2024-03-11 |
| 333333333 | 2024-03-11 | 2024-03-15 | 2024-03-01 | 2024-04-01 | null | null |
| 333333333 | 2024-03-15 | 2024-03-21 | 2024-03-01 | 2024-04-01 | 2024-03-15 | 2024-03-21 |
| 333333333 | 2024-03-21 | 2024-03-25 | 2024-03-01 | 2024-04-01 | null | null |
| 333333333 | 2024-03-25 | 2024-04-01 | 2024-03-01 | 2024-04-01 | 2024-03-25 | 2025-01-01 |
| 333333333 | 2024-04-01 | 2025-01-01 | null | null | 2024-03-25 | 2025-01-01 |
| 444444444 | null | 2024-04-01 | null | null | null | null |
| 444444444 | 2024-04-01 | 2024-04-16 | 2024-04-01 | 2024-05-01 | 2024-04-01 | 2024-04-16 |
| 444444444 | 2024-04-16 | 2024-05-01 | 2024-04-01 | 2024-05-01 | 2024-04-16 | 2024-05-16 |
| 444444444 | 2024-05-01 | 2024-05-16 | 2024-05-01 | 2024-06-01 | 2024-04-16 | 2024-05-16 |
| 444444444 | 2024-05-16 | 2024-06-01 | 2024-05-01 | 2024-06-01 | 2024-05-16 | 2024-06-01 |
| 555555555 | null | 2024-01-01 | null | null | null | null |
| 555555555 | 2024-01-01 | 2024-06-01 | null | null | 2024-01-01 | 2024-06-21 |
| 555555555 | 2024-06-01 | 2024-06-10 | 2024-06-01 | 2024-07-01 | 2024-01-01 | 2024-06-21 |
| 555555555 | 2024-06-10 | 2024-06-21 | 2024-06-01 | 2024-07-01 | 2024-01-01 | 2024-06-21 |
| 555555555 | 2024-06-10 | 2024-06-21 | 2024-06-01 | 2024-07-01 | 2024-06-10 | 2025-01-01 |
| 555555555 | 2024-06-21 | 2024-07-01 | 2024-06-01 | 2024-07-01 | 2024-06-10 | 2025-01-01 |
| 555555555 | 2024-07-01 | 2025-01-01 | null | null | 2024-06-10 | 2025-01-01 |