Pre-linking checks: Difference between revisions

(24 intermediate revisions by 2 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]]

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

## [[PL_Chart_9_Digit]]

## [[~~PL_Diff_Phin_SameLN_FN_DOB~~]]

## [[PL_DiffPhin_SameLN_FN_DOB]]

## [[PL_SameCHART_Site_Diff_PHIN]]

## [[~~PL_SamePhin_Diff_LN_FN_DOB_Sex~~]]

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

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

* Then ~~click "~~[[Populate linking pairs]]~~" before you go to ND'c~~

Then move on to [[Populate linking pairs]]

**2018-Apr-26: NOTE: this takes almost '''16 minutes to run'''.

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

{{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]]

[[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]]
-## [[Generating PseudoPHINs]] (PL_2Phin Fake or Blank)
 ## [[PL_Chart_9_Digit]]
-## [[PL_Diff_Phin_SameLN_FN_DOB]]
+## [[PL_DiffPhin_SameLN_FN_DOB]]
 ## [[PL_SameCHART_Site_Diff_PHIN]]
-## [[PL_SamePhin_Diff_LN_FN_DOB_Sex]]
+## [[PL_SamePhin_Diff_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.
-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
-* Then click "[[Populate linking pairs]]" before you go to ND'c
+Then move on to [[Populate linking pairs]]
-**2018-Apr-26: NOTE: this takes almost '''16 minutes to run'''.
-* If all PLs are corrected, then go to [[Quality Assurance queries in CFE]]
+{{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]]
+[[Category:Data Processing]]