Student Financial Aid (Type A)
General Instructions
The Student Financial Aid (Type A) file contains three categories of information:
- Student Identifying Information
- Free Application for Federal Student Aid (FAFSA) Data
- Details of Grants and Loans Received by the Student
Each institution must submit records for all undergraduate students who received financial aid from any source during the 2024-25 academic year. This includes students whose only financial aid was a tuition waiver.
Applicable to:
- Required for 4-year public & 2-year public
- Not Required for AIKCU Institutions
Data Submission Requirements:
- The data must cover the entire academic year, including Fall 2024, Spring 2025, and Summer 2025.
- Ensure complete records for all eligible students, with all required data fields filled.
- Follow the official data layout as specified in the reporting guidelines.
- Format financial aid fields correctly, rounding dollar amounts to the nearest whole number (no commas or decimals).
- Data must be consistent with institutional enrollment records, as it will be cross-checked with Type 1 enrollment records.
- Report only disbursed aid amounts, meaning funds must have been processed through the Bursar’s Office or a verified third-party billing system.
DATA ENTRY
- Dollar Amounts:
- Reported in a five-digit format (up to $99,999).
- Values must be rounded to the nearest dollar (e.g., $12,345.78 → 12346).
- Negative Values:
- Report negative numbers with a negative sign (no commas or decimals).
- Blank Fields:
- Ensure blank fields contain no spaces.
File Layout, Formats & Field Values
Type A |
||||
Start |
Width |
Header Title |
Type |
Definition |
1 |
1 |
Form - A |
Alphabetic |
Indicates the type of data record. Must be the first field in every detail record. Enter A for records. Cannot be blank |
2 |
8 |
Institution ID |
Numeric (8 digits) |
Your 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. |
10 |
9 |
Social Security Number |
Numeric |
Enter the student’s Social Security Number or another valid identification number. The number must not start with "9", contain all the same digit (e.g., 111111111), or be all zeros (e.g., 000000000). If an SSN is not available, enter the institutional ID, SEVIS, or ITIN. Do not leave this field blank. Use the same ID as previously submitted. If an SSN becomes available later, notify CPE to update the records. |
19 |
25 |
Last Name |
Alphanumeric |
Enter the student’s last name. The field cannot be blank or contain only spaces. Must be left justify. Allowed characters: letters, spaces, periods (.), apostrophes (’), and hyphens (-). Ensure accurate spelling and consistency with previously submitted records. |
44 |
15 |
First Name |
Alphanumeric |
Enter the student’s first name. See Student Last Name for formatting guidelines. |
59 |
5 |
Cost of Attendance |
Numeric |
Student’s most updated amount that was used for calculating student aid during the academic year, including the FAFSA/ISIR COA or one that has been adjusted by your institution. |
64 |
5 |
Blank |
Leave blank |
No data should be entered in this field. |
69 |
8 |
Blank |
Leave blank |
No data should be entered in this field. |
77 |
8 |
Blank |
Leave blank |
No data should be entered in this field. |
85 |
8 |
Blank |
Leave blank |
No data should be entered in this field. |
93 |
1 |
Student Dependency Status |
Alphabetic |
Student's dependency status as reported on the FAFSA (ISIR #6: Dependency Model) or first term of enrollment for the academic year if FAFSA is not available). Required if a valid and accepted FAFSA has been received for student. Valid codes: D = Dependent, I = Independent, X = Rejected dependent, Y = Rejected independent or blank for not available or unknown. |
94 |
1 |
Student Marital Status |
Numeric |
Student's Marital Status as reported on the accepted FAFSA (ISIR #40/FAFSA Student
Marital Status 3) |
95 |
2 |
State of Legal Residence |
Alphabetic |
Student's reported state of legal residences as reported on the FAFSA (ISIR #65/FAFSA: Student State of Legal Residence 14a). Valid two-letter code or could be blank. |
97 |
1 |
Grade Level in College |
Numeric |
Student's Grade Level in College 2024–25 as reported on the FAFSA (ISIR #41/FAFSA: Student College or Career School Plans 4a). Valid Codes: 1 = First Year (Freshman), 2 = Second Year (Sophomore), 3 = Other Undergraduate (Junior or Senior), 4 = College Graduate, Professional or Beyond (MBA, M.D., Ph.D., etc.) or or blank for not available or unknown. |
98 |
1 |
Blank |
Leave blank |
This field should be left blank. |
99 |
1 |
Blank |
Leave blank |
This field should be left blank. |
100 |
1 |
Blank |
Leave blank |
This field should be left blank. |
101 |
1 |
Blank |
Leave blank |
This field should be left blank. |
102 |
5 |
Pell Grants |
Numeric |
Total amount of federal Pell grants the student received during the academic year. Do not enter decimals. Round to the nearest integer. If the student did not receive a Pell grant, enter 0 |
107 |
5 |
Subsidized Stafford Loans |
Numeric |
Total amount of Subsidized Stafford Loans (FFEL or Direct) the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include direct parent PLUS loans, Perkins Loans or indirect loans. If the student did not receive any loans in this category, enter 0. |
112 |
5 |
Unsubsidized Stafford Loans |
Numeric |
Total amount of Unsubsidized Stafford Loans (FFEL or Direct) the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include direct parent PLUS loans, Perkins Loans or indirect loans. If the student did not receive any aid in this category, enter 0. |
117 |
5 |
PLUS Parent Loans |
Numeric |
Total amount of Parent PLUS loans the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
122 |
5 |
Perkins Loans |
Numeric |
Total amount of Perkins loans the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
127 |
5 |
Federal SEOG Grants |
Numeric |
Total amount of Federal Supplemental Educational Opportunity Grants (SEOG) the student received during the academic year. Do not enter decimals. Round to the nearest integer. If the student did not receive any aid in this category, enter 0. |
132 |
5 |
Federal Work Study |
Numeric |
Total amount of need-based federal work-study the student received during the academic year. Do not enter decimals. Round to the nearest integer. Include institutional matching funds and any amount the student reported as financial aid. If the student did not receive any aid in this category, enter 0. |
137 |
5 |
Robert Byrd Honors Scholarships |
Numeric |
Total amount of Robert Byrd Honors Scholarships the student received during the academic year. Do not enter decimals. Round to the nearest integer. Include institutional matching funds and any amount the student reported as financial aid. If the student did not receive any aid in this category, enter 0. |
142 |
5 |
Federal Health Professions Loans |
Numeric |
Total amount of Federal Health Professions Loans (Nursing, HPSL, Primary Care, Disadvantaged) the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
147 |
5 |
Federal Health Professional Disadvantaged Students Scholarships |
Numeric |
Total amount of Federal Health Professional Disadvantaged Students Scholarships the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
152 |
5 |
The National Science and Mathematics Access to Retain Talent Grant |
Numeric |
Total amount of The National Science and Mathematics Access to Retain Talent Grant (National SMART Grant) the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
157 |
5 |
Federal Academic Competitiveness Grant |
Numeric |
Total amount of Federal Academic Competitiveness Grant (ACG) the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
162 |
5 |
College Access Program Grants |
Numeric |
Total amount of College Access Program (CAP) Grants the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans if the student did not receive any aid in this category, enter 0. |
167 |
5 |
Kentucky Educational Excellence Scholarships |
Numeric |
Total amount of Kentucky Educational Excellence Scholarships (KEES) the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
172 |
5 |
Kentucky Tuition Grants |
Numeric |
Total amount of Kentucky Tuition Grants the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
177 |
5 |
Kentucky Teacher Awards |
Numeric |
Total amount of Kentucky Teacher Awards the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
182 |
5 |
Early Childhood Development Scholarships |
Numeric |
Total amount of Early Childhood Development Scholarships the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
187 |
5 |
Kentucky National Guard Tuition Award Program |
Numeric |
Total amount of Kentucky National Guard Tuition Award Program the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
192 |
5 |
Kentucky Minority Educator Recruitment and Retention Scholarships |
Numeric |
Total amount of Kentucky Minority Educator Recruitment and Retention Scholarships the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
197 |
5 |
KHEAA Work Study |
Numeric |
Total amount of KHEAA Work Study the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
202 |
5 |
Other State Grants |
Numeric |
Total amount of Other State Grants the student received during the academic year. Do not enter decimals. Round to the nearest integer. Do not include other loans. If the student did not receive any aid in this category, enter 0. |
207 |
5 |
Institutional Need-Based Grants and Scholarships |
Numeric |
Total amount of Institutional Need-Based Grants and Scholarships the student received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
212 |
5 |
Institutional Need/Non-Need-Based Grants and Scholarships |
Numeric |
Total amount of Institutional Need/Non-Need-Based Grants and Scholarships the student received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
217 |
5 |
Institutional Non-Need-Based Grants and Scholarships |
Numeric |
Total amount of Institutional Non-Need-Based Grants and Scholarships the student received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
222 |
5 |
Institutional Need-Based Loans |
Numeric |
Total amount of Institutional Need-Based Loans the student received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
227 |
5 |
Institutional Need/Non-Need-Based Loans |
Numeric |
Total amount of Institutional Need/Non-Need-Based Loans received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
232 |
5 |
Institutional Non-Need-Based Loans |
Numeric |
Total amount of Institutional Non-Need-Based Loans received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
237 |
5 |
Institutional Need-Based Work Study |
Numeric |
Total amount of Institutional Need-Based Work Study received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
242 |
5 |
Institutional Need/Non-Need-Based Work Study |
Numeric |
Total amount of Institutional Need/Non-Need-Based Work Study received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
247 |
5 |
Institutional Non-Need-Based Work Study |
Numeric |
Total amount of Institutional Non-Need-Based Work Study received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
252 |
5 |
Scholarships/Grants from Third Parties |
Numeric |
Total amount of Institutional Non-Need-Based Work Study received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
257 |
5 |
Employer Paid Tuition |
Numeric |
Total amount of Employer Paid Tuition, including tuition paid by third-party employers only, to the extent that the student financial aid office is aware of tuition paid by third party. Tuition waivers given to faculty/staff and their families should not be included here, but should be included in the Tuition Waivers field. If the student did not receive any aid in this category, enter 0. |
262 |
5 |
Tuition Waivers and Discounts |
Numeric |
Total amount of Tuition Waivers and Discounts received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
267 |
5 |
ROTC/Armed Forces Grants |
Numeric |
Total amount of ROTC/Armed Forces Grants received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
272 |
5 |
JTPA, Job Training, Vocational Rehabilitation |
Numeric |
Total amount of JTPA, Job Training, Vocational Rehabilitation received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
277 |
5 |
Bureau of Indian Affairs Grants |
Numeric |
Total amount of Bureau of Indian Affairs Grants received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
282 |
5 |
Scholarships/Grants from State Agencies Outside Kentucky |
Numeric |
Total amount of Scholarships/Grants from State Agencies Outside Kentucky received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
287 |
5 |
Other Loans |
Numeric |
Total amount of Other Loans (Private, Commercial, etc.) received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
292 |
5 |
Kentucky's Affordable Prepaid Tuition |
Numeric |
Total amount of Kentucky's Affordable Prepaid Tuition (KAPT). Do not enter decimals.
Round to the nearest integer. If the student did not receive any Kentucky's Affordable
Prepaid Tuition (KAPT), enter 0. |
297 |
5 |
Veteran's Benefits |
Numeric |
Total amount of Veteran's Benefits received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
302 |
5 |
Ky Coal County College Completion Scholarship |
Numeric |
Total aid disbursed to student through this target- ed scholarship program for juniors
and seniors from a nine-county region in eastern Kentucky. |
307 |
6 |
Academic Year |
Numeric |
Must be 2 consecutive years between 2000 and today. Example: 202425 |
313 |
15 |
Middle Name |
Alphanumeric |
Enter the student’s middle name. Must be left justify. Allowed characters: letters, spaces, periods (.), apostrophes (’), and hyphens (-). |
328 |
5 |
Name Suffix |
Alphanumeric |
Enter the student’s name suffix (e.g., Jr., II, III). A period may be included. Can be blank and must be left justify. |
333 |
10 |
Student’s Institutional ID |
Numeric |
Your institution’s unique ID for the student. Required if SSN is blank. Do not include periods (.), apostrophes (’), hyphens (-), or underscores (_). |
343 |
5 |
Dual Credit Scholarship |
Numeric |
Total amount of Dual Credit Scholarship received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
348 |
5 |
KY Work Ready Scholarship |
Numeric |
Total amount of KY Work Ready Scholarship received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
353 |
1 |
Student Housing Flag |
Alphabetic |
Student is living in housing provided by the Re- port “Y” for Yes if a student is charged (to live in an institution’s housing program) for any term during the aid year. |
354 |
5 |
Student Campus Housing Annual Charge |
Numeric |
If Student Housing = Y then enter the student's Room costs charged to the student for all terms attended during the academic year. Do not enter decimals. Round to the nearest integer. If exact amounts are not available, enter estimates. If no charges, enter 0. |
359 |
5 |
Annual Lab and Course Fees |
Numeric |
Cost of Lab and Course Fees charged to the student for all terms attended during the academic year. Do not enter decimals. Round to the nearest integer. If exact amounts are not available, enter estimates. If no charges, enter 0. |
364 |
5 |
Annual Meal Charges |
Numeric |
Cost of Meals charged to the student for all terms attended during the academic year. Do not enter decimals. Round to the nearest integer. If exact amounts are not available, enter estimates. If no charges, enter 0. |
369 |
5 |
Annual Tuition Charged |
Numeric |
Actual tuition and fees your institution charged the student prior to financial aid being applied for all terms attended in the academic year. Do not enter decimals. Round to the nearest integer. If no tuition was charged, enter 0. |
374 |
5 |
Annual Comprehensive Fees |
Numeric |
Cost of Comprehensive Fees (Fees not charged per course (ex. technology, student activities, orientation) charged to the student for all terms attended during the academic year. Do not enter decimals. Round to the nearest integer. If exact amounts are not available, enter estimates. If no charges, enter 0. |
379 |
5 |
Federal Grant Other |
Numeric |
Total amount of all other federal grants and awards (specifically used for the funds dispersed from the Cares Act/HEERF funds or any other emergency grant funds dispersed by the federal government to students.) the student received during the academic year. Do not enter decimals. Round to the nearest integer. If the student did not receive any other federal grants, enter 0. |
384 |
5 |
Innovative Scholarship |
Numeric |
Total amount of Innovative Scholarship (Displaced Students) received during the academic year. Do not enter decimals. Round to the nearest integer. Include individual departments grants and institution matching funds. If the student did not receive any aid in this category, enter 0. |
389 |
5 |
Student Aid Index |
Numeric |
This field is for the student’s primary SIA and should reflect the student’s most updated amount that was used for calculating student aid during the academic year including the FAFSA/ ISIR SIA or one that has been adjusted by your institution. If a student’s SIA is “None Calculated,” report this under the dependency code, as on the Because zero (0) is a valid value in this field, do not use zero (0) for missing Leave missing values blank Valid entry range -1500 to 999999 |
394 |
1 |
Either Parent Attend College |
Numeric |
Based on the Either Parent Attend College Question in the student's (FAFSA (Parent Education Status #15 or ISIR Field # 67). Valid Codes: 1 = Neither parent attended college, 2 = One or both parents attended college, but neither parent completed college, 3 = One or both parents completed college, 4 = Don’t know or blank for not available or unknown. |
395 |
1 |
FAFSA Does the Student have Dependents |
Numeric |
Student's dependents question as reported on the FAFSA (ISIR #46: Child or Other Dependents?/FAFSA #5c). Required if a valid and accepted FAFSA has been received for student. Valid codes: 1=Yes or blank for not available or unknown. |
Metric Validations
Total Degree awarded to Low-Income students
Definition: The number of degrees or credentials awarded to low-income students. Applies to both four-year institutions and KCTCS, with separate metric line codes.
Low-Income Definition: Students are identified as low-income if they received a Pell Grant (Type A.pell_grants > 0).
Logic:
- For non-KCTCS institutions: Includes only baccalaureate degrees awarded to low-income students.
- For KCTCS institutions: Includes all credentials awarded to low-income students.
Metric SQL:
-- Non-KCTCS: Baccalaureate Degrees Only
SELECT
metric_line_code = 'BAC_LI_DEGREES_SEC1_LI_9B',
fice,
inst_description,
Metric_Value = COUNT(*)
FROM #TempDeg9B_LI A
WHERE @inst != 'KCTCS'
AND Degree_Level = 'B'
AND LowIncome = 'Y'
GROUP BY inst_description, fice;
-- KCTCS: All Credentials
SELECT
metric_line_code = 'LI_CRED_SEC2_LI_9B',
fice,
inst_description,
Metric_Value = COUNT(*)
FROM #TempDeg9B_LI A
WHERE @inst = 'KCTCS'
AND LowIncome = 'Y'
GROUP BY inst_description, fice;
First to Second Year Retention Rates of Low-Income students
Definition: The percentage of low-income students (identified by Pell Grant receipt) in their first year who were retained to the second year.
Low-Income Definition: WHEN Type A.pell_grants > 0 THEN LowIncome = 'Y'
Logic:
- Only students flagged as low-income are included.
- Retention is defined by continued enrollment or credential completion as specified in retention metric logic.
- Validated using the Type A Financial Aid submission.
Metric SQL:
SELECT
metric_line_code = 'FIRST_TO_SECOND_YR_RETENTION_LI_6C',
fice,
inst_description,
Cohort_Count = SUM(CASE WHEN low_income = 'Y' THEN 1 ELSE 0 END),
LI_Retained_Count = SUM(CASE WHEN Retained = 'Y' AND low_income = 'Y' THEN 1 ELSE 0 END)
FROM #Cohort_Retain
GROUP BY fice, inst_description;
Overall Average Unmet Need
Definition: The average dollar amount of unmet financial need (Cost of Attendance minus all aid) for students with a valid FAFSA record and a cost of attendance greater than zero.
Eligibility Logic:
- cost_of_attendance > 0
- dependency_status NOT IN ('X', 'Y', '')
- One valid financial aid record per student
Unmet Need Formula:
Unmet_Need = (cost_of_attendance - inst_need_grants - inst_nonneed_grants - inst_need_nonneed_work - inst_need_work - inst_nonneed_work - inst_need_nonneed_grants - tuition_waivers - pell_grants - fed_seog_grants - fed_work_study - byrd_scholarship - nat_smart_grant - fed_acad_comp_grant - cap_grant - kees - ky_tuition_grants - ky_teach_awards - early_child_dev_scholar - ky_minority_scholar - kheaa_work_study - other_state_grants - ky_coal_county_scholar Work_Ready_Scholar - scholar_third_party - employer_paid_tuition - state_agency_outside_ky - fed_hlth_prof_disadvantaged - kapt - bia_grants – jtpa - rotc_grants - ky_nat_guard_tuition - veterans_benefits- StudentAid_Index)
Metric SQL:
SELECT
'UNMET_NEEDS_1AA' AS metric_type_code,
'UNMET_NEEDS_1AA' AS metric_line_code,
fice,
inst_description,
AVG(Unmet_Need) AS Metric_Value,
SUM(Unmet_Need) AS numerator_value,
COUNT(*) AS denominator_value
GROUP BY fice, inst_description;
Last Updated: 6/17/2025