Employee Overtime and Supplemental Earnings 2012

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id 92xk-4rg9
Name Employee Overtime and Supplemental Earnings 2012
Attribution City of Chicago
Category Administration & Finance
Tags budget, overtime, supplemental earnings
Created 2011-07-14T23:11:28Z
Publication Date 2015-12-04T17:50:29Z

Description

Employee overtime and supplemental earnings by month and year-to-date. Data Owner: Budget & Management. Time Period: January 2012 to December 2012. Frequency: Data is updated monthly

Columns

| Included | Schema Type    | Field Name      | Name            | Data Type | Render Type |
| ======== | ============== | =============== | =============== | ========= | =========== |
| Yes      | series tag     | department_name | Department Name | text      | text        |
| Yes      | series tag     | employee_name   | Employee Name   | text      | text        |
| Yes      | series tag     | title           | Title           | text      | text        |
| Yes      | numeric metric | jan_ot          | Jan 2012        | money     | money       |
| Yes      | numeric metric | feb_ot          | Feb 2012        | money     | money       |
| Yes      | numeric metric | mar_ot          | Mar 2012        | money     | money       |
| Yes      | numeric metric | apr_ot          | Apr 2012        | money     | money       |
| Yes      | numeric metric | may_ot          | May 2012        | money     | money       |
| Yes      | numeric metric | jun_ot          | Jun 2012        | money     | money       |
| Yes      | numeric metric | jul_ot          | Jul 2012        | money     | money       |
| Yes      | numeric metric | aug_ot          | Aug 2012        | money     | money       |
| Yes      | numeric metric | sept_ot         | Sept 2012       | money     | money       |
| Yes      | numeric metric | oct_2012        | Oct 2012        | money     | money       |
| Yes      | numeric metric | nov_2012        | Nov 2012        | money     | money       |
| Yes      | numeric metric | dec_2012        | Dec 2012        | money     | money       |
| Yes      | numeric metric | 2012_total      | 2012 Total      | money     | money       |

Time Field

Value = 2012
Format & Zone = yyyy

Data Commands

series e:92xk-4rg9 d:2012-01-01T00:00:00.000Z t:title="ADMINISTRATIVE ASST II" t:department_name="Administrative Hearings" t:employee_name="WOODRIDGE, RACHENETTE" m:dec_2012=0 m:sept_ot=0 m:apr_ot=0 m:feb_ot=0 m:jun_ot=0 m:may_ot=0 m:aug_ot=0 m:oct_2012=0 m:nov_2012=445 m:mar_ot=0 m:jan_ot=0 m:jul_ot=0 m:2012_total=445

series e:92xk-4rg9 d:2012-01-01T00:00:00.000Z t:title="ANIMAL CARE AIDE II" t:department_name="Animal Care and Control" t:employee_name="HOLLOWAY, EFREM J" m:dec_2012=287 m:sept_ot=0 m:apr_ot=0 m:feb_ot=670 m:jun_ot=0 m:may_ot=0 m:aug_ot=0 m:oct_2012=0 m:nov_2012=0 m:mar_ot=1040 m:jan_ot=278 m:jul_ot=0 m:2012_total=2275

series e:92xk-4rg9 d:2012-01-01T00:00:00.000Z t:title="ANIMAL CONTROL OFFICER" t:department_name="Animal Care and Control" t:employee_name="EDGECOMBE, CHERYL K" m:dec_2012=514 m:sept_ot=257 m:apr_ot=0 m:feb_ot=0 m:jun_ot=637 m:may_ot=147 m:aug_ot=478 m:oct_2012=539 m:nov_2012=257 m:mar_ot=771 m:jan_ot=404 m:jul_ot=1114 m:2012_total=5118

Meta Commands

metric m:jan_ot p:double l:"Jan 2012" t:dataTypeName=money

metric m:feb_ot p:double l:"Feb 2012" t:dataTypeName=money

metric m:mar_ot p:double l:"Mar 2012" t:dataTypeName=money

metric m:apr_ot p:double l:"Apr 2012" t:dataTypeName=money

metric m:may_ot p:double l:"May 2012" t:dataTypeName=money

metric m:jun_ot p:double l:"Jun 2012" t:dataTypeName=money

metric m:jul_ot p:double l:"Jul 2012" t:dataTypeName=money

metric m:aug_ot p:double l:"Aug 2012" t:dataTypeName=money

metric m:sept_ot p:double l:"Sept 2012" t:dataTypeName=money

metric m:oct_2012 p:double l:"Oct 2012" t:dataTypeName=money

metric m:nov_2012 p:double l:"Nov 2012" t:dataTypeName=money

metric m:dec_2012 p:double l:"Dec 2012" t:dataTypeName=money

metric m:2012_total p:double l:"2012 Total" t:dataTypeName=money

entity e:92xk-4rg9 l:"Employee Overtime and Supplemental Earnings 2012" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/92xk-4rg9

property e:92xk-4rg9 t:meta.view v:id=92xk-4rg9 v:category="Administration & Finance" v:attributionLink=http://www.cityofchicago.org/city/en/depts/obm/provdrs/perf_mang/svcs/overtime_reports.html v:averageRating=0 v:name="Employee Overtime and Supplemental Earnings 2012" v:attribution="City of Chicago"

property e:92xk-4rg9 t:meta.view.owner v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:displayName=cocadmin v:privilegesDisabled=false

property e:92xk-4rg9 t:meta.view.tableauthor v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:roleName=administrator v:displayName=cocadmin v:privilegesDisabled=false

Top Records

| department_name         | employee_name              | title                       | jan_ot | feb_ot | mar_ot | apr_ot | may_ot | jun_ot | jul_ot | aug_ot | sept_ot | oct_2012 | nov_2012 | dec_2012 | 2012_total | 
| ======================= | ========================== | =========================== | ====== | ====== | ====== | ====== | ====== | ====== | ====== | ====== | ======= | ======== | ======== | ======== | ========== | 
| Administrative Hearings | WOODRIDGE, RACHENETTE      | ADMINISTRATIVE ASST II      | 0.0    | 0.0    | 0.0    | 0.0    | 0.0    | 0.0    | 0.0    | 0.0    | 0.0     | 0.0      | 445      | 0.0      | 445        | 
| Animal Care and Control | HOLLOWAY, EFREM J          | ANIMAL CARE AIDE II         | 278    | 670    | 1040   | 0.0    | 0.0    | 0.0    | 0.0    | 0.0    | 0.0     | 0.0      | 0.0      | 287      | 2275       | 
| Animal Care and Control | EDGECOMBE, CHERYL K        | ANIMAL CONTROL OFFICER      | 404    | 0.0    | 771    | 0.0    | 147    | 637    | 1114   | 478    | 257     | 539      | 257      | 514      | 5118       | 
| Animal Care and Control | RUGLIC, MARY S             | ANIMAL CONTROL OFFICER      | 0.0    | 147    | 0.0    | 0.0    | 0.0    | 0.0    | 0.0    | 0.0    | 0.0     | 0.0      | 0.0      | 0.0      | 147        | 
| Animal Care and Control | WASHINGTON, MONTESE DAJUAN | VETERINARY ASST             | 575    | 780    | 1135   | 492    | 657    | 913    | 1552   | 821    | 780     | 954      | 855      | 472      | 9985       | 
| Animal Care and Control | CEHAJIC, TIHANA            | SUPVSR OF ANIMAL CARE AIDES | 1950   | 1808   | 330    | 0.0    | 0.0    | 0.0    | 0.0    | 0.0    | 0.0     | 0.0      | 0.0      | 0.0      | 4089       | 
| Animal Care and Control | ZAVALA, VICTOR             | ANIMAL CONTROL OFFICER      | 0.0    | 0.0    | 1310   | 245    | 0.0    | 0.0    | 987    | 385    | 1355    | 736      | 385      | 0.0      | 5404       | 
| Animal Care and Control | HAMILTON, ARTHUR           | ANIMAL CARE AIDE II         | 542    | 2392   | 665    | 250    | 286    | 512    | 1250   | 1190   | 637     | 250      | 0.0      | 643      | 8615       | 
| Animal Care and Control | MCDONALD, KOLLEEN DENISE   | ANIMAL CONTROL OFFICER      | 0.0    | 0.0    | 0.0    | 0.0    | 0.0    | 0.0    | 399    | 651    | 1862    | 1006     | 293      | 736      | 4948       | 
| Animal Care and Control | MCDONALD, KOLLEEN DENISE   | ANIMAL CARE AIDE II         | 179    | 875    | 418    | 60     | 71     | 411    | 179    | 0.0    | 0.0     | 0.0      | 0.0      | 0.0      | 2192       |