PSOWNERAPP_DES_CATEGORY1=Objects
2=Tools
3=Misc.
OBJNAMEY/N Table Edit
Default: N
Prompt Table: PSPTRECDEFNDVW
APP_DES_OBJCSTV |
index back |
|---|---|
Application Designer Objects |
| SELECT PSOWNER , APP_DES_CATEGORY , OBJNAME , SECURE , SEARCHRECNAME FROM %Table(APP_DES_OBJ_CST) UNION SELECT PSOWNER , APP_DES_CATEGORY , OBJNAME , 'N' , ' ' FROM %Table(APP_DES_OBJECTS) WHERE OBJECTTYPE <> 9999 AND OBJNAME NOT IN ( SELECT OBJNAME FROM %Table(APP_DES_OBJ_CST)) |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PSOWNER |
Character(8) | VARCHAR2(8) NOT NULL | Owner |
| APP_DES_CATEGORY |
Character(1) | VARCHAR2(1) NOT NULL |
category
1=Objects 2=Tools 3=Misc. |
| OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Object Name |
| SECURE | Character(1) | VARCHAR2(1) NOT NULL |
Secure
Y/N Table Edit Default: N |
| SEARCHRECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Search Record Name
Prompt Table: PSPTRECDEFNDVW |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |