FINAID GRANT STUDENT INTEREST1 Table
View exposing financial aid grant student interest records associated with grant-funded programs and student participation.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_APPLICANT_KEY |
Surrogate key identifying the aid applicant. |
VARCHAR2 |
13 |
AID_YEAR |
Aid year associated with the record. |
VARCHAR2 |
4 |
CITY_OF_BIRTH |
City of birth associated with the record. |
VARCHAR2 |
100 |
CONSENT_FLAG |
Consent flag associated with the record. |
VARCHAR2 |
1 |
DESCENDANT_TEXT |
Descendant text associated with the record. |
VARCHAR2 |
3000 |
FAMILY_IN_ORG_TEXT |
Family in org text associated with the record. |
VARCHAR2 |
3000 |
FULL_NAME |
Full name associated with the person. |
VARCHAR2 |
90 |
HIGH_SCHOOL |
High school associated with the record. |
VARCHAR2 |
100 |
HOMETOWN_INFO |
Hometown info 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 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NATION_OF_BIRTH |
Nation of birth associated with the record. |
VARCHAR2 |
3 |
OTHER_RELIGION_TEXT |
Other religion 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 |
STATE_OF_BIRTH |
State of birth associated with the record. |
VARCHAR2 |
2 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
TRANSFER_TEXT |
Transfer text associated with the record. |
VARCHAR2 |
3000 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |