https://www.baystatebanner.com/2020/08/19/little-oversight-on-police-court-overtime/
https://wokewindows-data.s3.amazonaws.com/Court%20Overtime%202014%20-%202019%20-%20August%2014,%2010_02%20AM.xlsx
Report requested by City Councilor Ricardo Arroyo showing court-related overtime hours worked by Boston Police officers.
| Field Name | Description |
|---|---|
| ID | employee id of the officer |
| NAME | name of the officer |
| RANK | e.g. Ptl or Det |
| ASSIGNED | this matches the organization of the officer in the employee roster |
| CHARGED | usually matches ASSIGNED |
| OTDATE | |
| DESCRIPTIONS | always COURT CODE ONLY |
| OTCODE | |
| DESCRIPTION | e.g. "PROBATION HEARING" or "COURT:TRIAL" |
| STARTTIME | |
| ENDTIME | |
| WRKDHRS | difference between STARTTIME and ENDTIME |
| OTHOURS | WRKDHRS after rounding-up logic is applied (e.g. anything under four hours is rounded up to four) |