msdyn_ocsession table

Session for interacting with a customer

Added by: Omnichannel – Base Solution

Messages

Message	Web API Operation	SDK Assembly
Assign	PATCH [org URI]/api/data/v9.0/msdyn_ocsessions(activityid) Update ownerid property.	AssignRequest
Create	POST [org URI]/api/data/v9.0/msdyn_ocsessions See Create	CreateRequest or Create
CreateMultiple	CreateMultiple Action	CreateMultipleRequest
Delete	DELETE [org URI]/api/data/v9.0/msdyn_ocsessions(activityid) See Delete	DeleteRequest or Delete
GrantAccess	GrantAccess Action	GrantAccessRequest
IsValidStateTransition	IsValidStateTransition Function	IsValidStateTransitionRequest
ModifyAccess	ModifyAccess Action	ModifyAccessRequest
Retrieve	GET [org URI]/api/data/v9.0/msdyn_ocsessions(activityid) See Retrieve	RetrieveRequest or Retrieve
RetrieveMultiple	GET [org URI]/api/data/v9.0/msdyn_ocsessions See Query Data	RetrieveMultipleRequest or RetrieveMultiple
RetrievePrincipalAccess	RetrievePrincipalAccess Function	RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccess Function	RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess	RevokeAccess Action	RevokeAccessRequest
SetState	PATCH [org URI]/api/data/v9.0/msdyn_ocsessions(activityid) Update statecode and statuscode properties.	SetStateRequest
Update	PATCH [org URI]/api/data/v9.0/msdyn_ocsessions(activityid) See Update	UpdateRequest or Update
UpdateMultiple	UpdateMultiple Action	UpdateMultipleRequest

Properties

Property	Value
CollectionSchemaName	msdyn_ocsessions
DisplayCollectionName	Sessions
DisplayName	Session
EntitySetName	msdyn_ocsessions
IsBPFEntity	False
LogicalCollectionName	msdyn_ocsessions
LogicalName	msdyn_ocsession
OwnershipType	UserOwned
PrimaryIdAttribute	activityid
PrimaryNameAttribute	subject
SchemaName	msdyn_ocsession

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• ActivityAdditionalParams
• ActivityId
• ActualDurationMinutes
• ActualEnd
• ActualStart
• BCC
• CC
• Community
• Customers
• DeliveryPriorityCode
• Description
• ExchangeItemId
• ExchangeWebLink
• From
• ImportSequenceNumber
• IsBilled
• IsMapiPrivate
• IsWorkflowCreated
• LastOnHoldTime
• LeftVoiceMail
• msdyn_agentacceptedon
• msdyn_agentassignedon
• msdyn_botengagementmode
• msdyn_cdsqueueid
• msdyn_channel
• msdyn_channelinstanceid
• msdyn_closurereason
• msdyn_liveworkitemid
• msdyn_primarysession
• msdyn_queueassignedon
• msdyn_queueassignedreason
• msdyn_queueid
• msdyn_routingfailurestage
• msdyn_sessionclosedon
• msdyn_sessioncreatedon
• msdyn_sessioncreationreason
• msdyn_sessionid
• msdyn_sessionmodifiedon
• msdyn_state
• OptionalAttendees
• Organizer
• OverriddenCreatedOn
• OwnerId
• OwnerIdType
• Partners
• PriorityCode
• ProcessId
• RegardingObjectId
• RegardingObjectIdName
• RegardingObjectIdYomiName
• RegardingObjectTypeCode
• RequiredAttendees
• Resources
• ScheduledDurationMinutes
• ScheduledEnd
• ScheduledStart
• ServiceId
• SLAId
• SortDate
• StageId
• StateCode
• StatusCode
• Subject
• TimeZoneRuleVersionNumber
• To
• TransactionCurrencyId
• TraversedPath
• UTCConversionTimeZoneCode

ActivityAdditionalParams

Property	Value
Description	Additional information provided by the external application as JSON. For internal use only.
DisplayName	Activity Additional Parameters
Format	TextArea
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	activityadditionalparams
MaxLength	8192
RequiredLevel	None
Type	Memo

ActivityId

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the activity.
DisplayName	Activity
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	activityid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ActualDurationMinutes

Property	Value
Description	Actual duration of the activity in minutes.
DisplayName	Actual Duration
Format	Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	actualdurationminutes
MaxValue	2147483647
MinValue	0
RequiredLevel	None
Type	Integer

ActualEnd

Property	Value
DateTimeBehavior	UserLocal
Description	Actual end time of the activity.
DisplayName	Actual End
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	actualend
RequiredLevel	None
Type	DateTime

ActualStart

Property	Value
DateTimeBehavior	UserLocal
Description	Actual start time of the activity.
DisplayName	Actual Start
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	actualstart
RequiredLevel	None
Type	DateTime

BCC

Added by: Active Solution Solution

Property	Value
Description	Blind Carbon-copy (bcc) recipients of the activity.
DisplayName	BCC
IsValidForForm	True
IsValidForRead	True
LogicalName	bcc
RequiredLevel	None
Targets	account,contact,lead,systemuser
Type	PartyList

CC

Added by: Active Solution Solution

Property	Value
Description	Carbon-copy (cc) recipients of the activity.
DisplayName	CC
IsValidForForm	True
IsValidForRead	True
LogicalName	cc
RequiredLevel	None
Targets	account,contact,lead,systemuser
Type	PartyList

Community

Property	Value
Description	Shows how contact about the social activity originated, such as from Twitter or Facebook. This field is read-only.
DisplayName	Social Channel
IsValidForForm	False
IsValidForRead	True
LogicalName	community
RequiredLevel	None
Type	Picklist

Community Choices/Options

Value	Label
0	Other
1	Facebook
2	Twitter
3	Line
4	Wechat
5	Cortana
6	Direct Line
7	Microsoft Teams
8	Direct Line Speech
9	Email
10	GroupMe
11	Kik
12	Telegram
13	Skype
14	Slack
15	WhatsApp
16	Apple Messages For Business
17	Google's Business Messages

Customers

Added by: Active Solution Solution

Property	Value
Description	Customer with which the activity is associated.
DisplayName	Customers
IsValidForForm	True
IsValidForRead	True
LogicalName	customers
RequiredLevel	None
Targets	account,contact
Type	PartyList

DeliveryPriorityCode

Property	Value
Description	Priority of delivery of the activity to the email server.
DisplayName	Delivery Priority
IsValidForForm	True
IsValidForRead	True
IsValidForUpdate	False
LogicalName	deliveryprioritycode
RequiredLevel	None
Type	Picklist

DeliveryPriorityCode Choices/Options

Value	Label
0	Low
1	Normal
2	High

Description

Property	Value
Description	Description of the activity.
DisplayName	Description
Format	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	description
MaxLength	2000
RequiredLevel	None
Type	Memo

ExchangeItemId

Property	Value
Description	The message id of activity which is returned from Exchange Server.
DisplayName	Exchange Item ID
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	exchangeitemid
MaxLength	200
RequiredLevel	None
Type	String

ExchangeWebLink

Property	Value
Description	Shows the web link of Activity of type email.
DisplayName	Exchange WebLink
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	exchangeweblink
MaxLength	1250
RequiredLevel	None
Type	String

From

Added by: Active Solution Solution

Property	Value
Description	Person who the activity is from.
DisplayName	From
IsValidForForm	True
IsValidForRead	True
LogicalName	from
RequiredLevel	None
Targets	account,contact,lead,systemuser
Type	PartyList

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
Format	None
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	importsequencenumber
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

IsBilled

Property	Value
Description	Information regarding whether the activity was billed as part of resolving a case.
DisplayName	Is Billed
IsValidForForm	False
IsValidForRead	True
LogicalName	isbilled
RequiredLevel	None
Type	Boolean

IsBilled Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

IsMapiPrivate

Property	Value
Description	For internal use only.
DisplayName	Is Private
IsValidForForm	False
IsValidForRead	True
LogicalName	ismapiprivate
RequiredLevel	None
Type	Boolean

IsMapiPrivate Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

IsWorkflowCreated

Property	Value
Description	Information regarding whether the activity was created from a workflow rule.
DisplayName	Is Workflow Created
IsValidForForm	False
IsValidForRead	True
LogicalName	isworkflowcreated
RequiredLevel	None
Type	Boolean

IsWorkflowCreated Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

LastOnHoldTime

Added by: Active Solution Solution

Property	Value
DateTimeBehavior	UserLocal
Description	Contains the date and time stamp of the last on hold time.
DisplayName	Last On Hold Time
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	lastonholdtime
RequiredLevel	None
Type	DateTime

LeftVoiceMail

Property	Value
Description	Left the voice mail
DisplayName	Left Voice Mail
IsValidForForm	True
IsValidForRead	True
LogicalName	leftvoicemail
RequiredLevel	None
Type	Boolean

LeftVoiceMail Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: False

msdyn_agentacceptedon

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when session was accepted by agent
DisplayName	Agent Accepted On
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_agentacceptedon
RequiredLevel	None
Type	DateTime

msdyn_agentassignedon

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when session was assigned to agent
DisplayName	Agent Assigned On
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_agentassignedon
RequiredLevel	None
Type	DateTime

msdyn_botengagementmode

Property	Value
Description	Indicates when a bot was engaged
DisplayName	Bot Engagement Mode
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_botengagementmode
RequiredLevel	None
Type	Picklist

msdyn_botengagementmode Choices/Options

Value	Label
192350000	Default
192350001	PreConversation
192350002	PostConverstation
192350003	OffBusinessHour

msdyn_cdsqueueid

Property	Value
Description	Unique identifier for Queue associated with Session.
DisplayName	Queue Id
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_cdsqueueid
RequiredLevel	None
Targets	queue
Type	Lookup

msdyn_channel

Property	Value
Description	The channel type of the session
DisplayName	Channel
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_channel
RequiredLevel	None
Type	Picklist

msdyn_channel Choices/Options

Value	Label
19241000	Microsoft Teams
192300000	WhatsApp
192310000	LINE
192320000	WeChat
192330000	Facebook
192340000	SMS
192350000	Entity Records
192350001	Twitter
192350002	Custom
192360000	Live chat
192370000	Voice
192380000	Video
192390000	Co-browse
192400000	Screen sharing
192440000	Voice call
192450000	Apple Messages for Business
192450001	Google's Business Messages

msdyn_channelinstanceid

Property	Value
Description	Unique identifier to identify the app to which this conversation belongs to.
DisplayName	Channel Instance ID
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_channelinstanceid
RequiredLevel	None
Targets	msdyn_channelinstance
Type	Lookup

msdyn_closurereason

Property	Value
Description	Reason for session closure
DisplayName	Closure Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_closurereason
RequiredLevel	None
Type	Picklist

msdyn_closurereason Choices/Options

Value	Label
192350000	Default
192350001	AgentReject
192350002	AgentTimeout
192350003	ConversationTimeout
192350004	AgentClosed
192350005	ConversationClosed
192350006	AgentTransfered
192350007	AgentDisconnected
192350008	AgentReRouted
192350009	VirtualAgentClosed
192350010	AgentTransferToQueue
192350011	SupervisorAssignToQueue
192350012	SupervisorTransferToAgent
192350013	SystemReject
192350014	ForceClose
192350015	OverflowQueueTransfer
192350016	OverflowEndConversation
192350017	AddAgentFailed
192350018	AutoClose
192350019	SecondaryChannelClosed
192350020	CustomerDisconnect
192350021	AgentEndConversation
192350022	CustomerEndConversation

msdyn_liveworkitemid

Property	Value
Description	Unique Identifier of Conversation associated to the session
DisplayName	Conversation
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_liveworkitemid
RequiredLevel	None
Targets	msdyn_ocliveworkitem
Type	Lookup

msdyn_primarysession

Property	Value
Description	Reference to primary session.
DisplayName	Primary Session
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_primarysession
RequiredLevel	None
Targets	msdyn_ocsession
Type	Lookup

msdyn_queueassignedon

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when queue was assigned to session
DisplayName	Queue Assigned On
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_queueassignedon
RequiredLevel	None
Type	DateTime

msdyn_queueassignedreason

Property	Value
Description	Reason for Queue Assignment (This is for internal use only. Customers are advised to not use this property.)
DisplayName	Queue Assignment Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_queueassignedreason
RequiredLevel	ApplicationRequired
Type	Picklist

msdyn_queueid

Property	Value
Description	Queue associated to the session
DisplayName	Queue Id
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_queueid
RequiredLevel	None
Targets	msdyn_omnichannelqueue
Type	Lookup

msdyn_routingfailurestage

Added by: Dynamics 365 UR OmnichanelBase Dependency Solution

Property	Value
Description	Routing Failure Stage
DisplayName	Routing Failure Stage
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_routingfailurestage
RequiredLevel	None
Type	Picklist

msdyn_routingfailurestage Choices/Options

Value	Label
10	None
1000	Record Identification
2000	Demand Classification

msdyn_sessionclosedon

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when session was closed
DisplayName	Session Closed On
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_sessionclosedon
RequiredLevel	None
Type	DateTime

msdyn_sessioncreatedon

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when session was created
DisplayName	Session Created On
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_sessioncreatedon
RequiredLevel	None
Type	DateTime

msdyn_sessioncreationreason

Property	Value
Description	Reason for session creation (This is for internal use only. Customers are advised to not use this property.)
DisplayName	Created Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_sessioncreationreason
RequiredLevel	ApplicationRequired
Type	Picklist

msdyn_sessionid

Property	Value
Description	Unique Identifier of Session
DisplayName	Session Id
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_sessionid
MaxLength	100
RequiredLevel	None
Type	String

msdyn_sessionmodifiedon

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when session was last modified
DisplayName	Session Modified On
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_sessionmodifiedon
RequiredLevel	None
Type	DateTime

msdyn_state

Property	Value
Description	(Deprecated)
DisplayName	State
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_state
RequiredLevel	None
Type	Picklist

msdyn_state Choices/Options

Value	Label
192350000	Default
192350001	Active
192350002	Closed
192350003	New

OptionalAttendees

Added by: Active Solution Solution

Property	Value
Description	List of optional attendees for the activity.
DisplayName	Optional Attendees
IsValidForForm	True
IsValidForRead	True
LogicalName	optionalattendees
RequiredLevel	None
Targets	account,contact,entitlement,equipment,knowledgearticle,lead,msdyn_salessuggestion,queue,systemuser,unresolvedaddress
Type	PartyList

Organizer

Added by: Active Solution Solution

Property	Value
Description	Person who organized the activity.
DisplayName	Organizer
IsValidForForm	True
IsValidForRead	True
LogicalName	organizer
RequiredLevel	None
Targets	systemuser
Type	PartyList

OverriddenCreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time that the record was migrated.
DisplayName	Record Created On
Format	DateOnly
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	overriddencreatedon
RequiredLevel	None
Type	DateTime

OwnerId

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the user or team who owns the activity.
DisplayName	Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	ownerid
RequiredLevel	SystemRequired
Targets	systemuser,team
Type	Owner

OwnerIdType

Added by: Active Solution Solution

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridtype
RequiredLevel	SystemRequired
Type	EntityName

Partners

Added by: Active Solution Solution

Property	Value
Description	Outsource vendor with which activity is associated.
DisplayName	Outsource Vendors
IsValidForForm	True
IsValidForRead	True
LogicalName	partners
RequiredLevel	None
Targets	account,contact
Type	PartyList

PriorityCode

Property	Value
Description	Priority of the activity.
DisplayName	Priority
IsValidForForm	True
IsValidForRead	True
LogicalName	prioritycode
RequiredLevel	None
Type	Picklist

PriorityCode Choices/Options

Value	Label
0	Low
1	Normal
2	High

ProcessId

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the Process.
DisplayName	Process
IsValidForForm	False
IsValidForRead	True
LogicalName	processid
RequiredLevel	None
Type	Uniqueidentifier

RegardingObjectId

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the object with which the activity is associated.
DisplayName	Regarding
IsValidForForm	True
IsValidForRead	True
LogicalName	regardingobjectid
RequiredLevel	None
Targets	account,adx_ad,adx_adplacement,adx_invitation,adx_poll,adx_polloption,adx_pollplacement,adx_pollsubmission,adx_publishingstatetransitionrule,adx_redirect,adx_shortcut,adx_webpage,adx_website,bookableresourcebooking,bookableresourcebookingheader,bulkoperation,campaign,campaignactivity,contact,contract,entitlement,entitlementtemplate,incident,interactionforemail,invoice,knowledgearticle,knowledgebaserecord,lead,msdyn_customerasset,msdyn_playbookinstance,msdyn_postalbum,msdyn_salessuggestion,msdyn_swarm,opportunity,quote,salesorder,site
Type	Lookup

RegardingObjectIdName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	regardingobjectidname
MaxLength	400
RequiredLevel	None
Type	String

RegardingObjectIdYomiName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	regardingobjectidyominame
MaxLength	400
RequiredLevel	None
Type	String

RegardingObjectTypeCode

Added by: Active Solution Solution

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	regardingobjecttypecode
RequiredLevel	None
Type	EntityName

RequiredAttendees

Added by: Active Solution Solution

Property	Value
Description	List of required attendees for the activity.
DisplayName	Required Attendees
IsValidForForm	True
IsValidForRead	True
LogicalName	requiredattendees
RequiredLevel	None
Targets	account,contact,entitlement,equipment,knowledgearticle,lead,msdyn_salessuggestion,queue,systemuser,unresolvedaddress
Type	PartyList

Resources

Added by: Active Solution Solution

Property	Value
Description	Users or facility/equipment that are required for the activity.
DisplayName	Resources
IsValidForForm	True
IsValidForRead	True
LogicalName	resources
RequiredLevel	None
Targets	equipment,systemuser
Type	PartyList

ScheduledDurationMinutes

Property	Value
Description	Scheduled duration of the activity, specified in minutes.
DisplayName	Scheduled Duration
Format	Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	scheduleddurationminutes
MaxValue	2147483647
MinValue	0
RequiredLevel	None
Type	Integer

ScheduledEnd

Property	Value
DateTimeBehavior	UserLocal
Description	Scheduled end time of the activity.
DisplayName	Due Date
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	scheduledend
RequiredLevel	None
Type	DateTime

ScheduledStart

Property	Value
DateTimeBehavior	UserLocal
Description	Scheduled start time of the activity.
DisplayName	Start Date
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	scheduledstart
RequiredLevel	None
Type	DateTime

ServiceId

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of an associated service.
DisplayName	Service
IsValidForForm	False
IsValidForRead	True
LogicalName	serviceid
RequiredLevel	None
Targets	service
Type	Lookup

SLAId

Added by: Active Solution Solution

Property	Value
Description	Choose the service level agreement (SLA) that you want to apply to the case record.
DisplayName	SLA
IsValidForForm	True
IsValidForRead	True
LogicalName	slaid
RequiredLevel	None
Targets	sla
Type	Lookup

SortDate

Property	Value
DateTimeBehavior	UserLocal
Description	Shows the date and time by which the activities are sorted.
DisplayName	Sort Date
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	sortdate
RequiredLevel	None
Type	DateTime

StageId

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the Stage.
DisplayName	Process Stage
IsValidForForm	False
IsValidForRead	True
LogicalName	stageid
RequiredLevel	None
Type	Uniqueidentifier

StateCode

Property	Value
Description	Status of the activity.
DisplayName	Activity Status
IsValidForCreate	False
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State

StateCode Choices/Options

Value	Label	DefaultStatus	InvariantName
0	Open	1	Open
1	Completed	2	Completed
2	Canceled	3	Canceled
3	Scheduled	4	Scheduled

StatusCode

Property	Value
Description	Reason for the status of the activity.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	None
Type	Status

StatusCode Choices/Options

Value	Label	State
1	Open	0
2	Completed	1
3	Canceled	2
4	Scheduled	3

Subject

Property	Value
Description	Subject associated with the activity.
DisplayName	Subject
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	subject
MaxLength	200
RequiredLevel	ApplicationRequired
Type	String

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

To

Added by: Active Solution Solution

Property	Value
Description	Person who is the receiver of the activity.
DisplayName	To
IsValidForForm	True
IsValidForRead	True
LogicalName	to
RequiredLevel	None
Targets	account,contact,lead,systemuser
Type	PartyList

TransactionCurrencyId

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the currency associated with the activitypointer.
DisplayName	Currency
IsValidForForm	True
IsValidForRead	True
LogicalName	transactioncurrencyid
RequiredLevel	None
Targets	transactioncurrency
Type	Lookup

TraversedPath

Added by: Active Solution Solution

Property	Value
Description	For internal use only.
DisplayName	Traversed Path
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	traversedpath
MaxLength	1250
RequiredLevel	None
Type	String

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

• ActivityTypeCode
• CreatedBy
• CreatedByName
• CreatedByYomiName
• CreatedOn
• CreatedOnBehalfBy
• CreatedOnBehalfByName
• CreatedOnBehalfByYomiName
• DeliveryLastAttemptedOn
• ExchangeRate
• InstanceTypeCode
• IsRegularActivity
• ModifiedBy
• ModifiedByName
• ModifiedByYomiName
• ModifiedOn
• ModifiedOnBehalfBy
• ModifiedOnBehalfByName
• ModifiedOnBehalfByYomiName
• msdyn_cdsqueueidName
• msdyn_channelinstanceidName
• msdyn_liveworkitemidName
• msdyn_primarysessionName
• msdyn_queueidName
• msft_DataState
• OnHoldTime
• OwnerIdName
• OwnerIdYomiName
• OwningBusinessUnit
• OwningBusinessUnitName
• OwningTeam
• OwningUser
• PostponeActivityProcessingUntil
• SenderMailboxId
• SenderMailboxIdName
• SentOn
• SeriesId
• ServiceIdName
• SLAInvokedId
• SLAInvokedIdName
• SLAName
• TransactionCurrencyIdName
• VersionNumber

ActivityTypeCode

Property	Value
Description	Type of activity.
DisplayName	Activity Type
IsValidForForm	False
IsValidForRead	True
LogicalName	activitytypecode
RequiredLevel	SystemRequired
Type	EntityName

CreatedBy

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the user who created the activity.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedByName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedByYomiName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyyominame
MaxLength	100
RequiredLevel	None
Type	String

CreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the activity was created.
DisplayName	Date Created
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime

CreatedOnBehalfBy

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the delegate user who created the activitypointer.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedOnBehalfByName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedOnBehalfByYomiName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

DeliveryLastAttemptedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the delivery of the activity was last attempted.
DisplayName	Date Delivery Last Attempted
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	deliverylastattemptedon
RequiredLevel	None
Type	DateTime

ExchangeRate

Added by: Active Solution Solution

Property	Value
Description	Exchange rate for the currency associated with the activitypointer with respect to the base currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	exchangerate
MaxValue	100000000000
MinValue	0.000000000001
Precision	12
RequiredLevel	None
Type	Decimal

InstanceTypeCode

Property	Value
Description	Type of instance of a recurring series.
DisplayName	Recurring Instance Type
IsValidForForm	False
IsValidForRead	True
LogicalName	instancetypecode
RequiredLevel	SystemRequired
Type	Picklist

InstanceTypeCode Choices/Options

Value	Label
0	Not Recurring
1	Recurring Master
2	Recurring Instance
3	Recurring Exception
4	Recurring Future Exception

IsRegularActivity

Property	Value
Description	Information regarding whether the activity is a regular activity type or event type.
DisplayName	Is Regular Activity
IsValidForForm	False
IsValidForRead	True
LogicalName	isregularactivity
RequiredLevel	SystemRequired
Type	Boolean

IsRegularActivity Choices/Options

Value	Label
1	Yes
0	No

DefaultValue: True

ModifiedBy

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of user who last modified the activity.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedByName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedByYomiName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyyominame
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when activity was last modified.
DisplayName	Last Updated
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime

ModifiedOnBehalfBy

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the delegate user who last modified the activitypointer.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedOnBehalfByName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOnBehalfByYomiName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

msdyn_cdsqueueidName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	msdyn_cdsqueueidname
MaxLength	200
RequiredLevel	None
Type	String

msdyn_channelinstanceidName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	msdyn_channelinstanceidname
MaxLength	100
RequiredLevel	None
Type	String

msdyn_liveworkitemidName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	msdyn_liveworkitemidname
MaxLength	200
RequiredLevel	None
Type	String

msdyn_primarysessionName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	msdyn_primarysessionname
MaxLength	200
RequiredLevel	None
Type	String

msdyn_queueidName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	msdyn_queueidname
MaxLength	100
RequiredLevel	None
Type	String

msft_DataState

Added by: Basic Solution Solution

Property	Value
Description
DisplayName	msft_DataState
IsValidForForm	True
IsValidForRead	True
LogicalName	msft_datastate
RequiredLevel	None
Type	Picklist

msft_DataState Choices/Options

Value	Label
0	Default
1	Retain

OnHoldTime

Added by: Active Solution Solution

Property	Value
Description	Shows how long, in minutes, that the record was on hold.
DisplayName	On Hold Time (Minutes)
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	onholdtime
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

OwnerIdName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

OwnerIdYomiName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridyominame
MaxLength	100
RequiredLevel	SystemRequired
Type	String

OwningBusinessUnit

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the business unit that owns the activity.
DisplayName	Owning Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	owningbusinessunit
RequiredLevel	None
Targets	businessunit
Type	Lookup

OwningBusinessUnitName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owningbusinessunitname
MaxLength	160
RequiredLevel	None
Type	String

OwningTeam

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the team that owns the activity.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	owningteam
RequiredLevel	None
Targets	team
Type	Lookup

OwningUser

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the user that owns the activity.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	owninguser
RequiredLevel	None
Targets	systemuser
Type	Lookup

PostponeActivityProcessingUntil

Property	Value
DateTimeBehavior	UserLocal
Description	For internal use only.
DisplayName	Delay activity processing until
Format	DateAndTime
IsValidForForm	False
IsValidForRead	True
LogicalName	postponeactivityprocessinguntil
RequiredLevel	None
Type	DateTime

SenderMailboxId

Added by: Active Solution Solution

Property	Value
Description	Unique identifier of the mailbox associated with the sender of the email message.
DisplayName	Sender's Mailbox
IsValidForForm	False
IsValidForRead	True
LogicalName	sendermailboxid
RequiredLevel	None
Targets	mailbox
Type	Lookup

SenderMailboxIdName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	sendermailboxidname
MaxLength	100
RequiredLevel	None
Type	String

SentOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the activity was sent.
DisplayName	Date Sent
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	senton
RequiredLevel	None
Type	DateTime

SeriesId

Property	Value
Description	Uniqueidentifier specifying the id of recurring series of an instance.
DisplayName	Series Id
IsValidForForm	False
IsValidForRead	True
LogicalName	seriesid
RequiredLevel	None
Type	Uniqueidentifier

ServiceIdName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	serviceidname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

SLAInvokedId

Added by: Active Solution Solution

Property	Value
Description	Last SLA that was applied to this case. This field is for internal use only.
DisplayName	Last SLA applied
IsValidForForm	False
IsValidForRead	True
LogicalName	slainvokedid
RequiredLevel	None
Targets	sla
Type	Lookup

SLAInvokedIdName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	slainvokedidname
MaxLength	100
RequiredLevel	None
Type	String

SLAName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	slaname
MaxLength	100
RequiredLevel	None
Type	String

TransactionCurrencyIdName

Added by: Active Solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	transactioncurrencyidname
MaxLength	100
RequiredLevel	None
Type	String

VersionNumber

Added by: Active Solution Solution

Property	Value
Description	Version number of the activity.
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	versionnumber
MaxValue	9223372036854775807
MinValue	-9223372036854775808
RequiredLevel	None
Type	BigInt

One-To-Many Relationships

Listed by SchemaName.

• msdyn_msdyn_ocsession_msdyn_ocsession_primarysession
• msdyn_ocsession_sessionevent_nested

msdyn_msdyn_ocsession_msdyn_ocsession_primarysession

Same as msdyn_ocsession table msdyn_msdyn_ocsession_msdyn_ocsession_primarysession Many-To-One relationship.

Property	Value
ReferencingEntity	msdyn_ocsession
ReferencingAttribute	msdyn_primarysession
IsHierarchical	False
IsCustomizable	False
ReferencedEntityNavigationPropertyName	msdyn_msdyn_ocsession_msdyn_ocsession_primarysession
AssociatedMenuConfiguration	Behavior: UseCollectionName Group: Details Label: Order: 10000
CascadeConfiguration	Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_ocsession_sessionevent_nested

Same as msdyn_sessionevent table msdyn_ocsession_sessionevent_nested Many-To-One relationship.

Property	Value
ReferencingEntity	msdyn_sessionevent
ReferencingAttribute	msdyn_omnichannelsession
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	msdyn_ocsession_sessionevent_nested
AssociatedMenuConfiguration	Behavior: UseCollectionName Group: Details Label: Order: 10000
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

msdyn_msdyn_ocsession_msdyn_ocsession_primarysession

Added by: Active Solution Solution

See msdyn_ocsession Table msdyn_msdyn_ocsession_msdyn_ocsession_primarysession One-To-Many relationship.

See also

Omnichannel for Customer Service entity reference
Web API Reference