PSPTTSTDEFN_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTTST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Test Name (see PSPTTSTDEFN). |
| 2 | PTTST_PARENTFOLDER | Character(200) | VARCHAR2(200) NOT NULL | Test Parent Folder |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |