ouhft / COPE

Project Repository for Work Package 4 of the COPE Transplant Trial
https://cope.nds.ox.ac.uk
1 stars 0 forks source link

Ensure date_of_death from v0.6.5 data is migrated to Patient.date_of_death in v0.8.1 #269

Closed marshalc closed 7 years ago

marshalc commented 7 years ago

Check and remedy as needed, that Date of Death as previously captured in the S/AE data is now present on the Patient data.

marshalc commented 7 years ago
UPDATE compare_patient SET date_of_death = '2015-06-26' WHERE id = 181;
UPDATE compare_patient SET date_of_death = '2016-02-09' WHERE id = 103;
UPDATE compare_patient SET date_of_death = '2016-03-28' WHERE id = 219;
UPDATE compare_patient SET date_of_death = '2016-04-16' WHERE id = 218;
UPDATE compare_patient SET date_of_death = '2016-01-21' WHERE id = 243;
UPDATE compare_patient SET date_of_death = '2016-03-07' WHERE id = 116;
UPDATE compare_patient SET date_of_death = '2016-02-26' WHERE id = 222;
UPDATE compare_patient SET date_of_death = '2016-10-25' WHERE id = 456;

Edit: Removed the new. prefix for use on the live data

marshalc commented 7 years ago
-- However, for Organ_ID 92, the Date of Death is unknown, so mark Patient 162 with dod_unknown
UPDATE compare_patient SET date_of_death_unknown = 1 WHERE id = 162;

Need to apply these to the live data on release.

marshalc commented 7 years ago

Done. And death summaries report now shows as expected.