Check duplicate patient: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 7: | Line 7: | ||
* phin | * phin | ||
* combination of (DOB, fname, lname) | * combination of (DOB, fname, lname) | ||
==Error scenario== | ==Error scenario== | ||
| Line 16: | Line 13: | ||
Serial# 15268 & 15306 no obvious problem other than MB Province both had PHIN# 999999999. Collector solution ended up being to changed one PHIN to 123456789. | Serial# 15268 & 15306 no obvious problem other than MB Province both had PHIN# 999999999. Collector solution ended up being to changed one PHIN to 123456789. | ||
*The correct data collection process if province is MB and no PHIN go to: [[PHIN field]]. Staff sent link to collection instructions & main office review also. | *The correct data collection process if province is MB and no PHIN go to: [[PHIN field]]. Staff sent link to collection instructions & main office review also. | ||
== IT Instructions == | |||
Uses functions ''has_multiples()'' and ''overlap()'' and query ''Check_pt_multiples''. | |||
Revision as of 13:11, 7 June 2018
Template:CCMDB Data Integrity Checks
The same patient should not be on a laptop/PDA twice with overlapping Admit/Discharge times. If there is a patient like that you will get an error.
Definition
Duplicates of the following with overlapping admit/discharge dates:
- chart number
- phin
- combination of (DOB, fname, lname)
Error scenario
2018-06-01; Problem sending A4 Val Penner. Error message Re: Duplicate patients......Screen shots of the error message sent to Pagasa. Copy of the csv file in Pagasa's C drive. Serial# 15268 & 15306 no obvious problem other than MB Province both had PHIN# 999999999. Collector solution ended up being to changed one PHIN to 123456789.
- The correct data collection process if province is MB and no PHIN go to: PHIN field. Staff sent link to collection instructions & main office review also.
IT Instructions
Uses functions has_multiples() and overlap() and query Check_pt_multiples.