Section V
Everything You Wanted to Know about Salary Data

Salary Data
Received: Monthly
Includes: Last, First, Initial, Employee Number, Appointment Code, Payroll Account, Job Title, Pay Rate, Pay Frequency, Time (FTE status), Building, Room, L-Code, Extension, Start Date
Set: All Employees
Media: Paper, since Dec-79; IBM diskette, since Jan-87

Years Since BS
Received: Monthly
Includes: Highest Degree, Job Code, Year of BS, Pay Frequency, Base Pay, Payroll Account
Set: 200 Series Employees
Media Paper, since Jul-80; IBM diskette since Jan-87

Years in Field & Management Code
Received: Annually (updated in July)
Discontinued: 1999
Includes: Employee Number, Employee Name (Last, First, MI), Years in Field, Mgmt Code
Set: 200 Series Employees
Media: Paper and IBM diskette, since Jan-91

Ranking
Received: Annually (typically in January)
Includes: (By Division & Jobcode Series) Employee Name (Last, First, MI), Rank, Number of Rank Groups
Set: All Employees
Media: Paper, and diskette, since since FY91

Personnel Transactions
Received: Monthly (lists produced weekly)
Includes: Job Starts, Leaves of Absence, Change in Hours Worked, Terminations, Approved Transfers, Change in Status, Lab Address Change, Name/Number Change
Set: All Employees
Media: Paper, since 1974 (early years may be erratic)

Monthly Reports
Includes: Last, First, Initial, Employee Number, and Jobcode (at minimum)
Set: New Hires, Terminations, Salary Changes
Media: Paper, since Feb-89

Salary Analysis "Fiche"
Run: Annually
Includes: Compares the salaries of employees from the January of one year with the January of the next, calculating the difference between the two salaries and the percentage of change.
Set/Media: Microfiche, since Jul-82100, 200, and 300 series employees (4 sorted lists)
Diskette, since 1989All Employees

S Curves
Run: Annually, using April data
Includes: The curves show salary distribution for scientists and engineers are derived by taking the salaries of all 200 series employees, and ordering them from the highest, down to the lowest. The percentile for a given salary is the percent of employees with salaries that are below this particular salary. (Note: This percentile should not be confused with those used in connection with the maturity curves where the independent variable is the Year-since-BS.)
Set: 200 Series Employees
Media: Generated by computer, typically published in the Newsletter

Maturity Curves
Run: Annually, using April data
Includes: The curves show salary distributions for scientists and engineers as a function of years since bachelor's degree. The 20th, 50th, and 80th percentiles are plotted. Smooth curves are fits of 3rd degree polynomials to the noisy raw data.
Set: 200 Series Employees
Media: Generated by computer, typically published in the Newsletter

Membership Database
Updated periodically with the monthly salary data in order to get current information. (Also, used to generate mailing labels.)

Newsletter Labels
Produced with current monthly salary data. Information is sorted to obtain selected set, e.g., 100s, 200s, and 300s, then sorted by Lcode. Some Lcodes are then printed separately because of mailing restrictions, i.e., they are offsite Lcodes.

Ad Hoc Reports
Any reports requested by Board or SPSE members. For example, all physicists hired in 1994, in a particular department (determined via payroll account numbers). Data comparing different years is often requested, particularly for grievances.

Go back to the SPSE Home Page
http://www.spse.org/