Centralized data Vetting Process

• need to make sure all in Data Appending Process is addressed.

Pull data

• "Pull" Centralized data.mdb

prep CFE for use

• Double click to open Centralized_data_front_end.mdb
• click Reconnect

Link patients

• Pre-linking checks (PL checks)
• Populate linking_pairs

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".

1. Press the "vet all sent" button.
2. 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
3. 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.
4. 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.