|
|
| (32 intermediate revisions by 3 users not shown) |
| Line 1: |
Line 1: |
| *'''need to make sure all in [[Data Appending Process]] is addressed.'''
| | "Vetting" is our name for the initial quality control our data goes through after [[Data collector]]s finish [[sending]] it. It is one of the main responsibilities of the [[Data Processor]]. |
|
| |
|
| == Pull data == | | == Instructions == |
| *[["Pull" Centralized data.mdb]] | | * [["Pull" Centralized_data.accdb]] |
| | |
| ==prep CFE for use==
| |
| * Double click to open ''Centralized_data_front_end.mdb'' | | * Double click to open ''Centralized_data_front_end.mdb'' |
| * click Reconnect | | * [[Reconnect CFE and initial error checks]] |
| * if there are any records with known false positives, document them to exclude them from queries; see [[Known data errors]] | | * [[Pre-linking checks]] (PL checks) |
| | | * [[Populate linking_pairs]] |
| == Pre-linking (PL) checks ==
| | * [[Correcting suspect links]] |
| 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.
| | * [[Quality Assurance queries in CFE]] - NDC Queries |
| | | ** as part of any of those, there might be [[Questioning data back to collectors]] |
| 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"'''
| | * [["Vet all sent" button]] |
| | | * [[Generate Person IDs]] |
| As of Dec 9.14 - processor to put in beginning of NOTES" the following: Question:date sent: what question was asked.
| | * [["Push" Centralized_data.accdb]] to return data to [[Regional Server]] so [[Data collector]]s can [[send]] |
| *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]]==
| |
| *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
| |
| | |
| == Set records as vetted ==
| |
| At this point all records with problems will have had the [[RecordStatus field]] set to "questioned" so the remaining ones that are set to "sent" are clean and can be set to "vetted".
| |
| | |
| # Press the "vet all sent" button.
| |
| # The program will display a count of how many records have each of the recorstatatus possibilities.
| |
| #* take note of the "sent" number and click OK
| |
| # The program will tell how many records it is about to update. 'you are about to update ___ rows'
| |
| #* If this number is the same as the number of sent records, click OK, if not click cancel and try to figure out what is wrong.
| |
| # This will change all records currently set to "sent" to "vetted".
| |
| | |
| == [[Generate Person IDs]] ==
| |
| | |
| == Push up data ==
| |
| When all processing is done, run [[Push_up_centralized_data.vbs]] to return the data to where collectors can add to it.
| |
|
| |
|
| | == Related articles == |
| | {{Related Articles}} |
|
| |
|
|
| |
|
| [[Category:Data Processing]] | | [[Category:Data Processing]] |
| [[Category:PL queries]]
| |