POQ_RULES

POQ_RULES stores the conditions that should be met in order to include a qualification area to be part of the questionnaire that would be generated using the rule set. It stores the type of condition, operators required to specify a condition if it depends on the value of a supplier attribute and the sequence in which any qualification area appears in the questionnaire.

Details

• Schema: FUSION

• Object owner: POQ

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
POQ_RULES_PK	RULE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RULE_ID	NUMBER		18	Yes	System-generated unique identifier.
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.
RULE_SET_ID	NUMBER		18	Yes	Unique identifier for the rule set.
DISPLAY_SEQUENCE	NUMBER		9	Yes	Specifies the order in which questions should be displayed in the questionnaire generated using this rule set.
CONDITION_TYPE	VARCHAR2	30		Yes	Specifies the condition type. Possible values are Always Display or response dependent.
SUPPLIER_ATTRIBUTE_CODE	VARCHAR2	35			If the condition is Response Dependent, identifies the Supplier attribute on which it is dependent, foreign key to POQ_SUPPLIER_ATTRIBUTES_B and TL tables.
EXT_ATTR_1	VARCHAR2	240			This is used to store some relevant information related to the business classification. For example, this column is used to store the minority type for the Minority Owned business classification.
CONDITION_OPERATOR	VARCHAR2	30			If the condition is Response Dependent, stores the operator to be used for checking the supplier attribute value.
CONDITION_VALUE	VARCHAR2	240			If condition type is Response Dependent, stores the value of the supplier attribute code to be checked for the given operator.
RULE_TYPE	VARCHAR2	30		Yes	This column is added for future use.
EVENT	VARCHAR2	30			Event for which the rules are created.
EVENT_RULE_CODE	VARCHAR2	30			Business Relationship or Registration source of the supplier for which the rule is applicable.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of 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_RULES	poq_rule_sets_b	RULE_SET_ID
POQ_RULES	poq_rules	RULE_ID
poq_rules	poq_rules	RULE_ID
poq_rule_area_questions	poq_rules	RULE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POQ_RULES_U1	Unique	Default	RULE_ID
POQ_RULES_U2	Unique	Default	RULE_SET_ID, RULE_TYPE, DISPLAY_SEQUENCE, EVENT