>Hi Dragan,
>
>When I was loading batches (and getting all these invalid seek offsets problems) I found several cases where SSN and DOB were the same, but patient name in our database didn't match the name in the stage tables and the difference was first letter of the last name.
>
>In other words, we may have Ruth Gordon in stage and Ruth Dgordon in our database, which doesn't make any sense. So, I found 32 cases (117 were until I ran select distinct to eliminate dups) with this problem. My manager and other colleagues were trying to track the problem.
Well it does make sense if names are so often retyped - there will be errors. You probably remember the many times your old name was misspelled - I've lost count of how many different versions of my last name I saw. And if the entry point where these data are created has no way to check the identity of the patient against your database - you're extremely lucky to have just 32.