FAID APPLICANT DETAIL SNAPSHOT Table
View exposing snapshot financial-aid applicant detail including applicant identity, demographic and residency attributes, family and income measures, enrollment attributes, budget measures, and snapshot metadata.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIT_STATUS |
Admit status associated with the record. |
VARCHAR2 |
1 |
APP_COMPLETE_DT |
App complete dt associated with the record. |
DATE |
|
AWARD_YEAR_TOKEN |
Award year token associated with the record. |
NUMBER |
|
BUDGET_DURATION |
Budget duration associated with the record. |
NUMBER |
4,1 |
CC_TFC |
Cc tfc associated with the record. |
NUMBER |
19 |
CITIZEN_CODE |
Code identifying citizen. |
VARCHAR2 |
1 |
CURRENT_IDOC |
Current idoc associated with the record. |
NUMBER |
|
CUST_TTL_INC |
Cust ttl inc associated with the record. |
NUMBER |
|
DATA_VALID |
Data valid associated with the record. |
VARCHAR2 |
1 |
DEPENDENCY |
Dependency associated with the record. |
VARCHAR2 |
1 |
DT_WITH |
Dt with associated with the record. |
DATE |
|
EFM_TFC |
Efm tfc associated with the record. |
NUMBER |
19 |
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 |
ETHNICITY |
Ethnicity associated with the record. |
VARCHAR2 |
6 |
FAID_APPLICANT_KEY |
Surrogate key identifying the faid applicant. |
VARCHAR2 |
21 |
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_BACHELOR_BY_7_1_96 |
First bachelor by 7 1 96 associated with the record. |
VARCHAR2 |
1 |
FIRST_NAME |
First name associated with the person. |
VARCHAR2 |
15 |
HOME_PURCH_PRICE |
Home purch price associated with the record. |
NUMBER |
19 |
HOUSING_STATUS |
Housing status associated with the record. |
VARCHAR2 |
1 |
INAR_FORMULA |
Inar formula associated with the record. |
VARCHAR2 |
1 |
IPEDS |
Ipeds associated with the record. |
NUMBER |
|
I_P_CNTRY_RES |
I p cntry res associated with the record. |
VARCHAR2 |
2 |
I_S_GENDER |
I s gender associated with the record. |
VARCHAR2 |
1 |
I_VABENEFITS |
I vabenefits associated with the record. |
NUMBER |
19 |
LAST_NAME |
Last name associated with the person. |
VARCHAR2 |
30 |
METHODOLOGY_TYPE |
Methodology type associated with the record. |
VARCHAR2 |
2 |
MIDDLE_INIT |
Middle init associated with the record. |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
10 |
NATURAL_STAT |
Natural stat associated with the record. |
VARCHAR2 |
1 |
NC_INCOME |
Nc income associated with the record. |
NUMBER |
|
NC_WAIVE_STRING |
Nc waive string associated with the record. |
NUMBER |
|
NUM_IN_COLLEGE |
Num in college associated with the record. |
NUMBER |
|
ORIGINAL_NEED |
Original need associated with the record. |
NUMBER |
27,6 |
OTHER_TAXABLE |
Other taxable associated with the record. |
NUMBER |
19 |
PARENT_1_AGE |
Parent 1 age associated with the record. |
NUMBER |
|
PARENT_2_AGE |
Parent 2 age associated with the record. |
NUMBER |
|
PARENT_AGI |
Parent agi associated with the record. |
NUMBER |
19 |
PARENT_ASSET_CONTRIB |
Parent asset contrib associated with the record. |
NUMBER |
19 |
PARENT_CONTRIB |
Parent contrib associated with the record. |
NUMBER |
19 |
PARENT_EMAIL |
Parent email associated with the record. |
VARCHAR2 |
50 |
PARENT_HOME_DEBT |
Parent home debt associated with the record. |
NUMBER |
19 |
PARENT_HOME_EQUITY |
Parent home equity associated with the record. |
NUMBER |
19 |
PARENT_HOME_VALUE |
Parent home value associated with the record. |
NUMBER |
19 |
PARENT_INCOME_CONTRIB |
Parent income contrib associated with the record. |
NUMBER |
19 |
PARENT_NET_WORTH |
Parent net worth associated with the record. |
NUMBER |
19 |
PARENT_NUM_IN_COLLEGE |
Parent num in college associated with the record. |
NUMBER |
|
PARENT_NUM_IN_FAMILY |
Parent num in family associated with the record. |
NUMBER |
|
PARENT_TOTAL_INCOME |
Parent total income associated with the record. |
NUMBER |
19 |
PAR_1_LAST_NAME |
Par 1 last name associated with the person. |
VARCHAR2 |
16 |
PAR_2_LAST_NAME |
Par 2 last name associated with the person. |
VARCHAR2 |
16 |
PAR_CONTRIB |
Par contrib associated with the record. |
NUMBER |
19 |
PRIMARY_COUNTRY |
Primary country associated with the record. |
VARCHAR2 |
25 |
PRIMARY_STATE |
Primary state associated with the record. |
VARCHAR2 |
2 |
P_LEGAL_RES |
P legal res associated with the record. |
VARCHAR2 |
2 |
P_LEGAL_RES_D |
P legal res d associated with the record. |
DATE |
|
P_LEG_RES_BEF |
P leg res bef associated with the record. |
VARCHAR2 |
1 |
P_NUMCOLLEGE |
P numcollege associated with the record. |
NUMBER |
|
P_NUMFAMILY |
P numfamily associated with the record. |
NUMBER |
|
RACE |
Race associated with the record. |
VARCHAR2 |
1 |
READER_DATE |
Date associated with reader. |
DATE |
|
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 |
SAR_C_FLAG |
Sar c flag associated with the record. |
VARCHAR2 |
1 |
SAT_PROG |
Sat prog associated with the record. |
NUMBER |
|
SH_75K_OR_LESS |
Sh 75k or less associated with the record. |
NUMBER |
|
SNAPSHOT_EVENT |
Snapshot event associated with the record. |
VARCHAR2 |
30 |
SNAPSHOT_KEY |
Surrogate key identifying the snapshot. |
BLOB |
|
SPR_GRADELVL |
Spr gradelvl associated with the record. |
VARCHAR2 |
6 |
STUDENT_CONTRIB |
Student contrib associated with the record. |
NUMBER |
19 |
STUDENT_MARITAL_STATUS |
Student marital status associated with the record. |
VARCHAR2 |
1 |
STUDENT_NET_WORTH |
Student net worth associated with the record. |
NUMBER |
19 |
STUDENT_NUM_IN_FAMILY |
Student num in family associated with the record. |
NUMBER |
|
STUDENT_SSN |
Student ssn associated with the applicant. |
VARCHAR2 |
9 |
STUDENT_TOTAL_INCOME |
Student total income associated with the record. |
NUMBER |
19 |
STU_GROSSINC |
Stu grossinc 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_IGRANTA |
S igranta associated with the record. |
NUMBER |
|
S_IGRANTD |
S igrantd associated with the record. |
NUMBER |
|
S_LEGAL_RES |
S legal res associated with the record. |
VARCHAR2 |
2 |
S_LEGAL_RES_D |
S legal res d associated with the record. |
DATE |
|
S_LEG_RES_BEF |
S leg res bef associated with the record. |
VARCHAR2 |
1 |
S_OTHERBDGT |
S otherbdgt associated with the record. |
NUMBER |
|
S_ROOM_BD |
S room bd associated with the record. |
NUMBER |
|
S_TOTPARCNTR |
S totparcntr associated with the record. |
NUMBER |
|
S_TRANSPORT |
S transport associated with the record. |
NUMBER |
|
S_TUITFEES |
S tuitfees associated with the record. |
NUMBER |
|
TOTAL_BUDGET |
Total budget associated with the record. |
NUMBER |
|
TOTAL_PARENT_INCOME |
Total parent income associated with the record. |
NUMBER |
19 |
TRACKING_STATUS |
Tracking status associated with the record. |
VARCHAR2 |
2 |
TRANSFER_FLAG |
Transfer flag associated with the record. |
VARCHAR2 |
1 |
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 |
|
WAREHOUSE_INSERT_TIMESTAMP |
Warehouse insert timestamp associated with the warehouse record. |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
Warehouse update timestamp associated with the warehouse record. |
DATE |
|
YELLOW_RIBBON |
Yellow ribbon associated with the record. |
VARCHAR2 |
6 |