Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 16, 2014 at 02:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

      GRACFFLOGDetails related to Firefighter ID Log On InformationGRACFFCTRLMaintain assignment of FF ID or Role to ControllersGRACFFREPMAPPFFLOG and Repository Mapping for FirefightersGRFNMWRTAPPRMSMP Runtime - Current Approvers for Line ItemGRACREQRequest ID, Request number, Request Created Date DetailsGRACREQOWNERRequest Owner Details