This dataset has the following 51 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Employee number | a_employee_number | number | Employee number | 7 10 21 22 30 view top 100 |
| Gender | e_gender | text | Gender | Male Female view top 100 |
| Status | a_activity_status | text | Status | A view top 100 |
| Department | a_location_primary | text | Department | 19 23 20 25 24 view top 100 |
| Job class code | a_job_class_code | text | Job class code | 5000 1830 3015 3010 5005 view top 100 |
| Pay type | a_pay_type | number | Pay type | 100 101 103 view top 100 |
| Location | a_location | text | Location | 19 23 20 25 24 view top 100 |
| Union | a_bargain_unit | text | Union | 1000 5000 1500 2000 3000 view top 100 |
| Job calculation code | jb_job_calc_code | text | Job calculation code | 32 01 21 view top 100 |
| Position code | a_position_code | number | Position code | 0 135900001 222000002 301500022 405700001 view top 100 |
| Workdays per year | s_days_per_year | number | Workdays per year | 260.00 0.00 242.67 view top 100 |
| Period hours | s_period_hours | number | Period hours | 81.25 86.67 0.00 121.33 40.00 view top 100 |
| Hours per day | s_hours_per_day | number | Hours per day | 7.50 8.00 0.00 12.00 6.00 view top 100 |
| Pay periods | s_pay_periods | number | Pay periods | 24.0000 view top 100 |
| Frequency | s_frequency | text | Frequency | S view top 100 |
| Pay scale | s_pay_scale | text | Pay scale | A H S view top 100 |
| Annual Salary | a_salary_annual | number | Annual Salary | 0.00 116010.62 130438.20 150005.49 138229.88 view top 100 |
| Period Salary | s_period_salary | number | Period salary | 0.00 4833.78 5434.93 6250.23 5759.58 view top 100 |
| Daily rate | s_daily_rate | number | Daily rate | 0.0000 446.1947 537.5127 618.1460 531.6534 view top 100 |
| Hourly rate | s_hourly_rate | number | Hourly rate | 55.7743 16.6448 44.7927 51.5122 18.7869 view top 100 |
| Organization | a_org | text | Organization | 01191021 01202022 01241055 01197021 01233631 view top 100 |
| Object | a_object | text | Object | 400003 400004 400002 400006 400005 view top 100 |
| Project | s_d_proj | text | Project | view top 100 |
| Start date | s_start_date | calendar_date | Start date | 2008-07-01T00:00:00.000 2008-01-16T00:00:00.000 2008-10-23T00:00:00.000 2013-05-17T00:00:00.000 2017-08-14T00:00:00.000 view top 100 |
| End date | s_end_date | calendar_date | End date | 9999-12-31T00:00:00.000 view top 100 |
| Reference salary | s_reference_salary | number | Reference salary | 0.00 116010.62 130438.20 150005.49 62588.46 view top 100 |
| Base pay | a_base_pay | text | Base pay | Y view top 100 |
| Job Salary | s_salary_job_pay | number | Job Salary | 0.00 116010.62 130438.20 150005.49 138229.88 view top 100 |
| Pay amount | s_line_pay_amount | number | Pay amount | 0.00 4833.78 5434.93 6250.23 5759.58 view top 100 |
| Rate Daily | s_daily_rate_jb | number | Daily rate | 0.0000 446.1947 537.5127 618.1460 531.6534 view top 100 |
| Rate Hourly | s_hourly_rate_jp | number | Hourly rate | 55.7743 16.6448 44.7927 51.5122 18.7869 view top 100 |
| Current Status | s_status | number | Status | 1 4 11 9 10 view top 100 |
| Type Pay | s_emp_pay_type | text | Pay type | view top 100 |
| Hours per year | s_hours_per_year | number | Hours per year | 1950.00 2080.00 0.00 2912.00 1560.00 view top 100 |
| Days per period | s_days_per_period | number | Days per period | 10.83 0.00 10.11 10.00 11.00 view top 100 |
| Job class description | a_job_class_descsh | text | Job class description | POL OFFICE LIFEGUARD FIRE FIGHT FIRE ENGR FIRE CAPT view top 100 |
| Short job class description | a_job_class_desc | text | Short job class description | POLICE OFFICER LIFEGUARD G/III FIRE FIGHTER FIRE ENGINEER POLICE SERGEANT view top 100 |
| Job Status | jb_status | text | Job Status | view top 100 |
| Job pay basis | jb_pay_basis | text | Job pay basis | S view top 100 |
| Job hours per day | jb_hrs_per_day | number | Job hours per day | 0.00 7.50 8.00 view top 100 |
| Job hours per year | jb_hrs_per_yr | number | Job hours per year | 0.00 1950.00 2080.00 view top 100 |
| Employee type | jb_employee_type | text | Employee type | view top 100 |
| Union description short | a_bargain_desc_sh | text | Union description short | LOC 1021 RPOA LOC 1021PT LOC 21 LOC 188 view top 100 |
| Union description | a_bargain_desc | text | Union description | SEIU LOCAL 1021 RICHMOND POLICE OFFICERS ASSOC SEIU LOCAL 1021 PART-TIME IFPTE LOCAL 21 FIRE LOCAL 188 view top 100 |
| Deparment description short | a_location_desc_sh | text | Deparment description short | POLICE PW FIRE COMM SRV LIBRARY view top 100 |
| Department description | a_location_desc | text | Department description | POLICE PUBLIC WORKS DEPARTMENT FIRE COMMUNITY SERVICES LIBRARY view top 100 |
| Inactive | s_inactive | text | Inactive | A view top 100 |
| Fulltime Employees | s_fulltime_percent | number | Fulltime percent | 1.0000 0.4000 0.8000 0.6666 view top 100 |
| Calendar code | ch_calendar_code | number | Calendar code | view top 100 |
| Work start date | s_work_start_date | calendar_date | Work start date | 2008-07-01T00:00:00.000 2008-01-16T00:00:00.000 2008-10-23T00:00:00.000 2013-05-17T00:00:00.000 2017-08-14T00:00:00.000 view top 100 |
| Work end date | s_work_end_date | calendar_date | Work end date | 9999-12-31T00:00:00.000 view top 100 |