The modSystem database has a user directory, the modUserList table, which stores attributes for everyone who has access to team solutions on the server. The user directory is common for all team solutions deployed on the server.
The modUserList table can be synchronized with both Microsoft Windows NTŪ and Microsoft Exchange Server (if available). Use the Team Solutions Manager to define the synchronization process to keep the user information current.
For information about using user directory data in your solution, see Working with User Information in your Team Solution.
For more information about maintaining the user directory, see Managing Users and Roles in the Access Workflow Designer Administrator's Guide.
Caution You should not alter the modUserList table manually. If you are using Exchange Server to synchronize this table, you should not make any changes to the table. If you are not using Exchange Server, you can use the Team Solutions Manager to make changes to the user information stored this table. Schema integrity is not guaranteed if you make manual changes to any solutions system tables.
The modUserList database table contains a number of columns used by the team solutions. The following table lists those columns and their data types and provides a brief description of each.
| Column | Data type | Comments |
| ObjectGUID | nvarchar(64) | Null; not used in this release. |
| ObjectSID | nvarchar(64) | Security ID of a user in a Windows NT domain. |
| SAMAccountName | nvarchar(64) | Windows NT domain and user name. |
| CN | nvarchar(64) | Common name. |
| DN | nvarchar(256) | Directory name. |
| nvarchar(256) | E-mail address. | |
| Manager | nvarchar(256) | The directory returns a ds-dn string that fully and uniquely defines the object. |
| SN | nvarchar(64) | User's last name. |
| GivenName | nvarchar(64) | User's first name. |
| TelephoneNumber | nchar(32) | User's telephone number. |
| Company | nvarchar(64) | User-defined; used to identify company of the user. |
| Department | nvarchar(64) | User-defined; used to identify department of the user. |