BDGT SOURCE OF FUNDS DETAIL

DATA VIEW NAME: BDGT_SOURCE_OF_FUNDS_DETAIL
OVERVIEW: This view shows the source of funds breakdown from the locked budget summary file. It includes summary information for salary & wages as well as capital, fringe, aids to individuals, special purpose, supplies & expense and sales credits.
LOAD FREQUENCY: Annually, after the budget files have been locked.
DATA CUSTODIAN: UW-System Budget Planning Office.
Contact: Sara Voigts
AUTHORIZATION: You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
SPECIAL CONSIDERATIONS: All data is at the unit level.
QUESTIONS: Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)
LAST UPDATED: 01/12/00 – New data view. (fls)
DATA FORMATS: The codes following the field names in this document define the field. The different types are:
Alphanumeric Data: A – Alphanumeric field. This indicates the field may contain letters and/or numbers. The number following is the field length.
Example: a field defined as A5 could contain ‘E10LN’.
Numeric Data: PS – Packed-Signed field. This indicates the field may contain only numbers. The number following is the field length. If two digits with a decimal point in between are present the first indicates the number of positions before the decimal point and the second the number of digits after the decimal point.
Example: a field defined as PS4.2 would be in the format 9999.99 whereas PS6 would be in the format 999999.
Date: DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)

Column Name	Format	Description
BUDGET_YEAR	A4	This is a four digit year which represents the budget fiscal year of July through June
CAMPUS	A1	The campus codes are as follows: A = Madison K = Stevens Point B = Milwaukee L = Stout C = Eau Claire M = Superior D = Green Bay N = Whitewater E = La Crosse R = Colleges F = Oshkosh T = Extension G = Parkside W = System Administration H = Platteville Y = Systemwide J = River Falls
FUND	A3	Indicates the general source of funds from which the budgeted amount is paid.
ACTIVITY	A1	Code which indicates the function for the budgeted amount: 0 = Student Services 1 = Institutional Support 2 = Instruction 3 = Hospitals 4 = Research 5 = Public Service 6 = Academic Support 7 = Physical Plant 8 = Auxiliary Enterprises 9 = Financial Aid & = Farm Operations
ACTIVITY_NAME	A17	Name for the Activity, see above codes and names associated with them.
CY_TOTAL_BUDGET	N10	Contains total amount for the following budget summary categories: Aids to Individuals Fringe Benefits Capital Special Purpose Supplies and Expense Sales Credits Salaries and Wages
SW_ACADEMIC_TOTAL_CY _BUDGET	N10	Budget summary amounts for Academic salaries and wages.
SW_CLASSIFIED_TOTAL_CY _BUDGET	N10	Budget summary amounts for Classified salaries and wages.
SALARY_WAGE_CY_BUDGET	N10	Total amount budgeted for the Academic and Classified salaries and wages.
FRINGE_BENEFITS	N10	Budget summary amount for fringe benefits.
SUPPLIES_AND_EXPENSE	N10	Budget summary amount for supplies and expense
SALES_CREDITS	N10	Budget summary amount for sales credits.
CAPITAL_EXPENSE	N10	Budget summary amount for capital.
AID_TO_INDIVIDUAL	N10	Budget summary amount for aids to individuals.
SPECIAL_PURPOSE	N10	Budget summary amount for special purpose.
EXTRACT_DATE	DATE	The date the data was extracted. Format: YYYYMMDD