FND Design Data [Home] [Help]

Table: PER_COBRA_DEPENDENTS_F

Product: PER - Human Resources
Description: Holds employee dependents coverage for a COBRA qualifying event.
Implementation/DBA Data: TableHR.PER_COBRA_DEPENDENTS_F
Primary Key: PER_COBRA_DEPENDENTS_PK
  1. ColumnCOBRA_DEPENDENT_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Primary Key: PER_COBRA_DEPENDENTS_UK
  1. ColumnCOBRA_COVERAGE_ENROLLMENT_ID
  2. ColumnCONTACT_RELATIONSHIP_ID
  3. ColumnEFFECTIVE_START_DATE
  4. ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_COBRA_DEPENDENTS_F FK Joins to TablePER_COBRA_COV_ENROLLMENTS PER_COBRA_DEPENDENTS_F.COBRA_COVERAGE_ENROLLMENT_ID
PER_COBRA_DEPENDENTS_F FK Joins to TablePER_CONTACT_RELATIONSHIPS PER_COBRA_DEPENDENTS_F.CONTACT_RELATIONSHIP_ID