City Employee Payroll (2013-2018)
City Employee Payroll (2013-2018)
Note this dataset is no longer being updated. Please use the updated payroll dataset with current pay year information: https://controllerdata.lacity.org/Payroll/City-Employee-Payroll-Current-/g9h8-fvhu.
Payroll information for all Los Angeles City Employees including the City's three proprietary departments: Water and Power, Airports and Harbor. Data is updated on a quarterly basis by the Los Angeles City Controller's Office. Payroll information for employees of the Department of Water and Power is provided by the Department.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Job Class Title | job_class_title | job_class_title | Text | |
| FMS Department | fms_department | fms_department | Text | Department number in City Financial Management System |
| Job Class Link | job_class_link | job_class_link | URL | Click this hyperlink to view the job class description |
| Total Payments | total_payments | total_payments | Number | Total earnings for the year |
| Q4 Payments | q4_payments | q4_payments | Number | Payments for the fourth quarter of the year from October 1 to December 31 |
| Q3 Payments | q3_payments | q3_payments | Number | Payments for the third quarter of the year from July 1 to September 30 |
| Q2 Payments | q2_payments | q2_payments | Number | Payments for the second quarter of the year from April 1 to June 30 |
| Q1 Payments | q1_payments | q1_payments | Number | Payments for the first quarter of the year from January 1 to March 31 |
| Hourly or Event Rate | hourly_or_event_rate | hourly_or_event_rate | Number | Hourly Earnings Rate or Per Event Rate based on Projected Annual Salary |
| Lump Sum Pay | lump_sum_pay | lump_sum_pay | Number | Lump sum payouts for special purposes - retirement payouts, back pay, etc.; typically not pensionable |
| Benefits Plan | benefits_plan | benefits_plan | Text | |
| Longevity Bonus Pay | longevity_bonus_pay | longevity_bonus_pay | Number | Payments attributable to years of service; typically pensionable |
| Temporary Bonus Pay | temporary_bonus_pay | temporary_bonus_pay | Number | Payments attributable to temporary bonuses; typically not pensionable |
| MOU | mou | mou | Text | Memorandum of Understanding |
| Job Class | job_class | job_class | Text | |
| Row ID | row_id | row_id | Text | Unique Identifier for each row |
| Payroll Department | payroll_department | payroll_department | Text | Department Number in City Payroll System |
| Other Pay (Payroll Explorer) | pay_other_actual | pay_other_actual | Number | Other Pay includes bonuses, adjustments, and lump sum payouts. Examples of bonuses include Permanent, Longevity, and Temporary Bonuses. Lump Sum Pay includes significant one-time payouts due to retirement, lawsuit settlements, or other adjustments |
| Average Benefit Cost | average_benefit_cost | average_benefit_cost | Number | The total average City contribution for the employee's health care, dental care and life insurance |
| Average Basic Life | average_basic_life | average_basic_life | Number | Average cost to the City to provide basic life insurance to the employee |
| % Over Base Pay | percent_over_base_pay | percent_over_base_pay | Number | Percentage of payment in excess of Base Pay which may include bonuses and other payouts |
| Overtime Pay | overtime_pay | overtime_pay | Number | Payments attributable to hours worked beyond regular work schedule |
| Other Pay & Adjustments | other_pay_adjustments | other_pay_adjustments | Number | Payments based on other pay codes or adjustments that do not fall into another category |
| MOU Title | mou_title | mou_title | Text | Title of Memorandum of Understanding |
| Average Health Cost | average_health_cost | average_health_cost | Number | Average cost to the City to provide health care to the employee |
| Average Dental Cost | average_dental_cost | average_dental_cost | Number | Average cost to the City to provide dental care to the employee |
| Projected Annual Salary | projected_annual_salary | projected_annual_salary | Number | Budgeted pay amount. Used for pension contribution calculations |
| Year | year | year | Number | Calendar Year |
| Payments Over Base Pay | payments_over_base_pay | payments_over_base_pay | Number | Payments in excess of Base Pay which may include bonuses and other payouts |
| Base Pay | base_pay | base_pay | Number | Base compensation for hours worked |
| Permanent Bonus Pay | permanent_bonus_pay | permanent_bonus_pay | Number | Payments attributable to permanent bonuses; typically pensionable |
| Record Number | record_number | record_number | Text | |
| Department Title | department_title | department_title | Text | Title of City Department |
| Pay Grade | pay_grade | pay_grade | Text | Pay Grade for the Job Class |
| Employment Type | employment_type | employment_type | Text | Employment Type - Full Time, Part Time, or Per Event |