The IPUser table contains one entry for each user and group of users.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| userid | integer | not null | Unique over all users and groups. For users, this is the SQL Server “suid” from the master..syslogins table. For Groups, this is an internal value starting at 1,000,000. NOTE: next Group ID kept in LookOutIdControl |
| username | varchar(32) | not null | The name of this User/Group NOTE: unique across all users of the same type. |
| usertype | integer1 | not null | Indicates whether this is a group or user. |
| usergroupid | integer | with null | The ID of the group that this user belongs to or group id of group. |
| lastlogintime | date | with null | The time and date of last login for user. |
| capabilities | integer | with null | The capabilities assigned to this user or group. |
| usernote | varchar(255) | with null | The optional user-defined note. |
Product Name: Data Transformer
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| userid | ipobject | userid |