For questions and general information regarding CAF, contact Becky Farmer at (510) 987-0814 or via email at Becky.Farmer@ucop.edu
What's New? 07/12/2011Updated Appendix E Fund Group Codes Table with Fund Group Code 403110 title change from "Registration Fees" to "Student Services Fee"; 05/18/2011 Updated Appendix E Fund Group Codes Table with new code 4103 for "Reserved for Minority Interests", changed CFDA requirement for Federal Contracts Fund Group Codes 40631 and 40634 to "should be blank"; 05/03/2011 updated edits to require UAS Code for AGC 300160; 02/03/2011 updated Account Group codes with new AGC 160518 for Accounts Receivable Federal Financing Appropriation Build America Bonds Subsidy; 08/23/2010 updated Account Group codes with new AGC for Graduate Student Health Insurance Plan (GSHIP), updated Fund Group codes with new FGC for Miscellaneous Professional Fees; 07/12/2010 updated Account Group codes with new AGCs for Federal Pell Grants; 06/28/10 updated edits to allow Sponsor Category 08 (Higher Education) for FGC 40421 (State Contracts, Grants and Cooperative Agreements); 06/07/10 updated Account Group codes with new AGCs for Derivatives; 01/27/10 updated Account Group codes with AGC 2035 for Build America Bonds Program; 07/08/09 updated Account Group codes, adding codes for recording the Variation Margin on Investment Derivatives; 06/09/09 updated Fund Group Codes, adding fund 19945 to FGC 401000 to record the ARRA funds from the state General Fund; 04/22/09 updated Guidelines for Determining Flow Through Codes and Flow Through Code Edits for the American Recovery and Reinvestment Act of 2009 (ARRA); 04/09/09 updated Fund Group Codes and federal flow through code edits for the ARRA; updated Account Codes 02/23/09 for Pollution Remediation; updated Account and Fund Group Codes 01/14/09 to include UC Supplemental Defined Contribution Plan (UC SDCP)
OverviewThe Corporate Account/Fund Profile System (CAF) is the corporate repository of campus account numbers and attributes (such as account title and account group code) and campus fund numbers and attributes (such as fund title and fund group code). The purpose of this repository is for financial reporting at UCOP. The mapping of local campus account numbers to account group codes and local campus fund numbers to fund group codes provides for a unified chart of accounts for consolidated financial reporting.
The system receives campus input files monthly, except during fiscal closing when additional files are received according to an annual closing schedule. In addition to data from the campuses, the system also incorporates account and fund attributes for UCOP-managed Endowments, the University of California Retirement System (UCRS), and Other Postemployment Benefits (OPEB Trust).
CAF data is rarely used by itself, but is used by several other corporate systems, including: Corporate Financial System (CFS), Consolidated Financial Reporting (CFR), Corporate Contracts and Grants (CGX), and the Corporate Budget System (BUD), among others.
Optional CAF Files for Interlocation Transfer of Funds (ITF) in May CAFITF.APR[yy]Campuses have the option of sending additional versions of their CAF data for May ITF transactions, after the regular CAF April file has been submitted. Any additional cycles after the regular CAF have been submitted are intended for use in the Interlocation Transfer of Funds (ITF) application only. These additional files must be named differently than the regular monthly CAF file submission (these files will be used as input to the UCOP CAFITF job rather than the regular UCOP CAFEDT edit job). The purpose of allowing campuses to send extra files in May for ITF each year is in case campuses need to add or change account or fund attributes in order to make fiscal year-end entries into the Interlocation Transfer of Funds application (ITF). The May ITF cycle is the last cycle to make entries into the ITF application for the current fiscal year. The campuses send this extra (optional) file to the vsftp site: /ftphome/ftpusr[n]/put/caf/CAFITF.APR[yy].
Campus File Information and Record LayoutsThe monthly CAF file contains account numbers and attributes and fund numbers and attributes for the campus. The Corporate Financial System (CFS) relies on the data sent in the CAF file - every account number and fund number appearing in the monthly campus CFS Balances file (CFSBAL) must appear in the corresponding monthly CAF file. The CAF monthly file contains two record types - the record layouts are:
File Submission Information
UCOP Edit Information
UCOP edits each campus and UCOP CAF file submitted. The edit reports are made available to campuses and UCOP on the vsftp UCOP server with a filename of:
/ftphome/ftpusr[n]/get/caf/CAFEDT[cc].MMMyy
Further information on specific errors that may appear on the edit reports
can be found at:
where
(1=Berkeley, 2=San Francisco, 3=Davis, 4=Los Angeles, 5=Riverside,
6=San Diego, 7=Santa Cruz, 8=Santa Barbara, 9=Irvine, 10=Merced, U=UCOP)
(BK=Berkeley, SF=San Francisco, DV=Davis, LA=Los Angeles, RV=Riverside,
SD=San Diego, SC=Santa Cruz, SB=Santa Barbara, IR=Irvine, MC=Merced,
EN=Endowments, RS=University of California Retirement System (UCRS), TR=OPEB Trust)
JUL, AUG, SEP, OCT, NOV, DEC, JAN, FEB, MAR, APR, MAY,
PRE (June Preliminary), WSH (June Worksheet), or FNL (June Final)
Data Element Definitions and Lists of Account Group Codes and Fund Group Codes
Link to Corporate Financial System (CFS) information