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

TABLE: HR.BEN_BENEFIT_CLASSIFICATIONS

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


BEN_BENEFIT_CLASSIFICATIONS holds the list of benefit classifications
that can be associated with specific elements, eg pension, health,
life insurance, flex plan etc. The values in this table are
predefined and currently cannot updated by the user.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_BENEFIT_CLASSIFICATION_PK
  1. ColumnBENEFIT_CLASSIFICATION_ID
Unique Key: BEN_BENEFIT_CLASSIFICATION_UK2
  1. ColumnBENEFIT_CLASSIFICATION_NAME
  2. ColumnBUSINESS_GROUP_ID
  3. ColumnLEGISLATION_CODE
Indexes
Index Type Uniqueness Tablespace Column
BEN_BENEFIT_CLASSIFICATION_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBENEFIT_CLASSIFICATION_ID
BEN_BENEFIT_CLASSIFICATION_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBENEFIT_CLASSIFICATION_NAME
ColumnBUSINESS_GROUP_ID
ColumnLEGISLATION_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
TablePAY_ELEMENT_TYPES_F PAY_ELEMENT_TYPES_F_FK2 BEN_BENEFIT_CLASSIFICATIONS PAY_ELEMENT_TYPES_F BENEFIT_CLASSIFICATION_ID
Columns
Name Datatype Length Mandatory Comments
BENEFIT_CLASSIFICATION_ID NUMBER (15) Yes Unique identifier for the benefit classification.
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS.
LEGISLATION_CODE VARCHAR2 (30)
Legislation where the classification applies.
ACTIVE_FLAG VARCHAR2 (30) Yes Indicates whether benefits of this classification can be created.
BENEFICIARY_ALLOWED_FLAG VARCHAR2 (30) Yes Indicates whether the benefit can be paid to beneficiaries, eg life insurance plans.
BENEFIT_CLASSIFICATION_NAME VARCHAR2 (80) Yes Name of the benefit classification.
BENEFIT_CLASSIFICATION_TYPE VARCHAR2 (30) Yes Indicates whether the row is a (BEN)efit or (FLEX) plan.
CHARGEABLE_FLAG VARCHAR2 (30) Yes Indicates whether the user can set-up charges for benefits of this classification.
COBRA_FLAG VARCHAR2 (30) Yes Indicates whether benefits of this class are subject to COBRA.
CONTRIBUTIONS_USED VARCHAR2 (30) Yes Indicates whether the classification uses Benefit Contributions.
DEPENDENTS_ALLOWED_FLAG VARCHAR2 (30) Yes Indicates whether the benefit can cover employee dependents.
DFLT_POST_TERMINATION_RULE VARCHAR2 (30) Yes Used to derive post termination rule for benefit plans (including flex).
DFLT_PROCESSING_TYPE VARCHAR2 (30) Yes Used to derive processing type for benefit plans (including flex).
BEN_CLASS_PROCESSING_RULE VARCHAR2 (30)
Describes the processing that can act on benefits in this class.
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.
COMMENTS LONG (0)
General remark.
Query Text

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


SELECT BENEFIT_CLASSIFICATION_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      ACTIVE_FLAG
,      BENEFICIARY_ALLOWED_FLAG
,      BENEFIT_CLASSIFICATION_NAME
,      BENEFIT_CLASSIFICATION_TYPE
,      CHARGEABLE_FLAG
,      COBRA_FLAG
,      CONTRIBUTIONS_USED
,      DEPENDENTS_ALLOWED_FLAG
,      DFLT_POST_TERMINATION_RULE
,      DFLT_PROCESSING_TYPE
,      BEN_CLASS_PROCESSING_RULE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      COMMENTS
FROM HR.BEN_BENEFIT_CLASSIFICATIONS;

Dependencies

[top of page]

HR.BEN_BENEFIT_CLASSIFICATIONS does not reference any database object

HR.BEN_BENEFIT_CLASSIFICATIONS is referenced by following:

SchemaAPPS
SynonymBEN_BENEFIT_CLASSIFICATIONS
TriggerBEN_BENEFIT_CLASSIFICATION_WHO
SchemaPUBLIC
SynonymBEN_BENEFIT_CLASSIFICATIONS