SLA KPI Instance (SLAKPIInstance) table/entity reference

Service level agreement (SLA) key performance indicator (KPI) instance that is tracked for an individual case

Messages

The following table lists the messages for the SLA KPI Instance (SLAKPIInstance) table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?
Web API Operation SDK for .NET
Assign
Event: True
PATCH /slakpiinstances(slakpiinstanceid)
Update the ownerid property.
AssignRequest
Create
Event: True
POST /slakpiinstances
See Create
Create records
Delete
Event: False
DELETE /slakpiinstances(slakpiinstanceid)
See Delete
Delete records
GrantAccess
Event: True
GrantAccess GrantAccessRequest
ModifyAccess
Event: True
ModifyAccess ModifyAccessRequest
Retrieve
Event: False
GET /slakpiinstances(slakpiinstanceid)
See Retrieve
Retrieve records
RetrieveMultiple
Event: False
GET /slakpiinstances
See Query data
Query data
RetrievePrincipalAccess
Event: True
RetrievePrincipalAccess RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess
Event: True
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess
Event: True
RevokeAccess RevokeAccessRequest
Update
Event: True
PATCH /slakpiinstances(slakpiinstanceid)
See Update
Update records
Upsert
Event: False
PATCH /slakpiinstances(slakpiinstanceid)
See Upsert a table row
UpsertRequest

Properties

The following table lists selected properties for the SLA KPI Instance (SLAKPIInstance) table.

Property Value
DisplayName SLA KPI Instance
DisplayCollectionName SLA KPI Instances
SchemaName SLAKPIInstance
CollectionSchemaName SLAKPIInstances
EntitySetName slakpiinstances
LogicalName slakpiinstance
LogicalCollectionName slakpiinstances
PrimaryIdAttribute slakpiinstanceid
PrimaryNameAttribute name
TableType Standard
OwnershipType UserOwned

Writable columns/attributes

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

ApplicableFromValue

Property Value
Description
DisplayName Applicable From Value
IsValidForForm True
IsValidForRead True
LogicalName applicablefromvalue
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Auto
SourceTypeMask 0

ComputedFailureTime

Property Value
Description Computed Failure Date and time
DisplayName Computed Failure Time
IsValidForForm True
IsValidForRead True
LogicalName computedfailuretime
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Auto
SourceTypeMask 0

ComputedWarningTime

Property Value
Description Computed Warning Date and time
DisplayName Computed Warning Time
IsValidForForm True
IsValidForRead True
LogicalName computedwarningtime
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Auto
SourceTypeMask 0

Description

Property Value
Description For internal use only.
DisplayName Description
IsValidForForm True
IsValidForRead True
LogicalName description
RequiredLevel None
Type String
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 100

ElapsedTime

Property Value
Description Paused duration of a KPI in business hours
DisplayName Elapsed Time (min)
IsValidForForm True
IsValidForRead True
LogicalName elapsedtime
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

FailureTime

Property Value
Description Enter the date and time when the service level agreement (SLA) key performance indicator (KPI) will expire.
DisplayName Failure Time
IsValidForForm True
IsValidForRead True
LogicalName failuretime
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Auto
SourceTypeMask 0

LastResumeTime

Property Value
Description
DisplayName Last Resume Time
IsValidForForm True
IsValidForRead True
LogicalName lastresumetime
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Auto
SourceTypeMask 0

msdyn_ActionExecutionStatus

Property Value
Description
DisplayName Action Execution Status
IsValidForForm True
IsValidForRead True
LogicalName msdyn_actionexecutionstatus
RequiredLevel None
Type Picklist
DefaultFormValue -1
GlobalChoiceName msdyn_slakpiinstance_msdyn_actionexecutionstatus

msdyn_ActionExecutionStatus Choices/Options

Value Label
0 None
1 Warning
2 Success

msdyn_activeduration

Property Value
Description Time taken in business hours by a KPI instance to reach the Success or failed state
DisplayName Active Duration (min)
IsValidForForm True
IsValidForRead True
LogicalName msdyn_activeduration
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

msdyn_calendarid

Property Value
Description
DisplayName Applicable Calendar
IsValidForForm True
IsValidForRead True
LogicalName msdyn_calendarid
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

msdyn_prevslakpiinstanceid

Property Value
Description
DisplayName Previous SLAKPI Instance
IsValidForForm True
IsValidForRead True
LogicalName msdyn_prevslakpiinstanceid
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

msdyn_slaitemid

Property Value
Description Unique identifier for SLA KPI Instance associated with SLA Item.
DisplayName SLAItem
IsValidForForm True
IsValidForRead True
LogicalName msdyn_slaitemid
RequiredLevel None
Type Lookup
Targets slaitem

Name

Property Value
Description Type a descriptive name for the service level agreement (SLA) key performance indicator (KPI) instance.
DisplayName Name
IsValidForForm True
IsValidForRead True
LogicalName name
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

OwnerId

Property Value
Description Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user or team.
DisplayName Owner
IsValidForForm True
IsValidForRead True
LogicalName ownerid
RequiredLevel SystemRequired
Type Owner
Targets systemuser

OwnerIdType

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

OwningBusinessUnit

Property Value
Description Owning Business Unit.
DisplayName Owning Business Unit
IsValidForForm True
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Type Lookup
Targets businessunit

OwningTeam

Property Value
Description OwningTeam.
DisplayName Owning Team
IsValidForForm False
IsValidForRead True
LogicalName owningteam
RequiredLevel None
Type Lookup
Targets

OwningUser

Property Value
Description Owning User.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Type Lookup
Targets

PausedOn

Property Value
Description
DisplayName Paused On
IsValidForForm True
IsValidForRead True
LogicalName pausedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Auto
SourceTypeMask 0

Regarding

Property Value
Description Unique identifier of the record that this service level agreement (SLA) key performance indicator (KPI) instance is associated with.
DisplayName Regarding
IsValidForForm True
IsValidForRead True
LogicalName regarding
RequiredLevel None
Type Lookup
Targets account, activitypointer, appointment, contact, email, fax, letter, phonecall, socialactivity, task

RegardingEntityID

Property Value
Description
DisplayName Regarding ID
IsValidForForm True
IsValidForRead True
LogicalName regardingentityid
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

RegardingObjectTypeCode

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

SLAKPIInstanceId

Property Value
Description Unique identifier of the SLA KPI Instance.
DisplayName SLA KPI InstanceId
IsValidForForm False
IsValidForRead True
LogicalName slakpiinstanceid
RequiredLevel SystemRequired
Type Uniqueidentifier

Status

Property Value
Description Reason for the status of the service level agreement (SLA) key performance indicator (KPI) instance. For example, the SLA KPI could be Noncompliant or Succeeded.
DisplayName Status
IsValidForForm True
IsValidForRead True
LogicalName status
RequiredLevel None
Type Picklist
DefaultFormValue
GlobalChoiceName slakpiinstance_status

Status Choices/Options

Value Label
0 In Progress
1 Noncompliant
2 Nearing Noncompliance
3 Paused
4 Succeeded
5 Canceled

SucceededOn

Property Value
Description Shows the date and time when the service level agreement (SLA) key performance indicator (KPI) success criteria was met.
DisplayName Succeeded On
IsValidForForm True
IsValidForRead True
LogicalName succeededon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Auto
SourceTypeMask 0

SuccessCheckedAt

Property Value
Description
DisplayName SuccessCheckedAt
IsValidForForm True
IsValidForRead True
LogicalName successcheckedat
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior TimeZoneIndependent
Format DateAndTime
ImeMode Auto
SourceTypeMask 0

TerminalStateReached

Property Value
Description
DisplayName Terminal State Reached
IsValidForForm True
IsValidForRead True
LogicalName terminalstatereached
RequiredLevel None
Type Boolean
GlobalChoiceName servicelevelagreementinstance_terminalstatereached
DefaultValue False
True Label Yes
False Label No

TerminalStateTime

Property Value
Description
DisplayName Terminal State Time
IsValidForForm True
IsValidForRead True
LogicalName terminalstatetime
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior True
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Auto
SourceTypeMask 0

TransactionCurrencyId

Property Value
Description Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName Currency
IsValidForForm True
IsValidForRead True
LogicalName transactioncurrencyid
RequiredLevel None
Type Lookup
Targets transactioncurrency

WarningTime

Property Value
Description Enter the date and time when the service level agreement (SLA) key performance indicator (KPI)will go to a warning state.
DisplayName Warning Time
IsValidForForm True
IsValidForRead True
LogicalName warningtime
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Auto
SourceTypeMask 0

WarningTimeReached

Property Value
Description Shows information about whether the case has reached its warning time.
DisplayName Warning Time Reached
IsValidForForm True
IsValidForRead True
LogicalName warningtimereached
RequiredLevel None
Type Picklist
DefaultFormValue 0
GlobalChoiceName slakpiinstance_warningtimereached

WarningTimeReached Choices/Options

Value Label
0 No
1 Yes

Read-only columns/attributes

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

CreatedBy

Property Value
Description For internal use only.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName createdby
RequiredLevel None
Type Lookup
Targets systemuser

CreatedOn

Property Value
Description For internal use only.
DisplayName Created On
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

CreatedOnBehalfBy

Property Value
Description For internal use only.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

ExchangeRate

Property Value
Description For internal use only.
DisplayName Exchange Rate
IsValidForForm True
IsValidForRead True
LogicalName exchangerate
RequiredLevel None
Type Decimal
ImeMode Disabled
MaxValue 100000000000
MinValue 1E-12
Precision 12
SourceTypeMask 0

ModifiedBy

Property Value
Description For internal use only.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Type Lookup
Targets systemuser

ModifiedOn

Property Value
Description For internal use only.
DisplayName Modified On
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ModifiedOnBehalfBy

Property Value
Description For internal use only.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

OwnerIdName

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

OwnerIdYomiName

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

VersionNumber

Property Value
Description For internal use only.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
RequiredLevel None
Type BigInt
MaxValue 9223372036854775807
MinValue -9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

business_unit_slakpiinstance

One-To-Many Relationship: businessunit business_unit_slakpiinstance

Property Value
ReferencedEntity businessunit
ReferencedAttribute businessunitid
ReferencingAttribute owningbusinessunit
ReferencingEntityNavigationPropertyName owningbusinessunit
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_slakpiinstancebase_createdby

One-To-Many Relationship: systemuser lk_slakpiinstancebase_createdby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdby
ReferencingEntityNavigationPropertyName createdby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_slakpiinstancebase_createdonbehalfby

One-To-Many Relationship: systemuser lk_slakpiinstancebase_createdonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdonbehalfby
ReferencingEntityNavigationPropertyName createdonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_slakpiinstancebase_modifiedby

One-To-Many Relationship: systemuser lk_slakpiinstancebase_modifiedby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedby
ReferencingEntityNavigationPropertyName modifiedby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_slakpiinstancebase_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_slakpiinstancebase_modifiedonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedonbehalfby
ReferencingEntityNavigationPropertyName modifiedonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_slaitem_slakpiinstance

One-To-Many Relationship: slaitem msdyn_slaitem_slakpiinstance

Property Value
ReferencedEntity slaitem
ReferencedAttribute slaitemid
ReferencingAttribute msdyn_slaitemid
ReferencingEntityNavigationPropertyName msdyn_slaitemid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_account

One-To-Many Relationship: account slakpiinstance_account

Property Value
ReferencedEntity account
ReferencedAttribute accountid
ReferencingAttribute regarding
ReferencingEntityNavigationPropertyName regarding_account
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_activitypointer

One-To-Many Relationship: activitypointer slakpiinstance_activitypointer

Property Value
ReferencedEntity activitypointer
ReferencedAttribute activityid
ReferencingAttribute regarding
ReferencingEntityNavigationPropertyName regarding_activitypointer
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_appointment

One-To-Many Relationship: appointment slakpiinstance_appointment

Property Value
ReferencedEntity appointment
ReferencedAttribute activityid
ReferencingAttribute regarding
ReferencingEntityNavigationPropertyName regarding_appointment
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_contact

One-To-Many Relationship: contact slakpiinstance_contact

Property Value
ReferencedEntity contact
ReferencedAttribute contactid
ReferencingAttribute regarding
ReferencingEntityNavigationPropertyName regarding_contact
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_email

One-To-Many Relationship: email slakpiinstance_email

Property Value
ReferencedEntity email
ReferencedAttribute activityid
ReferencingAttribute regarding
ReferencingEntityNavigationPropertyName regarding_email
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_fax

One-To-Many Relationship: fax slakpiinstance_fax

Property Value
ReferencedEntity fax
ReferencedAttribute activityid
ReferencingAttribute regarding
ReferencingEntityNavigationPropertyName regarding_fax
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_letter

One-To-Many Relationship: letter slakpiinstance_letter

Property Value
ReferencedEntity letter
ReferencedAttribute activityid
ReferencingAttribute regarding
ReferencingEntityNavigationPropertyName regarding_letter
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_owner

One-To-Many Relationship: owner slakpiinstance_owner

Property Value
ReferencedEntity owner
ReferencedAttribute ownerid
ReferencingAttribute ownerid
ReferencingEntityNavigationPropertyName ownerid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_phonecall

One-To-Many Relationship: phonecall slakpiinstance_phonecall

Property Value
ReferencedEntity phonecall
ReferencedAttribute activityid
ReferencingAttribute regarding
ReferencingEntityNavigationPropertyName regarding_phonecall
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_socialactivity

One-To-Many Relationship: socialactivity slakpiinstance_socialactivity

Property Value
ReferencedEntity socialactivity
ReferencedAttribute activityid
ReferencingAttribute regarding
ReferencingEntityNavigationPropertyName regarding_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

slakpiinstance_task

One-To-Many Relationship: task slakpiinstance_task

Property Value
ReferencedEntity task
ReferencedAttribute activityid
ReferencingAttribute regarding
ReferencingEntityNavigationPropertyName regarding_task
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

TransactionCurrency_slakpiinstance

One-To-Many Relationship: transactioncurrency TransactionCurrency_slakpiinstance

Property Value
ReferencedEntity transactioncurrency
ReferencedAttribute transactioncurrencyid
ReferencingAttribute transactioncurrencyid
ReferencingEntityNavigationPropertyName transactioncurrencyid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

SLAKPIInstance_SyncErrors

Many-To-One Relationship: syncerror SLAKPIInstance_SyncErrors

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName SLAKPIInstance_SyncErrors
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
slakpiinstance