Business Intelligence Competency Center Common View  -  Deep Understanding  -  Better Decisions

HR Stars

There are six stars, refreshed nightly:

  1. Employee Appointment
  2. Employee Action
  3. Employee Leave
  4. Employee Quotas
  5. Compensation Plan
  6. Payroll Charge

Each star also has a snapshot, taken at the end of each month. 

Stars reflect retro-dated corrections; snapshots will not.

Employee Appointment Star

Star Benefits:

  • Holds a record for each instance of employment since the inception of SAP.  Data is derived from Infotype 0001 (Organizational Assignment)
  • Includes descriptive information such as hire date, position title, job title, employee group

Advantages:

  • Trend employment levels over time
  • Compare numbers or FTE of employees across areas in a common way

Examples of Questions this Star Would Answer

  1. What is my headcount for current employees by department?
  2. Is the employee’s appointment faculty or administrative?
  3. What are an employee’s current appointments?
  4. What is an employee’s primary appointment?
  5. Is this a paid or non-paid appointment?
  6. How long has an employee held the current (or any) position? (Related to SAP data, no legacy data)
  7. Is this a temporary or regular appointment?
  8. Who hold concurrent appointments?
  9. What is employee hire-to-retire appointment picture? (Note: complete history would require legacy data.)
  10. What is an employee’s appointment history? (Note: complete history would require legacy data.)
  11. What employees have administrative appointments?
  12. What employees have faculty appointments?
  13. What employees have both admin and faculty appointments?
  14. What is the count of tenured faculty appointments?
  15. What are the different jobs by employee?
  16. Who held a given position or who has been in a particular position over time? (Note: complete history would require legacy data.)
  17. What is the ratio of faculty to staff?
  18. How many years has a person been in a particular position?
  19. How many different faculty are in a particular department by rank (Full Professor, Associate Professor, etc.)?
  20. What is FTE by department?
  21. Who hold AY appointments by area?
  22. Who hold FY appointments by area?
  23. What campus is the employee position assigned to?
  24. Who is the supervisor for a particular appointment?
  25. What is the org unit of the employee’s primary appointment?

Employee Action Star

Star Benefits:

  • Includes employee action by appointment.  Infotype 0000(Actions)
  • Examples include Separation, Change in Pay or Transfer
  • Includes Personnel Action Types as well as Action Reasons
  • By Action Date or by Changed Date

Advantages:

  • Useful when looking at turnover, employee histories or details of employee actions

Examples of Questions this Star Would Answer

  1. What is the action history for a particular employee?
  2. What is the reason a person has left the University?
  3. Did the person leave a position for another position in the university?
  4. Did an employee quit when a position was reclassified?
  5. Did a person leave a position due to advancement?
  6. What is turnover by position by employee type by campus and what was the reason for leaving?
  7. How often is a position turned over?
  8. Who on tenure track received a promotion?

Employee Leave Star

Star Benefits:

  • Consists of absences taken by appointment 
  • Provides employee’s current and historic leaves since the inception of SAP in June 2007
  • Estimated cost factor which can be used to calculate the cost associated with the leave
  • PA20 with various Infotypes (IT):
    • IT 2001 Absences
    •  IT0007 Display Planned Working Time
    • IT0008 Basic Pay
    • IT0027 Cost Distribution
    • IT0000 Actions
    • IT0001 Organizational Assignment

The employee leave may also be found using the following t-codes:

  • ZHRTM_CATS_DIS Display Working Times
  • ZHR_ESS_TIMESUPERBO
  • ZHR_FMLA_TESTER

Advantages:

  • Used for reporting on various leaves and associated costs
  • Will produce leave reports by Organization, Cost Center, Employee etc for actual leaves taken

Examples of Questions this Star Would Answer

  1. Who is on sick (or any specific) leave and what is it costing us?
  2. What is the total cost of vacation time to the university?
  3. Who has taken all of their personal holidays for the year?
  4. Who is on leave?
  5. What are total leaves by exempt status for a department?
  6. Who has taken leave/sabbatical by position, rank, and tenure?
  7. What is the sick leave liability by type in dollars by organization? (non-exempt)
  8. Does the master record reconcile with the FMLA workbench?
  9. Did an employee have a previous FMLA?
  10. What is the headcount on paid parental leave by department by year?
  11. What does parental leave cost the organization by department?
  12. What does parental leave cost the organization by employee?
  13. How many people are on FMLA, by employee, by department, by year for all types of FMLA?

Employee Quotas Star

Star Benefits:

  • Consists of employee quota by quota type by appointment and CUL
  • Provides an employee’s current quota balances
  • Estimated cost fact which can be used to calculate the cost associated with the quota usage and payouts
  • PA20 with various Infotypes  (IT)
    • IT2006 Quota Balances
    • IT0008 Basic Pay
    • IT0027 Cost Distribution
    • IT0000 Actions
    • IT0001 Organizational Assignment
    • IT0416 Time Quota Compensation
    • IT2013 Quota Correction

The employee leave quota may also be found using the following t-codes:

  • ZHR_ESS_TIMESUPERBO
  • ZHR_FMLA_TESTER
  • PT_QTA10
  • PT50
  •  Z_PY_REMUN_STMT_SAR

 

Advantages:

  • Used for reporting on quota balances, including the costs/liabilities associated with these balances
  • Will produce quota reports by Organization, Cost Center, Employee, etc..

Examples of Questions this Star Would Answer

  1. What would be the total estimated cost of vacation (or other) time paid out upon a person’s departure from the university? (Liability)
  2. What are total estimated quota payouts by exempt staff for a department?
  3. What is the estimated sick leave liability by type in dollars by organization? (non-exempt)
  4. What is the estimated parental leave quota liability for the organization by department?
  5. Who has taken all of their personal holidays for the year?

Payroll Charge Star

Star Benefits:

  • Primary source is ZHR_PAY_POSTING in SAP. Each pay period, multiple SAP Infotypes (IT) processed to create a payroll. Posting the payroll is the process of taking the amount of pay, fringe benefits, etc. for each personnel number (PERNR) and prorating it to the various University accounts as specified in the account distributions (IT 0027). The distributions identify the cost objects and the percentage each cost object combination will be charged for the payroll paid to each staff member.
  • Because the data is used primarily to get the payroll expenses posted to the University’s official accounting records, the Payroll Charge file belongs to Human Resources/ Payroll/ Costing/ Accounting Services

Advantages:

  • Identifying data such as cost objects, pay periods
  • Charge information containing pay and benefit dollar amounts.  For hourly staff, there is also information about hours worked.

Examples of Questions this Star Would Answer

  1. How much salary is paid for by research (or any fund type) for a specific fund center?
  2. What is the payroll breakdown for an org unit by commitment item, cost center?
  3. How much fringe benefits was charged to your general fund account, by employee group?
  4. How much overtime has your department paid out this year compared to the same time last year?

Compensation Star

Star Benefits:

  • Designed to estimate future payroll runs.  At any time, may be used to look into the future up to 12 months to estimate future salary and/or recurring and non-recurring payments, and it can look back in time and compare to historic payroll runs to identify retro cost distribution that will affect accounts in future payroll runs.

Advantages:

  • Projecting up to 12 future months of payments on your accounts
  • Anticipating net effect of retro cost distribution adjustments (PAR’s & CD-01’s) to hit with payroll.
  • Determining the amount of Summer Salary, Tech Allowances, Moving Allowances, or any other recurring or non-recurring payment entered into SAP
  • Reporting on FTE levels by funding sources for a past fiscal year for a specific area

Examples of Questions This Star Would Answer

  1. How much salary is projected to be paid on your general fund account?
  2. What is the projected technology allowance for your college/major unit?
  3. What was the college/major unit’s faculty FTE for the previous fiscal year?
  4. Who is being paid on grants in your area that are due to expire within the next year?

Purdue University, 610 Purdue Mall, West Lafayette, IN 47907, (765) 494-4600

© 2015 Purdue University | An equal access/equal opportunity university | Copyright Complaints | Maintained by BICC

Trouble with this page? Disability-related accessibility issue? Please contact BICC at bicc@purdue.edu.