SharePointSite Entity Metadata

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the SharePoint site entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is SharePointSite.

To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.

In This Topic

Entity Metadata

Privilege Metadata

Attribute Metadata

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

Entity Metadata

The following table shows the metadata for the SharePoint site entity.

Metadata property Value

EntityLogicalName

sharepointsite

DisplayName

SharePoint Site

DisplayCollectionName

SharePoint Sites

OTC

9502

OwnershipType

UserOwned

IsCustomizable

True

IsIntersect

False

AutoRouteToOwnerQueue

False

CanBeInManyToMany

True

CanBePrimaryEntityInRelationship

True

CanBeRelatedEntityInRelationship

True

CanCreateAttributes

True

CanCreateCharts

False

CanCreateForms

True

CanCreateViews

True

CanModifyAdditionalSettings

True

CanTriggerWorkflow

True

IsActivity

False

IsActivityParty

False

IsAuditEnabled

False

IsAvailableOffline

False

IsChildEntity

False

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsDocumentManagementEnabled

False

IsDuplicateDetectionEnabled

True

IsEnabledForCharts

False

IsImportable

True

IsMailMergeEnabled

False

IsManaged

True

IsMappable

True

IsReadingPaneEnabled

True

IsRenameable

True

IsValidForAdvancedFind

True

IsValidForQueue

False

IsVisibleInMobile

False

PrimaryIdAttribute

sharepointsiteid

PrimaryNameAttribute

name

ReportViewName

FilteredSharePointSite

RecurrenceBaseEntityLogicalName

Description

SharePoint site from where documents can be managed in Microsoft Dynamics CRM.

Privilege Metadata

The following table shows the privilege metadata for the SharePoint site entity.

PrivilegeName Id Type CanBeBasic CanBeDeep CanBeGlobal CanBeLocal

prvAppendSharePointSite

3eb82a81-00ad-4f57-827b-eb98ffe3e1f5

Append

False

True

True

True

prvAppendToSharePointSite

fac6ea8e-de45-41d0-a4e5-ea080a21f844

AppendTo

False

True

True

True

prvAssignSharePointSite

a55f7336-b1a7-4c4a-b0e6-ee0225e0fdf6

Assign

True

True

True

True

prvCreateSharePointSite

a4e95df4-9c6b-44f6-aa6a-888b7ef12737

Create

False

True

True

True

prvDeleteSharePointSite

90b9eb7a-480b-45ff-bc9c-5354540d5834

Delete

False

True

True

True

prvReadSharePointSite

93cafd0d-dbe1-4cb9-bb7b-e9f3a0c0464a

Read

False

True

True

True

prvShareSharePointSite

1a17ed0e-4434-4b98-bb1e-6d1df6952720

Share

True

True

True

True

prvWriteSharePointSite

967ba66e-6067-42e8-917f-34e8e798d08e

Write

False

True

True

True

Attribute Metadata

The following table shows the attribute metadata for the SharePoint site entity.

LogicalName SchemaName DisplayName Type RequiredLevel IsCustomizable IsValidForCreate IsValidForRead IsValidForUpdate IsCustomAttribute CanBeSecuredForCreate CanBeSecuredForRead CanBeSecuredForUpdate IsAuditEnabled IsManaged IsPrimaryId IsPrimaryName IsRenameable IsSecured IsValidForAdvancedFind Description DeprecatedVersion

absoluteurl

AbsoluteURL

Absolute URL

String

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Absolute URL of the SharePoint site.

createdby

CreatedBy

Created By

Lookup

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Unique identifier of the user who created the SharePoint site record.

createdon

CreatedOn

Created On

DateTime

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Date and time when the SharePoint site record was created.

createdonbehalfby

CreatedOnBehalfBy

Created By (Delegate)

Lookup

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Unique identifier of the delegate user who created the SharePoint site record.

description

Description

Description

Memo

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Description of the SharePoint site record.

exchangerate

ExchangeRate

Exchange Rate

Decimal

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Exchange rate between the currency associated with the SharePoint site record and the base currency.

folderstructureentity

FolderStructureEntity

Entity for SharePoint Folder Structure

EntityName

None

True

True

True

True

False

False

False

False

True

True

False

False

False

False

False

Entity on which the folder structure for Microsoft Dynamics CRM records will be created in SharePoint.

importsequencenumber

ImportSequenceNumber

Import Sequence Number

Integer

None

True

True

True

False

False

False

False

False

True

True

False

False

True

False

True

Sequence number of the import that created this record.

isdefault

IsDefault

Default Site

Boolean

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Indicates whether the SharePoint site is the default site or not.

isgridpresent

IsGridPresent

List component is installed

Boolean

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Indicates if SharePoint Grid is present or not.

lastvalidated

LastValidated

Last Validated

DateTime

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Date and time when the SharePoint site URL was last validated.

modifiedby

ModifiedBy

Modified By

Lookup

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Unique identifier of the user who last modified the SharePoint site record.

modifiedon

ModifiedOn

Modified On

DateTime

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Date and time when the SharePoint site record was last modified.

modifiedonbehalfby

ModifiedOnBehalfBy

Modified By (Delegate)

Lookup

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Unique identifier of the delegate user who modified the SharePoint site record.

name

Name

Name

String

SystemRequired

True

True

True

True

False

False

False

False

True

True

False

True

True

False

True

Name of the SharePoint site record.

overriddencreatedon

OverriddenCreatedOn

Record Created On

DateTime

None

True

True

True

False

False

False

False

False

True

True

False

False

True

False

True

Date and time that the record was migrated.

ownerid

OwnerId

Owner

Owner

SystemRequired

True

True

True

False

False

False

False

False

True

True

False

False

True

False

True

Unique identifier of the user or team who owns the SharePoint site.

owningbusinessunit

OwningBusinessUnit

Owning Business Unit

Lookup

None

True

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Unique identifier for the business unit that owns the document location record.

owningteam

OwningTeam

Owning Team

Lookup

None

True

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Unique identifier of the team that owns the SharePoint site record.

owninguser

OwningUser

Owning User

Lookup

None

True

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Unique identifier of the user who owns the SharePoint site record.

parentsite

ParentSite

Parent Site

Lookup

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Unique identifier of the parent SharePoint site.

relativeurl

RelativeUrl

Relative URL

String

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Relative URL of the SharePoint site.

sharepointsiteid

SharePointSiteId

SharePointSiteId

Uniqueidentifier

SystemRequired

True

True

True

False

False

False

False

False

False

True

True

False

True

False

True

Unique identifier of the SharePoint site in CRM

sitecollectionid

SiteCollectionId

Uniqueidentifier

None

False

False

True

False

False

False

False

False

False

True

False

False

False

False

False

For internal use only.

statecode

StateCode

Status

State

SystemRequired

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Status of the SharePoint site record.

statuscode

StatusCode

Status Reason

Status

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Reason for the status of the SharePoint site record.

timezoneruleversionnumber

TimeZoneRuleVersionNumber

Integer

None

True

True

True

True

False

False

False

False

False

True

False

False

False

False

False

For internal use only.

transactioncurrencyid

TransactionCurrencyId

Currency

Lookup

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Unique identifier of the currency associated with the SharePoint site record.

utcconversiontimezonecode

UTCConversionTimeZoneCode

Integer

None

True

True

True

True

False

False

False

False

False

True

False

False

False

False

False

Time zone code that was in use when the record was created.

validationstatus

ValidationStatus

Last Validation Status

Picklist

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Validation status of the SharePoint site URL.

validationstatuserrorcode

ValidationStatusErrorCode

Additional Information

Picklist

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Reason for validation status of the URL

versionnumber

VersionNumber

BigInt

None

False

False

True

False

False

False

False

False

False

True

False

False

False

False

False

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the SharePoint site entity.

Relationship schema name Referencing entity

SharePointSite_AsyncOperations

asyncoperation

SharePointSite_DuplicateBaseRecord

duplicaterecord

SharePointSite_DuplicateMatchingRecord

duplicaterecord

sharepointsite_principalobjectattributeaccess

principalobjectattributeaccess

SharePointSite_ProcessSessions

processsession

sharepointdocumentlocation_parent_sharepointsite

sharepointdocumentlocation

sharepointsite_parentsite_sharepointsite

sharepointsite

userentityinstancedata_sharepointsite

userentityinstancedata

Many-to-Many Relationships

There are no many-to-many relationships for the SharePoint site entity.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the SharePoint site entity.

Relationship schema name Referenced entity

business_unit_sharepointsites

businessunit

owner_sharepointsite

owner

sharepointsite_parentsite_sharepointsite

sharepointsite

user_sharepointsite

systemuser

lk_sharepointsitebase_modifiedonbehalfby

systemuser

lk_sharepointsitebase_createdby

systemuser

lk_sharepointsitebase_createdonbehalfby

systemuser

lk_sharepointsitebase_modifiedby

systemuser

team_sharepointsite

team

TransactionCurrency_SharePointSite

transactioncurrency

See Also

Reference

EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata

Concepts

SharePointSite Entity Messages and Methods
SharePointSite Entity Privileges

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.