FAID APPLICANT Table
View exposing financial-aid applicant detail including applicant and student identifiers, financial-aid year, demographic and contact attributes, address information, aid indicators, enrollment and admissions attributes, aggregate award and budget measures, and related application-tracking fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_YEAR_BEGIN_DATE |
Date associated with academic year begin. |
DATE |
|
ACADEMIC_YEAR_END_DATE |
Date associated with academic year end. |
DATE |
|
ADDRESS_END_DT |
Address end dt associated with the record. |
DATE |
|
ADDRESS_START_DT |
Address start dt associated with the record. |
DATE |
|
ADMSTAT |
Admstat associated with the record. |
VARCHAR2 |
1 |
ALIEN_NUM |
Alien num associated with the applicant. |
VARCHAR2 |
9 |
ALT_LOAN_DEBT |
Alt loan debt associated with the record. |
NUMBER |
12,2 |
APP_COMPLETE_DT |
App complete dt associated with the record. |
DATE |
|
CELLULAR_TELEPHONE |
Cellular telephone associated with the record. |
VARCHAR2 |
10 |
COLLEGE_GPA |
College gpa associated with the record. |
NUMBER |
3,2 |
COMPLETE_LETTER_SENT |
Complete letter sent associated with the record. |
VARCHAR2 |
1 |
CREATED_DT |
Created dt associated with the record. |
DATE |
|
CREATED_HOW |
Created how associated with the record. |
NUMBER |
|
CURRENT_IDOC |
Current idoc associated with the record. |
NUMBER |
|
DATE_AWARD_LETTER_PRINTED |
Date award letter printed associated with the record. |
DATE |
|
DATE_OFFER_ACCEPTED |
Date offer accepted associated with the record. |
DATE |
|
DRIVERS_LICENSE_NUM |
Drivers license num associated with the applicant. |
VARCHAR2 |
20 |
DRIVERS_LICENSE_STATE |
Drivers license state associated with the record. |
VARCHAR2 |
2 |
DT_LAST_APPLICATION_UPDATE |
Dt last application update associated with the record. |
DATE |
|
DT_WITH |
Dt with associated with the record. |
DATE |
|
EARLY_ADMIT |
Early admit associated with the record. |
VARCHAR2 |
6 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
50 |
EMAIL_ADDRESS_2 |
Email address 2 associated with the record. |
VARCHAR2 |
50 |
ENROLLMENT_DATE |
Date associated with enrollment. |
DATE |
|
ENR_STAT_FALL |
Enr stat fall associated with the record. |
VARCHAR2 |
6 |
ENR_STAT_SPR |
Enr stat spr associated with the record. |
VARCHAR2 |
6 |
ENR_STAT_SUM |
Enr stat sum associated with the record. |
VARCHAR2 |
6 |
ENTRANCE_IV_BY |
Entrance iv by associated with the record. |
NUMBER |
|
ENTRANCE_IV_BY_GRAD_PLUS |
Entrance iv by grad plus associated with the record. |
NUMBER |
|
ENTRANCE_IV_DT |
Entrance iv dt associated with the record. |
DATE |
|
ENTRANCE_IV_DT_GRAD_PLUS |
Entrance iv dt grad plus associated with the record. |
DATE |
|
ETHNICITY |
Ethnicity associated with the record. |
VARCHAR2 |
6 |
EXIT_IV_BY |
Exit iv by associated with the record. |
NUMBER |
|
EXIT_IV_DT |
Exit iv dt associated with the record. |
DATE |
|
EXPECTED_GRADUATION_DATE |
Date associated with expected graduation. |
DATE |
|
FAID_APPLICANT_KEY |
Surrogate key identifying the faid applicant. |
VARCHAR2 |
21 |
FAID_APPLICANT_UNIQUE_KEY |
Surrogate key identifying the faid applicant unique. |
VARCHAR2 |
32 |
FAID_YEAR |
Faid year associated with the record. |
NUMBER |
|
FAID_YEAR_DESC |
Description of faid year. |
VARCHAR2 |
23 |
FAILED_CHALLENGE_RESPONSE |
Failed challenge response associated with the record. |
NUMBER |
|
FAILED_LOGINS |
Failed logins associated with the record. |
NUMBER |
|
FALL_GRADELVL |
Fall gradelvl associated with the record. |
VARCHAR2 |
6 |
FED_AID_ONLY |
Fed aid only associated with the record. |
VARCHAR2 |
6 |
FIN_AID_APPL |
Fin aid appl associated with the record. |
VARCHAR2 |
6 |
FIRST_NAME |
First name associated with the person. |
VARCHAR2 |
15 |
FM_NEED_BASED_AMOUNT |
Fm need based amount associated with the record. |
NUMBER |
|
FOREIGN_ADDRESS_INDICATOR |
Foreign address indicator associated with the record. |
VARCHAR2 |
1 |
FOREIGN_COUNTRY_CODE |
Code identifying foreign country. |
VARCHAR2 |
3 |
FOREIGN_POSTAL_CODE |
Foreign postal code associated with the record. |
VARCHAR2 |
17 |
GPA_HIGHSCHOOL |
Gpa highschool associated with the record. |
NUMBER |
3,2 |
GRADPLUS_MPN_EXPIRATION_DATE |
Date associated with gradplus mpn expiration. |
DATE |
|
GRADUATE_STIPEND_AWARD_FALL |
Graduate stipend award fall associated with the record. |
NUMBER |
|
GRADUATE_STIPEND_AWARD_SPRING |
Graduate stipend award spring associated with the record. |
NUMBER |
|
GRADUATE_STIPEND_AWARD_SUMMER |
Graduate stipend award summer associated with the record. |
NUMBER |
|
GRADUATE_TEACHING_ASSISTANT |
Graduate teaching assistant associated with the record. |
VARCHAR2 |
6 |
GRADUATE_TUITION_AWARD_FALL |
Graduate tuition award fall associated with the record. |
NUMBER |
|
GRADUATE_TUITION_AWARD_SPRING |
Graduate tuition award spring associated with the record. |
NUMBER |
|
GRADUATE_TUITION_AWARD_SUMMER |
Graduate tuition award summer associated with the record. |
NUMBER |
|
GRADUATE_YEAR |
Graduate year associated with the record. |
VARCHAR2 |
1 |
GRAD_SCHOOL_ENROLLED |
Grad school enrolled associated with the record. |
VARCHAR2 |
6 |
HAS_PERKINS |
Indicator identifying whether perkins (Y/N). |
NUMBER |
|
HEAL_LIMIT_FLAG |
Heal limit flag associated with the record. |
VARCHAR2 |
1 |
HISPANIC |
Hispanic associated with the record. |
VARCHAR2 |
1 |
IM_NEED_BASED_AMOUNT |
Im need based amount associated with the record. |
NUMBER |
|
IPEDS |
Ipeds associated with the record. |
NUMBER |
|
IPEDS_DESCRIPTION |
Description of ipeds. |
VARCHAR2 |
50 |
ISIR_DATA_VALID |
Isir data valid associated with the record. |
VARCHAR2 |
1 |
I_P_CTRY_RES |
I p ctry res associated with the record. |
VARCHAR2 |
2 |
I_S_GENDER |
I s gender associated with the record. |
VARCHAR2 |
1 |
LAST_NAME |
Last name associated with the person. |
VARCHAR2 |
25 |
LIFETIME_CREDITS |
Lifetime credits associated with the record. |
NUMBER |
6,2 |
MIDDLE_INIT |
Middle init associated with the record. |
VARCHAR2 |
1 |
MITSIS_GRAD_PROGRAM_ON_RECORD |
Mitsis grad program on record associated with the record. |
VARCHAR2 |
6 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
10 |
MODIFIED_BY |
Modified by associated with the record. |
NUMBER |
|
MODIFIED_DT |
Modified dt associated with the record. |
DATE |
|
MPN_EXPIRATION_DATE |
Date associated with mpn expiration. |
DATE |
|
NAME_MID |
Name mid associated with the record. |
VARCHAR2 |
12 |
NAME_PREF |
Name pref associated with the record. |
VARCHAR2 |
12 |
NC_INCOME |
Nc income associated with the record. |
NUMBER |
|
NC_WAIVE_STRING |
Nc waive string associated with the record. |
NUMBER |
|
NETPARTNER_LOCKED |
Netpartner locked associated with the record. |
VARCHAR2 |
1 |
NETPARTNER_LOCKED_BY |
Netpartner locked by associated with the record. |
VARCHAR2 |
25 |
NETPARTNER_LOCKED_DATE |
Date associated with netpartner locked. |
DATE |
|
NETPARTNER_LOCKED_TIME |
Netpartner locked time associated with the record. |
DATE |
|
NUMBER_AWARD_LETTERS |
Number award letters associated with the record. |
NUMBER |
|
OLD_SSN |
Old ssn associated with the applicant. |
VARCHAR2 |
9 |
ORIG_EPS |
Orig eps associated with the record. |
VARCHAR2 |
5 |
PARENT_MARITAL_STATUS |
Parent marital status associated with the record. |
VARCHAR2 |
6 |
PIN |
Pin associated with the applicant. |
VARCHAR2 |
57 |
PRIMARY_CITY |
Primary city associated with the record. |
VARCHAR2 |
20 |
PRIMARY_COUNTRY |
Primary country associated with the record. |
VARCHAR2 |
25 |
PRIMARY_PHONE_NUMBER |
Primary phone number associated with the record. |
VARCHAR2 |
20 |
PRIMARY_PHONE_NUMBER_INTL |
Primary phone number intl associated with the record. |
VARCHAR2 |
20 |
PRIMARY_STATE |
Primary state associated with the record. |
VARCHAR2 |
2 |
PRIMARY_STREET1 |
Primary street1 associated with the record. |
VARCHAR2 |
40 |
PRIMARY_STREET2 |
Primary street2 associated with the record. |
VARCHAR2 |
40 |
PRIMARY_STREET3 |
Primary street3 associated with the record. |
VARCHAR2 |
40 |
PRIMARY_ZIPCODE |
Primary zipcode associated with the record. |
VARCHAR2 |
9 |
PRIOR_NAME |
Prior name associated with the record. |
VARCHAR2 |
25 |
PROFILE_DATA_VA |
Profile data va associated with the record. |
VARCHAR2 |
1 |
QA_REVIEW_DATE |
Date associated with qa review. |
DATE |
|
RACE |
Race associated with the record. |
VARCHAR2 |
1 |
RACE_DESCRIPTION |
Description of race. |
VARCHAR2 |
50 |
READER_DATE |
Date associated with reader. |
DATE |
|
REQUIRE_PIN_RESET |
Require pin reset associated with the record. |
VARCHAR2 |
1 |
ROTC_AWARD_AMOUNT |
Rotc award amount associated with the record. |
NUMBER |
|
SAP_FALL |
Sap fall associated with the record. |
VARCHAR2 |
6 |
SAP_SPRING |
Sap spring associated with the record. |
VARCHAR2 |
6 |
SAP_SUMMER |
Sap summer associated with the record. |
VARCHAR2 |
6 |
SAT_PROG |
Sat prog associated with the record. |
NUMBER |
|
SECURITY_VERSION |
Security version associated with the record. |
NUMBER |
|
SH_75K_OR_LESS |
Sh 75k or less associated with the record. |
NUMBER |
|
SPR_GRADELVL |
Spr gradelvl associated with the record. |
VARCHAR2 |
6 |
STUDENT_SSN |
Student ssn associated with the applicant. |
VARCHAR2 |
9 |
STUDENT_TOKEN |
Student token associated with the record. |
NUMBER |
|
SUM_GRADE_LVL |
Sum grade lvl associated with the record. |
VARCHAR2 |
6 |
S_BKS_SUPP |
S bks supp associated with the record. |
NUMBER |
|
S_FM_FINSTAT |
S fm finstat associated with the record. |
VARCHAR2 |
1 |
S_FNAR_FINSTAT |
S fnar finstat associated with the record. |
VARCHAR2 |
1 |
S_IGRANTA |
S igranta associated with the record. |
NUMBER |
|
S_IGRANTD |
S igrantd associated with the record. |
NUMBER |
|
S_OTHERBDGT |
S otherbdgt associated with the record. |
NUMBER |
|
S_ROOM_BD |
S room bd associated with the record. |
NUMBER |
|
S_TOTALBUDGET |
S totalbudget associated with the record. |
NUMBER |
|
S_TRANSPORT |
S transport associated with the record. |
NUMBER |
|
S_TUITFEES |
S tuitfees associated with the record. |
NUMBER |
|
TOTAL_AID |
Total aid associated with the record. |
NUMBER |
|
TOTAL_AWARD_MARKED_NEED_BASED |
Total award marked need based associated with the record. |
NUMBER |
|
TOTAL_DEPT_GRADUATE_AWARD |
Total dept graduate award associated with the record. |
NUMBER |
|
TOTAL_EXTERNAL_AID |
Total external aid associated with the record. |
NUMBER |
|
TOTAL_EXTERNAL_DISBURSE |
Total external disburse associated with the record. |
NUMBER |
|
TOTAL_FEDERAL_FUND_AWARD |
Total federal fund award associated with the record. |
NUMBER |
|
TOTAL_FEDERAL_FUND_DISBURSE |
Total federal fund disburse associated with the record. |
NUMBER |
|
TOTAL_FFELP_AWARD |
Total ffelp award associated with the record. |
NUMBER |
|
TOTAL_GRANT_AWARD |
Total grant award associated with the record. |
NUMBER |
|
TOTAL_GRANT_DISBURSE |
Total grant disburse associated with the record. |
NUMBER |
|
TOTAL_INSTITUTE_FUND_AWARD |
Total institute fund award associated with the record. |
NUMBER |
|
TOTAL_INSTITUTE_FUND_DISBURSE |
Total institute fund disburse associated with the record. |
NUMBER |
|
TOTAL_JOBS_FUND_AWARD |
Total jobs fund award associated with the record. |
NUMBER |
|
TOTAL_JOBS_FUND_DISBURSE |
Total jobs fund disburse associated with the record. |
NUMBER |
|
TOTAL_LOANS_AWARD |
Total loans award associated with the record. |
NUMBER |
|
TOTAL_LOANS_DISBURSE |
Total loans disburse associated with the record. |
NUMBER |
|
TOTAL_OTHER_AID |
Total other aid associated with the record. |
NUMBER |
|
TOTAL_PACKAGE_AWARD |
Total package award associated with the record. |
NUMBER |
|
TOTAL_PARENT_INCOME |
Total parent income associated with the record. |
NUMBER |
|
TOTAL_PARENT_NET_WORTH |
Total parent net worth associated with the record. |
NUMBER |
|
TOTAL_PFELP_DISBURSE |
Total pfelp disburse associated with the record. |
NUMBER |
|
TOTAL_PRIVATE_FUND_AWARD |
Total private fund award associated with the record. |
NUMBER |
|
TOTAL_PRIVATE_FUND_DISBURSE |
Total private fund disburse associated with the record. |
NUMBER |
|
TOTAL_PRIVATE_GRANT_AWARD |
Total private grant award associated with the record. |
NUMBER |
|
TOTAL_PRIVATE_GRANT_DISBURSE |
Total private grant disburse associated with the record. |
NUMBER |
|
TOTAL_STATE_FUND_AWARD |
Total state fund award associated with the record. |
NUMBER |
|
TOTAL_STATE_FUND_DISBURSE |
Total state fund disburse associated with the record. |
NUMBER |
|
TOTAL_STUDY_ABROAD |
Total study abroad associated with the record. |
NUMBER |
|
TOT_PRIV_OUTSIDE_SCHOLARSHIP |
Tot priv outside scholarship associated with the record. |
NUMBER |
|
TRACKING_STATUS |
Tracking status associated with the record. |
VARCHAR2 |
2 |
TRANSFER_FLAG |
Transfer flag associated with the record. |
VARCHAR2 |
1 |
TUITION_CHARGE_FALL |
Tuition charge fall associated with the record. |
NUMBER |
|
TUITION_CHARGE_SPRING |
Tuition charge spring associated with the record. |
NUMBER |
|
TUITION_CHARGE_SUMMER |
Tuition charge summer associated with the record. |
NUMBER |
|
UNITS_FALL |
Units fall associated with the record. |
NUMBER |
|
UNITS_FALL_F |
Units fall f associated with the record. |
NUMBER |
|
UNITS_SPRING |
Units spring associated with the record. |
NUMBER |
|
UNITS_SPRING_F |
Units spring f associated with the record. |
NUMBER |
|
VETERAN_STATUS |
Veteran status associated with the record. |
VARCHAR2 |
6 |
WAREHOUSE_INSERT_TIMESTAMP |
Warehouse insert timestamp associated with the warehouse record. |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
Warehouse update timestamp associated with the warehouse record. |
DATE |
|
WEB_ID |
Business identifier for the web. |
VARCHAR2 |
9 |
WEB_LAST_LOGIN |
Web last login associated with the record. |
DATE |
|
WEB_ROLE |
Web role associated with the record. |
VARCHAR2 |
8 |
YELLOW_RIBBON |
Yellow ribbon associated with the record. |
VARCHAR2 |
6 |