on 10-15-2014 5:25 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 |
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.