Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAID INST METHOD NEED ANALY Table


View exposing institute-method need-analysis measures by applicant and award year.


Field Name

Description

Data Type

Length

FAID_APPLICANT_KEY

Surrogate key identifying the faid applicant.

VARCHAR2

21

FAID_YEAR

Faid year associated with the record.

NUMBER

FAID_YEAR_DESC

Description of faid year.

VARCHAR2

23

FM_CALC_FINANCIAL_NEED

Fm calc financial need associated with the record.

NUMBER

29,6

FM_ESTM_CALC_ORIG_NEED

Fm estm calc orig need associated with the record.

NUMBER

27,6

FM_UNMET_FINANCIAL_NEED

Fm unmet financial need associated with the record.

NUMBER

29,6

IM_CALC_FINANCIAL_NEED

Im calc financial need associated with the record.

NUMBER

29,6

IM_ORIGINAL_NEED

Im original need associated with the record.

NUMBER

27,6

IM_UNMET_FINANCIAL_NEED

Im unmet financial need associated with the record.

NUMBER

29,6

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

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