BU_ADB_LANG

(SQL View)
 Index Back

ADB for a BU RLR


select b.business_unit ,L.adb ,L.LANGUAGE_CD ,L.DESCR from PS_BUS_UNIT_TBL_FS b ,PS_ADB_DEFN_LANG L where L.setid = ( select d.setid from ps_set_cntrl_rec d where d.setcntrlvalue = b.business_unit and d.recname = 'ADB_DEFN_TBL')

  • Related Language Record for SP_BUADB_CLSVW SP_BUADB_NONVW SP_BUADB_OPRVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ADB Character(10) VARCHAR2(10) NOT NULL Average Daily Balances
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description