# DW_CMP_CWB_PERSON_RATE_F

Information about the various Compensation Rates for a person

## Details

Module: Compensation

## Key Columns

COMPONENT_ID, PERSON_EVENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PERSON_EVENT_ID | NUMBER | 38 | 0 | True | Person Event Identifier |  |
COMPONENT_ID | NUMBER | 38 | 0 | True | Component Identifier | DW_CMP_PLAN_COMPONENT_D | COMPONENT_ID
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier |  |
PLAN_ID | NUMBER | 38 | 0 |  | Plan Identifier | DW_CMP_PLAN_D | PLAN_ID
PERIOD_ID | NUMBER | 38 | 0 |  | Plan Period Identifier | DW_CMP_PLAN_PERIOD_D | PERIOD_ID
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier | DW_PERSON_D | PERSON_ID
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Identifier |  |
ELIG_FLAG | VARCHAR2 | 16 |  |  | Eligibility Flag |  |
INELIG_REASON_CODE | VARCHAR2 | 32 |  |  | Ineligibility Reason |  |
CURRENCY | VARCHAR2 | 32 |  |  | Currency of person rates |  |
WS_VAL | NUMBER |  |  |  | Worksheet Compensation Amount |  |
WS_MIN_VAL | NUMBER |  |  |  | Worksheet Compensation Amount Minimum Value |  |
WS_MAX_VAL | NUMBER |  |  |  | Worksheet Compensation Amount Maximum Value |  |
ELIG_SAL_VAL | NUMBER |  |  |  | Eligible Salary Value |  |
MISC1_VAL | NUMBER |  |  |  | Miscellaneous Values |  |
MISC2_VAL | NUMBER |  |  |  | Miscellaneous Values |  |
MISC3_VAL | NUMBER |  |  |  | Miscellaneous Values |  |
MISC4_VAL | NUMBER |  |  |  | Miscellaneous Values |  |
MISC5_VAL | NUMBER |  |  |  | Miscellaneous Values |  |
MISC6_VAL | NUMBER |  |  |  | Miscellaneous Values |  |
REC_VAL | NUMBER |  |  |  | Target Compensation Value |  |
REC_MIN_VAL | NUMBER |  |  |  | Target Compensation Minimum Value |  |
REC_MAX_VAL | NUMBER |  |  |  | Target Compensation Maximum Value |  |
PRIOR_WS_VAL | NUMBER |  |  |  | Prior Worksheet Compensation Amount |  |
PRIOR_ELIG_SAL_VAL | NUMBER |  |  |  | Prior Eligible Salary Value |  |
EMP_BDGT_VAL | NUMBER |  |  |  | Employee Budget Value |  |
EMP_BDGT_MIN_VAL | NUMBER |  |  |  | Employee Budget Value Minimum |  |
EMP_BDGT_MAX_VAL | NUMBER |  |  |  | Employee Budget Value Mazimum |  |
PRIOR_WS_VAL_DATE | DATE |  |  |  | Prios Worksheet Value Date |  |
COMP_POSTED_DATE | DATE |  |  |  | Compensation Posted Date |  |
COMP_POSTING_DATE | DATE |  |  |  | Compensation Posting Date |  |
ELIG_OVERRIDE_DATE | DATE |  |  |  | Date when Eligibility is overriden |  |
ELIG_OVERRIDE_PERSON_ID | NUMBER | 38 | 0 |  | Person identifier who overrided eligibility | DW_PERSON_D | PERSON_ID
WS_VAL_LAST_UPD_DATE | DATE |  |  |  | Worksheet Value Last Updated Date |  |
CREATION_DATE | TIMESTAMP |  |  |  | creation date |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.