HP ALM Database Reference
td.RESOURCES Table

Description

A file or folder stored in the ALM repository that is represented by a resource.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key RSC_IDThe record ID.int4  
 RSC_NAMEThe name of the resource.varchar255  
 RSC_FILE_NAMEThe file or folder name without the path.varchar255 
 RSC_LOCATION_TYPEFor future use. The value is always "Local".varchar20  
 RSC_TYPE

One of the values of the Resource Type project list. The type determines the icon and viewer used for the resource in the Resources Tree and resource viewer tab.

The generic type is Test Resource.

varchar255  
 RSC_DESCRIPTIONA free text description of this item.varchar16 
 RSC_PARENT_IDThe RESOURCE_FOLDERS.RFO_ID of the folder containing this item.int4  
 RSC_VER_STAMPThe version number of this record.int4  
 RSC_CREATED_BYThe user who created the resource.varchar60  
 RSC_CREATION_DATEThe date on which the resource was created.datetime4 
 RSC_DEV_COMMENTSComments added for the resource.varchar16 
 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_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