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

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