FAID FED METHOD NEED ANALY Table
View exposing federal-method need-analysis measures by applicant and award year including original need, calculated financial need, and unmet packaged need.
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 |
16,6 |
FM_ORIGINAL_NEED |
Fm original need associated with the record. |
NUMBER |
16,6 |
FM_UNMET_PACK_NEED |
Fm unmet pack need associated with the record. |
NUMBER |
16,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 |