PTAI_CHKSEC_VW(SQL View) |
Index Back |
|---|
| SELECT Z.ROLEUSER , Z.ROLENAME , Y.CLASSID , A.MENUNAME , A.PNLGRPNAME , A.MARKET , B.PNLNAME , C.BARNAME , C.BARITEMNAME , C.PNLITEMNAME FROM PSROLEUSER Z , PSROLECLASS Y , PSMENUITEM A , PSPNLGROUP B , PSAUTHITEM C WHERE Y.ROLENAME = Z.ROLENAME AND Y.CLASSID = C.CLASSID AND A.MENUNAME = C.MENUNAME AND A.BARNAME = C.BARNAME AND A.ITEMNAME = C.BARITEMNAME AND A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND C.AUTHORIZEDACTIONS > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |
| 2 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 3 | CLASSID | Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
| 4 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 5 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 6 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 7 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 8 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| 9 | BARITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Bar Item Name |
| 10 | PNLITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Panel Item Name |