Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAID INSTITUTE BUDGET CATGY Table


XXX


Field Name

Description

Data Type

Length

ADJUSTED_TOTAL

XXX

NUMBER

ADJUSTMENT_AMOUNT

Adjusted amount of MIT Grant

NUMBER

BASE_AMOUNT

XXX

NUMBER

BUDGET_CATEGORY_DESC

XXX

VARCHAR2

20

BUDGET_CATEGORY_TOKEN

XXX

NUMBER

FAID_APPLICANT_KEY

XXX

VARCHAR2

21

FAID_YEAR

XXX

NUMBER

FAID_YEAR_DESC

XXX

VARCHAR2

23

GAINFUL_EMPLOYMENT_ALLOWANCE

XXX

NUMBER

IS_MANUAL_ADJ

XXX

VARCHAR2

1

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

10

STUDENT_TOKEN

XXX

NUMBER

STU_AWARD_YEAR_TOKEN

XXX

NUMBER

WAREHOUSE_INSERT_TIMESTAMP

XXX

DATE

WAREHOUSE_UPDATE_TIMESTAMP

XXX

DATE