FINAID AID APPLICANT Table
View exposing financial aid applicant records associated with students applying for institutional, federal, or external financial aid programs.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMISSIONS_REPLY_STATUS |
Admissions reply status associated with the record. |
VARCHAR2 |
10 |
ADMISSIONS_STATUS |
Admissions status associated with the record. |
VARCHAR2 |
12 |
ADMISSIONS_TYPE |
Admissions type associated with the record. |
VARCHAR2 |
8 |
ADM_APPLICATION_RECEIVED_DATE |
Date associated with adm application received. |
DATE |
|
AID_APPLICANT_KEY |
Surrogate key identifying the aid applicant. |
VARCHAR2 |
13 |
AID_PERIOD |
Aid period associated with the record. |
VARCHAR2 |
100 |
AID_YEAR |
Aid year associated with the record. |
VARCHAR2 |
4 |
APPEAL_OFFICER |
Appeal officer associated with the record. |
VARCHAR2 |
15 |
BUDGET_GROUP |
Budget group associated with the record. |
VARCHAR2 |
100 |
BUDGET_TYPE |
Budget type associated with the record. |
VARCHAR2 |
4 |
CITIZENSHIP_IND |
Citizenship ind associated with the record. |
VARCHAR2 |
100 |
DATE_OF_BIRTH |
Date of birth associated with the person. |
DATE |
|
DEPARTMENT |
Department associated with the record. |
VARCHAR2 |
6 |
DISB_METHOD_IND |
Disb method ind associated with the record. |
VARCHAR2 |
1 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
60 |
ENROLL_STATUS |
Enroll status associated with the record. |
VARCHAR2 |
100 |
ETHNIC |
Ethnic associated with the record. |
VARCHAR2 |
100 |
FINAID_CLASS_CODE |
Code identifying finaid class. |
NUMBER |
1 |
FINAID_CLASS_CODE_DESC |
Description of finaid class code. |
VARCHAR2 |
100 |
FM_GROSS_NEED_AMOUNT |
Fm gross need amount associated with the record. |
NUMBER |
11,2 |
FM_UNMET_NEED_AMOUNT |
Fm unmet need amount associated with the record. |
NUMBER |
11,2 |
FULL_NAME |
Full name associated with the person. |
VARCHAR2 |
93 |
GENDER |
Gender associated with the record. |
VARCHAR2 |
32 |
HAS_DIRECT_LOAN |
Indicator identifying whether direct loan (Y/N). |
VARCHAR2 |
1 |
HAS_INST_AWARDS |
Indicator identifying whether inst awards (Y/N). |
VARCHAR2 |
1 |
HAS_MIT_GRANT |
Indicator identifying whether mit grant (Y/N). |
VARCHAR2 |
1 |
HAS_NON_INST_AWARDS |
Indicator identifying whether non inst awards (Y/N). |
VARCHAR2 |
1 |
HAS_OUTSIDE_SCHOLARSHIP |
Indicator identifying whether outside scholarship (Y/N). |
VARCHAR2 |
1 |
HAS_PELL_GRANT |
Indicator identifying whether pell grant (Y/N). |
VARCHAR2 |
1 |
HAS_SEOG_GRANT |
Indicator identifying whether seog grant (Y/N). |
VARCHAR2 |
1 |
HAS_TECH_LOAN |
Indicator identifying whether tech loan (Y/N). |
VARCHAR2 |
1 |
IM_GROSS_NEED_AMOUNT |
Im gross need amount associated with the record. |
NUMBER |
11,2 |
IM_UNMET_NEED_AMOUNT |
Im unmet need amount associated with the record. |
NUMBER |
11,2 |
IN_EARLY_ACTION |
In early action associated with the record. |
VARCHAR2 |
1 |
IPEDS_ETHNIC |
Ipeds ethnic associated with the record. |
VARCHAR2 |
100 |
IS_AID_APPLICANT |
Indicator identifying whether aid applicant (Y/N). |
VARCHAR2 |
1 |
IS_APPLICANT |
Indicator identifying whether applicant (Y/N). |
VARCHAR2 |
1 |
IS_ATTENDED |
Indicator identifying whether attended (Y/N). |
VARCHAR2 |
1 |
IS_ELIG_TO_REG |
Indicator identifying whether elig to reg (Y/N). |
VARCHAR2 |
1 |
IS_FM_NEEDY_APPLICANT |
Indicator identifying whether fm needy applicant (Y/N). |
VARCHAR2 |
1 |
IS_IM_NEEDY_APPLICANT |
Indicator identifying whether im needy applicant (Y/N). |
VARCHAR2 |
1 |
IS_QA_PARTICIPANT |
Indicator identifying whether qa participant (Y/N). |
VARCHAR2 |
1 |
IS_REGISTERED |
Indicator identifying whether registered (Y/N). |
VARCHAR2 |
1 |
LOAD_LEVEL |
Load level associated with the record. |
VARCHAR2 |
100 |
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 |
Mit sibling 1 associated with the record. |
VARCHAR2 |
15 |
MIT_SIBLING_2 |
Mit sibling 2 associated with the record. |
VARCHAR2 |
15 |
MIT_SIBLING_3 |
Mit sibling 3 associated with the record. |
VARCHAR2 |
15 |
PACKAGING_COMPLETE_DATE |
Date associated with packaging complete. |
DATE |
|
PACKAGING_GROUP |
Packaging group associated with the record. |
VARCHAR2 |
100 |
PCKG_REQ_COMPLETE_DATE |
Date associated with pckg req complete. |
DATE |
|
READER_INITIALS |
Reader initials associated with the record. |
VARCHAR2 |
15 |
READ_DATE |
Date associated with read. |
VARCHAR2 |
15 |
REGISTER_TYPE |
Register type associated with the record. |
VARCHAR2 |
100 |
SSN |
Ssn associated with the record. |
VARCHAR2 |
11 |
TFC_METHOD_IND |
Tfc method ind associated with the record. |
VARCHAR2 |
1 |
TOTAL_BUDGET_AMOUNT |
Total budget amount associated with the record. |
NUMBER |
18,2 |
TOTAL_DIRECT_LOAN |
Total direct loan associated with the record. |
NUMBER |
11,2 |
TOTAL_MIT_GRANT |
Total mit grant associated with the record. |
NUMBER |
11,2 |
TOTAL_NET_OFFER_AWARD |
Total net offer award associated with the record. |
NUMBER |
19,2 |
TOTAL_OFFER_AWARD |
Total offer award associated with the record. |
NUMBER |
23,2 |
TOTAL_OUTSIDE_SCHOLARSHIP |
Total outside scholarship associated with the record. |
NUMBER |
11,2 |
TOTAL_PAID_AWARD |
Total paid award associated with the record. |
NUMBER |
28,2 |
TOTAL_TECH_LOAN |
Total tech loan associated with the record. |
NUMBER |
11,2 |
TRACKING_GROUP |
Tracking group associated with the record. |
VARCHAR2 |
100 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |