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 (→Instructions: m) |
||
| Line 5: | Line 5: | ||
In [[CFE]] | In [[CFE]] | ||
# open the Patient List | |||
# run each "PL_" (Pre-linking) query in the following order: | |||
## [[Orphans in Centralized data.mdb| "PL_1orphans"]] | |||
## PL_2Phin Fake or Blank (see [[Generating PseudoPHINs]] | |||
## PL_Diff_Phin_SameLN_FN_DOB | |||
## PL_SamePhin_Diff_LN_FN_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. | |||
# close the form | |||
[[Category: Data Processing]] | [[Category: Data Processing]] | ||
Revision as of 13:46, 2015 August 17
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:
- "PL_1orphans"
- PL_2Phin Fake or Blank (see Generating PseudoPHINs
- PL_Diff_Phin_SameLN_FN_DOB
- PL_SamePhin_Diff_LN_FN_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.
- close the form