Multiple Encounter: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 2: Line 2:


== Multiple Encounters ==
== Multiple Encounters ==
* {{discussion}} What are the fields that have to match to consider two encounters the same patient, eg likely a combination of names, dob, ?phin?, what else?Ttenbergen 18:07, 2012 November 22 (EST)
* Multiple encounters are considered of same patient if the combination of following fields match:
** PHIN
** Names (First and Last)
** DOB
** Gender
** Hospital Chart# if admitted in the same hospital
* Data quality check programs are being run after every appending of new data to the master database of both Critical Care and Medicine.  The programs find errors in  records not matching in any of the above combination of fields.
** The Data Processor runs the two programs at her local computer C:\TMSX\CombLookupProof.exe followed by C:\TMSX\CombinedErrorsFinder.exe in that order.
** The Statistician runs the SAS program in the shared folder  X:\Julie\SAS\CriticalCare\chkchartdupCCnMED.sas .
** The Data Processor fixes any errors found ensuring the consistencies in the demographics of same patient on both databases.


== Continuous Hospital Stay - Medicine ==
== Continuous Hospital Stay - Medicine ==

Revision as of 12:11, 2012 November 23

Patients may show up in our database repeatedly either during the same hospital stay or at a later time. If they show up at a later time, but soon after the last hospital stay, they may qualify as "readmission", which we report monthly, quarterly and annually.

Multiple Encounters

  • Multiple encounters are considered of same patient if the combination of following fields match:
    • PHIN
    • Names (First and Last)
    • DOB
    • Gender
    • Hospital Chart# if admitted in the same hospital
  • Data quality check programs are being run after every appending of new data to the master database of both Critical Care and Medicine. The programs find errors in records not matching in any of the above combination of fields.
    • The Data Processor runs the two programs at her local computer C:\TMSX\CombLookupProof.exe followed by C:\TMSX\CombinedErrorsFinder.exe in that order.
    • The Statistician runs the SAS program in the shared folder X:\Julie\SAS\CriticalCare\chkchartdupCCnMED.sas .
    • The Data Processor fixes any errors found ensuring the consistencies in the demographics of same patient on both databases.

Continuous Hospital Stay - Medicine

The statistician uses data from Admit From & Discharged To, Med Var 1 - Admit-from Ward and Med Var 2 - Discharge-to Ward to

  • link profiles from one ward to another when both wards are within the database program
    • Template:Discussion what do you mean "when both wards are within the database program" - would we have data if they were not?Ttenbergen 18:07, 2012 November 22 (EST)
  • detect a likely continuous stay when a pt is discharged from one of our wards to a non-collected ward and then re-admitted to one of our wards from the same non-collected ward.

Readmissions

For our purposes, readmissions are admissions of patients who were recorded by our database recently.

ICU Definition

For ICU, a readmission is a patient where

  • (admit date/time) - (most recent ICU discharge date/time to ward or home) <= 72 hours
  • is not admitted for planned and scheduled surgery
  • might be readmitted from Ward or outside hospital
    • is there anywhere pt would not be allowed to be admitted from? Ttenbergen 18:07, 2012 November 22 (EST) Template:Discussion

Medicine Definition

For medicine, a readmission is a patient where

  • (admit date/time) - (most recent discharge date/time to the hospital) <= 7 days after their most recent discharge time to the hospital
  • is admitted from outside hospital
  • (Legacy: planned surgery used to be excluded, but this stopped because of insufficient data when we stopped collecting some APACHE elements in the medicine program Dec 31, 2006)