DW_WRKFRC_ASG_EVENT_H

This helper table captures the assignment last promotion information

Details

Module: Global Human Resources

Key Columns

ASSIGNMENT_ID, PROMOTION_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ASSIGNMENT_ID NUMBER 38 0 True Assignment identifier    
PROMOTION_DATE DATE     True Date on which the person got promoted for that particular assignment    
NEXT_PROMOTION_DATE DATE       Next promotion date    
HIRE_EVENT_IND NUMBER 38 0   Hire Event Indicator    
PROMOTION_EVENT_IND NUMBER 38 0   Promotion Event Indicator    

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