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) |