Open solmazeradat opened 5 months ago
There is ambiguity in the guidance. I am moving this to Needs More Work, so a convention can be discussed in the Themis WG.
For inpatient stays, the current debate is to allow the visit_end_date to be NULL. The current CDM guidelines require a visit_end_date. @clairblacketer This is now a CDM issue.
changing to proposal as it is suggesting to allow null end dates in visit_end_date, this needs to be figured out, either allow null end dates or make the concept standard.
Convention for patients "still in hospital"
CDM or THEMIS convention?
THEMIS
Table or Field level?
Field
Is this a general convention?
No
Summary of issues
Summary of answer
Author 1:
visit_occurrence.end_date, visit_occurrence.end_datetime, visit_detail.visit_detail_end_date, and visit_detail.visit_detail_end_datetime
User Guide sections to direct users to set the visit_end_datetime to the date of the data extract when an inpatient visit is ongoing and the *.discharged_to_concept_id = 0.visit_occurrence.discharged_to_concept_id
andvisit_detail.discharged_to_concept_id
ETL Conventions sections to notify users it is assumed a Person returns home after a Visit, therefore, there is not a standard concept_id to represent 'home' and set the discharged_to_concept_id = 0Author 2
We should update this user guidance, as some things have changed.
Concept 32220 - Still Patient is non-standard, and the advice in the user guide for visit_end_date is to add this as the visit_type_concept_id, not discharge_concept_id.
For Inpatient Visits ongoing at the date of ETL, put date of processing the data into visit_end_datetime and visit_type_concept_id with 32220 “Still patient” to identify the visit as incomplete.
This is now conflicting with our conventions for type concepts to be standard and of class 'Type Concept'.
Author 3:
Related links
Other comments/notes