Production Loss Line Record Type 21

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

P21

1

AIP Code

Character

2

P21
P21

2
3

Reinsurance Year
Record Type Code

Numeric
Character

4
6

P21

4

AIP Policy Producer Key

Character

P21

5

AIP Insurance In Force Key

Character

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must be "2019".
Record Type Code must be "P21".

Y

Y

Y
Y

Y
Y

15

Y

Y

AIP Policy Producer Key must match the parent
primary Policy Producer, "P10" record.

15

Y

Y

AIP Insurance In Force Key must be unique within
the AIP Policy Producer Key.

Y

AIP Acreage Key is the value used to identify each
Acreage, "P11" record and must be unique within
the Reinsurance Year and the parent Insurance In
Force, "P14" record.

P21

6

AIP Acreage Key

Character

15

P21

7

AIP Production Loss Detail Key

Character

15

P21

8

AIP Adjuster Key

Character

15

"*" = Output Only
6/26/2018

File Type:
Reinsurance Year:
Version:
Release Date:

Page 1 of 56

CCYY

Y

Y

AIP Production Loss Detail Key must be unique
within the submitted Production Loss Detail,
"P21" records.
AIP Adjuster Key must match the corresponding
Adjuster, "P56" record when AIP Adjuster Key
exists.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
AIP Adjuster Key is required except when the
Insurance Plan Code equals Area Yield Protection,
"04", Area Revenue Protection, "05", Area
Revenue Protection with Harvest Price Exclusion,
"06", Rainfall Index "13", Margin Protection "16",
Margin Protection with Harvest Price Option "17",
SCO Yield Protection "31", SCO Revenue
Protection "32", SCO Revenue Protection with
Harvest Price Exclusion "33", STAX Revenue
Protection "35", or STAX Revenue with Harvest
Price Exclusion "36", and AIP Employee Key is
empty.
AIP Adjuster Key must be empty when the
Insurance Plan Code equals Area Yield Protection,
"04", Area Revenue Protection, "05", Area
Revenue Protection with Harvest Price Exclusion,
"06", Rainfall Index "13", Margin Protection "16",
Margin Protection with Harvest Price Option "17",
SCO Yield Protection "31", SCO Revenue
Protection "32", SCO Revenue Protection with
Harvest Price Exclusion "33", STAX Revenue
Protection "35", or STAX Revenue with Harvest
Price Exclusion "36".
AIP Adjuster Key must be empty when AIP
Employee Key exists.

"*" = Output Only
6/26/2018

Page 2 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

P21

9

AIP Employee Key

P21

10

Insured Loss Signature Date

"*" = Output Only
6/26/2018

Production Loss Detail
P21

Data Type

Max
Length

Character

15

Date

8

Page 3 of 56

File Type:
Reinsurance Year:
Version:
Release Date:

Format

CCYYMMDD

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
AIP Employee Key is required when Insurance
Plan Code is not one of the following values: "04",
"05", "06", "13", "16", "17", "31", "32", "33", '35",
"36", and AIP Adjuster Key is empty.
AIP Employee Key must be empty when Insurance
Plan Code is one of the following values: "04",
"05", "06", "13", "16", "17", "31", "32", "33",
"35", "36".
AIP Employee Key must be valid; edit with ODS,
Employee ODS "ODS54" record.
AIP Employee Key must be empty when AIP
Adjuster Key exists.
Insured Loss Signature Date is required and
cannot be greater than the Batch Submission
Date or less than the First Notice of Loss Date.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Insured Loss Signature Date is Required when
Insurance Plan Code is not one of the following
values: Area Yield Protection, "04", Area Revenue
Protection, "05", Area Revenue Protection with
Harvest Price Exclusion, "06", Rainfall Index "13",
Margin Protection "16", SCO Yield Protection
"31", Margin Protection with Harvest Price Option
"17", SCO Revenue Protection "32", SCO Revenue
Protection with Harvest Price Exclusion "33",
STAX Revenue Protection "35", or STAX Revenue
with Harvest Price Exclusion "36", and Stage Code
is not "DC".

"*" = Output Only
6/26/2018

Page 4 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Insured Loss Signature Date must be empty when
Insurance Plan Code equals one of the following
values: Area Yield Protection, "04", Area Revenue
Protection, "05", Area Revenue Protection with
Harvest Price Exclusion, "06", Rainfall Index "13",
Margin Protection "16", SCO Yield Protection
"31", Margin Protection with Harvest Price Option
"17", SCO Revenue Protection "32", SCO Revenue
Protection with Harvest Price Exclusion "33",
STAX Revenue Protection "35", or STAX Revenue
with Harvest Price Exclusion "36", and Stage Code
is not "DC".
Insured Loss Signature Date must be empty when
Stage Code is "DC".

"*" = Output Only
6/26/2018

Page 5 of 56

Record
Number

P21

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

11

Field Name

Adjuster Signature Date

Production Loss Detail
P21

Data Type

Date

Max
Length

8

File Type:
Reinsurance Year:
Version:
Release Date:

Format

CCYYMMDD

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Adjuster Signature Date is required when
Insurance Plan Code is not one of the following
values: Area Yield Protection "04", Area Revenue
Protection "05", Area Revenue Protection with
Harvest Price Exclusion "06", Rainfall Index "13",
Margin Protection "16", Margin Protection with
Harvest Price Option "17", SCO Yield Protection
"31", SCO Revenue Protection "32", SCO Revenue
Protection with Harvest Price Exclusion "33",
STAX Revenue Protection "35", or STAX Revenue
with Harvest Price Exclusion "36".
Adjuster Signature Date must be empty when the
Insurance Plan Code equals Area Yield Protection
"04", Area Revenue Protection "05", Area
Revenue Protection with Harvest Price Exclusion
"06", Rainfall Index "13", Margin Protection "16",
Margin Protection with Harvest Price Option "17",
SCO Yield Protection "31", SCO Revenue
Protection "32", SCO Revenue Protection with
Harvest Price Exclusion "33", STAX Revenue
Protection "35", or STAX Revenue with Harvest
Price Exclusion "36".
Adjuster Signature Date must be less than or
equal to the Batch Received Date.

"*" = Output Only
6/26/2018

Page 6 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

P21

12

Claim Number

Numeric

8

99999999

P21

13

AIP Indemnity Amount

Numeric

11

S9999999999

"*" = Output Only
6/26/2018

Page 7 of 56

BUS
Key Req?

Y

Delimited
2019
Approved
7/1/2018

Rules
Adjuster Signature Date must be less than the
Inactive Date from the Adjuster, "P56" record
when the Inactive Date exists.
Adjuster Signature Date must exceed the LRR
Record Accepted Date from an accepted
Insurance In Force, "P14" record when Stage Code
does not equal "P2", "PF", "PT", "R", "RF", "RR",
"RS" or "RT.
Adjuster Signature Date must exceed LRR Change
Date from an accepted Insurance In Force, "P14"
record when the LRR Change Date exists, the LRR
Transaction Code does not equal "01", "05", "06",
"07", "12", "13", "14", "15", "16", "17" or "18"
and the Stage Code does not equal "P2", "PF",
"PT", "R", "RF", "RR", "RS" or "RT" and the Late
Reported Reason Code does not equal "10", "15",
"16" or "17".
Claim Number must equal the Claim Number
from the Loss Total, "P20" record.
AIP Indemnity Amount must equal RMA
calculated Indemnity Amount.
AIP Indemnity Amount must equal "0" when
Stage Code equals "NR" or when Loss Multiple
Cropping Code equals "SW".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
AIP Indemnity Amount must equal zero when
Stage Code does not equal "DC" and a Yield Type
Code equal to "MR" is submitted in Yield Year 10
on the associated Yield History, P15A record.

P21

14

Large Claim Code

Character

1

P21

15

Settlement Flag

Character

1

P21

16

Stage Code

Character

2

"*" = Output Only
6/26/2018

Page 8 of 56

AIP Indemnity Amount must be less than or equal
to the calculated Indemnity Amount when
Insurance Plan Code is "40" and Insurance Option
Code List contains "CV" or "OX".
Large Claim Code must be valid; edit with Large
Claim ICE "D00102".
Large Claim Code must be empty when Stage
Code is "DC".
Settlement Flag equals Yes, "Y" if there is a
Settlement or Finding; otherwise, empty.
Settlement Flag is required when the record exists
in the Settlement table and Stage Code is not
"DC".
Settlement Flag must be empty when Stage Code
is "DC".
Stage Code must be valid; edit with the Stage
Commodity ICE, "D00124"; otherwise, empty.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Stage Code equals any claim inspected by the
Adjuster and denied, "DC", resulting in no
Indemnity payment and the record must contain
Record Type Code, AIP Code, Location State Code,
Commodity Year, Commodity Code, Insurance
Plan Code, Location County Code, Basic or
Optional Unit Number, Type Code, Practice Code,
Claim Number, Adjuster SSN, Determined
Acreage, Determined Tree Count, Adjuster
Signature Date and First Notice of Loss Date.
Stage Code must equal Raisin Reconditioning
Payment (Meets RAC standards), "RR" or
Raisin Reconditioning Payment (RAC standards
not met), "RF" for reconditioning payments when
Commodity Code equals Raisins, "0037"
otherwise, empty for a production loss.
Stage Code must not equal one of the following
values: Raisin Reconditioning Payment (Meets
RAC standards), "RR" or Raisin Reconditioning
Payment (RAC standards not met), "RF" when
Commodity Code equal Raisins, "'0037" and
Coverage Type Code equals Catastrophic, "C".

"*" = Output Only
6/26/2018

Page 9 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Stage Code is Required when Insurance Plan Code
equals Revenue Protection with Harvest Price
Exclusion, "03".
Stage Code must not equal Final Loss ARPI/SCO/STAX Crops Only, "FL" when Insurance
Plan Code is not one of the following values: Area
Yield Protection, "04", Area Revenue Protection,
"05", Area Revenue Protection with Harvest Price
Exclusion, "06", Rainfall Index "13", Margin
Protection "16", SCO Yield Protection "31",
Margin Protection with Harvest Price Option "17",
SCO Revenue Protection "32", SCO Revenue
Protection with Harvest Price Exclusion "33",
STAX Revenue Protection "35", or STAX Revenue
with Harvest Price Exclusion "36".
Stage Code must not equal: Stage 1 or I, "1" or
Stage 2 or II, "2" when Commodity Code is
Onions, "0013" and Guarantee Adjustment Type
Code is empty and Location State Code equals
New York, "36"'.
Stage Code is Required when Commodity Code
equals Canola, "0015".

"*" = Output Only
6/26/2018

Page 10 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Stage Code must not equal: Replanted, "R",
Prevented Planting - Unplanted Acreage, "P2",
Prevented Planting - Unplanted Acreage with 5%
Buy Up Option, "PF" or Prevented Planting Unplanted Acreage with 10% Buy Up Option, "PT"
when CEO Coverage Level Percent is not empty.
Stage Code must not equal: Replanted, "R",
Prevented Planting - Unplanted Acreage, "P2",
Prevented Planting - Unplanted Acreage with 5%
Buy Up Option, "PF" or Prevented Planting Unplanted Acreage with 10% Buy Up Option, "PT"
when Insurance Plan Code equal Revenue
Protection with Harvest Price Exclusion, "03" and
CEO Coverage Level Percent is empty.
Stage Code is Required when Insurance Option
Code List contains "NS" or "DC".
Stage Code must equal "PF" when the Insurance
Option Code List contains "PF" and the Guarantee
Adjustment Type Code equals "E" or "P".
Stage Code must equal "PT" when the Insurance
Option Code List contains "PT" and the Guarantee
Adjustment Type Code equals "E" or "P".

"*" = Output Only
6/26/2018

Page 11 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Stage Code must equal "P2" when the Insurance
Option Code List does not contain '"PF", "PT" or
"SE" and the Guarantee Adjustment Type Code
equals "E" or "P".
Stage Code must equal one of the following
values: "DQ" or "NQ" when the Insurance Option
Code List contains "DC".
Stage Code must equal one of the following
values: "PT", "PF" or "P2" when the Insurance
Option Code List contains "SE" and the Guarantee
Adjustment Type Code is one of the following
values: "E" or "P".
Stage Code is required when Commodity Code
exists in the Stage Commodity ICE "D00124"
record except when Insurance Plan Cod is "50"
and Commodity Code is one of the following:
"0201", "0202", "0203", "0227", "0309", "1302",
"9936".
Stage Code must equal "FL" when Insurance Plan
Code is one of the following values: "04", "05",
"06", "13", "16", "17", "31", "32", "33", "35",
"36".

"*" = Output Only
6/26/2018

Page 12 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Stage Code must not equal one of the following
values: "QU", "QH" when Location State Code is
not equal to "06" or Insurance Option Code List
does not contain "QE".
Stage Code must be empty or "DC" when
Insurance Plan Code is "50" and Commodity Code
is one of the following values: "0201", "0202".
Stage Code must not equal "UA" when
Commodity Code is "0227" and Insurance Plan
Code is "90".
Stage Code must not equal one of the following
values: Replanted, "R" or Not Replanted, "NR"
when Coverage Type Code equals Catastrophic,
"C".
Stage Code must not equal "UH" when
Commodity Code equals Potatoes, "0084" and
Insurance Option Code List contains "CH" or "CL".
Stage Code must not equal one of the following
values: 'PB', 'UB' when Commodity Code is one of
the following values: '0039', '0045'.

"*" = Output Only
6/26/2018

Page 13 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Stage Code must not equal Harvested, 'H', if Pre
QA Appraised Production Amount equal zero and
Pre QA Harvested Production Amount equal zero.

P21

17

Determined Tons

Numeric

11

99999999.99

Determined Tons must equal the total tons
determined for this claim when Commodity Code
equals Raisins, "0037".
Determined Tons must be empty when
Commodity Code is not Raisins, "0037".
Determined Tons must be less than or equal to 24
when Stage Code equals Raisin Reconditioning
Payment (RAC standards not met), RF"."

P21

18

"*" = Output Only
6/26/2018

Determined Acreage

Numeric

11

Page 14 of 56

99999999.99

Determined Tons is required when Stage Code is
"DC" and Determined Acreage is empty and
Determined Pounds is empty and Determined
Tree Count is empty.
Determined Acreage is Required when the
Insurance Plan Code does not equal Tree Based
Dollar Amount of Insurance, "40", Rainfall Index,
"13" or when the Commodity Code does not
equal Raisins, "0037", Oysters, "0115", or
Apiculture, "1191" or PRF, "0088".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Determined Acreage must be empty when the
Insurance Plan Code equals Tree Based Dollar
Amount of Insurance, "40", Rainfall Index, "13" or
when the Commodity Code equals Raisins,
"0037", Oysters, "0115", Apiculture, "1191" or
PRF, "0088".
Determined Acreage must be greater than zero
except when Insurance Plan Code is "13" or "40";
or when Commodity Code is "0037", "0115",
"0088", "1191" or "0332"; or when Insurance Plan
Code is "47" and Commodity Code is "0057",
"0154" or "0227", and Stage Code is "UA".

P21

19

"*" = Output Only
6/26/2018

Determined Tree Count

Numeric

10

Page 15 of 56

9999999999

Determined Acreage is required when Stage Code
is "DC" and Determined Pounds is empty and
Determined Tree Count is empty.
Determined Tree Count is required and must
equal the number of insurable trees when
Insurance Plan Code equals Tree Based Dollar
Amount of Insurance, "40" or Pecan Revenue,
"41", otherwise empty.
Determined Tree Count is required when Stage
Code is "DC" and Determined Acreage is empty
and Determined Pounds is empty and Determined
Tons is empty.

Record
Number
P21

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number
20

Field Name
Determined Pounds

Production Loss Detail
P21

Data Type
Numeric

Max
Length
10

File Type:
Reinsurance Year:
Version:
Release Date:

Format
9999999999

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Determined Pounds is Required when Commodity
Code equals Oysters, "0115" and the Stage Code
equals "R", "RS" or "RT".
Determined Pounds must equal the number of
pounds (Apportioned Landings) for Commodity
Code Oysters, "0115", otherwise empty.
Determined Pounds must be empty when
Commodity Code does not equal Oysters, "0115".

P21

21

First Damage Cause Code

Character

2

Determined Pounds must be empty when
Commodity Code is not Oysters, "0115" or
Mustard, "0069".
Determined Pounds is required when Stage Code
is "DC" and Determined Acreage is empty and
Determined Colonies is empty and Determined
Tons is empty and Determined Tree Count is
empty.
First Damage Cause Code cannot equal "00".
First Damage Cause Code must be valid; edit with
the Damage Cause Commodity ICE, "D00077".
First Damage Cause Code is required when Stage
Code is not "DC".
First Damage Cause Code must be empty when
Stage Code is "DC".

"*" = Output Only
6/26/2018

Page 16 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
First Damage Cause Code is optional.
First Damage Cause Code must not equal "86"
when Insurance Option Code List does not
contain "QE" and First Damage Cause Code exists.

P21

22

"*" = Output Only
6/26/2018

First Damage Date

Date

8

Page 17 of 56

CCYYMMDD

Y

First Damage Date must equal the month of final
payment when the Insurance Plan Code equals
Area Yield Protection "04", Area Revenue
Protection "05", Area Revenue Protection with
Harvest Price Exclusion "06", Rainfall Index "13",
SCO Yield Protection "31", SCO Revenue
Protection "32", SCO Revenue Protection with
Harvest Price Exclusion "33", STAX Revenue
Protection "35", or STAX Revenue with Harvest
Price Exclusion "36".
First Damage Date must be less than or equal to
Adjuster Signature Date when Second Damage
Date is greater than Adjuster Signature Date.
First Damage Date must be less than or equal to
the Batch Received Date when the Stage Code
equals, "DC".
First Damage Date is required when Stage Code is
not "DC".
First Damage Date must be empty when Stage
Code is "DC".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
First Damage Date is optional.

P21

23

First Damage Percent

Numeric

4

9.99

Y

First Damage Percent must equal ".01" to "1.00"
when the First Damage Cause Code is not empty.
First Damage Percent must be empty when the
Insurance Plan Code equals Area Yield Protection
"04", Area Revenue Protection "05", Area
Revenue Protection with Harvest Price Exclusion
"06", Rainfall Index "13", Margin Protection "16",
Margin Protection with Harvest Price Option "17",
SCO Yield Protection "31", SCO Revenue
Protection "32", SCO Revenue Protection with
Harvest Price Exclusion "33", STAX Revenue
Protection "35", or STAX Revenue with Harvest
Price Exclusion "36", or Stage Code equals "DC".
First Damage Percent plus Second Damage
Percent plus Third Damage Percent cannot be
greater than "1.00".
First Damage Percent is required when First
Damage Cause Code exists and First Damage
Cause Code is not equal to "00" and Insurance
Plan Code is not one of the following values: "04",
"05", "06", "13", "16", "17", "31", "32", "33",
"35", "36", and Stage Code is not "DC".

"*" = Output Only
6/26/2018

Page 18 of 56

Record
Number
P21

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number
24

"*" = Output Only
6/26/2018

Field Name
Second Damage Cause Code

Production Loss Detail
P21

Data Type

Max
Length

Character

2

Page 19 of 56

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Second Damage Cause Code cannot equal "00"
when Second Damage Cause Code exists.
Second Damage Cause Code must be valid; edit
with the Damage Cause Commodity ICE,
"D00077".
Second Damage Cause Code must equal zero
when First Damage Percent equal "1.00" or when
Insurance Plan Code equals, Area Yield Protection
"04", Area Revenue Protection "05", Area
Revenue Protection with Harvest Price Exclusion
"06", Rainfall Index "13", Margin Protection "16",
Margin Protection with Harvest Price Option "17",
SCO Yield Protection "31", SCO Revenue
Protection "32", SCO Revenue Protection with
Harvest Price Exclusion "33", STAX Revenue
Protection "35", or STAX Revenue with Harvest
Price Exclusion "36".
Second Damage Cause Code must be empty when
Second Damage Percent is empty or Insurance
Plan Code is one of the following values: "04",
"05", "06", "13", "31", "32", "33", "35", "36", or
Stage Code equals "DC".
Second Damage Cause Code is required when
Second Damage Percent exists and Stage Code is
not "DC".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Second Damage Cause Code must not equal "86"
when Insurance Option Code List does not
contain "QE" and Second Damage Cause Code
exists.

P21

25

Second Damage Date

Date

8

CCYYMMDD

Second Damage Date must equal the month of
final payment when the Insurance Plan Code
equals Area Yield Protection "04", Area Revenue
Protection "05", Area Revenue Protection with
Harvest Price Exclusion "06", Rainfall Index "13",
Margin Protection "16", Margin Protection with
Harvest Price Option "17", SCO Yield Protection
"31", SCO Revenue Protection "32", SCO Revenue
Protection with Harvest Price Exclusion "33",
STAX Revenue Protection "35", or STAX Revenue
with Harvest Price Exclusion "36".
Second Damage Date must be less than or equal
to Batch Received Date.
Second Damage Date is required when Second
Damage Percent exists and Stage Code is not
"DC".
Second Damage Date must be empty when
Second Damage Percent is empty or Stage Code
equals "DC".

"*" = Output Only
6/26/2018

Page 20 of 56

Record
Number
P21

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number
26

Field Name
Second Damage Percent

Production Loss Detail
P21

Data Type
Numeric

Max
Length
4

File Type:
Reinsurance Year:
Version:
Release Date:

Format
9.99

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Second Damage Percent must equal ".01" to
"0.99" when the Second Damage Cause Code is
not empty.
Second Damage Percent plus First Damage
Percent plus Third Damage Percent cannot be
greater than "1.00".
Second Damage Percent must be empty when the
Insurance Plan Code equals Area Yield Protection
"04", Area Revenue Protection "05", Area
Revenue Protection with Harvest Price Exclusion
"06", Rainfall Index "13", Margin Protection "16",
Margin Protection with Harvest Price Option "17",
SCO Yield Protection "31", SCO Revenue
Protection "32", SCO Revenue Protection with
Harvest Price Exclusion "33", STAX Revenue
Protection "35", or STAX Revenue with Harvest
Price Exclusion "36", or Stage Code equals "DC".

P21

27

"*" = Output Only
6/26/2018

Third Damage Cause Code

Character

2

Page 21 of 56

Second Damage Percent is required when
Insurance Plan Code is not one of the following
values: "04", "05", "06", "13", "16", "17", "31",
"32", "33", "35", "36", and Second Damage Cause
Code exists and Stage Code is not "DC".
Third Damage Cause Code cannot equal "00"
when Third Damage Cause Code exists.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Third Damage Cause Code must be valid; edit with
the Damage Cause Commodity ICE, "D00077".
Third Damage Cause Code must equal zero when
First Damage Percent equal "1.00" or when
Insurance Plan Code equals, Area Yield Protection
"04", Area Revenue Protection "05", Area
Revenue Protection with Harvest Price Exclusion
"06", Rainfall Index "13", Margin Protection "16",
Margin Protection with Harvest Price Option "17",
SCO Yield Protection "31", SCO Revenue
Protection "32", SCO Revenue Protection with
Harvest Price Exclusion "33", STAX Revenue
Protection "35", or STAX Revenue with Harvest
Price Exclusion "36".
Third Damage Cause Code must be empty when
Third Damage Percent is empty or Insurance Plan
Code is one of the following values: "04", "05",
"06", "13", "16", "17", "31", "32", "33", "35",
"36", or Stage Code equals "DC".
Third Damage Cause Code is required when Third
Damage Percent exists and Stage Code is not
"DC".

"*" = Output Only
6/26/2018

Page 22 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Third Damage Cause Code must not equal "86"
when Insurance Option Code List does not
contain "QE" and Third Damage Cause Code
exists.

P21

28

Third Damage Date

Date

8

CCYYMMDD

Third Damage Date must equal the month of final
payment when the Insurance Plan Code equals
Area Yield Protection "04", Area Revenue
Protection "05", Area Revenue Protection with
Harvest Price Exclusion "06", Rainfall Index "13",
Margin Protection "16", Margin Protection with
Harvest Price Option "17", SCO Yield Protection
"31", SCO Revenue Protection "32", SCO Revenue
Protection with Harvest Price Exclusion "33",
STAX Revenue Protection "35", or STAX Revenue
with Harvest Price Exclusion "36".
Third Damage Date is required when Third
Damage Percent exists and Stage Code is not
"DC".
Third Damage Date must be empty when Third
Damage Percent is empty or Stage Code equals
"DC".

P21

29

"*" = Output Only
6/26/2018

Third Damage Percent

Numeric

4

Page 23 of 56

9.99

Third Damage Percent must equal ".01" to "0.98"
when the Third Damage Cause Code is not empty.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Third Damage Percent plus First Damage Percent
plus Second Damage Percent must not be greater
than "1.00".
Third Damage Percent must be empty when the
Insurance Plan Code equals Area Yield Protection
"04", Area Revenue Protection "05", Area
Revenue Protection with Harvest Price Exclusion
"06", Rainfall Index "13", Margin Protection "16",
Margin Protection with Harvest Price Option "17",
SCO Yield Protection "31", SCO Revenue
Protection "32", SCO Revenue Protection with
Harvest Price Exclusion "33", STAX Revenue
Protection "35", or STAX Revenue with Harvest
Price Exclusion "36", or Stage Code equals "DC".

P21

30

"*" = Output Only
6/26/2018

WA Number

Character

9

Page 24 of 56

999999999

Third Damage Percent is required when Insurance
Plan Code is not one of the following values: "04",
"05", "06", "13", "16", "17", "31", "32", "33",
"35", "36", and Third Damage Cause Code exists
and Stage Code is not "DC".
WA Number must be valid.
WA Number must not equal "000000000".
WA Number is Required when WA Number was
submitted on the Acreage, "P11" record and
Stage Code is not "DC".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

P21

31

Replant Payment Flag

Character

1

P21

32

Gleaned Acreage Code

Character

2

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
WA Number must be empty when Coverage Type
Code equals Catastrophic, "C" or Stage Code is
"DC".
Replant Payment Flag equal Yes, "Y" when the
Policyholder is entitled up to 100% of the replant
cost or No, "N" when the Policyholder is entitled
to the normal replant reimbursement.
Replant Payment Flag must be empty when Stage
Code is "DC".
Gleaned Acreage Code must be valid; edit with
the Gleaned Acreage Commodity ICE , "D00126".
Gleaned Acreage Code must be empty when
Stage Code is "DC".

P21

33

Harvested Production Quantity

Numeric

11

99999999.99

Harvested Production Quantity field corresponds
with the Production Worksheet field number 66,
"(Harvest) Production To Count".
Harvested Production Quantity must be less than
or equal to the Production to Count Quantity,
otherwise empty.
Harvested Production Quantity must be reported
in whole dollars for Insurance Plan Code equal
Actual Revenue History, "47".

"*" = Output Only
6/26/2018

Page 25 of 56

Record
Number

P21

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

34

Field Name

Production To Count Quantity

Production Loss Detail
P21

Data Type

Numeric

Max
Length

11

File Type:
Reinsurance Year:
Version:
Release Date:

Format

99999999.99

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Harvest Production Quantity is required when
Sugar Factor exists and Stage Code is not "DC".
Harvest Production Quantity must be empty
when Stage Code is "DC".
Harvested Production Quantity is in Unit of
Measure (BU, LBS, etc) for Insurance Plan Codes,
"01, 02, 03".
Production To Count Quantity field corresponds
with the sum of Production Worksheet field
number 38, "Total To Coun"t and field number 66,
"Production To Count".
Production to Count Quantity must equal the sum
of the Net Harvested, Net Allocated and Net
Appraised Production. Adjusted for moisture and
quality.
Production to Count Quantity is used to calculate
Unit Deficiency Quantity and may equal zero.
Production to Count Quantity must be reported in
whole dollars for Insurance Plan Code Actual
Revenue History, "47".

"*" = Output Only
6/26/2018

Page 26 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Production to County Quantity must equal
Guarantee Amount * 0.50 rounded to a whole
number, when the Commodity Code equals
Forage Seeding, "0032" and the Stage Code
equals Spring-seeded acreage with 56-74% stand,
"S".
Production To Count Quantity must be empty
when Stage Code equals "DC".
Production to Count Quantity is in Unit of
Measure (BU, LBS, etc) for Insurance Plan Codes,
'01', '02', '03'.
When Quality Adjustment applies to the
Commodity per Quality Adjustment Commodity
ICE, "D00163", Post QA Appraised value cannot
be NULL if Pre QA Appraised value is submitted
and Total Production Amount is greater than or
equal to zero.
When Quality Adjustment applies to the
Commodity per Quality Adjustment Commodity
ICE, "D00163", Harvested Production Quantity
field cannot be empty if Pre QA Harvested field is
submitted and Production to Count Quantity is
greater than or equal to zero and Total
Production Amount is greater than or equal to
zero.

"*" = Output Only
6/26/2018

Page 27 of 56

Record
Number

P21

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

35

"*" = Output Only
6/26/2018

Field Name

Sugar Factor

Production Loss Detail
P21

Data Type

Numeric

Max
Length

5

Page 28 of 56

File Type:
Reinsurance Year:
Version:
Release Date:

Format

9.999

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
When Quality Adjustment applies to the
Commodity per Quality Adjustment Commodity
ICE, "D00163", Post QA Appraised Production
Amount AND Harvested Production Quantity
cannot be NULL if Pre QA Appraised Production
Amount AND Pre QA Harvested Production
Amount fields are not NULL and Production to
Count Quantity is greater than or equal to zero
and Total Production Amount is greater than or
equal to zero.
Sugar Factor must be greater than zero when
Commodity Code equals Sugar Beets, "0039" and
Harvested Production Quantity is greater than
zero; otherwise, empty.
Sugar Factor must be empty when Commodity
Code is not equal to Sugar Beets, "0039" or
Harvested Production Quantity is empty or
Harvested Production Quantity equals zero or
Stage Code equals "DC".

Record
Number

P21

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

36

Field Name

AIP Acre Stage Guarantee Amount

Production Loss Detail
P21

Data Type

Numeric

Max
Length

11

File Type:
Reinsurance Year:
Version:
Release Date:

Format

99999999.99

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
AIP Acre Stage Guarantee Amount must equal the
dollars and cents per ton for Raisin
Reconditioning Payments when Stage Code
equals Raisin Reconditioning Payment (Meets RAC
standards), "RR" or Raisin Reconditioning
Payment (RAC standards not met), "RF" and
Commodity Code equals Raisins, "0037".
AIP Acre Stage Guarantee Amount is Required
when Stage Code equals Replanted, "R", Raisin
Reconditioning Payment (RAC standards not met)
"RF", Raisin Reconditioning Payment (Meets RAC
standards) "RR", Replanted Seeded "RS", or
Replanted Transplants "RT" and the Insurance
Plan Code does not equal Yield Protection "01",
Revenue Protection "02", or Revenue Protection
with Harvest Price Exclusion "03" (exception Dry
Beans, "0047").
AIP Acre Stage Guarantee Amount must be empty
when the Stage Code does not equal Replanted,
"R", Raisin Reconditioning Payment (RAC
standards not met) "RF", Raisin Reconditioning
Payment (Meets RAC standards) "RR", Replanted
Seeded "RS", or Replanted Transplants "RT".

"*" = Output Only
6/26/2018

Page 29 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
AIP Acre Stage Guarantee Amount must be empty
when the Stage Code equals Replanted, "R",
Raisin Reconditioning Payment (RAC standards
not met) "RF", Raisin Reconditioning Payment
(Meets RAC standards) "RR", Replanted Seeded
"RS", or Replanted Transplants "RT", and the
Insurance Plan Code equals Yield Protection "01",
Revenue Protection "02", or Revenue Protection
with Harvest Price Exclusion "03" (exception Dry
Beans, "0047").
Not applicable for Peanuts, "0075".
AIP Acre Stage Guarantee Amount is Required
when Stage Code equals Replanted, "R", and
Commodity Code equals Dry Beans under Combo
(Insurance Plan Codes 01, 02, 03) or APH
(Insurance Plan Code 90). The value converted to
pounds per Dry Beans Loss Adjustment
Handbook.

"*" = Output Only
6/26/2018

Page 30 of 56

Record
Number

P21

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

37

"*" = Output Only
6/26/2018

Field Name

Multiple Cropping Exception Flag

Production Loss Detail
P21

Data Type

Character

Max
Length

1

Page 31 of 56

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Y

Delimited
2019
Approved
7/1/2018

Rules
Multiple Cropping Exception Flag equal Yes, "Y" when
any P21 record contains a Multiple Cropping Code
equal to 65% Reduction in Indemnity on first
commodity, "IR" and there are additional P21 records
for the Unit containing any of the following; Multiple
Cropping Codes, 100% Indemnity or PP with Double
Cropping history, "DC", 100% Indemnity (second crop
planted and no other crop applies), "FC", Waives
Indemnity on second commodity, "WI", 100%
Indemnity on second commodity acreage, "SC", 100%
Indemnity (no second commodity for PP or no insured
second commodity for planted acreage), "NS" or
Restore Indemnity on PP Payment (no loss on second
commodity or no second planted commodity for PP,
"RI" exists, then sum these P21 record Indemnities and
if less than or equal to zero apply ".35" to all of the
lines in the unit except any containing a Multiple
Cropping Code equal to Waived indemnity on second
crop acreage, "SW" or Guarantee Reduction Code
equal to Prevented Planning, "P", company verified
eligible PP acres from another unit and or commodity
or qualifying commodity payment acres does not
constitute 20 acres or 20% of the unit, "E", otherwise,
No, "N".

Record
Number

P21

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

38

Field Name

Loss Multiple Cropping Code

Production Loss Detail
P21

Data Type

Character

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Multiple Cropping Exception Flag must be empty
when Stage Code is "DC".
Loss Multiple Cropping Code must be valid; edit
with the Multiple Cropping ICE, "D00063".

2

Loss Multiple Cropping Code is only allowed for
valid Insurance Plan and Commodity Code
combinations as defined in the Multiple Cropping
Insurance Plan Commodity ICE, "D00054" record.

P21

39

Liability Adjustment Factor

Numeric

8

9.999999

Loss Multiple Cropping Code must be empty
when Stage Code is one of the following values:
"R", "RF", "RR", "RS", "RT", "DC".
Liability Adjustment Factor is by "P21" record in a
Unit Structure by Payment Type Code.
Liability Adjustment Factor must be empty when
Stage Code is "DC".
Reported Liability Before Share Amount and
Determined Liability Before Share Amount must
be submitted when Liability Adjustment Factor
(LAF) is applicable (i.e., LAF is less than 1.000000).

P21

40

"*" = Output Only
6/26/2018

Claim Process Code

Character

1

Page 32 of 56

Claim Process Code must be valid; edit with the
Claim Process ICE, "D00071".
Claim Process Code must be empty when Stage
Code is "DC".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

P21

41

Price Indicator Code

P21

42

First Notice of Loss Date

"*" = Output Only
6/26/2018

Production Loss Detail
P21

Data Type

Max
Length

Character

1

Date

8

Page 33 of 56

File Type:
Reinsurance Year:
Version:
Release Date:

Format

CCYYMMDD

BUS
Key Req?

Y

Delimited
2019
Approved
7/1/2018

Rules
Price Indicator Code must be valid; edit with the
Price Indicator ICE, "D00034".
Price Indicator Code must equal the associated
P14 Price Indicator Code when Price Indicator
Code is not equal to "H".
Price Indicator Code must equal Harvest Price,
“H” when Claim Processing code equals Simplified
Claim, “S” and Insurance Plan Code equals
Revenue Protection, “02” or Revenue Protection
with Harvest Price Exclusion, “03” if the Harvest
Price causes the indemnity to exceed the
Simplified Claims Processing Limit.
Price Indicator Code must be empty when Stage
Code is "DC".
First Notice of Loss Date must not be greater than
the Batch Received Date.
First Notice of Loss Date must equal the date the
insured provided the first notice of loss.

Record
Number

P21

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

43

"*" = Output Only
6/26/2018

Field Name

Last Notice of Loss Date

Production Loss Detail
P21

Data Type

Date

Max
Length

8

Page 34 of 56

File Type:
Reinsurance Year:
Version:
Release Date:

Format

CCYYMMDD

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
First Notice of Loss Date must equal NULL when
the Insurance Plan Code equals Area Yield
Protection "04", Area Revenue Protection "05",
Area Revenue Protection with Harvest Price
Exclusion "06", Rainfall Index "13", Margin
Protection "16", Margin Protection with Harvest
Price Option "17", SCO Yield Protection "31", SCO
Revenue Protection "32", SCO Revenue
Protection with Harvest Price Exclusion "33",
STAX Revenue Protection "35", or STAX Revenue
with Harvest Price Exclusion "36".
First Notice of Loss Date is required when
Insurance Plan Code is not one the following
values: "04", "05", "06", "13", "16", "17", "31",
"32", "33", "35", "36", and Stage Code equals "R",
"RS", "RT" or Stage Code equals "DC".
Last Notice of Loss Date must not be greater than
the Batch Received Date.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Last Notice of Loss Date must equal NULL when
the Insurance Plan Code equals Area Yield
Protection "04", Area Revenue Protection "05",
Area Revenue Protection with Harvest Price
Exclusion "06", Rainfall Index "13", Margin
Protection "16", "Margin Protection with Harvest
Price Option "17", SCO Yield Protection "31", SCO
Revenue Protection "32", SCO Revenue
Protection with Harvest Price Exclusion "33",
STAX Revenue Protection "35", or STAX Revenue
with Harvest Price Exclusion "36".

P21

44

Audit Correction Flag

Character

1

P21

45

Revenue Conversion Production To Count
Quantity

Numeric

11

"*" = Output Only
6/26/2018

Page 35 of 56

99999999.99

Last Notice of Loss Date must be empty when
Insurance Plan Code equals "04", "05", "06", "13",
"16", "17", "31", "32", "33", "35", "36", and Stage
Code does not equal "R", "RS", "RT" or Stage Code
equals "DC".
Audit Correction Flag must equal Yes, "Y"
indicating that the Audit is Corrected or No, "N"
indicating the Audit Correction is not applicable.
Audit Correction Flag must be empty when Stage
Code is "DC".
Revenue Conversion Production To Count is not
applicable when Stage Code equals R, RF, RR, RS,
RT, P2, PF or PT.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Revenue Conversion Production To Count
Quantity is required for the following: when
Insurance Plan Code equals"47" and Production
To Count Quantity is greater than zero and Stage
Code is not equal to "DC"; or when Insurance Plan
Code equals "90" and Commodity Code equals
"0132" (Cucumbers) and Production To Count
Quantity is greater than zero and Stage Code is
not equal to "DC".
Revenue Conversion Production To Count
Quantity must be empty for the following: when
Insurance Plan Code is not equal to "47" and
Insurance Plan Code is not equal to "90"; when
Insurance Plan Code equals "90" and Commodity
Code is not equal to "0132" (Cucumbers); when
Production To Count Quantity is empty or zero; or
when Stage Code equals "DC", "R", "RF", "RR",
"RS", "RT", "P2", "PF" or "PT".
Revenue Conversion Production to Count
Quantity is the dollar value as addressed in P21_1
and P21_2 for Insurance Plan Codes, '01', '02',
'03'.

"*" = Output Only
6/26/2018

Page 36 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

P21

46

MisReported Information Factor

Numeric

8

9.999999

P21

47

Stage Percent Factor

Numeric

4

9.99

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
MisReported Information Factor must be the
same value for all records in a Unit Structure by
Payment Type Code.
MisReported Information Factor must be empty
when Stage Code is "DC".
Stage Percent Factor is Required when
Commodity Code equals, Onions, "0013" and
Stage Code equals "1" or "2".
Stage Percent Factor must be empty when
Commodity Code does not equal to Onions,
"0013", Sweet Potatoes, "0156" or Commodity
Code equals Onions, "0013" and the Stage Code is
not equal to "1" or "2" or Commodity Code equals
Sweet Potatoes, "0156" and the Insurance Plan
Code does not equal "90" and the Stage Code
equals "I" or "M" or Stage Code equals "DC".
Stage Percent Factor must be valid; edit with the
Stage Factor ICE, "D00069" record when the
Commodity Code does not equal Sweet Potatoes,
"0156" and the Insurance Plan Code does not
equal "90" and the Stage Code does not equal "I"
or "M" and the Stage Percent Factor exists.

"*" = Output Only
6/26/2018

Page 37 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Stage Percent Factor must be valid; edit with the
Stage Price Percent Factor in the Stage Factor ICE,
"D00069" record when the Stage Percent Factor
exists and the Commodity Code equals Sweet
Potatoes, "0156" and the Insurance Plan Code
equals "90" and the Stage Code equals "I" or "M".

P21

48

Pre QA Appraised Production Amount

Numeric

11

99999999.99

P21

49

Post QA Appraised Production Amount

Numeric

11

99999999.99

"*" = Output Only
6/26/2018

Page 38 of 56

Pre QA Appraised Production Amount
corresponds with the Production Worksheet field
number 34, "Production Pre QA".
Pre QA Appraised Production Amount must be
empty when Stage Code is "DC".
Pre QA Appraised Production Amount is required
if Post QA Appraised Production Amount greater
than zero.
Post QA Appraised Production Amount
corresponds with the Production Worksheet field
number 36, "Production Post QA".
Post QA Appraised Production Amount must be
empty when Stage Code is "DC".
Post QA Appraised Production Amount cannot be
greater than Pre QA Appraised Production
Amount.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

P21

50

Uninsured Cause Production Amount

Numeric

11

99999999.99

P21

51

Pre QA Harvested Production Amount

Numeric

11

99999999.99

P21

52

Total Production Amount

Numeric

11

99999999.99

"*" = Output Only
6/26/2018

Page 39 of 56

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Uninsured Cause Production Amount corresponds
to the Production Worksheet field number 37,
"Uninsured Causes".
Uninsured Cause Production Amount must be
empty when Stage Code is "DC".
Pre QA Harvested Production Amount
corresponds with the Production Worksheet field
number 63, Production "Pre QA".
Pre QA Harvested Production Amount must be
empty when Stage Code is "DC".
Pre QA Harvested Production Amount must be
greater than zero when Harvested Production
Quantity greater than zero.
Total Production Amount corresponds with the
Production Worksheet field number 70, "Unit
Total".
Total Production Amount must be empty when
Stage Code is "DC".
Total Production Amount is Required when Pre
QA Harvested Production Amount exists.
Total Production Amount must be greater than or
equal to Pre QA Appraised Production Amount
and Pre QA Harvested Production Amount when
Insurance Plan Code is one of the following
values: '40', '41', '47', '50', '51', '55'.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Total Production Amount is Required when
Production Record Type Code is not 'L'.
Total Production Amount must be empty when
Production Record Type Code is 'L'.
Total Production Amount must be equal to zero 
when Production Record Type Code equals 'Z' or
Yield Descriptor Code equals 'Z'
Total Production Amount should reflect the "unit
total" of production worksheet.

P21

53

QA Type Code List

Character

8

QA Type Code List corresponds with the
Production Worksheet field number 40, "Quality".
QA Type Code List must be valid for each
delimited value; edit with the QA Type ICE,
"D00145" record.
QA Type Code List must be empty when Stage
Code is "DC".
QA Type Code List must be other than '00' when
Pre QA Appraised Production Amount is greater
than Post QA Appraised Production Amount.
QA Type Code List must be other than '00' when
Pre QA Harvested Production Amount is greater
than Total Production Amount and Insurance Plan
Code is one of the following values: '01', '02', '03'.

"*" = Output Only
6/26/2018

Page 40 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
QA Type Code List must be other than '00' when
Pre QA Harvested Production Amount is greater
than Total Production Amount and Insurance Plan
Code is one of the following values: '01', '02', '03'.

P21

54

Mycotoxin Level Flag

Character

1

P21

55

Reported Liability Before Share Amount

Numeric

10

"*" = Output Only
6/26/2018

Page 41 of 56

9999999999

QA Type Code List must be other than '00' if Pre
QA Harvested Production Amount is greater than
Harvested Production Quantity.
Mycotoxin Level Flag corresponds with the
Production Worksheet field 41, "Mycotoxins
exceed FDA, State or other health organization
maximums".
Mycotoxin Level Flag must equal Yes, "Y" when
entered otherwise empty.
Mycotoxin Level Flag must be empty when Stage
Code is "DC".
Reported Liability Before Share Amount must be
submitted when Liability Adjustment Factor (LAF)
is applicable (i.e., not 'NULL' or '1.000000').
Otherwise empty.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Reported Liability Before Share Amount is the
calculated dollar Total Guarantee Amount (e.g.,
liability without insured share percent) based on
original information provided on the acreage
report line that was used in determination of LAF.

P21

56

Determined Liability Before Share Amount

Numeric

10

P21

57

Associated AIP Production Loss Detail Key

Character

15

"*" = Output Only
6/26/2018

Page 42 of 56

9999999999

Determined Liability Before Share Amount must
be submitted when Liability Adjustment Factor
(LAF) is applicable (i.e., not 'NULL' or '1.000000').
Otherwise empty.
Determined Liability Before Share Amount is the
calculated dollar Total Guarantee Amount (e.g.,
liability without insured share percent) based on
information determined to be correct by the AIP,
including revised acres and corrected APH or
practice/type/variety that was used in
determination of LAF.
The P21 record Associated AIP Production Loss
Detail Key is required if the Margin Protection
policy also has a P21 record; otherwise, it must be
empty.
The Associated AIP Production Loss Detail Key
must be empty when the Insurance Plan Code is
not one of the following values: '01', '02', '03'.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
When the Insurance Plan Code equals '01', '02', or
'03' and the Associated AIP Production Loss Detail
Key exists there must also exist one and only one
P21 record for Margin Protection, Insurance Plan
Code 16 or 17, linked to this base P21.

P21

*

58

Acre Stage Guarantee Amount

Numeric

11

99999999.99

P21

*

59

Unit Deficiency Quantity

Numeric

12

S99999999.99

"*" = Output Only
6/26/2018

Page 43 of 56

AIP Acre Stage Guarantee Amount cannot be
greater than Max (125, Round (Maximum Replant
Guarantee Per Acre Amount * Coverage Level
Percent, 2)) when Stage Code equals Raisin
Reconditioning Payment (Meets RAC standards)
"RR" and the Insurance Plan Code equals Dollar
Amount of Insurance, "50".
AIP Acre Stage Guarantee Amount must be less
than or equal to Maximum Replant Guarantee Per
Acre Amount when Insurance Plan Code equals
Dollar Amount of Insurance, "50" and Stage Code
equals Replanted, "R".
Unit Deficiency Quantity less than or equal to zero
indicates that the Indemnity is less than or equal
to zero.
Unit Deficiency Quantity must equal zero for
Raisin Reconditioning Payments and IP.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Unit Deficiency Quantity must equal zero when
the Insurance Plan Code equals Area Yield
Protection "04", Area Revenue Protection "05",
Area Revenue Protection with Harvest Price
Exclusion "06", Rainfall Index "13", SCO Yield
Protection "31", SCO Revenue Protection "32",
SCO Revenue Protection with Harvest Price
Exclusion "33", STAX Revenue Protection "35", or
STAX Revenue with Harvest Price Exclusion "36".

P21

*

60

Loss Guarantee Amount

Numeric

11

99999999.99

P21

*

61

Second Commodity Waived Indemnity
Amount

Numeric

11

S9999999999

P21

*

62

Preliminary Indemnity Amount

Numeric

11

S9999999999

"*" = Output Only
6/26/2018

Page 44 of 56

Loss Guarantee Amount must be empty for Raisin
Reconditioning Payments.

Second Commodity Waived Indemnity Amount
must equal the calculated indemnity for the
Commodity Code, Insurance Plan Code when the
Loss Multiple Cropping Code equals Waived
Indemnity on Second Commodity Acreage, "SW".
Preliminary Indemnity Amount is the calculated
Indemnity before the Multiple Cropping Factor is
applied.
Preliminary Indemnity Amount must be zero
when Stage Code equal "R", "RR", "RS" or "RT".

Record
Number

P21

Output

Application Source:
File Group:
Record Name:
Record Code:

*

Field
Number

63

Field Name

Indemnity Amount

Production Loss Detail
P21

Data Type

Numeric

Max
Length

11

File Type:
Reinsurance Year:
Version:
Release Date:

Format

S9999999999

BUS
Key Req?

Y

Delimited
2019
Approved
7/1/2018

Rules
Indemnity Amount is the total of all Production
Loss Detail, "P21", Indemnity Fields for a given
Claim Number and must equal the sum of the
Total fields for all of the corresponding Loss Total
"P20" records.
Indemnity Amount must equal zero when the
Loss Multiple Cropping Code equals Waived
Indemnity on Second Commodity Acreage, "SW".

P21

*

64

Valid Escrow Flag

Character

1

P21

*

65

Initial Accepted Batch Number

Numeric

5

99999

P21

*

66

Initial Accepted Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

"*" = Output Only
6/26/2018

Page 45 of 56

Indemnity Amount may be a negative amount by
commodity when the Insurance Plan Code equals
Revenue Assurance, "03" and the Basic Unit
Option Code equals "WU".
Valid Escrow Flag is for internal use and will be
Yes. "Y" when the record passed edits necessary
for Escrow Processing; otherwise, No, "N"
indicating the record did not pass the edits for
Escrow Processing.
Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.
Initial Accepted Date is the original date assigned
when this record was first received at RMA.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

P21

*

67

Batch Received Date

P21

*

68

P21

*

P21

*

Production Loss Detail
P21

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

Batch Number

Numeric

5

99999

69

Batch Record ID

Numeric

15

70

Process Result Code

Character

1

"*" = Output Only
6/26/2018

Field Name

Page 46 of 56

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Batch Received Date is the date that the AIP file is
received by RMA.
Batch Number is a sequential number assigned
when an AIP file is received.
Batch Record ID is a sequential number assigned
to each record in the AIP file by RMA during
processing. Batch Record ID is unique within the
record type for the batch.
Process Result Code equals the final result code
as determined by PASS processing, refer to the
Process Result ICE, "D00002" for values.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules

Record Level Rules

"*" = Output Only
6/26/2018

1

When the COI Questionnaire Completion Date on
the Adjuster, "P56" record or on the Employee,
"P54" record is empty, the associated Production
Loss Detail, "P21" and Inventory Loss Detail,
"P22" records will be rejected.

2

The Production Loss Detail, "P21" record requires
a previously accepted Acreage, "P11" record.

Page 47 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
If any of the Production Loss Detail, "P21" records
within a unit has a Multiple Cropping Code of "IR"
and there are other Production Loss Detail, "P21"
lines with any of the following codes (DC, FC, WI,
SC, NS, RI) then sum the Preliminary Indemnities
of the lines with any of the codes in parenthesis,
and if the sum of these lines is less than or equal
to 0, then apply .35 to all of the lines in the unit
except any line with a Multiple Cropping Code of
"SW" or any line with a Guarantee Adjustment
Type Code from the Acreage, "P11" record equals
"P" or "E" and require that the Multiple Cropping
Exception Flag have an "Y" on these same lines.
The lines with "DC, FC, WI, SC, NS, RI" would
normally be calculated at 100% Indemnity unless
this exceptions exists.

3

"*" = Output Only
6/26/2018

File Type:
Reinsurance Year:
Version:
Release Date:

Page 48 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
For a denied Production Loss Detail, "P21" Record
being submitted to RMA the following fields must
be populated: Fields 1 - 8 AIP Code, Reinsurance
Year, Record Type Code, AIP Policy Producer Key,
Crop Code, AIP Insurance In Force Key, AIP
Acreage Key, AIP Claim Key, AIP Adjuster Key,
Claim Number, Stage Code (DC = Any claim
inspected by the adjuster and denied, resulting in
no indemnity payment), Determined Tons,
Determined Acreage, Determined Colonies,
Determined Tree Count, Determined Pounds or
Determined Contracted Pounds, Loss Adjuster
Signature Date and First Notice of Loss Date.

4

The Production Loss Detail, "P21" record date
entries in field 43, First Notice of Loss Date and
field 44, Last Notice of Loss Date are required
only for the cause(s) of loss reported on the
record. One of the Dates of Damage must be
greater than or equal to field 43, First Notice of
Loss Date.
The Production Loss Detail, "P21" record will not
be accepted when processing has been
suspended on this record type.

5

6

"*" = Output Only
6/26/2018

File Type:
Reinsurance Year:
Version:
Release Date:

Page 49 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
A Related Loss Total, "P20" record must be free of
errors for the Production Loss Detail, "P21"
record to be accepted when Stage Code is not
"DC".
All Production Loss Detail, "P21" records for the
corresponding Loss Total, "P20" record must be
accepted when Stage Code is not "DC".
For the P21 record to be accepted there must be
a corresponding P14 record accepted in this
batch.

7

8

9

10

When a parent record type fails with established
LRR or Escrow Fund recorded (where Process
Result Code equals "K") the child record type will
fail as well (with Process Result Code equals "R").

11

First Damage Percent + Second Damage Percent +
Third Damage Percent cannot be greater than 1.

12

Unable to perform the Corporate Calculation,
because one or more of the following fields has
failed validation: Insured Share Percent, Liability
Adjustment Factor, Misreported Information
Factor, Determined Commodity Quantity or
Commodity Year.

"*" = Output Only
6/26/2018

Page 50 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules

13

Unable to perform the Combo Indemnity
Corporate Calculation, because one or more of
the following fields has failed validation:
Determined Acreage, Liability Adjustment Factor
or Production To Count Quantity.

14

Unable to perform the Group Protection
Indemnity Corporate Calculation, because one or
more of the following fields has failed validation:
Commodity Year, Insured Share Percent, Liability
Adjustment Factor, Misreported Information
Factor, Applicable Determined Value (Acreage,
Pounds, Tons or Colonies), Multiple Commodity
Adjustment Factor or Payment Calculation Factor.

15

Unable to perform the Tree Based Dollar Amount
Of Insurance Indemnity Corporate Calculation,
because one or more of the following fields has
failed validation: Liability Adjustment Factor,
Production To Count Quantity, Determined Value
(Acreage, Pounds or Tons), Misreported
Information Factor or Insured Share Percent.

"*" = Output Only
6/26/2018

Page 51 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules

16

Unable to perform the Pecan Revenue Indemnity
Corporate Calculation, because one or more of
the following fields has failed validation:
Guarantee Adjustment Factor, Determined
Commodity Quantity, Liability Adjustment Factor,
Production To Count Quantity, Price Election
Percent, Insured Share Percent, Misreported
Information Factor, Applicable Determined Value
(Acreage, Pounds, Tons or Colonies), Multiple
Commodity Adjustment Factor or Dollar Amount
Of Insurance.

17

Unable to perform the Actual Revenue History
Indemnity Corporate Calculation, because one or
more of the following fields has failed validation:
Applicable Determined Value (Acreage, Pounds,
Tons or Colonies), Liability Adjustment Factor,
Production To Count Quantity, Price Election
Percent, Commodity Year, Approved Yield,
Coverage Level Percent, Insured Share Percent,
Type Code or Practice Code.

"*" = Output Only
6/26/2018

Page 52 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules

18

Unable to perform the Dollar Amount/ Fixed
Dollar Amount of Insurance Indemnity Corporate
Calculation, because one or more of the following
fields has failed validation: Insured Share Percent,
Liability Adjustment Factor, Misreported
Information Factor, Acre Stage Guarantee
Amount, Applicable Determined Value (Acreage,
Pounds, Tons or Colonies) or Commodity Year.

19

Unable to perform the Yield Based Dollar Amount
of Insurance Indemnity because one or more of
the following fields has failed validation:
Determined Acreage, Liability Adjustment Factor,
Production to Count Quantity, Insured Share
Percent, Commodity Year, Contract Value,
Minimum Payment Quantity, or Price Election
Amount.

"*" = Output Only
6/26/2018

Page 53 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Unable to perform the APH Indemnity Corporate
Calculation, because one or more of the following
fields has failed validation: Approved Yield,
Commodity Year, Insured Share Percent,
Coverage Level Percent, Liability Adjustment
Factor, Production To Count Quantity, Acre Stage
Guarantee Amount, Applicable Determined Value
(Acreage, Pounds, Tons or Colonies), Stage
Percent Factor or Yield Conversion Factor.

20

If the Insured Loss Signature Date on the
Production Loss Detail, “P21” record is less than
the Inactive Date on the Adjuster, “P56” record
for the Adjuster provided on the Production Loss
Detail, “P21” record, the Adjuster will be
accepted.
In order to perform an Indemnity Calculation
when the Insurance Plan Code equals Revenue
Protection with Harvest Price Exclusion, "03", the
Stage Code is not equal to "R" or "RN" and the
Production to Count Quantity is greater than "0",
the Harvest Price from the Price ADM, "A00810"
must be available.

21

22

"*" = Output Only
6/26/2018

File Type:
Reinsurance Year:
Version:
Release Date:

Page 54 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
When Claim Process Code equals "S" and Price
Indicator Code is not equal to "H" and the Unit
Structure Code equals "BU", "EU" or "WU" then
((Total Indemnity Amount - Total Prevented
Planting Indemnity Amount) - Total Replanted
Indemnity Amount) must not exceed $40,000 or if
the Unit Structure Code equals "OU" then ((Total
Indemnity Amount - Total Prevented Planting
Indemnity Amount) - Total Replanted Indemnity
Amount) must not exceed $20,000.
Total Determined Acreage for Replant must be
greater than or equal to the Lesser of 20 Acres or
20% of the Planted Acres for the Unit from the
Acreage, "P11" record.
A P20 record with the same Claim Number must
exist in this batch when Stage Code is not "DC".
No corresponding P20 records may be submitted
when Stage Code is "DC".
Unit Total Indemnity Amount must be less than or
equal to the calculated Indemnity Amount when
Insurance Plan Code is "40" and Insurance Option
Code List contains "CV" or "OX".

23

24

25
26
27

"*" = Output Only
6/26/2018

File Type:
Reinsurance Year:
Version:
Release Date:

Page 55 of 56

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Unable to perform the Stacked Income Protection
Indemnity Corporate Calculation, because one or
more of the following fields has failed validation:
Determined Acreage.
Unable to perform the Supplemental Coverage
Option Indemnity Corporate Calculation, because
one or more of the following fields has failed
validation: Liability Adjustment Factor.
Production Loss Detail, "P21" records cannot be
accepted for Acreage, "P11" records that have the
Short Rate, "SR" option selected.
Unable to perform the Margin Protection
Indemnity Calculation Corporate Calculation,
because one or more of the following fields has
failed validation: Determined Acreage.

28

29

30

31

"*" = Output Only
6/26/2018

File Type:
Reinsurance Year:
Version:
Release Date:

Page 56 of 56