***THIS DATASET IS NO LONGER UPDATED*** In November 2018, the City-Parish switched to a new payroll system. This dataset contains annual salaries through 2017. For data from 2018 onward, visit https://data.brla.gov/Government/City-Parish-Employee-Annual-Salaries/g9vh-zeiw City-Parish employees' annual salaries and other payroll related information. Information is calculated after the last payroll is run for the year specified.
This dataset has the following 23 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
YEAR | year | number | 2009 2010 2015 2013 2008 view top 100 | |
EMPLOYEE NUM | employee_num | text | Employee Number | 350559 448559 457060 317152 355240 view top 100 |
LAST NAME | last_name | text | WILLIAMS JOHNSON SMITH BROWN JONES view top 100 | |
FIRST NAME | first_name | text | MICHAEL JOHN JAMES ROBERT CHARLES view top 100 | |
MIDDLE INIT | middle_init | text | L M D A J view top 100 | |
DEPARTMENT NUM | department_num | text | Department Number | 50 70 12 60 51 view top 100 |
DEPARTMENT NAME | department_name | text | POLICE DEPARTMENT DEPARTMENT OF PUBLIC WORKS LIBRARY BOARD OF CONTROL HUMAN DEVELOPMENT AND SERVICES FIRE DEPARTMENT view top 100 | |
DIVISION NUM | division_num | text | Division Number | 1200015 5120001 5020001 6021066 5210001 view top 100 |
DIVISION NAME | division_name | text | LIBRARY BOARD OF CONTROL FIRE DEPT-FIRE SUPPRESSION & PREVENTION POLICE DEPARTMENT-UNIFORM PATROL BUREAU HEADSTART EMS-EMERGENCY MEDICAL SERVICES DIVISION view top 100 | |
JOB CODE | job_code | text | 5005 170105 400074 800800 5010 view top 100 | |
JOB TITLE | job_code_description | text | POLICE OFFICER FIRE FIGHTER COLLEGE STUDENT INTERN/CONTRACT POLICE SERGEANT FIRE EQUIP OPER view top 100 | |
CURRENT HIRE DATE | hire_date | calendar_date | Most current date employee hired (Does not include broken service with the City-Parish) | 2010-06-07T00:00:00.000 2009-06-01T00:00:00.000 2007-07-09T00:00:00.000 2008-04-28T00:00:00.000 1988-06-06T00:00:00.000 view top 100 |
EMPLOYMENT END DATE | end_date | calendar_date | End of service date. The employee may have retired, resigned or was terminated. | 2010-08-13T00:00:00.000 2009-07-31T00:00:00.000 2017-06-30T00:00:00.000 2014-07-23T00:00:00.000 2014-07-16T00:00:00.000 view top 100 |
SCHEDULED HOURS | scheduled_hours | number | Scheduled hours per pay period | 80 112 0 84 40 view top 100 |
LONGEVITY PERCENTAGE | longevity_percentage | number | Percentage of pay earned by employee for longevity with City-Parish | 0 0.2 0.05 0.06 0.07 view top 100 |
BASE HOURLY RATE | base_hourly_rate | number | Hourly rate based on pay grade and step | 9 7.25 20.8895 8 10 view top 100 |
TOTAL HOURLY RATE | total_hourly_rate | number | Hourly rate plus longevity and other earning allowances (Educational, Hazardous Pay, etc) | 9 7.25 8 10 8.0525 view top 100 |
OVERTIME HOURLY RATE | overtime_hourly_rate | number | Hourly rate plus allowable overtime earning types multiplied by 1.5 | 13.5 10.875 12 15 12.0788 view top 100 |
EMPLOYMENT STATUS | payroll_status | number | Status in payroll system: 0 - Active, 1 - Temporary Leave (no arrears), 2 - Temporary Leave with Arrears, 3 - Inactive, 4 - Terminated Last Pay Period, 5 - No longer with City-Parish. | 0 5 1 3 view top 100 |
TOTAL BASE PAY | base_pay | number | Annual salary plus longevity and other earning allowances (Educational, Hazardous Pay, etc) | 4799.96 576 21600.02 39147.94 30357.1 view top 100 |
GROSS PAY | gross_pay | number | Base pay plus overtime plus/minus any adjustments | 4799.96 576 21600.02 640 30357.1 view top 100 |
TOTAL OVERTIME HOURS | total_overtime_hours | number | Total number of overtime hours worked for the year | 0 8 4 20 93.12 view top 100 |
TOTAL OVERTIME PAY | total_overtime_pay | number | Total overtime amount earned for the year | 0 181.1 218.29 601.7 48.32 view top 100 |