Test artifacts

The Rational solution for Collaborative Lifecycle Management data dictionary for test artifacts shows how you can begin mapping elements to artifacts in the quality management application from the FM model and the REST API. The data dictionary topics in this section detail the relationship between data formats and the related queries that must be incorporated into a report, so that the desired change and test data appears in the report output. When authoring reports with data mappings, you can this data reference to determine which model queries to use for test artifacts.

Test Plan
Test Case
Requirement
Test Script
Test Suite
Test Schedules
Test Suite Result
Test Case Execution Record
Test Case Result
Test Case Result's Result Details
Defect / Work Item
Lab Resource
Lab Resource Group
Reservation
Test Environment
Automation Job
Automation Job Result
Build Record
Contributor (Deprecated in RQM301)
Quality Objective
Non Manual Test Script
Test Suite Execution Record
Project (Deprecated in RQM301)
Key Word
Request
Artifact Categories
Artifact Categories Type
Test Artifacts Workflows
Test Artifacts Workflows State Group
Test Artifacts Workflows State Group Category

Test Plan

Sample Input 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 Output Changes in 4.0
N/A Test Plan N/A testplan N/A N/A N/A N/A N/A TESTPLAN N/A N/A Test Plan N/A Unless otherwise specified in this dictionary, "Test Plan" UI elements are expressed by the REST API Resource URL as "testplan"; are stored in the data warehouse "TESTPLAN" table; and can be added to report definitions using the "Test Plan" Query Subject and related Items. N/A N/A
N/A Test Plan Modified testplan /content/qm:testplan/alm:updated TestPlan RQMTestPlan updated ODS TESTPLAN LAST_UPDATED Operational Data Store/Test Plan Area/ Test Plan Last Updated The last updated date and time of test plan in UTC format 2012-05-23T06:59:18.570Z N/A
N/A Test Plan Name testplan /content/qm:testplan/dc:title N/A RQMTestPlan title ODS TESTPLAN NAME N/A Test Plan Name The name of test plan N/A N/A
N/A Test Plan Owner testplan /content/qm:testplan/alm:owner N/A RQMTestPlan owner N/A N/A N/A N/A N/A N/A The contributor's registered id that owns the test plan N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Test Plan N/A testplan /id N/A RQMTestPlan itemId ODS TESTPLAN EXTERNAL_KEY2 N/A Test Plan External Key2 The uuid of test plan N/A N/A
N/A Test Plan State testplan /content/qm:testplan/alm:state N/A RQMTestPlan testplan_state N/A N/A N/A N/A Test Plan Test Plan State Reference ID The ID of current state of test plan com.ibm.rqm.planning.common.new Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to Test Plan State Reference ID in FM.
N/A Test Plan Test plan url testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan url ODS TESTPLAN URL N/A Test Plan URL The URL of test plan N/A N/A
N/A Test Plan Test plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan uuid ODS TESTPLAN EXTERNAL_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan N/A testplan /content/qm:testplan/qm:alias N/A RQMTestPlan alias N/A N/A N/A N/A N/A N/A Read-only element containing an alternative identifier for test plan N/A N/A
N/A Test Plan N/A testplan /content/qm:testplan/qm:alias/@qm:type N/A RQMTestPlan alias_type N/A N/A N/A N/A N/A N/A The type of the alternative identifier for test plan uuid N/A
N/A Test Plan N/A testplan /content/qm:testplan/qm:creationDate N/A RQMTestPlan creationDate ODS TESTPLAN CREATION_DATE N/A Test Plan Creation Date The creation date and time of test plan in UTC format N/A N/A
N/A Test Plan ID testplan /content/qm:testplan/qm:webId N/A RQMTestPlan webId ODS TESTPLAN REFERENCE_ID N/A Test Plan Reference ID Read-only integer ID of test plan as seen in the web UI N/A N/A
N/A Test Plan Is Deleted testplan /qm:archived N/A RQMTestPlan isSoftDeleted ODS TESTPLAN ISSOFTDELETED N/A Test Plan Is Deleted The test plan is archived or not 0: not deleted, 1: deleted N/A
N/A Test Plan Project Area testplan /content/qm:testplan/qm:projectArea/@vega:id N/A RQMTestPlan projectId ODS TESTPLAN PROJECT_ID N/A Test Plan Project ID The uuid of project area of the test plan N/A N/A
N/A Test Plan Owner testplan /content/qm:testplan/alm:owner/@rdf:resource N/A RQMTestPlan owner_uuid ODS TESTPLAN OWNER_ID N/A Test Plan Owner ID The MD5 encrypted value of URI of the contributor that owns the test plan N/A N/A
N/A Test Plan State testplan /content/qm:testplan/alm:state/@rdf:resource N/A RQMTestPlan state_uuid ODS TESTPLAN TESTPLAN_STATE_ID N/A Test Plan Test Plan State External ID The MD5 encrypted value of URI of current state of the test plan N/A Newly added in RQM 4.0. It is used to look up the value of TESTPLAN_STATE_ID column in TESTPLAN table, the value of the element in XDC is equal to the Test Plan State External ID field of "Test Plan" Query Subject in FM.
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_CustomAttribute testplan_uuid CALM TESTPLAN_STRING_EXT TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_CustomAttribute testplan_uuid CALM TESTPLAN_STRING_M_EXT TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_CustomAttribute testplan_uuid CALM TESTPLAN_INT_EXT TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_CustomAttribute testplan_uuid CALM TESTPLAN_TIMESTAMP_EXT TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan N/A testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestPlan_CustomAttribute identifier CALM TESTPLAN_STRING_EXT IDENTIFIER N/A Test Plan String Extension Identifying name The identifier of small text custom attribute of test plan N/A N/A
N/A Test Plan N/A testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestPlan_CustomAttribute identifier CALM TESTPLAN_STRING_M_EXT IDENTIFIER N/A Test Plan Medium String Extension Identifying name The identifier of medium text custom attribute of test plan N/A N/A
N/A Test Plan N/A testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestPlan_CustomAttribute identifier CALM TESTPLAN_INT_EXT IDENTIFIER N/A Test Plan Integer Extension Identifying name The identifier of integer custom attribute of test plan N/A N/A
N/A Test Plan N/A testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestPlan_CustomAttribute identifier CALM TESTPLAN_TIMESTAMP_EXT IDENTIFIER N/A Test Plan Timestamp Extension Identifying name The identifier of date/time custom attribute of test plan N/A N/A
N/A Test Plan Attributes Type testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/@qm:type N/A RQMTestPlan_CustomAttribute type N/A N/A N/A N/A N/A N/A The type of custom attribute of test plan, there are 4 types, SMALL_STRING, MEDIUM_STRING, INTEGER, TIMESTAMP 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. N/A
N/A Test Plan Attributes Attribute Name testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestPlan_CustomAttribute name CALM TESTPLAN_STRING_EXT NAME N/A Test Plan String Extension Name The name of small text custom attribute of test plan N/A N/A
N/A Test Plan Attributes Attribute Name testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestPlan_CustomAttribute name CALM TESTPLAN_STRING_M_EXT NAME N/A Test Plan Medium String Extension Name The name of medium text custom attribute of test plan N/A N/A
N/A Test Plan Attributes Attribute Name testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestPlan_CustomAttribute name CALM TESTPLAN_INT_EXT NAME N/A Test Plan Integer Extension Name The name of integer custom attribute of test plan N/A N/A
N/A Test Plan Attributes Attribute Name testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestPlan_CustomAttribute name CALM TESTPLAN_TIMESTAMP_EXT NAME N/A Test Plan Timestamp Extension Name The name of date/time custom attribute of test plan N/A N/A
N/A Test Plan Custom Attribute Value testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestPlan_CustomAttribute value CALM TESTPLAN_STRING_EXT VAR N/A Test Plan String Extension Value The value of small text custom attribute of test plan N/A N/A
N/A Test Plan Custom Attribute Value testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestPlan_CustomAttribute value CALM TESTPLAN_STRING_M_EXT VAR N/A Test Plan Medium String Extension Value The value of medium text custom attribute of test plan N/A N/A
N/A Test Plan Custom Attribute Value testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestPlan_CustomAttribute value CALM TESTPLAN_INT_EXT VAR N/A Test Plan Integer Extension Value The string type value of integer custom attribute of test plan N/A N/A
N/A Test Plan Custom Attribute Value testplan /content/qm:testplan/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestPlan_CustomAttribute timeValue CALM TESTPLAN_TIMESTAMP_EXT VAR N/A Test Plan Timestamp Extension Value The timestamp value of date/time custom attribute of test plan in UTC format N/A N/A
N/A Test Plan Is Deleted testplan /qm:archived N/A RQMTestPlan_CustomAttribute isSoftDeleted CALM TESTPLAN_STRING_EXT ISSOFTDELETED N/A Test Plan String Extension Is Deleted The test plan is archived or not 0: not deleted, 1: deleted N/A
N/A Test Plan Is Deleted testplan /qm:archived N/A RQMTestPlan_CustomAttribute isSoftDeleted CALM TESTPLAN_STRING_M_EXT ISSOFTDELETED N/A Test Plan Medium String Extension Is Deleted The test plan is archived or not 0: not deleted, 1: deleted N/A
N/A Test Plan Is Deleted testplan /qm:archived N/A RQMTestPlan_CustomAttribute isSoftDeleted CALM TESTPLAN_INT_EXT ISSOFTDELETED N/A Test Plan Integer Extension Is Deleted The test plan is archived or not 0: not deleted, 1: deleted N/A
N/A Test Plan Is Deleted testplan /qm:archived N/A RQMTestPlan_CustomAttribute isSoftDeleted CALM TESTPLAN_TIMESTAMP_EXT ISSOFTDELETED N/A Test Plan Timestamp Extension Is Deleted The test plan is archived or not 0: not deleted, 1: deleted N/A
N/A Test Plan N/A testplan /content/qm:testplan/qm:objectives/qm:objectiveStatus/qm:groupOrder N/A RQMTestPlan_ObjetiveStatus groupOrder CALM TESTPLAN_OBJECTIVESTATUS GROUP_ORDER N/A Test Plan Objectives Status Group Order The index of the objectiveStatus within the testplan N/A N/A
N/A Test Plan Quality Objective Actual Value testplan /content/qm:testplan/qm:objectives/qm:objectiveStatus/qm:actualValue N/A RQMTestPlan_ObjetiveStatus actualValue CALM TESTPLAN_OBJECTIVESTATUS ACTUAL_VALUE N/A Test Plan Objectives Status Value The value calculated for the objectiveStatus N/A N/A
N/A Test Plan Quality Objective Status testplan /content/qm:testplan/qm:objectives/qm:objectiveStatus/qm:state N/A RQMTestPlan_ObjetiveStatus state CALM TESTPLAN_OBJECTIVESTATUS STATE N/A Test Plan Objectives Status State The status code for the objective com.ibm.rqm.planning.objectives.not_started N/A
N/A Test Plan Quality Objective Comment testplan /content/qm:testplan/qm:objectives/qm:objectiveStatus/qm:comment N/A RQMTestPlan_ObjetiveStatus comment CALM TESTPLAN_OBJECTIVESTATUS COMMENT N/A Test Plan Objectives Status Comment The comment of the objective N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_ObjetiveStatus testplan_uuid CALM TESTPLAN_OBJECTIVESTATUS TESTPLAN_ID N/A Test Plan Objectives Status Test Plan ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Quality Objective testplan /content/qm:testplan/qm:objectives/qm:objectiveStatus/qm:objective/@qm:href N/A RQMTestPlan_ObjetiveStatus objective_uuid CALM TESTPLAN_OBJECTIVESTATUS OBJECTIVE_ID N/A Test Plan Objectives Status Objective ID The MD5 encrypted value of the URI of the objective of test plan N/A N/A
N/A Test Plan Is Deleted testplan /qm:archived N/A RQMTestPlan_ObjetiveStatus isSoftDeleted CALM TESTPLAN_OBJECTIVESTATUS ISSOFTDELETED N/A Test Plan Objectives Status Is Deleted The test plan is archived or not 0: not deleted, 1: deleted N/A
N/A Test Plan Categories value testplan /content/qm:testplan/qm:category/@qm:value N/A RQMTestPlan_Relationships category_value N/A N/A N/A N/A Test Plan Related Test Categories Category Term The name of the category of test plan N/A N/A
N/A Test Plan Categories name testplan /content/qm:testplan/qm:category/@qm:term N/A RQMTestPlan_Relationships category_term N/A N/A N/A N/A Test Plan Related Test Categories Category Value The value selected for the category of test plan N/A N/A
N/A Test Plan Related test suites testplan /content/qm:testplan/qm:testsuite/@qm:href N/A RQMTestPlan_Relationships testsuite_uuid ODS TESTSUITE_TESTPLAN_LOOKUP TESTSUITE_ID N/A Test Plan Related Test Suites External ID The MD5 encrypted value of the URL of the test suite of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_Relationships uuid ODS REQUIREMENT_TESTPLAN_LOOKUP TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_Relationships uuid ODS TESTSUITE_TESTPLAN_LOOKUP TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_Relationships uuid ODS TESTPLAN_CATEGORY_LOOKUP TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_Relationships uuid ODS TESTPLAN_TESTCASE_LOOKUP TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_Relationships uuid CALM TESTPLAN_OBJECTIVE_LOOKUP TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_Relationships uuid ODS REQUICOL_TESTPLAN_LOOKUP TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_Relationships uuid ODS TESTPLAN_TESTPLAN_HIERARCHY PARENT_TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_Relationships uuid ODS TESTPLAN_ITERATION_LOOKUP TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A N/A
N/A Test Plan Test Plan testplan /content/qm:testplan/dc:identifier N/A RQMTestPlan_Relationships uuid ODS REQUEST_TESTPLAN_LOOKUP TESTPLAN_ID N/A Test Plan External ID The MD5 encrypted value of the URL of test plan N/A Building the relationship of requests and test plans since RQM 4.0.
N/A Test Plan N/A testplan /content/qm:testplan/qm:category/@qm:valueUUID N/A RQMTestPlan_Relationships valueUUID ODS TESTPLAN_CATEGORY_LOOKUP TEST_CATEGORY_ID N/A Test Plan Related Test Categories External Key2 The uuid of category value of test plan N/A N/A
N/A Test Plan Related Test Cases testplan /content/qm:testplan/qm:testcase/@qm:href N/A RQMTestPlan_Relationships test case_uuid ODS TESTPLAN_TESTCASE_LOOKUP TESTCASE_ID N/A Test Plan Related Test Cases External ID The MD5 encrypted value of the URL of the test case of test plan N/A N/A
N/A Test Plan Related Objectives testplan /content/qm:testplan/qm:objectives/qm:objectiveStatus/qm:objective/@qm:href N/A RQMTestPlan_Relationships objective_uuid CALM TESTPLAN_OBJECTIVE_LOOKUP OBJECTIVE_ID N/A Test Plan Related Quality Objectives External ID The MD5 encrypted value of the URL of the quality objective of test plan N/A N/A
N/A Test Plan Related Requirement Collections testplan /content/qm:testplan/qm:requirementset/@qm:href N/A RQMTestPlan_Relationships reqcol_uuid ODS REQUICOL_TESTPLAN_LOOKUP REQUIREMENT_COLLECTION_ID N/A Test Plan Related Requirement Collections External ID The MD5 encrypted value of the URL of the requirement collection of test plan N/A N/A
N/A Test Plan Child Test plan testplan /content/qm:testplan/qm:childplan/@qm:href N/A RQMTestPlan_Relationships childplan_uuid ODS TESTPLAN_TESTPLAN_HIERARCHY CHILD_TESTPLAN_ID N/A Test Plan Related Test Plans External ID The MD5 encrypted value of the URL of the child test plan of test plan N/A N/A
N/A Test Plan Test Phase testplan /content/qm:testplan/qm:testphase/@vega:id N/A RQMTestPlan_Relationships testphase_id ODS TESTPLAN_ITERATION_LOOKUP ITERATION_ID N/A Test Plan Related Iterations External Key2 The uuid of iteration of test plan N/A N/A
N/A Test Plan Related Requirements testplan /content/qm:testplan/qm:requirement/@qm:externalReqId N/A RQMTestPlan_Relationships externalReqId ODS REQUIREMENT_TESTPLAN_LOOKUP REQUIREMENT_ID N/A Test Plan Related Requirements External Key2 The external id of Rational RequisitePro requirement of test plan {4C4DB6F2-2D6A-4FF0-8145-F7ABD4E3777E} N/A
N/A Test Plan Related Workitem testplan /content/qm:testplan/qm:workitem/@qm:href N/A RQMTestPlan_Relationships request_uuid ODS REQUEST_TESTPLAN_LOOKUP REQUEST_ID N/A Test Plan Related Requests External ID The MD5 encrypted value of the URL of the requests of test plan N/A Building the relationship of requests and test plans since RQM 4.0.
N/A Test Plan Related Workitem url testplan /content/qm:testplan/qm:workitem/@qm:href N/A RQMTestPlan_Relationships request_url ODS REQUEST_TESTPLAN_LOOKUP REQUEST_ID N/A Test Plan Related Requests URL The URL of the requests of test plan N/A Building the relationship of requests and test plans since RQM 4.0.
N/A Test Plan Related Requirements testplan /content/qm:testplan/qm:requirement/@qm:href N/A RQMTestPlan_Relationships requirement_uuid ODS REQUIREMENT_TESTPLAN_LOOKUP REQUIREMENT_ID N/A Test Plan Related Requirements EXTERNAL_ID The MD5 encrypted value of the URL of the requirement of test plan. N/A Newly added in RQM 4.0.
N/A Test Plan Related Requirement Collections OSLC linking type testplan /content/qm:testplan/qm:requirementset/@qm:rel N/A RQMTestPlan_Relationships reqcol_rel ODS REQUICOL_TESTPLAN_LOOKUP LINK_TYPE N/A Test Plan Related Requirement Collections Link Type The RQM named linking type of requirement collection and test plan. validates: The unified OSLC linking type is com.ibm.clm.validatesRequirementsSet Newly added in RQM 4.0. The value returned from XDC is RQM specified name and it is translated to unified OSLC linking type when running ETL to deliver it to DB.
N/A Test Plan Related Workitems OSLC linking type testplan /content/qm:testplan/qm:workitem/@qm:rel N/A RQMTestPlan_Relationships request_rel ODS REQUEST_TESTPLAN_LOOKUP LINK_TYPE N/A Test Plan Related Requests Link Type The RQM named linking type of request and test plan. trackedBy: The unified OSLC linking type is com.ibm.clm.relatedTestPlan Newly added in RQM 4.0. The value returned from XDC is RQM specified name and it is translated to unified OSLC linking type when running ETL to deliver it to DB.
N/A Test Plan State testplan /content/qm:testplan/alm:state/@rdf:resource N/A RQMTestPlan_Relationships state_uuid ODS TESTPLAN TESTPLAN_STATE_ID N/A Test Plan Test Plan State External ID The MD5 encrypted value of URI of current state of the test plan N/A Newly added in RQM 4.0. The field defined in this XDC Data Mapping Table is used for 4.0 ETL migration job.

Test Case

Sample Input 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 Output Changes in 4.0
N/A Test Case N/A testcase N/A N/A N/A N/A N/A TESTCASE N/A N/A Test Case N/A Unless otherwise specified in this dictionary, "Test Case" UI elements are expressed by the REST API Resource URL as "testcase"; are stored in the data warehouse "TESTCASE" table; and can be added to report definitions using the "Test Case" Query Subject and related Items. N/A N/A
N/A Test Case State testcase /content/qm:testcase/alm:state TestCase RQMTestCase testcase_state N/A N/A N/A Operational Data Store/Test Case Area/ Test Case Test Case State Reference ID The ID of current state of test case com.ibm.rqm.planning.common.new Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to Test Case State Reference ID in FM
N/A Test Case Owner testcase /content/qm:testcase/alm:owner N/A RQMTestCase owner N/A N/A N/A N/A N/A N/A The contributor's registered id that owns the test case N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Test Case Name testcase /content/qm:testcase/dc:title N/A RQMTestCase title ODS TESTCASE NAME N/A Test Case Name The name of test case N/A N/A
N/A Test Case Modified testcase /content/qm:testcase/alm:updated N/A RQMTestCase updated ODS TESTCASE LAST_UPDATED N/A Test Case Last Updated The last updated date and time of test case in UTC format N/A N/A
N/A Test Case N/A testcase /id N/A RQMTestCase itemId ODS TESTCASE EXTERNAL_KEY2 N/A Test Case External Key2 The uuid of test case N/A N/A
N/A Test Case Weight testcase /content/qm:testcase/qm:weight N/A RQMTestCase weight ODS TESTCASE WEIGHT N/A Test Case Weight An integer measure of the estimated effort that it will take to execute the test case N/A N/A
N/A Test Case Originator testcase /content/qm:testcase/dc:creator N/A RQMTestCase creator N/A N/A N/A N/A N/A N/A The contributor's registered id that created the test case N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Test Case Test case url testcase /content/qm:testcase/dc:identifier N/A RQMTestCase url ODS TESTCASE URL N/A Test Case URL The URL of test case N/A N/A
N/A Test Case Test Case testcase /content/qm:testcase/dc:identifier N/A RQMTestCase uuid ODS TESTCASE EXTERNAL_ID N/A Test Case External ID The MD5 encrypted value of the URL of test case N/A N/A
N/A Test Case N/A testcase /content/qm:testcase/qm:alias N/A RQMTestCase alias N/A N/A N/A N/A N/A N/A Read-only element containing an alternative identifier for test case N/A N/A
N/A Test Case N/A testcase /content/qm:testcase/qm:alias/@qm:type N/A RQMTestCase alias_type N/A N/A N/A N/A N/A N/A The type of the alternative identifier for test plan uuid N/A
N/A Test Case N/A testcase /content/qm:testcase/qm:creationDate N/A RQMTestCase creationDate N/A N/A N/A N/A N/A N/A The creation date and time of test case in UTC format N/A N/A
N/A Test Case ID testcase /content/qm:testcase/qm:webId N/A RQMTestCase webId ODS TESTCASE REFERENCE_ID N/A Test Case Reference ID Read-only integer ID of test case as seen in the web UI N/A N/A
N/A Test Case Is Deleted testcase /qm:archived N/A RQMTestCase isSoftDeleted ODS TESTCASE ISSOFTDELETED N/A Test Case Is Deleted The test case is archived or not 0: not deleted, 1: deleted N/A
N/A Test Case Project Area testcase /content/qm:testcase/qm:projectArea/@vega:id N/A RQMTestCase projectId ODS TESTCASE PROJECT_ID N/A Test Case Project ID The uuid of project area of the test case N/A N/A
N/A Test Case Owner testcase /content/qm:testcase/alm:owner/@rdf:resource N/A RQMTestCase owner_uuid ODS TESTCASE OWNER_ID N/A Test Case Owner ID The MD5 encrypted value of URI of the contributor that owns the test case N/A N/A
N/A Test Case Originator testcase /content/qm:testcase/dc:creator/@rdf:resource N/A RQMTestCase creator_uuid N/A N/A N/A N/A N/A N/A The MD5 encrypted value of URI of the contributor that created the test case N/A N/A
N/A Test Case State testcase /content/qm:testcase/alm:state/@rdf:resource N/A RQMTestCase state_uuid ODS TESTCASE TESTCASE_STATE_ID N/A Test Case Test Case State External ID The MD5 encrypted value of URI of current state of the test case N/A Newly added in RQM 4.0. It is used to look up the value of TESTCASE_STATE_ID column in TESTCASE table, the value of the element in XDC is equal to the Test Case State External ID field of "Test Case" Query Subject in FM.
N/A Test Case Test Case testcase /content/qm:testcase/dc:identifier N/A RQMTestCase_CustomAttribute testcase_uuid CALM TESTCASE_STRING_EXT TESTCASE_ID N/A Test Case External ID The MD5 encrypted value of the URL of test case N/A N/A
N/A Test Case Test Case testcase /content/qm:testcase/dc:identifier N/A RQMTestCase_CustomAttribute testcase_uuid CALM TESTCASE_STRING_M_EXT TESTCASE_ID N/A Test Case External ID The MD5 encrypted value of the URL of test case N/A N/A
N/A Test Case Test Case testcase /content/qm:testcase/dc:identifier N/A RQMTestCase_CustomAttribute testcase_uuid CALM TESTCASE_INT_EXT TESTCASE_ID N/A Test Case External ID The MD5 encrypted value of the URL of test case N/A N/A
N/A Test Case Test Case testcase /content/qm:testcase/dc:identifier N/A RQMTestCase_CustomAttribute testcase_uuid CALM TESTCASE_TIMESTAMP_EXT TESTCASE_ID N/A Test Case External ID The MD5 encrypted value of the URL of test case N/A N/A
N/A Test Case N/A testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestCase_CustomAttribute identifier CALM TESTCASE_STRING_EXT IDENTIFIER N/A Test Case String Extension Identifying name The identifier of small text custom attribute of test case N/A N/A
N/A Test Case N/A testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestCase_CustomAttribute identifier CALM TESTCASE_STRING_M_EXT IDENTIFIER N/A Test Case Medium String Extension Identifying name The identifier of medium text custom attribute of test case N/A N/A
N/A Test Case N/A testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestCase_CustomAttribute identifier CALM TESTCASE_INT_EXT IDENTIFIER N/A Test Case Integer Extension Identifying name The identifier of integer custom attribute of test case N/A N/A
N/A Test Case N/A testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestCase_CustomAttribute identifier CALM TESTCASE_TIMESTAMP_EXT IDENTIFIER N/A Test Case Timestamp Extension Identifying name The identifier of date/time custom attribute of test case N/A N/A
N/A Test Case Attributes Type testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/@qm:type N/A RQMTestCase_CustomAttribute type N/A N/A N/A N/A N/A N/A The type of custom attribute of test case, there are 4 types, SMALL_STRING, MEDIUM_STRING, INTEGER, TIMESTAMP 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. N/A
N/A Test Case Attributes Attribute Name testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestCase_CustomAttribute name CALM TESTCASE_STRING_EXT NAME N/A Test Case String Extension Name The name of small text custom attribute of test case N/A N/A
N/A Test Case Attributes Attribute Name testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestCase_CustomAttribute name CALM TESTCASE_STRING_M_EXT NAME N/A Test Case Medium String Extension Name The name of mediumn text custom attribute of test case N/A N/A
N/A Test Case Attributes Attribute Name testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestCase_CustomAttribute name CALM TESTCASE_INT_EXT NAME N/A Test Case Integer Extension Name The name of integer custom attribute of test case N/A N/A
N/A Test Case Attributes Attribute Name testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestCase_CustomAttribute name CALM TESTCASE_TIMESTAMP_EXT NAME N/A Test Case Timestamp Extension Name The name of date/time custom attribute of test case N/A N/A
N/A Test Case Custom Attribute Value testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestCase_CustomAttribute value CALM TESTCASE_STRING_EXT VAR N/A Test Case String Extension Value The value of small text custom attribute of test case N/A N/A
N/A Test Case Custom Attribute Value testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestCase_CustomAttribute value CALM TESTCASE_STRING_M_EXT VAR N/A Test Case Medium String Extension Value The value of medium text custom attribute of test case N/A N/A
N/A Test Case Custom Attribute Value testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestCase_CustomAttribute value CALM TESTCASE_INT_EXT VAR N/A Test Case Integer Extension Value The string type value of integer custom attribute of test case N/A N/A
N/A Test Case Custom Attribute Value testcase /content/qm:testcase/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestCase_CustomAttribute timeValue CALM TESTCASE_TIMESTAMP_EXT VAR N/A Test Case Timestamp Extension Value The timestamp value of date/time custom attribute of test case in UTC format N/A N/A
N/A Test Case Is Deleted testcase /qm:archived N/A RQMTestCase_CustomAttribute isSoftDeleted CALM TESTCASE_STRING_EXT ISSOFTDELETED N/A Test Case String Extension Is Deleted The test case is archived or not 0: not deleted, 1: deleted N/A
N/A Test Case Is Deleted testcase /qm:archived N/A RQMTestCase_CustomAttribute isSoftDeleted CALM TESTCASE_STRING_M_EXT ISSOFTDELETED N/A Test Case Medium String Extension Is Deleted The test case is archived or not 0: not deleted, 1: deleted N/A
N/A Test Case Is Deleted testcase /qm:archived N/A RQMTestCase_CustomAttribute isSoftDeleted CALM TESTCASE_INT_EXT ISSOFTDELETED N/A Test Case Integer Extension Is Deleted The test case is archived or not 0: not deleted, 1: deleted N/A
N/A Test Case Is Deleted testcase /qm:archived N/A RQMTestCase_CustomAttribute isSoftDeleted CALM TESTCASE_TIMESTAMP_EXT ISSOFTDELETED N/A Test Case Timestamp Extension Is Deleted The test case is archived or not 0: not deleted, 1: deleted N/A
N/A Test Case Test case testcase /content/qm:testcase/dc:identifier N/A RQMTestCase_Relationships uuid ODS TESTCASE_TESTSCRIPT_LOOKUP TESTCASE_ID N/A Test Case External ID The MD5 encrypted value of the URL of test case N/A N/A
N/A Test Case Test case testcase /content/qm:testcase/dc:identifier N/A RQMTestCase_Relationships uuid ODS TESTCASE_CATEGORY_LOOKUP TESTCASE_ID N/A Test Case External ID The MD5 encrypted value of the URL of test case N/A N/A
N/A Test Case Test case testcase /content/qm:testcase/dc:identifier N/A RQMTestCase_Relationships uuid ODS REQUIREMENT_TESTCASE_LOOKUP TESTCASE_ID N/A Test Case External ID The MD5 encrypted value of the URL of test case N/A N/A
N/A Test Case Test case testcase /content/qm:testcase/dc:identifier N/A RQMTestCase_Relationships uuid ODS REQUEST_TESTCASE_LOOKUP TESTCASE_ID N/A Test Case External ID The MD5 encrypted value of the URL of test case N/A N/A
N/A Test Case Related Remote Scripts testcase /content/qm:testcase/qm:remotescript/@qm:href N/A RQMTestCase_Relationships remotescript_uuid ODS TESTCASE_TESTSCRIPT_LOOKUP TESTSCRIPT_ID N/A Test Case Related Test Scripts External ID The MD5 encrypted value of the URL of the remote script of test case N/A N/A
N/A Test Case Related Test Scripts testcase /content/qm:testcase/qm:testscript/@qm:href N/A RQMTestCase_Relationships testscript_uuid ODS TESTCASE_TESTSCRIPT_LOOKUP TESTSCRIPT_ID N/A Test Case Related Test Scripts External ID The MD5 encrypted value of the URL of the manual test script of test case N/A N/A
N/A Test Case Categories value testcase /content/qm:testcase/qm:category/@qm:value N/A RQMTestCase_Relationships category_value N/A N/A N/A N/A Test Case Related Test Categories Category Value The category value of test case N/A Deprecated
N/A Test Case Categories value testcase /content/qm:testcase/qm:category/@qm:valueUUID N/A RQMTestCase_Relationships valueUUID ODS TESTCASE_CATEGORY_LOOKUP TEST_CATEGORY_ID N/A Test Case Related Test Categories External Key2 The uuid of category value of test case N/A N/A
N/A Test Case Related Requirements testcase /content/qm:testcase/qm:requirement/@qm:href N/A RQMTestCase_Relationships requirement_uuid ODS REQUIREMENT_TESTCASE_LOOKUP REQUIREMENT_ID N/A Test Case Related Requirements External ID The MD5 encrypted value of the URL of the requirement of test case N/A N/A
N/A Test Case Categories name testcase /content/qm:testcase/qm:category/@qm:term N/A RQMTestCase_Relationships category_term N/A N/A N/A N/A Test Case Related Test Categories Category Term The category name of test case N/A Deprecated
N/A Test Case Related Workitems testcase /content/qm:testcase/qm:workitem/@qm:href N/A RQMTestCase_Relationships request_uuid ODS REQUEST_TESTCASE_LOOKUP REQUEST_ID N/A Test Case Related Requests External ID The MD5 encrypted value of the URL of the requests of test case N/A N/A
N/A Test Case Related Requirements testcase /content/qm:testcase/qm:requirement/@qm:externalReqId N/A RQMTestCase_Relationships externalReqId ODS REQUIREMENT_TESTCASE_LOOKUP REQUIREMENT_ID N/A Test Case Related Requirements External Key2 The external id of Rational RequisitePro requirement of test case {4C4DB6F2-2D6A-4FF0-8145-F7ABD4E3777E} N/A
N/A Test Case Related Workitem url testcase /content/qm:testcase/qm:workitem/@qm:href N/A RQMTestCase_Relationships request_url ODS REQUEST_TESTCASE_LOOKUP REQUEST_ID N/A Test Case Related Requests URL The URL of the requests of test case N/A N/A
N/A Test Case Related Workitems OSLC linking type testcase /content/qm:testcase/qm:workitem/@qm:rel N/A RQMTestCase_Relationships request_rel ODS REQUEST_TESCASE_LOOKUP LINK_TYPE N/A Test Case Related Requests Link Type The RQM named linking type of request and test case trackedBy: The unified OSLC linking type is com.ibm.clm.relatedTestCase. tests: The unified OSLC linking type is com.ibm.clm.testsDevelopmentItem. Newly added in RQM 4.0. The value returned from XDC is RQM specified name and it is translated to unified OSLC linking type when running ETL to deliver it to DB.
N/A Test Case Related Requirements OSLC linking type testcase /content/qm:testcase/qm:requirement/@qm:rel N/A RQMTestCase_Relationships requirement_rel ODS REQUIREMENT_TESTCASE_LOOKUP LINK_TYPE N/A Test Case Related Requirements Link Type The RQM named linking type of requirement and test case validates: The unified OSLC linking type is com.ibm.clm.validatesRequirement. Newly added in RQM 4.0. The value returned from XDC is RQM specified name and it is translated to unified OSLC linking type when running ETL to deliver it to DB.
N/A Test Case State testcase /content/qm:testcase/alm:state/@rdf:resource N/A RQMTestCase_Relationships state_uuid ODS TESTCASE TESTCASE_STATE_ID N/A Test Case Test Case State External ID The MD5 encrypted value of URI of current state of the test case N/A Newly added in RQM 4.0. The field defined in this XDC Data Mapping Table is used for 4.0 ETL migration job.

Requirement

Sample Input 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 Output Changes in 4.0
N/A Requirement N/A requirement N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A It is not used in Data Manager ETL but only for RQM Java ETL (data collection job). RQM Java ETL read the RQM requirement feed to populate the requirements of integrated Rational RequisitePro and Rational Doors via RQMi to data warehouse database. Unless otherwise specified in this dictionary, "Requirement" UI elements are expressed by the REST API Resource URL as "requirement"; are stored in the data warehouse "REQUIREMENT" table; and can be added to report definitions using the "Requirement" Query Subject and related Items. N/A N/A
N/A Requirement Name requirement /content/qm:requirement/dc:title Requirement RQMRequirement title ODS REQUIREMENT NAME Operational Data Store/Requirement Area/ Requirement Name The name of requirement N/A Only used for RQM Java ETL
N/A Requirement N/A requirement /id N/A RQMRequirement itemId ODS REQUIREMENT EXTERNAL_KEY2 N/A Requirement External Key2 The uuid of proxy Rational Doors requirement (RQM and Doors integrated via RQMi) N/A Only used for RQM Java ETL
N/A Requirement Modified requirement /content/qm:requirement/alm:updated N/A RQMRequirement updated N/A N/A N/A N/A N/A N/A The last updated date and time of proxy requirment in UTC format N/A Not used in ETL and deprecated in RQM301
N/A Requirement Owner requirement /content/qm:requirement/alm:owner N/A RQMRequirement owner N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A Not used in ETL
N/A Requirement N/A requirement /content/qm:requirement/qm:creationtime N/A RQMRequirement creationtime N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A Not used in ETL
N/A Requirement Requirement URL requirement /content/qm:requirement/dc:identifier N/A RQMRequirement url ODS REQUIREMENT URL N/A Requirement URL The proxy URL of requirement exposed by RQM requirement feed https://<hostname>:<port>/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/CLM+%28Quality+Management%29/requirement/doors/QMW2K3-252:36677/version=2%26prodID=0%26urn=urn:telelogic::1-4ef985c84aee4a64-O-2-00000027 Only used for RQM Java ETL
N/A Requirement Requirement requirement /content/qm:requirement/dc:identifier N/A RQMRequirement uuid ODS REQUIREMENT EXTERNAL_ID N/A Requirement External ID The MD5 encrypted value of the proxy URL of requirement exposed by RQM requirement feed N/A Only used for RQM Java ETL
N/A Requirement ID requirement /content/qm:requirement/qm:webId N/A RQMRequirement webId ODS REQUIREMENT REFERENCE_ID N/A Requirement Reference ID Read-only integer ID of requirement as seen in the RQM 2.x web UI N/A Only used for RQM Java ETL
N/A Requirement Is Deleted requirement /qm:archived N/A RQMRequirement isSoftDeleted ODS REQUIREMENT ISSOFTDELETED N/A Requirement Is Deleted The requirement is archived in RQM or not 0: not deleted, 1: deleted Only used for RQM Java ETL
N/A Requirement Project Area requirement /content/qm:requirement/qm:projectArea/@vega:id N/A RQMRequirement projectId ODS REQUIREMENT PROJECT_ID N/A Requirement Project ID The uuid of project area of the proxy requirement N/A Only used for RQM Java ETL
N/A Requirement Owner requirement /content/qm:requirement/alm:owner/@rdf:resource N/A RQMRequirement owner_uuid N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A Not used in ETL
N/A Requirement Creator requirement /content/qm:requirement/dc:creator/@rdf:resource N/A RQMRequirement creator_uuid N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A Not used in ETL
N/A Requirement N/A requirement /content/qm:requirement/qm:externalReqId N/A RQMRequirement externalReqId ODS REQUIREMENT EXTERNAL_KEY2 N/A Requirement External Key2 The external id of Rational RequisitePro requirement {4C4DB6F2-2D6A-4FF0-8145-F7ABD4E3777E} Only used for RQM Java ETL
N/A Requirement Name requirement /content/qm:requirement/qm:externalTag N/A RQMRequirement externalTag ODS REQUIREMENT REFERENCE_ID N/A Requirement Reference ID The tag of Rational RequisitePro requirement N/A Only used for RQM Java ETL. Newly added since RQM 3.0.1.1. See RQM WI 56087: Requirement REST API does not return the Tag

Test Script

Sample Input 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 Output Changes in 4.0
N/A Test Script N/A testscript N/A N/A N/A N/A N/A TESTSCRIPT N/A N/A Test Script N/A Unless otherwise specified in this dictionary, "Test Script" UI elements are expressed by the REST API Resource URL as "testscript"; are stored in the data warehouse "TESTSCRIPT" table; and can be added to report definitions using the "Test Script" Query Subject and related Items. N/A N/A
N/A Test Script N/A testscript /id TestScript RQMTestScript itemId ODS TESTSCRIPT EXTERNAL_KEY2 Operational Data Store/Test Script Area/ Test Script External Key2 The uuid of test script N/A N/A
N/A Test Script Owner testscript /content/qm:testscript/alm:owner N/A RQMTestScript owner N/A N/A N/A N/A N/A N/A The contributor's registered id that owns the test script N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Test Script Script Type testscript /content/qm:testscript/qm:scripttype N/A RQMTestScript scripttype ODS TESTSCRIPT TYPE N/A Test Script Type The type of test script Manual N/A
N/A Test Script Name testscript /content/qm:testscript/dc:title N/A RQMTestScript title ODS TESTSCRIPT NAME N/A Test Script Name The name of test script N/A N/A
N/A Test Script Modified testscript /content/qm:testscript/alm:updated N/A RQMTestScript updated ODS TESTSCRIPT LAST_UPDATED N/A Test Script Last Updated The last updated date and time of test script in UTC format N/A N/A
N/A Test Script State testscript /content/qm:testscript/alm:state N/A RQMTestScript state N/A N/A N/A N/A Test Script Test Script State Reference ID The ID of current state of test script com.ibm.rqm.planning.common.new Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to Test Script State Reference ID in FM
N/A Test Script Test Script URL testscript /content/qm:testscript/dc:identifier N/A RQMTestScript url ODS TESTSCRIPT URL N/A Test Script URL The URL of test script N/A N/A
N/A Test Script Test Script testscript /content/qm:testscript/dc:identifier N/A RQMTestScript uuid ODS TESTSCRIPT EXTERNAL_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script N/A testscript /content/qm:testscript/qm:creationDate N/A RQMTestScript creationDate N/A N/A N/A N/A N/A N/A The creation date and time of test script in UTC format N/A N/A
N/A Test Script ID testscript /content/qm:testscript/qm:webId N/A RQMTestScript webId ODS TESTSCRIPT REFERENCE_ID N/A Test Script Reference ID Read-only integer ID of test script as seen in the web UI N/A N/A
N/A Test Script Is Deleted testscript /qm:archived N/A RQMTestScript isSoftDeleted ODS TESTSCRIPT ISSOFTDELETED N/A Test Script Is Deleted The test script is archived or not 0: not deleted, 1: deleted N/A
N/A Test Script Project Area testscript /content/qm:testscript/qm:projectArea/@vega:id N/A RQMTestScript projectId ODS TESTSCRIPT PROJECT_ID N/A Test Script Project ID The uuid of project area of the test script N/A New since RQM 4.0, see RQM WI 58168: As a report developer I need to report on the Project ID for Test Scripts
N/A Test Script Owner testscript /content/qm:testscript/alm:owner/@rdf:resource N/A RQMTestScript owner_uuid ODS TESTSCRIPT OWNER_ID N/A Test Script Owner ID The MD5 encrypted value of URI of the contributor that owns the test script N/A N/A
N/A Test Script State testscript /content/qm:testscript/alm:state/@rdf:resource N/A RQMTestScript state_uuid ODS TESTSCRIPT TESTSCRIPT_STATE_ID N/A Test Script Test Script State External ID The MD5 encrypted value of URI of current state of the test script N/A Newly added in RQM 4.0. It is used to look up the value of TESTSCRIPT_STATE_ID column in TESTSCRIPT table, the value of the element in XDC is equal to the Test Script State External ID field of "Test Script" Query Subject in FM.
N/A Test Script Test Script testscript /content/qm:testscript/dc:identifier N/A RQMTestScript_CustomAttribute testscript_uuid CALM TESTSCRIPT_STRING_EXT TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script Test Script testscript /content/qm:testscript/dc:identifier N/A RQMTestScript_CustomAttribute testscript_uuid CALM TESTSCRIPT_STRING_M_EXT TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script Test Script testscript /content/qm:testscript/dc:identifier N/A RQMTestScript_CustomAttribute testscript_uuid CALM TESTSCRIPT_INT_EXT TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script Test Script testscript /content/qm:testscript/dc:identifier N/A RQMTestScript_CustomAttribute testscript_uuid CALM TESTSCRIPT_TIMESTAMP_EXT TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script N/A testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestScript_CustomAttribute identifier CALM TESTSCRIPT_STRING_EXT IDENTIFIER N/A Test Script String Extension Identifying name The identifier of small text custom attribute of test script N/A N/A
N/A Test Script N/A testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestScript_CustomAttribute identifier CALM TESTSCRIPT_STRING_M_EXT IDENTIFIER N/A Test Script Medium String Extension Identifying name The identifier of medium text custom attribute of test script N/A N/A
N/A Test Script N/A testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestScript_CustomAttribute identifier CALM TESTSCRIPT_INT_EXT IDENTIFIER N/A Test Script Integer Extension Identifying name The identifier of integer custom attribute of test script N/A N/A
N/A Test Script N/A testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestScript_CustomAttribute identifier CALM TESTSCRIPT_TIMESTAMP_EXT IDENTIFIER N/A Test Script Timestamp Extension Identifying name The identifier of date/time custom attribute of test script N/A N/A
N/A Test Script Attributes Type testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/@qm:type N/A RQMTestScript_CustomAttribute type N/A N/A N/A N/A N/A N/A The type of custom attribute of test script, there are 4 types, SMALL_STRING, MEDIUM_STRING, INTEGER, TIMESTAMP 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. N/A
N/A Test Script Attributes Attribute Name testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestScript_CustomAttribute name CALM TESTSCRIPT_STRING_EXT NAME N/A Test Script String Extension Name The name of small text custom attribute of test script N/A N/A
N/A Test Script Attributes Attribute Name testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestScript_CustomAttribute name CALM TESTSCRIPT_STRING_M_EXT NAME N/A Test Script Medium String Extension Name The name of medium text custom attribute of test script N/A N/A
N/A Test Script Attributes Attribute Name testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestScript_CustomAttribute name CALM TESTSCRIPT_INT_EXT NAME N/A Test Script Integer Extension Name The name of integer custom attribute of test script N/A N/A
N/A Test Script Attributes Attribute Name testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestScript_CustomAttribute name CALM TESTSCRIPT_TIMESTAMP_EXT NAME N/A Test Script Timestamp Extension Name The name of date/time custom attribute of test script N/A N/A
N/A Test Script Attributes Custom Attribute Value testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestScript_CustomAttribute value CALM TESTSCRIPT_STRING_EXT VAR N/A Test Script String Extension Value The value of small text custom attribute of test script N/A N/A
N/A Test Script Attributes Custom Attribute Value testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestScript_CustomAttribute value CALM TESTSCRIPT_STRING_M_EXT VAR N/A Test Script Medium String Extension Value The value of medium text custom attribute of test script N/A N/A
N/A Test Script Attributes Custom Attribute Value testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestScript_CustomAttribute value CALM TESTSCRIPT_INT_EXT VAR N/A Test Script Integer Extension Value The string type value of integer custom attribute of test script N/A N/A
N/A Test Script Attributes Custom Attribute Value testscript /content/qm:testscript/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestScript_CustomAttribute timeValue CALM TESTSCRIPT_TIMESTAMP_EXT VAR N/A Test Script Timestamp Extension Value The timestamp type value of date/time custom attribute of test script N/A N/A
N/A Test Script Is Deleted testscript /qm:archived N/A RQMTestScript_CustomAttribute isSoftDeleted CALM TESTSCRIPT_STRING_EXT ISSOFTDELETED N/A Test Script String Extension Is Deleted The test script is archived or not 0: not deleted, 1: deleted N/A
N/A Test Script Is Deleted testscript /qm:archived N/A RQMTestScript_CustomAttribute isSoftDeleted CALM TESTSCRIPT_STRING_M_EXT ISSOFTDELETED N/A Test Script Medium String Extension Is Deleted The test script is archived or not 0: not deleted, 1: deleted N/A
N/A Test Script Is Deleted testscript /qm:archived N/A RQMTestScript_CustomAttribute isSoftDeleted CALM TESTSCRIPT_INT_EXT ISSOFTDELETED N/A Test Script Integer Extension Is Deleted The test script is archived or not 0: not deleted, 1: deleted N/A
N/A Test Script Is Deleted testscript /qm:archived N/A RQMTestScript_CustomAttribute isSoftDeleted CALM TESTSCRIPT_TIMESTAMP_EXT ISSOFTDELETED N/A Test Script Timestamp Extension Is Deleted The test script is archived or not 0: not deleted, 1: deleted N/A
N/A Test Script Test Script testscript /content/qm:testscript/dc:identifier N/A RQMTestScript_Relationships uuid ODS TESTSCRIPT_CATEGORY_LOOKUP TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script Test Script testscript /content/qm:testscript/dc:identifier N/A RQMTestScript_Relationships uuid ODS REQUEST_TESTSCRIPT_LOOKUP TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script Categories value testscript /content/qm:testscript/qm:category/@qm:valueUUID N/A RQMTestScript_Relationships valueUUID ODS TESTSCRIPT_CATEGORY_LOOKUP TEST_CATEGORY_ID N/A Test Script Related Test Categories External Key2 The uuid of category value of test script N/A Newly added in RQM 4.0.
N/A Test Script Related Workitems OSLC linking type testscript /content/qm:testscript/qm:workitem/@qm:rel N/A RQMTestScript_Relationships request_rel ODS REQUEST_TESTSCRIPT_LOOKUP LINK_TYPE N/A Test Script Related Requests Link Type The RQM named linking type of request and test script trackedBy: The unified OSLC linking type is com.ibm.clm.relatedTestScript. Newly added in RQM 4.0. The value returned from XDC is RQM specified name and it is translated to unified OSLC linking type when running ETL to deliver it to DB.
N/A Test Script Related Workitems testscript /content/qm:testscript/qm:workitem/@qm:href N/A RQMTestScript_Relationships request_uuid ODS REQUEST_TESTSCRIPT_LOOKUP REQUEST_ID N/A Test Script Related Requests External ID The MD5 encrypted value of the URL of the requests of test script N/A Newly added in RQM 4.0.
N/A Test Script Related Workitems URL testscript /content/qm:testscript/qm:workitem/@qm:href N/A RQMTestScript_Relationships request_url ODS REQUEST_TESTSCRIPT_LOOKUP REQUEST_ID N/A Test Script Related Requests URL The URL of the requests of test script N/A Newly added in RQM 4.0. It is used to look up for Clear Quest Requests.
N/A Test Script State testscript /content/qm:testscript/alm:state/@rdf:resource N/A RQMTestScript_Relationships state_uuid ODS TESTSCRIPT TESTSCRIPT_STATE_ID N/A Test Script Test Script State External ID The MD5 encrypted value of URI of current state of the test script N/A Newly added in RQM 4.0. The field defined in this XDC Data Mapping Table is used for 4.0 ETL migration job.
N/A Test Script Project Area testscript /content/qm:testscript/qm:projectArea/@vega:id N/A RQMTestScript_Relationships projectId ODS TESTSCRIPT PROJECT_ID N/A Test Script Project ID The uuid of project area of the test script N/A Newly added in RQM 4.0. The field defined in this XDC Data Mapping Table is used for 4.0 ETL migration job.

Test Suite

Sample Input 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 Output Changes in 4.0
N/A Test Suite N/A testsuite N/A N/A N/A N/A N/A TESTSUITE N/A N/A Test Suite N/A Unless otherwise specified in this dictionary, "Test Suite" UI elements are expressed by the REST API Resource URL as "testsuite"; are stored in the data warehouse "TESTSUITE" table; and can be added to report definitions using the "Test Suite" Query Subject and related Items. N/A N/A
N/A Test Suite N/A testsuite /id TestSuite RQMTestSuite itemId ODS TESTSUITE EXTERNAL_KEY2 Operational Data Store/Test Suite Area/ Test Suite External Key2 The uuid of test suite N/A N/A
N/A Test Suite Modified testsuite /content/qm:testsuite/alm:updated N/A RQMTestSuite updated ODS TESTSUITE LAST_UPDATED N/A Test Suite Last Updated The last updated date and time of test suite in UTC format N/A N/A
N/A Test Suite Owner testsuite /content/qm:testsuite/alm:owner N/A RQMTestSuite owner N/A N/A N/A N/A N/A N/A The contributor's registered id that owns the test suite N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Test Suite Name testsuite /content/qm:testsuite/dc:title N/A RQMTestSuite title ODS TESTSUITE NAME N/A Test Suite Name The name of test suite N/A N/A
N/A Test Suite State testsuite /content/qm:testsuite/alm:state N/A RQMTestSuite testsuite_state N/A N/A N/A N/A Test Suite Test Suite State Reference ID The ID of current state of test suite com.ibm.rqm.planning.common.new Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to Test Suite State Reference ID in FM
N/A Test Suite Test Suite URL testsuite /content/qm:testsuite/dc:identifier N/A RQMTestSuite url ODS TESTSUITE URL N/A Test Suite URL The URL of test suite N/A N/A
N/A Test Suite Test Suite testsuite /content/qm:testsuite/dc:identifier N/A RQMTestSuite uuid ODS TESTSUITE EXTERNAL_ID N/A Test Suite External ID The MD5 encrypted value of the URL of test suite N/A N/A
N/A Test Suite Is Sequential testsuite /content/qm:testsuite/qm:sequentialExecution N/A RQMTestSuite sequentialExecution ODS TESTSUITE ISSEQUENTIAL N/A Test Suite Is Sequential Indicate the test suite will be executed serially or not N/A N/A
N/A Test Suite Description testsuite /content/qm:testsuite/dc:description N/A RQMTestSuite description ODS TESTSUITE DESCRIPTION N/A Test Suite Description The description of test suite N/A N/A
N/A Test Suite Originator testsuite /content/qm:testsuite/dc:creator N/A RQMTestSuite creator N/A N/A N/A N/A N/A N/A The contributor's registered id that created the test suite N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Test Suite Weight testsuite /content/qm:testsuite/qm:weight N/A RQMTestSuite weight ODS TESTSUITE WEIGHT N/A Test Suite Weight An integer measure of the estimated effort that it will take to execute the test suite N/A N/A
N/A Test Suite ID testsuite /content/qm:testsuite/qm:webId N/A RQMTestSuite webId ODS TESTSUITE REFERENCE_ID N/A Test Suite Reference ID Read-only integer ID of test suite as seen in the web UI N/A N/A
N/A Test Suite Is Deleted testsuite /qm:archived N/A RQMTestSuite isSoftDeleted ODS TESTSUITE ISSOFTDELETED N/A Test Suite Is Deleted The test suite is archived or not 0: not deleted, 1: deleted N/A
N/A Test Suite Project Area testsuite /content/qm:testsuite/qm:projectArea/@vega:id N/A RQMTestSuite projectId ODS TESTSUITE PROJECT_ID N/A Test Suite Project ID The uuid of project area of the test suite N/A N/A
N/A Test Suite Owner testsuite /content/qm:testsuite/alm:owner/@rdf:resource N/A RQMTestSuite owner_uuid ODS TESTSUITE OWNER_ID N/A Test Suite Owner ID The MD5 encrypted value of URI of the contributor that owns the test suite N/A N/A
N/A Test Suite Originator testsuite /content/qm:testsuite/dc:creator/@rdf:resource N/A RQMTestSuite creator_uuid ODS TESTSUITE CREATOR_ID N/A Test Suite Creator ID The MD5 encrypted value of URI of the contributor that created the test suite N/A N/A
N/A Test Suite State testsuite /content/qm:testsuite/alm:state/@rdf:resource N/A RQMTestSuite state_uuid ODS TESTSUITE TESTSUITE_STATE_ID N/A Test Suite Test Suite State External ID The MD5 encrypted value of URI of current state of the test suite N/A Newly added in RQM 4.0. It is used to look up the value of TESTSUITE_STATE_ID column in TESTSUITE table, the value of the element in XDC is equal to the Test Suite State External ID field of "Test Suite" Query Subject in FM.
N/A Test Suite Test Suite testsuite /content/qm:testsuite/dc:identifier N/A RQMTestSuite_CustomAttribute testsuite_uuid CALM TESTSUITE_STRING_EXT TESTSUITE_ID N/A Test Suite External ID The MD5 encrypted value of the URL of test suite N/A N/A
N/A Test Suite Test Suite testsuite /content/qm:testsuite/dc:identifier N/A RQMTestSuite_CustomAttribute testsuite_uuid CALM TESTSUITE_STRING_M_EXT TESTSUITE_ID N/A Test Suite External ID The MD5 encrypted value of the URL of test suite N/A N/A
N/A Test Suite Test Suite testsuite /content/qm:testsuite/dc:identifier N/A RQMTestSuite_CustomAttribute testsuite_uuid CALM TESTSUITE_INT_EXT TESTSUITE_ID N/A Test Suite External ID The MD5 encrypted value of the URL of test suite N/A N/A
N/A Test Suite Test Suite testsuite /content/qm:testsuite/dc:identifier N/A RQMTestSuite_CustomAttribute testsuite_uuid CALM TESTSUITE_TIMESTAMP_EXT TESTSUITE_ID N/A Test Suite External ID The MD5 encrypted value of the URL of test suite N/A N/A
N/A Test Suite N/A testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestSuite_CustomAttribute identifier CALM TESTSUITE_STRING_EXT IDENTIFIER N/A Test Suite String Extension Identifying name The identifier of small text custom attribute of test suite N/A N/A
N/A Test Suite N/A testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestSuite_CustomAttribute identifier CALM TESTSUITE_STRING_M_EXT IDENTIFIER N/A Test Suite Medium String Extension Identifying name The identifier of medium text custom attribute of test suite N/A N/A
N/A Test Suite N/A testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestSuite_CustomAttribute identifier CALM TESTSUITE_INT_EXT IDENTIFIER N/A Test Suite Integer Extension Identifying name The identifier of integer custom attribute of test suite N/A N/A
N/A Test Suite N/A testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTestSuite_CustomAttribute identifier CALM TESTSUITE_TIMESTAMP_EXT IDENTIFIER N/A Test Suite Timestamp Extension Identifying name The identifier of date/time custom attribute of test suite N/A N/A
N/A Test Suite Attributes Type testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/@qm:type N/A RQMTestSuite_CustomAttribute type N/A N/A N/A N/A N/A N/A The type of custom attribute of test suite, there are 4 types, SMALL_STRING, MEDIUM_STRING, INTEGER, TIMESTAMP 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. N/A
N/A Test Suite Attributes Custom Attribute Name testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestSuite_CustomAttribute name CALM TESTSUITE_STRING_EXT NAME N/A Test Suite String Extension Name The name of small text custom attribute of test suite N/A N/A
N/A Test Suite Attributes Custom Attribute Name testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestSuite_CustomAttribute name CALM TESTSUITE_STRING_M_EXT NAME N/A Test Suite Medium String Extension Name The name of medium text custom attribute of test suite N/A N/A
N/A Test Suite Attributes Custom Attribute Name testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestSuite_CustomAttribute name CALM TESTSUITE_INT_EXT NAME N/A Test Suite Integer Extension Name The name of integer custom attribute of test suite N/A N/A
N/A Test Suite Attributes Custom Attribute Name testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTestSuite_CustomAttribute name CALM TESTSUITE_TIMESTAMP_EXT NAME N/A Test Suite Timestamp Extension Name The name of date/time custom attribute of test suite N/A N/A
N/A Test Suite Attributes Custom Attribute Value testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestSuite_CustomAttribute value CALM TESTSUITE_STRING_EXT VAR N/A Test Suite String Extension Value The value of small text custom attribute of test suite N/A N/A
N/A Test Suite Attributes Custom Attribute Value testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestSuite_CustomAttribute value CALM TESTSUITE_STRING_M_EXT VAR N/A Test Suite Medium String Extension Value The value of medium text custom attribute of test suite N/A N/A
N/A Test Suite Attributes Custom Attribute Value testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestSuite_CustomAttribute value CALM TESTSUITE_INT_EXT VAR N/A Test Suite Integer Extension Value The string type value of integer custom attribute of test suite N/A N/A
N/A Test Suite Attributes Custom Attribute Value testsuite /content/qm:testsuite/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTestSuite_CustomAttribute timeValue CALM TESTSUITE_TIMESTAMP_EXT VAR N/A Test Suite Timestamp Extension Value The timestamp type value of date/time custom attribute of test suite N/A N/A
N/A Test Suite Is Deleted testsuite /qm:archived N/A RQMTestSuite_CustomAttribute isSoftDeleted CALM TESTSUITE_STRING_EXT ISSOFTDELETED N/A Test Suite String Extension Is Deleted The test suite is archived or not 0: not deleted, 1: deleted N/A
N/A Test Suite Is Deleted testsuite /qm:archived N/A RQMTestSuite_CustomAttribute isSoftDeleted CALM TESTSUITE_STRING_M_EXT ISSOFTDELETED N/A Test Suite Medium String Extension Is Deleted The test suite is archived or not 0: not deleted, 1: deleted N/A
N/A Test Suite Is Deleted testsuite /qm:archived N/A RQMTestSuite_CustomAttribute isSoftDeleted CALM TESTSUITE_INT_EXT ISSOFTDELETED N/A Test Suite Integer Extension Is Deleted The test suite is archived or not 0: not deleted, 1: deleted N/A
N/A Test Suite Is Deleted testsuite /qm:archived N/A RQMTestSuite_CustomAttribute isSoftDeleted CALM TESTSUITE_TIMESTAMP_EXT ISSOFTDELETED N/A Test Suite Timestamp Extension Is Deleted The test suite is archived or not 0: not deleted, 1: deleted N/A
N/A Test Suite Categories name testsuite /content/qm:testsuite/qm:category/@qm:term N/A RQMTestSuite_Relationships category_term N/A N/A N/A N/A Test Suite Related Test Categories Category Term The category name of test suite N/A Deprecated
N/A Test Suite Categories value testsuite /content/qm:testsuite/qm:category/@qm:valueUUID N/A RQMTestSuite_Relationships valueUUID ODS TESTSUITE_CATEGORY_LOOKUP TEST_CATEGORY_ID N/A Test Suite Related Test Categories External Key2 The uuid of category value of test suite N/A N/A
N/A Test Suite Categories value testsuite /content/qm:testsuite/qm:category/@qm:value N/A RQMTestSuite_Relationships category_value N/A N/A N/A N/A Test Suite Related Test Categories Category Value The category value of test suite N/A Deprecated
N/A Test Suite Test Suite testsuite /content/qm:testsuite/dc:identifier N/A RQMTestSuite_Relationships uuid ODS TESTSUITE_CATEGORY_LOOKUP TESTSUITE_ID N/A Test Suite External ID The MD5 encrypted value of the URL of test suite N/A N/A
N/A Test Suite Test Suite testsuite /content/qm:testsuite/dc:identifier N/A RQMTestSuite_Relationships uuid ODS REQUEST_TESTSUITE_LOOKUP TESTSUITE_ID N/A Test Suite External ID The MD5 encrypted value of the URL of test suite N/A N/A
N/A Test Suite Related Workitems testsuite /content/qm:testsuite/qm:workitem/@qm:href N/A RQMTestSuite_Relationships request_uuid ODS REQUEST_TESTSUITE_LOOKUP REQUEST_ID N/A Test Suite Related Requests External ID The MD5 encrypted value of the URL of the requests of test suite N/A N/A
N/A Test Suite Related Workitems url testsuite /content/qm:testsuite/qm:workitem/@qm:href N/A RQMTestSuite_Relationships request_url ODS REQUEST_TESTSUITE_LOOKUP REQUEST_ID N/A Test Suite Related Requests URL The URL of the requests of test suite N/A N/A
N/A Test Suite Related Workitems OSLC linking type testsuite /content/qm:testsuite/qm:workitem/@qm:rel N/A RQMTestSuite_Relationships request_rel ODS REQUEST_TESTSUITE_LOOKUP LINK_TYPE N/A Test Suite Related Requests Link Type The RQM named linking type of request and test suite trackedBy: The unified OSLC linking type is com.ibm.clm.relatedTestSuite. Newly added in RQM 4.0. The value returned from XDC is RQM specified name and it is translated to unified OSLC linking type when running ETL to deliver it to DB.
N/A Test Suite State testsuite /content/qm:testsuite/alm:state/@rdf:resource N/A RQMTestSuite state_uuid ODS TESTSUITE TESTSUITE_STATE_ID N/A Test Suite Test Suite State External ID The MD5 encrypted value of URI of current state of the test suite N/A Newly added in RQM 4.0. The field defined in this XDC Data Mapping Table is used for 4.0 ETL migration job.
N/A Test Suite Test Suite testsuite /content/qm:testsuite/dc:identifier N/A RQMTestSuiteElement testsuite_uuid ODS TESTSUITE_ELEMENT TESTSUITE_ID N/A Test Suite Element Test Suite ID The MD5 encrypted value of the URL of test suite N/A N/A
N/A Test Suite Test Suite testsuite /content/qm:testsuite/dc:identifier N/A RQMTestSuiteElement testsuite_uuid ODS TESTSUITE_TESTCASE_LOOKUP TESTSUITE_ID N/A Test Suite External ID The MD5 encrypted value of the URL of test suite N/A N/A
N/A Test Suite's Test Cases Test Environment testsuite /content/qm:testsuite/qm:suiteelements/qm:suiteelement/qm:configuration/@qm:href N/A RQMTestSuiteElement configuration_uuid ODS TESTSUITE_ELEMENT CONFIGURATION_ID N/A Test Suite Element Configuration ID The MD5 encrypted value of the URL of the test environment of test suite element N/A N/A
N/A Test Suite's Test Cases Related Remote Scripts testsuite /content/qm:testsuite/qm:suiteelements/qm:suiteelement/qm:remotescript/@qm:href N/A RQMTestSuiteElement remotescript_uuid ODS TESTSUITE_ELEMENT TESTSCRIPT_ID N/A Test Suite Element Test Script ID The MD5 encrypted value of the URL of the remote test script of test suite element N/A N/A
N/A Test Suite's Test Cases Related Test Scripts testsuite /content/qm:testsuite/qm:suiteelements/qm:suiteelement/qm:testscript/@qm:href N/A RQMTestSuiteElement testscript_uuid ODS TESTSUITE_ELEMENT TESTSCRIPT_ID N/A Test Suite Element Test Script ID The MD5 encrypted value of the URL of the manual test script of test suite element N/A N/A
N/A Test Suite's Test Cases Related Test Cases testsuite /content/qm:testsuite/qm:suiteelements/qm:suiteelement/qm:testcase/@qm:href N/A RQMTestSuiteElement testcase_uuid ODS TESTSUITE_ELEMENT TESTCASE_ID N/A Test Suite Element Test Case ID The MD5 encrypted value of the URL of the test case of test suite element N/A N/A
N/A Test Suite's Test Cases Related Test Cases testsuite /content/qm:testsuite/qm:suiteelements/qm:suiteelement/qm:testcase/@qm:href N/A RQMTestSuiteElement testcase_uuid ODS TESTSUITE_TESTCASE_LOOKUP TESTCASE_ID N/A Test Suite Related Test Cases Test Case ID The MD5 encrypted value of the URL of the test case of test suite element N/A N/A
N/A Test Suite's Test Cases Execution Order testsuite /content/qm:testsuite/qm:suiteelements/qm:suiteelement/@qm:elementindex N/A RQMTestSuiteElement element_index ODS TESTSUITE_ELEMENT ELEMENT_INDEX N/A Test Suite Element Element Index The index of execution order of test suite element N/A N/A
N/A Test Suite Is Deleted testsuite /qm:archived N/A RQMTestSuiteElement isSoftDeleted ODS TESTSUITE_ELEMENT ISSOFTDELETED N/A Test Suite Element Is Deleted The test suite is archived or not 0: not deleted, 1: deleted N/A

Test Schedules

Sample Input 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 Output Changes in 4.0
N/A Test Schedules N/A testphase N/A N/A N/A N/A N/A ITERATION N/A N/A Iteration N/A Unless otherwise specified in this dictionary, "Test Schedules" UI elements are expressed by the REST API Resource URL as "testphase"; are stored in the data warehouse "ITERATION" table; and can be added to report definitions using the "Iteration" Query Subject and related Items. N/A N/A
N/A Test Schedules of Test Plan Actual End Date that is appended to the name testphase /content/qm:testphase/qm:endtime TestPhase RQMTestPhase endtime ODS ITERATION END_DATE Operational Data Store/Iteration Area/ Iteration End Date The date and time indicating the actual end time of the test phase in UTC format N/A N/A
N/A Test Schedules of Test Plan State testphase /content/qm:testphase/alm:state N/A RQMTestPhase testphase_state ODS ITERATION STATUS N/A Iteration Status The state of test phase that is deprecated N/A Deprecated
N/A Test Schedules of Test Plan Actual Start Date that is appended to the name testphase /content/qm:testphase/qm:starttime N/A RQMTestPhase starttime ODS ITERATION START_DATE N/A Iteration Start Date The date and time indicating the actual start time of the test phase in UTC format N/A N/A
N/A Test Schedules of Test Plan Name without the actual start and end date testphase /content/qm:testphase/dc:title N/A RQMTestPhase title ODS ITERATION NAME N/A Iteration Name The name of test phase N/A N/A
N/A Test Schedules of Test Plan N/A testphase /id N/A RQMTestPhase itemId ODS ITERATION EXTERNAL_KEY2 N/A Iteration External Key2 The uuid of test phase N/A N/A
N/A Test Schedules of Test Plan Planed Points testphase /content/qm:testphase/qm:expectedTotalPoints N/A RQMTestPhase expectedTotalPoints ODS ITERATION EXPECTED_TOTAL_POINTS N/A Iteration Expected Total Points The expected number of total points during the test phase N/A N/A
N/A Test Schedules of Test Plan Planed Defects testphase /content/qm:testphase/qm:expectedDefects N/A RQMTestPhase expectedDefects ODS ITERATION EXPECTED_DEFECTS N/A Iteration Expected Defects The expected number of defects during the test phase N/A N/A
N/A Test Schedules of Test Plan N/A testphase /content/qm:testphase/alm:owner N/A RQMTestPhase owner N/A N/A N/A N/A N/A N/A The contributor's registered id that owns the test phase N/A Deprecated
N/A Test Schedules of Test Plan Planed Defect Validity Rate testphase /content/qm:testphase/qm:expectedValidityRate N/A RQMTestPhase expectedValidityRate ODS ITERATION EXPECTED_VALIDITY_RATE N/A Iteration Expected Validity Rate The expected defect validity of the test phase N/A N/A
N/A Test Schedules of Test Plan Planed End Date testphase /content/qm:testphase/qm:expectedEndDate N/A RQMTestPhase expectedEndDate ODS ITERATION EXPECTED_END_DATE N/A Iteration Expected End Date The date and time indicating the expected end time of the test phase in UTC format N/A N/A
N/A Test Schedules of Test Plan Planed Start Date testphase /content/qm:testphase/qm:expectedStartDate N/A RQMTestPhase expectedStartDate ODS ITERATION EXPECTED_START_DATE N/A Iteration Expected Start Date The date and time indicating the expected start time of the test phase in UTC format N/A N/A
N/A Test Schedules of Test Plan Test Schedules URL testphase /content/qm:testphase/dc:identifier N/A RQMTestPhase url ODS ITERATION URL N/A Iteration URL The URL of test phase N/A N/A
N/A Test Schedules of Test Plan Test Schedules testphase /content/qm:testphase/dc:identifier N/A RQMTestPhase uuid ODS ITERATION EXTERNAL_ID N/A Iteration External ID The MD5 encrypted value of the URL of test phase N/A N/A
N/A Test Schedules of Test Plan Is Deleted testphase /qm:archived N/A RQMTestPhase isSoftDeleted ODS ITERATION ISSOFTDELETED N/A Iteration Is Deleted The test phase is archived or not 0: not deleted, 1: deleted N/A
N/A Test Schedules of Test Plan Project Area testphase /content/qm:testphase/qm:projectArea/@vega:id N/A RQMTestPhase projectId ODS ITERATION PROJECT_ID N/A Iteration Project ID The uuid of project area of the test phase N/A N/A
N/A Test Schedules of Test Plan N/A testphase /content/qm:testphase/alm:owner/@rdf:resource N/A RQMTestPhase owner_uuid N/A N/A N/A N/A N/A N/A The MD5 encrypted value of URI of the contributor that owns the test phase N/A Deprecated
N/A Test Schedules of Test Plan Description testphase /content/qm:testphase/dc:description N/A RQMTestPhase description ODS ITERATION DESCRIPTION N/A Iteration Description The description of test phase N/A Newly added in RQM 4.0.
N/A Plan Details of Test Schedule Comment testphase /content/qm:testphase/qm:detail/qm:comment N/A RQMTestPhase_Exec_Detail comment CALM ITERATION_EXEC_DETAIL COMMENT Operational Data Store/Execution Result Area/ Execution Detail for Iteration Comment Comments about the plan details of test phase N/A N/A
N/A Plan Details of Test Schedule Date testphase /content/qm:testphase/qm:detail/qm:date N/A RQMTestPhase_Exec_Detail date CALM ITERATION_EXEC_DETAIL EXEC_DATE N/A Execution Detail for Iteration Execution Date Execution data and time of the plan details of test phase in UTC format N/A N/A
N/A Plan Details of Test Schedule Points Attempted testphase /content/qm:testphase/qm:detail/qm:pointsAttempted N/A RQMTestPhase_Exec_Detail pointsAttempted CALM ITERATION_EXEC_DETAIL POINT_ATTEMPTED N/A Execution Detail for Iteration Point Attempted The number of point attempted at the given date of the plan details of test phase N/A N/A
N/A Plan Details of Test Schedule Points Completed testphase /content/qm:testphase/qm:detail/qm:pointsCompleted N/A RQMTestPhase_Exec_Detail pointsCompleted CALM ITERATION_EXEC_DETAIL POINT_COMPLETED N/A Execution Detail for Iteration Point Completed The number of point completed at the given date of the plan details of test phase N/A N/A
N/A Test Schedules of Test Plan Test Schedules testphase /content/qm:testphase/dc:identifier N/A RQMTestPhase_Exec_Detail iteration_uuid CALM ITERATION_EXEC_DETAIL ITERATION_ID N/A Execution Detail for Iteration Iteration ID The MD5 encrypted value of the URL of test phase N/A N/A
N/A Test Schedules of Test Plan Is Deleted testphase /qm:archived N/A RQMTestPhase_Exec_Detail isSoftDeleted CALM ITERATION_EXEC_DETAIL ISSOFTDELETED N/A Execution Detail for Iteration Is Deleted The test phase is archived or not 0: not deleted, 1: deleted N/A

Test Suite Result

Sample Input 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 Output Changes in 4.0
N/A Test Suite Result N/A testsuitelog N/A N/A N/A N/A N/A TESTSUITELOG N/A N/A Test Suite Log N/A Unless otherwise specified in this dictionary, "Test Suite Result" UI elements are expressed by the REST API Resource URL as "testsuitelog"; are stored in the data warehouse "TESTSUITELOG" table; and can be added to report definitions using the "Test Suite Log" Query Subject and related Items. N/A N/A
N/A Test Suite Result N/A testsuitelog /id TestSuiteLog RQMTestSuiteLog itemId ODS TESTSUITELOG EXTERNAL_KEY2 Operational Data Store/Test Suite Area/ Test Suite Log External Key2 The uuid of test suite result N/A N/A
N/A Test Suite Result Actual Result testsuitelog /content/qm:testsuitelog/alm:state N/A RQMTestSuiteLog testsuitelog_state ODS TESTSUITELOG VERDICT N/A Test Suite Log Verdict The actual result id of test suite result but it only get the last word in the id and capitalize the first letter when populate it to DW DB XDC returned value is com.ibm.rqm.execution.common.state.blocked and the value in DB is Blocked N/A
N/A Test Suite Result End Time testsuitelog /content/qm:testsuitelog/testsuitelog:endtime N/A RQMTestSuiteLog endtime ODS TESTSUITELOG END_DATE N/A Test Suite Log End Date The data and time when suite execution ended in UTC format N/A N/A
N/A Test Suite Result Owner testsuitelog /content/qm:testsuitelog/dc:creator N/A RQMTestSuiteLog creator N/A N/A N/A N/A N/A N/A The contributor's registered id that created the test suite result. The creator of test suite result is also the owner of test suite result. N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Test Suite Result Start Time testsuitelog /content/qm:testsuitelog/testsuitelog:starttime N/A RQMTestSuiteLog starttime ODS TESTSUITELOG START_DATE N/A Test Suite Log Start Date The data and time when suite execution started in UTC format N/A N/A
N/A Test Suite Result Name testsuitelog /content/qm:testsuitelog/dc:title N/A RQMTestSuiteLog title ODS TESTSUITELOG NAME N/A Test Suite Log Test Suite Log Name The name of test suite result N/A N/A
N/A Test Suite Result Test Suite Result URL testsuitelog /content/qm:testsuitelog/dc:identifier N/A RQMTestSuiteLog url ODS TESTSUITELOG URL N/A Test Suite Log URL The URL of test suite result N/A N/A
N/A Test Suite Result Test Suite Result testsuitelog /content/qm:testsuitelog/dc:identifier N/A RQMTestSuiteLog uuid ODS TESTSUITELOG EXTERNAL_ID N/A Test Suite Log Test Suite Execution Record ID The MD5 encrypted value of the URL of the test suite execution record of test suite result N/A N/A
N/A Test Suite Result Test Suite Execution Record testsuitelog /content/qm:testsuitelog/qm:suiteexecutionrecord/@qm:href N/A RQMTestSuiteLog tser_uuid ODS TESTSUITELOG TESTSUITE_EXECRECORD_ID N/A Test Suite Log Test Plan ID The MD5 encrypted value of the URL of the test plan of test suite result N/A N/A
N/A Test Suite Result Test Plan testsuitelog /content/qm:testsuitelog/qm:testplan/@qm:href N/A RQMTestSuiteLog testplan_uuid ODS TESTSUITELOG TESTPLAN_ID N/A Test Suite Log External ID The MD5 encrypted value of the URL of test suite result N/A N/A
N/A Test Suite Result Weight testsuitelog /content/qm:testsuitelog/testsuitelog:weight N/A RQMTestSuiteLog weight ODS TESTSUITELOG WEIGHT N/A Test Suite Log Weight An integer measure of the estimated effort to execute the test suite result N/A N/A
N/A Test Suite Result Points Passed testsuitelog /content/qm:testsuitelog/testsuitelog:pointspassed N/A RQMTestSuiteLog points_passed ODS TESTSUITELOG POINTS_PASSED N/A Test Suite Log Points Passed Number of points that were passed N/A N/A
N/A Test Suite Result Points Failed testsuitelog /content/qm:testsuitelog/testsuitelog:pointsfailed N/A RQMTestSuiteLog points_failed ODS TESTSUITELOG POINTS_FAILED N/A Test Suite Log Points Failed Number of points that were failed N/A N/A
N/A Test Suite Result Points Blocked testsuitelog /content/qm:testsuitelog/testsuitelog:pointsblocked N/A RQMTestSuiteLog points_blocked ODS TESTSUITELOG POINTS_BLOCKED N/A Test Suite Log Points Blocked Number of points that were blocked N/A N/A
N/A Test Suite Result Points Inconclusive testsuitelog /content/qm:testsuitelog/testsuitelog:pointsinconclusive N/A RQMTestSuiteLog points_inconclusive ODS TESTSUITELOG POINTS_INCONCLUSIVE N/A Test Suite Log Points Inconclusive Number of points that were inconclusive N/A N/A
N/A Test Suite Result Points Attempted testsuitelog /content/qm:testsuitelog/testsuitelog:pointsattempted N/A RQMTestSuiteLog points_attempted ODS TESTSUITELOG POINTS_ATTEMPTED N/A Test Suite Log Points Attempted Number of points that were attempted N/A N/A
N/A Test Suite Result Is Deleted testsuitelog /qm:archived N/A RQMTestSuiteLog isSoftDeleted ODS TESTSUITELOG ISSOFTDELETED N/A Test Suite Log Is Deleted The test suite result is archived or not 0: not deleted, 1: deleted N/A
N/A Test Suite Result ID testsuitelog /content/qm:testsuitelog/qm:webId N/A RQMTestSuiteLog webId ODS TESTSUITELOG REFERENCE_ID N/A Test Suite Log Reference ID Read-only integer ID of test suite result as seen in the web UI N/A N/A
N/A Test Suite Result Project Area testsuitelog /content/qm:testsuitelog/qm:projectArea/@vega:id N/A RQMTestSuiteLog projectId N/A N/A N/A N/A N/A N/A Actually it should be the uuid of project of the test suite log, but there is no PROJECT_ID column defined in RIODS.TESTSUITELOG table, so ETL does not load it from XDC although defined it in XDC. N/A N/A
N/A Test Suite Result Owner testsuitelog /content/qm:testsuitelog/dc:creator/@rdf:resource N/A RQMTestSuiteLog creator_uuid ODS TESTSUITELOG OWNER_ID N/A Test Suite Log Owner ID The MD5 encrypted value of URI of the contributor that created the test suite result. The creator of test suite result is also the owner of test suite result. N/A N/A
N/A Test Suite Result Iteration testsuitelog /content/qm:testsuitelog/qm:testphase/@qm:href N/A RQMTestSuiteLog testphase_uuid ODS TESTSUITELOG ITERATION_ID N/A Test Suite Log Iteration ID The MD5 encrypted value of URI of the iteration of test suite result N/A N/A
N/A Test Suite Result Build testsuitelog /content/qm:testsuitelog/qm:buildrecord/@qm:href N/A RQMTestSuiteLog buildrecord_uuid ODS TESTSUITELOG BUILD_ID N/A Test Suite Log Build ID The MD5 encrypted value of URI of the build of test suite result N/A Newly added in RQM 4.0.
N/A Test Suite Result Test Suite testsuitelog /content/qm:testsuitelog/qm:testsuite/@qm:href N/A RQMTestSuiteLog testsuite_uuid ODS TESTSUITELOG TESTSUITE_ID N/A Test Suite Log Test Suite ID The MD5 encrypted value of URI of the test suite of test suite result N/A Newly added in RQM 4.0.
N/A Test Suite Result State testsuitelog /content/qm:testsuitelog/alm:processState/@rdf:resource N/A RQMTestSuiteLog approval_state_uuid ODS TESTSUITELOG TESTSUITELOG_STATE_ID N/A Test Suite Log Test Suite Log State External ID The MD5 encrypted value of URI of current state of the test suite result N/A Newly added in RQM 4.0. It is used to look up the value of TESTSUITELOG_STATE_ID column in TESTSUITELOG table, the value of the element in XDC is equal to the Test Suite Log State External ID field of "Test Suite Log" Query Subject in FM.
N/A Test Suite Result Test Suite Result testsuitelog /content/qm:testsuitelog/dc:identifier N/A RQMSuiteLog_CustomAttribute testSuiteLog_uuid CALM TESTSUITELOG_STRING_EXT TESTSUITELOG_ID N/A Test Suite Log External ID The MD5 encrypted value of the URL of test suite result N/A N/A
N/A Test Suite Result Test Suite Result testsuitelog /content/qm:testsuitelog/dc:identifier N/A RQMSuiteLog_CustomAttribute testSuiteLog_uuid CALM TESTSUITELOG_STRING_M_EXT TESTSUITELOG_ID N/A Test Suite Log External ID The MD5 encrypted value of the URL of test suite result N/A N/A
N/A Test Suite Result Test Suite Result testsuitelog /content/qm:testsuitelog/dc:identifier N/A RQMSuiteLog_CustomAttribute testSuiteLog_uuid CALM TESTSUITELOG_INT_EXT TESTSUITELOG_ID N/A Test Suite Log External ID The MD5 encrypted value of the URL of test suite result N/A N/A
N/A Test Suite Result Test Suite Result testsuitelog /content/qm:testsuitelog/dc:identifier N/A RQMSuiteLog_CustomAttribute testSuiteLog_uuid CALM TESTSUITELOG_TIMESTAMP_EXT TESTSUITELOG_ID N/A Test Suite Log External ID The MD5 encrypted value of the URL of test suite result N/A N/A
N/A Test Suite Result N/A testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMSuiteLog_CustomAttribute identifier CALM TESTSUITELOG_STRING_EXT IDENTIFIER N/A Test Suite Log String Extension Identifying name The identifier of small text custom attribute of test suite result N/A N/A
N/A Test Suite Result N/A testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMSuiteLog_CustomAttribute identifier CALM TESTSUITELOG_STRING_M_EXT IDENTIFIER N/A Test Suite Log Medium String Extension Identifying name The identifier of medium text custom attribute of test suite result N/A N/A
N/A Test Suite Result N/A testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMSuiteLog_CustomAttribute identifier CALM TESTSUITELOG_INT_EXT IDENTIFIER N/A Test Suite Log Integer Extension Identifying name The identifier of integer custom attribute of test suite result N/A N/A
N/A Test Suite Result N/A testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMSuiteLog_CustomAttribute identifier CALM TESTSUITELOG_TIMESTAMP_EXT IDENTIFIER N/A Test Suite Log Timestamp Extension Identifying name The identifier of date/time custom attribute of test suite result N/A N/A
N/A Test Suite Result Attributes Type testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/@qm:type N/A RQMSuiteLog_CustomAttribute type N/A N/A N/A N/A N/A N/A The type of custom attribute of test suite result, there are 4 types, SMALL_STRING, MEDIUM_STRING, INTEGER, TIMESTAMP 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. N/A
N/A Test Suite Result Attributes Custom Attribute Name testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:name N/A RQMSuiteLog_CustomAttribute name CALM TESTSUITELOG_STRING_EXT NAME N/A Test Suite Log String Extension Name The name of small text custom attribute of test suite result N/A N/A
N/A Test Suite Result Attributes Custom Attribute Name testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:name N/A RQMSuiteLog_CustomAttribute name CALM TESTSUITELOG_STRING_M_EXT NAME N/A Test Suite Log Medium String Extension Name The name of medium text custom attribute of test suite result N/A N/A
N/A Test Suite Result Attributes Custom Attribute Name testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:name N/A RQMSuiteLog_CustomAttribute name CALM TESTSUITELOG_INT_EXT NAME N/A Test Suite Log Integer Extension Name The name of integer custom attribute of test suite result N/A N/A
N/A Test Suite Result Attributes Custom Attribute Name testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:name N/A RQMSuiteLog_CustomAttribute name CALM TESTSUITELOG_TIMESTAMP_EXT NAME N/A Test Suite Log Timestamp Extension Name The name of date/time custom attribute of test suite result N/A N/A
N/A Test Suite Result Attributes Custom Attribute Value testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:value N/A RQMSuiteLog_CustomAttribute value CALM TESTSUITELOG_STRING_EXT VAR N/A Test Suite Log String Extension Value The value of small text custom attribute of test suite result N/A N/A
N/A Test Suite Result Attributes Custom Attribute Value testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:value N/A RQMSuiteLog_CustomAttribute value CALM TESTSUITELOG_STRING_M_EXT VAR N/A Test Suite Log Medium String Extension Value The value of medium text custom attribute of test suite result N/A N/A
N/A Test Suite Result Attributes Custom Attribute Value testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:value N/A RQMSuiteLog_CustomAttribute value CALM TESTSUITELOG_INT_EXT VAR N/A Test Suite Log Integer Extension Value The string type value of integer custom attribute of test suite result N/A N/A
N/A Test Suite Result Attributes Custom Attribute Value testsuitelog /content/qm:testsuitelog/qm:customAttributes/qm:customAttribute/qm:value N/A RQMSuiteLog_CustomAttribute timeValue CALM TESTSUITELOG_TIMESTAMP_EXT VAR N/A Test Suite Log Timestamp Extension Value The string type value of date/time custom attribute of test suite result N/A N/A
N/A Test Suite Result Is Deleted testsuitelog /qm:archived N/A RQMSuiteLog_CustomAttribute isSoftDeleted CALM TESTSUITELOG_STRING_EXT ISSOFTDELETED N/A Test Suite Log String Extension Is Deleted The test suite result is archived or not 0: not deleted, 1: deleted N/A
N/A Test Suite Result Is Deleted testsuitelog /qm:archived N/A RQMSuiteLog_CustomAttribute isSoftDeleted CALM TESTSUITELOG_STRING_M_EXT ISSOFTDELETED N/A Test Suite Log Medium String Extension Is Deleted The test suite result is archived or not 0: not deleted, 1: deleted N/A
N/A Test Suite Result Is Deleted testsuitelog /qm:archived N/A RQMSuiteLog_CustomAttribute isSoftDeleted CALM TESTSUITELOG_INT_EXT ISSOFTDELETED N/A Test Suite Log Integer Extension Is Deleted The test suite result is archived or not 0: not deleted, 1: deleted N/A
N/A Test Suite Result Is Deleted testsuitelog /qm:archived N/A RQMSuiteLog_CustomAttribute isSoftDeleted CALM TESTSUITELOG_TIMESTAMP_EXT ISSOFTDELETED N/A Test Suite Log Timestamp Extension Is Deleted The test suite result is archived or not 0: not deleted, 1: deleted N/A
N/A Test Suite Result Test Suite Result testsuitelog /content/qm:testsuitelog/dc:identifier N/A RQMSuiteLog_Relationships uuid ODS TESTSUITE_TESTSUITELOG_LOOKUP TESTSUITELOG_ID N/A Test Suite Log External ID The MD5 encrypted value of the URL of test suite result N/A N/A
N/A Test Suite Result Test Suite Result testsuitelog /content/qm:testsuitelog/dc:identifier N/A RQMSuiteLog_Relationships uuid ODS TESTSUITELOG_EXECRESULT_LOOKUP TESTSUITELOG_ID N/A Test Suite Log External ID The MD5 encrypted value of the URL of test suite result N/A N/A
N/A Test Suite Result Test Suite Result testsuitelog /content/qm:testsuitelog/dc:identifier N/A RQMSuiteLog_Relationships uuid ODS TESTSUITELOG_CATEGORY_LOOKUP TESTSUITELOG_ID N/A Test Suite Log External ID The MD5 encrypted value of the URL of test suite result N/A N/A
N/A Test Suite Result Test Suite Execution Record testsuitelog /content/qm:testsuitelog/qm:suiteexecutionrecord/@qm:href N/A RQMSuiteLog_Relationships tser_uuid N/A N/A N/A N/A N/A N/A The MD5 encrypted value of the URL of the test suite execution record of test suite result. In there, it uses the value to lookup the test suite execution record then return the TESTSUITE_ID of the test suite result and populate TESTSUITE_ID into RIODS.TESTSUITE_TESTSUITELOG table. N/A N/A
N/A Test Suite Result Test Case Results testsuitelog /content/qm:testsuitelog/qm:executionresult/@qm:href N/A RQMSuiteLog_Relationships executionresult_uuid ODS TESTSUITELOG_EXECRESULT_LOOKUP EXECUTION_RESULT_ID N/A Test Suite Log Related Execution Results External ID The MD5 encrypted value of URI of the test case results of test suite result N/A N/A
N/A Test Suite Result Category value testsuitelog /content/qm:testsuitelog/qm:category/@qm:valueUUID N/A RQMSuiteLog_Relationships valueUUID ODS TESTSUITELOG_CATEGORY_LOOKUP TEST_CATEGORY_ID N/A Test Suite Log Related Test Categories External Key2 The uuid of category value of test suite result N/A N/A
N/A Test Suite Result Test Suite testsuitelog /content/qm:testsuitelog/qm:testsuite/@qm:href N/A RQMSuiteLog_Relationships testsuite_uuid ODS TESTSUITELOG TESTSUITE_ID N/A Test Suite Log Test Suite ID The MD5 encrypted value of URI of the test suite of test suite result N/A Newly added in RQM 4.0. The field defined in this XDC Data Mapping Table is used for 4.0 ETL migration job.
N/A Test Suite Result State testsuitelog /content/qm:testsuitelog/alm:processState/@rdf:resource N/A RQMSuiteLog_Relationships approval_state_uuid ODS TESTSUITELOG TESTSUITELOG_STATE_ID N/A Test Suite Log Test Suite Log State External ID The MD5 encrypted value of URI of current state of the test suite result N/A Newly added in RQM 4.0. The field defined in this XDC Data Mapping Table is used for 4.0 ETL migration job.

Test Case Execution Record

Sample Input 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 Output Changes in 4.0
N/A 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
N/A Test Case Execution Record 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 Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
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
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
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
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
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
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 XDC returned value is com.ibm.rqm.execution.common.state.blocked and the value in DB is Blocked N/A
N/A Test Case Execution Record Last Result 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
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
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
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 Acceptable values are: "literal.priority.101", "literal.priority.110", "literal.priority.120" and "literal.priority.130" for unassigned, low, medium and high priority respectively N/A
N/A Test Case Execution Record Last Modified executionworkitem /content/qm:executionworkitem/alm: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
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
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
N/A Test Case Execution Record Test Execution Record 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
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
N/A Test Case Execution Record 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 There is no ITERATION_ID column defined in EXECUTION_WORKITEM table, so it is not loaded the value from this data mapping table but loaded from RQMEWI_Relationships and deliver to EXECWORKITEM_ITERATION_LOOKUP table.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
N/A Test Case Execution Record 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 Newly added in RQM 4.0.
N/A Test Case Execution Record 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 Newly added in RQM 4.0.
N/A Test Case Execution Record 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 Newly added in RQM 4.0.
N/A Test Case Execution Record 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 Newly added in RQM 4.0.
N/A Test Case Execution Record 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 Newly added in RQM 4.0.
N/A Test Case Execution Record Attributes 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 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. Newly added in RQM 4.0.
N/A Test Case Execution Record Attributes 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 Newly added in RQM 4.0.
N/A Test Case Execution Record Attributes Custom Attribute Name executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:name N/A RQMEWI_Relationships name 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 Newly added in RQM 4.0.
N/A Test Case Execution Record Attributes Custom Attribute Name executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:name N/A RQMEWI_Relationships name 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 Newly added in RQM 4.0.
N/A Test Case Execution Record Attributes Custom Attribute Name executionworkitem /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:name N/A RQMEWI_Relationships name 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 Newly added in RQM 4.0.
N/A Test Case Execution Record Attributes 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 Newly added in RQM 4.0.
N/A Test Case Execution Record Attributes 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 Newly added in RQM 4.0.
N/A Test Case Execution Record Attributes 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 Newly added in RQM 4.0.
N/A Test Case Execution Record Attributes 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 Newly added in RQM 4.0.
N/A Test Case Execution Record 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 0: not deleted, 1: deleted Newly added in RQM 4.0.
N/A Test Case Execution Record 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 0: not deleted, 1: deleted Newly added in RQM 4.0.
N/A Test Case Execution Record 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 0: not deleted, 1: deleted Newly added in RQM 4.0.
N/A Test Case Execution Record 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 0: not deleted, 1: deleted Newly added in RQM 4.0.

Test Case Result

Sample Input 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 Output Changes in 4.0
N/A Test Case Result N/A executionresult N/A N/A N/A N/A N/A EXECUTION_RESULT N/A N/A Execution Result N/A Unless otherwise specified in this dictionary, "Test Case Result" UI elements are expressed by the REST API Resource URL as "executionresult"; are stored in the data warehouse "EXECUTION_RESULT" table; and can be added to report definitions using the "Execution Result" Query Subject and related Items. N/A N/A
N/A Test Case Result Build executionresult /content/qm:executionresult/executionresult:buildid ExecutionResult RQMExecutionResult build N/A N/A N/A Operational Data Store/Execution Result Area/ N/A N/A The id of the build record of test case result N/A Deprecated
N/A Test Case Result End Time executionresult /content/qm:executionresult/executionresult:endtime N/A RQMExecutionResult endtime ODS EXECUTION_RESULT END_DATE N/A Execution Result End Date The data and time when test case execution ended in UTC format N/A N/A
N/A Test Case Result Host Name executionresult /content/qm:executionresult/executionresult:machine N/A RQMExecutionResult machine ODS EXECUTION_RESULT MACHINE N/A Execution Result Machine The name of the machine that the test was executed on N/A N/A
N/A Test Case Result Points Inconclusive executionresult /content/qm:executionresult/executionresult:pointsinconclusive N/A RQMExecutionResult pointsinconclusive ODS EXECUTION_RESULT POINTS_INCONCLUSIVE N/A Execution Result Points Inconclusive Number of points that were inconclusive N/A N/A
N/A Test Case Result Start Time executionresult /content/qm:executionresult/executionresult:starttime N/A RQMExecutionResult starttime ODS EXECUTION_RESULT START_DATE N/A Execution Result Start Date The data and time when test case execution started in UTC format N/A N/A
N/A Test Case Result Points Attempted executionresult /content/qm:executionresult/executionresult:pointsattempted N/A RQMExecutionResult pointsattempted ODS EXECUTION_RESULT POINTS_ATTEMPTED N/A Execution Result Points Attempted Number of points that were attempted N/A N/A
N/A Test Case Result Points Passed executionresult /content/qm:executionresult/executionresult:pointspassed N/A RQMExecutionResult pointspassed ODS EXECUTION_RESULT POINTS_PASSED N/A Execution Result Points Passed Number of points that were passed N/A N/A
N/A Test Case Result Name executionresult /content/qm:executionresult/dc:title N/A RQMExecutionResult title ODS EXECUTION_RESULT NAME N/A Execution Result Name The name of test case result N/A N/A
N/A Test Case Result Last Modified executionresult /content/qm:executionresult/alm:updated N/A RQMExecutionResult updated ODS EXECUTION_RESULT LAST_UPDATED N/A Execution Result Last Updated The last updated date and time of test case result in UTC format N/A N/A
N/A Test Case Result N/A executionresult /id N/A RQMExecutionResult itemId ODS EXECUTION_RESULT EXTERNAL_KEY2 N/A Execution Result External Key2 The uuid of test case result N/A N/A
N/A Test Case Result State executionresult /content/qm:executionresult/alm:state N/A RQMExecutionResult executionresult_state ODS EXECUTION_RESULT VERDICT N/A Execution Result Verdict The actual result id of test case result but it only get the last word in the id and capitalize the first letter when populate it to DW DB XDC returned value is com.ibm.rqm.execution.common.state.blocked and the value in DB is Blocked N/A
N/A Test Case Result Points Failed executionresult /content/qm:executionresult/executionresult:pointsfailed N/A RQMExecutionResult pointsfailed ODS EXECUTION_RESULT POINTS_FAILED N/A Execution Result Points Failed Number of points that were failed N/A N/A
N/A Test Case Result Owner executionresult /content/qm:executionresult/alm:owner N/A RQMExecutionResult owner N/A N/A N/A N/A N/A N/A The contributor's registered id that owns the test case result N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Test Case Result Points Blocked executionresult /content/qm:executionresult/executionresult:pointsblocked N/A RQMExecutionResult pointsblocked ODS EXECUTION_RESULT POINTS_BLOCKED N/A Execution Result Points Blocked Number of points that were blocked N/A N/A
N/A Test Case Result Points Permfailed executionresult /content/qm:executionresult/qm:pointspermfailed N/A RQMExecutionResult pointspermfailed ODS EXECUTION_RESULT POINTS_PERMFAILED N/A Execution Result Points Perm Failed Number of points that were perm failed N/A N/A
N/A Test Case Result Execution Result URL executionresult /content/qm:executionresult/dc:identifier N/A RQMExecutionResult url ODS EXECUTION_RESULT URL N/A Execution Result URL The URL of test case result N/A N/A
N/A Test Case Result Execution Result executionresult /content/qm:executionresult/dc:identifier N/A RQMExecutionResult uuid ODS EXECUTION_RESULT EXTERNAL_ID N/A Execution Result External ID The MD5 encrypted value of the URL of test case result N/A N/A
N/A Test Case Result Test Script executionresult /content/qm:executionresult/qm:testscript/@qm:href N/A RQMExecutionResult testscript_uuid ODS EXECUTION_RESULT TESTSCRIPT_ID N/A Execution Result Test Script ID The MD5 encrypted value of URI of the manual test script of test case result N/A N/A
N/A Test Case Result Build executionresult /content/qm:executionresult/qm:buildrecord/@qm:href N/A RQMExecutionResult buildrecord_uuid ODS EXECUTION_RESULT BUILD_ID N/A Execution Result Build ID The MD5 encrypted value of URI of the build record of test case result N/A N/A
N/A Test Case Result Test Case executionresult /content/qm:executionresult/qm:testcase/@qm:href N/A RQMExecutionResult testcase_uuid ODS EXECUTION_RESULT TESTCASE_ID N/A Execution Result Test Case ID The MD5 encrypted value of URI of the test case of test case result N/A N/A
N/A Test Case Result Iteration executionresult /content/qm:executionresult/qm:testphase/@qm:href N/A RQMExecutionResult testphase_uuid ODS EXECUTION_RESULT ITERATION_ID N/A Execution Result Iteration ID The MD5 encrypted value of URI of the iteration of test case result N/A N/A
N/A Test Case Result Test Script executionresult /content/qm:executionresult/qm:remotescript/@qm:href N/A RQMExecutionResult remotescript_uuid ODS EXECUTION_RESULT TESTSCRIPT_ID N/A Execution Result Test Script ID The MD5 encrypted value of URI of the remote test script of test case result N/A N/A
N/A Test Case Result N/A executionresult /content/qm:executionresult/qm:testsuitelog/@qm:elementindex N/A RQMExecutionResult suite_index ODS EXECUTION_RESULT SUITE_INDEX N/A Execution Result Suite Index The index of the test case result in a test suite result The value is -1 means the test case result is not in any test suite result. The values larger and equal to 0 is the index of test case result in a test suite result. N/A
N/A Test Case Result N/A executionresult /content/qm:executionresult/qm:creationDate N/A RQMExecutionResult creationDate ODS EXECUTION_RESULT CREATION_DATE N/A Execution Result Creation Date The data and time that created test case execution in UTC format N/A N/A
N/A Test Case Result Is Deleted executionresult /qm:archived N/A RQMExecutionResult isSoftDeleted ODS EXECUTION_RESULT ISSOFTDELETED N/A Execution Result Is Deleted The test case result is archived or not 0: not deleted, 1: deleted N/A
N/A Test Case Result ID executionresult /content/qm:executionresult/qm:webId N/A RQMExecutionResult webId ODS EXECUTION_RESULT REFERENCE_ID N/A Execution Result Reference ID Read-only integer ID of test case result as seen in the web UI N/A N/A
N/A Test Case Result Project Area executionresult /content/qm:executionresult/qm:projectArea/@vega:id N/A RQMExecutionResult projectId ODS EXECUTION_RESULT PROJECT_ID N/A Execution Result Project ID The uuid of project area of the test case result N/A N/A
N/A Test Case Result Owner executionresult /content/qm:executionresult/alm:owner/@rdf:resource N/A RQMExecutionResult owner_uuid ODS EXECUTION_RESULT OWNER_ID N/A Execution Result Owner ID The MD5 encrypted value of URI of the contributor that owns the test case result N/A N/A
N/A Test Case Result Points Deferred executionresult /content/qm:executionresult/qm:pointsdeferred N/A RQMExecutionResult pointsdeferred ODS EXECUTION_RESULT POINTS_DEFERRED N/A Execution Result Points Deferred Number of points that were deferred N/A Newly added in RQM 4.0.
N/A Test Case Result Weight executionresult /content/qm:executionresult/executionresult:weight N/A RQMExecutionResult pointstotal ODS EXECUTION_RESULT POINTS_TOTAL N/A Execution Result Points Total Number of total points of the test case result N/A Newly added in RQM 4.0.
N/A Test Case Result State executionresult /content/qm:executionresult/executionresult:approvalstate/@rdf:resource N/A RQMExecutionResult approval_state_uuid ODS EXECUTION_RESULT EXECRESULT_STATE_ID N/A Execution Result Execution Result State External ID The MD5 encrypted value of URI of current state of the test case result N/A Newly added in RQM 4.0. It is used to look up the value of EXECRESULT_STATE_ID column in EXECUTION_RESULT table, the value of the element in XDC is equal to the Execution Result State External ID field of "Execution Result" Query Subject in FM.
N/A Test Case Result Test Case Result executionresult /content/qm:executionresult/dc:identifier N/A RQMExecResult_CustomAttribute execResult_uuid CALM EXECRES_STRING_EXT EXECUTION_RESULT_ID N/A Execution Result External ID The MD5 encrypted value of the URL of test case result N/A N/A
N/A Test Case Result Test Case Result executionresult /content/qm:executionresult/dc:identifier N/A RQMExecResult_CustomAttribute execResult_uuid CALM EXECRES_STRING_M_EXT EXECUTION_RESULT_ID N/A Execution Result External ID The MD5 encrypted value of the URL of test case result N/A N/A
N/A Test Case Result Test Case Result executionresult /content/qm:executionresult/dc:identifier N/A RQMExecResult_CustomAttribute execResult_uuid CALM EXECRES_INT_EXT EXECUTION_RESULT_ID N/A Execution Result External ID The MD5 encrypted value of the URL of test case result N/A N/A
N/A Test Case Result Test Case Result executionresult /content/qm:executionresult/dc:identifier N/A RQMExecResult_CustomAttribute execResult_uuid CALM EXECRES_TIMESTAMP_EXT EXECUTION_RESULT_ID N/A Execution Result External ID The MD5 encrypted value of the URL of test case result N/A N/A
N/A Test Case Result N/A executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMExecResult_CustomAttribute identifier CALM EXECRES_STRING_EXT IDENTIFIER N/A Execution Result String Extension Identifying name The identifier of small text custom attribute of test case result N/A N/A
N/A Test Case Result N/A executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMExecResult_CustomAttribute identifier CALM EXECRES_STRING_M_EXT IDENTIFIER N/A Execution Result Medium String Extension Identifying name The identifier of medium text custom attribute of test case result N/A N/A
N/A Test Case Result N/A executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMExecResult_CustomAttribute identifier CALM EXECRES_INT_EXT IDENTIFIER N/A Execution Result Integer Extension Identifying name The identifier of integer custom attribute of test case result N/A N/A
N/A Test Case Result N/A executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMExecResult_CustomAttribute identifier CALM EXECRES_TIMESTAMP_EXT IDENTIFIER N/A Execution Result Timestamp Extension Identifying name The identifier of date/time custom attribute of test case result N/A N/A
N/A Test Case Result Attributes Type executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/@qm:type N/A RQMExecResult_CustomAttribute type N/A N/A N/A N/A N/A N/A The type of custom attribute of test case result, there are 4 types, SMALL_STRING, MEDIUM_STRING, INTEGER, TIMESTAMP 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. N/A
N/A Test Case Result Attributes Custom Attribute Name executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:name N/A RQMExecResult_CustomAttribute name CALM EXECRES_STRING_EXT NAME N/A Execution Result String Extension Name The name of small text custom attribute of test case result N/A N/A
N/A Test Case Result Attributes Custom Attribute Name executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:name N/A RQMExecResult_CustomAttribute name CALM EXECRES_STRING_M_EXT NAME N/A Execution Result Medium String Extension Name The name of medium text custom attribute of test case result N/A N/A
N/A Test Case Result Attributes Custom Attribute Name executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:name N/A RQMExecResult_CustomAttribute name CALM EXECRES_INT_EXT NAME N/A Execution Result Integer Extension Name The name of integer custom attribute of test case execution record N/A N/A
N/A Test Case Result Attributes Custom Attribute Name executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:name N/A RQMExecResult_CustomAttribute name CALM EXECRES_TIMESTAMP_EXT NAME N/A Execution Result Timestamp Extension Name The name of date/time custom attribute of test case result N/A N/A
N/A Test Case Result Attributes Custom Attribute Value executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:value N/A RQMExecResult_CustomAttribute value CALM EXECRES_STRING_EXT VAR N/A Execution Result String Extension Value The value of small text custom attribute of test case result N/A N/A
N/A Test Case Result Attributes Custom Attribute Value executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:value N/A RQMExecResult_CustomAttribute value CALM EXECRES_STRING_M_EXT VAR N/A Execution Result Medium String Extension Value The value of medium text custom attribute of test case result N/A N/A
N/A Test Case Result Attributes Custom Attribute Value executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:value N/A RQMExecResult_CustomAttribute value CALM EXECRES_INT_EXT VAR N/A Execution Result Integer Extension Value The string type value of integer custom attribute of test case result N/A N/A
N/A Test Case Result Attributes Custom Attribute Value executionresult /content/qm:executionresult/qm:customAttributes/qm:customAttribute/qm:value N/A RQMExecResult_CustomAttribute timeValue CALM EXECRES_TIMESTAMP_EXT VAR N/A Execution Result Timestamp Extension Value The string type value of date/time custom attribute of test case result N/A N/A
N/A Test Case Result Is Deleted executionresult /qm:archived N/A RQMExecResult_CustomAttribute isSoftDeleted CALM EXECRES_STRING_EXT ISSOFTDELETED N/A Execution Result String Extension Is Deleted The test case result is archived or not 0: not deleted, 1: deleted N/A
N/A Test Case Result Is Deleted executionresult /qm:archived N/A RQMExecResult_CustomAttribute isSoftDeleted CALM EXECRES_STRING_M_EXT ISSOFTDELETED N/A Execution Result Medium String Extension Is Deleted The test case result is archived or not 0: not deleted, 1: deleted N/A
N/A Test Case Result Is Deleted executionresult /qm:archived N/A RQMExecResult_CustomAttribute isSoftDeleted CALM EXECRES_INT_EXT ISSOFTDELETED N/A Execution Result Integer Extension Is Deleted The test case result is archived or not 0: not deleted, 1: deleted N/A
N/A Test Case Result Is Deleted executionresult /qm:archived N/A RQMExecResult_CustomAttribute isSoftDeleted CALM EXECRES_TIMESTAMP_EXT ISSOFTDELETED N/A Execution Result Timestamp Extension Is Deleted The test case result is archived or not 0: not deleted, 1: deleted N/A
N/A Test Case Result Test Case Result executionresult /content/qm:executionresult/dc:identifier N/A RQMExecResult_Relationships uuid ODS EXECRES_EXECWKITEM_LOOKUP EXECUTION_RESULT_ID N/A Execution Result External ID The MD5 encrypted value of the URL of test case result N/A N/A
N/A Test Case Result Test Case Result executionresult /content/qm:executionresult/dc:identifier N/A RQMExecResult_Relationships uuid ODS EXECRES_REQUEST_LOOKUP EXECUTION_RESULT_ID N/A Execution Result External ID The MD5 encrypted value of the URL of test case result N/A N/A
N/A Test Case Result Test Case Result executionresult /content/qm:executionresult/dc:identifier N/A RQMExecResult_Relationships uuid ODS EXECRESULT_CATEGORY_LOOKUP EXECUTION_RESULT_ID N/A Execution Result External ID The MD5 encrypted value of the URL of test case result N/A N/A
N/A Test Case Result Test Case Execution Record executionresult /content/qm:executionresult/qm:executionworkitem/@qm:href N/A RQMExecResult_Relationships ewi_uuid ODS EXECRES_EXECWKITEM_LOOKUP EXECWORKITEM_ID N/A Execution Result Related Execution Work Items External ID The MD5 encrypted value of URI of test case execution record of the test case result N/A N/A
N/A Test Case Result Defect executionresult /content/qm:executionresult/qm:defect/@qm:href N/A RQMExecResult_Relationships defect_uuid ODS EXECRES_REQUEST_LOOKUP REQUEST_ID N/A Execution Result Related Requests External ID The MD5 encrypted value of URI of defect of the test case result N/A N/A
N/A Test Case Result Defect URL executionresult /content/qm:executionresult/qm:defect/@qm:href N/A RQMExecResult_Relationships defect_url ODS EXECRES_REQUEST_LOOKUP REQUEST_ID N/A Execution Result Related Requests URL The URL of the defects of test case result. It is used to look up for Clear Quest Requests. N/A N/A
N/A Test Case Result Category Value executionresult /content/qm:executionresult/qm:category/@qm:valueUUID N/A RQMExecResult_Relationships valueUUID ODS EXECRESULT_CATEGORY_LOOKUP TEST_CATEGORY_ID N/A Execution Result Related Test Categories External Key2 The uuid of category value of test case result N/A Newly added in RQM 4.0.
N/A Test Case Result Weight executionresult /content/qm:executionresult/executionresult:weight N/A RQMExecResult_Relationships pointstotal ODS EXECUTION_RESULT POINTS_TOTAL N/A Execution Result Points Total Number of total points of the test case result N/A Newly added in RQM 4.0. The field defined in this XDC Data Mapping Table is used for 4.0 ETL migration job.
N/A Test Case Result Related Defects OSLC linking type executionresult /content/qm:executionresult/qm:defect/@qm:rel N/A RQMExecResult_Relationships defect_rel ODS EXECRES_REQUEST_LOOKUP LINK_TYPE N/A Execution Result Related Requests Link Type The RQM named linking type of request and test case result affectedBy: The unified OSLC linking type is com.ibm.clm.affectsTestResult. Newly added in RQM 4.0.
N/A Test Case Result State executionresult /content/qm:executionresult/executionresult:approvalstate/@rdf:resource N/A RQMExecResult_Relationships state_uuid ODS EXECUTION_RESULT EXECRESULT_STATE_ID N/A Execution Result Execution Result State External ID The MD5 encrypted value of URI of current state of the test case result N/A Newly added in RQM 4.0. It is used to look up the value of EXECRESULT_STATE_ID column in EXECUTION_RESULT table, the value of the element in XDC is equal to the Execution Result State External ID field of "Execution Result" Query Subject in FM.

Test Case Result's Result Details

Sample Input 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 Output Changes in 4.0
N/A Test Case Result's Result Details N/A executionresult N/A N/A N/A N/A N/A EXECUTION_STEP_RESULT N/A N/A Execution Step Result N/A Unless otherwise specified in this dictionary, "Test Case Result's Result Details" UI elements are expressed by the REST API Resource URL as "executionresult"; are stored in the data warehouse "EXECUTION_STEP_RESULT" table; and can be added to report definitions using the "Execution Step Result" Query Subject and related Items. N/A N/A
N/A Test Case Result's Result Details Test Case Result executionresult /content/qm:executionresult/dc:identifier ExecutionResultSteps RQMExecResult_Step execResult_uuid ODS EXECUTION_STEP_RESULT EXECUTION_RESULT_ID Operational Data Store/Execution Result Area/ Execution Step Result Execution Result ID The MD5 encrypted value of URI of test case result of the test case execution step result N/A Deprecated
N/A Test Case Result's Result Details N/A executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/@vega:id N/A RQMExecResult_Step stepResult_itemId ODS EXECUTION_STEP_RESULT EXTERNAL_KEY2 N/A Execution Step Result External Key2 The uuid of the test case execution step result N/A N/A
N/A Test Case Result's Result Details N/A executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/@vega:id N/A RQMExecResult_Step stepResult_itemId ODS EXECSTEPRES_REQUEST_LOOKUP EXECUTION_STEP_RESULT_ID N/A Execution Step Result External Key2 The uuid of the test case execution step result N/A N/A
N/A Test Case Result's Result Details N/A executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/er:startTime N/A RQMExecResult_Step startTime ODS EXECUTION_STEP_RESULT START_TIME N/A Execution Step Result Start Time The data and time when test step execution started in UTC format N/A N/A
N/A Test Case Result's Result Details N/A executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/er:endTime N/A RQMExecResult_Step endTime ODS EXECUTION_STEP_RESULT END_TIME N/A Execution Step Result End Time The data and time when test step execution ended in UTC format N/A N/A
N/A Test Case Result's Result Details Description executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/er:description N/A RQMExecResult_Step description ODS EXECUTION_STEP_RESULT START_DATE N/A Execution Step Result Description The description of the test case execution step result N/A N/A
N/A Test Case Result's Result Details Type executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/er:stepType N/A RQMExecResult_Step stepType ODS EXECUTION_STEP_RESULT STEP_TYPE N/A Execution Step Result Step Type The step type of the test case execution step result com.ibm.rqm.execution.common.elementtype.execution: It is test script step. com.ibm.rqm.execution.common.elementtype.keyword: It is a keyword. N/A
N/A Test Case Result's Result Details Comment executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/er:comment N/A RQMExecResult_Step comment ODS EXECUTION_STEP_RESULT NAME N/A Execution Step Result Name The comment of the test case execution step result N/A N/A
N/A Test Case Result's Result Details Result executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/er:result N/A RQMExecResult_Step result ODS EXECUTION_STEP_RESULT RESULT N/A Execution Step Result Result The actual result id of test step execution but it only get the last word in the id and capitalize the first letter when populate it to DW DB XDC returned value is com.ibm.rqm.execution.common.state.blocked and the value in DB is Blocked N/A
N/A Test Case Result's Result Details Expected Results executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/er:expectedResult N/A RQMExecResult_Step expectedResult ODS EXECUTION_STEP_RESULT EXPECTED_RESULT N/A Execution Step Result Expected Result The expected result of the test case execution step result N/A N/A
N/A Test Case Result's Result Details Actual Results executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/er:actualResult N/A RQMExecResult_Step actualResult ODS EXECUTION_STEP_RESULT ACTUAL_RESULT N/A Execution Step Result Actual Result The actual result of the test case execution step result N/A N/A
N/A Test Case Result's Result Details Is Deleted executionresult /qm:archived N/A RQMExecResult_Step isSoftDeleted ODS EXECUTION_STEP_RESULT ISSOFTDELETED N/A Execution Step Result Is deleted The test case result is archived or not 0: not deleted, 1: deleted N/A
N/A Test Case Result's Result Details Defect executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/er:defect/@er:href N/A RQMExecResult_Step request_uuid ODS EXECSTEPRES_REQUEST_LOOKUP REQUEST_ID N/A Execution Step Results Related Requests External ID The MD5 encrypted value of URI of defect of the test case execution step result N/A N/A
N/A Test Case Result's Result Details Defect URL executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/er:defect/@er:href N/A RQMExecResult_Step request_url ODS EXECSTEPRES_REQUEST_LOOKUP REQUEST_ID N/A Execution Step Results Related Requests URL The URL of the defects of test case execution step result. It is used to look up for Clear Quest Requests. N/A N/A
N/A Test Case Result's Result Details Related Defects OSLC linking type executionresult /content/qm:executionresult/executionresult:stepResults/er:stepResult/er:defect/@er:rel N/A RQMExecResult_Step request_rel ODS EXECSTEPRES_REQUEST_LOOKUP LINK_TYPE N/A Execution Step Results Related Requests Link Type The RQM named linking type of request and test case result affectedBy: The unified OSLC linking type is com.ibm.clm.affectsTestResult. Newly added in RQM 4.0.

Defect / Work Item

Sample Input 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 Output Changes in 4.0
N/A Defect / Work Item N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
N/A N/A Deprecated in RQM301 N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A

Lab Resource

Sample Input 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 Output Changes in 4.0
N/A Lab Resource N/A labresource N/A N/A N/A N/A N/A LAB_RESOURCE N/A N/A Lab Resource N/A Unless otherwise specified in this dictionary, "Lab Resource" UI elements are expressed by the REST API Resource URL as "labresource"; are stored in the data warehouse "LAB_RESOURCE" table; and can be added to report definitions using the "Lab Resource" Query Subject and related Items. N/A N/A
N/A Lab Resource Primary Mac Address labresource /content/qm:labresource/qm:primaryMacAddress LabResource RQMLabResource primaryMacAddress ODS LAB_RESOURCE PRIMARY_MAC_ADDRESS Operational Data Store/Resource Area/ Lab Resource Primary Mac Address The hardware address of the L2 interface N/A N/A
N/A Lab Resource CPU Architecture labresource /content/qm:labresource/qm:cpuArchitecture N/A RQMLabResource cpuArchitecture ODS LAB_RESOURCE CPU_ARCHITECTURE N/A Lab Resource CPU Architecture The cpu architecture N/A N/A
N/A Lab Resource CPU Type labresource /content/qm:labresource/qm:cpuType N/A RQMLabResource cpuType ODS LAB_RESOURCE CPU_TYPE N/A Lab Resource CPU Type The cpu type N/A N/A
N/A Lab Resource CPU Manufacturer labresource /content/qm:labresource/qm:cpuManufacturer N/A RQMLabResource cpuManufacturer N/A N/A N/A N/A N/A N/A The name of the manufacturer of the cpu chip N/A N/A
N/A Lab Resource Operational Status labresource /content/qm:labresource/qm:operationalStatus N/A RQMLabResource operationalStatus ODS LAB_RESOURCE OPERATIONAL_STATUS N/A Lab Resource Operational Status The operational status of the lab resource One of [available, unavailable, unknown] N/A
N/A Lab Resource Memory labresource /content/qm:labresource/qm:memory N/A RQMLabResource memory ODS LAB_RESOURCE MEMORY N/A Lab Resource Memory The amount of installed memory in MB N/A N/A
N/A Lab Resource OS Locale labresource /content/qm:labresource/qm:osLocale N/A RQMLabResource osLocale ODS LAB_RESOURCE OS_LOCALE N/A Lab Resource OS Locale The locale of the lab resource N/A N/A
N/A Lab Resource IP Address labresource /content/qm:labresource/qm:ipAddress N/A RQMLabResource ipAddress ODS LAB_RESOURCE IP_ADDRESS N/A Lab Resource IP Address The ip address in dotted notation Physical Machine, Virtual Machine and Virtual Image N/A
N/A Lab Resource Name labresource /content/qm:labresource/qm:name N/A RQMLabResource name ODS LAB_RESOURCE LAB_RESOURCE_NAME N/A Lab Resource Lab Resource Name The name of lab resource N/A N/A
N/A Lab Resource Lab Resource Type labresource /content/qm:labresource/qm:type N/A RQMLabResource labresource_type ODS LAB_RESOURCE LAB_RESOURCE_TYPE N/A Lab Resource Lab Resource Type The type of the lab resource. This is a reference to a lab attribute catalog type. If this is not supplied, the text within the element will be used to identify the catalog type by its external id N/A N/A
N/A Lab Resource Disk space labresource /content/qm:labresource/qm:diskspace N/A RQMLabResource diskspace ODS LAB_RESOURCE DISK_SPACE N/A Lab Resource Disk Space The amount of diskspace on the resource in GB N/A N/A
N/A Lab Resource OS Type labresource /content/qm:labresource/qm:osType N/A RQMLabResource osType ODS LAB_RESOURCE OS_TYPE N/A Lab Resource OS Type The operating system. This must be selected from one of the types know to the LM system N/A N/A
N/A Lab Resource Hostname labresource /content/qm:labresource/qm:hostname N/A RQMLabResource hostname ODS LAB_RESOURCE HOSTNAME N/A Lab Resource Host Name The hostname of the lab resource N/A N/A
N/A Lab Resource System Id labresource /content/qm:labresource/qm:systemId N/A RQMLabResource systemId N/A N/A N/A N/A N/A N/A The system ID N/A N/A
N/A Lab Resource CPU Architecture Width labresource /content/qm:labresource/qm:cpuArchitectureWidth N/A RQMLabResource cpuArchitectureWidth ODS LAB_RESOURCE CPU_ARCHITECTURE_WIDTH N/A Lab Resource CPU Architecture Width The architecture width of the CPU One of [31 bit, 32 bit, 64 bit] N/A
N/A Lab Resource Fully Qualified Domain Name labresource /content/qm:labresource/qm:fullyQualifiedDomainName N/A RQMLabResource fullyQualifiedDomainName ODS LAB_RESOURCE FULLY_QUALIFIED_DOMAIN_NAME N/A Lab Resource Fully Qualified Domain Name The fully qualified domain name of the lab resource in dotted notation N/A N/A
N/A Lab Resource CPU Speed labresource /content/qm:labresource/qm:cpuSpeed N/A RQMLabResource cpuSpeed ODS LAB_RESOURCE CPU_SPEED N/A Lab Resource CPU Speed The processing speed of the cpu N/A N/A
N/A Lab Resource Administrative Status labresource /content/qm:labresource/qm:administrativeStatus N/A RQMLabResource administrativeStatus ODS LAB_RESOURCE ADMINISTRATIVE_STATUS N/A Lab Resource Administrative Status The administrative status of the lab resource One of [enabled, disabled, other, unknown] N/A
N/A Lab Resource OS Kernel Width labresource /content/qm:labresource/qm:osKernelWidth N/A RQMLabResource osKernelWidth ODS LAB_RESOURCE OS_KERNEL_WIDTH N/A Lab Resource OS Kernel Width The width of the perating system kernel One of [31 bit, 32 bit, 64 bit] N/A
N/A Lab Resource Resource group ID labresource /content/qm:labresource/qm:resourcegroup/@vega:id N/A RQMLabResource resourcegroup_id N/A N/A N/A N/A N/A N/A Read-Only UUID of the resource group N/A Deprecated
N/A Lab Resource Name labresource /content/qm:labresource/qm:title N/A RQMLabResource title ODS LAB_RESOURCE NAME N/A Lab Resource Name The name of lab resource N/A N/A
N/A Lab Resource N/A labresource /id N/A RQMLabResource itemId ODS LAB_RESOURCE EXTERNAL_KEY2 N/A Lab Resource External Key2 The uuid of lab resource N/A N/A
N/A Lab Resource Software labresource /content/qm:labresource/qm:software/qm:softwareInstall/@qm:name N/A RQMLabResource software ODS LAB_RESOURCE SOFTWARE N/A Lab Resource Software The name of the softwareInstall N/A N/A
N/A Lab Resource Lab Resource URL labresource /content/qm:labresource/dc:identifier N/A RQMLabResource url ODS LAB_RESOURCE URL N/A Lab Resource URL The URL of lab resource N/A N/A
N/A Lab Resource Lab Resource labresource /content/qm:labresource/dc:identifier N/A RQMLabResource uuid ODS LAB_RESOURCE EXTERNAL_ID N/A Lab Resource External ID The MD5 encrypted value of URL of lab resource N/A N/A
N/A Lab Resource Resource Group labresource /content/qm:labresource/qm:resourcegroup/@qm:href N/A RQMLabResource resourcegroup_uuid ODS LAB_RESOURCE RESOURCE_GROUP_ID N/A Lab Resource Resource Group ID The MD5 encrypted value of URI of the resource group of lab resource N/A N/A
N/A Lab Resource Is Deleted labresource /qm:archived N/A RQMLabResource isSoftDeleted ODS LAB_RESOURCE ISSOFTDELETED N/A Lab Resource Is Deleted The lab resource is archived or not 0: not deleted, 1: deleted N/A
N/A Lab Resource Project Area labresource /content/qm:labresource/qm:projectArea/@vega:id N/A RQMLabResource projectId ODS LAB_RESOURCE PROJECT_ID N/A Lab Resource Project ID The uuid of project area of the lab resource N/A N/A

Lab Resource Group

Sample Input 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 Output Changes in 4.0
N/A Lab Resource Group N/A resourcegroup N/A N/A N/A N/A N/A RESOURCE_GROUP N/A N/A Resource Group N/A Unless otherwise specified in this dictionary, "Lab Resource Group" UI elements are expressed by the REST API Resource URL as "resourcegroup"; are stored in the data warehouse "RESOURCE_GROUP" table; and can be added to report definitions using the "Resource Group" Query Subject and related Items. N/A N/A
N/A Lab Resource Group No Expiration resourcegroup /content/qm:resourcegroup/qm:isExpireable ResourceGroup RQMResourceGroup isExpireable ODS RESOURCE_GROUP IS_EXPIREABLE Operational Data Store/Resource Area/ Resource Group Is Expireable Determines if the group will expire or not N/A N/A
N/A Lab Resource Group Expiration Date resourcegroup /content/qm:resourcegroup/qm:expirationdate N/A RQMResourceGroup expirationdate ODS RESOURCE_GROUP EXPIRATION_DATE N/A Resource Group Expiration Date Date and time that the group expires in UTC format N/A N/A
N/A Lab Resource Group Name resourcegroup /content/qm:resourcegroup/qm:name N/A RQMResourceGroup name ODS RESOURCE_GROUP NAME N/A Resource Group Name The name of the resource group N/A N/A
N/A Lab Resource Group Start Date resourcegroup /content/qm:resourcegroup/qm:startDate N/A RQMResourceGroup startDate ODS RESOURCE_GROUP START_DATE N/A Resource Group Start Date Date and time that the group becomes active in UTC format N/A N/A
N/A Lab Resource Group N/A resourcegroup /id N/A RQMResourceGroup itemId ODS RESOURCE_GROUP EXTERNAL_KEY2 N/A Resource Group External Key2 The uuid of resource group N/A N/A
N/A Lab Resource Group Resource Group URL resourcegroup /content/qm:resourcegroup/dc:identifier N/A RQMResourceGroup url ODS RESOURCE_GROUP URL N/A Resource Group URL The URL of resource group N/A N/A
N/A Lab Resource Group Resource Group resourcegroup /content/qm:resourcegroup/dc:identifier N/A RQMResourceGroup uuid ODS RESOURCE_GROUP EXTERNAL_ID N/A Resource Group External ID The MD5 encrypted value of URL of resource group N/A N/A
N/A Lab Resource Group Is Deleted resourcegroup /qm:archived N/A RQMResourceGroup isSoftDeleted ODS RESOURCE_GROUP ISSOFTDELETED N/A Resource Group Is Deleted The resource group is archived or not 0: not deleted, 1: deleted N/A
N/A Lab Resource Group Project Area resourcegroup /content/qm:resourcegroup/qm:projectArea/@vega:id N/A RQMResourceGroup projectId ODS RESOURCE_GROUP PROJECT_ID N/A Resource Group Project ID The uuid of project area of the resource group N/A N/A

Reservation

Sample Input 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 Output Changes in 4.0
N/A Reservation N/A reservation N/A N/A N/A N/A N/A RESERVATION N/A N/A Reservation N/A Unless otherwise specified in this dictionary, "Reservation" UI elements are expressed by the REST API Resource URL as "reservation"; are stored in the data warehouse "RESERVATION" table; and can be added to report definitions using the "Reservation" Query Subject and related Items. N/A N/A
N/A Reservation Reserve From reservation /content/qm:reservation/qm:reserveFrom Reservation RQMReservation reserveFrom ODS RESERVATION RESERVE_FROM Operational Data Store/Reservation Area/ Reservation Reserve From The date and time that the reservation begins in UTC format N/A N/A
N/A Reservation Request Name reservation /content/qm:reservation/qm:request/@vega:id N/A RQMReservation request_id N/A N/A N/A N/A N/A N/A The uuid of the lab request of reservation N/A Deprecated
N/A Reservation Reserved By reservation /content/qm:reservation/qm:reservedBy N/A RQMReservation reservedBy ODS RESERVATION RESERVED_BY N/A Reservation Reserved By The login id of the person making the reservation N/A N/A
N/A Reservation Reserved For reservation /content/qm:reservation/qm:reservedFor N/A RQMReservation reservedFor ODS RESERVATION RESERVED_FOR N/A Reservation Reserved For The login id of the person for whom the lab resource is reserved N/A N/A
N/A Reservation Reserved To reservation /content/qm:reservation/qm:reserveTo N/A RQMReservation reservedTo ODS RESERVATION RESERVE_TO N/A Reservation Reserve To The date and time that the reservation ends in UTC format N/A N/A
N/A Reservation Machine reservation /content/qm:reservation/qm:labresource/@vega:id N/A RQMReservation labresource_id N/A N/A N/A N/A N/A N/A The uuid of the lab resource of reservation N/A Deprecated
N/A Reservation N/A reservation /id N/A RQMReservation itemId ODS RESERVATION EXTERNAL_KEY2 N/A Reservation External Key2 The uuid of reservation N/A N/A
N/A Reservation Reservation URL reservation /content/qm:reservation/dc:identifier N/A RQMReservation url ODS RESERVATION URL N/A Reservation URL The URL of reservation N/A N/A
N/A Reservation Reservation reservation /content/qm:reservation/dc:identifier N/A RQMReservation uuid ODS RESERVATION EXTERNAL_ID N/A Reservation Reference ID Read-only integer ID of reservation as seen in the web UI N/A N/A
N/A Reservation Request reservation /content/qm:reservation/qm:request/@qm:href N/A RQMReservation request_uuid N/A N/A N/A N/A N/A N/A The MD5 encrypted value of URI of the lab request of reservation N/A N/A
N/A Reservation Lab Resource reservation /content/qm:reservation/qm:labresource/@qm:href N/A RQMReservation labresource_uuid ODS RESERVATION LAB_RESOURCE_ID N/A Reservation Lab Resource ID The MD5 encrypted value of URI of the lab resource of reservation N/A N/A
N/A Reservation Is Deleted reservation /qm:archived N/A RQMReservation isSoftDeleted ODS RESERVATION ISSOFTDELETED N/A Reservation Is Deleted The reservation is archived or not 0: not deleted, 1: deleted N/A
N/A Reservation ID reservation /content/qm:reservation/qm:webId N/A RQMReservation webId ODS RESERVATION REFERENCE_ID N/A Reservation External ID The MD5 encrypted value of URL of reservation N/A N/A
N/A Reservation Project Area reservation /content/qm:reservation/qm:projectArea/@vega:id N/A RQMReservation projectId ODS RESERVATION PROJECT_ID N/A Reservation Project ID The uuid of project area of reservation N/A N/A
N/A Reservation Reservation reservation /content/qm:reservation/dc:identifier N/A RQMReservation_LabRequest_Lookup reservation_uuid CALM RESERVATION_LABREQUEST_LOOKUP RESERVATION_ID N/A Reservation External ID The MD5 encrypted value of URL of reservation N/A N/A
N/A Reservation Request reservation /content/qm:reservation/qm:request/@qm:href N/A RQMReservation_LabRequest_Lookup request_uuid CALM RESERVATION_LABREQUEST_LOOKUP LABREQUEST_ID N/A Reservation Related Lab Requests External ID The MD5 encrypted value of URI of the lab request of reservation N/A N/A

Test Environment

Sample Input 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 Output Changes in 4.0
N/A Test Environment N/A configuration N/A N/A N/A N/A N/A CONFIGURATION N/A N/A Configuration N/A Unless otherwise specified in this dictionary, "Test Environment" UI elements are expressed by the REST API Resource URL as "configuration"; are stored in the data warehouse "CONFIGURATION" table; and can be added to report definitions using the "Configuration" Query Subject and related Items. N/A N/A
N/A Test Environment N/A configuration /id Configuration RQMConfiguration itemId ODS CONFIGURATION EXTERNAL_KEY2 Operational Data Store/Configuration Area/ Configuration External Key2 The uuid of test environment N/A N/A
N/A Test Environment Name configuration /content/qm:configuration/dc:title N/A RQMConfiguration title ODS CONFIGURATION NAME N/A Configuration Name The name of test environment N/A N/A
N/A Test Environment Last Updated configuration /content/qm:configuration/alm:updated N/A RQMConfiguration updated ODS CONFIGURATION LAST_UPDATED N/A Configuration Last Updated The last updated date and time of test environment in UTC format N/A N/A
N/A Test Environment Is Deleted configuration /qm:archived N/A RQMConfiguration isSoftDeleted ODS CONFIGURATION ISSOFTDELETED N/A Configuration Is Deleted The test environment is archived or not 0: not deleted, 1: deleted N/A
N/A Test Environment Test Environment URL configuration /content/qm:configuration/dc:identifier N/A RQMConfiguration url ODS CONFIGURATION URL N/A Configuration URL The URL of test environment N/A N/A
N/A Test Environment Project Area configuration /content/qm:configuration/qm:projectArea/@vega:id N/A RQMConfiguration projectId ODS CONFIGURATION PROJECT_ID N/A Configuration Project ID The uuid of project area of test environment N/A N/A
N/A Test Environment Test Environment configuration /content/qm:configuration/dc:identifier N/A RQMConfiguration uuid ODS CONFIGURATION EXTERNAL_ID N/A Configuration External ID The MD5 encrypted value of URL of test environment N/A N/A
N/A Deprecated N/A configuration /content/qm:configuration/alm:state N/A RQMConfiguration configuration_state N/A N/A N/A N/A N/A N/A Deprecated N/A N/A
N/A Deprecated N/A configuration /content/qm:configuration/qm:configuration N/A RQMConfiguration configuration N/A N/A N/A N/A N/A N/A Deprecated N/A N/A

Automation Job

Sample Input 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 Output Changes in 4.0
N/A Automation Job N/A job N/A N/A N/A N/A N/A JOB N/A N/A Job N/A Unless otherwise specified in this dictionary, "Automation Job" UI elements are expressed by the REST API Resource URL as "job"; are stored in the data warehouse "JOB" table; and can be added to report definitions using the "Job" Query Subject and related Items. N/A N/A
N/A Automation Job Name job /content/qm:job/qm:name Job RQMJob name ODS JOB NAME Operational Data Store/Job Area/ Job Name The name of automation job N/A N/A
N/A Automation Job N/A job /id N/A RQMJob itemId ODS JOB EXTERNAL_KEY2 N/A Job External Key2 The uuid of automation job N/A N/A
N/A Automation Job Automation URL job /content/qm:job/dc:identifier N/A RQMJob url ODS JOB URL N/A Job URL The URL of automation job N/A N/A
N/A Automation Job Automation job /content/qm:job/dc:identifier N/A RQMJob uuid ODS JOB EXTERNAL_ID N/A Job External ID The MD5 encrypted value of URL of automation job N/A N/A
N/A Automation Job Is Deleted job /qm:archived N/A RQMJob isSoftDeleted ODS JOB ISSOFTDELETED N/A Job Is Deleted The automation job is archived or not 0: not deleted, 1: deleted N/A
N/A Automation Job Project Area job /content/qm:job/qm:projectArea/@vega:id N/A RQMJob projectId ODS JOB PROJECT_ID N/A Job Project ID The uuid of project area of automation job N/A N/A

Automation Job Result

Sample Input 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 Output Changes in 4.0
N/A Automation Job Result N/A jobresult N/A N/A N/A N/A N/A JOB_RESULT N/A N/A Job Result N/A Unless otherwise specified in this dictionary, "Automation Job Result" UI elements are expressed by the REST API Resource URL as "jobresult"; are stored in the data warehouse "JOB_RESULT" table; and can be added to report definitions using the "Job Result" Query Subject and related Items. N/A N/A
N/A Automation Job Result Owner Name jobresult /content/qm:jobresult/alm:owner JobResult RQMJobResult owner N/A N/A N/A Operational Data Store/Job Area/ N/A N/A The contributor's registered id that owns the job result N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Automation Job Result State jobresult /content/qm:jobresult/qm:state N/A RQMJobResult state ODS JOB_RESULT STATE N/A Job Result State The state of the job's execution Possible values are [UNKNOWN, RUNNING, STOPPED, WAITING, CREATED, SUSPENDED, STARTING, STOPPING, SUSPENDING, RESUMING] N/A
N/A Automation Job Result End Time jobresult /content/qm:jobresult/qm:endTime N/A RQMJobResult endTime ODS JOB_RESULT END_TIME N/A Job Result End Time The date and time that the execution of the job ended in UTC format N/A N/A
N/A Automation Job Result Machine jobresult /content/qm:jobresult/qm:labresource/@vega:id N/A RQMJobResult labresourceid N/A N/A N/A N/A N/A N/A The uuid of the lab resource of job result N/A N/A
N/A Automation Job Result Start Time jobresult /content/qm:jobresult/qm:startTime N/A RQMJobResult startTime ODS JOB_RESULT START_TIME N/A Job Result Start Time The date and time that the execution of the job began in UTC format N/A N/A
N/A Automation Job Result Automation Job jobresult /content/qm:jobresult/qm:job/@vega:id N/A RQMJobResult jobid N/A N/A N/A N/A N/A N/A The uuid of the job of job result N/A N/A
N/A Automation Job Result Duration jobresult /content/qm:jobresult/qm:duration N/A RQMJobResult duration ODS JOB_RESULT DURATION N/A Job Result Duration The duration of the job's execution in ms N/A N/A
N/A Automation Job Result N/A jobresult /id N/A RQMJobResult itemId ODS JOB_RESULT EXTERNAL_KEY2 N/A Job Result External Key2 The uuid of job result N/A N/A
N/A Automation Job Result Name jobresult /content/qm:jobresult/qm:name N/A RQMJobResult name ODS JOB_RESULT NAME N/A Job Result Name The name of job result N/A N/A
N/A Automation Job Result Result jobresult /content/qm:jobresult/qm:result N/A RQMJobResult result ODS JOB_RESULT VERDICT N/A Job Result Verdict The result of the job's execution Possible values are: [UNKNOWN, SUCCESS, FAILED, CANCELED, WAITING] N/A
N/A Automation Job Result Job Result URL jobresult /content/qm:jobresult/dc:identifier N/A RQMJobResult url ODS JOB_RESULT URL N/A Job Result URL The URL of job result N/A N/A
N/A Automation Job Result Job Result jobresult /content/qm:jobresult/dc:identifier N/A RQMJobResult uuid ODS JOB_RESULT EXTERNAL_ID N/A Job Result External ID The MD5 encrypted value of URL of job result N/A N/A
N/A Automation Job Result Lab Resource jobresult /content/qm:jobresult/qm:labresource/@qm:href N/A RQMJobResult labresource_uuid ODS JOB_RESULT LAB_RESOURCE_ID N/A Job Result Lab Resource ID The MD5 encrypted value of URI of the lab resource of lab resource N/A N/A
N/A Automation Job Result Automation Job jobresult /content/qm:jobresult/qm:job/@qm:href N/A RQMJobResult job_uuid ODS JOB_RESULT JOB_ID N/A Job Result Job ID The MD5 encrypted value of URI of the automation jop of lab resource N/A N/A
N/A Automation Job Result Is Deleted jobresult /qm:archived N/A RQMJobResult isSoftDeleted ODS JOB_RESULT ISSOFTDELETED N/A Job Result Is Deleted The job result is archived or not 0: not deleted, 1: deleted N/A
N/A Automation Job Result Project Area jobresult /content/qm:jobresult/qm:projectArea/@vega:id N/A RQMJobResult projectId N/A N/A N/A N/A N/A N/A The uuid of project area of job result N/A N/A
N/A Automation Job Result Owner jobresult /content/qm:jobresult/alm:owner/@rdf:resource N/A RQMJobResult owner_uuid ODS JOB_RESULT OWNER_ID N/A Job Result Owner ID The MD5 encrypted value of URI of the contributor that owns the job result N/A N/A

Build Record

Sample Input 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 Output Changes in 4.0
N/A Build Record N/A buildrecord N/A N/A N/A N/A N/A BUILD N/A N/A Build N/A Unless otherwise specified in this dictionary, "Build Record" UI elements are expressed by the REST API Resource URL as "buildrecord"; are stored in the data warehouse "BUILD" table; and can be added to report definitions using the "Build" Query Subject and related Items. N/A N/A
N/A Build Record Start Time buildrecord /content/qm:buildrecord/qm:starttime BuildRecord RQMBuildRecord starttime ODS BUILD START_TIME Operational Data Store/Build Area/ Build Start Time The date and time for the start of the build record N/A N/A
N/A Build Record N/A buildrecord /id N/A RQMBuildRecord itemId ODS BUILD EXTERNAL_KEY2 N/A Build External Key2 The uuid of build record N/A N/A
N/A Build Record Completed At buildrecord /content/qm:buildrecord/qm:endtime N/A RQMBuildRecord endtime ODS BUILD END_TIME N/A Build End Time The date and time for the end of the build record N/A N/A
N/A Build Record State buildrecord /content/qm:buildrecord/alm:state N/A RQMBuildRecord state ODS BUILD BUILD_STATE N/A Build Build State An ID or name of the current state of the build record but it capitalize the first letter when populate it to DW DB N/A N/A
N/A Build Record N/A buildrecord /content/qm:buildrecord/alm:owner N/A RQMBuildRecord owner N/A N/A N/A N/A N/A N/A The contributor's registered id that owns the build record N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Build Record Build Record URL buildrecord /content/qm:buildrecord/dc:identifier N/A RQMBuildRecord url ODS BUILD URL N/A Build URL The URL of build record N/A N/A
N/A Build Record Name buildrecord /content/qm:buildrecord/dc:title N/A RQMBuildRecord title ODS BUILD NAME N/A Build Name The name of build record N/A N/A
N/A Build Record Is Deleted buildrecord /qm:archived N/A RQMBuildRecord isSoftDeleted ODS BUILD ISSOFTDELETED N/A Build Is Deleted The build record is archived or not 0: not deleted, 1: deleted N/A
N/A Build Record Build Record buildrecord /content/qm:buildrecord/dc:identifier N/A RQMBuildRecord uuid ODS BUILD EXTERNAL_ID N/A Build External ID The MD5 encrypted value of URL of build record N/A N/A
N/A Build Record Project Area buildrecord /content/qm:buildrecord/qm:projectArea/@vega:id N/A RQMBuildRecord projectId ODS BUILD PROJECT_ID N/A Build Project ID The uuid of project area of build record N/A N/A
N/A Build Record N/A buildrecord /content/qm:buildrecord/alm:owner/@rdf:resource N/A RQMBuildRecord owner_uuid ODS BUILD OWNER_ID N/A Build Owner ID The MD5 encrypted value of URI of the contributor that owns the build record N/A N/A
N/A Build Record Status buildrecord /content/qm:buildrecord/qm:status N/A RQMBuildRecord status N/A N/A N/A N/A N/A N/A The status ID of the build N/A It is not loaded yet. It should request an new enhancement to populate the value into STATUS column of BUILD table

Contributor (Deprecated in RQM301)

Sample Input 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 Output Changes in 4.0
N/A Contributor (Deprecated in RQM301) N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
N/A Contributor ID contributor /id Contributor RQMContributor itemId N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Contributor UserId contributor /content/qm:contributor/userid N/A RQMContributor userid N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Contributor Email contributor /content/qm:contributor/emailaddress N/A RQMContributor emailaddress N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Contributor Name contributor /content/qm:contributor/name N/A RQMContributor name N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Contributor Updated contributor /content/qm:contributor/alm:updated N/A RQMContributor updated N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Contributor URL contributor /content/qm:contributor/dc:identifier N/A RQMContributor url N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Contributor UUID contributor /content/qm:contributor/dc:identifier N/A RQMContributor uuid N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Contributor Is Archived contributor /qm:archived N/A RQMContributor isSoftDeleted N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A

Quality Objective

Sample Input 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 Output Changes in 4.0
N/A Quality Objective N/A objective N/A N/A N/A N/A N/A QUALITY_OBJECTIVE N/A N/A Quality Objective N/A Unless otherwise specified in this dictionary, "Quality Objective" UI elements are expressed by the REST API Resource URL as "objective"; are stored in the data warehouse "QUALITY_OBJECTIVE" table; and can be added to report definitions using the "Quality Objective" Query Subject and related Items. N/A N/A
N/A Quality Objective N/A objective /id Objective RQMObjective itemId CALM QUALITY_OBJECTIVE EXTERNAL_KEY2 Operational Data Store/Test Plan Area/ Quality Objective External Key2 The uuid of quality objective N/A N/A
N/A Quality Objective Objective URL objective /content/qm:objective/dc:identifier N/A RQMObjective url CALM QUALITY_OBJECTIVE URL N/A Quality Objective URL The URL of quality objective N/A N/A
N/A Quality Objective Objective objective /content/qm:objective/dc:identifier N/A RQMObjective uuid CALM QUALITY_OBJECTIVE EXTERNAL_ID N/A Quality Objective External ID The MD5 encrypted value of URL of quality objective N/A N/A
N/A Quality Objective Name objective /content/qm:objective/dc:title N/A RQMObjective title CALM QUALITY_OBJECTIVE TITLE N/A Quality Objective Title The name of quality objective N/A N/A
N/A Quality Objective Description objective /content/qm:objective/dc:description N/A RQMObjective description CALM QUALITY_OBJECTIVE DESCRIPTION N/A Quality Objective Description The description of quality objective N/A N/A
N/A Quality Objective Last Updated objective /content/qm:objective/alm:updated N/A RQMObjective updated CALM QUALITY_OBJECTIVE LAST_UPDATED N/A Quality Objective Date of Last Update The last updated date and time of quality objective in UTC format N/A N/A
N/A Quality Objective N/A objective /content/qm:objective/dc:creator N/A RQMObjective creator N/A N/A N/A N/A N/A N/A The contributor's registered id that created the quality objective N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Quality Objective Condition objective /content/qm:objective/qm:operator N/A RQMObjective operator CALM QUALITY_OBJECTIVE OPERATOR N/A Quality Objective Operator An arithmetic symbol for the relationship One of values [=, <=, >=, <, >] N/A
N/A Quality Objective Target objective /content/qm:objective/qm:targetValue N/A RQMObjective targetValue CALM QUALITY_OBJECTIVE TARGET_VALUE N/A Quality Objective Target Value The integer value for the quality objective N/A N/A
N/A Quality Objective N/A objective /content/qm:objective/qm:evaluatorId N/A RQMObjective evaluatorId CALM QUALITY_OBJECTIVE EVALUATOR_ID N/A Quality Objective Evaluator ID The contributor's registered id that evaluated the quality objective N/A N/A
N/A Quality Objective Is Archived objective /qm:archived N/A RQMObjective isSoftDeleted CALM QUALITY_OBJECTIVE ISSOFTDELETED N/A Quality Objective Is Deleted The quality objective is archived or not 0: not deleted, 1: deleted N/A
N/A Quality Objective Project Area objective /content/qm:objective/qm:projectArea/@vega:id N/A RQMObjective projectId CALM QUALITY_OBJECTIVE PROJECT_ID N/A Quality Objective Project ID The uuid of project area of quality objective N/A N/A
N/A Quality Objective N/A objective /content/qm:objective/dc:creator/@rdf:resource N/A RQMObjective creator_uuid CALM QUALITY_OBJECTIVE CREATOR_ID N/A Quality Objective Creator ID The MD5 encrypted value of URI of the contributor that created the quality objective N/A N/A

Non Manual Test Script

Sample Input 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 Output Changes in 4.0
N/A Non Manual Test Script N/A remotescript N/A N/A N/A N/A N/A TESTSCRIPT N/A N/A Test Script N/A Unless otherwise specified in this dictionary, "Non Manual Test Script" UI elements are expressed by the REST API Resource URL as "remotescript"; are stored in the data warehouse "TESTSCRIPT" table; and can be added to report definitions using the "Test Script" Query Subject and related Items. N/A N/A
N/A Test Script N/A remotescript /id RemoteScript RQMRemoteScript itemId ODS TESTSCRIPT EXTERNAL KEY2 Operational Data Store/Test Script Area/ Test Script External Key2 The uuid of test script N/A N/A
N/A Test Script Name remotescript /content/qm:remotescript/dc:title N/A RQMRemoteScript title ODS TESTSCRIPT NAME N/A Test Script Name The name of test script N/A N/A
N/A Test Script Description remotescript /content/qm:remotescript/dc:description N/A RQMRemoteScript description N/A N/A N/A N/A N/A N/A The description of test script N/A N/A
N/A Test Script Type remotescript /content/qm:remotescript/qm:type N/A RQMRemoteScript type ODS TESTSCRIPT TYPE N/A Test Script Type The type of adapter that runs the script RFT, RPT, etc. The adapter provides this identifier in its plugin metadata. Some possible values are: RQM-KEY-APPSCAN-APTR-TYPE-NAME, RQM-KEY-CMD-APTR-TYPE-NAME, RQM-KEY-RFT-APTR-TYPE-NAME, RQM-KEY-ROBOT-APTR-TYPE-NAME, RQM-KEY-RPT-APTR-TYPE-NAME. N/A
N/A Test Script Originator remotescript /content/qm:remotescript/dc:creator N/A RQMRemoteScript creator N/A N/A N/A N/A N/A N/A The contributor's registered id that created the test script N/A N/A
N/A Test Script Owner remotescript /content/qm:remotescript/alm:owner N/A RQMRemoteScript owner N/A N/A N/A N/A N/A N/A The contributor's registered id that owns the test script N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Test Script State remotescript /content/qm:remotescript/alm:state N/A RQMRemoteScript state N/A N/A N/A N/A Test Script Test Script State Reference ID The ID of current state of test script N/A N/A
N/A Test Script Remote Script URL remotescript /content/qm:remotescript/dc:identifier N/A RQMRemoteScript url ODS TESTSCRIPT URL N/A Test Script URL The URL of test script N/A N/A
N/A Test Script Remote Script remotescript /content/qm:remotescript/dc:identifier N/A RQMRemoteScript uuid ODS TESTSCRIPT EXTERNAL_ID N/A Test Script External ID The MD5 encrypted value of URL of test script N/A N/A
N/A Test Script Modified remotescript /content/qm:remotescript/alm:updated N/A RQMRemoteScript updated ODS TESTSCRIPT LAST_UPDATED N/A Test Script Last Updated The last updated date and time of test script in UTC format N/A N/A
N/A Test Script N/A remotescript /content/qm:remotescript/qm:creationDate N/A RQMRemoteScript creationDate N/A N/A N/A N/A N/A N/A The creation date and time of test script in UTC format N/A N/A
N/A Test Script ID remotescript /content/qm:remotescript/qm:webId N/A RQMRemoteScript webId ODS TESTSCRIPT REFERENCE_ID N/A Test Script Reference ID Read-only integer ID of test script as seen in the web UI N/A N/A
N/A Test Script Is Deleted remotescript /qm:archived N/A RQMRemoteScript isSoftDeleted ODS TESTSCRIPT ISSOFTDELETED N/A Test Script Is Deleted The test script is archived or not 0: not deleted, 1: deleted N/A
N/A Test Script Project Area remotescript /content/qm:remotescript/qm:projectArea/@vega:id N/A RQMRemoteScript projectId ODS TESTSCRIPT PROJECT_ID N/A Test Script Project ID The uuid of project area of test script N/A Newly loaded by RQM 4.0 ETL.
N/A Test Script Originator remotescript /content/qm:remotescript/dc:creator/@rdf:resource N/A RQMRemoteScript creator_uuid N/A N/A N/A N/A N/A N/A The MD5 encrypted value of URI of the contributor that created the test script N/A N/A
N/A Test Script Owner remotescript /content/qm:remotescript/alm:owner/@rdf:resource N/A RQMRemoteScript owner_uuid ODS TESTSCRIPT OWNER_ID N/A Test Script Owner ID The MD5 encrypted value of URI of the contributor that owns the test script N/A N/A
N/A Test Script Author remotescript /content/qm:remotescript/qm:authorid/@rdf:resource N/A RQMRemoteScript author_uuid N/A N/A N/A N/A N/A N/A The contributor's registered id that authored the remote test script N/A Deprecated
N/A Test Script State remotescript /content/qm:remotescript/alm:state/@rdf:resource N/A RQMRemoteScript state_uuid ODS TESTSCRIPT TESTSCRIPT_STATE_ID N/A Test Script Test Script State External ID The MD5 encrypted value of URI of current state of the test script N/A Newly added in RQM 4.0. It is used to look up the value of TESTSCRIPT_STATE_ID column in TESTSCRIPT table, the value of the element in XDC is equal to the Test Script State External ID field of "Test Script" Query Subject in FM.
N/A Test Script Remote Script remotescript /content/qm:remotescript/dc:identifier N/A RQMRemoScript_CustomAttribute remotescript_uuid CALM TESTSCRIPT_STRING_EXT TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script Remote Script remotescript /content/qm:remotescript/dc:identifier N/A RQMRemoScript_CustomAttribute remotescript_uuid CALM TESTSCRIPT_STRING_M_EXT TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script Remote Script remotescript /content/qm:remotescript/dc:identifier N/A RQMRemoScript_CustomAttribute remotescript_uuid CALM TESTSCRIPT_INT_EXT TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script Remote Script remotescript /content/qm:remotescript/dc:identifier N/A RQMRemoScript_CustomAttribute remotescript_uuid CALM TESTSCRIPT_TIMESTAMP_EXT TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script N/A remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMRemoScript_CustomAttribute identifier CALM TESTSCRIPT_STRING_EXT IDENTIFIER N/A Test Script String Extension Identifying name The identifier of small text custom attribute of test script N/A N/A
N/A Test Script N/A remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMRemoScript_CustomAttribute identifier CALM TESTSCRIPT_STRING_M_EXT IDENTIFIER N/A Test Script Medium String Extension Identifying name The identifier of medium text custom attribute of test script N/A N/A
N/A Test Script N/A remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMRemoScript_CustomAttribute identifier CALM TESTSCRIPT_INT_EXT IDENTIFIER N/A Test Script Integer Extension Identifying name The identifier of integer custom attribute of test script N/A N/A
N/A Test Script N/A remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMRemoScript_CustomAttribute identifier CALM TESTSCRIPT_TIMESTAMP_EXT IDENTIFIER N/A Test Script Timestamp Extension Identifying name The identifier of date/time custom attribute of test script N/A N/A
N/A Test Script Attributes Type remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/@qm:type N/A RQMRemoScript_CustomAttribute type N/A N/A N/A N/A N/A N/A The type of custom attribute of test script, there are 4 types, SMALL_STRING, MEDIUM_STRING, INTEGER, TIMESTAMP 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. N/A
N/A Test Script Attributes Attribute Name remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:name N/A RQMRemoScript_CustomAttribute name CALM TESTSCRIPT_STRING_EXT NAME N/A Test Script String Extension Name The name of small text custom attribute of test script N/A N/A
N/A Test Script Attributes Attribute Name remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:name N/A RQMRemoScript_CustomAttribute name CALM TESTSCRIPT_STRING_M_EXT NAME N/A Test Script Medium String Extension Name The name of medium text custom attribute of test script N/A N/A
N/A Test Script Attributes Attribute Name remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:name N/A RQMRemoScript_CustomAttribute name CALM TESTSCRIPT_INT_EXT NAME N/A Test Script Integer Extension Name The name of integer custom attribute of test script N/A N/A
N/A Test Script Attributes Attribute Name remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:name N/A RQMRemoScript_CustomAttribute name CALM TESTSCRIPT_TIMESTAMP_EXT NAME N/A Test Script Timestamp Extension Name The name of date/time custom attribute of test script N/A N/A
N/A Test Script Attributes Custom Attribute Value remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:value N/A RQMRemoScript_CustomAttribute value CALM TESTSCRIPT_STRING_EXT VAR N/A Test Script String Extension Value The value of small text custom attribute of test script N/A N/A
N/A Test Script Attributes Custom Attribute Value remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:value N/A RQMRemoScript_CustomAttribute value CALM TESTSCRIPT_STRING_M_EXT VAR N/A Test Script Medium String Extension Value The value of medium text custom attribute of test script N/A N/A
N/A Test Script Attributes Custom Attribute Value remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:value N/A RQMRemoScript_CustomAttribute value CALM TESTSCRIPT_INT_EXT VAR N/A Test Script Integer Extension Value The string type value of integer custom attribute of test script N/A N/A
N/A Test Script Attributes Custom Attribute Value remotescript /content/qm:remotescript/qm:customAttributes/qm:customAttribute/qm:value N/A RQMRemoScript_CustomAttribute timeValue CALM TESTSCRIPT_TIMESTAMP_EXT VAR N/A Test Script Timestamp Extension Value The timestamp type value of date/time custom attribute of test script N/A N/A
N/A Test Script Is Deleted remotescript /qm:archived N/A RQMRemoScript_CustomAttribute isSoftDeleted CALM TESTSCRIPT_STRING_EXT ISSOFTDELETED N/A Test Script String Extension Is Deleted The test script is archived or not 0: not deleted, 1: deleted N/A
N/A Test Script Is Deleted remotescript /qm:archived N/A RQMRemoScript_CustomAttribute isSoftDeleted CALM TESTSCRIPT_STRING_M_EXT ISSOFTDELETED N/A Test Script Medium String Extension Is Deleted The test script is archived or not 0: not deleted, 1: deleted N/A
N/A Test Script Is Deleted remotescript /qm:archived N/A RQMRemoScript_CustomAttribute isSoftDeleted CALM TESTSCRIPT_INT_EXT ISSOFTDELETED N/A Test Script Integer Extension Is Deleted The test script is archived or not 0: not deleted, 1: deleted N/A
N/A Test Script Is Deleted remotescript /qm:archived N/A RQMRemoScript_CustomAttribute isSoftDeleted CALM TESTSCRIPT_TIMESTAMP_EXT ISSOFTDELETED N/A Test Script Timestamp Extension Is Deleted The test script is archived or not 0: not deleted, 1: deleted N/A
N/A Test Script Remote Script remotescript /content/qm:remotescript/dc:identifier N/A RQMRemoScript_Relationships uuid ODS TESTSCRIPT_CATEGORY_LOOKUP TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script Remote Script remotescript /content/qm:remotescript/dc:identifier N/A RQMRemoScript_Relationships uuid ODS REQUEST_TESTSCRIPT_LOOKUP TESTSCRIPT_ID N/A Test Script External ID The MD5 encrypted value of the URL of test script N/A N/A
N/A Test Script Categories value remotescript /content/qm:remotescript/qm:category/@qm:valueUUID N/A RQMRemoScript_Relationships valueUUID ODS TESTSCRIPT_CATEGORY_LOOKUP TEST_CATEGORY_ID N/A Test Script Related Test Categories External Key2 The uuid of category value of test script N/A Newly added in RQM 4.0.
N/A Test Script Related Workitems OSLC linking type remotescript /content/qm:remotescript/qm:workitem/@qm:rel N/A RQMRemoScript_Relationships request_rel ODS REQUEST_TESTSCRIPT_LOOKUP LINK_TYPE N/A Test Script Related Requests Link Type The RQM named linking type of request and test script N/A Newly added in RQM 4.0. The value returned from XDC is RQM specified name and it is translated to unified OSLC linking type when running ETL to deliver it to DB.
N/A Test Script Related Workitems remotescript /content/qm:remotescript/qm:workitem/@qm:href N/A RQMRemoScript_Relationships request_uuid ODS REQUEST_TESTSCRIPT_LOOKUP REQUEST_ID N/A Test Script Related Requests External ID The MD5 encrypted value of the URL of the requests of test script N/A Newly added in RQM 4.0.
N/A Test Script Related Workitems URL remotescript /content/qm:remotescript/qm:workitem/@qm:href N/A RQMRemoScript_Relationships request_url ODS REQUEST_TESTSCRIPT_LOOKUP REQUEST_ID N/A Test Script Related Requests URL The URL of the requests of test script N/A Newly added in RQM 4.0. It is used to look up for Clear Quest Requests.
N/A Test Script State remotescript /content/qm:remotescript/alm:state/@rdf:resource N/A RQMRemoScript_Relationships state_uuid ODS TESTSCRIPT TESTSCRIPT_STATE_ID N/A Test Script Test Script State External ID The MD5 encrypted value of URI of current state of the test script N/A Newly added in RQM 4.0. The field defined in this XDC Data Mapping Table is used for 4.0 ETL migration job.
N/A Test Script Project Area remotescript /content/qm:remotescript/qm:projectArea/@vega:id N/A RQMRemoScript_Relationships projectId ODS TESTSCRIPT PROJECT_ID N/A Test Script Project ID The uuid of project area of the test script N/A Newly added in RQM 4.0. The field defined in this XDC Data Mapping Table is used for 4.0 ETL migration job.

Test Suite Execution Record

Sample Input 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 Output Changes in 4.0
N/A Test Suite Execution Record N/A suiteexecutionrecord N/A N/A N/A N/A N/A TESTSUITE_EXECUTION_RECORD N/A N/A Test Suite Execution Record N/A Unless otherwise specified in this dictionary, "Test Suite Execution Record" UI elements are expressed by the REST API Resource URL as "suiteexecutionrecord"; are stored in the data warehouse "TESTSUITE_EXECUTION_RECORD" table; and can be added to report definitions using the "Test Suite Execution Record" Query Subject and related Items. N/A N/A
N/A Test Suite Execution Record N/A suiteexecutionrecord /id TestSuiteExecutionRecord RQMTestSuiteExecRecord itemId ODS TESTSUITE_EXECUTION_RECORD EXTERNAL_KEY2 Operational Data Store/Test Suite Execution Record Area/ Test Suite Execution Record External Key2 The uuid of test suite execution record N/A N/A
N/A Test Suite Execution Record Test Suite Execution Record suiteexecutionrecord /content/qm:suiteexecutionrecord/dc:identifier N/A RQMTestSuiteExecRecord uuid ODS TESTSUITE_EXECUTION_RECORD EXTERNAL_ID N/A Test Suite Execution Record External ID The MD5 encrypted value of the URL of test suite execution record N/A N/A
N/A Test Suite Execution Record Test Suite Execution Record URL suiteexecutionrecord /content/qm:suiteexecutionrecord/dc:identifier N/A RQMTestSuiteExecRecord url ODS TESTSUITE_EXECUTION_RECORD URL N/A Test Suite Execution Record URL The URL of test suite execution record N/A N/A
N/A Test Suite Execution Record Name suiteexecutionrecord /content/qm:suiteexecutionrecord/dc:title N/A RQMTestSuiteExecRecord title ODS TESTSUITE_EXECUTION_RECORD NAME N/A Test Suite Execution Record Name The name of test suite execution record N/A N/A
N/A Test Suite Execution Record Originator suiteexecutionrecord /content/qm:suiteexecutionrecord/dc:creator N/A RQMTestSuiteExecRecord creator N/A N/A N/A N/A N/A N/A The contributor's registered id that created test suite execution record N/A N/A
N/A Test Suite Execution Record Name suiteexecutionrecord /content/qm:suiteexecutionrecord/alm:owner N/A RQMTestSuiteExecRecord owner N/A N/A N/A N/A N/A N/A The contributor's registered id that owns test suite execution record N/A N/A
N/A Test Suite Execution Record Weight suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:weight N/A RQMTestSuiteExecRecord weight ODS TESTSUITE_EXECUTION_RECORD WEIGHT N/A Test Suite Execution Record Weight An integer measure of the estimated effort to execute the test suite execution record N/A N/A
N/A Test Suite Execution Record Modified suiteexecutionrecord /content/qm:suiteexecutionrecord/alm:updated N/A RQMTestSuiteExecRecord updated ODS TESTSUITE_EXECUTION_RECORD LAST_UPDATED N/A Test Suite Execution Record Last Updated The last updated date and time of test suite execution record in UTC format N/A N/A
N/A Test Suite Execution Record Test Plan suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:testplan/@qm:href N/A RQMTestSuiteExecRecord testplan_uuid ODS TESTSUITE_EXECUTION_RECORD TESTPLAN_ID N/A Test Suite Execution Record Test Plan ID The MD5 encrypted value of URI of the test plan of test suite execution record N/A N/A
N/A Test Suite Execution Record Iteration suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:testphase/@qm:href N/A RQMTestSuiteExecRecord testphase_uuid ODS TESTSUITE_EXECUTION_RECORD ITERATION_ID N/A Test Suite Execution Record Iteration ID The MD5 encrypted value of URI of the iteration of test suite execution record N/A N/A
N/A Test Suite Execution Record Test Suite suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:testsuite/@qm:href N/A RQMTestSuiteExecRecord testsuite_uuid ODS TESTSUITE_EXECUTION_RECORD TESTSUITE_ID N/A Test Suite Execution Record Test Suite ID The MD5 encrypted value of URI of the test suite of test suite execution record N/A N/A
N/A Test Suite Execution Record Test Environment suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:configuration/@qm:href N/A RQMTestSuiteExecRecord configuration_uuid ODS TESTSUITE_EXECUTION_RECORD CONFIGURATION_ID N/A Test Suite Execution Record Configuration ID The MD5 encrypted value of URI of the test environment of test suite execution record N/A N/A
N/A Test Suite Execution Record Last Result suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:currenttestsuitelog/@qm:href N/A RQMTestSuiteExecRecord currentTestsuiteLog_uuid ODS TESTSUITE_EXECUTION_RECORD CURRENT_SUITELOG_ID N/A Test Suite Execution Record Current Suite Log ID The MD5 encrypted value of URI of the current execution result of test suite execution record N/A N/A
N/A Test Suite Execution Record N/A suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:creationDate N/A RQMTestSuiteExecRecord creation_date ODS TESTSUITE_EXECUTION_RECORD CREATION_DATE N/A Test Suite Execution Record Creation Date The date and time that created the test suite execution record in UTC format N/A N/A
N/A Test Suite Execution Record Is Deleted suiteexecutionrecord /qm:archived N/A RQMTestSuiteExecRecord isSoftDeleted ODS TESTSUITE_EXECUTION_RECORD ISSOFTDELETED N/A Test Suite Execution Record Is Deleted The test suite execution record is archived or not 0: not deleted, 1: deleted N/A
N/A Test Suite Execution Record ID suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:webId N/A RQMTestSuiteExecRecord webId ODS TESTSUITE_EXECUTION_RECORD REFERENCE_ID N/A Test Suite Execution Record Reference ID Read-only integer ID of test suite execution record as seen in the web UI N/A N/A
N/A Test Suite Execution Record Project Area suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:projectArea/@vega:id N/A RQMTestSuiteExecRecord projectId ODS TESTSUITE_EXECUTION_RECORD PROJECT_ID N/A Test Suite Execution Record Project ID The uuid of project area of the test suite execution record N/A N/A
N/A Test Suite Execution Record Owner suiteexecutionrecord /content/qm:suiteexecutionrecord/alm:owner/@rdf:resource N/A RQMTestSuiteExecRecord owner_uuid ODS TESTSUITE_EXECUTION_RECORD OWNER_ID N/A Test Suite Execution Record Owner ID The MD5 encrypted value of URI of the contributor that owns the test suite execution record N/A N/A
N/A Test Suite Execution Record Originator suiteexecutionrecord /content/qm:suiteexecutionrecord/dc:creator/@rdf:resource N/A RQMTestSuiteExecRecord creator_uuid ODS TESTSUITE_EXECUTION_RECORD CREATOR_ID N/A Test Suite Execution Record Creator ID The MD5 encrypted value of URI of the contributor that created the test suite execution record N/A N/A
N/A Test Suite Execution Record Test Suite Execution Record suiteexecutionrecord /content/qm:suiteexecutionrecord/dc:identifier N/A RQMTSER_Relationships uuid ODS TESTSUITE_EXECUTION_RECORD TESTSUITE_EXECRECORD_ID N/A Test Suite Execution Record External ID The MD5 encrypted value of the URL of test suite execution record N/A N/A
N/A Test Suite Execution Record Test Suite Execution Record suiteexecutionrecord /content/qm:suiteexecutionrecord/dc:identifier N/A RQMTSER_Relationships uuid ODS TSTSUITEXECREC_CATEGORY_LOOKUP TESTSUITE_EXECRECORD_ID N/A Test Suite Execution Record External ID The MD5 encrypted value of the URL of test suite execution record N/A N/A
N/A Test Suite Execution Record Test Suite Execution Record suiteexecutionrecord /content/qm:suiteexecutionrecord/dc:identifier N/A RQMTSER_Relationships uuid CALM TSTSUITEXECREC_STRING_EXT TESTSUITE_EXECRECORD_ID N/A Test Suite Execution Record External ID The MD5 encrypted value of the URL of test suite execution record N/A N/A
N/A Test Suite Execution Record Test Suite Execution Record suiteexecutionrecord /content/qm:suiteexecutionrecord/dc:identifier N/A RQMTSER_Relationships uuid CALM TSTSUITEXECREC_STRING_M_EXT TESTSUITE_EXECRECORD_ID N/A Test Suite Execution Record External ID The MD5 encrypted value of the URL of test suite execution record N/A N/A
N/A Test Suite Execution Record Test Suite Execution Record suiteexecutionrecord /content/qm:suiteexecutionrecord/dc:identifier N/A RQMTSER_Relationships uuid CALM TSTSUITEXECREC_INT_EXT TESTSUITE_EXECRECORD_ID N/A Test Suite Execution Record External ID The MD5 encrypted value of the URL of test suite execution record N/A N/A
N/A Test Suite Execution Record Test Suite Execution Record suiteexecutionrecord /content/qm:suiteexecutionrecord/dc:identifier N/A RQMTSER_Relationships uuid CALM TSTSUITEXECREC_TIMESTAMP_EXT TESTSUITE_EXECRECORD_ID N/A Test Suite Execution Record External ID The MD5 encrypted value of the URL of test suite execution record N/A N/A
N/A Test Suite Execution Record Previous Results Details suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:testsuitelog/@qm:href N/A RQMTSER_Relationships testsuitelog_uuid N/A N/A N/A N/A Test Suite Execution Record Related Test Suite Logs External ID The MD5 encrypted value of URI of the execution results of test suite execution record. N/A N/A
N/A Test Suite Execution Record Category Value suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:category/@qm:valueUUID N/A RQMTSER_Relationships valueUUID ODS TSTSUITEXECREC_CATEGORY_LOOKUP TEST_CATEGORY_ID N/A Test Suite Execution Record Related Test Categories External Key2 The uuid of category value of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record Last Result suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:currenttestsuitelog/@qm:href N/A RQMTSER_Relationships currentTestsuiteLog_uuid ODS TESTSUITE_EXECUTION_RECORD CURRENT_SUITELOG_ID N/A Test Suite Execution Record Current Suite Log ID The MD5 encrypted value of URI of the current execution result of test suite execution record. It is used here is because the ETL build to load test suite execution record should be executed before the ETL build to load test suite result, so it needs to update the column after the execution of ETL build to load test suite result. N/A Newly loaded by RQM 4.0 ETL.
N/A Test Suite Execution Record N/A suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTSER_Relationships identifier CALM TSTSUITEXECREC_STRING_EXT IDENTIFIER N/A Test Suite Execution Record String Extension Identifying name The identifier of small text custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record N/A suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTSER_Relationships identifier CALM TSTSUITEXECREC_STRING_M_EXT IDENTIFIER N/A Test Suite Execution Record Medium String Extension Identifying name The identifier of medium text custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record N/A suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTSER_Relationships identifier CALM TSTSUITEXECREC_INT_EXT IDENTIFIER N/A Test Suite Execution Record Integer Extension Identifying name The identifier of integer custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record N/A suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:identifier N/A RQMTSER_Relationships identifier CALM TSTSUITEXECREC_TIMESTAMP_EXT IDENTIFIER N/A Test Suite Execution Record Timestamp Extension Identifying name The identifier of date/time custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record Attributes Type suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/@qm:type N/A RQMTSER_Relationships type N/A N/A N/A N/A N/A N/A The type of custom attribute of test suite execution record, there are 4 types, SMALL_STRING, MEDIUM_STRING, INTEGER, TIMESTAMP 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. Newly added in RQM 4.0.
N/A Test Suite Execution Record Attributes Attribute Name suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTSER_Relationships name CALM TSTSUITEXECREC_STRING_EXT NAME N/A Test Suite Execution Record String Extension Name The name of small text custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record Attributes Attribute Name suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTSER_Relationships name CALM TSTSUITEXECREC_STRING_M_EXT NAME N/A Test Suite Execution Record Medium String Extension Name The name of medium text custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record Attributes Attribute Name suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTSER_Relationships name CALM TSTSUITEXECREC_INT_EXT NAME N/A Test Suite Execution Record Integer Extension Name The name of integer custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record Attributes Attribute Name suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:name N/A RQMTSER_Relationships name CALM TSTSUITEXECREC_TIMESTAMP_EXT NAME N/A Test Suite Execution Record Timestamp Extension Name The name of date/time custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record Attributes Custom Attribute Value suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTSER_Relationships value CALM TSTSUITEXECREC_STRING_EXT VAR N/A Test Suite Execution Record String Extension Value The value of small text custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record Attributes Custom Attribute Value suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTSER_Relationships value CALM TSTSUITEXECREC_STRING_M_EXT VAR N/A Test Suite Execution Record Medium String Extension Value The value of medium text custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record Attributes Custom Attribute Value suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTSER_Relationships value CALM TSTSUITEXECREC_INT_EXT VAR N/A Test Suite Execution Record Integer Extension Value The string type value of integer custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record Attributes Custom Attribute Value suiteexecutionrecord /content/qm:suiteexecutionrecord/qm:customAttributes/qm:customAttribute/qm:value N/A RQMTSER_Relationships timeValue CALM TSTSUITEXECREC_TIMESTAMP_EXT VAR N/A Test Suite Execution Record Timestamp Extension Value The timestamp type value of date/time custom attribute of test suite execution record N/A Newly added in RQM 4.0.
N/A Test Suite Execution Record Is Deleted suiteexecutionrecord /qm:archived N/A RQMTSER_Relationships isSoftDeleted CALM TSTSUITEXECREC_STRING_EXT ISSOFTDELETED N/A Test Suite Execution Record String Extension Is Deleted The test suite execution record is archived or not 0: not deleted, 1: deleted Newly added in RQM 4.0.
N/A Test Suite Execution Record Is Deleted suiteexecutionrecord /qm:archived N/A RQMTSER_Relationships isSoftDeleted CALM TSTSUITEXECREC_STRING_M_EXT ISSOFTDELETED N/A Test Suite Execution Record Medium String Extension Is Deleted The test suite execution record is archived or not 0: not deleted, 1: deleted Newly added in RQM 4.0.
N/A Test Suite Execution Record Is Deleted suiteexecutionrecord /qm:archived N/A RQMTSER_Relationships isSoftDeleted CALM TSTSUITEXECREC_INT_EXT ISSOFTDELETED N/A Test Suite Execution Record Integer Extension Is Deleted The test suite execution record is archived or not 0: not deleted, 1: deleted Newly added in RQM 4.0.
N/A Test Suite Execution Record Is Deleted suiteexecutionrecord /qm:archived N/A RQMTSER_Relationships isSoftDeleted CALM TSTSUITEXECREC_TIMESTAMP_EXT ISSOFTDELETED N/A Test Suite Execution Record Timestamp Extension Is Deleted The test suite execution record is archived or not 0: not deleted, 1: deleted Newly added in RQM 4.0.

Project (Deprecated in RQM301)

Sample Input 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 Output Changes in 4.0
N/A Project (Deprecated in RQM301) N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
N/A Project N/A project /content/qm:project/qm:category/@qm:value Project RQMProjectCategory category_value N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Project N/A project /content/qm:project/qm:category/@qm:termUUID N/A RQMProjectCategory termID N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Project N/A project /content/qm:project/qm:category/@qm:valueUUID N/A RQMProjectCategory valueID N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Project N/A project /content/qm:project/dc:title N/A RQMProjectCategory project N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Project N/A project /content/qm:project/qm:category/@qm:term N/A RQMProjectCategory category_term N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Project N/A project /content/qm:project/qm:category/@qm:scope N/A RQMProjectCategory scope N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Project N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A Deprecated in RQM301 N/A N/A
N/A Key Word N/A keyword N/A N/A N/A N/A N/A KEYWORD N/A N/A Quality Keyword N/A Unless otherwise specified in this dictionary, "Key Word" UI elements are expressed by the REST API Resource URL as "keyword"; are stored in the data warehouse "KEYWORD" table; and can be added to report definitions using the "Quality Keyword" Query Subject and related Items. N/A N/A
N/A Key Word Name keyword /content/qm:keyword/dc:title KeyWord RQMKeyWord title CALM KEYWORD TITLE Operational Data Store/Test Script Area/ Quality Keyword Title The name of key word N/A N/A
N/A Key Word N/A keyword /id N/A RQMKeyWord itemId CALM KEYWORD EXTERNAL_KEY2 N/A Quality Keyword External Key2 The uuid of key word N/A N/A
N/A Key Word Modified keyword /content/qm:keyword/alm:updated N/A RQMKeyWord updated CALM KEYWORD LAST_UPDATED N/A Quality Keyword Last Updated The last updated date and time of key word in UTC format N/A N/A
N/A Key Word Key word URL keyword /content/qm:keyword/dc:identifier N/A RQMKeyWord url CALM KEYWORD URL N/A Quality Keyword URL The URL of key word N/A N/A
N/A Key Word Key Word keyword /content/qm:keyword/dc:identifier N/A RQMKeyWord uuid CALM KEYWORD EXTERNAL_ID N/A Quality Keyword External ID The MD5 encrypted value of the URL of key word N/A N/A
N/A Key Word Tags keyword /content/qm:keyword/qm:tags N/A RQMKeyWord tag CALM KEYWORD TAG N/A Quality Keyword Tag A searchable comment added to the key word N/A N/A
N/A Key Word Assocaited Script keyword /content/qm:keyword/qm:defaultscript/@qm:href N/A RQMKeyWord defaultscript_uuid CALM KEYWORD DEFAULT_SCRIPT_ID N/A Quality Keyword Default Script ID The MD5 encrypted value of the URL of the primary script associated to the key word N/A N/A
N/A Key Word ID keyword /content/qm:keyword/qm:webId N/A RQMKeyWord webId CALM KEYWORD REFERENCE_ID N/A Quality Keyword Reference ID Read-only integer ID of key word as seen in the web UI N/A N/A
N/A Key Word Is Deleted keyword /qm:archived N/A RQMKeyWord isSoftDeleted CALM KEYWORD ISSOFTDELETED N/A Quality Keyword Is Deleted The key word is archived or not 0: not deleted, 1: deleted N/A
N/A Key Word Project Area keyword /content/qm:keyword/qm:projectArea/@vega:id N/A RQMKeyWord projectId CALM KEYWORD PROJECT_ID N/A Quality Keyword Project ID The uuid of project area of the key word N/A N/A
N/A Key Word Key Word keyword /content/qm:keyword/dc:identifier N/A RQMKeyWord_TestScript_Lookup uuid CALM KEYWORD_SCRIPT_LOOKUP KEYWORD_ID N/A Quality Keyword External ID The MD5 encrypted value of the URL of key word N/A N/A
N/A Key Word Assocaited Script keyword /content/qm:keyword/qm:testscript/@qm:href N/A RQMKeyWord_TestScript_Lookup testscript_uuid CALM KEYWORD_SCRIPT_LOOKUP TESTSCRIPT_ID N/A N/A N/A The MD5 encrypted value of the URL of the manual script that references the key word N/A N/A

Key Word

Sample Input 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 Output Changes in 4.0
N/A Key Word N/A keyword N/A N/A N/A N/A N/A KEYWORD N/A N/A Quality Keyword N/A Unless otherwise specified in this dictionary, "Key Word" UI elements are expressed by the REST API Resource URL as "keyword"; are stored in the data warehouse "KEYWORD" table; and can be added to report definitions using the "Quality Keyword" Query Subject and related Items. N/A N/A
N/A Key Word Name keyword /content/qm:keyword/dc:title KeyWord RQMKeyWord title CALM KEYWORD TITLE Operational Data Store/Test Script Area/ Quality Keyword Title The name of key word N/A N/A
N/A Key Word N/A keyword /id N/A RQMKeyWord itemId CALM KEYWORD EXTERNAL_KEY2 N/A Quality Keyword External Key2 The uuid of key word N/A N/A
N/A Key Word Modified keyword /content/qm:keyword/alm:updated N/A RQMKeyWord updated CALM KEYWORD LAST_UPDATED N/A Quality Keyword Last Updated The last updated date and time of key word in UTC format N/A N/A
N/A Key Word Key word URL keyword /content/qm:keyword/dc:identifier N/A RQMKeyWord url CALM KEYWORD URL N/A Quality Keyword URL The URL of key word N/A N/A
N/A Key Word Key Word keyword /content/qm:keyword/dc:identifier N/A RQMKeyWord uuid CALM KEYWORD EXTERNAL_ID N/A Quality Keyword External ID The MD5 encrypted value of the URL of key word N/A N/A
N/A Key Word Tags keyword /content/qm:keyword/qm:tags N/A RQMKeyWord tag CALM KEYWORD TAG N/A Quality Keyword Tag A searchable comment added to the key word N/A N/A
N/A Key Word Assocaited Script keyword /content/qm:keyword/qm:defaultscript/@qm:href N/A RQMKeyWord defaultscript_uuid CALM KEYWORD DEFAULT_SCRIPT_ID N/A Quality Keyword Default Script ID The MD5 encrypted value of the URL of the primary script associated to the key word N/A N/A
N/A Key Word ID keyword /content/qm:keyword/qm:webId N/A RQMKeyWord webId CALM KEYWORD REFERENCE_ID N/A Quality Keyword Reference ID Read-only integer ID of key word as seen in the web UI N/A N/A
N/A Key Word Is Deleted keyword /qm:archived N/A RQMKeyWord isSoftDeleted CALM KEYWORD ISSOFTDELETED N/A Quality Keyword Is Deleted The key word is archived or not 0: not deleted, 1: deleted N/A
N/A Key Word Project Area keyword /content/qm:keyword/qm:projectArea/@vega:id N/A RQMKeyWord projectId CALM KEYWORD PROJECT_ID N/A Quality Keyword Project ID The uuid of project area of the key word N/A N/A
N/A Key Word Key Word keyword /content/qm:keyword/dc:identifier N/A RQMKeyWord_TestScript_Lookup uuid CALM KEYWORD_SCRIPT_LOOKUP KEYWORD_ID N/A Quality Keyword External ID The MD5 encrypted value of the URL of key word N/A N/A
N/A Key Word Assocaited Script keyword /content/qm:keyword/qm:testscript/@qm:href N/A RQMKeyWord_TestScript_Lookup testscript_uuid CALM KEYWORD_SCRIPT_LOOKUP TESTSCRIPT_ID N/A N/A N/A The MD5 encrypted value of the URL of the manual script that references the key word N/A N/A

Request

Sample Input 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 Output Changes in 4.0
N/A Request N/A request N/A N/A N/A N/A N/A LABREQUEST N/A N/A Lab Request N/A Unless otherwise specified in this dictionary, "Request" UI elements are expressed by the REST API Resource URL as "request"; are stored in the data warehouse "LABREQUEST" table; and can be added to report definitions using the "Lab Request" Query Subject and related Items. N/A N/A
N/A Request N/A request /id LabRequest RQMLabRequest itemId CALM LABREQUEST EXTERNAL_KEY2 Operational Data Store/Reservation Area/ Lab Request External Key2 The uuid of lab request N/A N/A
N/A Request Requrest URL request /content/qm:request/dc:identifier N/A RQMLabRequest url CALM LABREQUEST URL N/A Lab Request URL The URL of lab request N/A N/A
N/A Request Requrest request /content/qm:request/dc:identifier N/A RQMLabRequest uuid CALM LABREQUEST EXTERNAL_ID N/A Lab Request External ID The MD5 encrypted value of the URL of lab request N/A N/A
N/A Request Name request /content/qm:request/qm:title N/A RQMLabRequest title CALM LABREQUEST TITLE N/A Lab Request Title The name of lab request N/A N/A
N/A Request Summary request /content/qm:request/qm:summary N/A RQMLabRequest summary CALM LABREQUEST SUMMARY N/A Lab Request Summary The description of lab request N/A N/A
N/A Request Requester request /content/qm:request/qm:requester N/A RQMLabRequest requester CALM LABREQUEST REQUESTER_ID N/A Lab Request Requester ID The contributor's registered id making the lab request N/A N/A
N/A Request Reserve From request /content/qm:request/qm:reserveFrom N/A RQMLabRequest reserveFrom CALM LABREQUEST RESERVE_FROM N/A Lab Request Reserve from The date and time of the requested reservation in UTC format N/A N/A
N/A Request Reserve To request /content/qm:request/qm:reserveTo N/A RQMLabRequest reserveTo CALM LABREQUEST RESERVE_TO N/A Lab Request Reserve until The date and time that the requested reservation will end in UTC format N/A N/A
N/A Request Priority request /content/qm:request/qm:priority N/A RQMLabRequest priority CALM LABREQUEST PRIORITY N/A Lab Request Priority The importance of the lab request Must be one of "low", "normal" or "high" N/A
N/A Request State request /content/qm:request/alm:state N/A RQMLabRequest state CALM LABREQUEST CURRENT_STATE N/A Lab Request Current State The current state of the lab request as per the state transition matrix N/A N/A
N/A Request N/A request /content/qm:request/qm:visibleId N/A RQMLabRequest visibleId CALM LABREQUEST VISIBLE_ID N/A Lab Request Visable ID A read-only auto generated integer identifying the lab request N/A N/A
N/A Request Test Environment request /content/qm:request/qm:configuration N/A RQMLabRequest configuration CALM LABREQUEST CONFIGURATION N/A Lab Request Configuration The JSON string describing the requested lab resource N/A N/A
N/A Request Comments request /content/qm:request/qm:comments N/A RQMLabRequest comments CALM LABREQUEST COMMENTS N/A Lab Request Comments The comments of the lab request N/A N/A
N/A Request Creation Time request /content/qm:request/qm:createDate N/A RQMLabRequest createDate CALM LABREQUEST CREATE_DATE N/A Lab Request Creation Date The date and time the lab request was first submitted in UTC format N/A N/A
N/A Request Confirmation Time request /content/qm:request/qm:confirmationDate N/A RQMLabRequest confirmationDate CALM LABREQUEST CONFIRMATION_DATE N/A Lab Request Confirmation Date The date and time the lab request was confirmed in UTC format N/A N/A
N/A Request Last Updated request /content/qm:request/qm:updated N/A RQMLabRequest updated CALM LABREQUEST LAST_UPDATED N/A Lab Request Last Updated The last updated date and time of lab request in UTC format N/A N/A
N/A Request Fulfiller request /content/qm:request/qm:fulfiller N/A RQMLabRequest fulfiller CALM LABREQUEST FULFILLER_ID N/A Lab Request Fulfiller ID The contributor's registered id who is responsible for fulfilling the lab request N/A N/A
N/A Request Is Deleted request /qm:archived N/A RQMLabRequest isSoftDeleted CALM LABREQUEST ISSOFTDELETED N/A Lab Request Is Deleted The lab request is archived or not 0: not deleted, 1: deleted N/A
N/A Request ID request /content/qm:request/qm:webId N/A RQMLabRequest webId CALM LABREQUEST REFERENCE_ID N/A Lab Request Reference ID Read-only integer ID of lab request as seen in the web UI N/A N/A
N/A Request Project Area request /content/qm:request/qm:projectArea/@vega:id N/A RQMLabRequest projectId CALM LABREQUEST PROJECT_ID N/A Lab Request Project ID The uuid of project area of the lab request N/A N/A
N/A Request Request request /content/qm:request/dc:identifier N/A RQMLabRequest_ChangeState request_uuid CALM LABREQUEST_CHANGESTATE LABREQUEST_ID N/A Lab Request State Change Lab Request ID The MD5 encrypted value of the URL of lab request N/A N/A
N/A Request State request /content/qm:request/qm:changestates/qm:changestate/qm:stateid N/A RQMLabRequest_ChangeState stateid CALM LABREQUEST_CHANGESTATE STATE_UUID N/A Lab Request State Change State UUID UUID of the state change N/A N/A
N/A Request Old State request /content/qm:request/qm:changestates/qm:changestate/qm:oldstate N/A RQMLabRequest_ChangeState oldstate CALM LABREQUEST_CHANGESTATE FROM_STATE N/A Lab Request State Change From State The name of the prior state N/A N/A
N/A Request New State request /content/qm:request/qm:changestates/qm:changestate/qm:newstate N/A RQMLabRequest_ChangeState newstate CALM LABREQUEST_CHANGESTATE TO_STATE N/A Lab Request State Change To State The name of the state after the change N/A N/A
N/A Request N/A request /content/qm:request/qm:changestates/qm:changestate/qm:statechangedate N/A RQMLabRequest_ChangeState statechangedate CALM LABREQUEST_CHANGESTATE TO_TIME N/A Lab Request State Change To Time The date and time for the state change in UTC format N/A N/A
N/A Request N/A request /content/qm:request/qm:changestates/qm:changestate/qm:oldstatechangedate N/A RQMLabRequest_ChangeState oldstatechangedate CALM LABREQUEST_CHANGESTATE FROM_TIME N/A Lab Request State Change From Time The date and time for the previous state change in UTC format N/A N/A
N/A Request Is Deleted request /qm:archived N/A RQMLabRequest_ChangeState isSoftDeleted CALM LABREQUEST_CHANGESTATE ISSOFTDELETED N/A Lab Request State Change Is Deleted The lab request is archived or not 0: not deleted, 1: deleted N/A
N/A Request N/A request /content/qm:request/qm:changestates/qm:changestate/qm:statechangedby N/A RQMLabRequest_ChangeState statechangedby N/A N/A N/A N/A N/A N/A The contributor's registered id that changed the state N/A Not loaded by RQM 4.0 ETL anymore, but the value from REST API is equal to the Name field of Operational Data Store/Resource Area/Resource in FM.
N/A Request N/A request /content/qm:request/qm:changestates/qm:changestate/qm:statechangedby/@rdf:resource N/A RQMLabRequest_ChangeState statechangedby_uuid CALM LABREQUEST_CHANGESTATE USER_ID N/A Lab Request State Change User ID The MD5 encrypted value of URI of the contributor that changed the state N/A N/A

Artifact Categories

Sample Input 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 Output Changes in 4.0
N/A Artifact Categories N/A category N/A N/A N/A N/A N/A TEST_CATEGORY N/A N/A Test Category N/A Unless otherwise specified in this dictionary, value of "Artifact Category" UI elements are expressed by the REST API Resource URL as "category"; are stored in the data warehouse "TEST_CATEGORY" table; and can be added to report definitions using the "Test Category" Query Subject and related Items. N/A N/A
N/A Category N/A category /id Category RQMCategory itemId ODS TEST_CATEGORY EXTERNAL_KEY2 Operational Data Store/Test Category Area/ Test Category External Key2 The uuid of category value N/A N/A
N/A Category Category Value category /content/qm:category/dc:title N/A RQMCategory title ODS TEST_CATEGORY VALUE N/A Test Category Category Value The value of category N/A N/A
N/A Category Category Type category /content/qm:category/qm:categoryType/@qm:href N/A RQMCategory categoryType_uuid ODS TEST_CATEGORY EXTERNAL_ID N/A N/A N/A The MD5 encrypted value of URL of the category type N/A N/A
N/A Category Is Deleted category /qm:archived N/A RQMCategory isSoftDeleted ODS TEST_CATEGORY ISSOFTDELETED N/A Test Category Is Deleted The category is archived or not 0: not deleted, 1: deleted N/A
N/A Category Category Type URL category /content/qm:category/qm:categoryType/@qm:href N/A RQMCategory categoryType_url ODS TEST_CATEGORY URL N/A Test Category URL The URL of the category type N/A Newly added in RQM 4.0.

Artifact Categories Type

Sample Input 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 Output Changes in 4.0
N/A Artifact Categories Type N/A categoryType N/A N/A N/A N/A N/A TEST_CATEGORY N/A N/A Test Category N/A Unless otherwise specified in this dictionary, value of "Artifact Category Type" UI elements are expressed by the REST API Resource URL as "categoryType"; are stored in the data warehouse "TEST_CATEGORY" table; and can be added to report definitions using the "Test Category" Query Subject and related Items. N/A N/A
N/A Category Type N/A categoryType /id CategoryType RQMCategoryType itemId N/A N/A N/A Operational Data Store/Test Category Area/ N/A N/A The uuid of category type N/A N/A
N/A Category Type Category Type categoryType /content/qm:categoryType/dc:identifier N/A RQMCategoryType uuid ODS TEST_CATEGORY EXTERNAL_ID N/A N/A N/A The MD5 encrypted value of URL of the category type N/A N/A
N/A Category Type Category Type Name categoryType /content/qm:categoryType/dc:title N/A RQMCategoryType title ODS TEST_CATEGORY TERM N/A Test Category Category Term The name of category type N/A N/A
N/A Category Type Is Deleted categoryType /qm:archived N/A RQMCategoryType isSoftDeleted ODS TEST_CATEGORY ISSOFTDELETED N/A Test Category Is Deleted The category type is archived or not 0: not deleted, 1: deleted N/A

Test Artifacts Workflows

Sample Input 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 Output Changes in 4.0
N/A Test Artifacts Workflows N/A workflowstate N/A N/A N/A N/A N/A [Test Artifact Type]_STATE N/A N/A [Test Artifact Type] State N/A Unless otherwise specified in this dictionary, value of "Test Artifacts Workflows" UI elements are expressed by the REST API Resource URL as "workflowstate"; are stored in the data warehouse "[Test Artifact Type]_STATE" table; and can be added to report definitions using the "[Test Artifact Type] STATE" Query Subjects. N/A It is new since RQM 4.0
N/A Test Plan Workflow Test Plan Workflow States workflowstate /@rdf:about WorkflowState RQMWorkflowState uuid ODS TESTPLAN_STATE EXTERNAL_ID Operational Data Store/Test Plan Area/ Test Plan State External ID The MD5 encrypted value of URL of test plan's workflow state N/A N/A
N/A Test Plan Workflow States Group workflowstate /qm_process:stateGroup/@rdf:resource N/A RQMWorkflowState stategroup_uuid ODS TESTPLAN_STATE TEST_STATUS_ID N/A Test Plan State Test Status ID The MD5 encrypted value of URL of test artifacts state group N/A N/A
N/A Test Plan Workflow Test Plan Workflow States URL workflowstate /@rdf:about N/A RQMWorkflowState url ODS TESTPLAN_STATE URL N/A Test Plan State URL The URL of test plan's workflow state N/A N/A
N/A Test Plan Workflow States Name workflowstate /dcterms:title N/A RQMWorkflowState name ODS TESTPLAN_STATE NAME N/A Test Plan State Name The name of test plan's workflow state N/A N/A
N/A Test Plan Workflow N/A workflowstate /dcterms:identifier N/A RQMWorkflowState id ODS TESTPLAN_STATE REFERNCE_ID N/A Test Plan State Reference ID The id of test plan's workflow state The OOTB states id are: com.ibm.rqm.planning.common.approved, com.ibm.rqm.planning.common.underreview, com.ibm.rqm.planning.common.new, com.ibm.rqm.planning.common.retired. The new customized state id is as the format [workflow definition id] + [.state] + [.s#]. N/A
N/A Test Plan Workflow Project Area workflowstate /qm_process:projectArea/@rdf:resource N/A RQMWorkflowState project_uuid ODS TESTPLAN_STATE PROJECT_ID N/A Test Plan State Project ID The MD5 encrypted value of URI of the project of test case's workflow state N/A N/A
N/A Test Case Workflow Test Case Workflow States workflowstate /@rdf:about N/A RQMWorkflowState uuid ODS TESTCASE_STATE EXTERNAL_ID Operational Data Store/Test Case Area/ Test Case State External ID The MD5 encrypted value of URL of test case's workflow state N/A N/A
N/A Test Case Workflow States Group workflowstate /qm_process:stateGroup/@rdf:resource N/A RQMWorkflowState stategroup_uuid ODS TESTCASE_STATE TEST_STATUS_ID N/A Test Case State Test Status ID The MD5 encrypted value of URL of test artifacts state group N/A N/A
N/A Test Case Workflow Test Case Workflow States URL workflowstate /@rdf:about N/A RQMWorkflowState url ODS TESTCASE_STATE URL N/A Test Case State URL The URL of test case's workflow state N/A N/A
N/A Test Case Workflow States Name workflowstate /dcterms:title N/A RQMWorkflowState name ODS TESTCASE_STATE NAME N/A Test Case State Name The name of test case's workflow state N/A N/A
N/A Test Case Workflow N/A workflowstate /dcterms:identifier N/A RQMWorkflowState id ODS TESTCASE_STATE REFERNCE_ID N/A Test Case State Reference ID The id of test case's workflow state The OOTB states id are: com.ibm.rqm.planning.common.approved, com.ibm.rqm.planning.common.underreview, com.ibm.rqm.planning.common.new, com.ibm.rqm.planning.common.retired. The new customized state id is as the format [workflow definition id] + [.state] + [.s#]. N/A
N/A Test Case Workflow Project Area workflowstate /qm_process:projectArea/@rdf:resource N/A RQMWorkflowState project_uuid ODS TESTCASE_STATE PROJECT_ID N/A Test Case State Project ID The MD5 encrypted value of URI of the project of test case's workflow state N/A N/A
N/A Test Script Workflow Test Script Workflow States workflowstate /@rdf:about N/A RQMWorkflowState uuid ODS TESTSCRIPT_STATE EXTERNAL_ID Operational Data Store/Test Scripy Area/ Test Script State External ID The MD5 encrypted value of URL of test script's workflow state N/A N/A
N/A Test Script Workflow States Group workflowstate /qm_process:stateGroup/@rdf:resource N/A RQMWorkflowState stategroup_uuid ODS TESTSCRIPT_STATE TEST_STATUS_ID N/A Test Script State Test Status ID The MD5 encrypted value of URL of test artifacts state group N/A N/A
N/A Test Script Workflow Test Script Workflow States URL workflowstate /@rdf:about N/A RQMWorkflowState url ODS TESTSCRIPT_STATE URL N/A Test Script State URL The URL of test script's workflow state N/A N/A
N/A Test Script Workflow States Name workflowstate /dcterms:title N/A RQMWorkflowState name ODS TESTSCRIPT_STATE NAME N/A Test Script State Name The name of test script's workflow state N/A N/A
N/A Test Script Workflow N/A workflowstate /dcterms:identifier N/A RQMWorkflowState id ODS TESTSCRIPT_STATE REFERNCE_ID N/A Test Script State Reference ID The id of test script's workflow state The OOTB states id are: com.ibm.rqm.planning.common.approved, com.ibm.rqm.planning.common.underreview, com.ibm.rqm.planning.common.new, com.ibm.rqm.planning.common.retired. The new customized state id is as the format [workflow definition id] + [.state] + [.s#]. N/A
N/A Test Script Workflow Project Area workflowstate /qm_process:projectArea/@rdf:resource N/A RQMWorkflowState project_uuid ODS TESTSCRIPT_STATE PROJECT_ID N/A Test Script State Project ID The MD5 encrypted value of URI of the project of test script's workflow state N/A N/A
N/A Test Suite Workflow Test Suite Workflow States workflowstate /@rdf:about N/A RQMWorkflowState uuid ODS TESTSUITE_STATE EXTERNAL_ID Operational Data Store/Test Suite Area/ Test Suite State External ID The MD5 encrypted value of URL of test suite's workflow state N/A N/A
N/A Test Suite Workflow States Group workflowstate /qm_process:stateGroup/@rdf:resource N/A RQMWorkflowState stategroup_uuid ODS TESTSUITE_STATE TEST_STATUS_ID N/A Test Suite State Test Status ID The MD5 encrypted value of URL of test artifacts state group N/A N/A
N/A Test Suite Workflow Test Suite Workflow States URL workflowstate /@rdf:about N/A RQMWorkflowState url ODS TESTSUITE_STATE URL N/A Test Suite State URL The URL of test suite's workflow state N/A N/A
N/A Test Suite Workflow States Name workflowstate /dcterms:title N/A RQMWorkflowState name ODS TESTSUITE_STATE NAME N/A Test Suite State Name The name of test suite's workflow state N/A N/A
N/A Test Suite Workflow N/A workflowstate /dcterms:identifier N/A RQMWorkflowState id ODS TESTSUITE_STATE REFERNCE_ID N/A Test Suite State Reference ID The id of test suite's workflow state The OOTB states id are: com.ibm.rqm.planning.common.approved, com.ibm.rqm.planning.common.underreview, com.ibm.rqm.planning.common.new, com.ibm.rqm.planning.common.retired. The new customized state id is as the format [workflow definition id] + [.state] + [.s#]. N/A
N/A Test Suite Workflow Project Area workflowstate /qm_process:projectArea/@rdf:resource N/A RQMWorkflowState project_uuid ODS TESTSUITE_STATE PROJECT_ID N/A Test Suite State Project ID The MD5 encrypted value of URI of the project of test suite's workflow state N/A N/A
N/A Test Case Result Test Case Result Workflow States workflowstate /@rdf:about N/A RQMWorkflowState uuid ODS EXECRESULT_STATE EXTERNAL_ID Operational Data Store/Execution Result Area/ Execution Result State External ID The MD5 encrypted value of URL of test case result's workflow state N/A N/A
N/A Test Case Result States Group workflowstate /qm_process:stateGroup/@rdf:resource N/A RQMWorkflowState stategroup_uuid ODS EXECRESULT_STATE TEST_STATUS_ID N/A Execution Result State Test Status ID The MD5 encrypted value of URL of test artifacts state group N/A N/A
N/A Test Case Result Test Case Result Workflow States URL workflowstate /@rdf:about N/A RQMWorkflowState url ODS EXECRESULT_STATE URL N/A Execution Result State URL The URL of test case result's workflow state N/A N/A
N/A Test Case Result States Name workflowstate /dcterms:title N/A RQMWorkflowState name ODS EXECRESULT_STATE NAME N/A Execution Result State Name The name of test case result's workflow state N/A N/A
N/A Test Case Result N/A workflowstate /dcterms:identifier N/A RQMWorkflowState id ODS EXECRESULT_STATE REFERNCE_ID N/A Execution Result State Reference ID The id of test case result's workflow state The OOTB states id are: com.ibm.rqm.planning.common.approved, com.ibm.rqm.planning.common.underreview, com.ibm.rqm.planning.common.new, com.ibm.rqm.planning.common.retired. The new customized state id is as the format [workflow definition id] + [.state] + [.s#]. N/A
N/A Test Case Result Project Area workflowstate /qm_process:projectArea/@rdf:resource N/A RQMWorkflowState project_uuid ODS EXECRESULT_STATE PROJECT_ID N/A Execution Result State Project ID The MD5 encrypted value of URI of the project of test case result's workflow state N/A N/A
N/A Test Suite Result Test Suite Result Workflow States workflowstate /@rdf:about N/A RQMWorkflowState uuid ODS TESTSUITELOG_STATE EXTERNAL_ID Operational Data Store/Test Suite Area/ Test Suite Log State External ID The MD5 encrypted value of URL of test suite result's workflow state N/A N/A
N/A Test Suite Result States Group workflowstate /qm_process:stateGroup/@rdf:resource N/A RQMWorkflowState stategroup_uuid ODS TESTSUITELOG_STATE TEST_STATUS_ID N/A Test Suite Log State Test Status ID The MD5 encrypted value of URL of test artifacts state group N/A N/A
N/A Test Suite Result Test Suite Result Workflow States URL workflowstate /@rdf:about N/A RQMWorkflowState url ODS TESTSUITELOG_STATE URL N/A Test Suite Log State URL The URL of test suite result's workflow state N/A N/A
N/A Test Suite Result States Name workflowstate /dcterms:title N/A RQMWorkflowState name ODS TESTSUITELOG_STATE NAME N/A Test Suite Log State Name The name of test suite result's workflow state N/A N/A
N/A Test Suite Result N/A workflowstate /dcterms:identifier N/A RQMWorkflowState id ODS TESTSUITELOG_STATE REFERNCE_ID N/A Test Suite Log State Reference ID The id of test suite result's workflow state The OOTB states id are: com.ibm.rqm.planning.common.approved, com.ibm.rqm.planning.common.underreview, com.ibm.rqm.planning.common.new, com.ibm.rqm.planning.common.retired. The new customized state id is as the format [workflow definition id] + [.state] + [.s#]. N/A
N/A Test Suite Result Project Area workflowstate /qm_process:projectArea/@rdf:resource N/A RQMWorkflowState project_uuid ODS TESTSUITELOG_STATE PROJECT_ID N/A Test Suite Log State Project ID The MD5 encrypted value of URI of the project of test suite result's workflow state N/A N/A
N/A Test Artifacts Workflows States Group Category workflowstate /qm_process:category N/A RQMWorkflowState category N/A N/A N/A N/A N/A N/A The category name of test artifacts state group The OOTB state groups categories are: CLOSED, APPROVED, REVIEWED, UNDERREVIEW, DRAFT. N/A

Test Artifacts Workflows State Group

Sample Input 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 Output Changes in 4.0
N/A Test Artifacts Workflows State Group N/A workflowstategroup N/A N/A N/A N/A N/A TEST_STATUS N/A N/A [Test Artifact Type] State N/A Unless otherwise specified in this dictionary, value of "Test Artifacts Workflows State Group" UI elements are expressed by the REST API Resource URL as "workflowstategroup"; are stored in the data warehouse "TEST_STATUS" table; There is no Query Subject to directy expose state group of test artifacts, and can be added to report definitions using the "[Test Artifact Type] STATE" Query Subjects. N/A It is new since RQM 4.0
N/A Test Artifacts Workflows State Group States Group workflowstategroup /@rdf:about WorkflowStategroup RQMWorkflowStategroup uuid ODS TEST_STATUS EXTERNAL_ID Operational Data Store/[Test Artifact Type] Area/ [Test Artifact Type] State Test Status ID The MD5 encrypted value of URL of state group N/A N/A
N/A Test Artifacts Workflows State Group States Group URL workflowstategroup /@rdf:about N/A RQMWorkflowStategroup url N/A N/A N/A N/A N/A N/A The URL of state group N/A N/A
N/A Test Artifacts Workflows State Group States Group Category workflowstategroup /qm_process:category N/A RQMWorkflowStategroup category ODS TEST_STATUS REFERENCE_ID N/A N/A N/A The category name of test artifacts state group The OOTB state groups categories are: CLOSED, APPROVED, REVIEWED, UNDERREVIEW, DRAFT. N/A
N/A Test Artifacts Workflows State Group States Group Name workflowstategroup /dcterms:title N/A RQMWorkflowStategroup name N/A N/A N/A N/A N/A N/A The name of state group N/A N/A
N/A Test Artifacts Workflows State Group N/A workflowstategroup /dcterms:identifier N/A RQMWorkflowStategroup id ODS TEST_STATUS NAME N/A [Test Artifact Type] State Test Status Name The id of state group The OOTB state groups id are: closed, approved, reviewed, underreview, draft. N/A
N/A Test Artifacts Workflows State Group Project Area workflowstategroup /qm_process:projectArea/@rdf:resource N/A RQMWorkflowStategroup project_uuid ODS TEST_STATUS PROJECT_ID N/A N/A N/A The MD5 encrypted value of URI of the project of state group N/A N/A

Test Artifacts Workflows State Group Category

Sample Input 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 Output Changes in 4.0
N/A Test Artifacts Workflows State Group Category N/A workflowstategroupcategory N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A It is added into xdc for the purpose of customized ETLs by customers and RQM ETL does not load it. N/A It is new since RQM 4.0
N/A Test Artifacts Workflows State Group Category States Group Category workflowstategroupcategory /qm_process:category WorkflowStategroupCategory RQMWorkflowStategroupCategory category N/A N/A N/A N/A N/A N/A The category name of test artifacts state group The OOTB state groups categories are: CLOSED, APPROVED, REVIEWED, UNDERREVIEW, DRAFT. N/A

Feedback