Type 5: Degrees & Other Formal Awards Conferred
General Instructions
This file should include all degrees and formal awards conferred in the previously completed academic year. Each conferred degree or award must be reported as a separate record.
If a student receives multiple degrees during the reporting period, each degree should be reported individually—whether the degrees are:
- At the same level (e.g., a Bachelor of Arts in Chemistry and a Bachelor of Science in Computer Science, both are at the Bachelor level), or
- At different levels (e.g., an associate degree and a baccalaureate degree).
Each record must include the term in which the degree was conferred—fall, spring, or summer.
Applicable to:
- All Institutions
Do not report:
- Degrees or awards conferred in prior academic years, or
- Degrees or awards not yet completed, based on the institution’s academic policy.
For joint or collaborative degrees involving multiple institutions, reporting should reflect the degree-granting status of each participating institution.
For detailed definitions and data element descriptions, refer to Appendix: Degrees and Other Formal Awards Conferred – Terms and Definitions.
File Formats & Field Values
|
Start |
Width |
Header Title |
Type |
Definition |
|---|---|---|---|---|
|
1 |
1 |
Form (form) |
Alphabetic |
Indicates the collection file. Must be the first field in every detail record. Enter 5 for records. Cannot be blank. |
|
2 |
5 |
Date Conferred (date_conf) |
Numeric |
The academic semester being reported, expressed as a 4-digit year followed by a single-digit semester code (YYYY#). Semester Codes: 1 — Summer, 2 — Fall, 3 — Spring Example: 20252 = Fall 2025 |
|
7 |
8 |
Institution ID (fice) |
Numeric |
The institution’s 8-digit FICE code. Must include all leading or trailing 0s if applicable and cannot be blank. Refer to Table 1 for FICE codes. |
|
15 |
9 |
Social Security Number (ssn) |
Numeric |
The student's Social Security Number (SSN) or an alternate valid identification number. This field cannot be blank. Use the same identifier previously submitted for the student to ensure records remain linked across reporting terms. If an SSN is not available, report an alternate identifier such as the institutional student ID, SEVIS ID, or ITIN, and set ID_Type to "2" to indicate it is not a true SSN. If a valid SSN becomes available after a prior submission, notify CPE to update the student record. Each SSN must be unique within the submission; do not report the same SSN for multiple students. Valid entries must not:
|
|
24 |
1 |
ID Type (id_type) |
Numeric |
Indicates the type of identifier entered in Social Security Number Or other identification number column: 1 - Social Security Number (SSN) 2 - Alternate identifier (institutional ID, SEVIS ID, or ITIN) |
|
25 |
25 |
Last Name (last_name) |
Alphanumeric |
Enter the student's last name as it appears on official institutional records, used to maintain consistent student identification across reporting periods. Formatting Requirements:
Name Changes - If a student's last name changes (e.g., marriage, legal name change):
Consistent identification: Last name spelling should match prior submissions unless a legal name change occurred; mismatches may trigger student-matching errors in KPEDS. |
|
50 |
15 |
First Name (first_name) |
Alphanumeric |
Enter the student's first name as it appears on official institutional records. Formatting Requirements:
|
|
65 |
8 |
Date of Birth (birth_date) |
Date |
Report the student's date of birth using the format MMDDYYYY (e.g., 05152001 for May 15, 2001). Formatting Requirements:
Consistency Checks:
|
|
73 |
1 |
Gender (gender) |
Alphabetic |
Report the student's gender. F - Female M - Male |
|
74 |
1 |
Race/Ethnicity (race) |
Numeric |
Report the student's race and/or ethnicity following federal reporting guidelines, using the appropriate code from Table 2. |
|
75 |
1 |
Residency Status (residency) |
Alphabetic |
Indicate the student’s residence status for the reporting term. Use the appropriate code as defined in Table 3. |
|
76 |
2 |
State of Origin (origin_state) |
Numeric |
Report the 2-digit FIPS code for the student's state of origin, using the valid codes from Table 4 Formatting Requirements:
Related Reporting:
|
|
78 |
3 |
County of Origin (origin_county) |
Numeric |
Report the 2-digit FIPS code for the student's state of origin, using the valid codes from Table 4 Formatting Requirements:
Related Reporting:
If the out-of-state county is unavailable, report 000; the county will be determined from the reported ZIP code |
|
81 |
2 |
Reciprocity State (recip_state) |
Numeric |
For students with residency code B (reciprocity) as reported in Residency Status column, report the reciprocity state using the 2-digit FIPS state code. Refer to Table 5 for approved riprocity states/counties. |
|
83 |
3 |
Reciprocity County (recip_county) |
Numeric |
For students with residency code B (reciprocity) as reported in Residency Status column, residency status, the reciprocity county using the 3-digit FIPS county code. Refer to Table 5 for approved riprocity states/counties. |
|
86 |
2 |
Degree Level (level_degree) |
Alphabetic |
Each record must include a degree level code that corresponds to the credential awarded to the student. This code identifies whether the award is an associate, bachelor’s, graduate degree, diploma, or certificate, and the scope of credit hours completed. The degree level must match the program designation in your institution’s approved program inventory. |
|
88 |
15 |
Degree Conferred (degree_conferred) |
Alphabetic |
Report the specific degree being conferred; for example, BA, BS, AA, AAS. Degree codes must be consistent with degree designations in each institution’s program inventory. Left justify. |
|
103 |
8 |
Declared First Major Prefix (first_major_prefix) |
Alphabetic |
Report the appropriate major or program prefix code from the program inventory. Valid Values:
|
|
111 |
8 |
Declared Second Major Prefix (second_major_prefix) |
Alphabetic |
Report the appropriate major or program prefix code from the program inventory. See Declared First Major Prefix for guidelines. |
|
119 |
1 |
Multi-Institutional Program First Major (multi_inst_1) |
Alphabetic |
Indicates whether the student's first major is part of a joint or collaborative program involving resource sharing across multiple institutions. All participating institutions must share responsibility for program delivery, quality, enrollment, degree conferral, financial aid, student services, and general management. A formal agreement must be submitted to CPE for recognition on the CPE Registry of Degree Programs. Valid Values:
|
|
120 |
3 |
Earned Credit Hours at Time of Degree (earned_hrs) |
Alphanumeric |
Report the cumulative semester credit hours accepted from all prior institutions. Round decimals to the nearest whole number (below .50 rounds down). Valid Values:
|
|
123 |
10 |
Student’s Institutional ID (inst_id) |
Numeric |
The institution's unique identifier for the student. Do not include periods (.), apostrophes ('), hyphens (-), or underscores (_). |
|
133 |
1 |
Hispanic or Latino (hispanic) |
Alphabetic |
Indicates whether the student is of Hispanic or Latino origin. This includes persons of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. Y - Student is of Hispanic or Latino origin N - Student is not of Hispanic or Latino origin |
|
134 |
1 |
American Indian or Alaskan Native (am_indian) |
Alphabetic |
Indicates whether the student identifies as American Indian or Alaska Native. This includes persons having origins in any of the original peoples of North and South America (including Central America) who maintain tribal affiliation or community attachment. Y - Student identifies as American Indian or Alaska Native N - Student does not identify as American Indian or Alaska Native |
|
135 |
1 |
Asian (asian) |
Alphabetic |
Indicates whether the student identifies as Asian. This includes persons having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent (e.g., Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam). Y - Student identifies as Asian N - Student does not identify as Asian |
|
136 |
1 |
Black or African American (black) |
Alphabetic |
Indicates whether the student identifies as Black or African American. This includes persons having origins in any of the Black racial groups of Africa. Y - Student identifies as Black or African American N - Student does not identify as Black or African American |
|
137 |
1 |
Native Hawaiian or Other Pacific Islander (hawaiian) |
Alphabetic |
Indicates whether the student identifies as Native Hawaiian or Other Pacific Islander. This includes persons having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands. Y - Student identifies as Native Hawaiian or Other Pacific Islander N - Student does not identify as Native Hawaiian or Other Pacific Islander |
|
138 |
1 |
White (white) |
Alphabetic |
Indicates whether the student identifies as White. This includes persons having origins in any of the original peoples of Europe, the Middle East, or North Africa. Y - Student identifies as White N - Student does not identify as White |
|
139 |
1 |
Nonresident (nonresident) |
Alphabetic |
Indicates whether the student is a nonresident alien. This includes persons who are not citizens or nationals of the United States and who are in this country on a visa or temporary basis and do not have the right to remain indefinitely. Y - Student is a nonresident alien; do not report a racial or ethnic category for this student N - Student is not a nonresident alien |
|
140 |
1 |
Race and Ethnicity Unknown (race_unknown) |
Alphabetic |
Indicates whether the student declined to provide a racial or ethnic designation. Y - Student did not select a racial or ethnic category N - Student selected at least one racial or ethnic category |
|
141 |
1 |
Project Graduate (project_graduate) |
Alphabetic |
Indicates whether the student is enrolled in Project Graduate, a program supporting returning adults who are completing a previously unfinished degree. Y - Student is enrolled in Project Graduate N - Student is not enrolled in Project Graduate |
|
142 |
6 |
Academic Year (sem) |
Numeric |
The academic year being reported, expressed as two consecutive 4-digit years combined into a 6-digit value. Must fall between 2000 and the current year. Example: 202526 = Academic Year 2025–2026 |
|
148 |
15 |
Middle Name (middle_name) |
Alphanumeric |
The student's middle name. Left-justify. Cannot contain only spaces. Allowed characters: letters, spaces, periods (.), apostrophes ('), and hyphens (-). Leave blank if not applicable. |
|
163 |
5 |
Name Suffix (name_suffix) |
Alphanumeric |
The student's name suffix (e.g., Jr., II, III). A period may be included. Left-justify. Leave blank if not applicable. |
|
168 |
1 |
Military Relationship (military_relationship) |
Alphabetic |
The student's relationship to military service. Valid Values:
|
|
169 |
1 |
Tuition Waiver (tuition_waiver) |
Alphabetic |
Indicates whether the student received a tuition waiver based on foster care or adoption status, as governed by KRS 164.2847. This data is used for annual reporting to the Legislative Research Commission (LRC) by November 30. Y - Student received a tuition waiver due to foster care or adoption status N - Student did not receive a tuition waiver |
|
170 |
6 |
First Major Program ID (first_major_programid) |
Alphanumeric |
Report the First Major Program ID for the student’s declared major, matching the institution’s program inventory. Right-justify. If institutional policy does not allow the student to declare a major, use the undeclared prefix (U) and leave this field blank. For selective admissions or limited enrollment programs, report the Program ID of the declared major. |
|
176 |
6 |
Second Major Program ID (second_major_programid) |
Alphanumeric |
Report the second major program ID for the student’s second declared major, see First Major Program ID for guidelines. |
|
182 |
1 |
Teacher Prep (teacher_prep) |
Alphabetic |
Indicates whether the student is enrolled in a class meeting Education Professional Standards Board (EPSB) standards for teacher certification. Y - Class meets EPSB standards for teacher certification N - Class does not meet EPSB standards for teacher certification |
Metric Validations
Total Degree Awarded
Definition: Total count of all degrees awarded, based on Type 5 degree submissions.
Logic: Count every record in the Type 5 file, regardless of degree level or student flags.
SQL:
SELECT
metric_line_code = 'TOTAL_DEGREES', fice, inst_description, Metric_Value = COUNT(*)
FROM [Table]
GROUP BY inst_description, fice;
Baccalaureate Degrees in STEMH (Non-KCTCS Only)
Definition: Total number of baccalaureate degrees awarded where the student’s major is in a STEMH field.
Logic: Non-KCTCS institutions only (@inst != 'KCTCS') and Level_degree = 'B' and STEMH = 'Y'
STEMH Flag Logic:
STEMH = 'Y'
WHERE LEFT(a.major_1,2) IN ('14','26','27','40','51')
OR LEFT(a.major_2,2) IN ('14','26','27','40','51')
Metric SQL:
SELECT
metric_line_code = 'BAC_STEMH_DEGREES_SEC1_9B',
fice,
inst_description,
Metric_Value = COUNT(*)
FROM #TempDeg9B A
WHERE @inst != 'KCTCS'
AND Level_degree = 'B'
AND STEMH = 'Y'
GROUP BY inst_description, fice;
Graduate-Level Degrees (Non-KCTCS Only)
Definition:
Total number of degrees awarded at the graduate level.
Logic:
Non-KCTCS institutions only. Degree level is converted to "Graduate" using the following mapping:
- Graduate Levels = ('08', 'M', '10', 'S', '11', 'D', '12', 'P', 'O')
Metric SQL:
SELECT
metric_line_code = 'GRADUATE_DEGREE_TABLE’, fice, inst_description, Metric_Value = COUNT(*)
FROM #TempDeg9B A
WHERE @inst != 'KCTCS'
AND Level_degree = 'Graduate'
GROUP BY inst_description, fice;
STEMH Credentials Awarded (2-Year (KCCTS) Only)
Definition: Definition: Number of credentials awarded in STEMH fields at KCTCS institutions.
Logic: Only for @inst = 'KCTCS'. STEMH must be flagged as 'Y'.
Metric SQL:
SELECT
metric_line_code = 'STEMH_CRED_SEC2_9B',
fice,
inst_description,
Metric_Value = COUNT(*)
FROM #TempDeg9B A
WHERE @inst = 'KCTCS'
AND STEMH = 'Y'
GROUP BY inst_description, fice;
Underprepared Students (2-Year (KCCTS) Only)
Definition: Credentials awarded to students flagged as underprepared based on academic indicators.
Logic: Only for @inst = 'KCTCS'. Flag set based on entrance assessment or override:
- Underprepared:
CASE
WHEN b.Underprepared IS NULL THEN 'Prepared'
WHEN a.inst_id IN ('002018326', '002415562') THEN 'Excluded'
ELSE b.Underprepared
END
Metric SQL:
SELECT
metric_line_code = 'UNDERPREPARED_STUDENTS ',
fice,
inst_description,
Metric_Value = COUNT(*)
FROM #TEMP_DEGREE_TABLE A
WHERE @inst = 'KCTCS'
AND Underprepared = 'Y'
GROUP BY inst_description, fice;
Total Targeted Industry Credentials (2-Year (KCCTS) Only)
Definition: Credentials awarded in programs aligned with Kentucky's identified Targeted Industries.
Logic: Only for @inst = 'KCTCS'. Credential must have TargetedIndustry = 'Y'.
Metric SQL:
SELECT
metric_line_code = 'TARGETED_INDUSTRY_DEGREE', fice, inst_description, Metric_Value = COUNT(*)
FROM #TEMP_DEGREE_TABLE A
WHERE @inst = 'KCTCS'
AND TargetedIndustry = 'Y'
GROUP BY inst_description, fice;
Last Updated: 7/24/2026
