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   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