Correcting suspect links: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
PTorres (talk | contribs)
No edit summary
mNo edit summary
 
(3 intermediate revisions by 2 users not shown)
Line 3: Line 3:
== Instructions ==
== Instructions ==
# be sure you have completed [[Populate linking pairs]]
# be sure you have completed [[Populate linking pairs]]
# click the '''PatientList''' button on the Main Form; opening this can take a few seconds.
# click the '''PatientList''' button on the Main Form; opening this can take a few seconds
# for each "link_suspect..." entry in the ''"Apply Query"'' drop-down; see links for more info
# click the [[LSusp button]], which will run the following queries but only keep open the ones that are not empty
#* these can be done in any order
:::{{#ask: [[category:Data Integrity Checks]] [[~Link_suspect_*]]
{{#ask: [[category:Data Integrity Checks]] [[~Link_suspect_*]]
|format=UL
|format=UL
|default=none found
|default=none found
}}
}}
::* alternatively you can run the queries manually: for each "link_suspect..." entry in the ''"Apply Query"'' drop-down; see links for more info
::* these can be done in any order


Follow steps in [[Processing errors in patient data]] to address any errors
Follow steps in [[Processing errors in patient data]] to address any errors
{{DT |
update when the button has been added: When done, click the ...  button to confirm all link_suspects queries are clean. }}


When done, go to the next step in [[Centralized data Vetting Process]], [[Quality Assurance queries in CFE]].
When done, go to the next step in [[Centralized data Vetting Process]], [[Quality Assurance queries in CFE]].
== Implementation ==
The form will list any query that starts with "link_suspect_" in the "apply query" drop-down. If a choice is made in the drop-down, the resulting data is then listed in a format that should facilitate fixing it.


== Related articles ==
== Related articles ==

Latest revision as of 14:03, 2021 July 15

After Populate linking_pairs in CFE as part of Centralized data Vetting Process the links need to be checked for errors .

Instructions

  1. be sure you have completed Populate linking pairs
  2. click the PatientList button on the Main Form; opening this can take a few seconds
  3. click the LSusp button, which will run the following queries but only keep open the ones that are not empty
  • alternatively you can run the queries manually: for each "link_suspect..." entry in the "Apply Query" drop-down; see links for more info
  • these can be done in any order

Follow steps in Processing errors in patient data to address any errors

When done, go to the next step in Centralized data Vetting Process, Quality Assurance queries in CFE.

Related articles

Related articles: