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 |
||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check}} | {{Data Integrity Check | ||
|DIC_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. | |||
|DIC_related_concepts=PHIN field; Previous Location field | |||
|DIC_firmness=hard check | |||
|DIC_coding=''Link_suspect_mismatch_from_ours__incomplete'' query | |||
|DIC_status=implemented | |||
|DIC_LProblem=no | |||
|DIC_app=Centralized data front end.accdb | |||
|DIC_backlogged=No | |||
}} | |||
Follow steps in [[Processing errors in patient data]] to fix errors found. | |||
{{Organ donor inconsistencies}} | |||
== Log == | |||
* 2022-05-26 - changed the linking from previous to next to use <>s_dispoIDs and [s_dispo_early_location].[real_collection]<>[s_dispo_late_previous].[location_name]; without these, the a change we had made that turned “STB_SICU” into “STB_SICU (Legacy)” would result in false positives; also changed query to only compare up to 2018 | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data Processing]] | [[Category: Data Processing]] | ||
[[Category:Multiple Encounter linking]] | [[Category:Multiple Encounter linking]] | ||
[[Category:Multiple encounter longitudinal consistency check]] | [[Category:Multiple encounter longitudinal consistency check]] | ||
[[Category:Registry checks]] | |||
Latest revision as of 14:30, 2022 June 14
| 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: | Link_suspect_mismatch_from_ours__incomplete query |
| 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.
Log
- 2022-05-26 - changed the linking from previous to next to use <>s_dispoIDs and [s_dispo_early_location].[real_collection]<>[s_dispo_late_previous].[location_name]; without these, the a change we had made that turned “STB_SICU” into “STB_SICU (Legacy)” would result in false positives; also changed query to only compare up to 2018
Related articles
| Related articles: |