Data Definitions (HRP1190)

The data columns used in the Budget and Staff Report are defined on this page.

  1. Organization Code-Name:  The primary college or MAU code and name in which the employee is assigned.
  2. Department Code-Name:  The primary department code and name in which the employee is assigned.
  3. Sub-Org Code-Name: The primary sub org department code and name in which the employee is assigned.
  4. Person ID:  An HR/Payroll system generated number linking a person to an assignment. A person with concurrent employment will have multiple PERNRs but only one PERSID.
  5. Personnel Number:  An HR/Payroll system generated number linking a person to an assignment. A person with concurrent employment will have multiple PERNRs but only one PERSID.
  6. Professional Name:  The employee’s professional name as indicated in the HR/Payroll system.
  7. Current Status:  The employee’s current employment status.  
  8. Job Title:  The employee’s primary job title or classification in which the employee is assigned.
  9. Employment Percent:  The percent of employment the employee is working.
  10. Annual Salary:  The employee’s base salary.
  11. FTE Salary:  The base salary for a full year at 100% employment.
  12. Pay Scale Level:  The number level signifying range of possible pay assigned to the employee’s job title or classification.
  13. Personnel Subarea:  A further breakdown of the Personnel Area. The principal organization aspects of HR are controlled at this level, including work schedules, pay scales, public holiday calendar, and wage types.
  14. Employee Group:  Union, Non-Union, Non-Employee/No Pay. The employee group allows you to divide your employees into groups and allows you to define their relationship to the enterprise. It classifies employees into general groups for processing of Payroll, Time, and Benefits.
  15. Employee Subgroup Code:  EBS code for employee subgroup.
  16. Employee Subgroup Name:  A further breakdown of Employee Group. All control features of the Personnel Structure are defined at the Employee Subgroup level including specific payroll calculations for hourly or salaried employees, work schedules, and benefit groupings.
  17. Fund:  The MSU finance system account code allocated to funding of the position.  
  18. Fund Description:  The MSU finance system account code description allocated to funding of the position.
  19. WBS Element:  The pay cost distribution WBS element allocated to funding of the position.  WBS (Work Breakdown Structure) are used to track income for grants and contracts.  
  20. Weighing Percent:  The pay cost distribution weight percentage allocated to funding of the position.
  21. Cost Center:  The cost center code assigned to the MSU finance system fund account.
  22. Fund Org Code-Name:   The organization code and name providing position funding.
  23. Fund Dept Code-Name:  The department code and name providing position funding.
  24. Fund Sub-Org Code-Name:  The sub-org code and name providing position funding.
  25. Acct Effective Date:  The effective date of the MSU finance system fund account.  
  26. Acct Expiration Date:  The expiration date of the MSU finance system fund account.  Note: the column will be blank for fund accounts with an expiration date of 01-01-1900.  
  27. Fringe Benefit Fund:  The MSU finance system fringe benefit account code allocated to funding of the position.