This table stores mapping information about initiatives and questionaire responses
Module: Supplier Model
QUESTNAIRE_RESP_HEADER_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| QUESTNAIRE_RESP_HEADER_ID | NUMBER | 38 | 0 | True | Internal system identifier for a questionnaire response. | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. System generated identifier | |||
| QUESTNAIRE_ID | NUMBER | 38 | 0 | Identifier of questionnaire | DW_QUESTNAIRE_QUESTION_MAP_G | QUESTNAIRE_ID | |
| SUPPLIER_ID | NUMBER | 38 | 0 | Identifier of the Supplier who is being responded. | DW_SUPPLIER_D | SUPPLIER_ID | |
| SUPPLIER_SITE_ID | NUMBER | 38 | 0 | Identifier of the Supplier site. | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID | |
| INITIATIVE_ID | NUMBER | 38 | 0 | Unique identifier for initiative. | |||
| INITIATIVE_SURVEY_FLAG | VARCHAR2 | 16 | This flag to identify survey initiative. | ||||
| QUESTNAIRE_TYPE_CODE | VARCHAR2 | 32 | Type of the questionnaire such as supplier or internal responder. | DW_SUPPLIER_QUESTNAIRE_TYPE_LKP_TL | QUESTNAIRE_TYPE_CODE | ||
| QUESTNAIRE_RESPONSE_STATUS | VARCHAR2 | 32 | Status of response to questionnaire | DW_SUPPLIER_QUESTNAIRE_RESPONSE_STATUS_LKP_TL | QUESTNAIRE_RESPONSE_STATUS | ||
| SURROG_RESPONSE_FLAG | VARCHAR2 | 16 | Flag to indicate if a response is a surrogate response entered by qualification manager | DW_YN_LKP_TL | YN_LKP_CODE | ||
| ACCEPTED_BY_PERSON_ID | NUMBER | 38 | 0 | Person who accepted the response to questionnaire. | DW_PERSON_NAME_CURRENT_D | PERSON_ID | |
| SUBMISSION_DATE | TIMESTAMP | Date response to questionnaire is submitted. | |||||
| ACCEPTANCE_DATE | TIMESTAMP | Date on which response to questionnaire is accepted. | |||||
| ACCEPTED_BY_PERSON_NAME | VARCHAR2 | 256 | Person name who accepted the response to questionnaire. | ||||
| IS_CANCELED | VARCHAR2 | 1 | Flag to identify canceled questionnaire. |
Copyright © 2019, 2026, Oracle and/or its affiliates.