Description
The UCA_CHANGE_REQUESTS table stores data on requirement approvals in Serena Requirements Manager. All metrics that display information about requirement approvals draw data from this table.
Source
SBM
Fields
TS_ID
Requirement approval ID.
UUID
Unique identifier for the requirement approval.
TS_TITLE
Requirement approval title.
TS_DESCRIPTION
Requirement approval description.
TS_STATE
Current state of the approval.
TS_ASSOCIATED_ISSUE
ID of issue related to the approval.
TS_PROJECT_ID
ID of associated ALM project.
TS_CA_ADDITIONAL_NOTES
Additional comments in the approval.
TS_REVIEWERS
Requirement approval reviewers.
TS_CA_REVIEWER
TS_LASTMODIFIEDDATE
Date when the approval was last updated.
TS_ACTIVEINACTIVE
Whether the approval is active or inactive.
TS_ISSUETYPE
Type of approval.
TS_SUBMITTER
Submitter of the approval.
TS_OWNER
Owner of the approval.
TS_CLOSEDATE
Close date for the approval.
TS_LASTMODIFIER
User that last modified the approval.
TS_LASTSTATECHANGEDATE
Date of the last change to a state.
TS_LASTSTATECHANGER
User that last changed a state.
TS_SECONDARYOWNER
Secondary owner of the approval.
TS_SUBMITDATE
When the approval was submitted.
TS_CA_REASON_FOR_CLOSE
Reason for closing the approval.
TS_CA_PARENT_CHANGE_REQUEST
TS_CA_REVIEW_SUBTASKS
TS_CS_REVIEW_STATUS