RB_WL_COMNT_VW (SQL View)	Index Back
Worklist Comments View This view performs a left outer join from the main worklist table with the worklist sibling record to return the most recent comments. The outer join is required because the sibling record may not yet exist at the time is the view is run.

RB_WL_COMNT_VW

(SQL View)

Worklist Comments View

This view performs a left outer join from the main worklist table with the worklist sibling record to return the most recent comments. The outer join is required because the sibling record may not yet exist at the time is the view is run.

SELECT A.SYNCID , CASE WHEN B.COMMENTS254 <> ' ' THEN B.COMMENTS254 ELSE A.COMMENTSHORT END 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 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 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)

#	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	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)