What is sudden decline - Visit end date for Inpatients?

[MPhilofsky (Melanie Philofsky)]

@Akshay

Is there any example or SQL snippet that you can share for me to understand how this is done?

I would like to add the above to my OHDSI wish list Missing visit end dates are a common problem for EHR data.

@Akshay

For example let’s say patient A is admitted in hospital on Jan 1st 2008. Like you said, let’s say he has measurements records (vital signs) till Jan 8th or Drug exposure records till Jan 8th. So we pick the latest event that has occurred in patient’s treatment/hospital journey. In this case, should we just pick Jan 8th or 9th as visit_end_date?

Take the date of the last clinical event. Jan. 8th.

@Akshay

Q1) So do I have to drop all those 172 (178 minus 6) patients from my dataset? Because they don’t have any corresponding info on condition,drugs, procedures etc. So it’s likely to be a data issue? Any suggestions on this based on your experience

What question can you answer without any data for a Visit? I wonder if the Visit really occurred? Maybe this was a scheduled Visit (surgery was scheduled for this day) and the Visit never occurred?

@Akshay

Q2) Is my logic to derive Visit_end_date is right?

Before you derive anything, you should speak to an expert on the source data. They should be able to give you further insight into the missing Visit end date.

You should join the EHR WG details are located here We discuss all things OHDSI, healthcare, EHR, and ETL.

@QI_omop

ust come up with an arbitrary rule, e.g, add 7 days, 2 weeks or 30 days to the visit start date for visit end date

@QI_omop The vast majority of Persons do not stay in the hospital for a week, 2 weeks or a whole month. Very rare.