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 |