Yield Record - Type 15 - Format/Edits

June 18, 2004

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 Numb er

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, OT, 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 2005

June 18, 2004

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

18

Written Agreement Number

84

8

X(08)

For RMA issued Written Agreements enter
the identification number for the approved
written agreement for the RO, state, county
and crop. For company issued written
agreements, enter IP code followed by 6
digits, ONLY if the type equals SM, UA, NB,
TC or TS and the Written Agreement
Processing Flag equals ‘R’ or ‘W’.
The first 3 digits identify the issuing RO and
must be valid for the location state.
Enter spaces if No Written Agreement exists.

19

Written Agreement Processing
Flag

92

2

X(02)

20

Appendix IV Review Flag

94

2

9(02)

All single values must be left justified.
Must be:
H = ONLY for CRC High Risk land WITH a
FCI-2 Agreement that changes the
High Risk rate or factor. Use the High
Risk Classification Premium Calculation
Worksheet to calculate the premium.
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 zeros.

FCIC-APPENDIX III

15 - 2

RY 2005

June 18, 2004

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 Edit for Approved Yield)
K = Personal Transitional Yield (PTY)
for 5 counties in Montana only (no
ADM match for TYield)
L = Lag Year Planted for Sugar Cane and
Tobacco (crop 0236, type 061 in CT
& MA)
M = Master Yield
(No Edit For Approved Yield)
W = Average of Map Area T-Yields
(see Exhibit 15-2, page 10)
Blank = Not Applicable (Normal Approved
Yield)

15 - 3

RY 2005

June 18, 2004

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,T,E,I,N,X,H) or if the yield
limitation flag indicates a floored yield or one
or mo re substituted yields (Yield Limitation
Flag = 05,07,08,09).
If the Yield Limitation Flag equals “09”, the TYield 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,02,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.

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)

FCIC-APPENDIX III

15 - 4

RY 2005

June 18, 2004

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

27
28
29
30

Yield Type 1
Annual Yield 1
Yield Acres 1
Revenue Yield 1

31
32
33
34
35
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
61
62
63
64
65
66
67
68
69
70

Yield Year 2
Yield Type 2
Annual Yield 2
Yield Acres 2
Revenue Yield 2
Yield Year 3
Yield Type 3
Annual Yield 3
Yield Acres 3
Revenue Yield 3
Yield Year 4
Yield Type 4
Annual Yield 4
Yield Acres 4
Revenue Yield 4
Yield Year 5
Yield Type 5
Annual Yield 5
Yield Acres 5
Revenue Yield 5
Yield Year 6
Yield Type 6
Annual Yield 6
Yield Acres 6
Revenue Yield 6
Yield Year 7
Yield Type 7
Annual Yield 7
Yield Acres 7
Revenue Yield 7
Yield Year 8
Yield Type 8
Annual Yield 8
Yield Acres 8
Revenue Yield 8
Yield Year 9
Yield Type 9
Annual Yield 9
Yield Acres 9
Revenue Yield 9

FCIC-APPENDIX III

Size

Picture

Field Edits

142
144
154
162

2
10
8
6

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

168
172
174
184
192
198
202
204
214
222
228
232
234
244
252
258
262
264
274
282
288
292
294
304
312
318
322
324
334
342
348
352
354
364
372
378
382
384
394
402

4
2
10
8
6
4
2
10
8
6
4
2
10
8
6
4
2
10
8
6
4
2
10
8
6
4
2
10
8
6
4
2
10
8
6
4
2
10
8
6

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

Valid Yield Types are listed in exhibit 15-1.
See Exhibit 15-1 for valid values.
See Exhibit 15-1 for valid values.
Pecans: Enter the average per acre production
in whole pounds. Otherwise; zero fill.
See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield 1.
See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield 1.
See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield 1.
See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield 1.
See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield 1.
See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield 1.
See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield 1.
See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield 1.

15 - 5

RY 2005

June 18, 2004

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

See Yield Year 1.
See Yield Type 1.
See Annual Yield 1.
See Yield Acres 1.
See Revenue Yield 1.
Edit with the FIPS State table. See Notes.
Edit with the FIPS County table. See Notes.
Required for Peanuts (0075). Optional for
other crops. Must be a valid FSN or spaces.
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)
See Exhibit 15-2 for detailed edits.
Excessive Yield Edit Bypass: If approved or
annual yields exceed the lower yield
limitations (See Exhibit 15-3), enter
appropriate bypass 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

71
72
73
74
75
76
77
78

Yield Year 10
Yield Type 10
Annual Yield 10
Yield Acres 10
Revenue Yield 10
Rate State
Rate County
Farm Serial Number

408
412
414
424
432
438
440
443

4
2
10
8
6
2
3
7

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

79

Yield Limitation Flag

450

2

9(02)

80

Excessive Yield Edit Bypass

452

1

X(01)

81

Number of Years with Actual
Yields on Reference Records

453

2

9(02)

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.

82

Yield Index

455

4

S9(03)V9(01)

The yield index used to calculate the
Approved Yield for only, Indexed IP yields.
Otherwise, zero fill.

FCIC-APPENDIX III

15 - 6

RY 2005

June 18, 2004

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

83

Applicable Option Codes

459

16

X(16)

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.

84

Rate Yield

475

10

9(08)V9(02)

Required: Must be greater than zero.
For continuous rated plan codes this field
must equal Average APH Yield.
For non-continuous rated plan codes this
field must equal the Approved Yield.
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

Filler

497

54

X(54)

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)
02 Yield Cap
03 Yield Cup
04 Average APH Yield ( cap)
05 – 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.
00 Must be 00 ONLY if the previous
Approved Yield equals zeros.
Must be spaces.

FCIC-APPENDIX III

15 - 7

RY 2005

June 18, 2004

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

88

FCIC Control Time

551

4

9(04)

89

FCIC Control Date

555

8

9(08)

90

Reinsurance Year

563

4

9(04)

91

Batch Number

567

4

9(04)

92

Transaction Sequence Number

571

8

9(08)

93
94
95

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),
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.
Pecans – yield type ‘B’ for no records (4 years)
Only valid yield types for Pecans are: As, As with 1J or 4Bs.
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
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.
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, PA, PG, PV, R or V”, then determine the
substituted yield value for the year(s) with that yield type.

FCIC-APPENDIX III

15 - 8

RY 2005

June 18, 2004

Exhibit 15

FCIC-Appendix III

(YIELD RECORD – TYPE 15)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

Notes con’t:
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.
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.
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.)

FCIC-APPENDIX III

15 - 9

RY 2005