RBQ_FLD_RL_VW

(SQL View)
 Index Back

Field Role View

Prompt record for Field definition role view.

SELECT A.FLDDFN_ID , A.ROLE_TYPE_ID , B.DESCR FROM %Table(RBQ_FLDDFN_RL) A , %Table(BO_ROLE_TYPE) B WHERE A.ROLE_TYPE_ID = B.ROLE_TYPE_ID

  • Related Language Record: RBQ_FLD_RL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FLDDFN_ID Character(20) VARCHAR2(20) NOT NULL BO Search Role ID
    2 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

    Prompt Table: BO_ROLE_TYPE

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description