Is there a query/report I can run that tells me the start / end date and contract amount for a specific contract?

Is there a query/report I can run that tells me the start / end date and contract amount for a specific contract?

You can use this COGNOS report: MA01S Master Agreement Summary Report to see the begin/end date and the amount expended/left on the contracts, by department.
Fill in the details you want to see and click "finish",
Click on "HTML" tab (top left) choose how you'd like to view your report from the drop down. 
      (see the screenshot below for reference)

Preview

    • Related Articles

    • Incomplete Master Agreement Reference Document Information (A3962)

      Make sure the Master Agreement reference is correct, including the Reference Commodity Line and reference Accounting Line. The "Commodity Line" is in the MA "Commodity" Tab. It needs to be referenced in the document in the "Commodity" tab, ...

    • How do I correct a payment made on the wrong contract

      Please fill out the form & send it to fi_contracts@utah.gov This is the form you fill out if a payment was made on the wrong contract. When an agency’s accounting department makes a payment against the wrong contract, an agency will not have enough ...

    • QRG - Using Access to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1jcxI35q1Rpz_gLCbOonQaWSgO51duFq7/view ) Introduction Open Database Connectivity (ODBC) database. Similar to the state data warehouse, you’ll need to install an ...

    • QRG - Using Excel to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1CzcUic3qykVURnFS1yrkN-roU5YvQzJv/view ) Introduction To access State Data Warehouse using excel or other tools, create a DTS helpdesk ticket, they need to install ...

    • Labor Plus Query

      Labor Plus is a link within the Online Accounting Journal query. If you have accesss to the online accounting journal, then you have access to see Labor Plus. For privacy reasons, State Data Warehouse hides many vendor names. If you were to add the ...