This entity is an administrative entity which captures information relating to a custom query. Two types of selection query may be used. A dynamic query allows the audit coordinator to enter criteria such as case status and a case start date range, which is then used to produce a list of cases. A fixed query provides a predefined set of criteria. If a fixed query is used to generate a random sample of cases within an audit plan, then no audit coordinator entry of criteria is required.

Example

An audit coordinator has a requirement to audit Food Stamps cases, opened between the 10th and 14th of February which are currently approved. The system administrator creates a new selection query of type fixed. The system administrator then enters the appropriate SQL and criteria matching the audit coordinators needs. 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.