2015 University Of California Payroll (Geocoded)
auditor-ca.demo.socrata.com | Last Updated 30 Jan 2019This dataset has the following 31 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 view top 100 |
| Entity Group | entity_group | text | Higher Education view top 100 |
| Entity Name | entity_name | text | University of California, Los Angeles University of California, Davis University of California, San Diego University of California, Berkeley University of California, San Francisco 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 | Stdt 2 Stdt 4 Teachg Asst-Gship Stdt 3 Stdt 1 view top 100 |
| Elected Official | elected_official | text | FALSE view top 100 |
| Judicial | judicial | text | FALSE 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 view top 100 |
| Max Classification Salary | max_classification_salary | number | 0 view top 100 |
| Reported Base Wage | reported_base_wage | text | view top 100 |
| Regular Pay | regular_pay | number | 0 4284 18703 55049 14418 view top 100 |
| Overtime Pay | overtime_pay | number | 0 8 7 12 31 view top 100 |
| Lump-Sum Pay | lump_sum_pay | number | 0 5300 3168 838 2339 view top 100 |
| Other Pay | other_pay | number | 0 500 750 1000 640 view top 100 |
| Total Wages | total_wages | number | 4284 18703 7564 14418 2142 view top 100 |
| Defined Benefit Plan Contribution | defined_benefit_plan_contribution | number | 0 7480 5726 6861 5132 view top 100 |
| Employees Retirement Cost Covered | employees_retirement_cost_covered | number | 0 view top 100 |
| Deferred Compensation Plan | deferred_compensation_plan | number | 0 2318 350 1603 525 view top 100 |
| Health Dental Vision | health_dental_vision | number | 0 7765 21697 7773 8206 view top 100 |
| Total Retirement and Health Cost | total_retirement_and_health_cost | number | 0 6138 216 6315 325 view top 100 |
| Pension Formula | pension_formula | text | N/A 2.5% @ 60 2.5% @ 65 3% @ 50 1.25% @ 60 view top 100 |
| Entity URL | entity_url | text | http://compensation.universityofcalifornia.edu/ view top 100 |
| Entity Population | entity_population | text | view top 100 |
| Last Updated | last_updated | calendar_date | 2016-07-22T00:00:00.000 2016-07-20T00:00:00.000 2016-09-26T00:00:00.000 2016-08-10T00:00:00.000 2016-07-12T00:00:00.000 view top 100 |
| Entity County | entity_county | text | Los Angeles Yolo San Diego Alameda San Francisco view top 100 |
| Position Type | position_type | text | Full Time view top 100 |
| Location 1 | location_1 | location | view top 100 |
| Assembly District | assembly_district | text | District 54 District 4 District 78 District 15 District 74 view top 100 |
| Senate District | senate_district | text | District 26 District 3 District 39 District 9 District 37 view top 100 |