Exporting a completed Vendor Risk Assessment questionnaire

[andrewgreen]

We have vendors who are completing our Assessment Questionnaires.  Is there a way to easily export the completed assessment questionnaire with the vendor's responses?

We need the ability to send the completed assessment questionnaire to an internal business user as a PDF, Excel, etc....

[Jan Spurlin · Accepted solution]

Hey guys - Assessment data is stored in multiple tables.  What you probably need to do is to create a database view that combines all the necessary tables and then you will have a source for your export.  But you are talking about combining several tables.

This diagram will get you part of the way there - but I haven't tried to identify the table names where the answers are stored for a specific vendor.  And there is one table missing - the for Assessment Categories - I need to add that to this diagram

[daniellethomson]

Thanks for the view, it is helpful. I was able to get almost everything I need from the Assessment Instance Question table but for some reason in multiple choice responses I can only pull back the value and not the label/answer to those fields. The string field responses work fine. 

I find reporting out of this module to be the most difficult thing I've ever encountered in the platform. Praying to greatly improves. 

[Jan Spurlin]

I understand your frustration, but the system is not designed for users to extract data and avoid license fees... Wouldn't stay in business very long!

The design is geared so that assessments/surveys can be used for a wide variety of applications. In order to do that and keep the design flexible it gets cumbersome when trying to do what you are trying to do.

Having said that - I believe you will find the answers to choice questions in the asmt_metric_definition table.