BUDGET_PERIODBUDGET_BUS_UNITSCENARIOTRN_LST_ASCE_VW(SQL View) |
Index Back |
|---|---|
All Scenarios List ViewAll Scenarios List View |
| SELECT BUDGET_PERIOD, BUSINESS_UNIT, SCENARIO FROM PS_TRN_SCENARIO GROUP BY BUDGET_PERIOD, BUSINESS_UNIT, SCENARIO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUDGET_PERIOD |
Character(10) | VARCHAR2(10) NOT NULL | Budget Period |
| 2 | BUDGET_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | SCENARIO |
Character(10) | VARCHAR2(10) NOT NULL | Scenario |