Table Description
Selection Query Criteria Link: A relationship between a SelectionQuery and a Criteria record.

This entity stores the criteria that a system administrator has created for a specific selection query.

Example

An audit coordinator has a requirement to audit Food Stamps cases which are currently approved. The system administrator creates a new selection query of type fixed. The system administrator then enters the appropriate SQL and two new criteria, the case type and the case status. The associated values of the case type and status are also entered. This selection query can be validated and published, making it available for the administrator to associate to the Food Stamps case type. When an audit coordinator then creates an audit plan for a Food Stamps case type, they will be presented with the option to run the fixed query that was created by the system administrator.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::SelectionQuery::Entity::SelectionQueryCriteriaLink
Controlling File: core\model\Packages\Reference Model\Service Layer\SelectionQuery\Entity\Entity.efx
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
selectionQueryCriteriaLinkIDkeynoUnique reference number assigned by the system to a selection query criteria link record.SELECTION_QUERY_CRITERIA_LINK_ID SVR_INT64
selectionQueryIDdetails The identifier of the associated selection query.SELECTION_QUERY_ID SVR_INT64
criteriaIDdetails The identifier of the associated criteria.CRITERIA_ID SVR_INT64
Indices (2)
Index NameAttributes
IND_1303000801selectionQueryID
IND__1910994332criteriaID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: selectionQueryCriteriaLinkID
AUTO_ID_KEY: SELQRY
Standard Operation 
removeremove Standard Operation 
searchBySelectionQueryreadmulti   
searchByCriteriareadmulti   
readread Standard Operation 
modifymodify Standard Operation 
Related Pages (13)