Icon for Socrata external plugin
Updated over 5 years ago
Indexed 6 hours ago

Budget - 2017 Budget Ordinance - Positions and Salaries

The Annual Appropriation Ordinance is the final City operating budget as approved by the City Council. It reflects the City’s operating budget at the beginning of the fiscal year on January 1, 2017.

This dataset displays the positions and related salaries detailed in the budget as of January 1. It is extracted from the personnel portion of the Appropriation Ordinance. The dataset presents the position titles (without names) and salaries described in the budget, but does not provide a reflection of the current city workforce with full names and salaries.

Disclaimer: the “Total Budgeted Units” column displays either A) the number of employees AND vacancies associated with a given position, or B) the number of budgeted units (ie. hours/months) for that position. “Position Control” determines whether Total Budgeted Units column will count employees and vacancies or hours/months. If a Position Control is 1, then employees and vacancies are displayed; if a Position Control is 0, then the total number of hours/months recorded is displayed.

For information on the current city workforce, with names, positions and salaries, visit the "Current Employee Names, Salaries, and Position Titles" dataset:


NameSocrata field nameColumn name in sgr mountData typeDescription
POSITION CONTROLposition_controlposition_controlNumber
TOTAL BUDGETED UNITtotal_budgeted_unittotal_budgeted_unitNumber
ORGANIZATION CODEorganization_codeorganization_codeNumber
FUND DESCRIPTIONfund_descriptionfund_descriptionText
FUND CODEfund_codefund_codeText
SECTION DESCRIPTIONsection_descriptionsection_descriptionText
DIVISION DESCRIPTIONdivision_descriptiondivision_descriptionText
DIVISION CODEdivision_codedivision_codeNumber
DEPARTMENT CODEdepartment_codedepartment_codeNumber
SCHEDULE / GRADEschedule_gradeschedule_gradeText
BARGAINING UNITbargaining_unitbargaining_unitNumber
SUB-SECTION DESCRIPTIONsub_section_descriptionsub_section_descriptionText
BUDGETED PAY RATEbudgeted_pay_ratebudgeted_pay_rateNumber
TITLE CODEtitle_codetitle_codeText
TITLE DESCRIPTIONtitle_descriptiontitle_descriptionText
BUDGETED UNITbudgeted_unitbudgeted_unitText
SUB-SECTION CODEsub_section_codesub_section_codeNumber
DEPARTMENT DESCRIPTIONdepartment_descriptiondepartment_descriptionText
FUND TYPEfund_typefund_typeText
TOTAL BUDGETED AMOUNTtotal_budgeted_amounttotal_budgeted_amountNumber
ORGANIZATION DESCRIPTIONorganization_descriptionorganization_descriptionText
SECTION CODEsection_codesection_codeNumber
  • budget_2017_budget_ordinance_positions_and
Upstream Metadata