This table stores the definition of users
| Column Name | Column Datatype | Column Null Option | Column Comment |
| usrobjid | integer | not null | Object ID of user |
| username | char(32) | not null | Name of user |
| logindate | date | with null | Time of initial login |
| lastlogin | date | with null | Time of last login |
| loggedin | char(1) | not null | User logged in (Y/N) |
| realname | char(128) | with null | Real name of user |
| phonenumber | char(32) | with null | Phone number of user |
| extension | char(8) | with null | Phone extension of user |
| faxnumber | char(32) | with null | Fax number of user |
| encryptpsswd | char(32) | with null | Encrypted password |
| passwdattrs | integer | not null | Reserved for future use |
| creationtime | date | not null | Time user was created |
| creatorid | integer | not null | Object ID of user to create |
| modifiedtime | date | not null | Time user profile was modified |
| modifierid | integer | not null | Object ID of user to modify |
| varchar(128) | with null | Email address of user | |
| note | varchar(2000) | with null | User-defined note |
Product Name: AllFusion Harvest Change Manager
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| usrobjid | harpasswordhistory | usrobjid |
| usrobjid | harusersingroup | usrobjid |
| usrobjid | haruserdata | usrobjid |