|
|
| (66 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.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]] |
|
| |
|
| == 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**'''
| |
|
| |
|
| | | [[Category:Data Processing]] |
| == Make PseudoPHINs ==
| |
| see [[Generating PseudoPHINs]]
| |
| | |
| == Check For Problems ==
| |
| 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"]]
| |
| #* 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
| |
| | |
| *****For Queries 8-13
| |
| ******we are only monitoring ICU Medicine are also included and should not be.
| |
| *******look for 2014 ''sent'' and see if it has to be investigated Only patients send after Jan. 1 2014.
| |
| ********{{discussion}} what is this about? Do queries need tweaks? Ttenbergen 23:20, 2014 September 29 (CDT)
| |
| | |
| Once every query has been performed, checked, and cleaned perform the first 7 queries once more, to make sure data is all clean and you did not forget any corrections.
| |
| | |
| | |
| * '''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}} what needs doing? Ttenbergen 23:20, 2014 September 29 (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. This will change all records currently set to "sent" to "vetted".
| |
| | |
| | |
| When all data is cleaned, the last query is ''NDC_unvetted''
| |
| * does that query actually do anything for us? Ttenbergen 23:07, 2014 September 29 (CDT)
| |
| | |
| On the 'RecStatus' column
| |
| | |
| Right click the first one
| |
| | |
| Sort by Z to A which will sort by Sent, Questioned, Incomplete statuses
| |
| | |
| Scroll down to the last 'sent' record, to see how many records will be vetted
| |
| * should that query just change to have only "sent"s? Ttenbergen 23:07, 2014 September 29 (CDT)
| |
| | |
| Then click the ''Vet All Sent'' button
| |
| | |
| Prompts 'are you sure'
| |
| | |
| answer Yes
| |
| | |
| prompts 'you are about to run ...'
| |
| | |
| answer Yes
| |
| | |
| prompts 'you are about to update ___ rows'
| |
| | |
| answer Yes
| |
| | |
| The number in the ''___ rows'', should be the same as the last 'sent' record from your scroll down
| |
| | |
| e.g. if your last 'sent' record was 25, then the prompt will say 'you are about to update 25 rows'
| |
| * has the number ever been anything different? Ttenbergen 23:07, 2014 September 29 (CDT)
| |
| ** yes it has [[User:PTorres|PTorres]] 10:55, 2014 October 1 (CDT)
| |
| | |
| * Tina will replace this process with a tally msgox that comes up when "vet all" is pressed, ok, how many will be updated, ok, [[User:PTorres|PTorres]] 10:55, 2014 October 1 (CDT)
| |
| * NDC unvetted can then be deleted[[User:PTorres|PTorres]] 10:55, 2014 October 1 (CDT)
| |
| {{discussion}}
| |
| | |
| == 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]]
| |