Skip to main content

​The following are some useful queries which are useful for departments

Peoplesoft Finance Navigation: Main Menu->Reporting Tools->Query->Query Manager

Query NameDescription
UHS_AP_INTEREST_BY_DEPT_NODELate interest amt by dept node
UHS_AP_SEARCH_FOR_PAYMENTSVchr Pmts by Vchr Pmt Date
UHS_AP_SEARCH_FOR_VENDORSSearch for AP/PO vendors
UHS_AP_SEARCH_FOR_VOUCHERSVchrs by Vchr Accounting Date
UHS_AP_UNPOSTED_VOUCHERSVouchers not posted  
UHS_CC_LOOKUPCost center lookup
UHS_OPEN_COMMITMENTS_DETAILOpen commitments by DeptID
UHS_PO_BY_DEPT_NODEPOs by Dept, Project/Grant
UHS_WF_APAP voucher approval history
UHS_WF_AP_DENY_WITH_COMMENTAP vouchers-Deny with comment
UHS_WF_AP_NOT_POSTEDAP vouchers not posted
UHS_WF_AP_USER_ACTIVITYAP voucher activity by user
UHS_WF_GLGL journal approval history
UHS_WF_GL_DENY_WITH_COMMENTGL journal - deny with comment
UHS_WF_GL_NOT_POSTEDGL journals not posted
UHS_WF_REQRequisition Approval History
UHS_WF_REQ_DENY_WITH_COMMENTRequisition-Deny with Comment
UHS_WF_REQ_NOT_APPROVEDRequisition not Approved
UHS_WF_SCSC voucher approval history
UHS_WF_SC_BY_SERVICE_CENTERSC vchr appr hist by Svc Ctr
UHS_WF_SC_DENY_WITH_COMMENTSC vouchers-Deny with comment
UHS_WF_SC_NOT_POSTEDSC vouchers not posted

 


Last updated 7/24/2015 8:04 AM