Hello,

I need to build a custom report based on test script step information (Step description, Expected Results, Step Name) that is linked to a Requirement.

So the relationship would be: Requirement > Test Case > Test Script > Test Script Step

I know the test script step information is only available for test scripts linked to defects/requirements in the data warehouse and we have no near term plans to use LQE.

I can see the following views in the data warehouse that appear to house the  data I need on test scripts and script steps:

--RIDW.VW_EXECUTION_STEP_RESULT
--RIDW.VW_TESTSCRIPT_STEP 

The issue I am having is, I need to join these two views onto several other views in my query. Without prior knowledge of the architecture of the two test script views and based on the fact that they aren't being used in JRS, how can I know that the data being collected in them is complete and not just a partial set? 

 I need to join:

--RIDW.VW_TESTSCRIPT_STEP 

And

--RIDW.VW_EXECUTION_STEP_RESULT


Onto the other views in the query that I know have complete data: 

--RIDW.VW_REQUIREMENT
--RIDW.VW_TESTCASE
--RIDW.VW_EXECUTION_WORKITEM
--RIDW.VW_REQUEST
--RIDW.VW_REQUIREMENT_REQUEST_LOOKUP
--RIDW.VW_REQUIREMENT_TESTCASE_LOOKUP


I need to know what columns the second set of views have in common with the test script step views. I am not familiar with all of the ID columns in the test script step views so I cannot be sure that they match up, even though they may have the same name. Can I get more detailed information on if the test script step views have columns in common with the second set of views I have listed?  


Jazz version 6.0.5
Data Warehouse Data Source
 
Thank you <o:p> </o:p>