Record 22 Output Format

June 18, 2004

FCIC-Appendix III

Exhibit 98-13

(RECORD 22 OUTPUT FORMAT for ‘.acp,.rej,.sus’)
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 RO/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 Exh ibit 21-2)

FCIC-APPENDIX III

22 - 1

RY 2005

June 18, 2004

FCIC-Appendix III

Exhibit 98-13

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

Field
No.

Field Name

23

Optional Units

24
25

Size

Picture

Field Edits

106

1

X(01)

Inspection Number

107

2

9(02)

Liability Excluding Price &
Share (XPS
Effective XPS Liability/
Effective Amount of
Insurance

109

10

9(10)

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)

34

Unadjusted Indemnity

188

10

S9(10)

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,
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
For CAT, all records must be the same.
Adjusted Loss (field 32) - Occurrence Deductible
(field 33)

26

FCIC-APPENDIX III

Begin
Pos

22 - 2

RY 2005

June 18, 2004

FCIC-Appendix III

Exhibit 98-13

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

Field
No.

Field Name

Begin
Pos

Size

Picture

35

Preliminary Indemnity

198

10

S9(10)

36
37

Insured Share
Price Election Factor

208
212

4
5

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

Field Edits

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)

43

Insured’s Signature Date
for the Claim

253

8

9(08)

FCIC-APPENDIX III

22 - 3

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.
Required: Format is MMDDCCYY
Cannot exceed submission Date. Cannot be less
than Notice of Loss Date (field 41).
RY 2005

June 18, 2004

FCIC-Appendix III

Exhibit 98-13

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

Field
No.

Field Name

44

Large Claim Flag

45

Begin
Pos

Size

Picture

Field Edits

261

1

X(01)

Filler

262

289

X(289)

If indemnity exceeds $500,000 this field must:
N = AIP notified RMA of excessive indemnity
R = RMA participated or reviewed in the
excessive indemnity
else spaces if unit indemnity is less than
$500,000.
Must be spaces.

46

FCIC Control Time

551

4

9(04)

47

FCIC Control Date

555

8

9(08)

48

Reinsurance Year

563

4

9(04)

49

Batch Number

567

4

9(04)

50

Transaction Sequence
Number

571

8

9(08)

51
52
53

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 RO 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 - 4

RY 2005