...
- Email is matched on Entity_Id and Email_Type ("WRK", "HS", "OTH") to determine changes, deletions or additions.
- Employee/Affiliations are matched on Entity_Id, Affiliation_Type ("FCLTY", "STAFF", "STDNT", "AFLT" ) and IAMID (EMP_REC_ID) to determine changes, deletions or additions.
- If Employee number or primary department code is blank then the record is not updated (so we don't remove employee information about employees that have left or are leaving).
- Name, Address, and Phone are matched on Entity_Id to determine changes, deletions or additions.
...