TOOLS FOR RESEARCH ADMINISTRATION

at Queen's

site header
  • Mapping your PeopleSoft reports & queries to the new Financial Reporting Tool

    We will maintain a list of PeopleSoft reports and queries in this section so please visit often!

    Query Name

    Report Name

    Details/Directions

    Listings

    QU_MAPPING_ACCOUNT_CODE or

    QU_GL_ACCOUNT_LISTING_ALL

    Account Listing

    Run wide open to find the listing name.

    QU_GL_CLASS_LISTING

    Class Listing

    QU_GL_DEPT_LISTING

    Department Listing

    QU_GL_FUND_LISTING

    Fund Listing

    QU_GL_PROGRAM_LISTING

    Program Listing

    QU_GL_PROJECT_LISTING

    Project Listing

    GL (General Ledger)

     

     

    QU_GL_ACCTDEPTPROG_BALANCE

    GL Pivot - Actuals Budget and Commitment Enter fund and department, sort by account - program
    QU_GL_ACCTTRANS Transaction Details Revenue and Expense Available in Transaction detail and expense by searching on a specific month and Account. All information is available including a drill down on Journal ID for additional information. Similar to the QU_GL_ACCTTRANS_YTD query this is dependent on whether it is a balance sheet or revenue and expense.

    QU_GL_ACCTTRANS_YTD

    Transaction Details Balance Sheet
    Transaction Details Revenue and Expense

    For researchers needing period 0 information they can drill down on the Statement of Operations Research (when available) or the Project Summary report to get the same information. Other users can access this information from the Transaction Detail Balance Sheet.

    QU_GL_ACTPROJBALANCE Statement of Operations - Research Filter by account
    QU_GL_APJOURNAL_INQUIRY Transaction Details Balance Sheet Drill down on AP journal ID or run the accounts payable department report and filter on journal ID
    QU_GL_CAPITALFUNDYTD Transaction Details Balance Sheet Filter on fund code 40000 and account = 31% (currently broken in PeopleSoft)
    QU_GL_CARRYFORWRD GL Pivot - Department Expendable GL pivot department expendable or transaction detail balance sheet
    QU_GL_CARRYFORWRD_RANGE GL Pivot - Department Expendable Enter your department and sort by department and program
    QU_GL_DEPTANNUALDETAIL Transaction Details Balance Sheet Drill down on the AP journal for more detailed information
    QU_GL_DEPTANNUAL_VENDOR_DET Accounts Payable Details Department Filter on Vendor and fiscal year
    QU_GL_DEPTDETAIL Transaction Details Revenue and Expense Similar to QU_GL_DEPTTRANS report. With AP information. This would be available in the drilldown on the transaction detail revenue and expense.
    QU_GL_DEPTTRANS Transaction Details Revenue and Expense Similar to the QU_GL_DEPTTRANS_YTD this query allows you to select a specific period for the report to be run. This can be accomplished in the existing Transaction Details Revenue and Expense report.
    QU_GL_DEPTTRANS_CRFW Transaction Details Balance Sheet Period zero through 998 for income statement accounts, department expendable and drill down on carry forward mount to get the detail. Or if you want the income statement amount you can drill down on the revenue and expense accounts.
    QU_GL_DEPTTRANS_OPERATING Transaction Details Balance Sheet Filter on fund 10000
    QU_GL_DEPTTRANS_QSB_PL Transaction Details Balance Sheet Drill down on AP journal for more information. (Report to resolve gap in development)

    QU_GL_DEPTTRANS_YTD

    Transaction Details Revenue and Expense

    Nearly identical to the transaction detail revenue and expense report. With the FAST report providing additional details.

    QU_GL_FUNDDETAIL Transaction Details Balance Sheet Drill down on AP journal for more information. (Report to resolve gap in development)
    QU_GL_FUNDTRANS Transaction Details Balance Sheet Filter on fund.
    QU_GL_INACTIVE_PROJ Project Summary Project summary report will show project status for projects they legitimately have access to and filter on status within the report that particular report will not show closed projects i.e. Inactive and zero balance.
    QU_GL_INVOICEPAID Accounts Payable Details Department Filter on fund department, period, and year (program, project and vendor may be optionally included)
    QU_GL_INVOICERECORDED Accounts Payable Details Department Enter in chartfield criteria
    QU_GL_INVOICERECORDED_BYPROJ Accounts Payable Details Department Filter on department and in the fund enter 30000 and 310000
    QU_GL_LTDTRANS_YTD Transaction Details Balance Sheet Filter on chartfield criteria
    QU_GL_PROJANNUALDETAIL Statement of Operations - Research Available in the Statement of Ops Research report. With Drilldown on the Project to Date Actual.
    QU_GL_PROJDETAIL Statement of Operations - Research Virtually identical to the QU_GL_RESEARCHPROJECTS query with additional AP details. This can be found in FAST by drilling down on the Journal ID of an AP transaction. There is also an AP Transaction detail report that is for projects which can be used to get the same information.

    QU_GL_RESEARCHPROJECTS

    Statement of Operations - Research

    Access to information can be retrieved through the Statement of Ops research by Account then drilling down on the month Actual to the transaction details. Both include only income statement items.

    QU_GL_RSHPROJ_JOURNALDATE

    Transaction Details Balance Sheet

    Missing department description order/filter by date

    QU_GL_SF_JRNL_DET Student Financials Dept Not all information is presently available in FAST (Descr fields) but most information is there

    QU_GL_TRANS_DEPT_PROG_FUND

    Transaction Details Balance Sheet

    Query contains period 0, 999 which are not included in this report. period 998 is included in period 12 in FAST

    QU_GL_YREDNDDETAIL

    Accounts Payable Details Department

    Filter on year and department

    QU_GL_YTD_FUNDTRANS_UNITS

    Trust and Endowment

    Navigate to the Non Research Reports menu option, and select the Trust and Endowment report. This report contains all of the information in the query, with the exception of the Journal details which are available by drilling down on transaction detail.

    QU_GL_85000DETAIL_YTD Transaction Details Balance Sheet Irrelevant but link provided.
    QU_GL_998   Not in FAST but in the list of reports to be developed
    QU_GL_CARRYFORWARD 1 Department expendable filter on fund department and period (query includes both expendable balances and non-expendable balances)
    QU_GL_JOURNALBUDGETEXCEPTION(S)   Not available in FAST but only of interest to Research Accounting
    QU_GL_JOURNAL_LINE   Currently a gap new report in development to meet this need. In the meantime run transaction detail and revenue and expense and filter on the chartfields and drill down on the journal from there.
    QU_GL_MONTHEND_CHECK   Not available in FAST but only of interest to General Accounting
    QU_GL_OPERID_SEARCH   Available on all reports
    QU_GL_PROJECT_LISTING   Limitations on description will prevent this report from being available possible gap being discussed information also exists in the project summary report
    QU_GL_SOURCE_LISTING   Note: Not currently a pinned report. Will be added in future

    AP (Accounts Payable)

    QU_AP_SNGLEPAYMENT Accounts Payable Details Department  

    QU_AP_SNGLEPAYMENT_BY_NAME 

    Accounts Payable Details Department

     

    QU_AP_PAYCYCLE_ADVANCES1   Not available in FAST but only of interest to Accounts Payable
    QU_AP_PREPAYMENT_LTR   Not available in FAST but of interest only to AP
    QU_AP_SAR_TRANS   Not in FAST but only of interest to Student Financials
    QU_AP_SAR_TRANS_DETAIL   Gap exists for this report, if required please forward request to Financial Services
    QU_AP_UNPOSTED_VOUCHERS   Not available in FAST but only of interest to Accounts Payable
    QU_AP_VCHR_CNTLGRP   Not available in FAST but of interest only to Financial Services
    QU_AP_VOUCHERBUDGETEXCEPTION   Not available in FAST but only of interest to Research Accounting
    QU_AP_VOUCHER_ERROR   Not in FAST but only of interest to AP

    CC (Commitment Control)

    QU_CC_PROJ_BALANCES Project Summary Filter on year and period
    QU_CC_REQBUD_EXCEPTION   Not in FAST but only of interest to Research Accounting
    QU_CC_PI_DEFICIT   Not in FAST but only of interest to Research Accounting

    Other/Private

    BUDQU_GL_DEPTTRANS Transaction Details Balance Sheet Filter by chartfields

    CTG_TRANSACTIONS_QUERY

    Statement of Operations - Research

    Clinical trials group developed this public query. The same information can be retrieved from the Statement of Operations - Research report and drilling down on the Month Actual Column.

    SF_GL_ACCTTRANS_YTD Student Financials Dept Filter on period and fund
    SF_GL_ACCTTRANS_YTD_RECONCILE Student Financials Dept Full range of filters available (chartfields, period, etc...)
    QU_AUD_GL_QUERY Transaction Details Balance Sheet Filter on amounts
    QU_HR_ACCTG_LINE_BY_DEPTID Accounts Payable Details Department Filter by department but will only show the specific projects the user has access to
    QU_MAPPING_ACCOUNT_CODE   Not in FAST and not applicable