CUPAHRs Salary Surveys Overview of Surveys and Using DataOnDemand

1
CUPA-HRs Salary SurveysOverview of Surveys
and Using DataOnDemand
Ray B. Sizemore, Ph.D. Director, Research
Information Systems CUPA-HR
2

• Provide a brief overview of the CUPA-HR salary
  surveys
• Describe how to use DataOnDemand our real-time
  data analysis system
• Answer your questions

3

• Administrative Compensation Survey (AdComp)
• Since 1967
• National Faculty Salary Survey by Discipline and
  Rank in Four Year Colleges and Universities
  (NFSS) Since 1982
• Mid-Level Administrative and Professional Salary
  Survey (Mid-Level) Since 1998
• Community College Faculty Salary Survey
  (CCFSS) Since 2003
• Comprehensive Survey of College and University
  Health Care and Other Benefits Since 2002

4

• Covered 211 senior staff positions in 2006
• Data collected for each position
• Number of incumbents
• Annualized salary
• Years of service in position
• Hiring source
• Sex
• Minority status
• 2006 Survey 1,345 institutions participated
  reflecting salaries of 67,973 incumbents

If one incumbent
5

• Covered 163 staff and professional positions in
  2006 also collects pay practices data
• Data collected for each position
• Number of incumbents
• FLSA status exempt, non-exempt, both
• Annual salary Average, lowest, highest
• Salary rate structure Min, Midpoint, Max
• 2006 Survey 1,163 institutions participated
  reflecting salaries of 175,305 incumbents

6

• Covers 332 4-digit disciplines - uses
  Classification of Instructional Programs 2000
  Edition
• Collects data by discipline for ranks of Prof,
  Assoc Prof, Assist Prof, Instructor, New
  Assist Prof
• Number of faculty
• Average salary
• Lowest Salary
• Highest salary
• Also collects pay practices data for full-time
  and part-time/adjunct faculty
• 2006 Survey 844 participating institutions
  reflecting salaries of 225,805 full-time faculty
  members

7

• Collects salary data for 4 types of pay
  structures
• Level of education
• Rank
• Discipline unranked faculty and ranked faculty
• Data collected
• Number of faculty
• Average salary
• Lowest Salary
• Highest salary
• Salary rate structure Min, Midpoint, Max
• Also collects pay practices data for full-time
  and part-time/adjunct faculty
• 2006 Survey 205 participating institutions
  reflecting salaries of 37,304 full-time faculty
  members

8

• Pre-loaded
• Institution name, FICE code and Unit ID code
• Carnegie Classification
• Affiliation Public or Private - Indp, Relig,
  For-Profit
• Level of Instruction undergraduate, graduate or
  both
• Metropolitan Statistical Area (MSA)
• NCAA Division
• Collected but only once for all surveys
• Structure type single unit or system
• Total operating budget
• Cost of benefits
• Endowment
• Student FTE enrollment
• Faculty FTE size
• Union or non-union staff and faculty

9

• SurveysOnline (SOL) initiated with 2002-03
  salary surveys
• Application service highly customized for
  CUPA-HR always evolving
• Developed, supported by Peerfocus, LLC
  (http//www.peerfocus.com/)

10

• No paper to mail and collect or data to key
• User ID and Password protected
• Ability to control which surveys a user can
  access
• Prior year respondents able to see last years
  submissions
• Each survey has 1,000s of real-time and
  server-side validations to help ensure accuracy
  of data input
• All errors flagged if serious or fatal must
  be annotated or corrected before survey can be
  submitted
• Back-end data cleaning and data scrubbing tools
  allow us to more easily identify surveys with
  possible errors
• SOL allows us to keep surveys open longer and
  make results available quicker

11

• Survey reports
• National level results published electronically
  as a PDF
• AdComp and Mid-level reports include breakdowns
  by Carnegie, budget, enrollment, affiliation and
  region
• Four-year faculty report provides salaries by
  discipline and rank for all, private, public,
  public union and public non-union institutions
• DataOnDemand (DOD)
• SOL based real-time data analysis system
  originally designed to replace Special Studies
• Special studies
• Custom analyses of data conducted upon request by
  the CUPA-HR research staff

12

• 2006-07
• AdComp Survey
• Added 61 new positions includes 10 for Medical
  Schools, 7 in athletics
• Revised and added IT positions with assistance
  from EDUCAUSE
• Added pay practices section to collect data on
  incentive compensation for 15 senior
  administrative positions
• Mid-Level Survey - added 43 new positions,
  including 24 coaches of specific sports also
  revised and added IT positions.
• Upload capability added for both AdComp and
  Mid-Level surveys
• National Faculty Survey now collecting salary
  data for entry-level and senior-level researchers
  in 10 disciplines
• All reports will show un-weighted salary data to
  ensure compliance with Dept. of Justice Safe
  Harbor guidelines
• 2007-08
• New structure and numbering scheme will be
  implemented for both AdComp and Mid-Level
  surveys. Used in 2006-07 with new positions
• Community College Faculty Survey will be revised
  or possibly discontinued participation in not
  as high as we would like

13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16

• Gives institutions ability to conduct own
  analyses but protects confidentiality available
  for AdComp, Mid-Level and NFS surveys
• Allows users to create own comparison groups -
  from scratch or using the New Group Wizard
• Provides comprehensive set of pre-defined salary
  reports - output format HTML or Excel other
  analytical tools also available
• Available Feb 1 each year with annual
  institutional subscription good from date
  purchased until Jan 31 following year multiple
  users allowed at no extra charge
• Using DOD two-step process create comparison
  group(s) run reports/analyses

17

• Click DataOnDemand in menu bar select option

18

• Click on New Group from Scratch button

19

• Enter partial name of first institution in group
• List of possible institutions will appear
• Select one wanted by checking box
• Search for each remaining institution in group

20

• When done name and save group
• Minimum group size is 8 institutions
• Each group must differ by 3 from all other groups
  created and used at your school even those
  deleted
• Until used a group can be modified without
  restriction

21

• New group saved in your personal file
• Press down arrow to share group with other DOD
  users at your school
• Press minus to add your own school to group
• Public Groups created by CUPA-HR National
  Office

22

• Click on New Group Wizard

23

• Specify your selection criteria, search, name and
  save. Expect to have new expanded Carnegie
  classes in DOD by end of 2006

24

• Click DataOnDemand in menu bar select option

25

• Can access only if report underlined
• Note comment about weighted and un-weighted

26

• AdComp and Mid-Level Surveys
• Current and prior four years available same for
  all reports
• Output-HTML or Excel
• HTML - can select positions to report default
  what your institution reported
• Excel get all positions no choice
• Can run un-weighted or weighted follows DOJ
  Safe Harbor Guidelines
• Option to select addl percentiles
• Report highlights large salary differences can
  change

Demonstration University
27

• Minimum and Maximum salary is the average of
  reported low or high salaries single position
  shows actual low and high

28

• AdComp and Mid-Level Surveys
• change in salaries over a span of two to four
  years
• Output can be HTML or Excel
• Option to select addl percentiles
• Report highlights large salary differences can
  change

29
Demonstration University
30

• AdComp, Mid-Level, and Faculty Surveys
• Data for a single selected position or discipline
  (by rank)
• Can run weighted or un-weighted
• AdComp only option to restrict analyses on the
  basis of selected characteristics

31

• Minimum and Maximum salary is the actual lowest
  and highest salary reported

32

• AdComp, Mid-Level and Faculty Surveys
• Listing of individual salaries by position, or
  discipline (by rank), with average
• Can run weighted or un-weighted
• Output can be HTML or Excel

33

• Highlighted salary is that of the focus
  institution

34

• Faculty survey only
• Salaries results by discipline and rank for
  4-digit CIP codes
• Can run weighted or un-weighted
• Option to select addl percentiles
• Output HTML only

35
(No Transcript)
36

• Faculty survey only
• Salaries results by discipline and rank for
  2-digit CIP codes
• Represents a roll-up of four digit CIPs to the
  2-digit level
• Can run weighted or un-weighted
• Output Excel or HTML
• Option to select addl percentiles

37
(No Transcript)
38

• Faculty survey only
• Calculates overall and discipline specific salary
  statistics by rank
• Comparison group numbers based on faculty
  distribution of focus institution
• Allows apples to apples comparison
• 4-digit index report also available

39

• Report also shows overall salary for all
  disciplines and ranks combined
• And overall salary by rank for all disciplines
  combined

Demonstration University
40
(No Transcript)
41

• AdComp, Mid-Level and Faculty Surveys
• Public shows - we create these to provide data
  not shown in reports
• Existing slide shows can be used with your own
  comparison groups
• You also can create your own slide shows using
  any DOD output but salary reports

42
(No Transcript)
43

• Shows salaries and years in position for system
  CEOs latter not available elsewhere
• No Focus Institution Can always select this
  option on any report if you do not want to show
  your own data
• Note the menu bar you can scroll through one
  slide at a time or jump to a specific one

44

• Tables and Graphs allows you to see multiple
  years of data for a single variable
• Report Writer allows you to see multiple
  variables at once for a single year
• Crosstabs and Frequencies - Used for categorical
  variables (Yes/No). Crosstabs allows you to see
  count and percentage info by cell for two
  variables. Frequencies can be used to produce a
  single report for one or two years and for one or
  multiple variables.
• Of limited use in salary surveys

45

• Available in PDF format at
• www.cupahr.org/surveys/files/DOD_How_to_Manual.pd
  f
• Manual further explains types of reports offered
  in DataOnDemand and provides detailed
  instructions on how to use