FINAID GRANT STUDENT INTEREST2 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 |
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 |
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 |
DORM_TEXT |
Dorm 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 |
HILLEL_TEXT |
Hillel text associated with the record. |
VARCHAR2 |
3000 |
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 |
SKATING_TEXT |
Skating text associated with the record. |
VARCHAR2 |
3000 |
STS_TEXT |
Sts text associated with the record. |
VARCHAR2 |
3000 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
UROP_TEXT |
Urop text associated with the record. |
VARCHAR2 |
3000 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |