ZCH_SELECT_CRITERIA_RULES_B

This table stores criteria detail rules. Each detail rule contains an attribute, operation, and corresponding attribute value, e.g. a criterion can be that the Registry ID must be less than 1001. Registry ID would be the attribute, less than is the operation, and 1001 is the attribute value. An object record must meet all criteria specified for the batch to be included.

Details

• Schema: FUSION

• Object owner: ZCH

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
ZCH_SELECT_CRITERIA_RULES_B_PK	SELECT_CRITERIA_RULE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
SELECT_CRITERIA_RULE_ID	NUMBER		18	Yes	Primary key	Active
DATA_SELECT_CRITERIA_ID	NUMBER		18	Yes	Forgien key to Secection Criteria table	Active
OBJ_NAME	VARCHAR2	30		Yes	Name of the Object for the criteria set. Example PERSON_PARTY	Active
OBJ_DEF	VARCHAR2	100			The merge object definition, whole package name
OPERATION_CODE	VARCHAR2	30		Yes	Operation used to join 2 criteria rules. Values are = , > , < ,!= and IS NULL	Active
RELATION_TYPE_CODE	VARCHAR2	30		Yes	The relation between two rules. Values AND or OR	Active
ATTRIBUTE_NAME	VARCHAR2	30		Yes	Name of the attribute in the criteria rule	Active
ATTRIBUTE_VALUE	VARCHAR2	100			Attribute value for the criteria	Active
ATTRIBUTE_DATA_TYPE	VARCHAR2	30			Data type of the Attribute	Active
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
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

Foreign Keys

Table	Foreign Table	Foreign Key Column
ZCH_SELECT_CRITERIA_RULES_B	zch_data_select_criteria_b	DATA_SELECT_CRITERIA_ID
zch_select_criteria_rules_tl	zch_select_criteria_rules_b	SELECT_CRITERIA_RULE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ZCH_SELECT_CRITERIA_RULES_B_N1	Non Unique	Default	DATA_SELECT_CRITERIA_ID
ZCH_SELECT_CRITERIA_RULES_B_PK	Unique	FUSION_TS_TX_IDX	SELECT_CRITERIA_RULE_ID