BUSPRC_IDBUSPRCSEC_IDTRANS_LINK_IDTRANS_LINK_ORDERN=No
Y=Yes
ESA_LINK(SQL Table) |
Index Back |
|---|---|
ESA LinkESA business process specific hyperlinks used on ESA home pages |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSPRC_ID |
Number(3,0) | SMALLINT NOT NULL | Business Process ID |
| 2 | BUSPRCSEC_ID |
Number(3,0) | SMALLINT NOT NULL | Business Process Section ID |
| 3 | TRANS_LINK_ID |
Number(3,0) | SMALLINT NOT NULL | Transaction Link Id |
| 4 | TRANS_LINK_ORDER |
Number(3,0) | SMALLINT NOT NULL | Transaction Order |
| 5 | PRIMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Primary
N=No Y=Yes |
| 6 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 7 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| 8 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 9 | PAGE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Page Name |
| 10 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 11 | LINK_MSGSET | Number(5,0) | INTEGER NOT NULL | Message Set Number |
| 12 | LINK_MSGNUM | Number(5,0) | INTEGER NOT NULL | Message Number |
| 13 | APPL_ID | Character(10) | VARCHAR2(10) NOT NULL | Application ID |
| 14 | FUNC_GRP_ID | Number(3,0) | SMALLINT NOT NULL | Functional Group Id |