SVC_MCA_ENTITY_CRITERIA

This table is used to create query criteria for the VO entity being used by the LOOKUPS or ENTITY_ACTION

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
SVC_MCA_ENTITY_CRITERIA_PK	ENTITY_CRITERIA_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
ENTITY_CRITERIA_ID	NUMBER		18	Yes	Auto-generated number and primary key for this table.	Active
FIELD_NAME	VARCHAR2	32			The name of the field in the VO Object being used in the query criteria.	Active
ENTITY_ACTION_OR_LOOKUP_ID	NUMBER		18	Yes	Foreign key to either the SVC_MCA_ENTITY_ACTION.ENTITY_ACTION_ID or SVC_MCA_LOOKUPS.LOOKUP_ID
CRITERIA_ORDER	NUMBER		2	Yes	Specifies the order in a set of where clause specification
IS_GROUP_FLAG	VARCHAR2	1		Yes	Specifies if the row is for a group of attributes
OPERATOR	VARCHAR2	40			Specifies the operation (equals, not equals, between, like, greater than, less than, greater or equal, less or equal). Foreign Key to the ORA_SVC_MCA_CRIT_OPERATOR_CD lookup
VALUE_START	NUMBER		18		Specifies token / custom attribute which gives the value
VALUE_END	NUMBER		18		Specifies token / custom attribute which gives the value
LOGICAL_OPERATOR	VARCHAR2	20			Specifies the logical relation of the row to the following of the same category (attribute or group) – values: AND / OR. Foreign key to the ORA_SVC_MCA_LOGIC_OPERATOR_CD
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
DELETED_FLAG	VARCHAR2	1		Yes	Indicates whether the category is logically deleted (Y or N).	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
SVC_MCA_ENTITY_CRITERIA	svc_mca_entity_action	ENTITY_ACTION_OR_LOOKUP_ID
SVC_MCA_ENTITY_CRITERIA	svc_mca_lookups	ENTITY_ACTION_OR_LOOKUP_ID
SVC_MCA_ENTITY_CRITERIA	svc_mca_token	VALUE_START
SVC_MCA_ENTITY_CRITERIA	svc_mca_token	VALUE_END

Indexes

Index	Uniqueness	Tablespace	Columns	Status
SVC_MCA_ENTITY_CRITERIA_N1	Non Unique	Default	ENTITY_ACTION_OR_LOOKUP_ID
SVC_MCA_ENTITY_CRITERIA_N2	Non Unique	Default	VALUE_START
SVC_MCA_ENTITY_CRITERIA_N4	Non Unique	Default	VALUE_END
SVC_MCA_ENTITY_CRITERIA_PK	Unique	Default	ENTITY_CRITERIA_ID	Active