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
Exhibit F.4 is a technical specification document for Volusia County, Florida's banking services RFP #25-P-131TF that details the data format and file structure for cleared check processing and archival. The document outlines a comma-separated value (CSV) index file format with fixed-width columns containing cleared check metadata, including account number, check number, check amount, record number, and a CIMS key that encodes bank cycle information, transaction date, and bank-specific codes. The cleared check image files are generated using a 20-character TIFF filename derived from the CIMS key, with specific character positions designating the year (characters 1-4), month and day (characters 5-8), and bank codes (characters 9-18). Sample data rows and corresponding TIFF filenames are provided as reference examples for implementing the cleared check imaging and retrieval system.
This technical exhibit establishes the data integration requirements for the selected banking services provider to maintain compatibility with Volusia County's existing check processing and archive systems. The specification ensures that cleared check images can be systematically indexed, retrieved, and reconciled through a standardized naming convention and metadata structure, supporting the county's monthly reconciliation services and financial record management requirements across its pooled cash accounts and multiple specialized banking functions.
View the file
Other files
Show all 34
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 .