PIM_WF_PDUP_VW (SQL View)	Index Back
Potential Duplicates PIM Potential Duplicates workflow view

PIM_WF_PDUP_VW

(SQL View)

Potential Duplicates

PIM Potential Duplicates workflow view

SELECT A.OPRID , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.INSTSTATUS , A.INSTAVAILABLEDTTM , A.INSTTIMEOUTDTTM , A.ORIGINATORID , B.PIM_DUP_SYNCID , B.SYNC_DTTM , C.FIRST_NAME , C.LAST_NAME , C.PIM_DUP_STATUS , C.EMAIL_ADDR , C.ADDRESS_DESCR150 , C.PHONE , A.WL_PRIORITY , A.COMMENTSHORT , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , A.SYNCID FROM PSWORKLIST A , %Table(PIM_PDUP_WL) B , %Table(PIM_PDUP_TBL) 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 C.BO_ID = B.BO_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).

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 PIM_DUP_SYNCID Number(10,0) DECIMAL(10) NOT NULL This field is used to store syncid

12 SYNC_DTTM DateTime(26) TIMESTAMP This field is used to store Synchronize datetime

13 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

14 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

15 PIM_DUP_STATUS Character(1) VARCHAR2(1) NOT NULL Field is used to keep track of potential duplicate status
C=Complete
N=New

16 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.

17 ADDRESS_DESCR150 Character(150) VARCHAR2(150) NOT NULL This field is used to store the whole address

18 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.

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

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	PIM_DUP_SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	This field is used to store syncid
12	SYNC_DTTM	DateTime(26)	TIMESTAMP	This field is used to store Synchronize datetime
13	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
14	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
15	PIM_DUP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Field is used to keep track of potential duplicate status C=Complete N=New
16	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
17	ADDRESS_DESCR150	Character(150)	VARCHAR2(150) NOT NULL	This field is used to store the whole address
18	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
19	WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=1-High 2=2-Medium 3=3-Low
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.