Role Field in ARM_QUESTIONS table — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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" ,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!