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
| 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 |