Pre-linking checks: Difference between revisions

(12 intermediate revisions by 2 users not shown)

Line 6:

# open the Patient List

# run each "PL_" (Pre-linking) query in the following order:

#* (FIRST) [[PL_2Phin Fake or Blank]] - if any found, follow [[Generating PseudoPHINs]]

## [[PL_2Phin Fake or Blank]] - if any found, follow [[Generating PseudoPHINs]]

#* [[PL_Chart_9_Digit]]

## [[PL_Chart_9_Digit]]

#* [[~~PL_Diff_Phin_SameLN_FN_DOB~~]]

## [[PL_DiffPhin_SameLN_FN_DOB]]

#* [[PL_SameCHART_Site_Diff_PHIN]]

## [[PL_SameCHART_Site_Diff_PHIN]]

#* [[~~PL_SamePhin_Diff_LN_FN_DOB_Sex~~]]

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

~~{{DT | not working right now due to [[PL_SamePHIN_Site_Diff_chart]] size limit}}~~

Then move on to [[Populate linking pairs]]

~~=== SMW list of PL queries for reference ===~~

{{Collapsable

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

Line 27:

Line 24:

|default=none found

}} }}

~~{{Discuss | who = Pagasa | question = That includes an [[PL missing L Tables content]] - where does it fit in? It is likely a very first thing, right? }}~~

== Related articles ==

[[Category: Data Processing]]

[[Category:Data Processing]]

@@ Line 6: / Line 6: @@
 # open the Patient List
 # run each "PL_" (Pre-linking) query in the following order:
-#* (FIRST) [[PL_2Phin Fake or Blank]] - if any found, follow [[Generating PseudoPHINs]]
+## [[PL_2Phin Fake or Blank]] - if any found, follow [[Generating PseudoPHINs]]
-#* [[PL_Chart_9_Digit]]
+## [[PL_Chart_9_Digit]]
-#* [[PL_Diff_Phin_SameLN_FN_DOB]]
+## [[PL_DiffPhin_SameLN_FN_DOB]]
-#* [[PL_SameCHART_Site_Diff_PHIN]]
+## [[PL_SameCHART_Site_Diff_PHIN]]
-#* [[PL_SamePhin_Diff_LN_FN_DOB_Sex]]
+## [[PL_SamePhin_Diff_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; wait for the message "Query check for queries starting with ... is complete"
-{{DT | not working right now due to [[PL_SamePHIN_Site_Diff_chart]]  size limit}}
 Then move on to [[Populate linking pairs]]
-=== SMW list of PL queries for reference ===
 {{Collapsable
 | always= Automated list of all PL_ tables for reference, but use above because it is in a specific order
@@ Line 27: / Line 24: @@
 |default=none found
 }} }}
-{{Discuss | who = Pagasa | question = That includes an [[PL missing L Tables content]] - where does it fit in? It is likely a very first thing, right? }}
 == Related articles ==
 {{Related Articles}}
-[[Category: Data Processing]]
+[[Category:Data Processing]]