Financial Aid Analysis-Ready File Data
First NameStudent's first name
Middle NameStudent's middle name or initial
Last NameStudent's last name
SSNStudent’s Social Security Number
Date of BirthStudent’s date of birth in YYYYMMDD format
Student IDStudent’s ID number at your institution
Institution ID8-digit OPEID
CohortYYYY- YY format. Includes all undergraduate students who attempted at least one course in a given term for the first time at your institution. Students may be first-time ever in college or new transfer students and may be enrolled at any program level, including credential-seeking, college remedial, developmental, college-preparatory, adult basic skills (ESL, ABE, or ASE/GED), and non-credit vocational students. For non-credit vocational students, cohort only includes those who enrolled in courses that could lead to an occupational certificate, industry certificate, or other type of credential of economic value as well as those students who are simultaneously enrolled in credit- bearing courses. Also includes:
- Past dual enrollment students who took a course or courses at the cohort institution while simultaneously attending high school
- Fall entry students who enrolled in summer work prior to first term of enrollment with credential-seeking status. Examples of summer work include, but are not limited to, summer bridge programs or developmental/remedial coursework
- Non-credit vocational students enrolled in purely personal enrichment courses
- Current dual enrollment students or those taking a course or courses at the cohort institution while simultaneously attending high school.
Cohort Term(Fall, Winter, Spring, or Summer) Term student first enrolled in at least one course. See definition of cohort. If you have more than one term (e.g. Summer I and Summer II) you can differentiate the terms by using the appropriate Term Begin and Term End dates.
Student AgeA student’s age is calculated as Term Start Date of the institution term listed for the designated fall term in the cohort year minus Date of Birth divided by 365.25. Once rounded to the nearest whole number, ages are grouped into 3 categories: 20 and younger, >20-24, older than 24.
Academic YearAcademic year in which the student was enrolled in the course in YYYY–YY format.
Dependency StatusStudent's dependency status at the time of FAFSA application or first term of enrollment for the academic year if FAFSA data is not available.
- D = Dependent
- I = Independent
- X = Rejected Dependent
- Y = Rejected Independent
- If blank or any other value code as UK
Housing StatusType of housing student stayed in during the academic year.
- 1 = Off-campus (not with family): Student does not live with parents or legal guardians in a housing facility that is not owned or controlled by the educational institution.
- 2 = Off-campus (with family): Student lives with parents or legal guardians in a housing facility that is not owned or controlled by the educational institution.
- 3 = Off-campus: Only use this option if ISIR for student is not available and detail of Off-Campus living (with or without family) is unknown.
- 4 = On-campus housing: Any residence hall or housing facility owned or controlled by an institution within the same reasonably contiguous geographic area and used by the institution in direct support of or in a manner related to the institution's educational purposes.
- Any other value, or if blank, recode to UK
Cost of AttendanceTuition + Room Charges + Board Charges + Books + Other Expenses. Continuous with a minimum value of 0.
EFCExpected Family Contribution: An index number that financial aid staff use to determine how much financial aid a student would receive if they were to attend the institution. The information reported on the student's FAFSA form is used to calculate their EFC. EFC Passes through from the data intake file. Continuous with a minimum value of 0.
Total Institutional GrantsInstitution Grant Need Based + Institution Grant Employer Aid + Institution Grant Merit + Institution Grant Military or Veteran + Other Institution Grant (Non-need Based). Continuous with a minimum value of 0.
Total State GrantsState Grant Need Based + State Grant Non-need Based. Continuous with a minimum value of 0.
Total Federal GrantsSEOG + TEACH + Veteran and Military + Other Federal Grant + Pell Amount. SEOG: Supplemental Educational Opportunity Grant. TEACH: Teacher Education Assistance for College and Higher Education. Continuous with a minimum value of 0.
Unmet NeedCost of Attendance - EFC - Total Institutional Grants - Total State Grants - Total Federal Grants. Continuous with a minimum value of 0.
Net PriceCost of Attendance - Total Institutional Grants - Total State Grants - Total Federal Grants. Continuous with a minimum value of 0.
Applied AidWhether the institution received an ISIR record (including rejected ISIR records) for the student for the academic year.
- Y = Yes
- N = No