2.2.6.10 UserInfo Table

  • Article

The UserInfo Table stores descriptive properties and security information about principals with access to a site collection. The UserInfo Table is defined using T-SQL syntax, as follows.

 TABLE UserInfo (
 tp_SiteID                      uniqueidentifier   NOT NULL,
 tp_Id                          int                NOT NULL,
 tp_DomainGroup                 bit                NOT NULL,
 tp_SystemID                    varbinary(512)     NOT NULL,
 tp_Deleted                     int                NOT NULL,
 tp_SiteAdmin                   bit                NOT NULL,
 tp_IsActive                    bit                NOT NULL DEFAULT (1),
 tp_Login                       nvarchar(255)      NOT NULL,
 tp_Title                       nvarchar(255)      NOT NULL,
 tp_Email                       nvarchar(255)      NOT NULL,
 tp_Notes                       nvarchar(1023)     NOT NULL,
 tp_Token                       varbinary(max)     NULL,
 tp_ExternalToken               varbinary(max)     NULL,
 tp_ExternalTokenLastUpdated    datetime           NULL,
 tp_Locale                      int                NULL,
 tp_CalendarType                smallint           NULL,
 tp_AdjustHijriDays             smallint           NULL,
 tp_TimeZone                    smallint           NULL,
 tp_Time24                      bit                NULL,
 tp_AltCalendarType             tinyint            NULL,
 tp_CalendarViewOptions         tinyint            NULL,
 tp_WorkDays                    smallint           NULL,
 tp_WorkDayStartHour            smallint           NULL,
 tp_WorkDayEndHour              smallint           NULL,
 tp_Mobile                      nvarchar(127)      NULL,
 tp_MUILanguages                varchar(64)        NULL,
 tp_ContentLanguages            varchar(64)        NULL,
 tp_Flags                       int                NOT NULL DEFAULT (0),
 );

tp_SiteID: The Site Collection Identifier (section 2.2.1.1.9) of the site collection associated with the principal (1).

tp_Id: The User Identifier (section 2.2.1.1.13) of the principal, which MUST be unique within both this table and the group identifiers for permission levels. Certain User Identifiers are predefined, such as the system account (1073741823), the site collection owner (1), and the secondary site collection contact (2). User Identifier values of 0 and -1 MUST NOT be used in the table.

tp_DomainGroup: A bit set to 1 if the principal is a domain group; otherwise, 0, specifying that the principal is a user.

tp_SystemID: The SystemId of the principal.

tp_Deleted: A value specifying whether the principal is marked as deleted. If tp_Deleted is 0, the principal is not deleted. If tp_Deleted is not 0, the principal is marked as deleted, and the value is the User Identifier that was associated with this principal. The deleted state can be used for user information, rather than dropping entries from the table, to preserve list item ownership information. A user or domain group with the tp_Deleted value set to nonzero can be restored by setting the tp_Deleted value to 0 and updating other fields as necessary.

tp_SiteAdmin: A bit set to 1 if the principal is a site collection administrator for the site collection.

tp_IsActive: A bit set to 1 if the principal is an active user in the site collection.

tp_Login: The login name for the principal. This value MUST NOT be empty.

tp_Title: The display name for the principal. This value MUST NOT be empty.

tp_Email: The e-mail address for the principal. This value can be empty.

tp_Notes: A descriptive text about the principal. This value can be empty.

tp_Token: A WSS User Token (section 2.2.3.10) value specifying the permission level membership of the principal. This can be NULL, indicating that the principal is not a member of a permission level.

tp_ExternalToken: An External Group Token (section 2.2.3.2) value encoding information on external group membership derived from an external authentication role provider. This value can be NULL, indicating that this user has never visited any site in the site collection. If this value is NULL, the value in tp_ExternalTokenLastUpdated MUST also be NULL.

tp_ExternalTokenLastUpdated: A datetime containing a time stamp in UTC format specifying the time when the value in tp_ExternalToken for the principal was last updated. This can be NULL if the value in tp_ExternalToken has never been updated.

tp_Locale: An LCID specifying the preferred locale value to be used when displaying messages in the front-end Web server for the principal. This can be NULL, specifying that the system or site default locale can be used instead.

tp_CalendarType: The Calendar Type to be used when processing date values for the principal. This can be NULL, specifying that the site default Calendar Type can be used instead.

tp_AdjustHijriDays: If the tp_CalendarType value is "6", this specifies the number of days to extend or reduce the current month in Hijri calendars for the principal. Otherwise, this value MUST be NULL and MUST be ignored.

tp_TimeZone: The Time Zone Identifier for the time zone to be used when displaying time values for the principal. This can be NULL, specifying that the system or site default time zone can be used instead.

tp_Time24: A bit flag specifying whether a 24-hour time format can be used when displaying time values to the principal. If tp_Time24 is 1, the 24-hour time format will be used; otherwise, the 12-hour time format will be used. This can be NULL, specifying that the system or site default can be used instead.

tp_AltCalendarType: The Calendar Type of an alternate calendar to be used when displaying calendars in views for the principal. This can be NULL, specifying that the tp_CalendarType value can be used instead.

tp_CalendarViewOptions: A Calendar View Options Type that specifies the calendar options for the principal. This can be NULL, specifying that the site default calendar view options can be used instead.

tp_WorkDays: A set of Workdays Flags that specify the weekdays defined as the workweek for the principal. This can be NULL, specifying that the site default Workdays value can be used instead.

tp_WorkDayStartHour: The start time of the workday in minutes after midnight for the principal. This can be NULL, specifying that the site default workday start hour can be used instead.

tp_WorkDayEndHour: The end time of the workday in minutes after midnight for the principal. This can be NULL, specifying that the site default workday end hour can be used instead.

tp_Mobile: The mobile phone number of the security principal.

tp_MUILanguages: A string that contains the distinct culture(s) for the user's preferred display language(s), separated by semicolon. This string can be NULL.

tp_ContentLanguages: A string that contains the distinct culture(s) for the user's preferred content language(s), separated by semicolon. This string can be NULL.

tp_Flags: A 4-byte integer bit mask determining the user's options. For more details, see section 2.2.2.12.