Table Reference

You can use the columns in this table to build your own metrics on deployment data.

USR_DEPLOYMENT

Description

Provides data about deployment activities as a whole; each record in this table includes information on associated release packages, requests, deployment units, stage in the deployment lifecycle, the type of deployment activity, the state of the associated deployment task, etc.

Source

SBM schema.

Columns   

• TS_ID

Primary key. Deployment ID.

• TS_TASK_STATE

Current state of the deployment task.

• TS_STATE

• TS_RELEASE_PACKAGES

IDs of associated release packages, from the USR_RELEASE_PACKAGE table.

• TS_APPLICATION

Associated application, from the USR_RELATED_DEPLOY_UNIT table.

• TS_RELEASE_REQUEST

Associated request for a release, from the USR_RELATED_REQUESTS table.

• TS_RELATED_DEPLOY_UNIT

Associated deployment unit from the USR_RELATED_DEPLOY_UNIT table.

• STAGE

Current release stage, from the USR_RELEASETYPE_STAGE table.

• TS_AUTOMATION_TYPE

Automation type.

• TS_DEPLOYMENT_TYPE

Type of deployment task: manual, approval, vault, or automation.

• TS_TASK_STATES

States in the deployment task.

• TS_RELEASE_ENGINEER

Primary owner of the deployment process.

• TS_TEMPLATE

The deployment process template.

• TS_VAULT_TYPE

Type of release vault, such as CM or ZMF.