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]

VIEW: BEN.BEN_CWB_COMP_DETAILS#

Object Details

Object Name:	BEN_CWB_COMP_DETAILS#
Object Type:	VIEW
Owner:	BEN
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
GROUP_PER_IN_LER_ID	NUMBER	(15)	Yes
GROUP_PL_ID	NUMBER	(15)	Yes
LF_EVT_OCRD_DT	DATE		Yes
PERSON_ID	NUMBER	(15)	Yes
PLOIPLID	NUMBER	(15)
OIP1PLID	NUMBER	(15)
OIP2PLID	NUMBER	(15)
OIP3PLID	NUMBER	(15)
OIP4PLID	NUMBER	(15)
OIPL1ID	NUMBER	(15)
OIPL2ID	NUMBER	(15)
OIPL3ID	NUMBER	(15)
OIPL4ID	NUMBER	(15)
OPT1OIPLORDRNUM	NUMBER	(15)
OPT2OIPLORDRNUM	NUMBER	(15)
OPT3OIPLORDRNUM	NUMBER	(15)
OPT4OIPLORDRNUM	NUMBER	(15)
OIP1GRPOIPLID	NUMBER	(15)
OIP2GRPOIPLID	NUMBER	(15)
OIP3GRPOIPLID	NUMBER	(15)
OIP4GRPOIPLID	NUMBER	(15)
ELIG_FLAG	VARCHAR2	(30)
OPT1_ELIG_FLAG	VARCHAR2	(30)
OPT2_ELIG_FLAG	VARCHAR2	(30)
OPT3_ELIG_FLAG	VARCHAR2	(30)
OPT4_ELIG_FLAG	VARCHAR2	(30)
PLANUFACTOR	NUMBER
GRPUFACTOR	NUMBER
PER_IN_LER_STAT_CD	VARCHAR2	(30)
PROCD_DT	DATE
BG_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
LOC_ID	NUMBER	(15)
GRADE_RANGE	VARCHAR2	(100)
GRADE_MID_POINT	NUMBER
PRIOR_FTE_SALARY	NUMBER
NEW_FTE_SALARY	NUMBER
NEW_QUARTILE	VARCHAR2	(40)
NEW_QUINTILE	VARCHAR2	(40)
NEW_DECILE	VARCHAR2	(40)
NEW_PERCENTILE	NUMBER
NEW_COMPARATIO	NUMBER
PROPOSED_PERFORMANCE_RATING	VARCHAR2	(240)
JOB_ID	NUMBER	(15)
JOB_FLEX1	VARCHAR2	(150)
JOB_FLEX2	VARCHAR2	(150)
JOB_FLEX3	VARCHAR2	(150)
JOB_FLEX4	VARCHAR2	(150)
JOB_FLEX5	VARCHAR2	(150)
PROPOSED_JOB_ID	NUMBER	(15)
POSITION_ID	NUMBER	(15)
PROPOSED_POSITION_ID	NUMBER	(15)
GRADE_ID	NUMBER	(15)
PROPOSED_GRADE_ID	NUMBER	(15)
PEOPLE_GROUP	VARCHAR2	(240)
PROPOSED_GROUP	VARCHAR2	(240)
ASSIGNMENT_STATUS_ID	NUMBER	(15)
CORP_BASE_SALARY	NUMBER
PL_NAME	VARCHAR2	(240)
OPT1_NAME	VARCHAR2	(240)
OPT2_NAME	VARCHAR2	(240)
OPT3_NAME	VARCHAR2	(240)
OPT4_NAME	VARCHAR2	(240)
PL_UOM	VARCHAR2	(80)
OPT1_UOM	VARCHAR2	(80)
OPT2_UOM	VARCHAR2	(80)
OPT3_UOM	VARCHAR2	(80)
OPT4_UOM	VARCHAR2	(80)
PL_CURRENCY	VARCHAR2	(30)
OPT1_CURRENCY	VARCHAR2	(30)
OPT2_CURRENCY	VARCHAR2	(30)
OPT3_CURRENCY	VARCHAR2	(30)
OPT4_CURRENCY	VARCHAR2	(30)
PL_ELIG_SAL_VAL	NUMBER
PL_WS_VAL	NUMBER
PL_PCT_OF_ELIG_SAL	NUMBER
PL_WS_MIN_VAL	NUMBER
PL_WS_MAX_VAL	NUMBER
PL_WS_INCR_VAL	NUMBER
PL_NEW_SALARY	NUMBER
PL_WS_VAL_LIMIT	VARCHAR2	(100)
PL_REC_VAL	NUMBER
PL_REC_MN_VAL	NUMBER
PL_REC_MX_VAL	NUMBER
PL_REC_VAL_LIMIT	VARCHAR2	(100)
PL_REC_VAL_PCT	NUMBER
PL_REC_VAL_PCT_LIMIT	VARCHAR2	(100)
PL_MISC1_VAL	NUMBER
PL_MISC2_VAL	NUMBER
PL_MISC3_VAL	NUMBER
PL_STAT_SAL_VAL	NUMBER
PL_TOT_COMP_VAL	NUMBER
PL_OTH_COMP_VAL	NUMBER
PL_XCHG_RATE	NUMBER
PL_CORP_ELIG_SAL_VAL	NUMBER
PL_CORP_WS_VAL	NUMBER
PL_CORP_NEW_SALARY	NUMBER
PL_SALARY_COMP	VARCHAR2	(80)
OPT1_ELIG_SAL_VAL	NUMBER
OPT1_WS_VAL	NUMBER
OPT1_PCT_OF_ELIG_SAL	NUMBER
OPT1_WS_MIN_VAL	NUMBER
OPT1_WS_MAX_VAL	NUMBER
OPT1_WS_INCR_VAL	NUMBER
OPT1_NEW_SALARY	NUMBER
OPT1_WS_VAL_LIMIT	VARCHAR2	(100)
OPT1_REC_VAL	NUMBER
OPT1_REC_MN_VAL	NUMBER
OPT1_REC_MX_VAL	NUMBER
OPT1_REC_VAL_LIMIT	VARCHAR2	(100)
OPT1_REC_VAL_PCT	NUMBER
OPT1_REC_VAL_PCT_LIMIT	VARCHAR2	(100)
OPT1_MISC1_VAL	NUMBER
OPT1_MISC2_VAL	NUMBER
OPT1_MISC3_VAL	NUMBER
OPT1_STAT_SAL_VAL	NUMBER
OPT1_TOT_COMP_VAL	NUMBER
OPT1_OTH_COMP_VAL	NUMBER
OPT1_XCHG_RATE	NUMBER
OPT1_CORP_ELIG_SAL_VAL	NUMBER
OPT1_CORP_WS_VAL	NUMBER
OPT1_CORP_NEW_SALARY	NUMBER
OPT1_SALARY_COMP	VARCHAR2	(30)
OPT2_ELIG_SAL_VAL	NUMBER
OPT2_WS_VAL	NUMBER
OPT2_PCT_OF_ELIG_SAL	NUMBER
OPT2_WS_MIN_VAL	NUMBER
OPT2_WS_MAX_VAL	NUMBER
OPT2_WS_INCR_VAL	NUMBER
OPT2_NEW_SALARY	NUMBER
OPT2_WS_VAL_LIMIT	VARCHAR2	(100)
OPT2_REC_VAL	NUMBER
OPT2_REC_MN_VAL	NUMBER
OPT2_REC_MX_VAL	NUMBER
OPT2_REC_VAL_LIMIT	VARCHAR2	(100)
OPT2_REC_VAL_PCT	NUMBER
OPT2_REC_VAL_PCT_LIMIT	VARCHAR2	(100)
OPT2_MISC1_VAL	NUMBER
OPT2_MISC2_VAL	NUMBER
OPT2_MISC3_VAL	NUMBER
OPT2_STAT_SAL_VAL	NUMBER
OPT2_TOT_COMP_VAL	NUMBER
OPT2_OTH_COMP_VAL	NUMBER
OPT2_XCHG_RATE	NUMBER
OPT2_CORP_ELIG_SAL_VAL	NUMBER
OPT2_CORP_WS_VAL	NUMBER
OPT2_CORP_NEW_SALARY	NUMBER
OPT2_SALARY_COMP	VARCHAR2	(30)
OPT3_ELIG_SAL_VAL	NUMBER
OPT3_WS_VAL	NUMBER
OPT3_PCT_OF_ELIG_SAL	NUMBER
OPT3_WS_MIN_VAL	NUMBER
OPT3_WS_MAX_VAL	NUMBER
OPT3_WS_INCR_VAL	NUMBER
OPT3_NEW_SALARY	NUMBER
OPT3_WS_VAL_LIMIT	VARCHAR2	(100)
OPT3_REC_VAL	NUMBER
OPT3_REC_MN_VAL	NUMBER
OPT3_REC_MX_VAL	NUMBER
OPT3_REC_VAL_LIMIT	VARCHAR2	(100)
OPT3_REC_VAL_PCT	NUMBER
OPT3_REC_VAL_PCT_LIMIT	VARCHAR2	(100)
OPT3_MISC1_VAL	NUMBER
OPT3_MISC2_VAL	NUMBER
OPT3_MISC3_VAL	NUMBER
OPT3_STAT_SAL_VAL	NUMBER
OPT3_TOT_COMP_VAL	NUMBER
OPT3_OTH_COMP_VAL	NUMBER
OPT3_XCHG_RATE	NUMBER
OPT3_CORP_ELIG_SAL_VAL	NUMBER
OPT3_CORP_WS_VAL	NUMBER
OPT3_CORP_NEW_SALARY	NUMBER
OPT3_SALARY_COMP	VARCHAR2	(30)
OPT4_ELIG_SAL_VAL	NUMBER
OPT4_WS_VAL	NUMBER
OPT4_PCT_OF_ELIG_SAL	NUMBER
OPT4_WS_MIN_VAL	NUMBER
OPT4_WS_MAX_VAL	NUMBER
OPT4_WS_INCR_VAL	NUMBER
OPT4_NEW_SALARY	NUMBER
OPT4_WS_VAL_LIMIT	VARCHAR2	(100)
OPT4_REC_VAL	NUMBER
OPT4_REC_MN_VAL	NUMBER
OPT4_REC_MX_VAL	NUMBER
OPT4_REC_VAL_LIMIT	VARCHAR2	(100)
OPT4_REC_VAL_PCT	NUMBER
OPT4_REC_VAL_PCT_LIMIT	VARCHAR2	(100)
OPT4_MISC1_VAL	NUMBER
OPT4_MISC2_VAL	NUMBER
OPT4_MISC3_VAL	NUMBER
OPT4_STAT_SAL_VAL	NUMBER
OPT4_TOT_COMP_VAL	NUMBER
OPT4_OTH_COMP_VAL	NUMBER
OPT4_XCHG_RATE	NUMBER
OPT4_CORP_ELIG_SAL_VAL	NUMBER
OPT4_CORP_WS_VAL	NUMBER
OPT4_CORP_NEW_SALARY	NUMBER
OPT4_SALARY_COMP	VARCHAR2	(30)
CHANGE_REASON	VARCHAR2	(240)
LEVEL1MGR	VARCHAR2	(240)
LEVEL2MGR	VARCHAR2	(240)
LEVEL3MGR	VARCHAR2	(240)
LEVEL4MGR	VARCHAR2	(240)
LEVEL5MGR	VARCHAR2	(240)
LEVEL6MGR	VARCHAR2	(240)
LEVEL7MGR	VARCHAR2	(240)
LEVEL8MGR	VARCHAR2	(240)
SAL_STAT_CURRENCY	VARCHAR2	(30)
WRK_MGR_NAME	VARCHAR2	(480)
CORP_CURRENCY	VARCHAR2	(30)
CONC_REQUEST_ID	NUMBER	(15)
START_DATE	DATE
END_DATE	DATE

Query Text

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


SELECT GROUP_PER_IN_LER_ID
,      GROUP_PL_ID
,      LF_EVT_OCRD_DT
,      PERSON_ID
,      PLOIPLID
,      OIP1PLID
,      OIP2PLID
,      OIP3PLID
,      OIP4PLID
,      OIPL1ID
,      OIPL2ID
,      OIPL3ID
,      OIPL4ID
,      OPT1OIPLORDRNUM
,      OPT2OIPLORDRNUM
,      OPT3OIPLORDRNUM
,      OPT4OIPLORDRNUM
,      OIP1GRPOIPLID
,      OIP2GRPOIPLID
,      OIP3GRPOIPLID
,      OIP4GRPOIPLID
,      ELIG_FLAG
,      OPT1_ELIG_FLAG
,      OPT2_ELIG_FLAG
,      OPT3_ELIG_FLAG
,      OPT4_ELIG_FLAG
,      PLANUFACTOR
,      GRPUFACTOR
,      PER_IN_LER_STAT_CD
,      PROCD_DT
,      BG_ID
,      ORG_ID
,      LOC_ID
,      GRADE_RANGE
,      GRADE_MID_POINT
,      PRIOR_FTE_SALARY
,      NEW_FTE_SALARY
,      NEW_QUARTILE
,      NEW_QUINTILE
,      NEW_DECILE
,      NEW_PERCENTILE
,      NEW_COMPARATIO
,      PROPOSED_PERFORMANCE_RATING
,      JOB_ID
,      JOB_FLEX1
,      JOB_FLEX2
,      JOB_FLEX3
,      JOB_FLEX4
,      JOB_FLEX5
,      PROPOSED_JOB_ID
,      POSITION_ID
,      PROPOSED_POSITION_ID
,      GRADE_ID
,      PROPOSED_GRADE_ID
,      PEOPLE_GROUP
,      PROPOSED_GROUP
,      ASSIGNMENT_STATUS_ID
,      CORP_BASE_SALARY
,      PL_NAME
,      OPT1_NAME
,      OPT2_NAME
,      OPT3_NAME
,      OPT4_NAME
,      PL_UOM
,      OPT1_UOM
,      OPT2_UOM
,      OPT3_UOM
,      OPT4_UOM
,      PL_CURRENCY
,      OPT1_CURRENCY
,      OPT2_CURRENCY
,      OPT3_CURRENCY
,      OPT4_CURRENCY
,      PL_ELIG_SAL_VAL
,      PL_WS_VAL
,      PL_PCT_OF_ELIG_SAL
,      PL_WS_MIN_VAL
,      PL_WS_MAX_VAL
,      PL_WS_INCR_VAL
,      PL_NEW_SALARY
,      PL_WS_VAL_LIMIT
,      PL_REC_VAL
,      PL_REC_MN_VAL
,      PL_REC_MX_VAL
,      PL_REC_VAL_LIMIT
,      PL_REC_VAL_PCT
,      PL_REC_VAL_PCT_LIMIT
,      PL_MISC1_VAL
,      PL_MISC2_VAL
,      PL_MISC3_VAL
,      PL_STAT_SAL_VAL
,      PL_TOT_COMP_VAL
,      PL_OTH_COMP_VAL
,      PL_XCHG_RATE
,      PL_CORP_ELIG_SAL_VAL
,      PL_CORP_WS_VAL
,      PL_CORP_NEW_SALARY
,      PL_SALARY_COMP
,      OPT1_ELIG_SAL_VAL
,      OPT1_WS_VAL
,      OPT1_PCT_OF_ELIG_SAL
,      OPT1_WS_MIN_VAL
,      OPT1_WS_MAX_VAL
,      OPT1_WS_INCR_VAL
,      OPT1_NEW_SALARY
,      OPT1_WS_VAL_LIMIT
,      OPT1_REC_VAL
,      OPT1_REC_MN_VAL
,      OPT1_REC_MX_VAL
,      OPT1_REC_VAL_LIMIT
,      OPT1_REC_VAL_PCT
,      OPT1_REC_VAL_PCT_LIMIT
,      OPT1_MISC1_VAL
,      OPT1_MISC2_VAL
,      OPT1_MISC3_VAL
,      OPT1_STAT_SAL_VAL
,      OPT1_TOT_COMP_VAL
,      OPT1_OTH_COMP_VAL
,      OPT1_XCHG_RATE
,      OPT1_CORP_ELIG_SAL_VAL
,      OPT1_CORP_WS_VAL
,      OPT1_CORP_NEW_SALARY
,      OPT1_SALARY_COMP
,      OPT2_ELIG_SAL_VAL
,      OPT2_WS_VAL
,      OPT2_PCT_OF_ELIG_SAL
,      OPT2_WS_MIN_VAL
,      OPT2_WS_MAX_VAL
,      OPT2_WS_INCR_VAL
,      OPT2_NEW_SALARY
,      OPT2_WS_VAL_LIMIT
,      OPT2_REC_VAL
,      OPT2_REC_MN_VAL
,      OPT2_REC_MX_VAL
,      OPT2_REC_VAL_LIMIT
,      OPT2_REC_VAL_PCT
,      OPT2_REC_VAL_PCT_LIMIT
,      OPT2_MISC1_VAL
,      OPT2_MISC2_VAL
,      OPT2_MISC3_VAL
,      OPT2_STAT_SAL_VAL
,      OPT2_TOT_COMP_VAL
,      OPT2_OTH_COMP_VAL
,      OPT2_XCHG_RATE
,      OPT2_CORP_ELIG_SAL_VAL
,      OPT2_CORP_WS_VAL
,      OPT2_CORP_NEW_SALARY
,      OPT2_SALARY_COMP
,      OPT3_ELIG_SAL_VAL
,      OPT3_WS_VAL
,      OPT3_PCT_OF_ELIG_SAL
,      OPT3_WS_MIN_VAL
,      OPT3_WS_MAX_VAL
,      OPT3_WS_INCR_VAL
,      OPT3_NEW_SALARY
,      OPT3_WS_VAL_LIMIT
,      OPT3_REC_VAL
,      OPT3_REC_MN_VAL
,      OPT3_REC_MX_VAL
,      OPT3_REC_VAL_LIMIT
,      OPT3_REC_VAL_PCT
,      OPT3_REC_VAL_PCT_LIMIT
,      OPT3_MISC1_VAL
,      OPT3_MISC2_VAL
,      OPT3_MISC3_VAL
,      OPT3_STAT_SAL_VAL
,      OPT3_TOT_COMP_VAL
,      OPT3_OTH_COMP_VAL
,      OPT3_XCHG_RATE
,      OPT3_CORP_ELIG_SAL_VAL
,      OPT3_CORP_WS_VAL
,      OPT3_CORP_NEW_SALARY
,      OPT3_SALARY_COMP
,      OPT4_ELIG_SAL_VAL
,      OPT4_WS_VAL
,      OPT4_PCT_OF_ELIG_SAL
,      OPT4_WS_MIN_VAL
,      OPT4_WS_MAX_VAL
,      OPT4_WS_INCR_VAL
,      OPT4_NEW_SALARY
,      OPT4_WS_VAL_LIMIT
,      OPT4_REC_VAL
,      OPT4_REC_MN_VAL
,      OPT4_REC_MX_VAL
,      OPT4_REC_VAL_LIMIT
,      OPT4_REC_VAL_PCT
,      OPT4_REC_VAL_PCT_LIMIT
,      OPT4_MISC1_VAL
,      OPT4_MISC2_VAL
,      OPT4_MISC3_VAL
,      OPT4_STAT_SAL_VAL
,      OPT4_TOT_COMP_VAL
,      OPT4_OTH_COMP_VAL
,      OPT4_XCHG_RATE
,      OPT4_CORP_ELIG_SAL_VAL
,      OPT4_CORP_WS_VAL
,      OPT4_CORP_NEW_SALARY
,      OPT4_SALARY_COMP
,      CHANGE_REASON
,      LEVEL1MGR
,      LEVEL2MGR
,      LEVEL3MGR
,      LEVEL4MGR
,      LEVEL5MGR
,      LEVEL6MGR
,      LEVEL7MGR
,      LEVEL8MGR
,      SAL_STAT_CURRENCY
,      WRK_MGR_NAME
,      CORP_CURRENCY
,      CONC_REQUEST_ID
,      START_DATE
,      END_DATE
FROM BEN.BEN_CWB_COMP_DETAILS#;

Dependencies

[top of page]

BEN.BEN_CWB_COMP_DETAILS# references the following:

BEN: BEN_CWB_COMP_DETAILS

BEN.BEN_CWB_COMP_DETAILS# is referenced by following:

APPS: BEN_CWB_COMP_DETAILS