Budget - 2019 Budget Recommendations - Positions and Salaries
This dataset includes recommended positions and salaries for 2019 by title (without names) and salary. The dataset is excerpted from the 2019 Budget Recommendations, which is the line-item budget proposed by the Mayor to the City Council for approval. Disclaimer: the “Total Budgeted Unit” 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.
This dataset follows the format of the equivalent datasets from past years except that Section Code and Division Code have changed from Number to Text in order to accommodate non-numeric values.
For more information about the budget process, visit the Budget Documents page: http://j.mp/lPotWf.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| SECTION CODE | section_code | section_code | Text | |
| FUND TYPE | fund_type | fund_type | Text | |
| TOTAL BUDGETED AMOUNT | total_budgeted_amount | total_budgeted_amount | Number | |
| FUND DESCRIPTION | fund_description | fund_description | Text | |
| DEPARTMENT CODE | department_code | department_code | Number | |
| TOTAL BUDGETED UNIT | total_budgeted_unit | total_budgeted_unit | Number | |
| FUND CODE | fund_code | fund_code | Text | |
| SCHEDULE / GRADE | schedule_grade | schedule_grade | Text | |
| BUDGETED UNIT | budgeted_unit | budgeted_unit | Text | |
| ORGANIZATION CODE | organization_code | organization_code | Number | |
| POSITION CONTROL | position_control | position_control | Number | |
| TITLE CODE | title_code | title_code | Text | |
| BUDGETED PAY RATE | budgeted_pay_rate | budgeted_pay_rate | Number | |
| SUB-SECTION DESCRIPTION | sub_section_description | sub_section_description | Text | |
| SUBSECTION CODE | subsection_code | subsection_code | Number | |
| TITLE DESCRIPTION | title_description | title_description | Text | |
| ORGANIZATION DESCRIPTION | organization_description | organization_description | Text | |
| DEPARTMENT DESCRIPTION | department_description | department_description | Text | |
| SECTION DESCRIPTION | section_description | section_description | Text | |
| DIVISION CODE | division_code | division_code | Text | |
| DIVISION DESCRIPTION | division_description | division_description | Text | |
| BARGAINING UNIT | bargaining_unit | bargaining_unit | Number |