Skip to main content
Opt-Out County Layout For Forfeiture Parcel/Address Data File

Opt-Out County Layout For Forfeiture Parcel/Address Data File

Input from the Counties will be in the form of fixed length files. There will be one file to read the Parcel Information and a second one to read the Party and the Address Information. Each line in these files will be one record. A detailed description of each of the columns follows.

Layout of the Parcel Information file

 

Column Name

Max

Data Type

Edit Check
1

RecordID

8

Numeric

Required. A unique record ID that is generated by sender. It must match the associated records in the Addressee table.
2

Tax Year(s)

35

Alphanumeric

Required. Will hold years for which the tax is to be collected. Example:

1995

1995,1996, 1997 and so on.
3

SEV

10

Numeric

Numeric (currency) field if entered.
4

Base Tax

10

Numeric

Required. Numeric (currency) field.
5

Aggregate Tax

10

Numeric

Required. Numeric (currency) field.
6

Legal Description

3000

Alphanumeric

Required.
7

County Code

2

Numeric

Required. Numeric whole number.
8

Parcel ID

33

Alphanumeric

Required for non-Detroit parcels.
9

Street Address1

35

Alphanumeric

  
10

Street Address2

35

Alphanumeric

  
11

Postal Location

26

Alphanumeric

  
12

Street Direction

2

Alphanumeric

  
13

Ward

2

Numeric

Required for Detroit parcels only.
14

Item Number

31

Alphanumeric

Required for Detroit parcels only.
15

Subdivision Name

160

Alphanumeric

If present, can contain a combination of numbers and characters.
16

Private Claim

4

Numeric

Numeric whole number if entered.
17

CIS

7

Numeric

  
18

Liber

6

Numeric

Numeric whole number if entered.
19

Page

6

Numeric

Numeric whole number if entered.
20

Local Unit Number

5

Numeric

First two digits must be county code. Numeric whole number, if entered.
21

Local Unit Name

48

Alphanumeric

  
22

Local Unit Code

1

Alphanumeric

T, C, V or space.
23

Town

3

Alphanumeric

  
24

Range

3

Alphanumeric

  
25

Section

2

Numeric

Numeric whole number, if entered.
26

Acres

9

Numeric

Numeric, up to one digit after the decimal point.
27

County Comments

200

Alphanumeric

  
28

CR/LF

2

Alphanumeric

Carriage Return/Line Feed. Required.

Addressee Information file

 

Column Name

Width

Data Type

Edit Check

1

RecordID

8

Numeric

Required. Cannot be Null. A unique record ID that is generated by sender. It must match the associated records in the Parcel table.

2

Party Name

50

Alphanumeric

Required.

3

Address1

35

Alphanumeric

Required.

4

Address2

35

Alphanumeric

  

5

City

26

Alphanumeric

Required.

6

State

2

Alphanumeric

Required.

7

Zip Code

10

Alphanumeric

Required.

8

Relationship

1

Alphanumeric

Required. Must be either O or S.

9

CR/LF

2

Alphanumeric

Required. Carriage Return/Line Feed.