Payroll Across CSU, UC, Community Colleges And Departments
auditor-ca.demo.socrata.com | Last Updated 17 Aug 2017This dataset has the following 28 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Year | year | number | 2015 view top 100 |
| Entity Type | entity_type | text | University of California State Department Community College District California State University view top 100 |
| Entity Group | entity_group | text | Higher Education view top 100 |
| Entity Name | entity_name | text | University of California, Los Angeles Corrections & Rehabilitation, Department of University of California, Davis University of California, San Diego University of California, Berkeley view top 100 |
| Department / Subdivision | department_subdivision | text | UC - Los Angeles UC - Davis UC - San Diego UC - Berkeley UC - San Francisco view top 100 |
| Position | position | text | Student Assistant, Range 0 Correctional Officer, Range K Stdt 2 Stdt 4 Teachg Asst-Gship view top 100 |
| Elected Official | elected_official | number | 0 1 view top 100 |
| Judicial | judicial | number | 0 1 view top 100 |
| Other Positions | other_positions | text | Stdt 2 Teachg Asst-Gship Stdt 3 Gsr-No Rem Stdt 1 view top 100 |
| Min Classification Salary | min_classification_salary | number | 0 20799.6 63084 55200 51492 view top 100 |
| Max Classification Salary | max_classification_salary | number | 0 36981.6 79728 69096 57696 view top 100 |
| Reported Base Wage | reported_base_wage | text | view top 100 |
| Regular Pay | regular_pay | number | 0 4284 18703 55049 78623.88 view top 100 |
| Overtime Pay | overtime_pay | number | 0 8 7 14 12 view top 100 |
| Lump-Sum Pay | lump_sum_pay | number | 0 300 5300 600 2950 view top 100 |
| Other Pay | other_pay | number | 0 1000 500 100 750 view top 100 |
| Total Wages | total_wages | number | 4284 18703 100 300 500 view top 100 |
| Defined Benefit Plan Contribution | defined_benefit_plan_contribution | number | 0 16789.05 25878.12 30483.1 17632.99 view top 100 |
| Employees Retirement Cost Covered | employees_retirement_cost_covered | number | 0 18 19 17 16 view top 100 |
| Deferred Compensation Plan | deferred_compensation_plan | number | 0 2318 2 3 4 view top 100 |
| Health Dental Vision | health_dental_vision | number | 0 18200.28 17649.48 17368.68 6851.64 view top 100 |
| Total Retirement and Health Cost | total_retirement_and_health_cost | number | 0 216 6138 48683.38 94.44 view top 100 |
| Pension Formula | pension_formula | text | N/A 2.00% @ 55 2.5% @ 60 3.00% @ 50 2.5% @ 65 view top 100 |
| Entity URL | entity_url | text | http://compensation.universityofcalifornia.edu/ http://www.spb.ca.gov/ https://www.laccd.edu/Employment/Pages/default.aspx http://bfa.sdsu.edu/hr/ http://www.csun.edu/hr view top 100 |
| Entity Population | entity_population | text | view top 100 |
| Last Updated | last_updated | calendar_date | 2016-08-02T00:00:00.000 2016-07-22T00:00:00.000 2016-07-20T00:00:00.000 2016-09-26T00:00:00.000 2016-08-10T00:00:00.000 view top 100 |
| Entity County | entity_county | text | Los Angeles San Diego Orange Alameda Yolo view top 100 |
| Position Type | position_type | text | Full Time view top 100 |