University of California, Riverside

UCR Reporting



UCRFS Public Queries


UCRFS Public Queries

Several UCRFS queries have been created that UCRFS users may access using the UCRFS Query Viewer Option.  Query results may be run to HTML or MS Excel formats.  Please review the list below for additional query details.


NameDescriptionSampleAuth. ProcedureAccess Procedure

PO Encumbrance Report

This query provides current purchase order FAU encumbrance balance for all POs within a selected department code.

step 1

Access to UCRFS Query Viewer is available to all UCRFS users.  Please contact your SAA for UCRFS access.

Click here to Copy and Paste the Query Name into the Query Viewer Search Screen.

 

PO Encumbrance History Report

This query provides PO encumbrance reconcile/close history for a selected user.

step 1

Access to UCRFS Query Viewer is available to all UCRFS users.  Please contact your SAA for UCRFS access

Click here to Copy and Paste the Query Name into the Query Viewer Search Screen.

 

Outstanding Travel Advance Report

This query provides current outstanding employee travel advances.

 

step 1

Access to UCRFS Query Viewer is available to all UCRFS users.  Please contact your SAA for UCRFS access

Click here to Copy and Paste the Query Name into the Query Viewer Search Screen.

Vendor Payment History Report

This query provides vendor payment history for a selcted Vendor ID.  Note, the Vendor ID is available via the eBuy Vendor Search option.

 

step 1

Access to UCRFS Query Viewer is available to all UCRFS users.  Please contact your SAA for UCRFS access

Click here to Copy and Paste the Query name into the Query Viewer Search Screen.

UCR_PO_BALANCE_JRNL_FASTEST

UCR_RECOND_POS_BY_USER

TRAVEL_ADVANCE_112157_PUBLIC

AP_PAYMENTS_BY_VENDOR_VOUCHER

VENDOR_ANNUAL_PYMNT_REQUEST

More Information 

General Campus Information

University of California, Riverside
900 University Ave.
Riverside, CA 92521
Tel: (951) 827-1012

Department Information

Computing & Communications
Computing & Communications Bldg.

Tel: (951) 827-4741
Fax: (951) 827-4541
E-mail: helpdesk@ucr.edu

Footer