Pre-linking checks: Difference between revisions

(32 intermediate revisions by 3 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_Chart_9_Digit

## [[PL_DiffPhin_SameLN_FN_DOB]]

## ~~PL_Diff_Phin_SameLN_FN_DOB~~

## [[PL_SameCHART_Site_Diff_PHIN]]

## PL_SameCHART_Site_Diff_PHIN

## [[PL_SamePhin_Diff_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.

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; wait for the message "Query check for queries starting with ... is complete"

* Then it will prompt "~~query~~ check ... is complete"~~, click OK~~

* If all ~~PLs are corrected~~, ~~then go to~~ [[~~Quality Assurance queries in CFE~~]]

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

* I made the PLs button so it would no longer be necessary to run the queries individually. Do we still do that? If so, let's discuss. If not, please update the instructions above. Ttenbergen 10:25, 2016 August 3 (CDT)

[[Category: Data Processing]]

[[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_Chart_9_Digit
+## [[PL_DiffPhin_SameLN_FN_DOB]]
-## PL_Diff_Phin_SameLN_FN_DOB
+## [[PL_SameCHART_Site_Diff_PHIN]]
-## PL_SameCHART_Site_Diff_PHIN
+## [[PL_SamePhin_Diff_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.
-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; wait for the message "Query check for queries starting with ... is complete"
-* Then it will prompt "query check ... is complete", click OK
-* If all PLs are corrected, then go to [[Quality Assurance queries in CFE]]
+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
+}} }}
-{{discussion}}
+== Related articles ==
-* I made the PLs button so it would no longer be necessary to run the queries individually. Do we still do that? If so, let's discuss. If not, please update the instructions above. Ttenbergen 10:25, 2016 August 3 (CDT)
+{{Related Articles}}
-[[Category: Data Processing]]
+[[Category:Data Processing]]