RB_WF_PT_AMM_VW (SQL View)	Index Back
Application Message Worklist This view returns all active worklist entries for the PeopleTools Application Message Instance Error Notification Business Process.

RB_WF_PT_AMM_VW

(SQL View)

Application Message Worklist

This view returns all active worklist entries for the PeopleTools Application Message Instance Error Notification Business Process.

SELECT A.OPRID , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.INSTSTATUS , A.INSTAVAILABLEDTTM , A.INSTTIMEOUTDTTM , A.ORIGINATORID , B.IBPUBTRANSACTID , B.PUBNODE , B.QUEUENAME , B.IB_OPERATIONNAME , B.ACTIONNAME , B.SUBNODE , B.STATUSSTRING , A.WL_PRIORITY , ' ' , A.COMMENTSHORT , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , A.SYNCID FROM PSWORKLIST A , PS_PT_EIP_MSG_WL B WHERE A.BUSPROCNAME = B.BUSPROCNAME AND A.ACTIVITYNAME = B.ACTIVITYNAME AND A.EVENTNAME = B.EVENTNAME AND A.WORKLISTNAME = B.WORKLISTNAME AND A.INSTANCEID = B.INSTANCEID AND A.INSTSTATUS <= 2

# 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 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 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
0=Selected
1=Open
2=Worked
3=Cancelled

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

9 INSTTIMEOUTDTTM DateTime(26) TIMESTAMP Datetime that a worklist times out

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

11 IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID

12 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.

13 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).

14 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).

15 ACTIONNAME Character(30) VARCHAR2(30) NOT NULL Action Name

16 SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node

17 STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String

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

19 WF_PURPOSE Character(4) VARCHAR2(4) NOT NULL Purpose of the Notification
0=FYI
APPR=Approval Required
ASSN=Assignment
ESCA=Escalation
FOLL=Follow-Up Requested
HOLD=Hold Notification
SLA=SLA Warning
SLAX=SLA Exception
STAT=Status Change
TASG=Task Assignment
UPD=Update Notification

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

21 SHOW_COMPLETED Character(1) VARCHAR2(1) NOT NULL This field is used to determine whether the worklist should be filtered to show only completed worklist entries.
Y/N Table Edit
Default Value: N

22 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

#	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	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	INSTSTATUS	Number(5,0)	INTEGER NOT NULL	Determines worklist status, available, selected, worked, cancelled 0=Selected 1=Open 2=Worked 3=Cancelled
8	INSTAVAILABLEDTTM	DateTime(26)	TIMESTAMP	Datetime worklist instance was made available
9	INSTTIMEOUTDTTM	DateTime(26)	TIMESTAMP	Datetime that a worklist times out
10	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
11	IBPUBTRANSACTID	Character(36)	VARCHAR2(36) NOT NULL	Orig Transaction ID
12	PUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
13	QUEUENAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSQUEUEDEFN).
14	IB_OPERATIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation (see PSOPERATION).
15	ACTIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Action Name
16	SUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Subscribing Node
17	STATUSSTRING	Character(5)	VARCHAR2(5) NOT NULL	Status String
18	WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=1-High 2=2-Medium 3=3-Low
19	WF_PURPOSE	Character(4)	VARCHAR2(4) NOT NULL	Purpose of the Notification 0=FYI APPR=Approval Required ASSN=Assignment ESCA=Escalation FOLL=Follow-Up Requested HOLD=Hold Notification SLA=SLA Warning SLAX=SLA Exception STAT=Status Change TASG=Task Assignment UPD=Update Notification
20	COMMENTSHORT	Character(30)	VARCHAR2(30) NOT NULL	Short Comment
21	SHOW_COMPLETED	Character(1)	VARCHAR2(1) NOT NULL	This field is used to determine whether the worklist should be filtered to show only completed worklist entries. Y/N Table Edit Default Value: N
22	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.