PSOWNERAPP_DES_CATEGORY1=Objects
2=Tools
3=Misc.
OBJNAMEY/N Table Edit
Default Value: N
Prompt Table: PSPTRECDEFNDVW
APP_DES_OBJCSTV(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSOWNER |
Character(8) | VARCHAR2(8) NOT NULL | Owner |
| 2 | APP_DES_CATEGORY |
Character(1) | VARCHAR2(1) NOT NULL |
category
1=Objects 2=Tools 3=Misc. |
| 3 | OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Object Name |
| 4 | SECURE | Character(1) | VARCHAR2(1) NOT NULL |
Secure
Y/N Table Edit Default Value: N |
| 5 | SEARCHRECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Search Record Name
Prompt Table: PSPTRECDEFNDVW |