Data Definitions - HRP066
The data columns used in the Faculty/Academic Staff and Support Staff Listing Extract report are defined on this page.
- Organization Code: The primary organization code in which the employee is assigned.
- Organization Name: The primary organization name in which the employee is assigned.
- Professional Name: The employee’s professional name as indicated in the HR/Payroll system.
- Person ID: An HR/Payroll system generated number linking a person to all their assignment(s).
- Personnel Number (PERNR): 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.
- Position Number: The position number assigned to the employee’s primary position.
- Job Title: The employee’s primary job title or classification in which the employee is assigned.
- Personnel Area Code: The personnel area code assigned to the employee. MSU1 = MSU US. MSU2 = MSU Dubai.
- Personnel Subarea Code: A further breakdown of Personnel Area. The principal organization aspects of HR are controlled at this level, including work schedules, pay scales, public holiday calendar, and wage types.
- Employee Group Name: 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.
- Employee Subgroup Code & 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.
- Pay Scale Level: The number level signifying range of possible pay assigned to the employee’s job title or classification.
- Seniority Date: The employee’s seniority date as indicated in the HR/Payroll system. Default date is 1/1/1900.
- Continuous Service Date: The date the employee was hired without any breaks in service.
- Years of Service: The number of years the employee has had continuous service with the University.
- Years at Level: The number of years the employee has been assigned their current pay grade (scale) level.
- Degree(s): Education degrees and certificates held by the employee.
- Work Address: The employee’s work location address as indicated in the HR/Payroll system. If the employee has elected to restrict their work location, RESTRICTED will be shown for Address Line 1, remaining work address fields will be blank.
- Permanent Residence Address: The employee’s permanent residence address as indicated in the HR/Payroll system. If the employee has elected to restrict their residence address, RESTRICTED will be shown for Address Line 1, remaining address fields will be blank. RESTRICTED will be shown for Phone Number, if the employee has elected to restrict their telephone number.
- Annual Salary: The employee’s annual salary as indicated in the HR/Payroll system.
- Hourly Rate: The hourly rate at which the employee is paid (if applicable).
- Capacity Utilization Level (FTE): The percent of employment the employee is working.
- Funding Org Code – Name: The organization code and name providing position funding.
- Fund: The finance system account number allocated to funding of the position.
- KFS Sub Account – Name: The finance system sub account code and name allocated to funding of the position (if applicable).
- Weighing Percentage: The pay cost distribution weight percentage allocated to funding of the position.
- Sub Object Code: The finance system sub object code allocated to funding of the position (if applicable).
- Wage Type Name: The wage type based on pay cost distribution.
