RBW_UA_RISK_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_UA_RISK_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 FROM PS_RBW_CLIENT_RISK A WHERE RISK_ID NOT IN ( SELECT RISK_ID FROM PS_RBW_RECO_TEAM)

# 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

#	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