Data Definitions (HRP1170)

The data columns used in the Remote Work Agreements for Unit Admins report are defined on this page.  

  1. Organization Code:  The primary college or MAU code in which the employee is assigned.
  2. Organization Name:  The primary college or MAU name in which the employee is assigned.
  3. Department Code:  The department code in which the employee is assigned.
  4. Department Name:  The department name in which the employee is assigned.
  5. Sub-Org Code:  The sub-org code in which the employee is assigned.
  6. Sub-Org Name:  The sub-org name in which the employee is assigned.
  7. Person ID:  An HR/Payroll system generated number linking a person to all their assignments.  
  8. Personnel Number:  An HR/Payroll system generated number linking a person to their benefits eligible assignment.
  9. Professional Last Name:  The last name of the employee as indicated in the HR/Payroll system.  
  10. Professional First Name:  The first name of the employee as indicated in the HR/Payroll system.  
  11. Position#:  The position number in which the employee is assigned.  
  12. Position:  The position title assigned to the position number in which the employee is assigned.
  13. Job Title:  The job title assigned to the employee based on their assigned job code.  
  14. Personnel Subarea:  Personnel subarea assigned to the employee.  The principal organization aspects of HR are controlled at this level, including work schedules, pay scales, public holiday calendar, and wage types.  
  15. 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.  
  16. Employee Subgroup:  Employee subgroup assigned to the employee.  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. Payroll Area:  The payroll area (Monthly, BiWeekly, or Non-Pay) assigned to the employee.
  18. Primary Assignment End Date:  The end date of the employee’s primary assignment.  
  19. Supervisor (RWA Start Date):  The supervisor of the employee at the start of their remote work agreement.  NOTE:  If the employee transfers to the organization and already had a remote work agreement in place, the starting supervisor will be blank, i.e., supervisor from prior organization is not listed.  
  20. Supervisor (RWA End Date):  The current supervisor of the employee.   
  21. Remote Work Type:  The remote work type assigned to the employee.  
  22. Remote Work Addr Start Date:  The start date of the remote work agreement with the employee.  
  23. Remote Work Addr End Date:  The end date of the remote work agreement with the employee.
  24. Remote Work Addr Line 1:  The employee’s remote work agreement address line 1.  Will be blank for employee’s who have selected to restrict their remote work address.
  25. Remote Work Addr Line 2:  The employee’s remote work agreement address line 2.  Will be blank for employee’s who have selected to restrict their remote work address.
  26. Remote Work City:  The employee’s remote work agreement city.  Restricted will be shown for employee’s who have selected to restrict their remote work address.
  27. Remote Work State:  The employee’s remote work agreement state.  Restricted will be shown for employee’s who have selected to restrict their remote work address.
  28. Remote Work Zip Code:  The employee’s remote work agreement zip code.  Will be blank for employee’s who have selected to restrict their remote work address.
  29. Remote Work Country:  The employee’s remote work agreement country.  Restricted will be shown for employee’s who have selected to restrict their remote work address.
  30. Remote Work Phone #:  The employee’s remote work agreement phone number.  Will be blank for employee’s who have selected to restrict their remote work phone number.
  31. Admin Addr Line 1:  Administrative Address Line 1 of the primary department assigned to the employee.   Will be blank for employee’s who have selected to restrict their work address.   
  32. Admin Addr Line 2:   Administrative Address Line 2 of the primary department assigned to the employee.  Will be blank for employee’s who have selected to restrict their work address.
  33. Admin Addr City:  Administrative City of the primary department assigned to the employee.  Restricted will be shown for employee’s who have selected to restrict their work address.
  34. Admin Addr State:  Administrative State of the primary department assigned to the employee.  Restricted will be shown for employee’s who have selected to restrict their work address.
  35. Admin Addr Zip Code:  Administrative Zip Code of the primary department assigned to the employee.  Will be blank for employee’s who have selected to restrict their work address.
  36. Admin Addr Country:  Administrative County of the primary department assigned to the employee.  Restricted will be shown for employee’s who have selected to restrict their work address.
  37. Admin Addr Phone #:  Administrative Phone number of the primary department assigned to the employee.  Will be blank for employee’s who have selected to restrict their work phone number.
  38. Off Campus Code:  The code assigned to the employee’s off-campus work location (if applicable).  
  39. Off Campus Name:  The employee’s off-campus work location (if applicable).
  40. Work Loc1 Addr Line 1:  Employee’s work location address line 1.  Will be blank for employee’s who have selected to restrict their work address.
  41. Work Loc1 Addr Line 2:  Employee’s work location address line 2.  Will be blank for employee’s who have selected to restrict their work address.
  42. Work Loc1 City:  Employee’s work location City.  Restricted will be shown for employee’s who have selected to restrict their work address.
  43. Work Loc1 State:  Employee’s work location State.  Restricted will be shown for employee’s who have selected to restrict their work address.
  44. Work Loc1 Zip Code:  Employee’s work location Zip Code.  Will be blank for employee’s who have selected to restrict their work address.
  45. Work Loc1 Country:  Employee’s work location Country.  Restricted will be shown for employee’s who have selected to restrict their work address.
  46. Work Loc2 Addr Line 1:  Employee’s second work location address line 1.  Will be blank for employee’s who have selected to restrict their work address.
  47. Work Loc2 Addr Line 2:  Employee’s second work location address line 2.  Will be blank for employee’s who have selected to restrict their work address.
  48. Work Loc2 City:  Employee’s second work location City.  Restricted will be shown for employee’s who have selected to restrict their work address.
  49. Work Loc2 State:  Employee’s second work location State.  Restricted will be shown for employee’s who have selected to restrict their work address.
  50. Work Loc2 Zip Code:  Employee’s second work location Zip Code.  Will be blank for employee’s who have selected to restrict their work address.
  51. Work Loc2 Country:  Employee’s second work location Country.  Restricted will be shown for employee’s who have selected to restrict their work address.