Wisconsin State Employees (2010 - 2018)
It is a clone of this request.
Submitted | July 25, 2022 |
MuckRock users can file, duplicate, track, and share public records requests like this one. Learn more.
Communications
From: Ben Goehring
To Whom It May Concern:
Pursuant to the Wisconsin Open Records Act, I hereby request the following records:
Monthly electronic listings of all employees of the Wisconsin Executive Branch from January 1, 2010 to December 31, 2018. Specifically, I am seeking electronic listings of all individuals employed within the offices of the Governor and Lieutenant Governor and all state agencies, commissions, and departments for each month from January 1, 2010 to December 31, 2018.
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, title, department or agency, full-time/part-time status, location, hire date, termination date, civil service status, 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.
Sincerely,
Ben Goehring
From: Wisconsin Department of Administration
Good afternoon,
This message is to acknowledge receipt of your public records request. We are processing your request and will respond as soon as our work is complete.
Sincerely,
[cid:image001.png@01D8A031.39D6A6C0]<https://doa.wi.gov/>
Patricia Reardon | Program & Policy Analyst
Department of Administration
Division of Legal Services
Patricia.Reardon@wisconsin.gov
Direct: (608) 264-9595
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Wisconsin Open Records Act request, copied below, and originally submitted on July 25, 2022. Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
From: Wisconsin Department of Administration
We are working on your request and will respond as soon as our work is complete.
Sincerely,
[cid:image001.png@01D8ABE5.5A0F6B10]<https://doa.wi.gov/>
Patricia Reardon | Program & Policy Analyst
Department of Administration
Division of Legal Services
Patricia.Reardon@wisconsin.gov
Direct: (608) 264-9595
From: Wisconsin Department of Administration
One or more files have been sent to you.
Visit the Workspace<https://wibox.wi.gov:443/anonymous/c9468b92-5aca-4567-9b77-bd8019fdef09/> to retrieve files.
You may be prompted to register an account if authentication is required.
This link will expire on 10/21/2022 6:15:55 PM
Please follow the link to download your records
From: Ben Goehring
Dear Patricia,
I hope you had a great weekend. I am reaching out with a few questions regarding the data I received from you a couple of months ago. I would greatly appreciate if you could either provide clarify the points below or put me in touch with someone who can assist.
1) Does the gross payroll variable include compensatory and overtime pay?
2) In the earliest datasets (from 2010 and 2011, for instance), there are two date variables: start date and class date. I understand the former to mean the date that someone started working for the state and the latter to mean the date someone started working in their particular role. In the later datasets, however, there are three date variables: continuous service date, job code start date, and term date. I understand that term date means the date the employee left the state workforce, but I am unsure about the first two date variables (I cannot find documentation for these variables). Can you please let me know what continuous service date and job code start date mean?
3) Finally, could you please include a file that provides definitions of the variables in the enterprise personnel report? There are variables, such as EEO4 code and DP Unit Code that are difficult to understand without additional documentation.
Thank you very much for your time and assistance.
Best,
Ben
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Wisconsin Open Records Act request, copied below, and originally submitted on July 25, 2022. Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
From: Wisconsin Department of Administration
Good morning, Mr. Goehring,
We received your follow-up email and will get back to you as soon as we can.
Thank you.
[cid:image001.png@01D8FD89.AB5EE720]<https://doa.wi.gov/>
Patricia Reardon | Program & Policy Analyst
Department of Administration
Division of Legal Services
Patricia.Reardon@wisconsin.gov
Direct: (608) 264-9595
From: Ben Goehring
Thanks for your assistance, Patricia! I look forward to your response.
Take care and happy Thanksgiving,
Ben
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Wisconsin Open Records Act request, copied below, and originally submitted on July 25, 2022. Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Wisconsin Open Records Act request, copied below, and originally submitted on July 25, 2022. Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Wisconsin Open Records Act request, copied below, and originally submitted on July 25, 2022. Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Wisconsin Open Records Act request, copied below, and originally submitted on July 25, 2022. Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
From: Wisconsin Department of Administration
Dear Mr. Goehring:
This is in response to your November 6, 2022 email seeking additional information about our September 21, 2022 response to your July 25, 2022 records request. The answers to your questions are provided in red, below:
1) Does the gross payroll variable include compensatory and overtime pay? Gross payroll includes the amount included in the overtime column. The Compensatory Time columns are not presented in dollar amounts but are rather the hours that were earned by the employee in the year. If the employee used any of those hours to take leave during the calendar year, payment for those hours would be included in the gross amount in the same manner as any other leave type used.
2) In the earliest datasets (from 2010 and 2011, for instance), there are two date variables: start date and class date. I understand the former to mean the date that someone started working for the state and the latter to mean the date someone started working in their particular role. In the later datasets, however, there are three date variables: continuous service date, job code start date, and term date. I understand that term date means the date the employee left the state workforce, but I am unsure about the first two date variables (I cannot find documentation for these variables). Can you please let me know what continuous service date and job code start date mean?
*Continuous Service Date – The date on which an employee’s current period of continuous service with the state is considered to have begun, with deductions for authorized breaks in service. For employees who have had no break in service, this will be their original start date.
*Job Code Start Date – This is the same as the class date in the earlier datasets. Each classification is identified by a job code (formerly known as class code)
3) Finally, could you please include a file that provides definitions of the variables in the enterprise personnel report? There are variables, such as EEO4 code and DP Unit Code that are difficult to understand without additional documentation.
* The State Alphabetical Listing of Classifications provides additional information https://dpm.wi.gov/Documents/BCER/alphalst.xlsx - This file is updated regularly to reflect the current classification structure for the State.
Sincerely,
[cid:image001.png@01D9316D.F3118BF0]<https://doa.wi.gov/>
Patricia Reardon | Program & Policy Analyst
Department of Administration
Division of Legal Services
Patricia.Reardon@wisconsin.gov
Direct: (608) 264-9595
-
image001
Files
pages