eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	PER.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Unique Key: BEN_BENEFIT_CLASSIFICATION_UK2

BENEFIT_CLASSIFICATION_NAME
BUSINESS_GROUP_ID
LEGISLATION_CODE
ZD_EDITION_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_BENEFIT_CLASSIFICATION_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BENEFIT_CLASSIFICATION_ID ZD_EDITION_NAME
BEN_BENEFIT_CLASSIFICATION_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	BENEFIT_CLASSIFICATION_NAME BUSINESS_GROUP_ID LEGISLATION_CODE ZD_EDITION_NAME
SYS_IL0000043361C00020$$	LOB	UNIQUE	APPS_TS_TX_DATA

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	CLOB	(4000)		General remark.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

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
,      ZD_EDITION_NAME
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:

HR: BEN_BENEFIT_CLASSIFICATIONS#