RBW_RC_R1_VW2

(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 , RELT.REL_TYPE_ID , RELT.ROLE_CARDINALITY_1 , RELT.ROLE_CARDINALITY_2 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_LVW2

    • # 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
    4 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID
    5 ROLE_CARDINALITY_1 Character(1) VARCHAR2(1) NOT NULL Role Cardinality
    1=One
    M=Many
    6 ROLE_CARDINALITY_2 Character(1) VARCHAR2(1) NOT NULL Role Cardinality
    1=One
    M=Many