SP_BUADB_OPRVW

(SQL View)
 Index Back

Sec Vw - ADB for a BU


select l.oprid ,a.business_unit ,c.adb ,c.descr from ps_bu_led_tbl a ,PS_BU_LED_GRP_TBL b ,ps_adb_defn_tbl c ,ps_sec_ledger_opr l where b.business_unit = a.business_unit and b.ledger_group = a.ledger_group and b.adb_reporting = 'Y' and c.setid = (select setid from ps_set_cntrl_rec d where d.setcntrlvalue = a.business_unit and d.recname = 'ADB_DEFN_TBL') and c.ledger = a.ledger and l.ledger=a.ledger

  • Related Language Record: BU_ADB_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 ADB Character(10) VARCHAR2(10) NOT NULL Average Daily Balances
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description