City Employee Payroll (Current)
City Employee Payroll (Current)
Payroll information for all Los Angeles City Employees including the City's three proprietary departments: Water and Power, Airports and Harbor. Data is updated bi-weekly by the Los Angeles City Controller's Office. Payroll information for employees of the Department of Water and Power is updated every three months.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| EMPLOYMENT_TYPE | employment_type | employment_type | Text | Employment Type - Full Time, Part Time, or Per Event |
| OVERTIME_PAY | overtime_pay | overtime_pay | Number | Payments attributable to hours worked beyond regular work schedule |
| TOTAL_PAY | total_pay | total_pay | Number | Sum of regular, overtime and all other payments |
| CITY_RETIREMENT_CONTRIBUTIONS | city_retirement_contributions | city_retirement_contributions | Number | Estimated payments made by the City towards employee's retirement. |
| BENEFIT_PAY | benefit_pay | benefit_pay | Number | City contribution for the employee's health care, dental care, vision care, and life insurance |
| GENDER | gender | gender | Text | Gender as self-reported by employee |
| RECORD_NBR | record_nbr | record_nbr | Text | Unique number to identify an employee |
| PAY_YEAR | pay_year | pay_year | Number | Tax year employee was paid. This is not Fiscal Year. |
| MOU | mou | mou | Text | Memorandum of Understanding |
| DEPARTMENT_TITLE | fms_department_title | fms_department_title | Text | Title of City Department |
| ETHNICITY | ethnicity | ethnicity | Text | Ethnicity as self-reported by employee |
| ALL_OTHER_PAY | all_other_pay | all_other_pay | Number | Any payments other than Regular and Overtime. This 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. |
| JOB_TITLE | job_title | job_title | Text | Job Title |
| JOB_STATUS | job_status | job_status | Text | Employee's job status at the time the data was uploaded |
| DEPARTMENT_NO | fms_dept | fms_dept | Number | Department Number in City Payroll System |
| REGULAR_PAY | regular_pay | regular_pay | Number | Regular work hours payment |
| JOB_CLASS_PGRADE | job_class_pgrade | job_class_pgrade | Text | Job Class and Pay Grade |
| MOU_TITLE | mou_title | mou_title | Text | Title of Memorandum of Understanding |