Cohort-Level Analysis-Ready File Data Dictionary

Cohort-Level Analysis-Ready File Data

First Name

Student's first name in the submission file.

Middle Name

Student's middle name or first initial of middle name in the submission file.

Last Name

Student's last name in the submission file.

SSN

Student's Social Security Number in the submission file.

Date of Birth

Student's date of birth in the submission file in YYYYMMDD format.

Student ID

Institutionally supplied student ID number in the submission file.

Institution ID

8-digit OPEID.

Cohort

All undergraduate students who attempted at least one course in a given term, for the first time at the cohort institution in YYYY-YY format. For example: 2016-17. Students may be first-time ever in college or new transfer students at the cohort institution and may be enrolled at any program level, including credential- seeking; college remedial, developmental, or 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.
Excludes students who are:
  • 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

Cohort term of entry: 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.
  • Fall
  • Winter
  • Spring
  • Summer

Student Age

A 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

Enrollment Type

The student's enrollment type at the time of the defined cohort in the submission file.
  • First-time
  • Transfer-in

Enrollment Intensity First Term

A student’s full or part-time status is determined by the number of college credits attempted. If this value for the student's first term is greater than or equal to the single term-based credit threshold provided by the institution, the student is considered full-time. Otherwise, the student is considered part-time.
  • Full-time
  • Part-time

Math Placement

Student was determined to be college ready, not college ready, or of unknown readiness in math upon entry based on institution's standard math placement policies (e.g. placement determined by test scores, HS GPA, HS course taking and/or other institutional criteria).
  • C = Student is college ready in Math
  • N = Student is not college ready in Math
  • UK = Unknown or missing

English Placement

Student was determined to be college ready, not college ready, or of unknown readiness in English upon entry based on institution's standard English placement policies (e.g. placement determined by test scores, HS GPA, HS course taking and/or other institutional criteria).
  • C = Student is college ready in English
  • N = Student is not college ready in English
  • UK = Unknown or missing

Dual and Summer Enrollment

Student was a dual or concurrent high school enrollment student prior to first term enrolled with credential-seeking status at the cohort institution, and/or 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 or remedial coursework.
  • DE = Past Dual Enrollment
  • SE = Past Summer Enrollment
  • DS = Past Dual and Summer Enrollment

Race

Student race in the submission file.
  • Nonresident Alien
  • American Indian or Alaska Native
  • Asian
  • Black or African American
  • Native Hawaiian or Other Pacific Islander
  • White
  • Unknown or missing

Ethnicity

Student ethnicity in the submission file.
  • UK = Unknown
  • H = Hispanic
  • N = Not Hispanic

Gender

Student gender in data reported to the National Student Clearinghouse’s enrollment reporting service. If student gender is missing, it is imputed using methods developed by the Research Center.
  • M = Male
  • F = Female
  • N = NA

First Gen

First Generation Status: A student who is the first member of his or her immediate family to graduate from a college or university.
  • N = No parent has attended post-secondary
  • P = At least one parent has attended post-secondary but earned no credential or degree
  • C = At least one parent has a certificate
  • A = At least one parent has an Associate’s degree
  • B = At least one parent has a Bachelor's degree or higher

Pell Status First Year

If a student received a Pell Grant in any term within their first academic year.
  • Y = Yes
  • N = No

Attendance Status Term 1

In a student's first term of study, whether the student is a first-time freshman, a first-time transfer-in, or neither and whether the student is full-time or part-time.
  • First-Time Full-Time
  • First-Time Part-Time
  • Transfer-In Full-Time
  • Transfer-In Part-Time

Credential Type Sought Year 1

A student’s credential-seeking status is based on his/her "Degree Type Sought" value in an institution's submission file. If degree type sought is not populated in the Course Extended file, or if this field was populated in historical data from a secondary data source that does not have values that can be mapped with the values in the Course Extended File submission guide, then this is populated from NSC enrollment records, which is why there are multiple values that correspond to the same credential type.
  • C1 = Less than one-year certificate, less than Associate degree
  • C2 = One to two year certificate, less than Associate degree
  • C4 = Two to four year certificate, less than Bachelor's degree
  • 01 = Undergraduate Certificate or Diploma Program
  • A or 02 = Associate Degree
  • B or 03 = Bachelor's Degree
  • PB or 04 = Post Baccalaureate Certificate
  • M or 05 = Master’s Degree
  • D or 06 = Doctoral Degree
  • FP or 07 = First Professional Degree
  • PC or 08 = Graduate/Professional Certificate
  • NC or 99 = Non- Credential Program (Preparatory Coursework/Teach Certification)
  • −1= Missing

Program of Study Term 1

Student's program of study based on major CIP code reported by the cohort institution. Six-digit numeric code.

GPA Group Term 1

Student's GPA at the end of first term. Continuous with values between 0-4.

GPA Group Year 1

Student's GPA at the end of first academic year. Continuous with values between 0-4.

Number of Credits Attempted Year 1

The sum of the values in the number of credits attempted fields in the Course Extended file for the student's first academic year. Continuous with a minimum value of 1.

Number of Credits Attempted Year 2

The sum of the values in the number of credits attempted fields in the Course Extended file for the student's second academic year. Continuous with a minimum value of 0.

Number of Credits Attempted Year 3

The sum of the values in the number of credits attempted fields in the Course Extended file for the student's third academic year. Continuous with a minimum value of 0.

Number of Credits Attempted Year 4

The sum of the values in the number of credits attempted fields in the Course Extended file for the student's fourth academic year. Continuous with a minimum value of 0.

Number of Credits Earned Year 1

The sum of the values in the number of credits earned fields in the Course Extended file for the student's first academic year. Continuous with a minimum value of 0.

Number of Credits Earned Year 2

The sum of the values in the number of credits earned fields in the Course Extended file for the student's second academic year. Continuous with a minimum value of 0.

Number of Credits Earned Year 3

The sum of the values in the number of credits earned fields in the Course Extended file for the student's third academic year. Continuous with a minimum value of 0.

Number of Credits Earned Year 4

The sum of the values in the number of credits earned fields in the Course Extended file for the student's fourth academic year. Continuous with a minimum value of 0.

Gateway Math Status

Indicates whether the student is required to complete a gateway math course at time of first enrollment. Some students may be exempt from gateway math coursework, for example, those transferring from another institution where they completed the requirement, or students fulfilling the requirement by successful completion of AP, IB or similar high school coursework. Also, some majors/program areas may not require a gateway math course.
  • R = Gateway Math course is required of student at time of entry
  • N = Gateway Math course is not required of student at time of entry
  • UK = Unknown or missing

Gateway English Status

Indicates whether the student is required to complete a gateway English course at time of first enrollment. Some students may be exempt from gateway English coursework, for example, those transferring from another institution where they completed the requirement, or students fulfilling the requirement by successful completion of AP, IB or similar high school coursework. Also, some majors/program areas may not require a gateway English course.
  • R = Gateway English course is required of student at time of entry
  • N = Gateway English course is not required of student at time of entry
  • UK = Unknown or missing

AttemptedGatewayMathYear1

If a student is required to complete a gateway math course in the first academic year and the number of credits attempted for a math gateway course are greater than 0, the student is considered to have attempted.
  • Y = Attempted Gateway Math Course
  • N = Did not Attempt Gateway Math Course
  • UK = Unknown

AttemptedGatewayEnglishYear1

If a student is required to complete a gateway English course in the first academic year and the number of credits attempted for an English gateway course are greater than 0, the student is considered to have attempted.
  • Y=Attempted Gateway English Course
  • N = Did not Attempt Gateway English Course
  • UK = Unknown

CompletedGatewayMathYear1

For students who are required to take gateway math, and who receive a grade greater than or equal to 1 on a 4-point scale, or a "P" if the course is Pass/Fail during their first academic year.
  • C = Completed
  • D = Did not complete
  • NA = Not applicable

CompletedGatewayEnglishYear1

Completed English Gateway Course First Year For students who are required to take gateway English, and who receive a grade greater than or equal to 1 on a 4-point scale, or a "P" if the course is Pass/Fail during their first academic year.
  • C = Completed
  • D = Did not complete
  • NA = Not applicable

GatewayMathGradeY1

For students who are required to take gateway math the highest grade they received in their attempted gateway math course in their first academic year. Continuous with values between 0-4. If a numeric grade does not apply to the course:
  • P = Pass
  • F = Fail
  • I = Incomplete
  • W = Withdraw
  • A = Audit
  • M = Missing
  • O = Other

GatewayEnglishGradeY1

For students who are required to take gateway English, the highest grade they received in their attempted gateway English course in their first academic year. Continuous with values between 0-4. If a numeric grade does not apply to the course:
  • P = Pass
  • F = Fail
  • I = Incomplete
  • W = Withdraw
  • A = Audit
  • M = Missing
  • O = Other

AttemptedDevMathY1

If in a student's first academic year, the student is not considered college ready in math, and has at least one course in the Course Extended file with a course type that is developmental, remedial or preparatory, the student is assumed to have attempted developmental math. If a student is not college ready in math, but no course type is listed as developmental, remedial or preparatory, a student is not considered to have attempted developmental math. If a student's math placement is unknown then the value will be listed as unknown.
  • Y = Yes
  • N = No
  • NA = Not Applicable
  • UK = Unknown

AttemptedDevEnglishY1

If in a student's first academic year, the student is not considered college ready in English, and has at least one course in the Course Extended file with a course type that is developmental, remedial or preparatory, the student is assumed to have attempted developmental English. If a student is not college ready in English but no course type is listed as developmental, remedial or preparatory, a student is not considered to have attempted developmental English. If a student's English placement is unknown then the value will be listed as unknown.
  • Y = Yes
  • N = No
  • NA = Not Applicable
  • UK = Unknown

CompletedDevMathY1

For students who were referred/placed into developmental math, whether the student completed final developmental Math requirement(s) during the term as reported in the submission file. The student need not have completed all of the requirements during this term, just the final requirement.
  • C = Referred/placed, completed dev Math coursework
  • D = Referred/placed, did not complete dev English coursework
  • NA = Not applicable

CompletedDevEnglishY1

For students who were referred/placed into developmental math, whether the student completed final developmental English requirement(s) during the term as reported in the submission file. The student need not have completed all of the requirements during this term, just the final requirement.
  • C = Referred/placed, completed dev English coursework
  • D = Referred/placed, did not complete dev English coursework
  • NA = Not applicable

Retention

Retention is defined as either continued enrollment at the cohort institution in the second academic year or completion of any credential at the initial institution in the first or second academic year.
  • 1 = student was retained
  • 0 = student was not retained

Persistence

A student is defined as having persisted if the student has a bachelor's degree from another institution by second year, or an associate degree or certificate from another institution by second year, or is enrolled at other institution by second year.
  • 1 = student persisted
  • 0 = student did not persist

Year Earned Bachelor (cohort institution)

For students in the cohort that are either first-time or transfer-in students and have a bachelor's degree that was awarded on or before the report effective date (and not a future date) at the cohort institution. Year earned is calculated as (degree awarded date- cohort begin date)/365. For values > 0 and <=1, year earned bachelor will be 1, for values >1 and <=2, year earned bachelor will be 2, etc.
  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7

Year Earned Associates (cohort institution)

For students in the cohort that are either first-time or transfer students and have an associate degree or certificate that was awarded on or before the report effective date (and not a future date) at the cohort institution. Year earned is calculated as (degree awarded date- cohort begin date)/365. For values > 0 and <=1, year earned associate or certificate will be 1, for values >1 and <=2, year earned associate or certificate will be 2, etc.
  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7

Year Earned Bachelor (other institution)

For students in the cohort that are either first-time or transfer-in students and have a bachelor's degree awarded on or before the report effective date (and not a future date) at an institution other than the cohort institution. Year earned is calculated as (degree awarded date- cohort begin date)/365. For values > 0 and <=1, year earned bachelor will be 1, for values >1 and <=2, year earned bachelor will be 2, etc.
  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7

Year Earned Associates (other institution)

For students in the cohort that are either first-time or transfer-in students and have an associate degree or certificate that was awarded on or before the report effective date (and not a future date) at an institution other than the cohort institution. Year earned is calculated as (degree awarded date-cohort begin date)/365. For values > 0 and <=1, year earned associate or certificate will be 1, for values >1 and <=2, year earned associate or certificate will be 2, etc.
  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7

Year of Last Enrollment (cohort institution)

The year of the last term enrollment begin date that student was enrolled at the cohort institution.
  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7

Year of Last Enrollment (other institution)

The year of the last term enrollment begin date that student was enrolled at an institution other than the cohort institution.
  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7

Time to Credential

Number of years between a student's earliest enrollment at cohort institution and earliest degree award date at the cohort institution rounded to nearest decimal.

Was this article helpful?

Related Articles