SupplierQualificationsResponses
Returns the supplier responses submitted for qualification initiatives.
Columns
| Name | Type | SupportedFinders | Description |
| SupplierQualificationsQualificationId [KEY] | Long | Value that uniquely identifies the qualification. | |
| QualResponseId [KEY] | Long | Value that uniquely identifies the qualification response. | |
| QualificationId | Long | PrimaryKey | Value that uniquely identifies the qualification. |
| QuestionId | Long | Value that uniquely identifies the Question. | |
| ResponseRepositoryId | Long | A value that uniquely identifies a response from response repository. | |
| ResponseStatusCode | String | Code to specify the response status. | |
| ResponseStatus | String | Indicates the status of the response to a question. | |
| ResponseDate | Datetime | Indicates the date when the response was submitted. | |
| ResponseComments | String | Indicates the text value of manually added qualification comments. | |
| OriginalQuestionId | Long | Indicates the original question for the question revision for which this is a response. | |
| QuestionRevision | Int | Revision number of the question. | |
| QuestionName | String | Name of the question. | |
| QuestionText | String | Text of the question to be displayed to responders of a questionnaire. | |
| ResponderTypeCode | String | Code to specify the responder type. | |
| ResponderType | String | Indicates whether the question responder is a supplier or an internal user. | |
| QuestionTypeCode | String | Code to specify the question type. | |
| QuestionType | String | Indicates the type of question. | |
| DisplayPreferredResponseFlag | Bool | Indicates whether there is a preferred response. | |
| ResponseRequiredFlag | Bool | Indicates whether the response is required for the question. | |
| SupplierAttributeCode | String | Code to uniquely identify the supplier attribute that the question is mapped to. | |
| SupplierAttributeName | String | Indicates the supplier attribute that the question is mapped to. | |
| ResponseTypeCode | String | Code to indicate the response type for questions of text entry box type. | |
| ResponseType | String | Indicates the response type for questions of text entry box type, such as text, number or date. | |
| PreferredResponseDate | Date | Value of the preferred response in Date format. | |
| PreferredResponseDatetime | Datetime | Value of the preferred response in Date and Time format. | |
| PreferredResponseNumber | Decimal | Value of the preferred response in Number format. | |
| PreferredResponseText | String | Value of the preferred response in Text format. | |
| PreferredAcceptableResponseText | String | Preferred text for a response value. | |
| SupplierAttributeCategoryCode | String | Code to uniquely identify the supplier products and services category. | |
| SupplierAttributeCategory | String | Indicates the supplier products and services category. | |
| ResponseHistoryFlag | Bool | Indicates whether there is a response history for the question. | |
| QuestionAttachmentExistsFlag | Bool | Indicates whether there is a question attachment. | |
| QuestionLevelCode | String | Code to specify the question level. | |
| QuestionLevel | String | Indicates whether the question is relevant to a supplier or to a supplier site. | |
| EvaluationNote | String | Indicates the comments provided by the evaluator in response to a question. | |
| ResponseScore | Decimal | A value that indicates the calculated response score of parent questions in a qualification. | |
| ReassignedWeight | Decimal | Value that identifies the reassigned weight of a question after one or more questions in the qualification was excluded from scoring. | |
| ScoringMethodCode | String | Indicates the code used to identify the scoring method to be used for this question. | |
| AcceptanceNote | String | Indicates the comments provided by the acceptor in response to a question. | |
| CriticalQuestionFlag | Bool | Indicates whether a question is critical for evaluation. | |
| ScoringMethod | String | Specifies the scoring method used for a question. The system validates the scoring method against the lookup FND_LOOKUP for POQ_QUESTION_SCORING_METHOD. | |
| MaximumScore | Decimal | Maximum score for the question. | |
| ResponseSubmissionDate | Datetime | Indicates the date the responder submitted the response to the question. | |
| WeightedScore | Decimal | Indicates the weighted score calculated for the question in the qualification process. | |
| QuestionWeight | Decimal | Indicates the importance of the question in the qualification area. It's used to calculate the overall score of the qualification. | |
| KnockoutScore | Decimal | Specifies the knockout score for the question when the question has a scoring type of automatic or manual. | |
| FromUI | String | Indicates whether the response is provided by a REST resource or through Oracle Visual Builder Cloud Service. | |
| Bind_InitiativeId | Long | FindExistingQualifications | The qualification initiative identifier supplied as an input parameter to filter the responses returned. |
| Bind_QualFetchType | String | FindExistingQualifications | The qualification fetch type supplied as an input parameter that controls which qualification responses are returned. |
| Bind_SupplierId | Long | FindExistingQualifications | The supplier identifier supplied as an input parameter to filter the responses returned. |
| Bind_SupplierSiteId | Long | FindExistingQualifications | The supplier site identifier supplied as an input parameter to filter the responses returned. |
| Finder | String | A named finder reference used to filter or locate specific supplier qualification responses when querying. |