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 | 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 Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |