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? updated Account Group Codes 06/26/08; updated to include CFDA edits implemented January 3, 2008
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 MayCampuses have the option of sending additional versions of their CAF data for the MAYyy cycle, after the regular CAF May file has been submitted. Any additional cycles for May 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 as of the May cycle 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 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.MAY[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