POQ_QUESTNAIRES_B

POQ_QUESTNAIRES_B stores questionnaires generated during the initiative creation process. Supplier type questionnaires are sent to suppliers. Internal responder type questionnaires are sent to workers from the qualifying enterprise. This table also stores supplier registration questionnaire.

Details

• Schema: FUSION

• Object owner: POQ

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
POQ_QUESTNAIRES_B_PK	QUESTNAIRE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
QUESTNAIRE_ID	NUMBER		18	Yes	Unique Identifier for questionnaire.	Active
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.	Active
INITIATIVE_ID	NUMBER		18	Yes	Unique identifier for initiative.	Active
SUPPLIER_REG_ID	NUMBER		18	Yes	Unique identifier for supplier registration.
QUESTNAIRE_TYPE	VARCHAR2	30		Yes	Type of the questionnaire such as supplier or internal responder.	Active
QUESTNAIRE_USAGE_CODE	VARCHAR2	30			Identifies whether the questionnaire is of type Prerequisite, Checklist or Qualification. Default is Qualification. Lookup type: ORA_POQ_ENTITY_USAGE.
PRC_BU_ID	NUMBER		18	Yes	Procurement business unit identifier of the business unit in which the questionnaire is created.
QUESTNAIRE_STATUS	VARCHAR2	30		Yes	The status assigned to the questionnaire.	Active
DUE_DATE	DATE				Indicates the date on which questionnaire response is due from suppliers or internal responders.	Active
USE_QUESTION_BRANCH_FLAG	VARCHAR2	1			Indicates whether question branching is used when the questionnaire is created.
QUESTNAIRE_CUSTOM	VARCHAR2	1			Indicates whether the questionmaire has been modified prior to launching the initiative.
AUTO_CREATE_QUAL_FLAG	VARCHAR2	1			Indicates whether qualifications should be automatically created on supplier events.
REMIND_DAYS_BEFORE_DUE_FIRST	NUMBER		18		Number of days before due date when the first reminder should be sent.
REMIND_DAYS_BEFORE_DUE_SECOND	NUMBER		18		Number of days before due date when the second reminder should be sent.
REMIND_DAYS_PAST_DUE	NUMBER		18		Number of days after the due date when the reminders should be sent.
AUTO_CLOSE_DATE	DATE				Indicates when all the open questionnaires will be closed.
AUTO_CLOSE_THRESHOLD_PERCENT	NUMBER		2		Minimum percentage of responses received that will cause the questionnaire to be closed after the due date.
REMINDER_FIRST_SENT_DATE	TIMESTAMP				Date when the first reminder is sent.
REMINDER_SECOND_SENT_DATE	TIMESTAMP				Date when the second reminder is sent.
REMINDER_PAST_DUE_SENT_DATE	TIMESTAMP				Date when the past due reminder is sent.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
POQ_QUESTNAIRES_B	poq_initiatives	INITIATIVE_ID
poq_questnaire_acc_resps	poq_questnaires_b	QUESTNAIRE_ID
poq_questnaire_questions	poq_questnaires_b	QUESTNAIRE_ID
poq_questnaire_resp_headers	poq_questnaires_b	QUESTNAIRE_RESP_HEADER_ID
poq_questnaire_sections_b	poq_questnaires_b	QUESTNAIRE_ID
poq_qnaire_rules	poq_questnaires_b	QUESTNAIRE_ID
poq_removed_questions	poq_questnaires_b	QUESTNAIRE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POQ_QUESTNAIRES_B_N2	Non Unique	Default	TRUNC("DUE_DATE")
POQ_QUESTNAIRES_B_PK	Unique	Default	QUESTNAIRE_ID