Exhibit B _ JMS Technical Requirements.xlsx

XLSX spreadsheet 719 KB Posted

Attached to
RFP #26-24 Integrated Justice Information and Management System Modernization
Solicitation number
PE-63100-NONST-2026-000000096
Issued by
Clayton County, Georgia

About this file

This is a Technical Requirements Compliance Matrix for Clayton County, Georgia's Jail Management Solution (JMS) modernization project, establishing comprehensive technical and functional specifications that qualified vendors must meet or address. The document outlines over 150 detailed technical requirements organized into 25 categories including accessibility, auditability, backup and recovery, configuration, content management, data exchanges, security, reporting capabilities, user authentication, and user experience. Vendors must respond to each requirement using standardized response codes (Y for existing functionality, N for unable to meet, T for third-party software, C for customization required, or I for interface) and provide mandatory explanations for any N or C responses. The solution must support a jail population of approximately 1,790 inmates with annual admissions of 19,000 and discharges of 19,100, accommodate 315 concurrent users across three shifts (130 users during 0700-1500, 120 during 1500-2300, and 65 during 2300-0700), maintain 99.90% availability with maximum downtime of approximately 8 hours 45 minutes annually, and process significant transaction volumes including 21,232-21,244 intake and discharge transactions and 71,648 movements annually.

The proposed JMS solution must integrate with approximately 38 existing legacy and modern systems including GCIC, CPU8, RMS (Central Square), Keefe commissary, Eagle Biometrics, VINES victim notification, Kronos time and attendance, and numerous court and justice partner systems through defined data exchange mechanisms such as SFTP, web services, HL7 messages, ODBC connections, and RESTful APIs. The solution must comply with Section 508 accessibility standards, HIPAA regulations, FBI CJIS Security Policy, and American Correctional Association standards, support 256-bit encryption for data in transit and at rest using FIPS 140-2 certified methods, and maintain comprehensive audit trails with real-time monitoring capabilities. Data migration requirements include converting approximately 45 years of historical records across multiple domains (343,504 offender records, 4.17 million classification records, 1.53 million movements, and 1.08 million visitation records), with the solution requiring both desktop and mobile functionality across Windows 10, iOS, Android, and Keefe kiosk platforms. The document specifies detailed requirements for reporting, dashboards, user interface design, role-based security, multi-factor authentication, and administrative capabilities to enable Clayton County to maintain and support the system without continuous vendor assistance.

View the file

Other files

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

Instructions Jail Management Solution

TECHNICAL REQUIREMENTS COMPLIANCE MATRIX
For each Technical Requirement in this document, the Applicant must address each of the listed requirements by providing one of the response choices in the “Response Code” column.

The Applicant is further encouraged to provide comments, clarification, or references to other areas of the proposal which provide additional details related to the requirement. Applicants should NOT rely on references to documents that are not included in the proposal in their response, including URL links to information on the Internet.

Responses in the Response Code column are limited to the choices below. Entry of an incorrect Response Code will be considered an ‘X’; if Applicant enters multiple Response Codes for one requirement the City may assign a code of its own choosing.

Response CodeDescription
YYes – The requirement can be met with Existing Functionality out-of-the-box or through simple configuration (not customization / custom code).
Existing Functionality means that this capability exists, is being used in-production elsewhere and can be demonstrated. The requirement may also be met by leveraging standard County tools such as Active Directory and SQL. This response code includes interfaces that are part of the base product available out-of-the-box.
NNo – The requirement cannot be met.
TThird Party Software – The requirement can be met with a third-party software product provided by Applicant, including any work to incorporate the Third-Party Software to work with the Applicant’s software.
CCustomization or Modification – The requirement will be met by making programmatic (software development) changes to existing software, or developing new software.
IInterface – Refers to building an interface to the applications listed in this list of requirements.
Where ‘C’ is the response, the required customization must be fully described, and any additional cost to the County identified.

Where ‘N’ is the response, a full description of all features that the software will not provide and all respects in which it will not satisfy the requirement must be provided. These further explanations are to be provided in text sections identified by entering a reference number in the last column of the spreadsheet, with a separate reference number to the additional text for each requirement.

JMS Technical Reqs

Technical Requirements
Note: Please refer to the Worksheet "Reference Information" for operational and technical volumes, KPIs, metrics and other data associated with the requirements.APPLICANT RESPONSES
CategoryReq #Requirement TextResponse Code
(Y, N, T, C, I)Applicant Notes

(Mandatory for responses N and C)

AccessibilityNF-AC-01The JMS Solution shall comply with Section 508 (b) of the Rehabilitation Act of 1973, as amended 29 USC § 794 (d). § 794d pertaining to visually or hearing impaired employees.
AuditabilityNF-AU- 01The JMS Solution shall provide an Audit Trail capability that enables the to capture and store information on records and at the field level that have been created within JMS, such as but not limited to:

- Create / Insert

- Edit / Modify

- Delete

- Logon

- Logoff

- Save

- Update

- Open / View

- Login Successful

- Login Failure

- Password Change

- Password Change Failure

- Device / Terminal ID (or location)

AuditabilityNF-AU- 02The JMS Solution shall provide the capability to export, archive, purge and overwrite event logs.
AuditabilityNF-AU- 04The JMS Solution shall provide the capability to provide System Admin Alerts or Notifications for logged events (including associated emails and texts if available in the solution).
AuditabilityNF-AU- 05The JMS Solution shall protect the audit log information from tampering or unauthorized access.
AuditabilityNF-AU- 06The JMS Solution shall have the ability to backup and restore the audit log to/from archival storage.
AuditabilityNF-AU- 07The JMS Solution shall provide the capability to support notifications based on user-defined event triggers (example: Notification to Security Officer for unauthorized User ID access attempts exceed a predefined number of attempts).
AuditabilityNF-AU- 08The JMS Solution shall provide the ability to track transaction response times.
AuditabilityNF-AU- 09The JMS Solution shall maintain an audit log record for the data exchange activities to support the accountability, reconstruction of events and problem identification.
AuditabilityNF-AU-03The JMS Solution shall provide the capability to export events logs in real-time via the tool SysLog.
AuditabilityNF-AU-10The JMS Solution shall record the following attributes for each data exchange activity to provide the current status of a transaction: Transaction type, Date / Time, Status, Source system of data exchange.
AuditabilityNF-AU-11The JMS Solution shall enable the System Administrator with the ability to independently select and review the actions of any one or more JMS Users (including privileged users and based on individual user identity) with the objective of reconstructing a User's actions for investigative purposes.
AuditabilityNF-AU-12The JMS Solution shall enable the to search on Inmate Records using a set of search criteria / attributes (Desired search attributes included but are not limited to: Inmate PID#, User Name, Housing Location down to block / cell number, Inmate date of birth, inmate name, inmate alias, specific dates and times).
AuditabilityNF-AU-13The JMS shall enable the to view the Audit Trail associated with each Inmate’s record(s), such as but not limited to data entered, data changed or deleted with user ID and date/time stamps.
Back-Up and RecoveryNF-SLA-RT-06The JMS Solution shall be able to perform back-ups without creating any service disruptions to the end users (within impacting system availability).
Back-Up and RecoveryNF-SLA-RT-07The JMS Solution shall be able to perform back-ups without creating any service disruptions to the end users (within impacting system performance).
Back-Up and RecoveryNF-SLA-RT-07The JMS Solution architecture shall enable the monitoring and control of system resources. The solution must report application errors, resource limitations through suitable system management abstractions so that standards-based systems management tools can effectively monitor and manage JMS.
Back-Up and RecoveryNF-SLA-RT-08The JMS Solution shall have adequate redundancy to allow the to perform pre-identified critical business continuity applications in the event of failure of any component of the infrastructure.
Back-Up and RecoveryNF-SLA-RT-09The JMS Solution shall allow for maintenance and support performance activities (such as "Hot" backup procedures) to be carried out while the application and supporting systems are on line.
Back-Up and RecoveryNF-SLA-RT-10The JMS Solution shall limit the loss of un-saved data in the event of a system problem where the JMS application (or a specific screen or function) crashes or fails.
Concurrent UsersNF-SLA-RT-09The Solution shall accommodate each of the estimated User counts in Table 5: Concurrent Users above while maintaining required operational performance levels.
ConfigurationNF-CNF-01The JMS Solution shall be capable of allowing the JMS System Administrator to configure elements, such as tables, lists or pull-down menu fields, via a GUI based configuration tool. Examples of such data includes, but is not limited to: Offender programs, facility codes, cell codes / designations, locations, Rosters, Gangs, Priority lists for movement, Offenses, class levels, billing rates.
ConfigurationNF-CNF-02The JMS Solution shall be capable of allowing the JMS System Administrator to add new fields to the user interface, via a GUI based configuration tool.
ConfigurationNF-CNF-03The JMS Solution shall provide the JMS System Administrator with the ability to configure the titles (names) of data fields on the user interface to titles that the Department commonly uses, via a GUI based configuration tool.
ConfigurationNF-CNF-04The JMS Solution shall provide the JMS System Administrator the ability to add new specific data fields to the user interface, via a GUI based configuration tool.
ConfigurationNF-CNF-05The JMS Solution shall provide the JMS System Administrator with the ability to configure system notifications to appropriate users, via a GUI based configuration tool.
ConfigurationNF-CNF-06The JMS Solution shall provide a Workflow Utility that allows the JMS System Administrator to adjust / augment approval workflow within the appplication for without vendor assistance, via a GUI based configuration tool.
ConfigurationNF-CNF-07The JMS Solution shall provide the JMS System Administrator the ability to configure the JMS by hiding unwanted/unused fields so they are not presented to the Users, via a GUI based configuration tool. The therefore also need to be able to reveal (“unhide”) any fields previously hidden / unwanted.
ConfigurationNF-CNF-08The JMS Solution shall provide the JMS System Administrator the ability to customize and add new Data Input Screens (e.g., for a new Form), via an administrative user GUI tool.
ConfigurationNF-CNF-09The Solution shall allow authorized Department staff to easily add new user configurable forms and workflows in any area in the system that will support complex multi-step processes with multiple participants and, where appropriate, approvers
ConfigurationNF-CNF-10The Solution shall have the capability to assign, track, and maintain, through configurable business rules, the types and statuses needed to manage for the jail: unit/facility types, intake status, inmate custody, classification status, health status, housing assignment, disciplinary, job/program assignment, release review
Content ManagementNF-CM-1The Solution shall associate the attachments to an inmate and for the appropriate logical unit within the inmate, party or case record as appropriate (for example - signed property sheet document shall be associated with the property screen for that inmate). The attachment shall be readily retrievable and available by the user when accessing the inmate, party or case record.
Content ManagementNF-CM-2The Solution shall have the ability to store, index and retrieve attachment files.
Content ManagementNF-CM-3The Solution shall be able to perform electronic document management associated with Client/IP.
Content ManagementNF-CM-4The Solution shall provide the capability to upload and download media attachments (e.g., photos, videos) and PDF files, as required.
Data DictionaryNF-DD-01The JMS Solution shall include a searchable, comprehensive data dictionary covering all data elements in all databases supporting the Solution.
Data DictionaryNF-DD-02The JMS Solution shall include documentation of the database schema including entity relationship diagrams (ERDs) or data structure diagrams (DSDs); descriptions of the specific data elements that belong to each data structure; and a description of each data structure and the relationship to other data structures.
Data DictionaryNF-DD-03The JMS Solution shall have the capability to have the data dictionary updated, either manually or automatically, as changes occur in the Solutions database schemas or structure.
Data ExchangesNF-DE-1The Solution shall have the ability to provide a historical log of all transactions with external interfaces.
Data ExchangesNF-DE-2The soution will have the ability to integrate with a Data Integration Hub and support the exchange of information, such as custody status, housing location, current location in near real time.
Data ExchangesNF-DE-3The Solution shall have the ability to interface real time with justice partners to exchange release offender's custody and medical data.
Data ExchangesNF-DE-4The Solution shall provide the ability to setup new data exchanges with external agency partners maintaining proper security protocols and encryption standards.
Data ExchangesNF-DE-5The provider will identify any applications in Table 9 for which there is a defined or leverageable integration message. Please specify whether there is a defined exchange, what the content and pattern of the message(s) is.
Data Import and ExportNF-DA-01The JMS Solution shall support the ability to import and export data using:

• Delimited files (e.g., CSV, tab delimited)

• Fixed length files

• Excel files

• JSON files

• Shapefile

• File Geodatabase

• GeoJSON files

• Layer files

• GeoTIFF

• JPEG2000

• MrSID Preference is for a standard definable schema, such as ASCII.

Data Import and ExportNF-DA-02The JMS Solution shall allow to export JMS to the Data Warehouse and to stay in sync with it (in real time or near-real time).
Data Import and ExportNF-DA-03Should a Cloud Solution be proposed, the JMS Solution provides with the ability to retrieve all JMS data, as needed:
-Data retrieved will go back to Day 1 (all data from the first day the system is implemented)
-Data retrieved will be structured data, meaningful and ‘useable’
Data Import and ExportNF-DA-05The JMS Solution shall support data replication to a datamart server that will be utilized for data analytics, trend reports, tracking performance metrics and performance indicators, enable automated generation of reports.
Data Import and ExportNF-DA-06The JMS Solution shall provide real-time or near real-time synchronization of data between the production database and the reporting database. This should meet the same security levels identified in the Technical Requirements.
Data Import and ExportNF-DA-07The JMS Solution shall be ODBC Compliant.
Data Import and ExportNF-DA-08The JMS Solution shall integrate with Microsoft SSRS for Ad-Hoc Reporting.
Data Import and ExportNF-DA-09The JMS Solution shall support the system's data retention requirements . Specifically, JMS data should be available live / online for 10 years, but accessible forever in archived or offline storage.
Data MigrationNF-DM-1The providor will define and support the migration of data as defined in Table 9. The providor will provide detail on the methodology for migration, tools that will be leveraged and responsibilites of the County and the providor.
Design Constraints and EnvironmentNF-DC-01The JMS Solution shall support the use of data exchanges which conform to standards defined in the National Information Exchange Model (NIEM), HL7, Information Exchange Package Document (IEPDs) including NIBRS, N-DEx, APCO, and NCSC, and the Global Reference Architecture (GRA), and LEXS for inter-system communication.
Design Constraints and EnvironmentNF-DC-02The JMS Solution shall support interfaces using the exchange types and mechanisms described in Table 7 (See Reference Information Worksheet).
Design Constraints and EnvironmentNF-DC-03The JMS Solution's Application Program Interface (API) shall be fully documented with required and optional parameters, triggering event, return types, and error or exception return types.
Design Constraints and EnvironmentNF-DC-04The JMS Solution documentation shall identify the prerequisite software that is needed or recommended in order to create interfaces which utilize the provided API.
Design Constraints and EnvironmentNF-DC-05The database management system on which the JMS Solution relies must provide durability, ensuring that once a transaction has been committed it will remain so, even in the event of hardware failure, power loss, crashes, or errors (i.e.; transactions must be recorded in non-volatile memory).
Design Constraints and EnvironmentNF-DC-06The JMS Solution shall utilize Network Time Protocol (NTP) to synchronize time throughout all System components.
Design Constraints and EnvironmentNF-DC-07The JMS Solution shall enable to perform quality assurance processes such as stress testing, system testing, regression testing.
Design Constraints and EnvironmentNF-DC-08The JMS Solution shall provide a unique identifier for each Inmate that is associated with each JMS capability, function or record the Inmate is associated with. The unique identifier is referred to as the LE number. By default, the LE is a 7-digit number generated. If no LE is provided, a unique Inmate ID must be provided for the Inmate by JMS. (Note: the PID is often referred to casually in other contexts as the PPN, Inmate#, Inmate ID or Photo#).
Design Constraints and EnvironmentNF-DC-09The JMS Solution shall support a unique identifier referred to as the LE or "LE" that numeric. (Note: The current LE provided by the that uses as the unique Inmate identifier uses numbers only and is not alpha-numeric)
Design Constraints and EnvironmentNF-DC-10The JMS Solution shall provide a unique identifier referred to as the Prisoner Identifier or "PID" that is presented to a User within the user interface, as associated with any Inmate record.
Design Constraints and EnvironmentNF-DC-11The Solution shall support multiple, distinct environments, including but not limited to: Development, Staging, Testing, Training, Production. Please specify varied environments supported (for example – production, staging, ad hoc reporting, training, acceptance testing, maintenance (initial deployment), documentation of environment refresh from other environments in a repeatable, operation capacity
Devices and InputsNF-DV-01The JMS Solution shall operate on the Desktop environment, as described in Table 8 (See Reference Information Worksheet).
Devices and InputsNF-DV-02The JMS Solution shall operate on the Mobile environment(s), as described in Table 8 (See Reference Information Worksheet).
Devices and InputsNF-DV-03The JMS Solution shall be capable of using Internet Explorer 11 or greater, Microsoft Edge, Chrome and Firefox.
Devices and InputsNF-DV-04The JMS Solution shall support application extensions that use bar codes / RFID technology to track Inmate and documents and permit scanning and the use of bar codes to accomplish data entry. (This requirement includes the use of bar codes to inventory and manage offender personal property and match property to the offender).
Devices and InputsNF-DV-05The JMS Solution shall support other interaction modes / device types, for specific business functions, such as Kiosks.
Devices and InputsNF-DV-06The JMS Solution shall enable mobile devices (such as laptops or tablets/smart phones) to operate in a limited capacity in the absence of a wireless network, such as through an “offline mode” or similar function that provides JMS functionality through local caching or equivalent capability. Upon reconnection to the network, a User’s session and data is synced with JMS.
Information SecurityNF-SE-IS-01The JMS Solution shall provide a mechanism to authenticate publisher and subscriber systems involved in a data exchange using multifactor authentication.
Information SecurityNF-SE-IS-02The JMS Solution shall include a catalog of the account roles that are provided for controlling access to database tables and stored procedures for querying, report execution, update, and administrative purpose (changing access).
Information SecurityNF-SE-IS-03The JMS Solution shall provide the capability to terminate the network connection associated with a communications session at the end of the session.
Information SecurityNF-SE-IS-04The JMS Solution shall provide the capability to terminate the network connection associated with a communications session after a Prisons Department specified time period of inactivity.
Information SecurityNF-SE-IS-05The JMS Solution shall be CJIS compliant, covering the sharing of specific kinds of information with external entities, systems and users. The proposed Solution should be able to enforce authorization checks to protect specific kinds of data as needed. This should also cover access to reports, etc.
JMS AvailabilityNF-SLA-RT-01The JMS Solution shall be designed to avoid single points of failure.
JMS AvailabilityNF-SLA-RT-02The JMS Solution shall be designed / architected to support requirements for Service Level Availability defined in Table 3, Operational Metrics in Table 4 and User Volumes in Table 5, above.
JMS AvailabilityNF-SLA-RT-03If the proposed JMS Solution (core or non-core components) must be down for planned maintenance, in spite of the preference for 24 x 7 uptime, the planned outage must fall within the window of 7:00 am - 10:00 am Eastern Standard and Daylight Time on Saturday or Sunday only.
JMS AvailabilityNF-SLA-RT-04The proposed JMS Solution shall be able to tolerate simple failures without disruption of service, application errors in some of the components and / services).
JMS AvailabilityNF-SLA-RT-05With the exception of planned infrastructure maintenance and system upgrades, the proposed JMS Solution must be operational, reliable, available and performant 24x7x365 for essential business processes and mission-critical business operations against the SLAs defined in NF-SLA-RT 3.1 – JMS Availability
JMS AvailabilityNF-SLA-RT-06The proposed JMS solution must be able to support overlaps of shifts during shift change with no drop in system performance or availability. (refer to User Volumes by Shift, Table 5).
Network ConnectionsNF-SLA-RT-08The JMS Solution shall accommodate the forecasted number of network connections in Table 4: Concurrent Network Connections above while maintaining required operational performance levels.
Operational ContinuityNF-SLA-RT-04The JMS Solution shall provide the ability to track Solution uptime by issuing log entries indicating Solution startup and shutdown times.
Operational ContinuityNF-SLA-RT-05The JMS Solution shall provide the ability to track Solution uptime and transaction response times for both pre-formatted and ad-hoc queries.
Operational ContinuityNF-SLA-RT-05The JMS Solution system may operate in a reduced capacity should a major issue occur (such as hardware failure within architecture). However, in such a scenario, no data will be lost or corrupted and the user can perform all system functionality, albeit with slower response times.
Operational Transaction VolumesNF-SLA-RT-10The Solution shall accommodate the transaction volumes in Table 8: Operational Transaction Volumes above and estimated transaction growth, while maintaining required operational performance levels.
Reporting CapabilitiesNF-RC-1The Solution shall provide the ability to perform, store, track, and report on: Add/modify table of charges
Reporting CapabilitiesNF-RC-10The Solution shall have the ability to maintain a list of user-defined fields available for a standardized report.
Reporting CapabilitiesNF-RC-11The Solution shall have the ability to provide option to save ad-hoc report criteria.
Reporting CapabilitiesNF-RC-12The Solution shall have the ability to provide parameter driven reporting capabilities to meet business needs.
Reporting CapabilitiesNF-RC-13The Solution shall provide comprehensive reporting with real-time metrics, and data. In addition, data analytics features shall be available to authorized users.
Reporting CapabilitiesNF-RC-14The Solution shall support flexible, ad-hoc queries without IT intervention.
Reporting CapabilitiesNF-RC-15The Solution shall support use of a Business Intelligence analytics tool for ad hoc queries, dashboards, and reports.
Reporting CapabilitiesNF-RC-2The Solution shall provide the ability to perform, store, track, and report on: Deletion of any information (e.g., Cases, Offender records, Discipline Reports, Incident reports, Client/IP photos).
Reporting CapabilitiesNF-RC-3The Solution shall provide the ability to perform, store, track, and report on any action that impacts critical data, requires an override or is a significant exception. Examples include expungements, Inmate or defendant record merge
Reporting CapabilitiesNF-RC-4The Solution must have the ability to pull data from multiple databases and/or from multiple areas within The Solution and combine all the information into a single report.
Reporting CapabilitiesNF-RC-5The Solution shall have a reporting environment that is separate from the operational database with the following characteristics:

• At minimum it should be a replicated environment

• Reports shall not compete for capacity with real-time business transactions

• Prevent users from causing The Solution to crash when developing a robust or complex report

Reporting CapabilitiesNF-RC-6The Solution shall have the ability for reports to be automatically generated on a scheduled basis and distributed on a periodic basis.
Reporting CapabilitiesNF-RC-7The Solution shall have the ability to distribute reports through various mediums such as email, downloaded to share drives, intranet, internet.
Reporting CapabilitiesNF-RC-8The Solution shall have the ability to generate reports from a data snapshot.
Reporting CapabilitiesNF-RC-9The Solution shall have the ability to generate various reports with multiple parameters.
SecurityNF-SE-CS-01The JMS Solution shall support a group / role-based security model.
SecurityNF-SE-CS-02The JMS security system shall enable the JMS System Administrator to establish an number of user permission groups / roles.
SecurityNF-SE-CS-03The JMS Solution shall provide the capability for specific authorized users to ‘lock down’ (restrict, hide) individual JMS records for security purposes, at the discretion of .
SecurityNF-SE-CS-04The JMS security system shall provide module-level security.
SecurityNF-SE-CS-05The JMS Solution shall provide, Authentication, and Authorization, and Accounting capabilities throughout the Solution using Active Directory.
SecurityNF-SE-CS-06The JMS Solution shall comply with HIPAA standards upon implementation and throughout the performance of this contract by applying and/or recommending changes and enhancements to the Solution, as necessary.
SecurityNF-SE-CS-07The JMS Solution shall comply with the FBI CJIS Security Policy and state statutes and regulations upon implementation and throughout the performance of this contract by applying and/or recommending changes and enhancements to the Solution, as necessary.
SecurityNF-SE-CS-08The JMS Solution shall support, at a minimum, 256-bit encryption of data in use by the Solution. (Supports FIPS 140-2 certified FIPS 197 AES encryption methods)
SecurityNF-SE-CS-09The JMS Solution database shall be configurable to provide, at a minimum, 256-bit encryption of data at rest within the database. (Supports FIPS 140-2 certified FIPS 197 AES encryption methods)
SecurityNF-SE-CS-10The JMS Solution shall provide the ability to generate reports listing the roles or groups who have been granted access rights to available functions.
SecurityNF-SE-CS-11The JMS Solution shall provide the capability to restrict the use of maintenance tools to authorized personnel only.
SecurityNF-SE-CS-12The JMS Solution shall support the American Correctional Association Accreditation Standards, applicable state statutes and regulations
SecurityNF-SE-CS-13The Solution shall support field level masking and provide a means to configure fields that need masking. Example: only last few digits of SSN shall be displayed in UI but other digits are masked.
SecurityNF-SE-CS-14The Solution shall have ability to flag any records as restricted; thereby, limiting user access.
SecurityNF-SE-CS-15The Solution shall have the ability to support multi-factor authentication for off-site access.
Security Alerts and ReportingNF-SE-AR-01The JMS Solution shall have the ability to produce a report documenting all security related events in the system by selectable duration (shift, day, month, etc.)
Security Alerts and ReportingNF-SE-AR-02The JMS Solution shall have the ability to notify the appropriate personnel if a security breach is detected.
Security Alerts and ReportingNF-SE-AR-03The JMS Solution must have audit logging capabilities. At a minimum, the logs should be able to determine the identity of the users, the date / time of the interaction, details about the actions performed by users, IP address, Computer name and status of the interaction (success / failure).
Security Alerts and ReportingNF-SE-AR-04The Solution must have the capability to enable authorized users to view the security logs for investigative and other purposes.
Security Alerts and ReportingNF-SE-AR-05The JMS Solution must have the capability to enable authorized users to view the name of the user that created the record and any / all users who may have subsequently updated the record.
Security Alerts and ReportingNF-SE-AR-06The JMS Solution will report failed identification / authorization checks to the system logs, including notifications.
Security Alerts and ReportingNF-SE-AR-07The JMS Solution wil. report failed attempts to access unauthorized data to the system logs, including notifications.
SupportabilityNF-SU-01The JMS Solution shall provide ‘self-service’ support capabilities, giving the end users the ability to perform actions such as, but not limited to Submitting of Trouble tickets / Support requests
SupportabilityNF-SU-02The Proposer shall provide JMS application installation procedures for the JMS Solution, so that can maintain the system without always needing direct vendor support.
SupportabilityNF-SU-03The Applicant shall specify and provide the architectural design that is to be employed for the JMS Solution, so that can maintain the system without direct vendor support.
SupportabilityNF-SU-04The Applicant shall provide documentation defining the functionality of modules that comprise the Solution that are available for assignment of access rights by role or group. This shall include, but is not limited to: capabilities for creating accounts, updating accounts, deleting accounts, querying records, and changing administrative access.
SupportabilityNF-SU-05The JMS Solution shall provide the ability to generate reports listing the roles or groups who have been granted access rights to available functions.
SupportabilityNF-SU-06The JMS Solution shall provide the capability to restrict the use of maintenance tools to authorized personnel only.
SupportabilityNF-SU-07The JMS Solution shall support defined roles, processes, and responsibilities for views, data marts, and extracts.
SupportabilityNF-SU-08The JMS Solution shall provide user help documentation (soft-copy format, such as PDFs).
SupportabilityNF-SU-09The JMS Solution shall provide the capability to create, administer and modify help scripts and any online manuals / documentation provided.
SupportabilityNF-SU-10The JMS Solution shall provide context-sensitive user help documentation (on-line/web-based help resources).
SupportabilityNF-SU-11The JMS Solution shall provide useful prompts or tool tips when the user ‘hovers over’ certain features, controls and commands around the user interface.
SupportabilityNF-SU-12The JMS Solution shall provide the ability to link to a policy or other process / document that governs specific business functions associated with JMS modules or functionality within the system. This may reside in another system that currently utilizes or within the JMS Solution itself.
SupportabilityNF-SU-13The JMS Solution shall provide the System Administrator to perform certain management operations based on policies and procedures, such as but not limited to:

1. Merge 2 inmates (Based on Policies & Procedures)

2. Merge 2 visitors (Based on Policies and Procedures)

3. Expunge case, admission, or release

4. Delete a case, admission, or release

5. Reverse an Inmate discharge

6. Delete Reports such as an Inmate Misconduct

7. Charge Maintenance Fee for released inmates

SupportabilityNF-SU-14The JMS Solution shall provide with the ability to perform secure remote administration, as well as on-site administration. Example operations include, but are not limited to:
1.User account and password management
2.System security management
3.System log review and maintenance
4.System monitoring and generating system reports
5.Notification management
6.Software threshold parameter management
7.System and database backup initiation
8.Transaction management / pushes to external systems as needed
SupportabilityNF-SU-15The JMS Solution shall maintain an Audit Trail of all changes made to the System’s components. This includes a centralized repository for any / all error messages. This repository must be accessible and exportable by the System Administrator.
SupportabilityNF-SU-16The JMS Solution shall ensure that system error and events for software, hardware, interfaces, operating system, and network are written to a system event log accessible and searchable by a system administrator.
SupportabilityNF-SU-17The JMS Solution shall have formal, documented, release management procedures for the release and distribution of all releases, upgrades, patches and the withdrawal or retirement of each.
SupportabilityNF-SU-18The JMS Solution shall provide formal, documented, procedures to restart system components.
SupportabilityNF-SU-19The JMS Solution shall provide formal, documented, procedures to recover / restore incomplete transactions that are in appropriate states.
SupportabilityNF-SU-20The JMS Solution shall immediately notify the System Administrator when definable thresholds are exceeded, and, if the occurrence or accumulation of these relevant events continues, the system must take the least disruptive action to terminate the event.
SupportabilityNF-SU-21The JMS Solution shall be compatible with standard enterprise system monitoring tools. (Specifically Networking, Servers, Applications monitoring tools). The Vendor is requsted to describe which tools are supported.
Systems InterfacesNF-IF-01The JMS Solution shall provide an integration layer that allows any third party vendors’ systems the ability to integrate.
Systems InterfacesNF-IF-02The JMS Solution shall provide the required API’s to be published to a discoverable library.

Examples of these applications include, but not limited to, MBIS machines, Iris Scans for authentication and RFID, Bar coding for movement tracking. It should be noted that some 3rd party applications might require specific plug-ins to be built and configured in the Solution in order to integrate, however, the proposed Solution must permit this at the integration layer.

Systems InterfacesNF-IF-03The JMS Solution shall have the ability to integrate with other providers that are normally utilized in a Jail setting. Examples of these are commissary service systems, food service systems, payment systems, health care systems, banking systems (see complete list of interfaces in Table 9).
Systems InterfacesNF-IF-04The JMS Solution shall support the use of data exchanges which conform to standards defined in the National Information Exchange Model (NIEM), HL7, Information Exchange Package Document (IEPDs) including NIBRS, N-DEx, APCO, and NCSC, and the Global Reference Architecture (GRA), and LEXS for inter-system communication.
Systems InterfacesNF-IF-05The JMS Solution’s integration layer shall support the publishing of notifications when certain, pre-identified, events occur (such as processing the admission of an Inmate). These interactions should be permitted without exposing the product’s database to external systems.
Systems InterfacesNF-IF-06The product should support the expected interfaces standards described in Table 7 (See Reference Information).
Systems InterfacesNF-IF-07The JMS Solution shall archive the sending, receiving and logging of each transaction through all interfaces. This must be searchable and include reporting capabilities by inmate, transaction type, date range, facility, housing locations and various other statistics for trend analysis.
Systems InterfacesNF-IF-08The JMS Solution shall log interface transactions (categorized by status, such as but not limited to: Sent, Received, Failed etc. with reasons) and provide the Systems Administrator with a meaningful view of the transaction history.
User AuthenticationNF-SE-UA-01The JMS security system shall provide User Authentication capabilities through Microsoft Active Directory.
User AuthenticationNF-SE-UA-02The Solution must be compliant the organization ITP (IT Policy) with for user authorization, including the use of two-factor authentication.
User AuthenticationNF-SE-UA-03The JMS Solution will provide the ability to search on and retrieve a list of User Session Durations.
User AuthenticationNF-SE-UA-04The JMS Solution will provide the System Administrator with the ability to terminate a User Session (e.g. if user sessions are open for an extraordinary duration, or other reason).
User AuthenticationNF-SE-UA-05The JMS Solution shall ensure that Users are only allowed to have one (1) active session by default. Users wih elevated privileges can have a maximum of three (3) active sessions.
User AuthenticationNF-SE-UA-06The JMS Solution will enable to System Administrator with the ability to create / modify / remove access for authorized External Users to a limited, read-only, access to a subset of data within the JMS (to be determined during the JMS Implementation).
User ExperienceNF-UX-01The JMS Solution shall provide the ability to enable the users to navigate through the system with a minimum number of clicks.
User ExperienceNF-UX-02The JMS Solution shall provide the ability to enable users to retrieve information very easily without having to go through multiple screens.
User ExperienceNF-UX-03The JMS Solution shall provide basic word processing functionality, including word wrap, spell check, and font control, for the entry and manipulation of text data.
User ExperienceNF-UX-04All data entered into JMS should be included in the JMS Audit Trail, with timestamps of who created and updated the data.
User ExperienceNF-UX-05All data entered into JMS must be searchable, printable and reportable.
User ExperienceNF-UX-06The JMS Solution shall minimize data entry efforts by:
-Providing default values for fields based on previous input, referential lookup or other mechanisms
-Providing lookup tables for the values for fields
-Ordering values by most frequently entered
User ExperienceNF-UX-07The JMS Solution shall support the auto-filling of date/time entry fields but allow for manual date changes.
User ExperienceNF-UX-08The JMS Solution shall have the ability to display a calendar to select from to populate the date fields.
User ExperienceNF-UX-09The JMS Solution shall provide the ability to enter a date by using shortcuts but also allow for manual overrides.
User ExperienceNF-UX-10The JMS Solution shall provide data quality editing, consistency and validity checks on data elements at the point of data entry. The proposed Solution must display a meaningful error message, and prevent entry of data that does not pass edit checks.
User ExperienceNF-UX-11The JMS Solution shall provide a logical sequence of screens and fields enabling users to quickly access, modify, skip or jump to other areas of interest for data entry based on specific workflow developed during the JMS Implementation.
User ExperienceNF-UX-12The JMS solution shall provide a chevron type display, or another form of in-app navigation, so a user knows where they are within the application and/or within a workflow i.e. Intake, Discharge, etc.
User ExperienceNF-UX-13The JMS will provide authorized External Users with read-only access, via a Portal or other proposed solution, to a limited subset of JMS data, to be determined with the Applicant during the JMS implemtation.
User ExperienceNF-UX-14The Solution shall have the ability to support a browser-agnostic based interface.
User ExperienceNF-UX-15The Solution must be compatible with and support Microsoft® Edge, Google Chrome, Apple Safari browsers. The Solution shall maintain compatibility with the three most current versions of each browser and provide data over a web browser interface for example.
User ExperienceNF-UX-16The Solution shall allow creating Dashboards with drilldown capabilities for data analysis, along with the ability to distribute Dashboards and reports to selected users.
User ExperienceNF-UX-17The Solution shall be able to display a synthesis of information based on parameters set by staff. This includes being able to request information from different areas of an Inmate’s totality of information available and having it displayed for staff on a user-friendly dashboard.
User ExperienceNF-UX-18The Solution shall have the ability to provide summary information as well as the ability to drill down to the details associated with the summary information.
User ExperienceNF-UX-19Context-Sensitivity: The Solution shall provide the capability to dynamically display menus, pages, data fields and functionality based on the security access and roles defined of the user.
User ExperienceNF-UX-20Multiple Windows: The Solution shall provide the capability to view multiple windows at a time while maintaining data and session integrity.
User ExperienceNF-UX-21The Solution user interface shall provide help features based on process and context.
User ExperienceNF-UX-22The Solution shall support a common user interface "look and feel" across the entire application.
User ExperienceNF-UX-23The Solution shall support standard data validation on all input fields including but not limited to data type validation, range validation, and format validation.
User ExperienceNF-UX-24The Solution user interface shall provide help features based on process and context.
User ExperienceNF-UX-25The Solution shall have the capability to allow multiple users to view records at the same time.

&P &"Calibri,Regular"&11&K000000&A

Reference Information

Reference Information
Applicants must complete the Technical Requirements Compliance Matrix (provided in the MS Excel file). The information provided below is relevant to a subset of those detailed technical requirements only.
NF-AV 3.0 – JMS Services level expectations
Availability relates to the time that the Solution is expected to be available for use by its users. It is the objective of the County that the proposed Solution be highly reliable and able to be configured to provide maximum uptime and availability to all systems and users that depend upon its services. These requirements allow for only a small amount of planned downtime related to installation of upgrades, patches, and bug fixes. Planned outages may be necessary for regular system maintenance, and a fail-over capability can be utilized during that time to maintain operations if feasible.
NF-SLA-RT 3.1 – JMS Availability
End user availability relates to the time that the system is expected to be available to the users. This requirement is inclusive of downtime due to both planned outages and failures. Planned outages will be necessary for regular system maintenance and a fail-over server may be utilized during that time to maintain operations.
Due to the nature of Jail Management business processes, the Solution’s components are anticipated to be used 24 hours x 7 days per week x 365 days per year.
Table 1: JMS Availability Requirements
%Availability Target SLAApprox. Downtime Per YearApprox. Downtime Per MonthApprox. Downtime Per Week
Jail Management System (Core JMS)99.90%8h 45m 57s43m 49.7s10m 4.8s
Third Party / Associated Solution Components (Non-Core JMS)99.90%8h 45m 57s43m 49.7s10m 4.8s
Interfaces (Web Services, Data Exchanges, etc.)99.90%8h 45m 57s43m 49.7s10m 4.8s
Table 2: Operational Metrics
MetricValue
Inmate Population1790
Annual Admissions19,000
Discharges19,100
Estimated Annual Growth Rate+1% - 2% p.a.
Table 3: User Volumes by Shift
Concurrent User Volumes by Shift
0700 – 1500 Concurrent Users130
1500 – 2300 Concurrent Users120
2300 – 0700 Concurrent Users65
External Users (e.g. Portal Access )N/A
Total Users315
NF-SLA-RT 4.0 – Capacity Limits
NF-SLA-RT 4.1 – Network Connections
Network Connections refers to the number of connections expected between internal/external County systems and the JMS Solution’s components. The network connections include the sub-systems handling message services and external data synchronization.
Table 4: Concurrent Network Connections
Est. Number of Concurrent Network ConnectionsMinMax
Number of estimated concurrent JMS network connections based on interfaces listed in Table 965130
NF-SLA-RT 4.2 – Concurrent Users
The table below identifies the number of individuals (regular users and administration) expected to utilize the Solution and it is sub-systems concurrently.
Table 5: Concurrent Users
User Roles# of Users
Normal Operations Maximum Users
Maximum Total Users315
Maximum Mobile Users315
Maximum Concurrent Users315
Maximum External Concurrent UsersN/A

Note: The maximum number of users is representative of what may happen in an emergency situation. This is intended to reflect performance needs not licensing needs.

NF-SLA-RT 4.3 – Operational Transaction Volumes
The table below identifies the historical operational transaction volumes.
Table 6: Transaction Volumes
DescriptionEstimated VolumeYear
- Intakes21,232/16,8532024/2025
- Discharges21,244/17,0592024/2025
- IncidentsxxxInvestigations2024
2,342 Inmate Violations
- Shake-Downs / Searches365 Shakedown events2024
xxx Beds Searched
- Shift Log Entries400 Lines est per day2024
- Movements71,6482024
- Inmate Transactions38,5192024
NF-DC 9.0 – Design Constraints & Environment
This section specifies the constraints imposed on the Solution by compliance to identified standards.
Table 7: Exchange Types / Mechanisms
Exchange TypeMechanism
Flat fileSFTP (Push / Pull)
Self-contained structure (JSON, RESP [ack])Web service (Push / Pull)
Message (e.g. HL7)TCP connection (Out / In)
ImagesSFTP (In)
SQLODBC (Push / Pull) – Encrytped
ReportSFTP (Push)
Restful APIsWeb Service (Push / Pull)
NF-DV 10.0 – Devices & Inputs
The Solution must comply with the following device standards and needs.
Table 8: XXX Supported Devices
Device CategoryDevice TypesPlatformDevice Volumes (Units Required)
DesktopWindows MachinesWindows 10 (Current / n-1)315
Tablet / SmartPhoneAppleiOSN/A
Android OS (Preferred)8N/A
KiosksKeefe KioskKeefe Proprietary5
InfrastructureServersWindows (Preferred)Dependent on Applicant's Proposed Solution
Linux
NF-IF 11.0 – System Interfaces
To achieve the functionality required by the JMS Solution, several interfaces to other systems are required. The Applicant shall work with the County and other system vendors to develop interfaces, the approach for which is described in the ‘Systems Interfaces’ within the Proposed Statement of Work in the Appendix.
The County expects the Applicant will work with County to determine the best method for exposing the listed interface (e.g., web service, existing API, file, etc.). Where available, The County is seeking a Data Integration Hub solution to handle most data exchanges. In some instances, there may be justfication for direct exchange of information between the proposed solution and specific solutions within the Jail ecosystem. The County wishes to understand interfaces the Applicant already includes in the base product or has already completed as part of a previous project. The Applicant and Clayton County will further refine the specifications for interfaces during the interface design phase of the project.
The current and planned JMS interfaces are listed
Table 9: System Interfaces
ApplicationDirectionFrequencyInterface TypeBusiness PurposeData ElementsRetire/Modify/IntegrateDIH Scope
PalatineOne Way OutboundIntegrate or RetirePhase 2
GCICOne Way OutboundIntegratePhase 2
CPU8 CourtsBi-DirectionalRetirePhase 2
CPU8 JuryNANA
CPU8 ComplaintsNANA
CPU8 Grand JuryNANA
RMS – Central SquareOne Way InboundIntegratePhase 4
TrackerNANA
JCATSNANA
KeefeBi-DirectionalIntegratePoint to Point
Tyler eFile GeorgiaNANA
ICSBi-DirectionalIntegratePoint to Point
EHRBi-DirectionalIntegratePoint to Point
Picture LinkBi-DirectionalIntegrate or RetirePoint to Point
BrazosOne Way InboundIntegratePhase 4
IRISPoint to Point
UtilityNANA
AxonNANA
JagwareOne Way OutboundIntegratePhase 2
In Court – CatalystNANA
AmerisNANA
QuickbooksNANA
MunisNANA
Eagle BiometricsBi-DirectionalIntegratePhase 2
VINESOne Way OutboundIntegratePhase 2
CourtViewNANA
CJT JusticeTechNANA
FytheNANA
ZAPsNANA
ImfaxNANA
ConnexisNANA
Tech FriendsBi-DirectionalIntegratePhase 4
KronosOne Way InboundIntegratePhase 4
OnPointBi-DirectionalIntegratePhase 4
NF-DM 12.0 - Data Migration
The county wishes to migrate and maintain data from the legacy solution in the following domains to support continued operations, processing of repeat offenders, and compliance with jail standards and auditing needs. The County wishes to convert 45 years (estimate) years of historical data.
Table 10: Data Migration
DomainTotal RecordsActiveReleased - On ProbationInactiveYears of History
Offender343,5041,67585,526341,751All (est. 45 yrs)
Classification4,172,49232,351931,4443,978,266All (est. 45 yrs)
Incidents120,917117,969X2,948All (est. 45 yrs)
Visitation1,085,7313,847X81,233All (est. 45 yrs)
Housing343,8641,674X341,752All (est. 45 yrs)
Movements1,532,851N/AXN/AAll (est. 45 yrs)
Sentence483,149N/AXN/AAll (est. 45 yrs)
ProgramsAllNot currently tracked in CPU8
inmate transactionsAllNot currently tracked in CPU8

Legacy Applications

Application NameDescription of UseCapabilitiesUnit(s)Retire/Modify/Integrate

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 .