Budget - 2018 Budget Ordinance - Positions and Salaries
data.cityofchicago.org | Last Updated 22 Nov 2017The 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, 2018. 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: https://data.cityofchicago.org/d/xzkq-xp2w.
This dataset has the following 22 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
FUND TYPE | fund_type | text | Local Grant CDBG view top 100 |
DEPARTMENT CODE | department_code | number | 57 41 59 84 85 view top 100 |
DEPARTMENT DESCRIPTION | department_description | text | CPD HEALTH CFD CDOT AVIATION view top 100 |
FUND CODE | fund_code | text | 0100 0740 0200 0300 0J44 view top 100 |
FUND DESCRIPTION | fund_description | text | CORPORATE FUND O HARE REVENUE FUND WATER FUND VEHICLE FUND CDBG view top 100 |
ORGANIZATION CODE | organization_code | text | 1005 1010 1020 1025 1015 view top 100 |
ORGANIZATION DESCRIPTION | organization_description | text | Chicago Police Department DEPARTMENT OF PUBLIC HEALTH Chicago Fire Department AVIATION FINANCE view top 100 |
DIVISION CODE | division_code | text | 2005 2015 2020 2012 2705 view top 100 |
DIVISION DESCRIPTION | division_description | text | Chicago Fire Department CHICAGO-O'HARE INT'L AIRPORT LAW OEMC PATROL SERVICES view top 100 |
SECTION CODE | section_code | text | 3015 3010 3104 3005 3050 view top 100 |
SECTION DESCRIPTION | section_description | text | Operations Chicago-O'Hare International Airport Administration Special Functions Division Labor view top 100 |
SUB-SECTION CODE | sub_section_code | text | 0000 4118 4319 4026 4021 view top 100 |
SUB-SECTION DESCRIPTION | sub_section_description | text | Fire Suppression and Rescue District Law Enforcement Administration Human Resources Emergency Medical Services view top 100 |
SCHEDULE / GRADE | schedule_grade | text | 1 00 3 00 2 0 B 10 B 13 view top 100 |
BARGAINING UNIT | bargaining_unit | number | 1 0 10 9 20 view top 100 |
TITLE CODE | title_code | text | 0015 9161 9171 0308 0302 view top 100 |
TITLE DESCRIPTION | title_description | text | Schedule Salary Adjustments Police Officer Sergeant Staff Assistant Administrative Assistant II view top 100 |
BUDGETED UNIT | budgeted_unit | text | Annual Hourly Monthly view top 100 |
TOTAL BUDGETED UNIT | total_budgeted_unit | number | 1 0 2 3 4 view top 100 |
POSITION CONTROL | position_control | number | 1 0 view top 100 |
BUDGETED PAY RATE | budgeted_pay_rate | number | 70092.00 76932.00 84420.00 73440.00 36.00 view top 100 |
TOTAL BUDGETED AMOUNT | total_budgeted_amount | number | 70092.00 76932.00 84420.00 93300.00 73440.00 view top 100 |