Open Dental Forum

When an appointment with procedures under a certain providor is changed to a different providor the procedure providor changes but the claim procedure providor remains the same but needs to be changed to match the procedure providor. This only makes for a serious problem if it is a capitation plan since the writeoffs no longer match the providor.

To be corrected the claimproc.ProvNum should always match the procedurelog.ProcNum

This is a query that we wrote to correct it after the fact but it needs corrected in the code.

UPDATE claimproc
inner join procedurelog on procedurelog.procnum=claimproc.ProcNum
SET claimproc.ProvNum=procedurelog.ProvNum
WHERE
claimproc.ProvNum <> procedurelog.ProvNum AND claimproc.ProcNum = procedurelog.ProcNum

This should make all the claimproc.provnum the same as the procedurelog.provnum.

Thanks,
Curt