BUDGET GROUPINGS Table
View exposing budget grouping assignments by cost collector including area, bag, and PBM hierarchy levels used for budget reporting and rollups.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AREA |
Area as provided by the source. |
VARCHAR2 |
12 |
AREA_NAME |
Area name as provided by the source. |
VARCHAR2 |
40 |
BAG |
Bag as provided by the source. |
VARCHAR2 |
6 |
BAG_NAME |
Bag name as provided by the source. |
VARCHAR2 |
40 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
MAJOR_AREA |
Major area as provided by the source. |
VARCHAR2 |
6 |
MAJOR_AREA_NAME |
Major area name as provided by the source. |
VARCHAR2 |
40 |
PBM_LEVEL1 |
Pbm level1 as provided by the source. |
VARCHAR2 |
6 |
PBM_LEVEL1_NAME |
Pbm level1 name as provided by the source. |
VARCHAR2 |
40 |
PBM_LEVEL2 |
Pbm level2 as provided by the source. |
VARCHAR2 |
6 |
PBM_LEVEL2_NAME |
Pbm level2 name as provided by the source. |
VARCHAR2 |
40 |
PBM_LEVEL3 |
Pbm level3 as provided by the source. |
VARCHAR2 |
6 |
PBM_LEVEL3_NAME |
Pbm level3 name as provided by the source. |
VARCHAR2 |
40 |
SORT_AREA |
Sort area as provided by the source. |
VARCHAR2 |
48 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |