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.
| 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. |
| 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. |
| 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 |
| 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. |
| 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 |
| 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 |
| 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. |
| 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. |
| 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. |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 | 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 |
| 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 |
| 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. |
| 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. |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |