You need to report on both the Compensation Form content and Form Status.
Using the “Form Data: Document ID” as a ‘bridge column’ you can have a comprehensive view of both data and form status (current route step, current step owner…) within the same report.
You can use the document ID of each compensation worksheet to join with the Form Status subdomain schema.
“Form data Document ID” of each compensation worksheet is now available as a bridge column to join compensation planning subdomain schema with Form Status
Allowing you to extract information about worksheet such as current route step, current step owner, and route map.
Using this “inner join”, you can pull additional options for reporting on combined Form Status and Compensation data.
Cross Domain Reporting
Form Status , KBA , LOD-SF-CMP , Compensation Management , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , How To