RBW_RECO_SRHLVW (SQL View)	Index Back
Risk Recovery Task Template This record tracks the tasks template for various risks.

RBW_RECO_SRHLVW

(SQL View)

Risk Recovery Task Template

This record tracks the tasks template for various risks.

SELECT A.RISK_REASON ,L.LANGUAGE_CD , L.XLATLONGNAME FROM PS_RBW_RECO_TEMPL A , PSXLATITEM B , PSXLATITEMLANG L WHERE A.RISK_REASON = B.FIELDVALUE AND B.FIELDNAME = 'RISK_REASON' AND EFF_STATUS = 'A' AND B.FIELDVALUE = L.FIELDVALUE AND B.FIELDNAME = L.FIELDNAME AND B.EFFDT = L.EFFDT

Related Language Record for RBW_RECO_SRH_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RISK_REASON Character(4) VARCHAR2(4) NOT NULL The reason why a certain Risk Event was generated
ACAT=ACATS
NOAC=No Activity
OTH=Others
TEFA=Financial Advisor Terminated

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 RISK_REASON_LONG Character(30) VARCHAR2(30) NOT NULL Risk Reason Long displays the long description of RISK_REASON translate value in the search results.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RISK_REASON	Character(4)	VARCHAR2(4) NOT NULL	The reason why a certain Risk Event was generated ACAT=ACATS NOAC=No Activity OTH=Others TEFA=Financial Advisor Terminated
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	RISK_REASON_LONG	Character(30)	VARCHAR2(30) NOT NULL	Risk Reason Long displays the long description of RISK_REASON translate value in the search results.