DBA Data[Home] [Help] [Dependency Information]


TABLE: HR.BEN_BENEFIT_CONTRIBUTIONS_F

Object Details
Object Name: BEN_BENEFIT_CONTRIBUTIONS_F
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.BEN_BENEFIT_CONTRIBUTIONS_F
Subobject Name:
Status: VALID


BEN_BENEFIT_CONTRIBUTIONS_F is a DateTracked table that holds the
default contributions associated with cover by a specific benefit.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_BENEFIT_CONTRIBUTIONS_PK
  1. ColumnBENEFIT_CONTRIBUTION_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Unique Key: BEN_BENEFIT_CONTRIBUTIONS_UK2
  1. ColumnCOVERAGE_TYPE
  2. ColumnELEMENT_TYPE_ID
  3. ColumnEFFECTIVE_START_DATE
  4. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
BEN_BENEFIT_CONTRIBUTIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBENEFIT_CONTRIBUTION_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
BEN_BENEFIT_CONTRIBUTIONS_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOVERAGE_TYPE
ColumnELEMENT_TYPE_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
BEN_BENEFIT_CONTRIBUTIONS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
BEN_BENEFIT_CONTRIBUTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnELEMENT_TYPE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
BEN_BENEFIT_CONTRIBUTIONS_F BEN_BENEFIT_CONTRIBUTIONS_FK1 TableHR_ALL_ORGANIZATION_UNITS BEN_BENEFIT_CONTRIBUTIONS_F BUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
BENEFIT_CONTRIBUTION_ID NUMBER (15) Yes Unique identifier for the benefit contribution.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ALL_ORGANIZATION_UNITS.
FORMULA_ID NUMBER (9)
Foreign key to PAY_FORMULAS.
ELEMENT_TYPE_ID NUMBER (9) Yes Foreign key to PAY_ELEMENT_TYPES.
COVERAGE_TYPE VARCHAR2 (30) Yes Type of coverage, eg employee only, employee and spouse.
EMPLOYEE_CONTRIBUTION VARCHAR2 (60) Yes Default cost to employee for enrollment at a specific level of coverage.
EMPLOYER_CONTRIBUTION VARCHAR2 (60) Yes Default cost to employer for employee enrollment at a specific level of coverage.
MAXIMUM_EMPLOYEE_CONTRIBUTION VARCHAR2 (60)
Maximum cost to employee for enrollment at a specific level.
MAXIMUM_EMPLOYER_CONTRIBUTION VARCHAR2 (60)
Maximum cost to employer for employee enrollment at a specific level.
MINIMUM_EMPLOYEE_CONTRIBUTION VARCHAR2 (60)
Minimum cost to employee for enrollment.
MINIMUM_EMPLOYER_CONTRIBUTION VARCHAR2 (60)
Minimum cost to employer for enrollment.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BENEFIT_CONTRIBUTION_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      FORMULA_ID
,      ELEMENT_TYPE_ID
,      COVERAGE_TYPE
,      EMPLOYEE_CONTRIBUTION
,      EMPLOYER_CONTRIBUTION
,      MAXIMUM_EMPLOYEE_CONTRIBUTION
,      MAXIMUM_EMPLOYER_CONTRIBUTION
,      MINIMUM_EMPLOYEE_CONTRIBUTION
,      MINIMUM_EMPLOYER_CONTRIBUTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.BEN_BENEFIT_CONTRIBUTIONS_F;

Dependencies

[top of page]

HR.BEN_BENEFIT_CONTRIBUTIONS_F does not reference any database object

HR.BEN_BENEFIT_CONTRIBUTIONS_F is referenced by following:

SchemaHR
ViewBEN_BENEFIT_CONTRIBUTIONS_F#