Skip to main content

Salary / Wage Detail - Project / Grant

PeopleSoft Financials 9.2

  • Select the Budget Management homepage

  image2017-1-11 13_42_32 (6).png

  • Choose the Query Viewer tile

**  **image2017-4-11 17_26_25.png

  • Enter the beginning of the Query Name, hit Search

  • Click on Favorite to add this/these as a favorite query

image2017-4-15 14_43_38.png

CU_PAYROLL_EMPLOYEE_BY_PROJ will display the payroll information for a specific project/grant number

CU_PAYROLL_EMPLOYEE_PGALL will display the payroll information for all the projects/grants you have the ability to access

  • Choose HTML to run the query to your screen or Excel to download the query

  image2017-4-15 14_44_40.png

  • If prompted, complete the following fields:

    • Enter a Project / Grant

    • Enter a Journal From Date and Journal To Date

  • Hit View Results

  • You may encounter a pop-up blocker when trying to execute a query. Choose options and Always Allow.

 

  • If prompted, complete the following fields:

    • Enter a Project / Grant

    • Enter a Journal From Date and Journal To Date

  • Hit View Results

**  **image2017-4-15 14_51_43.png

The resulting screen should look similar to this example.

image2017-4-15 14_54_41.png

  • The journal dates can be entered several different ways:

    • Using the calendar icon to select the dates

    • Using slashes

    • Entering all the digits (including zeros) without slashes

    • You can use a "t" as a shortcut for today's date

  

  • If you chose HTML, you can still opt to download the results to Excel using the Excel Spreadsheet hyperlink

Missing Access? Have Questions? Contact Controllers_Office@clarkson.edu