Build Objects Table Reference

The ALMBuildData synonym contains the following tables. You can use the columns in the synonym tables to build your own metrics on build data.

BLD_BUILD_JOB

Description

Data on Dimensions CM build jobs. You can learn more about Dimensions CM published views in the Serena Dimensions CM Reports Guide.

Source

Dimensions CM schema.

Columns   

• BUILD_JOB_ID

Primary key. Stores the ID of the Dimensions CM build job.

• BUILD_ENV_ID

ID of the associated Dimensions CM build environment.

• BUILD_AREA_ID

ID of the associated Dimensions CM build area.

• BUILD_JOB_START_TIME

The start time for the build job.

• BUILD_JOB_STOP_TIME

The stop time for the build job.

• BUILD_JOB_USER

The user who created the build job.

• BUILD_JOB_RESULT

The result of the build job.

• BUILD_CONFIG_VERSION_ID

The ID of the version of the build configuration for the job.

• CLEAN_BUILD

Whether the build job should clean the target directory before running.

• SRC_BLINE_ID

The ID of the source baseline that the build job compiles.

BLD_BUILD_ENV

Description

Data on Dimensions CM build environments.

Source

Dimensions CM schema.

Columns   

• BUILD_ENV_ID

Primary key. ID of the build environment.

• BUILD_CONFIG_ID

ID of the build configuration for the environment.

• BUILD_AREA_ID

ID of the build area.

• BUILD_ENV_ASKPASSRUNTIME

Whether a password is required at runtime in order to run a build.

BLD_BUILD_CONFIG

Description

Data on Dimensions CM build configurations.

Source

Dimensions CM schema.

Columns   

• BUILD_CONFIG_ID

ID of the Dimensions CM build configuration.

• PROJECT_ID

ID of the Dimensions CM build project.

• PLATFORM_ID

ID of the Dimensions CM build platform.

• BUILD_CONFIG_CURRENT_ID

ID of the current build configuration.

BLD_BUILD_CONFIG_VERSION

Description

Data on versions of Dimensions CM build configurations.

Source

Dimensions CM schema.

Columns   

• BUILD_CONFIG_VERSION_ID

ID of the Dimensions CM build configuration version.

• BUILD_CONFIG_ID

ID of the Dimensions CM configuration.

• BUILD_CONFIG_VERSION_NUMBER

Dimensions CM build configuration version number.

• BUILD_CONFIG_VERSION_DATE

Date that the build configuration version was created.

BLN_CATALOGUE

Description

Data on Dimensions CM baselines.

Source

Dimensions CM schema.

Columns   

• OBJ_UID

Baseline ID.

• OBJ_SPEC_UID

Baseline specification ID.

• TYPE_UID

The type of baseline.

BLN_SPEC_CATALOGUE

Source

Dimensions CM schema.

• OBJ_SPEC_UID

• TYPE_UID

• PRODUCT_ID

Product ID.

• OBJ_ID

AREA_CATALOGUE

Description

Data on Dimensions CM areas.

Source

Dimensions CM schema.

Columns   

• AREA_UID

Area UID.

• AREA_ID

Name of the area.

• NETWORKNODE_UID

ID of the network node.

• DIRECTORY

Directory path to the area.

WS_CATALOGUE

Description

Dimensions CM project / stream specification.

Source

Dimensions CM schema.

Columns   

• OBJ_UID

Project / steam ID.

• OBJ_SPEC_UID

Full specification of the project / steam.

• TYPE_UID

The type of project or stream.

• REVISION

WS_SPEC_CATALOGUE

Source

Dimensions CM schema.

Columns   

• OBJ_SPEC_UID

• TYPE_UID

• PRODUCT_ID

ID of the Dimensions CM product.

• OBJ_ID