Object Reference

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

URA_REQUIREMENT_APPROVALS

Description

Stores data on approval ballots.

Source      

SBM

Fields   

• TS_ID

Approval ballot ID.

• TS_TITLE

Title of the approval ballot.

• TS_REQUIREMENT_APPROVAL (id)

Identifier for the approval ballot.

• TS_ALM_PROJECT

Associated ALM project.

• TS_DVM_CHANGE_REQUEST

Associated change request from Development Manager.

• TS_TARGET_DUE_DATE

Target due date for the ballot.

• TS_DEV_MANAGERS

Development managers assigned to the ballot.

• TS_QA_MANAGERS

QA managers assigned to the ballot.

• TS_DISTRIBUTION_TASK_COMPLETE

• TS_REQUIREMENT_IDS

IDs of the requirements to be approved.

• TS_REQUIREMENT_CLASS_NAMES

• TS_RM_SNAPSHOT_ID

ID of the snapshot in Dimensions RM.

• TS_RM_SNAPSHOT_NAME

Name of the snapshot in Dimensions RM.

• TS_RM_DOCUMENT_ID

ID of the requirements document in Dimensions RM.

• TS_REVIEWERS_SUBMITTED

• TS_RM_SNAPSHOT_URL

URL to the Dimensions RM snapshot.

• TS_RM_DOCUMENT_NAME

Name of the requirements document in Dimensions RM.

• TS_RM_DOCUMENT_URL

URL to the requirements document in Dimensions RM.

• TS_RM_SNAPSHOT_PREV_NAME

Previous name of the Dimensions RM snapshot.

• TS_LASTMODIFIEDDATE

Last modified date of the approval ballot.

• TS_LASTMODIFIER

User who last modified the approval ballot.

• TS_LASTSTATECHANGER

User who last changed the state of the approval ballot.

• TS_SUBMITTER

User who submitted the approval ballot.

• TS_SUBMITDATE

Date when the approval ballot was submitted.

• TS_CLOSEDATE

Date when the approval ballot was closed.

• TS_STATE

Current state of the approval ballot.

• TS_LASTSTATECHANGEDATE

Date when the state was last changed.

• TS_ACTIVEINACTIVE

• TS_PROJECTID

ID of the ALM project (as stored in the USR_ALM_PROJECTS table).

• TS_OWNER

Owner of the approval ballot.

• TS_SECONDARYOWNER

Secondary owner of the approval ballot.

• TS_ISSUETYPE

• TS_APPROVED_POLLS