PSPTTSTDEFN_VW |
index back |
---|
SELECT a.pttst_name ,a.pttst_parentfolder ,a.descr ,b.projectname FROM pspttstdefn a ,psprojectdefn b ,PSPROJECTITEM c WHERE a.pttst_name = c.objectvalue2 AND c.objecttype = 105 AND c.projectname = b.projectname UNION SELECT a.pttst_name ,a.pttst_parentfolder ,a.descr ,b.projectname FROM pspttstdefn a ,psprojectdefn b ,PSPROJECTITEM c WHERE a.pttst_name = c.objectvalue1 AND c.objecttype = 104 AND c.projectname = b.projectname |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
PTTST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Test Name (see PSPTTSTDEFN). |
PTTST_PARENTFOLDER | Character(200) | VARCHAR2(200) NOT NULL | Test Parent Folder |
DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |