Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BUDGET GROUPINGS Table


Budget groupings


Field Name

Description

Data Type

Length

AREA

The square footage of a particular space. In BUDGET GROUPINGS, AREA refers to the budget area.

VARCHAR2

22

AREA_NAME

xxx

VARCHAR2

40

BAG

Budget Authorization Group

VARCHAR2

6

BAG_NAME

Descriptive text for BAG (Budget Authorization Group)

VARCHAR2

40

COST_COLLECTOR_KEY

Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

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

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8