Updated: 2009-10-01

Version: Control 4.4

Table Purpose, Usage, and Notes

This table stores information on which (and how) employees are able to log into Control.

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 6000 - User
  • Valid values for UserLicenseType:
    • 0 - Full
    • 1 - Partial
  • Valid values for PartialTemplateType:
    • 0 - Default

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
UserName.ClassTypeID int Identifier for the Type of Object
UserName.ForcePWChange bit If 1, the user must change her password after logging in successfully with their current password.
UserName.ID int Primary Key for the Table
UserName.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
UserName.IsSystem bit Used to Mark Required Records
UserName.LastWebAccess datetime
UserName.LoginName nvarchar(50) The name the user logs into Control with. This field should be unique. The default is the first letter of the first name combined with the last name.
UserName.LogintoControl bit Is this user allowed to log into Control?
UserName.LogintoWebPro bit Is this user allowed to log into Production Terminal?
UserName.ModifiedByComputer nvarchar(50) HostName of computer that last modified this record
UserName.ModifiedByUser nvarchar(50) Windows User who last modified this record
UserName.ModifiedDate datetime DateTime this Record was last modified
UserName.ParentClassTypeID int 3500, the parent is always an Employee record.
UserName.ParentID int ID of Category/Group Above sql_structure_-_employee_table.ID
UserName.PartialTemplateType int Enumerated Type
UserName.SecurityRightTemplateID int Links to a protected field in the System Data.
UserName.SecurityTemplateID int Links to a protected field in the System Data.
UserName.SeqID int
UserName.StoreID int Not Used.
UserName.UserLicenseType int Enumerated Type
UserName.WebProSecurityTempID int Links to a protected field in the System Data.

Related Tables

sql_structure_-_employee_table

You could leave a comment if you were logged in.