alter table EVENT change OID_EMPLOYEE_RESPONSIBLE_FOR_CANCEL OID_RESPONSIBLE_FOR_CANCEL bigint unsigned;
update EVENT set OID_RESPONSIBLE_FOR_CANCEL = (select PARTY.OID from PARTY join EMPLOYEE on EMPLOYEE.OID_PERSON = PARTY.OID where EMPLOYEE.OID = OID_RESPONSIBLE_FOR_CANCEL);

alter table ACADEMIC_SERVICE_REQUEST_SITUATION change OID_EMPLOYEE OID_CREATOR bigint unsigned;
update ACADEMIC_SERVICE_REQUEST_SITUATION set OID_CREATOR = (select PARTY.OID from PARTY join EMPLOYEE on EMPLOYEE.OID_PERSON = PARTY.OID where EMPLOYEE.OID = OID_CREATOR);

update RECTORATE_SUBMISSION_BATCH set OID_CREATOR = (select PARTY.OID from PARTY join EMPLOYEE on EMPLOYEE.OID_PERSON = PARTY.OID where EMPLOYEE.OID = OID_CREATOR);
update RECTORATE_SUBMISSION_BATCH set OID_RECEPTOR = (select PARTY.OID from PARTY join EMPLOYEE on EMPLOYEE.OID_PERSON = PARTY.OID where EMPLOYEE.OID = OID_RECEPTOR);
update RECTORATE_SUBMISSION_BATCH set OID_SUBMITTER = (select PARTY.OID from PARTY join EMPLOYEE on EMPLOYEE.OID_PERSON = PARTY.OID where EMPLOYEE.OID = OID_SUBMITTER);

alter table MARK_SHEET change OID_CONFIRMATION_EMPLOYEE OID_VALIDATOR bigint unsigned;
update MARK_SHEET set OID_VALIDATOR = (select PARTY.OID from PARTY join EMPLOYEE on EMPLOYEE.OID_PERSON = PARTY.OID where EMPLOYEE.OID = OID_VALIDATOR);

alter table MARK_SHEET change OID_CREATION_EMPLOYEE OID_CREATOR bigint unsigned;
update MARK_SHEET set OID_CREATOR = (select PARTY.OID from PARTY join EMPLOYEE on EMPLOYEE.OID_PERSON = PARTY.OID where EMPLOYEE.OID = OID_CREATOR);

alter table ENROLMENT_EVALUATION change OID_EMPLOYEE OID_PERSON bigint unsigned;
update ENROLMENT_EVALUATION set OID_PERSON = (select PARTY.OID from PARTY join EMPLOYEE on EMPLOYEE.OID_PERSON = PARTY.OID where EMPLOYEE.OID = OID_PERSON);