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

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
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

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

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