WF_FEED_VW (SQL View)	Index Back
Worklist view for Webservice

WF_FEED_VW

(SQL View)

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 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

8 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier

9 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled

10 TIMEDOUT Number(5,0) INTEGER NOT NULL Timed Out

11 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Worklist Priority
1=1-High
2=2-Medium
3=3-Low

12 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

13 INSTAVAILABLEDTTM DateTime(26) TIMESTAMP Datetime worklist instance was made available

14 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment

15 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description

16 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.

17 WF_HTMLAREA Long Character CLOB HTML Area

#	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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
8	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
9	INSTSTATUS	Number(5,0)	INTEGER NOT NULL	Determines worklist status, available, selected, worked, cancelled
10	TIMEDOUT	Number(5,0)	INTEGER NOT NULL	Timed Out
11	WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Worklist Priority 1=1-High 2=2-Medium 3=3-Low
12	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
13	INSTAVAILABLEDTTM	DateTime(26)	TIMESTAMP	Datetime worklist instance was made available
14	COMMENTSHORT	Character(30)	VARCHAR2(30) NOT NULL	Short Comment
15	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
16	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.
17	WF_HTMLAREA	Long Character	CLOB	HTML Area