What Service Catalog database table contains the approval user information for a request

Document ID : KB000110088
Last Modified Date : 08/08/2018
Show Technical Document Details
Question:
I'd like to review the database to determine which approval users are assigned to requests. What database table contains this information?
Answer:
This information is stored in the following table:

usm_request_pending_action

The request information is located in the "request_id" table, and the user assigned is in the "user_id" field.
Additional Information:
Further information on the database table is located here:

https://docops.ca.com/ca-service-management/14-1/en/using/service-catalog-management/manage-events-rules-actions/event-parameters

https://support.ca.com/phpdocs/0/common/impcd/r11/MDBMain/Schema152/Tables/usm_request_pending_action.html