Pipeline table reference

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

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