Batch uses dynamic SQL queries to narrow down the group(s) of students for which audits are run. The dynamic SQL queries that Batch generates are based on the criteria (operands) that the user creates in the program.
The Database View is the entire universe of students that audits can be run on. For the purpose of efficiency, we suggest a database view is created with columns corresponding to your criteria. Not only does this improve Batch performance, but it simplifies other issues. Benefits include the following:
- Provides a basis for further development of data points
- Simplifies SIS table permissions for Batch
- Reduces the complexity of Data Point Queries/Student Queries
- Allows for application of addition filters on students without requiring additional data points
If you have a criteria that must always be used on a Batch, they can be applied to the view rather than requiring an additional criteria on every batch, e.g., Filtering off non-active students or those students before a specific year.
♦ Define your Database View Query.
Sample Student Name Query
♦ Define your Student Name Query.
Student Main Queries
Two queries are defined in criteria.xml. The main Student Query is used as the basis for the "universe of students" known as the Database View.
- If not using the Database View, the Main Student Query should include the tables associated to your data points and the joining tables, if needed.
- If the Database View is used, your Main Student Query should appear similar to the Sample Main Student Query below.
Sample Main Student Query
Criteria are appended to this query to select the students to run the Batch audits on.
♦ Define your Main Student Name Query.
Data Points are used to create the groups of students to run the Batch audits on.
The table below can help you to define your Data Points:
Table fields include the following:
- Display Label*: The label assigned to a specific Data Point and used in Batch as the criteria's label (or operand)
- LoV Query: Defines the list of possible values associated to that Data Point. The values in the LoV Query will be displayed as drop-down menu items (seen in the screenshot above).
- Return Type*: Provides information about the LoV Query's returned values. The Return Type should be the Database Variable type that the LoV Query returns.
- Description: Description of the Data Points that provides a context for the Data Point to verify it is working properly.
- Where Clause*: The Query Condition or Sub Query that is appended to the Main Student Query to return the group of students to run Batch audits on.