TEST_CASE_FLDVW

(SQL View)
Index Back

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).