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.