Process for creating grouped crns for 2.1.x

Requirements

• Select, Insert, Update, Delete rights on the COURSE_GROUPS table in the Sakai External Database.

Process

1. Determine the next group crn to use. You can find the current highest crn number by executing the following statement:

   select max(group_crn) from course_groups;

2. Create insert statements with the new group crn number and the crns to group. Inserts should be in the following form

   insert into COURSE_GROUPS("TERM_CODE","GROUP_CRN","MEMBER_CRN") values ('char[6]','char[5]','char[5]');

3. After executing the statements, be sure to commit the changes

   commit;