V2 rtds_episode
5,843,641 rows · 9 columns
| PATIENTID | RADIOTHERAPYEPISODEID | ATTENDID | APPTDATE | LINKCODE | DECISIONTOTREATDATE | EARLIESTCLINAPPROPDATE | RADIOTHERAPYPRIORITY | RADIOTHERAPYINTENT |
|---|---|---|---|---|---|---|---|---|
| 210003563 | 1979845 | 210003563.20190225 | 2019-02-25 | LPA | null | null | null | 1 |
| 210003563 | 1979845 | 210003563.20190226 | 2019-02-26 | LPA | null | null | null | 1 |
| 210003563 | 1979845 | 210003563.20190227 | 2019-02-27 | LPA | null | null | null | 1 |
| 210003563 | 1979845 | 210003563.20190228 | 2019-02-28 | LPA | null | null | null | 1 |
| 210003563 | 1979845 | 210003563.20190303 | 2019-03-03 | LPA | null | null | null | 1 |
| 210003563 | 1979845 | 210003563.20190304 | 2019-03-04 | LPA | null | null | null | 1 |
| 210003563 | 1979845 | 210003563.20190305 | 2019-03-05 | LPA | null | null | null | 1 |
| 210003563 | 1979845 | 210003563.20190306 | 2019-03-06 | LPA | null | null | null | 1 |
| 210003563 | 1979845 | 210003563.20190307 | 2019-03-07 | LPA | null | null | null | 1 |
| 210003563 | 1979845 | 210003563.20190308 | 2019-03-08 | LPA | null | null | null | 1 |
| 210001125 | 1310243 | 210003929.20170321 | 2017-03-21 | LPH | 2017-02-26 | null | R | 2 |
| 210001125 | 1310243 | 210003929.20170322 | 2017-03-22 | LPH | 2017-02-26 | null | R | 2 |
| 210000001 | 1536474 | 210004063.20191016 | 2019-10-16 | LMA | 2019-09-15 | 2019-10-13 | R | 2 |
| 210000001 | 1536474 | 210004063.20191019 | 2019-10-19 | LMA | 2019-09-15 | 2019-10-13 | R | 2 |
| 210000001 | 1536474 | 210004063.20191020 | 2019-10-20 | LMA | 2019-09-15 | 2019-10-13 | R | 2 |
| 210000002 | 1597469 | 210004064.20190102 | 2019-01-02 | LGA | 2018-10-30 | 2018-11-26 | R | 2 |
| 210000002 | 1597469 | 210004064.20190103 | 2019-01-03 | LGA | 2018-10-30 | 2018-11-26 | R | 2 |
| 210000002 | 1597469 | 210004064.20190106 | 2019-01-06 | LGA | 2018-10-30 | 2018-11-26 | R | 2 |
| 210000002 | 1597469 | 210004064.20190107 | 2019-01-07 | LGA | 2018-10-30 | 2018-11-26 | R | 2 |
| 210000002 | 1597469 | 210004064.20190111 | 2019-01-11 | LGA | 2018-10-30 | 2018-11-26 | R | 2 |
| 210000002 | 1597469 | 210004064.20190113 | 2019-01-13 | LGA | 2018-10-30 | 2018-11-26 | R | 2 |
| 210000002 | 1597469 | 210004064.20190114 | 2019-01-14 | LGA | 2018-10-30 | 2018-11-26 | R | 2 |
| 210000002 | 1597469 | 210004064.20190115 | 2019-01-15 | LGA | 2018-10-30 | 2018-11-26 | R | 2 |
| 210000002 | 1597469 | 210004064.20190116 | 2019-01-16 | LGA | 2018-10-30 | 2018-11-26 | R | 2 |
| 210000002 | 1597469 | 210004064.20190117 | 2019-01-17 | LGA | 2018-10-30 | 2018-11-26 | R | 2 |
| 210000003 | 1709199 | 210004065.20181110 | 2018-11-10 | LLT | 2018-10-01 | null | R | 2 |
| 210000003 | 1709199 | 210004065.20181111 | 2018-11-11 | LLT | 2018-10-01 | null | R | 2 |
| 210000003 | 1709199 | 210004065.20181112 | 2018-11-12 | LLT | 2018-10-01 | null | R | 2 |
| 210000003 | 1709199 | 210004065.20181113 | 2018-11-13 | LLT | 2018-10-01 | null | R | 2 |
| 210000003 | 1709199 | 210004065.20181116 | 2018-11-16 | LLT | 2018-10-01 | null | R | 2 |
| 210000004 | 1693172 | 210004066.20190710 | 2019-07-10 | LEJ | 2019-06-12 | 2019-07-10 | R | 2 |
| 210000004 | 1693172 | 210004066.20190711 | 2019-07-11 | LEJ | 2019-06-12 | 2019-07-10 | R | 2 |
| 210000004 | 1693172 | 210004066.20190712 | 2019-07-12 | LEJ | 2019-06-12 | 2019-07-10 | R | 2 |
| 210000004 | 1693172 | 210004066.20190715 | 2019-07-15 | LEJ | 2019-06-12 | 2019-07-10 | R | 2 |
| 210000004 | 1693172 | 210004066.20190716 | 2019-07-16 | LEJ | 2019-06-12 | 2019-07-10 | R | 2 |
| 210000004 | 1693172 | 210004066.20190719 | 2019-07-19 | LEJ | 2019-06-12 | 2019-07-10 | R | 2 |
| 210000004 | 1693172 | 210004066.20190720 | 2019-07-20 | LEJ | 2019-06-12 | 2019-07-10 | R | 2 |
| 210000004 | 1693172 | 210004066.20190721 | 2019-07-21 | LEJ | 2019-06-12 | 2019-07-10 | R | 2 |
| 210000005 | 1142513 | 210004067.20170811 | 2017-08-11 | LSW | 2017-07-14 | null | R | 2 |
| 210000005 | 1142513 | 210004067.20170812 | 2017-08-12 | LSW | 2017-07-14 | null | R | 2 |
| 210000005 | 1142513 | 210004067.20170813 | 2017-08-13 | LSW | 2017-07-14 | null | R | 2 |
| 210000005 | 1142513 | 210004067.20170816 | 2017-08-16 | LSW | 2017-07-14 | null | R | 2 |
| 210000005 | 1142513 | 210004067.20170817 | 2017-08-17 | LSW | 2017-07-14 | null | R | 2 |
| 210000006 | 1372635 | 210004068.20190425 | 2019-04-25 | LSL | 2019-03-17 | 2019-03-02 | R | 2 |
| 210000006 | 1372635 | 210004068.20190426 | 2019-04-26 | LSL | 2019-03-17 | 2019-03-02 | R | 2 |
| 210000007 | 1015299 | 210004069.20170113 | 2017-01-13 | LNG | null | 2016-12-09 | null | 2 |
| 210000007 | 1015299 | 210004069.20170116 | 2017-01-16 | LNG | null | 2016-12-09 | null | 2 |
| 210000007 | 1015299 | 210004069.20170118 | 2017-01-18 | LNG | null | 2016-12-09 | null | 2 |
| 210000008 | 1303893 | 210004070.20191017 | 2019-10-17 | LJV | 2019-07-03 | 2019-10-14 | R | 2 |
| 210000008 | 1303893 | 210004070.20191018 | 2019-10-18 | LJV | 2019-07-03 | 2019-10-14 | R | 2 |