Questionnairessectionsquestions
Questionnairessectionsquestions
Columns
| Name | Type | Description |
| QuestionnairesQuestionnaireId [KEY] | Long | QuestionnairesQuestionnaireId of Questionnairessectionsquestions |
| QuestionnairesVersionNumber [KEY] | Long | QuestionnairesVersionNumber of Questionnairessectionsquestions |
| SectionsSectionId [KEY] | Long | SectionsSectionId of Questionnairessectionsquestions |
| QuestionnaireQuestionId [KEY] | Long | QuestionnaireQuestionId of Questionnairessectionsquestions |
| QuestionId | Long | Surrogate identifier of the question. |
| QuestionCode | String | Question code for the question used in the questionnaire template section. Valid values are defined in the list questionsLOV. |
| QuestionText | String | QuestionText of Questionnairessectionsquestions |
| VersionNumber | Long | Version number of the question in the questionnaire. |
| QuestionType | String | QuestionType of Questionnairessectionsquestions |
| QuestionTypeMeaning | String | QuestionTypeMeaning of Questionnairessectionsquestions |
| ResponseType | String | Response type for the question when presented to the participant. Valid values are defined in the questionnaireResponseTypesLOV. |
| ResponseTypeMeaning | String | ResponseTypeMeaning of Questionnairessectionsquestions |
| MandatoryFlag | Bool | Indicates whether the response to this question is mandatory. Participants cannot skip this question without an answer. The default value is false. |
| ResponseOrder | String | ResponseOrder of Questionnairessectionsquestions |
| ResponseOrderMeaning | String | ResponseOrderMeaning of Questionnairessectionsquestions |
| SampleSize | Long | SampleSize of Questionnairessectionsquestions |
| ControllingQuestionId | Long | ControllingQuestionId of Questionnairessectionsquestions |
| ControllingQuestionCode | String | ControllingQuestionCode of Questionnairessectionsquestions |
| ControllingAnswerId | Long | ControllingAnswerId of Questionnairessectionsquestions |
| ControllingAnswerCode | String | ControllingAnswerCode of Questionnairessectionsquestions |
| ConditionalDisplayFlag | Bool | ConditionalDisplayFlag of Questionnairessectionsquestions |
| MaximumPossibleScore | Long | MaximumPossibleScore of Questionnairessectionsquestions |
| MaximumThresholdScore | Long | Maximum score limit for the question when the total score is calculated for a response to the question. |
| MinimumThresholdScore | Long | Minimum score limit for the question when the total score is calculated for a response to the question. |
| CreatedBy | String | CreatedBy of Questionnairessectionsquestions |
| CreationDate | Datetime | CreationDate of Questionnairessectionsquestions |
| LastUpdatedBy | String | LastUpdatedBy of Questionnairessectionsquestions |
| LastUpdateDate | Datetime | LastUpdateDate of Questionnairessectionsquestions |
| SequenceNumber | Long | Sequence number of the question in a questionnaire template section. |
| AdhocQuestion | String | AdhocQuestion of Questionnairessectionsquestions |
| LockQuestionFlag | Bool | LockQuestionFlag of Questionnairessectionsquestions |
| Status | String | Status of Questionnairessectionsquestions |
| ResponseMaximumLength | String | ResponseMaximumLength of Questionnairessectionsquestions |
| ResponseMinimumLength | Long | ResponseMinimumLength of Questionnairessectionsquestions |
| MaximumResponses | Long | MaximumResponses of Questionnairessectionsquestions |
| MinimumResponses | Long | MinimumResponses of Questionnairessectionsquestions |
| AllowAttachmentsFlag | Bool | AllowAttachmentsFlag of Questionnairessectionsquestions |
| ScoredFlag | Bool | ScoredFlag of Questionnairessectionsquestions |
| InstructionsText | String | InstructionsText of Questionnairessectionsquestions |
| AllowAdditionalCommentsFlag | Bool | AllowAdditionalCommentsFlag of Questionnairessectionsquestions |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| QuestionnaireId | Long | QuestionnaireId |
| Finder | String | finder |