FSPC_ADM_LNKLST(SQL Table) | 
Index Back | 
|---|---|
Workcenter TableFSWC-Workcenter Table | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(18) | VARCHAR2(18) NOT NULL | FSWC-Workcenter ID | |
| 2 | Character(36) | VARCHAR2(36) NOT NULL | Group ID | |
| 3 | Character(36) | VARCHAR2(36) NOT NULL | Link ID | |
| 4 | FSPC_LINK_TYPE | Character(1) | VARCHAR2(1) NOT NULL | 
Link Type
 1=Menu Item 2=URL Default Value: 1  | 
| 5 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). | 
| 6 | PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Item Name | 
| 7 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) | 
| 8 | FSPC_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Link Label | 
| 9 | FSPC_PUBLIC_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
Send to Vendor
 Y/N Table Edit Default Value: N  | 
| 10 | DISPLAY_ORDER | Number(3,0) | SMALLINT NOT NULL | Display order for ordering items in a list - web style | 
| 11 | SHOW_LINK | Character(1) | VARCHAR2(1) NOT NULL | 
FSWC - Show Link
 Y/N Table Edit Default Value: Y  | 
| 12 | FSPC_DATA_SOURCE | Character(1) | VARCHAR2(1) NOT NULL | 
Data Source
 1=Administrator 2=User Default Value: 1  | 
| 13 | FSPC_OVERRIDE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 
override label for workcenter
 Y/N Table Edit Default Value: N  | 
| 14 | NEW_WINDOW | Character(1) | VARCHAR2(1) NOT NULL | 
Open in New Window
 Y/N Table Edit Default Value: N  |