Remove persons/jobs added due to data entry errors in OIT Data Warehouse?

[nihiliad]

No description provided.

[nihiliad]

Some persons are mistakenly eligible for inclusion in Experts/Pure due to data entry errors, and become ineligible after those errors are corrected. In addition to removing the associated errors from Experts DW (see #12), their data should also be removed. These queries should do it:

delete from pure_eligible_person_chng_hst where emplid = :emplid; 
delete from pure_sync_staff_org_association where person_id = :emplid;
delete from pure_sync_user_data where person_id = :person_id; -- all of these should be the same as :emplid
delete from pure_sync_person_data where emplid = :emplid;
delete from umn_data_error where emplid = :emplid;