Multiple Encounter

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 Re-admission. If never discharged in between encounters, patient may be a Continuous Stay.

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.

Simplification?

Considering that the vetting process ensures that PHINs are fixed for all patients, why would we match on more than one field? Ttenbergen 11:39, 2014 May 5 (CDT) Ttenbergen 13:02, 2014 January 16 (CST) Template:Discussion