Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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]');
    

    example

    insert into COURSE_GROUPS("TERM_CODE","GROUP_CRN","MEMBER_CRN") values ('200101','G9999','12345');
    insert into COURSE_GROUPS("TERM_CODE","GROUP_CRN","MEMBER_CRN") values ('200101','G9999','23456');

  3. After executing the statements, be sure to commit the changes
    commit;
    
  • No labels