This view filtered on fiscal year = FY20-21, Fund = 3005, Sub fund = SW. Listing of all City expenses per department. This data includes transactions paid by check as well as payroll transactions and transactions paid by wire or electronic draft. Includes record date, payee, amount and the accounting string that describes which fund, organizational department and the activity roll up of the department that benefited from the transaction. The data contained on this website is for informational purposes only and represents expenditure transactions of the City of Mesa. The data includes check payments as well as payroll transactions and transactions paid by wire or electronic draft. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). Certain Mesa vendor and customer names have been redacted for confidentiality and safety issues; therefore, not all vendor or customer names are represented. Payments that are voided in a subsequent Fiscal Year may appear as a negative amount. 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 55 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Row ID | row_id | number | Unique record identifier that is being used for sorting and grouping purposes. | 1006166639 1010752770 1007939951 1011523597 1009674306 view top 100 |
Fiscal Year | fiscal_year | text | The span of the accounting fiscal year the document was created. Ex: FY 16/17 | FY20-21 view top 100 |
Accounting Period | accounting_period | number | The accounting period the transaction was recorded. The City's accounting year runs from July 1 to June 30, where July is accounting period 1. | 10 4 12 7 11 view top 100 |
Accounting Period 12 | accounting_period_12 | number | The Accounting Period field adjusted so that period 13 information is included as period 12. | 12 10 4 7 11 view top 100 |
Fiscal Month Name | fiscal_month_name | text | The month and period name of the fiscal year in the format of month-period. | Apr-10 Oct-4 Jun-12 Jan-7 May-11 view top 100 |
Fiscal Month Name 12 | fiscal_month_name_12 | text | The Fiscal Month Name field adjusted so that period 13 information is included as period 12. | Jul-1 Apr-10 Oct-4 Jun-12 Jan-7 view top 100 |
Date | date | calendar_date | The date of the transaction or when the document was created. | 2021-06-08T00:00:00.000 2020-09-15T00:00:00.000 2020-07-21T00:00:00.000 2021-05-25T00:00:00.000 2020-11-24T00:00:00.000 view top 100 |
Date 12 | date_12 | calendar_date | The Date field adjusted so that period 13 information is included as period 12 | 2021-06-30T00:00:00.000 2020-09-15T00:00:00.000 2021-06-08T00:00:00.000 2020-07-21T00:00:00.000 2021-05-25T00:00:00.000 view top 100 |
Fund Code | fund_code | text | The number assigned to the governmental segment that benefited from the transaction. | 3005 view top 100 |
Fund Name | fund_name | text | The governmental segment that benefited from the transaction. Examples include Cemetery, Transit and Arts and Culture. | Utility Fund Solid Waste Enterprise Fund Solid Waste view top 100 |
SubFund Code | sub_fund_code | text | The numbers assigned for the breakdown of a fund based on purpose, classification, and other specific characteristics. | SW view top 100 |
SubFund Name | sub_fund_name | text | The breakdown of a fund based on purpose, classification, and other specific characteristics. | Solid Waste Blank Trash Other - Administration Other - Barrel Collection view top 100 |
Department Code | department_code | text | The number assigned to the department that benefited from the transaction. | F320 F915 F310 F120 F920 view top 100 |
Department Name | department_name | text | The department that benefited from the transaction. | Environmental Management and Sustainability Centralized Appropriations II Water Resources City Attorney Project Management Program view top 100 |
Business Objective Code | business_objective_code | 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. | A034 A004 A038 A015 A024 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. | Solid Waste Management Centralized Appropriations Water Environmental and Sustainability Legal view top 100 |
Service Level Code | service_level_code | 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. | DA34 DA04 DA38 DA15 DA24 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. | Environmental Management and Sustainability Centralized Appropriations Water Resources City Attorney Project Management Program view top 100 |
Core Business Process Code | core_business_process_code | 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. | 1189 1013 1194 1233 1190 view top 100 |
Core Business Process Name | core_business_proces_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. | Solid Waste Administration Other Centralized Appropriations Barrel Collection Water Distribution Recycling and Outreach view top 100 |
Activity Code | activity_code | text | The number assigned to the activity the department was engaged in that led to the transaction. | 1451 1194 1193 1189 1195 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. | Cost Allocations-Indirect Costs Barrel Collection Operations Support Solid Waste Administration Bin Collection view top 100 |
SubActivity Code | sub_activity_code | text | The number assigned to a sub-activity. | BLNK S532 S615 S536 S640 view top 100 |
SubActivity Name | sub_activity_name | text | Activities are broken down into sub-activities for reporting and analysis purposes. | Blank Trash Other - Administration Other - Operations Support Recycle view top 100 |
Expense Category Code | expense_category_code | text | The number assigned to the category of expense on the chart of accounts. | 1000 2000 3000 9100 4000 view top 100 |
Expense Category Name | expense_category_name | text | The grouping of expense types into categories on the chart of accounts. Category examples include Personal Services, Other Services, or Commodities. | Personal Services Other Services Commodities Transfers Capital Outlay view top 100 |
Expense Type Code | expense_type_code | number | The number assigned to the expense type on the chart of accounts. | 1100 2800 3100 2200 2100 view top 100 |
Expense Type Name | expense_type_name | text | A grouping of expenses into types on the chart of accounts. Types are then grouped into categories. Expense type examples include Machinery and Equipment, Infrastructure, and Contractual Services. | Salaries and Wages Other Services Commodities Repair, Maintenance, and Utilities Contractual Services view top 100 |
Expense Code | expense_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 2998 3998 1110 1135 view top 100 |
Expense Name | expense_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. | Wages Citywide Overhead Charges Commodities Citywide Overhead Charge Insurance Benefits Miscellaneous Benefits view top 100 |
Payroll Expense Code | payroll_expense_code | text | The number assigned to the type of payroll expense being paid. | 10 50 18 12 13 view top 100 |
Payroll Expense Name | payroll_expense_name | text | The type of payroll expense being paid. Examples include Salaries, Vacation, or Taxes. | Salaries and Wages Overtime Other Compensatory Leave Vacation Leave Sick Leave view top 100 |
Amount | amount | number | The amount of the transaction. | 0.31 50 11.5 0.14 297.3 view top 100 |
Legal Name | legal_name | text | Legal name of the vendor. | Personal Services Other Services Commodities Fleet Services Creative Human Resources Concepts LLC view top 100 |
Vendor Name | vendor_name | text | Name of vendor paid if different than legal name. | Personal Services Other Services Commodities FLEET SERVICES Pcard Miscellaneous Vendor view top 100 |
Commodity Code | commodity_code | text | The number assigned to a tangible product purchase. | 99999 91027 96269 92645 80086 view top 100 |
Commodity Name | commodity_name | text | A category of tangible product purchased. Commodity categories are used by the purchasing department for analysis of major expenditures and contract opportunities. | Miscellaneous - P-Card Use Only Garbage/Trash Removal, Disposal and/or Treatment Personnel Services, Temporary Hazardous Material & Waste Services (Incl Emerg Response) Shoes & Boots, Work, Men's view top 100 |
Appropriation Code | appropriation_code | text | The number assigned to the type of appropriation of the transaction. | 1 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. | Base Operating Budget view top 100 |
Major Program Code | major_program_code | text | The number assigned to a project. | BLNK OT0122 LF0072 LF0255 LF0475 view top 100 |
Major Program Name | major_program_name | text | A project the City is working on. Generally, a major program is created to capture all of the costs of creating a new or improving an existing asset before the asset is placed in service. Major programs may also track costs related to a grant awarded to the City. | BLNK Engineering Pre-Design FY20-21 ITD CIS UPGRADE ERP Advantage Upgrade ERP Advantage Upgrades view top 100 |
Program Code | program_code | text | The number assigned to a program. | BLNK OT0122SW LF0072SW LF0255CAP LF0475CAP view top 100 |
Program Name | program_name | text | A program represents a smaller segment of a project the City is working on. For example, renovating a Park would be a major program, installing the bathroom would be a program. | BLNK Engineering Pre-Design FY20/21-Solid Waste ITD CIS UPGRADE-SW ERP Advantage Upgrade ERP Advantage Upgrades view top 100 |
Phase Code | phase_code | text | The number assigned to a phase of a project. | BLNK 102 120 106 view top 100 |
Phase Name | phase_name | text | A project is split into phases which generally represent pre-design/design/construction or may be split into purchases (where no construction is involved in the acquisition of the asset). | Blank Design Direct Expenses Purchases view top 100 |
Unit Code | unit_code | text | The number assigned to the organizational unit within the department that benefited from the transaction. | 3150 1700 3100 1100 2150 view top 100 |
Unit Name | unit_name | text | The organizational unit within the department that benefited from the transaction. Examples include Planning, Development Services, Energy Resources, Electric Utility and Gas Utility. | Solid Waste Management Facilities Maintenance Water Utility City Attorney-Civil Environmental and Sustainability view top 100 |
Reporting Code | reporting_code | text | The number assigned to a reporting mechanism used to track the expenditures related to a specific event or item. Examples are shows at the Mesa Arts Center and Park expenses. | 100674 100101 100120 100130 100057 view top 100 |
Reporting Code Name | reporting_code_name | text | A reporting mechanism used to track the expenditures related to a specific event or item. Examples are shows at the Mesa Arts Center and Park expenses. | COVID-19 FEMA Mesa Arts Center PD Central Plaza AZ Labs view top 100 |
Document ID | document_id | text | The number assigned to the transaction by the accounting system. | SPLT2100000587 SPLT2100000271 SPLT2100001373 SPLT2100001469 SPLT2100000264 view top 100 |
Document Type Code | document_type_code | text | The number assigned to the type of document the transaction was recorded in the accounting system. | PREXP CA IET PRM PRCP view top 100 |
Document Type Name | document_type_name | text | The type of document the transaction was recorded in the accounting system. | Payroll Expenditure Cost Allocation Internal Exchange Transaction Matching PR - Normal PCard Payment Request view top 100 |
Calendar Year | calendar_year | number | The calendar year portion of the current fiscal year derived from the document creation date. Ex: 2017 | 2021 2020 view top 100 |
Accounting Fiscal Year | accounting_fiscal_year | number | The accounting fiscal year the document was created. The accounting fiscal year is determined by rules of recognition of liability or revenue and can differ from the budget fiscal year. The City's fiscal year is from July 1 to June 30. | 2021 view top 100 |
Fiscal Month and Year | fiscal_month_and_year | calendar_date | The Fiscal Year and Fiscal Month formatted as as a date | 2021-06-12T00:00:00.000 2021-04-10T00:00:00.000 2020-10-04T00:00:00.000 2021-01-07T00:00:00.000 2021-05-11T00:00:00.000 view top 100 |