Unit 2 Getting Started

1
Welcome!

• EPAs Financial Data Warehouse (FDW) is accessed
  through EPAs Intranet, and provides a convenient
  way to check the status of certain fiscal details
  of Task Orders.
• At the current time, EPAs Financial Data
  Warehouse is undergoing a transition to a new
  name Administrative Data Warehouse.
  Accordingly, these two names may be used
  interchangeably here and in other materials
• Financial Data Warehouse
• Administrative Data Warehouse

2
Overview

• The objectives of this tutorial are to
• Introduce the steps to access the FDW.
• Explain the steps to display the name of the Task
  Order Manager (TOM) of record (and co-TOM, if
  applicable) for a Task Order
• Explain the steps to display the DCNs which have
  money obligated to a Task Order
• Explain the steps to display a list of invoices
  paid against a Task Order

3
Getting Started!!

• Before you can get started you must know the
• Contract Number
• Task Order Number
• Below is a list of the Contract Numbers
  associated with each company participating in the
  Multiple-Award National Watershed Protection
  Program Contract
• TetraTech 68-C-02-108
• Cadmus 68-C-02-109
• RTI International 68-C-02-110
• Parsons Engineering 68-C-02-111

4
Getting Started!

• If you cant remember your Task Order Number or
  the Contract Number, you can find both of these
  items on the original Task Order.

5

• The Financial Data Warehouse may be accessed
  through the link in the Financial category of
  the EPAs Intranet Homepage, or the URL may be
  typed directly into the web browser.

http//intranet.epa.gov/fdw
6
Using the Financial Data Warehouse

• The link displayed on the previous page will
  bring you to the Financial Data Warehouse
  homepage (pictured below)

http//intranet.epa.gov/fdw/
7
Using the Financial Data Warehouse

• On the right side of the page you will see a
  column of links. Click on the fifth link, CPS
  Contract Data

8
Contract Data Inquiry

• The link on the previous page leads to the
  Contract Data Inquiry page (pictured below).

1. Enter the Contract number (without spaces or
   hyphens)
2. Enter the Task Order Number
3. Click Submit.

9
After clicking Submit the results of the
inquiry will be displayed in the format shown
below.
Please note the following 2 sections IFMS
Document Provides a link to fiscal information
concerning a Task Order Project Officer Lists
the Task Order Manager (TOM) (and co-TOM, if
applicable).
10
IFMS Document

• This is the IFMS Document page, accessible
  through the link in the IFMS Document section of
  the previous page.

1. Document Summary Provides information regarding
   the Task Order and its fiscal status
2. Document Details Line-item description of each
   DCN obligated to the Task Order

11
Document Details

• Here is an enlarged image from the Document
  Details section.
• Each line corresponds to a DCN with funds
  obligated towards your Task Order
• Here are several items of particular interest
• Line Amt ( Obligated )
• Paid Amt.

• Available Amt.
• Comments (DCN )

The Comments category contains the DCN in a
unique format. The first two characters
correspond to the year of the money, the next
two characters correspond to the organization
where the money originated, and the final six
characters are the actual DCN .
12
Document Activity

• Scrolling further down this page will display the
  Document Activity section which details the
  transactions (i.e. invoice payments, Procurement
  Requests) of this Task Order

• Reference Amount - value associated with a
  transaction
• Related Document provides a link to the DCN or
  invoice associated with a transaction
• Direction
• Back money being added (i.e. PR)
• Forward money being deducted (i.e. invoice
  payment)

13
Conclusion

• This concludes the FDW tutorial. The objective
  of this tutorial is to introduce some of the
  basic functions of the FDW and to explain how
  these can help Task Order Managers monitor the
  fiscal status of their Task Orders.
• If you have any questions regarding this tutorial
  please contact Eric Powell, powell.eric_at_epa.gov.
  For all other questions please contact the
  appropriate FDW personnel.