Pre-linking checks: Difference between revisions

(36 intermediate revisions by 4 users not shown)

Line 2:

== 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.~~

Processor to complete all PL '''every day'''

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]] - if any found, follow [[Generating PseudoPHINs]]

## PL_2Phin Fake or Blank ~~(see~~ [[Generating PseudoPHINs]]

## [[PL_Chart_9_Digit]]

## PL_Diff_Phin_SameLN_FN_DOB

## [[PL_Diff_Phin_SameLN_FN_DOB]]

## ~~PL_SamePhin_Diff_LN_FN_DOB_Sex~~

## [[PL_SameCHART_Site_Diff_PHIN]]

## PL_SamePHIN_Site_Diff_chart

## [[PL_SamePhin_Diff_DOB_Sex]]

#* if there is an error in any of the queries follow the instructions in [[Processing errors in patient data]] to correct them.

## [[PL_SamePHIN_Site_Diff_chart]]

# ~~close~~ the ~~form~~

# 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 ==

[[Category: Data Processing]]

@@ Line 2: / Line 2: @@
 == 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.
+Processor to complete all PL '''every day'''
 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]] - if any found, follow [[Generating PseudoPHINs]]
-## PL_2Phin Fake or Blank (see [[Generating PseudoPHINs]]
+## [[PL_Chart_9_Digit]]
-## PL_Diff_Phin_SameLN_FN_DOB
+## [[PL_Diff_Phin_SameLN_FN_DOB]]
-## PL_SamePhin_Diff_LN_FN_DOB_Sex
+## [[PL_SameCHART_Site_Diff_PHIN]]
-## PL_SamePHIN_Site_Diff_chart
+## [[PL_SamePhin_Diff_DOB_Sex]]
-#* if there is an error in any of the queries follow the instructions in [[Processing errors in patient data]] to correct them.
+## [[PL_SamePHIN_Site_Diff_chart]]
-# close the form
+# 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]]