About this Dataset

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.
Organization: City of Baton Rouge
Last updated: 2020-11-12T15:00:01.050479
Tags: employees, job-title, salary

Tables

Table 1

@usgov.city_of_baton_rouge_legacy_city_parish_employees.table_1

1.07 MB
24,754 rows
22 columns

CREATE TABLE table_1 (
  "employee_num" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_initial" VARCHAR,
  "department_num" BIGINT,
  "department_name" VARCHAR,
  "division_num" BIGINT,
  "division_name" VARCHAR,
  "job_code" BIGINT,
  "job_title" VARCHAR,
  "pay_range" BIGINT,
  "pay_step" BIGINT,
  "current_hire_date" TIMESTAMP,
  "employment_end_date" TIMESTAMP,
  "years_service" BIGINT,
  "scheduled_hours" DOUBLE,
  "longevity_percentage" DOUBLE,
  "hourly_rate" DOUBLE,
  "total_hourly_rate" DOUBLE,
  "overtime_hourly_rate" DOUBLE,
  "annual_salary" DOUBLE,
  "employment_status" BIGINT
);