This article lists the public EPM queries and descriptions for this topic. Please review available public queries below before making a new query.
EPM public query names and descriptions for Accounts Receivable
- Deposit IDs by Fund SID, Fiscal Year and Date (DOCX): Deposit IDs linked to deposits by Fiscal Year, Accounting Date, Fund, SID and Account.
- Direct Journals in Budget Error (DOCX): Query returns all direct journal entries in the status of Budget Error. Normally the query will return rows.
- Audit Post Date versus Accounting Date (DOCX): Query provides a list of deposits by Deposit Business Unit, the accounting date, posted date and number of days between the accounting and posted date. Audit per Comptroller's Memorandum, 2011-05, 2-24-2011.
- Open Items budgeted Funds (DOCX): This will identify by Business Unit any Refund of Expenditure Open Items in Budgeted Funds. Agencies need to be aware that if they are closing out a Refund of Expenditure Item in a Budgeted Fund, they must manually re-bill it in the next fiscal year with prior year coding (Account 44410/SID 18010).
- AR Deposits Not Posted (DOCX): Query returns a list of deposits received but not posted and the number of days pending. To facilitate agency compliance with Comptroller's Memo 2011-5.
- AR Distribution for 50000 Accounts Only (DOCX): This is union query of the CT_POSTED_ITEM and CT_DIR_JRNL_PY tables. It returns only those deposit items that reference a 50000 (Expenditure) Account.
- Exp by SID/CFDA Nbr Prior FY (DOCX): Expenditures by SID/CFDA Number - The purpose of this query is to monitor Federal grant expenditures prior Fiscal Year only. Does not include MOD_CASH entries. Please note that if an attribute (CFDA) number is not associated in CORE-CT with a particular SID the expenditures are excluded in the results
- Rev by SID/CFDA Nbr Prior FY (DOCX): The purpose of this query is detail federal grant revenue received coded to account like 4% for the prior fiscal year.
- AR Accounting Distribution (DOCX): Query will pull posted item transaction details for the Business Unit and accounting dates from user prompts.
- Customer conversations (DOCX): Query returns customer conversations with and without associated item numbers. The user must populate the Reference ID on the References Tab in Conversations for item numbers to be associated with a conversation.
- Detail Revenue by Dept (DOCX): The query will return all of the detail revenue transactions that have been processed through the Accounts Receivable module for a selected business unit, time period, Fund, SID, Dept. and Account.
- Open items/conversations (DOCX): Query returns customer conversations with and without associated open item numbers. The user must populate the Reference ID on the References Tab in Conversations for item numbers to be associated with a conversation. The best thing for users to do is always check for this information before they save the conversation. If it is not populated, the query will not pick up the conversation. Query prompts on Business Unit. Customer ID and item number prompts allow the use of the wildcard %.
- Bill Account Entry (DOCX): This query allows a user to retrieve a list of bills that have been entered during a specified time frame.
- Billing AR Pending Item (DOCX): Billing AR Pending Item 5/14/07 query reconstructed to add back in date prompt and remove criteria on account.
- Cust contact information (DOCX): Query returns billing customer contact information including contact name, phone, email and address.
- Billing Invoice (DOCX): Billing Invoice Information. Query prompts on business unit, customer ID and accounting date range.
- Partial payments, open invoice (DOCX): Facilitates identification of all open, partial payments received by business unit.
- Expenditures by SID/CFDA Number (DOCX): The purpose of this query is to monitor Federal grant expenditures. Please note that if an attribute (CFDA) number is not associated in CORE-CT with a particular SID the expenditures are excluded in the results.
- Employee payroll COP-9 (DOCX): Query returns employee payroll data for COP-9 reimbursement detail. Successful execution of this query requires Payroll access. Budget staff with the EPM only role CT_E_HR_BUDGET_REPORTING can execute this query.
- Customer Conversations w/keyword (DOCX): Query returns all customer conversations, items associated with the conversation, date and time, and keywords. User can search by customerID, item, or Keyword.
More resources