# DW_CMP_CWB_PERSON_INFO_D

This dimension captures the Compensation Worksheet Person Info Details

## Details

Module: Compensation

## Key Columns

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 |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. Source Record Identifier |  |
PLAN_ID | NUMBER | 38 | 0 |  | Plan Identifier |  |
PERIOD_ID | NUMBER | 38 | 0 |  | Period Identifier |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier |  |
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Identifier |  |
WS_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Worksheet Manager Person Identifier |  |
WS_MGR_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Worksheet Manager Assignment Identifier |  |
WS_MGR_PERSON_EVENT_ID | NUMBER | 38 | 0 |  | Worksheet Manager Person Event Identifier |  |
SUPERVISOR_ID | NUMBER | 38 | 0 |  | Supervisor Identifier |  |
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business Group Identifier |  |
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit Identifier |  |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal Entity Identifier |  |
ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier |  |
LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier |  |
JOB_ID | NUMBER | 38 | 0 |  | Job Identifier |  |
POSITION_ID | NUMBER | 38 | 0 |  | Position Identifier |  |
GRADE_ID | NUMBER | 38 | 0 |  | Grade Identifier |  |
SALARY_BASIS_ID | NUMBER | 38 | 0 |  | Salary Basis Identifier |  |
PAYROLL_ID | NUMBER | 38 | 0 |  | Payroll Identifier |  |
DUE_DATE | DATE |  |  |  | Due Date |  |
ACCESS_CODE | VARCHAR2 | 32 |  |  | Access Code |  |
EMP_STATUS_CODE | VARCHAR2 | 32 |  |  | Employee Status Code |  |
MGR_STATUS_CODE | VARCHAR2 | 32 |  |  | Manager Status Code |  |
APPROVAL_CODE | VARCHAR2 | 32 |  |  | Approval Code |  |
APPROVAL_DATE | DATE |  |  |  | Approval Date |  |
SUBMIT_DATE | DATE |  |  |  | Submit Date |  |
DATE_OF_BIRTH | DATE |  |  |  | Date of Birth of the person |  |
SEX | VARCHAR2 | 32 |  |  | Gender of the person |  |
ETHNICITY | VARCHAR2 | 32 |  |  | Ethnicity of the person |  |
RELIGION | VARCHAR2 | 32 |  |  | Religion of the person |  |
DISABILITY_STATUS | VARCHAR2 | 32 |  |  | Disability Status of the person |  |
VETERAN_STATUS | VARCHAR2 | 32 |  |  | Veteran Status of the person |  |
NATIONALITY | VARCHAR2 | 32 |  |  | Nationality of the person |  |
LEGISLATION_CODE | VARCHAR2 | 32 |  |  | Legislation Code |  |
START_DATE | DATE |  |  |  | Start Date |  |
EMPLOYMENT_CATEGORY | VARCHAR2 | 32 |  |  | Employment Category |  |
YEARS_EMPLOYED | NUMBER |  |  |  | Years Employed |  |
YEARS_IN_GRADE | NUMBER |  |  |  | Years in Grade |  |
YEARS_IN_JOB | NUMBER |  |  |  | Years in Job |  |
YEARS_IN_POSITION | NUMBER |  |  |  | Years in Position |  |
ASSIGNMENT_POSTING_DATE | DATE |  |  |  | Assignment Posting Date |  |
ASSIGNMENT_POSTED_DATE | DATE |  |  |  | Assignment Posted Date |  |
ASSIGNMENT_CHANGE_DATE | DATE |  |  |  | Assignment Change Date |  |
ADJUSTED_CHANGE_AMOUNT | NUMBER |  |  |  | Adjusted Change Amount |  |
ADJUSTED_SALARY_CURRENT | NUMBER |  |  |  | Adjusted Salary Current |  |
ADJUSTED_SALARY_NEW | NUMBER |  |  |  | Adjusted Salary New |  |
BASE_SALARY | NUMBER |  |  |  | Base Salary |  |
BASE_SALARY_CURRENCY | VARCHAR2 | 32 |  |  | Base Salary Currency |  |
BASE_SALARY_FREQUENCY | VARCHAR2 | 32 |  |  | Base Salary Frequency |  |
BASE_SALARY_CHANGE_DATE | DATE |  |  |  | Base Salary Change Date |  |
BASE_SALARY_CHANGE_VAL | NUMBER |  |  |  | Base Salary Change Value |  |
PAY_ANNUALIZATION_FACTOR | NUMBER |  |  |  | Pay Annualization Factor |  |
FREQUENCY | VARCHAR2 | 32 |  |  | Frequency |  |
NEW_BASE_SALARY | NUMBER |  |  |  | New Base Salary |  |
PRIOR_SALARY | NUMBER |  |  |  | Prior Salary |  |
GRADE_COMPARATIO | NUMBER |  |  |  | Grade Comparatio |  |
NEW_GRADE_COMPARATIO | NUMBER |  |  |  | New Grade Comparatio |  |
CUSTOM_SEGMENT1 | VARCHAR2 | 256 |  |  | Custom Segment |  |
CUSTOM_SEGMENT2 | VARCHAR2 | 256 |  |  | Custom Segment |  |
CUSTOM_SEGMENT3 | VARCHAR2 | 256 |  |  | Custom Segment |  |
CUSTOM_SEGMENT4 | VARCHAR2 | 256 |  |  | Custom Segment |  |
CUSTOM_SEGMENT5 | VARCHAR2 | 256 |  |  | Custom Segment |  |
CUSTOM_SEGMENT6 | VARCHAR2 | 256 |  |  | Custom Segment |  |
CUSTOM_SEGMENT7 | VARCHAR2 | 256 |  |  | Custom Segment |  |
CUSTOM_SEGMENT8 | VARCHAR2 | 256 |  |  | Custom Segment |  |
CUSTOM_SEGMENT9 | VARCHAR2 | 256 |  |  | Custom Segment |  |
CUSTOM_SEGMENT10 | VARCHAR2 | 256 |  |  | Custom Segment |  |
CUSTOM_SEGMENT11 | VARCHAR2 | 256 |  |  | Custom Segment |  |
CUSTOM_SEGMENT12 | VARCHAR2 | 999 |  |  | Custom Segment |  |
CUSTOM_SEGMENT13 | VARCHAR2 | 999 |  |  | Custom Segment |  |
CUSTOM_SEGMENT14 | VARCHAR2 | 999 |  |  | Custom Segment |  |
CUSTOM_SEGMENT15 | VARCHAR2 | 999 |  |  | Custom Segment |  |
CUSTOM_SEGMENT16 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT17 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT18 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT19 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT20 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT21 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT22 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT23 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT24 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT25 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT26 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT27 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT28 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT29 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT30 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT31 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT32 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT33 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT34 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT35 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT36 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT37 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT38 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT39 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT40 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT41 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT42 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT43 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT44 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT45 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT46 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT47 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT48 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT49 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT50 | NUMBER |  |  |  | Custom Segment |  |
CUSTOM_SEGMENT46_VARCHAR | VARCHAR2 | 128 |  |  | Custom Segment |  |
CUSTOM_SEGMENT47_VARCHAR | VARCHAR2 | 128 |  |  | Custom Segment |  |
CUSTOM_SEGMENT48_VARCHAR | VARCHAR2 | 128 |  |  | Custom Segment |  |
CUSTOM_SEGMENT49_VARCHAR | VARCHAR2 | 128 |  |  | Custom Segment |  |
CUSTOM_SEGMENT50_VARCHAR | VARCHAR2 | 128 |  |  | Custom Segment |  |

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