HP ALM Database Reference
td.REQ_TYPE Table

Description

Types of requirements.

Remarks

The table is installed already populated with predefined types: Folder, Group, Undefined, Functional, Business, Testing. Additional types are added by the project administrator.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key TPR_TYPE_IDThe record ID.int4  
 TPR_NAMEThe type name.varchar80  
 TPR_ICON_STREAMObsolete. The encoded graphic icon in Quality Center versions prior to ALM 11.00. Replaced by TPR_ICON_STREAM2.varchar2000 
 TPR_PREFIXThe recommended prefix for requirements of this type. For example, if TPR_PREFIX for the type is BIZ, requirements of the type should have names like BIZ_REQ1. ALM does not change the names of existing requirements if TPR_PREFIX is changed.varchar10 
 TPR_EDITING_CONTROLFor future use.varchar255 
 TPR_HAS_DIRECT_COVERAGEA value of 1 indicates that this type of requirement can have direct test coverage.varchar1  
 TPR_RISK_ANALYSIS_TYPEA value of enum TDAPI_RBT_REQUIREMENT_TYPE_RISK_ANALYSIS_TYPE. See the API reference for possible values.int4  
 TPR_RICH_TEXT_TEMPLATEThe HTML representation of the requirement type's Rich Text Template document.varchar16 
 TPR_ICON_STREAM2The encoded graphic icon.varchar16 

See Also