Dataset: Program Budget Operating Budget Vs Expense Raw Data

About this Dataset

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.
Organization: City of Austin
Last updated: 2020-11-12T13:27:19.394389
Tags: actual, austin, austin-finance-online, budget, budget-documents, budget-office, city-of-austin, controller, expenditures, finance, financial, financial-services, operating, proposed, raw-budget-data, reports

Tables

Table 1

@usgov.city_of_austin_program_budget_operating_budget_vs_expense_raw.table_1

1.26 MB
55512 rows
19 columns


CREATE TABLE table_1 (
  "budget_fiscal_year" BIGINT,
  "thru_quarter" BIGINT,
  "dept_rollup" BIGINT,
  "dept_rollup_name" VARCHAR,
  "department_code" BIGINT,
  "department_name" VARCHAR,
  "fund_code" VARCHAR,
  "fund_name" VARCHAR,
  "program_code" VARCHAR,
  "program_name" VARCHAR,
  "activity_code" VARCHAR,
  "activity_name" VARCHAR,
  "unit_code" VARCHAR,
  "unit_name" VARCHAR,
  "expense_code" VARCHAR,
  "expense_name" VARCHAR,
  "budget" DOUBLE,
  "expenditures" DOUBLE,
  "key" VARCHAR
);