Readme
Updated over 2 years ago
‧ Indexed 6 hours ago
Legacy City-Parish Employees
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.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| RACE | race | race | Text | |
| SEX | sex | sex | Text | |
| LAST NAME | last_name | last_name | Text | |
| EMPLOYMENT STATUS | pm_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. |
| ANNUAL SALARY | pm_annual_salary | pm_annual_salary | Number | Annual salary based on paygrade and step, does not include any additional earnings |
| OVERTIME HOURLY RATE | xtr_ot_hr_rate | xtr_ot_hr_rate | Number | Total hourly rate times 1.5 |
| TOTAL HOURLY RATE | xtr_tot_hr_rate | xtr_tot_hr_rate | Number | Base hourly rate plus any additional earnings |
| HOURLY RATE | hourly_rate | hourly_rate | Number | |
| LONGEVITY PERCENTAGE | long_percent | long_percent | Number | |
| SCHEDULED HOURS | scheduled_hours | scheduled_hours | Number | Scheduled hours per pay period |
| YEARS SERVICE | years_service | years_service | Number | Years of service with City-Parish based on current hire date |
| EMPLOYMENT END DATE | term_date | term_date | Calendar date | End of service date. The employee may have retired, resigned or was terminated. |
| CURRENT HIRE DATE | hire_date | hire_date | Calendar date | Most current date employee hired (Does not include broken service with the City-Parish) |
| PAY STEP | pay_step | pay_step | Number | |
| JOB TITLE | job_code_descr | job_code_descr | Text | |
| JOB CODE | job_code | job_code | Text | |
| DIVISION NUM | division_num | division_num | Text | Division Number |
| MIDDLE INITIAL | middle_initial | middle_initial | Text | |
| FIRST NAME | first_name | first_name | Text | |
| EMPLOYEE NUM | employee_num | employee_num | Text | Employee Number |
| DEPARTMENT NAME | department_name | department_name | Text | |
| DIVISION NAME | division_name | division_name | Text | |
| PAY RANGE | pay_range | pay_range | Text | |
| DEPARTMENT NUM | department_num | department_num | Text |
Upstream Metadata