Pre-linking checks: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| Line 9: | Line 9: | ||
## [[Orphans in Centralized data.mdb| PL_1orphans]] | ## [[Orphans in Centralized data.mdb| PL_1orphans]] | ||
## [[Generating PseudoPHINs]] (PL_2Phin Fake or Blank) | ## [[Generating PseudoPHINs]] (PL_2Phin Fake or Blank) | ||
## PL_Chart_9_Digit | ## [[PL_Chart_9_Digit]] | ||
## PL_Diff_Phin_SameLN_FN_DOB | ## [[PL_Diff_Phin_SameLN_FN_DOB]] | ||
## PL_SameCHART_Site_Diff_PHIN | ## [[PL_SameCHART_Site_Diff_PHIN]] | ||
## PL_SamePhin_Diff_LN_FN_DOB_Sex | ## [[PL_SamePhin_Diff_LN_FN_DOB_Sex]] | ||
## PL_SamePHIN_Site_Diff_chart | ## [[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. | # 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 | 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 | ||
Revision as of 00:35, 27 October 2018
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 Tuesday before end of day and then email Manager and Statistician that all PL's are completed, corrected and vetted.
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
- Then it will prompt "query check ... is complete", click OK
- Then click "Populate linking pairs" before you go to ND'c
- 2018-Apr-26: NOTE: this takes almost 16 minutes to run.
- If all PLs are corrected, then go to Quality Assurance queries in CFE