PSWEBLIBCREFVW(SQL View) |
Index Back |
---|---|
Authorized Menu Item view |
SELECT DISTINCT CLASSID , MENUNAME , BARNAME , BARITEMNAME , PNLITEMNAME FROM PSAUTHITEM WHERE MENUNAME LIKE 'WEBLIB_%' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CLASSID | Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
2 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: PSMENUDEFN |
3 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
4 | BARITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Bar Item Name |
5 | PNLITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Panel Item Name |