DL_LINK_IDPrompt Table: PSMENUDEFN
Prompt Table: PSMENUITEM_VW1
Prompt Table: PSMENUITEM_VW2
Prompt Table: PSMENUITEM_VW3
A=Add
C=Correction
L=Update/Display All
U=Update/Display
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
DL_LINK_TBL(SQL Table) |
Index Back |
|---|---|
Dynamic Link Setup TableDynamic Link Setup Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DL_LINK_ID |
Character(30) | VARCHAR2(30) NOT NULL | Dynamic Link |
| 2 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: PSMENUDEFN |
| 3 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table: PSMENUITEM_VW1 |
| 4 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL |
Item Name
Prompt Table: PSMENUITEM_VW2 |
| 5 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: PSMENUITEM_VW3 |
| 6 | ACCESS_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Access Mode
A=Add C=Correction L=Update/Display All U=Update/Display |
| 7 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data Default Value: N |