DW_WRKFRC_ASG_EVENT_H

This helper table captures the assignment last promotion information

Details

Module: Global Human Resources

Key Columns

PROMOTION_DATE, ASSIGNMENT_ID

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