Download:
pdf |
pdfRecord
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
P14
1
AIP Code
Character
2
P14
P14
2
3
Reinsurance Year
Record Type Code
Numeric
Character
4
6
P14
4
AIP Policy Producer Key
Character
15
P14
5
AIP Insurance In Force Key
Character
15
File Type:
Reinsurance Year:
Version:
Release Date:
Format
CCYY
BUS
Key Req?
Y
Y
Y
Y
Y
Y
Y
Y
Delimited
2019
Approved
4/4/2019
Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must equal "2019".
Record Type Code must equal "P14".
AIP Policy Producer Key must match the
corresponding primary Policy Producer, "P10"
record.
AIP Insurance In Force Key must be unique within
the AIP Policy Producer Key.
AIP Insurance In Force Key must not be reassigned
once used within the AIP Policy Producer Key.
P14
6
AIP Insurance Agent Key
Character
15
Y
P14
7
Location County Code
Character
3
Y
Y
P14
8
Insurance Plan Code
Character
2
Y
Y
"*" = Output Only
3/20/2019
Page 1 of 75
For WFRP (Commodity Code, "0076") only one
Insurance In Force Key per tax id (entity)
nationwide.
AIP Insurance Agent Key must match the
corresponding Insurance Agent, "P55" record.
AIP Insurance Agent Key must refer to an active
Agent “P55” record.
Location County Code must be valid: edit with the
County ADM, "A00440".
Insurance Plan Code must be valid; edit with the
Insurance Plan ADM, "A00460".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Insurance Plan Code must not equal "81" or "82".
Insurance Plan Codes between the High-Risk
Alternate Coverage Endorsement (HR-ACE) record
and non-HR-ACE record (base policy) are an
invalid combination. When HR-ACE equals
Insurance Plan Code, "01", then non-HR-ACE
Insurance Plan Code must equal "01", "02" or
"03". When HR-ACE Insurance Plan Code equals
"02" or "03" then the non-HR-ACE must be the
same Insurance Plan Code "02" or "03"
respectively. When HR-ACE equals Insurance Plan
Code, "31", then non-HR-ACE Insurance Plan Code
must equal "31", "32" or "33". When HR-ACE
Insurance Plan Code equals "32" or "33" then the
non- HR-ACE must be the same Insurance Plan
Code "32" or "33" respectively.
Insurance Plan Code cannot change between
submissions if the Acreage, "P11" record exists or
has previously been accepted.
"*" = Output Only
3/20/2019
Page 2 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
P14
9
Commodity Code
Character
4
P14
10
Commodity Year
Numeric
4
P14
11
Type Code
Character
3
"*" = Output Only
3/20/2019
Page 3 of 75
File Type:
Reinsurance Year:
Version:
Release Date:
Format
CCYY
BUS
Key Req?
Y
Y
Y
Y
Y
Delimited
2019
Approved
4/4/2019
Rules
Insurance Plan Code must be the same for all
Insurance In Force, "P14" records within the same
Policy Number and AIP Policy Producer Key for
STAX under Insurance Plan Code "35" or "36". For
the same policy producer, all STAX Insurance In
Force, "P14" records must have either Insurance
Plan Code "35" or "36".
Commodity Code must be valid; edit with the
Commodity ADM, "A00420".
Commodity Year must be between the
Reinsurance Year plus one and the Reinsurance
Year minus one.
Type Code must be valid; edit with Type ADM
"A00540".
Type Code is required when Commodity Code
equals Table Grapes,"0052", Grapes, "0053" or
Whole Farm Revenue Protection, "0076".
Type Code is required if necessary to allow
multiple Coverage Level Percent's or Price
Election Percent's for the Location State
Code/Location County Code/Commodity Code.
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Type Code is required when Commodity Code
equals Nursery, "0073", Grapes, "0053" or PRF,
"0088" or when the Location State Code equals
Arizona, "04" or California, "06" and the
Commodity Code equals "0052" or the Location
State Code equals Texas, "48" and the Commodity
Code equals Tangerine Trees, "0193", Orange
Trees, "207" or Grapefruit Trees, "208" and Type
Practice Use Code equals "N".
Type Code for commodities with more than one
sales closing date may be used to determine
eligibility and LRR transaction cutoff date based
on sales closing date where multiple dates exist.
Type Code is Required when Commodity Code
equals Nursery, "0073", Grapes, "0053" or PRF,
"0088" or when the Location State Code equals
Arizona, "04" or California, "06" and the
Commodity Code equals "0052" or the Location
State Code equals Texas, "48" and the Commodity
Code equals Tangerine Trees, "0193", Orange
Trees, "207" or Grapefruit Trees, "208" and the
Extended Type Codes have not been
implemented, or are in transition and no
extended type codes have been submitted.
"*" = Output Only
3/20/2019
Page 4 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Type Code is required on all Insurance in Force,
"P14" records when multiple Type Code/Practice
Code values have been submitted, the Insurance
Plan Code equals Area Yield Protection "04", Area
Revenue Protection, "05" or Area Revenue
Protection with Harvest Price Exclusion, "06", the
Extended Type/Practice fields have not been
implemented or are in transition and no extended
Type fields have been submitted.
Type Code is Required when Late Reported
Reason Code equals "06" and the Extended
Type/Practice fields have not been implemented
or are in transition and no extended Type fields
have been submitted.
Type Code is Required when Commodity Code
equals Grapefruit, "0201"', Lemons, "0202",
Tangelos, "0203", Oranges, "0227", Tangerines,
"0309", Tangors, "1302" or Limes, "9936".
"*" = Output Only
3/20/2019
Page 5 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Type Code is required on all Insurance in Force,
"P14" records when Type Code is submitted and
Commodity Codes equals Peaches, "0034",
Apples, "0054", or Pears, "0089".
Type Code and/or Practice Code cannot change
between submissions if it changes the LRR
Transaction Cutoff Date and Premium Acreage
records have been submitted.
Type Code must be empty when Commodity Code
equals Milk, "0830".
P14
12
Practice Code
Character
3
Y
Practice Code is required when Commodity Code
equals Nursery, "0073" or Annual Forage, "0332".
Practice Code must be valid; edit with the Practice
ADM, "A00510".
Practice Code is required if necessary to
determine the Sales Closing Date; if not
submitted the earliest Sales Closing Date for the
Location State Code/Location County
Code/Commodity Code/Insurance Plan Code will
be used to establish the Fund Cut Off Date.
"*" = Output Only
3/20/2019
Page 6 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Practice Code is required on all Insurance in
Force, "P14" records when multiple Type
Code/Practice Code values have been submitted
for Insurance Plan Codes equal to Area Yield
Protection "04", Area Revenue Protection, "05" or
Area Revenue Protection with Harvest Price
Exclusion, "06" and Extended Type/Practice fields
have not been implemented or are in transition
and no extended Practice Codes have been
submitted.
Practice Code cannot change between
submissions if it changes the LRR Transaction
Cutoff Date, Premium Acreage records have been
submitted and Extended Type/Practice fields have
not been implemented or are in transition and no
extended Practice Codes have been submitted.
For Annual Forage, "0332", P14 records must be
submitted for every growing season.
"*" = Output Only
3/20/2019
Page 7 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
For Annual Forage, "0332", Practice Codes for CAT
and Buyup cannot be mixed under the same
policy. Practices selected must not have
overlapping months in each growing season.
Practice Code is required on the Insurance in
Force, "P14" record to elect separate coverage
levels by irrigation practice when the Insurance
Option Code List contains "LP" or when
Commodity Code equals PRF, "0088" and Type
Code equals Haying, "030".
P14
13
Commodity Type Code
Character
3
P14
14
Class Code
Character
3
P14
15
Sub Class Code
Character
3
P14
16
Intended Use Code
Character
3
P14
17
Irrigation Practice Code
Character
3
"*" = Output Only
3/20/2019
Page 8 of 75
Practice Code must be empty when Commodity
Code equals Milk, "0830".
Commodity Type Code must be valid; edit with
the Commodity Type ADM, "A00430".
Class Code must be valid; edit with the Class
ADM, "A00410".
Sub Class Code must be valid; edit with the Sub
Class ADM, "A00530".
Intended Use Code must be valid; edit with the
Intended Use ADM, "A00470".
Irrigation Practice Code must be valid; edit with
the Irrigation Practice ADM, "A00490".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
P14
18
Cropping Practice Code
Character
3
P14
19
Organic Practice Code
Character
3
P14
20
Interval Code
Character
3
P14
21
WA Number
Character
9
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Cropping Practice Code must be valid; edit with
the Cropping Practice ADM, "A00450".
Organic Practice Code must be valid; edit with the
Organic Practice ADM, "A00500".
Interval Code must be valid; edit with the Interval
ADM, "A00480".
WA Number must be valid.
WA Number must be empty when Commodity
Code equals Nursery "0073", Hybrid Seed Rice,
"0080", Clams, "0116", Avocados, "0119" or
Pecan Trees, "0284".
WA Number must be empty when Commodity
Code equals Milk, "0830".
WA Number must not equal "000000000".
999999999
WA Number must be empty when Coverage Type
Code equals Catastrophic, "C".
P14
"*" = Output Only
3/20/2019
22
Coverage Type Code
Character
1
Page 9 of 75
Y
Y
Coverage Type Code must be valid; edit with
Coverage ICE "D00016".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Coverage Type Codes for the entire County must
be designated as CAT when CAT is selected for
selected Commodity Code equal Grapes, "0053"
and Location State Code not equal to California,
"06".
Coverage Type Code must equal Additional, "A"
when the Commodity Code equals Cherries,
"0057" and the Type Code equals Tart Cherries,
"416".
Coverage Type Code must equal Additional, "A"
when the Commodity Code equals Milk, "0830".
Coverage Type Code must equal "A" for the SCO
Insurance In Force, "P14" records with Insurance
Plan Codes 01, 02, 03 and for the STAX Insurance
In Force, "P14" records with Insurance Plan Codes
35, 36. Base policy can be an "A" or "C" if SCO.
Dual Coverage Flag must be "N".
P14
"*" = Output Only
3/20/2019
23
Late Reported Reason Code
Character
2
Page 10 of 75
Y
Late Reported Reason Code must be valid; edit
with Late Reported Reason ICE, "D00006".
Late Reported Reason Code must equal '00' when
Commodity Code equals Milk, "0830".
Late Reported Reason Code is required if
submitted after LRR Cutoff Date.
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Late Reported Reason Code must be valid; edit
with Late Reported Reason ICE "D00006" when
Timely Submission Flag equals No, "N" and the
LRR Code is not equal to "00".
Late Reported Reason Code equal Alternative
Commodity, "05" requires that the Alternative
Commodity, Coverage Code must equal
Catastrophic, "C".
Late Reported Reason Code equal Changes to
Price or Coverage Level when Insured did Not
Plant Fall Type, "06" requires that the Commodity
has Spring & Fall Sales Closing Dates; edit with the
ADM Date, "A00200". An Insurance In Force,
"P14" record with a Fall Sales Closing Date was
accepted but the fall commodity was not planted
and no Acreage, "P11" record was accepted for
the commodity. A new Insurance In Force, "P14"
record may be submitted for the spring
commodity with changes to the Price Indicator
Code or the Coverage Level Percent.
"*" = Output Only
3/20/2019
Page 11 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Late Reported Reason Code equal Subsequent
Application For Multiple County, "07" requires
that the Added County Indicator Code equal
Subsequent County, "S".
Late Reported Reason Code, equals multiple
Insurance In Force, "P14" records submitted, "08"
requires that multiple Insurance In Force, "P14"
records exist for the Policy Number/Location
County Code/Commodity Code.
"*" = Output Only
3/20/2019
Page 12 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Late Reported Reason Code, equals multiple
Insurance In Force, "P14" records submitted, "08"
is only valid for the following combinations: when
Insurance Plan Code equal to Group Risk Plan,
"04" and Commodity Code equal to Wheat,
"0011", Corn, "0041", Cotton, "0021" or
Soybeans, "0081" OR when Insurance Plan Code
equals Dollar Amount of Insurance, "50", Location
State Code equals Florida, "0012" and Commodity
Code equals Grapefruits, "0201", Lemons, "0202",
Tangelos, "0203", Oranges, "0227",
Mandarins/Tangerines, "0309", Tangors, "1302"
or Limes, "9936" OR when Insurance Plan Code
equals Actual Production History "90" and
Commodity Code equals Peaches, "0034", Apples,
"0054", or Pears, "0089" OR when Commodity
Code equals Table Grapes, "0052" and Location
State Code equals Arizona, "04" or California,
"06".
"*" = Output Only
3/20/2019
Page 13 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Late Reported Reason Code equal Revised
Coverage Level, Market Price Indicator Code or
Price Election Percent, "10", allows changes only
to Coverage Level Percent, Market Price Indicator
Code, or Price Election Percent after the LRR
Transaction Cutoff Date.
Late Reported Reason Code is Required when LRR
Transaction Code does not equal: Timely
Accepted, "01" or Modified after Lockdown to
Lockdown Price Election, Coverage Level and
Price Indicator, "07".
Late Reported Reason Code equal to Contract
Change, "11", Entity Certification, "12" and Late
Payment of Debt, "18" cannot be changed once
accepted.
Late Reported Reason Code must not equal "00"
when the Batch Received Date is greater than the
LRR Transaction Cutoff Date and the LRR Code is
not equal to Lockdown LRR Code or "00".
"*" = Output Only
3/20/2019
Page 14 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Late Reported Reason Code equal to Changes to
Price or Coverage Level when insured did not
plant Fall type, "06" indicates that there are
separate Insurance in Force, “P14” records found
for the Fall and Spring plantings and that the Fall
planting must have a previously accepted
Insurance in Force, “P14” record with a different
AIP Insurance in Force Key for the Spring record
to be accepted.
Late Reported Reason Code equal to Changes to
Price or Coverage Level when insured did not
plant Fall type, "06" on a Spring planting
Insurance in Force, “P14” record will only be
accepted when there is a Fall planting, previously
accepted, Insurance in Force, “P14” record in the
“accepted” status.
"*" = Output Only
3/20/2019
Page 15 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Late Reported Reason Code equal to Changes to
Price or Coverage Level when insured did not
plant Fall type, "06" for a Spring planting
Insurance in Force, “P14” record will only be
accepted when there is a Non-Premium Acreage,
“P11” record for the Fall planted, Insurance in
Force, “P14” record that has been previously
accepted and is in the “accepted” status.
Late Reported Reason Code equal to Changes to
Price or Coverage Level when insured did not
plant Fall type, "06" for changing from a Fall to a
Spring planting, cannot be changed once
accepted.
Late Reported Reason Code of "12" is only valid
when an Entity Certification Code has been
submitted.
Late Reported Reason Codes "05, 06, 07, 08, and
11" do not apply to the WFRP (Commodity Code,
"0076").
Late Reported Reason Code of "18" is not allowed
when an entity with the status code of "42" is not
found in the Ineligible Entity ICE, "D10020" for the
primary producer Tax ID, Tax ID Type, AIP Code,
and Reinsurance Year.
"*" = Output Only
3/20/2019
Page 16 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Late Reported Reason Code of "18", PASS does
not allow any change to LRR related fields such as
Price Election, Coverage Level, etc., after the
initial acceptance.
Late Reported Reason Code equal WFRP Revised
Coverage Level and/or Location County Code,
"19", allows a reduced Coverage Level Percent
and/or change to Location County Code after LRR
Transaction Cutoff Date without incurring
additional LRR. This code is only applicable for
WFRP, "0076".
Late Reported Reason Code equal to Changes to
Price or Coverage Level when insured did not
plant Fall type, "06" for changing from a Fall to a
Spring planting and the LP option code is elected,
then the Late Reported Reason Code "06" will be
required on both Spring Insurance In Force, "P14"
records.
P14
"*" = Output Only
3/20/2019
24
Dual Coverage Flag
Character
1
Page 17 of 75
Y
Dual Coverage Flag must be Yes, "Y" when the
Coverage Code equals Catastrophic, "C" and a nonhigh risk buy-up policy exists for the Primary
Producer, otherwise No, "N".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
P14
25
Field Name
Insured Commodity Signature Date
Insurance In Force
P14
Data Type
Date
Max
Length
8
File Type:
Reinsurance Year:
Version:
Release Date:
Format
CCYYMMDD
BUS
Key Req?
Y
Delimited
2019
Approved
4/4/2019
Rules
Dual Coverage Flag must equal No, "N" when the
Commodity Code equals Nursery, "0073".
Insured Commodity Signature Date must not be
less than 1991.
Insured Commodity Signature Date must not be
greater than the Batch Received Date.
Insured Commodity Signature Date must not be
greater than the Modified Sales Closing Date
unless the Late Reported Reason Code does not
equal Timely Processed, "00".
Insured Commodity Signature Date must be
between the Contract Change Date minus one
year and Batch Received Date when Contract
Carryover Flag equals No, "N" indicating a "New
Policy" and the Insurance Plan Code equals "40".
"*" = Output Only
3/20/2019
Page 18 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Insured Commodity Signature Date must not be
greater than the Modified Sales Closing Date
unless a Late Reported Reason equal to "01" is
submitted, or the Commodity Code equals
Orange Trees, "0207", Grapefruit Trees, "0208",
Lemon Trees, "0209", Lime Trees, "0210", Other
Citrus Trees, "0211", Avocado Trees, "0212",
Carambola Trees, "0213", Mango Trees, "0214",
Pecan Trees, "0284", or Nursery, "0073".
Insured Commodity Signature Date must be
between Contract Change Date minus one year
and Batch Received Date when Contract
Carryover Flag equals No, "N" indicating a "New
Policy", the Location State Code equals "12" and
the Commodity Code equals Orange Trees,
"0207", Grapefruit Trees, "0208", Lemon Trees,
"0209", Lime Trees, "0210"', Other Citrus Trees,
"0211", Avocado Trees, "0212", Carambola Trees,
"0213", Mango Trees, "0214", or Pecan Trees,
"0284".
"*" = Output Only
3/20/2019
Page 19 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
P14
"*" = Output Only
3/20/2019
26
Field Name
Agent Commodity Signature Date
Insurance In Force
P14
Data Type
Date
Max
Length
8
Page 20 of 75
File Type:
Reinsurance Year:
Version:
Release Date:
Format
CCYYMMDD
BUS
Key Req?
Y
Delimited
2019
Approved
4/4/2019
Rules
Insured Commodity Signature Date must NOT be
greater than the Modified Sales Closing Date
unless the Late Reported Reason is greater than
"00" or the Commodity Code equals Orange
Trees, "0207", Grapefruit Trees, "0208", Lemon
Trees, "0209", Lime Trees, "0210"', Other Citrus
Trees, "0211", Avocado Trees, "0212", Carambola
Trees, "0213", Mango Trees, "0214", Pecan Trees,
"0284", Nursery, "0073" and the Contract
Carryover Flag equals, No, "N" indicating a "New
Policy".
Insured Commodity Signature Date must be
between January 31st (Reinsurance Year) and
Sales Closing Date when Location State Code
equals "12" and Commodity Code equals
Grapefruit "0201", Lemons "0202", Tangelos
"0203", Oranges "0227", Mandarins/Tangerines
"0309", Tangors "1302", or Limes "9936" and the
Contract Carryover Flag equals No, "N" indicating
a "New Policy".
Agent Commodity Signature Date must not be
less than 1991.
Agent Commodity Signature Date must not be
greater than the Batch Received Date.
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Agent Commodity Signature Date must be less
than the Inactive Date from the Agent, "P55"
record when the Inactive Date exists.
Agent Commodity Signature Date must be less
than or equal to the Sales Closing Date when the
Commodity Code does not equal: Nursery,
"0073", Orange Trees, "0207", Grapefruit Trees,
"0208", Lemon Trees, "0209", Lime Trees,
"0210", Other Citrus Trees, "0211", Avocado
Trees, "0212", Carambola Trees,"0213" or Mango
Trees, "0214" or when the Contract Carryover
Flag equals Yes, "Y" and the Commodity Code
equals Nursery, "0073", Avocado Trees, "0212",
or Carambola Trees, "0213" or the Commodity
Code equals Orange Trees, "0207", Grapefruit
Trees, "0208", Lemon Trees, "0209", Lime Trees,
"0210", Other Citrus Trees, "0211" with a
Location State Code not equal to Texas, "48" and
the Late Reported Reason Code is empty.
"*" = Output Only
3/20/2019
Page 21 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
P14
27
Field Name
Fee Prepaid Flag
Insurance In Force
P14
Data Type
Max
Length
Character
1
File Type:
Reinsurance Year:
Version:
Release Date:
Format
Delimited
2019
Approved
4/4/2019
BUS
Key Req?
Y
Rules
Fee Prepaid Flag must be Yes, "Y" when fees were
prepaid before the due date, otherwise No, "N".
Fee Prepaid Flag must be No, "N" when Coverage
Code equals Catastrophic, "C".
P14
28
FSA Administrative State Code
Character
2
P14
29
FSA Administrative County Code
Character
3
P14
30
FSA RMA Entity Difference Code
Character
2
P14
31
CIMS Information Code
Character
1
P14
32
Administrative Fee Waiver Code
Character
1
FSA Administrative State Code must be valid; edit
with the State ADM, "A00520".
FSA Administrative County Code must be valid;
edit with the County ADM, "A00440".
FSA RMA Entity Difference Code must be valid;
edit with the FSA RMA Entity Difference ICE,
"D00112".
Reserved
Administrative Fee Waiver Code must be valid;
edit with the Administrative Fee Waiver ICE,
"D00030".
Administrative Fee Waiver Code must equal "B"
when the Policy Producer qualifies for Beginning
Farmer Rancher.
Administrative Fee Waiver Code must not equal
'B' when the Policy Producer does not qualify for
Beginning Farmer Rancher.
"*" = Output Only
3/20/2019
Page 22 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Administrative Fee Waiver Code must equal "G"
when the Policy Producer qualifies for both
Beginning Farmer Rancher and Limited Resource
Farmer.
Administrative Fee Waiver Code cannot be null
because another Insurance In Force, "P14" record
has been submitted for the same Commodity
Code, Location State Code, and Location County
Code with an Administrative Fee Waiver Code.
Not applicable to DRP Insurance Plan Code 83.
Administrative Fee Waiver Codes must match
between all Insurance In Force, "P14" records on
the policy for the same Commodity Code,
Location State Code, and Location County Code.
P14
33
Cancellation Transfer Signed Flag
Character
1
P14
34
Coverage Level Percent
Numeric
6
"*" = Output Only
3/20/2019
Page 23 of 75
9.9999
Y
Cancellation Transfer Signed Flag must be Yes, "Y"
if the Primary Producer signed a Cancellation and
Transfer Application, otherwise No, "N".
Y
Coverage Level Percent must be valid; edit with
the Coverage Level ICE, "D00024".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Coverage Level Percent for the High-Risk
Alternate Coverage Endorsement (HR-ACE) record
must be less than or equal to (<=) the Coverage
Level Percent of the previously submitted non-HRACE record when the Insurance Plan Code for
both policies are different.
Coverage Level Percent for the High-Risk
Alternate Coverage Endorsement (HR-ACE) record
must be less than (<) the Coverage Level Percent
of the previously submitted non-HR-ACE record
when the Insurance Plan Code for both policies is
the same.
Coverage Level Percent must be valid; edit with
Coverage Level ICE "D00024" record when
Practice Code and Type Code do not exist.
Coverage Level Percent must be empty with
Commodity Milk, "0830".
"*" = Output Only
3/20/2019
Page 24 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Coverage Level Percent must equal the associated
Coverage Level Percent when the associated AIP
Insurance In Force Key exists and the associated
AIP Policy Producer Key exists and the Insurance
Plan Code equals one of the following values:
"31", "32", "33".
For WFRP (Commodity Code, "0076") higher
Coverage Level Percent's available for insureds
who qualify. See Whole Farm Revenue Protection
Pilot Handbook and Exhibit P14-7 for additional
information.
The Coverage Level Percent(s) of the grouped P14
record(s) must be equal within the same AIP
Policy Producer Key and within the same
Insurance Offer Group when Florida Citrus for
Group Codes "A" and "I", and Arizona, California,
or Texas Citrus for all Group Codes.
P14
35
Price Election Percent
Numeric
6
9.9999
Y
Price Election Percent must be valid; edit with
Price Election Percent ICE, "D00007".
Price Election Percent must be empty when
Commodity is Milk, "0830".
"*" = Output Only
3/20/2019
Page 25 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
P14
36
Dispute Settlement Code
Character
1
P14
37
Dispute Notification Date
Date
8
P14
38
Insurance Option Code List
Character
29
"*" = Output Only
3/20/2019
Page 26 of 75
File Type:
Reinsurance Year:
Version:
Release Date:
Format
CCYYMMDD
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Price Election Percent must equal 1.00 when the
Insurance Option Code List contains "CE", "CL",
"CH", or "CV".
Dispute Settlement Code must be valid; edit with
the Dispute Settlement ICE, "D00013".
Dispute Settlement Code must equal 'C' when
record exists in Settlement table.
Dispute Settlement Code must be valid; edit with
the Settlement table when Dispute Settlement
Code is 'C'.
Dispute Notification Date is required when
Dispute Settlement Code is not empty.
Dispute Notification Date must be empty when
Dispute Settlement Code is empty.
Dispute Notification Date must equal a valid date
within the Reinsurance Year.
Insurance Option Code List must be valid for each
delimited value; edit with the Option Rate ADM,
“A01060” when the Insurance Option Code List
exists.
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Insurance Option Code List must be valid for each
delimited value; edit with the Insurance Option
Criteria ICE, "D00137" when the Insurance Option
Code List exists.
P14
"*" = Output Only
3/20/2019
39
Price Indicator Code
Character
1
Page 27 of 75
Y
Insurance Option Code List must be a
combination of "FR" and/or "YA" when Coverage
Type Code equals Catastrophic, "C" and
Commodity Code does not equal Silage Sorghum,
"0059"; otherwise empty.
Price Indicator Code must be valid; edit with the
Price Indicator ICE, "D00034".
Price Indicator Code must be empty with
Commodity Milk, "0830".
Price Indicator Code must equal Additional Price,
"A" or Established Price, "E" when the Insurance
Plan Code equals Yield Based Dollar Amount of
Insurance, "55".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Price Indicator Code must equal Additional Price,
"A" or Established Price, "E" when the Insurance
Plan Code equals APH for Non-Combo
Commodities, "90" except when Commodity Code
equals Peanuts, "0075" or Hawaii Tropical Fruit
Trees, (0255, 0256, and 0257) which require Price
Indicator Code equal to Established Price, "E".
Price Indicator Code must equal Additional Price,
"A" or Established Price, "E" when the Insurance
Plan Code equals Dollar Plan of Insurance, "50"
and Commodity Code is Raisins, "0037". Use "E"
for Reference Maximum Dollar Amount and use
"A" for Additional Price.
P14
"*" = Output Only
3/20/2019
40
Added County Indicator Code
Character
1
Page 28 of 75
Added County Indicator Code must be valid; edit
with the Added County Indicator ICE, "D00003".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Added County Indicator Code is only valid with
Category "B" Commodity Codes excluding Forage
Production, "0033"; edit with the Commodity
Category ICE, "D00047", otherwise empty.
Added County Indicator Code equal National "N"
is allowed for only one AIP Code/Commodity
Code/Insurance Plan Code.
Added County Indicator Code equal Primary, "P"
is allowed only once per Location State
Code/Commodity Code/Insurance Plan Code and
when no National "N" exists for the Commodity
Code/Insurance Plan Code.
Added County Indicator Code equal Subsequent,
"S" is allowed only with a corresponding Primary,
"P" record for the Location State
Code/Commodity Code/Insurance Plan Code or
National, "N" record for the AIP Code/Commodity
Code/Insurance Plan Code.
"*" = Output Only
3/20/2019
Page 29 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Added County Indicator Code equal Subsequent,
"S" is allowed only when there is no Insurance In
Force "P14" record for the Location State
Code/Location County Code for the current
Commodity Year.
Added County Indicator Code equal Subsequent,
"S" is allowed only when a Primary Fund Code
has been previously accepted, the Coverage Type
Code does not equal Catastrophic, "C" and the
WA Number is empty.
Added County Indicator Code equal to
Subsequent, "S" is not allowed for Carryover
Policies where a Location County Code has been
insured for another Commodity Code in the
Current Year or the same Commodity Code in the
previous year.
Added County Indicator Code is used to
determine LRR and can be added after Sales
Closing Date.
Added County Indicator Code cannot be changed
after the LRR Cutoff Date.
"*" = Output Only
3/20/2019
Page 30 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Added County Indicator Code must have a
previously accepted Primary Insurance In Force,
"P14" record.
Added County Indicator Code does not allow for
another Insurance In Force, "P14" record with a
different Commodity as a Carryover Policy for the
same Reinsurance Year, AIP Code, Policy Number,
Commodity Year, Location State Code and
Location County Code as this would not qualify
for Added County.
"*" = Output Only
3/20/2019
Page 31 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Added County Indicator Code allows only one
Insurance in Force, "P14" record when the Added
County Indicator Code equals Primary, "P" or
National, "N" or is empty when Commodity Code
does not equal Grapes, "0053", Dry Beans,
"0047", Dry Peas "0067", Nursery, "0073" or
Pasture, Rangeland and Forage (PRF), "0088" and
when the Location State Code does not equal
Arizona, "04" or California, "06" and the
Commodity Code equals Table Grapes, "0052" or
when Commodity Code does not equal Texas or
Florida Citrus Trees or a Specialty Type and when
one Type Code/Practice Code is submitted.
"*" = Output Only
3/20/2019
Page 32 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Added County Indicator Code allows only one
Insurance in Force, "P14" record when the Added
County Indicator Code equals Primary, "P" or
National, "N" or is empty when Commodity Code
equals Table Grapes, "0052" or Grapes, "0053"
and the Location State Code equals Arizona, "04"
or California, "06" or when Commodity Code
equals Dry Beans, "0047", Dry Peas "0067" Florida
or Texas Citrus or Pasture, Rangeland and Forage
(PRF), "0088". Values checked are AIP Code,
Reinsurance Year, Commodity Year, Commodity
Code, Policy Number, Location County Code,
Coverage Type Code, and Type Code.
"*" = Output Only
3/20/2019
Page 33 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Added County Indicator Code allows only one
Insurance in Force, "P14" record when the Added
County Indicator Code equals Primary, "P" or
National, "N" or empty for Specialty Types. Values
checked are AIP Code, Reinsurance Year,
Commodity Year, Commodity Code, Policy
Number, Location County Code, and Insurance
Plan Code.
"*" = Output Only
3/20/2019
Page 34 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Added County Indicator Code allows only one
Insurance in Force, "P14" record when the Added
County Indicator Code equals Primary, "P" or
National, "N" or is empty when Insurance Plan
Code equals Area Yield Protection "04", Area
Revenue Protection, "05" or Area Revenue
Protection with Harvest Price Exclusion, "06" and
multiple Type Code/Practice Code values were
selected. Values checked are AIP Code,
Reinsurance Year, Commodity Year, Commodity
Code, Policy Number, Location County Code,
Coverage Type Code, Type Code and Practice
Code.
"*" = Output Only
3/20/2019
Page 35 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Added County Indicator Code allows only one
Insurance in Force, "P14" record when the Added
County Indicator Code equals Primary, "P" or
National, "N" or is empty when the Commodity
Code equals Nursery, "0073". Values checked
are AIP Code, Reinsurance Year, Commodity Year,
Commodity Code, Policy Number, Location
County Code, Coverage Type Code, Type Code,
and Practice Code.
"*" = Output Only
3/20/2019
Page 36 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Added County Indicator Code allows only one
Insurance in Force, "P14" record when the
Commodity Code does not equal Grapes, "0053",
Dry Beans, "0047", Dry Peas "0067", Nursery,
"0073" or Pasture, Rangeland and Forage (PRF),
"0088" and when the Location State Code does
not equal Arizona, "04" or California, "06" and the
Commodity Code equals Table Grapes, "0052"
and the Location State Code does not equal
Texas, "48" and Commodity Code equals
Tangerine Trees, "0193", Orange Trees, "207" or
Grapefruit Trees, "208" and the Location state
code does not equal Florida, "12" and the
Commodity Code equals Grapefruit, "0201"',
Lemons, "0202", Tangelos, "0203", Oranges,
"0227", Tangerines, "0309", Tangors, "1302" or
Limes, "9936" and the Insurance Plan Code does
not equal Area Yield Protection "04", Area
Revenue Protection, "05" or Area Revenue
Protection with Harvest Price Exclusion, "06" or
"*" = Output Only
3/20/2019
Page 37 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
the Insurance Plan Code equals Area Yield
Protection "04", Area Revenue Protection, "05" or
Area Revenue Protection with Harvest Price
Exclusion, "06" and submitted Commodity State
County Count equals "1" and Added County
Indicator Code equals Primary, "P" or National,
"N" and Commodity is not a Specialty Type.
Added County Code equal to Subsequent, "S"
must be submitted after the Sales Closing Date.
"*" = Output Only
3/20/2019
Page 38 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
When submitting an added county policy ('S'
record) and the primary county policy ('N' or 'P'
record) on the same batch, the primary record
must have been previously accepted with the
following matching values: AIP Code, Reinsurance
Year, Added County AIP Policy Producer Key,
Added County AIP Insurance In Force Key,
Commodity Year, Commodity Code, Coverage
Level Percent, Price Election Percent, Price
Indicator Code, Location State Code if the primary
county policy is equal to 'P', Coverage Type Code,
Insurance Plan Code.
Exceptions: if the Added County Indicator Code of
the primary county policy is equal to 'N' then the
Location State Code does not have to match. If
the added county policy is CAT and the primary
county policy is buy-up, then the Coverage Type
Code, Coverage Level Percent, Price Election
Percent, and/or Price Indicator Code can be
different and the Insurance Plan Code does not
have to match as long as the Insurance Plan Code
of the added county policy is '01', '02', or '03' and
the Insurance Plan Code of the primary county
policy is '01', '02', '03', '04', '05', or '06'.
"*" = Output Only
3/20/2019
Page 39 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
When submitting an added county policy ('S'
record) and the primary county policy ('N' or 'P'
record) on a different batch, the primary record
must have been previously accepted with the
following matching values: AIP Code, Reinsurance
Year, Added County AIP Policy Producer Key,
Added County AIP Insurance In Force Key,
Commodity Year, Commodity Code, Coverage
Level Percent, Price Election Percent, Price
Indicator Code, Location State Code if the primary
county policy is equal to 'P', Coverage Type Code,
Insurance Plan Code.
Exceptions: if the Added County Indicator Code of
the primary county policy is equal to 'N' then the
Location State Code does not have to match. If
the added county policy is CAT and the primary
county policy is buy-up, then the Coverage Type
Code, Coverage Level Percent, Price Election
Percent, and/or Price Indicator Code can be
different and the Insurance Plan Code does not
have to match as long as the Insurance Plan Code
of the added county policy is '01', '02', or '03' and
the Insurance Plan Code of the primary county
policy is '01', '02', '03', '04', '05', or '06'.
"*" = Output Only
3/20/2019
Page 40 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
When the Added County Indicator Code of "N" or
"P" is submitted for commodities electing the LP
option code then the same Added County
Indicator Code must be on both irrigation
practices (IRR and NonIRR) Insurance In Force,
"P14" records.
Added County Indicator Code must be empty
when Commodity Code equals Milk, "0830".
P14
41
Added County AIP Policy Producer Key
Character
15
P14
42
Added County AIP Insurance In Force Key
Character
15
P14
43
Policy History Request Code
Character
1
"*" = Output Only
3/20/2019
Page 41 of 75
Added County AIP Policy Producer Key is required
when Added County Indicator Code equals
Subsequent "S", otherwise empty.
Added County AIP Policy Producer Key must equal
the corresponding Primary "P" or National "N"
Policy Producer, "P10" when Added County
Indicator Code equals Subsequent, "S".
Added County AIP Insurance In Force Key is
required when the Added County Indicator Code
equals Subsequent "S", otherwise empty.
Policy History Request Code must be valid; edit
with "D00146" ICE table.
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
P14
44
Field Name
Reference Commodity Year
Insurance In Force
P14
Data Type
Numeric
Max
Length
4
File Type:
Reinsurance Year:
Version:
Release Date:
Format
CCYY
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Reference Commodity Year is Required when
Commodity Code equals Olives, "0501" or
Pistachios, "0470" or when the Insurance Plan
Code equals Pecan Revenue, "41".
Reference Commodity Year must be between
Commodity Year -1 and Commodity Year when
Reference Commodity Year exists and Insurance
Plan Code equals Pecan Revenue, "41".
P14
45
Percent of Value
Numeric
4
9.99
Percent of Value is required when Commodity
Code equals PRF, "0088" and Annual Forage,
"0332". For all other commodities, this field must
be empty.
Percent of Value must be between 0.10 and 1.00.
Percent of Value must be greater than or equal to
the Minimum Acre Percent and less than or equal
to the Maximum Acre Percent in the Price ADM,
"A00810".
"*" = Output Only
3/20/2019
Page 42 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
46
Field Name
Entity Certification Code
Insurance In Force
P14
Data Type
Character
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
For Annual Forage, "0332", the sum of Percent of
Value for all intervals in the same growing season
must equal 1.00 where the same growing season
is defined by Policy Number, AIP Policy Producer
Key, Location State Code, Location County Code,
Commodity Code, Insurance Plan Code and
Growing Season.
Entity Certification Code must be valid; edit with
the ICE "D00147".
1
Entity Certification Code is required when the SSA
Death Master File indicates that a potentially
invalid Tax ID is associated with this policy.
47
"*" = Output Only
3/20/2019
Associated AIP Policy Producer Key
Character
15
Page 43 of 75
N
N
Associated AIP Policy Producer Key is required
when the Insurance Plan Code equals
Supplemental Coverage Option (SCO); "31", "32",
"33".
Associated AIP Policy Producer Key is optional
when the Insurance Plan Code equals Margin
Protection (MP); "16", "17" or Stacked Income
Protection Plan (STAX); "35", "36".
Associated AIP Policy Producer Key must be
empty when the Insurance Plan Code does not
equal Margin Protection, SCO or STAX; "16", "17",
"31", "32", "33", "35", "36".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Associated AIP Policy Producer Key must exist
when Associate AIP Insurance In Force Key exists.
48
Associated AIP Insurance In Force Key
Character
15
N
N
Associated AIP Policy Producer Key is required for
STAX when the STAX policy is found to have a
base companion policy.
Associated AIP Insurance In Force Key is required
when the Insurance Plan Code equals
Supplemental Coverage Option (SCO); "31", "32",
"33".
Associated AIP Insurance In Force Key is optional
when the Insurance Plan Code equals Margin
Protection (MP); "16", "17" or Stacked Income
Protection Plan (STAX); "35", "36".
Associated AIP Insurance In Force Key must be
empty when the Insurance Plan Code does not
equal Margin Protection, SCO or STAX; "16", "17",
"31", "32", "33", "35", "36".
Associated AIP Insurance In Force Key must exist
when Associate AIP Policy Producer Key exists.
Associated AIP Insurance In Force Key is required
for STAX when the STAX policy is found to have a
base companion policy.
"*" = Output Only
3/20/2019
Page 44 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
49
Field Name
Coverage Range
Insurance In Force
P14
File Type:
Reinsurance Year:
Version:
Release Date:
Data Type
Max
Length
Format
Numeric
6
9.9999
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Coverage Range is Required when Insurance Plan
Code is one of the following values: '35', '36'.
Coverage Range must be empty when Insurance
Plan Code is not one of the following values: '35',
'36'.
Combination of Coverage Level Percent (Area
Loss Start Percent) and Coverage Range
(Coverage Level Percent - Coverage Range = Area
Loss End Percent) must be valid; edit with Area
Risk Rate ADM "A01005" record when Associated
AIP Insurance In Force Key exists and Associated
AIP Policy Producer Key exists and Insurance Plan
Code is one of the following values: '35', '36'.
P14
"*" = Output Only
3/20/2019
50
Policy Cancellation Code
Character
1
Page 45 of 75
Coverage Level Percent minus Coverage Range
must be greater than or equal to Associated
Coverage Level Percent when Associated AIP
Policy Producer Key exists and Associated AIP
Insurance In Force Key exists and Insurance Plan
Code is one of the following values: '35', '36'.
Coverage Range must be one of the following
values: '0.0500', '0.1000', '0.1500', '0.2000'.
Reserved
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
P14
*
51
P14
*
P14
Insurance In Force
P14
Data Type
Max
Length
Valid Commodity Type Code
Character
3
52
Valid Class Code
Character
3
*
53
Valid Sub Class Code
Character
3
P14
*
54
Valid Intended Use Code
Character
3
P14
*
55
Valid Irrigation Practice Code
Character
3
P14
*
56
Valid Cropping Practice Code
Character
3
P14
*
57
Valid Organic Practice Code
Character
3
P14
*
58
Valid Interval Code
Character
3
"*" = Output Only
3/20/2019
Field Name
Page 46 of 75
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Valid Commodity Type Code is populated from
the Valid Commodity Type Code in the Insurance
Offer ADM, "A00030".
Valid Class Code is populated from the Class Code
in the Insurance Offer ADM, "A00030".
Valid Sub Class Code is populated from the Sub
Class Code in the Insurance Offer ADM, "A00030".
Valid Intended Use Code is populated from the
Intended Use Code in the Insurance Offer ADM,
"A00030".
Valid Irrigation Practice Code is populated from
the Irrigation Practice Code in the Insurance Offer
ADM, "A00030".
Valid Cropping Practice Code is populated from
the cropping Practice Code in the Insurance Offer
ADM, "A00030".
Valid Organic Practice Code is populated from
ADM Insurance Offer Organic Practice Code
Valid Interval Code is populated from the Interval
Code in the Insurance Offer ADM, "A00030".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
File Type:
Reinsurance Year:
Version:
Release Date:
Insurance In Force
P14
Data Type
Max
Length
Format
P14
*
59
Lockdown Insurance Plan Code
Character
2
P14
*
60
Lockdown Price Election Percent
Numeric
6
9.9999
P14
*
61
Lockdown Coverage Level Percent
Numeric
6
9.9999
P14
*
62
LRR Percent
Numeric
4
9.99
P14
*
63
Lockdown Price Indicator Code
Character
1
P14
*
64
LRR Code
Character
2
"*" = Output Only
3/20/2019
Page 47 of 75
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Lockdown Insurance Plan Code will be the
Insurance Plan Code submitted by the AIP at the
later of the LRR Lockdown Date or the Initial
Accepted Date.
Lockdown Price Election Percent will be the Price
Election Percent submitted by the AIP at the later
of the LRR Lockdown Date or the Initial Accepted
Date.
Lockdown Coverage Level Percent will be the
Coverage Level Percent submitted by the AIP at
the later of the LRR Lockdown Date or the Initial
Accepted Date.
LRR Percent is the reduction percent for the later
of the Lockdown Date or Batch Received Date,
otherwise empty.
Lockdown Price Indicator Code will be the Price
Indicator Code submitted by the AIP at the later
of the LRR Lockdown Date or the Initial Accepted
Date.
LRR Code must be valid; edit with the LRR ICE,
"D00014".
Record
Number
P14
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
*
65
Field Name
LRR Transaction Cutoff Date
P14
*
66
LRR Change Date
P14
*
67
LRR Transaction Code
P14
*
68
P14
*
P14
Insurance In Force
P14
Data Type
Date
Max
Length
8
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
CCYYMMDD
LRR Transaction Cutoff Date is the Transaction
Cutoff Date for the week containing the 30th day
of the month after the Transaction Cutoff Date.
CCYYMMDD
LRR Change Date is the last date the Price Election
Percent, Price Indicator Code or Coverage Level
Percent was modified on the Insurance In Force,
"P14" or the Tax ID, Tax ID Type Code or Entity
Type Code was modified on the Policy Producer,
"P10" after the LRR Transaction Cutoff Date.
LRR Transaction Code must be valid; edit with the
LRR Transaction Code ICE, "D00046".
LRR Record Accepted Date is the date this
Insurance In Force, "P14" record was accepted for
LRR edits.
Ineligible SBI Share Percent must be greater than
zero when SBI is ineligible.
Date
8
Character
2
LRR Record Accepted Date
Date
8
CCYYMMDD
69
Ineligible SBI Share Percent
Numeric
6
9.9999
*
70
Duplicate Policy Code
Character
1
Duplicate Policy Code must be valid; edit with the
Duplicate Policy ICE, "D00010".
P14
*
71
Duplicate AIP Code
Character
2
Duplicate AIP Code is the code for the AIP with
the corresponding duplicate policy.
P14
*
72
Duplicate PIC Code
Character
3
Duplicate PIC Code is the PIC Code on the
corresponding duplicate policy.
"*" = Output Only
3/20/2019
Page 48 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
P14
*
73
P14
*
74
Field Name
Duplicate Policy Number
Contract Carryover Flag
Insurance In Force
P14
File Type:
Reinsurance Year:
Version:
Release Date:
Data Type
Max
Length
Character
7
Duplicate Policy Number is the Policy Number of
the corresponding duplicate policy.
1
Contract Carryover Flag equals Yes, "Y" when the
producer was insured for the AIP Code/Location
State Code/Location County Code/Commodity
Code/Insurance Plan Code in the previous year,
otherwise it equals No, "N".
Character
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Contract Carryover Flag cannot equal Yes, "Y" for
Texas Citrus in the current Reinsurance Year.
P14
*
75
Eligibility Code
Character
8
P14
*
76
Producer History Code
Character
100
"*" = Output Only
3/20/2019
Page 49 of 75
Eligibility Code is the returned values from the
Ineligible Tracking System.
Producer History Code will contain a comma
delimited list of the Production History for the
Producer for the Commodity within the Location
State Code and Location County Code when
Producer History exists. Each data item in the list
is in the format: "XCCYY", where "X" can be either
"P" to indicate "Producer" or "S" to indicate "SBI",
and "CCYY" will represent the year of history. If no
history is found, Producer History Code will equal,
No, "N".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
P14
*
77
P14
*
78
Field Name
Primary Fund Code
Approved Program Indicator Code List
Insurance In Force
P14
File Type:
Reinsurance Year:
Version:
Release Date:
Data Type
Max
Length
Character
1
Primary Fund Code must equal the Primary Fund
Code from the Fund Designation, "P09" record if
submitted; otherwise, Commercial "C".
20
Approved Program Indicator Code List will contain
a comma delimited list of Program Indicator
Codes that were elected and applied to the
Insurance In Force, "P14" record. A "NULL" value
will be returned if no programs were elected or
applied to the Insurance In Force, "P14" record.
Numeric
5
99999
Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.
Character
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
P14
*
79
Initial Accepted Batch Number
P14
*
80
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.
P14
*
81
Batch Received Date
Date/Time
21
CCYYMMDD
hh:mm:ss.fff
P14
*
82
Batch Number
Numeric
5
99999
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.
"*" = Output Only
3/20/2019
Page 50 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
P14
*
83
Batch Record ID
Numeric
15
P14
*
84
Process Result Code
Character
1
"*" = Output Only
3/20/2019
Page 51 of 75
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
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".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
Record Level Rules
"*" = Output Only
3/20/2019
1
Insurance In Force, "P14" records will be rejected
if there is no accepted corresponding Policy
Producer, "P10" record.
2
To avoid incurring LRR, an Insurance In Force,
"P14" with the following elements must be
accepted before the LRR Cutoff Date: AIP Code,
Location State Code, Policy Number, Commodity
Code, Commodity Year, Insurance Plan Code,
Location County Code, Coverage Type Code, Late
Reported Reason Code, Dual Coverage Flag,
Contract Carryover Flag, Coverage Level Percent,
Price Election Percent, and Price Indicator Code.
3
The Added County information contained on the
Insurance In Force, "P14" record is for
determining LRR, Added County reference can be
added after Sales Closing Date.
4
When the Insurance In Force, "P14" record is
submitted without a corresponding Fund
Designation, "P09"record, the Insurance in Force,
"P14" record will be assigned to the commercial
fund.
Page 52 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
A separate MPCI policy is allowed for acreage
grown under contract with different seed
companies for hybrid seed corn or hybrid
sorghum seed.
An Insurance In Force, "P14" record will not be
accepted when processing has been suspended
for this record type per RMA directive.
A proceeding Policy Producer, "P10" record in this
batch must be accepted for the Insurance In
Force, "P14" record to be accepted.
The count of Record Type Code must be less than
or equal to 2.
Type Code or Practice Code must not be empty
when multiple rows are submitted by AIP Policy
Producer Key, Commodity Code, Location State
Code, Location County Code, and Commodity
Year with a varying Coverage Level Percent or
Price Election Percent when the Insurance Plan
Code equals Area Yield Protection "04", Area
Revenue Protection "05" or Area Revenue
Protection with Harvest Price Exclusion "06".
5
6
7
8
9
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 53 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
The P14 record must be unique in the batch using
the following key: AIP Code, Reinsurance Year,
Policy Number, Location State Code, Location
County Code, Commodity Code, Coverage Type
Code, Dual Coverage Flag and Type Code when
Commodity Code equals Apples, "0054" or
Peaches, "0034" and the Type Code is not empty
OR when the Commodity Code equals Grapes,
"0053" or Table Grapes, "0052" with a Location
State Code equal to Arizona, "04" or California,
"06" OR when the Commodity Code equals
Tangerine Trees, "0193", Orange Trees, "0207" or
Grapefruit Trees, "0208" and the Location State
Code equals Texas, "48" or when the Commodity
Code equals Arizona, California, Florida, and
Texas Citrus Fruit Groups Grapefruits, "0201",
Lemons, "0202", Tangelos, "0203", Oranges,
"0227", Mandarins/Tangerines, "0309", Tangors,
"1302" or Limes, "9936" or when the Commodity
Code equals PRF, "0088".
10
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 54 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
"*" = Output Only
3/20/2019
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
11
When processing Insurance In Force, "P14"
records for Specialty Type Commodities, multiple
Insurance In Force, "P14" record submission is
allowed as long as the Acreage, "P11" indicates it
is a Specialty Type Commodity, the exact Specialty
Type does not need to match on the Insurance In
Force, "P14" and the Acreage, "P11" records.
12
When processing Insurance In Force, "P14"
records for Specialty Type Commodities, multiple
Insurance In Force, "P14" record submission is
allowed as long as the Yield, "P15" indicates it is a
Specialty Type Commodity, the exact Specialty
Type does not need to match on the Insurance In
Force, "P14" and the Yield, "P15" records.
Page 55 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
For the record key AIP Code, AIP Insurance In
Force Key, AIP Policy Producer Key, Reinsurance
Year, the following values must be the same as
prior submission: AIP Code, AIP Policy Producer
Key, Commodity Code, Commodity Year, Dual
Coverage Flag, Location County Code, and
Reinsurance Year when the Commodity Code
does not equal Grapes, "0053", Nursery, "0073"
Tangerine Trees, "0193", Orange Trees, "0207" or
Grapefruit Trees, "0208", the Location State Code
does not equal Arizona, "04" or California, "06" or
when the Commodity Code equals Table Grapes,
"0052".
13
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 56 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
For the record key AIP Code, AIP Insurance In
Force Key, AIP Policy Producer Key, Reinsurance
Year, the following values must be the same as
prior submission: AIP Code, AIP Policy Producer
Key, Commodity Code, Commodity Year, Dual
Coverage Flag, Location County Code,
Reinsurance Year and Type Code when Location
State Code equals Arizona, "04" or California, "06"
and the Commodity Code equals Table Grapes,
"0052", Grapes, "0053" or when the Commodity
Code equals Tangerine Trees, "0193", Orange
Trees, "0207" or Grapefruit Trees, "0208" and the
Location State Code equals Texas, "48".
14
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 57 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
The Insurance in Force, "P14" record must be
unique in the batch using the following key: AIP
Code, Reinsurance year, AIP Policy Producer Key,
Location County Code, Commodity Code,
Commodity Year and Dual Coverage Flag when
the Commodity Code does not equal Table
Grapes, "0052", Grapes, "0053", Nursery, "0073",
PRF, "0088", Annual Forage, "0332" and the
Location State Code does not equal Arizona, "04",
California, "06", Florida, "12" and the Commodity
Code equals Grapefruit, "0201", Lemons, "0202",
Tangelos, "0203", Oranges, "0227",
Mandarins/Tangerines, "0309", Tangors, "1302",
Limes, "9936" and the Location State Code does
not equal Texas, "48" and
15
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 58 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
the Commodity Code equals Tangerine Trees,
"0193", Orange Trees, "0207", Grapefruit Trees,
"0208" and the Commodity Code does not equal
Peaches, "0034", Dry Beans, "0047", Apples,
"0054", Dry Peas, "0067", Pears, "0089" and a
valid Type Code is submitted and when Insurance
Plan Code does not equal Area Yield Protection,
"04", Area Revenue Protection, "05", Area
Revenue Protection with Harvest Price Exclusion,
"06" and submitted Commodity State County
Count equals 1 and a Fall to Spring County Flag
does not equal Yes, "Y" and the Specialty Type
Commodity equals No, "N".
This record must be unique in the batch using the
following key: AIP Code, AIP Policy Producer Key,
Commodity Code, Commodity Year, Dual
Coverage Flag, Location County Code,
Reinsurance Year, and Coverage Type Code
(within Seed Cycle).
16
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 59 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
For commodities with 2-year coverage scenario
such as Pecans, Pistachios, and Olives, the 1st
year record must already be accepted and the
Coverage Level Percent and Price Election Percent
cannot change in the 2nd year from what was
submitted in the 1st year.
For the High-Risk Alternate Coverage
Endorsement (HR-ACE) record, PASS is unable to
locate the corresponding non-HR-ACE record of
the base policy. For the SCO HR-ACE record, PASS
is unable to locate the corresponding non-HR-ACE
SCO record of the base policy.
For commodities with 2-year coverage scenarios
such as Pecans, the 1st year record must already
be accepted and the Reference Commodity Year
cannot change in the 2nd year from what was
submitted in the 1st year.
For commodities with 2-year coverage scenarios
such as Pecans, a 1st year record cannot exist two
years in a row.
The Insurance In Force, "P14" record must be a
valid combination for the submitted Commodity
Codes when Practice Code is submitted.
17
18
19
20
21
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 60 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
The Insurance In Force, "P14" record must be a
valid combination for the submitted Commodity
Code when no Type Code or Practice Code is
submitted.
The Insurance In Force, "P14" record must be a
valid combination for the submitted Commodity
Code when a Type Code and Practice Code is
submitted.
The Insurance In Force, "P14" record must be a
valid combination for the submitted Commodity
Code when the Type Code is submitted.
This record must be unique in the batch using the
following key: AIP Code, Reinsurance Year, AIP
Policy Producer Key, Location County Code,
Commodity Code, Commodity Year, Coverage
Type Code, Type Code, and Practice Code when
the Commodity Code equals Nursery, "0073".
22
23
24
25
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 61 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
For the record key AIP Code, AIP Insurance In
Force Key, AIP Policy Producer Key, Reinsurance
Year, the following values must be the same as
prior submission: AIP Code, AIP Policy Producer
Key, Commodity Code, Commodity Year, Location
County Code, Reinsurance Year, and Practice
Code when the Commodity Code equals Nursery,
"0073".
26
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 62 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
This record must be unique in the batch using the
following key: AIP Code, Reinsurance Year, Policy
Number, Location State Code, Location County
Code, Commodity Code, Coverage Type Code,
Dual Coverage Flag, and Type Code for Peaches,
"0034", Apples, "0054", and Pears, "0089" only if
Type Code is not empty or when the Commodity
Code equals, Grapes, "0053" or Table Grapes,
"0052", and the Location State Code equals
Arizona, "04" or California, "06" or when the
Location State Code equals Texas, "48" and the
Commodity Code equals Tangerine Trees, "0193",
Orange Trees, "207" or Grapefruit Trees, "208" or
Location State Code equals Florida, "12" and the
Commodity Code equals Tangerine Trees, "0193",
Orange Trees, "0207" or Grapefruit Trees, "0208"
or Location State Code equals Florida, "12" and
the Commodity Code equals Grapefruit, "0201"',
Lemons, "0202", Tangelos, "0203", Oranges,
"0227", Tangerines, "0309", Tangors, "1302" or
Limes, "9936" or when Commodity Code equals
PRF, "0088".
27
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 63 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
This record must be unique in the batch using the
following key: AIP Code, Reinsurance Year, AIP
Policy Producer Key, Location County Code,
Commodity Code, Commodity Year, Dual
Coverage Flag, Type Code, and Practice Code
when Insurance Plan Code equals Area Yield
Protection, "04", Area Revenue Protection, "05",
Area Revenue Protection with Harvest Price
Exclusion, "06" or STAX, "35", "36" and multiple
Type Code/Practice Code values are submitted.
28
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 64 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
This record must be unique in the batch using the
following key: AIP Code, Reinsurance Year, AIP
Policy Producer Key, Location County Code,
Commodity Code, Commodity Year, Dual
Coverage Flag, and Type Code when (Type Code
exists) and the Commodity Code equals
Grapefruits, "0201", Lemons, "0202", Tangelos,
"0203", Oranges, "0227", Mandarins/Tangerines,
"0309", Tangors, "1302" or Limes, "9936" with a
Location State Code equal to Florida, "12" or the
Commodity Code equals Dry Beans, "0047" or Dry
Peas, "0067".
29
Data (e.g., Signature Date) cannot change
between submissions if it changes the LRR
Transaction Cutoff Date and Premium Acreage
records have been submitted. Refer to LRR
Transaction Code for data change.
The Coverage Level Percent(s) of the grouped
Insurance in Force, "P14" record(s) must equal
within the same AIP Policy Producer Key and
within the same Insurance Offer Group.
30
31
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 65 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
The SSA Death Master File indicates that the
Primary Producer on this Policy died 30 days prior
to the Sales Closing Date. The producer should no
longer be eligible for this policy.
The SSA Death Master File indicates that the SBI
on this Policy died 30 days prior to the Sales
Closing Date. The producer should no longer be
eligible for this policy.
32
33
This record must be unique in the batch using the
following key: AIP Code, Reinsurance Year, AIP
Policy Producer Key, Location County Code,
Commodity Code, Commodity Year, Dual
Coverage Flag and Group Code when the
Commodity Code equals Cherries, "0057". There
cannot be more than one Insurance In Force,
"P14" record for Sweet or Tart Cherries.
34
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 66 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
"*" = Output Only
3/20/2019
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
35
This record must be unique in the batch using the
following key: AIP Code, Reinsurance Year, AIP
Policy Producer Key, Location County Code,
Commodity Code, Commodity Year, Dual
Coverage Flag, and Type Code when Commodity
Code is Oranges, "0227" and Location State Code
is one of the following values: Arizona, "04",
California, "06" and Type Code is Navel Oranges,
"134". The producer in the county is not allowed
to insure Oranges, "0227" under APH Insurance
Plan Code "90" with Navel Oranges Type Code,
"134" and ARH Insurance Plan Code "47" with
Navel Oranges Type Code, "134" or NULL Type
(empty).
36
When the Commodity Code equals Cherries,
"0057" with the Tart Cherries Type Code, "416",
then the Type Code on the associated Fund
Designation, "P09" record must also equal the
Tart Cherries Type Code, "416".
Page 67 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
The Filing Date must be greater than or equal to
06/30/2014 in order to qualify for the Beginning
Farmer Rancher Program.
The corresponding SCO high risk (HR-ACE) policy
is required for this SCO policy when its associated
underlying policy has a corresponding high risk
(HR-ACE) policy.
When the Insurance Plan Code equals the
following values: "31", "32", "33" for SCO or, "35",
"36" for STAX and the Associated AIP Policy
Producer Key and the Associated AIP Insurance In
Force Key are submitted, then an accepted
associated policy with the Insurance Plan Code
"01", "02", or "03" for SCO/STAX or "04", "05",
"06" for STAX must be found for the Associated
AIP Policy Producer Key and Associated AIP
Insurance In Force Key in the same batch or prior
batch.
37
38
39
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 68 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
When the Insurance Option Code List contains
"LP", there must be two Insurance in Force, "P14"
records with the "LP" option code for the same
policy/batch submitted by the Sales Closing Date.
One "P14" for the irrigated practice and one
"P14" for the non-irrigated practice. If the
commodity is by type or variety then the multiple
Insurance in Force, "P14" records must be by type
and by practice.
When the Insurance Option Code List contains
"LP" and the commodity is not by type or variety
where the Commodity Code is not one of the
following values: "0052", "0053", "0034", "0054",
"0047", "0067", "0089", there must be two
Insurance in Force, "P14" records for
Irrigated/Non-Irrigated Practices submitted by the
Sales Closing Date and the coverage levels must
be different by irrigation practice.
40
41
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 69 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
"*" = Output Only
3/20/2019
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
42
When the Insurance Option Code List contains
"LP" and the commodity is by type or variety
where the Commodity Code is one of the
following values: "0052", "0053", "0034", "0054",
"0047", "0067", "0089", there must be two
Insurance in Force, "P14" records by type for
Irrigated/Non-Irrigated Practices submitted by the
Sales Closing date and the coverage levels must
be different by irrigation practice.
43
When the LP option code is elected, all options
and endorsements must be listed on the irrigated
practice and the non-irrigated practice Insurance
In Force, "P14" records; insurance options must
match across irrigation practices. Match is not
required when option is not found in the Option
Rate ADM, "ADM01060", for the
commodity/plan/practice.
Page 70 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
For commodities electing the LP and HB option
codes, all irrigation practices should match
between the LP "P14" record and endorsements
"P14" record; the Practice Code should match
exactly between the LP non-HB base policy "P14"
record and the LP HB "P14" record.
When SCO with the LP option code is elected, all
options and endorsements on the LP base policy
Insurance In Force, "P14" records must also be on
the SCO LP Insurance In Force, "P14" records.
Match is not required when option is not found in
the Option Rate ADM, ADM01060", for the
commodity/plan/practice.
44
45
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
46
For SCO, if the base policy Insurance In Force,
"P14" record has the LP option code elected then
the Practice Code should match exactly between
the base policy "P14" records and the SCO "P14"
records.
47
When a base policy Insurance In Force, "P14"
record exists, the SCO and/or STAX "P14" records
will be rejected if there is no accepted base policy
"P14" record.
Page 71 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
For commodities not by type or variety where the
Commodity Code is not one of the following
values: "0034", "0047", "0052", "0053", "0054",
"0067", and the Insurance Option Code List
contains "LP" there must be two Insurance In
Force, "P14" records for the Irrigated/NonIrrigated Practices sent by the Sales Closing Date
and the Coverage Level must be different by
irrigation practice.
For STAX policies, when a base companion policy
under ARPI Insurance Plan Codes "04", "05", "06"
with multiple types and practices exist, then there
must be a one to one match by type and by
practice of the STAX "P14" record to the ARPI
base companion "P14" record.
When Insurance Plan Code is "04", "05", "06",
there must be one and only one SCO or STAX
Insurance In Force, "P14" record pointing to a
particular base "P14" record. Multiple SCO or
STAX "P14" records for the same policy, same
Associated AIP Policy Producer Key, and same
Associated AIP Insurance In Force Key are not
allowed.
48
49
50
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 72 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
"*" = Output Only
3/20/2019
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
51
For STAX, if the base/companion policy Insurance
In Force, "P14" record has the LP option code
elected then the Irrigation Practice Code between
the base policy "P14" records and the STAX "P14"
records must match.
52
For SCO policies, the Malting Barley Endorsement
option (ME) or Cottonseed Endorsement option
(SE) cannot be submitted unless the same
endorsement option code is also submitted for
the SCO base companion policy.
53
When the LP option code is elected the Irrigation
Practice Code, instead of the Practice Code, will
be used to validate the elected option codes in
the Insurance Option Code List.
Page 73 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
"*" = Output Only
3/20/2019
Field Name
Insurance In Force
P14
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
54
When the Insurance Plan Code equals "16", "17"
for Margin Protection, and the Associated AIP
Policy Producer Key and the Associated AIP
Insurance In Force Key are submitted, then an
accepted associated policy with the Insurance
Plan Code "01", "02", or "03" must be found for
the Associated AIP Policy Producer Key and
Associated AIP Insurance In Force Key in the same
batch.
55
Margin Protection cannot be elected with a base
policy if the base policy has elected the High-Risk
Alternate Coverage Endorsement.
56
Margin Protection cannot be elected with a base
policy if the base policy has elected SCO.
57
Margin Protection cannot be elected with a base
policy if the base policy has elected STAX.
Page 74 of 75
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Insurance In Force
P14
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
4/4/2019
Rules
58
When the underlying policy (Insurance Plan Codes
01, 02, or 03) is tied to an MP policy (Insurance
Plan Codes 16, 17), then the underlying policy
cannot be accompanied by a High Risk land
Exclusion (HB Insurance Option Code) policy.
59
If the base policy (non-HR-ACE) has the LP option
then the high-risk policy (HR-ACE) must also have
the LP option. If the base policy (non-HR-ACE)
doesn't have the LP option then the high-risk
policy (HR-ACE) should not have the LP option.
For STAX policies, when a base companion policy
under Insurance Plan Codes "01", "02" and "03"
exists, then there can be multiple STAX "P14"
records matching back to one base companion
"P14" record under Insurance Plan Code "01",
"02" or "03".
For MP Plans (16, 17), when submitting multiple
P14 records by type and practice (meaning one
irrigated and one non-irrigated) then the
Insurance Plan Code must match by type.
60
61
"*" = Output Only
3/20/2019
File Type:
Reinsurance Year:
Version:
Release Date:
Page 75 of 75
| File Type | application/pdf |
| File Title | P14 Insurance In Force Record |
| Subject | PASS Record |
| Author | USDA Risk Management Agency |
| File Modified | 2019-03-20 |
| File Created | 2019-03-20 |