V2 rtds_episode
5,843,641 rows · 9 columns
| PATIENTID | RADIOTHERAPYEPISODEID | ATTENDID | APPTDATE | LINKCODE | DECISIONTOTREATDATE | EARLIESTCLINAPPROPDATE | RADIOTHERAPYPRIORITY | RADIOTHERAPYINTENT |
|---|---|---|---|---|---|---|---|---|
| 100011001 | 1048900 | 100158519.20180501 | 2018-05-01 | LSL | 2018-04-27 | 2018-04-28 | R | 1 |
| 100011001 | 1233089 | 100124222.20171228 | 2017-12-28 | LPH | 2017-12-16 | 2017-12-18 | E | 1 |
| 100011001 | 1233089 | 100124222.20171229 | 2017-12-29 | LPH | 2017-12-16 | 2017-12-18 | E | 1 |
| 100011001 | 1233089 | 100124222.20171230 | 2017-12-30 | LPH | 2017-12-16 | 2017-12-18 | E | 1 |
| 100011001 | 1233089 | 100124222.20180102 | 2018-01-02 | LPH | 2017-12-16 | 2017-12-18 | E | 1 |
| 100011001 | 1233089 | 100124222.20180103 | 2018-01-03 | LPH | 2017-12-16 | 2017-12-18 | E | 1 |
| 100011001 | 1233089 | 100124222.20180106 | 2018-01-06 | LPH | 2017-12-16 | 2017-12-18 | E | 1 |
| 100011001 | 1233089 | 100124222.20171225 | 2017-12-25 | LPH | 2017-12-16 | 2017-12-18 | E | 1 |
| 100011002 | 1679175 | 100124223.20171013 | 2017-10-13 | LDB | 2017-09-26 | 2017-09-25 | R | 1 |
| 100011003 | 1638521 | 100144781.20171007 | 2017-10-07 | LDD | 2017-09-26 | 2017-09-22 | R | 1 |
| 100011003 | 1638521 | 100144781.20171006 | 2017-10-06 | LDD | 2017-09-26 | 2017-09-22 | R | 1 |
| 100011003 | 1638521 | 100144781.20171008 | 2017-10-08 | LDD | 2017-09-26 | 2017-09-22 | R | 1 |
| 100011003 | 1924747 | 100124224.20171001 | 2017-10-01 | LJV | 2017-09-16 | 2017-09-14 | R | 1 |
| 100011005 | 1832544 | 100124225.20160928 | 2016-09-28 | LUA | 2016-09-20 | 2016-09-17 | E | 1 |
| 100011005 | 1832544 | 100124225.20160929 | 2016-09-29 | LUA | 2016-09-20 | 2016-09-17 | E | 1 |
| 100011005 | 1832544 | 100124225.20160930 | 2016-09-30 | LUA | 2016-09-20 | 2016-09-17 | E | 1 |
| 100011005 | 1832544 | 100124225.20161003 | 2016-10-03 | LUA | 2016-09-20 | 2016-09-17 | E | 1 |
| 100011005 | 1832544 | 100124225.20160925 | 2016-09-25 | LUA | 2016-09-20 | 2016-09-17 | E | 1 |
| 100011005 | 1832544 | 100124225.20161001 | 2016-10-01 | LUA | 2016-09-20 | 2016-09-17 | E | 1 |
| 100011006 | 1051822 | 100124226.20170302 | 2017-03-02 | LUA | 2017-02-19 | 2017-02-20 | U | 1 |
| 100011006 | 1051822 | 100124226.20170303 | 2017-03-03 | LUA | 2017-02-19 | 2017-02-20 | U | 1 |
| 100011006 | 1051822 | 100124226.20170306 | 2017-03-06 | LUA | 2017-02-19 | 2017-02-20 | U | 1 |
| 100011006 | 1051822 | 100124226.20170307 | 2017-03-07 | LUA | 2017-02-19 | 2017-02-20 | U | 1 |
| 100011006 | 1051822 | 100124226.20170308 | 2017-03-08 | LUA | 2017-02-19 | 2017-02-20 | U | 1 |
| 100011008 | 1194127 | 100124227.20190625 | 2019-06-25 | LOS | 2019-06-18 | 2019-06-24 | R | 1 |
| 100011008 | 1116214 | 100144782.20190720 | 2019-07-20 | LOS | 2019-06-19 | null | R | 1 |
| 100011008 | 1116214 | 100144782.20190719 | 2019-07-19 | LOS | 2019-06-19 | null | R | 1 |
| 100011011 | 1542290 | 100124228.20180608 | 2018-06-08 | LLT | 2018-05-21 | null | R | 1 |
| 100011011 | 1542290 | 100124228.20180605 | 2018-06-05 | LLT | 2018-05-21 | null | R | 1 |
| 100011011 | 1542290 | 100124228.20180611 | 2018-06-11 | LLT | 2018-05-21 | null | R | 1 |
| 100011011 | 1542290 | 100124228.20180607 | 2018-06-07 | LLT | 2018-05-21 | null | R | 1 |
| 100011011 | 1542290 | 100124228.20180606 | 2018-06-06 | LLT | 2018-05-21 | null | R | 1 |
| 100011011 | 1215328 | 100144783.20180918 | 2018-09-18 | LQS | 2018-09-10 | 2018-09-10 | R | 1 |
| 100011011 | 1542290 | 100124228.20180604 | 2018-06-04 | LLT | 2018-05-21 | null | R | 1 |
| 100011011 | 1808304 | 100158520.20180918 | 2018-09-18 | LUA | 2018-09-17 | 2018-09-17 | E | 1 |
| 100011011 | 1808304 | 100158520.20180919 | 2018-09-19 | LUA | 2018-09-17 | 2018-09-17 | E | 1 |
| 100011011 | 1808304 | 100158520.20180920 | 2018-09-20 | LUA | 2018-09-17 | 2018-09-17 | E | 1 |
| 100011011 | 1808304 | 100158520.20180921 | 2018-09-21 | LUA | 2018-09-17 | 2018-09-17 | E | 1 |
| 100011011 | 1808304 | 100158520.20180922 | 2018-09-22 | LUA | 2018-09-17 | 2018-09-17 | E | 1 |
| 100011012 | 1224048 | 100124229.20160820 | 2016-08-20 | LFZ | 2016-08-06 | null | null | 1 |
| 100011013 | 1879493 | 100124230.20170227 | 2017-02-27 | LLK | 2017-02-26 | 2017-02-25 | R | 1 |
| 100011013 | 1879493 | 100124230.20170228 | 2017-02-28 | LLK | 2017-02-26 | 2017-02-25 | R | 1 |
| 100011013 | 1879493 | 100124230.20170301 | 2017-03-01 | LLK | 2017-02-26 | 2017-02-25 | R | 1 |
| 100011017 | 1632477 | 100124231.20180308 | 2018-03-08 | LEJ | 2018-02-10 | null | null | 1 |
| 100011018 | 1539426 | 100124232.20190926 | 2019-09-26 | LPA | 2019-09-17 | 2019-09-25 | R | 1 |
| 100011018 | 1539426 | 100124232.20190927 | 2019-09-27 | LPA | 2019-09-17 | 2019-09-25 | R | 1 |
| 100011018 | 1442446 | 100144784.20200305 | 2020-03-05 | LLT | 2020-02-10 | 2020-02-09 | R | 1 |
| 100011018 | 1759099 | 100158521.20200311 | 2020-03-11 | LBN | 2020-03-05 | 2020-03-03 | U | 1 |
| 100011018 | 1983189 | 100167809.20200313 | 2020-03-13 | LFW | 2020-03-10 | 2020-03-10 | R | 1 |
| 100011018 | 1280624 | 100178315.20200312 | 2020-03-12 | LET | 2020-02-24 | 2020-02-24 | R | 1 |