Table Reference

You can use the columns in the following tables to supply IDs to various objects in your own metrics.

TS_PROJECTS

Description

Provides IDs for projects from providers. The USR_APPLICATION_RELEASE and URM_RELEASE_TRAIN tables refer to it.

Source

SBM schema.

Columns   

• TS_ID

Project ID.

TS_SELECTIONS

Description

Provides IDs for various objects. In the RLM tables, TS_SELECTIONS provides IDs for release types to the USR_APPLICATION_RELEASE and URM_RELEASE_TRAIN tables.

Source

SBM schema.

Columns   

• TS_ID

Object ID.

TS_STATES

Description

Provides IDs for workflow states. In the RLM tables, TS_STATES provides IDs for states to the USR_APPLICATION_RELEASE and URM_RELEASE_TRAIN tables.

Source

SBM schema.

Columns   

• TS_ID

State ID.

• TS_NAME

State name.

• TS_STATUS

• TS_OPENCLOSED

TS_CHANGEACTIONS

Source

SBM schema.

Columns   

• TS_ID

Primary key. Change action ID.

• TS_ACTION

The action.

• TS_ITEMID

• TS_TABLEID

• TS_TIME

• TS_USERID