RF_WL_SVCPRP_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 Service Order worklist.

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