Identifying the Main Legal Reporting Unit via BI
Identifying the Main Legal Reporting Unit via a SQL query.
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?