HP ALM Database Reference
td.BL_REQ Table

Description

Baseline table for the entity.

Remarks

For descriptions of the table and columns, see the referenced entity table. For example, for details of HIST_TEST, see the TEST table.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key RQ_BL_IDThe ID of the Baseline to which this version is pinned.int4  
Primary Key RQ_REQ_ID int4  
 RQ_FATHER_IDThe ID of the parent entity.int4 
 RQ_ORDER_ID int4 
 RQ_ISTEMPLATE int4 
 RQ_REQ_COMMENT varchar16 
 RQ_REQ_REVIEWED varchar255 
 RQ_REQ_PATHThe highest level node has path AAA. Each child node down the tree inherits the parent path and adds three letters,where the current level numeration is concatenated to the inherited path. For example, the child requirements of the first node (AAA) have paths of AAAAAA, AAAAAB, AAAAAC, and so on. The characters V and W are not used.varchar255  
 RQ_REQ_STATUS varchar255 
 RQ_REQ_PRIORITY varchar255 
 RQ_REQ_TYPE varchar255 
 RQ_REQ_PRODUCT varchar255 
 RQ_REQ_NAMEThe name of the item.varchar255 
 RQ_REQ_AUTHOR varchar255 
 RQ_RBT_IGNORE_IN_ANALYSIS varchar1 
 RQ_RBT_BSNS_IMPACT varchar1 
 RQ_RBT_CUSTOM_BSNS_IMPACT varchar1 
 RQ_RBT_USE_CUSTOM_BSNS_IMPACT varchar1 
 RQ_RBT_EFFECTIVE_BSNS_IMPACT varchar1 
 RQ_RBT_FAIL_PROB varchar1 
 RQ_RBT_CUSTOM_FAIL_PROB varchar1 
 RQ_RBT_USE_CUSTOM_FAIL_PROB varchar1 
 RQ_RBT_EFFECTIVE_FAIL_PROB varchar1 
 RQ_RBT_RISK varchar1 
 RQ_RBT_CUSTOM_RISK varchar1 
 RQ_RBT_USE_CUSTOM_RISK varchar1 
 RQ_RBT_EFFECTIVE_RISK varchar1 
 RQ_RBT_FUNC_CMPLX varchar1 
 RQ_RBT_CUSTOM_FUNC_CMPLX varchar1 
 RQ_RBT_USE_CUSTOM_FUNC_CMPLX varchar1 
 RQ_RBT_EFFECTIVE_FUNC_CMPLX varchar1 
 RQ_RBT_TESTING_LEVEL varchar70 
 RQ_RBT_CUSTOM_TESTING_LEVEL varchar70 
 RQ_RBT_TESTING_HOURS int4 
 RQ_RBT_CUSTOM_TESTING_HOURS int4 
 RQ_RBT_USE_CUSTOM_TL_AND_TE varchar1 
 RQ_RBT_RND_ESTIM_EFFORT_HOURS int4 
 RQ_RBT_ASSESSMENT_DATA varchar16 
 RQ_RBT_ANALYSIS_PARENT_REQ_ID int4 
 RQ_RBT_ANALYSIS_SETUP_DATA varchar16 
 RQ_RBT_ANALYSIS_RESULT_DATA varchar16 
 RQ_RBT_LAST_ANALYSIS_DATE datetime4 
 RQ_USER_01User-defined field.varchar40 
 RQ_USER_02User-defined field.varchar40 
 RQ_USER_03User-defined field.varchar40 
 RQ_USER_04User-defined field.varchar40 
 RQ_USER_05User-defined field.varchar40 
 RQ_USER_06User-defined field.varchar40 
 RQ_USER_07User-defined field.varchar40 
 RQ_USER_08User-defined field.varchar40 
 RQ_USER_09User-defined field.varchar40 
 RQ_USER_10User-defined field.varchar40 
 RQ_USER_11User-defined field.varchar40 
 RQ_USER_12User-defined field.varchar40 
 RQ_REQ_VER_STAMPThe version number of this record.int4 
 RQ_ATTACHMENTA value of Y indicates that the item has at least one attachment.varchar1 
 RQ_REQ_DATE datetime4 
 RQ_REQ_TIME varchar10 
 RQ_NO_OF_SONS int4 
 RQ_IS_FOLDER varchar1 
 RQ_VTSThe version time stamp.varchar20 
 RQ_USER_13User-defined field.varchar40 
 RQ_USER_14User-defined field.varchar40 
 RQ_USER_15User-defined field.varchar40 
 RQ_USER_16User-defined field.varchar40 
 RQ_USER_17User-defined field.varchar40 
 RQ_USER_18User-defined field.varchar40 
 RQ_USER_19User-defined field.varchar40 
 RQ_USER_20User-defined field.varchar40 
 RQ_USER_21User-defined field.varchar40 
 RQ_USER_22User-defined field.varchar40 
 RQ_USER_23User-defined field.varchar40 
 RQ_USER_24User-defined field.varchar40 
 RQ_REQUEST_ID int4 
 RQ_TEXT_SYNCFor internal use. Do not change data.varchar1 
 RQ_REQUEST_SERVER varchar120 
 RQ_REQUEST_TYPE varchar120 
 RQ_REQUEST_STATUS varchar40 
 RQ_REQUEST_UPDATES varchar120 
 RQ_REQUEST_ASSIGN_TO varchar120 
 RQ_REQUEST_NOTE varchar16 
 RQ_TYPE_ID int4  
 RQ_TARGET_RCYC_VARCHAR varchar255 
 RQ_TARGET_REL_VARCHAR varchar255 
 RQ_TARGET_RCYC int4 
 RQ_TARGET_REL int4 
 RQ_DEV_COMMENTSComments.Commentsvarchar16 
 RQ_HAS_RICH_CONTENT varchar1 
 RQ_VC_VERSION_NUMBERThe version ID of the entity.int4 
 RQ_VC_STATUSThe version status: Checked in, checked out, or read only.varchar20 
 RQ_VC_CHECKIN_USER_NAMEThe user name of the user who checked in this version.varchar60 
 RQ_VC_CHECKIN_DATEThe date this version was checked in according to the server clock.datetime4 
 RQ_VC_CHECKIN_TIMEThe time this version was checked in according to the server clock.varchar10 
 RQ_VC_CHECKIN_COMMENTSComments.The user's comments when checking in the item.varchar16 
 RQ_VC_CHECKOUT_USER_NAMEThe user who checked out the item under version control.varchar60 
 RQ_VC_CHECKOUT_DATEThe date the version was checked out according to the server clock.datetime4 
 RQ_VC_CHECKOUT_TIMEThe time this version was checked out according to the server clock.varchar10 
 RQ_VC_CHECKOUT_COMMENTSComments.The user's comments when checking out the item.varchar16 
 RQ_REQ_RICH_CONTENT varchar16 

See Also

Related Objects

td Schema
Shadow Tables