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

Identifying the Main Legal Reporting Unit via BI

Accepted answer
25
Views
1
Comments
edited Feb 14, 2023 3:22PM in Reporting and Analytics for HCM 1 comment

Summary:

Identifying the Main Legal Reporting Unit via a SQL query.

Content (required):

Hello experts,

We have multiple LRUs, and TRUs, setup for our implementation, and were looking to extract the data out via a quick BI report to verify the setups.

We are looking to pull the primary or the main legal reporting unit, and the 'sub-units' that fall under the legal employer. We've managed to to pull all the below 3 records via a simple query, but weren't able to identify the 'Main Legal Reporting Unit' among the 3 of them.

Would we know the table / column / joins where this info might reside?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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