Centralized data Vetting Process: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m minor
m Text replacement - "[["Pull" Centralized_data.accdb]]" to ""Pull" Centralized_data.accdb"
 
(31 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]]
 
==prep CFE for use==
* Double click to open ''Centralized_data_front_end.mdb''
* Double click to open ''Centralized_data_front_end.mdb''
* click Reconnect
* [[Reconnect CFE and initial error checks]]
* if there are any records with known false positives, document them to exclude them from queries; see [[Known data errors]]
* [[Pre-linking checks]] (PL checks)
 
* [[Populate linking_pairs]]
== Pre-linking (PL) checks ==
* [[Correcting suspect links]]
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. 
* [[Quality Assurance queries in CFE]] - NDC Queries
 
** as part of any of those, there might be [[Questioning data back to collectors]]
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"'''
* [["Vet all sent" button]]
 
* [[Generate Person IDs]]
As of Dec 9.14 - processor to put in beginning of NOTES" the following: Question:date sent: what question was asked.
* [["Push" Centralized_data.accdb]] to return data to [[Regional Server]] so [[Data collector]]s can [[send]]
*if question is resolved she removes the notes when she reset record status from Question, back to SENT.
*record status is automatically set to '''question''' if Process uses the paste clipboard button.  Change of record status should only apply to SENT patients.
 
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
# PL_SamePhin_Diff_LN_FN_DOB_Sex
# PL_SamePHIN_Site_Diff_chart
 
== [[Correcting suspect links]]==
*To edit serial number and location you should do it on L_Log and L_Phi.
*After you finished edit the PL close the form.
*Click the populate linking_pairs
 
==[[L Problem]]==
 
== 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 recordstatus 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]] ==
 
==[[Quality Assurance queries in CFE]]==
 
== 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]]

Latest revision as of 15:42, 23 July 2025

"Vetting" is our name for the initial quality control our data goes through after Data collectors finish sending it. It is one of the main responsibilities of the Data Processor.

Instructions

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_Vetting_Process&oldid=165571"