Edit

Pipeline table reference

  • Article

This article contains the table definitions used in the Pipeline solution. More information: Overview of pipelines in Power Platform

Diagram showing relationship between pipeline tables

Note

For brevity, common columns found on all tables are not included here. The schema name for these columns are: CreatedBy, CreatedOn, CreatedOnBehalfBy, ImportSequenceNumber, ModifiedBy, ModifiedOn, ModifiedOnBehalfBy, OverriddenCreatedOn, OwningBusinessUnit, OwningTeam, OwningUser, TimeZoneRuleVersionNumber, UTCConversionTimeZoneCode, VersionNumber, and statecode.

DeploymentArtifact (Deployment Artifact)

Stores solution artifacts that are exported when running pipelines.

SchemaName
Display Name		 Type Description
ArtifactVersion
Artifact Version		 String Stores the artifact version number.
DeploymentArtifactId
DeploymentArtifact		 Uniqueidentifier Unique identifier for entity instances.
GeneratedOn
Generated On		 DateTime Date and time when the artifact record was generated.
Name
Name		 String The name of the artifact record.
OwnerId
Owner		 Owner Owner ID
statuscode
Status Reason		 Status Reason for the status of the Deployment Artifact.
Value:1 Label: Active
Value:2 Label: Inactive
ArtifactFile
Managed Artifact File		 File Stores the managed version of the artifact.
Not valid for Create
ArtifactFileUnmanaged
Unmanaged Artifact File		 File Unmanaged Artifact File.
Not valid for Create

DeploymentEnvironment (Deployment Environment)

Stores the environments that are participating in pipelines and configured in the deployment stages.

SchemaName
Display Name		 Type Description
DeploymentEnvironmentId
Deployment Environment		 Uniqueidentifier Unique identifier for deployment environment instances
EnvironmentId
Environment ID		 String The Environment ID of the Power Platform environment.
EnvironmentType
Environment Type		 Picklist Indicates if the environment is used for development or as a target environment that a pipeline will deploy to.
Value: 200000000 Label: Development Environment
Value: 200000001 Label: Target Environment
ErrorMessage
Error Message		 String Stores the Power Platform environment validation failure error messages.
name
Name		 String The name of the Deployment Environment.
OwnerId
Owner		 Owner Owner ID
statuscode
Status Reason		 Status Reason for the status of the Deployment Environment.
Value:1 Label: Active
Value:2 Label: Inactive
ValidationStatus
Validation Status		 Picklist Indicates if the Environment ID of the Power Platform environment has been validated.
Not valid for Create
Value:200000000 Label: Pending
Value:200000001 Label: Success
Value:200000002 Label: Failed

DeploymentPipeline (Deployment Pipeline)

Stores the pipeline configurations.

SchemaName
Display Name		 Type Description
DeploymentPipelineId
Deployment Pipeline		 Uniqueidentifier Unique identifier for the pipeline instances
Description
Description		 String Custom description of the pipeline.
Name
Name		 String The name of the pipeline record.
OwnerId
Owner		 Owner Owner ID
statuscode
Status Reason		 Status Reason for the status of the deployment pipeline.
Value:1 Label: Active
Value:2 Label: Inactive

DeploymentStage (Deployment Stage)

Stores the deployment stage configuration such as target environment and prerequisite deployment stages.

SchemaName
Display Name		 Type Description
DeploymentPipelineId
Deployment Pipeline		 Lookup Lookup to the pipeline that this stage belongs to.
DeploymentStageId
Deployment Stage ID		 Uniqueidentifier Unique identifier for the Deployment Stage instance.
Description
Description		 String Custom description of the deployment stage instance.
Name
Name		 String The name of the deployment stage instance.
OwnerId
Owner		 Owner Owner ID
PreviousDeploymentStageId
Previous Deployment Stage		 Lookup Lookup to the previous deployment stage configured in the pipeline. Previous deployment stages must be run successfully before deployments can be run for the current stage.
statuscode
Status Reason		 Status Reason for the status of the Deployment Stage.
Value:1 Label: Active
Value:2 Label: Inactive
TargetDeploymentEnvironmentId
Target Deployment Environment ID		 Lookup Lookup to the target deployment environment associated with this deployment stage.

DeploymentStageRun (Deployment Stage Run)

Stores information about a deployment stage execution.

SchemaName
Display Name		 Type Description
ArtifactDevCurrentVersion
Solution Artifact Current Version		 String Stores the current version of the solution artifact within a development environment.
ArtifactId
Artifact ID		 Lookup Internal use only.
ArtifactName
Artifact Name		 String The name of the Deployment Artifact being deployed by a Stage Run instance.
ArtifactVersion
Solution Artifact Version		 String The version number of the Deployment Artifact being deployed by a Stage Run instance.
DeploymentSettingsJson
Deployment Settings JSON		 String Validated JSON payload storing the Connection Reference and Environment Variable information collected when a Deployment Stage is run.
DeploymentStageId
Deployment Stage		 Lookup Lookup to the Deployment Stage associated with a Deployment Stage Run instance.
DeploymentStageRunId
Deployment Stage Run		 Uniqueidentifier Unique identifier for Deployment Stage Run instances.
DevDeploymentEnvironment
Development Deployment Environment ID		 Lookup Lookup to the development Deployment Environment associated with a Deployment Stage Run.
DevEnvironmentId
Dev Environment Id		 String For internal use only.
EndTime
End Time		 DateTime Date and time when the deployment succeeded or failed.
ErrorMessage
Error Message		 String Stores the deployment failure messages for a stage run instance.
Name
Name		 String The name of a Deployment Stage Run. This is auto-generated based on the stage name, the artifact name, and the artifact version number.
Operation
Operation		 Picklist Indicates the current operation the deployment.
Value: 200000200 Label: None
Value: 200000201 Label: Validate
Value: 200000202 Label: Deploy
OperationDetails
Operation Details		 String Stores the details of the current deployment operation.
OperationStatus
Operation Status		 Picklist Stores the status of the current deployment operation.
Value: 200000000 Label: NotStarted
Value: 200000001 Label: Started
Value: 200000002 Label: Succeeded
Value: 200000003 Label: Failed
Value: 200000004 Label: Pending
OwnerId
Owner		 Owner Owner ID
RetryCount
Retry Count		 Integer For internal use only.
StageRunStatus
Stage Run Status		 Picklist Indicates the overall status of a Deployment Stage Run.
Value: 200000000 Label: NotStarted
Value: 200000001 Label: Started
Value: 200000002 Label: Succeeded
Value: 200000003 Label: Failed
StartTime
Start Time		 DateTime Date and time when the deployment started.
statuscode
Status Reason		 Status Reason for the status of the Deployment Stage Run.
Value:1 Label: Active
Value:2 Label: Inactive
SubOperation
SubOperation		 Picklist Represents the sub operation of the current deployment operation. This is managed internally.
Value: 200000100 Label: None
Value: 200000101 Label: Executing Pre-step
Value: 200000102 Label: Retrieving Artifact Configuration
Value: 200000103 Label: Validating Artifact Configuration
Value: 200000104 Label: Retrieving Artifact
Value: 200000105 Label: Deploying Artifact
Value: 200000106 Label: Executing Post-step
TargetDeploymentEnvironment
Target Deployment Environment ID		 Lookup Lookup to the target Deployment Environment associated with a Deployment Stage Run.
TargetEnvironmentId
Target Environment Id		 String For internal use only.
ValidationResults
Validation Results		 String Stores the artifact validation response.

DeploymentStageRunStatus (Deployment Stage Run Suboperations)

Stores background operation information for a Deployment Stage Run.

SchemaName
Display Name		 Type Description
DeploymentStageRunId
Deployment Stage Run		 Lookup Lookup to the owning Deployment Stage Run instance.
DeploymentStageRunStatusId
Deployment Stage Run Suboperation ID		 Uniqueidentifier Unique identifier for Deployment Stage Run Suboperation instances.
Details
Details		 String Stores information about the Deployment Stage Run Suboperation.
EndTime
End Time		 DateTime Date and Time when the deployment operation succeeded or failed.
ErrorMessage
Error Message		 String Stores any error message associated with the Deployment Stage Run Suboperation.
Name
Name		 String The name of the Deployment Stage Run Suboperation. This is managed internally.
Operation
Operation		 Picklist Stores information about the deployment operation being run.
Value: 200000200 Label: None
Value: 200000201 Label: Validate
Value: 200000202 Label: Deploy
OperationStatus
Operation Status		 Picklist Stores the status of the deployment sub operation.
Value: 200000000 Label: NotStarted
Value: 200000001 Label: Started
Value: 200000002 Label: Succeeded
Value: 200000003 Label: Failed
Value: 200000004 Label: Pending
OwnerId
Owner		 Owner Owner ID
RetryCount
Retry Count		 Integer For internal use only.
StartTime
Start Time		 DateTime Date and time when the deployment operation started.
statuscode
Status Reason		 Status Reason for the status of the Deployment Stage Run Status.
Value:1 Label: Active
Value:2 Label: Inactive
SubOperation
Suboperation		 Picklist Stores additional information about the background operation.
Value: 200000100 Label: None
Value: 200000101 Label: Executing Pre-step
Value: 200000102 Label: Retrieving Artifact Configuration
Value: 200000103 Label: Validating Artifact Configuration
Value: 200000104 Label: Retrieving Artifact
Value: 200000105 Label: Deploying Artifact
Value: 200000106 Label: Executing Post-step

See Also

Overview of pipelines in Power Platform