Revenue Data Download System 12/7/11 2:36 AM
All revenue data is resident in memory. A data sheet does not exist. Field Definitions
Agency Name (All)
Account Name (All)
Level Name (All)
Entity Name (All)
Fund Name (All)
Org (All)
Project (All)
Fiscal Year (All)
Program Year (All)
Current Prior Total Row Count
Total 86,503,484,617.33 1,007,156,815.91 87,510,641,433.24 165,291
12/7/2011:2:36 AM C:\Docstoc\Working\pdf\3ea1e1e5-0bb8-4e7a-bee4-62490737c9a8.xlsx\Revenue Page 1
12/7/2011:2:36 AM C:\Docstoc\Working\pdf\3ea1e1e5-0bb8-4e7a-bee4-62490737c9a8.xlsx\Revenue Page 2
Key to State Revenue Terms Go Back
Agency - The state has 51 agencies including units of the university system. Each agency is assigned a unique agency number
Agency Name
and name to indentify it.
Account Name Account Name - On the state accounting system, specific sources of revenues are identified with a six digit number and a
descriptive name. All revenue identifiers begin with the number 5.
Level Name - All types of revenue are grouped into the following categories, each of which is identified by the second number
in the five digit number: 0 = licenses and permits; 1 = taxes; 2 = charges for services; 3 = Board of Investment's earnings; 4 =
Level Name
fines and forfeitures; 5 = sale of documents, merchandise and property; 6 = rents, leases, and royalties; 7 = contributions and
premiums; 8 = grants, transfers and miscellaneous; and 9 = federal.
Entity Name - Under the state fund structure, specific types of revenue are deposited in separate accounts. Each account has a
Entity Name separate five digit number and a name that identifies the revenue or its purpose. With legislative appropriations, agencies
spend money from these accounts for its intended purpose.
Fund Name - All the entities (accounts) are group into the following categories, each of which is identified by the second
number in the five digit number: 1 = general fund (to be used for any purpose), 2 = state special (also known as dedicated
revenue accounts because the legislature has designated a specific purpose for which the money can be used), 3 = federal
Fund Name (money received from the federal government), 4 = debt service (used to pay debt service on bonds), 5 = capital projects (used
to build buildings), 6 = proprietary (money paid by a state agency for services provided by another state agency), 7 = agency
(money received for which the state does not yet have title to), 8 = expendable trusts (trusts whose earnings and principal can
be spent), and 9 = non-expendable trusts (trusts whose earnings can be spent but the principal generally can not). The
remaining fund numbers (with no names) are reserved for the university system.
Org -Agencies create these numbers (sometimes with cryptic names) to assist them in tracking revenue for specific activities or
Org
groups of activity.
Projects - Mostly in DPHHS for reporting federal revenue, these numbers (sometimes with cryptic names) are created to assist
Project
in tracking revenue across multiple orgs.
Fiscal Year - The state fiscal year begins July 1st and ends June 30th. The current fiscal year is commonly referred to as
Fiscal Year
"current year".
Program Year - Although this name is not very descriptive, it means any fiscal year prior to (thus also referred to as "prior
year") the current year. Since the state is on a modified accrual accounting system, revenue received in the current fiscal year
Program Year could have been the result of activities or requirements in a previous fiscal year. For example: Oil and natural gas tax revenue
for the second quarter of calendar 2008 (fiscal year 2008) is collected in the third quarter of calendar 2008 (fiscal year 2009).
So this revenue would have a fiscal year date of 2009 and a program year date of 2008.