SPB_PAGE_NAMEID_SEQ_ITEMMENUNAMEPrompt Table: PSMENUDEFN
BARNAMEITEMNAMEA=Add
C=Correction
E=Data Entry
L=Update/Display All
U=Update
ADM=Administration
EXP=Expenses
FUL=Fulfillment
PAY=Pay Types
SET=Settlement
SPB_START_PAGE(SQL Table) |
Index Back |
|---|---|
Start PageContains images and text for home pages |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SPB_PAGE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Page Name |
| 2 | ID_SEQ_ITEM |
Number(5,0) | INTEGER NOT NULL | Sequence control for ITEM |
| 3 | IMAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL | The name of images used in Personalizations explanations. |
| 4 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 5 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | MENUNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: PSMENUDEFN |
| 8 | BARNAME |
Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| 9 | ITEMNAME |
Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 10 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 11 | PAGE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Page Name |
| 12 | MENU_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Menu Action
A=Add C=Correction E=Data Entry L=Update/Display All U=Update |
| 13 | SP_MODULE | Character(3) | VARCHAR2(3) NOT NULL |
Module
ADM=Administration EXP=Expenses FUL=Fulfillment PAY=Pay Types SET=Settlement |