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 | PAGELET_CONFIG_ID | Character(18) | VARCHAR2(18) NOT NULL | FSWC-Workcenter ID |
2 | FSPC_GROUP_ID | Character(36) | VARCHAR2(36) NOT NULL | Group ID |
3 | FSPC_LINK_ID | 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 |