Budget - 2014 Budget Recommendations - Positions and Salaries

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id q8h3-djus
Name Budget - 2014 Budget Recommendations - Positions and Salaries
Attribution City of Chicago
Category Administration & Finance
Tags budget, 2014
Created 2013-10-22T18:49:37Z
Publication Date 2013-10-23T16:20:15Z

Description

This dataset includes recommended positions and salaries for 2014 by title (without names) and salary. The dataset is excerpted from the 2014 Budget Recommendations, which is the line-item budget proposed by the Mayor to the City Council for approval. 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 more information about the budget process, visit the Budget Documents page: http://j.mp/lPotWf.

Columns

| Included | Schema Type    | Field Name               | Name                     | Data Type | Render Type |
| ======== | ============== | ======================== | ======================== | ========= | =========== |
| Yes      | series tag     | fund_type                | FUND TYPE                | text      | text        |
| Yes      | series tag     | department_code          | DEPARTMENT CODE          | text      | number      |
| Yes      | series tag     | department_description   | DEPARTMENT DESCRIPTION   | text      | text        |
| Yes      | series tag     | fund_code                | FUND CODE                | text      | text        |
| Yes      | series tag     | fund_description         | FUND DESCRIPTION         | text      | text        |
| Yes      | series tag     | organization_code        | ORGANIZATION CODE        | text      | number      |
| Yes      | series tag     | organization_description | ORGANIZATION DESCRIPTION | text      | text        |
| Yes      | series tag     | division_code            | DIVISION CODE            | text      | number      |
| Yes      | series tag     | division_description     | DIVISION DESCRIPTION     | text      | text        |
| Yes      | series tag     | section_code             | SECTION CODE             | text      | number      |
| Yes      | series tag     | section_description      | SECTION DESCRIPTION      | text      | text        |
| Yes      | series tag     | subsection_code          | SUBSECTION CODE          | text      | number      |
| Yes      | series tag     | sub_section_description  | SUB-SECTION DESCRIPTION  | text      | text        |
| Yes      | series tag     | schedule_grade           | SCHEDULE / GRADE         | text      | text        |
| Yes      | numeric metric | bargaining_unit          | BARGAINING UNIT          | number    | number      |
| Yes      | series tag     | title_code               | TITLE CODE               | text      | text        |
| Yes      | series tag     | title_description        | TITLE DESCRIPTION        | text      | text        |
| Yes      | series tag     | budgeted_unit            | BUDGETED UNIT            | text      | text        |
| Yes      | numeric metric | total_budgeted_unit      | TOTAL BUDGETED UNIT      | number    | number      |
| Yes      | numeric metric | position_control         | POSITION CONTROL         | number    | number      |
| Yes      | numeric metric | budgeted_pay_rate        | BUDGETED PAY RATE        | money     | money       |
| Yes      | numeric metric | total_budgeted_amount    | TOTAL BUDGETED AMOUNT    | money     | money       |

Time Field

Value = 2014
Format & Zone = yyyy

Data Commands

series e:q8h3-djus d:2014-01-01T00:00:00.000Z t:fund_code=0100 t:fund_type=Local t:division_code=2005 t:organization_code=1005 t:budgeted_unit=Annual t:subsection_code=0 t:section_code=3005 t:fund_description="CORPORATE FUND" t:department_description="OFFICE OF THE MAYOR" t:organization_description="OFFICE OF THE MAYOR" t:schedule_grade="1 00" t:division_description="OFFICE OF THE MAYOR" t:title_code=9901 t:section_description=Executive t:title_description=Mayor t:department_code=1 m:total_budgeted_amount=216210 m:position_control=1 m:total_budgeted_unit=1 m:budgeted_pay_rate=216210 m:bargaining_unit=9

series e:q8h3-djus d:2014-01-01T00:00:00.000Z t:fund_code=0100 t:fund_type=Local t:division_code=2005 t:organization_code=1005 t:budgeted_unit=Annual t:subsection_code=0 t:section_code=3005 t:fund_description="CORPORATE FUND" t:department_description="OFFICE OF THE MAYOR" t:organization_description="OFFICE OF THE MAYOR" t:schedule_grade="1 00" t:division_description="OFFICE OF THE MAYOR" t:title_code=9637 t:section_description=Executive t:title_description="Administrative Assistant" t:department_code=1 m:total_budgeted_amount=59436 m:position_control=1 m:total_budgeted_unit=1 m:budgeted_pay_rate=59436 m:bargaining_unit=0

series e:q8h3-djus d:2014-01-01T00:00:00.000Z t:fund_code=0100 t:fund_type=Local t:division_code=2005 t:organization_code=1005 t:budgeted_unit=Annual t:subsection_code=0 t:section_code=3005 t:fund_description="CORPORATE FUND" t:department_description="OFFICE OF THE MAYOR" t:organization_description="OFFICE OF THE MAYOR" t:schedule_grade="1 00" t:division_description="OFFICE OF THE MAYOR" t:title_code=9637 t:section_description=Executive t:title_description="Administrative Assistant" t:department_code=1 m:total_budgeted_amount=46968 m:position_control=1 m:total_budgeted_unit=1 m:budgeted_pay_rate=46968 m:bargaining_unit=0

Meta Commands

metric m:bargaining_unit p:integer l:"BARGAINING UNIT" t:dataTypeName=number

metric m:total_budgeted_unit p:integer l:"TOTAL BUDGETED UNIT" t:dataTypeName=number

metric m:position_control p:integer l:"POSITION CONTROL" t:dataTypeName=number

metric m:budgeted_pay_rate p:integer l:"BUDGETED PAY RATE" t:dataTypeName=money

metric m:total_budgeted_amount p:integer l:"TOTAL BUDGETED AMOUNT" t:dataTypeName=money

entity e:q8h3-djus l:"Budget - 2014 Budget Recommendations - Positions and Salaries" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/q8h3-djus

property e:q8h3-djus t:meta.view v:id=q8h3-djus v:category="Administration & Finance" v:attributionLink=http://www.cityofchicago.org/city/en/depts/obm.html v:averageRating=0 v:name="Budget - 2014 Budget Recommendations - Positions and Salaries" v:attribution="City of Chicago"

property e:q8h3-djus t:meta.view.owner v:id=vewm-vupz v:screenName="Jonathan Levy" v:displayName="Jonathan Levy"

property e:q8h3-djus t:meta.view.tableauthor v:id=vewm-vupz v:screenName="Jonathan Levy" v:roleName=administrator v:displayName="Jonathan Levy"

Top Records

| fund_type | department_code | department_description | fund_code | fund_description | organization_code | organization_description | division_code | division_description | section_code | section_description | subsection_code | sub_section_description | schedule_grade | bargaining_unit | title_code | title_description                               | budgeted_unit | total_budgeted_unit | position_control | budgeted_pay_rate | total_budgeted_amount | 
| ========= | =============== | ====================== | ========= | ================ | ================= | ======================== | ============= | ==================== | ============ | =================== | =============== | ======================= | ============== | =============== | ========== | =============================================== | ============= | =================== | ================ | ================= | ===================== | 
| Local     | 1               | OFFICE OF THE MAYOR    | 0100      | CORPORATE FUND   | 1005              | OFFICE OF THE MAYOR      | 2005          | OFFICE OF THE MAYOR  | 3005         | Executive           | 0               |                         | 1 00           | 9               | 9901       | Mayor                                           | Annual        | 1                   | 1                | 216210            | 216210                | 
| Local     | 1               | OFFICE OF THE MAYOR    | 0100      | CORPORATE FUND   | 1005              | OFFICE OF THE MAYOR      | 2005          | OFFICE OF THE MAYOR  | 3005         | Executive           | 0               |                         | 1 00           | 0               | 9637       | Administrative Assistant                        | Annual        | 1                   | 1                | 59436             | 59436                 | 
| Local     | 1               | OFFICE OF THE MAYOR    | 0100      | CORPORATE FUND   | 1005              | OFFICE OF THE MAYOR      | 2005          | OFFICE OF THE MAYOR  | 3005         | Executive           | 0               |                         | 1 00           | 0               | 9637       | Administrative Assistant                        | Annual        | 1                   | 1                | 46968             | 46968                 | 
| Local     | 1               | OFFICE OF THE MAYOR    | 0100      | CORPORATE FUND   | 1005              | OFFICE OF THE MAYOR      | 2005          | OFFICE OF THE MAYOR  | 3005         | Executive           | 0               |                         | 1 00           | 9               | 9617       | Administrative Secretary                        | Annual        | 1                   | 1                | 78528             | 78528                 | 
| Local     | 1               | OFFICE OF THE MAYOR    | 0100      | CORPORATE FUND   | 1005              | OFFICE OF THE MAYOR      | 2005          | OFFICE OF THE MAYOR  | 3010         | Administrative      | 0               |                         | 1 00           | 9               | 9899       | Chief of Staff                                  | Annual        | 1                   | 1                | 174996            | 174996                | 
| Local     | 1               | OFFICE OF THE MAYOR    | 0100      | CORPORATE FUND   | 1005              | OFFICE OF THE MAYOR      | 2005          | OFFICE OF THE MAYOR  | 3010         | Administrative      | 0               |                         | 1 00           | 9               | 9898       | Deputy Chief of Staff                           | Annual        | 1                   | 1                | 154992            | 154992                | 
| Local     | 1               | OFFICE OF THE MAYOR    | 0100      | CORPORATE FUND   | 1005              | OFFICE OF THE MAYOR      | 2005          | OFFICE OF THE MAYOR  | 3010         | Administrative      | 0               |                         | 1 00           | 9               | 9898       | Deputy Chief of Staff                           | Annual        | 1                   | 1                | 120000            | 120000                | 
| Local     | 1               | OFFICE OF THE MAYOR    | 0100      | CORPORATE FUND   | 1005              | OFFICE OF THE MAYOR      | 2005          | OFFICE OF THE MAYOR  | 3010         | Administrative      | 0               |                         | 1 00           | 9               | 9896       | Chief Financial Officer                         | Annual        | 1                   | 1                | 169992            | 169992                | 
| Local     | 1               | OFFICE OF THE MAYOR    | 0100      | CORPORATE FUND   | 1005              | OFFICE OF THE MAYOR      | 2005          | OFFICE OF THE MAYOR  | 3010         | Administrative      | 0               |                         | 1 00           | 9               | 9891       | Administrative Assistant - Office Administrator | Annual        | 1                   | 1                | 85596             | 85596                 | 
| Local     | 1               | OFFICE OF THE MAYOR    | 0100      | CORPORATE FUND   | 1005              | OFFICE OF THE MAYOR      | 2005          | OFFICE OF THE MAYOR  | 3010         | Administrative      | 0               |                         | 1 00           | 9               | 9889       | First Deputy Chief of Staff                     | Annual        | 1                   | 1                | 154992            | 154992                |