The “discharge to” (and the visit concept, and the admission from) collects visit concepts. These are configurations of healthcare encounters, not individual institutions or flavors of null. Therefore, your job is easy, as most of them do not contain any analyzable information:
Non Eligible - Null
Discharge Home (Continue) - Null
Transfer - Null
Send Back to Original Hospital - 8717 “Inpatient Hospital”
Thanks for your support Mr. Christian
another question if you don’t mind, in visit_detail Table we will record the data from Lab,Medication and diagnosis tables with VISIT_DETAIL_CONCEPT_ID for Lab 32036 (Laborotry Visit),for Medication 581458 (Pharmacy Visit) and we don’t know which concept diagnosis belongs to.
we will appreciate you help.
Probably not. The Visit Detail really only makes sense inside a hospitalization: You go from ER to ICU, to ordinary ward, to rehab. You don’t really walk over to the pharmacy to get your drugs while in a hospital bed. You also don’t visit a lab to get tested, the nurse draws your blood in the morning.
So:
Ambulatory setting: All these are individual visits (in VISIT_OCCURRENCE)
Inpatient setting: All activities are VISIT_DETAIL records, but I would pick and chose what to put in there. ICU is fine, Lab probably not.
If you think you don’t want to pick, because you don’t really know, it’s probably ok to make everything inside a hospital Visit a Visit Detail. Nobody is going to kill you.
On May 8th, the Healthcare System Interest Group discussed the Discuss Visit Occurrence and Visit Detail tables, including questions about how to define inpatient versus outpatient visits, how to define visits which belong in Visit Occurrence, visits which belong in Visit Detail, how to populate the fields in this table, what to do when some source data have datetime and other data only have dates, etc. You might want to review the recording located here.
Even the Persons not really walk to pharmacy or lab, he\she engaged with the healthcare system for a duration of his\her stay and the test results or drugs was recorded in EHR.
to make it more clear to discuss
we have ER_Patients contain emergency and IP_Patients contain In Patients stays information and OP_Patients contain Outpatient information.
person may:
get in as emergency case then discharged same day or next day (it will be one visit)
get in as emergency case then move to InPatient same day or next day and visit some Outpatient
get in as emergency case then visit some Outpatient
for 2&3 how to deal with this cases, merge all visit to one if yes what’s the concept will take? or record each visit as separated visit
Have two records in VISIT_OCCURRENCE (ER and inpatient) and the outpatient visits during the inpatient as VISIT_DETAIL. (After the inpatient stay is over, they of course are also VISIT_OCCURRENCE).
Independent VISIT_OCCURRENCE records. ER visits, like outpatient visits are one day events (exceptions can happen if the patient work is not done by midnight, but never more than 2 days). They can happen on the same day.