BO_REL_TYPE_VW

(SQL View)
 Index Back

Rel Type view

Relationship Type view to show the descriptions of the 2 Role Types

SELECT A.REL_TYPE_ID , A.DESCR , B.DESCR , C.DESCR , A.HIERARCHICAL_IND , A.PEER2PEER_IND FROM PS_BO_REL_TYPE A , PS_BO_ROLE_TYPE B , PS_BO_ROLE_TYPE C WHERE A.ROLE_TYPE_ID_1 = B.ROLE_TYPE_ID AND A.ROLE_TYPE_ID_2 = C.ROLE_TYPE_ID

  • Related Language Record: BO_REL_TYP_LNG2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID
    2 REL_TYPE_NAME Character(50) VARCHAR2(50) NOT NULL Bus Object Relationship Name
    3 ROLE_TYPE_1_NAME Character(30) VARCHAR2(30) NOT NULL Role Type 1 Name
    4 ROLE_TYPE_2_NAME Character(30) VARCHAR2(30) NOT NULL Role Type 2 Name
    5 HIERARCHICAL_IND Character(1) VARCHAR2(1) NOT NULL Indicates if the relationsip is equivalent or hierarchial.
    N=No
    Y=Yes
    6 PEER2PEER_IND Character(1) VARCHAR2(1) NOT NULL Indicates a Peer to Peer relationship.
    N=No
    Y=Yes

    Y/N Table Edit