FA_ITEM_AUTH_VW

(SQL View)
Index Back

Authorized Menu Item


SELECT DISTINCT A.CLASSID , A.MENUNAME , A.BARNAME , A.BARITEMNAME FROM PSAUTHITEM A

# 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).
3 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
4 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name