This dataset has the following 34 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Employee number | a_employee_number | number | Employee number | 3808 2482 1070 2742 1360 view top 100 |
| EEO function | e_eeo_function | text | EEO function | 06 04 15 05 12 view top 100 |
| Marital Status | e_marital_status | text | Marital Status | Single Married Widowed view top 100 |
| Gender | e_gender | text | Gender | Male Female view top 100 |
| EEO race | e_eeo_race | text | EEO race | Black Caucasian Hispanic Asian Other Race view top 100 |
| EEO full time/part time status | e_eeo_part_full_t | text | EEO full time/part time status | F P T view top 100 |
| Activity status | e_activity_status | text | Activity status | Inactive Active Pension Benefits Only view top 100 |
| Date inactive | e_inactive_date | calendar_date | Date inactive | 2019-09-03T00:00:00.000 2009-12-30T00:00:00.000 2017-08-31T00:00:00.000 2021-02-24T00:00:00.000 2014-06-30T00:00:00.000 view top 100 |
| Termination code | e_terminated_code | text | Termination code | 400 700 100 D 500 view top 100 |
| Termination date | e_terminated_date | calendar_date | Termination date | 2009-12-31T00:00:00.000 2020-04-01T00:00:00.000 2017-09-01T00:00:00.000 2014-07-01T00:00:00.000 2019-11-01T00:00:00.000 view top 100 |
| Union | a_bargain_primary | text | Union | 1500 1000 5000 2000 3000 view top 100 |
| Organization | a_org_primary | text | Organization | 01191021 01202022 01241055 65115090 01251051 view top 100 |
| Project | a_project_primary | text | Project | view top 100 |
| Location | a_location_primary | text | Location | 19 25 23 20 24 view top 100 |
| Department description | a_location_p_desc | text | Department description | POLICE COMMUNITY SERVICES PUBLIC WORKS DEPARTMENT FIRE LIBRARY view top 100 |
| Department short description | a_location_p_short | text | Department short description | POLICE COMM SRV PW FIRE LIBRARY view top 100 |
| Job code | a_job_code_primary | text | Job code | 5000 1880 1860 1830 1800 view top 100 |
| Job class description short | a_job_class_descsh | text | Job class description short | POL OFFICE MNTAIDEII REC PRG LD ADMIN ST I LIFEGUARD view top 100 |
| Job class description | a_job_class_desc | text | Job class description | POLICE OFFICER MAINTENANCE AIDE II/III RECREATN PGM LEADER G/III LIFEGUARD G/III ADMN STUDENT INTERN G/III view top 100 |
| Status | e_status | number | Status | 1 9 11 4 10 view top 100 |
| Status Long Descriptor | status_long_descriptor | text | Long desciption of employment status code | Full Time Permanent Part Time 780-999 Hours Part Time Group III F.T.S. Probationary Part Time <780 Hours view top 100 |
| Hire date | e_hire_date | calendar_date | Hire date | 1989-01-01T00:00:00.000 2017-06-01T00:00:00.000 2010-03-01T00:00:00.000 2007-08-01T00:00:00.000 2018-05-30T00:00:00.000 view top 100 |
| Permanent date | e_permanent_date | calendar_date | Permanent date | 9999-12-31T00:00:00.000 2014-11-17T00:00:00.000 2008-04-10T00:00:00.000 1999-12-31T00:00:00.000 2017-08-14T00:00:00.000 view top 100 |
| Service date | e_service_date | calendar_date | Service date | 1989-01-01T00:00:00.000 2016-06-10T00:00:00.000 2013-05-17T00:00:00.000 2010-03-01T00:00:00.000 2006-10-10T00:00:00.000 view top 100 |
| Department | e_work_location | text | Department | 190 250 200 330 240 view top 100 |
| Object | a_object_primary | text | Object | 400006 400003 400004 400002 400005 view top 100 |
| Original hire date | e_orig_hire_date | calendar_date | Original hire date | 1989-01-01T00:00:00.000 2006-10-10T00:00:00.000 2013-05-17T00:00:00.000 2012-03-30T00:00:00.000 2009-04-20T00:00:00.000 view top 100 |
| Degree | e_adv_del | text | Degree | E P A B C view top 100 |
| White | prem_white | text | White | N Y view top 100 |
| Hawaiian | prem_hawaiian | text | Hawaiian | N Y view top 100 |
| Black | prem_black | text | Black | N Y view top 100 |
| Asian | prem_asian | text | Asian | N Y view top 100 |
| Hispanic | prem_hispanic | text | Hispanic | N Y view top 100 |
| American Indian | prem_amerind | text | American Indian | N Y view top 100 |