The following are some useful queries which are useful for departments
Peoplesoft Finance Navigation: Main Menu->Reporting Tools->Query->Query Manager
| Query
Name | Description |
| UHS_AP_INTEREST_BY_DEPT_NODE | Late interest amt by
dept node |
| UHS_AP_SEARCH_FOR_PAYMENTS | Vchr Pmts by Vchr Pmt
Date |
| UHS_AP_SEARCH_FOR_VENDORS | Search for AP/PO
vendors |
| UHS_AP_SEARCH_FOR_VOUCHERS | Vchrs by Vchr
Accounting Date |
| UHS_AP_UNPOSTED_VOUCHERS | Vouchers not posted
|
| UHS_CC_LOOKUP | Cost center lookup |
| UHS_OPEN_COMMITMENTS_DETAIL | Open commitments by
DeptID |
| UHS_PO_BY_DEPT_NODE | POs by Dept,
Project/Grant |
| UHS_WF_AP | AP voucher approval
history |
| UHS_WF_AP_DENY_WITH_COMMENT | AP vouchers-Deny with
comment |
| UHS_WF_AP_NOT_POSTED | AP vouchers not
posted |
| UHS_WF_AP_USER_ACTIVITY | AP voucher activity
by user |
| UHS_WF_GL | GL journal approval
history |
| UHS_WF_GL_DENY_WITH_COMMENT | GL journal - deny
with comment |
| UHS_WF_GL_NOT_POSTED | GL journals not
posted |
| UHS_WF_REQ | Requisition Approval
History |
| UHS_WF_REQ_DENY_WITH_COMMENT | Requisition-Deny with
Comment |
| UHS_WF_REQ_NOT_APPROVED | Requisition not
Approved |
| UHS_WF_SC | SC voucher approval
history |
| UHS_WF_SC_BY_SERVICE_CENTER | SC vchr appr hist by
Svc Ctr |
| UHS_WF_SC_DENY_WITH_COMMENT | SC vouchers-Deny with
comment |
| UHS_WF_SC_NOT_POSTED | SC vouchers not
posted |
