Opt-Out County Layout For Forfeiture Combo Data File

ELEMENT NAME LENGTH DATA TYPE SAMPLE DATA COMMENTS EDIT CHECK
1 Tax Year(s) 35 Alphanumeric 1995,96   Required
2 SEV 10 Numeric 11000 Most recent year delinquent Numeric (currency) field if entered
3 Base Tax 10 Numeric 325.21 Original delinquent tax Required, numeric (currency) field
4 Aggregate Tax 10 Numeric 595.00 Delinquent tax plus interest (18%/year) plus penalty + administrative fees ($175 + $15 + $9 forfeiture certificate + $9 redemption fee) + special assessments + local fees Required, numeric (currency) field
5 Legal Description 3000 Alphanumeric     Required
6 County Code 2 Numeric 76   Required, numeric whole number
7 Parcel ID 33 Alphanumeric 76-9-06-0-06890-000-00   Required for non-Detroit parcels
8 Street Address1 35 Alphanumeric 123 Main St. Where the property is located  
9 Street Address2 35 Alphanumeric Frontier Bldg. Where the property is located  
10 Postal Location 26 Alphanumeric Village of Empire Where the property is located  
11 Street Direction 2 Alphanumeric W Used for Detroit properties  
12 Ward 2 Numeric 1 Detroit Only  
13 Item Number 31 Alphanumeric A12345 Detroit Only  
14 Subdivision Name 160 Alphanumeric Maplewood    
15 Private Claim 4 Numeric 196 Private Claim Number Numeric whole number if entered.
16 CIS 7 Numeric 1135521 Consumer & Industry Services number for subdivisions  
17 Liber 6 Numeric 12   Numeric whole number if entered.
18 Page 6 Numeric 95   Numeric whole number if entered.
19 Local Unit Number 5 Numeric 76101   First two digits must be the county code. Numeric whole number if entered.
20 Local Unit Name 48 Alphanumeric Township of Curtis    
21 Local Unit Code 1 Alphanumeric T   T, C, V or space.
22 Town 3 Alphanumeric 01n    
23 Range 3 Alphanumeric 01w    
24 Section 2 Numeric 12   Numeric whole number if entered.
25 Acres 9 Numeric 10.2   Numeric, up to one digit after the decimal point
26 County Comments 200 Alphanumeric   Optional Comments  
27 Owner Name 50 Alphanumeric Joe Smith   Required
28 Owner Address 1 35 Alphanumeric 111 Main St   Required
29 Owner Address 2 35 Alphanumeric Suite 101    
30 Owner City 26 Alphanumeric Lansing   Required
31 Owner State 2 Alphanumeric MI   Required
32 Owner Zip 10 Alphanumeric 48825-1409   Required
33 Secondary Interest Name 50 Alphanumeric Doe   Required if inputting secondary interest.
34 Secondary Interest Address 1 35 Alphanumeric 12 South Blvd.   Required if inputting secondary interest.
35 Secondary Interest Address 2 35 Alphanumeric Apt. A    
36 Secondary Interest City 26 Alphanumeric Lansing   Required if inputting secondary interest.
37 Secondary Interest State 2 Alphanumeric MI   Required if inputting secondary interest.
38 Secondary Interest Zip 10 Alphanumeric 48825-1409   Required if inputting secondary interest.
39 Carriage Return/Line Feed 2 Alphanumeric   Needed at the end of each record Required