BUDGET GROUPINGS HISTORY Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AREA |
The square footage of a particular space. In BUDGET GROUPINGS, AREA refers to the budget area. |
VARCHAR2 |
12 |
AREA_NAME |
xxx |
VARCHAR2 |
40 |
BAG |
Budget Authorization Group |
VARCHAR2 |
6 |
BAG_NAME |
Descriptive text for BAG (Budget Authorization Group) |
VARCHAR2 |
40 |
COST_COLLECTOR_FP_KEY |
Key used to join historical Cost Collector tables and a fact table (Balances by Fiscal Period, Summary Statement Detail) when you want to bring up the cost collector data matching the fiscal period on the fact table. For the current fiscal period, the most recent data will be brought in. |
VARCHAR2 |
12 |
COST_COLLECTOR_ID |
7-digit number which uniquely identifies the Cost Collector. |
VARCHAR2 |
12 |
MAJOR_AREA |
xxx |
VARCHAR2 |
12 |
MAJOR_AREA_NAME |
xxx |
VARCHAR2 |
40 |
PBM_LEVEL1 |
xxx |
VARCHAR2 |
6 |
PBM_LEVEL1_NAME |
xxx |
VARCHAR2 |
40 |
PBM_LEVEL2 |
xxx |
VARCHAR2 |
6 |
PBM_LEVEL2_NAME |
xxx |
VARCHAR2 |
40 |
PBM_LEVEL3 |
xxx |
VARCHAR2 |
6 |
PBM_LEVEL3_NAME |
xxx |
VARCHAR2 |
40 |
SORT_AREA |
xxx |
VARCHAR2 |
12 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |