SupplierQualificationQuestions
Defines the questions used in supplier qualification, covering areas like safety standards or financial viability.
Columns
| Name | Type | Description |
| QuestionId [KEY] | Long | Unique identifier for the question. This ID is used to reference the specific question in the system. |
| Revision | Int | Number that identifies the revision of this question. Revision 0 is the base revision, and subsequent revisions are created as updates to the original question. |
| Question | String | The question text or identifier entered by the user. This is the actual question to be displayed to responders. |
| QuestionLevelCode | String | Abbreviation that identifies whether the question is relevant to a supplier or to a supplier site. Accepted values are defined in the lookup type 'POQ_QUESTION_LEVEL'. This can be reviewed in the Setup and Maintenance work area, in the Manage Standard Lookups task. |
| QuestionLevel | String | The level at which the question is relevant, either to the supplier or to the supplier site. |
| ResponderTypeCode | String | Abbreviation identifying the type of responder for the question. Valid values are 'SUPPLIER', 'INTERNAL', or 'AUTOMATIC'. Refer to the lookup type 'POQ_RESPONDER_TYPE' for accepted values, available in the Setup and Maintenance work area. |
| ResponderType | String | Value identifying the type of responder for the question. Valid types include 'SUPPLIER', 'INTERNAL', or 'AUTOMATIC'. |
| SupplierAttributeFlag | Bool | Indicates whether the question is mapped to an attribute from the supplier profile. If true, it is mapped; if false, it is not. The default value is false. |
| SupplierAttributeCode | String | Abbreviation identifying the supplier attribute this question is mapped to. Valid values include 'ADDITIONAL_INFORMATION', 'BUSINESS_CLASSIFICATION', 'CORPORATE_PROFILE', 'INCOME_TAX', 'PRODUCTS_AND_SERVICES', 'SUPPLIER_SITE', or 'TRANSACTION_TAX'. |
| SupplierAttribute | String | The specific supplier attribute that this question is mapped to. |
| QuestionTypeCode | String | Abbreviation identifying the type of question. Valid values are 'MCSS' (multiple choice single selection), 'MCMS' (multiple choice multiple selection), or 'INPUT_BOX' (text entry box). Refer to the lookup type 'POQ_QUESTION_TYPE' for valid values. |
| QuestionType | String | The type of question, such as 'multiple choice single selection', 'multiple choice multiple selection', or 'text entry box'. |
| QuestionStatusCode | String | Abbreviation identifying the status of the question. Accepted values are defined in the lookup type 'POQ_QUESTION_STATUS'. This can be reviewed in the Setup and Maintenance work area. |
| QuestionStatus | String | Value identifying the current status of the question (for example, 'ACTIVE', 'INACTIVE'). |
| OwnerId | Long | Unique identifier for the owner of the question. This identifies who owns or is responsible for the question. |
| Owner | String | Name of the owner of the question. |
| DisplayPreferredResponseFlag | Bool | Indicates whether the preferred response should be displayed to the supplier, if available. If true, it is displayed; if false, it is not. Default is false. |
| CriticalQuestionFlag | Bool | Indicates whether the question is critical for evaluation. If true, the question is critical for assessment; if false, it is not. Default is false. |
| ResponseRequiredFlag | Bool | Indicates whether a response is required for this question. If true, a response must be provided; if false, it is optional. Default is true. |
| AllowResponderCommentsFlag | Bool | Indicates whether the responder can provide free text comments when responding to the question. If true, comments can be entered; if false, they cannot. Default is false. |
| QuestionText | String | The full text of the question as it will be displayed to responders on a questionnaire. For POST operations, this should be in Base64 encoded format. |
| QuestionHint | String | Additional information or instructions provided to responders to help them answer the question correctly. |
| SubjectCode | String | Abbreviation identifying the subject associated with the question for search purposes. Accepted values are defined in the lookup type 'POQ_SUBJECT'. This can be reviewed in the Setup and Maintenance work area. |
| Subject | String | The subject associated with the question, used for search filtering. |
| StandardsOrganizationCode | String | Abbreviation identifying the standards organization that provides the source for this requirement. Accepted values are defined in the lookup type 'POQ_STDS_ORG'. This can be reviewed in the Setup and Maintenance work area. |
| StandardsOrganization | String | The standards organization that provides the source for the requirement. |
| ResponseTypeCode | String | Abbreviation identifying the type of response expected for the question, specifying the data type. Accepted values are defined in the lookup type 'POQ_RESPONSE_TYPE'. This can be reviewed in the Setup and Maintenance work area. |
| ResponseType | String | The type of response expected, such as 'single-line text', 'multiple-line text', 'number', 'date', 'datetime', or 'URL'. |
| PreferredResponseDate | Date | The preferred response value for questions where the response type is date. |
| PreferredResponseDatetime | Datetime | The preferred response value for questions where the response type is date and time. |
| PreferredResponseNumber | Decimal | The preferred response value for questions where the response type is a number. |
| PreferredResponseText | String | The preferred response value for questions with text-based responses (single-line, multi-line text, or URL). |
| ScoringMethodCode | String | Abbreviation identifying the scoring method for the question. Default value is 'NONE'. Accepted values are defined in the lookup type 'ORA_POQ_QUES_SCORING_METHOD'. This can be reviewed in the Setup and Maintenance work area. |
| ScoringMethod | String | The method used for scoring the question, such as 'NONE' for no scoring, 'MANUAL' for manual scoring, or other predefined methods. |
| MaximumScore | Int | The maximum score a responder can achieve for the question. This is used when the question is manually or automatically scored. |
| ScoreForNoResponse | Int | The score automatically assigned to optional questions when no response is provided. |
| ScoringApproachCode | String | Abbreviation identifying the scoring approach for this question. Accepted values are defined in the lookup type 'ORA_POQ_QUES_SCORING_APPROACH'. This can be reviewed in the Setup and Maintenance work area. |
| ScoringApproach | String | The approach used for scoring, such as 'Automatic' for multiple-choice questions, or other predefined approaches. |
| AttachmentAllowedCode | String | Abbreviation that identifies whether responders can attach documents with their responses. Accepted values are defined in the lookup type 'POQ_QUESTION_RESPONSE_ATTACH'. This can be reviewed in the Setup and Maintenance work area. |
| AttachmentAllowed | String | Indicates whether responders are allowed to attach documents when submitting their responses. Values include 'Not Allowed', 'Optional', or 'Required'. |
| LatestRevisionFlag | Bool | Indicates whether the revision is the latest revision of the question. If true, it is the latest; if false, it is not. Default is false. |
| QuestionPlainText | String | Plain text version of the question to be displayed to responders. |
| QuestionSurveyFlag | Bool | Indicates whether the question is part of a survey with multiple internal responses. If true, multiple responses are allowed; if false, only a single response is allowed. Default is false. |
| Finder | String | Search term or keyword to locate the question easily in the system. |