Check duplicate patient: Difference between revisions

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


== Log ==
== Log ==
* 2021-01-22 - better labels and included the relevant dates right in the query listing.
* 2019-10-27 - changed to only include if recordstatus is complete or incomplete
* 2019-10-27 - changed to only include if recordstatus is complete or incomplete



Revision as of 17:35, 2021 January 22

Data Integrity Checks
Summary: there are no dupliate entries for the same patient ward admission on the laptop at send time
Related: PHIN, DOB, Chart number, First Name, Last Name, Arrive DtTm, Dispo DtTm
Firmness: hard check
Timing:
App: CCMDB.accdb
Coding: functions has_multiples() and overlap() and query Check_pt_multiples
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: date change was rolled out / first applied
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

The same patient should not be on a laptop twice with overlapping Arrive DtTm / Dispo DtTm. If there is a patient like that you will get an error and you will not be able to send any patients. Function Overlap defines what it means for two timeframes to overlap.

This cross check is somewhat related to Transfer time rule.

Definition

Duplicates of the following with overlapping Arrive DtTm / Dispo DtTm:

Log

  • 2021-01-22 - better labels and included the relevant dates right in the query listing.
  • 2019-10-27 - changed to only include if recordstatus is complete or incomplete

Related articles

Related articles: