{$page} 



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|Employee]].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|Employee]]



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]