RDH_WF_EXCPT_VW (SQL View)	Index Back
Merge Admin Worklist view It is used for Merge Admin's worklist.

RDH_WF_EXCPT_VW

(SQL View)

Merge Admin Worklist view

It is used for Merge Admin's worklist.

SELECT A.OPRID , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.INSTSTATUS , A.INSTAVAILABLEDTTM , A.INSTTIMEOUTDTTM , A.ORIGINATORID , B.WORKLIST_DESCR , C.MERGE_ID , C.BO_ID_FROM , C.BO_ID_TO , C.MERGE_HANDLER_ID , C.MERGE_EXCEPT_DTTM , A.WL_PRIORITY , A.COMMENTSHORT , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , A.SYNCID FROM PSWORKLIST A , PS_RDH_WF_MERGE_WL B , PS_RDH_MERGE_LOG C 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 AND B.MERGE_ID = C.MERGE_ID AND B.BO_ID_TO = C.BO_ID_TO AND B.BO_ID_FROM = C.BO_ID_FROM AND B.MERGE_HANDLER_ID = C.MERGE_HANDLER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN

2 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
Prompt Table: PSBUSPROCDEFN

3 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: ACTIVITY_PROMPT

4 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
Prompt Table: PSEVENTDEFN

5 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
Prompt Table: WORKLIST_PRMPT

6 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
Default Value: 999999999

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 NOT NULL 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
Prompt Table: PSOPRDEFN

11 WORKLIST_DESCR Character(50) VARCHAR2(50) NOT NULL Description

12 MERGE_ID Number(15,0) DECIMAL(15) NOT NULL CDH Batch Merge ID

13 BO_ID_FROM Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
Prompt Table: BO

14 BO_ID_TO Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
Prompt Table: BO

15 MERGE_HANDLER_ID Character(167) VARCHAR2(167) NOT NULL Application Class Full Path of the Merge Handler

16 MERGE_EXCEPT_DTTM DateTime(26) TIMESTAMP Merge Exception DateTime

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

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

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

20 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). Prompt Table: PSOPRDEFN
2	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN). Prompt Table: PSBUSPROCDEFN
3	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN). Prompt Table: ACTIVITY_PROMPT
4	EVENTNAME	Character(30)	VARCHAR2(30) NOT NULL	Defines a routing event for PS Workflow Prompt Table: PSEVENTDEFN
5	WORKLISTNAME	Character(30)	VARCHAR2(30) NOT NULL	Worklist Name Prompt Table: WORKLIST_PRMPT
6	INSTANCEID	Number(10,0)	DECIMAL(10) NOT NULL	For a given worklist the unique number of rows in PSWORKLIST Default Value: 999999999
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 NOT NULL	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 Prompt Table: PSOPRDEFN
11	WORKLIST_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description
12	MERGE_ID	Number(15,0)	DECIMAL(15) NOT NULL	CDH Batch Merge ID
13	BO_ID_FROM	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID Prompt Table: BO
14	BO_ID_TO	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID Prompt Table: BO
15	MERGE_HANDLER_ID	Character(167)	VARCHAR2(167) NOT NULL	Application Class Full Path of the Merge Handler
16	MERGE_EXCEPT_DTTM	DateTime(26)	TIMESTAMP	Merge Exception DateTime
17	WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=1-High 2=2-Medium 3=3-Low
18	COMMENTSHORT	Character(30)	VARCHAR2(30) NOT NULL	Short Comment
19	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.
20	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.