Skip to main content
Garnishment: EDP Layout and File Format Questions

Garnishment: EDP Layout and File Format Questions

EDP Layout and File Format

  • On Form 2142, what should be entered in the File Order Number if the total number of files is unknown?

    Use sequential numbering (e.g., 1, 2, 3…). Continue from the last number for subsequent submissions. Avoid duplicates.

  • What is a .DAT file?

    A DAT file is a plain text, fixed width file used to transmit garnishment records. It uses fixed‑width formatting, meaning every field has a specific character length and location. The header record appears first and shows information about the batch. The detailed records contain case-level and party-level information. DAT files are extremely formatting-sensitive, so even one incorrect character can cause rejection.

  • How do I create a .DAT file?

    Michigan Treasury does not provide database creation or software support. There are several database solutions organizations typically use. Microsoft Access is the easiest for smaller files, while SQL Server is the most common in government environments due to its validation strength and integration with .NET systems. Open-source databases like MySQL, MariaDB, PostgreSQL or Oracle also work but require more technical expertise. Please consult your internal IT resources for system development. Ensure they review the EDP-Electronic Data File Processing specifications and build a compliant workflow for generating and validating DAT files prior to submission

  • Will the DAT file be screened for errors before November 2?

    Yes. Files submitted during the early submission window will be tested, and errors will be communicated.

  • Has the EDP layout changed since last year?

    No significant changes have been made. Refer to the 2026 EDP File Layout Guide to confirm formatting.