Budget - 2012 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, 2012.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. Owner: Budget and Management. Frequency: Data is updated annually. For information on the current city workforce, with names, positions and salaries, visit the "Current Employee Names, Salaries, and Position Titles" dataset: http://j.mp/iutKlR.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| DEPARTMENT DESCRIPTION | department_description | department_description | Text | |
| BUDGETED PAY RATE | budgeted_pay_rate | budgeted_pay_rate | Number | |
| TOTAL BUDGETED AMOUNT | total_budgeted_amount | total_budgeted_amount | Number | |
| TITLE CODE | title_code | title_code | Text | |
| TITLE DESCRIPTION | title_description | title_description | Text | |
| TOTAL BUDGETED UNIT | total_budgeted_unit | total_budgeted_unit | Number | |
| DIVISION DESCRIPTION | division_description | division_description | Text | |
| DIVISION CODE | division_code | division_code | Number | |
| ORGANIZATION CODE | organization_code | organization_code | Number | |
| SUB-SECTION DESCRIPTION | sub_section_description | sub_section_description | Text | |
| SUB-SECTION CODE | sub_section_code | sub_section_code | Number | |
| SCHEDULE/GRADE | schedule_grade | schedule_grade | Text | |
| BARGAINING UNIT | bargaining_unit | bargaining_unit | Number | |
| POSITION CONTROL | position_control | position_control | Number | |
| FUND DESCRIPTION | fund_description | fund_description | Text | |
| FUND CODE | fund_code | fund_code | Text | |
| SECTION DESCRIPTION | section_description | section_description | Text | |
| SECTION CODE | section_code | section_code | Number | |
| DEPARTMENT NUMBER | department_number | department_number | Number | |
| FUND TYPE | fund_type | fund_type | Text | |
| BUDGETED UNIT | budgeted_unit | budgeted_unit | Text |