RBW_ALLRISK_VW (SQL View)	Index Back
View to display Risk txns. View used by data set rules to display all risk transactions .This view should also return transactions that do not have recovery team assigned.

RBW_ALLRISK_VW

(SQL View)

View to display Risk txns.

View used by data set rules to display all risk transactions .This view should also return transactions that do not have recovery team assigned.

SELECT A.SYNCID ,A.SYNCDTTM ,B.PERSON_ID FROM PS_RBW_CLIENT_RISK A , PS_RBW_RECO_TEAM B WHERE A.RISK_ID = B.RISK_ID(+)

# 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 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

#	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	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
3	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID