Exhibit_F.4_-_Images_of_Cleared_Checks.pdf

PDF 123 KB Posted

Attached to
Banking Services
Solicitation number
25-P-131TF
Issued by
Volusia County, Florida

About this file

This document is an Exhibit F.4 detailing an index of cleared checks for project 25-P-131TF, specifically outlining a text file format for documenting cleared check information. The file describes a Comma Separated Value (CSV) structure with fixed-width columns designed to track financial transaction details, including account numbers, check numbers, check amounts, and a unique CIMS_KEY for associating check images. The document provides a comprehensive breakdown of each field's type, width, and purpose, with specific formatting instructions for creating filename conventions.

The technical specification includes precise instructions for generating check image filenames, which incorporate elements like year (Y####), month and day (MD####), and additional bank-specific codes. Sample data demonstrates the file's structure, showing two example entries with corresponding TIFF image filenames. The document appears to be a technical specification for financial record-keeping, likely used for tracking and archiving cleared check transactions, with specific relevance to banking or financial management processes.

View the file

Other files

File Type Posted
Banking_Services_(Addendum_#6_Revision).pdf PDF
Banking_Services.pdf PDF
Exhibit_Z_-_Exhibit_C_-_Insurance_Requirements_(FOR_DRAFT_CONTRACT).pdf PDF
Exhibit_Z_-_SAMPLE_-_DRAFT_Contract.pdf PDF
Exhibit_J.4_-_Tax_Collector_Average_Daily_Balances.pdf PDF
Exhibit_J.3_-_Property_Appraiser_Average_Daily_Balances.pdf PDF
Exhibit_J.2_-_Elections_Average_Daily_Balances.pdf PDF
Exhibit_J.1_-_County_Average_Daily_Balances.pdf PDF
Exhibit_I_-_Average_Cash_Vault_Deposits.xlsx XLSX spreadsheet
Exhibit_H_-_County_Computing_Security_Procedures.pdf PDF
Exhibit_G.5_-_Cash_Receipts_Data_File.xlsx XLSX spreadsheet
Exhibit_G.4_-_Bank_Reconciliation_Data_File.xlsx XLSX spreadsheet
Exhibit_G.3_-_ICL_File_Format.pdf PDF
Exhibit_G.2_-_Tax_Collector_E-Box_Export.pdf PDF
Exhibit_G.1_-_E-Box_Remittance_Report.pdf PDF
Exhibit_F.3_-_Cleared_Check_Data_File_Format.pdf PDF
Exhibit_F.2_-_Positive_Pay_Format.pdf PDF
Exhibit_F.1_-_EFT_File_Format.pdf PDF
Exhibit_E.4_-_Tax_Collector_Bank_Accounts.pdf PDF
Exhibit_E.3_-_Property_Appraiser_Bank_Accounts.pdf PDF
Exhibit_E.2_-_Elections_Bank_Accounts.pdf PDF
Exhibit_E.1_-_County_Bank_Accounts.pdf PDF
Exhibit_D_-_Human_Trafficking_Affidavit_FINAL_(TO_BE_COMPLETED).pdf PDF
Exhibit_C_-_Required_Types_and_Limits_of_Insurance_Chart.pdf PDF
Exhibit_B.3_-_One-Time_Transition_Costs_and_Cost_Offsets_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_B.2_-_Net_Earnings_Chart_(4_TABS_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_B.1.A_-_Appendix,_Services_Descriptions.xlsx XLSX spreadsheet
Exhibit_B.1_-_Pricing_Services_Chart_(1st_TAB_TO_COMPLETE_ONLY).xlsx XLSX spreadsheet
Exhibit_A.3_-_Technical_Requirements_Form_(TO_BE_COMPLETED).docx DOCX document
Exhibit_A.2_-_Technical_Requirements_Matrix_(1_TAB_TO_COMPLETE).xlsx XLSX spreadsheet
Exhibit_A.1_-_Banking_Service_Processes_(TO_BE_COMPLETED).docx DOCX document
Exhibit_A_-_Scope_of_Services.pdf PDF
PRIME-SUB_FORM_for_Contractors_rev._01.15.2025_(lock_before_publishing).xls XLS spreadsheet
Show all 33

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

25-P-131TF Exhibit F.4 - Images of Cleared Checks

Index of Cleared Checks Overview Text file in Comma Separated Value format containing data to be associated with images of cleared checks.

Columns are fixed width as well. Line terminators are Line Feed (New Line) characters.

Cleared Check Index File Field Name Type Field Width Note

ACCNO Text 13 Account Number COMMA Text 1 - SER_NO Text 10 Check Number COMMA Text 1 - ITM_AM Text 16 Check Amount (No decimal point) COMMA Text 1 - ITEM_NUM Text 5 Record number within the file COMMA Text 1 -

CIMS_KEY Text 35

Date String

– Period Separated

– Used to build image file name

ELRC - Code for Bank Use (not used at Volusia)

C## - Cycle Number Filename Characters 19-20

Y#### - Year Filename characters 1-4

MD#### - Month and Day Zero padded to 2 characters each Filename Characters 5-8

S##### - Code for Bank use Filename Characters 9-13

S##### - Code for Bank use Filename Characters 14-18

Sample 0009999999999,0001005223,0000000000095036,01241,ELRC.C05.Y2016.MD0701.S06528.S29437 0009898989898,0000760001,0000000000005559,02185,ELRC.C05.Y2016.MD0715.S50921.S24866

Cleared Check Image File Name Samples (matching sample data rows above) 20160701065282943705.tiff 20160715509212486605.tiff

Index of Cleared Checks
Overview
Cleared Check Index File
Sample
Cleared Check Image File Name Samples (matching sample data rows above)

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