Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Contains Approval records that are used to process new or updated submissions to the catalog system.
Messages
The following table lists the messages for the Approval Request (mspcat_certificationrequest) 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 |
|---|---|---|
AssignEvent: True |
PATCH /mspcat_certificationrequests(mspcat_certificationrequestid)Update the ownerid property. |
AssignRequest |
CreateEvent: True |
POST /mspcat_certificationrequestsSee Create |
Create records |
CreateMultipleEvent: True |
CreateMultiple | CreateMultipleRequest |
DeleteEvent: True |
DELETE /mspcat_certificationrequests(mspcat_certificationrequestid)See Delete |
Delete records |
GrantAccessEvent: True |
GrantAccess | GrantAccessRequest |
IsValidStateTransitionEvent: False |
IsValidStateTransition | IsValidStateTransitionRequest |
ModifyAccessEvent: True |
ModifyAccess | ModifyAccessRequest |
mspcat_ResolveApprovalEvent: False |
mspcat_ResolveApproval action | Learn to use messages with the SDK for .NET |
RestoreEvent: True |
Restore | Learn to use messages with the SDK for .NET |
RetrieveEvent: True |
GET /mspcat_certificationrequests(mspcat_certificationrequestid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: True |
GET /mspcat_certificationrequestsSee Query data |
Query data |
RetrievePrincipalAccessEvent: True |
RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccessEvent: True |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccessEvent: True |
RevokeAccess | RevokeAccessRequest |
SetStateEvent: True |
PATCH /mspcat_certificationrequests(mspcat_certificationrequestid)Update the statecode and statuscode properties. |
SetStateRequest |
UpdateEvent: True |
PATCH /mspcat_certificationrequests(mspcat_certificationrequestid)See Update |
Update records |
UpdateMultipleEvent: True |
UpdateMultiple | UpdateMultipleRequest |
UpsertEvent: False |
PATCH /mspcat_certificationrequests(mspcat_certificationrequestid)See Upsert a table row |
UpsertRequest |
UpsertMultipleEvent: False |
UpsertMultiple | UpsertMultipleRequest |
Events
The following table lists the events for the Approval Request (mspcat_certificationrequest) table. Events are messages that exist so that you can subscribe to them. Unless you added the event, you shouldn't invoke the message, only subscribe to it.
| Name | Web API Operation | SDK for .NET |
|---|---|---|
BulkRetain |
BulkRetain | Learn to use messages with the SDK for .NET |
PurgeRetainedContent |
PurgeRetainedContent | Learn to use messages with the SDK for .NET |
Retain |
Retain | Learn to use messages with the SDK for .NET |
RollbackRetain |
RollbackRetain | Learn to use messages with the SDK for .NET |
ValidateRetentionConfig |
ValidateRetentionConfig | Learn to use messages with the SDK for .NET |
Properties
The following table lists selected properties for the Approval Request (mspcat_certificationrequest) table.
| Property | Value |
|---|---|
| DisplayName | Approval Request |
| DisplayCollectionName | Approval Requests |
| SchemaName | mspcat_certificationrequest |
| CollectionSchemaName | mspcat_certificationrequests |
| EntitySetName | mspcat_certificationrequests |
| LogicalName | mspcat_certificationrequest |
| LogicalCollectionName | mspcat_certificationrequests |
| PrimaryIdAttribute | mspcat_certificationrequestid |
| PrimaryNameAttribute | mspcat_requestname |
| TableType | Standard |
| OwnershipType | UserOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ImportSequenceNumber
- LastOnHoldTime
- mspcat_Application
- mspcat_autoapproved
- mspcat_certduration
- mspcat_certenddate
- mspcat_certificationrequestId
- mspcat_certstartdate
- mspcat_codereview
- mspcat_CRMPackageDropLocation
- mspcat_CRMWorkingPackageDropPath
- mspcat_DropContainsMultiplePackages
- mspcat_functionalvalidation
- mspcat_internalreview
- mspcat_isvduration
- mspcat_isvresponded
- mspcat_isvwaitingstarttime
- mspcat_MarketingOnlyChange
- mspcat_OperationId
- mspcat_OperationType
- mspcat_packagedeployment
- mspcat_Publisher
- mspcat_PublishVersion
- mspcat_RequestAssetId
- mspcat_RequestAssetVersion
- mspcat_RequestCorrelationId
- mspcat_requestname
- mspcat_RequestsAccesstoTSPEvents
- mspcat_RequestSource
- mspcat_RequestsSecureStoreAccess
- mspcat_securityreview
- mspcat_stagename
- mspcat_summaryscanstatus
- mspcat_Supersededby
- mspcat_totalduration
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- processid
- SLAId
- stageid
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- traversedpath
- UTCConversionTimeZoneCode
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | importsequencenumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
LastOnHoldTime
| Property | Value |
|---|---|
| Description | Contains the date and time stamp of the last on-hold time |
| DisplayName | Last On Hold Time |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lastonholdtime |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
mspcat_Application
| Property | Value |
|---|---|
| Description | Application that this submission concerns. |
| DisplayName | Catalog Item |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_application |
| RequiredLevel | Recommended |
| Type | Lookup |
| Targets | mspcat_applications |
mspcat_autoapproved
| Property | Value |
|---|---|
| Description | |
| DisplayName | Auto Approved |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_autoapproved |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | mspcat_certificationrequest_mspcat_autoapproved |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
mspcat_certduration
| Property | Value |
|---|---|
| Description | |
| DisplayName | Cert Duration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_certduration |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
mspcat_certenddate
| Property | Value |
|---|---|
| Description | Captures the date time when approval team completed the request |
| DisplayName | Actual End Date |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_certenddate |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | True |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Auto |
| SourceTypeMask | 0 |
mspcat_certificationrequestId
| Property | Value |
|---|---|
| Description | Unique identifier for entity instances |
| DisplayName | Certification Request |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mspcat_certificationrequestid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
mspcat_certstartdate
| Property | Value |
|---|---|
| Description | Captures the date time when Approval team picked up the request |
| DisplayName | Actual Start Date |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_certstartdate |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | True |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Auto |
| SourceTypeMask | 0 |
mspcat_codereview
| Property | Value |
|---|---|
| Description | shows the code review stage status. |
| DisplayName | Code Review |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_codereview |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 526430000 |
| GlobalChoiceName | mspcat_certificationstage |
mspcat_codereview Choices/Options
| Value | Label |
|---|---|
| 526430000 | Not Started |
| 526430001 | In Progress |
| 526430002 | Waiting on Submitting User |
| 526430003 | Completed |
mspcat_CRMPackageDropLocation
| Property | Value |
|---|---|
| Description | URL of the package to be picked up for processing |
| DisplayName | CRM Package Drop Location |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_crmpackagedroplocation |
| RequiredLevel | None |
| Type | String |
| Format | Url |
| FormatName | Url |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 500 |
mspcat_CRMWorkingPackageDropPath
| Property | Value |
|---|---|
| Description | This is the location where the package file has been dropped for working |
| DisplayName | CRM Working Package Drop Path |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_crmworkingpackagedroppath |
| RequiredLevel | None |
| Type | String |
| Format | Url |
| FormatName | Url |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 500 |
mspcat_DropContainsMultiplePackages
| Property | Value |
|---|---|
| Description | indicator that the file at the drop location has more then one file in it. |
| DisplayName | Drop Contains Multiple Packages |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_dropcontainsmultiplepackages |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | mspcat_mspcat_certificationrequest_mspcat_dropcontainsmultiplepackages |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
mspcat_functionalvalidation
| Property | Value |
|---|---|
| Description | shows the Functional Validation stage status. |
| DisplayName | Functional Validation |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_functionalvalidation |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 526430000 |
| GlobalChoiceName | mspcat_certificationstage |
mspcat_functionalvalidation Choices/Options
| Value | Label |
|---|---|
| 526430000 | Not Started |
| 526430001 | In Progress |
| 526430002 | Waiting on Submitting User |
| 526430003 | Completed |
mspcat_internalreview
| Property | Value |
|---|---|
| Description | Shows the Internal Review stage status. |
| DisplayName | Internal Review |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_internalreview |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 526430000 |
| GlobalChoiceName | mspcat_certificationrequest_mspcat_internalreview |
mspcat_internalreview Choices/Options
| Value | Label |
|---|---|
| 526430000 | Not Started |
| 526430001 | InProgress |
| 526430002 | Reviews Implemented |
| 526430003 | Review Completed |
mspcat_isvduration
| Property | Value |
|---|---|
| Description | |
| DisplayName | ISV Duration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_isvduration |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
mspcat_isvresponded
| Property | Value |
|---|---|
| Description | Captures the ISV responded date time |
| DisplayName | ISV Responded |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_isvresponded |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | True |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Auto |
| SourceTypeMask | 0 |
mspcat_isvwaitingstarttime
| Property | Value |
|---|---|
| Description | Captures the ISV waiting start time |
| DisplayName | ISV Waiting Start Time |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_isvwaitingstarttime |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | True |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Auto |
| SourceTypeMask | 0 |
mspcat_MarketingOnlyChange
| Property | Value |
|---|---|
| Description | Indicates that this Approval Request is a Marketing Only Change request. |
| DisplayName | Marketing Only Change |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_marketingonlychange |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | mspcat_certificationrequest_mspcat_marketingonlychange |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
mspcat_OperationId
| Property | Value |
|---|---|
| Description | Operation ID used to report status back to Calling Service |
| DisplayName | OperationId |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_operationid |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
mspcat_OperationType
| Property | Value |
|---|---|
| Description | Operation Type passed to us by the Storefront |
| DisplayName | Operation Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_operationtype |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 500 |
mspcat_packagedeployment
| Property | Value |
|---|---|
| Description | shows the Package Deployment Stage status. |
| DisplayName | Deployment |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_packagedeployment |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 526430000 |
| GlobalChoiceName | mspcat_certificationstage |
mspcat_packagedeployment Choices/Options
| Value | Label |
|---|---|
| 526430000 | Not Started |
| 526430001 | In Progress |
| 526430002 | Waiting on Submitting User |
| 526430003 | Completed |
mspcat_Publisher
| Property | Value |
|---|---|
| Description | Publisher that this request concerns. |
| DisplayName | Publisher |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_publisher |
| RequiredLevel | Recommended |
| Type | Lookup |
| Targets | mspcat_publisher |
mspcat_PublishVersion
| Property | Value |
|---|---|
| Description | |
| DisplayName | Publish Version |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_publishversion |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 10 |
mspcat_RequestAssetId
| Property | Value |
|---|---|
| Description | |
| DisplayName | Request Asset Id |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_requestassetid |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
mspcat_RequestAssetVersion
| Property | Value |
|---|---|
| Description | |
| DisplayName | Request Asset Version |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_requestassetversion |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
mspcat_RequestCorrelationId
| Property | Value |
|---|---|
| Description | Correlation ID provided on the request for the approval. |
| DisplayName | Request Correlation Id |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_requestcorrelationid |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 50 |
mspcat_requestname
| Property | Value |
|---|---|
| Description | Request name - generated from the request data. |
| DisplayName | Request Name |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_requestname |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 500 |
mspcat_RequestsAccesstoTSPEvents
| Property | Value |
|---|---|
| Description | If true, publisher is requesting intergration to the TPS Event system |
| DisplayName | Requests Access to TSP Events |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_requestsaccesstotspevents |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | mspcat_mspcat_certificationrequest_mspcat_requestsaccesstotspevents |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
mspcat_RequestSource
| Property | Value |
|---|---|
| Description | Contains the Source of the approval request |
| DisplayName | Request Source |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_requestsource |
| RequiredLevel | ApplicationRequired |
| Type | Picklist |
| DefaultFormValue | 526430000 |
| GlobalChoiceName | mspcat_certificationrequest_requestsource |
mspcat_RequestSource Choices/Options
| Value | Label |
|---|---|
| 526430000 | Other |
| 526430001 | Power Automate Maker Portal |
| 526430002 | Power Platform Maker Portal |
| 526430003 | Power Virtual Agents Maker Portal |
| 526430004 | Power Platform Admin API |
| 526430005 | PAC CLI |
| 526430006 | PAC Build Task |
| 526430007 | Pipelines in Power Platform |
mspcat_RequestsSecureStoreAccess
| Property | Value |
|---|---|
| Description | if true, publisher is requesting use of the secure store system for this application |
| DisplayName | Requests Secure Store Access |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_requestssecurestoreaccess |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | mspcat_mspcat_certificationrequest_mspcat_requestssecurestoreaccess |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
mspcat_securityreview
| Property | Value |
|---|---|
| Description | displays the status Security Review |
| DisplayName | Security Review |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_securityreview |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | mspcat_certificationstage |
mspcat_securityreview Choices/Options
| Value | Label |
|---|---|
| 526430000 | Not Started |
| 526430001 | In Progress |
| 526430002 | Waiting on Submitting User |
| 526430003 | Completed |
mspcat_stagename
| Property | Value |
|---|---|
| Description | It denotes the current stage name of the Approval request record. |
| DisplayName | Stage Name |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_stagename |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 526430000 |
| GlobalChoiceName | mspcat_certificationrequest_mspcat_stagename |
mspcat_stagename Choices/Options
| Value | Label |
|---|---|
| 526430000 | Code Review |
| 526430001 | ISV Code Review Response |
| 526430002 | Security Review |
| 526430003 | ISV Security Review Response |
| 526430004 | Package Deployment |
| 526430005 | ISV Package Issue Response |
| 526430006 | Functional Validation |
| 526430007 | ISV Functional Issue Response |
mspcat_summaryscanstatus
| Property | Value |
|---|---|
| Description | |
| DisplayName | Summary of PowerApps scan status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_summaryscanstatus |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | mspcat_scanstatus |
mspcat_summaryscanstatus Choices/Options
| Value | Label |
|---|---|
| 526430000 | Required |
| 526430001 | In Progress |
| 526430002 | Success |
| 526430003 | CompletedWithError |
| 526430004 | Internal error |
| 526430005 | Not required |
mspcat_Supersededby
| Property | Value |
|---|---|
| Description | When populated, Indicated the Approval request that Superseded this request. |
| DisplayName | Superseded by |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_supersededby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | mspcat_certificationrequest |
mspcat_totalduration
| Property | Value |
|---|---|
| Description | |
| DisplayName | Total Duration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_totalduration |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
OverriddenCreatedOn
| Property | Value |
|---|---|
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
OwnerId
| Property | Value |
|---|---|
| Description | Owner Id |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Type | Owner |
| Targets | systemuser, team |
OwnerIdType
| Property | Value |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
processid
| Property | Value |
|---|---|
| Description | Contains the id of the process associated with the entity. |
| DisplayName | Process Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | processid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
SLAId
| Property | Value |
|---|---|
| Description | Choose the service level agreement (SLA) that you want to apply to the record. |
| DisplayName | SLA |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | slaid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | sla |
stageid
| Property | Value |
|---|---|
| Description | Contains the id of the stage where the entity is located. |
| DisplayName | Stage Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | stageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
statecode
| Property | Value |
|---|---|
| Description | Status of the Approval Request |
| DisplayName | Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
| DefaultFormValue | |
| GlobalChoiceName | mspcat_certificationrequest_statecode |
statecode Choices/Options
| Value | Details |
|---|---|
| 0 | Label: Active DefaultStatus: 526430008 InvariantName: Active |
| 1 | Label: Inactive DefaultStatus: 526430000 InvariantName: Inactive |
statuscode
| Property | Value |
|---|---|
| Description | Reason for the status of the Approval Request |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
| DefaultFormValue | |
| GlobalChoiceName | mspcat_certificationrequest_statuscode |
statuscode Choices/Options
| Value | Details |
|---|---|
| 1 | Label: Submitted State:0 TransitionData: None |
| 2 | Label: Completed State:1 TransitionData: None |
| 526430000 | Label: Abandoned State:1 TransitionData: None |
| 526430001 | Label: InProgress State:0 TransitionData: None |
| 526430002 | Label: Waiting On Submitter State:0 TransitionData: None |
| 526430003 | Label: Pending Deployment State:0 TransitionData: None |
| 526430004 | Label: Rejected State:1 TransitionData: None |
| 526430005 | Label: Marketing Content State:1 TransitionData: None |
| 526430006 | Label: Duplicate Request State:1 TransitionData: None |
| 526430008 | Label: Draft State:0 TransitionData: None |
| 526430009 | Label: Processing State:0 TransitionData: None |
| 526430010 | Label: Failed Prevalidation State:1 TransitionData: None |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
traversedpath
| Property | Value |
|---|---|
| Description | A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur. |
| DisplayName | Traversed Path |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | traversedpath |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1250 |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- mspcat_duration
- mspcat_Submissiondocument
- mspcat_Submissiondocument_Name
- OnHoldTime
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- slaidname
- SLAInvokedId
- VersionNumber
CreatedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
CreatedOn
| Property | Value |
|---|---|
| Description | Date and time when the record was created. |
| 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 | Unique identifier of the delegate user who created the record. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
ModifiedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who modified the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
ModifiedOn
| Property | Value |
|---|---|
| Description | Date and time when the record was modified. |
| 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 | Unique identifier of the delegate user who modified the record. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
mspcat_duration
| Property | Value |
|---|---|
| Description | Time spent on the current approval request |
| DisplayName | Approval Duration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_duration |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
mspcat_Submissiondocument
| Property | Value |
|---|---|
| Description | A copy of the submission document for an approval request |
| DisplayName | Submission document |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | mspcat_submissiondocument |
| RequiredLevel | None |
| Type | File |
| MaxSizeInKB | 32768 |
mspcat_Submissiondocument_Name
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mspcat_submissiondocument_name |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Disabled |
| IsLocalizable | False |
| MaxLength | 200 |
OnHoldTime
| Property | Value |
|---|---|
| Description | Shows how long, in minutes, that the record was on hold |
| DisplayName | On Hold Time (Minutes) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | onholdtime |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
OwnerIdName
| Property | Value |
|---|---|
| Description | Name of the owner |
| 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 | Yomi name of the owner |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier for the business unit that owns the record |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Type | Lookup |
| Targets | businessunit |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier for the team that owns the record. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Type | Lookup |
| Targets | team |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier for the user that owns the record. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
slaidname
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slaidname |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
SLAInvokedId
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Last SLA Applied |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slainvokedid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | sla |
VersionNumber
| Property | Value |
|---|---|
| Description | Version Number |
| 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.
- mspcat_mspcat_applications_mspcat_certificationrequest_Application
- mspcat_mspcat_certificationrequest_mspcat_certificationrequest_Supersededby
- mspcat_mspcat_publisher_mspcat_certificationrequest_Publisher
mspcat_mspcat_applications_mspcat_certificationrequest_Application
One-To-Many Relationship: mspcat_applications mspcat_mspcat_applications_mspcat_certificationrequest_Application
| Property | Value |
|---|---|
| ReferencedEntity | mspcat_applications |
| ReferencedAttribute | mspcat_applicationsid |
| ReferencingAttribute | mspcat_application |
| ReferencingEntityNavigationPropertyName | mspcat_Application |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
mspcat_mspcat_certificationrequest_mspcat_certificationrequest_Supersededby
One-To-Many Relationship: mspcat_certificationrequest mspcat_mspcat_certificationrequest_mspcat_certificationrequest_Supersededby
| Property | Value |
|---|---|
| ReferencedEntity | mspcat_certificationrequest |
| ReferencedAttribute | mspcat_certificationrequestid |
| ReferencingAttribute | mspcat_supersededby |
| ReferencingEntityNavigationPropertyName | mspcat_Supersededby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
mspcat_mspcat_publisher_mspcat_certificationrequest_Publisher
One-To-Many Relationship: mspcat_publisher mspcat_mspcat_publisher_mspcat_certificationrequest_Publisher
| Property | Value |
|---|---|
| ReferencedEntity | mspcat_publisher |
| ReferencedAttribute | mspcat_publisherid |
| ReferencingAttribute | mspcat_publisher |
| ReferencingEntityNavigationPropertyName | mspcat_Publisher |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- mspcat_certificationrequest_mspcat_InstallActivities
- mspcat_certreject_cert
- mspcat_certreq_analysis_status_reln
- mspcat_mspcat_certificationrequest_mspcat_certificationrequest_Supersededby
mspcat_certificationrequest_mspcat_InstallActivities
Many-To-One Relationship: mspcat_installactivity mspcat_certificationrequest_mspcat_InstallActivities
| Property | Value |
|---|---|
| ReferencingEntity | mspcat_installactivity |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | mspcat_certificationrequest_mspcat_InstallActivities |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
mspcat_certreject_cert
Many-To-One Relationship: mspcat_certificationrejectionappliedpolicy mspcat_certreject_cert
| Property | Value |
|---|---|
| ReferencingEntity | mspcat_certificationrejectionappliedpolicy |
| ReferencingAttribute | mspcat_certificationrequest |
| ReferencedEntityNavigationPropertyName | mspcat_certreject_cert |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
mspcat_certreq_analysis_status_reln
Many-To-One Relationship: mspcat_powerappsscanstatus mspcat_certreq_analysis_status_reln
| Property | Value |
|---|---|
| ReferencingEntity | mspcat_powerappsscanstatus |
| ReferencingAttribute | mspcat_parentrequestid |
| ReferencedEntityNavigationPropertyName | mspcat_certreq_analysis_status_reln |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
mspcat_mspcat_certificationrequest_mspcat_certificationrequest_Supersededby
Many-To-One Relationship: mspcat_certificationrequest mspcat_mspcat_certificationrequest_mspcat_certificationrequest_Supersededby
| Property | Value |
|---|---|
| ReferencingEntity | mspcat_certificationrequest |
| ReferencingAttribute | mspcat_supersededby |
| ReferencedEntityNavigationPropertyName | mspcat_mspcat_certificationrequest_mspcat_certificationrequest_Supersededby |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-to-Many relationships
mspcat_attachedpackages
See mspcat_packages mspcat_attachedpackages Many-To-Many Relationship
| Property | Value |
|---|---|
| IntersectEntityName | mspcat_certreq_package_association |
| IsCustomizable | True |
| SchemaName | mspcat_attachedpackages |
| IntersectAttribute | mspcat_certificationrequestid |
| NavigationPropertyName | mspcat_attachedpackages |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseLabelGroup: DetailsLabel: Related offers MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference