Attachment B _ RP024_26 Functional Requiremen.xlsx

XLSX spreadsheet 100 KB Posted

Attached to
RP024-26, Provision of a Re-Entry Management System on an Annual Contract
Solicitation number
PE-77023-NONST-2027-000000715
Issued by
Gwinnett County, Georgia

About this file

This is a Functional Requirements Response Workbook for Gwinnett County Sheriff's Office (GCSO) related to a competitive solicitation for case management and reentry services software. The document establishes evaluation criteria and scoring methodologies for vendor proposals across three solution types: Cloud, Hybrid, and On-Premise deployments. The solicitation requests a comprehensive system to support the GCSO's GRIP (reentry and recidivism reduction) program, capable of capturing participant demographic, legal, behavioral health, educational, and employment information, along with integration with the county's Smart Cop Jail Management System and Securus Technologies for communications. The evaluation framework includes 47 Information Technology (IT) requirements and 54 business requirements organized by functional categories including intake processes, case management, secure communications, reporting and analytics, compliance and accountability, user experience, and administrative roles. Requirements are weighted as High (5 points), Medium (3 points), or Low (1 point) importance, with vendors required to indicate availability (Full/Partial/No), environment compliance, and delivery compliance for each requirement.

The scoring structure allocates a total point value of 20 points for Cloud solutions, 25 points for Hybrid solutions, and 25 points for On-Premise solutions. The workbook establishes maximum possible scores of 205 points for IT requirements and 252 points for functional requirements, totaling 457 raw points that normalize to the respective point values by solution type. Vendors must complete response columns for Availability, Environment Compliance, and Delivery Compliance for all requirements, with failure to complete all three response columns resulting in a zero score for that requirement. Vendors selecting Hybrid or On-Premise solutions receive different scoring considerations, particularly for Cloud-specific IT requirements (IT-8 through IT-17). Critical compliance mandates include SOC 2 Type 2 certification for Cloud/Hybrid solutions, HIPAA compliance, CJIS compliance, Section 508 accessibility, Georgia Open Records Act compliance, FedRamp High or StateRamp certification, and encryption standards for data in transit, at rest, and during backup and retrieval. The solution must support mobile-friendly access for post-release participants up to three years after release and include comprehensive audit trails, version control, and document management capabilities.

View the file

Other files

File Type Posted
Attachment A _ Security Requirements for Purc.pdf PDF
Attachment C _ RP024_26 _ Pricing Proposal Re.xlsx XLSX spreadsheet
RP024_26 INV.pdf PDF

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

Scoring Summary- HIDE

Scoring SummaryVendor
Solution TypeCLOUD
Scoring Total Point Value20
Worksheet NameAvailable Raw PointScored Raw PointsNormalized Points
HighsMediumsLowsMaxHighsMediumsLowsTotalHighsMediumsLowsTotalRequirement row range for formulas
5315First rowLast rowException range
Functional Requirements Sheet 116045020500000000Sheet 1450
Functional Requirements Sheet 223021125200000000Sheet 24500
TOTAL39066145700000000
Scoring SummaryVendor
Solution TypeHYBRID
Scoring Total Point Value25
Worksheet NameAvailable Raw PointScored Raw PointsNormalized Points
HighsMediumsLowsMaxHighsMediumsLowsTotalHighsMediumsLowsTotalRequirement row range for formulas
5315
Functional Requirements Sheet 116045020500000000Sheet 1450
Functional Requirements Sheet 223021125200000000Sheet 24500
TOTAL39066145700000000
Scoring SummaryVendor
Solution TypeON-PREMISE
Scoring Total Point Value25
Worksheet NameAvailable Raw PointScored Raw PointsNormalized Points
HighsMediumsLowsMaxHighsMediumsLowsTotalHighsMediumsLowsTotal
5315Requirement row range for formulas
Functional Requirements Sheet 113530016500000000
Functional Requirements Sheet 223021125200000000Sheet 145011-20
TOTAL36551141700000000Sheet 44200

&A &B Confidential&B Page &P

Functional Requirement Instruct

1.1 Completing the Functional Requirements Response Workbook
Step 1. Review the instructions on the first worksheet.

Step 2. Go to each tab/worksheet and enter your company name in Cell H2 (Default value:"<Enter service provider Name>").

Step 3. Go to each tab/worksheet "Solution" and select the Solution Type from the drop-down options in Cell F2.

(This impacts the scoring and not scoring of solution type specific requirements in the workbook.)

Step 4. Go to each row in each of the worksheets and for each corresponding requirements select the response from columns F, G and H that reflects the current state of the proposed solution.

For any response that indicates "Yes - Partially met" for Availability, the vendor is required to include an explanation in the "Response Notes" Column E.

NOTE: Failure to complete all three response columns for a requirement will result in a score of zero (0) for that functional requirement. Failure to complete the Response Notes for "Partially met" items may also result in a zero or a degraded score. Further, Columns E, F, G and H are the ONLY columns in which the service provider should enter information. All other columns should are for internal use only and must not be altered by the service provider.

Additional detail on the columns in the worksheet is included in the Request for Proposal document.

Note : Light blue cells indicate response cells for the responding Solution Vendor.

TermMeaning
UserAll users that are authorized (based on roles and permissions) to perform the specified capability or use the feature described.
County Administrative UserGwinnett County Government users of the solution who posses the rights necessary to perform administrative functions within the application - such as User Management, Configurations, etc.
Service ProviderThe provider of the proposed solution that is responding to the RFP.
RecidivismThe tendency of a convicted criminal to re-offend due to causes such as lack of support, barriers to employment, and behavior and personal issues.

&F

&D &A Page &P

IT Requirements Sheet 1

Req. IDCategoryImportanceRequirementResponse NotesCompliance Response
AvailabilityCompliance Response
EnvironmentCompliance Response
DeliveryTally
(H,Full)Tally
(H,Part)Tally
(H,No)Tally
(M,Full)Tally
(M,Part)Tally
(M,No)Tally
(L,Full)Tally
(L,Part)Tally
(L,No)Availability scoreEnvironment ScoreTotal weighted scoreMaximum available scoreScorer CommentsTraceability
SOLUTION TYPEService Provider Name <Insert Service Provider Name>520310100(1,.25,0,0)
The proposed solution…....
IT-1Auditing and ReportingMedium.. includes the ability to capture and access reporting on usage statistics.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-2Auditing and ReportingHigh.. includes and retains audit information based upon configured rules.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-3Availability and ReliabilityHigh.. fits within the County’s disaster recovery and business continuity plans for the organization. The County will require proof prior to final award.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-4Availability and ReliabilityHigh.. includes redundancy and can be deployed without a single point of failure.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-5Availability and ReliabilityMedium.. provides a high availability architecture or configuration options to operate as such.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-6Availability and ReliabilityMedium.. has the ability to provide horizontal scalability and redundancy to all levels of the architecture/infrastructure.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-7Availability and ReliabilityHigh.. provides solution and data backups.

- For on-premise solutions, it provides for full and incremental backups to support a fail-safe backup strategy.

- For hosted solution, it provides a fail-safe backup.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-8Cloud & Hybrid SolutionHigh.. is SOC 2 Type 2 compliant. As such the vendor will provide a System and Organization Control (SOC) 2 Type 2 report with an Unqualified opinion prior to final contract award.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-9Cloud & Hybrid SolutionHigh.. provides Data Security, including safeguards against unauthorized access and disclosure of confidential, sensitive, and personally identifiable information (PII).Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-10Cloud & Hybrid SolutionHigh.. provides detailed logs of audit events and makes these logs continuously available for ingestion by a security information and event management solution (SIEM) without the need to manually download or transfer data.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-11Cloud & Hybrid SolutionMedium.. is NIST 800-53 Compliant.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-12Cloud & Hybrid SolutionMedium.. is SSAE16 Certified.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-13Cloud & Hybrid SolutionMedium.. enables software updates and patches automatically applied within 30 days for critical updates/patches and immediately for vulnerability with a known exploit.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-14Cloud & Hybrid SolutionMedium.. is compatible with Microsoft DLP.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-15Cloud & Hybrid SolutionMedium.. provides the ability to implement high-availability architecture implementations that support 99.99 uptime or better.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-16Cloud & Hybrid SolutionHigh.. meets HIPAA Compliance rules and guidelines.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-17Cloud & Hybrid SolutionHigh.. and solution provider(s) guarantee all County owned data is stored within the continental United States of America.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-18ComplianceHigh.. enables access to custodians of documents subject to the Health Insurance Portability and Accountability Act of 1996 (HIPAA), and the rules adopted under it and prohibit unauthorized access.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-19ComplianceHigh.. is compliant with Section 508 of the Rehabilitation Act of 1973 to provide for accessibility of information technology by the handicapped.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-20ComplianceHigh.. supports compliance with the State of Georgia Open Records Act (50-18-71 Article 5).Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-21ComplianceMedium.. supports the use and security of digital signatures (as authorized by the Georgia Electronic Signature Act, Title 10 Chapter 5) and should follow the Georgia Uniform Electronic Transactions Act.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-22ComplianceHigh.. enables compartmentalization of documents identified by their creators as judicial work product, attorney privileged, confidential, personally identifiable information (PII), protected health information (HPI), etc. so that only authorized users may access them and those users are aware of their classification.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-23SecurityHigh.. remote access capabilities are compatible with the existing enterprise remote access solutions (Global Protect and Cisco AnyConnect).Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-24SecurityHigh.. meets that requirement the all vendor personnel and contractors accessing the data are based in the continental United States.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-25SecurityHigh.. enforces unique usernames.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-26SecurityHigh.. does not store authentication credentials or sensitive data in its code.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-27SecurityHigh.. includes an interface for assigning, reporting, certifying, and modifying permissions based on user.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-28SecurityHigh.. meets or exceeds any and all encryption standards for data storage, access, and transmission as outlined in Exhibit A.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-29SecurityMedium.. provides file encryption capabilities within the solution and allows storage of data that has been encrypted by other encryption platforms (and continue to maintain those encryption levels).Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-30SecurityHigh.. is certified FedRamp High or StateRamp.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-31SecurityHigh.. provides roles and permissions assigned individually and by group or role.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-32SecurityHigh.. ensures end-to-end encryption of data in transit.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-33SecurityHigh.. ensures end-to-end encryption of data at rest.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-34SecurityHigh.. ensures end-to-end encryption during backup and retrieval.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-35SupportabilityHigh.. has uptime availability that meets or exceed a 99.5% service level to meet County requirements, excluding planned maintenance.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-36SupportabilityHigh.. is configurable.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-37SupportabilityHigh.. does not require a “heavy client” installation on the individual workstations or on-site servers.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-38UsabilityHigh.. provides users with a intuitive user interface that requires no coding experience and requires less than two hours of user training.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-39UsabilityMedium.. provides a user interface that uses standard MS Windows-like layout and navigation features.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-40UsabilityHigh.. provides the ability to use and create context sensitive tooltips or other similar online help feature.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-41UsabilityMedium.. provides context sensitive Online Help.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-42UsabilityMedium.. provides context menus accessible on a right mouse click or other one-step access.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-43UsabilityHigh.. provides a Web-Enabled User Interface.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-44UsabilityMedium.. adheres to Usability Design best practices in its construction (e.g., ISO 9241).Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-45UsabilityMedium.. includes computer-based training (CBT) or online training modules.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-46UsabilityHigh.. allows all user components to be available to users through one common interface (user does not have to move between applications) to perform their work.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-47UseabilityHigh.. is compatible with multiple browsers including the following ones at a minimum: Edge, Google Chrome, and Safari.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Totals000000000000205

&F &A

&D &A Page &P

GCSO Functional Requirements

Req. IDCategoryImportanceRequirementResponse NotesCompliance Response
AvailabilityCompliance Response
EnvironmentCompliance Response
DeliveryTally
(H,Full)Tally
(H,Part)Tally
(H,No)Tally
(M,Full)Tally
(M,Part)Tally
(M,No)Tally
(L,Full)Tally
(L,Part)Tally
(L,No)Availability scoreEnvironment ScoreTotal weighted scoreMaximum available scoreScorer CommentsTraceability
SOLUTION TYPE<Insert Company Name of Responding vendor>520310100(1,.25,0,0)
The proposed solution…....
BR-1Standardize and Streamline Intake ProcessesHigh…captures participant demographic information.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-2Standardize and Streamline Intake ProcessesHigh…captures participant legal information.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-3Standardize and Streamline Intake ProcessesHigh…captures participant behavioral health information.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-4Standardize and Streamline Intake ProcessesHigh…captures participant educational information.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-5Standardize and Streamline Intake ProcessesHigh…captures participant employment history.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-6Standardize and Streamline Intake ProcessesMedium…supports photograph file type uploadsSelect from drop down listSelect from drop down listSelect from drop down list0000000000003
BR-7Standardize and Streamline Intake ProcessesHigh…integrates with Smart Cop Jail Management System (JMS)Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-8Standardize and Streamline Intake ProcessesMedium…flags individuals with special needs to include mental health, medical history, and PREA status.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
BR-9Support tailored case manangementHigh…creates individual participant case file.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-10Support tailored case manangementHigh…supports uploading of participant documentation such as Microsoft Word, Excel, CSV and PDF files to case file.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-11Support tailored case manangementHigh…intergrates GCSO specific GRIP Vocational Program Training Standards and Theraputic Curriculum Requirements.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-12Support tailored case manangementHigh…allows GCSO personnel to assign specific GRIP Vocational Program Training Standards and/or Theraputic Curriculum requirements to participant.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-13Support tailored case manangementHigh…tracks a participant's progress on assigned GRIP Vocational Program Training Standards and/or Theraputic Curriculum requirementsSelect from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-14Support tailored case manangementHigh…notifies GCSO personnel to a participant failing to complete portions of assigned GRIP Vocational Program Training Standards and/or Theraputic Curriculum requirements.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-15Support tailored case manangementHigh…supports mobile-friendly access for individuals post release, up to three years post release.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-16Secure Communication and Information SharingHigh…interfaces with Securus Technologies for messaging.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-17Secure Communication and Information SharingHigh…interfaces with Securus Technologies for video conferencing.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-18Secure Communication and Information SharingHigh…maintains communications logs between GCSO personnel, participants, and service providers.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-19Secure Communication and Information SharingHigh…links referrals to internal external programs.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-20Secure Communication and Information SharingHigh...tracks referrals to internal and external programs.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-21Secure Communication and Information SharingHigh…provides participant access to GCSO GRIP Program and Community Resources guides and allows for the updating of participant resources.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-22Secure Communication and Information SharingHigh…provides participants access to Gwinnett County Accountability Courts Resource Guides.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-23Secure Communication and Information SharingHigh…provides participants the ability to download, fill, and send back Gwinnett County Accountability Courts Intake documents.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-24Secure Communication and Information SharingHigh…maintains records of Gwinnett County Accountability Courts Intake documentation.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-25Secure Communication and Information SharingHigh…allows GCSO personnel and authorized service providers to monitor all communications and documentation associtated with participant case file.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-26Secure Communication and Information SharingHigh…allows separate communication capabilities between GCSO personnel and authorized service providers that is not viewable by participant.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-27Reporting and AnalyticsHigh…supports real-time case activity reporting.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-28Reporting and AnalyticsHigh…utilizes a standard dashboard for all users based on roles and permissions.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-29Reporting and AnalyticsHigh…allows users to customize dashboard based on role and permissions.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-30Reporting and AnalyticsHigh…allows for custom report creation based on user roles and permissions.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-31Reporting and AnalyticsHigh…supports filtering and segmentation of data.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-32Reporting and AnalyticsHigh…alerts GCSO personnel when participant re-enters GCSO custody.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-33Reporting and AnalyticsHigh…alerts GCSO personnel to participant not meeting program requirements.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-34Reporting and AnalyticsHigh...supports centralized document management.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-35Reporting and AnalyticsHigh…supports post release platform adoption tracking (usage metrics).Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-36Reporting and AnalyticsHigh…allows for program completion tracking.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-37Reporting and AnalyticsHigh…allows for report export in CSV, Excel, Microsoft Word, and PDF format.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-38Compliance and AccountabilityLow…provides for stakeholder satisfaction surveys.Select from drop down listSelect from drop down listSelect from drop down list0000000000001
BR-39Compliance and AccountabilityHigh…maintain pre release and post release audit trails of activity associated with participant case file.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-40Compliance and AccountabilityHigh…allows for the retrieval of audit trails associated with participant case file.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-41Compliance and AccountabilityHigh…allows for the retrieval of all documentation associated with participant case file.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-42Compliance and AccountabilityHigh…allows for the retrevial of all communications associated with participant case file.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-43Compliance and AccountabilityHigh…is CJIS CompliantSelect from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-44Compliance and AccountabilityMedium…maintains version control of documents.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
BR-45User ExperienceHigh…provides a mobile friendly, intutive platform for program participantsSelect from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-46User ExperienceHigh…reduces administrative burden for GCSO personnel.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-47User ExperienceMedium…provides participants with an easy to read format that provides clear program expectations, schedules, and version of their invididual plan.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
BR-48User ExperienceMedium….supports automated data imports/exports to reduce manual entry.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
BR-49User ExperienceMedium…suports batch data imports/exports.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
BR-50User ExperienceHigh….provides training for participants, GCSO personnel, and stakeholders.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-51User ExperienceHigh…supports offline data entry with ability to sync data at a later time.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-52Administrative RolesHigh…allows administrators to manage access, user roles, and permissions.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-53Administrative RolesHigh…allows administrators to configure workflows, forms, and program catalogs.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
BR-54Administrative RolesMedium…track GCSO performance and caseload.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
Totals000000000000252

&F &A

&D &A Page &P

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