RF_WL_SVCPRP_VW(SQL View) |
Index Back |
---|---|
Worklist Purpose ViewThis 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 |