Link suspect mismatch to ours incomplete query
Jump to navigation
Jump to search
| Data Integrity Checks | |
| Summary: | Used in Correcting suspect links to find records where an earlier record with that PHIN has a dispo entry corresponding to one of our sites as per the s_dispo table.real_collection, but a later corresponding entry doesn't exist for that location. |
| Related: | PHIN field, Dispo field, Guideline for coding organ donation after death |
| Firmness: | hard check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | query Link suspect mismatch to ours incomplete |
| Uses L Problem table: | no |
| Status: | implemented |
| Implementation Date: | not entered |
| Backlogged: | No |
Follow steps in Processing errors in patient data to fix errors found.
Organ donor inconsistencies
We have Guideline for coding organ donation after death which might lead to some cross checks flagging an error for patient transfers. This situation is somewhat complex, so instead of changing queries to exclude these cases, just add them to L Problem table as usual after confirming that transfer info was indeed as entered.