citydata-mesaaz-gov/city-expenditures-vdg8-dx96
Icon for Socrata external plugin
 
Readme
Updated 11 days ago
Indexed 36 minutes ago

City Expenditures

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Fiscal Month and Yearfiscal_month_and_yearfiscal_month_and_yearCalendar dateThe Fiscal Year and Fiscal Month formatted as as a date
Document Type Namedocument_type_namedocument_type_nameTextThe type of document the transaction was recorded in the accounting system.
Reporting Code Namereporting_code_namereporting_code_nameTextA 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.
Reporting Codereporting_codereporting_codeTextThe 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.
Program Nameprogram_nameprogram_nameTextA 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.
Vendor Namevendor_namevendor_nameTextName of vendor paid if different than legal name.
AmountamountamountNumberThe amount of the transaction.
Expense Nameexpense_nameexpense_nameTextThe 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.
Expense Type Nameexpense_type_nameexpense_type_nameTextA 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.
Expense Type Codeexpense_type_codeexpense_type_codeNumberThe number assigned to the expense type on the chart of accounts.
Expense Category Codeexpense_category_codeexpense_category_codeTextThe number assigned to the category of expense on the chart of accounts.
SubActivity Codesub_activity_codesub_activity_codeTextThe number assigned to a sub-activity.
Activity Nameactivity_nameactivity_nameTextThe activity that the department was engaged in that led to the transaction. Activities are generally recurring activities such as accounting, inspections or planning.
Core Business Process Namecore_business_proces_namecore_business_proces_nameTextA 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.
Service Level Nameservice_level_nameservice_level_nameTextA 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.
Service Level Codeservice_level_codeservice_level_codeTextThe 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.
Business Objective Namebusiness_objective_namebusiness_objective_nameTextA 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.
Business Objective Codebusiness_objective_codebusiness_objective_codeTextThe 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.
SubFund Namesub_fund_namesub_fund_nameTextThe breakdown of a fund based on purpose, classification, and other specific characteristics.
Fund Namefund_namefund_nameTextThe governmental segment that benefited from the transaction. Examples include Cemetery, Transit and Arts and Culture.
Fund Codefund_codefund_codeTextThe number assigned to the governmental segment that benefited from the transaction.
Date 12date_12date_12Calendar dateThe Date field adjusted so that period 13 information is included as period 12
Commodity Namecommodity_namecommodity_nameTextA category of tangible product purchased. Commodity categories are used by the purchasing department for analysis of major expenditures and contract opportunities.
Expense Codeexpense_codeexpense_codeTextThe 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.
Core Business Process Codecore_business_process_codecore_business_process_codeTextThe number assigned to a collection of related programs and services that are designed and managed to achieve a common outcome or set of outcomes.
Department Namedepartment_namedepartment_nameTextThe department that benefited from the transaction.
DatedatedateCalendar dateThe date of the transaction or when the document was created.
Phase Namephase_namephase_nameTextA 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).
Fiscal Month Namefiscal_month_namefiscal_month_nameTextThe month and period name of the fiscal year in the format of month-period.
Accounting Period 12accounting_period_12accounting_period_12NumberThe Accounting Period field adjusted so that period 13 information is included as period 12.
Document Type Codedocument_type_codedocument_type_codeTextThe number assigned to the type of document the transaction was recorded in the accounting system.
Unit Nameunit_nameunit_nameTextThe organizational unit within the department that benefited from the transaction. Examples include Planning, Development Services, Energy Resources, Electric Utility and Gas Utility.
Major Program Namemajor_program_namemajor_program_nameTextA 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.
Major Program Codemajor_program_codemajor_program_codeTextThe number assigned to a project.
SubActivity Namesub_activity_namesub_activity_nameTextActivities are broken down into sub-activities for reporting and analysis purposes.
Document IDdocument_iddocument_idTextThe number assigned to the transaction by the accounting system.
Accounting Periodaccounting_periodaccounting_periodNumberThe accounting period the transaction was recorded. The City's accounting year runs from July 1 to June 30, where July is accounting period 1.
Expense Category Nameexpense_category_nameexpense_category_nameTextThe grouping of expense types into categories on the chart of accounts. Category examples include Personal Services, Other Services, or Commodities.
Activity Codeactivity_codeactivity_codeTextThe number assigned to the activity the department was engaged in that led to the transaction.
Row IDrow_idrow_idNumberUnique record identifier that is being used for sorting and grouping purposes.
SubFund Codesub_fund_codesub_fund_codeTextThe numbers assigned for the breakdown of a fund based on purpose, classification, and other specific characteristics.
Calendar Yearcalendar_yearcalendar_yearNumberThe calendar year portion of the current fiscal year derived from the document creation date. Ex: 2017
Unit Codeunit_codeunit_codeTextThe number assigned to the organizational unit within the department that benefited from the transaction.
Phase Codephase_codephase_codeTextThe number assigned to a phase of a project.
Program Codeprogram_codeprogram_codeTextThe number assigned to a program.
Appropriation Codeappropriation_codeappropriation_codeTextThe number assigned to the type of appropriation of the transaction.
Department Codedepartment_codedepartment_codeTextThe number assigned to the department that benefited from the transaction.
Fiscal Yearfiscal_yearfiscal_yearTextThe span of the accounting fiscal year the document was created. Ex: FY 16/17
Accounting Fiscal Yearaccounting_fiscal_yearaccounting_fiscal_yearNumberThe 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.
Commodity Codecommodity_codecommodity_codeTextThe number assigned to a tangible product purchase.
Legal Namelegal_namelegal_nameTextLegal name of the vendor.
Payroll Expense Namepayroll_expense_namepayroll_expense_nameTextThe type of payroll expense being paid. Examples include Salaries, Vacation, or Taxes.
Payroll Expense Codepayroll_expense_codepayroll_expense_codeTextThe number assigned to the type of payroll expense being paid.
Fiscal Month Name 12fiscal_month_name_12fiscal_month_name_12TextThe Fiscal Month Name field adjusted so that period 13 information is included as period 12.
Appropriation Nameappropriation_nameappropriation_nameTextThe type of appropriation of the transaction. These will either be the base operating budget or a capital improvement project.
 
Preview
  • city_expenditures
     
Upstream Metadata