FINAID APPLICANT Table
This table contains the yearly status and summary information of all prospective financial aid applicants, including incoming freshmen and applicants, at MIT since aid year 1994. Information includes biographical data, financial aid data, enrollment profile data, admissions data, and summary of award data. There is one record per aid applicant per financial aid year.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
CITIZENSHIP_IND |
Status of US Citizenship. Values are: US Citizen, US Permanent Resident, International, and Unknown. |
VARCHAR2 |
30 |
DEPARTMENT |
The department of the primary Course/major: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
ENROLL_STATUS |
The status of the student's registration for the term. Values include: Eligible to register, Registered, Early Thesis, Withdrew After 5th Week, etc. In the STUDENT and STUDENT_TERM_ENROLLMENT tables, only the codes (eg. EL, RE, ET, WR, WE) are shown. |
VARCHAR2 |
2 |
FINAID_CLASS_CODE |
Financial Aid Class Code -- One of these codes: 0,1,2,3,4,5,6 -- indicating the student's year of studies at MIT according to the rules of receiving financial aid. |
VARCHAR2 |
1 |
FINAID_CLASS_CODE_DESC |
Description of the financial aid class code: 0=undefined; 1=Freshman; 2=Sophomore; 3=Junior; 4=Senior; 5=Fifth Year Senior; 6=Graduate Student. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
IS_AID_APPLICANT |
Whether the person is really a financial aid applicant, as opposed to a prospective aid applicant. A financial aid applicant is someone who has submitted one or more of the following forms in good order: MIT Financial Aid Application for 1st time applicants (FRAPP), Electronic data from federal processor (FAFSAE), Electronic data from the CSS Profile Form (PROFIL), MIT Foreign Student Financial Aid Application (INTAPP), MIT Undergraduate Application for Financial Aid (UGRAPP), MIT Application for Financial Aid, the College Transfer Version (TRAPP), and MIT Graduate Loan Application (GLA). Students who are (re-)assigned the CANCAP ("Cancelled Application") tracking group are NOT considered as aid applicants. Y=Yes, is aid applicant; N=No, not an aid applicant. |
VARCHAR2 |
1 |
IS_APPLICANT |
Whether the person is a student or an applicant (ie. the person was not admitted or did not enroll). Y=Applicant, N=Student. |
VARCHAR2 |
1 |
IS_ATTENDED |
"Y" indicates that the student attended at least some part of the current term. "N" indicates that the student never attended this term. In the FINAID AID APPLICANT and FINAID APPLICANT tables, "Y" indicates that the student has attended at least partially in any one of the three terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not attended in any one of the three terms of the aid year. |
VARCHAR2 |
1 |
IS_ELIG_TO_REG |
Whether the student is eligible to register in any one of the three terms (in this order: Spring, Fall, Summer)) of the aid year. Y=Yes, N=No. |
VARCHAR2 |
1 |
IS_REGISTERED |
"Y" indicates that the student is currently registered. "N" indicates that the student is not currently registered. In the FINAID AID APPLICANT and FINAID APPLICANT tables, a "Y" in this field indicates that the student has registered for any one of the terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not registered in any one of the three terms of the aid year. |
VARCHAR2 |
1 |
LOAD_LEVEL |
The course load of the student in the registered term. Values: Full Time, Half Time, 3/4 Time, Early Thesis, No Load, Cross-registered, Less Than Half Time, Full Time Senior. |
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 |
REGISTER_TYPE |
The type of registration of the student of the term (any one of the three terms of the aid year, in this order: Spring, Fall, Summer) which he/she is registered. Possible types of registration are: Regular, Special, Cross-Registered and Non-Resident. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |