Download:
pdf |
pdfRecord
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 Type | application/pdf |
File Title | P21 Production Loss Detail |
Author | Todd Stinson |
File Modified | 2015-06-25 |
File Created | 2015-06-25 |