FND Design Data [Home] [Help]

Table: PER_CONTACT_RELATIONSHIPS

Product: PER - Human Resources
Description: Contacts and relationship details for dependents, beneficiaries, emergency contacts, parents etc.
Implementation/DBA Data: TableHR.PER_CONTACT_RELATIONSHIPS
Primary Key: PER_CONTACT_RELATIONSHIPS_PK
  1. ColumnCONTACT_RELATIONSHIP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_CONTACT_RELATIONSHIPS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_CONTACT_RELATIONSHIPS.BUSINESS_GROUP_ID
TableBEN_COVERED_DEPENDENTS_F FK Joins to PER_CONTACT_RELATIONSHIPS BEN_COVERED_DEPENDENTS_F.CONTACT_RELATIONSHIP_ID
TablePER_COBRA_COV_ENROLLMENTS FK Joins to PER_CONTACT_RELATIONSHIPS PER_COBRA_COV_ENROLLMENTS.CONTACT_RELATIONSHIP_ID
TablePER_COBRA_DEPENDENTS_F FK Joins to PER_CONTACT_RELATIONSHIPS PER_COBRA_DEPENDENTS_F.CONTACT_RELATIONSHIP_ID
TablePER_CONTACT_EXTRA_INFO_F FK Joins to PER_CONTACT_RELATIONSHIPS PER_CONTACT_EXTRA_INFO_F.CONTACT_RELATIONSHIP_ID