|
|
| Line 7: |
Line 7: |
| * Double click to open ''Centralized_data_front_end.mdb'' | | * Double click to open ''Centralized_data_front_end.mdb'' |
| * click Reconnect | | * click Reconnect |
|
| |
|
| |
|
| == Pre-linking (PL) checks == | | == Pre-linking (PL) checks == |
| 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.
| | [[Pre-linking checks]] |
| | |
| Use [[Centralized data front end.mdb]] "PL" (Pre-linking) queries and fix data as needed; if a patient shows up in one of the queries fix if possible; if question to collector is required, set '''[[RecordStatus field]] to "questioned"'''
| |
| | |
| As of Dec 9.14 - processor to put in beginning of NOTES" the following: Question:date sent: what question was asked.
| |
| *if question is resolved she removes the notes when she reset record status from Question, back to SENT.
| |
| *record status is automatically set to '''question''' if Process uses the paste clipboard button. Change of record status should only apply to SENT patients.
| |
| | |
| Perform the Queries in this order:
| |
| | |
| # [[Orphans in Centralized data.mdb| "PL_1orphans"]]
| |
| # PL_2Phin Fake or Blank (see [[Generating PseudoPHINs]]
| |
| # PL_Diff_Phin_SameLN_FN_DOB
| |
| # PL_SamePhin_Diff_LN_FN_DOB_Sex
| |
| # PL_SamePHIN_Site_Diff_chart
| |
|
| |
|
| == [[Correcting suspect links]]== | | == [[Correcting suspect links]]== |
| *To edit serial number and location you should do it on L_Log and L_Phi.
| |
| *After you finished edit the PL close the form.
| |
| *Click the populate linking_pairs
| |
| * if there are any records with known false positives, document them to exclude them from queries; see [[Known data errors]]/[[L Problem]]
| |
|
| |
|
| == Set records as vetted == | | == Set records as vetted == |
| Line 44: |
Line 25: |
| == [[Generate Person IDs]] == | | == [[Generate Person IDs]] == |
|
| |
|
| ==[[Quality Assurance queries in CFE]]== | | == [[Quality Assurance queries in CFE]] == |
|
| |
|
| == Push up data == | | == Push up data == |