FINAID AID APPLICANT Table
(Access to this table is restricted to the staff of Student Financial Services. Other authorized users are given access to the 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 financial 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 |
|---|---|---|---|
ADMISSIONS_REPLY_STATUS |
Reply to an admissions decision. Valid reply codes are: Coming (accepted the offer of admissions), Deferred (deferred the acceptance of admissions to a future term), No Reply (did not reply), Not Coming (did not accept the offer of admissions). This field is only applicable to incoming students (freshmen, transfers, graduates) for the aid year. |
VARCHAR2 |
12 |
ADMISSIONS_STATUS |
The status of admissions. Valid values are:Admitted, Not Admitted, No Action, Waitlisted. This field is only applicable to incoming students (freshmen, transfers, graduates) for the aid year. |
VARCHAR2 |
12 |
ADMISSIONS_TYPE |
The type of admissions offered. Valid values are: Freshman, Graduate, Special, Transfer. This field is only applicable to incoming students for the aid year. |
VARCHAR2 |
12 |
ADM_APPLICATION_RECEIVED_DATE |
The date the admissions application completed. |
DATE |
8 |
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_PERIOD |
The period of which the student is eligible for financial aid. Values are: Full Academic Year, Fall Term Only, Spring Term Only, Summer Term Only, Summer/Fall (7.5 Month), and Twelve-Month. |
VARCHAR2 |
30 |
AID_YEAR |
Financial aid year. |
VARCHAR2 |
4 |
APPEAL_OFFICER |
The initials or name of the Financial Aid Officer who processed the appeal of the case. |
VARCHAR2 |
18 |
BUDGET_GROUP |
The budget group assigned to the student for the aid year. In each financial aid year, aid applicants are assigned an appropriate budget group for the need analysis process to determine the amount of financial aid a student is eligible for. Some of the budget groups are: Undergraduate Regular, Undergraduate Commuter, Undergraduate International, Graduate Regular, Graduate Non-Resident, etc. |
VARCHAR2 |
30 |
BUDGET_TYPE |
The budget type codes: FEDR=Federal, INST=Institutional, PELL=Pell. The method applied in calculating the total budget amount (or the total cost of attendance) of the student for an aid year. |
VARCHAR2 |
4 |
CITIZENSHIP_IND |
Status of US Citizenship. Values are: US Citizen, US Permanent Resident, International, and Unknown. |
VARCHAR2 |
30 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
8 |
DEPARTMENT |
The department of the primary Course/major: 6, 10, HIST, etc. |
VARCHAR2 |
4 |
DISB_METHOD_IND |
Disbursement method indicator. |
VARCHAR2 |
1 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
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 |
ETHNIC |
Ethnicity code. |
VARCHAR2 |
35 |
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 |
FM_GROSS_NEED_AMOUNT |
The gross amount of financial aid eligibility that is provided by SFAO, according to the Federal Methodology (FM). |
NUMBER |
13 |
FM_UNMET_NEED_AMOUNT |
The amount of financial aid eligibility that is NOT provided by SFAO, according to the Federal Methodology (FM). |
NUMBER |
13 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
HAS_DIRECT_LOAN |
Whether the student has been awarded any Federal Direct Loans in the aid year. Y=Yes, N=No. |
VARCHAR2 |
1 |
HAS_INST_AWARDS |
If it is a "Y", the student has been awarded Institutional awards; a "N" indicates that the student does not have any Institutional awards in his/her financial aid pacakge. |
VARCHAR2 |
1 |
HAS_MIT_GRANT |
Whether the student has been awarded any MIT Grant in the aid year. Y=Yes, N=No. |
VARCHAR2 |
1 |
HAS_NON_INST_AWARDS |
If it is a "Y", the student has been awarded Non-Institutional awards; a "N" means the student does not have any Non-Institutional awards in his/her financial aid package. |
VARCHAR2 |
1 |
HAS_OUTSIDE_SCHOLARSHIP |
Whether the student has been awarded any outside scholarship award in the aid year. Y=Yes, N=No. |
VARCHAR2 |
1 |
HAS_PELL_GRANT |
Whether the student has been awarded any Federal Pell Grant in the aid year. Y=Yes, N=No. |
VARCHAR2 |
1 |
HAS_SEOG_GRANT |
Whether the student has been awarded any Federal Supplemental Educational Opportunity Grant in the aid year. Y=Yes, N=No. |
VARCHAR2 |
1 |
HAS_TECH_LOAN |
Whether the student has been awarded any Technology Loans from MIT in the aid year. Y=Yes, N=No. |
VARCHAR2 |
1 |
IM_GROSS_NEED_AMOUNT |
The gross amount f financial aid eligibility that is provided by SFAO, according to the Institutional Methodology (IM). |
NUMBER |
13 |
IM_UNMET_NEED_AMOUNT |
The amount of financial aid eligibility that is NOT provided by SFAO, according to the Institutional Methodology (IM). |
NUMBER |
13 |
IN_EARLY_ACTION |
Whether the student was admitted in the Early Action program. Y=Yes, N=No, Blank=Not Applicable. This field is only applicable to incoming students (freshmen, transfers, graduates) for the aid year. |
VARCHAR2 |
1 |
IPEDS_ETHNIC |
XXX |
VARCHAR2 |
50 |
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_FM_NEEDY_APPLICANT |
Whether the student is an needy aid applicant according to the Federal Methodology (FM). Y=Yes, N=No. Students who have a greater-than-zero FM Gross Need Amount are considered FM needy. |
VARCHAR2 |
1 |
IS_IM_NEEDY_APPLICANT |
Whether the student is an needy aid applicant according to the Institutional Methodology (IM). Y=Yes, N=No. Students who have a greater-than-zero IM Gross Need Amount are considered IM needy aid applicants. |
VARCHAR2 |
1 |
IS_QA_PARTICIPANT |
Whether the student was selected to participate in the Quality Assurance program. Y=Yes, N=No, Blank=Not Applicable. |
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 |
MIT_SIBLING_1 |
Name of a sibling of the student who is also a student or alumnus of MIT. |
VARCHAR2 |
18 |
MIT_SIBLING_2 |
Name of a sibling of the student who is also a student or alumnus of MIT. |
VARCHAR2 |
18 |
MIT_SIBLING_3 |
Name of a sibling of the student who is also a student or alumnus of MIT. |
VARCHAR2 |
18 |
PACKAGING_COMPLETE_DATE |
The date when aid packaging process is completed. |
DATE |
8 |
PACKAGING_GROUP |
The packaging group assigned to the student for the aid year. In each aid year, aid applicants are assigned an appropriate packaging group for the award packaging process. Some of the packaging groups are: Regular Undergrads, Regular Undergrads with SEOG, Unsubsidized Stafford Loans Only, Direct Loans Only, International, etc. |
VARCHAR2 |
30 |
PCKG_REQ_COMPLETE_DATE |
The date when all the financial aid requirements needed for aid packaging are satisfied/completed. |
DATE |
8 |
READER_INITIALS |
The initials of the Financial Aid Officer who read the case of this student. |
VARCHAR2 |
18 |
READ_DATE |
The date when the case was read. |
VARCHAR2 |
18 |
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 |
SSN |
The person's social security number. |
VARCHAR2 |
9 |
TFC_METHOD_IND |
XXX |
VARCHAR2 |
1 |
TOTAL_BUDGET_AMOUNT |
The total Cost of Attendance, or the total amount, for the aid year, it should cost the student to go to school. The amount usually covers tuition and fees, on-campus room and board and allowance for books and supplies, transportation, and miscellaneous expenses. |
NUMBER |
11 |
TOTAL_DIRECT_LOAN |
The total amount of Federal Direct Loans offered (that are not cancelled and declined) to the student in the aid year. |
NUMBER |
11 |
TOTAL_MIT_GRANT |
The total amount of MIT Grant offered (that are not cancelled and declined) to the student in the aid year. |
NUMBER |
11 |
TOTAL_NET_OFFER_AWARD |
The total amount of awards offered minus the total amount of federal loan fees |
NUMBER |
11 |
TOTAL_OFFER_AWARD |
The total amount of awards offered (that are not cancelled and declined) to the student in the aid year. |
NUMBER |
11 |
TOTAL_OUTSIDE_SCHOLARSHIP |
The total amount of outside scholarships the student has received in the aid year. |
NUMBER |
11 |
TOTAL_PAID_AWARD |
The total amount of awards paid to the student's account for the aid year |
NUMBER |
11 |
TOTAL_TECH_LOAN |
The total amount of MIT Technology Loans offered (that are not cancelled and declined) to the student in the aid year. |
NUMBER |
11 |
TRACKING_GROUP |
The tracking group assigned to the student for the aid year. In each financial aid year, aid applicants are assigned an appropriate tracking group to track the various different requirements (eg. documents, forms) needed to complete the financial aid application. Some of the tracking groups are: US Freshmen, US Freshmen with Divorced Parents, Continuing Undergraduates, International Freshmen, Graduates, etc. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |