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.