Link suspect mismatch to ours incomplete query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check}}
{{Data Integrity Check
|DIC_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.
|DIC_related_concepts=PHIN field; Dispo field
|DIC_firmness=hard check
|DIC_coding=query ''Link suspect mismatch to ours incomplete ''
|DIC_status=implemented
|DIC_app=Centralized data front end.accdb
}}


One of the queries used in [[Correcting suspect links]].  
Follow steps in [[Processing errors in patient data]] to fix errors found.


This one lists patients 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 articles ==
 
{{Related Articles}}
Follow steps in [[Processing errors in patient data]] to fix errors found.


[[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]]

Revision as of 02:29, 27 October 2018

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
Firmness: hard check
Timing: always
App: Centralized data front end.accdb
Coding: query Link suspect mismatch to ours incomplete
Uses L Problem table: not entered
Status: implemented
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

Follow steps in Processing errors in patient data to fix errors found.

Related articles

Related articles: