Record 15 Output Format

June 28, 2007

Exhibit 98-7

FCIC-Appendix III

(RECORD 15 OUTPUT FORMAT for ‘.acp, .rej, .sus’)

Format/Edits
Field
No.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

Field Name

Record Type
Approved Insurance Provider
Location State
Policy Issuing Company
Policy Number
Crop Year
Crop Code
Insurance Plan Code
Location County
Unit Number
Type Code
Practice Code
Coverage Flag
Type 15 Key Reserve
Record Number
T Yield Map Area
Written Agreement Type
Written Agreement Number
Written Agreement Processing
Flag
Filler
Yield Indicator
Transitional Yield
FSA Yield
Approved Yield
Previous Approved Yield
Yield Year 1
Yield Type 1
Annual Yield 1
Yield Acres 1
Revenue Yield 1/Skip Row
Code 1
Yield Year 2
Yield Type 2
Annual Yield 2
Yield Acres 2
Revenue Yield 2/ Skip Row
Code 2
Yield Year 3
Yield Type 3
Annual Yield 3
Yield Acres 3
Revenue Yield 3/ Skip Row
Code 3

FCIC-APPENDIX III

Begin
Pos

Size

Picture

1
3
5
7
10
17
21
25
27
30
35
38
41
42
76
79
82
84
92

2
2
2
3
7
4
4
2
3
5
3
3
1
34
3
3
2
8
2

9(02)
X(02)
9(02)
9(03)
9(07)
9(04)
9(04)
9(02)
9(03)
9(05)
9(03)
9(03)
X(01)
X(34)
9(03)
X(03)
X(02)
X(08)
X(02)

94
96
98
108
118
128
138
142
144
154
162

2
2
10
10
10
10
4
2
10
8
6

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

168
172
174
184
192

4
2
10
8
6

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

198
202
204
214
222

4
2
10
8
6

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

15 - 1

Field Edits

Must be 15.

RY 2008

June 28, 2007

Exhibit 98-7

FCIC-Appendix III

(RECORD 15 OUTPUT FORMAT for ‘.acp, .rej, .sus’)

Format/Edits
Field
No.

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
71
72
73
74
75
76
77
78
79

Field Name

Yield Year 4
Yield Type 4
Annual Yield 4
Yield Acres 4
Revenue Yield 4/ Skip Row
Code 4
Yield Year 5
Yield Type 5
Annual Yield 5
Yield Acres 5
Revenue Yield 5/ Skip Row
Code 5
Yield Year 6
Yield Type 6
Annual Yield 6
Yield Acres 6
Revenue Yield 6/ Skip Row
Code 6
Yield Year 7
Yield Type 7
Annual Yield 7
Yield Acres 7
Revenue Yield 7/ Skip Row
Code 7
Yield Year 8
Yield Type 8
Annual Yield 8
Yield Acres 8
Revenue Yield 8/ Skip Row
Code 8
Yield Year 9
Yield Type 9
Annual Yield 9
Yield Acres 9
Revenue Yield 9/ Skip Row
Code 9
Yield Year 10
Yield Type 10
Annual Yield 10
Yield Acres 10
Revenue Yield 10/ Skip Row
Code 10
Rate State
Rate County
Farm Serial Number
Yield Limitation Flag

FCIC-APPENDIX III

Begin
Pos

Size

Picture

228
232
234
244
252

4
2
10
8
6

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

258
262
264
274
282

4
2
10
8
6

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

288
292
294
304
312

4
2
10
8
6

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

318
322
324
334
342

4
2
10
8
6

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

348
352
354
364
372

4
2
10
8
6

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

378
382
384
394
402

4
2
10
8
6

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

408
412
414
424
432

4
2
10
8
6

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

438
440
443
450

2
3
7
2

9(02)
9(03)
X(07)
9(02)
15 - 2

Field Edits

RY 2008

June 28, 2007

Exhibit 98-7

FCIC-Appendix III

(RECORD 15 OUTPUT FORMAT for ‘.acp, .rej, .sus’)

Format/Edits
Field
No.
80

Field Name

Begin
Pos

Size

Picture

452

1

X(01)

453

2

9(02)

82
83

Excessive Yield Edit
Verification
Number of Years with Actual
Yields on Reference Records
Filler
Applicable Option Codes

455
459

4
16

X(04)
X(16)

84

Rate Yield

475

10

9(08)V9(02)

85
86

Average Yield
Previous Yield Limitation
Flag
Yield Index
Perennial Year of Set Out
Perennial Leaf Year
Perennial Density
Perennial Block Number
Perennial Transitional Yield
Factor
Perennial Special Cases
Perennial, Other
Characteristics
Perennial Year of Grafting
Filler

485
495

10
2

9(08)V9(02)
9(02)

497
502
508
510
514
517

5
6
2
4
3
3

S9(03)V9(02)
9(06)
9(02)
9(04)
9(03)
9(01)V9(02)

520
523

3
1

X(03)
X(01)

524
530

6
21

9(06)
X(21)

81

87
88
89
90
91
92
93
94
95
95
96
97
98
99
100
101
102
103

FCIC Control Time
FCIC Control Date
Reinsurance Year
Batch Number
Transaction Sequence Number
Transaction Rejected Flag
Transaction Source Flag
Filler

FCIC-APPENDIX III

551
555
563
567
571
579
580
581

4
8
4
4
8
1
1
20

9(04)
9(08)
9(04)
9(04)
9(08)
X(01)
X(01)
X(20)

15 - 3

Field Edits

Internal Use.
Internal Use.
Internal Use.
Internal Use. .
Internal Use. .
Internal. Reserved
Internal. Reserved
Internal.

RY 2008