I haven’t posted here in a long time. I am going to try to make short posts about various projects I am working on for my own records (so the expected audience is simply future me). If anyone else finds anything of interest, that will be a bonus.
Yesterday I had time to get back to working with salary information (from https://www.legis.iowa.gov/publications/fiscal/salaryBook) for Equity at Iowa. Previously I had added the job categories and classifications (with vlookups) using the information on the University’s human resources site (https://hr.uiowa.edu/pay/merit-plan and https://hr.uiowa.edu/professional-pay for salary ranges and https://hr.uiowa.edu/pay/merit and https://hr.uiowa.edu/professional-pay/classifications-by-pay-level for the pay level for each job classification). I pulled this information last year as well.
I would like gather this information from previous years as well to better trace how pay ranges have (or haven’t) increased over time. The HR website changed so it took longer to track down on the Internet Archive than I first expected/ Merit information was here http://www.uiowa.edu/hr/classcomp/pay/index.html. Prior to this, the URL was http://www.uiowa.edu/~hrpersvc/classpay.html. Unfortunately, IA did not capture the PDFs for 2005 & 2006 and the site was not archived from 2002-2004. If I want the missing information, I will need to request it from HR. I am particularly interested in how library assistant salary ranges and librarian salary ranges have changed across time.
Last year I used directory information match faculty members with departments and colleges. This year I used information from the general catalog. This data includes all the departments when people are in more than one. It also includes the year a faculty member started and the year of their current appointment, as well as degree dates and conferring institutions. We will parse this data in the coming year to see what else we can learn. This data needs to be split into appropriate columns to make use of it. The names also need to be formulated in such a way as to match the salary information. I need to extract this information from the PDFs for previous years in our repository so that we can better see changes across time.