FINAID GRANT STUDENT INTEREST Table
View exposing financial aid grant student interest records associated with student participation in grant-funded programs.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDTL_COMMENTS_TEXT |
Addtl comments text associated with the record. |
VARCHAR2 |
3000 |
AID_APPLICANT_KEY |
Surrogate key identifying the aid applicant. |
VARCHAR2 |
13 |
AID_YEAR |
Aid year associated with the record. |
VARCHAR2 |
4 |
ARTS_TEXT |
Arts text associated with the record. |
VARCHAR2 |
3000 |
ATHLETICS_TEXT |
Athletics text associated with the record. |
VARCHAR2 |
3000 |
BIOMED_TEXT |
Biomed text associated with the record. |
VARCHAR2 |
3000 |
CAREER_PLANS_TEXT |
Career plans text associated with the record. |
VARCHAR2 |
3000 |
CITY_OF_BIRTH |
City of birth associated with the record. |
VARCHAR2 |
100 |
CMRA_TEXT |
Cmra text associated with the record. |
VARCHAR2 |
3000 |
COMMUNITY_TEXT |
Community text associated with the record. |
VARCHAR2 |
3000 |
CONSENT_FLAG |
Consent flag associated with the record. |
VARCHAR2 |
1 |
CREW_TEXT |
Crew text associated with the record. |
VARCHAR2 |
3000 |
DESCENDANT_TEXT |
Descendant text associated with the record. |
VARCHAR2 |
3000 |
DORM_TEXT |
Dorm text associated with the record. |
VARCHAR2 |
3000 |
FAMILY_IN_ORG_TEXT |
Family in org text associated with the record. |
VARCHAR2 |
3000 |
FIRST_WEEK_TEXT |
First week text associated with the record. |
VARCHAR2 |
3000 |
FRESHMAN_PLANS_TEXT |
Freshman plans text associated with the record. |
VARCHAR2 |
3000 |
FULL_NAME |
Full name associated with the person. |
VARCHAR2 |
90 |
GOVT_TEXT |
Govt text associated with the record. |
VARCHAR2 |
3000 |
HELLENIC_TEXT |
Hellenic text associated with the record. |
VARCHAR2 |
3000 |
HIGH_SCHOOL |
High school associated with the record. |
VARCHAR2 |
100 |
HIGH_SCHOOL_ACTIVITIES_TEXT |
High school activities text associated with the record. |
VARCHAR2 |
3000 |
HILLEL_TEXT |
Hillel text associated with the record. |
VARCHAR2 |
3000 |
HOMETOWN_INFO |
Hometown info associated with the record. |
VARCHAR2 |
3000 |
IMPACT_TEXT |
Impact text associated with the record. |
VARCHAR2 |
3000 |
INTEREST_IN_FIELDS |
Interest in fields associated with the record. |
VARCHAR2 |
3000 |
INTL_TEXT |
Intl text associated with the record. |
VARCHAR2 |
3000 |
IS_CLASS_OF_1950_FUND |
Indicator identifying whether class of 1950 fund (Y/N). |
VARCHAR2 |
15 |
IS_DESCENDANT_OF_RETIREE |
Indicator identifying whether descendant of retiree (Y/N). |
VARCHAR2 |
15 |
IS_FIRST_GENERATION |
Indicator identifying whether first generation (Y/N). |
VARCHAR2 |
15 |
IS_RETURN_TO_MIT |
Indicator identifying whether return to mit (Y/N). |
VARCHAR2 |
15 |
IS_TRANSFER_STUDENT |
Indicator identifying whether transfer student (Y/N). |
VARCHAR2 |
15 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
LAST_ACTIVITY_USER |
Last activity user associated with the record. |
VARCHAR2 |
30 |
LEE_TEXT |
Lee text associated with the record. |
VARCHAR2 |
3000 |
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 |
Music text associated with the record. |
VARCHAR2 |
3000 |
NATION_OF_BIRTH |
Nation of birth associated with the record. |
VARCHAR2 |
3 |
OTHER_INT_TEXT |
Other int text associated with the record. |
VARCHAR2 |
3000 |
OTHER_RELIGION_TEXT |
Other religion text associated with the record. |
VARCHAR2 |
3000 |
RESEARCH_ACTIVITIES_TEXT |
Research activities text associated with the record. |
VARCHAR2 |
3000 |
RETURN_TO_MIT_TEXT |
Return to mit text associated with the record. |
VARCHAR2 |
3000 |
SCOUTS_FIRST_TEXT |
Scouts first text associated with the record. |
VARCHAR2 |
3000 |
SKATING_TEXT |
Skating text associated with the record. |
VARCHAR2 |
3000 |
STATE_OF_BIRTH |
State of birth associated with the record. |
VARCHAR2 |
2 |
STS_TEXT |
Sts text associated with the record. |
VARCHAR2 |
3000 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
SUMMER_PLANS_TEXT |
Summer plans text associated with the record. |
VARCHAR2 |
3000 |
SURPRISE_TEXT |
Surprise text associated with the record. |
VARCHAR2 |
3000 |
TRANSFER_TEXT |
Transfer text associated with the record. |
VARCHAR2 |
3000 |
UROP_TEXT |
Urop text associated with the record. |
VARCHAR2 |
3000 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WHAT_AREAS_TEXT |
What areas text associated with the record. |
VARCHAR2 |
3000 |
WHY_MIT_TEXT |
Why mit text associated with the record. |
VARCHAR2 |
3000 |