by Karen Wolfe
Merge duplicate records
Tax ID’s are still important for reimbursement and 1099 purposes, but often multiple doctors are represented by one Tax ID. To evaluate provider performance, individuals must be differentiated in the data. State medical license numbers and NPI (National Provider Identification) numbers are needed. Frankly, some doctors deliberately obfuscate the data by operating under multiple Tax ID’s and multiple NPI numbers. Consequently, provider records must be merged, scrubbed, and optimized before any analysis can begin.