develop an extract that captures the details of EMP as on effective date and also capture 2 years of
Summary
develop an extract that captures the details of EMP as on effective date and also capture 2 years of history for only those employees who have been terminatedContent
Hi Experts,
I need to develop an extract that captures the details of EMP as on effective date and also capture 2 years of history for only those employees who have been terminated.Can I use the RESET_UE over here?
This UE: PER_EXT_ASSIGNMENT_BASIC_HISTORY_UE can give me the details but then how do you suggest I single out History records only for terminated employees?
The extract would be a Changes-only file running on Effective date everyday.
Tagged:
0