Pre-linking checks: Difference between revisions

Created page with "We collect data as ward-stays, but we then try to link records together to get data on the complete hospital stay. Prior to this linking the data needs to be checked for incom..."
 
Line 5: Line 5:


In [[CFE]]
In [[CFE]]
* 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:  
*# [[Orphans in Centralized data.mdb| "PL_1orphans"]]
## [[Orphans in Centralized data.mdb| "PL_1orphans"]]
*# PL_2Phin Fake or Blank (see [[Generating PseudoPHINs]]
## PL_2Phin Fake or Blank (see [[Generating PseudoPHINs]]
*# PL_Diff_Phin_SameLN_FN_DOB
## PL_Diff_Phin_SameLN_FN_DOB
*# PL_SamePhin_Diff_LN_FN_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.  
#* if there is an error in any of the queries follow the instructions in [[Processing errors in patient data]] to correct them.  
 
# close the form
 


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