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 Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | TPR_TYPE_ID | The record ID. | int | 4 | |||
| TPR_NAME | The type name. | varchar | 80 | ||||
| TPR_ICON_STREAM | Obsolete. The encoded graphic icon in Quality Center versions prior to ALM 11.00. Replaced by TPR_ICON_STREAM2. | varchar | 2000 |  | |||
| TPR_PREFIX | The 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. | varchar | 10 | | |||
| TPR_EDITING_CONTROL | For future use. | varchar | 255 | | |||
| TPR_HAS_DIRECT_COVERAGE | A value of 1 indicates that this type of requirement can have direct test coverage. | varchar | 1 | ||||
| TPR_RISK_ANALYSIS_TYPE | A value of enum TDAPI_RBT_REQUIREMENT_TYPE_RISK_ANALYSIS_TYPE. See the API reference for possible values. | int | 4 | ||||
| TPR_RICH_TEXT_TEMPLATE | The HTML representation of the requirement type's Rich Text Template document. | varchar | 16 | | |||
| TPR_ICON_STREAM2 | The encoded graphic icon. | varchar | 16 | | |||
| TPR_ICON_REF | For internal use by HP. | varchar | 256 | | |||
| TPR_DEFAULT_CHILD_TYPE_ID | For internal use by HP. | int | 4 | | |||
| TPR_IS_DOCUMENT_ROOT | For internal use by HP. | varchar | 1 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| TPR_NAME_LWR_IDX | | ||
| TPR_PRIMARYKEY | | |
Objects that depend on td.REQ_TYPE
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | AUTR81022_REQ | Trigger | 2 | |
| MVTR_REQ | Trigger | 2 | |
 | td.REQ | Table | Details of individual requirements and the structure of the requirements tree. | 1 |
See Also