Questionnaires (Legacy)

How Questionnaire Responses are Stored

Each table with existing questionnaire capability contains a questionnaire response field. This is a memo field with field name typically ending in "_quest". When the questionnaire input is saved, the question names and their answers are stored in XML format and written to the questionnaire response field. This could look something like the following:

<questionnaire questionnaire_id=”New Hire” >
<question quest_name=name_plate value=”Yes” />
<question quest_name=jack_type value=”Fiber” />
</questionnaire>

Note that more than one questionnaire may be stored in one particular storage field. In this way, a single type of inventory record (for example, Move Orders) can have different questionnaires for different Move Order Types(for example, a New Hire, Equipment Move, and Asset Move can have different questions).  However, within one single record,  the results for one single questionnaire are stored.