Tennessee State Employees (2019 - 2022)

Kent Hoover filed this request on behalf of Ben Goehring with the Department Of Human Resources of Tennessee.
Status
Completed

Communications

From: Ben Goehring

To Whom It May Concern:

Pursuant to the Tennessee Public Records Act, I hereby request the following records:

Copies of the State of Tennessee employee salary data published on the "Transparent Tennessee" website (https://salary.app.tn.gov/public/searchsalary) for each month from January 2019 through March 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 every employee who worked in the Tennessee Executive Branch: Agency Name, Last Name, First Name, Job Title, Comp Rate, Comp Rate Period, Full/Part, and Bonus. If possible, please also provide information on employees' race/ethnicity, sex, hire date, and termination date. If these latter variables are unavailable, please exclude them and provide only the variables listed above.

If the data is not available for every month, please provide it at the most frequent interval possible. For instance, if the data is not available for each month, please provide quarterly listings. If unavailable quarterly, please provide bi-annual listings.

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 7 business days, as the statute requires.

Sincerely,

Kent Hoover, a citizen of Tennessee, in coordination with Ben Goehring.

From: Department Of Human Resources

Good Afternoon,

Please use the link below to submit your request.

https://stateoftennessee.formstack.com/forms/records_request

From:

Thank you for submitting your public records request to the State of
Tennessee Department of Human Resources. Your request has been
received electronically. An employee with the Records Department will
respond within 7 business days to verify that your request has been
approved, the date you should expect your request to be completed and
any fees associated with your request (if applicable).

If the request is not approved, the Records Department will respond
with an explanation.

For a full explanation of the Records Policy, please visit the below
site. Thank you,

https://www.tn.gov/content/dam/tn/hr/policy/12-042%20Public%20Records%20in%20the%20Custody%20of%20the%20Department%20of%20Human%20Resources%20(rev.%20040119).pdf

From: Department Of Human Resources

Good afternoon,

Please see the current response to the open records request you submitted.

[cid:image001.png@01D86AC3.461FB640]
TERESA JONES | HR Program Manager
Records Management
Tennessee Tower, 17th Floor
312 Rosa L. Parks Blvd.
Nashville, TN 37243
p. 615-741-2854 f. 615-401-7685
teresa.jones@tn.gov<mailto:teresa.jones@tn.gov>

From: Department Of Human Resources

Teresa Jones would like to recall the message, "Records Request".

From: Department Of Human Resources

Good morning,

The Transparent TN data is compiled semi-annually. Due to personnel issues in 2019 and 2021, the data was only compiled one time in each of those years. The information concerning bonuses did not begin to appear on the Transparent TN website until 2021. Therefore, the data before 2021 does not include bonus information. Each tab has a summary count of employee's ethnicity and gender, and all other information is aligned with the employee record.

[cid:image001.png@01D86C25.C84D2B80]
TERESA JONES | HR Program Manager
Records Management
Tennessee Tower, 17th Floor
312 Rosa L. Parks Blvd.
Nashville, TN 37243
p. 615-741-2854 f. 615-401-7685
teresa.jones@tn.gov<mailto:teresa.jones@tn.gov>

From: Ben Goehring

Thanks so much for your help with this request, Teresa! I really appreciate it.

Sincerely,
Ben Goehring

Files

pages

Close