The UserData table stores the data that is displayed in the lists.
| Column name | Data type | Description |
|---|
| tp_ID | int | ID of the data. |
| tp_ListId | uniqueidentifier | GUID of the list with which the data is associated. Found in the Lists table. |
| tp_SiteId | uniqueidentifier | GUID of the SharePoint site to which the data belongs. Found in the Sites table.
|
| tp_Version | int | Value that indicates the version of the data. |
| tp_Author | int | tp_ID from the UserInfo table of the user who entered the data. |
| tp_Editor | int | tp_ID from the UserInfo table of the user who last modified the data. |
| tp_Modified | datetime | Date and time the data was modified. |
| tp_Created | datetime | Date and time the data was created. |
| tp_Ordering | varchar | Field that specifies the order for threading Web discussion comments. |
| tp_HasAttachment | bit | Value that specifies whether the item has an associated attachment. |
| tp_ModerationStatus | int | Value that specifies the status of a list if it is moderated. 0 is approved; 2 is pending; 1 is rejected.
|
| tp_IsCurrent | bit | Value indicating whether the item is the current item in the issue tracking list. |
| tp_ItemOrder | float | Sort criterion for an ordered list. |
| tp_InstanceID | int | ID for an occurrence in a Meeting Workspace site that has a recurring event or multiple single events linked to it. |
| tp_GUID | uniqueidentifier | GUID value used in full-text search. |
| tp_Size | int | Size of the data. |
| nvarchar1 | nvarchar | Available field for custom information using the Microsoft SQL Server nvarchar data type. |
| nvarchar2 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar3 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar4 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar5 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar6 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar7 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar8 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar9 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar10 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar11 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar12 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar13 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar14 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar15 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar16 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar17 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar18 | nvarchar | Available field for custom information using the SQL Server nvarchar
data type.
|
| nvarchar19 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar20 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar21 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar22 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar23 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar24 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar25 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar26 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar27 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar28 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar29 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar30 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar31 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar32 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar33 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar34 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar35 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar36 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar37 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar38 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar39 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar40 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar41 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar42 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar43 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar44 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar45 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar46 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar47 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar48 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar49 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar50 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar51 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar52 | nvarchar | Available field for custom information using the SQL Server nvarchar
data type.
|
| nvarchar53 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar54 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar55 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar56 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar57 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar58 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar59 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar60 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar61 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar62 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar63 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| nvarchar64 | nvarchar | Available field for custom information using the SQL Server nvarchar data type.
|
| int1 | int | Available field for custom information using the SQL Server int data type. |
| int2 | int | Available field for custom information using the SQL Server int data type.
|
| int3 | int | Available field for custom information using the SQL Server int data type.
|
| int4 | int | Available field for custom information using the SQL Server int data type.
|
| int5 | int | Available field for custom information using the SQL Server int data type.
|
| int6 | int | Available field for custom information using the SQL Server int data type.
|
| int7 | int | Available field for custom information using the SQL Server int data type.
|
| int8 | int | Available field for custom information using the SQL Server int data type.
|
| int9 | int | Available field for custom information using the SQL Server int data type.
|
| int10 | int | Available field for custom information using the SQL Server int data type.
|
| int11 | int | Available field for custom information using the SQL Server int data type.
|
| int12 | int | Available field for custom information using the SQL Server int data type.
|
| int13 | int | Available field for custom information using the SQL Server int data type.
|
| int14 | int | Available field for custom information using the SQL Server int data type.
|
| int15 | int | Available field for custom information using the SQL Server int data type.
|
| int16 | int | Available field for custom information using the SQL Server int data type.
|
| float1 | float | Available field for custom information using the SQL Server float data type.
|
| float2 | float | Available field for custom information using the SQL Server float data type.
|
| float3 | float | Available field for custom information using the SQL Server float data type.
|
| float4 | float | Available field for custom information using the SQL Server float data type.
|
| float5 | float | Available field for custom information using the SQL Server float data type.
|
| float6 | float | Available field for custom information using the SQL Server float data type.
|
| float7 | float | Available field for custom information using the SQL Server float data type.
|
| float8 | float | Available field for custom information using the SQL Server float data type.
|
| float9 | float | Available field for custom information using the SQL Server float data type.
|
| float10 | float | Available field for custom information using the SQL Server float data type.
|
| float11 | float | Available field for custom information using the SQL Server float data type.
|
| float12 | float | Available field for custom information using the SQL Server float data type.
|
| float13 | float | Available field for custom information using the SQL Server float data type.
|
| float14 | float | Available field for custom information using the SQL Server float data type.
|
| float15 | float | Available field for custom information using the SQL Server float data type.
|
| float16 | float | Available field for custom information using the SQL Server float data type.
|
| float17 | float | Available field for custom information using the SQL Server float data type.
|
| float18 | float | Available field for custom information using the SQL Server float data type.
|
| float19 | float | Available field for custom information using the SQL Server float data type.
|
| float20 | float | Available field for custom information using the SQL Server float data type.
|
| float21 | float | Available field for custom information using the SQL Server float data type.
|
| float22 | float | Available field for custom information using the SQL Server float data type.
|
| float23 | float | Available field for custom information using the SQL Server float data type.
|
| float24 | float | Available field for custom information using the SQL Server float data type.
|
| float25 | float | Available field for custom information using the SQL Server float data type.
|
| float26 | float | Available field for custom information using the SQL Server float data type.
|
| float27 | float | Available field for custom information using the SQL Server float data type.
|
| float28 | float | Available field for custom information using the SQL Server float data type.
|
| float29 | float | Available field for custom information using the SQL Server float data type.
|
| float30 | float | Available field for custom information using the SQL Server float data type.
|
| float31 | float | Available field for custom information using the SQL Server float data type.
|
| float32 | float | Available field for custom information using the SQL Server float data type.
|
| datetime1 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime2 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime3 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime4 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime5 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime6 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime7 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime8 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime9 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime10 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime11 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime12 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime13 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime14 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime15 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| datetime16 | datetime | Available field for custom information using the SQL Server datetime data type.
|
| bit1 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit2 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit3 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit4 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit5 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit6 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit7 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit8 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit9 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit10 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit11 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit12 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit13 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit14 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit15 | bit | Available field for custom information using the SQL Server bit data type.
|
| bit16 | bit | Available field for custom information using the SQL Server bit data type.
|
| uniqueidentifier1 | uniqueidentifier | Available field for custom information using the SQL Server uniqueidentifier data type.
|
| ntext1 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext2 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext3 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext4 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext5 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext6 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext7 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext8 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext9 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext10 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext11 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext12 | ntext | Available field for custom information using the SQL Server ntext
data type.
|
| ntext13 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext14 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext15 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext16 | ntext | Available field for custom information using the SQL Serverntext data type.
|
| ntext17 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext18 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext19 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext20 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext21 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext22 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext23 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext24 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext25 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext26 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext27 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext28 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext29 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext30 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext31 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| ntext32 | ntext | Available field for custom information using the SQL Server ntext data type.
|
| sql_variant1 | sql_variant | Available field for custom information using the SQL Server sql_variant data type. |
| sql_variant2 | sql_variant | Available field for custom information using the SQL Server sql_variant data type.
|
| sql_variant3 | sql_variant | Available field for custom information using the SQL Server sql_variant data type.
|
| sql_variant4 | sql_variant | Available field for custom information using the SQL Server sql_variant data type.
|
| sql_variant5 | sql_variant | Available field for custom information using the SQL Server sql_variant data type.
|
| sql_variant6 | sql_variant | Available field for custom information using the SQL Server sql_variant data type.
|
| sql_variant7 | sql_variant | Available field for custom information using the SQL Server sql_variant data type.
|
| sql_variant8 | sql_variant | Available field for custom information using the SQL Server sql_variant data type.
|