Obtaining the Preparer/Reviewer from the database
Hi All,
We have begun reporting some of our ARM information from a data warehouse attached to the ARM schema in our database. I've been trying to figure out a way to pull the preparer/reviewer details of a rec before it has been completed by the users. There is an ARM_Workflow_Actions table that contains the preparer/reviewer, but only after the user has completed their step in the period. I was curious if anyone has figured out a way to pull these details before the user completes their assigned task. Thank you in advance for your help!