Yield Record - Type 15 - Format - Edits

June 28, 2007

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
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
12
13

Type Code
Practice Code
Coverage Flag

35
38
41

3
3
1

9(03)
9(03)
X(01)

14

Type 15 Key Reserve

42

34

X(34)

15

Record Number

76

3

9(03)

16

T Yield Map Area

79

3

X(03)

17

Written Agreement Type

82

2

X(02)

FCIC-APPENDIX III

15 - 1

Field Edits
Required. Must be 15.
Required. Edit with AIP/Company table.
Required. Edit with FIPS State table.
For Reinsured 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.
Required; Edit with ADM2.
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).
Required; Edit with ADM2.
Required; Edit with ADM2.
Required; Must be:
C = Catastrophic “CAT” Coverage
A = Additional Coverage
For CRC and Revenue Assurance must be
“A”.
Space Reserved for Additional key data
required in the future or for other record
types.
Must be > zero and unique within a Crop
Policy (fields 2 thru 9).
If not blank or zeros, then edit T-Yield Map
Area with ADM Record Y.
Valid Written Agreement types are: 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).
All entries, except a “33” require a valid
Written Agreement Number in field 18.

RY 2008

June 28, 2007

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

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.
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”.
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
Otherwise, spaces.
See Exhibit 11-8 for edit details.
Must be spaces.

18

Written Agreement Number

84

8

X(08)

19

Written Agreement Processing
Flag

92

2

X(02)

20

Filler

94

2

X(02)

FCIC-APPENDIX III

15 - 2

RY 2008

June 28, 2007

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

21

Field Name

Yield Indicator

FCIC-APPENDIX III

Begin
Pos

96

Size

Picture

Field Edits

2

X(02)

Must be:
A = Added Land (simple average)
AL = Added Land for Sugarcane and
Tobacco (crop 0236, type 061 in
CT & MA) with a lag year
(simple average)
B = Added Land, Variable T-yield
BL = Added Land for Sugarcane and
Tobacco (crop 0236, type 061 in
CT & MA) with a lag year,
Variable T-yield
C = Added Land, Variable T-yield, or
Determined Irrigated Yield for added
Irrigated Practice (No edit for Annual
Yields except Variable T-yields, edit for
Approved Yield)
CL = Added Land for Sugarcane and
Tobacco (crop 0236, type 061 in
CT & MA) with lag year,
Variable T-yield
F = FCIC RO Assigned Yield. No cup or
YA will be applicable.
(No Edit for Approved Yield)
K = Personal Transitional Yield (PTY)
for 5 counties in Montana and for Sweet
Potatoes, plan 92 only (no ADM match
for T-Yield)
L = Lag Year Planted for Sugar Cane and
Tobacco (crop 0236, type 061 in CT
& MA)
M = Master Yield
(No Edit For Approved Yield)
S = Skip-row planting pattern for all
skip-row crops, except Cotton, as
addressed in Section 4 of CIH
W = Average of Map Area T-Yields for a
unit or multiple blocks being reported
as one block that has mixed age or
density.
(see Exhibit 15-2, page 23)
Blank = Not Applicable (Normal Approved
Yield)

15 - 3

RY 2008

June 28, 2007

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

Must match the T Yield from ADMY (area
yield) if any of these yield types are reported
(Yield Types = S, SX, T, TX, E, EX, I, N,
NX, X,H) or if the yield limitation flag
indicates a floored yield or one or more
substituted yields (Yield Limitation Flag =
05,07,08,09).
If the Yield Limitation Flag equals “09”, the
T-Yield must be from the ADM for the
applicable year.
Enter the simple average T yield if: yield
indicator (field 21) = ‘A’, ‘AL’, ‘C’ (with at
least one yield type of ‘C’), ‘K’ or ‘W’. If
the yield indicator is ‘blank’ and at least one
Annual Yield Type = ‘C’, then this field must
equal the simple average T-yield for Added
P/T/V. If any of these situations, simple
average T-Yield, apply and the yield
limitation flag = 09, then use 60% of this
field for yield substitution.
If none of these cases apply, zero fill.
For CA Avocados, must contain the County
Average Per Acre Revenue. For all other
crops, zero fill.
Required; Must be greater than zero, See
Exhibit 15-2 for calculations. For CA
Avocados and Pecans enter the per acre
revenue in whole dollars.
For crop code 0047, type 062 and crop code
0067, type 098, this Approved Yield must be
in whole dollars.
For Cotton and ELS Cotton, this must be the
adjusted solid planted yield before the
skip-row factor.
Required if the Yield Limitation Flag = 01,
03,05 or 07 or if any Yield type is based on
the previous approved yield (Yield type = P).
Otherwise; zero fill.
Required if Yield Type 1 does not equal
Spaces. Indicates the year Yield Type 1
occurred. Must be ≥ 1970 and ≤ the
Reinsurance Year. Format: CCYY.
Otherwise; zero fill.
Valid Yield Types are listed in exhibit 15-1.
See Exhibit 15-1 for valid values. See Notes.
See Exhibit 15-1 for valid values.

22

Transitional Yield

98

10

9(08)V9(02)

23

FSA Yield

108

10

9(08)V9(02)

24

Approved Yield

118

10

9(08)V9(02)

25

Previous Approved Yield

128

10

9(08)V9(02)

26

Yield Year 1

138

4

9(04)

27
28
29

Yield Type 1
Annual Yield 1
Yield Acres 1

142
144
154

2
10
8

X(02)
9(08)V9(02)
9(06)V9(02)

FCIC-APPENDIX III

15 - 4

RY 2008

June 28, 2007

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

30

Revenue Yield/Skip Row
Code 1

162

6

9(06)

31
32
33
34
35

Yield Year 2
Yield Type 2
Annual Yield 2
Yield Acres 2
Revenue Yield/ Skip Row
Code 2
Yield Year 3
Yield Type 3
Annual Yield 3
Yield Acres 3
Revenue Yield/ Skip Row
Code 3
Yield Year 4
Yield Type 4
Annual Yield 4
Yield Acres 4
Revenue Yield/ Skip Row
Code 4
Yield Year 5
Yield Type 5
Annual Yield 5
Yield Acres 5
Revenue Yield/ Skip Row
Code 5
Yield Year 6
Yield Type 6
Annual Yield 6
Yield Acres 6
Revenue Yield/ Skip Row
Code 6
Yield Year 7
Yield Type 7
Annual Yield 7
Yield Acres 7
Revenue Yield/ Skip Row
Code 7

168
172
174
184
192

4
2
10
8
6

9(04)
X(02)
9(08)V9(02)
9(06)V9(02)
9(06)

Pecans: Enter the average per acre
production in whole pounds, or,
Sweet Potatoes: Enter the Packout Yield,
if available.
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.
Otherwise; zero fill. See Notes.
See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield/ Skip Row Code 1.

198
202
204
214
222

4
2
10
8
6

9(04)
X(02)
9(08)V9(02)
9(06)V9(02)
9(06)

See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield/ Skip Row Code 1.

228
232
234
244
252

4
2
10
8
6

9(04)
X(02)
9(08)V9(02)
9(06)V9(02)
9(06)

See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield/ Skip Row Code 1.

258
262
264
274
282

4
2
10
8
6

9(04)
X(02)
9(08)V9(02)
9(06)V9(02)
9(06)

See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield/ Skip Row Code 1.

288
292
294
304
312

4
2
10
8
6

9(04)
X(02)
9(08)V9(02)
9(06)V9(02)
9(06)

See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield/ Skip Row Code 1.

318
322
324
334
342

4
2
10
8
6

9(04)
X(02)
9(08)V9(02)
9(06)V9(02)
9(06)

See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield/ Skip Row Code 1.

36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

FCIC-APPENDIX III

15 - 5

RY 2008

June 28, 2007

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78

Field Name

Yield Year 8
Yield Type 8
Annual Yield 8
Yield Acres 8
Revenue Yield/ Skip Row
Code 8
Yield Year 9
Yield Type 9
Annual Yield 9
Yield Acres 9
Revenue Yield/ Skip Row
Code 9
Yield Year 10
Yield Type 10
Annual Yield 10
Yield Acres 10
Revenue Yield/ Skip Row
Code 10
Rate State
Rate County
Farm Serial Number

FCIC-APPENDIX III

Begin
Pos

Size

Picture

Field Edits

348
352
354
364
372

4
2
10
8
6

9(04)
X(02)
9(08)V9(02)
9(06)V9(02)
9(06)

See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield/ Skip Row Code 1.

378
382
384
394
402

4
2
10
8
6

9(04)
X(02)
9(08)V9(02)
9(06)V9(02)
9(06)

See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield/ Skip Row Code 1.

408
412
414
424
432

4
2
10
8
6

9(04)
X(02)
9(08)V9(02)
9(06)V9(02)
9(06)

See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield/ Skip Row Code 1.

438
440
443

2
3
7

9(02)
9(03)
X(07)

Edit with the FIPS State table. See Notes.
Edit with the FIPS County table. See Notes.
Required for Peanuts (0075) and Plan 90
Tobacco. Must be a valid FSN that is left
justified with no special characters or
imbedded spaces. Optional for other crops.

15 - 6

RY 2008

June 28, 2007

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

Required; Indicates what edit applies for
Approved Yield. Must be:
Flag Approved Yield
01
Average APH Yield (≥ cup)
03
Yield Cup
04
Average APH Yield (< cup)
05,07,08 Yield Floor (*see note page 15-8)
09
Yield Adjustment Election (60%
T-yield substitution applied to at
least 1 Annual Yield on this record)
10
Approved Yield Reduced,
Inconsistent Approved Yields
11
Approved Yield Reduced,
Different Production Methods
12
RMA RO determined yield with
substitutions applied by the RO or
AIP approved yield with adjustment
for percent stand according to
procedures. Premium rate surcharge
applies.
13
RMA RO determined yield with cup
applied by RO. Premium rate
surcharge applies.
See Exhibit 15-2 for detailed edits.
Excessive Yield Edit Verification: If
approved or annual yields exceed the lower
yield limitations (See Exhibit 15-3), enter
appropriate verification flag of 1 as official
confirmation that an appropriate underwriting
review has occurred and confirmed that the
yield is reasonable and correct.
Space = No High Yields
If reference records are required to calculate a
variable T-yield, enter the number of years
with actual yields on the 15 records used for
reference records. Must be 01 - 10.
Otherwise; zero fill.
Must be spaces.
Applicable option codes that directly affect
the yield calculation (i.e., FN, FO, YA, CU).
Edit with the appropriate ADM record.
OC = Organic Certified Acres
OT = Organic Transitional Acres
This code does not affect yield calculation.
For tracking purposes only.
(See Note at end of record)
Otherwise, must be spaces or blanks.

79

Yield Limitation Flag

450

2

9(02)

80

Excessive Yield Edit
Verification

452

1

X(01)

81

Number of Years with Actual
Yields on Reference Records

453

2

9(02)

82
83

Filler
Applicable Option Codes

455
459

4
16

X(04)
X(16)

FCIC-APPENDIX III

15 - 7

RY 2008

June 28, 2007

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

84

Rate Yield

475

10

9(08)V9(02)

Required: If the yield limitation flag equals
01, 05-08, 09 or 12, then rate yield must
equal the average yield. If the yield
limitation flag equals 03, 04, 10, 11 or 13,
then rate yield must equal the approved yield.
For plan code 96, must equal average APH
yield, before any adjustments, times the yield
index.
For Cotton and ELS Cotton, this must be the
average solid planted yield before the
skip-row factor.

85

Average Yield

485

10

9(08)V9(02)

86

Previous Yield Limitation
Flag

495

2

9(02)

87

Yield Index

497

5

S9(03)V9(02)

88

Perennial Year of Set Out

502

6

9(06)

Required: Must be greater than zero.
Sum of all annual yields (except Z), divided
by the number of annual yields (except Z) in
the database.
This is the yield limitation flag for the
previous approved yield and indicates what
edit was applied to Approved Yield the
previous year.
Flag Approved Yield
01
Average APH Yield (≥ cup and ≤ cap)
03
Yield Cup
04
Average APH Yield ( cap)
05, 07, 08 Yield Floor
09
Yield Adjustment Election
(60% T-yield substitution Applied to at
least 1 Annual Yield on this record)
See Exhibit 15-2 for detailed edits.
10 Approved Yield Reduced, Inconsistent
Approved Yields
11 Approved Yield Reduced,
Different Production Methods
12 RMA RO determined yield with
substitutions applied by the RO or AIP
approved yield with adjustment for
percent stand according to procedures.
13 RMA RO determined yield with cup
applied by RO.
00 Must be 00 ONLY if the previous
Approved Yield equals zeros.
The yield index used to calculate the
Approved Yield for ONLY, Indexed IP (plan
45) and Silage Sorghum (plan 96) yields.
Otherwise, zero fill.
For APH reporting purposes for perennial
crops, the actual calendar month and year the
acreage was planted. MMCCYY format.
Otherwise, must be zero filled.

FCIC-APPENDIX III

15 - 8

RY 2008

June 28, 2007

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

If the month and year of set out in field #88 is
041997, then the set out year is 1997. For
acreage planted or grafted after June 30, the
SET OUT YEAR shall be the year following
the calendar year in which set out actually
occurred (i.e. planted or grafted in
September, 1997, set out year is 1998).
To determine LEAF YEAR, subtract the set
out year from the calendar year of insurance,
then add one year. If 2004 is the year of
insurance and the trees/vines were set out in
April, 1997, then the LEAF YEAR is
determined as follows: 2004 minus 1997
plus 1 equals 8. See Exhibit 15-2, page 16
for Hawaii Tropical Fruit leaf year.
Otherwise, must be zero filled.
Perennial population density of trees, vines,
bushes, etc., per acre. Must be greater than
zero and less than 10,000. Zero fill for
Cranberries and non-perennial crops.
Unique number within a unit to identify
specific acreage or block of trees, vines,
bushes, etc. Otherwise, must be zero filled.
Factor used to adjust Map Area Transitional
Yields for Perennial crops. Otherwise, must
be zero filled.
Yield identifier for special cases for perennial
crops such as, variable yields, downward
trending, etc. (AF, D, DF, F, H, I, N, NS, R,
etc.). Otherwise, must be spaces.
See Exhibit 15-2.
Code to identify other perennial
characteristics such as Spur (S), Non-spur
(N), Early (E), Mid (M) or Late (L) season,
etc. Otherwise, must be spaces.
For APH reporting purposes, for perennial
crops, the actual calendar month and year the
acreage was grafted. MMCCYY format.
Otherwise, must be zero filled.
Must be spaces.

89

Perennial Leaf Year

508

2

9(02)

90

Perennial Density

510

4

9(04)

91

Perennial Block Number

514

3

9(03)

92

Perennial Transitional Yield
Factor

517

3

9(01)V9(02)

93

Perennial Special Cases

520

3

X(03)

94

Perennial, Other
Characteristics

523

1

X(01)

95

Perennial Year of Grafting

524

6

9(06)

96

Filler

530

21

X(21)

FCIC-APPENDIX III

15 - 9

RY 2008

June 28, 2007

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

97

FCIC Control Time

551

4

9(04)

98

FCIC Control Date

555

8

9(08)

99

Reinsurance Year

563

4

9(04)

100

Batch Number

567

4

9(04)

101

Transaction Sequence Number

571

8

9(08)

102
103
104

Transaction Rejected Flag
Transaction Source Flag
Filler

579
580
581

1
1
20

X(01)
X(01)
X(20)

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.

Notes:
Years must be in chronological order and year 10 must be either the most recent crop year in the database, or
equal to the current crop year minus one. For Sugarcane, (0038) and Tobacco (0236, Type 061 in CT & MA) and
Malting Barley (0091, option code MA), year 10 in the database must be less than or equal to the current crop year
minus 2.
Annual Yields 1 – 10 must be in whole dollars for CA Avocados and Pecans.
Annual Yields 1 – 10 must be the Field Pack Yield in Hundredweights for Sweet Potatoes (0085), plan 92.
Revenue Yields 1 – 10 must be the Packout Yield in Hundredweights for Sweet Potatoes (0085), plan 92, if
available.
Revenue Yields 1 – 10 must be the average per acre production in whole pounds for Pecans (0020), plan 41.
Pecans – yield type ‘B’ for no records (4 years) Only valid yield types for Pecans are: As and Bs. (See Exhibit 15-1
for valid Pecan yield type combinations).
California Avocados - only valid yield types are: A, AY, F, NA & P
Florida Avocados – only valid yield types are: A, AY, E, F, J, N, NA, P, S, T, Z and blank
APH (90) Peanuts (0075) – only valid yield types are: A, AY, C, E, F, I, IL, J, L, N, P, S, T, Z and blank.
An “F” yield type may only be used in years prior to 2002 (See Exhibit 15-1 for valid Peanut yield type
combinations).
Yield Limitation Flags 2 and 6 DO NOT APPLY to any crops. YIELD CAPS have been DISCONTINUED.
See Exhibit 15-6.
Yield CUPS (10% yield limitation) apply to ALL Category C, APH crops.
Notes con’t:
FCIC-APPENDIX III

15 - 10

RY 2008

June 28, 2007

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

Rate State and Rate County can only be different from Location State and County if a written agreement is in effect.
If the yield limitation flag equals “09” and the yield type equals “A, G, GW, PA, PW, R, V or VW”, then determine
the substituted yield value for the year(s) with that yield type.
If the yield year equals 2001 and prior: if all elements in state/county/crop/practice/type/map area are the same as
2001 ADM, then use the 2001 ADM T-yield to determine 60% T-yield substitution for yield years 2001 and prior,
use the 2002 ADM T-yield for state/county/crop/practice/type/map area if, at least, one element in the “key” is
new for 2002; use the 2003 ADM T-yield for state/county/crop/practice/type/map area if, at least, one element
in the “key” is new for 2003. Use the 2004 ADM T-yield for state/county/crop/practice/type/map area, if at least,
one element in the “key” is new for 2004.
If the yield year equals 2002, use the ADM for RY2002 to determine the applicable T-yield.
If the yield year equals 2003, use the ADM for RY2003 to determine the applicable T-yield.
If the yield year equals 2004, use the ADM for RY2004 to determine the applicable T-yield.
Organic Option
If a crop is being insured as Organic by Written Agreement do not report the organic code in the
Common Option field.
If a 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.)
Skip Row Code for Cotton: DAS Skip Row Code, Actual Row Width = Skip Row Code (6-byte field)
102
36
=
010236
TABLE 1 - These factors apply to Arkansas, Louisiana, Missouri, and all states east of these states.
Cropping Definition

Row Width 1/

Percent Planted to
Cotton

Yield
Factor

Solid-planted or non-qualifying skip row
patterns as determined by FSA or RMA

Less than 30 inches

100.00%

1.00

30 to 40 inch

66.67%

1.33

2 planted X 1 skipped

DAS Skip
Row Code

102

See Exhibit 15-2, page 16 for Hawaii Tropical Fruit reporting requirements.

FCIC-APPENDIX III

15 - 11

RY 2008