Open Budget Expense | Last Updated 26 Jun 2018

City of Colorado Springs Open Budget Expense Monthly export from the City's Enterprise Resource Planning system.

Tags: investing in infrastructure, building community & collaborative relationships, promoting job creation, excelling in city services, finance, transparency

This dataset has the following 16 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
RowIdrowidtextUnique identifier used to update year-to-date or complete annual value.
YearyearnumberYear for which the value is relevant. Present year will be year-to-date amount.
PeriodperiodnumberMost recent month for this record. Completed previous years will show as "12"
FundfundtextNumeric identifier for City funds. General Fund is "001", other funds use different numbers.
AccountaccounttextNumeric value to identify the account. Correlates to "Account_Description"
DeptdeptnumberNumeric value to identify the Department. Correlates to "Dept_Description"
ProjectprojecttextNumeric value to identify the project. Correlates to "Project_Description" Some expenses are relevant to projects; others are normal operations.
Fund_Descriptionfund_descriptiontextText description of fund. Corresponds to numerical value in "Fund"
Department_Descriptiondepartment_descriptiontextText description of Department. Corresponds to numerical value in "Department"
Account_Descriptionaccount_descriptiontextText description of account. Corresponds to numerical value in "Account"
Project_Descriptionproject_descriptiontextText description of project. Corresponds to numerical value in "Project"
ServiceservicetextGeneral category of this expense. Used at the highest level of the OpenBudgetCOS visualization, not in City accounting.
DivisiondivisiontextHierarchy division related to City org chart. See for complete org chart.
Operating or Projectoperating_or_projecttextDesignates the expense as regular operating expense or project. Related to "Project" and "Project_Description"
Expense Actualsexpense_actualsnumberRecorded year-to-date or complete annual expenses for this fund-org-department-account-project designation.
BudgetbudgetnumberBudgeted annual expenses for this fund-org-department-account-project designation.