BUSINESS_UNITADBSP_BUADB_NONVW(SQL View) |
Index Back |
|---|---|
Sec Vw - ADB for a BU |
| select a.business_unit ,c.adb ,c.descr from ps_bu_led_tbl a ,PS_BU_LED_GRP_TBL b ,ps_adb_defn_tbl c 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 |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |