HP ALM Database Reference
td.COMPONENT Table

Description

Business Process Components.

Remarks

Parameters for components are in the FRAMEWORK_PARAM Table.

Runtime data for parameters are in TESTCYCL.TC_DATA_OBJ.

When a component is contained in a test, the link between the test and component is in the BPTEST_TO_COMPONENTS Table.

The steps in the component are in the COMPONENT_STEP Table.

The logical organization of components in is the COMPONENT_FOLDER Table.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key CO_IDThe record ID.int4  
 CO_FOLDER_ID

The COMPONENT_FOLDER.FC_ID of the folder containing this component.

For QuickTest Professional Application Areas, CO_FOLDER_ID is 2. Application areas are not displayed in the Business Process Testing Module.

int4  
 CO_NAMEThe component name.varchar255 
 CO_VERSIONFor future use.varchar255 
 CO_PHYSICAL_PATHFor future use.varchar255 
 CO_RESPONSIBLEThe user to whom the component is assigned.varchar60 
 CO_CREATED_BYThe user who created the component.varchar60 
 CO_STATUS

The values are from the Component Status list. Typical values are: Error, Ready, Failed, Maintenance, Under Development, and Not Implemented.

varchar70 
 CO_CREATION_DATEThe date the component was created.datetime4 
 CO_DESCThe HTML formatted string that appears in the Description box in the component details.varchar16 
 CO_DEV_COMMENTSComments.varchar16 
 CO_STEPS_DATAFor future use.varchar16 
 CO_VER_STAMPIncrements when the record is updated.int4 
 CO_IS_ITERATABLEFor backward compatibility.varchar1 
 CO_DEFAULT_PICTURE_IDFor future use.int4 
 CO_IS_OBSOLETEIf a user deletes the component but it is in use in a test, this field is set to Y and the component is not physically deleted. If the component is restored, the field is set to N.varchar1 
 CO_SRC_IDFor future use.int4  
 CO_DELETION_DATEDatabase timestamp when the record is marked obsolete.datetime4 
 CO_DELETED_FROM_PATHThe path of the component before it was marked obsolete.varchar255 
 CO_DATAFor future use.varchar16 
 CO_SCRIPT_TYPEThe test type. For example: QuickTest, WinRunner, manual, and so on.varchar60 
 CO_HAS_PICTUREA value of Y indicates that the component has a snapshot.varchar1 
 CO_TEXT_SYNCFor internal use.varchar1 
 CO_APP_AREA_IDThe QuickTest Professional Application Area ID. Meaningful only when CO_FOLDER_ID points to a Application Area folder.int4 
 CO_VTSThe version time stamp.varchar20 
 CO_USER_01User-defined field.varchar40 
 CO_USER_02User-defined field.varchar40 
 CO_USER_03User-defined field.varchar40 
 CO_USER_04User-defined field.varchar40 
 CO_USER_05User-defined field.varchar40 
 CO_USER_06User-defined field.varchar40 
 CO_USER_07User-defined field.varchar40 
 CO_USER_08User-defined field.varchar40 
 CO_USER_09User-defined field.varchar40 
 CO_USER_10User-defined field.varchar40 
 CO_USER_11User-defined field.varchar40 
 CO_USER_12User-defined field.varchar40 
 CO_USER_13User-defined field.varchar40 
 CO_USER_14User-defined field.varchar40 
 CO_USER_15User-defined field.varchar40 
 CO_USER_16User-defined field.varchar40 
 CO_USER_17User-defined field.varchar40 
 CO_USER_18User-defined field.varchar40 
 CO_USER_19User-defined field.varchar40 
 CO_USER_20User-defined field.varchar40 
 CO_USER_21User-defined field.varchar40 
 CO_USER_22User-defined field.varchar40 
 CO_USER_23User-defined field.varchar40 
 CO_USER_24User-defined field.varchar40 
 CO_BPTA_FLOW_TEST_ID

A Flow is an abstract entity with no direct representation in the project database. It consists of both a Component and a Test of Test.Type BUSINESS-PROCESS. This field links a Component to a Test, thereby defining the Flow.

The field contains the TEST.TS_TEST_ID of the test with which the component forms a Flow.

int4 
 CO_BPTA_COMPONENT_TYPENULL=not change detectable
 1=SAP
 2=ORACLE
 1000=APPLICATION AREA
int4 
 CO_BPTA_CHANGE_DETECTED

1 - No change detected

2 - Change status is unknown

3 - Change detected

int4 
 CO_BPTA_CHANGE_TIMESTAMPThe time the last change was detected.varchar30 
 CO_BPTA_LAST_UPDATE_TIMESTAMPThe time of the last update.varchar30 
 CO_BPTA_SOR_IDThe ID of the Shared Object Repository related to this application area.int4 
 CO_BPTA_LOCATION_ID_IN_APP

The ID of the screen which is the subject of this component.

Used by Quick Test Professional.

varchar255 
 CO_VC_VERSION_NUMBERThe version ID of the entity.int4 
 CO_VC_STATUSThe version status: Checked in, checked out, or read only.varchar20 
 CO_VC_CHECKIN_USER_NAMEThe user name of the user who checked in this version.varchar60 
 CO_VC_CHECKIN_DATEThe date this version was checked in according to the server clock.datetime4 
 CO_VC_CHECKIN_TIMEThe time this version was checked in according to the server clock.varchar10 
 CO_VC_CHECKIN_COMMENTSComments.The user's comments when checking in the item.varchar16 
 CO_VC_CHECKOUT_USER_NAMEThe user who checked out the item under version control.varchar60 
 CO_VC_CHECKOUT_DATEThe date the version was checked out according to the server clock.datetime4 
 CO_VC_CHECKOUT_TIMEThe time this version was checked out according to the server clock.varchar10 
 CO_VC_CHECKOUT_COMMENTSComments.The user's comments when checking out the item.varchar16 
 CO_SUBTYPE_ID varchar50 
 CO_HAS_MANUAL_SCRIPT varchar1 
 CO_HAS_AUTO_SCRIPT varchar1 

See Also