Record 27 Output Format

June 28, 2007

Exhibit 98-13

FCIC-Appendix III

(RECORD 27 OUTPUT FORMAT for ‘.acp, .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
Filler
Sub Type/Variety
Grid ID
Type 27 Key Reserve
Record Number
Type 11Record Number
Land Identifier Type 1
Farm Serial Number 1
Tract Number 1
Field Number 1
Sub Field Identifier 1
Reported Acres 1
Land Identifier Type 2
Farm Serial Number 2
Tract Number 2
Field Number 2
Sub Field Identifier 2
Reported Acres 2
Land Identifier Type 3
Farm Serial Number 3
Tract Number 3
Field Number 3
Sub Field Identifier 3
Reported Acres 3
Land Identifier Type 4
Farm Serial Number 4
Tract Number 4
Field Number 4
Sub Field Identifier 4
Reported Acres 4
Land Identifier Type 5
Farm Serial Number 5

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
41
42
43
44
45

FCIC-APPENDIX III

Begin
Pos

Size

Picture

Field Edits

1
3

2
2

9(02)
X(02)

Required. Must be 27.

5
7
10
17
21
25
27
30
35
38
41
42
50
53
61
76
79
82
83
90
97
101
104
112
113
120
127
131
134
142
143
150
157
161
164
172
173
180
187
191
194
202
203

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

9(02)
9(03)
9(07)
9(04)
9(04)
9(02)
9(03)
9(05)
9(03)
9(03)
X(01)
X(08)
9(03)
9(08)
X(15)
9(03)
9(03)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
27 - 1

RY 2008

June 28, 2007

Exhibit 98-13

FCIC-Appendix III

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

Field
No.

Field Name

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
80
81
82
83
84
85
86
87
88
89
90
91

Tract Number 5
Field Number 5
Sub Field Identifier 5
Reported Acres 5
Land Identifier Type 6
Farm Serial Number 6
Tract Number 6
Field Number 6
Sub Field Identifier 6
Reported Acres 6
Land Identifier Type 7
Farm Serial Number 7
Tract Number 7
Field Number 7
Sub Field Identifier 7
Reported Acres 7
Land Identifier Type 8
Farm Serial Number 8
Tract Number 8
Field Number 8
Sub Field Identifier 8
Reported Acres 8
Land Identifier Type 9
Farm Serial Number 9
Tract Number 9
Field Number 9
Sub Field Identifier 9
Reported Acres 9
Land Identifier Type 10
Farm Serial Number 10
Tract Number 10
Field Number 10
Sub Field Identifier 10
Reported Acres 10
Land Identifier Type 11
Farm Serial Number 11
Tract Number 11
Field Number 11
Sub Field Identifier 11
Reported Acres 11
Land Identifier Type 12
Farm Serial Number 12
Tract Number 12
Field Number 12
Sub Field Identifier 12
Reported Acres 12

FCIC-APPENDIX III

Begin
Pos

210
217
221
224
232
233
240
247
251
254
262
263
270
277
281
284
292
293
300
307
311
314
322
323
330
337
341
344
352
353
360
367
371
374
382
383
390
397
401
404
412
413
420
427
431
434

Size

Picture

7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8

X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
27 - 2

Field Edits

RY 2008

June 28, 2007

Exhibit 98-13

FCIC-Appendix III

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

Field
No.

Field Name

92
93
94
95
96
97
98
99
100
101
102
103
104

Land Identifier Type 13
Farm Serial Number 13
Tract Number 13
Field Number 13
Sub Field Identifier 13
Reported Acres 13
Land Identifier Type 14
Farm Serial Number 14
Tract Number 14
Field Number 14
Sub Field Identifier 14
Reported Acres 14
Filler

FCIC-APPENDIX III

Begin
Pos

Size

Picture

Field Edits

442
443
450
457
461
464
472
473
480
487
491
494
502

1
7
7
4
3
8
1
7
7
4
3
8
49

X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(49)

Must be spaces.

27 - 3

RY 2008

June 28, 2007

Exhibit 98-13

FCIC-Appendix III

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

Field
No.

Field Name

91
92
93
94
95

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

96
97
98

FCIC-APPENDIX III

Begin
Pos

Size

Picture

Field Edits

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
19

X(01)
X(01)
X(19)

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

27 - 4

RY 2008

June 28, 2007

Exhibit 98-13

FCIC-Appendix III

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

Field
No.

Field Name

74
75
76
77
78

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

79
80
81

FCIC-APPENDIX III

Begin
Pos

Size

Picture

Field Edits

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
19

X(01)
X(01)
X(19)

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

27 - 5

RY 2008