The Question Responses template contains all of the fields that can be loaded via the Data Load Wizard.
Multiple Choice Responses Validation: When loading response choices for a multiple choice question, the total number of responses that are available for the question (available within the system and being loaded) must be greater than or equal to the Multiple Choice Answers to Always Display value for the question, which is set at the question level.
Multiple Choice Responses Validation: When loading response choices for a multiple choice question, the total number of responses that are set to always display for a question must be less than or equal to the Multiple Choice Answers to Always Display value for the question, which is set at the question level.
The Question Responses template contains the following data fields:
| System Field | Type | Limit | Comments/Rules |
|---|---|---|---|
| Question Reference Number | String | 50 | This field is required. This is the reference number for the question for which the multiple choice responses are being loaded. The corresponding question must have a response type of Multiple Choice/Multiple Response or Multiple Choice/Single Response. |
| Response Order | Integer | 6 | This field is required. This specifies the order of the responses for multiple choice questions. This order serves as the identifier for each response. If a response or correct answer for a question is updated, the Response Order value must be referenced. The Response Order must be unique per response choice within a question. Also, the Response Order must be a sequence of numbers (e.g., 1, 2, 3), and the sequence can have gaps (e.g., 1, 3, 8). Duplicate Response Order numbers are not supported within the same question. |
| MC Response Choice/Text Correct Answer | String | 500 | This field is required. When the question type is Multiple Choice, these values are the multiple choice options that are displayed to the user. When the question type is Text Only, then this is the correct answer for the question. Values can be localized. This must be set to Null when the Response Type is not Multiple Choice or Text Only. |
| Multiple Choice Correct Response | Boolean or Text | 1000 |
This indicates whether the response choice is the correct answer for a multiple choice question.
Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive. |
| Always Display Response | Boolean | Select this option to always display the option as a response choice. This only applies if Random Answer Selection is set to True for the question and not all choices are displayed. Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive. This must be set to Null when the Response Type does not equal Multiple Choice/Single Answer or Multiple Choice/Multiple Answer. | |
| Culture ID | String | This field is optional. This is the language for which the question is localized (translated). This must be a valid Culture ID. Please refer to the Data Mapping Report by selecting the Data Mapping Report link on the Upload page for a list of valid Culture IDs. | |
| Delete | Boolean | This field is optional. When this field is set to True, then the response choice will be deleted from the system. Responses cannot always be deleted. See Load Question Data - Considerations. Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive. |