BUDGET GROUPINGS HISTORY Table
View exposing historical budget grouping assignments by cost collector and fiscal period 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_FP_KEY |
Surrogate key identifying the cost collector fp. |
VARCHAR2 |
12 |
COST_COLLECTOR_ID |
Business identifier for the cost collector. |
VARCHAR2 |
12 |
MAJOR_AREA |
Major area as provided by the source. |
VARCHAR2 |
12 |
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 |
12 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |