USDA RD App Sustain_List of Systems Supported.pdf

Platform AppName Descriptions OS Additional AppInfo Target EOL Incidents Service/Change Requests PaaS

Account Cross Reference (ACR) Web Services (WS) A collection of web services that support eGovernment initiatives and systems that supply customer information. Customer initiated payment (CIP) is a web service that interfaces to Pay.Gov and another web application that allows borrowers to access their SFHD/RUS loans and make payments over the web. There is no graphical user interface. The Account Cross Reference (ACR) is a service that provides a social security number translator with a data warehouse front that masks social security numbers with a certificate‐based value. RDCensus is a service that provides needed information for various RD programs in order to calculate eligibility and rates related to census numbers. It also serves as a web service pass through for RD applications

RHEL 6 Apache 2.2

RHEL 6 Tomcat 6.0 Address Verification Address verification is a Web Service that takes a street address, does a Microsoft Bing lookup for that address and returns the geographic coordinates for the latitude and longitude of that address.

RHEL 6 Apache

RHEL 6 JBoss RHEL 6 Squid

Adobe Experience Manager (AEM) Other applications (including GLS, RDApply, MFIS, GUS, GAF) will make a request to this webservice to retrieve PDFs

RHEL6 Apache 2.2 3 20

RHEL7 Adobe AEM Application Authorization System Management (AASM) Application Authorization Security Management System (AASM) provides external user security for the GLS Web Suite Application RHEL6 Apache 2.2 34 933

RHEL6 Jboss EAP 6.4

RHEL6 DB2 10.5

Application Project Reporting (APR) Additional project reporting, Target Audience (public, authenticated, USDA Backbone only): USDA Backbone only

RHEL 6 Apache 7

RHEL 6 JBoss Automated Reports Tracking System (ARTS) Automated Review Tracking System (ARTS) An audit tracking application that allows the Financial Management Division (FMD) and state Management Control Officers to enter audits and related information

Windows 2016 ISS 7.5 &.NET 4.0 6

Windows 2016 MS SQL Server Benchmark Management System (BMS) Benchmark Management System (BMS) This application is a management tool for communities to identify best practices and stories for wider application, to spot problems early and target technical assistance, to streamline the flow of information, and to demonstrate accountability

RHEL 6.9 Apache 2.2 1

RHEL 6.9 JBOSS EAP6.4

Windows 2016 MS SQL Server

Business Rules Management System (BRMS/FICO Blaze) FICO Blaze Engine provides a rule‐based engine that allows applications with APIs for rule‐based interfaces for applications requiring rule‐based processing

RHEL 6 Apache 2.x 1

RHEL 6 Jboss 5.x Broadband Application Information Log (BAIL) Broadband Application Information Log (BAIL) This application provides the capability to record application information for broadband applications and to monitor the status of each application. It also manages company information, allows broadband staff to post public notice filings and has interfaces with the CLSS system

Windows 2016 IIS 7.5 & .Net 4.0 1

Windows 2016 MS SQL Server

12 Mo. PSO Operations FA2 Information

App Sustain_List of Systems Supported

Broadband Collection and Analysis System (BCAS) Broadband Collection Application System (BCAS) Provides the capability for the RUS Telecommunications Broadband Division staff to collect Broadband Borrowers’ historical 5‐year pro forma financial data and actual quarterly/monthly financial data

Windows 2016 IIS 7.5 & .Net 4.0 25

Windows 2016 MS SQL Server Budget Information Control System (BICS) The BICS system is a web application developed to automate and streamline the data handling, data analysis and to document the production process during the various budget phases, within the Budget Division of USDA Rural Development. The system was designed to provide a central repository for data for all the Budget Division branches: Credit Reform Staff (CRS), Administrative Program Branch (APB), and Program Budget Branch (PBB). The system aggregates relevant program information received from various sources that are both internal and external to the Budget Division (e.g. RD Program Area, DCFO, and CSC). The Budget Division Director and staff can retrieve data, analyze the data, and also generate various reports that are used for submissions during the fiscal year.

Furthermore, the BICS system stores data/information related to all loan and grant programs maintained by the Budget Division.

However, currently the system only handles data for the CRS branch within the Budget Division. Staff from the other two Budget Division branches, i.e., PBB and APB, can view this data and use it for their own internal processes. Anytime new program information is available, BICS users that have the appropriate application access permission can upload the new data into BICS.

The new data is required to be in a certain format as specified by BICS. After importing the data, the user may optionally send notification emails to other users of BICS informing them about the availability of new data.

Windows 2016 IIS 7.5 2 16

Windows 2016 MS SQL Server Broadband Search Application (BSA) Broadband Service Areas (BSA) Allows prospective customers to draw service areas of where they shall or already provide broadband services to. It also allows the public to visually see all funded service areas, pending application service areas and to file responses to public notice filings

RHEL 6 Apache 2.2 2 7

RHEL 6 JBoss EAP 6.4 Windows 2016 MS SQL Server

Call Pegging (Call Peg) Call Peg is a software application designed to provide USDA CSC with a tool to capture call data. Some of the data captured include account number, reason(s) for call, teller/rep answering the phone and date/time along with some current account data.

Windows 2016 IIS 7.0 16 11

Windows 2016 MS SQL Server

Commercial Loan Servicing System (CLSS) CLSS is being developed to replace functionality of the old, obsolete, labor‐intensive RUS Legacy System. CLSS tracks and services the Rural Development’s Commercial direct loan and grant programs’ borrowers, obligations, loans, grants, and payments. The current functional components/modules utilized in CLSS are as follows:

•Borrower Directory Management System (BDMS) •Loan and Grant Management System (LGMS) •Community Programs •RUS Loan Servicing (RLS) •Cash Applica on Module (CASH) •Reports •Administra on/MyCLSS/Table Maintenance

RUS Legacy is a mainframe system that maintains USDA Rural Utilities Programs borrower account information. RUS Legacy System is an IBM mainframe‐based computer post loan servicing application. The system’s primary functions are to perform post loan advances, collections, and adjustments. The system also provides a user interface for customers to run its many post loan processing functions and to generate reports. RUS Legacy is comprised of separate modules as follows:

•Rural Electric and Telephone (RET)‐Electric Only •Federal Finance Bank (FFB) •Loan Document System Applica on (LDS applica on) Commercial Support consists of separate applications which provide various support services to the Commercial Investment and i h i f

RHEL 6 Apache 2.2 14 52

RHEL 6 JBoss EAP 6.4

RHEL 6 DB2 10.5

RHEL 6 OpenSSH RHEL 6 Active MQ 6 RHEL 6 Active MQ 6

Community Programs Application Processing (CPAP) The Commercial Program Application Processing (CPAP) system is used by Rural Utilities Service (RUS) and Rural Business Service

(RBS).

Water and Environmental Programs (WEP) and Community Facilities (CF) personnel utilize CPAP for processing and tracking of WEP and CF loan and grant applications as well as servicing actions for loans and grants. The data entered into CPAP includes all data required to process the loan or grant obligation, generate required forms, and generate Tabular Data Warehouse (TDW) reports. The design of CPAP facilitates the processing by RD personnel of applications on behalf of Rural Utilities, Rural Business, and RD customers.

Electric and Telecommunication utilize CPAP for capturing customer application data beginning with pre‐ application thru application approval, rejection or withdrawal. Borrower activity including visits and communications are captured as well as other General Field Representative (GFR) related activities. Customer documents such as Load Forecast, Construction Work Plan, Financial Plan, Long Range Plan, and the like are captured in CPAP. Electric and Telecom GFRs also utilize CPAP to process and track procurement and expenses.

Windows 2016 IIS 7.0 44 64

Windows 2016 MS SQL Server Compliance Sheriff 508 Compliance tool Windows 2016 IIS 8.0 2

Credit Reform Data Store (CRDS) Credit Reform Data Store (CRDS) The Credit Reform Data Store application is an EssBase application that allows the National Financial and Accounting Operations Center (NFAOC) to manage credit reform, create scenarios, and create projections for funding needed from US Treasury in order to be able to make loans and grants. EssBase is a part of the Business Intelligence solution

RHEL 6.0 Apache 2.2 3

Solaris 11 Oracle EPM 11/Essbase Customer initiated payment (CIP/UPCIP) Web Services (WS) A collection of web services that support eGovernment initiatives and systems that supply customer information. Customer initiated payment (CIP) is a web service that interfaces to Pay.Gov and another web application that allows borrowers to access their SFHD/RUS loans and make payments over the web. There is no graphical user interface. The Account Cross Reference (ACR) is a service that provides a social security number translator with a data warehouse front that masks social security numbers with a certificate‐based value. RDCensus is a service that provides needed information for various RD programs in order to calculate eligibility and rates related to census numbers. It also serves as a web service pass through for RD applications

RHEL 6.0 Apache 2.2 10 16

RHEL 6.0 Jboss 6.4 Data Collection System (DCS) RUS collects and processes loan data to oversee companies that have borrowed funds to develop rural utilities. RUS requires borrowers to submit financial information on an annual basis, while some borrowers submit on a quarterly or monthly basis. RUS employs three forms – Forms 7, 12, and 479 – by which borrowers submit/file data to the agency. The Forms 7 and 12 are used for collecting data about electric borrowers. The Form 479 is used to monitor telecommunications borrowers; this form is similar to Forms 7 and 12 in both form and content.

The data collection system will also make use of borrower financial data currently serviced and stored in RUS Legacy Loan Accounting System. RUS’ loan statisticians will analyze and evaluate the data submitted by the borrowers.

RUS will produce the Annual Statistical Report and Borrower Statistical Profile documents from the data processed and maintained in the Data Collection System.

Windows 2016 IIS 4 173

Windows 2016 MS SQL Server DocFactory Document Factory (DocFactory) This application implements an enterprise document assembly solution utilizing the COTS package Exari to implement a system and workflow that aids in the selection and assembly of appropriate documents using data from other systems and/or data retrieved via an interview process. DocFactory for the Electric program area is in production

RHEL 6.x Apache 2 1

RHEL 6.x Tomcat eFile Suite eFile Suite The eFile suite is a series of applications for the support of electronic forms use for employees and the public. There is an FSA application that allows customer to submit Electronic Loan Deficiency Payments (ELDP) The only customer, Harvest States, is not submitting CCC‐633LDP transactions to FSA due to commodity market strength and therefore the site is currently inactive, but that could change. There is also a portal that allows public access to forms for FSA and RD. Forms can only be view and printed withan eAuth ID. To submit form customers shall sign in with an eAuth ID to MyForms. There is an application that allows service center employees to retrieve forms/packages from customers who submit from MyForms. There is also a management application that allows Forms Managers from FSA and RD to promote forms to the eForms Suite

RHEL 6.0 Apache 2.2 1 9

RHEL 6.x Tomcat Eligibility Eligibility The Eligibility application contain two components. There is a website that is used to maintain county textual descriptions of property eligibility for RD direct and guaranteed loans. There is also a public facing website listing income eligibility requirement and displaying maps showing eligible loan areas. It allows public customers to enter addresses to determine if they fall with RD eligible areas

RHEL 6.0 Apache 2.2 56 13

RHEL 6.0 JBoss 6.4

MS 2012 MS SQL 2012

Eligibility Manager Eligibility provides Income/Property Eligibility for a loan/Property Application for the USDA Rural Direct/Guaranteed Loan programs.

This application analyzes the submitted income and determines if the income amount is within the allowable range ranges for each specified program. The Property component of the application will determine if the address falls within in an allowable area for the program specified. The property service calls the rdgisservice to determine if the property is eligible

RHEL 6.0 Apache 2.2 1

RHEL 6.0 Tomcat 6.0

MS 2012 MS SQL 2012

Linux Salesforce

Enterprise Cash Management System (ECMS) ECMS centralizes disbursements and collections processing from RD servicing and obligation systems to Treasury and fulfills Treasury Account Symbol (TAS) and Business Event Type Code (BETC) processing requirements. ECMS operates in the DISC (formerly NITC) HA Cloud Production environment. ECMS was developed using the CLP Framework (Spring 3 Core, Rich Faces 4.x, Java Server Faces (JSF), and Spring Web Flow). The ECMS database is DB2 UDB.

ECMS is deployed on Red Hat EAP 6.2. ECMS receives disbursement data from GLS, PLAS, CLSS, AMAS, and LoanServ (a dedicated loan origination servicing system) as structured data files through Control‐M jobs. ECMS stores data from these systems in DB2 for reporting, administrative action, and response processing. ECMS outputs Treasury’s Payment Application Modernization (PAM) compliant xml with TAS/BETC data for each disbursement file received. Each PAM file is transferred to Operations Scheduling Branch (OSB) through Control‐M jobs for transmission to Treasury using Direct Connect. OSB receives Treasury PAM response files and executes Control‐M Jobs that move them to ECMS. ECMS process PAM response files.

NFACO staff logs in to ECMS to produce reports and take and required administrative action to complete disbursement processing. Additionally, ECMS produces PAM summary files required by Treasury to finalize and validate Disbursement requests, named SPF440 Summaries. These files are moved by Control‐M jobs from DISC (formerly NITC) Cloud HA to Web Farm 3 utilizing two Linux “Pivot” files servers. The final location for these fil i di hi i i d f lfill h

RHEL 6 Apache 10 46

RHEL 6 JBoss EAP 6.4

RHEL 6 DB2

RHEL 6 N/A

Electronic Funds Transfer (EFT) Electronic Funds Transfer (EFT) provides the government to directly deposit funds into borrower/lender bank accounts

RHEL 6 Apache 7

RHEL 6 Tomcat 6.0

Z/OS 2.3 DB2

Enterprise Lifecycle Management System (ELMS (MKS)) Source code management and work tracking Solaris 11.3 Oracle 11g 1st QTR. FY21 17 77 Windows 2008 R2 .Net Server Windows 2008 R2 .Net Server

EPM 11 (Hyperion) Real‐time and historical reporting against the TDW and against live application live data sources.

Real‐time data source examples: PFCS, AASM, ECMM, CLSS

RHEL 6 Apache 2.2 FY21 64 189

Solaris 11 Web Logic 10.3 Solaris 11 Oracle 11g

Equipment Acquisition Management System (EAMS) Equipment Acquisition Management System (EAMS) Used by RD and the Customer Experience Center to streamline the procurement process for new purchase requests as well as the replacement and/or repair of existing items

Windows 2016 IIS 7.5 & .NET 4.0 1 11

Windows 2016 MS SQL Server Farm Service Agency Guaranteed (FSAG) Agency users will log onto the GLS system and navigate to the Loan

List page. Options off of the Loan List page include JSPs that display FSA loan and Credit Bureau data. Data will be extracted from the mainframe, FTPed to PINKP1 and then sent to credit bureaus (Experian, Equifax and Dun and Bradstreet) on a monthly basis

RHEL 6.0 Apache 2.2 54

RHEL 6.0 Tomcat 6.0

Guaranteed Loan System (GLS) Guaranteed Loan System (GLS) provides servicing of the RD and Farm Service Agency (FSA) Guaranteed Loan Portfolio from pre‐ application, obligation closing, servicing, and termination, as well as Lender monitoring. Guaranteed Loan System (GLS) provides servicing of the FSA Guaranteed Loan Portfolio from pre‐ application, obligation closing, servicing, and termination, as well as

Lender monitoring. •Renewable Energy/Energy Efficiency (REEE) Provides the capability to report on renewable energy loans and grants across programs in RD, imports data from GLS. REEE is also used as a decision support system to track grants provided to borrowers for the REEE programs.

Windows 2016 ASP.Net 235 1044

Z/OS 2.3 DB2

Grants (GIM) Grants Interface Module (GIM) The Grants interface module is an application that allows USDA employees to review grant applications submitted by citizens through Grants.gov in an automated efficient and effective manner. The application has an interface to Grants.gov and systematically pulls applications submitted to USDA agencies into GIM

RHEL 6 Apache

RHEL 6 JBoss Windows 2016 MS SQL Server

Guaranteed Annual Fee (GAF) Assessing, billing and collection of annual fees on SFH guaranteed loans.

RHEL 6.0 Apache 3 102

RHEL 6.0 JBoss 6.4.5 Guaranteed Underwriting System (GUS) Guaranteed Underwriting System (GUS) allows the lender to create

Single Family Housing application packages that shall be uploaded into GLS for processing

RHEL 6 Apache 221 1089

RHEL 6 DB2

RHEL 6 JBoss

General Support System Toolchain (GSS) Tool Chain The RD General Support System has been designed and tested as the agency’s method of modernizing application development to support agile and incremental delivery of RD CIO Application Development. Currently across RD there is a decentralized method of software development that is aging and does not support modern methods integration, testing, deployments, and agile methods of software deployment. Our mission for the General Support Systems is to build an environment that will have the capability to support multiple lower environments and ability to deploy tools to facilitate the modern methods of application development. The General Support Systems environment will host the DevOps Tool Chain. One of the main goals of this implementation, other than modernizing application development tools, it to provide Agency traceability from the inception of the business need through production deployment and throughout the production lifecycle. The General Support System environment will host the DevOps and Security Tool Chain which consists of Confluence, Jira, Jira Service Desk, BitBucket, Git, Sparx, MS Project Online, ArtiFactory, Jenkins, Compliance Sheriff, Selenium, IBM AppScan, Burp Suite Professional, Checkmarx, and Microfocus Web Inspect.

RHEL 7 Apache

Solaris Oracle Lead Based Paint Lead Based Paint (LBP) This is a public facing application that provides guidance on lead‐based paint regulations/compliance. It prints out reports on the compliance requirements and allows users to make and retrieve their notes on the case

RHEL 6 Apache 1 1

RHEL 6 JBoss EAP 6.4

Lender Interactive Network Connection (LINC) Lender Interactive Network Connection (LINC) is the portal used by external customers to access specific, limited data with GLS

RHEL 6.0 Apache 2.2 28 694

RHEL 6.0 Tomcat 6.0 Management Agent Interactive Network Connection (MINC) Management Agent Interactive Network Connection (MINC) allows transmission of Tenant Transactions and Budgets, verification and approval of Bills and access to the Task Calendar and Income Limits

Windows 2016 IIS 3 646

MFH Services/Rentals MFH Rentals displays USDA MFH projects with basic property and contact information

RHEL 6.0 Apache 2.2 1 1

RHEL 6.0 Tomcat 6.0 Solaris 11.3 Oracle 11g

MFIS Mobile RD Mobile Apps consists of mobile applications that allow users to dynamically download project inspection and review itineraries, capture the results on a mobile device, and upload these results back into their parent system for processing. These mobile applications have been developed for Native iOS using XCODE and Cross Platform Development (iOS, Android, and Windows) using C# with Mobile Forms XML framework and Xamarin. These mobile applications interface with web services developed in Java that are deployed on Tomcat 6 Linux servers that communicate with the Oracle 11g (MFIS) and DB2 for z/OS (GLS) databases.

The current and soon to be mobile apps that are utilized in the Mobile Apps suite of products are listed below:

Multi‐Family Housing Inspection Apps There are 3 apps are currently used for Multi‐Family Housing: MFIS Physical Inspection, MFIS Management Review, and MFIS Tenant Review. These apps provide USDA RD servicing office personnel the ability to perform inspections on the overall physical condition of the projects, reviews of the management and tenant files, and capture photographs of violations. Upon return to their office the RD resource uploads the captured results into the MFIS system.

RBS This app shall provide USDA RD servicing office personnel the ability to perform field visit reviews of RBS lenders and borrowers.

Upon return to their office the RD resource uploads the captured results into the GLS system.

SFHD This app shall provide USDA RD servicing office personnel the ability to assist potential borrowers with population of their loan application and personal budget/financial statement. Upon return h i ffi h l d h d i f i

Windows 2016 IIS Server v7.5 3 24

Red Hat 6.9 Tomcat 6.0 Solaris 11.3 Oracle 11g

Monitoring Program Compliance/Civil Rights Applications (MPCCRA) Civil Rights Applications The Civil Rights applications contain two components. The first is Monitoring Program Compliance (MPC). It enables the RD Civil Rights Staff to monitor complaints, corporate compliance, and other case demographic information. The application provides the capability to receive a complaint, determine if the complaint is a civil rights issue, and maintain and track the complaint process. The system includes functionality to receive and track Borrower’s equal opportunity policies and statistical information also. The second component is the Program Civil Rights Reporting Application (PCRRA). This enables the RD Civil Rights Staff to implement a reporting system to accurately report Civil Rights Complaints and Actions

Windows 2016 IIS

Windows 2016 MS SQL Server Mortgage Link (Loan Serv)/Loansrv (DLOS) site providing links to different sites hosted for RD RHEL 6 Apache

Z/OS 2.3 VSAM 12 295

Multi Family Information System (MFIS) Multi Family Information System (MFIS) provides functionality for Project Tracking, Monthly Billing, Tenant Tracking, Reserve Account Tracking and Financial Statements

Windows 2016 IIS 7.5 8 271

Red Hat 6.9 Tomcat 6.0 Solaris 11.3 Oracle 11g

Multi‐Family Housing Guaranteed (MFHG) Agency users will log onto the GLS web menu and select the Rural Housing Menu for access to MFH Guaranteed functionality. The application is consistent with other GLS program areas. There are MFH options on the RHS Menu that allow users to navigate to a Request List which displays existing funding requests and provides links to associated web pages used to capture, approve, obligate, close, and service a MFH Guarantee Loan. Administrative options on the RHS Menu allow the MFH program staff to establish and monitor funding and maintain program control information

RHEL 6.0 Apache 2.2 1 3

RHEL 6.0 Tomcat 6.0 RHEL 6.x DB2

Multi‐Family Information Systems Java (MFHJ) MFH servicing office specialists load CNA spreadsheets into MFIS to track progress of Agency properties towards meeting comprehensive needs goals. MFH servicing office specialists produce VDS spreadsheets for properties that have left the projects and need rental assistance vouchers to supplement their rent in non‐government sponsored housing. The National Office allocates rental assistance dollars to the individual states. MFH servicing office specialists obligate the money using MFHJ generated MRA transactions into AMAS.

RHEL 6.x Apache 2.x

RHEL 6.x Tomcat 6.0.24 Solaris 11.3 Oracle 11g

National Office Reserve Funds (NORF) NORF allows national office users to set up and maintain Reserve Funds of various types and state office users to make requests for those Reserve Funds based on customer need. A national office users will set up at least one Reserve Fund per FY year, and the state office users will submit requests, which are reviewed by a national office user and either accepted or rejected

RHEL 6.X Apache 1 39

RHEL 6.X JBoss

RHEL 6.X MSSQL

Performance Management (PM) Performance Management (PM) The first set of applications consolidated into the Performance Management system are Additional Project Reporting (APR) and Faith Based and Community Initiatives (FBCIR), followed by Data Collection System (DCS) and Broadband Collection Application System (BCAS), and then additional systems to be named at a later date. The system is developed utilizing the CLP framework

RHEL 6.X Apache 2.2

RHEL 6 Jboss EAP 6.4 Pre‐Authorized Debit (PAD) Pre‐Authorized Debit (PAD) maintains Banking and Account information and interfaces with Treasury RHEL 6 Apache 2.2 2 2

RHEL 6 Tomcat 6.0 Preservation Information Exchange (PIX) Preservation Information Exchange (PIX) Allows Nonprofits and

Public Bodies to display basic property and contact information for MFH Projects that have applied to prepay MFH Loans

RHEL 6 Apache 2.2 2

RHEL 6 Tomcat 6.0

Program Funds Control System (PFCS) PFCS provides funds control for RD and FSA loan and grant programs. PFCS interfaces with all major financial accounting systems‐ Guaranteed Loan System (GLS), Automated Multi‐Housing Accounting System (AMAS), Program Loan Accounting System (PLAS), LoanServ, and Commercial Loan Servicing System (CLSS)‐‐ providing core financial accounting loan and grant program funds control at multiple budgetary levels (Appropriation, Apportionment, Allotment, Program Distribution, and Allocation).

PFCS also performs funds checking for disbursements for GLS, AMAS, and CLSS. PFCS sends all transaction information at all budgetary levels to the RD Data Warehouse and maintains the same information within PFCS.

PFCS uses Oracle Federal Financials, PL/SQL, Oracle Reports, Oracle Forms, and Hyperion. PFCS currently has MQ Series based integration to PLAS using JMS and XML. It has a web service for GLS, LoanServ, CLSS, and AMAS. Other technologies supporting PFCS include Solaris UNIX 11.3, Oracle RDBMS 11gR2, Oracle EBS 12.2, Oracle Fusion MiddleWare 11g; SOAP XML WebServices (2) for GLS, LoanServ, CLSS, and AMAS

Solaris 11 Apache 2.2 12 233

RHEL 6 JBoss EAP 6.4 RHEL 6 JBoss EAP 6.4 Solaris 11 Web Logic 11 Solaris 11 OID Solaris 11 OAM Solaris 11 Oracle DB 11

Pre‐Trac Prepayment Tracking (PRE‐TRAC) Used to process and track MFH Project Prepayment Requests. PRE‐TRAC is used to determine if a project can prepay its loan to USDA or be provided incentives to keep the project active. Incentives are available when it is determined that the project is ‘needed’ by the Rural Community where it resides

RHEL 6.x Apache 2.x 49

RHEL 6.x Tomcat 6.x Solaris 11.x Oracle 11g

REO Properties State and National office personnel input detailed property information into a database through the application. The general public can access the application to search for various types of government property for sale.

RHEL6 Apache 2 34

RHEL6 Apache RHEL6 JBoss EAP 6.4 RHEL6 SQL Server

Rural Business Relending Program The application will enable business enrolled in the re‐lending program to manage their portfolio. It will also allow loan applicants to submit their service area maps online

RHEL 6.0 Apache 2.2

RHEL 6.0 Tomcat 6.0

RUS App Intake (RD Apply) The RD Apply system was developed to facilitate the intake of RUS loan applications for the Electric, Telecom, and WEP programs. RD Staff accesses that system to check for completeness and assists public users with questions. Public customers access the system to input company data, project proposals, funding requests, and other relevant information.

RD Apply operates in the DISC (formerly NITC) HA Cloud Production Environment RD Apply was developed using the CLP Framework (Spring 3 Core, Rich Faces 4.x, Java Server Faces (JSF), Spring Web Flow, Hibernate) RD Apply database is Oracle 11g (RMDB) RD Apply is deployed on Red Hat EAP 6.2

RD Apply security and roles are managed with a combination of interfaces between RD Apply, eAuth, and AASM. The system queries existing borrower’s 'customer' data from CPAP, and the Borrower Data Management System (BDMS). The System stores customer uploaded attachments, and certifications in the Electronic Customer File (ECF). RD Apply has a built‐in module that allows users to draw service areas over a map and exchange information with geospatial data centers. These results are stored in the Geospatial Data Warehouse (GDW). Once an application has met all data quality checks, and passed validations for completeness, the discreet application data is formatted into document forms and sent to ECF. RD Apply interfaces with the Tabular Data Warehouse (TDW) sending transactional data on a nightly basis.

RD Apply interfaces with 2 legacy processing systems (BAIL, and

) h h ff l b i d

RHEL 6 Apache 2.2 17 461

RHEL 6 JBoss EAP 6.4 RHEL 6 Oracle 11g

Self‐Help Automated Reporting & Evaluation System (SHH) Self Help Housing (SHH) This system is a web‐based java application built upon the CLP framework. It manages tracks, evaluates and reports on the status of the Self‐Help Housing Section 523 Grant Program as well as shares this information with all parties that provide assistance to this program

RHEL 6 Apache 6 73

RHEL 6 JBoss Solaris 11 Oracle

Single Family Housing Loss Claims Single Family Housing Loss Claims allows the Lenders to submit Loss Claim requests directly into GLS for approval/processing.

Windows 2016 ASP.Net 1 20

TDW‐Informatica Rural Development (RD)currently uses the tabular data warehousing server for their data warehousing needs. The TDW database consists of an Oracle RDBMS database that houses data warehousing data for the Rural Development agencies and its field offices. It will serve as a DW repository for other applications that are/will be hosted in the Hosting DISC Paas HA infrastructure as well as outside of the DISC HA.

Solaris 11 Informatica 169 152

Unifi UniFi is used by RD field users (at state, district and local office level), along with users from the Customer Service Center in St.

Louis and National Office support staff in both Washington D.C. and St. Louis. Users create and update proposed borrower application and financial data supplied from the borrower and other sources such as employers, credit agencies, etc. This information is used to fully review and underwrite each loan application to determine the credit worthiness of proposed applicants and to determine if the properties that loans are being applied for are adequate for the Single Family Housing – Direct loan programs available. During the application creation and update process, data is transferred to the LoanServ loan servicing system (a Fiserv product – currently on a mainframe platform). The UniFi application also has connectivity to the credit provider, Equifax, in order to obtain a proposed borrower’s credit data for verifications of a borrower’s credit worthiness. UniFi does also connect to an underwriting web service (named Direct‐US) for further analysis of a borrower’s and an overall loan’s level of risk. Once a loan is underwritten and approved, the loan is placed in a closed state and loan servicing is done in LoanServ

COTS – BSD based 145 2026

COTS – BSD based Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS Windows 2012 R2 COTS

Value‐Added Producer Grant Program (VAPG) Value Added Producer Grants (VAPG) A mechanism to allow the RD Business and Cooperative Programs staff to post Value‐Added Grant applications to a website so that both internal and external reviewers of the applications can download them in a secure way

Windows 2016 IIS 7.0 6 196

Salesforce HBIIP The HBIIP system was developed on the Salesforce platform to allow rural businesses to quickly and easily apply for federal grants and allows the agency to track and report data and other program requirements

Salesforce 112

Reconnect The ReConnect system was developed to facilitate the expansion of broadband services to rural areas by awarding grants and low interest loans to eligible broadband service providers in underserved areas. ReConnect Program is to expand broadband service to rural areas without sufficient broadband access, defined as 10 megabits per second (Mbps) downstream and 1 Mbps upstream. The first round of applicants have three separate funding categories to choose from: 100 percent (%) loan, 50% loan/50% grant, or 100% grant. To be eligible for a 100% loan or 50% loan/50% grant, the proposed funded service area in an application must be in a rural area where 90% of the households do not have sufficient broadband access

Salesforce 4 285

URLA/Prosperity Gateway (GUS‐2) Modernization of the GUS application. Guaranteed Underwriting System (GUS) allows the lender to create Single Family Housing application packages that shall be uploaded into GLS for processing

Salesforce

Employee Portal (OneRD) The Employee portal application was developed to establish a customer portal for the Business Center on Salesforce to support administrative and service requests. This application provides a modern platform that automates mission support workflows such as HR, CFO and Procurement

Salesforce 197

Mainframe Specific

Automated Mutli‐Family Accounting System (AMAS) AMAS is one of RD’s official accounting and financial management systems and supports the Multiple Family Housing loan and grant programs. AMAS is an on‐line transaction entry and inquiry financial and accounting system accessed by over 200 field offices, National Office, and Finance Office. Updates are done nightly in a batch mode using Control‐M as the primary scheduling tool. The National Office is the primary user of AMAS and the Finance Office has overall operational, financial, and accounting responsibility for RD. Approximately 1 million transactions are processed to the system annually. AMAS functions include: online appropriation accounting; on‐line inquiry and transaction input; loan making and loan servicing transaction updates; acquired property inventory;

daily register, balancing, and program reporting; and fiscal and financial reporting. The AMAS system currently consists of about 400 COBOL (600,000 lines of code) programs and 9 subsystems.

The on‐line system is written primarily in ADS‐0 with some usage of DC‐COBOL, and is made up of about 300 maps and dialogs. There are approximately 300 Job Control Language (JCL) members.

Structured programming techniques have been used.

The architecture for AMAS and all Services includes Rumba and Mocha accessing the Mainframe apps hosted at DISC’s (formerly NITC) Mainframe. Endeavor and ELMS are used for configuration management and version control. The choice of tool set and architecture will be determined by the COR using the approved suite of tools approved by the Agency. To supplement servicing, Multi‐Family Information System (MFIS) was designed to monitor the management of the Multiple Family Housing program through j i i h h d li d ki f i d

Z/OS 2.3 IDMS V18.5 18 32

Program Loan Accounting System (PLAS) PFCS Accounting System Z/OS 2.3 IDMS V18.5 6 109 FOCUS Mainframe reporting DB Z/OS 2.3 FOCUS 3 68 Endevor source code management and release management tool for mainframe Z/OS 2.3 Endevor 2