SLAKPIInstance table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

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

Messages

Message Web API Operation SDK class or method
Assign PATCH /slakpiinstances(slakpiinstanceid)
Update ownerid property.
AssignRequest
Create POST /slakpiinstances
See Create
CreateRequest or
Create
Delete DELETE /slakpiinstances(slakpiinstanceid)
See Delete
DeleteRequest or
Delete
GrantAccess GrantAccess GrantAccessRequest
ModifyAccess ModifyAccess ModifyAccessRequest
Retrieve GET /slakpiinstances(slakpiinstanceid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET /slakpiinstances
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess RevokeAccessRequest
Update PATCH /slakpiinstances(slakpiinstanceid)
See Update
UpdateRequest or
Update

Properties

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

Writable columns/attributes

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

ApplicableFromValue

Added by: Service Level Agreement (SLA) Solution

Property Value
DateTimeBehavior UserLocal
Description
DisplayName Applicable From Value
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName applicablefromvalue
RequiredLevel None
Type DateTime

ComputedFailureTime

Property Value
DateTimeBehavior UserLocal
Description Computed Failure Date and time
DisplayName Computed Failure Time
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName computedfailuretime
RequiredLevel None
Type DateTime

ComputedWarningTime

Property Value
DateTimeBehavior UserLocal
Description Computed Warning Date and time
DisplayName Computed Warning Time
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName computedwarningtime
RequiredLevel None
Type DateTime

Description

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

ElapsedTime

Added by: Service Level Agreement (SLA) Solution

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

FailureTime

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

LastResumeTime

Added by: Service Level Agreement (SLA) Solution

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

msdyn_ActionExecutionStatus

Added by: Service Level Agreement (SLA) Extension Solution

Property Value
Description
DisplayName Action Execution Status
IsValidForForm True
IsValidForRead True
LogicalName msdyn_actionexecutionstatus
RequiredLevel None
Type Picklist

msdyn_ActionExecutionStatus Choices/Options

Value Label Description
0 None
1 Warning
2 Success

msdyn_activeduration

Added by: Service Level Agreement (SLA) Extension Solution

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

msdyn_calendarid

Added by: Service Level Agreement (SLA) Extension Solution

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

msdyn_prevslakpiinstanceid

Added by: Service Level Agreement (SLA) Extension Solution

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

msdyn_slaitemid

Added by: Service Level Agreement (SLA) Extension Solution

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

Name

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

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
Targets systemuser
Type Owner

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
Targets businessunit
Type Lookup

OwningTeam

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

OwningUser

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

PausedOn

Added by: Service Level Agreement (SLA) Solution

Property Value
DateTimeBehavior UserLocal
Description
DisplayName Paused On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName pausedon
RequiredLevel None
Type DateTime

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
Targets account,activitypointer,appointment,contact,email,fax,letter,phonecall,socialactivity,task
Type Lookup

RegardingEntityID

Added by: Service Level Agreement (SLA) Solution

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

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

Status Choices/Options

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

SucceededOn

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

SuccessCheckedAt

Added by: Service Level Agreement (SLA) Solution

Property Value
DateTimeBehavior TimeZoneIndependent
Description
DisplayName SuccessCheckedAt
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName successcheckedat
RequiredLevel None
Type DateTime

TerminalStateReached

Added by: Service Level Agreement (SLA) Solution

Property Value
Description
DisplayName Terminal State Reached
IsValidForForm True
IsValidForRead True
LogicalName terminalstatereached
RequiredLevel None
Type Boolean

TerminalStateReached Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

TerminalStateTime

Added by: Service Level Agreement (SLA) Solution

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

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
Targets transactioncurrency
Type Lookup

WarningTime

Property Value
DateTimeBehavior UserLocal
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
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName warningtime
RequiredLevel None
Type DateTime

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

WarningTimeReached Choices/Options

Value Label Description
0 No
1 Yes

Read-only columns/attributes

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

CreatedBy

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

CreatedByName

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

CreatedByYomiName

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 For internal use only.
DisplayName Created On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

CreatedOnBehalfBy

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

CreatedOnBehalfByName

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

CreatedOnBehalfByYomiName

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

ExchangeRate

Property Value
Description For internal use only.
DisplayName Exchange Rate
IsValidForForm True
IsValidForRead True
LogicalName exchangerate
MaxValue 100000000000
MinValue 0.000000000001
Precision 12
RequiredLevel None
Type Decimal

ModifiedBy

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

ModifiedByName

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

ModifiedByYomiName

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 For internal use only.
DisplayName Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

ModifiedOnBehalfBy

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

ModifiedOnBehalfByName

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

ModifiedOnBehalfByYomiName

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

msdyn_slaitemidName

Added by: Service Level Agreement (SLA) Extension Solution

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

OwnerIdName

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

OwnerIdYomiName

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

OwningBusinessUnitName

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

RegardingIdName

Property Value
Description RegardingName
DisplayName RegardingName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName regardingidname
MaxLength 800
RequiredLevel None
Type String

RegardingYomiName

Property Value
Description RegardingYomiName
DisplayName RegardingYomiName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName regardingyominame
MaxLength 800
RequiredLevel None
Type String

TransactionCurrencyIdName

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

VersionNumber

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

One-To-Many Relationships

Listed by SchemaName.

SLAKPIInstance_SyncErrors

Same as the SLAKPIInstance_SyncErrors many-to-one relationship for the syncerror table/entity.

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName SLAKPIInstance_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

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.

slakpiinstance_activitypointer

See the slakpiinstance_activitypointer one-to-many relationship for the activitypointer table/entity.

slakpiinstance_email

See the slakpiinstance_email one-to-many relationship for the email table/entity.

slakpiinstance_fax

See the slakpiinstance_fax one-to-many relationship for the fax table/entity.

lk_slakpiinstancebase_createdonbehalfby

See the lk_slakpiinstancebase_createdonbehalfby one-to-many relationship for the systemuser table/entity.

lk_slakpiinstancebase_modifiedonbehalfby

See the lk_slakpiinstancebase_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.

slakpiinstance_account

See the slakpiinstance_account one-to-many relationship for the account table/entity.

slakpiinstance_letter

See the slakpiinstance_letter one-to-many relationship for the letter table/entity.

slakpiinstance_phonecall

See the slakpiinstance_phonecall one-to-many relationship for the phonecall table/entity.

business_unit_slakpiinstance

See the business_unit_slakpiinstance one-to-many relationship for the businessunit table/entity.

slakpiinstance_socialactivity

See the slakpiinstance_socialactivity one-to-many relationship for the socialactivity table/entity.

slakpiinstance_task

See the slakpiinstance_task one-to-many relationship for the task table/entity.

lk_slakpiinstancebase_modifiedby

See the lk_slakpiinstancebase_modifiedby one-to-many relationship for the systemuser table/entity.

TransactionCurrency_slakpiinstance

See the TransactionCurrency_slakpiinstance one-to-many relationship for the transactioncurrency table/entity.

slakpiinstance_contact

See the slakpiinstance_contact one-to-many relationship for the contact table/entity.

lk_slakpiinstancebase_createdby

See the lk_slakpiinstancebase_createdby one-to-many relationship for the systemuser table/entity.

slakpiinstance_appointment

See the slakpiinstance_appointment one-to-many relationship for the appointment table/entity.

msdyn_slaitem_slakpiinstance

See the msdyn_slaitem_slakpiinstance one-to-many relationship for the slaitem table/entity.

See also

Dataverse table/entity reference
Web API Reference
slakpiinstance EntityType