Audit 328998

FY End
2024-06-30
Total Expended
$33.33M
Findings
2
Programs
18
Organization: Oklahoma City Community College (OK)
Year: 2024 Accepted: 2024-11-19

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
508381 2024-001 Significant Deficiency - M
1084823 2024-001 Significant Deficiency - M

Programs

Contacts

Name Title Type
CDQGFKMH7LY5 Cynthia Gary Auditee
4056821611 Jake Winkler Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts, if any, shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The expenditures are recorded upon the disbursement of funds that meet federal award requirements. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal awards activity of the Oklahoma City Community College (the “College”) under programs of the federal government for the year ended June 30, 2024. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of the College, it is not intended to and does not present the net position, changes in net position, or cash flows of the College.
Title: Summary of Significant Accounting Policies Accounting Policies: Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts, if any, shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The expenditures are recorded upon the disbursement of funds that meet federal award requirements. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts, if any, shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years.
Title: Indirect Cost Rate Accounting Policies: Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts, if any, shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The expenditures are recorded upon the disbursement of funds that meet federal award requirements. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The College has a Negotiated Indirect Cost Rate Agreement (the “Agreement”) issued by the U.S. Department of Health and Human Services issued as of August 2022. The negotiated rate of 46% was applied in accordance with the Agreement for the year ended June 30, 2024, except that certain grants limited the rate charged.
Title: Subrecipients Accounting Policies: Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts, if any, shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The expenditures are recorded upon the disbursement of funds that meet federal award requirements. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. During the year ended June 30, 2024, the College did not provide federal awards to subrecipients.
Title: Subsequent Events Accounting Policies: Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts, if any, shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The expenditures are recorded upon the disbursement of funds that meet federal award requirements. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The College has evaluated the effects of all subsequent events from June 30, 2024, through the date the SEFA was available to be issued, for potential recognition or disclosure in this SEFA. The College is not aware of any subsequent events which would require recognition or disclosure in the SEFA.
Title: Federal Direct Student Loan Program Accounting Policies: Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts, if any, shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The expenditures are recorded upon the disbursement of funds that meet federal award requirements. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. Under the Federal Direct Student Loan Program (“Direct Loan Program”), the U.S. Department of Education makes loans to enable a student or parent to pay the costs of the student’s attendance at a postsecondary school. The Direct Loan Program enables an eligible student or parent to obtain a loan to pay for the student’s cost of attendance directly from the U.S. Department of Education rather than through private lenders. The College administers the origination and disbursement of the loans to eligible students or parents. The College is not responsible for the collection of these loans.

Finding Details

Finding 2024-001 – Student Financial Aid Cluster Enrollment Reporting Questioned Costs: Unknown Criteria: Institutions are responsible for accurately reporting all campus-level record data elements. Specifically, an institution determines how often it receives the enrollment reporting roster file with the default set as a minimum of every 60 days. The institution must update for changes in the data elements for the campus record and the program records, submit the changes electronically through a batch method, spreadsheet submittal, or the National Student Loan Data System (NSLDS) website in accordance with Pell, 34 CFR 690.839(b)(2) and Direct Loan, 34 CFR 685.309. If errors are identified, institutions have 10 days to correct the errors and resubmit to NSLDS. Condition: The College alongside its software vendor, Ellucian, adjusted enrollment reporting to isolate the needed students for data pulls to upload to NSLDS as required for student financial aid. the College’s adjusted reporting query did not accurately capture the appropriate student enrollment records during fiscal year 2024. Cause and Effect: During the College’s decustomization meetings with Ellucian consultants in late Spring 2023, the College made an update to their Clearinghouse enrollment reporting process to incorporate a saved list of student records rather than running through all student records as previously done. This significantly reduced the time it took to process the enrollment reporting and was said to be more efficient for the College. During the annual audit of the Student Financial Aid award activity, the College realized that the new process caused some students enrollment to be missed when reporting for Fall 2023 and Spring 2024. 4.8% of students enrolled for Fall 2023 were impacted, totaling 534 students. 5.9% of all students enrolled for Spring 2024 were impacted, totaling 588 students. As a result, the College was not in compliance with the required enrollment reporting requirements in accordance with 24 CFR 690.839(b)(2) and 34 CFR 685.309. Recommendation: AA recommends that after any significant process update, the College should perform a postimplementation review to assess the performance of the updated process and check for unintended consequences. Additionally, AA would recommend improving communication and training to ensure that all personnel understand the new process and report any anomalies in a timely manner. Management Response: To ensure this issue is fully resolved moving forward, we have implemented a more rigorous internal process, including thorough testing and random sampling. We now compare reported enrollment data against actual student enrollment for each semester, allowing us to verify that all students are accurately reported. These enhanced measures will safeguard against similar oversights in the future.
Finding 2024-001 – Student Financial Aid Cluster Enrollment Reporting Questioned Costs: Unknown Criteria: Institutions are responsible for accurately reporting all campus-level record data elements. Specifically, an institution determines how often it receives the enrollment reporting roster file with the default set as a minimum of every 60 days. The institution must update for changes in the data elements for the campus record and the program records, submit the changes electronically through a batch method, spreadsheet submittal, or the National Student Loan Data System (NSLDS) website in accordance with Pell, 34 CFR 690.839(b)(2) and Direct Loan, 34 CFR 685.309. If errors are identified, institutions have 10 days to correct the errors and resubmit to NSLDS. Condition: The College alongside its software vendor, Ellucian, adjusted enrollment reporting to isolate the needed students for data pulls to upload to NSLDS as required for student financial aid. the College’s adjusted reporting query did not accurately capture the appropriate student enrollment records during fiscal year 2024. Cause and Effect: During the College’s decustomization meetings with Ellucian consultants in late Spring 2023, the College made an update to their Clearinghouse enrollment reporting process to incorporate a saved list of student records rather than running through all student records as previously done. This significantly reduced the time it took to process the enrollment reporting and was said to be more efficient for the College. During the annual audit of the Student Financial Aid award activity, the College realized that the new process caused some students enrollment to be missed when reporting for Fall 2023 and Spring 2024. 4.8% of students enrolled for Fall 2023 were impacted, totaling 534 students. 5.9% of all students enrolled for Spring 2024 were impacted, totaling 588 students. As a result, the College was not in compliance with the required enrollment reporting requirements in accordance with 24 CFR 690.839(b)(2) and 34 CFR 685.309. Recommendation: AA recommends that after any significant process update, the College should perform a postimplementation review to assess the performance of the updated process and check for unintended consequences. Additionally, AA would recommend improving communication and training to ensure that all personnel understand the new process and report any anomalies in a timely manner. Management Response: To ensure this issue is fully resolved moving forward, we have implemented a more rigorous internal process, including thorough testing and random sampling. We now compare reported enrollment data against actual student enrollment for each semester, allowing us to verify that all students are accurately reported. These enhanced measures will safeguard against similar oversights in the future.