Check duplicate patient: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 19: | Line 19: | ||
* [[PHIN]] (except 999999999 for [[PHIN_field#Location_Manitoba_and_no_PHIN]]) | * [[PHIN]] (except 999999999 for [[PHIN_field#Location_Manitoba_and_no_PHIN]]) | ||
* combination of ([[DOB]], [[First Name]], [[Last Name]]) | * combination of ([[DOB]], [[First Name]], [[Last Name]]) | ||
== Log == | |||
* 2019-10-27 - changed to only include if recordstatus is complete or incomplete | |||
== Related articles == | == Related articles == | ||
Revision as of 16:19, 27 October 2019
| 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 |
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:
- Chart number
- PHIN (except 999999999 for PHIN_field#Location_Manitoba_and_no_PHIN)
- combination of (DOB, First Name, Last Name)
Log
- 2019-10-27 - changed to only include if recordstatus is complete or incomplete