Information about the various Compensation Rates for a person
Module: Compensation
PERSON_EVENT_ID, COMPONENT_ID
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 | 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 |