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
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Fiscal Month and Year | fiscal_month_and_year | fiscal_month_and_year | Calendar date | The Fiscal Year and Fiscal Month formatted as as a date |
| Document Type Name | document_type_name | document_type_name | Text | The type of document the transaction was recorded in the accounting system. |
| Reporting Code Name | 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. |
| Reporting Code | 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. |
| Program Name | 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. |
| Vendor Name | vendor_name | vendor_name | Text | Name of vendor paid if different than legal name. |
| Amount | amount | amount | Number | The amount of the transaction. |
| Expense Name | 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. |
| Expense Type Name | 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. |
| Expense Type Code | expense_type_code | expense_type_code | Number | The number assigned to the expense type on the chart of accounts. |
| Expense Category Code | expense_category_code | expense_category_code | Text | The number assigned to the category of expense on the chart of accounts. |
| SubActivity Code | sub_activity_code | sub_activity_code | Text | The number assigned to a sub-activity. |
| Activity Name | 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. |
| Core Business Process Name | core_business_proces_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. |
| Service Level Name | 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. |
| Service Level Code | 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. |
| Business Objective Name | 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. |
| Business Objective Code | 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. |
| SubFund Name | sub_fund_name | sub_fund_name | Text | The breakdown of a fund based on purpose, classification, and other specific characteristics. |
| Fund Name | fund_name | fund_name | Text | The governmental segment that benefited from the transaction. Examples include Cemetery, Transit and Arts and Culture. |
| Fund Code | fund_code | fund_code | Text | The number assigned to the governmental segment that benefited from the transaction. |
| Date 12 | date_12 | date_12 | Calendar date | The Date field adjusted so that period 13 information is included as period 12 |
| Commodity Name | 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. |
| Expense Code | 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. |
| Core Business Process Code | 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. |
| Department Name | department_name | department_name | Text | The department that benefited from the transaction. |
| Date | date | date | Calendar date | The date of the transaction or when the document was created. |
| Phase Name | 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). |
| Fiscal Month Name | fiscal_month_name | fiscal_month_name | Text | The month and period name of the fiscal year in the format of month-period. |
| Accounting Period 12 | accounting_period_12 | accounting_period_12 | Number | The Accounting Period field adjusted so that period 13 information is included as period 12. |
| Document Type Code | document_type_code | document_type_code | Text | The number assigned to the type of document the transaction was recorded in the accounting system. |
| Unit Name | 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. |
| Major Program Name | 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. |
| Major Program Code | major_program_code | major_program_code | Text | The number assigned to a project. |
| SubActivity Name | sub_activity_name | sub_activity_name | Text | Activities are broken down into sub-activities for reporting and analysis purposes. |
| Document ID | document_id | document_id | Text | The number assigned to the transaction by the accounting system. |
| Accounting Period | 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. |
| Expense Category Name | 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. |
| Activity Code | activity_code | activity_code | Text | The number assigned to the activity the department was engaged in that led to the transaction. |
| Row ID | row_id | row_id | Number | Unique record identifier that is being used for sorting and grouping purposes. |
| SubFund Code | sub_fund_code | sub_fund_code | Text | The numbers assigned for the breakdown of a fund based on purpose, classification, and other specific characteristics. |
| Calendar Year | calendar_year | calendar_year | Number | The calendar year portion of the current fiscal year derived from the document creation date. Ex: 2017 |
| Unit Code | unit_code | unit_code | Text | The number assigned to the organizational unit within the department that benefited from the transaction. |
| Phase Code | phase_code | phase_code | Text | The number assigned to a phase of a project. |
| Program Code | program_code | program_code | Text | The number assigned to a program. |
| Appropriation Code | appropriation_code | appropriation_code | Text | The number assigned to the type of appropriation of the transaction. |
| Department Code | department_code | department_code | Text | The number assigned to the department that benefited from the transaction. |
| Fiscal Year | fiscal_year | fiscal_year | Text | The span of the accounting fiscal year the document was created. Ex: FY 16/17 |
| Accounting Fiscal Year | 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. |
| Commodity Code | commodity_code | commodity_code | Text | The number assigned to a tangible product purchase. |
| Legal Name | legal_name | legal_name | Text | Legal name of the vendor. |
| Payroll Expense Name | payroll_expense_name | payroll_expense_name | Text | The type of payroll expense being paid. Examples include Salaries, Vacation, or Taxes. |
| Payroll Expense Code | payroll_expense_code | payroll_expense_code | Text | The number assigned to the type of payroll expense being paid. |
| Fiscal Month Name 12 | 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. |
| Appropriation Name | 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. |
Upstream Metadata