Questionsanswers
Questionsanswers
Columns
| Name | Type | Description |
| QuestionsQuestionId [KEY] | Long | QuestionsQuestionId of Questionsanswers |
| QuestionsVersionNumber [KEY] | Long | QuestionsVersionNumber of Questionsanswers |
| QuestionAnswerId [KEY] | Long | QuestionAnswerId of Questionsanswers |
| AnswerCode | String | Alphanumeric value that uniquely identifies the answer choice for a subscriber. |
| CorrectFlag | Bool | Indicates whether the answer choice is correct or incorrect for a question. |
| Score | Long | Score for the answer choice. |
| ShortAnswerText | String | Short text of the answer choice. |
| ResponseFeedback | String | Feedback provided to the participant when the answer choice is chosen. |
| RatingLevelId | Long | Surrogate identifier of the rating level from which the answer choice is created. |
| RatingLevelName | String | RatingLevelName of Questionsanswers |
| CreatedBy | String | CreatedBy of Questionsanswers |
| CreationDate | Datetime | CreationDate of Questionsanswers |
| LastUpdatedBy | String | LastUpdatedBy of Questionsanswers |
| LastUpdateDate | Datetime | LastUpdateDate of Questionsanswers |
| LongAnswerText | String | Answer text presented to the participant as a choice for a question when responding to a questionnaire. |
| SequenceNumber | Long | Sequence in which the answer choice is presented during response by a participant. |
| AddlQuestionnaireId | Long | Surrogate identifier of the questionnaire sent to candidates from whom additional information is requested. Used only for the Recruiting subscriber. |
| AddlQuestionnaireVersionNumber | Long | Version number of the additional questionnaire sent to the participant. Used only for the Recruiting subsciriber. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| QuestionId | Long | QuestionId |
| VersionNumber | Long | VersionNumber |
| Finder | String | finder |