City-Parish employees, both active and inactive, that exist in the City-Parish Payroll System. The information includes employee current pay information, including any special pay. Special pay is earned per pay period. ***In November of 2018, the City-Parish switched to a new payroll system. This dataset contains employee information from this new system. For data prior to 2018, please see the Legacy City-Parish Employees at https://data.brla.gov/Government/Legacy-City-Parish-Employees/gyhq-w3h3
This dataset has the following 29 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| LAST NAME | last_name | text | WILLIAMS JOHNSON SMITH BROWN JONES view top 100 | |
| FIRST NAME | first_name | text | MICHAEL JOHN JAMES CHRISTOPHER ROBERT view top 100 | |
| MIDDLE INIT | middle_initial | text | D M L J A view top 100 | |
| DEPARTMENT NUMBER | department_num | number | Numerical code associated with the department for which an employee works (see department name column) | 5000 1200 5100 7600 6000 view top 100 |
| DEAPRTMENT NAME | department_name | text | Corresponds to the City-Parish department for which an employee works | POLICE DEPARTMENT LIBRARY BOARD OF CONTROL FIRE DEPARTMENT MAINTENANCE HUMAN DEVELOPMENT AND SERVICES view top 100 |
| PAY LOCATION CODE | payloc_num | number | Numerical code associated with the division or location where an employee works (see pay location description column) | 1200 5020 5122 5210 6221 view top 100 |
| PAY LOCATION DESCRIPTION | payloc_name | text | Corresponds to the division or location where the employee works | LIBRARY POLICE-UNIFORM PATROL BUREAU FIRE-SUPPRESSION (112 HRS) EMS-OPERATIONS EMPLOY BR-YOUTH PROGRAM view top 100 |
| JOB CODE | job_code | number | Numerical value associated with an employee's position (job title) | 6030 5005 6510 7005 6520 view top 100 |
| JOB TITLE | job_title | text | PROGRAM PARTICIPANT POLICE OFFICER COLLEGE STUDENT INTERN FIREFIGHTER SECURITY GUARD view top 100 | |
| PAY RANGE | pay_range | number | The pay range or grade that is tied to an employee's current pay (one range may be applicable to multiple positions) | 1150 3090 1050 7201 1110 view top 100 |
| PAY STEP | pay_step | number | The step at which an employee is paid within their pay range (there are 21 steps for each pay range) | 19 6 10 9 7 view top 100 |
| SEX | sex | text | M F view top 100 | |
| RACE | race | text | B W H A T view top 100 | |
| CURRENT HIRE DATE | current_hire_date | calendar_date | Most current date employee hired (Does not include broken service with the City-Parish) | 2018-05-24T00:00:00.000 2022-06-06T00:00:00.000 2019-06-10T00:00:00.000 2022-04-25T00:00:00.000 2023-04-24T00:00:00.000 view top 100 |
| EMPLOYMENT END DATE | employment_end_date | calendar_date | End of service date, the employee may have retired, resigned or was terminated | 2018-07-31T00:00:00.000 2022-07-29T00:00:00.000 2021-01-23T00:00:00.000 2023-08-18T00:00:00.000 2019-08-30T00:00:00.000 view top 100 |
| YEARS OF SERVICE | years_service | number | Years of service with City-Parish based on current hire date | 6.1 2 5 1 2.2 view top 100 |
| SCHEDULED HOURS | scheduled_hours | number | Scheduled hours per pay period | 80 0 112 84 20 view top 100 |
| HOURLY RATE | hrly_rate | number | 10 30 8 9 7.25 view top 100 | |
| ANNUAL SALARY | annual_pay | number | Annual salary based on paygrade and step, does not include any additional earnings | 0 74970.22 69888.78 43398.68 75831.34 view top 100 |
| EDUCATION PAY | edupay | number | Educational pay for employees receiving State Supplemental Pay, or for Municipal Fire and Police employees | 115.38 86.54 43.27 76.92 144.23 view top 100 |
| ENGINEER LICENSE | englicnspay | number | Post license experience allowance for licensed professional engineers | 384.62 192.31 153.85 76.92 115.38 view top 100 |
| CAR ALLOWANCE | carallowpay | number | 184.62 800 view top 100 | |
| MEAL ALLOWANCE | mealallowpay | number | Allowance for EMS employees | 35 view top 100 |
| STATE 2 PERCENT | state2pcnt | number | Statute requiring Fire employees to receive a raise of at least 2% each year after completion of 3 years of continuous service in the Fire Department. Effective for 20 years or until the employee's 23rd year of service. | 54.92 57.67 110.94 231.92 56.08 view top 100 |
| PRISON ASSIGNMENT | prisonpay | number | Employees assigned to work at the Parish Prison | 46.15 view top 100 |
| PERSONNEL STATUS | personnel_status | text | See personnel status description column | FT TP IN PT SN view top 100 |
| PERSONNEL STATUS DESCRIPTION | personnel_status_desc | text | FULL TIME TEMPORARY INTERN PART TIME SEASONAL WORKER view top 100 | |
| EMPLOYMENT STATUS | employment_status | text | Employee's status with the City-Parish. A=Active; I=Inactive | I A B view top 100 |
| UNIQUEID | uniqueid | text | Unique Identifier | E9E37F380FABD046CEF14B47B2AFAEEA30C4F259 923012571801B0F9D6E4D653438C40AF1F450E62 C1EDFF49CE0563DF26DA62E91BB802B536BC5E1B 12ABCD3E84B89D628312E8B096AA83F1E8DD8171 50BFE06B4F18585EE1EFDC73B40CBF59AFD79071 view top 100 |