WorkerJourneyTasksquestionnaireResponsesquestionResponses
WorkerJourneyTasksquestionnaireResponsesquestionResponses
Columns
Name | Type | Description |
WorkerJourneyTasksWorkerJourneyTaskId [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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
CategoryFilter | String | CategoryFilter |
Facets | String | Facets |
RequiredFilter | String | RequiredFilter |
SearchTerms | String | SearchTerms |
StatusFilter | String | StatusFilter |
WorkerJourneyTaskId | Long | WorkerJourneyTaskId |
Finder | String | finder |