You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI report - Worker Assignment Status

edited Oct 14, 2017 4:38PM in Reporting and Analytics for HCM 10 comments

Content

I am creating a BI report and I need to show Assignment Status just like how it is showing in OTBI as follows:

Active - Payroll Eligible
Leave - No Payroll
Leave - Payroll Eligible
Terminated - No Payroll
Terminated - Payroll Eligible

I checked the ASSIGNMENT_STATUS_TYPE  in the table  PER_ALL_ASSIGNMENTS_M  and it contains only values 'ACTIVE, INACTIVE, SUSPENDED' . How can I get the same values as the one in OTBI ? Is it in another table or do I have to map it with another column?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!