Production Loss Line Record Type 21

Production Loss Detail Record Type 21.pdf

Multiple Peril Crop Insurance

Production Loss Line Record Type 21

OMB: 0563-0053

Document [pdf]
Download: pdf | pdf
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

P21

6

P21

P21

"*" = Output Only
6/25/2015

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?
Y

Y

Y
Y

Y
Y

15

Y

Y

Character

15

Y

Y

AIP Acreage Key

Character

15

7

AIP Production Loss Detail Key

Character

15

8

AIP Adjuster Key

Character

15

Page 1 of 49

CCYY

Y

Y

Y

Delimited
2016
Approved
7/1/2015

Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must be "2016".
Record Type Code must be "P21".
AIP Policy Producer Key must match the parent
primary Policy Producer, "P10" record.
AIP Insurance In Force Key must be unique within
the AIP Policy Producer Key.
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.
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

P21

"*" = Output Only
6/25/2015

9

Field Name

AIP Employee Key

Production Loss Detail
P21

Data Type

Max
Length

Character

15

Page 2 of 49

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
AIP Adjuster Key is required except when the
Insurance Plan Code equals Group Risk Plan, "04",
Group Risk Income Protection with Harvest
Revenue Option, "05", Group Risk Income
Protection, "06", Rainfall Index "13", or
Vegetation Index "14", and AIP Employee Key is
empty.
AIP Adjuster Key must be empty when the
Insurance Plan Code equals Group Risk Plan, "04",
Group Risk Income Protection with Harvest
Revenue Option, "05", Group Risk Income
Protection, "06", Rainfall Index "13", or
Vegetation Index "14"."
AIP Adjuster Key must be empty when AIP
Employee Key exists.
AIP Employee Key is required when Insurance
Plan Code is not one of the following values: "04",
"05", "06", "13", "14", 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", "14.
AIP Employee Key must be valid; edit with ODS,
Employee ODS "ODS54" record.

Record
Number

P21

Output

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

10

Field Name

Insured Loss 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
2016
Approved
7/1/2015

Rules
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.
Insured Loss Signature Date is Required when
Insurance Plan Code is not one of the following
values: Group Risk Plan, 04", Group Risk Income
Protection with Harvest Revenue Option, "05",
Group Risk Income Protection, "06", Rainfall Index
"13"or Vegetation Index, "14" and Stage Code is
not "DC".
Insured Loss Signature Date must be empty when
Insurance Plan Code equals one of the following
values: Group Risk Plan, 04", Group Risk Income
Protection with Harvest Revenue Option, "05",
Group Risk Income Protection, "06", Rainfall Index
"13"or Vegetation Index, "14" and Stage Code is
not "DC".
Insured Loss Signature Date must be empty when
Stage Code is "DC".

"*" = Output Only
6/25/2015

Page 3 of 49

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
2016
Approved
7/1/2015

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",
Vegetation Index "14".
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", or Vegetation Index
"14".
Adjuster Signature Date must be less than or
equal to the Batch Received Date.
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.

"*" = Output Only
6/25/2015

Page 4 of 49

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

BUS
Key Req?

Y

Delimited
2016
Approved
7/1/2015

Rules
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.
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".
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.
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".

"*" = Output Only
6/25/2015

Page 5 of 49

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
2016
Approved
7/1/2015

P21

14

Large Claim Code

Character

1

P21

15

Settlement Flag

Character

1

Rules
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".

P21

16

Stage Code

Character

2

Stage Code must be valid; edit with the Stage
Commodity ICE, "D00124"; otherwise, empty.

"*" = Output Only
6/25/2015

Page 6 of 49

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
2016
Approved
7/1/2015

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.

"*" = Output Only
6/25/2015

Page 7 of 49

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
2016
Approved
7/1/2015

Rules
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".
Stage Code is Required when Insurance Plan Code
equals Revenue Protection with Harvest Price
Exclusion, "03".
Stage Code must not equal Final Loss - GRP/GRIP
Crops Only, FL" when Insurance Plan Code is not
one of the following values: Group Risk Plan, "04",
Group Risk Income Protection with Harvest
Revenue Option, "05", Group Risk Income
Protection, "06", Rainfall Index "13"or Vegetation
Index, "14".
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/25/2015

Page 8 of 49

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
2016
Approved
7/1/2015

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".

"*" = Output Only
6/25/2015

Page 9 of 49

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
2016
Approved
7/1/2015

Rules
Stage Code must equal "PT" when the Insurance
Option Code List contains "PT" and the Guarantee
Adjustment Type Code equals "E" or "P".
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 Commodity Code is Peanuts,
"0075", and when Insurance Plan Cod is "50" and
Commodity Code is one of the following: "0201",
"0202", "0203", "0227", "0309", "1302", "9936".

"*" = Output Only
6/25/2015

Page 10 of 49

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
2016
Approved
7/1/2015

Rules
Stage Code must equal "FL" when Insurance Plan
Code is one of the following values: "04", "05",
"06", "13", "14".
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".

P21

17

"*" = Output Only
6/25/2015

Determined Tons

Numeric

11

Page 11 of 49

99999999.99

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".
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".

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
2016
Approved
7/1/2015

Rules
Determined Tons must be less than or equal to 24
when Stage Code equals Raisin Reconditioning
Payment (RAC standards not met), RF"."

P21

18

Determined Acreage

Numeric

11

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 Vegetation Index, "14" or when the
Commodity Code does not equal Raisins, "0037",
Oysters, "0115", or Apiculture, "1191" or PRF,
"0088".
Determined Acreage must be empty when the
Insurance Plan Code equals Tree Based Dollar
Amount of Insurance, "40", Rainfall Index, "13"or
Vegetation Index, "14" or when the Commodity
Code equals Raisins, "0037", Oysters, "0115",
Apiculture, "1191" or PRF, "0088".

"*" = Output Only
6/25/2015

Page 12 of 49

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
2016
Approved
7/1/2015

Rules
Determined Acreage must be greater than zero
except when Insurance Plan Code is "13", "14" 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"; or when Commodity Code is "0075" and
Stage Code is empty or not "R", "RS" or "RT".
Determined Acreage is required when Stage Code
is "DC" and Determined Pounds is empty and
Determined Tree Count is empty.

P21

19

Determined Tree Count

Numeric

10

9999999999

P21

20

Determined Pounds

Numeric

10

9999999999

"*" = Output Only
6/25/2015

Page 13 of 49

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.
Determined Pounds is Required when Commodity
Code equals Oysters, "0115" and the Stage Code
equals "R", "RS" or "RT".

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
2016
Approved
7/1/2015

Rules
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".
First Damage Cause Code is optional.

"*" = Output Only
6/25/2015

Page 14 of 49

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
2016
Approved
7/1/2015

Rules
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

First Damage Date

Date

8

CCYYMMDD

Y

First or Second Damage Date must be less than
the First Notice of Loss Date.
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",
or Vegetation Index "14".
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".
First Damage Date is optional.

"*" = Output Only
6/25/2015

Page 15 of 49

Record
Number
P21

Output

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

Field Name
First Damage Percent

Production Loss Detail
P21

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Format

BUS
Key Req?

Numeric

4

9.99

Y

Delimited
2016
Approved
7/1/2015

Rules
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", or Vegetation Index "14"
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", "14" and Stage Code is not "DC".

P21

24

Second Damage Cause Code

Character

2

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".

"*" = Output Only
6/25/2015

Page 16 of 49

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
2016
Approved
7/1/2015

Rules
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", or Vegetation Index
"14".
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", "14" or Stage Code equals "DC".
Second Damage Cause Code is required when
Second Damage Percent exists and Stage Code is
not "DC".
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

"*" = Output Only
6/25/2015

Second Damage Date

Date

8

Page 17 of 49

CCYYMMDD

First or Second Damage Date must be 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
2016
Approved
7/1/2015

Rules
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",
or Vegetation Index "14".
Second Damage Date must be less than First
Notice Of Loss Date when (Second Damage Date
is greater than or equal to First Damage Date) or
(First Notice Of Loss Date is greater than or equal
to First Damage Date).

P21

26

"*" = Output Only
6/25/2015

Second Damage Percent

Numeric

4

Page 18 of 49

9.99

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".
Second Damage Percent must equal ".01" to
"0.99" when the Second 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
2016
Approved
7/1/2015

Rules
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", or Vegetation Index "14"
or Stage Code equals "DC".

P21

27

Third Damage Cause Code

Character

2

Second Damage Percent is required when
Insurance Plan Code is not one of the following
values: "04", "05", "06", "13", "14" 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.
Third Damage Cause Code must be valid; edit with
the Damage Cause Commodity ICE, "D00077".

"*" = Output Only
6/25/2015

Page 19 of 49

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
2016
Approved
7/1/2015

Rules
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", or Vegetation Index
"14".
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", "14" or Stage Code equals "DC".
Third Damage Cause Code is required when Third
Damage Percent exists and Stage Code is not
"DC".
Third Damage Cause Code must not equal "86"
when Insurance Option Code List does not contain
"QE" and Third Damage Cause Code exists.

"*" = Output Only
6/25/2015

Page 20 of 49

Record
Number

P21

Output

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

28

Field Name

Third Damage Date

Production Loss Detail
P21

Data Type

Date

Max
Length

8

File Type:
Reinsurance Year:
Version:
Release Date:

Format

CCYYMMDD

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
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",
or Vegetation Index "14".
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

Third Damage Percent

Numeric

4

9.99

Third Damage Percent must equal ".01" to "0.98"
when the Third Damage Cause Code is not empty.
Third Damage Percent plus First Damage Percent
plus Second Damage Percent must not be greater
than "1.00".

"*" = Output Only
6/25/2015

Page 21 of 49

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
2016
Approved
7/1/2015

Rules
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", or Vegetation Index "14"
or Stage Code equals "DC".
Third Damage Percent is required when Insurance
Plan Code is not one of the following values: "04",
"05", "06", "13", "14" and Third Damage Cause
Code exists and Stage Code is not "DC".

P21

P21

30

31

"*" = Output Only
6/25/2015

WA Number

Replant Payment Flag

Character

Character

9

1

Page 22 of 49

999999999

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".
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.

Record
Number

P21

P21

Output

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

32

33

Field Name

Gleaned Acreage Code

Harvested Production Quantity

Production Loss Detail
P21

Data Type

Max
Length

Character

2

Numeric

11

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
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".

99999999.99

Gleaned Acreage Code must be empty when
Stage Code is "DC".
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".
Harvest Production Quantity is required when
Sugar Factor exists and Stage Code is not "DC".

P21

34

Production To Count Quantity

Numeric

11

99999999.99

Harvest Production Quantity must be empty
when Stage Code is "DC".
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.

"*" = Output Only
6/25/2015

Page 23 of 49

Record
Number

P21

Output

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

35

Field Name

Sugar Factor

Production Loss Detail
P21

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Format

Numeric

5

9.999

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Production to Count Quantity must be reported in
whole dollars for Insurance Plan Code Actual
Revenue History, "47".
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".
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".

"*" = Output Only
6/25/2015

Page 24 of 49

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
2016
Approved
7/1/2015

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").

"*" = Output Only
6/25/2015

Page 25 of 49

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
2016
Approved
7/1/2015

Rules
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".
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".

"*" = Output Only
6/25/2015

Page 26 of 49

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
2016
Approved
7/1/2015

Rules
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/25/2015

Page 27 of 49

Record
Number

P21

Output

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

37

"*" = Output Only
6/25/2015

Field Name

Multiple Cropping Exception Flag

Production Loss Detail
P21

Data Type

Character

Max
Length

1

Page 28 of 49

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Y

Delimited
2016
Approved
7/1/2015

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

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
2016
Approved
7/1/2015

Rules
Multiple Cropping Exception Flag must be empty when
Stage Code is "DC".

P21

38

Loss Multiple Cropping Code

Character

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.
Loss Multiple Cropping Code must be empty when
Stage Code is one of the following values: "R",
"RF", "RR", "RS", "RT", "DC".
P21

39

Liability Adjustment Factor

Numeric

8

P21

40

Claim Process Code

Character

1

P21

41

Price Indicator Code

Character

2

"*" = Output Only
6/25/2015

Page 29 of 49

9.999999

Liability Adjustment Factor must be the same
value for all records in a Unit Structure by
Payment Type Code.
Liability Adjustment Factor must be empty when
Stage Code is "DC".
Claim Process Code must be valid; edit with the
Claim Process ICE, "D00071".
Claim Process Code must be empty when Stage
Code is "DC".
Price Indicator Code must be valid; edit with the
Price Indicator ICE, "D00034".

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
2016
Approved
7/1/2015

Rules
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.

P21

42

"*" = Output Only
6/25/2015

First Notice of Loss Date

Date

8

Page 30 of 49

CCYYMMDD

Y

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.
First Notice of Loss Date 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", or Vegetation
Index "14".

Record
Number

P21

Output

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

43

Field Name

Last Notice of Loss Date

Production Loss Detail
P21

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Format

Date

8

CCYYMMDD

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
First Notice of Loss Date is required when
Insurance Plan Code is not one the following
values: "04", "05", "06", "13", "14" 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.
Last Notice of Loss Date 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", or Vegetation
Index "14".
Last Notice of Loss Date must be empty when
Insurance Plan Code equals "04", "05", "06", "13",
"14" and Stage Code does not equal "R", "RS",
"RT" or Stage Code equals "DC".

P21

44

Audit Correction Flag

Character

1

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".

"*" = Output Only
6/25/2015

Page 31 of 49

Record
Number

P21

Output

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

45

Field Name

Revenue Conversion 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
2016
Approved
7/1/2015

Rules
Revenue Conversion Production To Count
Quantity must be greater than zero when
Production to Count Quantity is greater than zero
and Insurance Plan Code equal Actual Revenue
History, "47", otherwise, empty.
Revenue Conversion Production To Count is not
applicable when Stage Code equals R, RF, RR, RS,
RT, P2, PF or PT.
Revenue Conversion Production To Count
Quantity is required when Production To Count
Quantity exists and Production To Count Quantity
is greater than zero and Insurance Plan Code is
"47" and Stage Code is not "DC".

P21

46

"*" = Output Only
6/25/2015

MisReported Information Factor

Numeric

8

Page 32 of 49

9.999999

Revenue Conversion Production To Count
Quantity must be empty when Insurance Plan
Code is not equal to "47" or Stage Code equals
"DC".
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".

Record
Number
P21

Output

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

Field Name
Stage Percent Factor

Production Loss Detail
P21

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Format

Numeric

4

9.99

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
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/25/2015

Page 33 of 49

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
2016
Approved
7/1/2015

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

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

P21

53

QA Type Code List

Character

8

P21

54

Mycotoxin Level Flag

Character

1

"*" = Output Only
6/25/2015

Page 34 of 49

Pre QA Appraised Production Amount must be
empty when Stage Code is "DC".
Post QA Appraised Production Amount must be
empty when Stage Code is "DC".
Uninsured Cause Production Amount must be
empty when Stage Code is "DC".
Pre QA Harvested Production Amount must be
empty when Stage Code is "DC".
Total Production Amount must be empty when
Stage Code is "DC".
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".
Mycotoxin Level Flag must equal Yes, "Y" when
entered otherwise empty.

Record
Number

P21

Output

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

*

Field
Number

55

Field Name

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
2016
Approved
7/1/2015

Rules
Mycotoxin Level Flag must be empty when Stage
Code is "DC".
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".

P21

*

56

"*" = Output Only
6/25/2015

Unit Deficiency Quantity

Numeric

12

Page 35 of 49

S99999999.99

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

P21

Production Loss Detail
P21

File Type:
Reinsurance Year:
Version:
Release Date:

Output

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

*

57

Loss Guarantee Amount

Numeric

11

S9999999999

Numeric

11

S9999999999

Field Name

P21

*

58

Second Commodity Waived Indemnity
Amount

P21

*

59

Preliminary Indemnity Amount

Data Type

Max
Length

Format

Numeric

11

99999999.99

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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", or Vegetation
Index "14".
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".

"*" = Output Only
6/25/2015

Page 36 of 49

Record
Number

Output

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

P21

*

60

Field Name

Indemnity Amount

Production Loss Detail
P21

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Format

Numeric

11

S9999999999

BUS
Key Req?

Y

Delimited
2016
Approved
7/1/2015

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".
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".

P21

*

61

Valid Escrow Flag

Character

1

P21

*

62

Initial Accepted Batch Number

Numeric

4

"*" = Output Only
6/25/2015

Page 37 of 49

9999

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.

Record
Number

Output

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

P21

*

63

P21

*

P21

Production Loss Detail
P21

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Initial Accepted Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

Initial Accepted Date is the original date assigned
when this record was first received at RMA.

64

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

*

65

Batch Number

Numeric

4

9999

P21

*

66

Batch Record ID

Numeric

15

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.

P21

*

67

Process Result Code

Character

1

"*" = Output Only
6/25/2015

Field Name

Page 38 of 49

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

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
2016
Approved
7/1/2015

Rules

Record Level Rules

"*" = Output Only
6/25/2015

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 39 of 49

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
2016
Approved
7/1/2015

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/25/2015

File Type:
Reinsurance Year:
Version:
Release Date:

Page 40 of 49

Record
Number

Output

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

"*" = Output Only
6/25/2015

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

4

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.

5

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.

6

The Production Loss Detail, "P21" record will not
be accepted when processing has been
suspended on this record type.
Page 41 of 49

Record
Number

Output

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

Field Name

Production Loss Detail
P21

Data Type

Max
Length

7

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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".

8

All Production Loss Detail, "P21" records for the
corresponding Loss Total, "P20" record must be
accepted when Stage Code is not "DC".

9

For the P21 record to be accepted there must be
a corresponding P14 record accepted in this
batch.

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.

"*" = Output Only
6/25/2015

Page 42 of 49

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
2016
Approved
7/1/2015

Rules

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.

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.

"*" = Output Only
6/25/2015

Page 43 of 49

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
2016
Approved
7/1/2015

Rules

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.

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.

"*" = Output Only
6/25/2015

Page 44 of 49

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
2016
Approved
7/1/2015

Rules

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.

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.

"*" = Output Only
6/25/2015

Page 45 of 49

Record
Number

Output

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

Field Name

Production Loss Detail
P21

Data Type

Max
Length

19

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
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 or Price Election
Amount.

20

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.

21

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.

"*" = Output Only
6/25/2015

Page 46 of 49

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
2016
Approved
7/1/2015

Rules

22

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" and the Production
to Count Quantity is greater than "0", the Harvest
Price from the Price ADM, "A00810" must be
available.

23

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.

24

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.

"*" = Output Only
6/25/2015

Page 47 of 49

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
2016
Approved
7/1/2015

Rules

25

When Commodity Code equals Peanuts, "0075"
and Stage Code not equal to "R", "RS" or "RT", If a
WA Number is applicable, it must be submitted
on all related Production Loss detail, "P21",
Records for the unit.

26

A P20 record with the same Claim Number must
exist in this batch when Stage Code is not "DC".

27

No corresponding P20 records may be submitted
when Stage Code is "DC".

28

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".

29

Unable to perform the Stacked Income Protection
Indemnity Corporate Calculation, because one or
more of the following fields has failed validation:
Determined Acreage.

"*" = Output Only
6/25/2015

Page 48 of 49

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
2016
Approved
7/1/2015

Rules

30

Unable to perform the Supplemental Coverage
Option Indemnity Corporate Calculation, because
one or more of the following fields has failed
validation: Liability Adjustment Factor.

31

Production Loss Detail, "P21" records cannot be
accepted for Acreage, "P11" records that have the
Short Rate, "SR" option selected.

"*" = Output Only
6/25/2015

Page 49 of 49


File Typeapplication/pdf
File TitleP21 Production Loss Detail
AuthorTodd Stinson
File Modified2015-06-25
File Created2015-06-25

© 2024 OMB.report | Privacy Policy