DW_CMP_CWB_PERSON_INFO_EF

This Enhanced fact 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 DW_CMP_CWB_PERSON_INFO_D PERSON_EVENT_ID
SOURCE_RECORD_ID NUMBER 38 0   This column is for Oracle Internal use only. Source Record Identifier    
PLAN_ID NUMBER 38 0   Plan Identifier DW_CMP_PLAN_D PLAN_ID
PERIOD_ID NUMBER 38 0   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    
CMP_WS_MGR_PERSON_ID NUMBER 38 0   Worksheet Manager Person Identifier DW_PERSON_D PERSON_ID
CMP_WS_MGR_ASSIGNMENT_ID NUMBER 38 0   Worksheet Manager Assignment Identifier    
CMP_WS_MGR_PERSON_EVENT_ID NUMBER 38 0   Worksheet Manager Person Event Identifier DW_CMP_CWB_PERSON_INFO_D PERSON_EVENT_ID
CMP_SUPERVISOR_ID NUMBER 38 0   Supervisor Identifier DW_PERSON_D PERSON_ID
CMP_BUSINESS_GROUP_ID NUMBER 38 0   Business Group Identifier    
CMP_BUSINESS_UNIT_ID NUMBER 38 0   Business Unit Identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
CMP_LEGAL_ENTITY_ID NUMBER 38 0   Legal Entity Identifier    
CMP_ORGANIZATION_ID NUMBER 38 0   Organization Identifier    
CMP_LOCATION_ID NUMBER 38 0   Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
CMP_JOB_ID NUMBER 38 0   Job Identifier DW_JOB_D JOB_ID
CMP_POSITION_ID NUMBER 38 0   Position Identifier DW_POSITION_D POSITION_ID
CMP_GRADE_ID NUMBER 38 0   Grade Identifier DW_PAY_GRADE_D GRADE_ID
CMP_SALARY_BASIS_ID NUMBER 38 0   Salary Basis Identifier DW_SALARY_BASIS_D SALARY_BASIS_ID
CMP_PAYROLL_ID NUMBER 38 0   Payroll Identifier    
DEPARTMENT_ID NUMBER 38 0   Department Identifier DW_DEPARTMENT_D DEPARTMENT_ID
REPORTING_ESTABLISHMENT_ID NUMBER 38 0   Reporting Establishment Identifier DW_REPORTING_EST_D REPORTING_EST_ID
JOB_ID NUMBER 38 0   Job Identifier DW_JOB_D JOB_ID
LOCATION_ID NUMBER 38 0   Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
POSITION_ID NUMBER 38 0   Position Identifie DW_POSITION_D POSITION_ID
GRADE_ID NUMBER 38 0   Grade Identifier DW_PAY_GRADE_D GRADE_ID
LEGAL_EMPLOYER_ID NUMBER 38 0   Legal Employer DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
BUSINESS_UNIT_ID NUMBER 38 0   Business Unit Identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
PERIOD_OF_SERVICE_ID NUMBER 38 0   Period of Service Identifier DW_SERVICE_PERIOD_D PERIOD_OF_SERVICE_ID
PERSON_TYPE_ID NUMBER 38 0   Person Type DW_PERSON_TYPE_D_TL PERSON_TYPE_ID
ASSIGNMENT_STATUS_TYPE_ID NUMBER 38 0   Assignment Status Type Identifier DW_ASSIGNMENT_STATUS_D_TL ASSIGNMENT_STATUS_TYPE_ID
SUPERVISOR_ASSIGNMENT_ID NUMBER 38 0   Manager Assignment Identifier    
SUPERVISOR_ID NUMBER 38 0   Manager Person Identifier DW_PERSON_D PERSON_ID
PERFORMANCE_RATING_LEVEL_ID NUMBER 38 0   Performance rating level id DW_RATING_LEVEL_D RATING_LEVEL_ID
POTENTIAL_RATING_LEVEL_ID NUMBER 38 0   Potential rating level id DW_RATING_LEVEL_D RATING_LEVEL_ID
SYSTEM_PERSON_TYPE VARCHAR2 32     Person Type in System    
PRIMARY_FLAG VARCHAR2 32     Represents overall Primary assignment    
PRIMARY_ASSIGNMENT_FLAG VARCHAR2 32     Primary assignment Flag    
ASSIGNMENT_NUMBER VARCHAR2 32     Assignment Number    
ASSIGNMENT_NAME VARCHAR2 128     Assignment Name    
WORKER_TYPE VARCHAR2 32     Identifies the type of record: either assignment (employee, CWK, applicant, non-workers) or a set of Terms DW_WORKER_TYPE_D_TL WORKER_TYPE
WORKER_CATEGORY VARCHAR2 32     Employee category example: Blue collar, Civil Servant, etc DW_WORKER_CATEGORY_D_TL WORKER_CATEGORY
ASSIGNMENT_CATEGORY VARCHAR2 32     User defined category. For example Full-Time Permanent or Part-Time Permanent DW_ASSIGNMENT_CATEGORY_D_TL ASSIGNMENT_CATEGORY
LEGISLATION_CODE VARCHAR2 256     Legislation of Assignment DW_LEGISLATION_D_TL LEGISLATION_CODE
PAY_SYSTEM_STATUS VARCHAR2 32     Payroll status indicating whether the assignment is processed in payroll runs.    
PER_SYSTEM_STATUS VARCHAR2 32     HR status used to determine how the assignment is processed    
FULL_PART_TIME_FLAG VARCHAR2 32     Full Part Time Flag    
PERMANENT_TEMPORARY_FLAG VARCHAR2 32     Permanent Temporary Flag    
DUE_DATE DATE       Due Date    
ACCESS_CODE VARCHAR2 32     Access Code DW_CMP_BUDGET_ACCESS_D_TL BUDGET_ACCESS_CODE
EMP_STATUS_CODE VARCHAR2 32     Employee Status Code DW_CMP_EMPLOYEE_STATUS_D_TL EMPLOYEE_STATUS_CODE
MGR_STATUS_CODE VARCHAR2 32     Manager Status Code DW_CMP_MANAGER_STATUS_D_TL MANAGER_STATUS_CODE
APPROVAL_CODE VARCHAR2 32     Approval Code DW_CMP_APPROVAL_D_TL 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    
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    
ANCHOR_DATE DATE       Anchor Date    
PERFORMANCE_DATE DATE       Performance Rating 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     Pay Frequency DW_PAY_FREQUENCY_D_TL PAY_FREQUENCY_CODE
NEW_BASE_SALARY NUMBER       New Base Salary    
PRIOR_SALARY NUMBER       Prior Salary    
GRADE_COMPARATIO NUMBER       Grade Comparatio    
NEW_GRADE_COMPARATIO NUMBER       New Grade Comparatio    
AGE_IN_YEARS NUMBER 38 0   Age in Years of the Worker associated with the Assignment    
AGE_IN_MONTHS NUMBER 38 0   Age in Months of the Worker associated with the Assignment    
TENURE_IN_YEARS NUMBER 38 0   Service Period of the Worker    
TENURE_IN_MONTHS NUMBER 38 0   Person Tenure in Months    
NORMAL_HOUR_FREQUENCY VARCHAR2 32     Frequency of normal working hours:week,month,year    
NORMAL_HOURS NUMBER       Normal working hours    
BARGAINING_UNIT_CODE VARCHAR2 32     Bargaining Unit Code    
PROBATION_PERIOD NUMBER       Duration of probation period    
PROBATION_UNIT VARCHAR2 32     Units of probation period duration    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global Currency Code    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Global currency conversion rate.    
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 VARCHAR2 128     Custom Segment DW_CMP_CUSTOM_SEGMENT_46_D_TL CUSTOM_SEGMENT_46_CODE
CUSTOM_SEGMENT47 VARCHAR2 128     Custom Segment DW_CMP_CUSTOM_SEGMENT_47_D_TL CUSTOM_SEGMENT_47_CODE
CUSTOM_SEGMENT48 VARCHAR2 128     Custom Segment DW_CMP_CUSTOM_SEGMENT_48_D_TL CUSTOM_SEGMENT_48_CODE
CUSTOM_SEGMENT49 VARCHAR2 128     Custom Segment DW_CMP_CUSTOM_SEGMENT_49_D_TL CUSTOM_SEGMENT_49_CODE
CUSTOM_SEGMENT50 VARCHAR2 128     Custom Segment DW_CMP_CUSTOM_SEGMENT_50_D_TL CUSTOM_SEGMENT_50_CODE

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