EO_EIP_C_SET_VW(SQL View) |
Index Back |
|---|---|
View over EO_EIP_CTL_SET |
| SELECT EIP_PROGRAM , DESCR , EIP_GRID_BTN , EIP_BU_SETID_SEL , PROMPT_TBL , PNLGRPNAME , PNLNAME , ROLENAME ,OPRID , MENUNAME , BARNAME , ITEMNAME , PANELITEMNAME , EIP_XFERCODE ,EIP_ACTION_MODE FROM PS_EO_EIP_CTL_SET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EIP_PROGRAM |
Character(10) | VARCHAR2(10) NOT NULL |
Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync 701=BOM Sync 801=Item Revision 901=Item Bus Unit Sync 902=Item Sync |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | EIP_GRID_BTN | Character(3) | VARCHAR2(3) NOT NULL |
EIP Grid Button
001=Stage Table 002=Queue Based 003=Select Trans |
| 4 | EIP_BU_SETID_SEL | Character(3) | VARCHAR2(3) NOT NULL |
BU/SETID Control
001=Business Unit 002=Set ID |
| 5 | PROMPT_TBL | Character(15) | VARCHAR2(15) NOT NULL | Prompt Table |
| 6 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 7 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 8 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 10 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: PSMENUDEFN |
| 11 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table: PSMENUITEM_VW1 |
| 12 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL |
Item Name
Prompt Table: PSMENUITEM |
| 13 | PANELITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Panel Item Name |
| 14 | EIP_XFERCODE | Character(1) | VARCHAR2(1) NOT NULL |
Panel Transfer Type - DoModaPanelGroupl Transfer, Transfer Panel(Next Panel), Non Modal Transfer to a Different Panel Group.
1=Modal Transfer 2=Transfer Panel(Next Panel) 3=Transfer to a Diff Panel Group |
| 15 | EIP_ACTION_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Action Mode for PnlGrp Launch
A=Add C=Correction E=Data Entry L=Update/Display all U=Update |