Please enable javascript to view this page in its intended format.

Queen's University
 

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

Kingston, Ontario, Canada. K7L 3N6. 613.533.2000