FND Design Data [Home] [Help]

Table: PER_COBRA_COVERAGE_BENEFITS_F

Product: PER - Human Resources
Description: Details of a benefit that the employee accepts or rejects as part of their COBRA coverage.
Implementation/DBA Data: TableHR.PER_COBRA_COVERAGE_BENEFITS_F
Primary Key: PER_COBRA_COVERAGE_BENEFIT_PK
  1. ColumnCOBRA_COVERAGE_BENEFIT_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Primary Key: PER_COBRA_COVERAGE_BENEFIT_UK2
  1. ColumnCOBRA_COVERAGE_ENROLLMENT_ID
  2. ColumnELEMENT_TYPE_ID
  3. ColumnEFFECTIVE_START_DATE
  4. ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_COBRA_COVERAGE_BENEFITS_F FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_COBRA_COVERAGE_BENEFITS_F.BUSINESS_GROUP_ID
PER_COBRA_COVERAGE_BENEFITS_F FK Joins to TablePER_COBRA_COV_ENROLLMENTS PER_COBRA_COVERAGE_BENEFITS_F.COBRA_COVERAGE_ENROLLMENT_ID