|
|
| (38 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]] |
| | | * Double click to open ''Centralized_data_front_end.mdb'' |
| ==prep CFE for use==
| | * [[Reconnect CFE and initial error checks]] |
| *Double click to open ''Centralized_data_front_end.mdb'' | | * [[Pre-linking checks]] (PL checks) |
| *click Reconnect | | * [[Populate linking_pairs]] |
| | | * [[Correcting suspect links]] |
| == Pre-linking (PL) checks ==
| | * [[Quality Assurance queries in CFE]] - NDC Queries |
| 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.
| | ** as part of any of those, there might be [[Questioning data back to collectors]] |
| | | * [["Vet all sent" button]] |
| 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"'''
| | * [[Generate Person IDs]] |
| | | * [["Push" Centralized_data.accdb]] to return data to [[Regional Server]] so [[Data collector]]s can [[send]] |
| 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. | |
| | |
| {{Discussion}}
| |
| record status is automatically set to '''question''' if Process uses the paste clip button (not sure what it is called?). Change of record status should only apply to SENT patients. Currently it is being automatically applied to incomplete patients, even though processor send questions to collectors when she spot errors, it is confusing........Tina to review with Pagasa.[[User:TOstryzniuk|Trish Ostryzniuk]] 21:01, 2014 December 9 (CST)
| |
| | |
| 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
| |
| #* Home, Advanced, Advanced Filter/Sort, LastName (double click or drag & drop), Sort by ''ascending'', Home, Toggle Filter what is this? does the query need changing? I am doing that query so that it will group together the same LN and easy to see the error.
| |
| #** this should no longer be required because automated today. If that works, please remove the home... point
| |
| # PL_SamePhin_Diff_LN_FN_DOB_Sex
| |
| #* Home, Advanced, Advanced Filter/sort, Phin (double click or drag & drop), Sort by ''ascending'', Home, Toggle Filter what is this? does the query need changing?I used this query to group together the same PHIN and easy to see the error.
| |
| #** this should no longer be required because automated today. If that works, please remove the home... point
| |
| # PL_SamePHIN_Site_Diff_chart
| |
| | |
| == [[Correcting suspect links]]==
| |
| | |
| == 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]]
| |