POQ_QUESTIONS
POQ_QUESTIONS constitutes the supplier qualification question library. The table stores all the questions created by a buying organization. Each row in this table corresponds to one revision of a question, and carries information such as question text, type of a question, type of a responder, critical question flag.
Details
-
Schema: FUSION
-
Object owner: POQ
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
POQ_QUESTIONS_PK |
QUESTION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
QUESTION_ID | NUMBER | 18 | Yes | Internal system identifier for this question. | |
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. | |
ORIGINAL_QUESTION_ID | NUMBER | 18 | Yes | QUESTION_ID value for the revision 0 of this question. | |
REVISION_NUMBER | NUMBER | 9 | Yes | Revision number of this question. Revision 0 is the base revision. | |
QUESTION_NAME | VARCHAR2 | 80 | Yes | Question name or identifier entered by the user. | |
QUESTION_LEVEL | VARCHAR2 | 30 | Yes | Indicates whether the question is relevant to a supplier or to a supplier site. The system validates against the FND_LOOKUP for POQ_QUESTION_LEVEL. | |
RESPONDER_TYPE | VARCHAR2 | 30 | Yes | Indicates whether the question responder should be a supplier or an internal user. The system validates against the FND_LOOKUP for POQ_RESPONDER_TYPE. | |
SUPPLIER_ATTRIBUTE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the question is mapped to an attribute from the supplier profile. | |
QUESTION_TYPE | VARCHAR2 | 30 | Yes | Specifies which of the following types of question: 1) a multiple choice question with single selection, 2) a multiple choice question with multiple selections, or 3) a question without predefined acceptable responses (an input box question). The system validates against the FND_LOOKUP for POQ_QUESTION_TYPE. | |
QUESTION_STATUS | VARCHAR2 | 30 | Yes | The status of the question. Values are: DRAFT, ACTIVE, INACTIVE, ARCHIVED, ARCHIVED_INACTIVE. | |
OWNER_ID | NUMBER | 18 | The person id of the worker who is the owner of this question. | ||
DISPLAY_PREFERRED_RESP_FLAG | VARCHAR2 | 1 | Specifies whether to display the preferred response, if it exists, to the supplier. | ||
LATEST_REVISION_FLAG | VARCHAR2 | 1 | Specifies whether this revision is the latest revision for this question. | ||
CRITICAL_QUESTION_FLAG | VARCHAR2 | 1 | Specifies whether a question is critical for evaluation. | ||
RESPONSE_REQUIRED_FLAG | VARCHAR2 | 1 | Specifies whether a response is required when a responder submits the question on a questionnaire. | ||
ALLOW_RESP_COMMENT_FLAG | VARCHAR2 | 1 | Specifies whether a responder can enter free text comments when submitting a response to the question on a questionnaire. | ||
QUESTION_TEXT | CLOB | Yes | The rich text of the question to be displayed to responders on a questionnaire. | ||
QUESTION_HINT | VARCHAR2 | 1000 | Additional instructions or information to be presented to responders with the question text. | ||
SUBJECT_CODE | VARCHAR2 | 30 | A code identifying a subject to be associated with the question for search purposes. The system validates against the FND_LOOKUP for POQ_SUBJECT. | ||
STDS_ORG_CODE | VARCHAR2 | 30 | A code identifying the standards organization designated as the source of this requirement. The system validates against the FND_LOOKUP for POQ_STDS_ORG. | ||
SUPPLIER_ATTRIBUTE_CODE | VARCHAR2 | 35 | If this question is mapped to a supplier attribute, this code identifies the supplier attribute that this question is mapped. The system validates against the POQ_SUPPLIER_ATTRIBUTES_B. | ||
RESPONSE_TYPE | VARCHAR2 | 30 | For a question type value of input box, the response type specifies the data type of the response. The domain values include: single line text, multiple line text, number, date, date and time, and URL. The system validates against the FND_LOOKUP for POQ_RESPONSE_TYPE. | ||
ATTACHMENT_ALLOWED_CODE | VARCHAR2 | 30 | For a question type value of input box, this code specifies whether the responder is able to attach any documents with their response when submitting the questionnaire. The system validates against the FND_LOOKUP for POQ_QUESTION_RESPONSE_ATTACH. | ||
PREFERRED_RESPONSE_TEXT | VARCHAR2 | 4000 | For a question with question type of input box and a response type of either 1) single-line text, 2) multi-line text, or 3) URL, this captures the preferred response value for this question. | ||
PREFERRED_RESPONSE_DATE | DATE | For a question with question type of input box and response type of date, this captures the preferred response value for this question. | |||
PREFERRED_RESPONSE_DATETIME | TIMESTAMP | For a question with question type of input box and response type of date and time, this captures the preferred response value for this question. | |||
PREFERRED_RESPONSE_NUMBER | NUMBER | For a question with question type of input box and response type of number, this captures the preferred response value for this question. | |||
SCORING_METHOD | VARCHAR2 | 30 | Yes | Code identifying the scoring method to be used for this question. The default value is NONE. The system validates against the FND_LOOKUP for POQ_QUESTION_SCORING_METHOD. | |
MAXIMUM_SCORE | NUMBER | 9 | The maximum score for the question. For an automatically scored question it will be calculated. For a manually scored question it will be manually assigned to this question. | ||
SCORE_FOR_NO_RESPONSE | NUMBER | 9 | Score that is automatically assigned to an optional question if no response is provided for the question. | ||
SCORING_APPROACH | VARCHAR2 | 30 | The automatic scoring approach for multiple choice multiple select questions. The system validates against the FND_LOOKUP for POQ_QUESTION_SCORING_APPROACH. | ||
ACTIVATION_DATE | TIMESTAMP | The date and time that the question was activated. | |||
QUESTION_SURVEY_FLAG | VARCHAR2 | 1 | Yes | This flag will determine whether the question can have multiple responses for the question or a single response. | |
QUESTION_USAGE_CODE | VARCHAR2 | 30 | A code identifying whether the question is of type prerequisite, checklist or a regular one i.e., qualification. Possible values are PREREQUISITE, CHECKLIST and QUALIFICATION. The system validates against the FND_LOOKUP for ORA_POQ_ENTITY_USAGE. | ||
MAPPED_TO_PREREQ_QUESTION_FLAG | VARCHAR2 | 1 | If this is a checklist type of question, this flag indicates whether this question is mapped to a prerequisite question. | ||
MAPPED_TO_PREREQ_QUESTION_ID | NUMBER | 18 | If this is a checklist type of question mapped to a prerequisite question as denoted in MAPPED_TO_PREREQ_QUESTION_FLAG, this column identifies the prerequisite question id. | ||
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_QUESTIONS | poq_supplier_attributes_b | SUPPLIER_ATTRIBUTE_CODE |
poq_ques_acc_responses | poq_questions | QUESTION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
POQ_QUESTIONS_N1 | Non Unique | Default | ORIGINAL_QUESTION_ID |
POQ_QUESTIONS_N2 | Non Unique | Default | QUESTION_STATUS |
POQ_QUESTIONS_PK | Unique | Default | QUESTION_ID |
POQ_QUESTIONS_U1 | Unique | Default | UPPER("QUESTION_NAME"), REVISION_NUMBER |
POQ_QUESTIONS_U2 | Unique | Default | QUESTION_ID, QUESTION_LEVEL, QUESTION_TYPE |
POQ_QUESTIONS_U3 | Unique | Default | QUESTION_ID, SUPPLIER_ATTRIBUTE_CODE |