Download:
pdf |
pdfMarch 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2011
FCIC-Appendix III
POLICY KEY INFORMATION USED FOR ALL RECORD TYPES.
Field
No.
1
2
Field Name
Begin
Pos
Size
Picture
Field Edits
1
2
X(02)
Will be 81
3
RECORD TYPE
APPROVED INSURANCE
PROVIDER
POLICY STATE
3
5
2
2
X(02)
X(02)
4
POLICY PREFIX
7
3
X(03)
5
6
POLICY NUMBER
CROP YEAR
10
17
7
4
X(07)
9(04)
ALL DAS YEARS
LOCATION STATE for
Reinsured/FSA policy, RATE
STATE for FCIC policy. ALL
DAS YEARS
COMPANY/SERVICING
COUNTY for Reinsured/FSA
policy, RATE COUNTY for FCIC
policy. ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
PHT is designed to be an informational reporting tool for either a 1 year or 5 year inquiry request
for an active processing year. When a 1 Year inquiry request is submitted, the requestor will receive
only the previous year’s data information. When a 5 Year request is submitted, the requestor will
receive the previous 5 years, providing data is available. The layout of Record 81 with its respective
record types will not always be in the same order/sequence as the records submitted for editing.
The procedure is NOT designed to provide a specific year upon request.
Information retrieved from a PHT request – submitted with the type 10/14 record – is based ONLY
on the primary insurer’s SSN taken from the type 10 record. Limited information is provided on
SBI’s, affiliated with the primary insurer, not to include crop or cross-reference data.
PHT has been revised to provide a consolidated record layout descriptor for a single or five
(5) year report. Under the ‘Field Edit’ column will indicate which year that field was active. A
duplicate field number with an asterisk(*) beside it will indicate that ‘field position’ would
have had a different field name for the year indicated with the exception of the Type 15
record which reference the ‘field number’. PHTS now reflects Reinsurance Year 2011 record
layouts first for the record types and Reinsurance Years 2010 – 2007 following.
FCIC-Appendix III
1
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 10 RECORD DATA - POLICY PRODUCER
Field
No.
Field Name
Begin
Pos
Size
Picture
Field Edits
1
RECORD NUMBER
21
3
9(03)
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
BRANCH OFFICE
ID TYPE
ID NUMBER
ENTITY TYPE
PRODUCER LAST NAME
PRODUCER FIRST NAME
PRODUCER MIDDLE NAME
PRODUCER NAME SUFFIX
PRODUCER TITLE
BUSINESS NAME
ADDRESS LINE 1
ADDRESS LINE 2
CITY
ADDRESS STATE
ZIP CODE
ZIP EXTENSION
PHONE NUMBER
CO EMPLOYEE
INELIGIBLE SBI FLAG
FILLER
INELIGIBLE SBI SHARE
USDA COMMON
CUSTOMER ID
UNINSURABLE SBI FLAG
FILLER
FILLER
MEASUREMENT
SERVICE FLAG
AIP KEY PROD 10
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA
TYPE 10
24
26
27
36
37
62
82
102
112
127
177
242
277
312
314
319
323
333
334
335
337
341
2
1
9
1
25
20
20
10
15
50
65
35
35
2
5
4
10
1
1
2
4
6
X(02)
X(01)
X(09)
X(01)
X(25)
X(20)
X(20)
X(10)
X(15)
X(50)
X(65)
X(35)
X(35)
X(02)
X(05)
X(04)
X(10)
X(01)
X(01)
X(02)
9V9(03)
X(06)
Value for a Primary 10
record is ‘001’. Value for a
SBI record is ‘999’.
ALL DAS YEARS.
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
347
348
349
364
1
1
15
1
X(01)
X(01)
X(15)
X(01)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
365
380
526
530
X(15)
146
4
2
X(15)
X(146)
9(04)
X(02)
DAS 2011
DAS 2011
ALL DAS YEARS
MUST EQUAL 10.
ALL DAS YEARS
24
25
26
27
28
29
30
31
FCIC-Appendix III
2
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 10 RECORD DATA – POLICY PRODUCER cont’d
Field
No.
32
Field Name
CONTRACT NUMBER
Begin
Pos
Size
Picture
532
18
X(18)
Field Edits
From policy which initiated the
Inquiry. ALL DAS YEARS.
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number (FSA
Servicing County), Policy Number and Crop Year.
33
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is being retrieved
for the crop in the location county of
the originating Type 14 record
(see below). ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 10, 14
FCIC-Appendix III
3
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 11 RECORD DATA - ACREAGE
Field
No.
Field Name
Begin
Pos
1
2
3
4
5
6
7
8
9
10
11
12
13
14
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
BASIC UNIT NUMBER
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
RATE CLASS
MAP AREA
CRUSH DISTRICT
REFERENCE CROP YEAR
WRITTEN AGREEMENT TYPE
WRITTEN AGREEMENT NUMBER
WRITTEN AGREEMENT
PROCESSING FLAG
DATE PLANTED
GUARANTEE REDUCTION FLAG
YIELD
DOLLAR AMOUNT OF INSURANCE
QUOTA/NUMBER OF TREES
COVERAGE LEVEL
GUARANTEE PER ACRES
GUAR REDUCTION FACTOR
REPORTED ACRES/TONS
TOTAL GUARANTEE
PRICE ELECTION
CONTRACT PRICE
INSURED SHARE
LIABILITY
PRICE ELECTION FACTOR
YIELD CONVERSION FACTOR and
YLD INDEX for MAC TREES
BASE PREMIUM RATE
PRELIMINARY BASE RATE
LOADED PREMIUM PER ACRE
UNIT OPTION CODE
COMMON OPTION CODE
AIP KEY 14
FILLER
EXPERIENCE FACTOR
PREMIUM RATE SURCHARGE
UNIT PREM ADJUSTMENT FCTR
RA FALL HARVEST PRICE OPTION
FILLER
RA WHOLE FARM DISC FACTOR
21
25
27
30
38
41
44
45
48
51
53
57
59
68
4
2
3
8
3
3
1
3
3
2
4
2
9
2
9(04)
9(02)
9(03)
X(08)
9(03)
9(03)
X(01)
X(03)
X(03)
X(02)
9(04)
X(02)
X(09)
X(02)
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
70
78
79
89
100
110
115
125
128
136
147
155
163
167
177
182
8
1
10
11
10
5
10
3
8
11
8
8
4
10
5
4
9(08)
X(01)
9(08)V9(02)
9(09)V9(02)
9(10)
9(01)V9(04)
9(08)V9(02)
V9(03)
9(06)V9(02)
9(09)V9(02)
9(04)V9(04)
9(04)V9(04)
9V9(03)
9(10)
9(01)V9(04)
9(01)V9(03)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
186
195
203
211
213
233
248
253
257
258
263
264
272
9
8
8
2
20
15
5
4
1
5
1
8
5
9(01)V9(08)
V9(08)
9(04)V9(04)
X(02)
X(20)
X(15)
X(05)
9(01)V9(03)
X(01)
9V9(04)
X(01)
X(08)
9V9(04)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
36a
37
38
39
40
41
42
FCIC-Appendix III
4
Size
Picture
Field Edits
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 11 RECORD DATA –ACREAGE cont’d
Field
No.
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
Field Name
Begin
Pos
TOTAL PREMIUM
SUBSIDY
PRODUCER PREMIUM
PRIVATE POLICY CODE
INTENDED/ZERO ACREAGE FLAG
SEED COMPANY CODE
FARM SERIAL NUMBER
NUMBER OF SECTIONS
SEED CYCLE CODE
CEO COVERAGE LEVEL
PRORATION FACTOR
HISTORICAL PACKOUT FACTOR
RATE YIELD
PRICE INDICATOR
INSURED ACREAGE REPORT
SIGNATURE DATE
RESIDUAL FACTOR
LAND LOCATION ID TYPE
LAND LOCATION
MULTIPLE CROPPING FLAG
CROP STATUS
INTENDED USE
VARIETY/TYPE
LAND USE
OFFICIAL MEASURED
FIELD ID
QUALIFYING PREVENTED
PLANTING CROP
UNIT NBR OF QUALIFYING PP CROP
ADDITIONAL SUBSIDY FLAG
ADDITIONAL SUBSIDY
AGENT’S SIGNATURE DATE
MODIFIED ACREAGE RECORD FLAG
UNIT LIABILITY
CIMS CURRENT YEAR
INFORMATION REQUEST
FSA ADMINISTRATIVE STATE
FSA ADMINISTRATIVE COUNTY
FCIC-Appendix III
5
Size
Picture
Field Edits
277
287
297
307
310
311
314
321
323
324
329
333
336
346
347
10
10
10
3
1
3
7
2
1
5
4
3
10
1
8
9(10)
9(10)
9(10)
X(03)
X(01)
9(03)
X(07)
9(02)
X(01)
9(01)V9(04)
9V9(03)
9V9(02)
9(08)V9(02)
X(01)
9(08)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
355
359
360
378
380
383
385
388
389
390
392
4
1
18
2
3
2
3
1
1
2
4
9(01)V9(03)
X(01)
X(18)
X(02)
X(03)
X(02)
X(03)
X(01)
X(01)
X(02)
9(04)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
396
404
405
415
423
425
435
8
1
10
8
2
10
1
X(08)
X(01)
9(10)
9(08)
9(02)
9(10)
X(01)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
436
438
2
3
9(02)
9(03)
DAS 2011
DAS 2011
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 11 RECORD DATA –ACREAGE cont’d
Field
No.
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
Field Name
Begin
Pos
SUB TYPE/VARIETY
GRID ID
SKIP ROW CODE
FILLER
PEANUT WAREHOUSE CODE
A&O EXPENSE SUBSIDY
APH PROCEDURAL EXCEPTION CODE
APH PROCEDURAL EXCEPTION NBR
SETTLEMENT FLAG
CAT LOSS ADJUSTMENT EXPENSE AMT
AIP KEY 11
AIP KEY 15
PEANUT PROCESSING FLAG
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA TYPE 11
CONTRACT NUMBER
Size
441
444
452
457
458
463
475
476
479
480
492
507
522
523
526
530
532
3
8
5
1
5
12
1
3
1
12
15
15
1
3
4
2
18
Picture
Field Edits
9(03)
DAS 2011
9(08)
DAS 2011
9(05)
DAS 2011
9(01)
DAS 2011
X(05)
DAS 2011
9(10)V9(02) DA
DAS 2011
X(01)
DAS 2011
X(03)
DAS 2011
X(01)
DAS 2011
9(10)V9(02) DAS 2011
X(15)
DAS 2011
X(15)
DAS 2011
X(01)
DAS 2011
X(05)
DAS 2011
9(04)
ALL DAS YEARS
X(02)
MUST EQUAL 11
X(18)
From policy which
initiated the inquiry.
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
95
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is
being retrieved for the
crop in the location
county of the
originating Type 14
record. (see below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
6
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 13 RECORD DATA – INVENTORY VALUE
Field
No.
1
2
3
4
5
6
7
7a
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
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
FILLER
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
FILLER
WRITTEN AGREEMENT
TYPE
FILLER
WRITTEN AGREEMENT
PROCESSING FLAG
REVISED REPORT
VALUE/INVENTORY
VALUE
PREVIOUS YEAR SALES
COVERAGE LEVEL
PRICE ELECTION FACTOR
INSURED SHARE
AMOUNT OF INSURANCE
FILLER
UNIT OPTION CODE
COMMON OPTION CODES
BASE PREMIUM RATE
FILLER
TOTAL PREMIUM
SUBSIDY
PRODUCER PREMIUM
INSURED’S INVENTORY
PEAK COMMENCEMENT
DATE
PEAK TERMINATION DATE
LIABILITY EXCLUDING
PRICE & SHARE (XPS)/
DAS AMT OF INS
CROP YEAR DEDUCTIBLE
FILLER
FILLER
SURVIVAL FACTOR
SURVIVAL FACTOR FLAG
NUMBER OF CLAMS
FCIC-Appendix III
Begin
Pos
Size
Picture
21
25
27
30
35
38
41
42
45
4
2
3
5
3
3
1
3
2
9(04)
9(02)
9(03)
X(05)
9(03)
9(03)
X(01)
X(03)
X(02)
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
47
55
8
2
X(08)
X(02)
DAS 2011
DAS 2011
57
58
1
9
X(01)
9(09)
DAS 2011
DAS 2011
67
76
81
86
90
100
104
106
126
135
137
147
157
167
175
9
5
5
4
10
4
2
20
9
2
10
10
10
8
8
9(09)
9(01)V9(04)
9(01)V9(04)
9(01)V9(03)
9(10)
X(04)
X(02)
X(20)
9(01)V9(08)
X(02)
9(10)
9(10)
9(10)
9(08)
9(08)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
183
191
8
10
9(08)
9(10)
DAS 2011
DAS 2011
201
211
213
222
226
227
10
2
9
4
1
8
9(10)
X(02)
X(09)
9(01)V9(03)
X(01)
9(08)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
7
Field Edits
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 13 RECORD DATA –INVENTORY VALUE cont’d
Field
No.
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
Field Name
PRICE ELECTION AMOUNT
FILLER
ADDITIONAL SUBSIDY
FLAG
ADDITIONAL SUBSIDY
STATE/PRIVATE
SUBSIDY FLAG
STATE/PRIVATE SUBSIDY
AGENT’ SIGNATURE DATE
ORIGINAL INVENTORY
VALUE
BASIC UNIT NUMBER
WRITTEN AGREEMENT
NUMBER
PRORATION FACTOR
SETTLEMENT FLAG
A&O EXPENSE SUBSIDY
AMT
CAT LOSS ADJ EXPSE AMT
UNIT DIVISION
AIP KEY 13
AIP KEY 10
AIP KEY 14
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA
TYPE 13
CONTRACT NUMBER
Begin
Pos
Size
Picture
Field Edits
235
243
244
8
1
1
9(04)V9(04)
X(01)
X(01)
DAS 2011
DAS 2011
DAS 2011
245
255
10
1
9(10)
X(01)
DAS 2011
DAS 2011
256
266
274
10
8
9
9(10)
9(08)
9(09)
DAS 2011
DAS 2011
DAS 2011
283
291
8
9
X(08)
X(09)
DAS 2011
DAS 2011
300
304
305
4
1
12
9(01)V9(03)
X(01)
9(10)V9(02)
DAS 2011
DAS 2011
DAS 2011
317
329
330
345
360
375
526
530
12
1
15
15
15
151
4
2
9(10)V9(02)
X(01)
X(15)
X(15)
X(15)
X(151)
9(04)
X(02)
532
18
X(18)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
ALL DAS YEARS
Must equal 13
ALL DAS YEARS
From policy which
initiated the inquiry.
ALL DAS Years
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
58
MESSAGE CODE
MESSAGE
CODE
N
P
S
FCIC-Appendix III
550
1
X(01)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
8
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 14 RECORD DATA – INSURANCE IN FORCE
Field
No.
Field Name
Begin
Pos
Size
Picture
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
FILLER
LATE PROCESSED FLAG
FUND DESIGNATION FLAG
FEE PREPAYMENT FLAG
ADMIN FEE FLAG
FILLER
FILLER
DUAL COVERAGE FLAG
INSURED’S SIGNATURE DATE
FOR CROP
CONTRACT FLAG
EXPERIENCE INQUIRY
WRITTEN AGREEMENT FLAG
FILLER
WRITTEN AGREEMENT TYPE
ADDED COUNTY FLAG
21
25
27
30
33
36
37
40
42
43
44
45
47
50
51
4
2
3
3
3
1
3
2
1
1
1
2
3
1
8
9(04)
9(02)
9(03)
9(03)
9(03)
X(01)
X(03)
9(02)
9(01)
X(01
X(01)
X(02)
X(03)
X(01)
9(08)
59
60
61
63
71
73
74
75
80
85
87
107
127
135
136
143
144
146
149
1
1
2
8
2
1
1
5
5
2
20
20
8
1
7
1
2
3
7
X(01)
X(01)
X(02)
X(08)
X(02)
X(01)
X(01)
156
4
9(04)
DAS 2011
160
4
9(04)
DAS 2011
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
CANCEL/TRANSFER APPLICATION
COVERAGE LEVEL
PRICE ELECTION FACTOR
FILLER
COMMON OPTION CODES
RATE CLASS OPTIONS CODES
WRITTEN AGREEMENT DATE
FILLER
MARKETING ACTIVITY TYPE
PRICE INDICATOR
ADDED COUNTY REFERENCE STATE
FILLER
ADDED COUNTY REFERENCE
POLICY NUMBER
ADDED COUNTY REFERENCE
CROP YEAR
ADDED COUNTY REFERENCE
CROP CODE
FCIC-Appendix III
9
Field Edits
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
9(01)V9(04) DAS 2011
9(01)V9(04) DAS 2011
X(02)
DAS 2011
X(20)
DAS 2011
X(20)
DAS 2011
9(08)
DAS 2011
X(01)
DAS 2011
X(07)
DAS 2011
X(01)
DAS 2011
9(02)
DAS 2011
9(03)
DAS 2011
9(07)
DAS 2011
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 14 RECORD DATA - INSURANCE IN FORCE cont’d
Field
No.
Field Name
37
ADDED COUNTY REFERENCE
LOCATION COUNTY
ADDED COUNTY REFERENCE
TYPE CODE FLAG
AGENT’S SIGNATURE DATE
WRITTEN AGREEMENT MULTI
YEAR FLAG
DISPUTE NOTIFICATION FLAG
DATE AIP NOTIFIED OF DISPUTE
FSA ADMINISTRATIVE STATE
FSA ADMINISTRATIVE COUNTY
DIFFERENCE FLAG 1
WRITTEN AGREEMENT NUMBER
PRODUCER HISTORY FLAG
AIP KEY 14
AIP KEY 10
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA TYPE 14
CONTRACT NUMBER
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
Begin
Pos
Size
Picture Field Edits
164
3
9(03)
DAS 2011
167
3
9(03)
DAS 2011
170
178
8
1
9(08)
X(01)
DAS 2011
DAS 2011
179
180
188
190
193
195
204
210
225
240
526
530
532
1
8
2
3
2
9
6
15
15
286
4
2
18
X(01)
9(08)
9(02)
9(03)
X(02)
X(09)
X(06)
X(15)
X(15)
X(286)
9(04)
X(02)
X(18)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
All DAS Years
must equal 14
from policy which
initiated the inquiry.
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
54
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is being retrieved
for the crop in the location county of
the originating Type 14 record.
(See below)
All DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
10
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 15 RECORD DATA - YIELD
Field
No.
Field Name
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
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
T YIELD MAP AREA
WRITTEN AGREEMENT TYPE
WRITTEN AGREEMENT PROC FLAG
YIELD INDICATOR
TRANSITIONAL YIELD
FSA YIELD
APPROVED YIELD
PREVIOUS APPROVED YIELD
YIELD YEAR 1
YIELD TYPE 1
ANNUAL YIELD 1
YIELD ACRE 1
REVENUE YIELD/SKIP ROW CODE 1
YIELD YEAR 2
YIELD TYPE 2
ANNUAL YIELD 2
YIELD ACRE 2
REVENUE YIELD/SKIP ROW CODE 2
YIELD YEAR 3
YIELD TYPE 3
ANNUAL YIELD 3
YIELD ACRE 3
REVENUE YIELD/SKIP ROW CODE 3
YIELD YEAR 4
YIELD TYPE 4
ANNUAL YIELD 4
YIELD ACRE 4
REVENUE YIELD/SKIP ROW CODE 4
YIELD YEAR 5
YIELD TYPE 5
ANNUAL YIELD 5
YIELD ACRE 5
REVENUE YIELD/SKIP ROW CODE 5
FCIC-Appendix III
Begin
Pos
21
25
27
30
33
36
37
40
42
44
46
56
66
76
86
90
92
102
110
116
120
122
132
140
146
150
152
162
170
176
180
182
192
200
206
210
212
222
230
11
Size
4
2
3
3
3
1
3
2
2
2
10
10
10
10
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
Picture
9(04)
9(02)
9(03)
9(03)
9(03)
X(01)
X(03)
X(02)
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)
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)
Field Edits
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 15 RECORD DATA – YIELD cont’d
Field
No.
Field Name
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
YIELD YEAR 6
YIELD TYPE 6
ANNUAL YIELD 6
YIELD ACRE 6
68
69
70
71
72
73
74
Begin
Pos
Size
Picture
Field Edits
236
240
242
252
260
266
270
272
282
290
296
300
302
312
320
326
330
332
342
350
356
360
362
372
380
386
393
395
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
7
2
1
9(04)
X(02)
9(06)
X(07)
9(02)
X(01)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
NUMBER OF YEARS W/ ACTUAL
YIELDS ON REFERENCE RECORDS
396
2
9(020
DAS 2011
YIELD INDEX
APPLICABLE OPTION CODES
RATE YIELD
FILLER
AVERAGE YIELD
PREVIOUS YLD LIMITATION FLG
398
403
419
429
432
442
5
16
10
3
10
2
S9(03)V9(02) DAS 2011
REVENUE YIELD/SKIP ROW CODE 6
YIELD YEAR 7
YIELD TYPE 7
ANNUAL YIELD 7
YIELD ACRE 7
REVENUE YIELD/SKIP ROW CODE 7
YIELD YEAR 8
YIELD TYPE 8
ANNUAL YIELD 8
YIELD ACRE 8
REVENUE YIELD/SKIP ROW CODE 8
YIELD YEAR 9
YIELD TYPE 9
ANNUAL YIELD 9
YIELD ACRE 9
REVENUE YIELD/SKIP ROW CODE 9
YIELD YEAR 10
YIELD TYPE 10
ANNUAL YIELD 10
YIELD ACRE 10
REVENUE YIELD/SKIP ROW CODE 10
FARM SERIAL NUMBER
YIELD LIMITATION FLAG
EXCESSIVE YIELD EDIT
VERIFICATION
FCIC-Appendix III
12
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)
X(16)
9(08)V9(02)
X(03)
9(08)V9(02)
9(02)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 15 RECORD DATA - YIELD cont’d
Field
No.
Field Name
Begin
Pos
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
PERENNIAL YEAR OF SET OUT
PERENNIAL LEAF YEAR
PERENNIAL DENSITY
PERENNIAL BLOCK NUMBER
90
Size
PERENNIAL YEAR OF GRAFTING
WRITTEN AGREEMENT NUMBER
UNIT NUMBER
AIP KEY 15
AIP KEY 14
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA TYPE 15
444
450
452
456
459
462
465
466
472
481
489
504
519
526
530
6
2
4
3
3
3
1
6
9
8
15
15
7
4
2
CONTRACT NUMBER
532
18
PERENNIAL TRANS YIELD FACTOR
PERENNIAL SPECIAL CASES
PEREN OTHER CHARACTERISTICS
Picture
Field Edits
9(06)
9(02)
9(04)
9(03)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
9(01)V9(02) DAS 2011
9(03)
DAS 2011
X(01)
DAS 2011
9(06)
DAS 2011
X(09)
DAS 2011
X(08)
DAS 2011
X(15)
DAS 2011
X(15)
DAS 2011
X(07)
DAS 2011
9(04)
ALL DAS YEARS
X(02)
Must equal 15
ALL DAS YEARS
From policy which
X(18)
initiated the inquiry.***
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
91
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is being
retried for the crop in the
location county of the
originating Type 14 record.
(See below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
13
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 17 RECORD DATA – LAND ID
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
41
42
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
UNIT NUMBER
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
LAND IDENTIFIER TYPE 1
LAND IDENTIFIER 1
LAND IDENTIFIER TYPE 2
LAND IDENTIFIER 2
LAND IDENTIFIER TYPE 3
LAND IDENTIFIER 3
LAND IDENTIFIER TYPE 4
LAND IDENTIFIER 4
LAND IDENTIFIER TYPE 5
LAND IDENTIFIER 5
LAND IDENTIFIER TYPE 6
LAND IDENTIFIER 6
LAND IDENTIFIER TYPE 7
LAND IDENTIFIER 7
LAND IDENTIFIER TYPE 8
LAND IDENTIFIER 8
LAND IDENTIFIER TYPE 9
LAND IDENTIFIER 9
LAND IDENTIFIER TYPE 10
LAND IDENTIFIER 10
PERSON SHARING 1
PERSON SHARING 2
PERSON SHARING 3
LATITUDE 1
LONGITUDE 1
LATITUDE 2
LONGITUDE 2
LATITUDE 3
LONGITUDE 3
LATITUDE 4
LONGITUDE 4
LATITUDE 5
LONGITUDE 5
LATITUDE 6
LONGITUDE 6
FCIC-Appendix III
Begin
Pos
21
25
27
30
38
41
44
45
46
64
65
83
84
102
103
121
122
140
141
159
160
178
179
197
198
216
217
235
265
295
325
333
341
349
357
365
373
381
389
397
405
413
Size
4
2
3
8
3
3
1
1
18
1
18
1
18
1
18
1
18
1
18
1
18
1
18
1
18
1
18
30
30
30
8
8
8
8
8
8
8
8
8
8
8
8
14
Picture
9(04)
9(02)
9(03)
X(08)
9(03)
9(03)
X(01)
X(01)
X(18)
X(01)
X(18)
X(01)
X(18)
X(01)
X(18)
X(01)
X(18)
X(01)
X(18)
X(01)
X(18)
X(01)
X(18)
X(01)
X(18)
X(01)
X(18)
X(30)
X(30)
X(30)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
Field Edits
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 17 RECORD DATA – LAND ID cont’d
Field
No.
43
44
45
46
47
48
49
50
51
52
53
54
55
56
Field Name
Begin
Pos
LATITUDE 7
LONGITUDE 7
LATITUDE 8
LONGITUDE 8
LATITUDE 9
LONGITUDE 9
LATITUDE 10
LONGITUDE 10
AIP KEY 17
AIP KEY 11
FILLER
REINSURANCE YEAR
421
429
437
445
453
461
469
477
485
500
515
526
POLICYHOLDER DATA TYPE 17 530
CONTRACT NUMBER
532
Size
Picture
8
8
8
8
8
8
8
8
15
15
11
4
2
18
Field Edits
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(15)
X(15)
X(11)
9(04)
X(02)
X(18)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
ALL DAS YEARS
Must equal 17
From policy which
initiated the inquiry.***
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
57
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is being
retried for the crop in the
location county of the
originating Type 14 record.
(See below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
15
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 21 RECORD DATA – PRODUCTION LOSS DETAIL
Field
No.
Begin
Pos
Size
21
25
27
30
33
36
37
45
48
50
51
61
71
81
91
95
4
2
3
3
3
1
8
3
2
1
10
10
10
10
4
4
9(04)
9(02)
9(03)
9(03)
9(03)
X(01)
9(08)
X(03)
X(02)
X(01)
9(08)V9(02)
9(08)V9(02)
9(08)V9(02)
S9(08)V9(02)
9(01)V9(03)
9(01)V9(03)
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
99
109
119
120
122
124
125
132
10
10
1
2
2
1
7
10
S9(10)
9(08)V9(02)
9(01)
9(02)
9(02)
X(01)
X(07)
9(08)V9(02)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
25
26
27
28
29
30
31
32
33
DOLLAR AMOUNT INSURANCE
142
LIABILITY ADJUSTMENT FACTOR 152
159
167
177
187
192
200
202
10
7
8
10
10
5
8
2
2
9(08)V9(02)
9(01)V9(06)
9(04)V9(04)
9(08)V9(02)
9(10)
9(01)V9(04)
9(04)V9(04)
X(02)
X(02)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
34
35
36
37
38
39
204
209
214
220
221
222
5
5
6
1
1
8
9(01)V9(04)
9(01)V9(04)
9(01)V9(05)
X(01)
X(01)
9(08)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
230
8
9(08)
DAS 2011
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
40
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
CLAIM NUMBER
RATE CLASS
STAGE CODE
100% REPLANT PAYMENT FLAG
STAGE GUARANTEE PER ACRE
LOSS GUARANTEE
PRODUCTION TO COUNT
FARM UNIT DEFICIENCY
INSURED SHARED
GRP/GRIP PAYMENT
CALC FACTOR
INDEMNITY
HARVESTED PRODUCTION
AUDIT CORRECTION
PRIMARY MONTH
SECONDARY MONTH
SIMPLIFIED CLAIM FLAG
FARM SERIAL NUMBER
PRODUCTION TO COUNT
CONVERSION FOR
REVENUE CROPS
CONTRACT PRICE
YIELD
QUOTA /NUMBER OF TREES
COVERAGE LEVEL
PRICE ELECTION AMOUNT
WRITTEN AGREEMENT TYPE
WRITTEN AGREEMENT
PROC FLAG
PRICE ELECTION FACTOR
CEO COVERAGE LEVEL
CEO INDEMNITY FACTOR
GUARANTEE REDUCTION FLAG
PRICE INDICATOR
LOSS ADJUSTER
SIGNATURE DATE
FIRST NOTICE OF LOSS DATE
FCIC-Appendix III
16
Picture
Field Edits
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 21 RECORD DATA – PRODUCTION LOSS DETAIL cont’d
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
Field Name
Begin
Pos
Size
238
246
248
SECONDARY DATE OF DAMAGE 251
SECONDARY CAUSE
259
MULTI CROPPING FLAG
261
INSURED’S SIGNATURE DATE 263
PRELIMINARY INDEMNITY
271
MULTI CROPPING EXCEPTION FLAG
281
SECOND CROP WAIVED
282
INDEMNITY
LARGE CLAIM FLAG
292
SETTLEMENT FLAG
293
MISREPORTED INFORMATION 294
FACTOR
LAST NOTICE OF LOSS DATE 301
COMMON OPTION CODES
309
WRITTEN AGREE MULT329
YEAR FLAG
UNIT LIABILITY FLAG
330
SUB TYPE/VARIETY
331
GRID ID
334
GLEANED ACREAGE CODE
342
UNIT LIABILITY
344
LOSS PREMIUM
354
SKIP ROW CODE
364
DETERMINED ACRES/TONS
369
SUGAR FACTOR
379
GUARANTEE REDUCTION
383
FACTOR
WRITTEN AGREEMENT NUMBER 387
UNIT NUMBER
396
TERTIARY CAUSE
404
TERTIARY PERCENT
406
SECONDARY PERCENT
409
AIP KEY 21
412
AIP KEY 14
427
AIP KEY 11
442
AIP KEY 10
457
FILLER
472
8
2
3
8
2
2
8
10
1
10
9(08)
9(02)
9(01)V9(02)
9(08)
9(02)
X(02)
9(08)
S9(10)
X(01)
S9(10)
DAS 2011
DAS 2011
DAS 2011
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
ALL DAS YEARS
ALL DAS YEARS
1
1
7
X(01)
X(01)
9(01)V9(06)
DAS 2011
DAS 2011
DAS 2011
8
20
1
9(08)
X(20)
X(01)
DAS 2011
DAS 2011
DAS 2011
1
3
8
2
10
10
5
10
4
4
X(01)
9(03)
9(08)
X(02)
9(10)
9(10)
9(05)
9(08)V9(02)
9(01)V9)03)
9(01)V9(03)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
9
8
2
3
3
15
15
15
15
54
X(09)
X(08)
X(02)
9(01)V9(02)
9(01)V9(02)
X(15)
X(15)
X(15)
X(15)
X(54)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
PRIMARY DATE OF DAMAGE
PRIMARY CAUSE
PRIMARY PERCENT
FCIC-Appendix III
17
Picture
Field Edits
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 21 RECORD DATA – PRODUCTION LOSS DETAIL cont’d
Field
No.
77
78
79
Field Name
REINSURANCE YEAR
Begin
Pos
526
POLICYHOLDER DATA TYPE 21 530
CONTRACT NUMBER
532
Size
4
2
18
Picture
9(04)
X(02)
X(18)
Field Edits
ALL DAS YEARS
Must equal 21
From policy which
initiated the inquiry.***
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
80
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is being
retried for the crop in the
location county of the
originating Type 14 record.
(See below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
18
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 22 RECORD DATA – INVENTORY LOSS DETAIL
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
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
FILLER
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
CLAIM NUMBER
FILLER
FILLER
PRIMARY DATE OF DAMAGE
PRIMARY CAUSE
PRIMARY PERCENT
SECONDARY CAUSE
OPTIONAL UNITS
INSPECTION NUMBER
BASIC UNIT VALUE
EFFECTIVE XPS LIABILITY/
EFFECTIVE AMOUNT OF
INSURANCE
EFFECTIVE CROP YEAR
DEDUCTIBLE
BASIC UNIT VALUE FOR CLAMS
UNDER REPORTING FACTOR
FIELD MARKET VALUE A/
UNIT VALUE BEFORE LOSS
FIELD MARKET VALUE B/
UNIT VALUE AFTER LOSS
ADJUSTED LOSS
OCCURRENCE DEDUCTIBLE
UNADJUSTED INDEMNITY
PRELIMINARY INDEMNITY
INSURED SHARE
PRICE ELECTION FACTOR
INDEMNITY
FILLER
LOSS ADJUSTER SIGNATURE
DATE
FCIC-Appendix III
Begin
Pos
Size
21
25
27
30
35
38
41
42
50
53
56
64
66
69
71
72
74
84
4
2
3
5
3
3
1
8
3
3
8
2
3
2
1
2
10
10
9(04)
9(02)
9(03)
X(05)
9(03)
9(03)
X(01)
9(08)
X(03)
X(03)
9(08)
9(02)
9(01)V(02)
9(02)
X(01)
9(02)
9(10)
9(10)
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
DAS 2011
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
ALL DAS YEARS
94
9
9(09)
ALL DAS YEARS
103
112
116
9
4
9
9(09)
ALL DAS YEARS
9(09)
ALL DAS YEARS
125
9
S9(09)
ALL DAS YEARS
134
144
153
163
173
177
182
192
194
10
9
10
10
4
5
10
2
8
9(10)
9(09)
S9(10)
S9(10)
19
Picture
Field Edits
9(01)V9(03) ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
9(01)V9(03) ALL DAS YEARS
9(01)V9(04) ALL DAS YEARS
S9(10)
ALL DAS YEARS
X(02)
ALL DAS YEARS
9(08)
ALL DAS YEARS
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 22 RECORD DATA – INVENTORY LOSS DETAIL cont’d.
Field
No.
Field Name
33
34
NOTICE OF LOSS DATE
SECONDARY DATE OF
DAMAGE
INSURED’S SIGNATURE DATE
FOR THE CLAIM
LARGE CLAIM FLAG
COVERAGE LEVEL
SETTLEMENT FLAG
REHAB PLANT VALUE
OPTION CODES
MULTIPLE REHAB PAYMENTS
ACTUAL REHAB COST
CALCULATION STATUS
REPORTING FACTOR FLAG
BASIC UNIT NUMBER
TERTIARY CAUSE OF LOSS
CODE
TERTIARY DAMAGE DATE
TERTIARY PERCENT
SECONDARY PERCENT
AIP KEY 22
AIP KEY 14
AIP KEY 13
AIP KEY 10
FILLER
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
FCIC-Appendix III
Begin
Pos
Size
202
210
8
8
9(08)
9(08)
ALL DAS YEARS
ALL DAS YEARS
218
8
9(08)
ALL DAS YEARS
226
227
232
233
243
253
254
264
265
273
281
1
5
1
10
10
1
10
1
8
8
2
X(01)
ALL DAS YEARS
X(01)
9(10)
X(10)
X(01)
9(10)
X(01)
X(08)
X(08)
X(02)
ALL DAS YEARS
ALL DASA YEARS
ALL DASA YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2011
DAS 2011
DAS 2011
283
291
294
297
312
327
342
357
8
3
3
15
15
15
15
169
X(08)
DAS 2011
20
Picture
Field Edits
9(01)V9(04) ALL DAS YEARS
9(01)V9(02) DAS 2011
9(01)V9(02) DAS 2011
X(15)
X(15)
X(15)
X(15)
X(169)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 22 RECORD DATA – INVENTORY LOSS DETAIL cont’d
Field
No.
55
56
57
Field Name
REINSURANCE YEAR
Begin
Pos
526
POLICYHOLDER DATA TYPE 22 530
CONTRACT NUMBER
532
Size
4
2
18
Picture
9(04)
X(02)
X(18)
Field Edits
ALL DAS YEARS
Must equal 22
From policy which
initiated the inquiry.***
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
58
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is being
retried for the crop in the
location county of the
originating Type 14 record.
(See below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
21
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 27 RECORD DATA – LAND RECORD
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
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
FILLER
FILLER
GRID ID
FILLER
LAND IDENTIFIER TYPE
FSA FARM SERIAL TYPE
FSA TRACT NUMBER
FSA FIELD NUMBER
FSA SUB FIELD IDENTIFIER
REPORTED ACRED
INTENDED USE
DATE PLANTED
IRRIGATION INDICATOR
UNIQUE CLU ID
PERSONS SHARING 1
PERSONS SHARING 2
RMA/FSA ENTITY DIFFERENCE
FLAG 1
RMA/FSA ACREAGE DIFF FLG 2
X CENTROID
Y CENTROID
FSA ADMINISTRATIVE STATE
FSA ADMINISTRATIVE CNTY
CLU DETERMINATION
BASIC UNIT NUMBER
AIP KEY 27
AIP KEY 14
AIP KEY 11
AIP KEY 13
AIP KEY 10
FILLER
FCIC-Appendix III
Begin
Pos
Size
Picture
21
25
27
30
35
53
61
68
69
76
83
87
90
98
100
108
109
145
180
215
4
2
3
5
18
8
7
1
7
7
4
3
8
2
8
1
36
35
35
2
9(04)
9(02)
9(03)
X(05)
X(18)
X(08)
X(07)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(02)
9(08)
X(01)
X(36)
X(35)
X(35)
X(02)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
217
219
231
243
245
248
249
257
272
287
302
317
332
2
12
12
2
3
1
8
15
15
15
15
15
194
X(02)
9(06)V9(06)
9(07)V9(05)
9(02)
9(03)
X(01)
X(08)
X(15)
X(15)
X(15)
X(15)
X(15)
X(194)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
22
Field Edits
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 27 RECORD DATA – LAND RECORD cont’d.
Field
No.
34
35
36
Field Name
REINSURANCE YEAR
POLICYHOLDER DATA TYPE 27
CONTRACT NUMBER
Begin
Pos
Size
526
530
532
Picture
4
2
18
Field Edits
9(04)
X(02)
X(18)
ALL DAS YEARS
Must equal 27
From policy which
initiated the inquiry.***
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
37
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is being
retried for the crop in the
location county of the
originating Type 14 record.
(See below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
23
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 57 RECORD DATA – QUALITY CONTROL REPORTING
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
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
FILLER
REVIEWER’S NAME
REVIEWER’S TITLE
DATE REVIEW COMPLETED
CROP POLICY IN ERROR
PROGRAM REVIEW
APH TOLERANCE REVIEW
CONFLICT OF INTEREST
REVIEW
SIMPLIFIED CLAIM REVIEW
CONSECUTIVE LOSS
ADJUSTER REVIEW
$100,000 CLAIM REVIEW
$500,000 CLAIM REVIEW
REPORTED SUSPICION OF
MISREPRESENTATION,
FRAUD, WASTE OR ABUSE
REVIEW
OTHER REVIEW REQUIRED
AIP QUALITY CONTROL
REVIEW
APPLICATION REVIEWED
APH REVIEWED
ACREAGE REPORT REVIEWED
CLAIM REVIEWED
ORIGINAL LIABILITY
ORIGINALTOTAL PREMIUM
ORIGINAL INDEMNITY
FINAL LIABILITY
FINAL TOTAL PREMIUM
FINAL INDEMNITY
COMMENT
WRITTEN AGREEMENT FLAG
AIP KEY 57
FILLER
FCIC-Appendix III
Begin
Pos
Size
Picture
21
25
27
30
33
73
93
101
102
103
104
4
2
3
3
40
20
8
1
1
1
1
9(04)
9(02)
9(03)
9(03)
X(40)
X(20)
9(08)
X(01)
X(01)
X(01)
X(01)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
105
106
1
1
X(01)
X(01)
DAS 2011
DAS 2011
107
108
109
1
1
1
X(01)
X(01)
X(01)
DAS 2011
DAS 2011
DAS 2011
110
111
1
1
X(01)
X(01)
DAS 2011
DAS 2011
112
113
114
115
116
126
136
146
156
166
176
376
377
392
1
1
1
1
10
10
10
10
10
10
200
1
15
134
X(01)
X(01)
X(01)
X(01)
9(10)
9(10)
9(10)
9(10)
9(10)
9(10)
X(200)
X(01)
X(15)
X(134)
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
DAS 2011
24
Field Edits
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Year - 2011
FCIC-Appendix III
TYPE 57 RECORD DATA – QUALITY CONTROL REPORTING cont’d.
Field
No.
33
34
35
Field Name
REINSURANCE YEAR
POLICYHOLDER DATA TYPE 57
CONTRACT NUMBER
Begin
Pos
Size
526
530
532
Picture
4
2
18
Field Edits
9(04)
X(02)
X(18)
ALL DAS YEARS
Must equal 57
From policy which
initiated the inquiry.***
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
36
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is being
retried for the crop in the
location county of the
originating Type 14 record.
(See below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
TYPE 10 RECORD DATA - POLICY PRODUCER
Field
No.
Field Name
Begin
Pos
Size
Picture
1
RECORD NUMBER
21
3
9(03)
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
BRANCH OFFICE
ID TYPE
ID NUMBER
ENTITY TYPE
PRODUCER LAST NAME
PRODUCER FIRST NAME
PRODUCER MIDDLE NAME
PRODUCER NAME SUFFIX
PRODUCER TITLE
BUSINESS NAME
ADDRESS LINE 1
ADDRESS LINE 2
CITY
ADDRESS STATE
ZIP CODE
24
26
27
36
37
57
67
77
82
86
121
156
191
226
228
2
1
9
1
20
10
10
5
4
35
35
35
35
2
5
X(02)
X(01)
X(09)
X(01)
X(20)
X(10)
X(10)
X(05)
X(04)
X(35)
X(35)
X(35)
X(35)
X(02)
X(05)
FCIC-Appendix III
25
Field Edits
Value for a Primary 10
record is ‘001’. Value for a
SBI record is ‘999’.
ALL DAS YEARS.
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2007 – 2010
DAS 2007 – 2010
DAS 2007 – 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 – 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
RY2012
March 1, 2012
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
ZIP EXTENSION
PHONE NUMBER
CO EMPLOYEE
INELIGIBLE SBI FLAG
FILLER
INELIGIBLE SBI SHARE
USDA COMM CUST ID
UNINSURABLE SBI FLAG
CIMS PRODUCER
INFORMATION REQUEST
FILLER
MEASURE SVC FLAG
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA
TYPE 10
FCIC-Appendix III
FCIC-Appendix III
233
237
247
248
249
251
255
261
262
4
10
1
1
2
4
6
1
1
X(04)
X(10)
X(01)
X(01)
X(02)
9V9(03)
X(06)
X(01)
X(01)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 – 2010
DAS 2007 – 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 – 2010
DAS 2007- 2008
263
278
279
526
530
15
1
247
4
2
9(15)
X(01)
X(247)
9(04)
X(02)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
ALL DAS YEARS
MUST EQUAL 10.
ALL DAS YEARS
26
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 10 RECORD DATA – POLICY PRODUCER cont’d
Field
No.
31
Field Name
CONTRACT NUMBER
Begin
Pos
Size
Picture
532
18
X(18)
Field Edits
From policy which initiated the
inquiry. ALL DAS YEARS.
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
32
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is being retrieved
for the crop in the location county of
the originating Type 14 record
(see below). ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 10, 14
FCIC-Appendix III
27
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 11 RECORD DATA - ACREAGE
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
41
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
BASIC UNIT NUMBER
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
RECORD NUMBER
TYPE 15 RECORD NUMBER
RATE CLASS
MAP AREA
CRUSH DISTRICT
REFERENCE CROP YEAR
WRITTEN AGREEMENT TYPE
WRITTEN AGREEMENT NUMBER
WRITTEN AGMT PROCESS FLAG
DATE PLANTED
GUARANTEE REDUCTION FLAG
YIELD
DOLLAR AMOUNT OF INSURANCE
QUOTA/NUMBER OF TREES
COVERAGE LEVEL
GUARANTEE PER ACRE
GUAR REDUCTION FACTOR
REPORTED ACRES/TONS
TOTAL GUARANTEE
PRICE ELECTION
CONTRACT PRICE
INSURED SHARE
LIABILITY
PRICE ELECTION FACTOR
YLD CVN FCT & YLD INDX MC TREE
BASE PREMIUM RATE
PRELIMINARY BASE RATE
LOADED PREMIUM PER ACRE
UNIT OPTION CODE
COMMON OPTION CODE
RATE CLASS OPTION CODE
EXPERIENCE FACTOR
PREMIUM RATE SURCHARGE
UNIT PREM ADJUSTMENT FCTR
FCIC-Appendix III
Begin
Pos
21
25
27
30
35
38
41
42
45
48
51
54
56
60
62
70
72
80
81
91
101
111
116
126
129
137
147
155
163
167
177
182
186
194
202
210
212
232
252
256
257
28
Size
Picture
4
2
3
5
3
3
1
3
3
3
3
2
4
2
8
2
8
1
10
10
10
5
10
3
8
10
8
8
4
10
5
4
8
8
8
2
20
20
4
1
5
9(04)
9(02)
9(03)
9(05)
9(03)
9(03)
X(01)
X(03)
X(03)
X(03)
X(03)
X(02)
9(04)
X(02)
X(08)
X(02)
9(08)
X(01)
Field Edits
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(10)
DAS 2007 - 2010
9(01)V9(04) DAS 2007 - 2010
9(08)V9(02) DAS 2007- 2010
V9(03)
DAS 2007 - 2010
9(06)V9(02) DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(04)V9(04) DAS 2007 - 2010
9(04)V9(04) DAS 2007 - 2010
9V9(03)
DAS 2007 - 2010
9(10)
DAS 2007 - 2010
9(01)V9(04) DAS 2007 - 2010
9(01)V9(03) DAS 2007 - 2010
V9(08)
DAS 2007 - 2010
V9(08)
DAS 2007 - 2010
9(04)V9(04) DAS 2007 - 2010
X(02)
DAS 2007 - 2010
X(20)
DAS 2007 - 2010
X(20)
DAS 2007 - 2010
9(01)V9(03) DAS 2007 - 2010
X(01)
DAS 2007 - 2010
9V9(04)
DAS 2007 - 2010
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 11 RECORD DATA –ACREAGE cont’d.
Field
No.
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
80
81
82
83
84
Field Name
RA FALL HARVEST PRICE OPTION
IP/IIP COUNTY AVERAGE YIELD
RA WHOLE FARM DISC FACTOR
TOTAL PREMIUM
SUBSIDY
PRODUCER PREMIUM
PRIVATE POLICY CODE
INTENDED/ZERO ACREAGE FLAG
SEED COMPANY CODE
RATE STATE
RATE COUNTY
FARM SERIAL NUMBER
NUMBER OF SECTIONS
SEED CYCLE CODE
FILLER
CEO COVERAGE LEVEL
FILLER
PRORATION FACTOR
HISTORICAL PACKOUT FACTOR
RATE YIELD
PRICE INDICATOR
INS ACREAGE RPT SIGNATURE DATE
FILLER
RESIDUAL FACTOR
LAND LOCATION ID TYPE
LAND LOCATION
MULTIPLE CROPPING FLAG
CROP STATUS
INTENDED USE
VARIETY/TYPE
LAND USE
OFFICIAL MEASURED
FIELD ID
QUALIFYING PREV PLANT CROP
UNIT NBR OF QUALIFYING PP
ADDITIONAL SUBSIDY FLAG
ADDITIONAL SUBSIDY
STATE/PRIVATE SUBSIDY FLAG
STATE/PRIVATE SUBSIDY
AGENT’S SIGNATURE DATE
MODIFIED ACREAGE RECORD FLAG
UNIT LIABILITY
CIMS CURRYR INFO REQUEST
FCIC-Appendix III
Begin
Pos
262
263
271
276
286
296
306
309
310
313
315
318
325
327
328
330
335
346
349
352
362
363
371
372
376
377
395
397
400
402
405
406
407
409
413
418
419
429
430
440
448
450
460
29
Size
1
8
5
10
10
10
3
1
3
2
3
7
2
1
2
5
11
3
3
10
1
8
1
4
1
18
2
3
2
3
1
1
2
4
5
1
10
1
10
8
2
10
1
Picture
Field Edits
X(01)
9(07)V9(01)
9V9(04)
9(10)
9(10)
9(10)
X(03)
X(01)
9(03)
9(02)
9(03)
X(07)
9(02)
X(01)
X(02)
9(01)V9(04)
X(11)
9V9(02)
9V9(02)
9(08)V9(02)
X(01)
9(08)
X(01)
9(01)V9(03)
X(01)
X(18)
X(02)
X(03)
X(02)
X(03)
X(01)
X(01)
X(02)
9(04)
X(05)
X(01)
9(10)
X(01)
9(10)
9(08)
9(02)
9(10)
X(01)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007- 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007- 2010
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 11 RECORD DATA –ACREAGE cont’d.
Field
No.
85
86
87
88
89
90
91
92
93
94
Field Name
Begin
Pos
FSA ADMINISTRATIVE STATE
FSA ADMINISTRATIVE COUNTY
SUB TYPE/VARIETY
GRID ID
SKIP ROW CODE
PEANUT PROCESSING FLAG
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA TYPE 11
CONTRACT NUMBER
461
463
466
469
477
482
483
526
530
532
Size
Picture
2
3
3
8
5
1
43
4
2
18
9(02)
9(03)
9(03)
9(08)
9(05)
9(01)
X(43)
9(04)
X(02)
X(18)
Field Edits
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
ALL DAS YEARS
MUST EQUAL 11
From policy which
initiated the inquiry.
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
95
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is
being retrieved for the
crop in the location
county of the
originating Type 14
record. (see below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
30
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 13 RECORD DATA – INVENTORY VALUE
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
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
BASIC UNIT NUMBER
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
RECORD NUMBER
WRITTEN AGREEMENT
TYPE
WRITTEN AGMT NBR
WRITTEN AGREEMENT
PROCESSING FLAG
REVISED REPORT
VALUE/INVENTORY
VALUE
PREVIOUS YEAR SALES
COVERAGE LEVEL
PRICE ELECTION FACTOR
INSURED SHARE
AMOUNT OF INSURANCE
FILLER
UNIT OPTION CODE
COMMON OPTION CODES
BASE PREMIUM RATE
PRORATION FACTOR
TOTAL PREMIUM
SUBSIDY
PRODUCER PREMIUM
INSURED’S INVENTORY
PEAK COMMENCEMENT
DATE
PEAK TERMINATION DATE
LIABILITY EXCLUDING
PRICE & SHARE (XPS)/
DAS AMT OF INS
FCIC-Appendix III
Begin
Pos
Size
Picture
21
25
27
30
35
38
41
42
45
4
2
3
5
3
3
1
3
2
9(04)
9(02)
9(03)
9(05)
9(03)
9(03)
X(01)
9(03)
X(02)
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 – 2010
47
55
8
2
X(08)
X(02)
DAS 2007 - 2010
DAS 2007 - 2010
57
58
1
9
X(01)
9(09)
DAS 2007 - 2010
DAS 2007 - 2010
67
76
81
86
90
100
104
106
126
134
137
147
157
167
175
9
5
5
4
10
4
2
20
8
3
10
10
10
8
8
9(09)
9(01)V9(04)
9(01)V9(04)
9(01)V9(03)
9(10)
X(04)
X(02)
X(20)
V9(08)
9(01)V9(02)
9(10)
9(10)
9(10)
9(08)
9(08)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
183
191
8
10
9(08)
9(10)
DAS 2007 - 2010
DAS 2007 - 2010
31
Field Edits
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 13 RECORD DATA - INVENTORY VALUE cont’d
Field
No.
31
32
33
*34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
Field Name
Begin
Pos
Size
Picture
Field Edits
CROP YEAR DEDUCTIBLE
FILLER
PREVIOUS YEARS
SALES FLAG
FILLER
SURVIVAL FACTOR
SURVIVAL FACTOR FLAG
NUMBER OF CLAMS
PRICE ELECTION AMOUNT
FILLER
ADDITIONAL SUBSIDY
FLAG
ADDITIONAL SUBSIDY
STATE/PRIVATE
SUBSIDY FLAG
STATE/PRIVATE SUBSIDY
AGENT’ SIGNATURE DATE
ORIGINAL INVENTORY
VALUE
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA
TYPE 13
CONTRACT NUMBER
201
211
213
10
2
1
9(10)
9(02)
X(01)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
214
222
226
227
235
243
244
8
4
1
8
8
1
1
9(08)
9(01)V9(03)
X(01)
9(08)
9(04)V9(04)
X(01)
X(01)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
245
255
10
1
9(10)
X(01)
DAS 2007 - 2010
DAS 2007 - 2010
256
266
274
10
8
9
9(10)
9(08)
9(09)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
283
526
530
243
4
2
X(243)
9(04)
X(02)
MESSAGE CODE
550
1
X(01)
DAS 2007 - 2010
ALL DAS YEARS
Must equal 13
ALL DAS YEARS
49
532
18
X(18)
From policy which
initiated the inquiry.
ALL DAS YEARS
***CONTRACT NUMBER consists of Insurance Provider , Location St, Company Number
(FSA Servicing County), Policy Number and Crop Year
50
MESSAGE
CODE
N
P
S
FCIC-Appendix III
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
32
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 14 RECORD DATA – INSURANCE IN FORCE
Field
No.
Field Name
Begin
Pos
Size
Picture
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
RECORD NUMBER
LATE PROCESSED FLAG
FUND DESIGNATION FLAG
FEE PREPAYMENT FLAG
ADMIN FEE FLAG
RATE STATE
RATE COUNTY
DUAL COVERAGE FLAG
INSURED’S SIGNATURE
DATE FOR CROP
CONTRACT FLAG
EXPERIENCE INQUIRY
WRITTEN AGREEMENT FLAG
WRITTEN AGREEMENT NUMBER
WRITTEN AGREEMENT TYPE
ADDED COUNTY FLAG
CANCEL/TRANSFER APPLICATION
COVERAGE LEVEL
PRICE ELECTION FACTOR
FILLER
COMMON OPTION CODES
RATE CLASS OPTION CODES
WRITTEN AGREEMENT DATE
PRODUCER HISTORY FLAG
MARKETING ACTIVITY TYPE
PRICE INDICATOR
ADDED COUNTY REFERENCE
STATE
FILLER
ADDED COUNTY REFERENCE
POLICY NUMBER
ADDED COUNTY REFERENCE
CROP YEAR
ADDED COUNTY REFERENCE
CROP CODE
21
25
27
30
33
36
37
40
42
43
44
45
47
50
51
4
2
3
3
3
1
3
2
1
1
1
2
3
1
8
9(04)
9(02)
9(03)
9(03)
9(03)
X(01)
9(03)
9(02)
9(01)
X(01)
X(01)
9(02)
9(03)
X(01)
9(08)
59
60
61
63
71
73
74
75
80
85
87
107
127
135
136
143
144
1
1
2
8
2
1
1
5
5
2
20
20
8
1
7
1
2
X(01)
X(01)
X(02)
X(08)
X(02)
X(01)
X(01)
146
149
3
7
X(03)
9(07)
DAS 2007 - 2010
DAS 2007 - 2010
156
4
9(04)
DAS 2007 - 2010
160
4
9(04)
DAS 2007 - 2010
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
FCIC-Appendix III
33
Field Edits
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 – 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 – 2010
DAS 2007 - 2010
DAS 2007 - 2010
9(01)V9(04) DAS 2007 - 2010
9(01)V9(04) DAS 2007 - 2010
X(02)
DAS 2007 - 2010
X(20)
DAS 2007 - 2010
X(20)
DAS 2007 - 2010
9(08)
DAS 2007 - 2010
X(01)
DAS 2007 - 2010
X(01)
DAS 2007 - 2010
X(01)
DAS 2007 - 2010
9(02)
DAS 2007 - 2010
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 14 RECORD DATA – INSURANCE IN FORCE cont’d.
Field
No.
Field Name
37
ADDED COUNTY REFERENCE
LOCATION COUNTY
ADDED COUNTY REFERENCE
TYPE CODE
FILLER
COMMON INFORMATION SYSTEM
FLAG
AGENT’S SIGNATURE DATE
WRITTEN AGREEMENT MULTIYEAR FLAG
DISPUTE NOTIFICAION FLAG
DATE AIP NOTIFIED OF DISPUTE
FSA ADMINISTRATIVE STATE
FSA ADMINISTRATIVE COUNTY
RMA/FSA DIFFERENCE FLAG
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA TYPE 14
CONTRACT NUMBER
38
39
40
41
42
43
44
45
46
47
48
49
50
51
Begin
Pos
Size
Picture
Field Edits
164
34
9(03)
DAS 2007 - 2010
167
3
9(03)
DAS 2007 - 2010
170
171
1
1
X(01)
X(01)
DAS 2007 - 2010
DAS 2007 - 2010
172
180
8
1
9(08)
X(01)
DAS 2007 - 2010
DAS 2007 - 2010
181
182
190
192
195
197
526
530
532
1
8
2
3
2
329
4
2
18
X(01)
9(08)
9(02)
9(03)
X(02)
X(329)
9(04)
X(02)
X(18)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
All DAS YEARS
Must equal 14
From policy which
initiated the inquiry.
*** All DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
52
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is
being retrieved for the
crop in the location
county of the
originating Type 14
record. (see below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
34
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 15 RECORD DATA - YIELD
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
41
Field Name
Begin
Pos
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
UNIT NUMBER
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
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 ACRE 1
REVENUE YIELD/SKIP ROW CODE 1
YIELD YEAR 2
YIELD TYPE 2
ANNUAL YIELD 2
YIELD ACRE 2
REVENUE YIELD/SKIP ROW CODE 2
YIELD YEAR 3
YIELD TYPE 3
ANNUAL YIELD 3
YIELD ACRE 3
REVENUE YIELD/SKIP ROW CODE 3
YIELD YEAR 4
YIELD TYPE 4
ANNUAL YIELD 4
YIELD ACRE 4
REVENUE YIELD/SKIP ROW CODE 4
YIELD YEAR 5
YIELD TYPE 5
ANNUAL YIELD 5
FCIC-Appendix III
Size
Picture
Field Edits
21
25
27
30
35
38
41
42
45
48
50
4
2
3
5
3
3
1
3
3
2
8
9(04)
9(02)
9(03)
9(05)
9(03)
9(03)
X(01)
9(03)
X(03)
X(02)
X(08)
58
60
62
64
74
84
94
104
108
110
120
128
134
138
140
150
158
164
168
170
180
188
194
198
200
210
218
224
228
230
2
2
2
10
10
10
10
4
2
10
8
6
4
2
10
8
6
4
2
10
8
6
4
2
10
8
6
4
2
10
X(02)
X(02)
X(02)
35
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(04)
DAS 2007 - 2010
X(02)
DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(06)V9(02) DAS 2007 - 2010
9(06)
DAS 2007 - 2010
9(04)
DAS 2007 - 2010
X(02)
DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(06)V9(02) DAS 2007 - 2010
9(06)
DAS 2007 - 2010
9(04)
DAS 2007 - 2010
X(02)
DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(06)V9(02) DAS 2007 - 2010
9(06)
DAS 2007 - 2010
9(04)
DAS 2007 - 2010
X(02)
DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(06)V9(02) DAS 2007 - 2010
9(06)
DAS 2007 - 2010
9(04)
DAS 2007 - 2010
X(02)
DAS 2007 – 2010
9(08)V9(02) DAS 2007 - 2010
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 15 RECORD DATA – YIELD cont’d.
Field
No.
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
Field Name
Begin
Pos
Size
YIELD ACRE 5
REVENUE YIELD/SKIP ROW CODE 5
YIELD YEAR 6
YIELD TYPE 6
ANNUAL YIELD 6
YIELD ACRE 6
REVENUE YIELD/SKIP ROW CODE 6
YIELD YEAR 7
YIELD TYPE 7
ANNUAL YIELD 7
YIELD ACRE 7
REVENUE YIELD/SKIP ROW CODE 7
YIELD YEAR 8
YIELD TYPE 8
ANNUAL YIELD 8
YIELD ACRE 8
REVENUE YIELD/SKIP ROW CODE 8
YIELD YEAR 9
YIELD TYPE 9
ANNUAL YIELD 9
YIELD ACRE 9
REVENUE YIELD/SKIP ROW CODE 9
YIELD YEAR 10
YIELD TYPE 10
ANNUAL YIELD 10
YIELD ACRE 10
REVENUE YIELD/SKIP ROW CODE 10
RATE STATE
RATE COUNTY
FARM SERIAL NUMBER
YIELD LIMITATION FLAG
EXCESSIVE YIELD EDIT
VERIFICATION
NUMBER OF YEARS W/ACTUAL
YIELDS ON REFERENCE RECORDS
YIELD INDEX
APPLICABLE OPTION CODES
RATE YIELD
FCIC-Appendix III
Picture
Field Edits
240
248
254
258
260
270
278
284
288
290
300
308
314
318
320
330
338
344
348
350
360
368
374
378
380
390
398
404
406
409
416
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
2
3
7
2
9(06)V9(02) DAS 2007 - 2010
9(06)
DAS 2007 - 2010
9(04)
DAS 2007 - 2010
X(02)
DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(06)V9(02) DAS 2007 - 2010
9(06)
DAS 2007 - 2010
9(04)
DAS 2007 - 2010
X(02)
DAS 2007 – 2010
9(08)V9(02) DAS 2007 - 2010
9(06)V9(02) DAS 2007 - 2010
9(06)
DAS 2007 - 2010
9(04)
DAS 2007 - 2010
X(02)
DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(06)V9(02) DAS 2007 - 2010
9(06)
DAS 2007 - 2010
9(04)
DAS 2007 - 2010
X(02)
DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
9(06)V9(02) DAS 2007 - 2010
9(06)
DAS 2007 - 2010
9(04)
DAS 2007 - 2010
X(02)
DAS 2007 – 2010
9(08)V9(02) DAS 2007 - 2010
9(06)V9(02) DAS 2007 - 2010
9(06)
DAS 2007 - 2010
9(02)
DAS 2007 - 2010
9(03)
DAS 2007 – 2010
X(07)
DAS 2007 - 2010
9(02)
DAS 2007 - 2010
418
419
1
2
X(01)
9(02)
421
426
442
5
16
10
S9(03)V9(02) DAS 2007 - 2010
X(16)
DAS 2007 - 2010
9(08)V9(02) DAS 2007 - 2010
36
DAS 2007 - 2010
DAS 2007 - 2010
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 15 RECORD DATA - YIELD cont’d.
Field
No.
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
Field Name
Begin
Pos
Size
FILLER-15-1
452
AVERAGE YIELD
455
PREVIOUS YLD LIMITATION FLG
465
PERENNIAL YEAR OF SET OUT
467
PERENNIAL LEAF YEAR
473
PERENNIAL DENSITY
475
PERENNIAL BLOCK NUMBER
479
PERENNIAL TRANS YIELD FACTOR
482
PERENNIAL SPECIAL CASES
485
PERENNIAL, OTHER CHARACTERISTICS 488
PERENNIAL YEAR OF GRAFTING
489
FILLER-15-2
495
FILLER
504
REINSURANCE YEAR
526
POLICYHOLDER DATA TYPE 15
530
93 CONTRACT NUMBER
532
Picture
Field Edits
3
10
2
6
2
4
3
3
3
1
6
31
22
4
2
9(03)
9(08)V9(02)
9(02)
9(06)
9(02)
9(04)
9(03)
9(03)
9(03)
X(01)
9(06)
X(31)
X(22)
9(04)
X(02)
18
X(18)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007- 2010
DAS 2007 - 2010
ALL DAS YEARS
Must equal 15
ALL DAS YEARS
From policy which
initiated the inquiry. ***
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
94
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is being
retrieved for the crop in the
location county of the
originating Type 14 record.
(See below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
37
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 17 RECORD DATA – LAND ID
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
41
42
43
44
45
46
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
UNIT NUMBER
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
RECORD NUMBER
TYPE 11/15 RECORD NUMBER
LAND IDENTIFIER TYPE 1
LAND IDENTIFIER 1
LAND IDENTIFIER TYPE 2
LAND IDENTIFIER 2
LAND IDENTIFIER TYPE 3
LAND IDENTIFIER 3
LAND IDENTIFIER TYPE 4
LAND IDENTIFIER 4
LAND IDENTIFIER TYPE 5
LAND IDENTIFIER 5
LAND IDENTIFIER TYPE 6
LAND IDENTIFIER 6
LAND IDENTIFIER TYPE 7
LAND IDENTIFIER 7
LAND IDENTIFIER TYPE 8
LAND IDENTIFIER 8
LAND IDENTIFIER TYPE 9
LAND IDENTIFIER 9
LAND IDENTIFIER TYPE 10
LAND IDENTIFIER 10
PERSON SHARING 1
PERSON SHARING 2
PERSON SHARING 3
LATITUDE 1
LONGITUDE 1
LATITUDE 2
LONGITUDE 2
LATITUDE 3
LONGITUDE 3
LATITUDE 4
LONGITUDE 4
LATITUDE 5
LONGITUDE 5
LATITUDE 6
LONGITUDE 6
LATITUDE 7
LONGITUDE 7
FCIC-Appendix III
Begin
Pos
21
25
27
30
35
38
41
42
45
48
49
62
63
76
77
90
91
104
105
118
119
132
133
146
147
160
161
174
175
188
223
258
293
301
309
317
325
333
341
349
357
365
373
381
389
397
Size
Picture
4
2
3
5
3
3
1
3
3
1
13
1
13
1
13
1
13
1
13
1
13
1
13
1
13
1
13
1
13
35
35
35
8
8
8
8
8
8
8
8
8
8
8
8
8
8
38
9(04)
9(02)
9(03)
X(05)
9(03)
9(03)
X(01)
9(03)
9(03)
X(01)
X(13)
X(01)
X(13)
X(01)
X(13)
X(01)
X(13)
X(01)
X(13)
X(01)
X(13)
X(01)
X(13)
X(01)
X(13)
X(01)
X(13)
X(01)
X(13)
X(35)
X(35)
X(35)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
Field Edits
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 17 RECORD DATA – LAND ID cont’d.
Field
No.
47
48
49
50
51
52
53
54
55
56
Field Name
LATITUDE 8
LONGITUDE 8
LATITUDE 9
LONGITUDE 9
LATITUDE 10
LONGITUDE 10
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA
TYPE 17
CONTRACT NUMBER
Begin
Pos
Size
Picture
Field Edits
405
413
421
429
437
445
453
526
530
8
8
8
8
8
8
73
4
2
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(73)
9(04)
X(02)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
ALL DAS YEARS
Must equal 17
532
18
X(18)
From policy which
initiated the inquiry.
*** ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
57
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is
being retrieved for the
crop in the location county of the
originating Type 14 record. (see
below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
39
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 21 RECORD DATA – PRODUCTION LOSS DETAIL
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
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
UNIT NUMBER
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
CLAIM NUMBER
RECORD NUMBER
TYPE 11 RECORD NUMBER
RATE CLASS
STAGE CODE
100% REPLANT PAYMENT FLAG
STAGE GUARANTEE PER ACRE
DETERMINED ACRES/TONS
LOSS GUARANTEE
PRODUCTION TO COUNT
FARM UNIT DEFICIENCY
INSURED SHARED
GRP/GRIP PAYMENT CALC FACTOR
INDEMNITY
HARVESTED PRODUCTION
SUGAR FACTOR
AUDIT CORRECTION
FILLER-21-1
SIMPLIFIED CLAIM FLAG
FARM SERIAL NUMBER
PRODUCTION TO COUNT
CONVERSION FOR REVENUE CROPS
GUAR REDUCTION FACTOR
DOLLAR AMOUNT INSURANCE
LIABILITY ADJUSTMENT FACTOR
CONTRACT PRICE
YIELD
QUOTA /NUMBER OF TREES
COVERAGE LEVEL
PRICE ELECTION AMOUNT
FCIC-Appendix III
Begin
Pos
Size
21
25
27
30
35
38
41
42
50
53
56
59
61
62
72
80
90
100
110
114
118
128
138
141
142
146
147
4
2
3
5
3
3
1
8
3
3
3
2
1
10
8
10
10
10
4
4
10
10
3
1
4
1
7
9(04)
9(02)
9(03)
9(05)
9(03)
9(03)
X(01)
9(08)
9(03)
9(03)
X(03)
X(02)
X(01)
9(08)V9(02)
9(06)V9(02)
9(08)V9(02)
9(08)V9(02)
S9(08)V9(02)
9(01)V9(03)
9(01)V9(03)
S9(10)
9(08)V9(02)
V9(03)
9(01)
9(04)
X(01)
X(07)
ALL DAS YEARS
ALL DAS YEARS
ALL DAS YEARS
DAS 2007 – 2010
DAS 2007 - 2010
DA 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 -2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
154
164
167
177
184
192
202
212
217
10
3
10
7
8
10
10
5
8
9(08)V9(02)
V9(03)
9(08)V9(02)
9(01)V9(06)
9(04)V9(04)
9(08)V9(02)
9(10)
9(01)V9(04)
9(04)V9(04)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
40
Picture
Field Edits
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 21 RECORD DATA – PRODUCTION LOSS DETAIL contd.
Field
No.
Field Name
37 WRITTEN AGREEMENT TYPE
38 WRITTEN AGREEMENT NUMBER
39 WRITTEN AGREEMENT PROCESSING
FLAG
40 PRICE ELECTION FACTOR
41 FILLER
42 CEO COVERAGE LEVEL
43 CEO INDEMNITY FACTOR
44 GUARANTEE REDUCTION FLAG
45 PRICE INDICATOR
46 LOSS ADJUSTER SIGNATURE DATE
47 FIRST NOTICE OF LOSS DATE
48 PRIMARY DATE OF DAMAGE
49 PRIMARY CAUSE
50 PRIMARY PERCENT
51 SECONDARY DATE OF DAMAGE
52 SECONDARY CAUSE
53 MULTI CROPPING FLAG
54 INSURED’S SIGNATURE DATE
55 PRELIMINARY INDEMNITY
56 MULTI CROPPING EXCEPTION FLAG
57 SECOND CROP WAIVED INDEMNITY
58 LARGE CLAIM FLAG
59 SETTLEMENT FLAG
60 MISREPORTED INFORMATION FACTOR
61 LAST NOTICE OF LOSS DATE
62 COMMON OPTION CODES
63 WRITTEN AGREEMENT MULTI-YEAR
FLAG
64 UNIT LIABILITY FLAG
65 SUB TYPE/VARIETY
66 GRID ID
67 GLEANED ACREAGE CODE
68 UNIT LIABILITY
69 LOSS PREMIUM
70 SKIP ROW CODE
71 FILLER-21-3
72 REINSURANCE YEAR
73 POLICYHOLDER DATA TYPE 21
FCIC-Appendix III
Begin
Pos
Size
225
227
2
8
X(02)
X(08)
DAS 2007 - 2010
DAS 2007 – 2010
235
237
242
244
249
255
256
257
265
273
281
283
286
294
296
298
306
316
317
327
328
329
336
344
2
5
2
5
6
1
1
8
8
8
2
3
8
2
2
8
10
1
10
1
1
7
8
20
X(02)
9(01)V9(04)
X(02)
9(01)V9(04)
9(01)V9(05)
X(01)
X(01)
9(08)
9(08)
9(08)
9(02)
9(01)V9(02)
9(08)
9(02)
X(2)
9(08)
S9(10)
X(01)
S9(10)
X(01)
X(01)
9(01)V9(06)
9(08)
X(20)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007- 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007- 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
364
365
366
369
377
379
389
399
404
526
530
1
1
3
8
2
10
10
5
122
4
2
X(01)
X(01)
9(03)
9(08)
X(02)
9(10)
X(10)
9(05)
X(122)
9(04)
X(02)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2011
DAS 2007 - 2011
DAS 2007 - 2011
DAS 2007 - 2011
DAS 2007 – 2011
DAS 2007 - 2010
ALL DAS YEARS
Must equal 21
41
Picture
Field Edits
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 21 RECORD DATA – PRODUCTION LOSS DETAIL contd.
Field
No.
Field Name
Begin
Pos
Size
74
CONTRACT NUMBER
532
18
75
MESSAGE CODE
Picture
Field Edits
From policy which
initiated the inquiry. ***
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
MESSAGE
CODE
N
P
S
550
1
X(18)
X(01)
Reason the record is being
retrieved for the crop in the
location county of the
originating Type 14 record.
(See below)
ALL DAS YEARS
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
42
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 22 RECORD DATA – INVENTORY LOSS DETAIL
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
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
UNIT NUMBER
TYPE CODE
PRACTICE CODE
COVERAGE FLAG
CLAIM NUMBER
RECORD NUMBER
TYPE 13 RECORD NUMBER
PRIMARY DATE OF DAMAGE
PRIMARY CAUSE
PRIMARY PERCENT
SECONDARY CAUSE
OPTIONAL UNITS
INSPECTION NUMBER
BASIC UNIT VALUE
EFFECTIVE XPS LIABILITY/
EFFECTIVE AMOUNT OF
INSURANCE
EFFECTIVE CROP YEAR
DEDUCTIBLE
BASIC UNIT VALUE for CLAMS
UNDER REPORTING FACTOR
FIELD MARKET VALUE A/
UNIT VALUE BEFORE LOSS
FIELD MARKET VALUE B/
UNIT VALUE AFTER LOSS
ADJUSTED LOSS
OCCURRENCE DEDUCTIBLE
UNADJUSTED INDEMNITY
PRELIMINARY INDEMNITY
INSURED SHARE
PRICE ELECTION FACTOR
INDEMNITY
FILLER
LOSS ADJUSTER SIGNATURE DATE
NOTICE OF LOSS DATE
202
SECONDARY DATE OF
210
DAMAGE
INSURED’S SIGNATURE DATE
218
FOR THE CLAIM
LARGE CLAIM FLAG
226
COVERAGE LEVEL
227
FCIC-Appendix III
Begin
Pos
Size
Picture
Field Edits
21
25
27
30
35
38
41
42
50
53
56
64
66
69
71
72
74
84
4
2
3
5
3
3
1
8
3
3
8
2
3
2
1
2
10
10
9(04)
ALL DAS YEARS
9(02)
ALL DAS YEARS
9(03)
ALL DAS YEARS
9(05)
DAS 2007 - 2010
9(03)
DAS 2007 - 2010
9(03)
DAS 2007 - 2010
X(01)
DAS 2007 - 2010
9(08)
DAS 2007 - 2010
9(03)
DAS 2007 - 2010
9(03)
DAS 2007 - 2010
9(08)
DAS 2007 - 2010
9(02)
DAS 2007 - 2010
9(01)V9(02) DAS 2007 - 2010
9(02)
DAS 2007 - 2010
X(01)
DAS 2007 - 2010
9(02)
DAS 2007 - 2010
9(10)
DAS 2007 - 2010
9(10)
DAS 2007 - 2010
94
9
9(09)
103
112
116
9
4
9
9(09)
DAS 2007 - 2010
9(01)V9(03) DAS 2007 - 2010
9(09)
DAS 2007 - 2010
DAS 2007 - 2010
125
9
S9(09)
134
144
153
163
173
177
182
192
10
9
10
10
4
5
10
9(10)
DAS 2007 - 2010
9(09)
DAS 2007 -2010
S9(10)
DAS 2007 - 2010
S9(10)
DAS 2007 - 2010
9(01)V9(03) DAS 2007 - 2010
9(01)V9(04) DAS 2007 - 2010
S9(10)
DAS 2007 - 2010
2
8
X(02)
9(08)
8
8
9(08)
9(08)
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 -2010
8
9(08)
DAS 2007 - 2010
1
5
X(01)
9(01)V9(04)
DAS 2007 -2010
DAS 2007 - 2010
194
43
DAS 2007 - 2010
RY2012
March 1, 2012
Field
No.
38
39
40
41
42
43
44
45
46
47
48
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
Field Name
SETTLEMENT FLAG
REHAB PLANT VALUE
OPTION CODES
MULTIPLE REHAB PAYMENTS
ACTUAL REHAB COST
CALCULATION STATUS
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA
TYPE 22
CONTRACT NUMBER
Begin
Pos
Size
Picture
232
233
243
253
254
264
265
526
530
1
10
10
1
10
1
261
4
2
X(01)
9(10)
X(10)
X(01)
9(10)
X(01)
X(261)
9(04)
X(02)
532
18
X(18)
FCIC-Appendix III
Field Edits
DAS 2007 - 2010
DAS 2007- 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
DAS 2007 - 2010
ALL DAS YEARS
Must equal 22
From policy which
initiated the inquiry***.
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
MESSAGE CODE
MESSAGE
CODE
N
P
S
550
1
X(01)
Reason the record is
being retrieved for the
crop in the location
county of the originating
Type 14 record. (See below)
DESCRIPTION
ALL DAS YEARS
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
FCIC-Appendix III
44
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 27 RECORD DATA – LAND RECORD
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
33
34
35
36
Field Name
Begin
Pos
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
BASIC UNIT NUMBER
FILLER
GRID ID
RECORD NUMBER
TYPE 11 RECORD NUMBER
LAND IDENTIFIER TYPE
FSA FARM SERIAL TYPE
FSA TRACT NUMBER
FSA FIELD NUMBER
FSA SUB FIELD IDENTIFIER
REPORTED ACRED
INTENDED USE
DATE PLANTED
IRRIGATION INDICATOR
UNIQUE CLU ID
PERSONS SHARING 1
PERSONS SHARING 2
RMA/FSA ENTITY DIFFERENCE
FLAG 1
RMA/FSA ACREAGE DIFF FLG 2
X CENTROID
Y CENTROID
FSA ADMINISTRATIVE STATE
FSA ADMINISTRATIVE
COUNTY
CLU DETERMINATION
FILLER
REINSURANCE YEAR
POLICYHOLDER DATA TYPE 27
CONTRACT NUMBER
Size
Picture
Field Edits
21
25
27
30
35
53
61
65
68
69
76
83
87
90
98
100
108
109
145
180
215
4
2
3
5
18
8
4
3
1
7
7
4
3
8
2
8
1
36
35
35
2
9(04)
9(02)
9(03)
9(05)
X(18)
X(08)
9(04)
9(03)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(02)
9(08)
X(01)
X(36)
X(35)
X(35)
X(02)
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 -2010
DAS 2009 - 2010
DAS 2009 -2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 – 2010
DAS 2009 – 2010
217
219
231
243
245
2
12
12
2
3
X(02)
9(06)V9(06)
9(07)V9(05)
9(02)
9(03)
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
DAS 2009 - 2010
248
249
526
530
532
1
277
4
2
18
X(01)
X(277)
9(04)
X(02)
X(18)
DAS 2009 - 2010
DAS 2009 - 2010
ALL DAS YEARS
Must equal 27
From policy which
initiated the inquiry***
All DAS Years
*** Contract Number consists of Insurance Provider, Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
MESSAGE CODE
N
P
S
FCIC-Appendix III
DESCRIPTION
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
45
RETURNED RECORD TYPE(s)
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 57 RECORD DATA – QUALITY CONTROL REPORTING
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
Field Name
CROP CODE
INSURANCE PLAN CODE
LOCATION COUNTY
RECORD NUMBER
REVIEWER’S NAME
REVIEWER’S TITLE
DATE REVIEW COMPLETED
CROP POLICY IN ERROR
PROGRAM REVIEW
APH TOLERANCE REVIEW
CONFLICT OF INTEREST
REVIEW
SIMPLIFIED CLAIM REVIEW
CONSECUTIVE LOSS
ADJUSTER REVIEW
$100,000 CLAIM REVIEW
$500,000 CLAIM REVIEW
REPORTED SUSPICION OF
MISREPRESENTATION, FRAUD,
WASTE OR ABUSE REVIEW
OTHER REVIEW REQUIRED
AIP QUALITY CONTROL
REVIEW
APPLICATION REVIEWED
APH REVIEWED
ACREAGE REPORT REVIEWED
CLAIM REVIEWED
ORIGINAL LIABILITY
ORIGINALTOTAL PREMIUM
ORIGINAL INDEMNITY
FINAL LIABILITY
FINAL TOTAL PREMIUM
FINAL INDEMNITY
COMMENT
WRITTEN AGREEMENT FLAG
FILLER
FCIC-Appendix III
Begin
Pos
Size
Picture
Field Edits
21
25
27
30
33
73
93
101
102
103
104
4
2
3
3
40
20
8
1
1
1
1
9(04)
9(02)
9(03)
9(03)
X(40)
X(20)
9(08)
X(01)
X(01)
X(01)
X(01)
DAS 2007 – 10
DAS 2007 – 10
DAS 2007 – 10
DAS 2007– 10
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 - 10
105
106
1
1
X(01)
X(01)
DAS 2007 - 10
DAS 2007 - 10
107
108
109
1
1
1
X(01)
X(01)
X(01)
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 - 10
110
111
1
1
X(01)
X(01)
DAS 2007 - 10
DAS 2007 - 10
112
113
114
115
116
126
136
146
156
166
176
376
377
1
1
1
1
10
10
10
10
10
10
200
1
149
X(01)
X(01)
X(01)
X(01)
9(10)
9(10)
9(10)
9(10)
9(10)
9(10)
X(200)
X(01)
X(149)
DAS 2007 - 10
DAS 2007- 10
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 - 10
DAS 2007 -10
DAS 2007 - 10
DAS 2010
DAS 2007 - 10
46
RY2012
March 1, 2012
Exhibit 81
2012 Policy Holder Tracking Experience Inquiry
Type 81 - Output Format for Years 2007 - 2010
FCIC-Appendix III
TYPE 57 RECORD DATA – QUALITY CONTROL REPORTING contd.
Field
No.
32
33
34
Field Name
REINSURANCE YEAR
POLICYHOLDER DATA
TYPE 57
CONTRACT NUMBER
Begin
Pos
Size
Picture
526
530
4
2
9(04)
X(02)
532
18
X(18)
Field Edits
ALL DAS YEARS
Must equal 57
From policy which
initiated the inquiry***.
ALL DAS YEARS
*** CONTRACT NUMBER consists of Insurance Provider , Location State, Company Number
(FSA Servicing County), Policy Number and Crop Year.
35
MESSAGE CODE
550
1
X(01)
Reason the record is
being retrieved for the
crop in the location
county of the originating
Type 14 record. (See below)
ALL DAS YEARS
MESSAGE
CODE
N
P
S
FCIC-Appendix III
DESCRIPTION
RETURNED RECORD TYPE(s)
No prior year records for ID NUMBER
Prior year policy found
Prior year insurance with same company
Originating 14
10, 11, 13, 14, 15, 17, 21, 22, 27, 57
Originating 14
47
RY2012
| File Type | application/pdf |
| File Title | POLICY KEY INFORMATION USED FOR ALL RECORD TYPES |
| Author | leonard.dixon |
| File Modified | 2012-03-06 |
| File Created | 2012-03-06 |