EOWC_WRKLST_VW

(SQL View)
 Index Back

My Work Link View

User level configuration for My Work links

SELECT A.OPRID , A.PAGELET_CONFIG_ID , A.FSPC_GROUP_ID , A.FSPC_LINK_ID , B.FSPC_DESCR , B.FSPC_PUBLIC_FLG , B.DISPLAY_ORDER , B.SHOW_LINK , B.SHOW_COUNT , B.FSPC_WRK_LINK_TYPE , B.FILTER_ID , B.FSPC_SYS_LINK_ID , B.RECNAME , B.PACKAGEROOT , B.APPCLASS_PATH , B.PACKAGEROOT_FL , B.APPCLASS_PATH_FL , B.EOEN_PRCS_NAME , B.EOEN_CATEGORY , B.WORKLISTNAME , B.EOWC_CLASSIC_FLUID , B.EOWC_SHOW_IN_SFF , A.EOWC_MST_GROUP_ID FROM PS_FSPC_USR_WRKLST A , PS_FSPC_MST_WRKLST B WHERE A.PAGELET_CONFIG_ID = B.PAGELET_CONFIG_ID AND A.EOWC_MST_GROUP_ID = B.FSPC_GROUP_ID AND A.FSPC_LINK_ID = B.FSPC_LINK_ID

  • Related Language Record: EOWC_WRKLST_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PAGELET_CONFIG_ID Character(18) VARCHAR2(18) NOT NULL FSWC-Workcenter ID
    3 FSPC_GROUP_ID Character(36) VARCHAR2(36) NOT NULL Group ID
    4 FSPC_LINK_ID Character(36) VARCHAR2(36) NOT NULL Link ID
    5 FSPC_DESCR Character(40) VARCHAR2(40) NOT NULL Link Label
    6 FSPC_PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor

    Y/N Table Edit

    Default Value: N

    7 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style
    8 SHOW_LINK Character(1) VARCHAR2(1) NOT NULL FSWC - Show Link

    Y/N Table Edit

    Default Value: Y

    9 SHOW_COUNT Character(1) VARCHAR2(1) NOT NULL FSPC - Show Count

    Y/N Table Edit

    Default Value: N

    10 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

    11 FILTER_ID Character(10) VARCHAR2(10) NOT NULL Filter criteria identification

    Prompt Table: FSPC_FILTER_VW

    12 FSPC_SYS_LINK_ID Character(22) VARCHAR2(22) NOT NULL Link ID
    13 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: FSFBRECDEFN_VW3

    14 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: EOAWPACKAGE_VW

    15 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

    Prompt Table: EOAWAPCLSPTH_VW

    16 PACKAGEROOT_FL Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: EOAWPACKAGE_VW

    17 APPCLASS_PATH_FL Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

    Prompt Table: EOAWAPCLSPTH_V1

    18 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name

    Prompt Table: EOEN_PRCS_VW

    19 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category

    Prompt Table: EOEN_REG

    20 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name

    Prompt Table: FSPC_WLNAME_VW

    21 EOWC_CLASSIC_FLUID Character(1) VARCHAR2(1) NOT NULL Classic/Fluid
    1=Classic
    2=Fluid
    3=Both
    22 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

    23 EOWC_MST_GROUP_ID Character(36) VARCHAR2(36) NOT NULL Group ID