FA STUDENT PROFILE Table
View exposing student profile records used in financial aid processing, eligibility evaluation, and aid reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_PERIOD |
Aid period associated with the record. |
VARCHAR2 |
6 |
AID_PERIOD_DESC |
Description of aid period. |
VARCHAR2 |
30 |
AID_YEAR |
Aid year associated with the record. |
VARCHAR2 |
4 |
ESTIMATED_FM_NEED |
Estimated fm need associated with the record. |
NUMBER |
9,2 |
FALL_ENROLL_STATUS_CODE |
Code identifying fall enroll status. |
VARCHAR2 |
2 |
FALL_ENROLL_STATUS_DESC |
Description of fall enroll status. |
VARCHAR2 |
50 |
FALL_LOAD_LEVEL_CODE |
Code identifying fall load level. |
VARCHAR2 |
2 |
FALL_LOAD_LEVEL_DESC |
Description of fall load level. |
VARCHAR2 |
50 |
FALL_STUDENT_YEAR |
Fall student year associated with the record. |
VARCHAR2 |
1 |
FALL_UNITS_OF_LOAD |
Fall units of load associated with the record. |
NUMBER |
3 |
FA_APPLICANT_KEY |
Surrogate key identifying the fa applicant. |
VARCHAR2 |
13 |
FA_CLASS_CODE |
Code identifying fa class. |
VARCHAR2 |
1 |
FA_CLASS_CODE_DESC |
Description of fa class code. |
VARCHAR2 |
30 |
FM_NEED |
Fm need associated with the record. |
NUMBER |
9,2 |
FM_PARENT_CONTRIBUTION |
Fm parent contribution associated with the record. |
NUMBER |
9,2 |
FM_STUDENT_CONTRIBUTION |
Fm student contribution associated with the record. |
NUMBER |
9,2 |
FM_UNMET_NEED |
Fm unmet need associated with the record. |
NUMBER |
9,2 |
IM_NEED |
Im need associated with the record. |
NUMBER |
9,2 |
IM_PARENT_CONTRIBUTION |
Im parent contribution associated with the record. |
NUMBER |
9,2 |
IM_STUDENT_CONTRIBUTION |
Im student contribution associated with the record. |
NUMBER |
9,2 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
SPRING_ENROLL_STATUS_CODE |
Code identifying spring enroll status. |
VARCHAR2 |
2 |
SPRING_ENROLL_STATUS_DESC |
Description of spring enroll status. |
VARCHAR2 |
50 |
SPRING_LOAD_LEVEL_CODE |
Code identifying spring load level. |
VARCHAR2 |
2 |
SPRING_LOAD_LEVEL_DESC |
Description of spring load level. |
VARCHAR2 |
50 |
SPRING_STUDENT_YEAR |
Spring student year associated with the record. |
VARCHAR2 |
1 |
SPRING_UNITS_OF_LOAD |
Spring units of load associated with the record. |
NUMBER |
3 |
SUMMER_ENROLL_STATUS_CODE |
Code identifying summer enroll status. |
VARCHAR2 |
2 |
SUMMER_ENROLL_STATUS_DESC |
Description of summer enroll status. |
VARCHAR2 |
50 |
SUMMER_LOAD_LEVEL_CODE |
Code identifying summer load level. |
VARCHAR2 |
2 |
SUMMER_LOAD_LEVEL_DESC |
Description of summer load level. |
VARCHAR2 |
50 |
SUMMER_STUDENT_YEAR |
Summer student year associated with the record. |
VARCHAR2 |
1 |
SUMMER_UNITS_OF_LOAD |
Summer units of load associated with the record. |
NUMBER |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |