MS SQL table information for user profiles
This article explains data fields which make up the user profile table in the MS SQL database. This article may be useful when performing user imports to the Learning Management System (iLS), or for integrating with 3rd party systems which contain employee information.
There are 22 fields which encompass 1 record for a user profile. New user information can be entered directly through the User Profile screen. However, for initial system loading, data imports can be accomplished using scripts provided (see additional knowledge base article). The following is a definition of information contained in each field:
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 an auto increment field. MS SQL automatically sequentially assigns a number to each newly added user. Do not modify or place data in this field.
USERPRNUM - User login username or ID.
USERPRPASSWD - User password.
USERPRFNAME - User first name.
USERPRLNAME - User last name.
USERPRSTATUSID - Denotes if a user is active or inactive.
USERPRADDR1 - User address, line 1.
USERPRADDR2 - User address, line 2.
USERPRCITY - User city.
USERPRSTATE - User state.
USERPRZIP - User zip code.
USERPRCOUNTRY - User country.
USERPREMAIL - User e-mail address.
USERPRPHONE - User phone number.
USERPREMPTITLEID - Denotes the User title.
USERPRLASTLOGIN – Do Not write data to this Field
USERPRACCESSLEVEL - Denotes the User security level. 1 = User, 2 = Manager, 3 = Administrator
USERPRHIREDATE - User hire date. (mo/dd/year)
USERPRTERMDATE - User termination date. (mo/dd/year)
USERPRACCESSMOD - Do not write data to this field
USERDATA – Open field, can be used for integration with other systems.
Article ID: 45, Created On: 2/15/2008, Modified: 7/15/2009