Inventory Loss Record - Type 22 - Calculations

June 28, 2007

Exhibit 22

FCIC-Appendix III

(INVENTORY LOSS RECORD – TYPE 22)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

1
2

1
3

2
2

9(02)
X(02)

Required. Must be 22.
Required. Edit with AIP/Company table.

3
4

Record Type
Approved Insurance
Provider
Location State
Policy Issuing Company

5
7

2
3

9(02)
9(03)

5
6

Policy Number
Crop Year

10
17

7
4

9(07)
9(04)

7

Crop Code

21

4

9(04)

8

Insurance Plan Code

25

2

9(02)

9
10

Location County
Unit Number

27
30

3
5

9(03)
9(05)

11
12

Type Code
Practice Code

35
38

3
3

9(03)
9(03)

13

Coverage Flag

41

1

X(01)

14

Claim Number

42

8

9(08)

15

Type 22 Key Reserve

50

26

X(26)

16

Record Number

76

3

9(03)

17

Type 13 Record Number

79

3

9(03)

18

Adjuster SSN

82

9

9(09)

19

Primary Date of Damage

91

8

9(08)

20
21

Primary Cause
Primary Percent

99
101

2
3

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

Required. Edit with FIPS State table.
Required. Edit with company table. Must be
valid Pic code for reinsurance year.
Required. Must be > zeros.
Required. Must be the crop year of the crops
reported under the policy. This will equal the
Reinsurance Year for Aquaculture (0116) or
Reinsurance Year + 1 for Nursery (0073).
Required; must be ‘0073’ for Nursery and
‘0116’ for Aquaculture
Required; must be ‘50’ for Nursery and ‘43’ for
Aquaculture.
Required; Edit with FIPS County Table.
Required; Must be > zeros. For crop 0073,
optional units are not allowed.
Required; Edit with ADM-2.
Required; For Nursery must be 007 or 008. For
Aquaculture edit with ADM.
Required; Must be:
C = Catastrophic “Cat” Coverage
A = Additional Coverage
Must match Loss Total Claim Number on the
Type 20 record. Must be unique by Inspection
Number.
Space Reserved for Additional key data
required in the future or for other record types.
Must be spaces.
Must be > zero and unique within a Crop
Policy (Crop Year/Location State/Location
County/Crop.)
Required. The record number of the Type 13
record that established the liability and
premium for this Type 22 record.
Required; must match a certified loss adjuster
SSN (established by an accepted Type 56
record).
Required field.
Date of damage format = (MMDDCCYY)
Month, Day, Year is required for all Cause of
Loss codes. This Date cannot be later than
Notice of Loss Date (field 41).
Must be valid cause of loss. (See Exhibit 22-3)
Must be zero if the Primary Cause = zero.
Otherwise, must be 0.50 – 1.00.

FCIC-APPENDIX III

22 - 1

RY 2008

June 28, 2007

Exhibit 22

FCIC-Appendix III

(INVENTORY LOSS RECORD – TYPE 22)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

22
23
24

Secondary Cause
Filler
Inspection Number

104
106
107

2
1
2

9(02)
X(01)
9(02)

25

Basic Unit Value

109

10

9(10)

26

Effective XPS Liability/
Effective Amount of
Insurance

119

10

9(10)

27

Effective Crop Year
Deductible

129

9

9(09)

28

Basic Unit Value for
Clams

138

9

9(09)

Must be valid cause of loss. (See Exhibit 22-3)
Must be spaces.
Inspection number from item 19 of claim. Must
be the same within a claim number.
For Crop 0073, Value for the basic unit without
price percent, coverage level, or share.
For CAT or Buy up by Share this field will have
the same value on all records for the Unit within
the same crop year/practice/claim/inspection
number.
If field 48 = ‘RH’, value from item 6 of Rehab
worksheet.
For Crop 0116, Zero fill.
For Crop 0073 the Basic Unit Value (including
coverage level) minus any previous Basic Unit
Indemnities.
For CAT or Buy up by Share this field will have
the same value on all records for the Unit within
the same crop year/practice/claim/inspection
number.
Not applicable to Rehab.
For Crop 0116, this field = the remaining
Amount Of Insurance after previous losses for
the basic unit.
Crop 0073 = Basic Unit Value * (1 – coverage
level). Must match to field 44 on the
corresponding T-13.
For CAT or Buy up by Share this field will have
the same value on all records for the Unit within
the same crop year/practice/claim/inspection
number.
Not applicable to Rehab.
For Crop 0116, this field must match field 44 on
the corresponding (T13) Inventory Record.
Total crop year deductible for basic unit. Item
18C from claim.
For Crop 0073 – Zero Fill.
For Crop 0116, Basic Unit Value. Item 22 from
claim.

FCIC-APPENDIX III

22 - 2

RY 2008

June 28, 2007

Exhibit 22

FCIC-Appendix III

(INVENTORY LOSS RECORD – TYPE 22)
Format/Edits

Field
No.

Field Name

29

Under Reporting Factor

30

31

Size

Picture

Field Edits

147

4

9(01)V9(03)

Field Market Value A/
Unit Value Before Loss

151

9

9(09)

Field Market Value B/
Unit Value After Loss

160

9

S9(09)

Crop 0073 = the lesser of;
1.000 OR the Basic Unit Value minus any
previous losses divided by Field Market A.
For CAT or Buy up by Share this field will have
the same value on all records for the Unit within
the same crop year/practice/claim/inspection
number.
If field 48 = ‘RH’, value from item 11 of Rehab
worksheet.
Crop 0116 = the lesser of;
1.000 OR the sum of all stage values minus all
previous losses divided by the basic unit value
before loss.
For Crop 0073 for the record: enter the value of
all insurable plants based on plant price schedule
(or the prices in your catalog/price list) before
any loss occurrence.
For CAT & Buy up by Share: For Crop 0073 the
value of this field will be for each individual
record.
If field 48 = ‘RH’, value from item 7 of Rehab
worksheet.
For Crop 0116, enter unit value before loss in
whole dollars for record. Item 25 from claim.
For Crop 0116, For CAT, all records must be
the same within the same claim/inspection
number.
For Crop 0073 for the record: enter the value of
all insurable plants based on the plant price
schedule (or the prices in your catalog/price list)
after any loss occurrence.
For CAT & Buy up by Share: For Crop 0073 the
value of this field will be for each individual
record.
Not applicable to Rehab.
For Crop 0116, enter Unit Value After Loss in
whole dollars for the record. Item 26C from
claim. For Crop 0116, For CAT, all records
must be the same within the same
claim/inspection number.

FCIC-APPENDIX III

Begin
Pos

22 - 3

RY 2008

June 28, 2007

Exhibit 22

FCIC-Appendix III

(INVENTORY LOSS RECORD – TYPE 22)
Format/Edits

Field
No.

Field Name

32

Adjusted Loss

33

34

Size

Picture

Field Edits

169

10

9(10)

Occurrence Deductible

179

9

9(09)

Unadjusted Indemnity

188

10

S9(10)

For Crop 0073 and 0116:
Loss adjusted for under reporting and prior to
deductibles. (field 30 - field 31) * field 29
(item 25 - item 26) * item 23 from claim.
For Crop 0073:
For CAT or Buy up by Share this field will have
the same value on all records for the Unit within
the same crop year/practice/claim/inspection
number. Item 28G from claim.
Not applicable to Rehab.
For Crop 0116 for CAT, all records must be
the same within the same claim/inspection
number.
Required For Crop 0073 & 0116.
This field must equal the lesser of:
Market Value A (Field 30 * (1.0000 - coverage
level %) * Under Report Factor (field 29)
OR Crop Year Deductible (field 27)
For Crop 0073:
For CAT or Buy up by Share this field will have
the same value on all records for the Unit within
the same crop year/practice/claim/inspection
number. Item 29G from claim.
Not applicable to Rehab.
For Crop 0116 for CAT, all records must be the
same within the same claim/inspection number.
Required for 0073 & 0116.
This field must equal the:
Adjusted Loss (field 32) - Occurrence
Deductible (field 33).
For Crop 0073:
For CAT or Buy up by Share this field will have
the same value on all records for the Unit within
the same crop year/practice/claim/inspection
number. Item 30G from claim.
Not applicable to Rehab.
For Crop 0116 for CAT, all records must be
the same within the same claim/inspection
number.

FCIC-APPENDIX III

Begin
Pos

22 - 4

RY 2008

June 28, 2007

Exhibit 22

FCIC-Appendix III

(INVENTORY LOSS RECORD – TYPE 22)
Format/Edits

Field
No.

Field Name

35

Preliminary Indemnity

36
37

Size

Picture

Field Edits

198

10

S9(10)

Insured Share
Price Election Factor

208
212

4
5

9(01)V9(03)
9(01)V9(04)

38

Indemnity

217

10

S9(10)

Required for 0073 & 0116.
The lesser of Unadjusted Indemnity (field 34) or
Effective XPS Liability (field 26).
For Crop 0073:
For CAT or Buy up by Share this field will have
the same value on all records for the Unit within
the same crop year/practice/claim/inspection
number. Item 32G from claim.
Not applicable to Rehab.
For Crop 0116 for CAT, all records must be
the same within the same claim/inspection
number.
Required; must be > zero and ≤ 1.000.
For Crop 0073; If Coverage Flag = ‘A’ this field
must = 1.0000
If coverage flag (field 13) equals “C”, this field
must = 0.5500.
If crop = 0116 and Coverage Flag = ‘A’ or ‘C’
this field must = the ADM-1-8 by Stage/Type.
This field must match (field 24) on the T-13.
For Crop 0073:
Preliminary Indemnity * Insured Share * Price
Election Percent
For Crop 0073:
For CAT or Buy up by Share this field will have
the same value on all records for the Unit within
the same crop year/practice/claim/inspection
number. Item 35G from claim.
If field 48 = ‘RH’, value from item 19 of Rehab
worksheet.
For Crop 0116:
Preliminary Indemnity * Insured Share
For Crop 0116 for CAT, all records must be
the same within the basic unit and the same
claim/inspection number.

39
40

Filler
Loss Adjuster Signature
Date

227
229

2
8

X(02)
9(08)

41

Notice of Loss Date

237

8

9(08)

42

Secondary Date of
Damage

245

8

9(08)

FCIC-APPENDIX III

Begin
Pos

22 - 5

Must be spaces.
Required: Date that Loss Adjuster settled claim.
MMDDCCYY format. Cannot exceed
submission date. Must exceed LSR change date
and Record Type 14 FCIC Accepted Date.
Required. Date that insured provided notice
of loss. MMDDCCYY format. Cannot exceed
submission date.
Required if secondary cause > “0”.
Format = (MMDDCCYY)
Month, Day, Year is required for all Cause of
Loss codes. This Date cannot be later than
Notice of Loss Date (field 41).

RY 2008

June 28, 2007

Exhibit 22

FCIC-Appendix III

(INVENTORY LOSS RECORD – TYPE 22)
Format/Edits

Field
No.

Field Name

43

Insured’s Signature Date
for the Claim

44

Size

Picture

Field Edits

253

8

9(08)

Large Claim Flag

261

1

X(01)

45

Coverage Level

262

5

9(01)V9(04)

46

Settlement Flag

267

1

X(01)

47

Rehabilitation Plant Value

268

10

9(10)

48

Option Codes

278

10

X(10)

49

Multiple Rehab Payments

288

1

X(01)

50

Actual Rehab Cost

289

10

9(10)

51
52

Filler
Valid for Escrow Flag

299
542

243
1

X(243)
X(01)

53

Ineligible Tracking
Validation Flag

543

8

X(08)

Required: Format is MMDDCCYY
Cannot exceed submission Date. Cannot be less
than Notice of Loss Date (field 41).
If indemnity exceeds $500,000 this field must
contain one of the following values:
N = AIP notified RMA of excessive indemnity
R = RMA reviewed the excessive indemnity
Spaces = Not applicable
Must match Coverage Level Percent (field 37)
on the 14 record.
Valid coverage levels for Crop 0073 and
Crop 0116 are {0.5000, 05500, 0.6000, 0.6500,
0.7000, 0.7500}.
Values are:
A = Settlement by arbitration
M = Settlement by mediation
O = Other settlement process
Spaces = Not applicable
If field 48 = ‘RH’, dollar value of plants to be
rehabilitated. Item 8 of Rehab worksheet.
Zero fill if not applicable.
Must be left justified.
Valid Values are:
PE = Peak Endorsement
PO = Price Endorsement
RH = Rehab Endorsement; only use with
Practice 007
OC = Organic Certified
OT = Organic Transitional
Spaces if not applicable.
Valid Values are
Y = Multiple Rehab Payments
Spaces = Not applicable.
If field 48 = ‘RH’, actual dollar amount to
Rehabilitate plants. Item 9 of Rehab worksheet.
Zero fill if not applicable.
Must be spaces
Internal Use. Will be “Y” if the record passes
edits necessary for escrow processing (numeric
checks). Will be “N” if the record is not
acceptable for escrow.
Internal Use. Reserved.

FCIC-APPENDIX III

Begin
Pos

22 - 6

RY 2008

June 28, 2007

Exhibit 22

FCIC-Appendix III

(INVENTORY LOSS RECORD – TYPE 22)
Format/Edits

Field
No.

Field Name

54

FCIC Control Time

55

Begin
Pos

Size

Picture

Field Edits

551

4

9(04)

FCIC Control Date

555

8

9(08)

56

Reinsurance Year

563

4

9(04)

57

Batch Number

567

4

9(04)

58

Transaction Sequence
Number

571

8

9(08)

59
60
61

Transaction Rejected Flag
Transaction Source Flag
Filler

579
580
581

1
1
20

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

Internal Use. The time the transaction batch file
was received. (From when transmission started)
HHMM Format.
Internal Use. The date the transaction batch file
was received. (From when transmission started)
MMDDCCYY Format.
Internal Use. The Reinsurance Year. CCYY
format.
Internal Use. The sequential number identifying
the file that was submitted by the AIP to
FCIC/RMA.
Internal Use. The sequential number assigned to
each transaction number processed by DAS after
it has been sorted.
Internal Use. Reserved.
Internal Use. Reserved.
Internal Use.

Notes:
Applicable for Nursery (0073) and Clams (0116) only.
Requires an accepted Type 13 record.

FCIC-APPENDIX III

22 - 7

RY 2008