PSOWNERAPP_DES_CATEGORY1=Objects
2=Tools
3=Misc.
OBJNAMEACCESS_CDN=No Access
Y=Read/Write Access
APPDES_OBJ_PERM(SQL Table) |
Index Back |
|---|
| # | 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 | ACCESS_CD |
Character(1) | VARCHAR2(1) NOT NULL |
Access Code
N=No Access Y=Read/Write Access |
| 5 | ACCESS_PERMISSION | Character(30) | VARCHAR2(30) NOT NULL | Access Permission |