MENUNAMEPrompt Table: PSMENUDEFN
BARNAMEPrompt Table: RSEC_MENU_VW1
ITEMNAMEPrompt Table: RSEC_MENU_VW2
PANELITEMNAMEPrompt Table: RSEC_MENU_VW1
LANGUAGE_CDRSEC_DMN_LNG_VW(SQL View) |
Index Back |
|---|---|
View of config search menu'sRelated language view that gets the description of the component name that is used for defining dynamic security criteria. |
| SELECT A.MENUNAME , A.BARNAME , A.ITEMNAME , C.ITEMNAME , E.LANGUAGE_CD , E.DESCR FROM PSMENUITEM A , PSPNLGRPDEFN B , PSPNLGROUP C , PS_RB_FILTER_DEFN D , PSPNLGDEFNLANG E WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND B.PNLGRPNAME = C.PNLGRPNAME AND B.MARKET = C.MARKET AND C.PNLGRPNAME = D.PNLGRPNAME AND C.MARKET = D.MARKET AND C.PNLNAME = D.PNLNAME AND D.RSEC_APP_SCRTY_FLG = 'Y' AND B.PNLGRPNAME = E.PNLGRPNAME AND B.MARKET = E.MARKET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MENUNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: PSMENUDEFN |
| 2 | BARNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table: RSEC_MENU_VW1 |
| 3 | ITEMNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Item Name
Prompt Table: RSEC_MENU_VW2 |
| 4 | PANELITEMNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Panel Item Name
Prompt Table: RSEC_MENU_VW1 |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |