North Carolina Set off Debt ASCII File Format

Field Name Start Position End Position Length Required Comments
SSN 1 9 9 Yes
First Name 10 19 10 Yes Setoff Debt First Name
Middle Initial 20 20 1 Yes Hard coded as blank
Last Name 21 35 15 Yes Setoff Debt Last Name
Street Address 36 60 25 Yes Owner Mailing address1
City 61 71 11 Yes Owner Mailing City
State 72 73 2 Yes Owner Mailing State
Zip Code 74 78 5 Yes Owner Mailing Zip Code
Debt Amount 79 85 7 Yes Current debt amount owed. If a payment has been made to the entity this will be the new debt amount. Debt must be $50.00 or more to be processed. Debts less than $50.00 can be combined under a single SSN to satisfy $50.00 requirement. Each debt $50.00 or more stands alone in the $50.00
Entity/Agency Code 86 89 4 Yes Agency Code
Debt Expiration Date 90 95 6 Yes (YYYYMM)
Debt Compliance Date 96 103 8 Yes (MMDDYYYY)
Debt Account Number 104 128 25 No Customer Account Number
Debt Unique Key 129 136 8 Yes Unique Key
Account Code 137 139 3 No Hard coded as 'TAX'
Base Debt Amount 140 146 7 No Same as Current debt amount owed. (for use only if importing into client software to do interest accrual )
Base Debt Interest 147 153 7 No Hard coded as blank
Debt Unique Key Extended 154 165 12 Yes Hard coded as blank (for Unique Keys larger than 8 characters). If the Unique Key is longer than 8 characters, put characters 9 - 20 appear in this location

Formats:

 a) Numeric:  All digits, 0-9.   Ex. SSN would be submitted as 248001234, not 248-00-1234

 b) Alpha:      Alphabetic characters A-Z, hyphen or blank

 c) Currency: All digits, 0-9, no commas or decimal points.  Ex. $1,265.48 would be submitted as 0126548

 d) YYYYMM:     Year, Month. All digits, 0-9.  Ex. 200409 would be submitted as September 2004; 200501 would be submitted as January 2005

 e) MMDDYYYY: Month, Day, Year. Ex. 09302004 is for September 30, 2004; 01012005 is for January 1, 2005