HP ALM Database Reference
td.HIST_RESOURCES Table

Description

History of checked in versions of 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 RSC_VC_VERSION_NUMBERThe version ID of the entity.int4  
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_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_USER_NAMEThe user who checked out the item under version control.varchar60 
 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