RB_WF_FEED_VW

(SQL View)
 Index Back

Worklist view for Webservice

This view returns worklist items for worklist RSS feed.

SELECT 'DUMMY1' , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , B.DESCR , A.OPRID , A.ORIGINATORID , A.INSTSTATUS , A.TIMEDOUT , A.WL_PRIORITY , A.URL , A.INSTAVAILABLEDTTM , A.COMMENTSHORT , A.DESCR254_MIXED , A.LASTUPDDTTM , %TextIn('DUMMY2') FROM PSWORKLIST A , PS_RB_WL_GRID_DFN B WHERE B.WORKLISTNAME = A.WORKLISTNAME AND A.INSTSTATUS < 2

  • Related Language Record: RB_WF_FEED_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RELEASELABEL Character(50) VARCHAR2(50) NOT NULL Release Label
    00=Core
    10=Education and Government
    18=Service Industries
    19=Comm., Transportation & Util
    20=Retail
    21=Performance Measurement
    22=HealthCare
    23=Student Administration
    25=U.S. Federal Govt
    26=Canadian Govt
    30=Intl Translations
    32=Netherlands
    33=United Kingdom
    34=Espanol/Spain
    35=France
    36=Portuguese
    37=Italy
    39=German
    50=South Africa
    60=Latin America Local
    61=Mexico
    62=Argentina
    63=Brazil
    81=Japanese
    88=Asia/Pacific
    99=PeopleSoft Select
    2 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
    3 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
    4 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
    5 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
    6 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    9 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    10 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
    0=Selected
    1=Open
    2=Worked
    3=Cancelled
    11 TIMEDOUT Number(5,0) INTEGER NOT NULL Timed Out
    12 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
    1=1-High
    2=2-Medium
    3=3-Low
    13 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    14 INSTAVAILABLEDTTM DateTime(26) TIMESTAMP Datetime worklist instance was made available
    15 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
    16 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    18 WF_HTMLAREA Long Character CLOB HTML Area