ID | prev_org | org | event | Prev_org_start_date | event_date |
---|---|---|---|---|---|
1 | - | A | Hire | NULL | 202301 |
1 | A | B | Transfer | 202301 | 202304 |
2 | - | A | Hire | NULL | 202301 |
2 | - | A | Leave | NULL | 202304 |
2 | - | A | Return | NULL | 202311 |
2 | A | B | Transfer | 202301 | 202401 |
(6 rows affected)
ID | prev_org | org | event | Prev_org_start_date | event_date |
---|---|---|---|---|---|
1 | - | A | Hire | NULL | 202301 |
1 | A | B | Transfer | 202301 | 202304 |
2 | - | A | Hire | NULL | 202301 |
2 | - | A | Leave | NULL | 202304 |
2 | - | A | Return | NULL | 202311 |
2 | A | B | Transfer | 202301 | 202401 |