The modUserList Table
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
The modSystem database has a user directory, the modUserList table, which stores attributes for everyone who has access to workflow applications on the server. The user directory is common for all workflow applications deployed on the server.
The modUserList table can be synchronized with Active Directory, Microsoft® Exchange 2000 Server, or Microsoft® Exchange 5.5 Server. Use the Workflow Manager for SQL Server to define the synchronization process to keep the user information current.
**Note **You should not alter the modUserList table manually except through the Workflow Manager, which can be used to make changes to the user information stored this table. Schema integrity is not guaranteed if you make manual changes to any system tables.
The following table lists the modUserList 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 domain. |
| SAMAccountName | nvarchar(64) | Windows 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 the company of the user. |
| Department | nvarchar(64) | User-defined. Used to identify the department of the user. |
See Also
ModSystem Database Tables | The modApplications Table | The modTemplates Table | The Individual Template Tables | The modProperties Table (modSystem Database) | User Information for Workflow Applications