FINAID GRANT STUDENT INTEREST Table
Financial Aid Grant -- student interests. This table is granted to users in the Office of Student Financial Services and Resource Development only.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDTL_COMMENTS_TEXT |
XXX |
VARCHAR2 |
2000 |
AID_APPLICANT_KEY |
Key identifying an entry in the Financial Aid Applicant Table. This field should only be used for linking tables together, not for reporting. The field is a concatenation of the fields of MIT ID and Aid Year |
VARCHAR2 |
13 |
AID_YEAR |
Financial aid year. |
VARCHAR2 |
4 |
ARTS_TEXT |
XXX |
VARCHAR2 |
2000 |
ATHLETICS_TEXT |
XXX |
VARCHAR2 |
2000 |
BIOMED_TEXT |
XXX |
VARCHAR2 |
2000 |
CAREER_PLANS_TEXT |
XXX |
VARCHAR2 |
2000 |
CITY_OF_BIRTH |
XXX |
VARCHAR2 |
100 |
CMRA_TEXT |
XXX |
VARCHAR2 |
2000 |
COMMUNITY_TEXT |
XXX |
VARCHAR2 |
2000 |
CONSENT_FLAG |
XXX |
VARCHAR2 |
1 |
CREW_TEXT |
XXX |
VARCHAR2 |
2000 |
DESCENDANT_TEXT |
XXX |
VARCHAR2 |
2000 |
DORM_TEXT |
XXX |
VARCHAR2 |
2000 |
FAMILY_IN_ORG_TEXT |
XXX |
VARCHAR2 |
2000 |
FIRST_WEEK_TEXT |
XXX |
VARCHAR2 |
2000 |
FRESHMAN_PLANS_TEXT |
XXX |
VARCHAR2 |
2000 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GOVT_TEXT |
XXX |
VARCHAR2 |
2000 |
HELLENIC_TEXT |
XXX |
VARCHAR2 |
2000 |
HIGH_SCHOOL |
XXX |
VARCHAR2 |
100 |
HIGH_SCHOOL_ACTIVITIES_TEXT |
XXX |
VARCHAR2 |
2000 |
HILLEL_TEXT |
XXX |
VARCHAR2 |
2000 |
HOMETOWN_INFO |
XXX |
VARCHAR2 |
2000 |
IMPACT_TEXT |
XXX |
VARCHAR2 |
2000 |
INTEREST_IN_FIELDS |
XXX |
VARCHAR2 |
2000 |
INTL_TEXT |
XXX |
VARCHAR2 |
2000 |
IS_CLASS_OF_1950_FUND |
XXX |
VARCHAR2 |
15 |
IS_DESCENDANT_OF_RETIREE |
XXX |
VARCHAR2 |
1 |
IS_FIRST_GENERATION |
XXX |
VARCHAR2 |
1 |
IS_RETURN_TO_MIT |
XXX |
VARCHAR2 |
1 |
IS_TRANSFER_STUDENT |
XXX |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
LAST_ACTIVITY_USER |
XXX |
VARCHAR2 |
30 |
LEE_TEXT |
XXX |
VARCHAR2 |
2000 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
MUSIC_TEXT |
XXX |
VARCHAR2 |
2000 |
NATION_OF_BIRTH |
XXX |
VARCHAR2 |
3 |
OTHER_INT_TEXT |
XXX |
VARCHAR2 |
2000 |
OTHER_RELIGION_TEXT |
XXX |
VARCHAR2 |
2000 |
RESEARCH_ACTIVITIES_TEXT |
XXX |
VARCHAR2 |
2000 |
RETURN_TO_MIT_TEXT |
XXX |
VARCHAR2 |
2000 |
SCOUTS_FIRST_TEXT |
XXX |
VARCHAR2 |
2000 |
SKATING_TEXT |
XXX |
VARCHAR2 |
2000 |
STATE_OF_BIRTH |
XXX |
VARCHAR2 |
2 |
STS_TEXT |
XXX |
VARCHAR2 |
2000 |
STUDENT_YEAR |
The student's primary year of degree for the current term. Values include 1,2,3,4 (for freshman through senior), G for Graduate, and U for Special Undergraduate. If the student is in the graduate school and also is still an undergraduate student, then this field should always contain a "G". The undergraduate year is then stored in the Undergraduate Year (UG YEAR) field, if applicable. |
VARCHAR2 |
1 |
SUMMER_PLANS_TEXT |
XXX |
VARCHAR2 |
2000 |
SURPRISE_TEXT |
XXX |
VARCHAR2 |
2000 |
TRANSFER_TEXT |
XXX |
VARCHAR2 |
2000 |
UROP_TEXT |
XXX |
VARCHAR2 |
2000 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WHAT_AREAS_TEXT |
XXX |
VARCHAR2 |
2000 |
WHY_MIT_TEXT |
XXX |
VARCHAR2 |
2000 |