MKT_RM_RULE_CONDITIONS

This table stores the details of the conditions that make up the rule.

Details

• Schema: FUSION

• Object owner: MKT

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
MKT_RM_RULE_CONDITIONS_PK	RULE_CONDITION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
RULE_CONDITION_ID	NUMBER		18	Yes	Rule Condition Id. Primary key of the rule conditions table.	Active
RULE_HEADER_ID	NUMBER		18	Yes	Rule Header Id. Reference to the rule header to which the condition belongs.	Active
PARENT_RULE_CONDITION_ID	NUMBER		18		Parent Rule Condition Id. Stores reference to the parent rule condition in case of a sub condition.	Active
SEQUENCE_NUMBER	NUMBER		18		Sequence Number. Stores the sequence number assigned to the parent rule conditions for ordering purpose.
PREV_RULE_CONDITION_ID	NUMBER		18		Previous Rule Condition Id. Stores reference to the previous rule sub condition for a given sub condition.	Active
AGGREGATE_CONDITION_FLAG	VARCHAR2	1			Aggregate Condition Flag. Indicates whether the current condition is an aggregate condition.	Active
AGGREGATE_OPERATOR	VARCHAR2	30			Aggregate Operator. Stores the operator for the aggregate condition (Exists, Not exists, Count)	Active
LHS_FACT_TYPE	VARCHAR2	30			LHS Fact Type. Stores type of the fact (profile) used for rule condition	Active
LHS_ATTRIBUTE	VARCHAR2	30			LHS Attribute. Stores the attribute name of the left hand side attribute in a condition.	Active
OPERATOR	VARCHAR2	30			Operator. Stores the operator used in a condition relating the left and right hand sides.	Active
CONNECTOR	VARCHAR2	30			Connector. Stores the connector used between different rule conditions e.g AND, OR .	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	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
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Indexes

Index	Uniqueness	Tablespace	Columns	Status
MKT_RM_RULE_CONDITIONS_N1	Non Unique	Default	RULE_HEADER_ID
MKT_RM_RULE_CONDITIONS_PK	Unique	FUSION_TS_TX_IDX	RULE_CONDITION_ID	Active