WorkerJourneystasksquestionnaireResponsesquestionResponses
WorkerJourneystasksquestionnaireResponsesquestionResponses
Columns
| Name | Type | Description |
| WorkerJourneysWorkerJourneyId [KEY] | Long | Unique identifier of the journey. |
| TasksWorkerJourneyTaskId [KEY] | Long | Unique identifier of the journey task. |
| QuestionnaireresponsesQuestionnaireResponseId [KEY] | Long | Unique identifier for the questionnaire response. |
| QuestionResponseId [KEY] | Long | Surrogate identifier for the question response. |
| QuestionnaireQuestionId | Long | Surrogate identifier for the question in a questionnaire. |
| QuestionId | Long | Surrogate identifier for the question. |
| QuestionCode | String | Alphanumeric value that uniquely identifies a question defined for a subscriber. |
| QuestionText | String | Text of the question that a participant responds to. |
| QuestionAnswerId | Long | Surrogate identifier of the answer that a participant chose when responding to a single choice question. |
| AnswerCode | String | The answer code that a participant chose when responding to a single choice question. |
| AnswerShortdescription | String | Text of the answer chosen by a participant when responding to a single choice question. |
| AnswerList | String | Concatenated list of answer identifiers, separated by a semicolon as a delimiter, which is selected by the participant when responding to a multiple choice question. |
| AnswerCodeList | String | Concatenated list of answer choices, separated by a semicolon as a delimiter, which is selected by the participant when responding to a multiple choice question. |
| AnswerShortDescriptionList | String | Concatenated list of answer texts, separated by a semicolon as a delimiter, which is selected by the participant when responding to a multiple choice question. |
| Score | Long | Calculated score for the responses provided for a question by a participant. |
| AnswerLargeObject | String | Attachment provided by the participant when responding to a question. |
| ChoiceList | String | Concatenated list of answer identifiers, separated by a semicolon as a delimiter, which are presented to the participant when responding to a question enabled for random order responses. |
| ChoiceCodeList | String | Concatenated list of answer codes, separated by a semicolon as a delimiter, which are presented to the participant when responding to a question enabled for random order responses. |
| ChoiceShortDescription | String | Concatenated list of answer texts, separated by a semicolon as a delimiter, which are presented to the participant when responding to a question enabled for random order responses. |
| CreatedBy | String | User who created the question response. |
| CreationDate | Datetime | Date on which the question response was created. |
| LastUpdatedBy | String | User who last updated the question response. |
| LastUpdateDate | Datetime | Date on which the question response was updated. |
| AnswerComments | String | Additional comments provided by the participant when responding to a question. |
| QuestionResponseAttachments | String | questionResponseAttachments |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AllocatedAfterDate | Date | AllocatedAfterDate |
| AssignmentId | Long | AssignmentId |
| CategoryFilter | String | CategoryFilter |
| CodeFilter | String | CodeFilter |
| Context | String | Context |
| ContextualAction | String | ContextualAction |
| Facets | String | Facets |
| JourneyId | Long | JourneyId |
| Overdue | String | Overdue |
| PersonId | Long | PersonId |
| SearchTerms | String | SearchTerms |
| StatusCategory | String | StatusCategory |
| StatusFilter | String | StatusFilter |
| SubCategoryFilter | String | SubCategoryFilter |
| WorkerJourneyId | Long | WorkerJourneyId |
| Finder | String | finder |