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 Project Costing
- Summary and detail project (DOCX) - This query retrieves a list of projects and related transactions that are associated with a specific summary project
- Transactions by type (DOCX) - This query obtains a listing of transaction rows for a specified Business Unit, Range of Project IDs, Analysis Type, and Range of Accounting Dates.
- Trans rows for pay, GLE (DOCX): This query returns a list of project transaction rows with analysis types of PAY and GLE and accounts between 50110 and 50800.
- Projects without contract (DOCX) - This query selects all project/activity combinations for the specified Project Business Unit that does not have an associated contract.
- Project asset IDs (DOCX) - This query allows users to obtain the Asset IDs associated to a specific Project ID or a range of Project IDs for a specified Projects Business Unit.
- Contracts for projects (DOCX) - This query provides a listing of contracts associated with a particular project and activity combination.
- Project manager (DOCX) - This query provides the manager for a project or range of projects.
- Project status (DOCX) - This query provides the status for a project or range of projects for a given Project Business Unit.
- Projects at status (DOCX) - This query provides a list of projects with a particular status for a given Project Business Unit.
- Project team members (DOCX) - This query provides a listing of team members for a project or range of projects for a given project business unit.
- GL to PC reconciliation (DOCX) - This query provides the user with transaction detail from CTW_JRNL_TRN. This query should be used in conjunction with the CT_PC_TO_GL_PROJ_RES query to compare results and to isolate differences in the PC to GL Reconciliation Report.
- PC to GL project resource (DOCX) - This query is used for PC to GL Reconciliation and it provides user with transaction detail from the PROJ_RESOURCE table.
- Trees for projects (DOCX) - This query returns a list of agency trees and a range of project ID's associated with the tree.
- Projects/ reporting tree 2 (DOCX): This query shows a listing of Projects assigned to any tree for a specific Business Unit.
- Reporting tree 3 (DOCX) - This query provides a listing of all Projects ID’s that have been assigned to any agency tree.
- Project vendor information (DOCX) -This query provides purchasing and accounts payable information for charges against a project for a particular vendor (prompt on Projects Business Unit and Vendor ID).
More resources