This article explains how the SQL user table integrates with the SQL Workgroups & Roles table
The table used in SQL to ingrate a user with a workgroup or role is USERGROUP. Here, there are 3 different fields:
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.
USERPRID - This is a unique auto increment number assigned by SQL for each new user added to the Learning Management System (iLS).
ILSGROUPID - This is a unique auto increment number assigned by SQL for each new workgroup or role added to the Learning Management System (iLS).
The USERPRID is an internal numeric field also located in the USERPROFILE table. This field creates the relationship between the user profile and his or her workgroup and role.
Article ID: 58, Created On: 11/4/2010, Modified: 11/4/2010