ATTACHMENT 5 - Agency Interface File Formats.docx

This is a technical specification document for STATE 0000000178SL outlining agency interface file formats for a Secure File Transfer Protocol (SFTP) debit card system. The document provides detailed specifications for data field requirements, including standardized formats for cardholder information such as card number, name, address, Social Security number, and date of birth, along with transaction-related fields including dollar amounts, cents, and transaction codes. The file specifications section defines the structure for daily deposit files with batch header and detail records, establishing sequential numbering protocols, offender identification numbers, transaction amounts with implied decimal places, and mandatory vendor-identifying transaction IDs. Additionally, the document includes specifications for an offender validation file containing inmate account information, housing location details, and deposit indicators, as well as a PIN file structure and a video visitation file currently in development.

The technical specifications establish precise field lengths, data types (numeric or alphanumeric), and formatting requirements for the SFTP interface system. The offender validation file incorporates institutional housing data including building numbers, complex identifiers, and room assignments, suggesting this system manages inmate commissary or financial accounts within a correctional facility environment. The specifications require right-justified, zero-filled numeric fields for monetary amounts and sequential transaction numbering, with vendors responsible for assigning batch header numbers and transaction identifiers. The document does not specify pricing terms, contract duration, award dates, or incumbent information, focusing exclusively on the technical requirements necessary for system integration and data exchange between the state agency and contracted vendors.