Attachment_1_-_GMS_Requirements.xlsx

XLSX spreadsheet 35 KB Posted

Attached to
Grants Management Solution State and local contract opportunity
Solicitation number
RFP- 25 - 057
Issued by
Pinellas County, Florida

About this file

This document is a requirements specification file for the City of St. Petersburg, Florida's Grants Lifecycle Management System (GLMS) procurement, outlined in RFP #25-057. The City seeks a comprehensive cloud-based software solution supporting the entire grant lifecycle, from funding identification and collaborative proposal development through award management, performance tracking, compliance monitoring, and grant closeout. The system must include features such as automated deadline tracking, workflow capabilities, budget management, real-time data updates, and integration with existing infrastructure including Oracle E-Business Suite. The RFP was released on April 22, 2025, with questions due by May 13, 2025, and proposals due on May 22, 2025, at 3:00 pm. The initial contract term is two years with a nine-month implementation timeline and potential one-year successive renewals. Evaluation will allocate 100 points across eight categories, with the highest weighted areas being compliance with functional and technical requirements (21 points), vendor experience and qualifications (21 points), and implementation and training plans (21 points).

The requirements specification encompasses 127 detailed functional and technical requirements across 14 categories, including pre-award activities, award management, grant-making evaluation, post-award administration, audit and closeout, common services, data collection and reporting, Oracle EBS integration, system architecture, and data storage and management. The system must provide 24/7 availability with 99.9% annual uptime, support SAML 2.0 federation, comply with NIST security standards, and feature a web-based browser interface without requiring thick-client software installations. Support must be available Monday through Friday from 7:00 am to 6:00 pm EST with United States-based personnel, and software updates must occur quarterly at no additional cost. Vendors must provide comprehensive insurance coverage, demonstrate experience through references from at least five clients with preference for two Florida government clients, and submit implementation and training plans. Set-asides for Small Business Enterprise, Minority Business Enterprise, and Women Business Enterprise certifications will be evaluated on a pass/fail basis. No specific budget range is disclosed in the requirements document.

View the file

Other files for this state and local contract opportunity

Other files attached to Grants Management Solution, newest first.
File Type Posted
Grants_Management_Solution_(Addendum_#1_Revision).pdf PDF
Grants_Management_Solution_(Addendum_#1_Revision).pdf PDF
Base_Agreement_-_Grant_Mgmt_RFP_-_Form_T-49_v05.pdf PDF
Base_Agreement_-_Grant_Mgmt_RFP_-_Form_T-49_v05.pdf PDF
FY25_Grants_Administration_Manual.pdf PDF
Proposal_Requirements.pdf PDF
Attachment_1_-_GMS_Requirements.xlsx XLSX spreadsheet
Proposal_Requirements.pdf PDF
FY25_Grants_Admin_Manual_-_FINAL.pdf PDF
FY25_Grants_Admin_Manual_-_FINAL.pdf PDF
SOW_GrantManagementSoftware_DRAFT.docx DOCX document
Show all 11

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

ICDVVA Requirements

*indicates optional requirements
Tracking #CategorySubcategoryRequirement: System provides the ability to:Degree of Fit ResponseComment
101Pre-AwardIdentify Funding OpportunitiesAllow users to search, share, and track grant opportunities from federal, state, local, and private sources to find funding opportunities that the City is eligible for and that match specific funding needs.
102Email Notification of New Funding OpportunitiesSend users email notifications of new grants that become available and meet their defined search parameters or funding criteria.
103Authorize Grant Application SubmittalsSupport submission and approval of requests to apply for funding opportunities.
104Pre-Award Data Pre-PopulationThe system should allow information entered during the pre-award phase (e.g., project details, budget, key personnel) to automatically pre-populate relevant fields in future forms and documentation throughout the grant lifecycle, reducing the need for duplicate data entry and ensuring consistency across all documents.
105Collaborative Grant Proposal DevelopmentThe system should support real-time collaboration between internal and external users during grant proposal development, including features for tracked changes and the ability to add comments to specific sections, similar to functionalities in tools like Google Docs or Word, ensuring seamless review and feedback.
106Grant Application Review and ApprovalFacilitate review and approval of grant proposals.
107Application Review ManagementAssign, track, and manage reviewer feedback for both internal and external users
108Grant Submission TrackingTrack submission deadlines and provide automated reminders and alerts for approaching deadlines.
109Letters of Support*Coordinate internal and external requests for letters of support for funding proposals, including initiating requests, drafting letters, and routing for review and signature.
110Forms TrackingTrack, collect and manage standard forms, such as those for FEMA and other standard federal grant forms.
111WorkflowsCapability to build workflows that can be reviewed by staff to include timelines and number of day requirements
112Reminders to Potential ApplicantsThe system should send automated reminder notifications via Outlook to potential applicants, alerting them of upcoming grant submission deadlines to ensure timely submissions.
113Grant Budget DevelopmentFacilitate creation, review, modification, and reporting on grant budgets.
114Application ManagementAssign an identity to the application, preassign to appropriate internal and external users, create the application file, and include or discount a related preliminary application if applicable.
115Grant Needs CaptureTrack projects and programs that require grant funding, helping inform and streamline the process of identifying and applying for grants. This feature should allow users to capture detailed information about each project or program’s funding requirements and key timelines.
116Track and Update Grant TimelinesTrack and update key grant milestones, including NOFO issuance, months to complete the pre-application, months until invited to apply, months to submit the application, months to Notice of Award, environmental review duration, months to project start, months to project completion, and months from application start to project start.
117AI Grant Writing Assistant*Use AI-enabled tools to assist in drafting, revising, and reviewing grant narratives.
201AwardAward ManagementTrack awarded grants, including tasks associated with accepting grant awards, disbursement schedules, and reporting requirements.
202Award Acceptance*Prepare and route template memos and resolutions for City Council Acceptance.
301Grant-Making*Design of Application Forms*Define form structure and fields, filing data requirements, etc. via templates or custom design frameworks.
302Announcement/Publication of Grants Program*Prepare grants notice and publish it in multiple media and official journals.
303Email Notification for Registered Organizations*Allow organizations that are registered in the system the ability to receive email notifications whenever new grants that match their defined search parameters or funding criteria become available.
304Online Self-Service for Applicants/Grantees*Offer individual and organization registration, grants search, preliminary application and final application form submission, status of the application, etc. through the web.
305Capture of Application*Assign an identity to the application, preassign to appropriate committee and/or program staff, create the application file and include or discount a related preliminary application if applicable.
306Capture of BudgetValidate budget entries based on business rules. This includes caps on certain elements and approve or reject items as part of the budget process.
307Management and Integration of Attachments*Receive allowable attachments, and associate them with the original application package. Ability to hold the application until sufficient content is received.
308Preliminary Validation of Application*Verify in real time if the application is directed to the correct program, identity of applicants, and required data is included in the submission. Automated rejection of the submission if response is noncompliant with required data. Manages resubmission and reverification if allowable.
309Inbound Correspondence Management*Manage incoming documents, such as preliminary applications, final applications, complaints, requests for amendments and clarification, proposal withdrawals and resubmissions.
310Outbound Correspondence Management*Manage courtesy reminders, award notices, declines, withdrawals, etc.
311Collaborative Correspondence Management*Offer online forums where applicants can ask questions and receive advice. For example, some programs allow an application to be submitted as draft for comments before the actual application is submitted.
312Contact Management*Automate applicant/grantee registration (individual, organization and consortium) and manage identity credentials (role, updates, authorization to apply for multiple grants and so on).
313Finalize Eligibility Assessment*Complete review of formal requirements of the application after real-time validation, such as entitlement of applicant, completeness of data, timeliness of submission, analysis of funds already received via previous or parallel programs and so on.
314Web Accessibility*Pass WCAG 2.X standards. Provide a WCAG compliance report.
315Certification of Federal, State and County Assurance*Allow applicants to certify federal, state and County annual certifications and assurances
401Grant Making: Evaluation*Allocate/Assign to Committees/Panels*Determine which committee members will act as reviewers, and in what capacity. Includes load balancing, negotiation, identifying conflicts and possibly self-selection by members.
402Allocate/Assign to Staff*Identify and assign roles to program office staff members.
403Allocate/Assign to External Reviewers*Select internal and external reviewers not included in panels that have to evaluate the merit of the proposal.
404Provide Access to Review Material*Make application material available to the internal committee and external reviewers.
405Review Application*Read, research and create notes and comments for the application.
406Score Application*Use the defined evaluation criteria to score the application by creating rankings and recommendations.
407Collate Evaluation Score*Collate results of feedback on the merit of the proposal from internal and external reviewers.
408Meet and Discuss Evaluation*Support adjudication meetings to evaluate each application. Typically involves comments by readers, discussion, voting for new scores, assigning factors that will be taken into consideration when adjustments are made to competition wide criteria. Organize logistics of site visits when used as part of a multipart adjudication.
409Evaluation Results Approval*Allow program officers to approve all collected feedback to support award or decline decision and create a ranking of individual and competitive grants.
410Prepare Evaluation Report*Create an evaluation report summarizing results and suggesting changes for the next cycles of evaluation
411Decision*Record the final decision to award or decline grants funding.
412Announce Grants Awards*Notify grantees of award or decline decision and to publish results when necessary.
413Appeal Management*Support resubmission and reconsideration of the case if the applicant disagrees with a decline.
414Grants Agreement Negotiation*Support workflow of discussion of amount and nature of expenses to be reimbursed under the grants (direct and indirect, capital and operating), timeline of disbursements and reporting, inclusion of subgrantees and so on.
415Negotiation Results Approval*Allow program officers to approve grants agreement and commit funds to individual grantees.
416Subaward Decisions*Allow for staff to approve, modify, or reject subaward applications and commit funds to subgrantees.
417Award Letter Generation*Allow an award letter/notice of award to be generated and maintained within the system.
501Post-AwardPreparation of Subaward and Award AgreementsPrepare and transmit grant subaward and award agreements.Ensure that the execution of subawards follows a multi-step process, including digital signatures and the use of a Clerk’s digital seal. Notifications should be sent via email to the next signer in the process.
502Individual Subaward and Award AmendmentsModify the overall budget, individual line items, and time frame of subawards or award agreements, or process full termination. The amendment process should also follow a multi-step approval procedure, incorporating digital signatures and Clerk’s digital seal, with email notifications to the next signer in the process.
503Subaward and Award ManagementManage awards, subawards, and subrecipient agreements, including reporting and performance tracking.
504Preparation of Contract (Award Agreement)Prepare and transmit grant award agreement documents. The process should integrate multi-step approval workflows, with digital signatures and Clerk’s digital seal, and send email notifications to the next signer in the process.
505Acceptance and Signature of Contract (Award Agreement)Collect signatures on grant award agreement documents from program officers and grantees. Ensure the use of digital signatures and Clerk’s digital seal, with email notifications triggered to the next required signer at each step of the process.
506Amendment Requirement TriggersAllow users to define specific circumstances or events (such as budget changes, project scope alterations, timeline shifts, or compliance issues) that trigger the need for an amendment.
507Amendment Requirement GuidelinesStore and display the guidance or criteria related to amendments for each individual grant, such as specific thresholds (e.g., if costs exceed a certain percentage) or conditions that must be met for an amendment to be necessary
508Automated Amendment Alerts and RemindersSend automated alerts or reminders when specific triggers or conditions are met (e.g., a change in grant scope or an increase in expenses beyond a predefined threshold). Alerts should also include a link to the relevant amendment guidance.
509Individual Grants AmendmentsModify the management, time frame, and budget of grants awarded to a single grantee or full withdrawal of a subaward or award agreement. Amendments should follow a multi-step approval process, incorporating digital signatures and Clerk’s digital seal, with email notifications to each signer in the process.
510Program AmendmentsModify the management, time frame, and budget of an overall grants program, including related award agreements or subawards, or full withdrawal. The system should allow for multi-step approval workflows, including digital signatures, Clerk’s digital seal, and email notifications to each signer in the process.
511Compliance Controls and MonitoringCapture grant requirements and regulations, seemlessly integrate compliance controls into business processes, and support robust compliance monitoring throughout the grant lifecycle
512Compliance and Risk AssessmentFeatures to track compliance requirements and perform risk assessments. The system should flag compliance requirements as part of business processes, such as when processing payables against grants and when procuring goods and services.
513Performance and Reporting TrackingTrack and notify users via email when performance and other required reports are due.
601Administration and Performance ManagementRisk Assessment/Dashboard ReportingConduct risk analysis of grant programs based on determined criteria and provide dashboard status of grant programs administered
602Differentiate AwardsTrack and differentiate grant projects from other projects in the system (e.g., interlocal agreements, donations, etc.); Assign different award types, grant designations, and interlocal agreements.
603Dashboard SummaryProvide user-friendly summaries of year-to-date grant spending (possible to filter by funding stream, by subrecipient, by line item, etc.).
604Grant Position TrackingThe solution should have the ability to track and report on how many positions are funded by or allocated to grants throughout the City (part time and full time).
605Dependency Tracking*Track percentage dependence on grants per subrecipient and measure trends year over year.
606Match TrackingCalculate or capture required match per grant and track quarterly progress toward meeting match requirements. The system should also ensure that match progress is automatically updated as expenditures are recorded and updated from the City's general ledger.
607FFR (Federal Financial Report) GenerationAutomatically generate the FFR based on recorded expenditures and match contributions. The FFR should be created in compliance with reporting standards, and the system should match expenditures to the required match when applicable, ensuring accuracy in the financial reporting process.
608Provgram Income TrackingThe solution should have the ability to capture and report on program income or revenue per grant.
609Award TrackingTrack all awards, by funding stream, including amount awarded, amount sub awarded, spending to-date, and spending by category.
610Sandbox (Test System)Test the system with a “sandbox” version to identify weaknesses and bugs.
611Integration with other SystemsIntegrate with other technologies using REST API, flat files, or common data
612Periodic Report AssessmentAnalyze individual grants reports to evaluate compliance with program goals, budget and schedule according to grant criteria.
613Submission of Reports to External Committees*Send periodic report to external committees that oversee the grantor operations.
614Validation of Payments*Confirm disbursement after assessment of reports.
615Accept Uploaded Documentation*Allow grantees to upload supporting documentation along with draw requests (receipts, payroll records, timesheets, etc.)
616Revision of Documentation with ReviewAllow additional documents to be uploaded or revisions to uploaded documents to ensure records are adequate. This includes version control and tracking of changes, ensuring that all documents are current and properly reviewed.
617External System Integration for Data Capture and Pre-PopulationIntegrate with external funder systems (such as JustGrants, Intelligrants, and Grants.gov) to capture data from documents uploaded from those systems. This data should be automatically pre-populated into relevant fields in the City’s system to minimize manual data entry and ensure consistency across systems.
618Withdrawal of Funds*Withdraw funds should a report demonstrate lack of compliance.
619Payment ProfilingBreak down disbursements between operating and capital expenditures, direct and indirect costs, or other categories relevant to the program.
620Initiate Payment/RefundAllow users to request payment or reimbursement of funds, prepare the necessary documentation, and confirm the payment mechanism and date. This includes capturing all required details, such as payment amount, grant information, and account details, to facilitate the payment or refund process.
621Push System-Generated Reimbursement Requests to External Systems*Automatically push system-generated reimbursement requests to external systems like ASAP, with prepopulated account information (such as grant numbers, account details, and payment amounts). This feature should streamline the reimbursement process by automatically transferring data to external systems, reducing manual entry and ensuring consistency.
622Authorize payment/refund*Issue payment order and transfer of funds to appropriate account.
623Subgrantee Budget Management*The solution must have the ability for both staff and subgrantees to see real-time budget balance to date across all funding streams in award.
701Audit and Close GrantMake Payment/Intake RefundAllow treasurer to execute authorized payment/refund order.
702Final ReportAssess financial and operating report once the grants cycle has concluded.
703Final Reconciliation of FundsCalculate and account for unobligated funds, final payments or paybacks.
704Closure of Grants AgreementTerminate/close contract between grantor and grantee.
705Payment ApprovalAllow staff to authorize payment, and to send this authorization to the city controller to execute authorized payment. Should also be able to track the time interval between authorization and payment.
706Generate Closeout LettersGenerate subrecipient closeout letters.
707Audit and CloseoutSupport a formalized process for managing audits and closing grants, including read-only access for auditors and tracking final reconciliation and closure of grant agreements.
801Common Services Across PhasesCase Management*Create, manage and track case activities or claims relating to individual applicants and grantees. This includes cross-program information and the ability to link case events to process workflow.
802WorkflowDefine business rules and roles along the life cycle of the grants program.
803Document and Records ManagementCapture and store data from multiple sources and in multiple formats; to associate information with a particular case; to comply with retention policies and flexibility to set record retention ; and to audit record usage.
804Document ManagementManage and store grant-related documents, with robust capabilities allowing for collaboration, submission coordination, and tracking the status of documents.
805Data servicesDisplay currency, dates, times. Ability to provide enterprise relationship diagrams showing layout of tables, fields and data entity relationships. Ability to provide XML interface to seamlessly update and exchange data and provide the capability of populating and producing reports.
806Ability to Collect DataCollect data specific to the program from grant recipients
807Ability to Export DataExport collected data to .xlx or .csv files (and other formats if available)
808Due Date and Late NotificationsNotify grantees via email when required data or other items are due, late, or missing
809Data WarehouseExtract, transform and load large amounts of data.
810Analytics and ReportingCreate disbursement reports, budget and outcome analyses, KPI achievement, risk assessment of programs, detect duplicate applications, fraud detection, etc.
811Real-time DataUpdate data in real-time, particularly for components like payroll.
812Payroll IntegrationIntegrate with payroll systems for effort reporting and managing staff time charged to grants, addressing current challenges with split positions and allowable costs.
813Geolocational Analysis*Map applicant and/or recipient data geographically
814Text SearchSearch against database values and documents attached to grants application forms.
815SecurityProtect and encrypt data and manage grantees and grant-making agency employees' authentication and levels of authorization.
901Data CollectionCollection of Required DataCollect performance and other data required by grants.
902Customization of New Reports as NeededAllow creation and customization of reports for internal and external stakeholder, including dashboards for real-time insights.
1001Oracle EBS IntegrationIntegration ServicesSeemlessly integrate with financial management systems to ensure reconciliation of payments and accounts.
1002Multilingual Interface*Present and process data in multiple languages
1101Architecture IdentityAdministrative InterfaceThe product must use a web browser interface for all user access. It cannot require any "thick-client" installable software. The product must provide an interface in which an administrator can create, manage, and delete user accounts.
1102Directory SynchronizationProvide directory synchronization that will create, update, disable or delete user accounts based on the enterprise directory. The process must create and retain a change log that can be accessed for at least six months.
1103System SupportSupport SAML 2.0 federation, and specifically permit IDP-initiated SSO/SAML
1104System IntegrationInterface directly with existing systems (e.g., financial management software (Oracle E-Business Suite), task management software, Staffbase, Outlook (reminders, calendar)), via ION API/REST API. If not possible, the product must be able to exchange information via SFTP delimited files. (Please indicate in Comment Section which interface option it supports)
1105System Integration*Integrate with country-specific systems, such as the U.S. Federal Government Grants.gov platform.
1106System ManagementProvide authorization policy management to allow customer to have Administrator privilege from the business so it can maintain groups, privileges, and roles without having to rely on administrative IT staff.
1107System AccessMaintain a closed grant management site for the City to use but with the ability to allow outside sources to input data in it.
1108User ManagementProvision role-based access controls for different stakeholders, including administrators, applicants, and reviewers.
1201Architecture Data Storage & ManagementSystem Monitoring & AlertsReal-time monitor use and data thresholds and provide alerts to the City of St. Petersburg. Describe the COTS monitoring and alert system along with any elements that are configurable to meet the business needs of the City of St. Petersburg.
1202Data Storage LimitsAllow the City of St. Petersburg to surpass standard service use and data storage limits. Describe the notification process and any related costs that are triggered in the event that the City of St. Petersburg would exceed their limits.
1203Data ExportingProvide a path for bulk data export from the services. Describe any assistance that the vendor will need to provide if a bulk data export is required and any related costs.
1204Data ManagementDescribe your strategies in the proposed solution to ensure city data is protected and available 24/7. The discussion should include but not be limited to items such as: multiple data centers, uninterrupted power, data fall back procedures, etc. Also include a description of the data backup methodology and schedule(s) that will be applied to protect state data.
1205Data SecurityComply to NIST security standards. https://csrc.nist.gov/publications/detail/sp/800-53/rev-5/final
1206Confidential Data DetectionIdentify confidential information (e.g., through encryption, tagging, or metadata) to determine when the system needs to lock or restrict access. If sensitive or confidential data is detected, the system should trigger automatic security measures (e.g., data encryption, access restriction).
1207Data SecurityThe product offers a FEDRAMP-certified "GovCloud" data center (preferred).
1208Data SecurityData stored is ONLY stored in datacenters located in the United States.
1301Architecture ServicesImplementation SupportAssistance with system setup and configuration.
1302Data Import/LoadImport or load existing data from legacy systems or external sources. This functionality should ensure seamless migration of historical data. The system should provide tools for mapping, validating, and transforming the data to ensure accuracy, consistency, and integrity during the import process.
1303System AvailabilityThe system must be available 24/7, ensuring continuous access and functionality at all times, with a guaranteed uptime of 99.9% annually
1304Customer SupportCustomer support for the system must be available five (5) days a week, Monday through Friday, from 7:00 AM to 6:00 PM EST.
1305Support ServicesSupport personnel/engineers are based in the United States.
1306Software UpdatesUpdate its software at least every three (3) months to stay up to date on identified fixes and security features and work with current City of St. Petersburg's preferred browser(s). The Contractor must provide the City of St. Petersburg all available upgrades and new software versions at no additional cost to the proposed amount.
1307TrainingProvide training to all users, including both staff and subrecipient staff. The training materials should be easily accessible and include searchable virtual training guides that allow users to find information based on topics or specific subjects.

Response

Response
Compliant
Alternative Method
Modification Required
Non Compliant

File details come from the government source that posted it. Updated .