V2 rtds_episode
5,843,641 rows · 9 columns
| PATIENTID | RADIOTHERAPYEPISODEID | ATTENDID | APPTDATE | LINKCODE | DECISIONTOTREATDATE | EARLIESTCLINAPPROPDATE | RADIOTHERAPYPRIORITY | RADIOTHERAPYINTENT |
|---|---|---|---|---|---|---|---|---|
| 100029346 | 1184143 | 100181874.20180504 | 2018-05-04 | LFT | 2018-04-01 | null | R | 2 |
| 100029346 | 1321268 | 100175522.20180305 | 2018-03-05 | LNM | 2018-02-07 | 2018-02-12 | R | 2 |
| 100029346 | 1321268 | 100175522.20180306 | 2018-03-06 | LNM | 2018-02-07 | 2018-02-12 | R | 2 |
| 100029346 | 1321268 | 100175522.20180310 | 2018-03-10 | LNM | 2018-02-07 | 2018-02-12 | R | 2 |
| 100029346 | 1321268 | 100175522.20180311 | 2018-03-11 | LNM | 2018-02-07 | 2018-02-12 | R | 2 |
| 100029346 | 1321268 | 100175522.20180312 | 2018-03-12 | LNM | 2018-02-07 | 2018-02-12 | R | 2 |
| 100029347 | 1918263 | 100108095.20190307 | 2019-03-07 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190308 | 2019-03-08 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190309 | 2019-03-09 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190310 | 2019-03-10 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190311 | 2019-03-11 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190312 | 2019-03-12 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190313 | 2019-03-13 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190314 | 2019-03-14 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190315 | 2019-03-15 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190316 | 2019-03-16 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190317 | 2019-03-17 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190318 | 2019-03-18 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190319 | 2019-03-19 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190322 | 2019-03-22 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029347 | 1918263 | 100108095.20190323 | 2019-03-23 | LQZ | 2019-02-16 | 2019-02-16 | R | 2 |
| 100029349 | 1072877 | 100108096.20181218 | 2018-12-18 | LCH | 2018-11-23 | 2018-11-23 | R | 2 |
| 100029351 | 1008785 | 100108097.20170609 | 2017-06-09 | LDR | 2017-05-19 | 2017-05-17 | D | 2 |
| 100029351 | 1008785 | 100108097.20170611 | 2017-06-11 | LDR | 2017-05-19 | 2017-05-17 | D | 2 |
| 100029351 | 1008785 | 100108097.20170612 | 2017-06-12 | LDR | 2017-05-19 | 2017-05-17 | D | 2 |
| 100029351 | 1008785 | 100108097.20170613 | 2017-06-13 | LDR | 2017-05-19 | 2017-05-17 | D | 2 |
| 100029351 | 1008785 | 100108097.20170614 | 2017-06-14 | LDR | 2017-05-19 | 2017-05-17 | D | 2 |
| 100029352 | 1050894 | 100108098.20180323 | 2018-03-23 | LOS | 2018-03-06 | 2018-03-07 | U | 2 |
| 100029353 | 1541203 | 100108099.20170416 | 2017-04-16 | LPH | 2017-03-23 | 2017-03-21 | R | 2 |
| 100029353 | 1541203 | 100108099.20170417 | 2017-04-17 | LPH | 2017-03-23 | 2017-03-21 | R | 2 |
| 100029353 | 1541203 | 100108099.20170420 | 2017-04-20 | LPH | 2017-03-23 | 2017-03-21 | R | 2 |
| 100029353 | 1541203 | 100108099.20170421 | 2017-04-21 | LPH | 2017-03-23 | 2017-03-21 | R | 2 |
| 100029353 | 1541203 | 100108099.20170423 | 2017-04-23 | LPH | 2017-03-23 | 2017-03-21 | R | 2 |
| 100029353 | 1541203 | 100108099.20170426 | 2017-04-26 | LPH | 2017-03-23 | 2017-03-21 | R | 2 |
| 100029355 | 1707731 | 100108100.20190828 | 2019-08-28 | LHD | 2019-07-18 | 2019-08-07 | R | 2 |
| 100029355 | 1707731 | 100108100.20190831 | 2019-08-31 | LHD | 2019-07-18 | 2019-08-07 | R | 2 |
| 100029355 | 1707731 | 100108100.20190901 | 2019-09-01 | LHD | 2019-07-18 | 2019-08-07 | R | 2 |
| 100029355 | 1707731 | 100108100.20190902 | 2019-09-02 | LHD | 2019-07-18 | 2019-08-07 | R | 2 |
| 100029357 | 1583611 | 100108101.20161023 | 2016-10-23 | LPA | 2016-04-19 | 2016-10-23 | U | 2 |
| 100029357 | 1583611 | 100108101.20161024 | 2016-10-24 | LPA | 2016-04-19 | 2016-10-23 | U | 2 |
| 100029357 | 1583611 | 100108101.20161027 | 2016-10-27 | LPA | 2016-04-19 | 2016-10-23 | U | 2 |
| 100029357 | 1583611 | 100108101.20161028 | 2016-10-28 | LPA | 2016-04-19 | 2016-10-23 | U | 2 |
| 100029358 | 1645984 | 100108102.20170503 | 2017-05-03 | LQZ | 2017-04-17 | 2017-04-13 | R | 2 |
| 100029358 | 1645984 | 100108102.20170504 | 2017-05-04 | LQZ | 2017-04-17 | 2017-04-13 | R | 2 |
| 100029358 | 1645984 | 100108102.20170505 | 2017-05-05 | LQZ | 2017-04-17 | 2017-04-13 | R | 2 |
| 100029358 | 1645984 | 100108102.20170506 | 2017-05-06 | LQZ | 2017-04-17 | 2017-04-13 | R | 2 |
| 100029358 | 1645984 | 100108102.20170507 | 2017-05-07 | LQZ | 2017-04-17 | 2017-04-13 | R | 2 |
| 100029358 | 1645984 | 100108102.20170508 | 2017-05-08 | LQZ | 2017-04-17 | 2017-04-13 | R | 2 |
| 100029358 | 1203273 | 100175523.20171002 | 2017-10-02 | LJX | 2017-09-11 | 2017-09-13 | D | 2 |
| 100029358 | 1203273 | 100175523.20171003 | 2017-10-03 | LJX | 2017-09-11 | 2017-09-13 | D | 2 |