Table Description
Audit Case Selection Query: A relationship between a SelectionQuery and an AuditCaseConfig record.

This entity stores all the selection queries that an administrator has made available for audits of a particular case type. An administrator can associate one and only one dynamic query. Zero-to-many fixed queries can be associated to the configuration for a particular case type.

Example

A system administrator publishes three fixed selection queries. An administrator then enters audit configuration details for a Social Assistance case type and associates one of these fixed queries to the case type. When an audit coordinator creates an audit plan for Social Assistance case types, they can choose to select from the dynamic query and the fixed query to generate the case sample.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::CaseAuditConfiguration::Entity::AuditCaseSelectionQuery::AuditCaseSelectionQuery
Controlling File: core\model\Packages\Reference Model\Service Layer\CaseAuditConfiguration\Entity\Entity_cat.efx
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
auditCaseSelectionQueryIDkeynoUnique reference number assigned by the system to an audit case selection query record.AUDIT_CASE_SELECTION_QUERY_ID SVR_INT64
auditCaseConfigIDdetails The audit case config record that the selection query is associated with.AUDIT_CASE_CONFIG_ID SVR_INT64
selectionQueryIDdetails The identifier of the selection query which contains the selection criteria available to an audit coordinator.SELECTION_QUERY_ID SVR_INT64
Indices (1)
Index NameAttributes
auditCaseConfigAndQueryKeyIdxauditCaseConfigID, selectionQueryID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: auditCaseSelectionQueryID
AUTO_ID_KEY: CACNFG
Standard Operation 
removeremove Standard Operation 
searchByAuditCaseConfigreadmulti Searches selection queries by a specified configuration. 
searchByAuditCaseConfigAndSelectionQueryreadmulti Method to search for an audit case selection query record by audit case config id and selection query id. 
readread Standard Operation 
modifymodify Standard Operation 
Related Pages (7)