HCM Extract in Changes Only run is displaying blank rows
Content
Hello All,
We are using historical UE's in our extract design to get all the employee history records (history, latest and future) information.
Used UE;s: PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE - Root DG
PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE - Child DG
Key Attribute: Assignment_id, Effective_start_date, Effective_end_date and Effective_sequence
Please consider the below test cases.
1. Full Mode - Extract is giving all the records data for each assignment transaction.
For Ex: Person (1001) is having 5 assignment records.
ACTION_CODE | EFFECTIVE_START_DATE | EFFECTIVE_END_DATE |
HIRE | 1/1/15 | 12/31/15 |
ASG_CHANGE | 1/1/16 | 6/30/16 |
POSITION_CHANGE | 7/1/16 | 12/31/16 |
ASG_CHANGE |