FND Design Data [Home] [Help]

Table: BEN_COVERED_DEPENDENTS_F

Product: PER - Human Resources
Description: Dependents covered by specific benefit plans.
Implementation/DBA Data: TableHR.BEN_COVERED_DEPENDENTS_F
Primary Key: BEN_COVERED_DEPENDENTS_F_PK
  1. ColumnCOVERED_DEPENDENT_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Primary Key: BEN_COVERED_DEPENDENTS_F_UK2
  1. ColumnCONTACT_RELATIONSHIP_ID
  2. ColumnELEMENT_ENTRY_ID
  3. ColumnEFFECTIVE_START_DATE
  4. ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
BEN_COVERED_DEPENDENTS_F FK Joins to TablePER_CONTACT_RELATIONSHIPS BEN_COVERED_DEPENDENTS_F.CONTACT_RELATIONSHIP_ID