Datasets: Financial Aid Database Report (FY 2001 to FY 2017)
Datasets
The Financial Aid Database (FAD) Report contains student-level financial aid data for students enrolled in Texas higher education institutions.
ERC Datasets | UTD-ERC Datasets | Sector | Start | End |
|---|---|---|---|---|
fads_fy[xx] |
| All | FY 2001 | FY 2017 |
Variables
ERC Variable | UTD-ERC Variable | Item Name | Description | TYPE | LENGTH | Item Number | Start | End |
|---|---|---|---|---|---|---|---|---|
fadcode | rectype | Record Code identifies the report associated with the data, in this case, Financial Aid Data. For all rows, Record Code = 'F.' | Character | 1 | 1A | FY 2005 | FY 2017 | |
fadfice | school | FICE is the 6-digit FICE code that uniquely identifies an institution. | Character | 6 | 1B | FY 2001 | FY 2017 | |
fadyear | fis_year | Reporting Year identifies the fiscal year for which the data were reported. | Character | 4 | 1C | FY 2001 | FY 2017 | |
fadstuinc | stinc | Student Income Earned from Work. | Numeric | 8 | 2 | FY 2001 | FY 2007 | |
fadstuadjinc | stuadinc | Student Adj Income |
| Numeric | 8 | 2 | FY 2008 | FY 2016 |
fadstuAGI | stuadinc | Student and/or Spouse Adjusted Gross Income (AGI) is the parent(s) AGI used to calculate the Expected Family Contribution (EFC). | Numeric | 8 | 2 | FY 2017 | FY 2017 | |
fadspouseinc | sposeinc | Spouse Income Earned from Work. | Numeric | 8 | 3 | FY 2001 | FY 2007 | |
fadparadjinc | paradinc | Parent Adj Income |
| Numeric | 8 | 3 | FY 2008 | FY 2016 |
fadparentAGI | paradinc | Parent(s) Adjusted Gross Income (AGI) is the parent(s)' AGI used to calculate the Expected Family Contribution (EFC). | Numeric | 8 | 3 | FY 2017 | FY 2017 | |
fadssben | ssben | Social Security Benefits for Student and/or Spouse. | Numeric | 8 | 4 | FY 2001 | FY 2007 | |
fadtop10scholarship | top10sch | Top Ten Percent (Top 10%) Scholarship is the amount of Top 10% Scholarship funds disbursed to the student during the given fiscal year, as of the reporting cycle. | Numeric | 8 | 4 | FY 2010 | FY 2017 | |
fadafdc | afdc | Aid to Families with Dependent Children (AFDC or ADC) for Student and/or Spouse. | Numeric | 8 | 5 | FY 2001 | FY 2007 | |
fadunmatchedreason | unmreas | Justification (formerly called Exceptions) identifies the reason that a student is eligible for financial assistance for the given fiscal year when no match is found for the student on the corresponding CBM001/CBM0C1 reports. | Character | 2 | 5 | FY 2011 | FY 2017 | |
fadchildsupport | childspt | Child Support Received for All Children by Student and/or Spouse. | Numeric | 8 | 6 | FY 2001 | FY 2007 | |
fadexemptwaiveraward1 | tuiwawd1 | Tuition Exemption/Waiver Award 1 is the amount of tuition and fees the student did not pay as a result of the exemption/waiver. If not applicable, the value is 0. | Numeric | 8 | 6 | FY 2011 | FY 2017 | |
fadotherinc | othinc | ther Untaxed Income and Benefits for Student and/or Spouse. | Numeric | 8 | 7 | FY 2001 | FY 2007 | |
fadexemptwaivercode1 | tuiwcd1 | Tuition Exemption/Waiver Award 1 Code identifies the type of tuition exemption/waiver. If not applicable, code '00' is used. | Character | 2 | 7 | FY 2011 | FY 2017 | |
fadfatherinc | dadinc | Father's Income Earned from Work. | Numeric | 8 | 8 | FY 2001 | FY 2007 | |
fadexemptwaiveraward2 | tuiwawd2 | Tuition Exemption/Waiver Award 2 is the amount of tuition and fees the student did not pay as a result of the exemption/waiver. If not applicable, the value is 0. | Numeric | 8 | 8 | FY 2011 | FY 2017 | |
fadmotherinc | mominc | Mother's Income Earned from Work. | Numeric | 8 | 9 | FY 2001 | FY 2007 | |
fadexemptwaivercode2 | tuiwcd2 | Tuition Exemption/Waiver Award 2 Code identifies the type of tuition exemption/waiver. If not applicable, code '00' is used. | Character | 2 | 9 | FY 2011 | FY 2017 | |
fadparssben | pssbene | Parent's Social Security Benefits. | Numeric | 8 | 10 | FY 2001 | FY 2007 | |
fadexemptwaiveraward3 | tuiwawd3 | Tuition Exemption/Waiver Award 3 is the amount of tuition and fees the student did not pay as a result of the exemption/waiver. If not applicable, the value is 0. | Numeric | 8 | 10 | FY 2011 | FY 2017 | |
fadparafdc | pafdc | Parents' AFDC, ADC Received. | Numeric | 8 | 11 | FY 2001 | FY 2007 | |
fadexemptwaivercode3 | tuiwcd3 | Tuition Exemption/Waiver Award 3 Code identifies the type of tuition exemption/waiver. If not applicable, code '00' is used. | Character | 2 | 11 | FY 2011 | FY 2017 | |
fadparchildsupp | pchilspt | Child Support Received by Parents for All Children. | Numeric | 8 | 12 | FY 2001 | FY 2007 | |
fadparotherinc | pothinc | Parents' Other Untaxed Income and Benefits. | Numeric | 8 | 13 | FY 2001 | FY 2007 | |
fadneedanalysis | needana | Need Analysis identifies whether an Expected Family Contribution (EFC) based on the Federal Methodology was calculated. | Character | 1 | 13 | FY 2010 | FY 2017 | |
fadeth | ethnic | Ethnic origin of the student. | Character | 1 | 14 | FY 2001 | FY 2010 | |
fadlivingarrangement | livarge | Living Arrangement identifies the living arrangement for the student as determined by the institution when calculating cost of attendance. | Character | 1 | 14 | FY 2010 | FY 2017 | |
fadclass | classify | Classification identifies the student's classification at the start of the fiscal (academic) year. | Character | 1 | 15 | FY 2001 | FY 2017 | |
fadethnicorigin | ethhispa | Ethnic Origin indicates whether the student is of Hispanic or Latino origin or not. Hispanic or Latino refers to a person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. | Character | 1 | 15 | FY 2010 | FY 2017 | |
faddepend | dependnt | Dependency Status identifies the dependency status of the student based on the FAFSA for the given fiscal (academic) year. | Character | 1 | 16 | FY 2001 | FY 2017 | |
fadwhite | ethwhite | White indicates whether the student is White or not. White, one of the categories of race, refers to a person having origins in any of the original peoples of Europe, the Middle East, or North Africa. | Character | 1 | 16a | FY 2010 | FY 2017 | |
fadblack | ethblack | Black or African-American indicates whether the student is Black or African-American or not. Black or African American, one of the categories of race, refers to a person having origins in any of the black racial groups of Africa. | Character | 1 | 16b | FY 2010 | FY 2017 | |
fadasian | ethasian | Asian indicates whether the student is Asian or not. Asian, one of the categories of race, refers to a person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam. | Character | 1 | 16c | FY 2010 | FY 2017 | |
fadnative | ethnativ | American Indian or Alaskan Native indicates whether the student is American Indian or Alaskan Native or not. American Indian or Alaskan Native, one of the categories of race, refers to a person having origins in any of the original peoples of North and South America (including Central America) and who maintains a tribal affiliation or community attachment. | Character | 1 | 16d | FY 2010 | FY 2017 | |
fadinternat | ethinter | International indicates whether the student is an international student or not. International, reported along with race categories, refers to a student who is not a citizen or permanent resident of the United States and who is in this country on a temporary basis and does not have the right to remain indefinitely. | Character | 1 | 16e | FY 2010 | FY 2017 | |
fadunknown | ethunkwn | Unknown or Not Reported indicates that the student's race is unknown or not reported. | Character | 1 | 16f | FY 2010 | FY 2017 | |
fadpacific | ethpacif | Native Hawaiian or Other Pacific Islander indicates whether the student is Native Hawaiian or Other Pacific Islander or not. Native Hawaiian or Other Pacific Islander, Native Hawaiian or Other Pacific Islander is a person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands. | Character | 1 | 16g | FY 2010 | FY 2017 | |
fadresflag | res_flag | Residency Status identifies the residency status used to determine the student's eligibility for financial assistance for the given fiscal (academic) year. | Character | 1 | 18 | FY 2001 | FY 2017 | |
fadres | res | Location Code of Permanent Home Address based on county codes. | Character | 3 | 19 | FY 2001 | FY 2009 | |
fadefc9 | nfamcont | 9-Month Expected Family Contribution (EFC) is the EFC as determined using the Federal Methodology. | Numeric | 8 | 21a | FY 2014 | FY 2017 | |
COA9 | coa9 |
| Character | 6 | 21b | FY 2016 | FY 2017 | |
fadenrstat | enrstat | Enrollment Status identifies is the student's highest enrollment status (e.g., Full-time, ½ time) for a semester in the given fiscal year (e.g., fall, spring, summer). | Character | 1 | 23 | FY 2001 | FY 2017 | |
fadgen | sex | Gender is the student's gender at birth. | Character | 1 | 24 | FY 2001 | FY 2017 | |
fadmgrade | momed | Parent 1 Highest Grade-Level Completed is the highest level of education completed by the student's first parent. | Character | 1 | 25 | FY 2001 | FY 2017 | |
fadfgrade | daded | Parent 2 Highest Grade-Level Completed is the highest level of education completed by the student's second parent. | Character | 1 | 26 | FY 2001 | FY 2017 | |
fadcost | costatt | Cost of Attendance (COA) is the COA used in calculating the student’s financial need based on the enrollment period (e.g. 12months, 9 months, 6 months, 4 months, etc.) determined by using the Federal Methodology. | Numeric | 8 | 27 | FY 2001 | FY 2017 | |
fadfamcontrib | tfamcont | Expected Family Contribution (EFC) is the amount of the student's actual EFC on the enrollment period (e.g. 12months, 9 months, 6 months, 4 months, etc.) determined by using the Federal Methodology. | Numeric | 8 | 28 | FY 2001 | FY 2017 | |
fadexempt |