[Home] [Help] [Dependency Information]
Object Name: | BEN_CWB_COMP_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | BEN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|