Financial Services
Queen's University-
Support & Training
-
Access
- Access Eligibility and Training
- IT Services
- Modify User’s Existing Access
- NetID and Password
- PeopleSoft GL Inquiry
- PeopleSoft Human Resources
- PeopleSoft Journal Entry
- PeopleSoft Purchasing
- PeopleSoft Query Viewer
- PeopleSoft Student System
- PeopleSoft versus Queen’s Portal
- Remote Access
- Research Project Not on Portal
- Research Statement of Operations
- Additional Resources
- Chart of Accounts
- Frequently Asked Questions
- Resource Material
- Support - How Can We Help?
- Training Calendar
-
Access
PeopleSoft Public Queries
The following table offers guidance on using the public queries that are available to general PeopleSoft GL Inquiry users. It may also be downloaded as a PDF document.
PeopleSoft Public Query Guide - March 27, 2013 (85 kB)
| Query Name | Criteria | Use |
|---|---|---|
| QU_GL_ACCOUNT_LISTING | List of Active Revenue & Expense GL Accounts | This is used to get a report of accounts a user can use. |
| QU_GL_CLASS_LISTING | List of Active Classes | This will give the user a list of active Classes. |
| QU_GL_DEPT_LISTING | List of Active Departments | This will give the user a list of active Departments. |
| QU_GL_FUND_LISTING | List of Active Funds | This will give the user a list of active Fund codes. |
| QU_GL_INACTIVE_PROJ | List of Inactive Projects | This will give the user a list of inactive Projects. |
| QU_GL_PROGRAM_LISTING | List of Active Programs | This will give the user a list of active Programs. |
| QU_GL_ACCTTRANS_YTD | Account & Year | This is mainly for balance sheet accounts, such as bank accounts or accounts receivable (accounts that start with 1 or 2). This is all transactions for the year. |
| QU_GL_ACTDEPTBALANCE | Department & Fund Ledger Balance | This is the balance of your Department & Fund for the current date. This would be used to get your actual balance for Department or Fund. |
| QU_GL_ACCTDEPTPROG_BALANCE | Department & Fund with Program Ledger Balance | This is the balance of your Department & Fund for the current date. This would be used to get your actual balance for Department or Fund that includes Programs. |
| QU_GL_ACTPROJBALANCE | Project Balance for Fiscal Year | This is the balance for Projects year-to-date. |
| QU_GL_DEPTTRANS | Transactions for a Department for one month | This will give the user all actual transactions posted to their Department for everything but Projects (Fund 30000 or 31000). |
| QU_GL_DEPTTRANS_OPERATING | Transactions for a Operating Department for one month | This will give the user all actual transactions posted to their Department for Fund 10000. |
| QU_GL_DEPTTRANS_YTD | Transactions for a Department for a year by Fund | This will give the user all actual transactions posted to their Department for the Fund selected. |
| QU_GL_FUNDTRANS | Transactions for a Fund for one month | This will give the user all transactions posted to their Fund - this would be used for Trust Funds. |
| QU_GL_RESEARCHPROJECTS | The detailed transactions for Projects up to a given accounting period | This will give the user a list of transactions that have occurred against their Project. |
| QU_GL_YTD_FUNDTRANS_UNITS | All transactions for a Fund and the units associated to it for a year | This will give all transactions for a Trust and the units. |
| QU_MAPPING_ACCOUNT_CODE | Mapping table by legacy account | This will give the user all the lines in the mapping table for the legacy account. |
| QU_MAPPING_PSDEPARTMENT | Mapping Table by PeopleSoft Department | This will give the user all the lines in the mapping table for their new PeopleSoft Department. |
| QU_GL_SOURCE_LISTING | Listing of Active Journal Sources | This can be used to determine what area a journal originated from. |
| QU_OPRID_LOOKUP | Look up for PeopleSoft Users to tell who created a journal | This can be used in conjunction with the journal inquiry to determine who has created a journal. |
| QU_GL_FUNDDETAIL | Transaction Detail for your Trust fund, including Accounts Payable information | This will give the user all actual transactions posted to their Department including Accounts Payable information |
| QU_GL_DEPTDETAIL | Transaction Detail for your Department including Accounts Payable information | This can be used in conjunction with the journal inquiry to determine who has created a journal. |
| QU_GL_DEPTANNUALDETAIL | Transaction Detail for your Department including Accounts Payable information for a year | This will give the user all actual transactions posted to their Department, including Accounts Payable information. |
| QU_GL_85000DETAIL | Transaction Detail for your 85000 Program, including Accounts Payable information for a year | This will give the user all actual transactions posted to their 85000 Programs, including Accounts Payable information. |
| QU_GL_PROJDETAIL | Transaction Detail for your Research Project, including Accounts Payable information for a period | This will give the user all actual transactions posted to their Research Project, including Accounts Payable information. |
| QU_GL_PROJANNUALDETAIL | Transaction Detail for your Research Project, including Accounts Payable information for a year | This will give the user all actual transactions posted to their Research Project, including Accounts Payable information. |
| QU_GL_CARRYFORWRD | Opening carry forward balances | This will give the user their carry forward balance for their department or fund at the beginning of the 2009/2010 fiscal year. |
| QU_GL_PROJECT_LISTING | List of Active Projects | This will give the user a list of active Projects. |
| QU_GL_998 | Transaction Detail for Period 998 |
This can be used for reconciling the statement of operations closing carry-forward at period 12 (which does not include period 998) and the opening carry-forward in the next fiscal year (which does include all adjusting entries in period 998 of the previous year). |
| QU_GL_85000DETAIL_YTD | Transaction Detail for Fund 85000 by Department & Program for the year | This will give the user all actual transactions posted to their 85000 Funds by Department and Program for the year. |
| QU_GL_RSHPROJ_JOURNALDATE | Project & Dates | You can query on a project for a specific date range that will cross fiscal years. |
| QU_GL_CARRYFORWRD_RANGE | Dept, Fiscal Year & Fund Range | This will enable departments to have all the fund carryforward balances for a year. |
| QU_GL_INVOICERECORDED_BYPROJ | AP Transactions for a Project, Year and Month | Lists Invoices/Vouchers paid through Accounts Payable for a project for a month & Year |
| QU_GL_DEPTTRANS_CrFW | All transactions for a Year, Department & Fund. | Lists all transactions by Department & Fund for a year ,and includes the Carry forward accounts |
| QU_GL_TRANS_DEPT_PROG_FUND | All transactions for a Department, Program & Fund for a specific year | Lists all transactions by Department, Program & Fund for selected year and includes the Carry forward accounts |
| QU_GL_DEPTANNUAL_VENDOR_DET | Vendor payments for a Department for a year | This will give the user all vendor payment transactions posted to their Department for the fiscal year and vendor selected |