V2 rtds_episode
5,843,641 rows · 9 columns
| PATIENTID | RADIOTHERAPYEPISODEID | ATTENDID | APPTDATE | LINKCODE | DECISIONTOTREATDATE | EARLIESTCLINAPPROPDATE | RADIOTHERAPYPRIORITY | RADIOTHERAPYINTENT |
|---|---|---|---|---|---|---|---|---|
| 100012843 | 1072135 | 100125242.20171101 | 2017-11-01 | LUA | 2017-10-31 | 2017-10-30 | U | 1 |
| 100012843 | 1072135 | 100125242.20171105 | 2017-11-05 | LUA | 2017-10-31 | 2017-10-30 | U | 1 |
| 100012843 | 1072135 | 100125242.20171031 | 2017-10-31 | LUA | 2017-10-31 | 2017-10-30 | U | 1 |
| 100012844 | 1578150 | 100125243.20160611 | 2016-06-11 | LKD | 2016-06-09 | 2016-06-09 | null | 1 |
| 100012845 | 1518684 | 100125244.20190102 | 2019-01-02 | LDD | 2018-12-01 | 2018-12-04 | null | 1 |
| 100012845 | 1518684 | 100125244.20190105 | 2019-01-05 | LDD | 2018-12-01 | 2018-12-04 | null | 1 |
| 100012845 | 1779025 | 100145305.20190207 | 2019-02-07 | LXH | 2019-01-11 | 2019-01-19 | D | 1 |
| 100012845 | 1779025 | 100145305.20190211 | 2019-02-11 | LXH | 2019-01-11 | 2019-01-19 | D | 1 |
| 100012850 | 1523375 | 100145306.20190123 | 2019-01-23 | LHB | 2018-12-28 | null | R | 1 |
| 100012850 | 1717208 | 100125245.20180617 | 2018-06-17 | LPH | 2018-06-09 | 2018-06-11 | R | 1 |
| 100012850 | 1523375 | 100145306.20190201 | 2019-02-01 | LHB | 2018-12-28 | null | R | 1 |
| 100012850 | 1523375 | 100145306.20190131 | 2019-01-31 | LHB | 2018-12-28 | null | R | 1 |
| 100012850 | 1523375 | 100145306.20190130 | 2019-01-30 | LHB | 2018-12-28 | null | R | 1 |
| 100012850 | 1523375 | 100145306.20190129 | 2019-01-29 | LHB | 2018-12-28 | null | R | 1 |
| 100012850 | 1523375 | 100145306.20190128 | 2019-01-28 | LHB | 2018-12-28 | null | R | 1 |
| 100012850 | 1523375 | 100145306.20190127 | 2019-01-27 | LHB | 2018-12-28 | null | R | 1 |
| 100012850 | 1523375 | 100145306.20190126 | 2019-01-26 | LHB | 2018-12-28 | null | R | 1 |
| 100012851 | 1579671 | 100145307.20190111 | 2019-01-11 | LEJ | 2018-12-28 | 2019-01-01 | R | 1 |
| 100012851 | 1579671 | 100145307.20190123 | 2019-01-23 | LEJ | 2018-12-28 | 2019-01-01 | R | 1 |
| 100012851 | 1117227 | 100158818.20190919 | 2019-09-19 | LNG | 2019-08-14 | 2019-09-13 | null | 1 |
| 100012851 | 1117227 | 100158818.20190918 | 2019-09-18 | LNG | 2019-08-14 | 2019-09-13 | null | 1 |
| 100012851 | 1117227 | 100158818.20190917 | 2019-09-17 | LNG | 2019-08-14 | 2019-09-13 | null | 1 |
| 100012851 | 1117227 | 100158818.20190914 | 2019-09-14 | LNG | 2019-08-14 | 2019-09-13 | null | 1 |
| 100012851 | 1486935 | 100125246.20181023 | 2018-10-23 | LPO | 2018-09-26 | null | null | 1 |
| 100012851 | 1579671 | 100145307.20190112 | 2019-01-12 | LEJ | 2018-12-28 | 2019-01-01 | R | 1 |
| 100012851 | 1579671 | 100145307.20190113 | 2019-01-13 | LEJ | 2018-12-28 | 2019-01-01 | R | 1 |
| 100012851 | 1579671 | 100145307.20190118 | 2019-01-18 | LEJ | 2018-12-28 | 2019-01-01 | R | 1 |
| 100012851 | 1579671 | 100145307.20190119 | 2019-01-19 | LEJ | 2018-12-28 | 2019-01-01 | R | 1 |
| 100012851 | 1579671 | 100145307.20190120 | 2019-01-20 | LEJ | 2018-12-28 | 2019-01-01 | R | 1 |
| 100012851 | 1579671 | 100145307.20190121 | 2019-01-21 | LEJ | 2018-12-28 | 2019-01-01 | R | 1 |
| 100012851 | 1579671 | 100145307.20190122 | 2019-01-22 | LEJ | 2018-12-28 | 2019-01-01 | R | 1 |
| 100012852 | 1720645 | 100125247.20160120 | 2016-01-20 | LSL | 2016-01-09 | 2016-01-09 | R | 1 |
| 100012854 | 1790597 | 100125248.20160519 | 2016-05-19 | LPA | 2016-05-19 | 2016-05-19 | null | 1 |
| 100012855 | 1376485 | 100145308.20170704 | 2017-07-04 | LSL | 2017-06-21 | null | R | 1 |
| 100012855 | 1779279 | 100125249.20170630 | 2017-06-30 | LAM | 2017-06-18 | 2017-06-19 | R | 1 |
| 100012855 | 1779279 | 100125249.20170701 | 2017-07-01 | LAM | 2017-06-18 | 2017-06-19 | R | 1 |
| 100012855 | 1779279 | 100125249.20170702 | 2017-07-02 | LAM | 2017-06-18 | 2017-06-19 | R | 1 |
| 100012855 | 1318900 | 100158819.20180201 | 2018-02-01 | LKD | 2018-01-18 | 2018-01-22 | R | 1 |
| 100012855 | 1318900 | 100158819.20180204 | 2018-02-04 | LKD | 2018-01-18 | 2018-01-22 | R | 1 |
| 100012855 | 1318900 | 100158819.20180207 | 2018-02-07 | LKD | 2018-01-18 | 2018-01-22 | R | 1 |
| 100012858 | 1172612 | 100125250.20161029 | 2016-10-29 | LCH | 2016-10-08 | 2016-10-08 | R | 1 |
| 100012858 | 1482884 | 100145309.20161208 | 2016-12-08 | LLX | 2016-11-25 | 2016-12-08 | R | 1 |
| 100012858 | 1482884 | 100145309.20161209 | 2016-12-09 | LLX | 2016-11-25 | 2016-12-08 | R | 1 |
| 100012858 | 1482884 | 100145309.20161210 | 2016-12-10 | LLX | 2016-11-25 | 2016-12-08 | R | 1 |
| 100012858 | 1482884 | 100145309.20161211 | 2016-12-11 | LLX | 2016-11-25 | 2016-12-08 | R | 1 |
| 100012858 | 1482884 | 100145309.20161212 | 2016-12-12 | LLX | 2016-11-25 | 2016-12-08 | R | 1 |
| 100012858 | 1482884 | 100145309.20161213 | 2016-12-13 | LLX | 2016-11-25 | 2016-12-08 | R | 1 |
| 100012858 | 1482884 | 100145309.20161214 | 2016-12-14 | LLX | 2016-11-25 | 2016-12-08 | R | 1 |
| 100012858 | 1482884 | 100145309.20161218 | 2016-12-18 | LLX | 2016-11-25 | 2016-12-08 | R | 1 |
| 100012858 | 1172612 | 100125250.20161030 | 2016-10-30 | LCH | 2016-10-08 | 2016-10-08 | R | 1 |