DW_CMP_CWB_PROMOTION_D

Stores promotions given to employees through compensatoin workbench

Details

Module: Compensation

Key Columns

PROMOTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROMOTION_ID NUMBER 38 0 True Primary Key sequence for Workbench Promotion
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Unique Source Record Identifier This column contains PROMOTION_ID
ASSIGNMENT_ID NUMBER 38 0 Assignment Identifier
PERSON_ID NUMBER 38 0 Person Identifier DW_PERSON_D PERSON_ID
ASG_CHANGE_DATE DATE Assignment Change Date
JOB_ID NUMBER 38 0 Job Identifier DW_JOB_D JOB_ID
POSITION_ID NUMBER 38 0 Position Identifer DW_POSITION_D POSITION_ID
GRADE_ID NUMBER 38 0 Grade Identifer DW_PAY_GRADE_D GRADE_ID