Pre-linking checks

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 email the Statistician that all PL's are completed, corrected and vetted.

In CFE

1. open the Patient List
2. run each "PL_" (Pre-linking) query in the following order:
   1. PL_1orphans- see Orphans in Centralized data.mdb for what to do about these.
   2. PL_2Phin Fake or Blank - Generating PseudoPHINs
   3. PL_Chart_9_Digit
   4. PL_Diff_Phin_SameLN_FN_DOB
   5. PL_SameCHART_Site_Diff_PHIN
   6. PL_SamePhin_Diff_LN_FN_DOB_Sex
   7. PL_SamePHIN_Site_Diff_chart

Do the above need to be done in a specific order? all of them or just one or two and the rest can be any?

• SMW

• Cargo

• Categories

1. if there is an error in any of the queries follow the instructions in Processing errors in patient data to correct them.
2. 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
3. Then it will prompt "query check ... is complete", click OK

Then move on to Populate linking pairs

need to confirm that all of CFE Data Integrity Checks are addressed.

• SMW

• Cargo

• Categories

SMW list of PL queries for reference

Automated list of all PL_ tables for reference, but use above because it is in a specific order

PL 2Phin Fake or Blank PL Chart 9 Digit PL DiffPhin SameLN FN DOB PL SameCHART Site Diff PHIN PL SamePHIN Site Diff chart PL SamePhin Diff DOB Sex

That includes an PL missing L Tables content - where does it fit in? It is likely a very first thing, right?

• SMW

• Cargo

• Categories