PNLGRPNAMEMARKETMENUNAMESEC_DISP_VW1(SQL View) |
Index Back |
|---|---|
Sec Display DerivedDerived work record for troubleshooting Row level Security. |
| SELECT A.PNLGRPNAME , A.MARKET , B.MENUNAME , A.SEARCHRECNAME , A.ADDSRCHRECNAME , B.SEARCHRECNAME FROM PSPNLGRPDEFN A , PSMENUITEM B WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | MENUNAME |
Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 4 | SEARCHRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Search Record Name |
| 5 | ADDSRCHRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Additional Search Record Name |
| 6 | SEARCH_OVERRIDE | Character(15) | VARCHAR2(15) NOT NULL | Override Search Record at the Menu item level |