V2 rtds_episode
5,843,641 rows · 9 columns
| PATIENTID | RADIOTHERAPYEPISODEID | ATTENDID | APPTDATE | LINKCODE | DECISIONTOTREATDATE | EARLIESTCLINAPPROPDATE | RADIOTHERAPYPRIORITY | RADIOTHERAPYINTENT |
|---|---|---|---|---|---|---|---|---|
| 100020805 | 1373850 | 100147926.20190103 | 2019-01-03 | LFT | 2018-12-14 | null | R | 2 |
| 100020805 | 1373850 | 100147926.20190106 | 2019-01-06 | LFT | 2018-12-14 | null | R | 2 |
| 100020808 | 1438484 | 100147927.20180109 | 2018-01-09 | LFZ | 2017-11-10 | 2017-12-13 | R | 2 |
| 100020809 | 1869181 | 100147928.20180813 | 2018-08-13 | LLT | 2017-08-06 | 2018-07-15 | R | 2 |
| 100020809 | 1869181 | 100147928.20180814 | 2018-08-14 | LLT | 2017-08-06 | 2018-07-15 | R | 2 |
| 100020809 | 1869181 | 100147928.20180817 | 2018-08-17 | LLT | 2017-08-06 | 2018-07-15 | R | 2 |
| 100020811 | 1805374 | 100147929.20160903 | 2016-09-03 | LQZ | 2016-08-03 | 2016-08-02 | R | 2 |
| 100020811 | 1805374 | 100147929.20160904 | 2016-09-04 | LQZ | 2016-08-03 | 2016-08-02 | R | 2 |
| 100020811 | 1805374 | 100147929.20160905 | 2016-09-05 | LQZ | 2016-08-03 | 2016-08-02 | R | 2 |
| 100020811 | 1805374 | 100147929.20160906 | 2016-09-06 | LQZ | 2016-08-03 | 2016-08-02 | R | 2 |
| 100020811 | 1805374 | 100147929.20160907 | 2016-09-07 | LQZ | 2016-08-03 | 2016-08-02 | R | 2 |
| 100020811 | 1805374 | 100147929.20160908 | 2016-09-08 | LQZ | 2016-08-03 | 2016-08-02 | R | 2 |
| 100020814 | 1606355 | 100147930.20210211 | 2021-02-11 | LZH | 2021-01-18 | 2021-02-11 | U | 2 |
| 100020814 | 1606355 | 100147930.20210212 | 2021-02-12 | LZH | 2021-01-18 | 2021-02-11 | U | 2 |
| 100020818 | 1004584 | 100147931.20171025 | 2017-10-25 | LLK | 2017-10-01 | 2017-10-04 | R | 2 |
| 100020818 | 1004584 | 100147931.20171026 | 2017-10-26 | LLK | 2017-10-01 | 2017-10-04 | R | 2 |
| 100020820 | 1275893 | 100147932.20160824 | 2016-08-24 | LPA | 2016-07-13 | 2016-08-22 | R | 2 |
| 100020820 | 1275893 | 100147932.20160825 | 2016-08-25 | LPA | 2016-07-13 | 2016-08-22 | R | 2 |
| 100020820 | 1275893 | 100147932.20160828 | 2016-08-28 | LPA | 2016-07-13 | 2016-08-22 | R | 2 |
| 100020820 | 1275893 | 100147932.20160829 | 2016-08-29 | LPA | 2016-07-13 | 2016-08-22 | R | 2 |
| 100020820 | 1275893 | 100147932.20160901 | 2016-09-01 | LPA | 2016-07-13 | 2016-08-22 | R | 2 |
| 100020820 | 1275893 | 100147932.20160904 | 2016-09-04 | LPA | 2016-07-13 | 2016-08-22 | R | 2 |
| 100020821 | 1470545 | 100147933.20191001 | 2019-10-01 | LEA | 2019-09-03 | 2019-08-15 | R | 2 |
| 100020821 | 1470545 | 100147933.20191004 | 2019-10-04 | LEA | 2019-09-03 | 2019-08-15 | R | 2 |
| 100020821 | 1470545 | 100147933.20191005 | 2019-10-05 | LEA | 2019-09-03 | 2019-08-15 | R | 2 |
| 100020821 | 1470545 | 100147933.20191006 | 2019-10-06 | LEA | 2019-09-03 | 2019-08-15 | R | 2 |
| 100020821 | 1470545 | 100147933.20191007 | 2019-10-07 | LEA | 2019-09-03 | 2019-08-15 | R | 2 |
| 100020824 | 1501655 | 100147934.20190825 | 2019-08-25 | LKY | 2019-08-24 | 2019-08-25 | U | 2 |
| 100020824 | 1501655 | 100147934.20190826 | 2019-08-26 | LKY | 2019-08-24 | 2019-08-25 | U | 2 |
| 100020824 | 1501655 | 100147934.20190827 | 2019-08-27 | LKY | 2019-08-24 | 2019-08-25 | U | 2 |
| 100020824 | 1501655 | 100147934.20190828 | 2019-08-28 | LKY | 2019-08-24 | 2019-08-25 | U | 2 |
| 100020825 | 1614775 | 100147935.20180827 | 2018-08-27 | LYR | 2018-07-19 | 2018-07-07 | U | 2 |
| 100020825 | 1614775 | 100147935.20180828 | 2018-08-28 | LYR | 2018-07-19 | 2018-07-07 | U | 2 |
| 100020825 | 1614775 | 100147935.20180829 | 2018-08-29 | LYR | 2018-07-19 | 2018-07-07 | U | 2 |
| 100020826 | 1340644 | 100147936.20170524 | 2017-05-24 | LOS | 2017-04-09 | 2017-04-26 | R | 2 |
| 100020826 | 1179079 | 100183444.20171002 | 2017-10-02 | LFT | 2017-09-17 | null | R | 1 |
| 100020826 | 1024295 | 100181539.20170926 | 2017-09-26 | LPA | 2017-08-13 | 2017-08-19 | D | 1 |
| 100020826 | 1024295 | 100181539.20170929 | 2017-09-29 | LPA | 2017-08-13 | 2017-08-19 | D | 1 |
| 100020826 | 1024295 | 100181539.20170930 | 2017-09-30 | LPA | 2017-08-13 | 2017-08-19 | D | 1 |
| 100020826 | 1024295 | 100181539.20171001 | 2017-10-01 | LPA | 2017-08-13 | 2017-08-19 | D | 1 |
| 100020826 | 1461945 | 100184772.20171004 | 2017-10-04 | LVU | 2017-09-18 | 2017-09-18 | R | 1 |
| 100020826 | 1461945 | 100184772.20171003 | 2017-10-03 | LVU | 2017-09-18 | 2017-09-18 | R | 1 |
| 100020826 | 1461945 | 100184772.20171002 | 2017-10-02 | LVU | 2017-09-18 | 2017-09-18 | R | 1 |
| 100020826 | 1461945 | 100184772.20171001 | 2017-10-01 | LVU | 2017-09-18 | 2017-09-18 | R | 1 |
| 100020826 | 1289343 | 100185707.20171015 | 2017-10-15 | LFW | 2017-09-28 | 2017-10-03 | R | 1 |
| 100020826 | 1289343 | 100185707.20171014 | 2017-10-14 | LFW | 2017-09-28 | 2017-10-03 | R | 1 |
| 100020826 | 1289343 | 100185707.20171013 | 2017-10-13 | LFW | 2017-09-28 | 2017-10-03 | R | 1 |
| 100020826 | 1289343 | 100185707.20171012 | 2017-10-12 | LFW | 2017-09-28 | 2017-10-03 | R | 1 |
| 100020826 | 1024295 | 100181539.20170925 | 2017-09-25 | LPA | 2017-08-13 | 2017-08-19 | D | 1 |
| 100020826 | 1179079 | 100183444.20171001 | 2017-10-01 | LFT | 2017-09-17 | null | R | 1 |