Check duplicate patient: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
||
| Line 4: | Line 4: | ||
| DIC_firmness = hard check | | DIC_firmness = hard check | ||
| DIC_timing = | | DIC_timing = | ||
| DIC_app = CCMDB. | | DIC_app = CCMDB.accdb | ||
| DIC_coding = functions ''has_multiples()'' and ''overlap()'' and query ''Check_pt_multiples'' | | DIC_coding = functions ''has_multiples()'' and ''overlap()'' and query ''Check_pt_multiples'' | ||
| DIC_status = implemented | | DIC_status = implemented | ||
Revision as of 10:45, 22 September 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 |
| 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.
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)