Attachment 1_EHBs External Interfaces.pdf

Attachment 1: External Interfaces to HRSA EHBs

External Interfaces 1 of 3 Last Update - 12/13/2011

System System Overview System Designation

Communication Mechanism

Communication Direction

Communication Protocol

Comments

Fedgrants.gov Grants.gov (Find) or Fedgrants.gov allows applicant organizations to browse competitive funding opportunities from all grant making agencies in a consistent format.

Federal XML Feed Outbound from EHBs SMTP

Grants.gov (Apply) Grants.gov allows applicant and grantee organizations to electronically apply for competitive and noncompetitive grant opportunities from all Federal grant-making agencies.

Federal Web services Bi-Directional HTTPS

IRMS (Integrated Resources Management System)

IRMS maintains a commitment register based on grants data from the HRSA EHBs.

Agency Specific Database views maintained by the HRSA EHBs

N/A Native SQL Connection

GATES GATES is the Department's Center of Excellence System and is used by the EHBs to perform the following functions:

1. Grant Award certification

2. Interfacing with the department's financial system (UFMS)

3. Interfacing with CLO

4. Interfacing with the departments Tracking Accountability in Governments Grants Systems

(TAGGS)

Departmental XML Feed Bi-Directional SFTP

HRSA Data warehouse The HRSA Data Warehouse serves as the official repository of HRSA’s data and provides a single point of access to HRSA programmatic information, related health resources, demographic, and statistical data for analyzing and reporting on HRSA activities.

Agency Specific Database views maintained by the HRSA EHBs

N/A Native SQL Connection

PMS Payment Management System manages funds disbursement for all HRSA grants and Loans program.

Departmental CSV File Inbound into EHBs SFTP The CSV file is downloaded on a nightly basis.

Once the file is successfully downloaded, it is deleted from the SFTP location.

External Interfaces 2 of 3 Last Update - 12/13/2011

CCR Central Contractor Registration (CCR) is the official, on-line registrant database for the U.S.

Federal Government. CCR collects, validates, stores and disseminates data in support of agency acquisition and award missions.

Grants.gov validates an organization against CCR registration before providing user credentials to apply for a grant.

Federal CSV File and Web services

Inbound into EHBs REST HTTP POST or SOAP

CCR integration is expected to be completed in the Apr/May 2012 timeframe. Once integrated, organization related information such as DUNS number will flow into EHBs from CCR real time.Currently, the DUNS number and certain information about an organization is received from grants.gov where the users of an organization register themselves to apply for a grant. The goals for the integration with CCR include: 1.)

retrieving necessary information about an organization from CCR and storing the data in EHBs (using web services), 2.) verifying the validity of an organization (using web services) and 3. )Regularly updating organization information (using CCR extracts csv file) that is relevant with respect to Grants without any manual intervention.

UFMS UFMS (Unified Financial Management System) is a business management tool that provides relevant, reliable and timely information to improve the efficiency and effectiveness of financial, business and operational functions.

UFMS acts as a staging area for PMS (Payment Management System). UFMS validates the information and then transmits it on to PMS.

Departmental Fixed length text file. Outbound from EHBs SMTP Currently, closeout and Loan awards with one or more funding items from HRSA EHBs are sent to UFMS via an email in the form of a fixed length text file. All transactions other than Closeout and Loan awards are transmitted to UFMS by GATES.

ARM ARM is part of the services offered by the Departmental Grants Center of Excellence managed by ACF. ARM is the System used by HRSA to perform independent reviews of applications submitted for Competitive funding opportunities.

Departmental Web services Bi-Directional HTTPS DIR Staff export the Reviewer Information and Application data from EHB to ARM via web service. Once reviews are completed in ARM DIR imports the Rank Order List (ROL) and the Summary statements for the reviewed applications in to EHBs.

External Interfaces 3 of 3 Last Update - 12/13/2011

CLO Notification to the Congressional Liaison Office (CLO) is required in order to assure that members of Congress receive prompt notification of grant and cooperative agreement awards. It also enables the Department's Congressional Liaison Office (CLO) to plan adequately for the announcement of grants when they are awarded.

Federal Fixed length text file. Outbound from EHBs SMTP Currently CLO communcation around all new and competitive awards is handled by GATES. In case of batch awards EHBs transmit CLO notification date to GATES and then notifies CLO. CLO allows the notification to be communicated over email with a text file containing variable length records delimited by “|”.

Enterprise Sites Repository

Central repository of all performance locations where HRSA related activities (grant and non-grant) are either occurring or are being proposed to occur.

Agency Specific Web Services; Database views;

Bi-Directional HTTPS; Native SQL Connection

Currently only BPHC related H80 activities and look-alike activities are integrated with this repository.

EHB Integration Services (EIS)

EIS is a XML based API which exposes a set of schemas to both retreive as well as to populate information from and into the HRSA EHBs database. EIS allows systems to communicate with the HRSA EHBs without having direct DB connections. Currently EIS supports 70 distinct schemas around the application/grant/award entities within the HRSA EHBs

Agency Specific XML Feed Bi-Directional HTTPS

GovDelivery GovDelivery is a public communication solution, offering an automated Email and Digital Subscription Management platform to government. The EHBs uses REST Based web service API's to provide Govdelivery with HRSA grantee information which in in turn used by Govdelivery for broadcast communications and campaigns.

COTS Tool Web services (REST based architecture)

Outbound from EHBs HTTPS

Sheet1