Finding 1160854 (2025-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2025-10-16
Audit: 370942
Organization: Texas Christian University (TX)

AI Summary

  • Core Issue: A student's withdrawal date was incorrectly reported to NSLDS due to a transcription error, impacting enrollment reporting accuracy.
  • Impacted Requirements: Compliance with 34 CFR 685.309, which mandates accurate enrollment reporting for federal programs.
  • Recommended Follow-Up: Implement controls to review batch reports before uploading to NSLDS to ensure timely and accurate reporting.

Finding Text

Federal program Federal Pell Grant Program AL #: 84.063 Award Year: 2024/2025 Type of finding Significant Deficiency and Noncompliance Compliance requirement Enrollment Reporting Criteria Under 34 CFR 685.309, Institutions are required to report enrollment information under the Pell grant and the Direct and FFEL loan programs via the NSLDS. Institutions must review, update, and certify student enrollment statuses, program information, and effective dates that appear on the Enrollment Reporting Roster file or on the Enrollment Maintenance page of the NSLDS Professional Access website which the financial aid administrator can access for the auditor. Condition We noted one out of forty judgmentally selected students the withdrawal date per PeopleSoft was accurate at 10/3/2024 and it was inaccurately reported as 10/30/2024 into NSLDS. The error was corrected by the Associate Director of Financial Aid Compliance (within NSLDS) and Assistant Registrar (within NSCH) when identified in June 2025. Questioned costs None Context The student’s withdrawal date was inaccurately reported to NSLDS due to human error. Cause When performing enrollment reporting for return of funds students, the Student Financial Aid office (SFA) uses a tracking worksheet to document critical data and ensure communication between SFA and the Registrar. When SFA transcribed information from the return of funds worksheet to the tracking worksheet, a 0 was inadvertently added from the withdrawal date of 10/3 to 10/30. Then, that tracking worksheet was used to perform NSLDS enrollment reporting, with the incorrectly transcribed date being entered into NSLDS. This error was caused by human error. Effect The student’s withdrawal date was listed correctly within the University’s system, therefore, there was no effect to the accuracy of aid distributed or return of funds. This is strictly an enrollment reporting error and as a result, the student’s Campus Level and Program Level screens within NSLDS were inaccurate. Repeat finding NoRecommendations We recommend that the University have controls in place to review the status change information included in the batch reports prior to uploading the data to NSLDS ensure that all required reporting is completed timely and accurately. View of responsible officials It was discovered that for one student a transcription error was made when transcribing the LDA (last date of attendance) from the student’s return of funds worksheet to SFA’s and Registrar’s enrollment tracking document of return of funds students. This student was an unofficial withdrawal at the end of the Fall 2024 semester. The Compliance Officer created a RT24 workflow tracking worksheet to identify enrollment reporting dates and ensure communication between SFA and the Registrar. This includes, but is not limited to, unofficial withdrawals with a LDA, all Fs with a LDA, and Q drops with an LDA. There may be other reasons there will be different enrollment dates, and those are also charted. The Compliance Officer will now run a query from PeopleSoft that pulls return of funds information directly from the PeopleSoft worksheet. This query will be imported into a tracking worksheet to ensure accurate enrollment reporting dates. This new tracking worksheet will remove the need for any additional manual updates to enrollment data tracking and reduce the possibility of future transcription errors.

Corrective Action Plan

It was discovered that for one student a transcription error was made when transcribing the LDA (last date of attendance) from the student’s return of funds worksheet to SFA’s and Registrar’s enrollment tracking document of return of funds students. This student was an unofficial withdrawal at the end of the Fall 2024 semester. The Compliance Officer created a RT24 workflow tracking worksheet to identify enrollment reporting dates and ensure communication between SFA and the Registrar. This includes, but is not limited to, unofficial withdrawals with a LDA, all Fs with a LDA, and Q drops with an LDA. There may be other reasons there will be different enrollment dates, and those are also charted. The Compliance Officer will now run a query from PeopleSoft that pulls return of funds information directly from the PeopleSoft worksheet. This query will be imported into a tracking worksheet to ensure accurate enrollment reporting dates. This new tracking worksheet will remove the need for any additional manual updates to enrollment data tracking and reduce the possibility of future transcription errors.

Categories

Student Financial Aid

Other Findings in this Audit

  • 1160853 2025-001
    Material Weakness Repeat
  • 1160855 2025-003
    Material Weakness Repeat
  • 1160856 2025-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $89.19M
84.063 Federal Pell Grant Program $13.66M
93.264 Nurse Faculty Loan Program (nflp) $4.22M
15.U15 Drug Abuse Programs Evaluation $2.64M
84.007 Federal Supplemental Educational Opportunity Grants $1.22M
84.038 Federal Perkins Loan Program_federal Capital Contributions $990,569
84.325 Special Education - Personnel Development to Improve Services and Results for Children with Disabilities $636,230
84.042 Trio Student Support Services $613,446
93.364 Nursing Student Loans $499,421
84.033 Federal Work-Study Program $396,903
84.217 Trio McNair Post-Baccalaureate Achievement $311,070
84.047 Trio Upward Bound $298,703
84.000 Cac_fafsa_stud Support Strategy $233,219
93.859 Biomedical Research and Research Training $211,875
47.049 Mathematical and Physical Sciences $192,290
15.U15 Anger Management Research $146,869
93.595 Welfare Reform Research, Evaluations and National Studies $120,452
93.286 Discovery and Applied Research for Technological Innovations to Improve Human Health $96,791
81.049 Office of Science Financial Assistance Program $91,242
10.215 Sustainable Agriculture Research and Education $75,762
93.279 Drug Use and Addiction Research Programs $60,609
84.425 Education Stabilization Fund $52,757
93.867 Vision Research $49,184
93.307 Minority Health and Health Disparities Research $36,519
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $27,176
93.865 Child Health and Human Development Extramural Research $22,631
84.379 Teachers Education Assistance for College and Higher Education Grants $18,860
12.RD Sensor Systems-Bioluminescence $12,689
93.969 Pphf Geriatric Education Centers $10,923
47.041 Engineering $10,000
93.855 Allergy and Infectious Diseases Research $8,930
93.173 Research Related to Deafness and Communication Disorders $8,685
10.310 Agriculture and Food Research Initiative (afri) $6,574
12.630 Basic, Applied, and Advanced Research in Science and Engineering $2,156
84.305 Education Research, Development and Dissemination $2,122
47.074 Biological Sciences $1,713
10.212 Small Business Innovation Research (sbir) Program / Small Business Technology Transfer (sttr) Program $1,662
45.129 Promotion of the Humanities Federal/state Partnership $1,555
47.076 Stem Education (formerly Education and Human Resources) $1,494
39.003 Donation of Federal Surplus Personal Property $322
12.900 Language Grant Program $150
43.RD National Aeronautics and Space Administration $140