Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID BUDGET COMPONENT Table


View exposing budget component reference data used in financial aid cost-of-attendance calculations and need analysis.


Field Name

Description

Data Type

Length

AID_PERIOD

Aid period associated with the record.

VARCHAR2

30

AID_YEAR

Aid year associated with the record.

VARCHAR2

4

BUDGET_AMOUNT

Budget amount associated with the record.

NUMBER

11,2

BUDGET_CATEGORY

Budget category associated with the record.

VARCHAR2

30

BUDGET_COMPONENT

Budget component associated with the record.

VARCHAR2

30

BUDGET_COMPONENT_KEY

Surrogate key identifying the budget component.

VARCHAR2

24

BUDGET_GROUP

Budget group associated with the record.

VARCHAR2

30

BUDGET_TYPE

Budget type associated with the record.

VARCHAR2

4

TERM_CODE

Code identifying term.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE