**TEAM-Web Interaction with Other Systems**

**ECHO**

The Electronic Clearing House Operation (ECHO) System is an application
of the FTA Office of Budget and Financial Management and is used to
process drawdown requests and make payments to FTA grantees. The ECHO
System validates payment requests by comparing the request amounts to
the available project balance maintained by FTA\'s Accounting Division
and then transmits the approved payments to the Grantee\'s financial
institution through the U.S. Treasury Dept.\'s Automated Clearing House
(ACH) process. Grantees are required to submit Financial Status Reports
(FSR) on a quarterly basis to ensure that funds are not drawn down
before they are needed for immediate cash needs and to ensure that
Federal funds are not being held prior to disbursement.

The TEAM-Web system enables the federal share of outlays (line C) of the
FSR to be generated so that the disbursement data (passed from the ECHO
system) of the grantee can be automatically compared to the data in
TEAM-Web. FTA program managers monitor the TEAM-Web reports for
exceptions or discrepancies.

**ECHO-Web**

The ECHO-Web System is a new, web-enabled application through which
Grantees may request ECHO payments. Currently, the TEAM-Web and ECHO-Web
systems are not integrated but links to the ECHO-Web system may be
available in TEAM-Web in the future.

# DELPHI/DAFIS 

The DELPHI System is the new financial system replacing the Departmental
Accounting and Financial Information System (DAFIS) previously
implemented at FTA. Throughout the system transition, the routine file
transfer process and exchange of data has remained the same with a few
minor modifications for TEAM-Web. DELPHI/DAFIS is the system that
processes all financial transactions submitted through the TEAM-Web
application.

["To DELPHI/DAFIS" Process:]{.underline}

In TEAM-Web, project funds may be obligated, deobligated and authorized
for disbursement. These transactions are recorded in the database
"dafis_out" tables and are processed through stored procedures which
generate ".pln", ".fob" and ".abu" files in the "Data" folder on the
TEAM-Web server. These flat files are transferred nightly via ftp to the
FTA DELPHI/DAFIS system. In the TEAM-Web database, each nightly process
archives the data and refreshs the dafis_out tables.

["To TEAM" Process:]{.underline}

During the automated ftp process, DELPHI/DAFIS transfers a batch control
file (BCF) back to the TEAM-Web server. The BCF contains transactions
that were previously uploaded to DELPHI/DAFIS and have been processed
through FTA accounting. TEAM-Web generates two files from the BCF:
"Accepted.txt" and "Rejected.txt", updates the TEAM-Web database and
loads the "dafis_in" tables with the new transaction data so that
payments, refunds and disbursements will be reflected in TEAM-Web
projects. Any transactions that were rejected by the DELPHI/DAFIS system
are loaded into the "dafis_in_error" table for analysis and resolution.

# JARC

The Job Access And Reverse Commute (JARC) Program Grantee Quarterly
Reporting (GQR) System is an application for the FTA Office Of Research,
Demonstration, And Innovation. The GQR System is a relational database
system that simplifies quarterly reporting and provides the necessary
data to effectively and efficiently evaluate the JARC Program.

The TEAM-Web flash screen displays hyperlinks to JARC-GQR files stored
on the TEAM-Web server. These files include two Microsoft Word documents
(.doc) and two Microsoft Access database files (.mdb). The Word
documents consist of a JARC -- GQR User's Guide and a list of JARC
program contacts. The Access files contain template forms which the JARC
users open to input data into an Access database file. The database file
is then saved to the user's local hard drive where it can be uploaded
into the TEAM-Web system using the TEAM-Web Attachment feature. Once
uploaded, the .mdb files are handled in the same manner as any other
type of attachment file stored on the TEAM-Web server.

In the TEAM-Web application, JARC projects can be identified by Section
of Statute: "TEA-21 3037 - Job Access/Reverse Commute" and/or the
Project Brief Description.