Loss Total Record - Type 20 - Format-Edits

June 28, 2007

Exhibit 20

FCIC-Appendix III

(LOSS TOTAL RECORD – TYPE 20)
Format/Edits

Field
No.

Field Name

1
2
3
4

Record Type
Approved Insurance
Provider
Location State
Policy Issuing Company

5
6

Size

Picture

Field Edits

1
3

2
2

9(02)
X(02)

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

5
7

2
3

9(02)
9(03)

Policy Number
Crop Year

10
17

7
4

9(07)
9(04)

7
8
9
10

Type 20 Key Reserve
Claim Number
Reinsurance Year
Type 20 Key Reserve

21
42
50
54

21
8
4
22

X(21)
9(08)
9(04)
X(22)

11

Record Number

76

3

9(03)

12

1st Total Reinsurance Year

79

4

9(04)

13

1st Total Payment/Credit
Memo Company
1st Total Loss Code

83

3

9(03)

86

1

X(01)

1st Escrow Check/Draft
Number -orP/C Memo State
P/C Memo Policy
1st Total Date Draft Issued

87

9

9(09)

Required. Edit with FIPS State table.
For Reinsured edit with company table; for
FSA edit with the county 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.
Space Reserved for other record types.
Required. Must be > zeros.
Required. Must be 2008.
Space Reserved for Additional key data
required in the future or for other record types.
Must be > zero and unique within a Crop
Policy (Location State/Location County/Crop).
If 1st Total Loss Code = “R”, Must = Recovery
Year or subsequent year.
Otherwise must = zeros.
If 1st Total Loss Code<> Spaces, must be a
valid company. Otherwise must = zeros.
Must be:
D = Unfunded Escrow (See Note)
E = Escrow Funded
F = Administrative Fees
M = Credit Memo this Policy for current
reinsurance year
O = Other (e.g. Interest, etc.)
P = Credit Memo - Loss Applied to another
Policy for current reinsurance year
R = Recovery of Premium or Overpaid
Indemnity for prior or subsequent
reinsurance year Premium
Blank = No Total
If 1st Total Loss Code = E or V must be >
zero. Enter escrow check # or if = ‘P’ enter
credit memo number. Otherwise; zero fill.

96

8

9(08)

14

15

16

FCIC-APPENDIX III

Begin
Pos

20 - 1

If 1st Total Loss Code = D or Blank, must be
zeros. Otherwise, if > 0 must be a valid date.
Format is MMDDCCYY.

RY 2008

June 28, 2007

Exhibit 20

FCIC-Appendix III

(LOSS TOTAL RECORD – TYPE 20)
Format/Edits

Field
No.

Field Name

17

1st Total Amount

18

19

Size

Picture

Field Edits

104

12

S9(10)V(02)

2nd Total Reinsurance Year

116

4

9(04)

120

3

9(03)

123
124

1
9

X(01)
9(09)

22

2nd Total Payment/Credit
Memo Company
2nd Total Loss Code
2nd Escrow Check/Draft
Number -orP/C Memo State
P/C Memo Policy
2nd Total Date Draft Issued

If 1st Total Loss Code = Blank, must be zero.
Otherwise, must be > 0 or < 0. Sum of all
Total Amounts must be > zero for each loss
code by claim number.
If 2nd Total Loss Code = “R”, Must =
Recovery Year or subsequent year.
Otherwise must = zeros.
If 2nd Total Loss Code <> Spaces, must be a
valid company. Otherwise must = zeros.
See 1st Total Loss Code for permitted values.
If 2nd Total Loss Code = E or V must be >
zero. Enter escrow check # or if = ‘P’ enter
credit memo number. Otherwise; zero fill.

133

8

9(08)

23

2nd Total Amount

141

12

S9(10)V(02)

24

3rd Total Reinsurance Year

153

4

9(04)

25

157

3

9(03)

160
161

1
9

X(01)
9(09)

28

3rd Total Payment/Credit
Memo Company
3rd Total Loss Code
3rd Escrow Check/Draft
Number -orP/C Memo State
P/C Memo Policy
3rd Total Date Draft Issued

170

8

9(08)

29

3rd Total Amount

178

12

S9(10)V(02)

30

4th Total Reinsurance Year

190

4

9(04)

31

4th Total Payment/Credit
Memo Company

194

3

9(03)

20
21

26
27

FCIC-APPENDIX III

Begin
Pos

20 - 2

If 2nd Total Loss Code = D or Blank, must be
zeros. Otherwise, if > 0 must be a valid date.
Format is MMDDCCYY.
If 2nd Total Loss Code = Blank, must be zero.
Otherwise, must be > 0 or < 0 for each loss
code by claim number. Sum of all Total
Amounts must be > zero for each loss code by
claim number.
If 3rd Total Loss Code = “R”, Must =
Recovery Year or subsequent year.
Otherwise must = zeros.
If 3rd Total Loss Code <> Spaces, must be a
valid company. Otherwise must = zeros.
See 1st Total Loss Code for permitted values.
If 3rd Total Loss Code = E or V must be >
zero. Enter escrow check # or if = ‘P’ enter
credit memo number. Otherwise; zero fill.
If 3rd Total Loss Code = D or Blank, must be
zeros. Otherwise, if > 0 must be a valid date.
Format is MMDDCCYY.
If 3rd Total Loss Code = Blank, must be zero.
Otherwise, must be > 0 or < 0. Sum of all
Total Amounts must be > zero for each loss
code by claim number.
If 4th Total Loss Code = “R”, Must =
Recovery Year or subsequent year.
Otherwise must = zeros.
If 4th Total Loss Code <> Spaces, must be a
valid company. Otherwise must = zeros.

RY 2008

June 28, 2007

Exhibit 20

FCIC-Appendix III

(LOSS TOTAL RECORD – TYPE 20)
Format/Edits

Field
No.

Field Name

32
33

34

4th Total Loss Code
4th Escrow Check/Draft
Number -orP/C Memo State
P/C Memo Policy
4th Total Date Draft Issued

35

Begin
Pos

Size

Picture

Field Edits

197
198

1
9

X(01)
9(09)

See 1st Total Loss Code for permitted values.
If 4th Total Loss Code = E or V must be >
zero. Enter escrow check # or if = ‘P’ enter
credit memo number. Otherwise; zero fill.

207

8

9(08)

4th Total Amount

215

12

S9(10)V(02)

36
37

Filler
Valid for Escrow Flag

227
342

115
1

X(115)
X(01)

38
39

Filler
FCIC Control Time

343
551

208
4

X(208)
9(04)

40

FCIC Control Date

555

8

9(08)

41

Reinsurance Year

563

4

9(04)

42

Batch Number

567

4

9(04)

43

Transaction Sequence
Number

571

8

9(08)

44
45
46

Transaction Rejected Flag
Transaction Source Flag
Filler

579
580
581

1
1
20

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

If 4th Total Loss Code = D or Blank, must be
zeros. Otherwise, if > 0 must be a valid date.
Format is MMDDCCYY.
If 4th Total Loss Code = Blank, must be zero.
Otherwise, must be > 0 or < 0. Sum of all
Total Amounts must be > zero for each loss
code by claim number.
Must be Blanks.
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.
Must be spaces.
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) MMDD CCYY 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. Reserved.
Internal. Reserved.
Internal.

Note:
The loss code of “D” will be used to process a loss without funding escrow. In order to fund escrow the AIP
must resubmit the records for the policy using a loss code of “E”.

FCIC-APPENDIX III

20 - 3

RY 2008