# 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, 2026, Oracle and/or its affiliates.