WF_FEED_VW

index back

Worklist view for Webservice


SELECT 'DUMMY1' ,BUSPROCNAME , ACTIVITYNAME , EVENTNAME , WORKLISTNAME , INSTANCEID , OPRID , ORIGINATORID , INSTSTATUS , TIMEDOUT , WL_PRIORITY , URL , INSTAVAILABLEDTTM , COMMENTSHORT , DESCR254_MIXED , LASTUPDDTTM , 'DUMMY2' FROM PSWORKLIST

PeopleSoft Field NameField TypeColumn TypeDescription
RELEASELABELCharacter(50)VARCHAR2(50) NOT NULLRelease 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
BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).
ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).
EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow
WORKLISTNAMECharacter(30)VARCHAR2(30) NOT NULLWorklist Name
INSTANCEIDNumber(10,0)DECIMAL(10) NOT NULLFor a given worklist the unique number of rows in PSWORKLIST
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
ORIGINATORIDCharacter(30)VARCHAR2(30) NOT NULLOriginator Identifier
INSTSTATUSNumber(5,0)INTEGER NOT NULLDetermines worklist status, available, selected, worked, cancelled
TIMEDOUTNumber(5,0)INTEGER NOT NULLTimed Out
WL_PRIORITYCharacter(1)VARCHAR2(1) NOT NULLWorklist Priority
1=1-High
2=2-Medium
3=3-Low
URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
INSTAVAILABLEDTTMDateTime(26)TIMESTAMPDatetime worklist instance was made available
COMMENTSHORTCharacter(30)VARCHAR2(30) NOT NULLShort Comment
DESCR254_MIXEDCharacter(254)VARCHAR2(254) NOT NULLDescription
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
WF_HTMLAREALong CharacterCLOBHTML Area
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19