- Organizations & Services
- Services
- Organizational Charts
- Directory and Contact List
- Forms
- Chartfield Setup and Maintenance
- Journal Entry and Budget Adjustment
- Equipment Related Forms
- Petty Cash and Change Funds
- Other Forms
- Reporting
- Business Objects (WEBI)
- Other Reporting Tools
- Physical Plant Work Orders
- Imaging
- Policy in Practice
- Policies
- Documentation
- Internal
- Archives
- Fin Search
PeopleSoft Queries for Campus Users
The following list represents the most commonly used PeopleSoft Financials (General Ledger, Purchasing and Accounts Payable). These, along with all other public queries, are available for campus PeopleSoft client users.
| Query Name | Description |
| YCMP_LDGR_DEPT_RANGE | Account balances through a specific time period for one or more departments |
| YCMP_LDGR_PROJ_RANGE | Account balances through a specific time period for one or more projects |
| YCMP_JRNL_DEPT_RANGE | Journal transactions for one or more departments within a specified date range |
| YCMP_JRNL_PROJ_RANGE | Journal transactions for one or more projects within a specified date range |
| YCMP_JOURNAL_ID | Journal transactions for a specific journal ID and time period |
| YCMP_JOURNAL_SOURCE | Journal transactions for a specific journal source within a specified date range |
| YCMP_CF_SPEED_TYPE_DEPT_RANGE | List of all speedtypes related to one or more specified departments |
| YCMP_CF_SUBCLASS | List of all subclasses |
| YCMP_CONSTRUCTION_PROJECT_SUM | Construction project budget, expenses & encumbrances |
| YCMP_PURCHASE_ORDER | Purchase order history by line for a specified purchase order |
| YCMP_AP_VOUCHER | Accounts Payable voucher history for a specified voucher |
| YCMP_AP_VOUCHER_INVOICE_PMT | Accounts Payable voucher history for a specified voucher with payment information |
Related Links
- PeopleSoft Queries for Campus Users
- Basic Financial Services Workshop
- FRS to People Soft Chartblock Conversion
- FRS to People Soft Conversion Index
- 10/22/02 - FS/Controller's Retreat - Achieving Compliance Objectives - John Gardner
- 10/22/02 - FS/Controller's Retreat - Building Relationships of Trust - Blair Condie
- 10/22/02 - FS/Controller's Retreat - Let's Get Organized! - Paul Behrmann/Doug Belliston
- 10/22/02 - FS/Controller's Retreat- Controller's Retreat Presentation - Brian Evans
- 09/24/02 - FS Management Retreat - Strategy Session - Brian Evans
- Accounts Payable Voucher File Layout
- Organization Chart with Address
- Instructions to Download Chartfield Queries
- GL Transaction Record Descriptions for Updating Data
- Account System Conversion Procedure Changes
- Accounts Payable Blanket Order Layout
- History of the PeopleSoft Decision
The Church of Jesus Christ of Latter-day Saints | BYU-Hawaii | BYU-Idaho | BYU Jerusalem Center |
BYU Salt Lake Center | LDS Business College | Missionary Training Center
Updated by the webmaster,
Brigham Young University, Provo, UT 84602 - (801)422-4636 -
Copyright 2007, All Rights Reserved