Appendix_B-Revised_8-29-2025.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
Statewide Court CMS and eFiling Application - UPDATED
Solicitation number
RFP 30227-00725
Issued by
Davidson County, Tennessee

About this file

This is a data feeds and interfaces specification document prepared for the State of Tennessee's Administrative Office of the Courts (AOC) in support of a statewide Case Management System (CMS) and eFiling Application procurement. The document outlines 26 distinct data exchange mechanisms that the new CMS solution must integrate with various state agencies, local county offices, and internal court systems. These integrations include connections to the Tennessee Judicial Information System (TJIS), General Sessions Data Repository, Mental Health Monitoring System, Department of Correction cost reimbursement processing, Department of Revenue litigation tax reporting, Department of Safety e-cite and disposition reporting, Tennessee Bureau of Investigations final disposition and registry reporting, Sheriff's victim notification system (EVINE), and various local election offices. The data feeds operate at varying frequencies ranging from daily to yearly, with some interfaces requiring on-demand execution, and utilize multiple data formats including Fixed Length files, CSV, SQL, API, and JSON protocols. Integration complexity levels vary from simple to complex, with most interfaces classified as statewide in scope except for four locally-managed feeds related to county delinquent tax processing, eFiling, county audit exports, and local election reporting.

The specification document indicates that existing documentation is available for most data feeds, with several feeds already supporting automation while others currently rely on manual processes pending system modernization. Integration types include direct electronic file transfers, API connections, database backup and restoration, and web service implementations. Notable integrations requiring particular attention include the Mental Health Monitoring System, which operates nightly to prevent firearm purchases and remove handgun permits; the State Cost Reimbursement interface, which involves complex bidirectional processing of reimbursement calculations and receipt posting; and multiple registry reporting feeds for felony drug convictions, violent offender buccal swab disposals, animal abuse, and elder abuse incidents. The document notes that several manual reporting processes—including felony drug conviction registry, violent offender dispositions, animal abuse registry, elder abuse reporting, physician felony conviction reporting, and election-related disqualification reporting—currently lack automated agency accommodation and represent opportunities for system enhancement through the new CMS implementation.

View the file

Other files

File Type Posted
Appendix_D_Chart_of_Accounts.pdf PDF
RFP_30227-00725_Amd_6.pdf PDF
RFP_30227-00725_Amd_2.pdf PDF
Appendix_A_Use%20Cases.pdf PDF
RFP_Attachment_6.6-Revised_8-29-25.xlsx XLSX spreadsheet
Appendix_F%20-Legacy_CMS_List.xlsx XLSX spreadsheet
RFP_30227-00725_Amd_4.pdf PDF
RFP_30227-00725_Amd_6.pdf PDF
Appendix_E_-_Chart_of_TN_counties_pop_CMS_current.pdf PDF
RFP_30227-00725_CMS_and_eFiling_Application_FINAL.pdf PDF
RFP_30227-00725_Amd_2.pdf PDF
Appendix_D_Chart_of_Accounts.pdf PDF
Appendix_F%20-Legacy_CMS_List.xlsx XLSX spreadsheet
RFP_Attachment_6.6-Revised_8-29-25.xlsx XLSX spreadsheet
Appendix_E_-_Chart_of_TN_counties_pop_CMS_current.pdf PDF
RFP_30227-00725_CMS_and_eFiling_Application_FINAL.pdf PDF
RFP_30227-00725_Amd_4.pdf PDF
Appendix_D_Chart_of_Accounts.pdf PDF
Appendix_A_Use%20Cases.pdf PDF
Appendix_E_-_Chart_of_TN_counties_pop_CMS_current.pdf PDF
RFP_30227-00725_Amd_1.pdf PDF
RFP_30227-00725_Amd_3-FINAL_9_11_25.pdf PDF
RFP_30227-00725_Amd_4.pdf PDF
Appendix_B-Revised_8-29-2025.xlsx XLSX spreadsheet
Appendix_C.pdf PDF
Appendix_F%20-Legacy_CMS_List.xlsx XLSX spreadsheet
RFP_30227-00725_Amd_2.pdf PDF
Appendix_E_-_Chart_of_TN_counties_pop_CMS_current.pdf PDF
RFP_30227-00725_Amd_1.pdf PDF
RFP_30227-00725_Amd_3-FINAL_9_11_25.pdf PDF
RFP_30227-00725_CMS_and_eFiling_Application_FINAL.pdf PDF
RFP_Attachment_6.6-Revised_8-29-25.xlsx XLSX spreadsheet
Appendix_F%20-Legacy_CMS_List.xlsx XLSX spreadsheet
Attachment_6.3-Cost_Proposal_Scoring_Guide.xlsx XLSX spreadsheet
RFP_30227-00725_Amd_1.pdf PDF
Appendix_E_-_Chart_of_TN_counties_pop_CMS_current.pdf PDF
RFP_30227-00725_Amd_2.pdf PDF
RFP_30227-00725_CMS_and_eFiling_Application_FINAL.pdf PDF
Attachment_6.3-Cost_Proposal_Scoring_Guide.xlsx XLSX spreadsheet
RFP_30227-00725_Amd_1.pdf PDF
RFP_Attachment_6.6-Revised_8-29-25.xlsx XLSX spreadsheet
Appendix_A_Use%20Cases.pdf PDF
Appendix_D_Chart_of_Accounts.pdf PDF
Appendix_F%20-Legacy_CMS_List.xlsx XLSX spreadsheet
RFP_30227-00725_CMS_and_eFiling_Application_FINAL.pdf PDF
Appendix_A_Use%20Cases.pdf PDF
Appendix_D_Chart_of_Accounts.pdf PDF
Attachment_6.3-Cost_Proposal_Scoring_Guide.xlsx XLSX spreadsheet
RFP_Attachment_6.6-Requirements_Traceability_Matrix.xlsx XLSX spreadsheet
RFP_30227-00725_CMS_and_eFiling_Application_FINAL.pdf PDF
Show 40 more

50 files listed here. See the rest on GovTribe.

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

TN CMS Data Feeds and Interface

Tennessee CMS Data Feeds & Interfaces
#Data Feed/Interface TypeDescriptionData RecipientRelated StatuteTN Specific (Y/N)TnCIS Specific (Y/N)FrequencyFormatExisting Documentation (Y/N)Use Case RequiredIntegration type
1TN Judicial Information System (TJIS)Electronically sends files each month for civil filings, criminal charges, dispositions and expungements occurring throughout the monthAdministrative Office of the Courts16-1-117YNMonthlyFixed lengthYNModerate Statewide
2General Sessions Data RepositoryClerks send data monthly to provide a much more extensive set of case data for GS civil and criminal casesAdministrative Office of the Courts18-1-105YNMonthlySQL partial Database Backup & CSVYNComplex Statewide
3Mental Health Monitoring System (MHMS)Qualifying Judicial Hospitalizations and Conservatorships that is then forwarded to the federal NCIC (to prevent individual from purchasing a gun) and to DOS Handgun Unit (to remove and or deny any handgun permit)Administrative Office of the Courts16-1-117; 16-10-213YNNightlyCSVYNModerate Statewide
4County - Delinquent Tax ImportImports file generated by County Trustee of properties where real and property taxes are delinquent. This prevents clerks from having to manually enter all the parcel information manually. These are then either collected or placed into a Delinquent Tax sale.Case Management SystemNo statute but a required importNY1 time per yearFixed LengthOld user requirementNSimple Local
5County - Delinquent Tax ExportCreates a file for a clerk who has chosen to use a vendor for an online delinquent tax sale. The file is exported as part of TnCIS and the contract for the vendor is between the clerk and vendor.Online Delinquent Tax Sale VendorNo statuteNYAs neededFixed LengthOld user requirementNSimple Local
6State Cost ReimbursementTnCIS calculates monies based on DOC rules and creates forms for submission for qualifying cases to DOC. Clerks can remove fee to report the next time State Cost bill is pulled. Fees can be modified if state determines it will not pay. One check is receipted for all cases that the DOC is paying and a state cost reimbursement fee is posted back to each case/charge for the amount receipted. DOC requires the forms with backup information and sends the clerks a check back which is then automatically applied electronically to each case and creates a reimbursement line back to the state, so the defendant can reimburse advanced fees.Department of Correction40-25-131NYOn demand; when the clerk runs the reportYesYComplex Statewide -Note: Not an actual integration, but complex system processing to get data and be able to post money back into system.
7State Litigation Tax formData is submitted electronically directly from CMS to update their State Litigation Tax form which also includes payment due amount so DOR can draft payment from clerk's bank account.Department of Revenue67-4-603YNMonthlyAPIYYComplex Statewide
8DOS e-CiteDepartment of Safety electronically downloads ticket information and creates cases within TnCIS which alleviates the need for clerks to add cases manually and also places an image of the ticket to the case for easy accessCase Management SystemN/ANY (Quest does this as well)DailyAPI/JSONYes, we have the TITAN Disposition Web Service documentationNComplex Statewide
9DOS Disposition reportingSends disposition data electronically to DOS, upon clerk running interface, so they can upload to their database case historiesDepartment of Safety55-10-306; 55-50-502(j)YNVaries (Daily or Monthly)Fixed lengthYYComplex Statewide
10Failure to Pay court costBased on case payment plans and payments received for both traffic and criminal cases; notifies DOS for suspension and withdrawal of Driver's LicenseDepartment of Safety40-24-105(b)(1)YNat least once week/statute require reporting with 5 daysFixed lengthYNComplex Statewide
11Jury Master ImportTnCIS imports the file created from DOS Driver records to create/update/maintain the master list.Case Management SystemN/ANYOn demand; when the clerk runs the importCSVOld specs - needs to be updated. Reached out to the TNDOS to get a copy of the file record layout they provide for the TnCIS Jury import.NSimple Statewide
12Electronic FilingData is entered by attorneys and sent from the E-Filing software to the CMS for the creation of casesCase Management SystemYNDailyAPISome user and technical documentationNSimple Local
13County Audit ExportCreates an End of Year audit file so county audit can export from TnCIS and import onto their laptop so they can do a majority of their audit remotely.State Comptroller’s OfficeNo statute but a required exportNYYearlyFixed lengthSome user documentationNModerate Statewide
14EVINESubmits nightly data to the Sheriff's system for victim notificationSheriff's EVINE System40-38-507YNNightlyJSONYNModerate Statewide
15TCA Export/ImportExports the AOC statewide TCA table out to each court nightly to update all TnCIS clerks with the latest updates or changes to the table. This allows up to date TCA’s in all counties immediately so they have the latest.Case Management SystemNo statute but a required exportNYNightlyImported API/JSONYNSimple Statewide
16Final DispositionsElectronically sends a nightly file to TBI of dispositions entered throughout the day for Final Disposition ReportingTN Bureau of Investigations8-4-115YNNightlyFixed lengthYNModerate Statewide
17Indigent Admin FeeAttorneys Indigent Defense Ordered Paid and/or WaivedAdministrative Office of the Courts40-14-202
37-1-150YNMonthlyManual. No request received for automatedYNSimple Statewide
18Juvenile ReportingJV data is reported to the AOC for juvenile and family court statistics.Quest37-1-187YNMonthlySome manual; some automatedYNComplex Statewide
19ExpungementsTnCIS electronically sends expungments to the AOC in the TJIS data.
Clerks import the expungement order manually into a TBI portal (echeck) and the TBI sends a stamped copy that says expunged and also notifies the AOC and any other agencies by email the clerk has requested.TN Bureau of Investigations/AOC/Sheriff40-32-101YNMonthlyCSVYNModerate Statewide
20Felony Drug Conviction RegistryFelony or felony reduced to misdemeanor drug convictionTN Bureau of Investigations39-17-436YNMonthlyManual, agency has no automation accommodationNNSimple Statewide
21Violent OffenderDispositions for certain violate crimes for the disposal of buccal swabsTN Bureau of Investigations40-35-321YNMonthlyManual, agency has no automation accommodationNNSimple Statewide
22Animal Abuse RegistryDefendant information and dispositions for certain animal abuse charges for Animal Abuse RegistryTN Bureau of Investigations40-39-401YNMonthlyManual, agency has no automation accommodationNNSimple Statewide
23Elder AbuseReport defendants and information for those charged with 39-15-502 - Financial Exploitation of elderly or vulnerable person.Department of Health39-15-506YNMonthlyManual, agency has no automation accommodationNNSimple Statewide
24Physician Felony ConvictionReport physicians with felony conviction. A form was to be created for this reporting by the medical board/Dept of Health however I am not sure this was createdDepartment of Health63-6-214YNMonthlyManual, agency has no automation accommodationNNSimple Statewide
25Administrator of Election ReportReport disqualified jurors so they may be removed from voting rolls (Deceased, No longer a County Resident, etc.)Local Election Office22-2-317YNMonthlyManual, agency has no automation accommodationNNSimple Local
26Infamous Crime Report-Felony ConvictionsReport individuals that are felons to be removed from election rolesLocal Election Office40-20-13YNMonthlyManual, agency has no automation accommodationNNSimple Local
* Format is determined by what the agency can accept.

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