SQL Table Information For Workgroups And Roles
This article explains the breakdown of the table in SQL which holds workgroups and roles.
The table in SQL which holds the workgroup and role information is the ILSGROUP table. There are 5 fields which describe each workgroup or role.
COMPANYID - Clients can have multiple “companies” or instances of the Learning Management System (iLS) running under the same database. This field assigns a number to each company.
ILSGROUPID - This is an auto increment number assigned by SQL for each new workgroup or role added to the Learning Management System (iLS).
GROUPNAME - This holds the name given to a workgroup or role by the administrator.
GROUPDESC - This holds the description of a workgroup or role by the administrator. This can be blank as a description is not required when creating a workgroup or role.
GROUPTYPEID - This dictates whether the field is a workgroup or a role. A value of "1" is used for a role and a value of "2" is used for a workgroup.
Article ID: 57, Created On: 11/3/2010, Modified: 11/4/2010