DataQualityDashboard icon indicating copy to clipboard operation
DataQualityDashboard copied to clipboard

Published 20 hours ago • verified publisher icon OHDSI

Inpatient visits that only last a day

Open clairblacketer opened this issue 2 years ago • 7 comments

If an inpatient visit only lasts one day then they should not be classified as inpatient, this would be a new check

This could also be applied to other visits, outpatient should only be 1 day, ER should only be 1 day, <24hrs

clairblacketer avatar Mar 10 '22 16:03 clairblacketer

Let's not add "ER should only be 1 day, <24hrs". In general, this should be true. But in periods of high demand and low available bed counts, some persons stay in the ER for > 24 hours. 48 hours would be a more helpful check.

MelaniePhilofsky avatar Apr 15 '22 14:04 MelaniePhilofsky

@MelaniePhilofsky thank you for the insight!

clairblacketer avatar Apr 21 '22 20:04 clairblacketer

Hi, I can try to create this check in SQL. I wasn't sure, if there is a way for me to assign the issue to myself?

Thanks, Priya

priagopal avatar May 03 '22 15:05 priagopal

Thanks @priagopal! I added you as a collaborator and assigned the issue to you

clairblacketer avatar May 05 '22 14:05 clairblacketer

Thank you

priagopal avatar May 05 '22 14:05 priagopal

Hi Clair, I have created the check. Can you please check? if it looks good. I can take more issues related to SQL checks.

Thanks, Priya

priagopal avatar May 05 '22 17:05 priagopal

hi @clairblacketer & @priagopal , i saw that the PR for this check in the develop branch ended up getting reverted (#336 ). is the intention to develop/add this check later on in the future, or not to add after all?

katy-sadowski avatar Nov 17 '22 02:11 katy-sadowski