Is it possible to query the AVDB and retrieve the monitors for each review?
I tried the review definition table which has a monitor but that value is same as the review owner even though the review has multiple monitors set.
SELECT
user_id, first_name, last_name
FROM
PV_USERS
WHERE ID IN (SELECT monitor FROM T_AV_ENTITLEMENTREVIEWDEF)
Hi Pradeep, the actual monitors are only calculated at the time of review generation because the monitor list can change based on generated review. For example if you have supervisors of users as monitors, the monitor list will depend on what users are included in the review and who their supervisors are at that time. So, such monitor list can not be resolved before generating the review.
The monitor list would remain constant for the case you displayed where you explicitly pick the users as monitors for entire review. Till the review is generated, this list of users as well is only stored in an xml configuration. Check out the column alt_monitor_def on review definition table t_av_entitlementreviewdef