Centralized data Vetting Process: Difference between revisions

(26 intermediate revisions by 3 users not shown)

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''

* ~~click~~ Reconnect

* [[Reconnect CFE and initial error checks]]

* [[Pre-linking checks]] (PL checks)

~~== Link patients ==~~

* [[Populate linking_pairs]]

*[[Pre-linking checks]] (PL checks)

* [[Correcting suspect links]]

*[[Populate linking_pairs]]

* [[Quality Assurance queries in CFE]] - NDC Queries

** as part of any of those, there might be [[Questioning data back to collectors]]

== [[Correcting suspect links]]==

* [["Vet all sent" button]]

* [[Generate Person IDs]]

~~== Set records as vetted ==~~

* [["Push" Centralized_data.accdb]] to return data to [[Regional Server]] so [[Data collector]]s can [[send]]

~~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 ==

[[Category:Data Processing]]

~~[[Category:PL queries]]~~

@@ 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''
-* click Reconnect
+* [[Reconnect CFE and initial error checks]]
+* [[Pre-linking checks]] (PL checks)
-== Link patients ==
+* [[Populate linking_pairs]]
-*[[Pre-linking checks]] (PL checks)
+* [[Correcting suspect links]]
-*[[Populate linking_pairs]]
+* [[Quality Assurance queries in CFE]] - NDC Queries
+** as part of any of those, there might be [[Questioning data back to collectors]]
-== [[Correcting suspect links]]==
+* [["Vet all sent" button]]
+* [[Generate Person IDs]]
-== Set records as vetted ==
+* [["Push" Centralized_data.accdb]] to return data to [[Regional Server]] so [[Data collector]]s can [[send]]
-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:PL queries]]