Inventory Loss Record - Type 22 - Format/Edits

June 18, 2004

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
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
11

Location County
Unit Number
Type Code

27
30
35

3
5
3

9(03)
9(05)
9(03)

12

Practice Code

38

3

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)

22

Secondary Cause

104

2

9(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 or Reinsurance Year +/- 1 for
applicable crop code
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.
Required; For Nursery, if field 23 = ‘Y’ edit with
numeric type codes (see Exhibit 22-2); else if
field 23 = blank enter 997. For Aquaculture, edit
with ADM.
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
(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.
Must be valid cause of loss. (See Exhibit 21-2)
Must be zero if the Primary Cause = zero.
Otherwise, must be 0.50 – 1.00.
Must be valid cause of loss. (See Exhibit 21-2)

FCIC-APPENDIX III

22 - 1

RY 2005

June 18, 2004

Exhibit 22

FCIC-Appendix III

(INVENTORY LOSS RECORD – TYPE 22)
Format/Edits

Field
No.

Field Name

23

Optional Units

24

Size

Picture

Field Edits

106

1

X(01)

Inspection Number

107

2

9(02)

25

Liability Excluding Price &
Share (XPS)

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

Field Market Value C/
Basic Unit Value

138

9

9(09)

29

Under Reporting Factor

147

4

9(01)V9(03)

30

Field Market Value A/
Unit Value Before Loss

151

9

9(09)

31

Field Market Value B/
Unit Value After Loss

160

9

S9(09)

32

Adjusted Loss

169

10

9(10)

33

Occurrence Deductible

179

9

9(09)

Enter “Y” for optional units or leave blank for
Basic Units.
Inspection number from item 19 of claim. Must be
the same within a claim number.
For Crop 0073, liability for the basic unit without
price and share.
For Crop 0116, Zero fill.
For Crop 0073, remaining XPS Liability after
previous losses for the basic unit.
For Crop 0116, this field = the remaining Amount
Of Insurance after previous losses for the basic
unit.
For Crop 0116, this field must match field 43 on
the corresponding (T13) Inventory Record.
Total crop year deductible for basic unit. Item
18C from claim.
For Crop 0073, field market value C for the basic
unit.
For Crop 0116, Basic Unit Value. Item 22 from
claim.
Enter 1.000 or value from item 23 from claim for
the basic unit.
For Crop 0073 for the record: enter the value of
all insurable plants based on plant price schedule
before any loss occurrence.
For Crop 0116, enter unit value before loss in
whole dollars for record. Item 25 from claim. 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 after any loss occurrence.
For Crop 0116, enter Unit Value After Loss in
whole dollars for the record. Item 26C from
claim. For CAT, all records must be the same
within the same claim/inspection number.
Loss adjusted for under reporting and prior to
deductibles. (field 30 - field 31) * field 29
(item 25 - item 26) * item 23 from claim. For CAT,
all records must be the same within the same
claim/inspection number.
The lesser of:
(Field 30 * (1.0000 - coverage level %) * field 29)
or field 27 or field 32
(Item 25 * (1.0000 - coverage level %) * item 23)
or Item 18C or item 28

FCIC-APPENDIX III

Begin
Pos

22 - 2

RY 2005

June 18, 2004

Exhibit 22

FCIC-Appendix III

(INVENTORY LOSS RECORD – TYPE 22)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

For CAT, all records must be the same.

FCIC-APPENDIX III

22 - 3

RY 2005

June 18, 2004

Exhibit 22

FCIC-Appendix III

(INVENTORY LOSS RECORD – TYPE 22)
Format/Edits

Field
No.

Field Name

34

Unadjusted Indemnity

35

36
37

Begin
Pos

Size

Picture

Field Edits

188

10

S9(10)

Preliminary Indemnity

198

10

S9(10)

Insured Share
Price Election Factor

208
212

4
5

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

Adjusted Loss (field 32) - Occurrence Deductible
(field 33)
Item 28 - item 29 from claim
For CAT, all records must be the same within
the same claim/inspection number.
The lesser of field 34 or field 26.
For CAT, all records must be the same within
the same claim/inspection number.
Required; must be > zero and = 1.000.
For Crop 0073, required; all records must
be the same.
If coverage flag (field 13) equals “C”, this field
must = 0.5500.
If coverage flag (field 13) equals “A” and
coverage level (field 23) on record type 13 equals:
1.)
2.)
3.)
4.)
5.)
6.)

38

Indemnity

217

10

S9(10)

0.5000 this field must = 1.0000
0.5500 this field must be = 0.9100
0.6000 this field must be.= 0.8400
0.6500 this field must be = 0.7700
0.7000 this field must be = 0.7200
0.7500 this field must be = 0.6700

If crop = 0116 and (field 13) = ‘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 0116:
Preliminary Indemnity * Insured Share
For CAT, all records must be the same within
the same claim/inspection number.

39
40

M-14 Review Flag
Loss Adjuster Signature
Date

227
229

2
8

9(02)
9(08)

41

Notice of Loss Date

237

8

9(08)

42

Secondary Date of
Damage

245

8

9(08)

FCIC-APPENDIX III

22 - 4

Must be zeros.
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.
RY 2005

June 18, 2004

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

Begin
Pos

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

268

8

X(08)

48

Ineligible Tracking
Validation Flag
Filler

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:
N = AIP notified RMA of excessive indemnity
R = RMA participated or reviewed in the
excessive indemnity
must be spaces if unit indemnity is less than
$500,000.
Must match Coverage Level Percent (field 35) 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
Internal Use. Reserved.

276

275

X(275)

Must be spaces.

49

FCIC Control Time

551

4

9(04)

50

FCIC Control Date

555

8

9(08)

51

Reinsurance Year

563

4

9(04)

52

Batch Number

567

4

9(04)

53

Transaction Sequence
Number

571

8

9(08)

54
55
56

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.

FCIC-APPENDIX III

22 - 5

RY 2005

June 18, 2004

Exhibit 22

FCIC-Appendix III

(INVENTORY LOSS RECORD – TYPE 22)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

Requires an accepted Type 13 record.

FCIC-APPENDIX III

22 - 6

RY 2005