Any views expressed related to procedural or explanatory material are those of the author and not ne

1
Any views expressed related to procedural or
explanatory material are those of the author and
not necessarily those of the U.S. Census Bureau.
2
U.S. Census Bureau
Demystifying the Consolidated Federal
Funds Report Kenneth Beatty Scott
Peterson Pennsylvania State Data Center Annual
Data Users Conference Holiday Inn Harrisburg,
PA September 10, 2009
3
Agenda

• Overview of programs FAADS, CFFR, and FAS
• Overview of CFFR Query System by example
• Get acquainted with the CFFR and FAADS web pages

4
Federal Assistance Award Data System (FAADS)

• Project was initiated by Office of Management and
  budget in 1981.
• FAADS is the central collection point for
  submissions from various Federal agencies.
• Data are released on a quarterly basis.

5
Consolidated Federal Funds Report (CFFR)

• Statistics reported on the geographic
  distribution of Federal expenditures.
• Report is released on an annual basis.
• Query system and data downloads available online.

6
Federal Aid to States (FAS)

• Actual expenditures reported.
• Assistance reported only on State and local
  governments.
• Annual report released with CFFR.

7
THE CONSOLIDATED FEDERAL FUNDS REPORT (CFFR)
ONLINE QUERY SYSTEM

• HOW TO GET THERE
• Start at the website, URL http//www.census.gov/g
  ovs/
• In the center of the page, under Business
  Industry, select GOVERNMENTS
• The following webpage is displayed
• Select the Consolidated Federal Funds Report link
  in the top right of the page.

8

• For the CFFR online query system, select the
  On-Line Query System link.
• Note The current year is displayed and years
  (1993 to 2007) are available under Select a Year
  (1993 onward). The user will be directed to an
  identically formatted page for any desired year.
  The current and past CFFR web pages have all
  available data files, reference materials, and
  related links for that particular year.

9

• USING THE QUERY SYSTEM
• Once you have selected the online query system,
  the following page will be displayed.
• Choose Geography to see a summary of Federal
  expenditures for a particular state or county
  area, or for the entire United States. This
  summary can be narrowed down to a single object
  category.
• Choose Agency if you are interested in seeing a
  display that has been filtered to include only
  expenditures of a particular Federal agency or
  sub-agency. You will be prompted to choose a
  level of geography AND an agency.
• Choose Program if you are interested in data for
  a single Federal program. You will choose a level
  of geography AND a Federal program. The
  geography choices include one for "multi-state"
  or "multi-county." Also different from Geography
  and Agency searches, you are permitted to specify
  a "multi-year" time span.

10
Geography Example

• After choosing geography and the year of
  interest, using the various pull down menus,
  continue to build your custom report.
• Select
• STATE Pennsylvania
• COUNTY Yes (Choosing No would produce state
  totals)
• FUNDING TYPES All Types (Choices include
  Grants, Direct Payments, Loans, etc)
• Click Submit.

11

• This screen will appear, prompting you to select
  a county.
• Click submit to view the requested output.

12
(No Transcript)
13
Agency Example

• Return to the main query system page and choose
  Agency in the search drop down box.

14

• Choose the following options
• State Pennsylvania
• County No
• Agency Commerce Department
• Sub-Agency No
• Click submit.

15
(No Transcript)
16
Program Example

• Return to the main CFFR Query page.
• Select
• Year 2008
• Search Program

17

• Continue by Choosing
• State Pennsylvania
• County Multi
• Programs 96.002 Social Security Retirement
  Insurance
• Click submit.
• Note With all selections in the program
  category, output is displayed in Excel.

18
(No Transcript)
19
The Flow of Data
Department of Homeland Security
FAADS
Department of Agriculture
Department of Commerce
CFFR
Procurement Contracts
Salaries and Wages
Retirement and Disability
FAS
Various Federal Agencies
20
FAADS/CFFR Assistance Crosswalk
21
What Happens Between FAADS and CFFR?
22
FAADS Excerpt
23
CFFR Excerpt
24
Questions?
25
Contact

• Federal Programs Branch
• Governments Division
• U.S. Census Bureau
• [phone]
• Email govs.cffr_at_census.gov