DFW_ADM_SEC_PL |
index back |
|---|
| SELECT DISTINCT RU.ROLEUSER , PC.MENUNAME , PC.BARNAME , PC.BARITEMNAME , PC.PNLITEMNAME FROM PSROLEUSER RU , PSROLECLASS RC , PSAUTHITEM PC WHERE RU.ROLENAME = RC.ROLENAME AND RC.CLASSID = PC.CLASSID |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |
| MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| BARITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Bar Item Name |
| PNLITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Panel Item Name |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |