Attachment 11 RD Application Technology Matrix.xlsx
XLSX spreadsheet 78 KB Posted
- Attached to
- RD Application Sustainment Operations & Maintenance Support Federal contract opportunity
- Solicitation number
- 12SAD125R0002
About this file
The file is an Excel-based Application Technology Matrix detailing the comprehensive IT systems and applications supporting the USDA Rural Development (RD) technology portfolio across multiple program areas including Guaranteed Loans, Single Family Housing Direct, Commercial Lending, Multi-Family Housing, Enterprise Support Services, and Salesforce-based applications.
The matrix provides granular details on 65 distinct applications, including their infrastructure, software platforms, databases, and historical ticket volumes across three fiscal years. Key systems include the Guaranteed Loan System (GLS), LoanServ, Commercial Loan Servicing System (CLSS), and Salesforce-based applications like ReConnect and the Guaranteed Underwriting System (GUS2). The applications support critical functions such as loan origination, servicing, payment processing, reporting, and program management across rural housing, utilities, and economic development initiatives. Notably, the Salesforce applications represent a significant portion of the portfolio, with ReConnect and the Higher Blends Infrastructure Incentive Program (HBIIP) showing substantial ticket volumes and strategic importance to rural development programs.
View the file
Other files for this federal contract opportunity
Show all 17
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Combined
| Application/System/Process | Description | Infrastructure | Software | Front End | Mid-Tier | Database | Historical Ticket Count SE | Historical Ticket Count PSO | SE 3 year Total | Total % | PSO 3 Year Total | Total % | ||||
| FY 22 | FY23 | FY24 | FY 22 | FY23 | FY24 | |||||||||||
| GUARANTEED/DIRECT | ||||||||||||||||
| Guaranteed Loan System (GLS) | GLS is an online transaction entry and inquiry financial and accounting system that records and manages obligations, servicing, and loss claims for guaranteed programs, as well as managing and monitoring lenders. | Windows | IIS | N/A | DB2 | 546 | 210 | 444 | 241 | 182 | 183 | 1200 | 21.13% | 606 | 5.97% | |
| Electronic Status Reporting (ESR) | ESR captures current loan status and delinquency information, monitors USDA portfolio and lender performance, and provides monthly reports on servicers and default status. | Linux | Apache | JBoss | DB2 | 45 | 18 | 41 | 8 | 10 | 14 | 104 | 1.83% | 32 | 0.31% | |
| Farm Service Agency Guaranteed (FSAG) | FSAG includes loan origination, loan closing, losses, secondary market transactions, lender portfolio management, servicing actions, re-amortizations, consolidations, transfers, agency loan repurchases, liquidation expenses, interest assistance payments, and status reporting. | Linux | Apache | Tomcat | DB2 | 20 | 6 | 28 | 6 | 5 | 5 | 54 | 0.95% | 16 | 0.16% | |
| Guaranteed Annual Fees (GAF) | GAF provides an automated method for lenders to retrieve billing of annual fees against guaranteed loans and submit annual fee payment requests. | Linux | Apache | Tomcat | DB2 | 30 | 8 | 18 | 17 | 12 | 12 | 56 | 0.99% | 41 | 0.40% | |
| Guaranteed Loan (GuarLoan) | GuarLoan includes common or shared (RD and FSA) applications, including loan origination, funds administration, loan closing, annual fees, late fees, losses, secondary market transactions, lender portfolio management, servicing actions, re-amortizations, consolidations, transfers, agency loan repurchases, liquidation expenses, interest assistance payments, status reporting, and credit bureau reporting. | Linux | Apache | JBoss | DB2 | 12 | 9 | 10 | 24 | 30 | 10 | 31 | 0.55% | 64 | 0.63% | |
| Intermediary Relending Program (IRP) | IRP facilitates loan making to local organizations (intermediaries) for establishing revolving loan funds. The funds finance business and economic development activities to create/retain jobs in disadvantaged/remote communities. | Linux | Apache | Tomcat | DB2 | 18 | 4 | 4 | 3 | 3 | 1 | 26 | 0.46% | 7 | 0.07% | |
| Multi-Family Housing Guaranteed (MFHG) | MFHG includes loan origination, funds reservation, loan closing, losses, secondary market transactions, lender portfolio management, servicing actions, re-amortizations, consolidations, transfers, agency loan repurchases, liquidation expenses, interest credit payments, and status reporting. | Linux | Apache | Tomcat | DB2 | 3 | 0 | 1 | 17 | 7 | 16 | 4 | 0.07% | 40 | 0.39% | |
| Single Family Housing (SFH Loss) | SFH Loss allows lenders to input and transmit loss data, the Agency to disburse loss payments to the lender via EFT. It allows for accurate and timely processing of SFH Loss claims data, and the captured data was used for the, now discontinued, Debt Collection Improvement Act (DCIA) processing. | Windows | IIS | N/A | DB2 | 8 | 2 | 7 | 2 | 2 | 5 | 17 | 0.30% | 9 | 0.09% | |
| Authorization Authentication Security Module (AASM) | AASM provides secure external lender access, via eAuthentication, to the Guaranteed Loan System (GLS). This external connection allows BP, CF, FSA, MH, RUS, SFH, WW lenders limited capabilities to the Guaranteed applications. | Linux | Apache | Tomcat | DB2 | 14 | 11 | 21 | 38 | 17 | 44 | 46 | 0.81% | 99 | 0.97% | |
| Lender Interactive Network Connection (LINC) | Accessible by Guaranteed Loan Program participating RD, Intermediary, and FSA private industry lenders, LINC houses GLS systems for accessing/inputting information for: Loan/Default Status Reporting, Annual Fees, Mortgage Recovery Advance, Loss Claim, Loan Underwriting, Loan Closing/Administration, Application Authorization, Intermediary Relending Program. The data collected is integrated with GLS. | Linux | Apache | Tomcat | DB2 | 24 | 17 | 33 | 12 | 11 | 9 | 74 | 1.30% | 32 | 0.31% | |
| SINGLE FAMILY HOUSING DIRECT | ||||||||||||||||
| Automated Mail Processing (AMP) | AMP is an enterprise print and mail-handling service that produces and distributes financial and management reports, as well as loan servicing and customer notification correspondence. The volume of printed material exceeds 36.6 million pages per year and supports an average of 475,000 pieces of metered mail per month. SFH | Mainframe | Precisely |
• EngageOne™ Enrichment
• EngageOne™ Designer
• EngageOne™ Vault
• EngageOne™ Generate
• Finalist
• Mail360 Manager
• MailStream Plus
• Tag Print System II
Xerox
• Design ProTool
| N/A | N/A | N/A | 11 | 13 | 10 | 15 | 19 | 13 | 34 | 0.60% | 47 | 0.46% |
| LoanServ | LoanServ a COTS product that records and manages obligations, disbursements, collections, and servicing for the SFHD loans and grants portfolio. NOTE: The COTS product is supported by another vendor. the support under this contract will include development and maintenance of LoanServ scripts and macros and test regions. SFH | Mainframe | COBOL |
VB
Click Once
.NET
| N/A | N/A | N/A | 67 | 65 | 68 | 61 | 78 | 106 | 200 | 3.52% | 245 | 2.41% | ||||||
| Mortgage Account Information (MAI) | MAI provides online information to Single Family Housing Direct borrowers regarding the loan accounts they hold with RD. | Linux | Apache | JBoss | MS SQL Server | 5 | 2 | 3 | 14 | 15 | 19 | 10 | 0.18% | 48 | 0.47% | |||
| MortgageLink | MortgageLink is a portal page to access LoanServ test and production regions. | Linux | Apache | N/A | N/A | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0.00% | 1 | 0.01% | |||
| National Office Reserve Funds (NORF) | ||||||||||||||||||
| Trying to Retire | NORF allows state offices to reserve program loan funds from the National Office. | Linux | Apache | Tomcat | MS SQL Server | 1 | 0 | 0 | 5 | 1 | 12 | 1 | 0.02% | 18 | 0.18% | |||
| Self Help Automated Reporting and Evaluation System (SHARES) | SHARES manages, tracks, evaluates, and reports on the status of the Self-Help Housing Section 523 Grant Program, as well as provides this information with all parties that provide assistance to this program. | Linux | Apache | JBoss | Oracle | 11 | 2 | 2 | 21 | 16 | 19 | 15 | 0.26% | 56 | 0.55% | |||
| Customer Initiated Payments (CIP) | CIP is a web service that interfaces to Pay.Gov that allows borrowers to access their SFHD loans and make payments over the web. | Linux | Apache | JBoss | MS SQL Server | 0 | 0 | 1 | 4 | 4 | 2 | 1 | 0.02% | 10 | 0.10% | |||
| SFHD Workflows, File Transfers, and Automated Processes | Workflows/Integrations | Workflows/Integrations | ||||||||||||||||
| Payment and Special Assistance (LoanServ Integration) | Workflows/Integrations | Workflows/Integrations | ||||||||||||||||
| New Loans (LoanServ Integration) | Workflows/Integrations | Workflows/Integrations | ||||||||||||||||
| FARETS | FARETS retreives select origination legal documents that are send through FTPS to a vendor. | Workflows/Integrations | ||||||||||||||||
| Global Notes (GNOTES) | GNOTES collects a file from the mainframe and based on the data has a cross-reference of notes that are rocorded on the borrower account in LoanServ. | Workflows/Integrations | ||||||||||||||||
| MONEYGRAM | SFTP process to collect a file from Money Gram server and then place on the mainframe. | Workflows/Integrations | ||||||||||||||||
| SFHPAD (Single Family Housing Pre-Authorized Debit (PAD)) | Collects specific files from the mainframe, WEFTALL (PAD data), and EFS (credit reporting fees), and sends them to ECMS server. | Workflows/Integrations | ||||||||||||||||
| WESTERN UNION | SFTP process to collect a file from Western Union server and then place on the mainframe. | Workflows/Integrations | ||||||||||||||||
| New Loan Quality Assurance Review (QAR) Upload | Uploads new loan data to the data warehouse. | Workflows/Integrations | ||||||||||||||||
| PA TDW Upload | Uploads payment assistance data to the data warehouse. | Workflows/Integrations | ||||||||||||||||
| Property Administration | Retrieves property data for other applications. | Workflows/Integrations | ||||||||||||||||
| COMMERCIAL | ||||||||||||||||||
| Commercial Loan Servicing System (CLSS) | CLSS tracks and services the commercial direct loan and grant programs (e.g., electric, telephone, distance learning, broadband, cable television, water and environmental, community facilities) borrowers, obligations, loans, grants, and payments. | Linux | Apache | JBoss | DB2 | 90 | 53 | 57 | 95 | 58 | 71 | 200 | 3.52% | 224 | 2.20% | |||
| Rural Development Utilities Program Customer Initiated Payments (RDUPCIP) | RD Utilities Program Customer Initiated Payments (RDUPCIP) is an electronic collection method that enables borrowers with Commercial program loans, being serviced in CLSS, to make payments through an on-line collection system. Pay.gov uses the information to transmit an Automated Clearing House transaction for an electronic withdrawal from the bank account designated by the borrower. The borrower is given credit at the time the payment is withdrawn. Pay.gov transmits the funds to Treasury and sends an electronic file to USDA. The file is used to update the borrower’s account. | Linux | Apache | JBoss | MS SQL Server | 1 | 1 | 1 | 8 | 5 | 5 | 3 | 0.05% | 18 | 0.18% | |||
| Staff Review Reporting System (SRRS) | SRRS supports the Program Accounting Services Division in tracking various activities related to the Utilities Programs certified public accountants audit program and the Loan Fund and Accounting Reviews. | Windows | IIS | N/A | DB2 | 16 | 37 | 54 | 6 | 16 | 21 | 107 | 1.88% | 43 | 0.42% | |||
| Data Collection System (DCS) | DCS automates financial and statistical report submissions by their borrowers, fulfilling the regulatory reporting requirement. These reports make the information available to the Utilities programs for analysis in connection with Government loan funds security. | Windows | .NET | N/A | MS SQL Server | 80 | 81 | 50 | 12 | 25 | 26 | 211 | 3.72% | 63 | 0.62% | |||
| Commercial Program Application Processing (CPAP) | CPAP is an application used by RUS program to process Water and Waste loan and grant applications. | Windows | .NET | N/A | MS SQL Server | 96 | 96 | 52 | 37 | 49 | 45 | 244 | 4.30% | 131 | 1.29% | |||
| DocFactory Electric (in process of being migrated to Coupa) | DocFactory Electric is the enterprise document assembly solution utilizing a COTS package called 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. | Linux | Exari | Apache | Tomcat | MS SQL Server | 1 | 0 | 1 | 3 | 10 | 10 | 2 | 0.04% | 23 | 0.23% | ||
| RD Apply | RDApply is an application intake system that allows an applicant to apply for loans and grants for Rural Utilities Services (RUS) Programs. With RDApply, applicants can create an application, upload attachments, sign certifications, and draw service areas, to name a few features. | Linux | Apache | JBoss | Oracle | 85 | 64 | 37 | 72 | 39 | 63 | 186 | 3.28% | 174 | 1.71% | |||
| ePER | The electronic Preliminary Engineering Report (ePER) is an online tool designed to allow consulting engineers to enter and upload analyses, data, and technical information and produce a report that can accompany an application for funding from Rural Utilities Service’s (RUS)Water and Waste Disposal Loan and Grant program. | Linux | Apache | JBoss | Oracle | 3 | 1 | 1 | 10 | 4 | 12 | 5 | 0.09% | 26 | 0.26% | |||
| Electric and Telecommunications Loan Statistics (LoanStats) | LoanStats tracks statistics on Rural Utilities Service Telephone and Electric loans. Commercial | Mainframe | N/A | N/A | N/A | 0 | 0 | 0 | 3 | 1 | 0 | 0 | 0.00% | 4 | 0.04% | |||
| FoxPro Loan Statistics (FoxPro) | Desktop application used to track statistics on Rural Utilities Service (RUS) Electric loans. Commercial | Mainframe | N/A | N/A | N/A | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0.00% | 3 | 0.03% | |||
| MULTI-FAMILY HOUSING | ||||||||||||||||||
| Automated Multi-Family Account System (AMAS) | AMAS records and manages obligations, disbursements, collections, and servicing for the multi-family housing loans and grants portfolio. MFH | Mainframe | N/A | N/A | N/A | 33 | 30 | 11 | 50 | 56 | 45 | 74 | 1.30% | 151 | 1.49% | |||
| Electronic Fund Transfer (EFT) | EFT is a repository of customer banking information that is used to disburse Government funds electronically to a customer bank account. | Linux | Apache | Tomcat | DB2 | 7 | 2 | 6 | 5 | 5 | 13 | 15 | 0.26% | 23 | 0.23% | |||
| Multi-Family Integrated System (MFIS) | MFIS assists personnel in monitoring the management of Multi-Family rental properties. MFIS provides the capabilities to track all of the activities related to the management and servicing of the MFH property. | Windows | Legacy ASP | N/A | DB2 | 80 | 72 | 31 | 74 | 66 | 63 | 183 | 3.22% | 203 | 2.00% | |||
| Pre-Authorized Debt (PAD) | PAD is used for automatic payments of loans. PAD takes pre-authorized funds from borrower accounts via EFT for automatic payments of loans. | Linux | Apache | Tomcat | DB2 | 3 | 3 | 1 | 12 | 8 | 3 | 7 | 0.12% | 23 | 0.23% | |||
| Management Interactive Network Connection (MINC) | MINC collects project budget and tenant residency status information from management agencies and service bureaus either through EDI files or direct data entry through website. The data collected is integrated into MFIS. | Windows | Legacy ASP | N/A | DB2 | 11 | 11 | 6 | 14 | 9 | 16 | 28 | 0.49% | 39 | 0.38% | |||
| Prepayment Tracking/Concurrence (PreTrac) | PreTrac processes MFH prepayment requests and enables RHS to process, manage, and track prepayment applications received from MFH borrowers of rental properties and to offer incentives for borrowers to remain in the program in areas where there is a need for such housing by low-income families and minorities. | Linux | Apache | Tomcat | Oracle | 7 | 3 | 0 | 8 | 10 | 7 | 10 | 0.18% | 25 | 0.25% | |||
| Prepayment Information Exchange (PIX) | PIX allows nonprofit organizations and public bodies interested in preserving affordable housing to obtain information regarding MFH projects that have applied to prepay their MFH Loans. | Linux | Apache | Tomcat | Oracle | 1 | 2 | 0 | 7 | 5 | 7 | 3 | 0.05% | 19 | 0.19% | |||
| RD GENERAL SUPPORT SERVICES | ||||||||||||||||||
| RD General support Services (RD GSS) | RD GSS hosts the DevOps and Security Tool Chain which consists of Confluence, Jira, BitBucket/Git, ArtiFactory, Jenkins, Compliance Sheriff, OwnBackup, IBM AppScan, Burp Suite Professional, and HP Web Inspect. | Linux | Apache | Tomcat | 16 | 9 | 1 | 270 | 370 | 410 | 26 | 0.46% | 1050 | 10.34% | ||||
| Rules Engine BRE/FICO Blaze | Business Rules Engine (BRE) / FICO Blaze Advisor business rules management system with the primary purpose to develop, deploy and maintain business rules services. This service automates policies and procedures as a service in an application. This desktop tool has an integrated set of development and deployment tools used for creating business rule services. | Linux | FICO Blaze Advisor | Apache | JBoss | MS SQL Server | 0 | 1 | 7 | 3 | 0 | 1 | 8 | 0.14% | 4 | 0.04% | ||
| Automated Report Tracking System (ARTS) | ARTS tracks internal management control documents, such as Financial Management Division (FMD) reviews, Management Control Reviews (MCRs), State Internal Reviews (SIRs), investigations, and hotline complaints. ARTS is used by National Office FMD staff and each state’s Management Control Officers (MCOs) and Alternate MCOs. Rural Development (RDs) Operations and Maintenance (O&M) staff and other users access ARTS through the web to input/retrieve appropriate/pertinent data into/from the application. ARTS processes system data to produce RD audit and results information. Appropriate O&M staff then take the respective actions/steps to resolve/respond to ARTS-generated audit reports. | Windows | .NET | N/A | MS SQL Server | 1 | 0 | 0 | 8 | 3 | 4 | 1 | 0.02% | 15 | 0.15% | |||
| Credit Reform Data Store (CRDS) | CRDS extract data from financial systems and pass to BICS. CRDS import data from the SAS mainframe system and Excel files. CRDS is a secure data store for credit reform data. The data store provides analytical tools for analyzing and comparing data, automating the creation of reports, and maintaining version control over reporting. | Solaris | EssBase | Apache | EssBase | Oracle | 0 | 0 | 0 | 6 | 0 | 1 | 0 | 0.00% | 7 | 0.07% | ||
| User Access Management (UAM) | UAM manages the initiation and documentation of the lifecycle of user account administration. | Linux | Apache | Tomcat | MS SQL Server | 2 | 3 | 2 | 19 | 20 | 12 | 7 | 0.12% | 51 | 0.50% | |||
| Mulesoft | AWS GovCloud | N/A | N/A | N/A | 0 | 1 | 3 | 6 | 61 | 55 | 4 | 0.07% | 122 | 1.20% | ||||
| ENTERPRISE SUPPORT SERVICES | ||||||||||||||||||
| Account Cross Reference (ACR) | ACR serves as a social security number (SSN) translator with a data warehouse front the masks SSN's with a certificate-based value. The service resides inside of the Tabular Data Warehouse. | Linux | Apache | JBoss | Oracle | 2 | 0 | 0 | 11 | 9 | 23 | 2 | 0.04% | 43 | 0.42% | |||
| Enterprise Cash Management Services (ECMS) | ECMS is the web view of the ECMS database which currently holds all the loan level accounting data (FY’s appropriation codes, type of assistance codes, cohorts, Treasury Account Symbols (TAS), etc) all necessary to derive the component TAS and Business Event Type Code (BETC) required by Treasury. | Linux | Apache | JBoss | MS SQL Server | 33 | 14 | 28 | 66 | 52 | 57 | 75 | 1.32% | 175 | 1.72% | |||
| Income & Property Eligibility | Web site listing income eligibility requirements and displaying maps showing eligible loan areas. | Linux | Apache | JBoss | MS SQL Server | 18 | 13 | 30 | 22 | 17 | 40 | 61 | 1.07% | 79 | 0.78% | |||
| Rural Development Census | Website that provides RD census data needed for various RD programs in order to calculate eligibility and rates related to US census numbers. | .NET | N/A | N/A | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0.00% | 1 | 0.01% | ||||
| Program Funds Control System (PFCS) | Financial management system designed to consolidate and reengineer the funding controls for multiple loan programs at FSA and RD. | Solaris | Oracle App Server | Oracle | 291 | 267 | 228 | 143 | 132 | 124 | 786 | 13.84% | 399 | 3.93% | ||||
| Program Loan Accounting System (PLAS) | PLAS tracks and services business programs, community facilities, water and waste, MFH Preservation, farmer program borrowers, obligations, loans, grants, and payments. PLAS also supports general ledger, cash tracking, Pre-Authorized Debit, and the County Office Information file. | |||||||||||||||||
| NOTE: FPAC is the systems owner for PLAS. However, Contractor will provide full-time data base support, Batch scheduling/processing support (control-M) and secondary application support for all environments. | Mainframe | N/A | N/A | N/A | 105 | 78 | 24 | 128 | 105 | 85 | 207 | 3.65% | 318 | 3.13% | ||||
| Lead-Based Paint (LBP) | LBP is a decision support tool for complying with Federal regulations regarding lead-based paint. | Linux | Apache | JBoss | MS SQL Server | 3 | 5 | 1 | 12 | 4 | 11 | 9 | 0.16% | 27 | 0.27% | |||
| Grants USDA (GIM) | GIM interfaces with Grants.gov. GIM provides USDA employee access to information and forms to allow submission of specified grant forms electronically. | Linux | Apache | JBoss | MS SQL Server | 11 | 4 | 5 | 19 | 15 | 50 | 20 | 0.35% | 84 | 0.83% | |||
| Multi-Family Management Rentals | Web site listing MFH properties for rent. | Linux | Apache | Tomcat | DB2 | 1 | 2 | 2 | 8 | 3 | 14 | 5 | 0.09% | 25 | 0.25% | |||
| Eligibility Manager | Website to maintain county textual descriptions of property eligibility for RD direct and guaranteed loans. | Linux | Apache | JBoss | MS SQL Server | 0 | 0 | 0 | 2 | 3 | 3 | 0 | 0.00% | 8 | 0.08% | |||
| eForms | eForms is a web-based application used to lessen the public paperwork burden mandated by the Paperwork Reduction Act. Forms gives customers, producers, partners, and others access to forms and account information related to USDA programs. eForms consists of the following modules: | Linux | Adobe Experience Manager (AEM) | Apache | Tomcat | MS SQL Server | 67 | 107 | 95 | 38 | 9 | 17 | 269 | 4.74% | 64 | 0.63% | ||
| Forms | Forms - Portal that allows public access to forms for FSA, NRCS, and RD. Forms can only be view and printed without an eAuth ID but to submit a form than an eAuth ID is required. | Linux | Apache | Tomcat | MS SQL Server | 3 | 0 | 1 | 9 | 5 | 8 | 4 | 0.07% | 22 | 0.22% | |||
| My Forms | MyForms - Web application that allows public access (with eAuth ID) to access for FSA, NRCS, and RD. Forms can be saved and submitted electronically to Federal service centers. | Linux | Apache | Tomcat | MS SQL Server | 0 | 0 | 0 | 4 | 3 | 5 | 0 | 0.00% | 12 | 0.12% | |||
| Forms Admin | Forms Administration - Web application providing RD and FPAC employee processing of electronic service requested submitted through MyForms. | Linux | Apache | Tomcat | MS SQL Server | 0 | 0 | 0 | 6 | 0 | 7 | 0 | 0.00% | 13 | 0.13% | |||
| RD Address Verification (Verification) | Address Verification is a geospatial system which identifies eligible and ineligible areas by program based off the user’s input of a geographic location (address). This service is used by the RD Eligibility system. This services uses Bing Spatial Services to determine if a property exists, and if its location is in an eligible area for a preliminary eligibility assessment. It is also used in reporting on Congressional Districts that RD services. | Windows | Apache | JBoss | N/A | 1 | 0 | 0 | 8 | 4 | 11 | 1 | 0.02% | 23 | 0.23% | |||
| Service Center Agencies Online Services (SCAO) | Service Center Agencies Online Services, (SCA Online Services) (SCAOS) is a static web page that lists services provided by FSA, NRCS and RD. | Linux | Apache | N/A | N/A | 4 | 1 | 3 | 3 | 22 | 13 | 8 | 0.14% | 38 | 0.37% | |||
| Federal Asset Sales-Real Property (FASRP) | FASRP is a non-authenticating module which provides a centralized searching solution for all United States Federal Assets for sale. The initial release will focus on “Real Property”, e.g., Commercial property holdings. | Linux | Apache | JBoss | MS SQL Server | 0 | 0 | 0 | 4 | 1 | 8 | 0 | 0.00% | 13 | 0.13% | |||
| Property Administration |
| Property Administration - RD security staff uses this application to add, modify or delete UserIDs and passwords that are stored in the database for FCLREO properties. | Linux | Apache | JBoss | MS SQL Server | 0 | 1 | 0 | 5 | 2 | 10 | 1 | 0.02% | 17 | 0.17% | ||||
| Foreclosure Real Estate Owned (FCLREO) | FCLREO is a protected internal website (USDA employees) for the RD field offices to list Foreclosure and Real Estate Owned property to the properties website that is for sale. | Linux | Apache | JBoss | MS SQL Server | 0 | 0 | 0 | 8 | 1 | 0 | 0 | 0.00% | 9 | 0.09% | |||
| Farm Service Agency Real Estate Owned (FSAREO) | FSAREO is a protected internal website (USDA employees) for the FSA field offices to list farm Foreclosure and Real Estate Owned property to the properties website that is for sale. | Linux | Apache | JBoss | MS SQL Server | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0.00% | 1 | 0.01% | |||
| Home Sales | HomeSales provides a centralized repository of re-possessed property for sale for all Federally owned real-estate (REO). | Linux | Apache | JBoss | MS SQL Server | 1 | 0 | 0 | 8 | 0 | 6 | 1 | 0.02% | 14 | 0.14% | |||
| MFHREO | MFHREO display MFH foreclosure and real estate owned (REO) properties for sale. | Linux | Apache | JBoss | MS SQL Server | 0 | 1 | 1 | 2 | 0 | 0 | 2 | 0.04% | 2 | 0.02% | |||
| Budget Information Control Systems (BICS) | BICS automates and streamlines the data handling, data analysis and document 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 internal and external to the Budget Division (e.g., RD Program Area, NFAOC, and CSC). Budget Division Director and staff can retrieve and analyze the data and generate various reports that are used for submissions during the fiscal year. | Windows | .NET | N/A | MS SQL Server | 9 | 4 | 8 | 13 | 9 | 15 | 21 | 0.37% | 37 | 0.36% | |||
| Properties | ||||||||||||||||||
| USDAProperties is a non-authenticating public facing website for RDSFH, RDMFH, RBS, and FSAREO and FSAFCL. | Linux | Apache | JBoss | MS SQL Server | 3 | 1 | 4 | 10 | 1 | 13 | 8 | 0.14% | 24 | 0.24% | ||||
| SALESFORCE – RD FORCE | ||||||||||||||||||
| ReConnect (RPS)/Telecom Program Services | ReConnect supports the intake and reporting of loans, grants, and loan-grant combinations to facilitate broadband development in areas of rural America that currently do not have sufficient access to broadband. | Salesforce GovCloud | N/A | N/A | N/A | 193 | 79 | 236 | 845 | 617 | 714 | 508 | 8.95% | 2176 | 21.42% | |||
| (RPS) Funding Opportunity Announcement (Intake Application) | Community within ReConnect that streamlines the application intake. | RPS community | ||||||||||||||||
| (RPS) Reporting and Compliance (R&C) | Community within ReConnect that streamlines the reporting process for entities receiving financial assistance from Rural Utility Services. | RPS community | ||||||||||||||||
| (RPS) Public Notice Filings (PNF) | Community within ReConnect to publish Proposed Funded Service Areas included in the recently submitted broadband applications requesting financial assistance. | RPS community | ||||||||||||||||
| (RPS) Community Connect | RPS community | |||||||||||||||||
| Resource 1 RDForce | Resource 1 is used by USDA RD employees to enter basic contact information to share with fellow employees facilitating effective communication and correspondence with new and existing. | Salesforce GovCloud | N/A | N/A | N/A | 0 | 1 | 1 | 6 | 16 | 1 | 2 | 0.04% | 23 | 0.23% | |||
| Higher Blends Infrastructure Incentive Program (HBIIP) | HBIIP provides the intake for an application to expand the availability of ethanol and biodiesel by incentivizing the expansion of sales or renewable fuels. The HBIIP grant program includes infrastructure projects for transportation fueling facilities and fuel distribution facilities. | Salesforce GovCloud | N/A | N/A | N/A | 15 | 135 | 38 | 129 | 580 | 1009 | 188 | 3.31% | 1718 | 16.91% | |||
| Food Systems Modernization FSCG | FSC-G is a public facing portal for lenders to upload documents into ECF using information from GLS to identify Borrower and Loan information to which these documents should be related. Lenders will only be able to upload documentation post obligation. The system features automated communications to and from the agency and lender, allowing lenders to send and receive secure information and stay up to date on their servicing requirements for the program. It also has reporting features for RD program staff. | Salesforce GovCloud | N/A | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 22 | 0 | 0.00% | 22 | 0.22% | |||
| Food Systems Modernization VAPG | FSM-VAPG provides an application intake and review portal for potential grantseekers looking to garner funding for investments in the creation of more enhanced products than what their already owned initial product. The Value-Added Producer Grant automated solution provides a way for external users, potential or current applicants, to fill out the grant application via an online portal. | |||||||||||||||||
| The FSM-VAPG deliverability will provide grant seekers a grant application intake portal for investments in Value-Added initiatives to increase and drive demand for changed product lines. | Salesforce GovCloud | N/A | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 26 | 0 | 0.00% | 26 | 0.26% | ||||
| Inflation Reduction Act (IRA) Rural Energey for America Program (REAP) Grant Program | The program provides guaranteed loan financing and grant funding to agricultural producers and rural small businesses for renewable energy systems or to make energy efficiency improvements. Agricultural producers may also apply for new energy efficient equipment and new system loans for agricultural production and processing. The goal is to increase energy independence in the United States by generating a higher supply of clean energy in the private sector while simultaneously decreasing energy needs | Salesforce GovCloud | N/A | N/A | N/A | 0 | 0 | 0 | 0 | 12 | 11 | 0 | 0.00% | 29 | 0.29% | |||
| New Empowering Rural America (New ERA) loan/grant program | Helps rural Americans transition to clean, affordable, and reliable energy. New ERA program funding is available to member-owned rural electric cooperatives, which have been the backbone of America’s rural power delivery for nearly a century. | Salesforce GovCloud | N/A | N/A | N/A | 0 | 0 | 0 | 0 | 2 | 55 | 0 | 0.00% | 58 | 0.57% | |||
| Powering Affordable Clean Energy (PACE) | Makes available partially forgivable loans to renewable-energy developers and electric service providers, including municipals, cooperatives, and investor-owned and Tribal utilities to help finance large-scale solar, wind, geothermal, biomass, hydropower projects and energy storage in support of renewable energy systems. | Salesforce GovCloud | N/A | N/A | N/A | 0 | 0 | 0 | 0 | 14 | 55 | 0 | 0.00% | 69 | 0.68% | |||
| SALESFORCE – RD FORCE RA | ||||||||||||||||||
| GUS2 | The Guaranteed Underwriting System, known as GUS, is an |
underwriting system to support Single Family Housing Guaranteed Loan Program loans. GUS was created by USDA Rural Development to assist approved lenders to underwrite Single Family Housing Guaranteed Loans by providing underwriting
| recommendations and a comprehensive underwriting findings report. | Salesforce GovCloud | N/A | N/A | N/A | 88 | 94 | 100 | 202 | 201 | 141 | 282 | 4.97% | 544 | 5.35% | ||||
| RD DirectPro (Point of Sale) | In Development as part of the UNIFI replacement project | Salesforce GovCloud | N/A | N/A | N/A | 0 | 0 | 2 | 0 | 36 | 28 | 2 | 0.04% | 64 | 0.63% | |||
| SALESFORCE – RDWORKFORCE/ MISSION SUPPORT | ||||||||||||||||||
| CIO Budget Tracker System (BTS) | The RD CIO Budget Tracker System is an end-to-end Cloud-based application that provides a secure, scalable, enterprise-level, web-based application for efficiently tracking RD CIO's Budget. It provides the complete capability to create, manage, track, and report on all Budget topics. The application is configured to provide an environment that offers maximum ease of use to the RD management and the users by using presentation techniques that are familiar to users of Internet Explorer or other internet browsers. Being a cloud based solution, it enables RD management to free up IT resources from day-to-day administration of servers, operating systems and databases. | Salesforce GovCloud | N/A | N/A | N/A | NA | NA | NA | NA | NA | NA | 0 | 0.00% | 0 | 0.00% | |||
| RD Employee Portal/OneRD/Team RD | The OneRD Portal is an employee-based portal for centralizing USDA RD various Business Center administrative service offerings and service requests. The Business Center, which works with employees throughout the country, performs various workflow that can accommodate selected RD administrative functions and be used by a virtual workforce. The intent is to automate majority of administrative tasks, and provide a paperless, fast, and efficient service to our virtual workforce. | Salesforce GovCloud | N/A | N/A | N/A | 4 | 6 | 0 | 67 | 34 | 9 | 10 | 0.18% | 110 | 1.08% | |||
| Civil Rights Automated Management (CRAMS) | CRAMS is a tracking system for civil rights compliants. | Salesforce GovCloud | N/A | N/A | N/A | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0.00% | 3 | 0.03% | |||
| Congressional Announcement Management System (CAMS) | CAMS provides reporting for the Congressional Announcements for the Office of External Affairs (OEA) and RD leadership to track data and communications and assist with communication to various organizations and external customers. | Salesforce GovCloud | N/A | N/A | N/A | 0 | 0 | 9 | 3 | 23 | 38 | 9 | 0.16% | 64 | 0.63% | |||
| TOTALS | 2200 | 1650 | 1828 | 3005 | 3165 | 3989 | 5678 | 10159 | ||||||||||
| Three Year Average | 1893 | 3386 | 100% | 100% |
Mainframe
| Application/System/Process | Description | Infrastructure | Software | Front End | Mid-Tier | Database | Historical Ticket Count SE | Historical Ticket Count PSO | SE 3 year Total | Total % | PSO 3 Year Total | Total % | ||||
| FY 22 | FY23 | FY24 | FY 22 | FY23 | FY24 | |||||||||||
| Mainframe | ||||||||||||||||
| Automated Mail Processing (AMP) | AMP is an enterprise print and mail-handling service that produces and distributes financial and management reports, as well as loan servicing and customer notification correspondence. The volume of printed material exceeds 36.6 million pages per year and supports an average of 475,000 pieces of metered mail per month. SFH | Mainframe | Precisely |
• EngageOne™ Enrichment
• EngageOne™ Designer
• EngageOne™ Vault
• EngageOne™ Generate
• Finalist
• Mail360 Manager
• MailStream Plus
• Tag Print System II
Xerox
• Design ProTool
| N/A | N/A | N/A | 11 | 13 | 10 | 15 | 19 | 13 | 34 | 6.60% | 47 | 6.12% |
| LoanServ | LoanServ a COTS product that records and manages obligations, disbursements, collections, and servicing for the SFHD loans and grants portfolio. NOTE: The COTS product is supported by another vendor. the support under this contract will include development and maintenance of LoanServ scripts and macros and test regions. SFH | Mainframe | COBOL |
VB
Click Once
.NET
| N/A | N/A | N/A | 67 | 65 | 68 | 61 | 78 | 106 | 200 | 38.83% | 245 | 31.90% | ||||||
| Electric and Telecommunications Loan Statistics (LoanStats) | LoanStats tracks statistics on Rural Utilities Service Telephone and Electric loans. Commercial | Mainframe | N/A | N/A | N/A | 0 | 0 | 0 | 3 | 1 | 0 | 0 | 0.00% | 4 | 0.52% | |||
| FoxPro Loan Statistics (FoxPro) | Desktop application used to track statistics on Rural Utilities Service (RUS) Electric loans. Commercial | Mainframe | N/A | N/A | N/A | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0.00% | 3 | 0.39% | |||
| Automated Multi-Family Account System (AMAS) | AMAS records and manages obligations, disbursements, collections, and servicing for the multi-family housing loans and grants portfolio. MFH | Mainframe | N/A | N/A | N/A | 33 | 30 | 11 | 50 | 56 | 45 | 74 | 14.37% | 151 | 19.66% | |||
| Program Loan Accounting System (PLAS) | PLAS tracks and services business programs, community facilities, water and waste, MFH Preservation, farmer program borrowers, obligations, loans, grants, and payments. PLAS also supports general ledger, cash tracking, Pre-Authorized Debit, and the County Office Information file. | |||||||||||||||||
| NOTE: FPAC is the systems owner for PLAS. However, Contractor will provide full-time data base support, Batch scheduling/processing support (control-M) and secondary application support for all environments. | Mainframe | N/A | N/A | N/A | 105 | 78 | 24 | 128 | 105 | 85 | 207 | 40.19% | 318 | 41.41% | ||||
| TOTALS | 216 | 186 | 113 | 260 | 259 | 249 | 515 | 768 | 3 | |||||||||
| Three Year Average | 172 | 256 | 100% | 100% | ||||||||||||||
| Percentage of total | 9.07% | 7.56% |
Mainframe Sofware
| Vendor | Product | Platform |
| BroadCom | CA ENDEVOR CM BASE | z/OS |
| BroadCom | CA ENDEVOR CM EXT PROC OPTION | z/OS |
| BroadCom | CA EASYTRIEVE PLUS REPORT GEN | z/OS |
| BroadCom | CA EASYTRIEVE PLUS IDMS OPTION | z/OS |
| BroadCom | CA IDMS/DB | z/OS |
| BroadCom | CA IDMS PERFORMANCE MONITOR | z/OS |
| BroadCom | CA OPTIMIZER/II | z/OS |
| EIS | SAS/AF | z/OS |
| IBM | IBM Debug for z Systems V14 | z/OS |
| IBM | DB2 High Performance Unload for z/OS | z/OS |
| IBM | DB2 12 for z/OS | z/OS |
| IBM | DB2 Utilities Suite | z/OS |
| IBM | z/OS V2 GDDM-PGF | z/OS |
| IBM | WebSphere Application Server for z/OS | z/OS |
| IBM | z/OS V2 XL C/C++ | z/OS |
| IBM | PSF V4 for OS/390 | z/OS |
| IBM | COBOL V4 | z/OS |
| IBM | IBM Connect:Direct z/OS Std | z/OS |
| IBM | CICS TS VUE V5 | z/OS |
| IBM | IBM Hourglass | z/OS |
| IBM | DB2 QMF z/OS | z/OS |
| IBM | Enterprise COBOL z/OS V6 | z/OS |
| IBM | IBM CICS Optim Solution S&S | z/OS |
| IBM | Optim DGS for DB2 for z/OS | z/OS |
| IBM | VS COBOL II Comp Lib and Debug | z/OS |
| Immix Technology | Basic Reporting System | z/OS |
| Immix Technology | Database Management | z/OS |
| Immix Technology | FOCUS DBMS Server | z/OS |
| Immix Technology | Multiple Session Option | z/OS |
| Immix Technology | DB2 Read Interface | z/OS |
| Immix Technology | CA-IDMS/R Read Interface | z/OS |
| Immix Technology | WebFOCUS ReportCaster | z/OS |
| Immix Technology | WebFOCUS Reporting Server | z/OS |
| Immix Technology | WebFOCUS Comprehensive User Services | z/OS |
| Immix Technology | Pitney Bowes: EngageOne DOC1 Generate | z/OS |
| Immix Technology | Pitney Bowes: Finalist | z/OS |
| Immix Technology | Pitney Bowes: Finalist DB | z/OS |
| Immix Technology | Pitney Bowes: Mail 360 Manager | z/OS |
| Immix Technology | Pitney Bowes: Streamweaver | z/OS |
| Immix Technology | Pitney Bowes: MailStream Plus | z/OS |
| Immix Technology | Pitney Bowes: USPS Reference File Monthly | z/OS |
| Levi Ray & Shoup, Inc. | DRS | z/OS |
| Levi Ray & Shoup, Inc. | VMCF/vtam | z/OS |
| Levi Ray & Shoup, Inc. | VPS/Report Browser | z/OS |
| Levi Ray & Shoup, Inc. | VTAM Printer Supprt | z/OS |
| MacKinney Systems Inc. | Batch to CICS | z/OS |
| PKWARE, Inc. | Smartcrypt SE for z Systems | z/OS |
| Software Engineering America | $AVRS | z/OS |
| Software Engineering America | Archive Browse Program Product Suite | z/OS |
| Software Engineering America | TRMS/MVS | z/OS |
| IBM | VA Java OS/390 V2 Compiler | z/OS |
Guaranteed
| Application/System/Process | Description | Infrastructure | Software | Front End | Mid-Tier | Database | Historical Ticket Count SE | Historical Ticket Count PSO | SE 3 year Total | Total % | PSO 3 Year Total | Total % | ||||
| FY 22 | FY23 | FY24 | FY 22 | FY23 | FY24 | |||||||||||
| GUARANTEED | ||||||||||||||||
| Guaranteed Loan System (GLS) | GLS is an online transaction entry and inquiry financial and accounting system that records and manages obligations, servicing, and loss claims for guaranteed programs, as well as managing and monitoring lenders. | Windows | IIS | N/A | DB2 | 546 | 210 | 444 | 241 | 182 | 183 | 1200 | 74.44% | 606 | 64.06% | |
| Electronic Status Reporting (ESR) | ESR captures current loan status and delinquency information, monitors USDA portfolio and lender performance, and provides monthly reports on servicers and default status. | Linux | Apache | JBoss | DB2 | 45 | 18 | 41 | 8 | 10 | 14 | 104 | 6.45% | 32 | 3.38% | |
| Farm Service Agency Guaranteed (FSAG) | FSAG includes loan origination, loan closing, losses, secondary market transactions, lender portfolio management, servicing actions, re-amortizations, consolidations, transfers, agency loan repurchases, liquidation expenses, interest assistance payments, and status reporting. | Linux | Apache | Tomcat | DB2 | 20 | 6 | 28 | 6 | 5 | 5 | 54 | 3.35% | 16 | 1.69% | |
| Guaranteed Annual Fees (GAF) | GAF provides an automated method for lenders to retrieve billing of annual fees against guaranteed loans and submit annual fee payment requests. | Linux | Apache | Tomcat | DB2 | 30 | 8 | 18 | 17 | 12 | 12 | 56 | 3.47% | 41 | 4.33% | |
| Guaranteed Loan (GuarLoan) | GuarLoan includes common or shared (RD and FSA) applications, including loan origination, funds administration, loan closing, annual fees, late fees, losses, secondary market transactions, lender portfolio management, servicing actions, re-amortizations, consolidations, transfers, agency loan repurchases, liquidation expenses, interest assistance payments, status reporting, and credit bureau reporting. | Linux | Apache | JBoss | DB2 | 12 | 9 | 10 | 24 | 30 | 10 | 31 | 1.92% | 64 | 6.77% | |
| Intermediary Relending Program (IRP) | IRP facilitates loan making to local organizations (intermediaries) for establishing revolving loan funds. The funds finance business and economic development activities to create/retain jobs in disadvantaged/remote communities. | Linux | Apache | Tomcat | DB2 | 18 | 4 | 4 | 3 | 3 | 1 | 26 | 1.61% | 7 | 0.74% | |
| Multi-Family Housing Guaranteed (MFHG) | MFHG includes loan origination, funds reservation, loan closing, losses, secondary market transactions, lender portfolio management, servicing actions, re-amortizations, consolidations, transfers, agency loan repurchases, liquidation expenses, interest credit payments, and status reporting. | Linux | Apache | Tomcat | DB2 | 3 | 0 | 1 | 17 | 7 | 16 | 4 | 0.25% | 40 | 4.23% | |
| Single Family Housing (SFH Loss) | SFH Loss allows lenders to input and transmit loss data, the Agency to disburse loss payments to the lender via EFT. It allows for accurate and timely processing of SFH Loss claims data, and the captured data was used for the, now discontinued, Debt Collection Improvement Act (DCIA) processing. | Windows | IIS | N/A | DB2 | 8 | 2 | 7 | 2 | 2 | 5 | 17 | 1.05% | 9 | 0.95% | |
| Authorization Authentication Security Module (AASM) | AASM provides secure external lender access, via eAuthentication, to the Guaranteed Loan System (GLS). This external connection allows BP, CF, FSA, MH, RUS, SFH, WW lenders limited capabilities to the Guaranteed applications. | Linux | Apache | Tomcat | DB2 | 14 | 11 | 21 | 38 | 17 | 44 | 46 | 2.85% | 99 | 10.47% | |
| Lender Interactive Network Connection (LINC) | Accessible by Guaranteed Loan Program participating RD, Intermediary, and FSA private industry lenders, LINC houses GLS systems for accessing/inputting information for: Loan/Default Status Reporting, Annual Fees, Mortgage Recovery Advance, Loss Claim, Loan Underwriting, Loan Closing/Administration, Application Authorization, Intermediary Relending Program. The data collected is integrated with GLS. | Linux | Apache | Tomcat | DB2 | 24 | 17 | 33 | 12 | 11 | 9 | 74 | 4.59% | 32 | 3.38% | |
| TOTALS | 720 | 285 | 607 | 368 | 279 | 299 | 1612 | 946 | ||||||||
| Three Year Average | 537 | 315 | 100% | 100% | ||||||||||||
| Percentage of total | 28.39% | 9.31% |
SFH Direct
| Application/System/Process | Description | Infrastructure | Software | Front End | Mid-Tier | Database | Historical Ticket Count SE | Historical Ticket Count PSO | SE 3 year Total | Total % | PSO 3 Year Total | Total % | ||||
| FY 22 | FY23 | FY24 | FY 22 | FY23 | FY24 | |||||||||||
| SINGLE FAMILY HOUSING DIRECT | ||||||||||||||||
| Automated Mail Processing (AMP) | AMP is an enterprise print and mail-handling service that produces and distributes financial and management reports, as well as loan servicing and customer notification correspondence. The volume of printed material exceeds 36.6 million pages per year and supports an average of 475,000 pieces of metered mail per month. SFH | Mainframe | Precisely |
• EngageOne™ Enrichment
• EngageOne™ Designer
• EngageOne™ Vault
• EngageOne™ Generate
• Finalist
• Mail360 Manager
• MailStream Plus
• Tag Print System II
Xerox
• Design ProTool
| N/A | N/A | N/A | 11 | 13 | 10 | 15 | 19 | 13 | 34 | 13.03% | 47 | 11.06% |
| LoanServ | LoanServ a COTS product that records and manages obligations, disbursements, collections, and servicing for the SFHD loans and grants portfolio. NOTE: The COTS product is supported by another vendor. the support under this contract will include development and maintenance of LoanServ scripts and macros and test regions. SFH | Mainframe | COBOL |
VB
Click Once
.NET
| N/A | N/A | N/A | 67 | 65 | 68 | 61 | 78 | 106 | 200 | 76.63% | 245 | 57.65% | ||||||
| Mortgage Account Information (MAI) | MAI provides online information to Single Family Housing Direct borrowers regarding the loan accounts they hold with RD. | Linux | Apache | JBoss | MS SQL Server | 5 | 2 | 3 | 14 | 15 | 19 | 10 | 3.83% | 48 | 11.29% | |||
| MortgageLink | MortgageLink is a portal page to access LoanServ test and production regions. | Linux | Apache | N/A | N/A | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0.00% | 1 | 0.24% | |||
| National Office Reserve Funds (NORF) | ||||||||||||||||||
| Trying to Retire | NORF allows state offices to reserve program loan funds from the National Office. | Linux | Apache | Tomcat | MS SQL Server | 1 | 0 | 0 | 5 | 1 | 12 | 1 | 0.38% | 18 | 4.24% | |||
| Self Help Automated Reporting and Evaluation System (SHARES) | SHARES manages, tracks, evaluates, and reports on the status of the Self-Help Housing Section 523 Grant Program, as well as provides this information with all parties that provide assistance to this program. | Linux | Apache | JBoss | Oracle | 11 | 2 | 2 | 21 | 16 | 19 | 15 | 5.75% | 56 | 13.18% | |||
| Customer Initiated Payments (CIP) | CIP is a web service that interfaces to Pay.Gov that allows borrowers to access their SFHD loans and make payments over the web. | Linux | Apache | JBoss | MS SQL Server | 0 | 0 | 1 | 4 | 4 | 2 | 1 | 0.38% | 10 | 2.35% | |||
| SFHD Workflows, File Transfers, and Automated Processes | Workflows/Integrations | |||||||||||||||||
| Payment and Special Assistance (LoanServ Integration) | Workflows/Integrations | |||||||||||||||||
| New Loans (LoanServ Integration) | Workflows/Integrations | |||||||||||||||||
| FARETS | FARETS retreives select origination legal documents that are send through FTPS to a vendor. | |||||||||||||||||
| Global Notes (GNOTES) | GNOTES collects a file from the mainframe and based on the data has a cross-reference of notes that are rocorded on the borrower account in LoanServ. | |||||||||||||||||
| MONEYGRAM | SFTP process to collect a file from Money Gram server and then place on the mainframe. | |||||||||||||||||
| SFHPAD (Single Family Housing Pre-Authorized Debit (PAD)) | Collects specific files from the mainframe, WEFTALL (PAD data), and EFS (credit reporting fees), and sends them to ECMS server. | |||||||||||||||||
| WESTERN UNION | SFTP process to collect a file from Western Union server and then place on the mainframe. | |||||||||||||||||
| New Loan Quality Assurance Review (QAR) Upload | Uploads new loan data to the data warehouse. | |||||||||||||||||
| PA TDW Upload | Uploads payment assistance data to the data warehouse. | |||||||||||||||||
| Property Administration | Retrieves property data for other applications. | |||||||||||||||||
| TOTALS | 95 | 82 | 84 | 121 | 133 | 171 | 261 | 425 | ||||||||||
| Three Year Average | 87 | 142 | 100% | 100% | ||||||||||||||
| Percentage of total | 4.60% | 4.18% |
Commercial
| Application/System/Process | Description | Infrastructure | Software | Front End | Mid-Tier | Database | Historical Ticket Count SE | Historical Ticket Count PSO | SE 3 year Total | Total % | PSO 3 Year Total | Total % | ||||
| FY 22 | FY23 | FY24 | FY 22 | FY23 | FY24 | |||||||||||
| COMMERCIAL | ||||||||||||||||
| Commercial Loan Servicing System (CLSS) | CLSS tracks and services the commercial direct loan and grant programs (e.g., electric, telephone, distance learning, broadband, cable television, water and environmental, community facilities) borrowers, obligations, loans, grants, and payments. | Linux | Apache | JBoss | DB2 | 90 | 53 | 57 | 95 | 58 | 71 | 200 | 20.88% | 224 | 31.59% | |
| Rural Development Utilities Program Customer Initiated Payments (RDUPCIP) | RD Utilities Program Customer Initiated Payments (RDUPCIP) is an electronic collection method that enables borrowers with Commercial program loans, being serviced in CLSS, to make payments through an on-line collection system. Pay.gov uses the information to transmit an Automated Clearing House transaction for an electronic withdrawal from the bank account designated by the borrower. The borrower is given credit at the time the payment is withdrawn. Pay.gov transmits the funds to Treasury and sends an electronic file to USDA. The file is used to update the borrower’s account. | Linux | Apache | JBoss | MS SQL Server | 1 | 1 | 1 | 8 | 5 | 5 | 3 | 0.31% | 18 | 2.54% | |
| Staff Review Reporting System (SRRS) | SRRS supports the Program Accounting Services Division in tracking various activities related to the Utilities Programs certified public accountants audit program and the Loan Fund and Accounting Reviews. | Windows | IIS | N/A | DB2 | 16 | 37 | 54 | 6 | 16 | 21 | 107 | 11.17% | 43 | 6.06% | |
| Data Collection System (DCS) | DCS automates financial and statistical report submissions by their borrowers, fulfilling the regulatory reporting requirement. These reports make the information available to the Utilities programs for analysis in connection with Government loan funds security. | Windows | .NET | N/A | MS SQL Server | 80 | 81 | 50 | 12 | 25 | 26 | 211 | 22.03% | 63 | 8.89% | |
| Commercial Program Application Processing (CPAP) | CPAP is an application used by RUS program to process Water and Waste loan and grant applications. | Windows | .NET | N/A | MS SQL Server | 96 | 96 | 52 | 37 | 49 | 45 | 244 | 25.47% | 131 | 18.48% | |
| DocFactory Electric | DocFactory Electric is the enterprise document assembly solution utilizing a COTS package called 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. | Linux | Exari | Apache | Tomcat | MS SQL Server | 1 | 0 | 1 | 3 | 10 | 10 | 2 | 0.21% | 23 | 3.24% |
| RD Apply | RDApply is an application intake system that allows an applicant to apply for loans and grants for Rural Utilities Services (RUS) Programs. With RDApply, applicants can create an application, upload attachments, sign certifications, and draw service areas, to name a few features. | Linux | Apache | JBoss | Oracle | 85 | 64 | 37 | 72 | 39 | 63 | 186 | 19.42% | 174 | 24.54% | |
| ePER | The electronic Preliminary Engineering Report (ePER) is an online tool designed to allow consulting engineers to enter and upload analyses, data, and technical information and produce a report that can accompany an application for funding from Rural Utilities Service’s (RUS)Water and Waste Disposal Loan and Grant program. | Linux | Apache | JBoss | Oracle | 3 | 1 | 1 | 10 | 4 | 12 | 5 | 0.52% | 26 | 3.67% | |
| Electric and Telecommunications Loan Statistics (LoanStats) | LoanStats tracks statistics on Rural Utilities Service Telephone and Electric loans. Commercial | Mainframe | N/A | N/A | N/A | 0 | 0 | 0 | 3 | 1 | 0 | 0 | 0.00% | 4 | 0.56% | |
| FoxPro Loan Statistics (FoxPro) | Desktop application used to track statistics on Rural Utilities Service (RUS) Electric loans. Commercial | Mainframe | N/A | N/A | N/A | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0.00% | 3 | 0.42% | |
| TOTALS | 372 | 333 | 253 | 249 | 207 | 253 | 958 | 709 | ||||||||
| Three Year Average | 319 | 236 | 100% | 100% | ||||||||||||
| Percentage of total | 16.87% | 6.98% |
MFH
| Application/System/Process | Description | Infrastructure | Software | Front End | Mid-Tier | Database | Historical Ticket Count SE | Historical Ticket Count PSO | SE 3 year Total | Total % | PSO 3 Year Total | Total % | ||||
| FY 22 | FY23 | FY24 | FY 22 | FY23 | FY24 | |||||||||||
| MULTI-FAMILY HOUSING | ||||||||||||||||
| Automated Multi-Family Account System (AMAS) | AMAS records and manages obligations, disbursements, collections, and servicing for the multi-family housing loans and grants portfolio. MFH | Mainframe | N/A | N/A | N/A | 33 | 30 | 11 | 50 | 56 | 45 | 74 | 23.13% | 151 | 31.26% | |
| Electronic Fund Transfer (EFT) | EFT is a repository of customer banking information that is used to disburse Government funds electronically to a customer bank account. | Linux | Apache | Tomcat | DB2 | 7 | 2 | 6 | 5 | 5 | 13 | 15 | 4.69% | 23 | 4.76% | |
| Multi-Family Integrated System (MFIS) | MFIS assists personnel in monitoring the management of Multi-Family rental properties. MFIS provides the capabilities to track all of the activities related to the management and servicing of the MFH property. | Windows | Legacy ASP | N/A | DB2 | 80 | 72 | 31 | 74 | 66 | 63 | 183 | 57.19% | 203 | 42.03% | |
| Pre-Authorized Debt (PAD) | PAD is used for automatic payments of loans. PAD takes pre-authorized funds from borrower accounts via EFT for automatic payments of loans. | Linux | Apache | Tomcat | DB2 | 3 | 3 | 1 | 12 | 8 | 3 | 7 | 2.19% | 23 | 4.76% | |
| Management Interactive Network Connection (MINC) | MINC collects project budget and tenant residency status information from management agencies and service bureaus either through EDI files or direct data entry through website. The data collected is integrated into MFIS. | Windows | Legacy ASP | N/A | DB2 | 11 | 11 | 6 | 14 | 9 | 16 | 28 | 8.75% | 39 | 8.07% | |
| Prepayment Tracking/Concurrence (PreTrac) | PreTrac processes MFH prepayment requests and enables RHS to process, manage, and track prepayment applications received from MFH borrowers of rental properties and to offer incentives for borrowers to remain in the program in areas where there is a need for such housing by low-income families and minorities. | Linux | Apache | Tomcat | Oracle | 7 | 3 | 0 | 8 | 10 | 7 | 10 | 3.13% | 25 | 5.18% | |
| Prepayment Information Exchange (PIX) | PIX allows nonprofit organizations and public bodies interested in preserving affordable housing to obtain information regarding MFH projects that have applied to prepay their MFH Loans. | Linux | Apache | Tomcat | Oracle | 1 | 2 | 0 | 7 | 5 | 7 | 3 | 0.94% | 19 | 3.93% | |
| TOTALS | 142 | 123 | 55 | 170 | 159 | 154 | 320 | 483 | ||||||||
| Three Year Average | 107 | 161 | 100% | 100% | ||||||||||||
| Percentage of total | 5.64% | 4.75% |
GSS
| Application/System/Process | Description | Infrastructure | Software | Front End | Mid-Tier | Database | Historical Ticket Count SE | Historical Ticket Count PSO | SE 3 year Total | Total % | PSO 3 Year Total | Total % | ||||
| FY 22 | FY23 | FY24 | FY 22 | FY23 | FY24 | |||||||||||
| RD GENERAL SUPPORT SERVICES | ||||||||||||||||
| RD General support Services (RD GSS) | RD GSS hosts the DevOps and Security Tool Chain which consists of Confluence, Jira, BitBucket/Git, ArtiFactory, Jenkins, Compliance Sheriff, OwnBackup, IBM AppScan, Burp Suite Professional, and HP Web Inspect. | Linux | Apache | Tomcat | 16 | 9 | 1 | 270 | 370 | 410 | 26 | 56.52% | 1050 | 84.07% | ||
| Rules Engine BRE/FICO Blaze | Business Rules Engine (BRE) / FICO Blaze Advisor business rules management system with the primary purpose to develop, deploy and maintain business rules services. This service automates policies and procedures as a service in an application. This desktop tool has an integrated set of development and deployment tools used for creating business rule services. | Linux | FICO Blaze Advisor | Apache | JBoss | MS SQL Server | 0 | 1 | 7 | 3 | 0 | 1 | 8 | 17.39% | 4 | 0.32% |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .