RB_WL_SIB_VW (SQL View)	Index Back
Worklist Extension Record This record acts as a sibling extension record to the Tools Worklist record.

RB_WL_SIB_VW

(SQL View)

Worklist Extension Record

This record acts as a sibling extension record to the Tools Worklist record.

SELECT A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.OPRID , A.INSTSTATUS , B.UID20F_FOLDER , B.READ_SW , B.COMMENTS254 , B.WF_PURPOSE FROM PSWORKLIST A , PS_RB_WORKLIST_SIB 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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

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

6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

7 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
0=Selected
1=Open
2=Worked
3=Cancelled

8 UID20F_FOLDER Character(20) VARCHAR2(20) NOT NULL This field is used to store a unique identifier for a folder that is created to categorize CRM worklist notifications.

9 READ_SW Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether a CRM worklist notification has been read by the user.
Y/N Table Edit
Default Value: N

10 COMMENTS254 Character(254) VARCHAR2(254) NOT NULL Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)

11 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN). Prompt Table: PSBUSPROCDEFN
2	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN). Prompt Table: ACTIVITY_PROMPT
3	EVENTNAME	Character(30)	VARCHAR2(30) NOT NULL	Defines a routing event for PS Workflow Prompt Table: PSEVENTDEFN
4	WORKLISTNAME	Character(30)	VARCHAR2(30) NOT NULL	Worklist Name Prompt Table: WORKLIST_PRMPT
5	INSTANCEID	Number(10,0)	DECIMAL(10) NOT NULL	For a given worklist the unique number of rows in PSWORKLIST Default Value: 9999999999
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	INSTSTATUS	Number(5,0)	INTEGER NOT NULL	Determines worklist status, available, selected, worked, cancelled 0=Selected 1=Open 2=Worked 3=Cancelled
8	UID20F_FOLDER	Character(20)	VARCHAR2(20) NOT NULL	This field is used to store a unique identifier for a folder that is created to categorize CRM worklist notifications.
9	READ_SW	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether a CRM worklist notification has been read by the user. Y/N Table Edit Default Value: N
10	COMMENTS254	Character(254)	VARCHAR2(254) NOT NULL	Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)
11	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