***THIS DATASET IS NO LONGER UPDATED*** In November 2018, the City-Parish switched to a new payroll system. We are in the final stages of adding employee data from the new system into Open Data BR. This data can be used to see employees as of the last day in the former payroll system. City-Parish employees, both active and inactive, that exist in the City-Parish Payroll System.
This dataset has the following 24 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
EMPLOYEE NUM | employee_num | text | Employee Number | 000086 000094 000124 000132 000140 view top 100 |
LAST NAME | last_name | text | WILLIAMS JOHNSON SMITH BROWN JACKSON view top 100 | |
FIRST NAME | first_name | text | MICHAEL JAMES JOHN ROBERT CHARLES view top 100 | |
MIDDLE INITIAL | middle_initial | text | L M D A J view top 100 | |
DEPARTMENT NUM | department_num | text | 60 70 50 12 51 view top 100 | |
DEPARTMENT NAME | department_name | text | HUMAN DEVELOPMENT AND SERVICES DEPARTMENT OF PUBLIC WORKS POLICE DEPARTMENT LIBRARY BOARD OF CONTROL FIRE DEPARTMENT view top 100 | |
DIVISION NUM | division_num | text | Division Number | 1200015 5020001 5120001 6055026 6021066 view top 100 |
DIVISION NAME | division_name | text | LIBRARY BOARD OF CONTROL POLICE DEPARTMENT-UNIFORM PATROL BUREAU FIRE DEPT-FIRE SUPPRESSION & PREVENTION WIA YOUTH PROGRAM HEADSTART view top 100 | |
JOB CODE | job_code | text | 400074 160105 800800 999409 5005 view top 100 | |
JOB TITLE | job_code_descr | text | COLLEGE STUDENT INTERN/CONTRACT LABORER WIA SUMMER EMPLOYMENT WORKER DISPLACED DISASTER WORKER POLICE OFFICER view top 100 | |
PAY RANGE | pay_range | text | 9999 1050 1040 1150 3090 view top 100 | |
PAY STEP | pay_step | number | 1 12 2 4 3 view top 100 | |
SEX | sex | text | M F U view top 100 | |
RACE | race | text | B W A S O 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 2018-05-24T00:00:00.000 2017-06-05T00:00:00.000 2012-06-01T00:00:00.000 view top 100 |
EMPLOYMENT END DATE | term_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 2018-07-31T00:00:00.000 2006-01-27T00:00:00.000 2017-07-21T00:00:00.000 view top 100 |
YEARS SERVICE | years_service | number | Years of service with City-Parish based on current hire date | 0 1 2 3 4 view top 100 |
SCHEDULED HOURS | scheduled_hours | number | Scheduled hours per pay period | 80 0 58 40 112 view top 100 |
LONGEVITY PERCENTAGE | long_percent | number | 0 0.2 0.05 0.1 0.15 view top 100 | |
HOURLY RATE | hourly_rate | number | 9 8 9.75 10 8.0525 view top 100 | |
TOTAL HOURLY RATE | xtr_tot_hr_rate | number | Base hourly rate plus any additional earnings | 9 8 9.75 10 8.0525 view top 100 |
OVERTIME HOURLY RATE | xtr_ot_hr_rate | number | Total hourly rate times 1.5 | 13.5 12 14.625 15 12.0788 view top 100 |
ANNUAL SALARY | pm_annual_salary | number | Annual salary based on paygrade and step, does not include any additional earnings | 0 16749.2 13572 14706.12 12064 view top 100 |
EMPLOYMENT STATUS | pm_status | number | Employee status with City-Parish: 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. | 5 0 1 view top 100 |