XCC_CB_RULE_FILTER_COND_VALS

This table stores the rule filter condition values for supplementary rules and revenue funding rules. When rule condition is enabled for ALL values, this table will not have any rows populated for the corresponding condition.

Details

• Schema: FUSION

• Object owner: XCC

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
XCC_CB_RULE_FILTER_COND_V_PK	RULE_FILTER_COND_VAL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RULE_FILTER_COND_VAL_ID	NUMBER		18	Yes	Unique identifier for this transaction
RULE_FILTER_CONDITION_ID	NUMBER		18	Yes	Foreign key to XCC_CB_RULE_FILTER_CONDITIONS table
FILTER_CONDITION_VALUE	VARCHAR2	100		Yes	Indicates the condition value to be used to match a transaction to this rule
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.
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.
REV_FUNDING_PERCENTAGE	NUMBER		6		Percentage of the funding amount assigned to the target budget account.

Indexes

Index	Uniqueness	Tablespace	Columns
XCC_CB_RULE_FIL_VALS_U1	Unique	FUSION_TS_TX_DATA	RULE_FILTER_COND_VAL_ID
XCC_CB_RULE_FIL_VALS_U2	Unique	FUSION_TS_TX_DATA	RULE_FILTER_CONDITION_ID, FILTER_CONDITION_VALUE