Data Definitions (HRP1002)

The data columns used in the University Staff Counts reports are defined on this page.  The counts of distinct people in assignments are based on: Person ID, Personnel Subarea, Employee Group, Employee Subgroup, Assignment Type, and Contract Code.

Currently Active and Currently Inactive report definitions.  These reports include all active and inactive employees across the university grouped by employee type. 

  1. Employee Type:  Note this column does not have a header.  Employee Type groups are as follows:  
    1. Faculty
    2. Academic Staff
    3. Post Doc Fellows 
    4. Executive Managers 
    5. Regular Paid Support Staff 
    6. On-Call Support Staff
    7. Temporary Support Staff
    8. Graduate Assistants 
    9. Student Employees  
  2. Employee Group:  The Employee Type is further broken down by employee subgroup.   
  3. Employee Count:  The count of employees by employee subgroup.  
  4. Total:   The total count by Employee Type.  
  5. Grand Total:  The grand total of all Employee Types.  

 

Employee Working Overseas report definitions.  This report includes all active employee types with a work location code of 98 (Out of Country).  These employees are included in the Currently Active counts.

  1. Employee Group:  The employee group name.  
  2. Employee Count:  The count of employees by employee group.  
  3. Total:   The total count of all employees working overseas.

 

Visiting Faculty and Academic Staff report definitions.  This report includes all active faculty and academic staff with an assignment type code 7 (Visiting) and grouped by Employee Group.  These employees are included in the Currently Active counts.

  1. Employee Type:  The employee type name.  
    1. Continuing System Academic Staff = if employee subgroup in AN Academic Staff or AY Academic Staff and contract code = Z8 (Tenure/Contin)
    2. Tenure System Faculty = if employee subgroup in AN Faculty or AY Faculty and contract code = Z8 (Tenure/Contin)
    3. Fixed-Term Academic Staff = if employee subgroup in AN Academic Staff or AY Academic Staff and contract code = Z5 (Fixed Term), Z6 (Contract) or Z7 (Roll/Fixed Cntr)
    4. Fixed-Term Faculty = if employee subgroup in AN Faculty or AY Faculty and contract code = Z5 (Fixed Term), Z6 (Contract) or Z7 (Roll/Fixed Cntr)
  2. Employee Count:  The count of employees by employee type.  
  3. Total:   The total count of all Visiting Faculty and Academic Staff.