Pre-linking checks: Difference between revisions

PTorres (talk | contribs)
m Text replacement - "[[Category: " to "[[Category:"
 
(5 intermediate revisions by 2 users not shown)
Line 6: Line 6:
# open the Patient List
# open the Patient List
# run each "PL_" (Pre-linking) query in the following order:  
# run each "PL_" (Pre-linking) query in the following order:  
## [[PL 1orphans]] - if any found, follow [[Orphans in Centralized data.mdb]]
## [[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_DOB_Sex]]
## [[PL_SamePhin_Diff_DOB_Sex]]
Line 18: Line 17:
Then move on to [[Populate linking pairs]]
Then move on to [[Populate linking pairs]]


=== SMW list of PL queries for reference ===
{{Collapsable  
{{Collapsable  
| always= Automated list of all PL_ tables for reference, but use above because it is in a specific order
| 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
|default=none found
}} }}
}} }}
{{Discuss | who = Pagasa | question = This automatic list includes an [[PL missing L Tables content]] - where does it fit in into the order in which you run these above? It is likely a very first thing, right? }}
* It should be #5.


== Related articles ==
== Related articles ==
{{Related Articles}}
{{Related Articles}}


[[Category: Data Processing]]
[[Category:Data Processing]]