Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAID BUDGET COMPONENT Table


XXX


Field Name

Description

Data Type

Length

BUDCAT_ITEM_TOKEN

XXX

NUMBER

BUDGET_AMOUNT

The estimated amount for a budget item (eg. Tuition, Room, Books) in a financial aid year.

NUMBER

BUDGET_AMOUNT_TYPE

XXX

VARCHAR2

1

BUDGET_CATEGORY_DESCRIPTION

XXX

VARCHAR2

20

BUDGET_CATEGORY_TOKEN

XXX

NUMBER

BUDGET_COMPONENT_DESC

XXX

VARCHAR2

40

BUDGET_TYPE

The budget type codes: FEDR=Federal, INST=Institutional, PELL=Pell. The method applied in calculating the total budget amount (or the total cost of attendance) of the student for an aid year.

VARCHAR2

1

FAID_PERIOD

XXX

VARCHAR2

6

FAID_TERM

XXX

VARCHAR2

13

FAID_YEAR

XXX

NUMBER

FAID_YEAR_DESC

XXX

VARCHAR2

23

MITSIS_TERM_CODE

XXX

VARCHAR2

42

POE_TOKEN

XXX

NUMBER

WAREHOUSE_INSERT_TIMESTAMP

XXX

DATE

WAREHOUSE_UPDATE_TIMESTAMP

XXX

DATE