Desert Community College District Extraordinary Audit November 28, 2012 Joel D. Montero Chief Executive Officer FISCAL CRISIS MANAGEMENT ASSISTANCE TEAM November 28, 2012 Frederick Harris, Assistant Vice Chancellor & Project Monitor California Community College Chancellor's Office 1102 Q Street, 4th Floor Sacramento, CA. 95811-6549 Dear Assistant Vice Chancellor Harris: On July 25, 2012 the Fiscal Crisis and Management Assistance Team (FCMAT) entered into an agreement with the California Community College Chancellor's Office to provide a review in accordance with Education Code Section 84041(a) and (c) (1)(2). Specifically, the agreement states that FCMAT will perform the following: The California Community Colleges Chancellor's Office is requesting that the FCMAT Team conduct a review of the Desert Community College District's (DCCD), attendance accounting policies and procedures including the internal control structure to determine if fraud, misappropriation of funds or other illegal activities may have occurred in reporting apportionment attendance. The review shall be conducted in accordance with Education Code Sections 84501, 84752, Title 5, ? 58000 et seq. and the state Budget and Accounting Manual for Student Attendance Accounting Manual rules and regulations in computing full-time equivalent students (FTES). In accordance with Education Code section 84041 (a) and (c) (1) (2) the DCCD may request the FCMAT Team to assist the college to establish and maintain sound financial and budgetary conditions that comply with principles of sound fiscal management. The scope of work and review of attendance accounting procedures for full-time equivalent student (FTES) shall include forms prepared by the Chancellor's Office for State Apportionment Reports including CCFS-320 CCFS-321, CCFS- 320F Addendum to Part I, Supplemental Information CDCP Noncredit FTES and any supporting work papers or electronic files. The review shall include findings and recommendations to determine if the DCCD inappropriately claimed state apportionment funds utilizing catalog hours rather than actual or scheduled hours; and if any issues of fraud, misappropriation of funds or other illegal activities occurred during the reporting period. The primary focus of this review is to provide the Community College Chancellor's Office with reasonable assurances based on the testing performed that adequate management controls are in place regarding the district's attendance reporting and monitoring and that fraud, misappropriation of funds or other illegal activities have not occurred. Management controls include the processes for planning, organizing, directing, and controlling program operations, including systems for measuring, reporting, and monitoring performance. FCMAT Joel D. Montero, Chief Executive Officer 1300 17th Street - CITY CENTRE, Bakersfield, CA 93301-4533 Telephone 661-636-4611 Fax 661-636-4647 422 Petaluma Blvd North, Suite. C, Petaluma, CA 94952 Telephone: 707-775-2850 Fax: 707-775-2854 www.fcmat.org . . . . Administrative Agent: Christine L. Frazier - Office of Kern County Superintendent of Schools . Specific audit objectives will include evaluating the policies, procedures, and internal controls and transactions performed by the district related to the following: o The FCMAT Team will sample test data from the 2003-04 to 2009-10 fiscal years. Testing associated with this review will be based upon sample selection and will not include the testing of the complete list of all transactions and records for this period. Sample testing and review results are intended to provide reasonable, but not absolute assurance as to the accuracy of the district's transactions and financial activity. The college's attendance accounting has been previously reviewed and recalculated with the appropriate amount of FTES that should have been claimed for a 7 year period from 2003-04 to 2009-10 by independent auditors. The 2003-04 fiscal year was the initial year of conversion and implementation to the Datatel ERP system. Independent auditors have reviewed, corrected and validated the new calculations, which demonstrate that the district over-reported FTES for apportionment funding for 3 of the 7 years, and under-reported the remaining 4 years and this component is not part of the study agreement. This report includes the study team's findings and recommendations. FCMAT appreciates the opportunity to serve you and extend our thanks to all the staff of the Desert Community College District in conjunction with the California Community Colleges Chancellor's Office for their assistance during fieldwork. Sincerely, Joel D. Montero Chief Executive Officer T A B L E O F C O ND R N T S TEAFT Table of contents About FCMAT.......................................................................................... iii Introduction............................................................................................. 1 Background.............................................................................................. 5 Scope and Procedures.......................................................................... 7 Findings and Recommendations...................................................... 9 Occupational Fraud........................................................................................ 9 Chronology of Events.................................................................................. 11 Potential Fraudulent Activities................................................................. 15 Concealment of Material Facts................................................................. 17 Materiality of Reported FTES.................................................................... 21 Management's Fiduciary Duties..............................................................23 Recommendations.......................................................................................25 Appendices.............................................................................................27 Desert Community College D istrict i cw FISCAL CRISIS MANAGEMENT ASSISTANCE TEAM A B O U T F C M AT About FCMAT FCMAT's primary mission is to assist California's local K-14 educational agencies to identify, prevent, and resolve financial and data management challenges. FCMAT provides fiscal and data management assistance, professional development training, product development and other related school business and data services. FCMAT's fiscal and management assistance services are used not just to help avert fiscal crisis, but to promote sound financial practices and efficient operations. FCMAT's data management services are used to help local educational agencies (LEAs) meet state reporting responsibilities, improve data quality, and share information. FCMAT may be requested to provide fiscal crisis or management assistance by a school district, charter school, community college, county office of education, the state Superintendent of Public Instruction, or the Legislature. When a request or assignment is received, FCMAT assembles a study team that works closely with the local education agency to define the scope of work, conduct on-site fieldwork and provide a written report with findings and recommendations to help resolve issues, overcome challenges and plan for the future. Studies by Fiscal Year 90 80 Number of Studies 70 60 50 40 30 20 10 0 92/93 93/94 94/95 95/96 96/97 97/98 98/99 99/00 00/01 01/02 02/03 03/04 04/05 05/06 06/07 07/08 08/09 09/10 10/11 11/12 FCMAT also develops and provides numerous publications, software tools, workshops and professional development opportunities to help local educational agencies operate more effectively and fulfill their fiscal oversight and data management responsibilities. The California School Information Services (CSIS) arm of FCMAT assists the California Department of Education with the implementation of the California Longitudinal Pupil Achievement Data System (CALPADS) and also maintains DataGate, the FCMAT/CSIS software LEAs use for CSIS services. FCMAT was created by Assembly Bill 1200 in 1992 to assist LEAs to meet and sustain their financial obligations. Assembly Bill 107 in 1997 charged FCMAT with responsibility for CSIS and its statewide data management work. Assembly Bill 1115 in 1999 codified CSIS' mission. AB 1200 is also a statewide plan for county office of education and school districts to work together locally to improve fiscal procedures and accountability standards. Assembly Bill 2756 (2004) provides specific responsibilities to FCMAT with regard to districts that have received emergency state loans. In January 2006, SB 430 (charter schools) and AB 1366 (community colleges) became law and expanded FCMAT's services to those types of LEAs. Desert Community College D istrict iii iv A B O U T F C M AT Since 1992, FCMAT has been engaged to perform nearly 850 reviews for LEAs, including school districts, county offices of education, charter schools and community colleges. The Kern County Superintendent of Schools is the administrative agent for FCMAT. The team is led by Joel D. Montero, Chief Executive Officer, with funding derived through appropriations in the state budget and a modest fee schedule for charges to requesting agencies. Fiscal Crisis & Management Assistance Team INTRODUCTION Introduction In July 2012, the Fiscal Crisis and Management Assistance T eam (FCMAT) received a request from the California Community College Chancellor's Office to determine whether the Desert Community College District inappropriately claimed state apportionment funds. The FCMAT study team reviewed attendance reports that reported attendance using catalog hours instead of actual student contact hours as required by Education Code 84501 regulations adopted by the Board of Governors of the California Community Colleges. The California Community College Chancellor's Office had received numerous allegations of fiscal irregularities related to the recording and reporting of student attendance that intention- ally inflated funding from state apportionment that relied on the certified attendance reports. Concerned that these allegations may have violated various Education Code sections and California Code of Regulations (CCR) related to fraud and/or misappropriation of assets, the Chancellor's Office initiated an investigation to determine whether sufficient evidence of fraudulent activity exists to report the matter to the local district attorney's office for further investigation. Under the provisions of Education Code (EC) ? 84041, the Fiscal Crisis and Management Assistance T eam (FCMAT) entered into a contract with the Chancellor's Office to conduct a review in accordance with EC ?84501, 84752 and title 5 ? 58000 et seq. FCMAT interviewed current and former employees; the college's independent attendance consultant; and reviewed documents to determine if instances of fraud, misappropriation of funds or other illegal practices may have occurred that would warrant further investigation by the local district attorney's office. Study Guidelines FCMAT provides a variety of services to community colleges, school districts, charter schools and county offices of education upon request. Education Code Section 84041 (a) and (c) (1) (2) permits the Chancellor's Office to assist a community college district to establish or maintain sound financial and budgetary conditions and to comply with principles of sound fiscal management. The board of governors may request that FCMAT assist a community college district with an audit of the financial conditions of the district, provide management or fiscal crisis intervention, or both. The FCMAT study team focused on specific allegations of fiscal mismanagement that district employees are alleged to have knowingly committed a wrongful act, misrepresented and concealed material facts from the Chancellor's Office by intentionally misreporting student attendance. Audit Fieldwork The goal of a fraud examination is to resolve specific allegations, determine whether fraud has, or continues to occur, and to determine who is responsible. The fieldwork conducted for the College of the Desert focused on determining whether there is information to support or refute fraud pertaining to the allegation of intentional misreporting of full time equivalent Student (FTES) attendance information to the Chancellor's Office over a seven-year period of time. Desert Community College D istrict 1 2 INTRODUCTION Investigating allegations of fraud requires a number of steps that include examination of both internal and external third party documentation and interviews with staff members, former staff members and potential witnesses. The FCMAT study team visited the Desert Community College District in July and August of 2012 to conduct interviews, collect data and review documents. Specifically, FCMAT reviewed, analyzed and tested records that included audited financial records; an agreed-upon procedures report prepared by independent auditors; (FTES) attendance reports (CCFS 320); district email correspondence; internal records including meeting minutes, board minutes and other documentation from independent third party sources. Interviews were conducted with the college president, former president, vice presidents, senior administrative staff, management personnel, business office staff, information technology staff, the consultant that assisted with attendance report preparation on behalf of the district, and former community college employees. The purpose of the interviews was to evaluate information concerning the alleged mismanagement and fraudulent submittal of attendance reports. The fieldwork focused on determining whether there is sufficient information to ascertain fraud pertaining to the allegation of intentional over reporting of FTES attendance information. Fraud is defined in the California Civil Code at section 3294, (3) as, "... an intentional misrepresentation, deceit, or concealment of a material fact known to the defendant with the intention on the part of the defendant of thereby depriving a person of property or legal rights or otherwise causing injury." All fraud has common elements including the following: o Intent - knowingly committing a wrongful act, o Misrepresentation - or disguise of purpose to accomplish the act, o Reliance - on weaknesses in the internal control structure, and o Concealment - of the offense or material facts. This report is the result of that investigation and is divided into the following sections. I. Introduction II. Background III. Scope and Procedures IV Findings and Recommendations . o Occupational Fraud o Chronology of Events o Potential Fraudulent Activities o Concealment of Material Facts o Materiality of Reported FTES o Management's Fiduciary Duty o Recommendations V Appendices . Fiscal Crisis & Management Assistance Team INTRODUCTION Study Team The FCMAT study team was composed of the following members: Deborah Deal, CFE Michael Ammermon, CPA, CFE FCMAT Fiscal Intervention Specialist FCMAT Consultant Los Angeles, CA Laguna Niguel, CA Leonel Mart?nez Reagan F Romali, Ph.D. . FCMAT T echnical Writer FCMAT Consultant Bakersfield, CA Chicago, IL Desert Community College D istrict 3 n~mooucn FISCAL CRISIS MANAGEMENT ASSISTANCE TEAM BACKGROUND Background In spring and summer 2011, the California Community College Chancellor's Office was alerted that the Desert Community College District may have misreported attendance beginning in 2003-04 when the college converted to a new software reporting system. An informant notified the Chancellor's Office that the district was inaccurately reporting full-time equivalent students (FTES) attendance for purposes of apportionment revenue based on catalog hours instead of actual student contact hours and furthermore, that district administrators were aware of the misreporting of FTES. It was alleged that administrators had intentionally submitted false reports and failed to correct or properly report the misreported FTES to the Chancellor's Office as required under title 5, 58134 and 59116. The California community college website has extensive resources available, including a Student Attendance Accounting Manual, 2001 Edition (SAAM), and related fiscal advisories that provide a complete set of statutory and regulatory guidelines for the proper reporting of student workload measurements for apportionment funding. Full-Time Equivalent Student (FTES) Attendance Accounting and legal references can be accessed at the following Web address: http://extranet.cccco.edu/Divisions/FinanceFacilities/FiscalServicesUnit/ StudentAttendanceAccountingManual.aspx#Concurrent_Enrollment California community colleges receive more than 80% of their unrestricted funding from state apportionment paid through the Chancellor's Office and funding is primarily driven by the FTES workload measure. FTES is not a "head count," but is the equivalent of 525 hours of student instruction per each FTES. Per title 5,? 58003.1, the FTES are computed under four different attendance accounting formulas: positive attendance (actual attendance generated from each class meeting), weekly census, daily census, and the alternative attendance accounting procedure for independent study/work experience education and distance education courses not computed using other basic procedures. Each method of attendance accounting ultimately calculates to a number of FTES (workload in contact hours) based on the number of students enrolled, the length of the course, and divided by 525. Per title 5?, 58003.1(a), the determination of which attendance accounting procedure to apply is based on the type of course (credit, noncredit, independent study, etc.), the way the course is scheduled, and the length of the course. The major number of FTES reported by the community college districts are generated in weekly census procedure courses that are scheduled in the primary term either quarter or semester depending on the academic calendar configuration of the college. Courses that are scheduled as "weekly census" must be scheduled the same number of hours each week of the primary term. The primary terms usually equate to 35 weeks, but in some instances, there are more or fewer weeks than 35. Funding for census-based courses is based on students who are determined to be actively enrolled as of "census day," which is Monday of the week nearest to one-fifth of the length of the primary terms (i.e., the third or fourth week depending on the length of the primary term). Education Code, 84501 and California Code of Regulations title 5?, 58003.1, 58004, 58006, 58012, 58020, and 58023 govern how apportionment funding is calculated for daily and weekly student attendance. To calculate FTES under the weekly census procedure, the number of actively enrolled students in each course are multiplied by the number of weekly scheduled hours as of the census day, then multiplied by a term length multiplier (TLM) of 17.5 (The TLM could be higher if the acacemic year has been compressed) and divided by 525. This calculation is made for all weekly census courses for each primary term. Desert Community College D istrict 5 6 BACKGROUND In September 2008, the Chancellor's Office issued an addendum to the SAAM. This addendum specifically addressed the topic of attendance reporting. Chapter 3 of the manual provided several examples of how to properly calculate student attendance hours. Further guidance is provided in the Community Colleges Apportionment Attendance Report (form CCFS-320.) Per title 5?, 58003.4, FTES is required to be reported by community colleges three times per year using form CCFS-320. The CCFS-320 attendance report is signed and certified by the district superintendent/president that the information presented in the report is true and correct and is submitted three separate times each fiscal year as follows: o First Period - July 1 through December 31, o Second Period - July 1 through April 15, and o Annual - July 1 through June 30. As part of the regular reporting process for each fiscal year, districts can make adjustments/corrections to their "Annual" CCFS-320 reports up to November 1 of the subsequent fiscal year. This is known as the "Recal" CCFS-320 report and represents a possible fourth submission. In addition to the regular submission of CCFS-320 reports as noted above, title 5 Section 59116 requires districts to promptly resolve inaccuracies in attendance accounting and reporting that are identified subsequent to the submission of the final CCFS-320 report submitted by district for a particular fiscal year (Annual or Recal). Districts are to inform the Chancellor's Office of these inaccuracies through a declaration of discrepancy notification pursuant to title 5 Section 59116. The CCFS-320 report converts the student attendance contact hours based on the attendance accounting procedure designation into FTES. The FTES are then converted through a funding formula provided by the Legislature to the Chancellor's Office to apportionment dollars, which is how the college receives funding for the students the college serves. If a college incorrectly accounts for student contact hours attending classes using a method that is not permissible for calculating FTES, the institution may receive more or less funding than what was actually earned. Consistent with the above noted title 5 regulations, the Chancellor's Office has established that catalog hours are not an acceptable method for calculating California community college FTES apportionment funding for specific designated classes. Except for courses required to be on the Alternative Attendance Accounting Procedure, the contact hours that form the basis of an FTES must be appropriately calculated from scheduled or actual meeting times as applicable for the particular course and the attendance accounting procedures that is applied. Catalog hours are the course hours that a student may take as shown in a college's course catalog that lists all of the classes or courses a community college offers. The hours indicated for a course shown in the catalog is an estimate of how many hours the course will require. However, many times scheduling patterns for sections of the course may have different actual instructional time calculated than what is listed in the catalog for a particular course and must be reported appropriately using scheduled or actual hours and established contact hour computation rules (see title 5?, 58023). If a college reports catalog hours instead of actual hours by mistake or on purpose, the FTES reported by the college to the Chancellor's Office will be incorrect and therefore, the apportionment funding received will be inaccurate. Fiscal Crisis & Management Assistance Team SCOPE AND PROCEDURES Scope and Procedures The fraud investigation consisted of gathering adequate information regarding specific allegations, establishing an audit plan, and performing various audit tests procedures to determine whether fraud may have occurred, who was involved and how it may have occurred. During the interviews, FCMAT study team members asked questions pertaining to levels of authority, financial management policies and procedures, job duties and responsibilities, and issues related specifically to when the district staff knew that FTES attendance reporting had not been accurately reported to the Chancellor's Office for the 2003-04 through the 2009-10 fiscal years. FCMAT conducted interviews, examined district email communications, reviewed auditor's management representation letters, and reviewed the independent auditors agreed-upon procedures report specific to the overstatement of FTES to determine if fraud or other illegal activities may have occurred. The examination of district emails and interviews associated with this study is based on sample selection and does not include examining all district emails or interviewing all district staff members for the study period. The primary focus of this review is to determine if illegal activities involving fraud, misappropriation of funds may have occurred and if there are adequate management controls to prevent illegal activity in the future. The review will also examine current management controls regarding the district reporting of student attendance to provide the Chancellor's Office with reasonable assurance that the appropriate controls are in place. Management controls include the processes for planning, organizing, directing, and controlling program operations, including systems for measuring, reporting, and monitoring performance. T esting for this review is based on sample selection and does not include the testing of the complete list of all transactions and records for this period. Sample testing and review results are intended to provide reasonable, but not absolute assurance as to the accuracy of the district's transactions and financial activity. T accomplish the objectives of this audit, a number of audit test procedures were developed to o provide an in-depth analysis and understanding of the allegations and potential outcomes. The team had access to internal and external information that included the following: o Audited financial statements. o Review the governing board minutes. o The independent accountants' report on applying agreed-upon procedures. o Access to the district emails and internal documents from 2001 to 2012. o Employee severance agreements. The following findings and recommendations are the result of the audit procedures and review performed. Desert Community College D istrict 7 scope FISCAL CRISIS MANAGEMENT ASSISTANCE TEAM O C C U PAT I O N A L F R A U D Findings and Recommendations Occupational Fraud The owners, executives, managers or employees of an organization may commit occupational fraud, which has three primary classifications: 1. Asset misappropriation fraud - Includes cash skimming, falsifying expense reports and/or forging company checks. 2. Corruption fraud - Involves an employee(s) using his or her influence in business transactions to obtain a personal benefit that violates that employee's duty to the employer or the organization; conflicts of interest fall into this category. 3. Financial statements fraud - Includes the intentional misstatement or omission of material information in the financial reports. Occupational fraud is one of the most difficult types of fraud and abuse to detect; however, the most common method of detection is receiving tips, which accounts for three times the number of incidents of fraud detection compared to any other method for this type of scheme It is estimated that financial statement fraud represents approximately 10% of all occupational frauds worldwide according to the Association of Certified Fraud Examiner's (ACFE) "2010 Report to the Nations" but the median loss is substantially larger than other occupational frauds. Of the 1,843 reported cases studied by the ACFE, fraudulent financial statements comprised 4.8% overall. Financial statement fraud is characterized as a deliberate misrepresentation designed to deceive the users of financial statements. It is further defined as "the intentional misstatement or omission of material information in the organizations' financial report" according to ACFE. Manipulation of fictitious revenues is one common fraud scheme associated with financial statement fraud. Extensive research based on reported cases of financial fraud show a direct correlation between the perpetrator's position and authority in the organization and the losses incurred. Owners and/ or executives losses are three times higher than those from managers and nine times higher that losses incurred by the employees within the organization. Internal Control Elements Internal controls are the principal mechanism for preventing and/or deterring fraud or illegal acts. Illegal acts, misappropriation of assets or other fraudulent activities can include an array of irregularities characterized by intentional deception and misrepresentation of material facts. Effective internal control processes provide reasonable assurance that a district's operations are effective and efficient, that the financial information produced is reliable, and that the organization operates in compliance with all applicable laws and regulations. Internal control elements provide the framework for an effective fraud prevention program. An effective internal control structure includes the policies and procedures used by the staff, adequate accounting and information systems, the work environment, and the professionalism of employees. An effective internal control structure includes the five interrelated components of the control environment, fraud risk assessment, control activities, information and communication, and monitoring. Desert Community College D istrict 9 10 O C C U PAT I O N A L F R A U D Internal Control Element Control Environment Commonly referred to as "the moral tone of the organization," the control environment includes a code of ethical conduct; policies for ethics, hiring and promotion guidelines; proper assignment of authority and responsibility; oversight by management, the board or an audit committee; investigation of reported concerns; and effective disciplinary action for violations. Fraud Risk Assessment Identification and assessment of organization's objectives to establish and develop a strategy to react timely; analysis of potential risks of violations both internal (examples include personnel changes and/ or new operating systems) and external (examples include shifting economic conditions and/or new legislation); and developing a strategy to manage risks. Control Activities The development of policies and procedures to enforce the governing board's directives. These include the actions by management to prevent and identify misuse of the district's assets, including the prevention of override of controls in the system by any employee. Information and Communication The establishment of effective fraud communication. This includes ensuring that employees receive information regarding policies and opportunities to discuss ethical dilemmas, and establishing clear lines of communication in an organization to report suspected violations. The organization should assimilate important information (such as legislative changes), pass on pertinent information, including anonymous reports, to those who need it, and provide for upward communication that is free from retaliation. Monitoring Ongoing monitoring that includes regular evaluation of the control environment by managers and employees. This also includes a process to verify the accuracy of financial information. Examples of improper internal controls include, but are not limited to, the following: o Failure to adequately segregate the duties and responsibilities of authorization. o Failure to limit access to assets or sensitive data. o Not recording transactions, resulting in lack of accountability and the possibility of theft. o Unauthorized transactions, resulting in skimming, embezzlement or larceny. o Lack of monitoring or implementing internal controls by the governing board and management. o Collusion among employees where little or no supervision exists. A system of internal controls consists of policies and procedures designed to provide the governing board and management with reasonable assurance that the organization achieves its objectives and goals. T raditionally referred to as hard controls, these include segregation of duties, limiting access to cash, management review and approval, and reconciliations. Other types of internal controls include soft controls such as management tone, performance evaluations, training programs, and maintaining established policies, procedures and standards of conduct. The internal control environment is a critical component since it establishes the organization's moral tone, commonly referred to as "the tone at the top." The tone at the top is an intangible internal control element that consists of the perception of an organization's employees regarding the ethical conduct displayed by the governing board and administrative management. A strong system of internal controls that consists of all five internal control elements can provide reasonable, but not absolute assurance that the organization will succeed in achieving its goals and objectives. Fiscal Crisis & Management Assistance Team CHRONOLOGY OF EVENTS Chronology of Events The California State Chancellor's Office was concerned that the Desert Community College District incorrectly reported FTES for the fiscal years ending 2004 through 2010, a seven-year period, after receiving numerous tips about attendance reporting irregularities. Over the past eight years, the district has employed senior administrators who were knowledgeable and familiar with the rules, methods, and proper determination of FTES. The district also retained a consulting firm that specialized in attendance reporting and helped the college convert attendance data from the previous Legacy system to a new reporting system purchased by the college in December 2001 for a 2003-04 targeted implementation date. Datatel Enterprise software is used by many California community colleges and in almost every state to track and report student attendance. From December 2001 to the fall of 2003, district personnel conducted a series of committee meetings that included senior administrators, managers and support staff to decide how to map each course section and record student attendance among many other implementation decisions. The goal was to have the Datatel system operational by fall 2003. FCMAT received a course selection mapping dated December 18, 2002 in a matrix format designed to map existing data from the current system into the intermediate files along with comments extracted from committee meetings for implementation purposes. This detailed document identifies each of the following areas: o ID Information o Basic section information o Credit information o Instructional methods information o Billing information o Registration information o Facility requirement information o Expense information o Additional course section information o Override date information o Meeting information o Faculty information o Corequisite information o Regular billing information o Other regular billing information o California information The instructional methods information section provides details to the technology information programming staff on how the system was to be programmed for the measurement of student contact hours. According to the matrix, "contact hours of the section, defaults from the contract hours of the course." Desert Community College D istrict 11 12 CHRONOLOGY OF EVENTS In March 2004, district personnel made a final decision to use catalog hours instead of scheduled or actual hours in Datatel at a committee meeting attended by several employees, including two vice presidents. The results of that decision and minutes from the meeting were shared with numerous employees. Email evidence reviewed by FCMAT indicates that the district senior management team had significant and extensive knowledge of FTES miscalculation as early as 2004. T emails support the fact that the staff was instructed in how to set up the new Datatel system wo using catalog hours instead of actual student contact hours. The first email dated March 9, 2004 clarified section hours as follows: Greater than 50 but less than 54 = 54 Greater than 30 but less than 36 = 36 Greater than 16 but less than 18 = 18 The methodology to use catalog hours is further illustrated in a second email and an attachment from a vice president to the district staff on how to calculate the FTES calculations for weekly student contact hour (WSCH) classes dated March 25, 2004. The attachment states that the final decision for total hours for the course will be "based on the catalog hours." The document shows the following summarized example from the attachment: If the catalog refers to a 3 hour class, the total hours per semester will be 54 = 3 x 18. The table for other classes follows this pattern: 1 hour = 18 semester hours 2 hour = 36 semester hours 3 hour = 54 semester hours 4 hour = 72 semester hours FTES for a WSCH class will be computed as follows: FTES = (Number of Students) x (Semester Hours/16) x 16.4* 525 Example: 30 students in a 4 hour class: 30 x (72/16) x 16.4 = 4.22 FTES 525 * The 16.4 multiplier is results of 2 flex days/semester which makes the semester 16.4 weeks. The correct methodology for calculating weekly census contact hours according to the formula provided by the Chancellor's Office is as follows: If the class schedule results in 3 weekly contact hours for a semester length class, the total hours per semester will be 52.5 = 3 x 17.5. (Maximum length term multiplier is 17.5.) Therefore, using this general example, there would be a total of 52.5 contact hours per student instead of 54, providing an overstatement of approximately 3% for every student hour reported Using an actual previously claimed College of the Desert three-unit weekly census course from fall 2009 - AGPS 005-134 Plant Science, the weekly contact hours based on the catalog and the above district formula results in 3.38 weekly contact hours (54/16=3.375, rounded to 3.38), or 55.43 for each student for the entire semester (3.38 x 16.4 TLM=55.43). Fiscal Crisis & Management Assistance Team CHRONOLOGY OF EVENTS However, using contact hours calculated from the official schedule of classes, only 3.2 weekly student contact hours are calculated (class met Mondays and Wednesday from 8 a.m. to 9:20 a.m., which totals 3.2 contact hours per week), or 52.48 for each student for the entire semester (3.2 x 16.4 TLM=52.48). For this specific course section, there would be a total of 52.48 claimable contact hours per student instead of 55.43, providing an overstatement of approximately 5.62% for every student reported. The contact hour and FTES differences can have wide variances depending on course section and how that course section may have been scheduled. For example, a different section of the same three-unit plant science course from fall 2009 (AGPS 005-168) scheduled differently (Wednesdays, 3:40 p.m. to 6:45 p.m.) generated 3.3 weekly student contact hours based on the schedule of classes or 54.12 claimable semester hours per student. However, using catalog hours, the district inappropriately claimed a total of 55.43 contact hours per student (3.38 weekly hours x 16.4 TLM= 55.43). Therefore, for this one-day per week course section, the total difference between the two methods would be 1.31 contact hours per student or an overstatement of 2.42% for every student reported. Shortly after the president's appointment in 2005-06, he retained an independent consulting firm to assist with the FTES calculations because he had concerns about the potential problem with the data from some district staff members. The contract dated January 3, 2005 between SIG and the district had the following scope of work: Under the terms of this Agreement, the Consultant will provide consulting services to the staff of the College, as directed, and perform the following work: Consultant will conduct an analysis of the academic history data in the existing legacy COCO system and develop options and estimated costs to convert the data and load it into Colleague*. The options and cost estimates will include the definition of ELF templates and conversion tables, development of extract programs, formatting the data within the ELF toolkit, loading the data into Colleague, reviewing the new academic records in Colleague for accuracy and making any required corrections. *Note: Colleague is Datatel. The consulting firm has been on contract preparing the required attendance CCFS-320 reports from 2004-05 through the 2010-2011 fiscal year for all three reporting periods. At the Chancellor's Office request to resubmit the CCFS-320 reports from 2004-05 through 2009-10 fiscal years, the president retained the consulting firm to correct and resubmit the reports originally prepared by the same consulting firm at a cost of $170 per hour totaling $29,290. The consulting contract is attached as Appendix A to this report. Desert Community College D istrict 13 14 cHr> conduct an analysis of the academic history data in the existing legacy COCO System and develop options and estimated costs ta convert he data and load it mm colleague. The options and cost estimates wm lnctude the definition of templates and Fables. development of extract programe, formatting the data within the ELF 1 foo t, loading the deta into Colleague, reviewing the new academic records In Colleague'- OF accuracy and making any required corrections. FISCAL CRISIS MANAGEMENT ASSISTANCE TEAM APPENDICES 33 Appendix - Dcricrtel Letter ('LI-Alege QR Desert . JUL 1 3 2011 <<-Farr 947 kg U9. r' fit July15,'201t 9* A?lwew President Jerry Patton Coilege of the Desert ~30" 43-500 Monte-rey Avenue Palm Desert, CA -92260-9399 Dear President Patton: On behalf of the Datatel staff and Board, I want to thank you for your time last Wednesday to discuss the reporting issue you've had to handle recently. enjoyed meeting your executives and reviewing how we can handle this issue together. As I shared with you, Datatel is strongly committed to supporting and partnering with our customers. The Board works very hard to foster the highest ethical standards in all our transactions. We were dismayed that you discovered that you needed to account for your credit hours in a different manner than you had been doing. i realize what a hassie this has been and am reiieved that you have been able to manage the accounting modifications. The State has underfunded your growth for years and I hope they are able to factor this into any adjustment which might be made. am also relieved, on behalf of Datatel, that we were not the cause of any miscaiculation and am grateful that you will share our meeting with Fred Harris in the Chancellor's offioe. l'il assume that you will share that discovery with your staff should the question arise. We will be prepared to indicate to anyone who inquires about this issue that we had a very productive meetingand that the issue was resolved totally. Wears delighted thatyouiare weil your planning process and know that I would hope to assist you in any way in the future. iirfi 'proud of are acoozmpiishingiand look forward to future meetings. East' "Charles . "00? John Si5eer}'Eiatatel, 5E0 - Anupam Mishra,,H&F. Managing Director Mark Jones, Datate-I, -. 4. . - A DESERT COMMUNITY COLLEGE DISTRICT 34 APPENDICES Appendix - Study Agreement CMAT Llilfilfi l' II. CSIS(laliforni.1 School lnformauiim Services FISCAL CRISIS MANAGEMENT ASSISTANCE TEAM STUDY AGREEMENT July 25, 2012 The FISCAL CRISIS AND MANAGEMENT ASSISTANCE TEAM (FCMAT), l1ereinafte1' referred to as tl1e Team, and the College of the Desert (governed by the Desert Community College District), hereinafter referred to as the College, mutually agree as follows: 1. BASIS OF AGREEMENT The Team provides a variety of services to school districts, county offices of education, charter schools, and community colleges upon request. The College has requested that the Team provide for the assignment of professionals to study specific aspects ofthe College of the Desert operations, based on the provisions of Education Code section 84041. These professionals may include staff of the Team, County Offices of Education, the California State Department of Education, school districts, charter schools, community colleges, or private contractors. All work shall be performed in accordance with the terms and conditions of this Agreement. 2. SCOPE OF THE WORK A. Scope and Obiectives of the Study The scope and objectives of this study are to: The California Community Colleges Chancellor's Office is requesting that the FCMAT Team conduct a review of the Desert Community College District's (DCCD), attendance accounting policies and procedures including the internal control structure to determine if fraud, misappropriation of funds or other illegal activities may have occurred in reporting apportionment attendance. The review shall be conducted in accordance with Education Code Sections 84501, 84752, Title 5, Section 58000 et seq. and the state Budget and Accounting Manual for Student Attendance Accounting Manual rules and regulations in computing full-time equivalent students (F TES) In accordance with Education Code section 84041 and the DCCD may request the FCMAT Team to assist the college to establish and maintain sound financial and budgetary conditions that comply with principals of sound fiscal management. The scope of work and review of attendance accounting procedures for full-time equivalent student FISCAL CRISIS MANAGEMENT ASSISTANCE TEAM meumces as (F TES) shall include forms prepared by the Chancellor's Office for State Apportionment Reports including CCFS-320 CCFS--32I CCFS- 320F Addendum to Part I, Supplemental Information CDCP Noncredit FTES a11d any supporting work papers or electronic files. The review shall include findings and recommendations to determine if the DCCD inappropriately claimed state apportionment funds utilizing catalog hours rather than actual or scheduled hours; and if any issues of fraud, misappropriation of funds or other illegal activities occurred during the reporting period. The primary focus of this review is to provide the Community College Chancellor's Office with reasonable assurances based on the testing performed that adequate management controls are in place regarding the districts attendance reporting and monitoring and that fraud, misappropriation of funds or other illegal activities have not occurred. Management controls include the processes for planning, organizing, directing, and controlling program operations, including systems for measuring, reporting, and monitoring performance. Specific audit objectives will include evaluating the policies, procedures, and internal controls and transactions performed by the district related to the following: 1. The FCMAT Team will sample test data from the 2003-04 FY to 2009-10 FY. Testing associated with this review will be based upon sample selection and will not include the testing of the complete list of all transactions and records for this period. Sample testing and review results are intended to provide reasonable, but not absolute assurance as to the accuracy of the district's transactions and financial activity. The college's attendance accounting has been previously reviewed and recalculated with the appropriate amount of FTES that should have been claimed for a 7 year period from 2003-04 to 2009-10. The 2003-04 fiscal year was the initial year of conversion and implementation to the Datatel ERP system. Independent auditors have reviewed, corrected and validated the new calculations, which demonstrate that the district over- reported FTES for apportionment funding for 3 of the 7 years, and under-reported the remaining 4 years and this component is not part of the study agreement. B. Services and Products to be Provided 1) Orientation Meeting - The Team will conduct an orientation session at the College to brief management and supervisory personnel on the procedures of the Team and on the purpose and schedule of the study. 2) On-site Review -- The Team will conduct an on--site review at the College administration office and at other college sites if necessary. 3) Exit Meeting -- The Team will hold an exit meeting at the conclusion of the on--site review to inform the College administration of significant findings and recommendations to that point. DESERT COMMUNITY COLLEGE DISTRICT meumces 4) Exit Letter - The Team will issue an exit letter approximately 10 days after the exit meeting detailing significant findings and recommendations to memorialize the topics discussed in the exit meeting. 5) Draft Reports -- Electronic copies of a preliminary draft report will be delivered to the College administration for review and comment. 6) Final Report -- Electronic ve1'sions ofthe final study report and copies is requested will be delivered to the College following completion ofthe review. The final report will be published on the FCMAT website. 3. PROJECT PERSONNEL The study team will be supervised by Anthony L. Bridges, CFE, Deputy Executive Officer, Fiscal Crisis and Management Assistance Team, Kern County Superintendent of Schools Office. The study team may also include: A. Deborah Deal, CFE FCMAT Fiscal intervention Specialist B. Dr. Reagan Romali FCMAT Community College Consultant C. Michael Ammermon, CPA FCMAT Community College Consultant Other equally qualified consultants will be substituted in the event one of the above noted individuals is unable to participate in the study. 4. PROJECT COSTS The cost for studies requested pursuant to E.C. shall be: A. $800.00 per day for each CMAT staff Member while on site, conducting fieldwork at other locations, presenting and preparing reports, or participating in meetings. B. All out--of--pocket expenses, ineludi11g travel, meals, lodging, etc. The College will be invoiced at actual costs, with 50% ofthe estimated cost due following the completion of the on--sitc review and the remaining amount due upon acceptance of the final report by the College. Based on the elements noted in section 2 A, the total cost of the study shall not exceed the amount of $25,000. C. Any change to the scope will affect the estimate oftotal cost. FISCAL CRISIS MANAGEMENT ASSISTANCE TEAM APPENDICES 37 In consideration of satisfactory performance of this Agreement, the Chancellor's Office agrees to pay the FCMAT's costs including contractors in accordance with the approved contract budget, Exhibit G, which is also attached hereto and by reference made a part of this Agreement, and the Project Authorization for each particular investigation, review or audit. The total amount payable under this Agreement shall not exceed the maximum amount of this Agreement, specified on the face page of this Agreement. Payment shall be n1ade in arrears upon receipt ofan invoice, in triplicate, specifying this Agreement Number and the expenditures for the period covered, broken down by Project Authorization. Payment ofall invoices will be subject to withholding often percent of the expenses billed pending satisfactory performance of this Agreement. No payments shall be made without the written approval of the Project Monitor and the Executive Vice Chancellor, or his/her designee. Such approval is contingent upon the Project Monitor's approval of the progress the Contractor has made within each respective invoicing period. Approval of invoices by the Project Monitor and the Executive Vice Chancellor or his/her designee shall not be unreasonably withheld. Payments for FCMAT services are payable to Kern County Superintendent of Schools - Administrative Agent. RESPONSIBILITIES OF THE COLLEGE A. The College will provide office and conference room space while on-site reviews are in progress. B. The College will provide the following (if requested): 1) A map of the local area 2) Existing policies, regulations and prior reports addressing the study request 3) Current or proposed organizational charts 4) Current and two (2) prior years' audit reports 5) Any documents requested on a supplemental listing 6) Any documents requested on the supplemental listing should be provided to FCMAT i11 electronic format when possible. 7) Documents that are only available in hard copy should be scanned by the district and sent to CMAT in an electronic format. 8) All documents should be provided in advance of field work and any delay in the receipt of the requested documentation may affect the start date of the project. C. The College administration will review a preliminary draft copy of the study. Any comments regarding the accuracy of the data presented in the report or the practicability of the recommendations will be reviewed with the Team prior to DESERT COMMUNITY COLLEGE DISTRICT as meumces completion ofthe final report. The final report will be published on the FCMAT website. 6. PROJECT SCHEDULE The following schedule outlines the planned completion dates for key study milestones: Orientation: August 15, 2012 Staff Interviews: To be determined Exit Interviews: To be determined Preliminary Report Submitted To be determined Final Report Submitted To be determined Board Presentation To be determined 7. CONTACT PERSON Name of contact person: Frederick Harris. Assistant Vice Chancellor Telephone: (916) 323-8245 FAX -mail: Dr. Joe Kinnanon, President I Datle College gt' rig; Desert Julv 25.2012 Anthony Bridges, CF13 Date Deputy Executive Officer Fiscal Crisis and Management Assistance Team ligfiua? F'redericl< Harris Date Assistant Vice Chancellor Project Monitor Californ' Comnyu liege Chancel "5 Office 7/23//2 ZQCJ Steve Bruclmian Date Executive Vice Chancellor of Operations and General Counsel California Community College'Chancellor's Office FISCAL CRISIS MANAGEMENT ASSISTANCE TEAM