This helper table captures the assignment last promotion information
Module: Global Human Resources
PROMOTION_DATE, ASSIGNMENT_ID
| 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, 2024, Oracle and/or its affiliates.