Qualtrics
## Columns
| Type | Name | Description |
| -------- | ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| STRING | question\_response\_id | Fivetran-generated unique key hashed on `response_id`, `question_id`, `sub_question_key`, `sub_question_text` , `question_option_key` , `loop_id` and `importId`. |
| STRING | survey\_response\_id | The unique ID for the `SURVEY_RESPONSE`. |
| STRING | survey\_id | The unique identifier for this survey. Match pattern = ^SV\_\[a-zA-Z0-9]{11,15}$ |
| STRING | question\_id | The unique identifier for the question. Match pattern = ^QID\[a-zA-Z0-9]+$ |
| STRING | question\_text | Text for the question. |
| INTEGER | sub\_question\_key | Key of the sub question. |
| INTEGER | sub\_question\_text | Sub question text. |
| INTEGER | question\_option\_key | The key of the `QUESTION_OPTION` that was chosen. |
| INTEGER | value | Value of the question response. |
| INTEGER | loop\_id | ID of the [Loop and Merge](https://www.qualtrics.com/support/survey-platform/survey-module/block-options/loop-and-merge/) object this response is associated with. |
| STRING | distribution\_channel | The method by which the survey was distributed to respondents. |
| INTEGER | survey\_response\_status | The type of response. |
| INTEGER | survey\_progress | How far the respondent has progressed through the survey as a percentage out of 100. |
| INTEGER | duration\_in\_seconds | How long it took for the respondent to finish the survey in seconds. |
| BOOLEAN | is\_finished\_with\_survey | Boolean (stored as int) indicating if the respondent finished and submitted the survey, the value will be 1, otherwise it will be 0. |
| STRING | survey\_finished\_at | The point in time when the survey response was finished. |
| STRING | survey\_response\_last\_modified\_at | The point in time when the record was last modified. |
| DATETIME | survey\_response\_recorded\_at | The point in time when the survey response was recorded. |
| DATETIME | survey\_response\_started\_at | The point in time when the survey response was recorded. |
| STRING | recipient\_email | Email of the [recipient](https://api.qualtrics.com/ZG9jOjg3NzY2OQ-getting-information-about-distributions#the-recipients-object) if they are a single recipient (not a mailing list or sample). |
| STRING | recipient\_first\_name | First name of the [recipient](https://api.qualtrics.com/ZG9jOjg3NzY2OQ-getting-information-about-distributions#the-recipients-object) if they are a single recipient (not a mailing list or sample). |
| STRING | recipient\_last\_name | Last name of the [recipient](https://api.qualtrics.com/ZG9jOjg3NzY2OQ-getting-information-about-distributions#the-recipients-object) if they are a single recipient (not a mailing list or sample). |
| STRING | user\_language | The language of the respondent. |
| STRING | ip\_address | IP address of the recipient. |
| INTEGER | location\_latitude | The approximate location of the respondent at the time the survey was taken. |
| INTEGER | location\_longitude | The approximate location of the respondent at the time the survey was taken. |
| STRING | source\_relation | The schema or database this record came from if you are making use of the qualtrics\_union\_schemas or qualtrics\_union\_databases variables, respectively. Empty string if you are not using either of these variables to union together multiple Qualtrics connectors. |
| INTEGER | recode\_value | Recode/mapping value for the option. |
| STRING | question\_option\_text | Question option text. |
| STRING | first\_name | Contact's first name. |
| STRING | last\_name | Contact's surname. |
| STRING | email\_domain | Domain of the contact's email address. |
| STRING | contact\_language | The user's default language. |
| STRING | contact\_external\_data\_reference | The external reference for the contact. |
| BOOLEAN | is\_xm\_directory\_contact | Boolean representing whether the contact came from the XM Directory API endpoint (ie stored in the `directory_contact` table). |
| BOOLEAN | is\_research\_core\_contact | Boolean representing whether the contact came from the (to-be-deprecated) Research Core API endpoint (ie stored in the `core_contact` table). |
| STRING | embedded\_data | JSON of Any extra information you would like recorded in addition to the question responses (from the `survey_embedded_data` source table). |
| STRING | survey\_name | Name of the survey. |
| STRING | survey\_status | The distribution status of the survey, or a flag indicating that it's a library blockAllowed values - `Inactive`, `Active`, `Pending`, `LibBlock`, `Deactive`, `Temporary` |
| STRING | project\_category | Project category of the survey.Allowed values - `CORE`, `CX`, `EX`, `BX`, `PX` |
| STRING | project\_type | Type of [Qualtrics project](https://www.qualtrics.com/support/survey-platform/my-projects/my-projects-overview/#SelectingProjectType). Match pattern = ^\[a-zA-Z]+$ |
| STRING | brand\_base\_url | Base url for the organization/brand. |
| STRING | question\_description | Label to identify the question. |
| STRING | question\_type | The type of question. Can be -`MC`,`Matrix`,`Captcha`,`CS`,`DB`,`DD`,`Draw`,`DynamicMatrix`,`FileUpload`,`GAP`,`HeatMap`,`HL`,`HotSpot`,`Meta`,`PGR`,`RO`,`SBS`,`Slider`,`SS`,`TE`,`Timing`,`TreeSelect` |
| STRING | block\_id | The ID of the survey block. Match pattern = ^BL\_\[a-zA-Z0-9]{11,15}$ |
| STRING | block\_description | Description given to the block. |
| INTEGER | block\_question\_randomization | If/how the block questions are randomized. Can be - `false` (no randomization), `RandomWithXPerPage` (randomize all and place X questions in each block), `RandomWithOnlyX` (randomly present only X out of the total questions), or `Advanced` (custom configuration) |
| STRING | block\_type | Type of block. Can be `Trash`, `Default`, or `Standard` |
| INTEGER | block\_visibility | Whether the questions in the block are 'collapsed' or 'expanded' by default. |
| INTEGER | validation\_setting\_force\_response | The response from forcing respondents to answer a question or request that they consider answering the question before leaving the page |
| INTEGER | validation\_setting\_force\_response\_type | The type of response from forcing respondents to answer a question or request that they consider answering the question before leaving the page |
| STRING | validation\_setting\_type | The type of forced response validation that is set. |
| BOOLEAN | is\_question\_deleted | Boolean representing whether the record was soft-deleted in Qualtrics. |
| BOOLEAN | is\_block\_deleted | Boolean representing whether the record was soft-deleted in Qualtrics. |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/qualtrics-response.md?ask=