Payment Record - Type 12 - Format - Edits

June 28, 2007

Exhibit 12

FCIC-Appendix III

(PAYMENT RECORD – TYPE 12)
Format/Edits

Field
No.

Field Name

Begin
Pos

1
2

1
3

2
2

9(02)
X(02)

Required. Must be 12.
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

Type 12 Key Reserve

21

55

X(55)

8
9

Record Number
Payment Type

76
79

3
2

9(03)
X(02)

10

Paid Amount

81

12

S9(10)V9(02)

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 Additional key data
required in the future or for other record types.
Must be > 000 and unique within a policy.
Must be one of the following:
‘00’ = Paid by Insured
‘02’ = CAT fees paid after crop termination
‘03’ = Reversal of CAT fees paid (02)
‘04’ = State Subsidy – If ‘04’ must also
Submit T11 Record.
‘05’ = Producer Premium Payment from a
Livestock Indemnity
Required; Edit as follows:
If Payment Type = 00 Then enter the premium
amount paid by the insured.
If Payment Type = 02 then enter amount of
CAT fees collected, including interest, AFTER
the crop termination date. The paid amount
cannot exceed the total receivable amount
reported on the 65 record. The paid amount is
cumulative.
If Payment Type = 03 then enter the amount of
CAT fees reversal. Amount must be same as
02 reported.
If Payment Type = 04 then enter the amount of
the state subsidy.
If Payment Type = 05 then enter amount of
livestock indemnity applied to producer
premium.
The sum of all paid amounts for a policy must
be ≥ zero.
Note:
Fees and related interest are not included in
Payment Type = ‘00’ or ‘05’. For example, no
$30 or $100 administrative fees should be
included in the paid amount.

FCIC-APPENDIX III

Size

Picture

12 - 1

Field Edits

RY 2008

June 28, 2007

Exhibit 12

FCIC-Appendix III

(PAYMENT RECORD – TYPE 12)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

11

Prepayment Flag

93

1

9(01)

12

Paid Date

94

8

9(08)

13

Payment/Credit Memo
Parent Transaction
Sequence Number

102

8

9(08)

14

Payment/Credit Memo
Parent Contract Number

110

18

X(18)

15

CAT Fee Payment
Validation Flag

128

8

X(08)

If the payment record is submitted before any
Type 11 or 13 Records are submitted for the
policy and the paid amount is greater than
zero, the flag must be = 1. Otherwise the flag
must equal zero.
The date of payment; must be < the current
date. Must be a valid date if the payment type
= ‘00’, ‘02’, ‘03’ or ‘05’ and the paid amount
is > zero. If 02, must be > Debt Delinquency
Date. If 03 date must be same as 02. Date
format must be MMDDCCYY.
Internal Use. The transaction sequence number
of the type 20 record that caused this type 12
record to be created as a Payment/Credit
memo.
Internal Use. The contract number of the type
20 record that caused this type 12 record to be
created as a Payment/Credit memo.
Internal Use.

16

Filler

136

415

X(415)

Must be Spaces.

17

FCIC Control Time

551

4

9(04)

18

FCIC Control Date

555

8

9(08)

19

Reinsurance Year

563

4

9(04)

20

Batch Number

567

4

9(04)

21

Transaction Sequence
Number

571

8

9(08)

22
23
24

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. Reserved
Internal. Reserved
Internal.

FCIC-APPENDIX III

Picture

12 - 2

Field Edits

RY 2008