Step-by-step guide

The following are public queries available to be run by all employee's.  They can be copied and modifed, but please do not change the original query.  Questions can be directed to crimsonservicedesk@wsu.edu. 

Additional queries will be added as time permits.  All queries will begin with WD_ and reside in the WD Folder within myWSU Query Manager or Query Viewer. 

  1. Navigate to MM > Reporting Tools > Query > Query Viewer
  2. Enter WD_ and Click Search

  3. Click on Report Type (Excel is most common)
  4. Report will download to your My Downloads folder.

Reports Currently Available:

Query Name:Query Description:

WD_ACCTG_FEED_DETAIL

Accounting Feed Deetail

WD_ACCTG_FEED_REPORT

Accounting Feed Report

WD_ACCTG_SUMMARY_REPORT

Accounting Summary Report

WD_ACCTG_SUMM_FINAL_TOTALS

Accounting Summary Final Total

WD_DAILY_BOOKING_REPORT

myWSU Daily Booking Report

WD_DAILY_BOOKING_SUMMARY

myWSU Daily Booking Summary

WD_GL_TRIAL_BALANCE

GL Trial Bal byFund

WD_GL_TRIAL_BALANCE_SUM

GL Trial Bal byFund Sumary

WD_MONTHLY_CASH_LEDGER_POST

myWSU Monthly Cash Ledger Post

WD_PERS_PMTS_BY_DATE_RANGEmyWSU Person Pmts - Date Prompts
WD_ORG_PMTS_BY_DATE_RANGEmyWSU Org Payments - Date Prompts

WD_PURFC_ITEMTYPELISTING

Pickup Rec From Chgr Item Type Listing

WD_SF_ACCTG_LINES_SCC

Return Account Coding for Item Types

All employee with a cost center manager role have been provided query viewer access.  Any new Cost Center Managers or others with a need to view student financials data in myWSU will need to request access to query viewer.

Training is offered once a month for Query Manager access, which would provide users ability to create their own reports.