Program Budget Operating Budget Vs Expense Raw Data
datahub.austintexas.gov | Last Updated 10 Apr 2023City 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.
This dataset has the following 19 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
BUDGET_FISCAL_YEAR | budget_fiscal_year | number | 2024 view top 100 | |
THRU_QUARTER | thru_quarter | text | The 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. | 4 view top 100 |
DEPT_ROLLUP | dept_rollup | number | A department is a primary organizational unit used by the City of Austin. Examples of various departments are Parks and Recreation and Austin Police Department. | 11 22 86 87 60 view top 100 |
DEPT_ROLLUP_NAME | dept_rollup_name | text | A department is a primary organizational unit used by the City of Austin. Examples of various departments are Parks and Recreation and Austin Police Department. | Austin Energy Austin Water Parks & Recreation Police Public Works view top 100 |
DEPARTMENT_CODE | department_code | number | A department is a primary organizational unit used by the City of Austin. Examples of various departments are Parks and Recreation and Austin Police Department. | 1100 2200 8600 8700 6200 view top 100 |
DEPARTMENT_NAME | department_name | text | A department is a primary organizational unit used by the City of Austin. Examples of various departments are Parks and Recreation and Austin Police Department. | Austin Energy Austin Water Parks and Recreation Police Transportation and Public Works view top 100 |
FUND_CODE | fund_code | text | A 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. | 1000 5010 5150 5020 5030 view top 100 |
FUND_NAME | fund_name | text | A 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. | General Fund Austin Energy Fund Support Services Fund Austin Water Water Utility Operating Fund Austin Water Wastewater Utility Operating Fund view top 100 |
PROGRAM_CODE | program_code | text | A 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. | 9MGT 7CRS OPRS 2ESD 10PL view top 100 |
PROGRAM_NAME | program_name | text | A 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. | Support Services Community Services Operations Electric Service Delivery Park Planning, Development, and Operations view top 100 |
ACTIVITY_CODE | activity_code | text | An activity is a sub-group under programs that further segregates the organization to track the City of Austin's functions and expenses. | 9ADM 7RCA 2PDL 31AA 1GEN view top 100 |
ACTIVITY_NAME | activity_name | text | An activity is a sub-group under programs that further segregates the organization to track the City of Austin's functions and expenses. | Departmental Support Services Community Recreation Services Power Delivery Support Centralized Investigations Power Generation view top 100 |
UNIT_CODE | unit_code | text | 8790 8783 8781 8784 8785 view top 100 | |
UNIT_NAME | unit_name | text | Administration and Management Human Resources Information Technology Support Financial Services Interfund Transfers-Other view top 100 | |
EXPENSE_CODE | expense_code | text | The 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. | 5191 5190 5023 6361 5185 view top 100 |
EXPENSE_NAME | expense_name | text | The 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. | Medicare tax FICA tax Sick pay Awards and Recognition Insurance-health/life/dental view top 100 |
BUDGET | budget | number | 0 500 1000 2000 5000 view top 100 | |
EXPENDITURES | expenditures | number | 0 29812 14906 74530 1800.24 view top 100 | |
KEY | key | text | Row Key Identifier | 20244878700100011AA11A644145190 2024485850010009MGT9ADM87857580 2024415150050405DVS5ZRW23067482 2024411110050103DES3DSM24375021 2024411110050102ESD2PDL31246551 view top 100 |