PeopleSoft Queries
* = Available only in Production *^ = Available in both Production and Reporting ^ = Available only in Reporting
Query
Name
JE_BY_ID *
JOURNAL_INFO*^
PROJECT_ACTIVITY
_BY_MONTH*^
Q_Vchr_Pending
College_by_OUC^
Q_Vchr_Incomplete
_by_OUC ^
Q_Voucher_List_Not
_Paid_by_OUC ^
Q_Vchr_List_Not _PD_2DIGIT_OUC ^
Q_MKTPL_PO
ENCUMBRANCES^
Q_NON_MKTPL_PO
_ENCUMBRANCES ^
Description
Listing of
Journal
Entries by
User ID
Journal ID
Accounting entries
by period
Project ID activity listing by
month
Listing of vouchers needing
college approval
Listing of incomplete
vouchers
Listing of unpaid
vouchers
Listing of unpaid vouchers by 2-digit
department id
Listing of open
balances
on MarketPlace
Purchase Orders
Listing of open
balances on Non-
MarketPlace Purchase
Orders
Criteria
Needed
Fiscal Year
Operator ID
Fiscal Year
Accounting Period
Journal ID
Fiscal Year
Accounting Period
Project Number
Department/OUC Number
Department/OUC
Number
Journal Date(s)
To / From
Department/OUC
To / From
Journal Date(s)
Department/OUC Number(s)
Department/OUC
Number
Department/OUC
Number
Query
Results
Ledger
Group
Journal ID
Journal Date
Source
Journal
Header
Status
Budget
Header
Status
Journal
Process
Request
Fiscal Year
Accounting
Period
Operator
Identification
Date and
Time Stamp
Journal ID
Journal Date
Source
Journal Header
Status
Journal Process
Request
Program
Subclass
Amount
Fiscal Year
Accounting Period
Operator
Identification
Journal Line Number
Project Number
Account Number
Organization
Line Description
Journal Reference
Journal ID
Journal Date
Source
Journal Header Status
Program
Subclass
Amount
Posted Date
Fiscal Year
Accounting Period
Operator Identification
Journal Line Number
Project Number
Account Number
Organization
Header & Line Description
Journal Reference
Voucher ID
Invoice ID
Invoice Date
User
Gross Amount
Entered Date
Approval Status
Department ID
Project ID
Voucher Creation Date
Department ID
Voucher ID
Invoice ID
Invoice Date
Gross Amount
Vendor ID
Vendor Name
Operator ID
Entered Date
Approval Status
Project ID
Account
Amount
Voucher
Invoice
PO Number
Vendor ID
Vendor Name
Voucher Route Date
Campus Approver
Campus Approval Date
AP Approver
AP Approval Date
Department ID
Project ID
Account
Amount
Voucher
Invoice
PO Number
Vendor ID
Vendor Name
Accounting Date
Department ID
Description
Purchase Order ID
Purchase Order
Status
Vendor Name
Purchase Order
Date
Receipt Status
Encumbrance
Balance
Purchase Order
Reference
Department ID
Description
Buyer
Purchase Order ID
Purchase Order
Status
Vendor Name
Purchase Order Date
Receipt Status
Encumbrance Balance
Purchase Order
Reference
