Wednesday, February 17, 2010

SharePoint Reference Sheet

While creating Features, Web Parts, Web Service calls or Site Templates or even basic DataViews at many places you required to have some short of reference chart mostly to write CAML related stuff.

So after having my few hours I created this handy reference sheet useful at many places.

You can use this sheet at many places like "BaseType" values (just below) are always useful as part of SPSiteDataQuery :

<Lists BaseType='0′ MaxListLimit='0′/> or similar goes for "Server Template"

<Lists ServerTemplate='303′ MaxListLimit='0′/>

Another handy example is "FieldType" again which is useful in CAML queries.

<FieldRef Name='MyLookupField'/><Value Type='Lookup'>

Endless possibilities. Be patient to load this huge page (And sincere apology for SMALL fonts, hard to fit in screen)

Don't forget to comment back If I am missing something that should be here too .

Type

Name

Value

Summary

SPBaseType

GenericList

0

Generic type of list template used for most lists.

or

DocumentLibrary

1

Document library.

BaseType

Unused

2

Unused.

 

DiscussionBoard

3

Discussion board.

 

Survey

4

Survey list.

 

Issue

5

Issue-tracking list.

 

UnspecifiedBaseType

-1

 
    
    

SPListCategoryType

None

0

 
 

Libraries

1

 
 

Communications

2

 
 

Tracking

3

 
 

CustomLists

4

 
    
    

SPListTemplateType

GenericList

100

Custom list.

or

DocumentLibrary

101

Document library.


ServerTemplate

Survey

102

Survey.

 

Links

103

Links.

 

Announcements

104

Announcements.

 

Contacts

105

Contacts.

 

Events

106

Calendar.

 

Tasks

107

Tasks.

 

DiscussionBoard

108

Discussion board.

 

PictureLibrary

109

Picture library.

 

DataSources

110

Data sources for a site.

 

WebTemplateCatalog

111

Site template gallery.

 

UserInformation

112

User Information.

 

WebPartCatalog

113

Web Part gallery.

 

ListTemplateCatalog

114

List template gallery.

 

XMLForm

115

XML Form library.

 

MasterPageCatalog

116

Master Page gallery.

 

NoCodeWorkflows

117

No Code Workflows.

 

WorkflowProcess

118

Custom Workflow Process.

 

WebPageLibrary

119

Wiki Page Library.

 

CustomGrid

120

Custom grid for a list.

 

DataConnectionLibrary

130

 
 

WorkflowHistory

140

Workflow History.

 

GanttTasks

150

Project Tasks.

 

Meetings

200

Meeting Series (Meeting).

 

Agenda

201

Agenda (Meeting).

 

MeetingUser

202

Attendees (Meeting).

 

Decision

204

Decisions (Meeting).

 

MeetingObjective

207

Objectives (Meeting).

 

TextBox

210

Text Box (Meeting).

 

ThingsToBring

211

Things To Bring (Meeting).

 

HomePageLibrary

212

Workspace Pages (Meeting).

 

Posts

301

Posts (Blog).

 

Comments

302

Comments (Blog).

 

Categories

303

Categories (Blog).

 

IssueTracking

1100

Issue tracking.

 

AdminTasks

1200

Administrator Tasks.

 

InvalidType

-1

Not used.

    
    

SPFieldType

Invalid

0

Not used.

or

Integer

1

Contains positive or negative integer values.

Value Type

Text

2

Contains a single line of text.

 

Note

3

Specifies a field that can contain multiple lines of text.

 

DateTime

4

Contains date and time values.

 

Counter

5

Contains an integer used for internal ID fields.

 

Choice

6

Specifies a predetermined set of values that can be used to enter data into the field.

 

Lookup

7

Contains references to values in other lists.

 

Boolean

8

Contains Boolean values that are stored in the database as 1 or 0.

 

Number

9

Contains floating point numbers.

 

Currency

10

Contains currency values formatted based on a specific locale.

 

URL

11

Contains hyperlinks.

 

Computed

12

Specifies an abstract field type that depends on other fields for its content and definition.

 

Threading

13

Specifies a field that is used in the creation and display of threaded Web discussions.

 

Guid

14

Contains GUIDs.

 

MultiChoice

15

Contains multiple values per list item.

 

GridChoice

16

Specifies a Choice field for a data sheet.

 

Calculated

17

Contains calculated values.

 

File

18

Contains files.

 

Attachments

19

Contains attachments.

 

User

20

Specifies users of a SharePoint site.

 

Recurrence

21

Specifies a field used in calendars for recurring events and, like computed fields, an abstract field type that depends on other fields for its content and definition.

 

CrossProjectLink

22

Specifies a link between projects in a Meetings Workspace site.

 

ModStat

23

Specifies Content Approval status.

 

Error

24

Contains errors.

 

ContentTypeId

25

 
 

PageSeparator

26

 
 

ThreadIndex

27

 
 

WorkflowStatus

28

 
 

AllDayEvent

29

 
 

WorkflowEventType

30

 
 

MaxItems

31

Contains the maximum number of items.

    
    

SPListEventType

Insert

0

A new document is saved to the library.

 

Update

1

A document in the library is edited.

 

Delete

2

A document in the library is deleted.

 

Move

3

A document is moved or renamed in the library.

 

Copy

4

A document is copied within the document library. If a document is copied to a location outside the document library, a Delete event occurs.

 

CheckIn

5

A document is checked into the library.

 

CheckOut

6

A document is checked out from the library.

 

UncheckOut

7

The check-out of a document is undone.

 

Invalid

-1

Unused.

    
    

DefaultItemOpen

PreferClient

0

Open the item in a client application.

 

Browser

1

Use the browser to open the item.

    
    

DraftVisibilityType

Reader

0

Reader. Value = 0.

 

Author

1

Author. Value = 1.

 

Approver

2

Approver. Value = 2.

    
    

OfficialFileResult

Success

0

 
 

MoreInformation

1

 
 

InvalidConfiguration

2

 
 

NotFound

3

 
 

FileRejected

4

 
 

FileCheckedOut

5

 
 

UnknownError

6

 
    
    

PAGETYPE

PAGE_DEFAULTVIEW

0

Default view. Value=0.

 

PAGE_NORMALVIEW

1

Normal view. Value=1.

 

PAGE_DIALOGVIEW

2

File dialog box view. Value=2.

 

PAGE_VIEW

3

View, including both default view and normal view. Value=3.

 

PAGE_DISPLAYFORM

4

Display form for list items. Value=4.

 

PAGE_DISPLAYFORMDIALOG

5

Display form for a file dialog box. Value=5.

 

PAGE_EDITFORM

6

Edit form for list items. Value=6.

 

PAGE_EDITFORMDIALOG

7

Edit form for a file dialog box. Value=7.

 

PAGE_NEWFORM

8

New form for list items. Value=8.

 

PAGE_NEWFORMDIALOG

9

New form for a file dialog box. Value=9.

 

PAGE_SOLUTIONFORM

10

Solution form. Value=10.

 

PAGE_MAXITEMS

11

Not used. Value=11.

 

PAGE_INVALID

-1

Not used. Value= -1.

    
    

RequestResources

None

0

 
 

UserInfoList

1

 
 

WebProperties

2

 
 

Features

4

 
 

NavigationStructure

8

 
    
    

SPAddFieldOptions

Default

0

 
 

AddToDefaultContentType

1

 
 

AddToNoContentType

2

 
 

AddToAllContentTypes

4

 
 

AddFieldInternalNameHint

8

 
 

AddFieldToDefaultView

16

 
 

AddFieldCheckDisplayName

32

 
    
    

SPAlertFrequency

Immediate

0

Send immediately when the list or list item changes.

 

Daily

1

Send daily.

 

Weekly

2

Send weekly.

    
    

SPAlertStatus

On

0

The alert is implemented.

 

Off

1

The alert is not implemented.

 

Error

2

The alert is not functional.

    
    

SPAlertType

List

0

Applies to a list.

 

Item

1

Applies to a list item.

 

Custom

2

Applies to a custom object.

    
    

SPBasePermissions

EmptyMask

0

Has no permissions on the Web site. Not available through the user interface.

 

ViewListItems

1

View items in lists, documents in document libraries, and view Web discussion comments.

 

AddListItems

2

Add items to lists, add documents to document libraries, and add Web discussion comments.

 

EditListItems

4

Edit items in lists, edit documents in document libraries, edit Web discussion comments in documents, and customize Web Part Pages in document libraries.

 

DeleteListItems

8

Delete items from a list, documents from a document library, and Web discussion comments in documents.

 

ApproveItems

16

Approve a minor version of a list item or document.

 

OpenItems

32

View the source of documents with server-side file handlers.

 

ViewVersions

64

View past versions of a list item or document.

 

DeleteVersions

128

Delete past versions of a list item or document.

 

CancelCheckout

256

Discard or check in a document which is checked out to another user.

 

ManagePersonalViews

512

Create, change, and delete personal views of lists.

 

ManageLists

2048

Create and delete lists, add or remove columns in a list, and add or remove public views of a list.

 

ViewFormPages

4096

View forms, views, and application pages. Enumerate lists.

 

Open

65536

Allows users to open a Web site, list, or folder in order to access items inside that container.

 

ViewPages

131072

View pages in a Web site.

 

AddAndCustomizePages

262144

Add, change, or delete HTML pages or Web Part Pages, and edit the Web site using a Windows SharePoint Services-compatible editor.

 

ApplyThemeAndBorder

524288

Apply a theme or borders to the entire Web site.

 

ApplyStyleSheets

1048576

Apply a style sheet (.CSS file) to the Web site.

 

ViewUsageData

2097152

View reports on Web site usage.

 

CreateSSCSite

4194304

Create a Web site using Self-Service Site Creation.

 

ManageSubwebs

8388608

Create subsites such as team sites, Meeting Workspace sites, and Document Workspace sites. Activate, deactivate, or edit properties of site collection-scoped Features. NoteÿÿÿThrough the user interface, to browse to the Site Collection Features page and activate or deactivate site collection-scoped Features, you must be the site collection administrator.

 

CreateGroups

16777216

Create a group of users that can be used anywhere within the site collection.

 

ManagePermissions

33554432

Create and change permission levels on the Web site and assign permissions to users and groups.

 

BrowseDirectories

67108864

Enumerate files and folders in a Web site using Microsoft SharePoint Designer and Web DAV interfaces.

 

BrowseUserInfo

134217728

View information about users of the Web site.

 

AddDelPrivateWebParts

268435456

Add or remove personal Web Parts on a Web Part Page.

 

UpdatePersonalWebParts

536870912

Update Web Parts to display personalized information.

 

ManageWeb

1073741824

Grants the ability to perform all administration tasks for the Web site as well as manage content.

 

UseClientIntegration

0

 
 

UseRemoteAPIs

0

Use SOAP, Web DAV, or Microsoft SharePoint Designer interfaces to access the Web site.

 

ManageAlerts

0

Manage alerts for all users of the Web site.

 

CreateAlerts

0

Create e-mail alerts.

 

EditMyUserInfo

0

Allows a user to change his or her own user information, such as adding a picture.

 

EnumeratePermissions

0

Enumerate permissions on the Web site, list, folder, document, or list item.

 

FullMask

-1

Has all permissions on the Web site. Not available through the user interface.

    
    

SPCalendarOrderType

MDY

0

Month-Day-Year

 

DMY

1

Day-Month-Year

 

YMD

2

Year-Month-Day

    
    

SPCalendarType

None

0

No type specified. Value=0.

 

Gregorian

1

Gregorian. Value=1.

 

Japan

3

Japanese Emperor Era. Value=3.

 

Taiwan

4

Taiwan Era. Value=4.

 

Korea

5

Korean Tangun Era. Value=5.

 

Hijri

6

Hijri (Arabic lunar). Value=6.

 

Thai

7

Thai. Value=7.

 

Hebrew

8

Hebrew (lunar). Value=8.

 

GregorianMEFrench

9

Gregorian Middle East French. Value=9.

 

GregorianArabic

10

Gregorian Arabic. Value=10.

 

GregorianXLITEnglish

11

Gregorian transliterated English. Value=11.

 

GregorianXLITFrench

12

Gregorian transliterated French. Value=12.

 

KoreaJapanLunar

14

Korean and Japanese lunar. Value=14.

 

ChineseLunar

15

Chinese lunar. Value=15.

 

SakaEra

16

Saka Era. Value=16.

    
    

SPCheckinType

MinorCheckIn

0

Incremented as a minor version. Value=0.

 

MajorCheckIn

1

Incremented as a major version. Value=1.

 

OverwriteCheckIn

2

Overwrite the file. Value=2.

    
    

SPChoiceFormatType

Dropdown

0

Drop-down list box.

 

RadioButtons

1

Option buttons.

    
    

SPEventReceiverType

ItemAdding

1

An item is being added.

 

ItemUpdating

2

An item is being updated.

 

ItemDeleting

3

An item is being deleted.

 

ItemCheckingIn

4

An item is being checked in.

 

ItemCheckingOut

5

An item is being checked out.

 

ItemUncheckingOut

6

An item is being unchecked out.

 

ItemAttachmentAdding

7

An attachment is being added to the item.

 

ItemAttachmentDeleting

8

An attachment is being removed from the item.

 

ItemFileMoving

9

A file is being moved.

 

FieldAdding

101

A field is being added.

 

FieldUpdating

102

A field is being updated.

 

FieldDeleting

103

A field is being removed.

 

SiteDeleting

201

A site collection is being deleted.

 

WebDeleting

202

A site is being deleted.

 

WebMoving

203

A site is being moved.

 

ItemAdded

10001

An item was added.

 

ItemUpdated

10002

An item was updated.

 

ItemDeleted

10003

An item was deleted.

 

ItemCheckedIn

10004

An item was checked in.

 

ItemCheckedOut

10005

An item was checked out.

 

ItemUncheckedOut

10006

An item was unchecked out.

 

ItemAttachmentAdded

10007

An attachment was added to the item.

 

ItemAttachmentDeleted

10008

An attachment was removed from the item.

 

ItemFileMoved

10009

A file was moved.

 

ItemFileConverted

10010

A file was converted.

 

FieldAdded

10101

A field was added.

 

FieldUpdated

10102

A field was updated.

 

FieldDeleted

10103

A field was removed.

 

SiteDeleted

10201

A site collection was deleted.

 

WebDeleted

10202

A site was deleted.

 

WebMoved

10203

A site was moved.

 

EmailReceived

20000

The list received an e-mail message.

 

ContextEvent

32766

The list received a context event.

 

InvalidReceiver

-1

Invalid.

    
    

SPEventType

Add

1

Additions to the list or list item.

 

Modify

2

All changes made in a list or list item.

 

Delete

4

Deletion of a list or list item.

 

Discussion

4080

Changes in Web discussions.

 

All

-1

All events pertaining to the list or list item.

    
    

SPFeatureScope

Farm

0

Specifies server farm.

 

WebApplication

1

Specifies Web application.

 

Site

2

Specifies site collection.

 

Web

3

Specifies Web site.

 

ScopeInvalid

-1

Specifies that the scope is not valid.

    
    

SPFieldType

Invalid

0

Not used.

 

Integer

1

Contains positive or negative integer values.

 

Text

2

Contains a single line of text.

 

Note

3

Specifies a field that can contain multiple lines of text.

 

DateTime

4

Contains date and time values.

 

Counter

5

Contains an integer used for internal ID fields.

 

Choice

6

Specifies a predetermined set of values that can be used to enter data into the field.

 

Lookup

7

Contains references to values in other lists.

 

Boolean

8

Contains Boolean values that are stored in the database as 1 or 0.

 

Number

9

Contains floating point numbers.

 

Currency

10

Contains currency values formatted based on a specific locale.

 

URL

11

Contains hyperlinks.

 

Computed

12

Specifies an abstract field type that depends on other fields for its content and definition.

 

Threading

13

Specifies a field that is used in the creation and display of threaded Web discussions.

 

Guid

14

Contains GUIDs.

 

MultiChoice

15

Contains multiple values per list item.

 

GridChoice

16

Specifies a Choice field for a data sheet.

 

Calculated

17

Contains calculated values.

 

File

18

Contains files.

 

Attachments

19

Contains attachments.

 

User

20

Specifies users of a SharePoint site.

 

Recurrence

21

Specifies a field used in calendars for recurring events and, like computed fields, an abstract field type that depends on other fields for its content and definition.

 

CrossProjectLink

22

Specifies a link between projects in a Meetings Workspace site.

 

ModStat

23

Specifies Content Approval status.

 

Error

24

Contains errors.

 

ContentTypeId

25

 
 

PageSeparator

26

 
 

ThreadIndex

27

 
 

WorkflowStatus

28

 
 

AllDayEvent

29

 
 

WorkflowEventType

30

 
 

MaxItems

31

Contains the maximum number of items.

    
    

SPListEventType

Insert

0

A new document is saved to the library.

 

Update

1

A document in the library is edited.

 

Delete

2

A document in the library is deleted.

 

Move

3

A document is moved or renamed in the library.

 

Copy

4

A document is copied within the document library. If a document is copied to a location outside the document library, a Delete event occurs.

 

CheckIn

5

A document is checked into the library.

 

CheckOut

6

A document is checked out from the library.

 

UncheckOut

7

The check-out of a document is undone.

 

Invalid

-1

Unused.

    
    

SPRights

EmptyMask

0

Value: 0×00000000. Has no permissions on the Web site. Not available through the user interface. Groups: N/A.

 

ViewListItems

1

Value: 0×00000001. View items in lists, documents in document libraries, view Web discussion comments, and set up e-mail alerts for lists. Groups: Reader, Contributor, Web Designer, Administrator.

 

AddListItems

2

Value: 0×00000002. Add items to lists, add documents to document libraries, and add Web discussion comments. Groups: Contributor, Web Designer, Administrator.

 

EditListItems

4

Value: 0×00000004. Edit items in lists, edit documents in document libraries, edit Web discussion comments in documents, and customize Web Part Pages in document libraries. Groups: Contributor, Web Designer, Administrator.

 

DeleteListItems

8

Value: 0×00000008. Delete items from a list, documents from a document library, and Web discussion comments in documents. Groups: Contributor, Web Designer, Administrator.

 

CancelCheckout

256

Value: 0×00000100. Check in a document without saving the current changes. Groups: Web Designer, Administrator.

 

ManagePersonalViews

512

Value: 0×00000200. Create, change, and delete personal views of lists. Groups: Contributor, Web Designer, Administrator.

 

ManageListPermissions

1024

Value: 0×00000400. Grant, deny, or change user permissions to a list. Groups: Administrator.

 

ManageLists

2048

Value: 0×00000800. Approve content in lists, add or remove columns in a list, and add or remove public views of a list. Groups: Web Designer, Administrator.

 

OpenWeb

65536

Value: 0×00010000. Open the SharePoint Web site and get metadata related to the site, as well as see the underlying navigation structure (not exposed in the user interface). Groups: Guest, Reader, Contributor, Web Designer, Administrator.

 

ViewPages

131072

Value: 0×00020000. View pages in a Web site. Groups: Reader, Contributor, Web Designer, Administrator.

 

AddAndCustomizePages

262144

Value: 0×00040000. Add, change, or delete ASPX pages, HTML pages, or Web Part Pages, and edit the Web site using a Windows SharePoint Services-compatible editor. Groups: Web Designer, Administrator.

 

ApplyThemeAndBorder

524288

Value: 0×00080000. Apply a theme or borders to the entire Web site. Groups: Web Designer, Administrator.

 

ApplyStyleSheets

1048576

Value: 0×00100000. Apply a style sheet (.CSS file) to the Web site. Groups: Web Designer, Administrator.

 

ViewUsageData

2097152

Value: 0×00200000. View reports on Web site usage. Groups: Administrator.

 

CreateSSCSite

4194304

Value: 0×00400000. Create a Web site using Self-Service Site Creation. Groups: Reader, Contributor, Web Designer, Administrator.

 

ManageSubwebs

8388608

Value: 0×00800000. Manage or create subsites. Groups: Administrator.

 

CreatePersonalGroups

16777216

Value: 0×01000000. Create, change, and delete site groups, including adding users to the site groups and specifying which rights are assigned to a site group. Groups: Contributor, Web Designer, Administrator.

 

ManageRoles

33554432

Value: 0×02000000. Create, change, and delete site groups, including adding users to the site groups and specifying which rights are assigned to a site group. Groups: Administrator.

 

BrowseDirectories

67108864

Value: 0×04000000. Browse directories in a Web site. Groups: Contributor, Web Designer, Administrator.

 

BrowseUserInfo

134217728

Value: 0×08000000. View information about users. This right is not available through the user interface. Guest, Reader, Contributor, Web Designer, Administrator.

 

AddDelPrivateWebParts

268435456

Value: 0×10000000. Add or remove Web Parts on a personalized Web Part Page. Groups: Contributor, Web Designer, Administrator.

 

UpdatePersonalWebParts

536870912

Value: 0×20000000. Update Web Parts to display personalized information. Groups: Contributor, Web Designer, Administrator.

 

ManageWeb

1073741824

Value: 0×40000000. Manage a site, including the ability to perform all administration tasks for the site and manage contents and permissions. Groups: Administrator.

 

FullMask

-1

Value: -1. Has all permissions on the Web site. Not available through the user interface. Groups: N/A.

    
    

SPRoleType

None

0

Has no rights on the Web site.

 

Guest

1

Has limited rights to view pages and specific page elements. This site group is used for giving users access to a particular page, list, or item in a list, without granting them rights to view the entire site. Users cannot be explicitly added to the Guest site group, rather users who are given access to lists or document libraries by way of per-list permissions are automatically added to the Guest site group. The Guest site group cannot be customized or deleted.

 

Reader

2

Has rights to view items, personalize Web parts, use alerts, and create their own top-level Web site using Self-Service Site Creation. Readers can only read a site; they cannot add content. Note that when a reader creates a site using Self-Service Site Creation, he or she becomes the site owner and a member of the Administrator site group for the new site. This does not affect the users site group membership for any other site. Rights included: CreateSSCSite, ViewListItems, ViewPages.

 

Contributor

3

Has Reader rights, plus rights to add, edit, and delete items, manage list permissions, manage personal views, personalize Web Part Pages, and browse directories. Contributors cannot create new lists or document libraries, but they can add content to existing lists and document libraries. All rights included in the Reader site group, plus the following: AddDelPrivateWebParts, AddListItems, BrowseDirectories, CreatePersonalGroups, DeleteListItems, EditListItems, ManagePersonalViews, UpdatePersonalWebParts.

 

WebDesigner

4

Has Contributor rights, plus rights to cancel checkout, delete items, manage lists, add and customize pages, define and apply themes and borders, and link style sheets. Web Designers can modify the structure of the site and create new lists or document libraries. All rights included in the Contributor site group, plus the following: AddAndCustomizePages, ApplyStyleSheets, ApplyThemeAndBorder, CancelCheckout, ManageLists.

 

Administrator

5

Has all rights from other site groups, plus rights to manage site groups and view usage analysis data. The Administrator site group cannot be customized or deleted, and there must always be at least one member of the Administrator site group. Members of the Administrator site group always have access to, or can grant themselves access to, any item in the Web site. All rights included in the WebDesigner site group, plus the following: ManageListPermissions, ManageRoles, ManageSubwebs, ViewUsageData.

    
    

MeetingListTemplateType

MeetingEvents

200

Specifies the template for the list that displays the meeting events.

 

MeetingEvents

200

Specifies the template for the list that displays the meeting events.

 

MeetingAgenda

201

Specifies the template for the list that displays the agenda of the meeting.

 

MeetingAttendees

202

Specifies the template for the list that displays the attendees of the meeting.

 

MeetingDecisions

204

Specifies the template for the list that displays the meeting decisions.

 

MeetingObjectives

207

Specifies the template for the list that displays the meeting objectives.

 

MeetingTextbox

210

Specifies the template for the list that displays the meeting text box.

 

MeetingThingsToBring

211

Specifies the template for the list that displays the things to bring for the meeting.

 

MeetingEnd

212

Specifies the template for the list that displays the meeting end date.

 

MeetingEnd

212

Specifies the template for the list that displays the meeting end date.

 

MeetingMax

299

Specifies the template for the list that displays the meeting results.

    
    

SPDateFormat

DateTime

0

Both the date and the time are included.

 

DateOnly

1

Only the date is included.

 

TimeOnly

2

Only the time is included.

 

ISO8601

3

ISO8601 time format converted to coordinated universal time (UTC) in the format YYYY-MM-DDTHH:MM:SSZ.

 

MonthDayOnly

4

 
    
    

SPDataSourceMode

List

0

 
 

ListOfLists

1

 
 

CrossList

2

 
 

Webs

3

 
 

ListItem

4

 
    
    

ViewType

None

0

View is undefined.

 

Grid

1

Display as a client ActiveX control.

 

Html

2

Display as a server HTML view.

 

Chart

3

Display as a graphical summary.

 

Calendar

4

 
 

Gantt

5

 
    
    

SPWorkflowState

None

0

 
 

Locked

1

 
 

Running

2

 
 

Completed

4

 
 

Cancelled

8

 
 

Expiring

16

 
 

Expired

32

 
 

Faulting

64

 
 

Terminated

128

 
 

Suspended

256

 
 

Orphaned

512

 
 

HasNewEvents

1024

 
 

NotStarted

2048

 
 

All

4095

 
    
    

SPWorkflowStatus

NotStarted

0

 
 

FailedOnStart

1

 
 

InProgress

2

 
 

ErrorOccurred

3

 
 

StoppedByUser

4

 
 

Completed

5

 
 

FailedOnStartRetrying

6

 
 

ErrorOccurredRetrying

7

 
 

ViewQueryOverflow

8

 
 

Max

15

 
    
    


SPFileLevel

Published

1

Published. Value=1.

 

Draft

2

Draft stage. Value=2.

 

Checkout

255

Checked out. Value=255.

    
    


Template Name

GLOBAL#0

 

Global template (1033)

 

STS#0

 

Team Site (1033)

 

STS#1

 

Blank Site (1033)

 

STS#2

 

Document Workspace (1033)

 

MPS#0

 

Basic Meeting Workspace (1033)

 

MPS#1

 

Blank Meeting Workspace (1033)

 

MPS#2

 

Decision Meeting Workspace (1033)

 

MPS#3

 

Social Meeting Workspace (1033)

 

MPS#4

 

Multipage Meeting Workspace (1033)

 

CENTRALADMIN#0

 

Central Admin Site (1033)

 

WIKI#0

 

Wiki Site (1033)

 

BLOG#0

 

Blog (1033)

 

BDR#0

 

Document Center (1033)

 

OFFILE#0

 

Records Center (1033)

 

OFFILE#1

 

Records Center (1033)

 

OSRV#0

 

Shared Services Administration Site (1033)

 

SPS#0

 

SharePoint Portal Server Site (1033)

 

SPSPERS#0

 

SharePoint Portal Server Personal Space (1033)

 

SPSMSITE#0

 

Personalization Site (1033)

 

SPSTOC#0

 

Contents area Template (1033)

 

SPSTOPIC#0

 

Topic area template (1033)

 

SPSNEWS#0

 

News Site (1033)

 

CMSPUBLISHING#0

 

Publishing Site (1033)

 

BLANKINTERNET#0

 

Publishing Site (1033)

 

BLANKINTERNET#1

 

Press Releases Site (1033)

 

BLANKINTERNET#2

 

Publishing Site with Workflow (1033)

 

SPSNHOME#0

 

News Site (1033)

 

SPSSITES#0

 

Site Directory (1033)

 

SPSCOMMU#0

 

Community area template (1033)

 

SPSREPORTCENTER#0

 

Report Center (1033)

 

SPSPORTAL#0

 

Collaboration Portal (1033)

 

SRCHCEN#0

 

Search Center with Tabs (1033)

 

PROFILES#0

 

Profiles (1033)

 

BLANKINTERNETCONTAINER#0

 

Publishing Portal (1033)

 

SPSMSITEHOST#0

 

My Site Host (1033)

 

SRCHCENTERLITE#0

 

Search Center (1033)

 

SRCHCENTERLITE#1

 

Search Center (1033)

 

SPSBWEB#0

 

SharePoint Portal Server BucketWeb Template (1033)