POQ_QUESTNAIRES

POQ_QUESTNAIRES 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.

Details

• Schema: FUSION

• Object owner: POQ

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
POQ_QUESTNAIRES_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_TITLE	VARCHAR2	80		Yes	The title assigned to the questionnaire.	Active
QUESTNAIRE_STATUS	VARCHAR2	30		Yes	The status assigned to the questionnaire.	Active
INTRODUCTION	CLOB				Introduction 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	poq_initiatives	INITIATIVE_ID
poq_questnaire_sections	poq_questnaires	QUESTNAIRE_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
POQ_QUESTNAIRES_N1	Non Unique	Default	UPPER("QUESTNAIRE_TITLE")
POQ_QUESTNAIRES_N2	Non Unique	Default	TRUNC("DUE_DATE")
POQ_QUESTNAIRES_PK	Unique	Default	QUESTNAIRE_ID
POQ_QUESTNAIRES_U1	Unique	FUSION_TS_TX_IDX	INITIATIVE_ID, SUPPLIER_REG_ID, QUESTNAIRE_TYPE	Active