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_SUMMARY

Object Details

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

Stores the summarized information for budgets, allocations and reserved amounts. The totals are held at the directs and all levels for every manager.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_CWB_SUMMARY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUMMARY_ID
BEN_CWB_SUMMARY_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_PER_IN_LER_ID GROUP_PL_ID GROUP_OIPL_ID
BEN_CWB_SUMMARY_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SUMMARY_ID	NUMBER	(15)	Yes	Summary Primary Key
GROUP_PER_IN_LER_ID	NUMBER	(15)	Yes	Group Person Life Event
GROUP_PL_ID	NUMBER	(15)	Yes	Group Plan
GROUP_OIPL_ID	NUMBER	(15)		Group Option
PERSON_ID	NUMBER	(15)		Person
LF_EVT_OCRD_DT	DATE			Life Event Occured on Date
STATUS	VARCHAR2	(30)		Summary Row Status
ELIG_COUNT_DIRECT	NUMBER	(15)		Directs Eligible
ELIG_COUNT_ALL	NUMBER	(15)		Alls Eligible
EMP_RECV_COUNT_DIRECT	NUMBER	(15)		Directs Receiving
EMP_RECV_COUNT_ALL	NUMBER	(15)		Alls Receiving
ELIG_SAL_VAL_DIRECT	NUMBER			Directs Eligible Salary
ELIG_SAL_VAL_ALL	NUMBER			Alls Eligible Salary
WS_VAL_DIRECT	NUMBER			Directs Worksheet Value
WS_VAL_ALL	NUMBER			Alls Worksheet Value
WS_BDGT_VAL_DIRECT	NUMBER			Directs Worksheet Budget Value
WS_BDGT_VAL_ALL	NUMBER			Alls Worksheet Budget Value
WS_BDGT_ISS_VAL_DIRECT	NUMBER			Directs Worksheet Budget Issued Value
WS_BDGT_ISS_VAL_ALL	NUMBER			Alls Worksheet Budget Issued Value
BDGT_VAL_DIRECT	NUMBER			Directs Budget Value
BDGT_ISS_VAL_DIRECT	NUMBER			Directs Budget Issued Value
STAT_SAL_VAL_DIRECT	NUMBER			Directs Stated Salary
STAT_SAL_VAL_ALL	NUMBER			Alls Stated Salary
OTH_COMP_VAL_DIRECT	NUMBER			Directs Other Compensation
OTH_COMP_VAL_ALL	NUMBER			Alls Other Compensation
TOT_COMP_VAL_DIRECT	NUMBER			Directs Total Compensation
TOT_COMP_VAL_ALL	NUMBER			Alls Total Compensation
REC_VAL_DIRECT	NUMBER			Directs Recommended Value
REC_VAL_ALL	NUMBER			Alls Recommended Value
REC_MN_VAL_DIRECT	NUMBER			Directs Recommended Min Value
REC_MN_VAL_ALL	NUMBER			Alls Recommended Min Value
REC_MX_VAL_DIRECT	NUMBER			Directs Recommended Max Value
REC_MX_VAL_ALL	NUMBER			Alls Recommended Max Value
MISC1_VAL_DIRECT	NUMBER			Directs Miscellaneous 1 Value
MISC1_VAL_ALL	NUMBER			Alls Miscellaneous 1 Value
MISC2_VAL_DIRECT	NUMBER			Directs Miscellaneous 2 Value
MISC2_VAL_ALL	NUMBER			Alls Miscellaneous 2 Value
MISC3_VAL_DIRECT	NUMBER			Directs Miscellaneous 3 Value
MISC3_VAL_ALL	NUMBER			Alls Miscellaneous 3 Value
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 SUMMARY_ID
,      GROUP_PER_IN_LER_ID
,      GROUP_PL_ID
,      GROUP_OIPL_ID
,      PERSON_ID
,      LF_EVT_OCRD_DT
,      STATUS
,      ELIG_COUNT_DIRECT
,      ELIG_COUNT_ALL
,      EMP_RECV_COUNT_DIRECT
,      EMP_RECV_COUNT_ALL
,      ELIG_SAL_VAL_DIRECT
,      ELIG_SAL_VAL_ALL
,      WS_VAL_DIRECT
,      WS_VAL_ALL
,      WS_BDGT_VAL_DIRECT
,      WS_BDGT_VAL_ALL
,      WS_BDGT_ISS_VAL_DIRECT
,      WS_BDGT_ISS_VAL_ALL
,      BDGT_VAL_DIRECT
,      BDGT_ISS_VAL_DIRECT
,      STAT_SAL_VAL_DIRECT
,      STAT_SAL_VAL_ALL
,      OTH_COMP_VAL_DIRECT
,      OTH_COMP_VAL_ALL
,      TOT_COMP_VAL_DIRECT
,      TOT_COMP_VAL_ALL
,      REC_VAL_DIRECT
,      REC_VAL_ALL
,      REC_MN_VAL_DIRECT
,      REC_MN_VAL_ALL
,      REC_MX_VAL_DIRECT
,      REC_MX_VAL_ALL
,      MISC1_VAL_DIRECT
,      MISC1_VAL_ALL
,      MISC2_VAL_DIRECT
,      MISC2_VAL_ALL
,      MISC3_VAL_DIRECT
,      MISC3_VAL_ALL
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM BEN.BEN_CWB_SUMMARY;

Dependencies

[top of page]

BEN.BEN_CWB_SUMMARY does not reference any database object

BEN.BEN_CWB_SUMMARY is referenced by following:

APPS: BEN_CWB_SUMMARY; BEN_CWB_SUMMARY_WHO