ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Fields from the Responses worksheet
3
4
Instructions for completing the Responses worksheet.
5
6
FieldDescriptionExpected Content
7
QuestionQuestionField completed automatically. Modifications in this field will generate conflicts when the spreadsheet is imported.
8
DescriptionQuestion description.Field completed automatically. Modifications in this field will generate conflicts when the spreadsheet is imported.
9
ResponseResponse provided to the question.Enter a response to the question. See information below on how to complete each type of question.
10
JustificationJustification provided to the questionEnter a justification to the question. See information below on how to complete each type of question.
11
Question TypeQuestion Type, based on which you can add responses accordingly.Field completed automatically. Modifications in this field will generate conflicts when the spreadsheet is imported.
12
13
Note: Only complete fields from the Response column. Values from other fields are informational only and modifications will result in the question not being recognized by the system.
14
15
Accepted values for fields from the Responses worksheet
16
17
18
Type of Question/ItemResponse ExampleJustification
19
DateEnter a date in the YYYY-MM-DD format.
Format: 2019-06-19.		N/A
20
MultiChoice - multiple answerList comma delimited, with space. Example: Answer1, Answer2, Answer3
(Copy responses from "Assessment Response Options" tab)		Supported
21
MultiChoice - single answerSelect the response option from pick list in the Response column.
Example: Answer 1		Supported
22
TextThis type of question accepts free text.N/A
23
StatementThis field should not be completed.N/A
24
Attribute DateEnter a date in the YYYY-MM-DD format.
Format: 2019-06-19.		N/A
25
InventoryIf user makes any change in inventory question response other than it is visible on UI/or exported in excel, then that will be considered invalid.N/A
26
Looped Attribute (where parent question is multiselect)This type of question accepts multiple responses separated by semicolon.Not supported; this question can only be updated directly in the assessment.
27
Personal DataNot supported; this question can only be updated directly in the assessment.Not supported; this question can only be updated directly in the assessment.
28
ControlsNot supported; this question can only be updated directly in the assessment.Not supported; this question can only be updated directly in the assessment.
29
Advanced AttributeNot supported; this question can only be updated directly in the assessment.N/A
30
ContractContract responses must be responded to on the UI and exported to Excel. Only contract attributes can be updated via export templatesNot supported; this question can only be updated directly in the assessment.
31
EngagementEngagement responses must be responded to on the UI and exported to Excel. Only engagement attributes can be updated via export templatesNot supported; this question can only be updated directly in the assessment.
32
Assess_Control and Its attributesNot supported; this question can only be updated directly in the assessment.N/A
33
Relationship and Its attributesNot supported; this question can only be updated directly in the assessment.N/A
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100