RB_WLOWNER_VW (SQL View)	Index Back
Worklist Owner View This view returns names of users who delegated their worklists.

RB_WLOWNER_VW

(SQL View)

Worklist Owner View

This view returns names of users who delegated their worklists.

SELECT A.DELEGATE_OPRID , A.START_DT , A.END_DT , A.READONLY , A.WORKLIST_PRSN_ID , B.BO_NAME_DISPLAY , A.WORKLISTNAME FROM PS_RB_WL_DELEGATE A , PS_RD_PERSON_NAME B WHERE A.DELEGATE_TYPE = 'I' AND A.WORKLIST_PRSN_ID = B.PERSON_ID AND B.PRIMARY_IND = 'Y' UNION SELECT B.USERID , A.START_DT , A.END_DT , A.READONLY , A.WORKLIST_PRSN_ID , C.BO_NAME_DISPLAY , A.WORKLISTNAME FROM PS_RB_WL_DELEGATE A , PS_RB_WF_GRP_PLIST B , PS_RD_PERSON_NAME C WHERE A.DELEGATE_TYPE = 'G' AND A.DELEGATE_NAME = B.RB_WF_GRP_NAME AND A.WORKLIST_PRSN_ID = C.PERSON_ID AND C.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DELEGATE_OPRID Character(30) VARCHAR2(30) NOT NULL Delegate person ID

2 START_DT Date(10) DATE Start date field to store start date value.

3 END_DT Date(10) DATE This field stores the end date values.

4 READONLY Character(1) VARCHAR2(1) NOT NULL Read Only
Y/N Table Edit

5 WORKLIST_PRSN_ID Character(15) VARCHAR2(15) NOT NULL Worklist assignee

6 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

7 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DELEGATE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Delegate person ID
2	START_DT	Date(10)	DATE	Start date field to store start date value.
3	END_DT	Date(10)	DATE	This field stores the end date values.
4	READONLY	Character(1)	VARCHAR2(1) NOT NULL	Read Only Y/N Table Edit
5	WORKLIST_PRSN_ID	Character(15)	VARCHAR2(15) NOT NULL	Worklist assignee
6	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
7	WORKLISTNAME	Character(30)	VARCHAR2(30) NOT NULL	Worklist Name