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.