Centralized data Vetting Process: Difference between revisions

m Confirm data backups: spun out into existing article
Line 243: Line 243:
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".
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".


===VET ALL SENT===


When all data is cleaned, the last query is ''NDC_unvetted''  
When all data is cleaned, the last query is ''NDC_unvetted''  
* does that query actually do anything for us? {{discussion}} Ttenbergen 23:07, 2014 September 29 (CDT)


On the 'RecStatus' column  
On the 'RecStatus' column  
Line 255: Line 254:


Scroll down to the last 'sent' record, to see how many records will be vetted  
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? {{discussion}} Ttenbergen 23:07, 2014 September 29 (CDT)


Then ''Vet All Sent''  
Then click the ''Vet All Sent'' button


Prompts 'are you sure'  
Prompts 'are you sure'  
Line 273: Line 273:


e.g. if your last 'sent' record was 25, then the prompt will say 'you are about to update 25 rows'  
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? {{discussion}} Ttenbergen 23:07, 2014 September 29 (CDT)
[[User:Srusnak|Srusnak]] 12:00, 2014 July 23 (CDT)


== Push up data ==
== Push up data ==