Authority: IC 6-1.1-31-1; IC 6-1.1-31.5-3.5

Affected: IC 6-1.1-31.5

Sec. 4. (a) HEADER RECORD (the first record in each file):

1. (1) The HEADER RECORD must be placed as the first record in each CERTDRATES and ALLCERRATE file.

2. (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 2017A. 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. (1) The CERTDRATES file contains all of the certified tax rates assigned to each taxing district and unit within a county.
2. (2) The CERTDRATES file must be submitted by the department to the county auditor.

3. (3) Primary Key for the CERTDRATES file: The combination of the following fields must be unique within this file:

   1. (A) County Number. A unique number for each county as provided in code list 59.
   2. (B) State-Assigned District Number. The State-Assigned District Number as provided in code list 60.
   3. (C) Taxing Unit Type Code. The Taxing Unit Type Code as provided in code list 57.
   4. (D) Taxing Unit Code. The Taxing Unit Code as provided in county budget order.

   5. (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)
      Exempt	21	21	1	A	Is the fund exempt from property tax caps? (Y/N)
      Protected	22	22	1	A	Is the fund a protected taxes fund? (Y/N)
      Referendum	23	23	1	A	Is the fund a referendum fund? (Y/N)
      TIF AV Included	24	24	1	A	Is the fund a Post 09 referendum fund? (Y/N)

(c) ALL TAX & CREDIT RATES (appears once per district) - Filename = ALLCERRATE:

1. (1) The ALLCERRATE file contains all of the certified tax and credit rates assigned to each taxing district within a county.
2. (2) The ALLCERRATE file must be submitted by the department to the county auditor.

3. (3) Primary Key for the ALLCERRATE file: The combination of the following fields must be unique within this file:

   1. (A) County Number. A unique number for each county as provided in code list 59.
   2. (B) State-Assigned District Number. The State-Assigned District Number as provided in code list 60.

   3. (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. (1) The TRAILER RECORD must be placed as the last record in each CERTDRATES and ALLCERRATE file.

2. (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; filed May 9, 2018, 10:00 a.m.: 20180606-IR-050180006FRA; readopted filed Oct 4, 2024, 4:04 p.m.: 20241030-IR-050230833RFA)