Table Description
Criteria: Details of the criteria used in the generation of a case sample.

This entity is an administrative entity which captures information relating to criteria associated with a 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::Criteria
Controlling File: core\model\Packages\Reference Model\Service Layer\SelectionQuery\Entity\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
criteriaIDkeynoUnique reference number assigned by the system to a criteria record.CRITERIA_ID SVR_INT64
namedetails The name of the criteria.CRITERIA_NAME SVR_STRING<100>
valuedetails The value of the criteria. For fixed queries, this will be used as part of the query. For dynamic queries, the values are used for validation purposes only.CRITERIA_VALUE SVR_STRING<100>
displayNamedetails The display name of the criteria.CRITERIA_DISPLAY_NAME SVR_STRING<100>
displayValuedetails The display value of the criteria.CRITERIA_DISPLAY_VALUE SVR_STRING<100>
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: criteriaID
AUTO_ID_KEY: SELQRY
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
readread Standard Operation 
Related Pages (14)