MyWSU - Workday Queries
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.
Navigate to MM > Reporting Tools > Query > Query Viewer
Enter WD_ and Click Search
Click on Report Type (Excel is most common)
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_RANGE | myWSU Person Pmts - Date Prompts |
WD_ORG_PMTS_BY_DATE_RANGE | myWSU 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.