TEST_CSE_RECCVW

(SQL View)
 Index Back

SELECT DISTINCT A.TEST_CASE , B.RECNAME_COMPARE FROM PS_TEST_CASE_OBJ A , PS_TEST_OBJECT_TBL B WHERE A.COMPARE_RESULT = 'Y' AND B.TEST_OBJECT = A.TEST_OBJECT AND B.RECNAME_COMPARE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).