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

What tables contain labor schedules for labor distribution?

in Payroll and Global Payroll Interface (GPI)

Summary:

What tables contain labor schedules for labor distribution? These are available via OTBI, but I'm needing to query this from BI Publisher to create a more comprehensive report than what OTBI can offer.

Content (please ensure you mask any confidential information):

I'm needing to write a detailed report from BI Publisher that will be run semi-annually. We're using Labor Distribution and have schedules assigned to each employee for Payroll costing. The schedules can be queried easily in OTBI using the "Projects - Labor Schedule Analysis Real Time" Subject Area, but I'm struggling to locate the tables that contain this data in BI Publisher. The labor schedule table that is most apparent is an interface table. I've searched tables in both Projects and HCM, but can't figure out where it's stored. I'm needing a table that contains

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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