What table in the database stores form table data?

Document ID : KB000013046
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

What table in the database stores form table data?

Answer:

All form data is stored in usm_request_item_form table for forms that are associated to offerings. A query similar to the following can be leveraged to return form data for a specific request: 

select * from usm_request_item_form where subscription_detail_id in (select id from usm_subscription_detail where request_id=<request id>) 

Data entered into the 'Request Information' form is stored in usm_request_value table.