Listing of the adopted budget, amended budget, and City expenditures tied to budgetary accounts. This includes the accounting string that describes which fund, organizational department and the activity rollup of the department for the corresponding adopted budget, amended budget, and actual expenditures. The data contained on this website is for informational purposes only and represents adopted budget, amended budget, expenditures, and year end estimates of the City of Mesa. The data does not include internal transfers or accounting adjustments. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). Certain Activity assignments may change mid-year. This year-to-date information is updated monthly and represents the most current activity assignment regardless of the assignment at the time of the transaction.
This dataset has the following 27 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Row ID | row_id | text | Unique row identifier | 2022F1101101AA009DA0910451045300030001 2023F1551101AA022DA2211371277100011031 2016F9153205ELCA004DA0410091009500059041 2020F9103004FFA004DA0413721428200028811 2020F3501205AA035DA5015011515100010001 view top 100 |
Fiscal Year | fiscal_year | number | A 12-month period of time to which the Annual Budget applies and at the end of which, a governmental unit determines its financial position and the results of its operations. For the City of Mesa, the fiscal year is July 1 through June 30. | 2023 2020 2024 2021 2022 view top 100 |
Department | department | text | The number assigned to the department that benefited from the transaction. | F920 F310 F210 F420 F400 view top 100 |
Department Name | department_name | text | The department that benefited from the transaction. | Project Management Program Water Resources Police Parks, Recreation and Community Facilities Arts and Culture view top 100 |
Fund | fund | text | The number assigned to the governmental segment that benefited from the transaction. | 1101A 3005WTR 1109A 3005WW 3005ELC view top 100 |
Fund Name | fund_name | text | The governmental segment that benefited from the transaction. Examples include Cemetery, Transit and Arts and Culture. | General Fund Arts & Culture Fund Enterprise Fund Water Local Streets Environmental Compliance Fee view top 100 |
Fund Category | fund_category | text | A higher-level grouping of independent fiscal and accounting entity with a self-balancing set of accounts recording cash and/or other resources, together with all related liabilities, for the purpose of carrying on specific activities or attaining certain objectives in accordance with special regulations. Examples include Enterprise and Restricted Funds. | General Fund Other Funds Restricted Funds Enterprise Fund Grant Funds view top 100 |
Business Objective | business_objective | text | The number assigned to a major line of business that aligns with one or more of the Council's strategic initiatives; denotes a primary public purpose; and defines where the City allocates its resources. | A041 A032 A038 A031 A004 view top 100 |
Business Objective Name | business_objective_name | text | A major line of business that aligns with one or more of the Council's strategic initiatives; denotes a primary public purpose; and defines where the City allocates its resources. Examples include Fleet Services and Economic Development. | Project Management Police Water Parks, Recreation and Commercial Facilities Centralized Appropriations view top 100 |
Service Level | service_level | text | The number assigned to a group of core business processes related by a common purpose (mission, outcomes, and expected performance). This level of structure is optional depending on departmental needs. | DA41 DA38 DA04 C031 DA50 view top 100 |
Service Level Name | service_level_name | text | A group of core business processes related by a common purpose (mission, outcomes, and expected performance). This level of structure is optional depending on departmental needs. Examples include Operations Bureau and Investigations Bureau. | Project Management Program Water Resources Arts and Culture Centralized Appropriations Energy Resources view top 100 |
Core Business Process | core_business_process | text | The number assigned to a collection of related programs and services that are designed and managed to achieve a common outcome or set of outcomes. | 1274 1233 1500 1013 1181 view top 100 |
Core Business Process Name | core_business_process_name | text | A collection of related programs and services that are designed and managed to achieve a common outcome or set of outcomes. These include Patrol, Metro, and Criminal Investigations. | Capital Improvement Program Water Distribution Field Operations Other Centralized Appropriations Metro view top 100 |
Activity | activity | text | The number assigned to the activity the department was engaged in that led to the transaction. | 1448 1009 1308 1451 1070 view top 100 |
Activity Name | activity_name | text | The activity that the department was engaged in that led to the transaction. Activities are generally recurring activities such as accounting, inspections or planning. | Project Default Cost Allocations-Indirect Costs Debt Service Housing and Community Development Utility Locating view top 100 |
Expense Object Category | expense_object_category | text | The number assigned to the category of expense on the chart of accounts. | 2000 1000 3000 4000 5000 view top 100 |
Expense Object Category Name | expense_object_category_name | text | The grouping of expense types into categories on the chart of accounts. Category examples include Personal Services, Other Services, or Commodities. | Other Services Personal Services Commodities Capital Outlay Debt Service view top 100 |
Expense Object Code | expense_object_code | text | The number assigned to the type of expense being paid. In the private sector, this would be called a general ledger account number, however in the government sector, these are most often referred to as object codes. | 1101 2180 3131 2000 2181 view top 100 |
Expense Object Code Name | expense_object_code_name | text | The type of expense being paid. In the private sector, this would be called a general ledger account, however in the government sector, these are most often referred to as objects. Examples include Payroll, Professional Services or Travel. | Personal Services Other Professional Services Materials and Supplies Outside Other Services Other Contractual Services view top 100 |
Appropriation | appropriation | number | The number assigned to the type of appropriation of the transaction. | 1 2 view top 100 |
Appropriation Name | appropriation_name | text | The type of appropriation of the transaction. These will either be the base operating budget or a capital improvement project. | Operating Budget Capital Improvement Program view top 100 |
Adopted Budget | adopted_budget | number | Represents the budget as approved by formal action of the City Council which sets the spending limits for the fiscal year. | 0 1000 500 2000 5000 view top 100 |
Amended Budget | amended_budget | number | Represents amendments to the adopted budget to realign resources within the departments to achieve the desired results per the department's operational plan. | 0 1000 500 100 2000 view top 100 |
Actual Expenditures | actual_expenditures | number | The transactions amount | 0 100 150 50 225 view top 100 |
Year End Estimate | year_end_estimate | number | A projection of where the City will financially end for the fiscal year. | 0 5000 10000 30000 20000 view top 100 |
Fiscal Year Date | fiscal_year_date | calendar_date | A date representation of the Fiscal Year | 2022-01-07T00:00:00.000 2023-01-07T00:00:00.000 2021-01-07T00:00:00.000 view top 100 |
Full Time Equivalent | full_time_equivalent | number | A position converted to a decimal equivalent of a full-time position based on 2,080 hours per year. The full-time equivalent of a part-time position is calculated by dividing the number of hours budgeted by 2,080 hours. | 0 1 2 3 5 view top 100 |