austintexas-gov/program-budget-operating-budget-vs-expense-raw-g5k8-8sud

  • actual
  • austin
  • austin finance online
  • budget
  • budget documents
  • + 11

Program Budget Operating Budget Vs Expense Raw Data

Program Budget Operating Budget Vs Expense Raw Data

City of Austin current budget fiscal year Operating Budget showing budget versus expenditures. This budget is at the Fund, Department, Unit level. This data set includes a build date and will be updated on a quarterly basis. The data contained in this data set is for informational purposes. Certain Austin Energy budget items have been excluded as competitive matters under Texas Government Code Section 552.133 and City Council Resolution 20051201-002.

The comparison of actual expenditures to budget may appear inconsistent. That is because base wages for personnel are fully budgeted in the expense categories regular wages—full-time, regular wages—part-time or regular wages—civil service. The budget does not assume expenditure levels for the various leave categories, such as sick pay, vacation pay, or jury leave. However, actual expenses for various leave categories are recorded based on timesheet coding. The result is that actual expenditures for regular wages are spread across multiple expense categories while the budget is shown in one expense category.

Personnel savings is budgeted to account for the likely savings in personnel costs generated through attrition. However, the savings is realized in the expense categories regular wages—full-time, regular wages—part-time and regular wages—civil service. Therefore, the actual expenditures in the personnel savings expense category will always be zero.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
UNIT_CODEunit_codeunit_codeText
KEYkeykeyTextRow Key Identifier
FUND_NAMEfund_namefund_nameTextA fund is a high level chart of accounts structure. Funds help organize the City's finances. Some examples include the General Fund, Drainage Fund, and the Airport Operating Fund.
EXPENDITURESexpendituresexpendituresNumber
EXPENSE_NAMEexpense_nameexpense_nameTextThe identification name associated with an object of expenditure.  Object is a fund accounting Chart of Accounts element.  It is used to describe types of expenses. An expense category describes the types of expenses. For example, Computer Software, Salaries, and Architectural Services.
BUDGETbudgetbudgetNumber
ACTIVITY_NAMEactivity_nameactivity_nameTextAn activity is a sub-group under programs that further segregates the organization to track the City of Austin's functions and expenses.
ACTIVITY_CODEactivity_codeactivity_codeTextAn activity is a sub-group under programs that further segregates the organization to track the City of Austin's functions and expenses.
FUND_CODEfund_codefund_codeTextA fund is a high level chart of accounts structure. Funds help organize the City's finances. Some examples include the General Fund, Drainage Fund, and the Airport Operating Fund.
PROGRAM_NAMEprogram_nameprogram_nameTextA program is the secondary organizational unit used by the City of Austin. Each department has one or more programs within it. For example, Parks and Recreation have Acquatics, Cultural Arts Services, Facilities Services, etc. A program can be an organizational entity within a department, or an administrative entity in which expenses can be captured and tracked.
BUDGET_FISCAL_YEARbudget_fiscal_yearbudget_fiscal_yearNumber
PROGRAM_CODEprogram_codeprogram_codeTextA program is the secondary organizational unit used by the City of Austin. Each department has one or more programs within it. For example, Parks and Recreation have Acquatics, Cultural Arts Services, Facilities Services, etc. A program can be an organizational entity within a department, or an administrative entity in which expenses can be captured and tracked.
UNIT_NAMEunit_nameunit_nameText
EXPENSE_CODEexpense_codeexpense_codeTextThe identification code associated with an object of expenditure.  Object is a fund accounting Chart of Accounts element.  It is used to describe types of expenses. An expense category describes the types of expenses. For example, Computer Software, Salaries, and Architectural Services.
DEPARTMENT_NAMEdepartment_namedepartment_nameTextA department is a primary organizational unit used by the City of Austin. Examples of various departments are Parks and Recreation and Austin Police Department.
THRU_QUARTERthru_quarterthru_quarterTextThe Budget versus expense data set is populated with data thru the quarter defined in this column. Fiscal Months 1 to 3 is Q1, 4-6 is Q2, 7-9 is Q3, and 10-12 is Q4.
DEPT_ROLLUPdept_rollupdept_rollupNumberA department is a primary organizational unit used by the City of Austin. Examples of various departments are Parks and Recreation and Austin Police Department.
DEPT_ROLLUP_NAMEdept_rollup_namedept_rollup_nameTextA department is a primary organizational unit used by the City of Austin. Examples of various departments are Parks and Recreation and Austin Police Department.
DEPARTMENT_CODEdepartment_codedepartment_codeNumberA department is a primary organizational unit used by the City of Austin. Examples of various departments are Parks and Recreation and Austin Police Department.

Upstream Metadata