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: BEN.BEN_CWB_MGR_HRCHY_RBV

Object Details

Object Name:	BEN_CWB_MGR_HRCHY_RBV
Object Type:	TABLE
Owner:	BEN
FND Design Data:	BEN.BEN_CWB_MGR_HRCHY_RBV
Subobject Name:
Status:	VALID

Obsolete in R12. Not used.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_CWB_MGR_HRCHY_RBV_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BENEFIT_ACTION_ID MGR_ELIG_PER_ELCTBL_CHC_ID EMP_ELIG_PER_ELCTBL_CHC_ID
BEN_CWB_MGR_HRCHY_RBV_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MGR_ELIG_PER_ELCTBL_CHC_ID	NUMBER	(15)	Yes	Refers to MGR_ELIG_PER_ELCTBL_CHC_ID in BEN_CWB_MGR_HRCHY
EMP_ELIG_PER_ELCTBL_CHC_ID	NUMBER	(15)	Yes	Refers to EMP_ELIG_PER_ELCTBL_CHC_ID in BEN_CWB_MGR_HRCHY
LVL_NUM	NUMBER	(15)	Yes	Level Number
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
OBJECT_VERSION_NUMBER	NUMBER	(9)		Change Indicator Column
BENEFIT_ACTION_ID	NUMBER	(15)	Yes	Foreign key to BEN_BENEFIT_ACTIONS
PERSON_ACTION_ID	NUMBER	(15)		Foreign key to BEN_PERSON_ACTIONS

Query Text

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


SELECT MGR_ELIG_PER_ELCTBL_CHC_ID
,      EMP_ELIG_PER_ELCTBL_CHC_ID
,      LVL_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      BENEFIT_ACTION_ID
,      PERSON_ACTION_ID
FROM BEN.BEN_CWB_MGR_HRCHY_RBV;

Dependencies

[top of page]

BEN.BEN_CWB_MGR_HRCHY_RBV does not reference any database object

BEN.BEN_CWB_MGR_HRCHY_RBV is referenced by following:

BEN: BEN_CWB_MGR_HRCHY_RBV#