[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BEN_CWB_COMP_DETAILS |
|---|---|
| Object Type: | TABLE |
| Owner: | BEN |
| Subobject Name: | |
| Status: | VALID |
Summary table which stores the information displayed on the Compensation Detail report.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| BEN_CWB_COMP_DETAILS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 GROUP_PL_ID
LF_EVT_OCRD_DT
|
| BEN_CWB_COMP_DETAILS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
GROUP_PER_IN_LER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| GROUP_PER_IN_LER_ID | NUMBER | (15) | Yes | Group Person Life Event. |
| GROUP_PL_ID | NUMBER | (15) | Yes | Group Plan. |
| LF_EVT_OCRD_DT | DATE | Yes | Life Event Occured on Date. | |
| PERSON_ID | NUMBER | (15) | Yes | Person. |
| PLOIPLID | NUMBER | (15) | Option In Plan for Local Plan. | |
| OIP1PLID | NUMBER | (15) | Local Plan of Option 1. | |
| OIP2PLID | NUMBER | (15) | Local Plan of Option 2. | |
| OIP3PLID | NUMBER | (15) | Local Plan of Option 3. | |
| OIP4PLID | NUMBER | (15) | Local Plan of Option 4. | |
| OIPL1ID | NUMBER | (15) | Option 1. | |
| OIPL2ID | NUMBER | (15) | Option 2. | |
| OIPL3ID | NUMBER | (15) | Option 3. | |
| OIPL4ID | NUMBER | (15) | Option 4. | |
| OPT1OIPLORDRNUM | NUMBER | (15) | Option 1 Order. | |
| OPT2OIPLORDRNUM | NUMBER | (15) | Option 2 Order. | |
| OPT3OIPLORDRNUM | NUMBER | (15) | Option 3 Order. | |
| OPT4OIPLORDRNUM | NUMBER | (15) | Option 4 Order. | |
| OIP1GRPOIPLID | NUMBER | (15) | Group Option 1. | |
| OIP2GRPOIPLID | NUMBER | (15) | Group Option 2. | |
| OIP3GRPOIPLID | NUMBER | (15) | Group Option 3. | |
| OIP4GRPOIPLID | NUMBER | (15) | Group Option 4. | |
| ELIG_FLAG | VARCHAR2 | (30) | Eligibility of Plan. | |
| OPT1_ELIG_FLAG | VARCHAR2 | (30) | Eligibility of Option 1. | |
| OPT2_ELIG_FLAG | VARCHAR2 | (30) | Eligibility of Option 2. | |
| OPT3_ELIG_FLAG | VARCHAR2 | (30) | Eligibility of Option 3. | |
| OPT4_ELIG_FLAG | VARCHAR2 | (30) | Eligibility of Option 4. | |
| PLANUFACTOR | NUMBER | Plan Annualization Factor for Local Plan. | ||
| GRPUFACTOR | NUMBER | Plan Annualization Factor for Group Plan. | ||
| PER_IN_LER_STAT_CD | VARCHAR2 | (30) | Person Life Event Status. | |
| PROCD_DT | DATE | Person Life Event Processed Date. | ||
| BG_ID | NUMBER | (15) | Business Group. | |
| ORG_ID | NUMBER | (15) | Organization. | |
| LOC_ID | NUMBER | (15) | Location. | |
| GRADE_RANGE | VARCHAR2 | (100) | Grade Range. | |
| GRADE_MID_POINT | NUMBER | Grade Mid. | ||
| PRIOR_FTE_SALARY | NUMBER | Prior Full Time Equivalent Salary. | ||
| NEW_FTE_SALARY | NUMBER | New Full Time Equivalent Salary. | ||
| NEW_QUARTILE | VARCHAR2 | (40) | New Salary Quartile. | |
| NEW_QUINTILE | VARCHAR2 | (40) | New Salary Quintile. | |
| NEW_DECILE | VARCHAR2 | (40) | New Salary Decile. | |
| NEW_PERCENTILE | NUMBER | New Salary Percentile. | ||
| NEW_COMPARATIO | NUMBER | New Salary Comparatio. | ||
| PROPOSED_PERFORMANCE_RATING | VARCHAR2 | (240) | Proposed Performance Rating. | |
| JOB_ID | NUMBER | (15) | Job. | |
| JOB_FLEX1 | VARCHAR2 | (150) | Job Descriptive Flex Attribute 1. | |
| JOB_FLEX2 | VARCHAR2 | (150) | Job Descriptive Flex Attribute 2. | |
| JOB_FLEX3 | VARCHAR2 | (150) | Job Descriptive Flex Attribute 3. | |
| JOB_FLEX4 | VARCHAR2 | (150) | Job Descriptive Flex Attribute 4. | |
| JOB_FLEX5 | VARCHAR2 | (150) | Job Descriptive Flex Attribute 5. | |
| PROPOSED_JOB_ID | NUMBER | (15) | Proposed Job. | |
| POSITION_ID | NUMBER | (15) | Position. | |
| PROPOSED_POSITION_ID | NUMBER | (15) | Proposed Position. | |
| GRADE_ID | NUMBER | (15) | Grade. | |
| PROPOSED_GRADE_ID | NUMBER | (15) | Proposed Grade. | |
| PEOPLE_GROUP | VARCHAR2 | (240) | People Group. | |
| PROPOSED_GROUP | VARCHAR2 | (240) | Proposed People Group. | |
| ASSIGNMENT_STATUS_ID | NUMBER | (15) | Assignment Status. | |
| CORP_BASE_SALARY | NUMBER | Base Salary converted to Corporate currency. | ||
| PL_NAME | VARCHAR2 | (240) | Plan Name. | |
| OPT1_NAME | VARCHAR2 | (240) | Option 1 Name. | |
| OPT2_NAME | VARCHAR2 | (240) | Option 2 Name. | |
| OPT3_NAME | VARCHAR2 | (240) | Option 3 Name. | |
| OPT4_NAME | VARCHAR2 | (240) | Option 4 Name. | |
| PL_UOM | VARCHAR2 | (80) | Plan UOM. | |
| OPT1_UOM | VARCHAR2 | (80) | Option 1 UOM. | |
| OPT2_UOM | VARCHAR2 | (80) | Option 2 UOM. | |
| OPT3_UOM | VARCHAR2 | (80) | Option 3 UOM. | |
| OPT4_UOM | VARCHAR2 | (80) | Option 4 UOM. | |
| PL_CURRENCY | VARCHAR2 | (30) | Plan Currency. | |
| OPT1_CURRENCY | VARCHAR2 | (30) | Option 1 Currency. | |
| OPT2_CURRENCY | VARCHAR2 | (30) | Option 2 Currency. | |
| OPT3_CURRENCY | VARCHAR2 | (30) | Option 3 Currency. | |
| OPT4_CURRENCY | VARCHAR2 | (30) | Option 4 Currency. | |
| PL_ELIG_SAL_VAL | NUMBER | Eligibile Salary at Plan Level. | ||
| PL_WS_VAL | NUMBER | Worksheet Value at Plan Level. | ||
| PL_PCT_OF_ELIG_SAL | NUMBER | Worksheet Value as Percentage of Eligible Salaryat Plan Level. | ||
| PL_WS_MIN_VAL | NUMBER | Min Worksheet Value at Plan Level. | ||
| PL_WS_MAX_VAL | NUMBER | Max Worksheet Value at Plan Level. | ||
| PL_WS_INCR_VAL | NUMBER | Worksheet Value Increment at Plan Level. | ||
| PL_NEW_SALARY | NUMBER | New Salary. | ||
| PL_WS_VAL_LIMIT | VARCHAR2 | (100) | Worksheet Value Range at Plan Level. | |
| PL_REC_VAL | NUMBER | Recommended Value at Plan Level. | ||
| PL_REC_MN_VAL | NUMBER | Min Recommended Value at Plan Level. | ||
| PL_REC_MX_VAL | NUMBER | Max Recommended Value at Plan Level. | ||
| PL_REC_VAL_LIMIT | VARCHAR2 | (100) | Recommended Value Range at Plan Level. | |
| PL_REC_VAL_PCT | NUMBER | Recommended Value as Percentage of Eligible Salaryat Plan Level. | ||
| PL_REC_VAL_PCT_LIMIT | VARCHAR2 | (100) | Range for Recommended Value as Percentage of Eligible Salaryat Plan Level. | |
| PL_MISC1_VAL | NUMBER | Miscellaneous 1 Value at Plan Level. | ||
| PL_MISC2_VAL | NUMBER | Miscellaneous 2 Value at Plan Level. | ||
| PL_MISC3_VAL | NUMBER | Miscellaneous 3 Value at Plan Level. | ||
| PL_STAT_SAL_VAL | NUMBER | Stated Value at Plan Level. | ||
| PL_TOT_COMP_VAL | NUMBER | Total Compensation Value at Plan Level. | ||
| PL_OTH_COMP_VAL | NUMBER | Other Compensation Value at Plan Level. | ||
| PL_XCHG_RATE | NUMBER | Exchange Rate for Plan currency. | ||
| PL_CORP_ELIG_SAL_VAL | NUMBER | Plan Eligible Salary converted to corporate currency. | ||
| PL_CORP_WS_VAL | NUMBER | Plan worksheet value converted to corporate currency. | ||
| PL_CORP_NEW_SALARY | NUMBER | Plan New Salary converted to corporate currency. | ||
| PL_SALARY_COMP | VARCHAR2 | (80) | Worksheet Rate Sub Activity Type Code of Plan. | |
| OPT1_ELIG_SAL_VAL | NUMBER | Eligibile Salary at Option 1 Level. | ||
| OPT1_WS_VAL | NUMBER | Worksheet Value at Option 1 Level. | ||
| OPT1_PCT_OF_ELIG_SAL | NUMBER | Worksheet Value as Percentage of Eligible Salaryat Option 1 Level. | ||
| OPT1_WS_MIN_VAL | NUMBER | Min Worksheet Value at Option 1 Level. | ||
| OPT1_WS_MAX_VAL | NUMBER | Max Worksheet Value at Option 1 Level. | ||
| OPT1_WS_INCR_VAL | NUMBER | Worksheet Value Increment at Option 1 Level. | ||
| OPT1_NEW_SALARY | NUMBER | New Salary. | ||
| OPT1_WS_VAL_LIMIT | VARCHAR2 | (100) | Worksheet Value Range at Option 1 Level. | |
| OPT1_REC_VAL | NUMBER | Recommended Value at Option 1 Level. | ||
| OPT1_REC_MN_VAL | NUMBER | Min Recommended Value at Option 1 Level. | ||
| OPT1_REC_MX_VAL | NUMBER | Max Recommended Value at Option 1 Level. | ||
| OPT1_REC_VAL_LIMIT | VARCHAR2 | (100) | Recommended Value Range at Option 1 Level. | |
| OPT1_REC_VAL_PCT | NUMBER | Recommended Value as Percentage of Eligible Salaryat Option 1 Level. | ||
| OPT1_REC_VAL_PCT_LIMIT | VARCHAR2 | (100) | Range for Recommended Value as Percentage of Eligible Salaryat Option 1 Level. | |
| OPT1_MISC1_VAL | NUMBER | Miscellaneous 1 Value at Option 1 Level. | ||
| OPT1_MISC2_VAL | NUMBER | Miscellaneous 2 Value at Option 1 Level. | ||
| OPT1_MISC3_VAL | NUMBER | Miscellaneous 3 Value at Option 1 Level. | ||
| OPT1_STAT_SAL_VAL | NUMBER | Stated Value at Option 1 Level. | ||
| OPT1_TOT_COMP_VAL | NUMBER | Total Compensation Value at Option 1 Level. | ||
| OPT1_OTH_COMP_VAL | NUMBER | Other Compensation Value at Option 1 Level. | ||
| OPT1_XCHG_RATE | NUMBER | Exchange Rate for Option 1 currency. | ||
| OPT1_CORP_ELIG_SAL_VAL | NUMBER | Option 1 Eligible Salary converted to corporate currency. | ||
| OPT1_CORP_WS_VAL | NUMBER | Option 1 worksheet value converted to corporate currency. | ||
| OPT1_CORP_NEW_SALARY | NUMBER | Option 1 New Salary converted to corporate currency. | ||
| OPT1_SALARY_COMP | VARCHAR2 | (30) | Worksheet Rate Sub Activity Type Code of Option 1. | |
| OPT2_ELIG_SAL_VAL | NUMBER | Eligibile Salary at Option 2 Level. | ||
| OPT2_WS_VAL | NUMBER | Worksheet Value at Option 2 Level. | ||
| OPT2_PCT_OF_ELIG_SAL | NUMBER | Worksheet Value as Percentage of Eligible Salaryat Option 2 Level. | ||
| OPT2_WS_MIN_VAL | NUMBER | Min Worksheet Value at Option 2 Level. | ||
| OPT2_WS_MAX_VAL | NUMBER | Max Worksheet Value at Option 2 Level. | ||
| OPT2_WS_INCR_VAL | NUMBER | Worksheet Value Increment at Option 2 Level. | ||
| OPT2_NEW_SALARY | NUMBER | New Salary. | ||
| OPT2_WS_VAL_LIMIT | VARCHAR2 | (100) | Worksheet Value Range at Option 2 Level. | |
| OPT2_REC_VAL | NUMBER | Recommended Value at Option 2 Level. | ||
| OPT2_REC_MN_VAL | NUMBER | Min Recommended Value at Option 2 Level. | ||
| OPT2_REC_MX_VAL | NUMBER | Max Recommended Value at Option 2 Level. | ||
| OPT2_REC_VAL_LIMIT | VARCHAR2 | (100) | Recommended Value Range at Option 2 Level. | |
| OPT2_REC_VAL_PCT | NUMBER | Recommended Value as Percentage of Eligible Salaryat Option 2 Level. | ||
| OPT2_REC_VAL_PCT_LIMIT | VARCHAR2 | (100) | Range for Recommended Value as Percentage of Eligible Salaryat Option 2 Level. | |
| OPT2_MISC1_VAL | NUMBER | Miscellaneous 1 Value at Option 2 Level. | ||
| OPT2_MISC2_VAL | NUMBER | Miscellaneous 2 Value at Option 2 Level. | ||
| OPT2_MISC3_VAL | NUMBER | Miscellaneous 3 Value at Option 2 Level. | ||
| OPT2_STAT_SAL_VAL | NUMBER | Stated Value at Option 2 Level. | ||
| OPT2_TOT_COMP_VAL | NUMBER | Total Compensation Value at Option 2 Level. | ||
| OPT2_OTH_COMP_VAL | NUMBER | Other Compensation Value at Option 2 Level. | ||
| OPT2_XCHG_RATE | NUMBER | Exchange Rate for Option 2 currency. | ||
| OPT2_CORP_ELIG_SAL_VAL | NUMBER | Option 2 Eligible Salary converted to corporate currency. | ||
| OPT2_CORP_WS_VAL | NUMBER | Option 2 worksheet value converted to corporate currency. | ||
| OPT2_CORP_NEW_SALARY | NUMBER | Option 2 New Salary converted to corporate currency. | ||
| OPT2_SALARY_COMP | VARCHAR2 | (30) | Worksheet Rate Sub Activity Type Code of Option 2. | |
| OPT3_ELIG_SAL_VAL | NUMBER | Eligibile Salary at Option 3 Level. | ||
| OPT3_WS_VAL | NUMBER | Worksheet Value at Option 3 Level. | ||
| OPT3_PCT_OF_ELIG_SAL | NUMBER | Worksheet Value as Percentage of Eligible Salaryat Option 3 Level. | ||
| OPT3_WS_MIN_VAL | NUMBER | Min Worksheet Value at Option 3 Level. | ||
| OPT3_WS_MAX_VAL | NUMBER | Max Worksheet Value at Option 3 Level. | ||
| OPT3_WS_INCR_VAL | NUMBER | Worksheet Value Increment at Option 3 Level. | ||
| OPT3_NEW_SALARY | NUMBER | New Salary. | ||
| OPT3_WS_VAL_LIMIT | VARCHAR2 | (100) | Worksheet Value Range at Option 3 Level. | |
| OPT3_REC_VAL | NUMBER | Recommended Value at Option 3 Level. | ||
| OPT3_REC_MN_VAL | NUMBER | Min Recommended Value at Option 3 Level. | ||
| OPT3_REC_MX_VAL | NUMBER | Max Recommended Value at Option 3 Level. | ||
| OPT3_REC_VAL_LIMIT | VARCHAR2 | (100) | Recommended Value Range at Option 3 Level. | |
| OPT3_REC_VAL_PCT | NUMBER | Recommended Value as Percentage of Eligible Salaryat Option 3 Level. | ||
| OPT3_REC_VAL_PCT_LIMIT | VARCHAR2 | (100) | Range for Recommended Value as Percentage of Eligible Salaryat Option 3 Level. | |
| OPT3_MISC1_VAL | NUMBER | Miscellaneous 1 Value at Option 3 Level. | ||
| OPT3_MISC2_VAL | NUMBER | Miscellaneous 2 Value at Option 3 Level. | ||
| OPT3_MISC3_VAL | NUMBER | Miscellaneous 3 Value at Option 3 Level. | ||
| OPT3_STAT_SAL_VAL | NUMBER | Stated Value at Option 3 Level. | ||
| OPT3_TOT_COMP_VAL | NUMBER | Total Compensation Value at Option 3 Level. | ||
| OPT3_OTH_COMP_VAL | NUMBER | Other Compensation Value at Option 3 Level. | ||
| OPT3_XCHG_RATE | NUMBER | Exchange Rate for Option 3 currency. | ||
| OPT3_CORP_ELIG_SAL_VAL | NUMBER | Option 3 Eligible Salary converted to corporate currency. | ||
| OPT3_CORP_WS_VAL | NUMBER | Option 3 worksheet value converted to corporate currency. | ||
| OPT3_CORP_NEW_SALARY | NUMBER | Option 3 New Salary converted to corporate currency. | ||
| OPT3_SALARY_COMP | VARCHAR2 | (30) | Worksheet Rate Sub Activity Type Code of Option 3. | |
| OPT4_ELIG_SAL_VAL | NUMBER | Eligibile Salary at Option 4 Level. | ||
| OPT4_WS_VAL | NUMBER | Worksheet Value at Option 4 Level. | ||
| OPT4_PCT_OF_ELIG_SAL | NUMBER | Worksheet Value as Percentage of Eligible Salaryat Option 4 Level. | ||
| OPT4_WS_MIN_VAL | NUMBER | Min Worksheet Value at Option 4 Level. | ||
| OPT4_WS_MAX_VAL | NUMBER | Max Worksheet Value at Option 4 Level. | ||
| OPT4_WS_INCR_VAL | NUMBER | Worksheet Value Increment at Option 4 Level. | ||
| OPT4_NEW_SALARY | NUMBER | New Salary. | ||
| OPT4_WS_VAL_LIMIT | VARCHAR2 | (100) | Worksheet Value Range at Option 4 Level. | |
| OPT4_REC_VAL | NUMBER | Recommended Value at Option 4 Level. | ||
| OPT4_REC_MN_VAL | NUMBER | Min Recommended Value at Option 4 Level. | ||
| OPT4_REC_MX_VAL | NUMBER | Max Recommended Value at Option 4 Level. | ||
| OPT4_REC_VAL_LIMIT | VARCHAR2 | (100) | Recommended Value Range at Option 4 Level. | |
| OPT4_REC_VAL_PCT | NUMBER | Recommended Value as Percentage of Eligible Salaryat Option 4 Level. | ||
| OPT4_REC_VAL_PCT_LIMIT | VARCHAR2 | (100) | Range for Recommended Value as Percentage of Eligible Salaryat Option 4 Level. | |
| OPT4_MISC1_VAL | NUMBER | Miscellaneous 1 Value at Option 4 Level. | ||
| OPT4_MISC2_VAL | NUMBER | Miscellaneous 2 Value at Option 4 Level. | ||
| OPT4_MISC3_VAL | NUMBER | Miscellaneous 3 Value at Option 4 Level. | ||
| OPT4_STAT_SAL_VAL | NUMBER | Stated Value at Option 4 Level. | ||
| OPT4_TOT_COMP_VAL | NUMBER | Total Compensation Value at Option 4 Level. | ||
| OPT4_OTH_COMP_VAL | NUMBER | Other Compensation Value at Option 4 Level. | ||
| OPT4_XCHG_RATE | NUMBER | Exchange Rate for Option 4 currency. | ||
| OPT4_CORP_ELIG_SAL_VAL | NUMBER | Option 4 Eligible Salary converted to corporate currency. | ||
| OPT4_CORP_WS_VAL | NUMBER | Option 4 worksheet value converted to corporate currency. | ||
| OPT4_CORP_NEW_SALARY | NUMBER | Option 4 New Salary converted to corporate currency. | ||
| OPT4_SALARY_COMP | VARCHAR2 | (30) | Worksheet Rate Sub Activity Type Code of Option 4. | |
| CHANGE_REASON | VARCHAR2 | (240) | Change Reason. | |
| LEVEL1MGR | VARCHAR2 | (240) | Level 1 Manager. | |
| LEVEL2MGR | VARCHAR2 | (240) | Level 2 Manager. | |
| LEVEL3MGR | VARCHAR2 | (240) | Level 3 Manager. | |
| LEVEL4MGR | VARCHAR2 | (240) | Level 4 Manager. | |
| LEVEL5MGR | VARCHAR2 | (240) | Level 5 Manager. | |
| LEVEL6MGR | VARCHAR2 | (240) | Level 6 Manager. | |
| LEVEL7MGR | VARCHAR2 | (240) | Level 7 Manager. | |
| LEVEL8MGR | VARCHAR2 | (240) | Level 8 Manager. | |
| SAL_STAT_CURRENCY | VARCHAR2 | (30) | Salary Component currency. | |
| WRK_MGR_NAME | VARCHAR2 | (480) | Wroksheet manager name. | |
| CORP_CURRENCY | VARCHAR2 | (30) | Corporate currency. | |
| CONC_REQUEST_ID | NUMBER | (15) | Concurrent request ID that populated the row | |
| START_DATE | DATE | Start date and time when refresh process begins for the plan | ||
| END_DATE | DATE | End date and time when refresh process ends for the plan |
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;
BEN.BEN_CWB_COMP_DETAILS does not reference any database object
BEN.BEN_CWB_COMP_DETAILS is referenced by following:
BEN
BEN_CWB_COMP_DETAILS#
|
|
|
|