V2 rtds_episode
5,843,641 rows · 9 columns
| PATIENTID | RADIOTHERAPYEPISODEID | ATTENDID | APPTDATE | LINKCODE | DECISIONTOTREATDATE | EARLIESTCLINAPPROPDATE | RADIOTHERAPYPRIORITY | RADIOTHERAPYINTENT |
|---|---|---|---|---|---|---|---|---|
| 100017399 | 1477849 | 100100182.20170817 | 2017-08-17 | LYR | 2017-07-31 | 2017-07-31 | null | 1 |
| 100017399 | 1477849 | 100100182.20170818 | 2017-08-18 | LYR | 2017-07-31 | 2017-07-31 | null | 1 |
| 100017399 | 1477849 | 100100182.20170819 | 2017-08-19 | LYR | 2017-07-31 | 2017-07-31 | null | 1 |
| 100017399 | 1477849 | 100100182.20170820 | 2017-08-20 | LYR | 2017-07-31 | 2017-07-31 | null | 1 |
| 100017399 | 1477849 | 100100182.20170821 | 2017-08-21 | LYR | 2017-07-31 | 2017-07-31 | null | 1 |
| 100017399 | 1477849 | 100100182.20170822 | 2017-08-22 | LYR | 2017-07-31 | 2017-07-31 | null | 1 |
| 100017399 | 1477849 | 100100182.20170823 | 2017-08-23 | LYR | 2017-07-31 | 2017-07-31 | null | 1 |
| 100017399 | 1477849 | 100100182.20170824 | 2017-08-24 | LYR | 2017-07-31 | 2017-07-31 | null | 1 |
| 100017400 | 1448467 | 100100183.20170721 | 2017-07-21 | LZH | 2017-07-19 | null | E | 1 |
| 100017401 | 1415121 | 100100184.20160123 | 2016-01-23 | LDR | 2016-01-11 | 2016-01-22 | R | 1 |
| 100017401 | 1415121 | 100100184.20160126 | 2016-01-26 | LDR | 2016-01-11 | 2016-01-22 | R | 1 |
| 100017401 | 1415121 | 100100184.20160127 | 2016-01-27 | LDR | 2016-01-11 | 2016-01-22 | R | 1 |
| 100017401 | 1415121 | 100100184.20160128 | 2016-01-28 | LDR | 2016-01-11 | 2016-01-22 | R | 1 |
| 100017401 | 1415121 | 100100184.20160129 | 2016-01-29 | LDR | 2016-01-11 | 2016-01-22 | R | 1 |
| 100017401 | 1415121 | 100100184.20160130 | 2016-01-30 | LDR | 2016-01-11 | 2016-01-22 | R | 1 |
| 100017401 | 1415121 | 100100184.20160202 | 2016-02-02 | LDR | 2016-01-11 | 2016-01-22 | R | 1 |
| 100017401 | 1415121 | 100100184.20160203 | 2016-02-03 | LDR | 2016-01-11 | 2016-01-22 | R | 1 |
| 100017401 | 1415121 | 100100184.20160204 | 2016-02-04 | LDR | 2016-01-11 | 2016-01-22 | R | 1 |
| 100017401 | 1415121 | 100100184.20160205 | 2016-02-05 | LDR | 2016-01-11 | 2016-01-22 | R | 1 |
| 100017401 | 1415121 | 100100184.20160206 | 2016-02-06 | LDR | 2016-01-11 | 2016-01-22 | R | 1 |
| 100017403 | 1758545 | 100100185.20160408 | 2016-04-08 | LDR | 2016-04-08 | 2016-04-08 | U | 1 |
| 100017406 | 1343452 | 100100186.20180705 | 2018-07-05 | LSW | 2018-06-28 | 2018-07-02 | U | 1 |
| 100017406 | 1343452 | 100100186.20180706 | 2018-07-06 | LSW | 2018-06-28 | 2018-07-02 | U | 1 |
| 100017406 | 1343452 | 100100186.20180707 | 2018-07-07 | LSW | 2018-06-28 | 2018-07-02 | U | 1 |
| 100017406 | 1343452 | 100100186.20180708 | 2018-07-08 | LSW | 2018-06-28 | 2018-07-02 | U | 1 |
| 100017406 | 1343452 | 100100186.20180711 | 2018-07-11 | LSW | 2018-06-28 | 2018-07-02 | U | 1 |
| 100017406 | 1343452 | 100100186.20180713 | 2018-07-13 | LSW | 2018-06-28 | 2018-07-02 | U | 1 |
| 100017407 | 1062828 | 100100187.20180227 | 2018-02-27 | LHB | 2018-02-27 | 2018-02-26 | U | 1 |
| 100017407 | 1062828 | 100100187.20180228 | 2018-02-28 | LHB | 2018-02-27 | 2018-02-26 | U | 1 |
| 100017407 | 1062828 | 100100187.20180301 | 2018-03-01 | LHB | 2018-02-27 | 2018-02-26 | U | 1 |
| 100017407 | 1062828 | 100100187.20180302 | 2018-03-02 | LHB | 2018-02-27 | 2018-02-26 | U | 1 |
| 100017407 | 1062828 | 100100187.20180305 | 2018-03-05 | LHB | 2018-02-27 | 2018-02-26 | U | 1 |
| 100017407 | 1062828 | 100100187.20180306 | 2018-03-06 | LHB | 2018-02-27 | 2018-02-26 | U | 1 |
| 100017407 | 1062828 | 100100187.20180307 | 2018-03-07 | LHB | 2018-02-27 | 2018-02-26 | U | 1 |
| 100017407 | 1062828 | 100100187.20180310 | 2018-03-10 | LHB | 2018-02-27 | 2018-02-26 | U | 1 |
| 100017407 | 1062828 | 100100187.20180311 | 2018-03-11 | LHB | 2018-02-27 | 2018-02-26 | U | 1 |
| 100017407 | 1062828 | 100100187.20180312 | 2018-03-12 | LHB | 2018-02-27 | 2018-02-26 | U | 1 |
| 100017408 | 1010545 | 100100188.20170629 | 2017-06-29 | LBW | 2017-06-15 | 2017-06-25 | R | 1 |
| 100017408 | 1010545 | 100100188.20170630 | 2017-06-30 | LBW | 2017-06-15 | 2017-06-25 | R | 1 |
| 100017408 | 1010545 | 100100188.20170703 | 2017-07-03 | LBW | 2017-06-15 | 2017-06-25 | R | 1 |
| 100017408 | 1010545 | 100100188.20170706 | 2017-07-06 | LBW | 2017-06-15 | 2017-06-25 | R | 1 |
| 100017409 | 1768030 | 100100189.20181001 | 2018-10-01 | LLK | 2018-09-17 | 2018-09-19 | R | 1 |
| 100017411 | 1765009 | 100100190.20190314 | 2019-03-14 | LJX | 2019-03-01 | 2019-03-02 | null | 1 |
| 100017411 | 1765009 | 100100190.20190315 | 2019-03-15 | LJX | 2019-03-01 | 2019-03-02 | null | 1 |
| 100017411 | 1765009 | 100100190.20190316 | 2019-03-16 | LJX | 2019-03-01 | 2019-03-02 | null | 1 |
| 100017411 | 1765009 | 100100190.20190317 | 2019-03-17 | LJX | 2019-03-01 | 2019-03-02 | null | 1 |
| 100017411 | 1765009 | 100100190.20190318 | 2019-03-18 | LJX | 2019-03-01 | 2019-03-02 | null | 1 |
| 100017411 | 1765009 | 100100190.20190319 | 2019-03-19 | LJX | 2019-03-01 | 2019-03-02 | null | 1 |
| 100017411 | 1765009 | 100100190.20190320 | 2019-03-20 | LJX | 2019-03-01 | 2019-03-02 | null | 1 |
| 100017412 | 1131020 | 100100191.20170728 | 2017-07-28 | LCH | 2017-07-21 | 2017-07-22 | R | 1 |