Pre-linking checks: Difference between revisions
Jump to navigation
Jump to search
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]] | ||
Latest revision as of 11:56, 30 July 2025
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 incomplete matches and errors.
Instructions
Processor to complete all PL every day In CFE
- open the Patient List
- run each "PL_" (Pre-linking) query in the following order:
- 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
| Automated list of all PL_ tables for reference, but use above because it is in a specific order |