HR Business Center

HR Business Center Home :: Payroll

My Reports

My Reports is a tool utilized to run queries against the data warehouse. Existing users with HR ASU Data Warehouse access also have access to the HR My Reports. Instructions on requesting access is available on the My Reports welcome page under Getting an Account. This site also contains information on using My Reports and training.

To use My Reports go the My Reports website.

  • Click on "Go to My Reports"
  • Sign on using your ASURITE ID and Password.

  • Click on the Human Resources Folder to view a listing of available reports.

Queries Available in My Reports Under Human Resource Folder as of 2/1/2010:

  • BPC 2008: Budget Position Control for 2008.
  • Budget Position Control: Budget Position Control for 2009 and beyond. The Budget Position Control (BPC) report allows users to view payroll budget, encumbrance and expense information by position. The budget information includes amounts entered into salary planning and budget changes processed in Advantage for all accounts that have separately budgeted personal services at the “P” appropriation level. The encumbrance and expense information comes from PeopleSoft and includes activity for all types of accounts.
  • Distributed Pay End Dates: This query lists the pay end dates that have been distributed to accounts.
  • Emergency Contact: The first query lists the employee’s primary emergency contact. The second query lists all emergency contacts.
  • Faculty and Graduates in Short Work Break: The first query (Fac and Grad Short Work Break) identifies employees on Short Work Break who may need renewal. The second query (Fac and Grad Renewed) lists employees who have been renewed. If the return date is reached, they will be in active status; otherwise they will be in Short Work Break Status until their return date is reached.
  • HR Encumbrances: Current HR Encumbrances by Account.
  • HR Expenditures by Account: This query is set up to filter by account. HR Expenditures uses three views to report on HR Expenditures. The first view lists all expenditures Salaries, Wages & ERE. The second view contains Salary and Wages. The third view contains ERE and Tuition Remission. All 3 views contain original pay distributions and redistribution transactions that have been approved.
    *Note-the first query (Salaries, Wages & ERE) splits all payroll expenses for pay end dates of 7/10/09 and 7/12/09 between fiscal year 2009 and 2010.
  • HR Expenditures by Emplid: This query filters by employee ID, and is identical to HR Expenditures by Account.
  • Leave with Furlough: This query displays all leave types Sick, Vacation, Furlough, and Comp. The leave report has two queries. The first query displays the current leave balance, and the second query displays the detailed leave history.
  • Peoplesoft Security Role Assignment: This query lists PeopleSoft security role assignment by Employee ID.
  • Reports To: This query identifies all the employees within a department and who is listed as their Report To person in Peoplesoft. This report also includes the current account distribution amount and percentages. The Reports To person listed may not be the direct supervisor, but instead the person the employee reports their time to.
  • Sponsored Accounts with Grant End Dates: This query identifies staff paid from sponsored accounts with grant end dates.

The Workforce Profile Folder also contains useful queries. Queries Available In Workforce Profile Folder as of 2/1/2010:

  • All Active Jobs for Employee ID: This query displays a list of all active jobs for an employee.
  • Count of Benefit Eligible Employees by VP/College: This query displays a count of current employees organized by VP/College area.
  • Count of Regular Employees by Campus: This query displays a count of current employees organized by campus.
  • Employee List by Employee Campus: This query displays a list of current employees (primary job only by dept id, empl class).
  • Employee on Short Work Break: This query displays a list of all employees currently on Short Work Break (emplstat=W).
  • FY Earnings History by Employee ID and Department No: This query displays the earnings history of an employee including pay dates, earnings code,
  • Maildrop and Email for Active employees by Department VP Code or Campus: Provides ASU maildrop and ASU email address for active employees. Also includes name, department, and VP college information, and campus location.
  • Non Active/Non Terminated Employees (NO SWB): This query lists employees who are non-active employee status and not on short work break.
  • Salary History: This query list by employee id the key compensation factors along with annual rate and the annualized salary.