Record 21 Output Format

June 18 2004

Exhibit 98-12

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
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
Filler
Loss Guarantee
Reserved
Reserved
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

FCIC-APPENDIX III

Begin
Pos

Size

Picture

Field Edits

1
3

2
2

9(02)
X(02)

Required. Must be 21.

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

2
3
7
4
4
2
3
5
3
3
1
8
26
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)
X(26)
9(03)
9(03)
9(09)
X(03)
X(02)
X(01)

97
107
115
119
129
139
149
159
169
179
189
199

10
8
4
10
10
10
10
10
10
10
10
10

9(08)V9(02)
9(06)V9(02)
X(04)
9(08)V9(02)
X(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

Must be spaces.

RY 2005

June 18 2004

Exhibit 98-12

FCIC-Appendix III

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

Field
No.

Field Name

37
38
39
40
41

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
Multiple Cropping Flag
Filler
Yield
Quota/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
Appendix IV Review Flag
CEO Coverage Level
CEO Indemnity Factor
Price Indicator
Loss Adjuster Signature
Date
Notice of Loss Date
Primary Date of Damage
Primary Cause
Primary Percent
Secondary Date of
Damage
Secondary Cause
Insured’s Signature Date
Second Crop Waived

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

FCIC-APPENDIX III

Begin
Pos

Size

Picture

227
237
240
241
251

10
3
1
10
1

S9(10)
V9(03)
9(01)
9(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)
X(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)
9(02)
9(01)V9(04)
9(01)V9(05)
X(01)
9(08)

369
377
385
387
390

8
8
2
3
8

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

398
400
408

2
8
10

9(02)
9(08)
S9(10)
21 - 2

Field Edits

Must be Spaces.

Internal Use. .
Must be zeros.

RY 2005

June 18 2004

Exhibit 98-12

FCIC-Appendix III

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

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

Indemnity

FCIC-APPENDIX III

21 - 3

RY 2005

June 18 2004

Exhibit 98-12

FCIC-Appendix III

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

Field
No.

Field Name

73
74
75
76
77
78
79
80
81
82
83

Begin
Pos

Size

Picture

Field Edits

Large Claim Flag
Settlement Flag
Filler

418
419
420

1
1
131

X(01)
X(01)
X(131)

Must be spaces.

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

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.

FCIC-APPENDIX III

21 - 4

RY 2005