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

The document is an Appendix B file detailing 26 data feeds and interfaces for the Tennessee Court Management System (TnCIS), involving multiple state agencies including the Administrative Office of the Courts, Department of Correction, Department of Revenue, Department of Safety, State Comptroller's Office, and Tennessee Bureau of Investigations. The interfaces cover a wide range of critical judicial functions, including monthly and nightly data exchanges for civil filings, criminal charges, dispositions, expungements, mental health monitoring, tax records, driver's license actions, jury management, electronic filing, and specialized reporting for various registries tracking felony convictions, animal abuse, and elder abuse. The interfaces are categorized by frequency (daily, monthly, yearly), format (CSV, Fixed Length, API/JSON), and complexity (simple to complex), with most being statewide in scope and tied to specific Tennessee statutory requirements.

The data feeds represent a comprehensive integration strategy across multiple state and local government systems, supporting both automated and manual reporting mechanisms. While no specific budget is outlined in this document, the interfaces demonstrate a sophisticated approach to data sharing that supports judicial efficiency, public safety, and administrative reporting. The interfaces range from critical public safety functions like preventing firearm purchases for individuals with certain judicial hospitalizations to administrative processes like tax record management and jury selection. Most interfaces are mandated by state statutes, with varying levels of technical complexity, and support core government functions across criminal justice, public safety, tax collection, and electoral processes. The document indicates a robust, multi-agency approach to data exchange that prioritizes inter-departmental communication and standardized reporting.

View the file

Other files

File Type Posted
RFP_30227-00725_Amd_5.pdf PDF
RFP_30227-00725_Amd_7.pdf PDF
Appendix_E_-_Chart_of_TN_counties_pop_CMS_current.pdf PDF
Appendix_B-Revised_8-29-2025.xlsx XLSX spreadsheet
Appendix_D_Chart_of_Accounts.pdf PDF
RFP_30227-00725_Amd_3-FINAL_9_11_25.pdf PDF
RFP_30227-00725_Amd_5.pdf PDF
RFP_30227-00725_Amd_1.pdf PDF
Appendix_B-Revised_8-29-2025.xlsx XLSX spreadsheet
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
Appendix_C.pdf PDF
RFP_30227-00725_Amd_2.pdf PDF
Appendix_F%20-Legacy_CMS_List.xlsx XLSX spreadsheet
RFP_Attachment_6.6-Revised_8-29-25.xlsx XLSX spreadsheet
RFP_30227-00725_CMS_and_eFiling_Application_FINAL.pdf PDF
Attachment_6.3-Cost_Proposal_Scoring_Guide.xlsx XLSX spreadsheet
RFP_30227-00725_Amd_2.pdf PDF
Appendix_B-Revised_8-29-2025.xlsx XLSX spreadsheet
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
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_A_Use%20Cases.pdf PDF
Appendix_B-Revised_8-29-2025.xlsx XLSX spreadsheet
Appendix_D_Chart_of_Accounts.pdf PDF
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
Appendix_C.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_B.xlsx XLSX spreadsheet
Appendix_C.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 .