Workforce Management - Worker Assignment Event Real Time - Assignment FTE

Summary:

We want to achieve below requirement using OTBI.

Can we get FTE and leaving reason from the same SA or need to join other SA to get the data ?

Can we get Assignment data as of termination date?

Filters/criteria:

• Person type = Employee.

• Person left employment (i.e., all active assignments ended) between 1 August 2022 and 31 July 2023 inclusive.

• Assignment data must be as it existed at the end of the assignment.

 

Required fields:

• Person Number

• Person First Name 

• Person Surname

• Employee start date

• Employee leave date

• Assignment Number

• Assignment Start Date

• Assignment End Date

• Department Tree levels

• Assignment Job Title