RA_WL_OFFPRP_VW (SQL View)	Index Back
Worklist Purpose View This view performs a left outer join from the transaction worklist table with the worklist sibling record to return the most recent notification purpose. The outer join is required because the sibling record may not yet exist at the time is the view is run. This view is specific to Marketing Offer worklist.

RA_WL_OFFPRP_VW

(SQL View)

Worklist Purpose View

This view performs a left outer join from the transaction worklist table with the worklist sibling record to return the most recent notification purpose. The outer join is required because the sibling record may not yet exist at the time is the view is run. This view is specific to Marketing Offer worklist.

SELECT A.SYNCID , CASE WHEN B.WF_PURPOSE <> ' ' THEN B.WF_PURPOSE ELSE A.WF_PURPOSE END FROM PS_RA_WF_OFFER_VW 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 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.

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