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