Course-Level Analysis-Ready File Data
First NameStudent's first name in the submission file.
Middle NameStudent's middle name or initial in the submission file.
Last NameStudent's last name in the submission file.
SSNStudent’s Social Security Number in the submission file.
Date of BirthStudent’s date of birth in the submission file in YYYYMMDD format.
Student IDInstitutionally supplied student ID number in the submission file.
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 365.25 and rounded to the nearest whole number.
- 20 and younger
RaceStudent’s race in the submission file.
- Nonresident Alien
- American Indian or Alaska Native
- Black or African American
- Native Hawaiian or Other Pacific Islander
- Two or more races
- Unknown or missing
EthnicityEthnicity Ethnicity Student’s ethnicity in the submission file.
- UK = Unknown
- H = Hispanic
- N = Not Hispanic
Institution IDThe institution’s ID (currently only OPEID) 8-digit OPEID
CohortAcademic year in which the student first enrolled in at least one course in YYYY-YY format. Must match the Cohort value in the course data file. Must be 2 consecutive years between 2000 and today. Example: 2019-20
Cohort TermTerm student first enrolled in at least one course.
Academic YearAcademic year in which the student was enrolled in the course in YYYY–YY format.
Academic TermAcademic term in which the student was enrolled in the course.
Course PrefixCourse prefix in the submission file. Course prefix as it appears in your institution’s catalog. For example, ENG 101 Composition I = ENG. Can include: period, hyphen, underscore, ampersand
Course NumberCourse number in the submission file. Course number as it appears in your institution’s catalog. For example, ENG 101 Composition I = 101. Can include: period, hyphen, underscore, ampersand
Section IDSection ID in the submission file. Section ID as it appears in your institution’s catalog. If not available, enter Missing. Can include: period, hyphen, underscore, ampersand
Course NameCourse name in the submission file. Course name as it appears in your institution’s catalog. For example, ENG 101 Composition I = Composition I. Course CIP Course CIP Appropriate Course CIP Code See https://nces.ed.gov/ipeds/cipcode for a list of valid codes. Left blank if a code is not available.
Course TypeType of course.
- CU = College‐level, undergraduate (credit towards certificate, associate’s, or bachelor's degree)
- CG = College level, graduate (credit towards graduate degree)
- CC = College developmental, remedial or preparatory credit towards credential completion requirements
- CD = College developmental, remedial or preparatory credits not applicable towards credential completion requirements
- EL = ESL (non‐credit adult basic skills courses supported by WIA Title II)
- AB = Adult basic education
- GE = Adult secondary education/GED
- NC = Non‐credit vocational (courses that lead to an occupational certificate, industry certificate, or other type of credential)
- O = Other
Math or English GatewayWhether the course is considered a Math or English Gateway.
- M = Math
- E = English
- N = N/A
Co-requisite CourseWhether or not this course was a co-requisite, which enrolls students in developmental (remedial) education and college‐level courses in the same subject at the same time.
- Y = Yes
- N = No
Course Begin DateDate the student began enrollment in the course (not the registration date) in YYYYMMDD format.
Course End DateDate the student ended enrollment in the course in YYYYMMDD format.
GradeGrade the student earned for the course in the submission file. Student’s grade for the term on a 4‐point scale. If a numeric grade did not apply to the course, one of the following values may appear:
- P = Pass
- F = Fail
- I = Incomplete
- W = Withdraw
- A = Audit
- M = Missing
- O = Other
Number of CreditsAttempted Number of credits the student attempted in the course. Should be a number between 0-20.
Number of Credits EarnedNumber of credits the student earned for the course. Should be a number between 0-20; cannot be greater than number of credits attempted
Delivery MethodDescribes how the course was administered between teacher and student.
- F = Face-to-face
- O = Online
- H = Hybrid
Core CourseCourse is part of core competency/general education courses at the institution.
- Y = Yes
- N = No
Core Course TypeType of core competency. Required if Core Course = Y. Can be up to 20 characters. For example, core course type for “Introduction to Art 101” is “Humanities.”
Core Competency CompletedStudent completed the core/general education course.
- Y = Core requirements evaluated and satisfied
- N = Core requirements evaluated but not satisfied
Enrollment Record at Other Institution(s)Whether or not the student was enrolled at another institution at the same time as this course or during this academic term (if a course record is not available).
- Y = Yes
- N = No