Record 21 Output Format

June 28, 2007

Exhibit 98 -10

FCIC-Appendix III

(RECORD 21 OUTPUT FORMAT for ‘.acp,.esc,.rej,.sus’)
Format/Edits
Field
No.

Field Name

1
2

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
Claim Number
Sub Type/Variety
Grid ID
Type 21 Key Reserve
Record Number
Type 11 Record Number
Adjuster SSN
Rate Class
Stage Code
100% Replant Payment
Flag
Stage Guarantee per Acre
Determined Acres/Tons
Gleaned Acreage Code
Filler
Loss Guarantee
Reported Unit Total
Guarantee
Loss Premium
Reserved
Reserved
Harvested Production
Reserved
Production to Count
Production to Count
Conversion for Revenue
Crops
(Bushels, Tons, etc...)
Farm Unit Deficiency
Insured Share
GRP/GRIP Payment
Calculation Factor

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

FCIC-APPENDIX III

Begin
Pos

Size

Picture

Field Edits

1
3

2
2

9(02)
X(02)

Must be 21.

5
7
10
17
21
25
27
30
35
38
41
42
50
53
61
76
79
82
91
94
96

2
3
7
4
4
2
3
5
3
3
1
8
3
8
15
3
3
9
3
2
1

9(02)
9(03)
9(07)
9(04)
9(04)
9(02)
9(03)
9(05)
9(03)
9(03)
X(01)
9(08)
9(03)
9(08)
X(15)
9(03)
9(03)
9(09)
X(03)
X(02)
X(01)

97
107
115
117
119
129

10
8
2
2
10
10

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

139
149
159
169
179
189
199

10
10
10
10
10
10
10

X(10)
X(10)
X(10)
9(08)V9(02)
X(10)
9(08)V9(02)
9(08)V9(02)

209
219
223

10
4
4

S9(08)V9(02)
9(01)V9(03)
9(01)V9(03)

21 - 1

RY 2008

June 28, 2007

Exhibit 98 -10

FCIC-Appendix III

(RECORD 21 OUTPUT FORMAT for ‘.acp,.esc,.rej,.sus’)
Format/Edits
Field
No.

Field Name

40
41
42
43
44

Indemnity
Sugar Factor
Audit Correction
Preliminary Indemnity
Multi Cropping Exception
Flag
Simplified Claim Flag
Farm Serial Number
Guarantee Reduction
Factor
Dollar Amount of
Insurance
Liability Adjustment
Factor
Contract Price
Guarantee Reduction Flag

45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67

Multiple Cropping Flag
Skip Row Code
Yield
Number of Trees
Coverage Level
Price Election Amount
Written Agreement
Number
Written Agreement Type
Written Agreement
Processing Flag
Valid for Escrow Flag
Price Election Factor
Filler
CEO Coverage Level
CEO Indemnity Factor
Price Indicator
Loss Adjuster Signature
Date

FCIC-APPENDIX III

Begin
Pos

Size

Picture

227
237
240
241
251

10
3
1
10
1

S9(10)
V9(03)
9(01)
S9(10)
X(01)

252
253
260

1
7
3

X(01)
X(07)
V9(03)

263

10

9(08)V9(02)

273

7

9(01)V9(06)

280
288

8
1

9(04)V9(04)
X(01)

289
291
296
306
316
321
329

2
5
10
10
5
8
8

X(02)
9(05)
9(08)V9(02)
9(10)
9(01)V9(04)
9(04)V9(04)
X(08)

337
339

2
2

X(02)
X(02)

341
342
347
349
354
360
361

1
5
2
5
6
1
8

X(01)
9(01)V9(04)
X(02)
9(01)V9(04)
9(01)V9(05)
X(01)
9(08)

21 - 2

Field Edits

.

RY 2008

June 28, 2007

Exhibit 98 -10

FCIC-Appendix III

(RECORD 21 OUTPUT FORMAT for ‘.acp,.esc,.rej,.sus’)
Format/Edits
Field
No.

Field Name

68
69
70
71
72

First Notice of Loss Date
Primary Date of Damage
Primary Cause
Primary Percent
Secondary Date of
Damage
Secondary Cause

73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92

Insured’s Signature Date
Second Crop Waived
Indemnity
Large Claim Flag
Settlement Flag
Misreported Information
Factor
Last Notice of Loss Date
Common Option Codes
Written Agreement Multi
Year Flag
Unit Liability Flag
Filler
Ineligible Tracking
Validation Flag
FCIC Control Time
FCIC Control Date
Reinsurance Year
Batch Number
Transaction Sequence
Number
Transaction Rejected Flag
Transaction Source Flag
Filler

FCIC-APPENDIX III

Begin
Pos

Size

Picture

369
377
385
387
390

8
8
2
3
8

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

398

2

9(02)

400
408

8
10

9(08)
S9(10)

418
419
420

1
1
7

X(01)
X(01)
9(01)V9(06)

427
435
455

8
20
1

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

Internal Use

456
457
543

1
86
8

X(01)
X(86)
X(08)

Internal Use. Reserved.

551
555
563
567
571

4
8
4
4
8

9(04)
9(08)
9(04)
9(04)
9(08)

Internal Use.
Internal Use. .
Internal Use.
Internal Use.
Internal Use.

579
580
581

1
1
20

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

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

21 - 3

Field Edits

RY 2008