RBW_RECO_SRH_VW

(SQL View)
 Index Back

Risk Recovery Task Template

This record tracks the tasks template for various risks.

SELECT A.RISK_REASON , B.XLATLONGNAME , A.RB_TSK_TPL_ID FROM PS_RBW_RECO_TEMPL A , PSXLATITEM B WHERE A.RISK_REASON = B.FIELDVALUE AND B.FIELDNAME = 'RISK_REASON' AND EFF_STATUS = 'A'

  • Related Language Record: RBW_RECO_SRHLVW

    • # 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 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.
    3 RB_TSK_TPL_ID Character(15) VARCHAR2(15) NOT NULL Task Template ID. Used by Task Management.

    Prompt Table: RB_TGRP_ALL_VW