RB_WF_FEED_LVW

(SQL View)
 Index Back

Worklist view for Webservice

This view is a related language view to return worklist items in the user's language.

SELECT 'DUMMY1' , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , B.LANGUAGE_CD , B.DESCR FROM PSWORKLIST A , PS_RB_WL_GRID_LANG B WHERE B.WORKLISTNAME = A.WORKLISTNAME

  • Related Language Record for RB_WF_FEED_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description