|
|
| (59 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]]. |
|
| |
|
| | == Instructions == |
| | * [["Pull" Centralized data.mdb]] |
| | * 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.mdb]] to return data to [[Regional Server]] so [[Data collector]]s can [[send]] |
|
| |
|
| == Pull data == | | == Related articles == |
| *[["Pull" Centralized data.mdb]]
| | {{Related Articles}} |
|
| |
|
| ==prep CFE for use==
| |
| *Double click to open ''Centralized_data_front_end.mdb''
| |
| *click Reconnect
| |
| === cross-check tables ===
| |
| *Open Patient List
| |
| *on the Left side,
| |
| *scroll All Access Objects
| |
| *Tables
| |
| **L_Log - write down the number
| |
| **L_PHI - write down the number
| |
| *click ''back to top''
| |
| **Queries
| |
| **L_Log_PHI - write down the number
| |
| '''**ALL 3 must be the same**'''
| |
|
| |
|
| == steps ==
| | [[Category:Data Processing]] |
| Use [[Centralized data front end.mdb]] "NDC" (''New Data Check'') 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| "NDC_orphans"]]
| |
| # see [[Generating PseudoPHINs]]
| |
| #* should always be zero
| |
| # NDC_Chart_9_Digit
| |
| # NDC_Diff_Phin__SameLN_FN_DOB
| |
| #* Home, Advanced, Advanced Filter/Sort, LastName (double click or drag & drop), Sort by ''ascending'', Home, Toggle Filter
| |
| # NDC_SameChart_Site_Diff_Phin
| |
| # NDC_SamePhin_Diff_LN_FN_DOB_Sex
| |
| #* Home, Advanced, Advanced Filter/sort, Phin (double click or drag & drop), Sort by ''ascending'', Home, Toggle Filter
| |
| # NDC_SamePHIN_Site_Diff_chart
| |
| # NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]])
| |
| # NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]])
| |
| # NDC_CLI_unacceptable_date (see [[CLI Dx vs Tmp checking]])
| |
| # NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]])
| |
| # NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]])
| |
| # NDC_VAP_unacceptable_date (see [[VAP Dx vs Tmp checking]])
| |
| # NDC_unvetted
| |
| | |
| * '''still working on this one''' (have not done this one yet)
| |
| ** [[Transfer_Ready_date_and_time #NDC_Missing_TransferDate_w_pivot|NDC_Missing_TransferDate_wPivot]]
| |
| *** {{discussion}} Pagasa agreed to update this during meeting today. Ttenbergen 15:57, 2014 October 1 (CDT)
| |
| | |
| == 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]]
| |