The Degree File includes all students who have received a certificate, degree, or formal award approved by DHE during the report year. Also contains data on age, ethnicity, program name, and residency.
This dataset has the following 21 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
year | year | number | Year of record. Changes from source: derived by removing the FA- from Data Type field. | 2001 2002 2003 2004 2005 view top 100 |
institutionName | institutionname | text | The name of the institution. Changes from source: 'Western State University' replaced 'Western State Colorado University' for older years records to maintain consistancy for queries on this university. | Aims Community College Arapahoe Community College Colorado Mountain College Colorado Northwestern Community College Community College of Aurora view top 100 |
institutionLevelId | institutionlevelid | number | Machine readable coded number 2=College or 4=University. Change from source: derived from the original database field InstitutionType. | 2 4 view top 100 |
institutionLevel | institutionlevel | text | Human readable column. Changes from source: colum created and populated from the original database field InstitutionType by mapping the number value to 2=College 4=University. | College University view top 100 |
institutionType | institutiontype | text | Indicates whether the university is public or private. Derived from the CDHE Colleges & Universities database. | Public view top 100 |
taxType | taxtype | text | Describes whether the institution is a non-profit or has another tax designation. Derived from the CDHE Colleges & Universities database. | Not-for-Profit view top 100 |
coBased | cobased | text | Describes whether the institution is a based in Colorado or is headquartered in a different state. Derived from the CDHE Colleges & Universities database. | Yes view top 100 |
division | division | text | Describes the agency aggregating the data. Derived from the CDHE Colleges & Universities database. | DHE view top 100 |
ageDesc | agedesc | text | The age range of sample. | Under 17 17-20 21-24 25-40 Over 40 view top 100 |
ageMin | agemin | number | Minimum age from the age description. Changes from source: derived by splitting the ageDesc field and taking the lower end of the value as the min value. 'Under' is set to null values as an unbounded range, treated as an empty value. | 17 21 25 40 view top 100 |
ageMax | agemax | number | Maximum age from the age description. Changes from source: derived by splitting the ageDesc field and taking the higher end of the value as the max value. 'Over' is set to null values as an unbounded range, and treated as an empty value. | 17 20 24 40 view top 100 |
gender | gender | text | Gender of student. Values are: Male, Female, Unknown. | Female Male Unknown view top 100 |
ethnicity | ethnicity | text | Ethnicity of student. Values are: Asian or Pacific Islander; Black, non-Hispanic; Hispanic; Native American or Alaskan Native; Non-Resident Alien; Unknown Ethnicity; White, non-Hispanic. | White, non-Hispanic Hispanic Native American or Alaskan Native Unknown Ethnicity Asian or Pacific Islander view top 100 |
studentLevel | studentlevel | text | Student level as either Undergraduate or Graduate. | Undergraduate Graduate view top 100 |
degreeLevel | degreelevel | text | Degree level of the student. Values are: Associate, Bachelor, Certificate, Doctoral, Masters, OtherGraduate, Professional, Specialist. | Certificate Associate Bachelor Masters Doctoral view top 100 |
residencyId | residencyid | number | Machine readable coded column denoting if student is in-state or out-of-state. Derived from splitting the number from residency value. 'in-state' : 1, 'out-of-state' :2, 'unclassified/unspecified' :3 | 1 2 3 view top 100 |
residency | residency | text | Human readable column derived from original residency retaining the text value. Values are: In-State, Out-Of-State, Unclassified. Changes from source: Values of Unclassified, Unknown have been changed to 'Unclassified' | In-State Out-of-State Unclassified/Unspecified view top 100 |
cip2 | cip2 | number | Classification of Instructional Programs two digit category code. Derived by splitting up CDHE Colleges & Universities database code into the cip standard format. | 51 20 24 43 48 view top 100 |
cip | cip | number | Classification of Instructional Programs 2010 code Derived by converting CDHE Colleges & Universities database number into the decimal format found on nces.ed.gov | 24.0101 52.0201 51.0904 51.3801 24.0102 view top 100 |
programName | programname | text | Description of the Classification of Instructional Programs code. Original values overwritten in transform with the 2010 CIP datafilehttp://nces.ed.gov | Liberal Arts and Sciences/Liberal Studies. General Studies. Business Administration and Management, General. Emergency Medical Technology/Technician (EMT Paramedic). Registered Nursing/Registered Nurse. view top 100 |
recordCount | recordcount | number | Record Count. Changes from source: Replaced all * values to null values so that the field type can be treated as an integer field for numerical queries. | 20 11 31 10 14 view top 100 |