Type 81 - Policyholder Tracking Experience Inquiry

March 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