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_PERSON_RATES

Object Details

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

Stores the various rates like eligible salary, target amount, worksheet amount etc. for all eligible workers for a CWB Plan. Rate details are held at local plan/option level.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BEN_CWB_PERSON_RATES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_RATE_ID
BEN_CWB_PERSON_RATES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_PER_IN_LER_ID PL_ID OIPL_ID
BEN_CWB_PERSON_RATES_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_PL_ID GROUP_OIPL_ID
BEN_CWB_PERSON_RATES_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID
BEN_CWB_PERSON_RATES_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID
BEN_CWB_PERSON_RATES_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PL_ID LF_EVT_OCRD_DT GROUP_PL_ID GROUP_OIPL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_RATE_ID	NUMBER	(15)	Yes	Person Rate Primary Key
GROUP_PER_IN_LER_ID	NUMBER	(15)	Yes	Group Person Life Event
PL_ID	NUMBER	(15)	Yes	Plan
OIPL_ID	NUMBER	(15)		Option
GROUP_PL_ID	NUMBER	(15)	Yes	Group Plan
GROUP_OIPL_ID	NUMBER	(15)		Group Option
LF_EVT_OCRD_DT	DATE		Yes	Life Event Occured on Date
PERSON_ID	NUMBER	(15)		Person
ASSIGNMENT_ID	NUMBER	(15)		Assignment
ELIG_FLAG	VARCHAR2	(30)		Eligible
WS_VAL	NUMBER			Worksheet Value
WS_MN_VAL	NUMBER			Worksheet Min Value
WS_MX_VAL	NUMBER			Worksheet Max Value
WS_INCR_VAL	NUMBER			Worksheet Incr Value
ELIG_SAL_VAL	NUMBER			Eligible Salary
STAT_SAL_VAL	NUMBER			Stated Salary
OTH_COMP_VAL	NUMBER			Other Compensation
TOT_COMP_VAL	NUMBER			Total Compensation
MISC1_VAL	NUMBER			Miscellaneous 1 Value
MISC2_VAL	NUMBER			Miscellaneous 2 Value
MISC3_VAL	NUMBER			Miscellaneous 3 Value
REC_VAL	NUMBER			Recommended Value
REC_MN_VAL	NUMBER			Recommended Min Value
REC_MX_VAL	NUMBER			Recommended Max Value
REC_INCR_VAL	NUMBER			Recommended Incr Value
WS_VAL_LAST_UPD_DATE	DATE			Worksheet Update Date
WS_VAL_LAST_UPD_BY	NUMBER	(15)		Worksheet Updated by Person
PAY_PROPOSAL_ID	NUMBER	(15)		Pay Proposal
ELEMENT_ENTRY_VALUE_ID	NUMBER	(15)		Element Entry Value
INELIG_RSN_CD	VARCHAR2	(30)		Ineligible Reason
ELIG_OVRID_DT	DATE			Eligibility Override Date
ELIG_OVRID_PERSON_ID	NUMBER	(15)		Eligibility Override by Person
COPY_DIST_BDGT_VAL	NUMBER			Distribution Budget Value
COPY_WS_BDGT_VAL	NUMBER			Worksheet Budget Value
COPY_RSRV_VAL	NUMBER			Reserve Budget Value
COPY_DIST_BDGT_MN_VAL	NUMBER			Distribution Budget Min Value
COPY_DIST_BDGT_MX_VAL	NUMBER			Distribution Budget Max Value
COPY_DIST_BDGT_INCR_VAL	NUMBER			Distribution Budget Incr Value
COPY_WS_BDGT_MN_VAL	NUMBER			Worksheet Budget Min Value
COPY_WS_BDGT_MX_VAL	NUMBER			Worksheet Budget Max Value
COPY_WS_BDGT_INCR_VAL	NUMBER			Worksheet Budget Incr Value
COPY_RSRV_MN_VAL	NUMBER			Reserve Budget Min Value
COPY_RSRV_MX_VAL	NUMBER			Reserve Budget Max Value
COPY_RSRV_INCR_VAL	NUMBER			Reserve Budget Incr Value
COPY_DIST_BDGT_ISS_VAL	NUMBER			Distribution Budget Issued Value
COPY_WS_BDGT_ISS_VAL	NUMBER			Worksheet Budget Issued Value
COPY_DIST_BDGT_ISS_DATE	DATE			Distribution Budget Issued Date
COPY_WS_BDGT_ISS_DATE	DATE			Worksheet Budget Issued Date
COMP_POSTING_DATE	DATE			Comp Posting Date
WS_RT_START_DATE	DATE			Worksheet Rate Start Date
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object version 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
CURRENCY	VARCHAR2	(30)		Currency

Query Text

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


SELECT PERSON_RATE_ID
,      GROUP_PER_IN_LER_ID
,      PL_ID
,      OIPL_ID
,      GROUP_PL_ID
,      GROUP_OIPL_ID
,      LF_EVT_OCRD_DT
,      PERSON_ID
,      ASSIGNMENT_ID
,      ELIG_FLAG
,      WS_VAL
,      WS_MN_VAL
,      WS_MX_VAL
,      WS_INCR_VAL
,      ELIG_SAL_VAL
,      STAT_SAL_VAL
,      OTH_COMP_VAL
,      TOT_COMP_VAL
,      MISC1_VAL
,      MISC2_VAL
,      MISC3_VAL
,      REC_VAL
,      REC_MN_VAL
,      REC_MX_VAL
,      REC_INCR_VAL
,      WS_VAL_LAST_UPD_DATE
,      WS_VAL_LAST_UPD_BY
,      PAY_PROPOSAL_ID
,      ELEMENT_ENTRY_VALUE_ID
,      INELIG_RSN_CD
,      ELIG_OVRID_DT
,      ELIG_OVRID_PERSON_ID
,      COPY_DIST_BDGT_VAL
,      COPY_WS_BDGT_VAL
,      COPY_RSRV_VAL
,      COPY_DIST_BDGT_MN_VAL
,      COPY_DIST_BDGT_MX_VAL
,      COPY_DIST_BDGT_INCR_VAL
,      COPY_WS_BDGT_MN_VAL
,      COPY_WS_BDGT_MX_VAL
,      COPY_WS_BDGT_INCR_VAL
,      COPY_RSRV_MN_VAL
,      COPY_RSRV_MX_VAL
,      COPY_RSRV_INCR_VAL
,      COPY_DIST_BDGT_ISS_VAL
,      COPY_WS_BDGT_ISS_VAL
,      COPY_DIST_BDGT_ISS_DATE
,      COPY_WS_BDGT_ISS_DATE
,      COMP_POSTING_DATE
,      WS_RT_START_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      CURRENCY
FROM BEN.BEN_CWB_PERSON_RATES;

Dependencies

[top of page]

BEN.BEN_CWB_PERSON_RATES does not reference any database object

BEN.BEN_CWB_PERSON_RATES is referenced by following:

APPS: BEN_CWB_PERSON_RATES; BEN_CWB_PERSON_RATES_WHO