P21 Loss Line Record

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
2/22/2012

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

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 33

CCYY

Y

Y

Y

Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must be "2012".
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.
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"."

Record
Number

Output

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

Field
Number

P21

9

Field Name

Insured Loss Signature Date

Production Loss Detail
P21

Data Type

Date

Max
Length

8

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

CCYYMMDD

BUS
Key Req?

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

"*" = Output Only
2/22/2012

Page 2 of 33

Record
Number

P21

Output

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

Field
Number

10

Field Name

Adjuster Signature Date

Production Loss Detail
P21

Data Type

Date

Max
Length

8

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

11

Claim Number

Numeric

8

99999999

P21

12

AIP Indemnity Amount

Numeric

11

S9999999999

P21

13

Large Claim Code

Character

1

P21

14

Settlement Flag

Character

1

Page 3 of 33

Rules
Adjuster Signature Date must equal the date the
Adjuster settled the claim, except when Claim
Process Code equals Simplified Claim, "S" or SelfCertified Replant Claim, "R"; otherwise, empty.

CCYYMMDD

P21

"*" = Output Only
2/22/2012

BUS
Key Req?

Y

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.
Claim Number must equal the Claim Number from
the Loss Total, "P20" record.
AIP Indemnity Amount must equal RMA
calculated Indemnity Amount.
Large Claim Code must be valid; edit with Large
Claim ICE "D00102".
Settlement Flag equals Yes, "Y" if there is a
Settlement or Finding; otherwise, empty.

Record
Number
P21

Output

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

Field
Number
15

Field Name
Stage Code

Production Loss Detail
P21

Data Type

Max
Length

Character

2

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Stage Code must be valid; edit with the Stage
Commodity ICE, "D00124"; otherwise, empty.
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 be "00" when the Insurance
Option Code list on the Acreage, "P11" record
contains No Stage, "NS" and Commodity Code
equals Onions, "0013" or Sugar Beets, "0039".

"*" = Output Only
2/22/2012

Page 4 of 33

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
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"."
"Stage Code is Required when Insurance Plan
Code equals Revenue Protection with Harvest
Price Exclusion, "03"."

"*" = Output Only
2/22/2012

Page 5 of 33

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Stage Code must not equal one of the following
values: 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 Commodity Code equals Barley, "0091" and
Insurance Option Code List contains 'MA' or
'MB'."
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 one of the following
values: 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
2/22/2012

Page 6 of 33

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Stage Code must not equal one of the following
values: 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 one of the following
values: 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."

P21

16

"*" = Output Only
2/22/2012

Determined Tons

Numeric

11

Page 7 of 33

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

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

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

P21

17

Determined Acreage

Numeric

11

99999999.99

Determined Acreage must equal the total acreage
determined for this claim when Commodity Code
equals Mint, "0074".
Determined Acreage must equal the lesser of 20
acres or 20% of the insurable acres in the unit
when Commodity Code equal Mint, "0074" and
Stage Code equals Winter Coverage Option,
"W1".
Determined Acreage must be empty when
Insurance Plan Code equals Tree Based Dollar
Amount of Insurance, "40" or when the
Commodity Code equals: Raisins, "0037",
Oysters, "0115" or Apiculture, "1191".
Determined Acreage is required when Commodity
Code equals Peanuts, "0075", except when the
Commodity Price Processing Code equals "M" and
the Contract Liability Record Flag equals Yes, "Y"
or No, "N" on the corresponding Acreage, "P11",
record.

"*" = Output Only
2/22/2012

Page 8 of 33

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Determined Acreage can have no more than two
significant digits greater than zero to the right of
the decimal point when Commodity Code equals
Flue Cured Tobacco, "0229", Fire Cured Tobacco,
"0230", Burley Tobacco, "0231", Maryland
Tobacco, "0232", Dark Air Tobacco, "0233", Cigar
Filler Tobacco, "0234", Cigar Binder Tobacco,
"0235" or Cigar Wrapper Tobacco, "0236". For all
other Commodities Determined Acreage can have
no more than one significant digit greater than
zero to the right of the decimal point.

P21

18

Determined Colonies

Numeric

11

99999999.99

P21

19

Determined Tree Count

Numeric

10

9999999999

"*" = Output Only
2/22/2012

Page 9 of 33

Determined Colonies must equal the total
number of colonies attached to the claim when
Commodity Code equal Apiculture, "1191"
otherwise 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.

Record
Number

P21

Output

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

Field
Number

20

Field Name

Determined Pounds

Production Loss Detail
P21

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Data Type

Max
Length

Format

Numeric

10

9999999999

BUS
Key Req?

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 J57equal Peanuts,
"0075" or Oysters, "0115"."
Determined Pounds must be empty when
Commodity Code equals Peanuts, "0075" and
Commodity Price Processing Code is empty or
Contract Liability Record Flag is empty and
Commodity Price Processing Code equals "M'"
and Commodity Code does not equal Oysters,
"0115" or Mustard, "0069".

P21

21

First Damage Cause Code

P21

22

First Damage Date

"*" = Output Only
2/22/2012

Character

2

Date

8

Page 10 of 33

First Damage Cause Code must be valid edit with
the Damage Cause Commodity ICE, "D00077".
CCYYMMDD

Y

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
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 A+J70djuster Signature Date.

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", or Vegetation Index
"14".
First Damage Percent plus Second Damage
Percent plus Third Damage Percent cannot be
greater than "1.00".

"*" = Output Only
2/22/2012

Page 11 of 33

Record
Number

Output

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

Field
Number

Field Name

P21

24

Second Damage Cause Code

P21

25

Second Damage Date

Production Loss Detail
P21

Data Type

Max
Length

Character

2

Date

8

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

CCYYMMDD

BUS
Key Req?

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

"*" = Output Only
2/22/2012

Page 12 of 33

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

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

Second Damage Percent

Numeric

4

P21

27

Third Damage Cause Code

Character

2

"*" = Output Only
2/22/2012

Page 13 of 33

9.99

Second Damage Date must be less than or equal
to Batch Received Date.
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", or Vegetation Index "14"
.
Third Damage Cause Code must be valid; edit with
the Damage Cause Commodity ICE, "D00077".

Record
Number

Output

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

Field
Number

Field Name

P21

28

Third Damage Date

P21

29

Third Damage Percent

Production Loss Detail
P21

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

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

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

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
2/22/2012

Page 14 of 33

Record
Number

P21

Output

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

Field
Number

30

Field Name

WA Number

Production Loss Detail
P21

Data Type

Max
Length

Character

9

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

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".
WA Number must be valid; edit with the ICE
Written Agreement table.
WA Number can not be changed after the Fund
Designation Cutoff Date.
WA Number must contain only numeric
characters.
WA Number must not equal "000000000".

P21

31

Replant Payment Flag

Character

1

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.

P21

32

Gleaned Acreage Code

Character

2

Gleaned Acreage Code must be valid; edit with
the Gleaned Acreage Commodity ICE , "D00126".

11

Harvested Production Quantity must be less than
or equal to the Production to Count Quantity,
otherwise empty.

P21

33

"*" = Output Only
2/22/2012

Harvested Production Quantity

Numeric

Page 15 of 33

99999999.99

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

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Data Type

Max
Length

Format

Numeric

11

99999999.99

BUS
Key Req?

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

P21

35

"*" = Output Only
2/22/2012

Sugar Factor

Numeric

5

Page 16 of 33

9.999

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 two
decimals, when the Commodity Code equals
Forage Seeding, "0032" and the Stage Code
equals Spring-seeded acreage with 56-74% stand,
"S".
Sugar Factor must be greater than zero when
Commodity Code equals Sugar Beets, "0039" and
Harvested Production Quantity is greater than
zero; otherwise, empty.

Record
Number

P21

Output

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

Field
Number

36

Field Name

Acre Stage Guarantee Amount

Production Loss Detail
P21

Data Type

Numeric

Max
Length

11

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

99999999.99

BUS
Key Req?

Rules
Acre Stage Guarantee Amount must equal zero
except for replants, Commodity Code equal
Tangerine Trees, "0193"; Orange Trees, "0207" or
Grapefruit Trees, "0208" when Insurance Plan
Code equal Income Protection, "40".
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".
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".

"*" = Output Only
2/22/2012

Page 17 of 33

Record
Number

P21

Output

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

Field
Number

37

"*" = Output Only
2/22/2012

Field Name

Multiple Cropping Exception Flag

Production Loss Detail
P21

Data Type

Max
Length

Character

1

Page 18 of 33

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Y

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 crcop 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

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

Max
Length

Character

2

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Loss Multiple Cropping Code must be valid; edit
with the Multiple Cropping ICE, "D00063".
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

P21

40

Claim Process Code

Character

1

P21

41

Price Indicator Code

Character

2

"*" = Output Only
2/22/2012

Page 19 of 33

9.999999

Liability Adjustment Factor must be the same
value for all records in a Unit Structure by
Payment Type Code.
Claim Process Code must be valid; edit with the
Claim Process ICE, "D00071".
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".

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
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

First Notice of Loss Date

Date

8

CCYYMMDD

P21

43

Last Notice of Loss Date

Date

8

CCYYMMDD

"*" = Output Only
2/22/2012

Page 20 of 33

Y

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

P21

44

P21

45

P21

P21

Field
Number

*

Field Name

Audit Correction Flag

Revenue Conversion Production To Count
Quantity

Production Loss Detail
P21

Data Type

Character

Numeric

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

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

1

Audit Correction Flag must equal Yes, "Y"
indicating that the Audit is Corrected or No, "N"
indicating the Audit Correction is not applicable.

11

99999999.99

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.
MisReported Information Factor must be the
same value for all records in a Unit Structure by
Payment Type Code.
Unit Deficiency Quantity less than or equal to zero
indicates that the Indemnity is less than or equal
to zero.

46

MisReported Information Factor

Numeric

8

9.999999

47

Unit Deficiency Quantity

Numeric

12

S99999999.99

"*" = Output Only
2/22/2012

BUS
Key Req?

Page 21 of 33

Record
Number

P21

Production Loss Detail
P21

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Output

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

Field
Number

*

48

Loss Guarantee Amount

Numeric

11

S9999999999

Numeric

11

S9999999999

Field Name

P21

*

49

Second Commodity Waived Indemnity
Amount

P21

*

50

Preliminary Indemnity Amount

Data Type

Max
Length

Format

Numeric

11

99999999.99

BUS
Key Req?

Rules
Unit Deficiency Quantity must equal zero for
Raisin Reconditioning Payments and IP.
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
2/22/2012

Page 22 of 33

Record
Number

P21

Output

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

*

Field
Number

51

Field Name

Indemnity Amount

Production Loss Detail
P21

Data Type

Numeric

Max
Length

11

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

S9999999999

BUS
Key Req?

Y

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

*

52

Valid Escrow Flag

Character

1

P21

*

53

Initial Accepted Batch Number

Numeric

4

9999

P21

*

54

Initial Accepted Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

"*" = Output Only
2/22/2012

Page 23 of 33

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

*

55

Batch Received Date

P21

*

56

P21

*

P21

*

Production Loss Detail
P21

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Data Type

Max
Length

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

Batch Number

Numeric

4

9999

57

Batch Record ID

Numeric

15

58

Process Result Code

Character

1

"*" = Output Only
2/22/2012

Field Name

Page 24 of 33

Format

BUS
Key Req?

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules

Record Level Rules

"*" = Output Only
2/22/2012

1

When the COI Questionnaire Completion Date on
the Adjuster, "P56" 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 25 of 33

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?

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 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 "X" 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
2/22/2012

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Page 26 of 33

Record
Number

Output

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

Field
Number

"*" = Output Only
2/22/2012

Field Name

Production Loss Detail
P21

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

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 Contrcted 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

Record must be submitted between 7/1/2011 and
2/12/2015.

Page 27 of 33

Record
Number

Output

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

Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

7

8

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
The Production Loss Detail, "P21" record will not
be accepted when processing has been
suspended on this record type.
Related P20 record must be free of errors for the
Production Loss Detail, "P21" record to be
accepted.

9

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

10

All P21 records for the corresponding P20 record
must be accepted.

11

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
2/22/2012

Page 28 of 33

Record
Number

Output

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

Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

12

Format

BUS
Key Req?

Rules
Unable to perform the Combo Indemnity
Corporate Calculation, because one or more of
the following fields has failed validation:
Approved Yield, Commodity Year, Coverage Level
Percent, Determined Acreage, Insured Share
Percent, Liability Adjustment Factor, Price
Election Amount, Production To Count Quantity
or Contract Price.
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.

13

"*" = Output Only
2/22/2012

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Page 29 of 33

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules

14

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.

15

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
2/22/2012

Page 30 of 33

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules

16

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.

17

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
2/22/2012

Page 31 of 33

Record
Number

Output

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

Field
Number

Field Name

Production Loss Detail
P21

Data Type

Max
Length

18

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

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.

19

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

"*" = Output Only
2/22/2012

Page 32 of 33

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?

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

21

"*" = Output Only
2/22/2012

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Page 33 of 33