Pre-linking checks: Difference between revisions
Ttenbergen (talk | contribs) Created page with "We collect data as ward-stays, but we then try to link records together to get data on the complete hospital stay. Prior to this linking the data needs to be checked for incom..." |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (39 intermediate revisions by 4 users not shown) | |||
| Line 2: | Line 2: | ||
== Instructions == | == Instructions == | ||
Processor to complete all PL '''every | Processor to complete all PL '''every day''' | ||
In [[CFE]] | |||
# open the Patient List | |||
# run each "PL_" (Pre-linking) query in the following order: | |||
## [[PL_2Phin Fake or Blank]] - if any found, follow [[Generating PseudoPHINs]] | |||
## [[PL_Chart_9_Digit]] | |||
## [[PL_DiffPhin_SameLN_FN_DOB]] | |||
## [[PL_SameCHART_Site_Diff_PHIN]] | |||
## [[PL_SamePhin_Diff_DOB_Sex]] | |||
## [[PL_SamePHIN_Site_Diff_chart]] | |||
# if there is an error in any of the queries follow the instructions in [[Processing errors in patient data]] to correct them. | |||
# After we have corrected all errors, click the PLs box to see if we corrected all the errors. A prompt message "Are you sure you want...", click yes; wait for the message "Query check for queries starting with ... is complete" | |||
Then move on to [[Populate linking pairs]] | |||
{{Collapsable | |||
| always= Automated list of all PL_ tables for reference, but use above because it is in a specific order | |||
| full= | |||
{{#ask: [[category:Data Integrity Checks]] [[~PL_*]] | |||
|format=UL | |||
|default=none found | |||
}} }} | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data Processing]] | [[Category:Data Processing]] | ||