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

Pre-linking (PL) checks

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.

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"

As of Dec 9.14 - processor to put in beginning of NOTES" the following: Question:date sent: what question was asked.

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:

"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

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

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.