MENUNAMEPrompt Table: CTI_MENU_VW
BARNAMEPrompt Table: CTI_BAR_VW
ITEMNAMEPrompt Table: PSMENUITEM_VW2
SEARCHRECNAMEPrompt Table: PSRECDEFN
RB_EM_SRCHREC_V(SQL View) |
Index Back |
|---|---|
email serachCRM ERMS view used for email search record |
| SELECT A.MENUNAME ,A.BARNAME ,A.ITEMNAME ,B.SEARCHRECNAME FROM PSMENUITEM A ,PSPNLGRPDEFN B WHERE A.PNLGRPNAME=B.PNLGRPNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MENUNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: CTI_MENU_VW |
| 2 | BARNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table: CTI_BAR_VW |
| 3 | ITEMNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Item Name
Prompt Table: PSMENUITEM_VW2 |
| 4 | SEARCHRECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Search Record Name
Prompt Table: PSRECDEFN |