New dynamic selection queries can be created by a database administrator or a system administrator. Once created, they are associated with a case audit configuration by an administrator. Development effort is required to produce the new selection criteria page that an audit coordinator uses before the new selection query can be associated with a case audit configuration. A sample dynamic query is provided for each of the standard case types: integrated case, benefit product delivery, liability product delivery, and investigation case.
Page names for the manual search and random search pages are required when creating a dynamic selection query. These are the pages that the audit coordinator views when creating a list of cases for an audit. The system administrator must also enter the SQL statement for the selection query which will be used to query the database for the list of cases to be returned.
As part of creating a selection query, selection criteria are recorded to ensure the query is valid. The system administrator then publishes the selection query, making it available to be added to a case audit configuration by an administrator. This allows an audit coordinator to generate a list of cases for audit using the selection query. The selection criteria are used to return the list of cases.
When configuring a case audit, an administrator must associate one (and only one) predefined dynamic query with a case audit configuration.