Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAID APPLICANT MANUAL BUDGET Table


View exposing manually entered financial-aid budget detail by applicant, award year, term, and budget category including budget amount and budget type.


Field Name

Description

Data Type

Length

BUDGET_AMOUNT

Budget amount associated with the record.

NUMBER

BUDGET_CATEGORY_DESCRIPTION

Description of budget category.

VARCHAR2

20

BUDGET_CATEGORY_TOKEN

Budget category token associated with the record.

NUMBER

BUDGET_TYPE

Budget type associated with the record.

VARCHAR2

1

FAID_APPLICANT_KEY

Surrogate key identifying the faid applicant.

VARCHAR2

21

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

MIT_ID

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

VARCHAR2

10

POE_TOKEN

Poe token associated with the record.

NUMBER

STUDENT_TOKEN

Student token associated with the record.

NUMBER

STU_AWARD_YEAR_TOKEN

Stu award year 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