TABLE 1. Uniform Fertilizer Tonnage Reporting System
Standard Fixed Length Text File Format
Division of Regulatory Services
University of Kentucky
FIELD NAME |
START Column |
END Column |
WIDTH |
IMPLIED DEC* |
TYPE** |
DESCRIPTION |
Registrant/ Licensee Code |
1 |
6 |
6 |
N |
Registrant/Licensee code assigned by Division of Regulatory Services. The code which is numeric must be: right-justified and zero-fill. For example a registrant code of 550 would be entered as 000550. If the correct code is not used, the file cannot be imported. |
|
State |
7 |
8 |
2 |
A |
State postal code: KY (Capital Letters) |
|
Fertilizer Year |
9 |
12 |
4 |
N |
Use the last two digits of the calendar years for July and June. For example, July 1993 – June 1994 would be represented by "9394". |
|
Reporting Period |
13 |
14 |
2 |
N |
Monthly (July="01", August="02", . . . June="12") |
|
Fertilizer Code |
15 |
17 |
3 |
N |
A fertilizer code must be provided for fertilizer materials. For mixed fertilizers, use fertilizer code of zero (000) and provide the grade. For data to be accepted, use codes as defined in appendix II, Fertilizer Tonnage Reporting Handbook. |
|
Units |
18 |
18 |
1 |
N |
1=tons (always use "1") |
|
N |
20 |
22 |
3 |
1 |
N |
% Nitrogen (N) |
P2O5 |
24 |
26 |
3 |
1 |
N |
% Phosphate (P2O5) |
K2O |
28 |
30 |
3 |
1 |
N |
% Potash (K2O) |
Quantity (Tons) |
31 |
39 |
9 |
3 |
N |
Amount shipped in tons |
Container |
40 |
40 |
1 |
N |
1=bag, 2=bulk, 3=liquid |
|
Use |
41 |
41 |
1 |
N |
1=farm, 2=non-farm (default=1) |
|
Pesticide |
42 |
42 |
1 |
N |
1=none added, 2=some added (default=1) |
|
County |
43 |
45 |
3 |
N |
Use county FIPS code provided by regulatory office which represents the county where the product was applied if known, if not, the county where the purchaser is located. The county code list may be found in Appendix I of Fertilizer Tonnage Reporting Handbook. |
|
Tax Code |
46 |
46 |
1 |
N |
1=taxable (manufacturer whose registrant/licensee code appears in registrant/licensee code field is responsible for tonnage tax), 2=nontaxable (another manufacturer is responsible for tonnage tax). See below. |
|
Firm’s Name |
47 |
76 |
30 |
A |
Party responsible for tonnage tax if tonnage is nontaxable (tax code=2) |
|
Firm’s address |
77 |
106 |
30 |
A |
||
Firm’s City |
107 |
126 |
20 |
A |
||
Firm’s State |
127 |
128 |
2 |
A |
||
Firm’s Zip |
129 |
137 |
9 |
A |
||
Custom Mixture |
138 |
138 |
1 |
N |
1=not a custom mix product 2=custom mix product (default=1) |
|
Secondary/Micro |
139 |
139 |
1 |
N |
1=none added 2=some added (default=1) |
|
Ca |
140 |
142 |
3 |
1 |
N |
% Calcium (Ca) |
Mg |
143 |
145 |
3 |
1 |
N |
% Magnesium (Mg) |
S |
146 |
148 |
3 |
1 |
N |
% Sulfur (S) |
Cl |
1 45 |
151 |
3 |
1 |
N |
% Chlorine (Cl) |
B |
152 |
155 |
4 |
2 |
N |
% Boron (B) |
Cu |
156 |
159 |
4 |
2 |
N |
% Copper (Cu) |
Fe |
160 |
163 |
4 |
2 |
N |
% Iron (Fe) |
Mn |
164 |
167 |
4 |
2 |
N |
% Manganese (Mn) |
Zn |
168 |
171 |
4 |
2 |
N |
% Zinc (Z) |
Mo |
172 |
175 |
4 |
3 |
N |
% Molybdenum (Mo) |
*Decimal is NOT entered but implied. For example 24.722
tons would be entered as 24722 ending in column 39.
**N = Numeric – all numeric data must be right adjusted; A = Alpha
Other Information:
Name the files as follows: KYppyy.txt where pp = reporting period, yy = fertilizer
year txt = extension. For example, KY0101.txt represents data reported
for July 2000 for fertilizer year 2000-2001. Label each diskette with the
following: date sent, month, year, registrant/licensee name and code, and
filename(s). If you do not know your ‘code’ contact the Fertilizer Regulatory
Office at 859/257-2668.
The file must be a DOS ‘text’ file where only ASCII characters are allowed
and each line ends with a carriage return/line feed.