Utah State Employees (2018 - 2022)

Ben Goehring filed this request with the Department of Human Resource Management of Utah.

It is a clone of this request.

Status
Completed

Communications

From: Ben Goehring

To Whom It May Concern:

Pursuant to the Government Records Access and Management Act, I hereby request the following records:

Monthly electronic listings of all employees of the Utah Executive Branch from January 1, 2018 to July 31, 2022. Specifically, I am seeking electronic listings of all individuals employed within all state agencies, commissions, and departments for each month from January 1, 2018 to July 31, 2022.

For each month, Iā€™m seeking a spreadsheet, database, or delimited text file(s) ā€” not paper records or a PDF created from data ā€” with the following fields for each employee: full legal name, unique employee identification code, date of birth or age, title, department or agency, race, gender, full-time/part-time status, location, hire date, termination date, civil service status (e.g., classified or unclassified), and gross annual salary. If you cannot produce any of these fields, please let me know and generate only the available variables.

If these data are not available at monthly intervals, please produce the datasets at the most frequent interval possible. For example, if the data is not available monthly, please produce the data at quarterly intervals.

In addition, please include any lookup tables that may be needed to interpret the data. For example, if departments are listed with codes linked to a separate table, I will be happy to join the records myself, rather than require your staff to do so.

I am comfortable working with large data sets and can receive the records in a variety of formats (.dbf, .csv, .mdb, etc).

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 10 business days, as the statute requires.

Sincerely,

Ben Goehring

From: Department of Human Resource Management

Thank you. We are in receipt of your request and will be responding shortly.

Please direct future communications to me, Timothy Evans, Legal Compliance Review Manager, at: tevans@utah.gov.

From: Department of Human Resource Management

Please find most of the requested information attached in xlsx format. Some information was not provided due to private or protected status under Utah's Government Records Access and Management Act (Utah Code section 63G-2-101, et seq.); including such information as an employee's ethnicity, date of birth/age, and employee identification number.

From: Ben Goehring

Thank you! Could you please provide a crosswalk of the values in the "code" column?

Thank you!

Ben

From: Department of Human Resource Management

The codes correspond to employee schedules defined in statute: Utah Code 63A-17-301. Link: https://le.utah.gov/xcode/Title63A/Chapter17/63A-17-S301.html?v=C63A-17-S301_2022050420220701.

For any further correspondence, email me directly: tevans@utah.gov. I have mentioned this before, but your organization continues to email the wrong individual.

Files