BO_ROLE_MAP_VW

(SQL View)
Index Back

Business Object Role Type Map

Business Object Role Type Mapping

SELECT MAP.ROLE_TYPE_ID , MAP.BO_MAP_TYPE , MAP.REL_TYPE_ID , %Upper(RL.DESCR ) FROM PS_BO_ROLE_MAP MAP , PS_BO_ROLE_TYPE RL WHERE MAP.ROLE_TYPE_ID = RL.ROLE_TYPE_ID

  • Related Language Record: BO_ROLE_MAPLVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

    Prompt Table: BO_ROLE_TYPE_V1

    2 BO_MAP_TYPE Character(1) VARCHAR2(1) NOT NULL Mapping Type
    1=Role Mapping
    2=Relationship Mapping

    Default Value: 1

    3 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID

    Prompt Table: BO_REL_TYPE_VW1

    4 ROLE_TYPE_NAME Character(30) VARCHAR2(30) NOT NULL Role Type Name