POQ_QUESTNAIRE_RESP_SECTIONS
POQ_QUESTNAIRE_RESP_SECTIONS stores various sections included in a questionnaire response along with details such as if a section is completed, if a section has been generated with its resposnes.
Details
-
Schema: FUSION
-
Object owner: POQ
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
POQ_QUESTNAIRE_RESP_SECTS_PK |
QUESTNAIRE_RESP_SECTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| QUESTNAIRE_RESP_SECTION_ID | NUMBER | 18 | Yes | Unique identifier for questionnaire response section. | |
| 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. | |
| QUESTNAIRE_RESP_HEADER_ID | NUMBER | 18 | Yes | Internal system identifier for a questionnaire response. | |
| QUESTNAIRE_SECTION_ID | NUMBER | 18 | Yes | Internal system identifier for a questionnaire section. | |
| SECTION_GENERATED_FLAG | VARCHAR2 | 1 | Flag indicates section generated into the questionnaire response. | ||
| SECTION_COMPLETED_FLAG | VARCHAR2 | 1 | Flag indicates section response is completed. | ||
| SECTION_DISPLAYED_FLAG | VARCHAR2 | 1 | This flag will be set to 'Y' for all the sections that were shown to the responder at the time of supplier registration submission. For sections that were not displayed during submission will carry the flag as 'N'. | ||
| 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_RESP_SECTIONS | poq_questnaire_resp_headers | QUESTNAIRE_RESP_HEADER_ID |
| POQ_QUESTNAIRE_RESP_SECTIONS | poq_questnaire_sections_b | QUESTNAIRE_SECTION_ID |
| poq_questnaire_responses | poq_questnaire_resp_sections | QUESTNAIRE_RESP_SECTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| POQ_QUESTNAIRE_RESP_SECTS_PK | Unique | Default | QUESTNAIRE_RESP_SECTION_ID |
| POQ_QUESTN_RESP_SECTS_U1 | Unique | Default | QUESTNAIRE_RESP_HEADER_ID, QUESTNAIRE_SECTION_ID |