search

UMNLibraries / experts_etl

Moves data from UMN to Pure (Experts@Minnesota), and vice versa.
3 stars 0 forks source link

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

Open nihiliad opened 4 years ago

nihiliad commented 3 years ago

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 https://github.com/UMNLibraries/experts_etl/issues/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;