Time taken for clerical review

brendomac · Posted: Thu Sep 14, 2017 8:23 pm

Hi everyone,

We are attempting to create a timeline for a project along with resource needs.

I was hoping someone could provide some insight into the time taken for clerical review from a datastage matching job.

For example, our experience indicates clerical record review takes on average 5 minutes per record. Using a base of 1000 pairs to be checked it would take approximately 83 hours to perform the review

Thanks
Brendan

qt_ky · Posted: Fri Sep 15, 2017 5:42 am

I guess it depends entirely on the nature of your data.

Here is some food for thought. In our QualityStage matching project, the customer did not want to spend any human time doing ongoing clerical reviews, so we set the high and low thresholds equal to each other, and put them at a level that the customer was comfortable with.

brendomac · Posted: Sun Sep 17, 2017 3:59 pm

Thanks qt..

vmcburney · Posted: Tue Sep 26, 2017 7:24 am

Depends on what business process you want to follow out of the clerical review.

During the testing phase you will need a block of time to investigate the clerical reviews and then go back and improve your standardisation and matching rules to reduce future clerical reviews.

You have a process of adjusting your clerical review thresholds based on what you are finding.

You could have a process of going back and fixing some records back at source to get the match to work on the next batch run and this will have a support cost. You can have a low cost in the matching team to review and verify that two records should be matched. You have a higher cost in the customer support team to go and fix the source records to make them more consistent for that customer.

brendomac · Posted: Tue Sep 26, 2017 4:11 pm

Thankyou VM, I appreciate your input.