Exhibit A OPTIS Grant Management System Requirements Master.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
RFP SAIF Actuary Review
Solicitation number
S-16500-00011756
Issued by
Marion County, Oregon

About this file

This is an Exhibit A document containing the Grant Management System Requirements Master for the Oregon Department of Transportation (ODOT), outlining comprehensive functional and technical specifications for a Commercial-Off-the-Shelf (COTS) grant management system. The system must support ODOT's dual roles as both a federal grantee and state grantor, encompassing the complete grant lifecycle from funding opportunity identification through closeout. The requirements are organized into 30 major functional groups spanning system-wide capabilities, permissions and workflow management, data access, customization, user interface design, and support services. Key functional areas include advanced querying and reporting with dashboard views, role-based security with single sign-on integration, comprehensive grant tracking at multiple organizational levels, sub-recipient and vendor management, online application processing with customizable forms, and integration with federal systems such as SAM.gov and Grants.gov. The system must also support asset and work management capabilities, resource management including equipment and materials tracking, and financial integration with accounting and ERP systems. The platform must be fully cloud-hosted, accessible via standard web browsers, and permit multi-agency utilization with agency-specific configurations without affecting customization upgrades.

The document emphasizes that all configuration must be performable by agency staff without vendor involvement, and the system must support extensive customization of forms, workflows, reports, dashboards, and security parameters while maintaining compliance with federal grant management requirements including OMB financial reporting and FFR submission capabilities. Vendor support obligations include phone support as part of service level agreements, online manuals and release notes, in-person and online training, and user support forums. The requirements mandate support for electronic signatures, document management integration with platforms such as SharePoint and Google Docs, email notification and scheduling capabilities, and comprehensive audit trail functionality. Critical to sub-award management are capabilities for contract template creation, automated deadline reminders, progress report collection and analysis, payment integration with configurable approval workflows, and performance measurement against established goals, with the system designed to accommodate multiple spending and grant periods including single-year, multi-year, and state fiscal year reporting structures.

View the file

Other files

File Type Posted
SAIF Actuary Review RFP S-16500-00011756~2.pdf PDF
RFPAttE Cost Proposal~3.xlsx XLSX spreadsheet
RFPAttD~3.docx DOCX document
Amendment 1 RFPAttE Cost Proposal.xlsx XLSX spreadsheet
RFPAttG~3.docx DOCX document
RFPAttB~3.docx DOCX document
RFPAttA Sample Contract for Actuary Review Services~1.docx DOCX document
RFPAttC~3.docx DOCX document
RFP s-16500-00011756 Amendment 1.pdf PDF
RFPs-16500-00011756 Amendment 2.pdf PDF
Intent_to_Award_SAIF_Actuary_Review 6-23-25.pdf PDF
Show all 11

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet1

Requirement GroupIDRequirement Detail
General System-Wide Requirements
System Querying and Reporting1.1Casual users can easily run queries and retrieve reports independently with minimal training.
1.2Ability to search or filter to find a particular set of grants based on various important fields such as status, federal award number, and funding agency.
1.3Ability to make common updates to standard reports—for example, to change the columns displayed, or the grouping—to meet slightly different needs.
1.4Ability to view favorite reports, actions, or queries without searching/navigating a large result set.
1.5Ability for users to name and save newly created reports.
1.6Supports user creation of ad hoc reports within the system including any field displayed to users, custom data columns, sorting, grouping, logos, and headers.
1.7Virtually all system data—including data entered into online applications, review forms, and sub-recipient progress reports—can be included in reports.
1.8Allows drill down on reports.
1.9Ability to search within attached documents.
1.10System contains industry-standard reporting templates.
1.11Reports can be set to automatically run and send to individuals or groups.
1.12Report support visual graphic representations—e.g., charts or graphs.
1.13Provides pre-defined “dashboard” views that summarize the grants currently relevant to each individual user.
1.14Provide a department wide sub-recipient/vendor repository that contains grant funding history.
1.15Ability for the agency, sub-recipients and/or vendors to print a final report.
1.16Ability to define a standard visual dashboard of the grant lifecycle milestones and alerts that can be customized by agency.
1.17Ability to report, sort, and query on any field.
1.18Reports must be able to support graphics such as attachments, graphs, charts, logos, and watermarks.
1.19Provides a user-friendly report writer that does not require vendor or technical assistance.
1.20Reports must be able to be printed our exported into various file formats such as .pdf, .csv, .doc, .xls, etc.
Permissions and Workflow2.1Ability to grant individuals access to granularly view, edit, or delete data for a wide variety of system functions.
2.2Ability to provide a role-specific internal interface for each role in the system.
2.3Records most data updates, along with the data and the user who made the update, in an audit log.
2.4Provides “dashboard” views that only display information that the user has permissions to access.
2.5Provides users a “task list” when they sign onto the system.
2.6Ability to assign tasks, such as reviews, to other users.
2.7Ability to provide a focused, roles-based view for management via dashboards and role definitions.
2.8Assigns tasks to users based on security permissions.
2.9System provides role-based data security, task lists, and email reminders.
2.10Supports single sign-on capability with AD & LDAP.
2.11Supports the ability to integrate with electronic signature systems.
2.12Provide workflow capabilities and dashboard tracking for key activities within the federal grant lifecycle.
2.13Ability for administrators to view, sort and organize submissions.
2.14Supports electronic approvals.
2.15Ability to delegate authority to another user to approve or take other actions on a workflow item or task.
2.16Ability to inactivate any user in the system.
Data Access3.1Allows export of all data visible to users into another file format, such as .xls or .csv.
3.2Allows a programmer to create custom data flows to an external system.
3.3Ability to import grants current and historical data from various formats including spreadsheets and databases.
3.4Data is secure and encrypted at rest and when data travels to and from the database via network connections using Advanced Encryption Standard (AES) (up to 256-bit keys), Triple Data Encryption Standard (DES), and RC4 encryption.
Overall Customization4.1Ability to customize online forms including file uploads, drop down lists, checkboxes, and text fields.
4.2System includes character and word counts for application questions, and an administrator can set and adjust character limit for any field.
4.3System includes in-system editable help text for customizable fields created.
4.4Allows customized dropdown values for fields.
4.5Allows custom fields throughout the system.
4.6Allows custom “internal tracking” fields for staff use only.
4.7Allows customization of the information requested in online forms.
4.8Fields may be marked as required.
4.9Labels and field order are fully customizable.
4.10Vendor permits customized systems to remain on the upgrade path, and ensures that enhancements don’t affect customizations.
4.11Ability to define custom language sets for public-facing forms.
4.12All configuration can be performed by the staff without involvement from the vendor.
Ease of Use5.1User interface is polished, organized, and intuitive.
5.2Navigation and action items are labeled intuitively.
5.3On the core interface pages, the user can easily find the actions they would most likely take.
5.4System groups information and actions an expert user is likely to need.
Support and Training6.1Vendor provides phone support included in as part of the SLA.
6.2Manuals and release notes are available online.
6.3Vendor provides in person and online training.
6.4User support forums or discussion groups are available.
Installation and Maintenance7.1System is fully hosted and cloud-based accessible from any major web browser.
7.2Ability to export all system data into CSV and PDF format.
7.3System must be a Commerical-Off-the-Shelf (COTS) solution.
7.4Ability to support multiple agencies utilizing the same instance of the system.
7.5Ability to have agency specific configurations within the same instance of the system including workflows, reports, dashboards, forms, and security.
Letters/
Documents8.1Ability to create custom forms for printing including the ability to choose which fields to include, as well as customizing fonts, colors, and logos.
8.2Ability to create letter templates in Microsoft Word that include mail-merged information about grants and organizations, and lets you customize their fonts, colors, and logos.
8.3Electronic signatures on letters and other documents supported with an integration.
8.4All letters and documents can be exported out of the system to Word, Excel, or PDF.
Emails9.1Supports spell checking within the system.
9.2Ability to create email to individuals and groups based on templates that include both standard text and “mail-merge” type inserted data.
9.3Allows file attachments to emails sent to individuals and groups.
9.4Ability to set up event-triggered emails.
9.5Ability to set up and send scheduled reminder emails to applicants and sub-recipients.
Integration10.1Supports integration with enterprise systems including financial and ERP systems.
10.2Integrates with SAM.gov and Grants.gov.
10.3Ability to integrate with a Document Storage client file server such as SharePoint, Google Docs, or other document storage application.
10.4Ability to integrate with federal agencies grant management systems, payment systems and reporting systems /websites.
Collaboration11.1Ability to collaborate across multiple teams using social media tools.
11.2Ability to upload documents (Word, Excel, PDF) to support the grant management lifecycle.
11.3Supports creating, assigning, and tracking tasks.
11.4Supports calendar sharing and scheduling.
11.5Provides a dashboard with messages, tasks, workflow items, and other pre-defined performance measures.
ODOT as a Grantee
Registration12.1New user registration.
12.2Department user and organizational profile creation and maintenance.
12.3Ability to allow multiple users to register to work on a single application.
Funding Opportunity13.1Ability to provide a searchable repository to identify grant opportunities by keyword.
13.2View multiple Funding Opportunity Announcements (FOAs) and recent updates.
13.3Search across grant announcements from external services such as Grants.gov and foundations.
13.4Review/rate FOAs and collaborate on pursuit decision making and next steps.
13.5Ability to schedule automated application due date reminder email notifications.
13.6Internal FOA review and formal approval process prior to opportunity pursuit.
13.7Track all historic opportunity data such as past funding information, grant performance measures, prior vendors, attachments, success rate with the federal agency for a specific program, etc.
Applications14.1Complete, review, approve, and store applications directly in the system.
14.2Ability to create, store, and update budget spreadsheets that meet the level of detail required for federal grant submissions.
14.3Ability to attach artifacts e.g., Word, PDF, Excel, etc. to grant application.
14.4Define multi-level workflow for the application to support the review and approval processes.
14.5Maintain historic application repository including version control.
14.6Display all federal grants that are in the application process across all the department.
Award Management15.1Ability to manage and report on grants at the multiple levels including department, project, grant, and sub-award.
15.2Ability to support the federal grants spending and project periods including:

• Single year spending and grant period

• Multi-year spending and grant period

• Multiple spending periods within a grant period

• State fiscal year reporting

15.3Ability to interface with accounting systems to track expenses, collections, and payments.
15.4Ability to identify match for a grant and determine if match requirements are met including third party match.
15.4Ability to track indirect cost and determine if appropriate amount is being reimbursed.
15.6Ability to manage grant award amendments.
15.7Ability to track tasks and milestones for a grant.
15.8Ability to monitor grant spending against budget.
15.9Upload all documents required for the grant set-up as they are received including award letters, amendments, internal documents, etc.
15.10Grant management system sub-recipients and vendors are alerted to provide interim or final reports and then submit the reports via the system.
15.11Ability to generate federal OMB financial reports (e.g. FFR, FFATA).
15.12Ability to create an audit trail of actions taken on a grant.
15.13Ability to track vendor contracts including deliverables, terms, progress, and payments.
15.14Ability to support creating and maintaining grant project schedules including key grant dates as well as project dates (site visits, reporting dates, etc.).
15.15Ability to interface with federal system to initiate a draw down or funds reimbursement.
15.16Ability to track draw downs.
15.17Ability to produce federal reports to request reimbursement (e.g. SF-270).
15.18Ability to create custom forms to request payments.
15.19Ability to update the Approved Budget in response to an approved budget re-direction request.
15.20Ability to provide managers list of key grant dates across all the grants under their management.
15.21Ability to revise the grant application budget to an approved budget in response to creating a grant award.
15.22Ability to update the Approved Budget in response to an approved budget re-direction request.
Post-Award Reports16.1Create federal financial and performance reports.
16.2Aggregate and finalize reports to the federal government.
16.3Manage program level budgets and programmatic impact.
Close Out17.1Create grant close out documents including final financial and performance reports per task-based checklist with workflow capability and notifications.
17.2Measure performance and financial outcomes.
ODOT as a Grantor
Applicant Registration18.1System registration follows standard best practices—applicants enter email address and password and are sent a confirmation email.
18.2System checks the email address of each new registrant to make sure it doesn’t already exist in the system and prompts the registrant if there is a match.
18.4System creates a profile for each sub-recipient based on registration information and other information desired by the department.
18.5Ability for sub-recipients to maintain profile information online.
18.6Supports multiple logins for sub-recipients on a single application—for example, allows separate people to complete financial sections and proposal sections.
18.7Sub-recipient organization profile can be automatically populated with information from the IRS by entering the EIN number.
18.8Both applicant and grantmaker can quickly and easily reset lost credentials via self-service tools.
Internal Tracking19.1All information for each grant is linked together through its entire lifecycle from the federal award to the sub-awards and vendor contracts.
19.2Ability to retrieve grant information and status.
19.3Track by categories, such as geographic, population-based budget, or project codes, and by percentage or dollar allocations.
19.4Split grants across different categories/codes.
19.5Define custom categorization codes for tracking and reporting.
19.6Ability to update basic grant information like project names or codes throughout the process.
19.7Attach files to grant records, including Word documents, Excel spreadsheets, and PDFs.
19.8Paper applications can be easily entered into the system and attached to existing users.
19.9System uploads attached documents to the server and stores a link to that uploaded file in the database.
19.10Batch data updates of defined coding and other fields is supported.
19.11Ability to see related records and data across records.
19.12Ability to report on all changes made by a sub-recipient over a specified timeframe.
Online Applications20.1Ability to create new online applications file uploads, dropdown boxes, checkboxes, and text fields, without additional charges from the vendor.
20.2Ability to create different online forms to support each grant program.
20.3Ability to format applications—for example, use rich text, create groups of questions, and create multiple pages.
20.4Grant application forms can "branch"—for example, to show a different set of questions based on specific criteria.
20.5System allows both individuals and organizations to apply for grants from the same grant program.
20.6System does not allow more than one application from an entity for an award.
20.7Receive grant applications and proposals in electronic format.
20.8Eligibility quizzes can "branch" (stored and reused) to multiple applications.
20.9Supports multiple application stages, including eligibility quizzes.
20.10Applicants can save partially completed applications and return to them later.
20.11Ability for the sub-recipient or applicant to transfer their account and history to a new staff contact.
20.12Applicants can view their status online.
20.13Applicants can easily view or print applications at any stage in the process.
20.14Applicant can create a preview packet of their grant which includes either copies of all uploaded documents or links to them.
20.15Offers a full virus scan feature to prevent malicious files from being uploaded onto the application.
20.16Allows for applicants or sub-recipients to manage all grant information for all of their funders in the system.
20.17Provide a workflow with checkpoints to ensure that all documents are provided.
20.18Provide templates and forms to sub-recipients and vendors to control responses and material submitted.
Application Review22.1Provides history of a relationship with prospective sub-recipients such as past communications, applications completed, applications declined or awarded across the department.
22.2Supports checklist functionality to define what information or documents are required from prospective sub-recipients.
22.3Ability for reviewers to print grant summaries or full grant information.
22.4Provides an interface to allow reviewers to view, review, and score grant applications.
22.5Allows reviewers to view uploaded documents associated with the application.
22.6Ability for users to define automatic workflows to support grants review process.
22.7Ability for multiple reviewers to evaluate and score an application on a number of different factors and add comments.
22.8Supports different information or scoring schemes for different programs.
22.9Provides numeric review scores with ability and report summary statistics.
22.10Ability to choose whether to allow reviewers to see each other’s comments and scores.
22.11Ability to choose whether to allow applicants to see the reviewers' comments.
22.12Ability for agency staff to view applications and reviewer comments.
22.13Ability to notify applicant the status of the applications - approved or denied.
22.14Ability to notify applicant and grants management staff when reviews are completed, either via email or internal message, or both.
Client Relationship23.1Allows multiple individuals on online forms with ability to track contact status.
23.2Tracks organizations separately from individual grants to allow you to see a history of all grants to an organization.
23.3Ability to send email to any contact recorded in an application form.
23.4Ability to associate multiple contacts with an organization and define their relationships.
23.5Ability to log outside communications, such as phone calls and emails, with a particular contact at a grantee organization.
23.6Ability to store a record of all system-generated letters and emails for each grant.
23.7Ability to capture emails from an external email system.
23.8System allows you to automatically export system contacts.
23.9Ability to create a risk assessment template for sub-recipients containing various fields of varying field types for data collection.
23.10Ability to capture risk assessment for sub-recipients at the time of application and periodically thereafter, and provide a monitoring plan that is visible to the department.
23.11Allows scheduling, tracking, and documenting of sub-recipient monitoring activities (e.g. desk reviews, onsite visits, training, etc.) with workflow and e-mail notifications.
23.12Ability to track findings, issues, and concerns from a desk review.
23.13Allow sub-recipients to submit resolutions/responses to desk review action items online.
Sub-award Management24.1Ability to create a contract template with standard language.
24.2Ability to create and maintain standard language for individual contract terms and conditions.
24.3Ability to generate a contract using the template and selecting specific pre-defined terms and conditions relevant to the grant.
24.4Workflow to route contract for review and approval.
24.5Ability to associate documents as part of an award package for distribution or download/printing.
24.6Ability to track where grant funding is disbursed by zip code.
24.7Ability to define a default set of grant requirements and customize them for individual sub-awards.
24.8Ability to “branch” (store and reuse) data collection based on grant type.
24.9Sub-recipients can view grant requirement deadlines online.
24.10Ability to report on performance measures against goals using submitted progress reports.
24.11Ability to view which requirements sub-recipients have met and which they have not.
24.12Automatically email sub-recipients to remind them about upcoming deadlines using email templates.
24.13Track the receipt of progress reports and approval by internal staff.
24.14Store progress report information submitted by sub-recipients to allow summarization across many sub-recipients.
24.15Submit progress report information through online data fields.
24.16Ability to create custom online progress report forms specific to the grant.
24.17Ability to configure a template of performance measures to collect data based on grant program.
24.18Allows staff to define performance goals by program and for individual grants, and automatically measures progress toward those goals using submitted progress reports.
Payments25.1Ability to integrate with the accounting system for payments.
25.2Ability to generate a custom form request for accounting.
25.3Ability to view payments that are due based on a schedule and whether the sub-recipient has met the associated prerequisite requirements.
25.4Supports an automated payment approval process with configurable workflow steps.
25.5Allows for payments to be made contingent or conditional upon a specified grant or payment requirement.
25.6Allows configuration of audit/security controls to ensure that only certain staff can change payment information.
25.7System provides the ability to include notes on payments.
Budgeting26.1Create budgets by grant year (project period and budget period), state fiscal year, and the total amount awarded.
26.2Track budgets against spending by grant year (project period and budget period), state fiscal year, and the total amount awarded.
26.3Allow budgets to be summarized by defined categories or programs.
26.4Allows use previous years’ budgets as a base with ability to and adjust them for current year.
26.5Split grants across more than one program for budgeting and payment-tracking purposes.
26.6Ability to set up multi-year budgets.
26.7Ability to revise the contract budget per approved re-direction request
26.8Ability to create a process for requesting budget re-direction, with configurable review and approval hierarchy.
ODOT and Asset Management
Asset Management27.1Ability to move assets from one location to another
27.2Ability to set up Preventative Maintenance plans for any asset. Plans must be able to be created based on time, condition or a combination of both.
27.3Configurable performance curves must be available for every asset in an easy to use graphical interface.
27.4Standard and configurable inspection capability for every asset with weighted condition categories can be utilized.
27.5Each asset should have the capability to view historic work, broken down by completed, in-progress or planned work status.
27.6Work activities must be able to be configured for any type of asset.
27.7Every asset type can have their own configurable attributes that can be tracked.
27.8Ability to see a roll up cost of every work activity performed against an asset.
27.9Ability to view an estimated overall condition index (OCI) for every asset that automatically calculates.
27.10Every asset should allow for various attachment file formats to be associated to asset record.
27.11Ability to create configured, non-standard assets with little or no vendor assistance.
27.12Ability for assets to be linked to other assets (sign to a support for example)
Work Management28.1Ability to create work on assets and non-assets.
28.2Ability to create non-asset work without a location being required.
28.3Ability to group multiple tasks together for cost and progress-level tracking.
28.4Ability to assign a priority to work.
28.5Intuitive work creation wizard that steps the user through the process.
28.6Ability to assign work to an individual or multiple laborers and or crews.
28.7Email notifications when new work has been assigned to a laborer.
28.8Ability to reassign work from one laborer to another based on permissions.
28.9Ability to receive email notification upon work completion or cancelation.
28.10Ability to manage work tasks and work orders.
28.11Ability to create work orders with multiple tasks associated to it and roll up cost capability.
29.12System must have capability to manually or automatically calculate estimated activity costs. These costs should be easily comparable to actual costs.
Resource Management30.1Equipment/vehicles can be tracked in time or distance (miles, kilometers) for usage.
30.2Preventative maintenance plans can be created for equipment based on time, condition or a combination of both.
30.3Vehicle Replacement Ratings (VRR) can be associated to vehicles to assist in determining when vehicle is nearing the end of useful life.
30.4Labor, Equipment and Materials can be associated to any work activity with costing information automatically calculated.
30.5Materials can be inventoried and quantity automatically deducted from inventory when consumed.
30.6Ability to establish inventory consumption methodology in either LIFO, FIFO, Most Expensive or Least Expensive first.
30.7Ability to establish re-order point and amount to re-order with email notifications when threshold is met.
30.8Labor, Equipment and Materials should be available via pick lists when entering against a work activity.
30.9System must support the ability to multiple laborers, equipment and materials to multiple work records at the same time.
30.10System must support the use of multiple warehouse locations, including mobile warehouses.
30.11System must support the ability to transfer materials from one location to another.
30.12System must have the ability to order materials and restock to inventory when they arrive.

_x000D_&1#&"Calibri"&10&K000000 Level 3 - Restricted

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