Role Field in ARM_QUESTIONS table
Summary:
We are building a custom report to show results of a specific reconciliation question. When querying ARM_QUESTIONS field ORDER_SEQ =2, the results show both Preparer and Reviewer question 2 instead of just Preparer question 2. Is there a field specific to the role in the ARM_QUESTIONS table we can use? We are unable to find any in the ARM_TABLES documentation :Tables
SELECT ReconciliationEO.reconciliation_account_id,
ReconciliationEO.reconciliation_name,
CASE ReconciliationEO.STATUS_ID WHEN 32 THEN 'Pending' WHEN 1 THEN 'Closed' WHEN 6 THEN 'Open' WHEN 10 THEN 'Open'ELSE null END AS "Status" ,
((SELECT CASE WHEN FIRST_NAME IS NULL AND LAST_NAME IS NULL THEN USER_LOGIN ELSE FIRST_NAME||' '||LAST_NAME END FROM FCM_USERS WHERE USER_ID = (coalesce(R_PreparerEO.ACTIVE_USER_ID, R_PreparerEO.USER_ID)))) AS "Preparer" ,