BUSINESS_UNITSP_BAM_RC_NONVW(SQL View) |
Index Back |
|---|---|
Call Center Business UnitsView used by call center to get all business units registered on support cases. |
| SELECT BUSINESS_UNIT FROM %Table(BUS_UNIT_TBL_RC) WHERE BUSINESS_UNIT IN ( SELECT BUSINESS_UNIT FROM %Table(RC_CASE) WHERE RC_VERTICAL='SW') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |