RBQ_FLDDFNRL_VW

(SQL View)
Index Back

Field Role View

Prompt record for Field Role definition view.

SELECT F.FLDDFN_ID , R.ROLE_TYPE_ID , R.DESCR FROM %Table(RBQ_FLDDFN_RL) F , %Table(BO_ROLE_TYPE) R WHERE F.ROLE_TYPE_ID = R.ROLE_TYPE_ID

  • Related Language Record: RBQ_FLDRLVW_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