HP ALM Database Reference
td.VC_TEST Table

Description

Versions of the entity that are checked out under version control.

Remarks

The versions in this table are not available to users in the Quality Center UI until they are checked in. They are visible to the user who checked out the version and to privileged users. Descriptions of the table and columns are in the referenced entity table. For example, for details of VC_TEST,see the TEST table.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key TS_VC_USER_NAMEThe name of the item.varchar255  
 TS_TEST_VERSION int4 
Primary Key TS_TEST_ID int4  
 TS_NAMEThe name of the item.varchar255 
 TS_STEPS int4 
 TS_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 
 TS_SUBJECT int4 
 TS_STATUS varchar70 
 TS_RESPONSIBLE varchar60 
 TS_CREATION_DATEThe server date when this item was created.datetime4 
 TS_DESCRIPTIONA free text description of this item.varchar16 
 TS_TYPE varchar70 
 TS_TIMEOUT int4 
 TS_ATTACHMENTA value of Y indicates that the item has at least one attachment.varchar1 
 TS_RUNTIME_DATA varchar255 
 TS_WORKING_MODE varchar70 
 TS_PROTOCOL_TYPE varchar255 
 TS_SERVICE_TEST_MODE varchar70 
 TS_USER_01User-defined field.varchar40 
 TS_USER_02User-defined field.varchar40 
 TS_USER_03User-defined field.varchar40 
 TS_USER_04User-defined field.varchar40 
 TS_USER_05User-defined field.varchar40 
 TS_USER_06User-defined field.varchar40 
 TS_USER_07User-defined field.varchar40 
 TS_USER_08User-defined field.varchar40 
 TS_USER_09User-defined field.varchar40 
 TS_USER_10User-defined field.varchar40 
 TS_USER_11User-defined field.varchar40 
 TS_USER_12User-defined field.varchar40 
 TS_USER_HR_01 int4 
 TS_USER_HR_02 int4 
 TS_USER_HR_03 int4 
 TS_USER_HR_04 int4 
 TS_USER_HR_05 int4 
 TS_USER_HR_06 int4 
 TS_ESTIMATE_DEVTIME int4 
 TS_TEST_VER_STAMPThe version number of this record.int4 
 TS_EXEC_STATUS varchar70 
 TS_TEMPLATE varchar1 
 TS_STEP_PARAM int4 
 TS_VTSThe version time stamp.varchar20 
 TS_VC_CUR_VER varchar50 
 TS_USER_13User-defined field.varchar40 
 TS_USER_14User-defined field.varchar40 
 TS_USER_15User-defined field.varchar40 
 TS_USER_16User-defined field.varchar40 
 TS_USER_17User-defined field.varchar40 
 TS_USER_18User-defined field.varchar40 
 TS_USER_19User-defined field.varchar40 
 TS_USER_20User-defined field.varchar40 
 TS_USER_21User-defined field.varchar40 
 TS_USER_22User-defined field.varchar40 
 TS_USER_23User-defined field.varchar40 
 TS_USER_24User-defined field.varchar40 
 TS_TEXT_SYNCFor internal use. Do not change data.varchar1 
 TS_DEV_COMMENTSComments.Commentsvarchar16 
 TS_VC_DATEIn a VC_* table, the checkin date. In a HIST_* or primary entity table, the checkin date.datetime4 
 TS_VC_TIMEIn a VC_* table, the checkin time. In a HIST_* or primary entity table, the checkin time.varchar10 
 TS_VC_COMMENTSComments.varchar16 
 TS_VC_CHECKIN_USER_NAMEThe user name of the user who checked in this version.varchar255 
 TS_VC_CHECKIN_DATEThe date this version was checked in according to the server clock.datetime4 
 TS_VC_CHECKIN_TIMEThe time this version was checked in according to the server clock.varchar10 
 TS_VC_CHECKIN_COMMENTSComments.The user's comments when checking in the item.varchar16 
 TS_VC_STATUSThe version status: Checked in, checked out, or read only.varchar20 
 TS_VC_START_AUDIT_ACTION_ID int4 
 TS_VC_END_AUDIT_ACTION_ID int4 
 TS_VC_VERSION_NUMBERThe version ID of the entity.int4 
 TS_BPTA_CHANGE_DETECTED int4 
 TS_BASE_TEST_ID int4 

See Also

Related Objects

td Schema
Shadow Tables