 |
Indiana Administrative Code (Last Updated: December 20, 2016) |
 |
Title 50. DEPARTMENT OF LOCAL GOVERNMENT FINANCE |
|
Article 50IAC26. COMPUTER STANDARDS FOR A UNIFORM AND COMMON PROPERTY TAX MANAGEMENT SYSTEM |
|
Rule 50IAC26-21. Property Tax Input-Output File Format Requirements |
Section 50IAC26-21-4. Budget order
-
(a) HEADER RECORD (the first record in each file):
(1) The HEADER RECORD must be placed as the first record in each CERTDRATES and ALLCERRATE file.
(2) The format of the HEADER RECORD must be consistent with the following data format:
Column
Start
End
Length
Type
Comments/Format
FileName
1
10
10
A
Name of data file (e.g., CERTDRATES or ALLCERRATE).
County Number
11
12
2
A
State designated county ID (e.g., 23). See code list 59.
County Description
13
32
20
A
State designated county name (e.g., LAKE). See code list 59.
File Format ID
33
37
5
A
Constant value of 2010A. This communicates the version of the structure used to create the data.
County Contact Name
38
77
40
A
Full name of the individual at the county who can answer questions specific to this data extract (e.g., Robert Smith).
County Contact Phone
78
95
18
A
Complete telephone number of individual at the county who can answer questions specific to this data extract – format required is ###-###-#### ##### (e.g., 219-555-5555 44444).
File Create Date
96
105
10
D
Date the file was created – format required is mm/dd/yyyy format (e.g., 10/01/2010).
File Create Time
106
109
4
A
Time the file was created – format required is #### in military time (e.g., 1400).
Assessment Year
110
113
4
A
The assessment year specific to the data submission – format required is yyyy (e.g., 2009).
Pay Year
114
117
4
A
The tax payment year specific to the data submission – format required is yyyy (e.g., 2010).
Software Vendor Company
118
177
60
A
Full name of the vendor company preparing the data extract.
Software Package Name and Version
178
237
60
A
Complete name of the software package along with the version of the software used to build this data extract (e.g., ABC Assessor System Version 1.5).
Software Vendor Contact Name
238
287
50
A
Full name of the individual at the vendor who can answer questions specific to this data extract (e.g., Robert Smith).
Software Vendor Phone Number
288
305
18
A
Complete telephone number of the individual at the vendor's company who can answer questions specific to this data extract – format required is ###-###-#### ##### (e.g., 317-555-5555 44444).
Software Vendor Contact E-mail
306
353
48
A
E-mail of the individual at the vendor's company who can answer questions specific to this data extract (e.g., Help@ABCVendor.com).
Transmission Description
354
453
100
A
Description of transmission. Comment field, free text.
(b) TAX RATES (appears once per unit's fund/district combination) - Filename = CERTDRATES:
(1) The CERTDRATES file contains all of the certified tax rates assigned to each taxing district and unit within a county.
(2) The CERTDRATES file must be submitted by the department to the county auditor.
(3) Primary Key for the CERTDRATES file: The combination of the following fields must be unique within this file:
(A) County Number. A unique number for each county as provided in code list 59.
(B) State-Assigned District Number. The State Assigned District Number as provided in code list 60.
(C) Taxing Unit Type Code. The Taxing Unit Type Code as provided in code list 57.
(D) Taxing Unit Code. The Taxing Unit Code as provided in county budget order.
(E) Fund Code. The Fund Code as provided on the county budget order issued by DLGF.
Column
Start
End
Length
Type
Comments/Format
County Number
1
2
2
A
State designated county ID (e.g., 23). See code list 59.
Taxing Unit Type Code
3
3
1
A
1 digit Unit Type Code See Code List 57.
Taxing Unit Code
4
7
4
A
4 digit Taxing Unit Code as provided in county budget order.
Fund Code
8
11
4
A
4 digit Fund Code as provided in county budget order.
State-Assigned Tax District Number
12
14
3
A
Must be 3 digits as provided in code list 60 (e.g., 026).
Tax Rate
15
20
6
N
Format 2.4 (e.g., 010015; Implied 01.0015)
(c) ALL TAX & CREDIT RATES (appears once per district) - Filename = ALLCERRATE:
(1) The ALLCERRATE file contains all of the certified tax and credit rates assigned to each taxing district within a county.
(2) The ALLCERRATE file must be submitted by the county auditor to the department.
(3) Primary Key for the ALLCERRATE file: The combination of the following fields must be unique within this file:
(A) County Number. A unique number for each county as provided in code list 59.
(B) State-Assigned District Number. The State Assigned District Number as provided in code list 60.
(C) Rate Type Code. The credit type code as provided in code list 37. District tax rates are type code "99".
Column
Start
End
Length
Type
Comments/Format
County Number
1
2
2
A
State designated county ID (e.g., 23). See code list 59.
State-Assigned Tax District Number
3
5
3
A
Must be 3 digits as provided in code list 60 (e.g., 026).
Total Tax or Credit Rate
6
11
6
N
Format 2.4 (e.g., 010015; Implied 01.0015)
Rate Type Code
12
13
2
N
Identify type of rate such as gross tax rate, state homestead credit, or COIT homestead credit, etc. See code list 37 for applicable credit types. Use "99" for gross tax rate.
(d) TRAILER RECORD (the last record in each file):
(1) The TRAILER RECORD must be placed as the last record in each CERTDRATES and ALLCERRATE file.
(2) The format of the TRAILER RECORD must be consistent with the following data format:
Column
Start
End
Length
Type
Comments/Format
Record Id
1
10
10
A
Constant value of "TRAILER"
Total Record Count
11
30
20
N
Total Number of Records excluding Header and Trailer
(Department of Local Government Finance; 50 IAC 26-21-4; filed Jan 28, 2011, 3:07 p.m.: 20110223-IR-050100165FRA)