HP ALM Database Reference
td.VC_RESOURCES 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 RSC_VC_CHECKOUT_USER_NAMEThe user who checked out the item under version control.varchar60  
Primary Key RSC_IDThe record ID.int4  
 RSC_NAMEThe name of the item.varchar255  
 RSC_FILE_NAMEThe name of the item.varchar255 
 RSC_LOCATION_TYPE varchar20  
 RSC_TYPE varchar255  
 RSC_DESCRIPTIONA free text description of this item.varchar16 
 RSC_PARENT_IDThe record ID of the folder that contains this item.int4  
 RSC_VER_STAMPThe version number of this record.int4  
 RSC_CREATED_BYThe user name of the user who created this item.varchar60  
 RSC_CREATION_DATEThe server date when this item was created.datetime4 
 RSC_DEV_COMMENTSComments.Commentsvarchar16 
 RSC_USER_01User-defined field.varchar40 
 RSC_VC_VERSION_NUMBERThe version ID of the entity.int4 
 RSC_VC_STATUSThe version status: Checked in, checked out, or read only.varchar20 
 RSC_VC_CHECKIN_USER_NAMEThe user name of the user who checked in this version.varchar60 
 RSC_VC_CHECKIN_DATEThe date this version was checked in according to the server clock.datetime4 
 RSC_VC_CHECKIN_TIMEThe time this version was checked in according to the server clock.varchar10 
 RSC_VC_CHECKIN_COMMENTSComments.The user's comments when checking in the item.varchar16 
 RSC_VC_CHECKOUT_DATEThe date the version was checked out according to the server clock.datetime4 
 RSC_VC_CHECKOUT_TIMEThe time this version was checked out according to the server clock.varchar10 
 RSC_VC_CHECKOUT_COMMENTSComments.The user's comments when checking out the item.varchar16 
 RSC_VTSThe version time stamp.varchar20 
 RSC_BPTA_FLOW_TEST_ID int4 
 RSC_BPTA_TYPE int4 
 RSC_BPTA_CHANGE_DETECTED int4 
 RSC_BPTA_CHANGE_TIMESTAMP varchar30 
 RSC_BPTA_LAST_UPDATE_TIMESTAMP varchar30 
 RSC_BPTA_SOR_ID int4 
 RSC_BPTA_LOCATION_ID_IN_APP varchar255 

See Also

Related Objects

td Schema
Shadow Tables