Test Case Execution Record

Test Case Execution Record is an element in the IBM Engineering Lifecycle Management data dictionary that you can use for mapping test artifacts.

UI Element UI Field REST API Resource REST API Property Path XDC Resource XDC Data Mapping Table XDC Column Name Data Warehouse Schema Data Warehouse Table Data Warehouse Column FM Model Path FM Model Query Subject FM Model Query Item Description Sample Input Sample Output
Test Case Execution Record N/A executionworkitem N/A N/A N/A N/A N/A EXECUTION_WORKITEM N/A N/A Execution Work Item N/A Unless otherwise specified in this dictionary, "Test Case Execution Record" UI elements are expressed by the REST API Resource URL as "executionworkitem"; are stored in the data warehouse "EXECUTION_WORKITEM" table; and can be added to report definitions using the "Execution Work Item" Query Subject and related Items. N/A N/A
Test Case Execution Record

Version Updates
Owner executionworkitem /content/qm:executionworkitem/alm:owner ExecutionWorkItem RQMExecutionWorkItem owner N/A N/A N/A Operational Data Store/Execution Work Item Area/ N/A N/A The contributor's registered id that owns the test case execution record. N/A N/A
Test Case Execution Record Test Case executionworkitem /content/qm:executionworkitem/qm:testcase/@qm:href N/A RQMExecutionWorkItem testcase_uuid ODS EXECUTION_WORKITEM TESTCASE_ID N/A Execution Work Item Test Case ID The MD5 encrypted value of URI of the test case of test case execution record N/A N/A
Test Case Execution Record Name executionworkitem /content/qm:executionworkitem/dc:title N/A RQMExecutionWorkItem title ODS EXECUTION_WORKITEM NAME N/A Execution Work Item Name The name of test case execution record N/A N/A
Test Case Execution Record N/A executionworkitem /id N/A RQMExecutionWorkItem itemId ODS EXECUTION_WORKITEM EXTERNAL_KEY2 N/A Execution Work Item External Key2 The uuid of test case execution record N/A N/A
Test Case Execution Record EWI Frequency executionworkitem /content/qm:executionworkitem/executionworkitem:frequency N/A RQMExecutionWorkItem frequency ODS EXECUTION_WORKITEM FREQUENCY N/A Execution Work Item Frequency The number of times the test is scheduled to run N/A N/A
Test Case Execution Record Test Plan executionworkitem /content/qm:executionworkitem/qm:testplan/@qm:href N/A RQMExecutionWorkItem testplan_uuid ODS EXECUTION_WORKITEM TESTPLAN_ID N/A Execution Work Item Test Plan ID The MD5 encrypted value of URI of the test plan of test case execution record N/A N/A
Test Case Execution Record N/A executionworkitem /content/qm:executionworkitem/alm:state N/A RQMExecutionWorkItem executionworkitem_state ODS EXECUTION_WORKITEM EXECUTION_WORKITEM_STATE N/A Execution Work Item Execution Work Item State The actual result id of test case execution record but it only get the last word in the id and capitalize the first letter when populate it to DW DB N/A XDC returned value is com.ibm.rqm.execution.common.state.blocked and the value in DB is Blocked
Test Case Execution Record The latest result of Previous Result Details executionworkitem /content/qm:executionworkitem/qm:currentexecutionresult/@qm:href N/A RQMExecutionWorkItem currentexecutionresult ODS EXECUTION_WORKITEM CURRENT_RESULT_ID N/A Execution Work Item Current Result ID The MD5 encrypted value of URI of the current execution result of test case execution record N/A N/A
Test Case Execution Record N/A executionworkitem /content/qm:executionworkitem/executionworkitem:regression N/A RQMExecutionWorkItem regression ODS EXECUTION_WORKITEM REGRESSION N/A Execution Work Item Regression Indicator that this is a regression test N/A N/A
Test Case Execution Record Weight executionworkitem /content/qm:executionworkitem/executionworkitem:weight N/A RQMExecutionWorkItem weight ODS EXECUTION_WORKITEM WEIGHT N/A Execution Work Item Weight An integer measure of the estimated effort to execute the test case execution record N/A N/A
Test Case Execution Record Priority executionworkitem /content/qm:executionworkitem/executionworkitem:priority N/A RQMExecutionWorkItem priority ODS EXECUTION_WORKITEM PRIORITY N/A Execution Work Item Priority The priority of the test N/A Acceptable values are: "literal.priority.101", "literal.priority.110", "literal.priority.120" and "literal.priority.130" for unassigned, low, medium and high priority respectively
Test Case Execution Record

Version Updates
Last Modified executionworkitem /updated N/A RQMExecutionWorkItem updated ODS EXECUTION_WORKITEM LAST_UPDATED N/A Execution Work Item Last Updated The last updated date and time of test case execution record in UTC format N/A N/A
Test Case Execution Record Default Test Script executionworkitem /content/qm:executionworkitem/qm:testscript/@qm:href N/A RQMExecutionWorkItem testscript_uuid ODS EXECUTION_WORKITEM TESTSCRIPT_ID N/A Execution Work Item Test Script ID The MD5 encrypted value of URI of the manual test script of test case execution record N/A N/A
Test Case Execution Record Test Execution Record URL executionworkitem /content/qm:executionworkitem/dc:identifier N/A RQMExecutionWorkItem url ODS EXECUTION_WORKITEM URL N/A Execution Work Item URL The URL of test case execution record N/A N/A
Test Case Execution Record Test Execution Record URL executionworkitem /content/qm:executionworkitem/dc:identifier N/A RQMExecutionWorkItem uuid ODS EXECUTION_WORKITEM EXTERNAL_ID N/A Execution Work Item External ID The MD5 encrypted value of the URL of test case execution record N/A N/A
Test Case Execution Record Test Environment executionworkitem /content/qm:executionworkitem/qm:configuration/@qm:href N/A RQMExecutionWorkItem config_uuid ODS EXECUTION_WORKITEM CONFIGURATION_ID N/A Execution Work Item Configuration ID The MD5 encrypted value of URI of the test environment of test case execution record N/A N/A
Test Case Execution Record

Version Updates
Iteration executionworkitem /content/qm:executionworkitem/qm:testphase/@qm:href N/A RQMExecutionWorkItem testphase_uuid N/A N/A N/A N/A N/A N/A The MD5 encrypted value of URI of the iteration of test case execution record N/A N/A
Test Case Execution Record Default Test Script executionworkitem /content/qm:executionworkitem/qm:remotescript/@qm:href N/A RQMExecutionWorkItem remotescript_uuid ODS EXECUTION_WORKITEM TESTSCRIPT_ID N/A Execution Work Item Test Script ID The MD5 encrypted value of URI of the remote test script of test case execution record N/A N/A
Test Case Execution Record N/A executionworkitem /content/qm:executionworkitem/qm:creationDate N/A RQMExecutionWorkItem creationDate ODS EXECUTION_WORKITEM CREATION_DATE N/A Execution Work Item Creation Date The date and time that created the test case execution record in UTC format N/A N/A
Test Case Execution Record Is Deleted executionworkitem /qm:archived N/A RQMExecutionWorkItem isSoftDeleted ODS EXECUTION_WORKITEM ISSOFTDELETED N/A Execution Work Item Is Deleted The test case execution record is archived or not N/A N/A
Test Case Execution Record ID executionworkitem /content/qm:executionworkitem/qm:webId N/A RQMExecutionWorkItem webId ODS EXECUTION_WORKITEM REFERENCE_ID N/A Execution Work Item Reference ID Read-only integer ID of test case execution record as seen in the web UI N/A N/A
Test Case Execution Record Project Area executionworkitem /content/qm:executionworkitem/qm:projectArea/@vega:id N/A RQMExecutionWorkItem projectId ODS EXECUTION_WORKITEM PROJECT_ID N/A Execution Work Item Project ID The uuid of project area of the test case execution record N/A N/A
Test Case Execution Record Owner executionworkitem /content/qm:executionworkitem/alm:owner/@rdf:resource N/A RQMExecutionWorkItem owner_uuid ODS EXECUTION_WORKITEM OWNER_ID N/A Execution Work Item Owner ID The MD5 encrypted value of URI of the contributor that owns the test case execution record N/A N/A
Test Case Execution Record

Version Updates
Estimate executionworkitem /content/qm:executionworkitem/qm:estimate N/A RQMExecutionWorkItem estimate ODS EXECUTION_WORKITEM ESTIMATE N/A Execution Work Item Estimate The estimate weight of the test case execution record N/A N/A
Test Case Execution Record

Version Updates
Time Spent executionworkitem /content/qm:executionworkitem/qm:timeSpent N/A RQMExecutionWorkItem timeSpent ODS EXECUTION_WORKITEM TIMESPENT N/A Execution Work Item Time Spent The time spent of the test case execution record N/A N/A
Test Case Execution Record

Version Updates
Priority executionworkitem /content/qm:executionworkitem/executionworkitem:priority/@rdf:resource N/A RQMExecutionWorkItem priority_uuid ODS EXECUTION_WORKITEM TEST_PRIORITY_ID N/A Execution Work Item Test Priority External ID The MD5 encrypted value of URI of the priority of test case execution record N/A N/A
Test Case Execution Record Test Environment executionworkitem /content/qm:executionworkitem/qm:configuration/@qm:href N/A RQMEWI_Relationships configuration_uuid ODS CONFIG_EXECUTIONWORKITM_LOOKUP CONFIGURATION_ID N/A Execution Work Item Related Configurations External ID The MD5 encrypted value of URI of the test environment of test case execution record N/A N/A
Test Case Execution Record Blocking Defects executionworkitem /content/qm:executionworkitem/qm:blockingdefects/@qm:href N/A RQMEWI_Relationships blockingDefect_uuid ODS EXECWORKITEM_REQUEST_LOOKUP REQUEST_ID N/A Execution Work Item Related Requests External ID The MD5 encrypted value of URI of the blocking defects of test case execution record N/A N/A
Test Case Execution Record Test Case Execution Record executionworkitem /content/qm:executionworkitem/dc:identifier N/A RQMEWI_Relationships uuid ODS CONFIG_EXECUTIONWORKITM_LOOKUP EXECWORKITEM_ID N/A Execution Work Item External ID The MD5 encrypted value of the URL of test case execution record N/A N/A
Test Case Execution Record Test Case Execution Record executionworkitem /content/qm:executionworkitem/dc:identifier N/A RQMEWI_Relationships uuid ODS EXECWORKITEM_REQUEST_LOOKUP EXECWORKITEM_ID N/A Execution Work Item External ID The MD5 encrypted value of the URL of test case execution record N/A N/A
Test Case Execution Record Test Case Execution Record executionworkitem /content/qm:executionworkitem/dc:identifier N/A RQMEWI_Relationships uuid ODS EXECWORKITEM_ITERATION_LOOKUP EXECWORKITEM_ID N/A Execution Work Item External ID The MD5 encrypted value of the URL of test case execution record N/A N/A
Test Case Execution Record Test Case Execution Record executionworkitem /content/qm:executionworkitem/dc:identifier N/A RQMEWI_Relationships uuid ODS EXECWORKITEM_CATEGORY_LOOKUP EXECWORKITEM_ID N/A Execution Work Item External ID The MD5 encrypted value of the URL of test case execution record N/A N/A
Test Case Execution Record Test Case Execution Record executionworkitem /content/qm:executionworkitem/dc:identifier N/A RQMEWI_Relationships uuid CALM EXECWORKITEM_STRING_EXT EXECWORKITEM_ID N/A Execution Work Item External ID The MD5 encrypted value of the URL of test case execution record N/A N/A
Test Case Execution Record Test Case Execution Record executionworkitem /content/qm:executionworkitem/dc:identifier N/A RQMEWI_Relationships uuid CALM EXECWORKITEM_STRING_M_EXT EXECWORKITEM_ID N/A Execution Work Item External ID The MD5 encrypted value of the URL of test case execution record N/A N/A
Test Case Execution Record Test Case Execution Record executionworkitem /content/qm:executionworkitem/dc:identifier N/A RQMEWI_Relationships uuid CALM EXECWORKITEM_INT_EXT EXECWORKITEM_ID N/A Execution Work Item External ID The MD5 encrypted value of the URL of test case execution record N/A N/A
Test Case Execution Record Test Case Execution Record executionworkitem /content/qm:executionworkitem/dc:identifier N/A RQMEWI_Relationships uuid CALM EXECWORKITEM_TIMESTAMP_EXT EXECWORKITEM_ID N/A Execution Work Item External ID The MD5 encrypted value of the URL of test case execution record N/A N/A
Test Case Execution Record Iteration executionworkitem /content/qm:executionworkitem/qm:testphase/@qm:href N/A RQMEWI_Relationships testphase_uuid ODS EXECWORKITEM_ITERATION_LOOKUP ITERATION_ID N/A Execution Work Item Related Iterations External ID The MD5 encrypted value of URI of the iteration of test case execution record N/A N/A
Test Case Execution Record Blocking Defect URL executionworkitem /content/qm:executionworkitem/qm:blockingdefects/@qm:href N/A RQMEWI_Relationships blockingDefect_url ODS EXECWORKITEM_REQUEST_LOOKUP REQUEST_ID N/A Execution Work Item Related Requests URL The URL of the blocking defects of test case execution record. It is used to look up for Clear Quest Requests. N/A N/A
Test Case Execution Record

Version Updates
Category Value executionworkitem /content/qm:executionworkitem/qm:blockingdefects/@qm:href N/A RQMEWI_Relationships valueUUID ODS EXECWORKITEM_CATEGORY_LOOKUP TEST_CATEGORY_ID N/A Execution Work Item Related Test Categories External Key2 The uuid of category value of test case execution record N/A N/A
Test Case Execution Record

Version Updates
N/A executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMEWI_Relationships identifier CALM EXECWORKITEM_STRING_EXT IDENTIFIER N/A Execution Work Item String Extension Identifying name The identifier of small text custom attribute of test case execution record N/A N/A
Test Case Execution Record

Version Updates
N/A executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMEWI_Relationships identifier CALM EXECWORKITEM_STRING_M_EXT IDENTIFIER N/A Execution Work Item Medium String Extension Identifying name The identifier of medium text custom attribute of test case execution record N/A N/A
Test Case Execution Record

Version Updates
N/A executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMEWI_Relationships identifier CALM EXECWORKITEM_INT_EXT IDENTIFIER N/A Execution Work Item Integer Extension Identifying name The identifier of integer custom attribute of test case execution record N/A N/A
Test Case Execution Record

Version Updates
N/A executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMEWI_Relationships identifier CALM EXECWORKITEM_TIMESTAMP_EXT IDENTIFIER N/A Execution Work Item Timestamp Extension Identifying name The identifier of date/time custom attribute of test case execution record N/A N/A
Test Case Execution Record Attributes

Version Updates
Type executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/@qm:type N/A RQMEWI_Relationships type N/A N/A N/A N/A N/A N/A The type of custom attribute of test case execution record, there are 4 types, SMALL_STRING, MEDIUM_STRING, INTEGER, TIMESTAMP N/A SMALL_STRING: the type of custom attribute is Text (Small). MEDIUM_STRING: the type of custom attribute is Text (Medium). INTEGER: the type of custom attribute is Integer. TIMESTAMP: the type of custom attribute is Date/Time.
Test Case Execution Record Attributes

Version Updates
Custom Attribute Name executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:name N/A RQMEWI_Relationships name CALM EXECWORKITEM_STRING_EXT NAME N/A Execution Work Item String Extension Name The name of small text custom attribute of test case execution record N/A N/A
Test Case Execution Record Attributes

Version Updates
Custom Attribute Name executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:name N/A RQMEWI_Relationships N/A CALM EXECWORKITEM_STRING_M_EXT NAME N/A Execution Work Item Medium String Extension Name The name of medium text custom attribute of test case execution record N/A N/A
Test Case Execution Record Attributes

Version Updates
Custom Attribute Name executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:name N/A RQMEWI_Relationships N/A CALM EXECWORKITEM_INT_EXT NAME N/A Execution Work Item Integer Extension Name The name of integer custom attribute of test case execution record N/A N/A
Test Case Execution Record Attributes

Version Updates
Custom Attribute Name executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:name N/A RQMEWI_Relationships N/A CALM EXECWORKITEM_TIMESTAMP_EXT NAME N/A Execution Work Item Timestamp Extension Name The name of date/time custom attribute of test case execution record N/A N/A
Test Case Execution Record Attributes

Version Updates
Custom Attribute Value executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:value N/A RQMEWI_Relationships value CALM EXECWORKITEM_STRING_EXT VAR N/A Execution Work Item String Extension Value The value of small text custom attribute of test case execution record N/A N/A
Test Case Execution Record Attributes

Version Updates
Custom Attribute Value executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:value N/A RQMEWI_Relationships value CALM EXECWORKITEM_STRING_M_EXT VAR N/A Execution Work Item Medium String Extension Value The value of medium text custom attribute of test case execution record N/A N/A
Test Case Execution Record Attributes

Version Updates
Custom Attribute Value executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:value N/A RQMEWI_Relationships value CALM EXECWORKITEM_INT_EXT VAR N/A Execution Work Item Integer Extension Value The string type value of integer custom attribute of test case execution record N/A N/A
Test Case Execution Record Attributes

Version Updates
Custom Attribute Value executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:value N/A RQMEWI_Relationships timeValue CALM EXECWORKITEM_TIMESTAMP_EXT VAR N/A Execution Work Item Timestamp Extension Value The string type value of date/time custom attribute of test case execution record N/A N/A
Test Case Execution Record

Version Updates
Is Deleted executionworkitem /qm:archived N/A RQMEWI_Relationships isSoftDeleted CALM EXECWORKITEM_STRING_EXT ISSOFTDELETED N/A Execution Work Item String Extension Is Deleted The test case execution record is archived or not N/A 0: not deleted, 1: deleted
Test Case Execution Record

Version Updates
Is Deleted executionworkitem /qm:archived N/A RQMEWI_Relationships isSoftDeleted CALM EXECWORKITEM_STRING_M_EXT ISSOFTDELETED N/A Execution Work Item Medium String Extension Is Deleted The test case execution record is archived or not N/A 0: not deleted, 1: deleted
Test Case Execution Record

Version Updates
Is Deleted executionworkitem /qm:archived N/A RQMEWI_Relationships isSoftDeleted CALM EXECWORKITEM_INT_EXT ISSOFTDELETED N/A Execution Work Item Integer Extension Is Deleted The test case execution record is archived or not N/A 0: not deleted, 1: deleted
Test Case Execution Record

Version Updates
Is Deleted executionworkitem /qm:archived N/A RQMEWI_Relationships isSoftDeleted CALM EXECWORKITEM_TIMESTAMP_EXT ISSOFTDELETED N/A Execution Work Item Timestamp Extension Is Deleted The test case execution record is archived or not N/A 0: not deleted, 1: deleted

Feedback