Open topic with navigation
SQL Statement Entry
This tool offers advanced users with SQL knowledge the opportunity to
write their own SQL statements to create formulas within groups. When
you choose to populate the group automatically with the SQL statement,
CAMS will ignore any courses that may be assigned to the group, and instead
accesses courses from the Course Master. Any attributes
that you assign will affect every course within the SQL statement.
Note: When using Auto-Populated SQL Groups, if at least one course record does not exist in the group when the audit is evaluated, CAMS will generate one "non-course" entry for the audit using all asterisks (*) for the Department, Course ID, and Type in order to display the group on the audit report.
To enter SQL statements:
- From the Registration
>Degree Audit >Degree Audit Setup >Groups tab, double-click
the group for which you want to create the formula. A groups
detail window appears.
- Make sure the Populate Group Automatically option
is set to "Yes". If this option is set to "No"
you will not be able to use the SQL Statement Entry tool.
- Click the SQL
button to access the SQL Statement Entry form.
- Write the SQL statement, beginning with the "Where"
clause.
- After completing the statement, assign attributes
to all courses within the statement.
- Click the Test SQL
button to test your statement. All courses written into the
statement will display in the SQL Records data grid.
- Click Update
to save your formula,or Cancel
to exit without saving.
Related Topics