Oracle Fusion/HCM/Global HR

PER_EMAIL_ADDRESSES

Person email addresses — one row per email type (work, home) per person.

EMAIL_ADDRESS_IDPERSON_IDEMAIL_TYPEEMAIL_ADDRESSDATE_FROM

PER_ALL_PEOPLE_F

Person records — one date-effective row set per person, holding person number and identifiers.

Global HR