|
|
| Line 224: |
Line 224: |
|
| |
|
| look for 2014 ''sent'' and see if it has to be investigated | | look for 2014 ''sent'' and see if it has to be investigated |
|
| |
|
| |
| '''VET ALL SENT'''
| |
|
| |
| When all data is cleaned, the last query is ''NDC_unvetted''
| |
|
| |
| 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
| |
|
| |
| Then ''Vet All Sent''
| |
|
| |
| 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'
| |
|
| |
|
| |
|
|
| |
|
| Line 265: |
Line 234: |
|
| |
|
|
| |
|
| [[User:Srusnak|Srusnak]] 11:56, 2014 July 23 (CDT) | | [[User:Srusnak|Srusnak]] 12:01, 2014 July 23 (CDT) |
|
| |
|
| == Set record as vetted == | | == Set record as vetted == |