Download:
pdf |
pdfJune 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
1
2
3
4
Record Type
Approved Insurance Provider
Location State
Policy Issuing Company
1
3
5
7
2
2
2
3
9(02)
X(02)
9(02)
9(03)
5
6
Policy Number
Crop Year
10
17
7
4
9(07)
9(04)
7
8
9
10
Crop Code
Insurance Plan Code
Location County
Unit Number
21
25
27
30
4
2
3
5
9(04)
9(02)
9(03)
9(05)
11
Type Code
35
3
9(03)
12*
Practice Code
38
3
9(03)
13
Coverage Flag
41
1
X(01)
14
15
Filler
Sub Type/Variety
42
50
8
3
X(08)
9(03)
16*
Grid ID
53
8
9(08)
17
Type 11 Key Reserve
61
15
X(15)
18
Record Number
76
3
9(03)
19
Type 15 Record Number
79
3
9(03)
FCIC-APPENDIX III
11 - 1
Field Edits
Required. Must be 11.
Required. Edit with AIP/Company table.
Required. Edit with FIPS State table.
Required. Edit with company table. Must be
valid Pic code for reinsurance year.
Required. Must be > zeros.
Required. Must be the crop year of the crops
reported under the policy. This will equal the
Reinsurance Year or Reinsurance Year +/- 1 for
applicable crop code.
Required; Edit with ADM2. See Exhibit 99-a.
Required; Edit with ADM2. See Exhibit 99-a.
Required; Edit with FIPS County Table.
Required; Must be > zeros. Unit number must
end in ‘00’ for Enterprise and Whole Farm Units
(i.e. 00100).
For PRF, crop 0088, plans 13 and 14, only basic
units by unique crop type/crop practice/grid id #
are allowed. Unit number must be “00000” if
Zero Acre Flag (field 70) equals “I”.
Required; Edit with ADM2. For 2009 crop year
Florida Fruit Trees, report sub type code in this
Field, if applicable.
Required; Edit with ADM2. Index Interval for
Pasture, Rangeland and Forage. Edit with
ADM1-E. (Required for timely processing).
Required; Must be:
C = Catastrophic “Cat” Coverage
A = Additional Coverage
For Revenue Assurance, CRC and GRIP
must be ‘A’.
Must be spaces.
Sub Type/Variety Code if applicable.
The subtype/variety code from the ADM is
applicable for option lines only for Florida Fruit
Trees. If not applicable, zero fill.
Grid ID from Map for Pasture Rangeland and
Forage Products. (Required for timely
processing). Right justify with leading zeros. If
not applicable, zero fill.
Space Reserved for Additional key data required
in the future or for other record types. Must be
spaces or blanks.
Must be > zero and unique within a Crop Policy
(fields 2 thru 9).
Required; The record number of the Type 15
record that established the yield or revenue
amount for this Type 11 record. See Exhibit 154 for the crops and plan codes that require a 15
record. Zero fill if not applicable.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
20
Agent SSN
82
9
9(09)
21
Rate Class
91
3
X(03)
22
23
Filler
Map Area (High Risk)
94
98
4
3
X(04)
X(03)
24
Crush District
101
2
X(02)
25
Reference Crop Year
103
4
9(04)
26
Written Agreement Type
107
2
X(02)
27
Written Agreement Number
109
8
X(08)
FCIC-APPENDIX III
11 - 2
Field Edits
Enter the SSN of the agent responsible for the
acreage report.
See Exhibit 11-2 for ADM validation rules.
Required for Florida Fruit Trees, Mac Trees and
Hawaii Tropical Trees. If not applicable, zero
fill.
Must be spaces.
Required for HRC dual coverage unless Rate is
from 33 Supplement. Can not be spaces if field
87 is an “H”. See Exhibit 11-3 for reporting
requirements. Must be spaces if not applicable.
Required for California Grapes Only. Crush
District = 01-17. Otherwise; spaces.
Required for Pecans only. Enter the first year of
the current 2 year module. Format CCYY. All
other crops, zero fill.
Valid Written Agreement types are: GP, HR,
NB, OC, OP, PE, RE, SC, SG, SM, SP, TC, TD,
TP, UA, UC, XC and 33. Enter spaces if
NO Written Agreement is in effect. Enter ‘33’ if
the insurance rate is provided on a FCI-33 (rules
page, map or supplement).
For Revenue Assurance (RA) plan 25, only valid
types are “33, HR, NB, SM and UC”.
All entries, except a “33” require a valid Written
Agreement Number in field 27.
For RMA issued Written Agreements enter the
identification number for the approved written
agreement for the RO, state, county and crop.
The first 3 digits identify the issuing RO and
must be valid for the location state.
Enter spaces if No Written Agreement exists.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
28
Written Agreement
Processing Flag
117
2
X(02)
29
Date Planted
119
8
9(08)
FCIC-APPENDIX III
11 - 3
Field Edits
All single values must be left justified.
Must be:
H = Use only for High Risk land with a
Written Agreement that changes the High
Risk rate, factor or yield. Use the Written
Agreement type of “HR”.
P = FCI-2 Dollar Amount of Insurance
exception for Macadamia Trees.
R = FCI-2 Agreement with a Reference
County.
W = FCI-2 Agreement with no Reference
County
3 = FCI-33 (rules page, map or supplemental)
Rates
RC = Certified organic acreage with a
location or reference county
RT = Transitional acreage with a location
or reference county
NC = Certified organic acreage with no
reference county
NT = Transitional acreage with no reference
County
XX = Uninsurable acres with no actuarial due
to Written Agreement. Must have
positive acre record with Written
Agreement.
For Revenue Assurance (25) only valid flags are
“3, H or R”.
Otherwise, spaces.
See Exhibit 11-8 for edit details.
Enter zeros if the crop has not been planted or is
listed in Exhibit 11-10, otherwise must be a valid
date in MMDDCCYY format. Date Planted
cannot be greater than the submission date.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
30
Field Name
Guarantee Reduction Flag
FCIC-APPENDIX III
Begin
Pos
127
Size
1
Picture
X(01)
11 - 4
Field Edits
L = Late Planting
M = Maximum Late Planted Reduction
P = Prevented Planting
E = Company verified eligible PP acres from
another unit and/or crop or qualifying
crop payment acres do not constitute 20
acres or 20 percent of the unit (as allowed
by section 17 (h) of the Common Crop
Insurance Policy Basic Provisions).
F = First Year thinning for Pecans
C = Percent Stand Limitation for Cherries
D = Amount of Insurance reduction for
Fixed Dollar Citrus (0215) in California and
Fixed Dollar Strawberries (0110). Also for
Cherries (0057) for reduction other than
percent stand limitation.
Space = No Reduction
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
31
Field Name
Yield
FCIC-APPENDIX III
Begin
Pos
128
Size
10
Picture
9(08)V9(02)
11 - 5
Field Edits
Insurance Plans 12, 13, 14, 40, 50, 51, and 73:
zero fill, except Macadamia Trees, 0024.
Insurance plan 50, crop 0024: If the average
yield of Mac. Nuts exceeds 3,000 pounds per
acre and the producer qualifies for an indexed
amount of insurance for Mac Trees, then report
the average yield in this field and the index in
field #44.
Insurance plans 41 and 46: yield must be
in whole dollars and match Type 15 record
for approved yield.
Insurance plan 55: (Yield from FCI-35 *
Coverage Level Factor) – minimum payment:
yield must be > 0 and ≤ ADM yield * coverage
level factor.
Insurance plans 25, 42, 44, 45, 90,
92 and 96: Yield must match Type 15 record for
approved yield (crop 0067: yield is in pounds).
For crop code 0047, type 062 and crop code
0067, type 098: this yield must be in pounds,
and DAS will internally convert this yield to
whole dollars and match to the Approved Yield
on the corresponding type 15 record. For Cotton
and ELS Cotton, this must be the
skip-row yield and match the converted
approved yield on the Type 15 (record type 15
Approved Yield * skip-row factor).
See Exhibit 11-12 for yield requirements.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
32
Dollar Amount of Insurance
138
10
9(08)V9(02)
33
Number of Trees/ Contracted
Pounds
148
10
9(10)
FCIC-APPENDIX III
11 - 6
Field Edits
For Revenue Assurance (25), Pecans (41), IP
(42 and 45), Avocados (46) and Dollar Crops
(50, except Florida Citrus), the selected dollar
amount of protection per acre goes in this field
and includes coverage level and/or price election
factor (see exhibit 11-4 for details). Florida
Citrus (plan code 50, crop codes 0245 thru
0251), the selected dollar amount of protection
per acre which includes coverage level and price
election factor (see Exhibit 11-4). For plan
code (51), this field must contain the exact $
amount from ADM-1-D. For Dollar Citrus
(0215) in California (06), Cherries, and
Strawberries must be Dollar Amount from
ADM-1-D or Dollar Amount from ADM-1-D *
Guarantee Reduction Factor from field 36. This
field is based on the “CEO” coverage level if
elected. For GRP(12) and GRIP (73) the Dollar
Amount of Insurance must not be < 60% of the
Maximum Protection per Acre or > 100% of the
Maximum Protection per Acre, except for GRP
CAT which = 45% of the Maximum Protection
Per Acre.
For Pasture, Rangeland and Forage (plan 13 and
14) Dollar Amount of Insurance must equal
(County Base Value per Acre times Coverage
Level) times Productivity Factor (Price Election
Factor, field 43). Otherwise; zero fill.
An entry greater than zero is only for the
following: Estimated number of Florida Fruit
Trees (40) by crop code. The number of
insurable Pecan (41) trees. The number of
insured Hawaii Tropical Fruit Trees (90) and
Hawaii Tropical Trees (40) by crop code and
age. The number of contracted pounds of
Peanuts by contract price for this record, if
applicable. For Peanuts, if this field is greater
than zero, then field # 40, Contract Price must be
greater than zero.
Otherwise, zero fill.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
34
Coverage Level
158
5
9(01)V9(04)
Must match Coverage Level (field 38) on the 14
record.
For Cat Policies, the coverage level must be
0.5000 for all plans except GRP (12) Crops, in
which case it must be 0.6500.
Florida Citrus - Valid Coverage Levels are
{0.5000, 0.5500, 0.6000,
0.6500, 0.7000, 0.7500, 0.8000, 0.8500}
Avocados (Ins Plan 46) - Valid Coverage
Levels are {0.5000, 0.5500, 0.6000, 0.6500,
0.7000, 0.7500}
Ins Plan 12 & 73 - Valid Coverage Levels are
{0.7000, 0.7500, 0.8000, 0.8500, 0.9000}
Ins Plan 13 & 14 (PRF) - Valid Coverage Levels
are {0.7000, 0.7500, 0.8000, 0.8500, 0.9000}
IP (Ins Plan 45), Sweet Potatoes (Ins. Plan 92) &
IAPH (Ins Plan 96) - Valid Coverage Levels are
{0.5000, 0.5500, 0.6000, 0.6500, 0.7000,
0.7500}
For Revenue Assurance - All T11 records for
RA must have the same coverage level within
the unit organization selected. Coverage levels
in 5% increments. Valid coverage levels are
0.6500, 0.7000, 0.7500 if unit option code (field
48) = BU or OU (0.8000 and 0.8500 if available
under MPCI, except Cotton). Valid coverage
levels are 0.6500, 0.7000, 0.7500, 0.8000,
0.8500 if unit option code (field 48) = EU or
WU. If Winter Wheat and spring crops have
WU, they are limited to Winter Wheat coverage
level.
IP (42), CRC (44) and All Other Crops – Valid
Coverage Levels are {0.5000, 0.5500, 0.6000,
0.6500, 0.7000, 0.7500, 0.8000, 0.8500}
There is no valid Coverage Level below 0.5000.
35
Guarantee Per Acre
163
10
9(08)V9(02)
Edit According to Guarantee Calculations for the
Crop/Insurance Plan. This is the adjusted
guarantee for late or prevented planting. This is
the adjusted guarantee for Cabbage (0072, except
processing) and Potatoes (Certified Seed) and
Hawaii Tropical Fruit with the 125% acreage
limitation. For Peanuts, (0075, plan 90), the
GPA should only be reported on records with
acres to calculate the Total Guarantee.
Otherwise; zero fill. See Type 11 Calculations
Exhibit 11-11.
FCIC-APPENDIX III
Size
Picture
11 - 7
Field Edits
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
36
Guarantee Reduction Factor
173
3
V9(03)
37
Reported Acres/Tons
176
8
9(06)V9(02)
38
Total Guarantee
184
10
9(08)V9(02)
FCIC-APPENDIX III
11 - 8
Field Edits
Required if Guarantee Reduction Flag is not
Blank.
Cherries (0057) = Stand reduction factor from
Exhibit 11-5 or Other Reduction Factor from
Special Provisions (whichever is lower).
Strawberries (0110) = factor from Special
Provisions For Dollar Citrus (0215, Plan 51) =
factor from Special provisions
If Guarantee Reduction Flag is spaces zero fill
this field.
For Late & Prevented Planting see Exhibit 11-1
for appropriate entry.
Required for all crops except Florida Fruit Trees
and Hawaii Tropical Trees. For Raisins, enter the
number of tons to the nearest hundredth. For
Skip Row Cotton, this must be the NET planted
acres, AFTER applying the skip row planting
pattern factor. For Peanuts, (0075, plan 90), the
acres should only be reported on records with the
GPA to calculate the Total Guarantee.
Edit According to Guarantee Calculations for the
Crop/Insurance Plan. For Peanuts, (0075, plan
90), the total guarantee should only be reported
on records with the GPA and acres to calculate
the Total Guarantee and on Liability records with
a $.19 price.
See Type 11 Calculations Exhibit 11-11.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
39
Field Name
Price Election Amount
FCIC-APPENDIX III
Begin
Pos
194
Size
8
Picture
9(04)V9(04)
11 - 9
Field Edits
Required; Must be 1.0000 for Plan codes 12,
13, 14, 41, 46, 50, 51, and 73.
Certified Seed Potatoes Option CL = 1.00
Option CH = 3.00
Ins. Plan Code 25 –
Malt Barley Option A ≤ the Price from
ADM-P
Malt Barley Option B ≤ 2.00.
Ins. Plan Code 42 –
Malt Barley Option A = the Price from
ADM-P
Malt Barley Option B ≤ 2.00.
Ins. Plan Code 90 Malt Barley Option A = the Price from
ADM-P
Malt Barley Option B ≤ 2.00.
For Peanuts, plan 90, (ADM Price or Contract
Price [up to .228]) * Price Election Factor =
Price Election Amount.
All other Plans/Crops edit using ADM4.
(ADM Price or Contract Price) * Price
Election Factor = Price Election Amount.
The CAT price election is 55%.
If Contract Price (field 40) = zeros, then use
ADM price.
Suffix:
1 = Catastrophic & Established High Price
are applicable (MPCI), (Peanuts) and
Tobacco (Plan 70)
2 = Catastrophic, Established High &
Market Price are applicable (MPCI)
3 = Projected Harvest and County Harvest
Price (RA) are applicable
4 = Not applicable
5 = N/A
6 = N/A
7 = IP Price is applicable
8 = CRC Base Price is applicable
9 = Contract Price is applicable (MPCI)
A = N/A
B = CAT/Established and/or Additional/
Contract Price is available.
If CE Option is selected, price must be 100% of
the price for the MPCI crop policy.
If HS option code is elected (ADM4-2)
then use higher of MPCI or Alternative Price
(ADMP-7) * PE Factor.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
40
Contract Price
202
8
9(04)V9(04)
41
42
Insured Share
Liability
210
214
4
10
9(01)V9(03)
9(10)
FCIC-APPENDIX III
Size
Picture
11 - 10
Field Edits
For Contract price crops enter 100% of the
contract price. Crops are:
Crop
State
Cty
Type
Alfalfa Seed
All
All
All
Silage Sorghum All
All
All
Peanuts
All
All
All
Grapes
CA
All
All
Grapes
OR
All
All
Grapes
ID
All
All except
Type 161
Grapes
WA
All
All except
Type 161
(For Alfalfa, Grapes, Peanuts and Silage
Sorghum only: use if contract price applies. For
Peanuts, if this field is greater than zero, then
Contracted pounds, field #33 must be greater
than zero. If no contract, use established price
and zero fill this field).
Processing Beans Idaho 041 301
Processing Beans Idaho 027 303
Processing Beans Oregon 045 303
Dry Beans
All
All
062
Green Peas
All
All
All
Dry Peas
All
All 098
Mustard
All
All All
Zero fill if not applicable.
Must be > zero and ≤ 1.000.
Edit According to the Exhibit 11-11 Calculations
for the Crop/Insurance Plan. If prevented
planting applies, the total liability for the unit
must exceed the total producer premium for the
unit. For Peanuts, if the Price Election Amount
field, # 39, is greater than zero, then this field
must be greater than zero.
Otherwise, zero fill.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
43
Price Election Factor
224
5
9(01)V9(04)
44
Yield Conversion Factor and
Yield Index for Mac Trees
229
4
9(01)V9(03)
FCIC-APPENDIX III
11 - 11
Field Edits
Must match Price Election Factor
(field 39) on the 14 record.
Required for all crops.
Plan codes 25, 44, 46, 50 (except Florida Citrus see table below) and 51 must = 1.0000. If plan
code = 46 and if coverage level = “C”,
this field must = 0.5500.
If option code = CE, this field must = 1.0000.
If crop = 0084 and the option code is CL or CH,
this field must = 1.0000.
If insurance plan = 41 and coverage flag (field
13) equals A, then this field must equal 1.0000;
if coverage flag (field 13) equals C, this field
must = 0.5500.
If insurance plan = 12 or 73 and coverage flag
(field 13) equals A, then this field must equal
0.6000 thru 1.0000.
If insurance plan = 12 and if coverage flag (field
13) equals C, this field must = 0.4500.
If insurance plan = 13 or 14, this is the
productivity factor selected by the insured and
coverage flag (field 13) must equal A, and this
field must equal 0.6000 thru 1.5000.
For all other plans, if coverage flag (field 13)
equals ‘A’ and coverage level (field 34) equals:
1.) 0.5000 this field must = 1.0000
2.) 0.5500 this field must be.≥ 0.9100
3.) 0.6000 this field must be.≥ 0.8400
4.) 0.6500 this field must be ≥ 0.7700
5.) 0.7000 this field must be ≥ 0.7200
6.) 0.7500 this field must be ≥ 0.6700
7.) 0.8000 this field must be ≥ 0.6300
8.) 0.8500 this field must be ≥ 0.5900
Can be applicable for non-irrigated Cotton
(0021). For irrigated Cotton (0021) and irrigated
ELS Cotton (0022) zero fill.
For Cabbage (except processing) and Potatoes
(Certified Seed) and Hawaii Tropical Fruit this is
the factor used to reduce the production
guarantee with the 125% acreage limitation.
For Hawaii Tropical Trees, this is the factor used
to reduce the total guarantee with the 125% tree
limitation.
For Mac Trees (0024), if field #31 is > 3,000
then this field should be > 1.000 and will be
validated (round to thousandths).
For all other crops zero fill.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
45
Base Premium Rate
233
8
V9(08)
46
Preliminary Base Rate
241
8
V9(08)
47
Loaded Premium per Acre
249
8
9(04)V9(04)
FCIC-APPENDIX III
11 - 12
Field Edits
Required; Plan code 25, 44, 90, 92 or 96 – Enter
calculated Base Premium Rate. For Peanuts, if
the Price Election Amount field, # 39, is greater
than zero, then this field must be greater than
zero. Otherwise, zero fill. All other plan codes
edit with ADM. For FCI-2 flag codes, see
Exhibit 11-8 for DAS validations.
For Plan codes 12, 13, 14 and 73: Must be the
premium rate per dollar (the ADM rate divided
by 100).
Note: Even if CEO is selected, use the rate
for the MPCI coverage level.
Plan code 25, 44, 90 – The value (current year’s
adjusted continuous rating base rate, adjusted
yield span base rate, prior year’s adjusted
continuous rating base rate or .999) used to
determine the reported Base Premium Rate.
This rate is not capped at .999 if base premium
rate is not capped and could exceed the field
size. Submit the values for the 8 decimal places
dropping the values before the decimal. For
Peanuts, if the Price Election Amount field, # 39,
is greater than zero, then this field must be
greater than zero. Otherwise, zero fill.
Otherwise, zero fill if Written Agreement
Processing Flag equals W, 3, H, NC & NT.
Plan Codes 92 & 96 – The calculated rate using
the continuous rating formula for plan codes 92
& 96.
For plan 25 with written agreement the
requirement will be by unit structure. If record is
basic (BU) or optional (OU) with written
agreement/FCI-33, zero fill for that record. If
record is enterprise (EU) with written
agreement/FCI-33, zero fill all records under
enterprise. If record is whole farm (WU) with
written agreement/FCI-33, zero fill all records
under whole farm.
Required for plan code 25. See Exhibit 11-11
for calculation and RA programming
instructions. Not applicable for Malting Barley
under plan code 25.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
48
Unit Option Code
257
2
X(02)
49
Common Option Codes
259
20
X(20)
50
Rate Class Option Codes
279
20
X(20)
FCIC-APPENDIX III
11 - 13
Field Edits
Enter :BU = Basic Unit Discount
WU = Whole Farm Unit (RA) Unit
number must end in 00
(i.e. 00100)
EU = Enterprise Unit (CRC, IP , RA &
APH) Unit number must end in
00 (i.e. 00100). If Crop Code =
0020 EU has a .900 discount.
OU = Optional Units - use for Ins.
Plans 25, 44, 90, 96 or 40 (crops
0265, 0266 and 0267 only)
Spaces = Optional Units - All other Ins.
Plans. If Crop Code = 0020
Spaces = Basic Unit by share
with No discount.
See Exhibit 11-7.
If crop code = 0231, spaces or BU = Basic Unit.
No ADM lookup of unit option code and factor
= 1.00.
Applicable Option code from FCI-35 Option
Table. Must be left justified. If not applicable,
leave blank. See Exhibit 11-9.
OC = Organic Practice
OT = Organic Transitional Practice
For Plans 25, 44, 90, 92 and 96 use the ADM-K.
For all other plans use the ADM-O.
Not applicable to Plans 12, 13, 14 & 73.
For 2009 Florida Fruit Trees and 2008 Hawaii
Tropical Trees (crops 0266 and 0267), plan 40,
report CV (not on the ADM) if ONLY the
CTVE has been selected. Report other
applicable option codes (OW, OX, OY, OZ)
from the ADM.
(See Ex. 11-9) (See Note at end of record)
Applicable Option code from FCI-35 Rate Class
Option Factor by Type/Practice table. Must be
left justified. If not applicable, leave blank. See
Exhibit 11-9. Does not apply to plan code 25,
44 or 90.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
51
Experience Factor
299
4
9(01)V9(03)
52
Premium Rate Surcharge
303
1
X(01)
53
Unit Premium Adjustment
Factor
304
5
9(01)V9(04)
54
RA Fall Harvest Price Option
309
1
X(01)
55
IP/IIP & Silage Sorghum
County Average Yield
310
8
9(07)V9(01)
56
RA Whole Farm Discount
Factor
318
5
9(01)V9(04)
57
Price Indicator
323
1
X(01)
58
Qualifying Prevented Planting
Crop
324
4
9(04)
FCIC-APPENDIX III
11 - 14
Field Edits
Must be 1.000 if the crop code is: 0012, 0013,
0015, 0019, 0022, 0023, 0024, 0029, 0036,
0043, 0044, 0046, 0049, 0050, 0052, 0058,
0059, 0060, 0062, 0083, 0085, 0086, 0088,
0089, 0090, 0255, 0256, 0257,0265, 0266,
0267, all GRP/GRIP Crops (Ins. Plan code 12,
13, 14 & 73), all Revenue Assurance Crops (Ins.
Plan Code 25), all CRC (Ins. Plan Code 44), all
IP (Ins. Plan Code 42), all IIP (Ins. Plan Code
45) and all IAPH (Ins Plan Code 96) and Ins.
Plan 92. All Texas Citrus Trees, All Florida
Fruit Trees & All Hawaii Tropical Fruit and
Tropical Trees.
Must be in the range 0.500 - 1.000 for all other
crops.
Values as Follows:
Y = APH Yield was cupped or floored, for nonyield-span crops, or cupped for yield-span crops
(from type 15 approved yield) and a 5%
premium surcharge is applied.
Blank = No premium surcharge has been
applied.
Required for all Revenue Assurance records and
for CRC & APH Enterprise Units. See
calculation exhibits. All other plans, zero fill.
Required for RA. Enter Y if producer selected
the Fall Harvest Price Option or N if it does not
apply. For all other plan codes leave blank.
Required for IP (42), Indexed IP (45) and
Indexed APH (96). Must be > zero. All other
Plans, zero fill.
Required for all Revenue Assurance records, see
Exhibit 11-12 for calculation. All other plans,
zero fill.
This field must equal ‘A’ or ‘E’.
‘A’ = Additional Price: If the additional price
has not been released, DAS will validate to the
established price.
‘E’ = Established Price
Plan codes 55, 90 & 96 can be ‘A’ or ‘E’.
Plan code 90, Hawaii Tropical Fruit (crops 0255,
0256 and 0257), indicator must be “E”. Plan
code 90, Peanuts 0075, indicator must be “E”.
All other Plan codes must = ‘E’.
If field number 30, Guarantee Reduction Flag,
equals “E”, this field should be the crop code for
the qualifying crop. Otherwise, zero fill.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
59
Unit Number of Qualifying
PP Crop
328
5
9(05)
60
333
8
X(08)
61
Ineligible Tracking Validation
Flag
Skip-row code
341
5
9(05)
62
Total Premium
346
10
9(10)
63
Subsidy
356
10
9(10)
64
65
66
67
68
Additional Subsidy Flag
Additional Subsidy
State/Private Subsidy Flag
State/Private Subsidy
Producer Premium
366
367
377
378
388
1
10
1
10
10
X(01)
9(10)
X(01)
9(10)
9(10)
69
Private Policy Code
398
3
X(03)
FCIC-APPENDIX III
11 - 15
Field Edits
If field number 58 is greater than zero, then this
field must be greater than zero and must be the
unit number of the qualifying crop. Otherwise,
zero fill.
Internal Use. Reserved.
Cotton: Enter the appropriate skip-row code for
the planting pattern and row width from the table
for skip-row cotton, if applicable. See note on
last page on the Type 15 record.
Otherwise; zero fill.
Required; edit according to the premium
calculation for the crop and insurance plan.
This field is based on the CEO coverage level if
elected. If any total premium is less than $1,
round to $1. For Peanuts, if field #45 is greater
than zero, this field must be greater than zero.
Required; enter dollar amount of subsidy for the
crop and insurance plan. If less than $1.00
round to $1.00. For CAT, subsidy must equal
Total Premium. For Peanuts, if field #45 is
greater than zero, this field must be greater than
zero.
Must be a space.
Zero fill.
Reserved. Must be a space.
Reserved. Zero fill.
Edit according to producer premium calculations
for the crop and insurance plan. This field is
based on the CEO coverage level if elected.
Cat coverage policies zero fill. For Peanuts, if
field #45 is greater than zero, this field must be
greater than zero.
First three letters of a valid acronym for the type
of reinsured private policy. Not applicable for
Cat coverage policies. See Exhibit 11-14 for list
of valid codes.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
70
Zero Acre Flag
401
1
X(01)
71
Seed Company Code
402
3
9(03)
72
73
74
Rate State
Rate County
Farm Serial Number
405
407
410
2
3
7
9(02)
9(03)
X(07)
75
Number of Sections
417
2
9(02)
76
Seed Cycle Code
419
1
X(01)
77
Insured’s Acreage Report
Signature Date
420
8
9(08)
FCIC-APPENDIX III
Size
Picture
11 - 16
Field Edits
A = Number of Florida Fruit Trees uninsurable
for ACC coverage.
I = Total Insurable Acres of Pasture, Rangeland
and Forage (PRF) for the crop in the county
in which the insured has a share, by plan
code, crop code and type code. This should
be very similar to a zero acreage report.
Only allowable for crop 0088.
Z = Zero County Acres – insured crop not
planted in the entire county (only one T-11
for the crop/county)
X = Zero Unit Acres – insured crop not planted
in an entire unit (only one T-11 for the
crop/county/unit; must have planted acres on
different units)
U = Uninsured Acres – planted to the insured
crop, but not insurable (can have records
with planted acres) reported acres must be
greater than zero, or Number of
uninsurable Florida Fruit Trees (can have
records with insurable Florida Fruit Trees)
N = No History Acres – never planted
Blanks = This is a regular acreage report.
See Exhibit 11-1 (pg.6) for Reporting
Requirements.
If the crop is Hybrid Sorghum Seed (0050) or
Hybrid Corn Seed (0062), edit with the seed
company table; Otherwise, zero fill.
Edit with the FIPS State table. See Notes.
Edit with the FIPS County table. See Notes.
Required for Peanuts, Burley Tobacco (0231)
Plan 90 (with coverage flag of A, and Flu cured
Tobacco (0229) Plan 90 in state 37 where the
EU option is used. For Burley Tobacco each
FSN must have a unique unit number. For all
other crops and states this field is optional. If
greater than spaces, must be left justified with no
special characters or imbedded spaces. Must be
spaces if no FSN is submitted.
Required for Revenue Assurance when Unit
Option Code = EU (Enterprise Unit) or WU
(Whole Farm). Enter the number of sections for
the entire unit. Otherwise, zero fill.
Internal Use. Companies must leave blank.
DAS will determine the seed cycle for RMA
reporting. Must be used to sum unit liability.
Required. Format = MMDDCCYY. This date
cannot be less than the Reinsurance Year – 1 or
greater than the submission date.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
78
79
Filler
CEO Coverage Level
428
430
2
5
X(02)
9(01)V9(04)
80
Agent’s Signature Date
435
8
9(08)
81
Sheller Warehouse Code
443
5
9(05)
82
Proration Factor
448
3
9(01)V9(02)
83
84
Filler
Filler
451
454
3
1
X(03)
X(01)
FCIC-APPENDIX III
11 - 17
Field Edits
Must be spaces.
If CEO coverage is elected, enter CEO coverage
level; must be greater than Coverage Level (field
34). Used to determine premium. Zero fill if
CEO option does not apply.
Required. Format = MMDDCCYY. This date
cannot be less than the Reinsurance Year – 1 or
greater than the submission date.
Required only if reporting Peanuts with
contract price; must be greater than zero.
See Exhibit 11-5 for codes.
Other crops; zero fill.
For 2008 Florida Fruit Trees, the applicable
proration factor for 2009 crop year by sub type,
option code and map area, if applicable.
See calculations in Exhibit 11-11. For 2009 crop
year contracts, factor = factor for signature date
+ 45 days.
Must be spaces.
Must be spaces.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
85
Rate Yield
455
10
9(08)V9(02)
86
Residual Factor
465
4
9(01)V9(03)
87
Land Location ID Type
469
1
X(01)
FCIC-APPENDIX III
11 - 18
Field Edits
Required. Continuous rating insurance plans 25,
44, 90, 92 and 96 rate yield will be used to
determine base premium rate and must match
rate yield on the record type 15. Rate yield does
not have to match yield (field 31). Rate yield
can be greater than zero or “zero”. A rate yield
of “zero” will be used to determine base
premium rate, resulting in a higher rate (lower
the yield, higher the rate). For Cotton and ELS
Cotton, this must be the skip-row rate yield and
match the converted rate yield on the record type
15 (record type 15, Rate Yield * skip-row
factor).
Non-continuous rating insurance plans 41, 42,
45, 46 – rate yield must match rate yield on the
T15 record.
Insurance plan 55, rate yield must match yield
(field 31).
Non-continuous rating insurance plans 12, 13,
14, 40, 50, 51 and 73 – zero fill rate yield and
yield (field 31). For Peanuts, if field #45 is
greater than zero, this field must be greater than
zero.
Internal. DAS will store the residual factor used
in calculation of total premium for plans
25 (RA), 44 (CRC) and 90 (APH).
Company will not submit a value.
Required. Use “L” for Legal Description, “F”
for FSA Farm Serial Number, “C” for Common
Land Unit or “O” for Other. Not required for
plan codes 12, 13, 14 and 73. “H” for Legal
Descriptions within a high risk area designation.
“V” for verified standard areas in partial high
risk sections. Must be “H” if field 23 is not
spaces.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
88
Land Location
470
18
X(18)
89
Multiple Cropping Flag
488
2
X(02)
FCIC-APPENDIX III
Size
Picture
11 - 19
Field Edits
If ID Type = “L”, must be a valid Legal
Description for the state/county with a format of
SSS-TTTD-RRRD. Must be left justified with
trailing spaces.
If ID Type = “H” or “V”, must be a valid Legal
Description for the state/county with a format of
SSS-TTTD-RRRD. Must be left justified with
trailing spaces.
If ID Type = “F”, must be a valid FSA Farm
Serial Number and left justified with trailing
spaces.
If ID Type = “C”, must be a valid Common
Land Unit number based on a valid FSA Farm
Serial Number, Tract Number and Field
Number. FSA FSN and Tract Number are both
7 bytes and must include leading zeros
(i.e. 00015460000134); Field Number must be 4
bytes and include leading zeros if applicable
and/or alpha-characters at the end, if applicable.
if ID Type = “O”, must be left justified with
trailing spaces. If a legal description is within a
section that contains a high risk land designation
and field 23 is spaces and field 87 is not a “V”,
then field 26 must be “HR” or “UC” and field 27
must be a valid written agreement number. See
Exhibit 11-8 for High Risk Land Validation
edits.
See State/County Cross Reference File for
reporting requirements for Legal Descriptions,
Farm Serial Numbers, Common Land Units and
Others.
Not required for plan codes 12, 13, 14 and 73.
MUST = SPACES FOR ORIGINAL FIRST
CROP
Use only with First Crop Loss
(See Ex. 11-1 for Flow Chart)
See Ex. 11-11 Calc Pages for applicable plans
Values are:
PR = 65% Premium Reduction on first crop
RP = Revised to 100% premium after premium
reduction, (PR)
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
90
Crop Status
490
3
X(03)
91
Intended Use
493
2
X(02)
92
Variety/Type
495
3
X(03)
93
Land Use
498
1
X(01)
94
Official Measured
499
1
X(01)
95
Field ID
500
2
X(02)
FCIC-APPENDIX III
11 - 20
Field Edits
Optional; used for reporting common USDA
information.
First character
“I” Initial Crop
“D” Double Crop
“S” Subsequent Crop
“E” Experimental
“R” Repeat Crop
Second Character
“I” Intended (We may not want to keep)
“P” Prevented Plant
“F” Failed Acreage
“A” Abandoned (Previously used for Quota
Peanuts)
“ ” Blank Space indicates Planted
Third Character
“M” Multiple plantings on same field
Must be spaces if not applicable.
Optional; used for reporting common USDA
information. Example: Intended use such as
Wheat “GR” for grain. Must be spaces if not
applicable.
Optional; used for reporting common USDA
information. Example: For Wheat-SRW (soft
red wheat). Must be spaces if not applicable.
Optional; used for reporting common USDA
information. Example: “F” for Fruit or
Vegetable. Must be spaces if not applicable.
Optional; used for reporting common USDA
information.
“O” = Official acreage reported
“M” = Acreage as measured
“S” = Staked and referenced acreage
Must be spaces if not applicable.
Optional; used for reporting common USDA
information.
Code for tracking special conditions on a field.
Must be spaces if not applicable.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
96
Modified Acreage Record
Flag
502
2
9(02)
97
Unit Liability
504
10
9(10)
98
Written Agreement
Multi Year Flag
514
1
X(01)
99
100
Filler
FSA Administrative State
515
519
4
2
X(04)
9(02)
101
FSA Administrative County
521
3
9(03)
102
Filler
524
27
X(27)
FCIC-APPENDIX III
11 - 21
Field Edits
Required. This is to implement the 2005 Basic
Provisions concerning allowable reasons to
change the acreage report for a policy. If the
reported unit total liability is more than $250
different than the value recorded 60 days after
the acreage reporting date, a value greater than
00, representing the reason for the modification
is required. If the unit total liability changes by
any amount prior to 60 days after the acreage
report date or if it changes by less than $250
after 60 days after acreage report date, this may
be 00.
00 – Not Applicable
01 – Approved Modified Acreage record
02 – Liability Adjustment Factor (LAF) applies
03 – Misreported Information Factor (MIF)
applies
04 – Both LAF and MIF apply
06 – Processing Correction
07 - Estimated Tonnage - Raisins
08 - Fall/Spring Unit
Required. This field contains the sum of the
amounts reported in the Liability, (field 42), for
the unit, reported in the transmission. If there
are multiple T11 records for the unit with more
than one seed cycle (Fall vs. Spring), this Total
must be the same on all T11s for the unit with
the same seed cycle. This Total will be used in
the validation of the modified acreage record
flag, (field 96). Seed cycle is identified for some
crops by type (fall and spring) and for some
crops by practice (fall, winter, spring, summer).
If a crop has a fall and winter practice or type,
they should be summed together or a spring and
summer practice or type, they should be summed
together.
Internal Use. Must be a space.
Will be populated with Y, N or a space if there
is no Written agreement.
Must be spaces.
FIPS code for FSA Administrative State if
different from Location State when reporting
Common Land Unit in Land Location.
FIPS code for FSA Administrative County if
different from Location County when reporting
Common Land Unit in Land Location.
Must be spaces.
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
103
FCIC Control Time
551
4
9(04)
104
FCIC Control Date
555
8
9(08)
105
Reinsurance Year
563
4
9(04)
106
Batch Number
567
4
9(04)
107
Transaction Sequence
Number
571
8
9(08)
108
109
110
111
112
Transaction Rejected Flag
Transaction Source Flag
First Submission Flag
Filler
Rate Method
579
580
581
582
584
1
1
1
2
1
X(01)
X(01)
X(01)
X(02)
X(01)
113
FCIC Initially Accepted Date
585
8
9(08)
114
LSR Reduction Flag
593
2
9(02)
115
FCIC Initially Accepted
Batch
595
4
9(04)
116
Filler
599
1
X(01)
Field Edits
Internal Use. The time the transaction batch file
was received. (From when transmission started)
HHMM Format.
Internal Use. The date the transaction batch file
was received. (From when transmission started)
MMDDCCYY Format.
Internal Use. The Reinsurance Year. CCYY
format.
Internal Use. The sequential number identifying
the file that was submitted by the AIP to
FCIC/RMA.
Internal Use. The sequential number assigned to
each transaction number processed by DAS after
it has been sorted.
Internal. Reserved
Internal. Reserved
Internal.
Internal Use. Must be spaces.
Internal use. For plan codes 25, 44, 90, 92 and
96 with value in Map Area (High Risk). The
rate method for the High Risk from ADM record
F.
A = Add on rate
M = Multiplicative rate
F = Fixed rate
Otherwise; spaces.
Internal Use. The date this record was initially
accepted by DAS. MMDDCCYY format. Zero
fill.
Internal Use. Record Type 14, Reduction Flag
(field 63).
RMA Internal Use. The sequential number
identifying the file that was initially submitted
by the AIP to FCIC/RMA and accepted by DAS.
Internal Use.
* Data elements that must be accepted to meet timely reporting of an eligible crop insurance contract.
Notes:
The Type 11 record must contain a corresponding Type 15 record number (in field 16) if a yield record is required for the
crop. The corresponding Type 15 record must match to the Type 11 on:
Fields 2 thru 13, field 31 and field 82.
A matching Insurance in Force Record (Type 14) must exist for each crop policy.
Acreage will not be accepted by DAS more than 60 days prior to the earliest final planting date for the crop/type/practice
in the county. This does not apply to California Sugar Beets (except counties 025, 035, 049, 089 & 093). This does not
apply to Wheat and Barley in Idaho, Oregon and Washington.
FCIC-APPENDIX III
11 - 22
RY2008
June 28, 2007
Exhibit 11
FCIC-Appendix III
(ACREAGE RECORD – TYPE 11)
Format/Edits
Field
No.
Field Name
Begin
Pos
Size
Picture
Field Edits
Notes con’t
Does not apply to Wheat if the type code = 011 or 997.
Rate State and Rate County can only be different from Location State and County if a written agreement is in effect.
If a producer has a Sheller contract, Peanut records will be reported for 2 primary reasons, 1) to report and calculate
the Total Guarantee for the Unit, and 2) to report and calculate the Liability by price and Premium by rate for the
Unit. These primary reasons will require the submission of two type 11 records, these are referred to as the total
guarantee record and the liability/premium record. If there are variable conditions within the unit that require
additional records, (ie late planting, prevented planting, type, practice or share), they will need a total guarantee and
liability/premium record.
1) For the Total Guarantee records, the companies will submit data for field numbers, 1-13, 18, 19, 20, 29, 30, 31,
34, 35, 36, 37, 38, 41, 58, 59, 74, 77, 80, 87, 88, 96, 97 and any other field that will affect the total guarantee. Even
though Insured Share will not affect the total guarantee, if the share is different, it must be reported with the different
acres for the share. All other fields must be "zero filled" or left "blank" on the total guarantee record.
2) For the Liability and Premium records, the companies will submit data for field numbers, 1-13, 18, 23, 26, 27, 28,
33, 34, 38(for non-contracted pounds, if applicable), 39, 40(for contract pounds only), 41, 42, 43, 45, 46, 48, 49, 51,
52, 57, 62, 63, 68, 72, 73, 85, 89, 96, 97, and any other field that will affect the liability or premium. All other fields
must be "zero filled" or left "blank" on the liability/premium record.
Organic Option
If crop is being insured as Organic by a Written Agreement do not report the organic code in the common option field.
If crop is being insured as Organic and does not need a written agreement, then report the applicable Common Option
code (OT = Organic Transitional acreage and OC = Organic Certified acreage).
FCIC-APPENDIX III
11 - 23
RY2008
File Type | application/pdf |
File Title | Microsoft Word - REC11.doc |
Author | julie.carew |
File Modified | 2007-06-28 |
File Created | 2007-06-28 |