POQ_QUESTNAIRE_RESPONSES
POQ_QUESTNAIRE_RESPONSES stores the response details such as response comment, acceptance note for each question on the questionnaire sent to suppliers as well as internal responders. The actual response value to a question is stored in POQ_QUESTNAIRE_RESP_VALUES. POQ_QUESTNAIRE_RESPONSES table holds all the questions on the questionnaire irrespective of the fact that if responder has seen and responded to a question or not on a questionnaire. If responder responds to a question, then response details are filled in. If responder does not respond to a certain question or never sees the question, the response details remain empty.
Details
-
Schema: FUSION
-
Object owner: POQ
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
POQ_QUESTNAIRE_RESPONSES_PK |
QUESTNAIRE_RESPONSE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| QUESTNAIRE_RESPONSE_ID | NUMBER | 18 | Yes | Internal system identifier for a questionnaire question response. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| HAS_NEWER_RESPONSE_FLAG | VARCHAR2 | 1 | Indicates that a newer response is available and this response will be ignored. | ||
| FAILED_POZ_VALIDATION_FLAG | VARCHAR2 | 1 | Indicates that this response failed POZ validation and this response will be ignored | ||
| QUESTNAIRE_RESP_HEADER_ID | NUMBER | 18 | Yes | Identifier to the response to questionnaire. | |
| QUESTNAIRE_RESP_SECTION_ID | NUMBER | 18 | Section identifier of questionnaire. | ||
| QUESTION_ID | NUMBER | 18 | Yes | Identifier to the questionnaire question. | |
| QUESTNAIRE_QUESTION_ID | NUMBER | 18 | Questionnaire question identifier from the questionnaires table. | ||
| RESPONSE_COMMENTS | VARCHAR2 | 1000 | Comments entered by supplier or internal respondent for response to a question. | ||
| QUESTION_DISPLAYED_FLAG | VARCHAR2 | 1 | This flag will be set to 'Y' for all the questions that were shown to the responders at the time of response submission. For questions that were not displayed during submission will carry the flag as 'N'. | ||
| ACCEPTANCE_NOTE | VARCHAR2 | 1000 | Note entered by acceptor for a question response at the time of acceptance. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| POQ_QUESTNAIRE_RESPONSES | poq_questnaire_resp_headers | QUESTNAIRE_RESP_HEADER_ID |
| POQ_QUESTNAIRE_RESPONSES | poq_questions_b | QUESTION_ID |
| POQ_QUESTNAIRE_RESPONSES | poq_questnaire_questions | QUESTNAIRE_QUESTION_ID |
| POQ_QUESTNAIRE_RESPONSES | poq_questnaire_resp_sections | QUESTNAIRE_RESP_SECTION_ID |
| poz_supplier_mappings | poq_questnaire_responses | POQ_QUESTNAIRE_RESPONSE_ID |
| poq_questnaire_resp_values | poq_questnaire_responses | QUESTNAIRE_RESPONSE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| POQ_QUESTNAIRE_RESPONSES_F1 | Non Unique | Default | QUESTNAIRE_RESP_SECTION_ID |
| POQ_QUESTNAIRE_RESPONSES_N1 | Non Unique | Default | QUESTION_ID |
| POQ_QUESTNAIRE_RESPONSES_PK | Unique | FUSION_TS_TX_DATA | QUESTNAIRE_RESPONSE_ID |
| POQ_QUESTNAIRE_RESPONSES_U1 | Unique | Default | QUESTNAIRE_RESP_HEADER_ID, QUESTNAIRE_QUESTION_ID |