This chapter covers case audit configuration options available in the system administration application. Case audits are used to examine and evaluate cases. The random list of cases which are produced for a case audit are generated using selection queries. A selection query consists of an SQL statement and selection criteria used to validate the query and return information from the database. Two types of selection queries exist: fixed and dynamic.
A dynamic selection query is a flexible way to produce a list of cases for an audit. The coordinator can choose one or any combination of criteria to produce the list of cases. For example, the audit coordinator can select to generate a list of all cases with a status of open. Alternatively the audit coordinator could choose several criteria to produce the list of cases. For example, criteria of case start date and gender would return a more specific group of cases.
A fixed query is less flexible than a dynamic query, in that the values for the criteria form part of the query. An audit coordinator does not input the parameters for a fixed query. Fixed queries are reusable however, and are easier to run as no criteria selection by the audit coordinator is necessary. An example of a fixed query would be 'All open cases for males aged 18-35'.
For more information on selection queries, and case audits in general, please consult the Cúram Case Audits Guide. For detailed information on selection queries and the SQL statements required to run a selection query, consult the Case Audits Developer Guide.