|
|
| (46 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'' |
| | * [[Reconnect CFE and initial error checks]] |
| | * [[Pre-linking checks]] (PL checks) |
| | * [[Populate linking_pairs]] |
| | * [[Correcting suspect links]] |
| | * [[Quality Assurance queries in CFE]] - NDC Queries |
| | ** as part of any of those, there might be [[Questioning data back to collectors]] |
| | * [["Vet all sent" button]] |
| | * [[Generate Person IDs]] |
| | * [["Push" Centralized_data.accdb]] to return data to [[Regional Server]] so [[Data collector]]s can [[send]] |
|
| |
|
| ==prep CFE for use== | | == Related articles == |
| *Double click to open ''Centralized_data_front_end.mdb''
| | {{Related Articles}} |
| *click Reconnect
| |
|
| |
|
| == Pre-linking (PL) 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 '''[[Record Status field]] to "questioned"'''
| |
|
| |
| 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 the it will group together with the same LN and easy to see the error.
| |
| # 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.
| |
| # PL_SamePHIN_Site_Diff_chart
| |
|
| |
| == [[Correcting suspect links]]==
| |
|
| |
| == Set record as vetted ==
| |
| At this point all records with problems will have had the [[Record Status 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".
| |
|
| |
| == 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.
| |
|
| |
| == backup and confirm data backups ==
| |
| see [[Centralized data backup process]]
| |
|
| |
|
| [[Category:Data Processing]] | | [[Category:Data Processing]] |
| [[Category:PL queries]]
| |