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 eProcurement
- Catalog items by contract (DOCX) - This query returns all active catalog items for a specified contract.
- Catalog item price comparison (DOCX) - This query compares the state catalog item pricing on the requisition to the purchase order and voucher prices. Users can identify items loaded to the state catalog with incorrect pricing or suppliers invoicing at a different price than what’s loaded. These discrepancies should be reported to DAS Procurement. The query also identifies the number of change orders done to the purchase order.
- Workflow status by requisition (DOCX) - This query returns the workflow status, the approver(s), and the number of days the requisition is in pending status for a specific requisition. Prompts on business unit and requisition ID.
- EOY req budget check error (DOCX) - This query displays requisitions in budget error for end of year review.
- Reqs by contract, DOIT flag (DOCX) - This query displays requisitions by contract without vendor suffix, DOIT Flag, and requisition date.
- Requisitions by DOIT flag (DOCX) - This query displays requisitions by vendor, DOIT flag, business unit, and requisition date.
- Requisitions by vendor, DOIT flag (DOCX) - This query displays requisitions by DOIT flag, vendor, business unit, and requisition date.
- Status by requisition number (DOCX) - This query shows the status of all requisitions based on the user input of business unit and specific requisition number. Built using the CT_REQ_TRNS_TBL table.
- All reqs by workflow status (DOCX) - This query displays all requisitions in a particular workflow status (such as pending) by business unit. Prompts on business unit and requisition status.
- Req type by requisition date (DOCX) - This query returns requisition type information by requisition date.
- Requisition type by flag and date (DOCX) - This query returns requisition type information by Req Type flag value & requisition date
- Requisition type by requisition number (DOCX) - This query returns requisition type information by requisition number.
- Req type by vendor requisition date (DOCX) - This query returns requisition type information by vendor ID and requisition date
- Requisitions by entered date (DOCX) - This query shows the status of all requisitions based on the user input of business unit and date range. This query was built using the CT_REQ_TRNS_TBL table.
- Items by contract or vendor (DOCX) - This query returns procurement catalog items by contract or vendor. Query prompts on Contract ID and Vendor Number; both accept wild cards (%).
More resources