Taxes - Layout of the Parcel and Addressee Information File

Layout of the Parcel and Addressee Information 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.