QuestionnaireQuestionsLOV
QuestionnaireQuestionsLOV
Columns
Name | Type | Description |
QuestionnaireQuestionId [KEY] | Long | System-generated primary key for the question in a questionnaire definition. |
QuestionnaireCode | String | Alphanumeric code that uniquely identifies a questionnaire defined for a subscriber. |
QuestionCode | String | User-defined identifier of the question definition. |
QuestionText | String | Text displayed as the question in the questionnaire. |
QuestionId | Long | System-generated primary key for the question definition. |
QuestionVersionNumber | Long | Version number of the question. |
QuestionType | String | Type of the question such as Single Choice, Multiple Choice, Text, or No Response. |
AdhocQuestion | String | Indicates whether the question is an additional question added by a person requesting a response to the questionnaire. If the value is Y, the question is displayed only to specific participants as part of specific requests. If the value is N, the question is displayed to all participants for all requests. |
AttachmentAllowed | String | Indicates whether the question is supported by attachments from the respondent. Valid values are Y and N. |
Mandatory | String | Indicates whether the respondent needs to answer a question in a questionnaire. Valid values are Y and N. |
MaximumLength | String | Minimum number of characters that the respondent must provide when answering a text type of question. |
MinimumLength | Long | Maximum number of characters that the respondent can provide when answering a text type of question. |
MaximumSelections | Long | Minimum number of choices that the respondent must select when answering a multiple choice type of question. |
MinimumSelections | Long | Maximum number of choices that the respondent can select when answering a multiple choice type of question. |
CreatedBy | String | User who added the question to the questionnaire definition. |
CreationDate | Datetime | Date and time of addition of the question to the questionnaire definition. |
LastUpdateDate | Datetime | Date and time of update of the question in the questionnaire definition. |
LastUpdatedBy | String | User who last updated the question in the questionnaire definition. |
QuestionSequenceNumber | Long | Sequence number of a question in the questionnaire and section definitions. |
QuestionnaireId | Long | Surrogate identifier of the questionnaire. |
SectionSequenceNumber | Long | Sequence number of the sections in a questionnaire definition. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Finder | String | finder |