Skip to main content

Finance Queries

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