For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to get the employees' latest assignment data and the effective start date of the TOS position th
Summary
How to get the employees' latest assignment data and the effective start date of the TOS position through OTBIContent
Hello,
I'm trying to create a report using OTBI where I need to get the employees' latest assignment data with the effective start date of the TOS position.
Ex:
Person_number Effective_start_date Position Assignment_id Location_id
123 01/01/2019 xyz 1a2w qwr
123 12/01/2018 xyz 1a2w qwr
123 08/01/2018 xyz 1a2w qwr
123 01/01/2019 abc 1a2w qwr
From the above example, I would need assignment details as of 01/01/2019 and date when the position xyz started i.e. 08/01/2018.
Thank You,
Rajesh