Creating a selection query is a two step process; the first step allows the addition of the basic selection query details, such as name and the query type, along with the SQL. The second step allows the entry of the selection criteria associated with the selection query.
The 'Name' of the selection query is what will be displayed to the administrator when configuring a case audit and to the audit coordinator when generating a random case sample, so it should have a meaningful and descriptive name.
'Query' represents the type of objects that the selection query will impact. In this initial release there is one type of object, Case. Additional functionality is envisaged in this area so that selection queries can be captured for any object. An example usage of this might be participants, where an agency may want to poll all employers to determine information on employee working patterns.
The 'Query Type' should be chosen depending on the type of selection query required, Dynamic or Fixed. If the selection query is 'Dynamic', the 'Random Generation' and 'Manual Search' page names must be entered. The page names entered must match the name of the custom UIM that will be used to enter the selection criteria.
The SQL text is the SQL statement that will be used to execute the selection query. Every field on the custom selection criteria selection screen should be part of the WHERE clause. Take the example outlined in Utilizing Dynamic Selection Queries a UIM has been created to allow the audit coordinator to select a status, the SQL necessary for this query would be -
SELECT caseID INTO :caseID FROM CaseHeader WHERE statusCode = :statusCode