Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAID BUDGET COMPONENT Table


View exposing financial-aid budget-component reference and amount detail by year, term, period, and budget category including budget component descriptions and amounts.


Field Name

Description

Data Type

Length

BUDCAT_ITEM_TOKEN

Budcat item token associated with the record.

NUMBER

BUDGET_AMOUNT

Budget amount associated with the record.

NUMBER

BUDGET_AMOUNT_TYPE

Budget amount type associated with the record.

VARCHAR2

1

BUDGET_CATEGORY_DESCRIPTION

Description of budget category.

VARCHAR2

20

BUDGET_CATEGORY_TOKEN

Budget category token associated with the record.

NUMBER

BUDGET_COMPONENT_DESC

Description of budget component.

VARCHAR2

40

BUDGET_TYPE

Budget type associated with the record.

VARCHAR2

1

FAID_PERIOD

Faid period associated with the record.

VARCHAR2

6

FAID_TERM

Faid term associated with the record.

VARCHAR2

13

FAID_YEAR

Faid year associated with the record.

NUMBER

FAID_YEAR_DESC

Description of faid year.

VARCHAR2

23

MITSIS_TERM_CODE

Code identifying mitsis term.

VARCHAR2

42

POE_TOKEN

Poe token associated with the record.

NUMBER

WAREHOUSE_INSERT_TIMESTAMP

Warehouse insert timestamp associated with the warehouse record.

DATE

WAREHOUSE_UPDATE_TIMESTAMP

Warehouse update timestamp associated with the warehouse record.

DATE