EHDEN / ETL-UK-Biobank

ETL UK-Biobank
https://ehden.github.io/ETL-UK-Biobank/
13 stars 4 forks source link

visit_detail_start_date fallback #249

Closed SofiaMp closed 3 years ago

SofiaMp commented 3 years ago

In the hospital dataset for the visit_detail_start_date we use the epistart field and for the visit_occurrence_start_date the admidate. For both the fallback date if no value given is 1970/01/01. Would it make sense with the data for the "visit_detail" table if the epistart is empty to check and use admidate before the fallback date.

MaximMoinat commented 3 years ago

HES tables, hospital, missing dates (admission date (first admission) and epi_date (episode dates))