This dimension captures the Compensation Worksheet Person Info Details
Module: Compensation
PERSON_EVENT_ID
| 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 |
Copyright © 2019, 2024, Oracle and/or its affiliates.