ABPN IT

Sometimes program users will accidentally create a duplicate physician when they intended to transfer an existing user into their program, and these duplicate physician records will need to be deleted.  Note - if the physician gets further into their process and has made a payment to the ABPN we realize that they have two person records in BC, keep the person that has the payment and invoice.  The process is as follows:

Run the following Select queries to see which tables need to have the duplicate physician records deleted

select * from person_name where person_key = 226829

select * from userPhysicianViewHistory where person_key = 226829

select * from medical_education where person_key = 226829

select * from personTraining where person_key = 226829

select * from clinicalSkill where person_key = 226829

Run the following Delete statements in order (NOTE: it is recommended to enclose each one in a transaction first to ensure you are deleting the expected number of rows)

delete from person_name where person_key = 226829

delete from userPhysicianViewHistory where person_key = 226829

delete from medical_education where person_key = 226829

delete from personTraining where person_key = 226829

delete from clinicalSkill where person_key = 226829

Lastly, delete the record from the Person table

delete from person where person_key = 226829

Also In case if you might have visited Boardcert and navigated to the deleted person key in the past. You might want to delete that record from UserPhysicianViewHistory table as well. 

failing to delete from the table above might result in getting a 500 error in Boardcert, and you may not be able to login to Boardcert.

delete from UserPhysicianViewHistory WHERE Person_Key = 226829 

Note:

1. If the physician gets further into their process and has made a payment to the ABPN we realize that they have two person records in BC, keep the person that has the payment and invoice.  

2. Ask requestor if it is ok to delete any training (PGYs, CSEs on the person they ask you to delete.  Usually it is ok, but always ask first before deleting.