RBW_RC_R1_VW

(SQL View)
 Index Back

Rel Class Role 1 view

View of Role 1 values for a given Relationship Classification

SELECT DISTINCT RC.REL_CLASS_ID , ROLT.ROLE_TYPE_ID , ROLT.DESCR FROM PS_RBW_REL_CLASS RC , PS_RBW_REL_CLS_ROL RCR , PS_BO_REL_TYPE RELT , PS_BO_ROLE_TYPE ROLT WHERE RC.REL_CLASS_ID = RCR.REL_CLASS_ID AND RELT.REL_TYPE_ID = RCR.REL_TYPE_ID AND (ROLT.ROLE_TYPE_ID = RELT.ROLE_TYPE_ID_1 OR ROLT.ROLE_TYPE_ID = RELT.ROLE_TYPE_ID_2) AND ROLT.ROLE_TYPE_ID <> RC.ROLE_TYPE_ID_ORG

  • Related Language Record: RBW_RC_R1_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REL_CLASS_ID Number(12,0) DECIMAL(12) NOT NULL Unique identifier of a Relationship Classification in Wealth Management
    2 ROLE_TYPE_ID_1 Number(12,0) DECIMAL(12) NOT NULL Role Type ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description