IR Q Answer View
The IR_QAnswer view contains answers to a question on a questionnaire.
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| QAnswerId | uniqueidentifier (16) | False | No | ID of the answer. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| QFormId | uniqueidentifier (16) | False | No | ID of the form that contains this answer. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| QQuestionId | uniqueidentifier (16) | False | No | ID of the question that was answered. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| Sequence | int (4) | False | No | Sequence number of the answer within the form. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| Score | numeric (9) | True | No | Score given to the answer. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| RawAnswer | nvarchar (1024) | True | Depends on customer usage | Raw text input of the answer. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| UserComments | nvarchar (1024) | True | Depends on customer usage | Comments provided with the answer. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| IsMarkedNA | tinyint (1) | False | No | Was the answer marked N/A? One if true else zero. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| Version | int (4) | False | No | Version of the database row. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| RecordingDate | datetime2 (8) | False | No | Time the recording was made. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| QANSWERID | raw (16) | False | No | ID of the answer. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| QFORMID | raw (16) | False | No | ID of the form that contains this answer. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| QQUESTIONID | raw (16) | False | No | ID of the question that was answered. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| SEQUENCE | number (22) | False | No | Sequence number of the answer within the form. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| SCORE | number (22) | True | No | Score given to the answer. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| RAWANSWER | nvarchar2 (2048) | True | Depends on customer usage | Raw text input of the answer. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| USERCOMMENTS | nvarchar2 (2048) | True | Depends on customer usage | Comments provided with the answer. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| ISMARKEDNA | number (22) | False | No | Was the answer marked N/A? One if true else zero. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| VERSION | number (22) | False | No | Version of the database row. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |
| RECORDINGDATE | timestamp (11) | False | No | Time the recording was made. |
17.4.0.0 | Added for data extraction from IR_QAnswer table. |