Frequently used PS Queries

PS Queries

Query Name Description
Transactions
CHEG_TRANS_QUERY_NEW Purpose transactions for a period of time; prompt on journal ID
NEW_QUERY Test query
CHEG_TRANS_SALARY Salary transactions for a period of time with multiple prompts
EZQ_TRANS_BUDGET_QUERY2 Purpose budget transactions for a period of time
EZQ_TRANS_NONBUDGETPURP Transactions for purposes with no budget for a period of time
EZQ_TRANS_ALL_QUERY Purpose transactions (all ledgers) for a period of time
CHEG_TRANS_PO Purpose PO transactions for a period of time
CHEG_TRANS_USER_FIELDS Purpose transactions for a period of time; Prompt on user field
CHEG_TRANS_PRO_CARD Procard transactions for a period of time; Prompt on purpose and/or last 6 digits of card number
Balances
ENGR_BAL_TOTAL Purpose balance for purposes with no budget
CHEG_BAL_TOTAL Purpose balance for purposes with no budget
EZQ_BAL_BGT_SUMMARY Account Category balances for block (1-book) purposes
EZQ_BAL_TOTAL Purpose balance for purposes with no budget
CHEG_BAL_45_PURPOSES Balance for purposes beginning with 45-temporary investment income
Contract & Grants
CHEG_TRANS_PURP_PROJ_CONFLICT Find conflicting purpose/projectid numbers
GMQ_CASH_PS_BILLED Shows amount billed to & received from sponsor
GMQ_CLOSEOUT_ASSIGNED Assignment of close-out coordinator
GMQ_CLOSE_OUT_REPORT All transactions for projectid
GMQ_PI_PROJECT Determine award/contract number for purpose
GMQ_PI_GRANT_BALS_CATEGORY Determine PI budget balances by category-pulled from proj_resource
CHEG_BALS_PTD Sponsor Budget Balances from proj_resources; search on PI or project code
CHEG_IC_RETURNS F&A Return to dept supplemental funds-Need to modify for each dept
GMQ_PENDING_CLOSEOUT Determine projects that are nearing end date
Miscellaneous
EZQ_ACCTPURPCONVERSION Convert legacy account numbers to current purpose numbers
ELEG_LAM_DISTRIB_GRADS Current LAM allocations for dept ID
EZQ_DV_SPEEDTYPE Complete FAIs
UDQ_REF_PURPS_W_ACTIV_BY_ADM Identify purposes with activity during a particular acctg. period (useful when viewing web statements)
Comments