Centralized data Vetting Process: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →Check For Problems: clean-up |
Ttenbergen (talk | contribs) |
||
| Line 51: | Line 51: | ||
== Set record as vetted == | == 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 | 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 == | == Push up data == | ||
Revision as of 15:06, 1 October 2014
- need to make sure all in Data Appending Process is addressed.
Pull data
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**
Make 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:
- "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
- still working on this one (have not done this one yet)
- NDC_Missing_TransferDate_wPivot
- Template:Discussion Pagasa agreed to update this during meeting today. Ttenbergen 15:57, 2014 October 1 (CDT)
- NDC_Missing_TransferDate_wPivot
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.