A fixed query provides a predefined set of selection criteria that is defined through the entry of a SQL statement. For example, a fixed query might specify all cases opened, found ineligible, and closed within the month of February. If a fixed query is used to generate a random sample of cases within an audit plan, then no audit coordinator entry of selection criteria is required.
Fixed queries may also be created by an administrator and associated to a case audit configuration once they are validated and published. Multiple fixed queries may be associated to a case audit configuration, along with the one dynamic query. These queries are not a replacement but an addition to the dynamic query. An audit coordinator has the option to choose which type of query to use when generating the random list of cases for audit.