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 store the representatives that are assigned to each employee?

Received Response


I have been tasked with creating either an OTBI analysis or BI Publisher report to pull all employees and the representatives that have been assigned/linked to them. By "representatives", I mean the ones that show when you click on the headset icon after calling up an employee via My Client Groups > Person Management.

Content (required):

I have created a fabricated a list of representatives that would display for pretend employee Tes Thomas below. My report would need to show Tes Thomas and then all of the representative information shown in the below snip-it. I was not able to find a subject area with this information. If you are aware of one, please let me know. If a subject area does not exist, then I would be fine with creating a BI Publisher report, but I need help in finding the table(s) that track the representative information that is linked to each employee.

Howdy, Stranger!

Log In

To view full details, sign in.


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