GADS3_Attachment_J_4_Final.pdf

Attachment J-4 | Page 1

ATTACHMENT J-4: GADS3 APPLICATION DESCRIPTION

Application Description

IMPAC II Database Consolidation (IDC) IDC centralizes data needed by all the other GADS tools/systems into one single database repository at NIEHS.

Needed data are downloaded nightly via an automated process from IMPAC II into an Oracle database.

Grants Funding Decision Tool (GFDT) GFDT is designed to manage the external grants funding decision-making process, track the funding plans, and provide transparency into the funding decision-making process.

Supplement Operations System (SOS) SOS provides application tracking, document storage, internal appraisal features, and decision tracking for Administrative Supplements that are submitted to NIEHS. SOS pulls data in from IMPAC II, routes supplements through the review process and commits data back to IMPAC II.

High Impacts Tracking System (HITS) HITS provides a permanent database that allows DERT to dynamically identify and track research outcomes, such as biomarkers, models, collaborations, policies and regulations, patents, new knowledge that helps prevent exposures and disease, and other public health impacts.

Travel Management System (TRIPS) TRIPS is a travel-focused software application designed to establish a comprehensive communication tool between supervisors, travelers, travel planners(division-wide), to ensure the travel process easy for everyone in the process, and to provide transparency into the travel process.

Partnerships for Environmental Public Health Program (PEPH) Resource Center (PEPHRC)

PEPHRC is a Web-based document repository that allows grantees to upload materials of potential use to others. Users can view and “like” materials and use the system for networking, finding like-minded partners.

Who We Fund (WWF) The Who We Fund page is a publicly available reporting tool that provides information about active grants, research topics, assigned program staff and publications.

Scheduled Task: Application Assignment

This Scheduled Task sends an email to the DERT email showing any PCC changes in the two-week time between runs.

Scheduled Task: Generate Active Grantee Email List

This Scheduled Task generates the list of NIEHS active grantee names and email addresses and sends the list to the staff member assigned to update the NIEHS-ACTIVE-PIS listserv.

Scheduled Task: GM Closeout Notification

This Scheduled Task sends an email to the GMOs listing any awarded grant with a budget end date at least 150 days ago which have not been closed out.

Scheduled Task: GM Leadership

This Scheduled Task sends the Grants Management Leadership an aggregated list of awards identified in the PO Closeout Notification scheduled task.

Attachment J-4 | Page 2

Scheduled Task: Grants Workload Details Report

This Scheduled Task sends the GMB Supervisors relevant details about each application assigned to all the GMS' by fiscal year for the current fiscal year, previous fiscal year, and past fiscal year.

Scheduled Task: Human Subjects - Percentile Unsolicited Report (Query 1)

This Scheduled Task sends a completed Word document to the Human Subjects coordinator when an investigator-initiated application submitted in response to the parent RFA for a competing application has a percentile score and falls within the set pay line (<= 10%).

Scheduled Task: Human Subjects Funded Report (Query 2)

This Scheduled Task sends a completed Word document to the Human Subjects Coordinator when a competing application is marked to-be-paid.

Scheduled Task: Human Subjects Superfund Report - Priority Scores Released (Query 3)

This Scheduled Task sends a completed Word document to the HSRB (Superfund) Human Subjects coordinator when an investigator-initiated application submitted in response to the parent RFA for a competing application has a percentile score and falls within the set pay line (<= 10%).

Scheduled Task: Human Subjects Superfund Report - Marked as "To be paid" (Query 4)

This Scheduled Task sends a completed Word document to the HSRB (Superfund) Human Subjects Coordinator when a competing application is marked to-be-paid.

Scheduled Task: Noncompleted Checklist

This Scheduled Task sends an email to the PO and GMS when a type 5 grant with a budget period start date within the next 30 days has a checklist status of “not started” or “in progress”.

Scheduled Task: No Progress Report

When a progress report is overdue, this Scheduled Task sends an email with the pertinent grant data to the Program Officer of record so that the PO can follow up with the grantee.

Scheduled Task: Null PCC

This Scheduled Task sends two queries are to the Referral Coordinator: 1) the list of applications newly assigned to NIEHS and are awaiting PCC codes and 2) the list of applications assigned to ES that arrive in the REV module.

Scheduled Task: PCC Change Notification This Scheduled Task sends an email to the SOS Coordinator notifying her of any PCC changes from the past day

Scheduled Task: Program Officer Notice of Award

This scheduled task provides an email to Program Officers when a Type 1, 2, or 3 application has been funded.

Scheduled Task: PO Closeout Notification This Scheduled Task sends an email to Program Officers when they have a grant in the closeout status for too long a period

Scheduled Task: R35 Mechanism This Scheduled Task sends an attached MS Excel file that identifies researchers eligible for the R35 mechanism.

Scheduled Task: Secondary Assignments

This Scheduled Task sends a report to the Referral Coordinator via email of applications with the term "environmental health" in the abstract.

Scheduled Task: Summary Statements

This Scheduled Task sends a new summary statement, when available, via email each day to the DERT Council Coordinator.

Attachment J-4 | Page 3

Scheduled Task: Time Sensitive Report

This Scheduled Task checks newly refreshed data for new applications in response to the time sensitive PAR and sends the application information via email/Excel file to the Time Sensitive Coordinators.

Scheduled Task: Type 2 Assignment Notification This Scheduled Task sends an email to the referral officer of all current type 2 applications.

Database Task: Import Process to Refresh IDC Data This Oracle Scheduled Task refreshes data from IMPAC II and IDC for NIEHS use daily.

NGA Clearance Daily Email This NGA Clearance Oracle Job runs against IRDBPRD directly to mirror for a task that is running in the Grants Funding Decision Tool.

Study Section Calendar (SSC) The Study Section Calendar Tool promotes staff awareness of Study Section Review for applications assigned to them. The tool facilitates shared coverage for review meetings and one-click access to relevant meeting details.

Grants Budget Forecasting Tool (Budfore) Budfore, not yet in full production status, is designed to be used by DERT leadership to examine various scenarios for allocating the extramural grant budget. It provides the ability to perform "what-if" scenarios using many different variables, such as changes in funding, time, standard cuts and success rates.

ATTACHMENT J-4: GADS3 APPLICATION DESCRIPTION