Link suspect mismatch from ours incomplete query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 3: | Line 3: | ||
|DIC_related_concepts=PHIN field; Previous Location field | |DIC_related_concepts=PHIN field; Previous Location field | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_coding=query '' | |DIC_coding=query ''Link_suspect_mismatch_from_ours_incomplete'' | ||
|DIC_status=implemented | |DIC_status=implemented | ||
|DIC_LProblem=Yes | |DIC_LProblem=Yes | ||
Revision as of 16:56, 2020 January 28
| Data Integrity Checks | |
| Summary: | Used in Correcting suspect links to find records where a later record with that PHIN has a Previous Location entry corresponding to one of our sites as per the s_dispo table.real_collection table, but an earlier corresponding entry doesn't exist for that location. |
| Related: | PHIN field, Previous Location field |
| Firmness: | hard check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | query Link_suspect_mismatch_from_ours_incomplete |
| Uses L Problem table: | Yes |
| Status: | implemented |
| Implementation Date: | not entered |
| Backlogged: | true |
Follow steps in Processing errors in patient data to fix errors found.
Related articles
| Related articles: |