FSPC_MST_WRKLST(SQL Table) |
Index Back |
|---|---|
Pagelet Config - My Work LinksAdministrator level configuration |
| # | 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_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Link Label |
| 5 | FSPC_PUBLIC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Send to Vendor
Y/N Table Edit Default Value: N |
| 6 | DISPLAY_ORDER | Number(3,0) | SMALLINT NOT NULL | Display order for ordering items in a list - web style |
| 7 | SHOW_LINK | Character(1) | VARCHAR2(1) NOT NULL |
FSWC - Show Link
Y/N Table Edit Default Value: Y |
| 8 | SHOW_COUNT | Character(1) | VARCHAR2(1) NOT NULL |
FSPC - Show Count
Y/N Table Edit Default Value: N |
| 9 | FSPC_WRK_LINK_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Link Type
1=System-Defined 2=User-Defined 3=Events and Notifications Alert 4=Worklist Default Value: 1 |
| 10 | FILTER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Filter criteria identification
Prompt Table: FSPC_FILTER_VW |
| 11 | FSPC_SYS_LINK_ID | Character(22) | VARCHAR2(22) NOT NULL | Link ID |
| 12 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: FSFBRECDEFN_VW3 |
| 13 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: EOAWPACKAGE_VW |
| 14 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL |
Application Class Full Path
Prompt Table: EOAWAPCLSPTH_VW |
| 15 | PACKAGEROOT_FL | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: EOAWPACKAGE_VW |
| 16 | APPCLASS_PATH_FL | Character(254) | VARCHAR2(254) NOT NULL |
Application Class Full Path
Prompt Table: EOAWAPCLSPTH_V1 |
| 17 | EOEN_PRCS_NAME | Character(30) | VARCHAR2(30) NOT NULL |
EOEN Process Name
Prompt Table: EOEN_PRCS_VW |
| 18 | EOEN_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL |
EOEN Category
Prompt Table: EOEN_REG |
| 19 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Worklist Name
Prompt Table: FSPC_WLNAME_VW |
| 20 | EOWC_CLASSIC_FLUID | Character(1) | VARCHAR2(1) NOT NULL |
Classic/Fluid
1=Classic 2=Fluid 3=Both |
| 21 | EOWC_SHOW_IN_SFF | Character(1) | VARCHAR2(1) NOT NULL |
WorkCenter Framework Field - My Work Link will show in small form factor
Y/N Table Edit Default Value: N |