GRC 10.1 - Table with Controller id and approval status for FF id

[Former Member]

Hi Everyone,

I am trying to find a table that can give me the following information

Request number, Firefighter user, Firefighter ID, Controller ID that reviewed it and approval status.

The firefighter log report review workflow gives me the FF user, system, FF ID and status but not the controller who approved it. I need it for auditing purposes. I can get one controller name at a time for each request approved in the audit log but couldnt find the table that can give me all the information in one place.

Any ideas?

Thank you.

Kiran

[Former Member · Accepted solution]

Hi Kiran,

I don't think if there is any table which can give you themapping of everything..request number..ffid..firefighter user..controller and all.

You would need to combine several tables in order to do so.

Regards,

Ameet

[Former Member · Accepted solution]

Ameet,

Would you be able to share the names of tables that can provide this info?

Thank you!!

Kiran

[madhusap · Accepted solution]

Hi Kiran,

Please check below tables if these can help

GRACFFLOG

GRACFFCTRL

GRACFFREPMAPP

GRFNMWRTAPPR

GRACREQ

GRACREQOWNER

Regards,

Madhu.

[Former Member · Accepted solution]

Thank you

[former_member185447 · Accepted solution]

Hello All,

Just adding the description for the tables since the thread is already resolved this might be helpful for someone who will view this thread.

GRACFFLOG	Details related to Firefighter ID Log On Information
GRACFFCTRL	Maintain assignment of FF ID or Role to Controllers
GRACFFREPMAPP	FFLOG and Repository Mapping for Firefighters
GRFNMWRTAPPR	MSMP Runtime - Current Approvers for Line Item
GRACREQ	Request ID, Request number, Request Created Date Details
GRACREQOWNER	Request Owner Details