Pre-linking checks

From CCMDB Wiki
Revision as of 10:10, 17 August 2015 by 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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:
    1. "PL_1orphans"
    2. PL_2Phin Fake or Blank (see Generating PseudoPHINs
    3. PL_Diff_Phin_SameLN_FN_DOB
    4. PL_SamePhin_Diff_LN_FN_DOB_Sex
    5. PL_SamePHIN_Site_Diff_chart
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Pre-linking_checks&oldid=45442"