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.