50 IAC 26-21-4 Budget order

Sec. 4. (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 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) 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) 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) 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 department to the county auditor. (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