P11 Acreage Record

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

P11

1

AIP Code

Character

2

Y

P11
P11

2
3

Reinsurance Year
Record Type Code

Numeric
Character

4
6

P11

4

AIP Policy Producer Key

Character

15

P11

5

AIP Insurance In Force Key

Character

15

Y

Y

P11

6

AIP Acreage Key

Character

15

Y

Y

P11

7

AIP Insurance Agent Key

Character

15

CCYY

Y
Y

Y
Y
Y

Y

Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must be "2011".
Record Type Code must be "P11".
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 must be unique within the
submitted Acreage, "P11" records.
AIP Insurance Agent Key must match the
corresponding Insurance Agent, "P55" record.
AIP Insurance Agent Key must refer to an active
Agent “P55” record, or an Agent who is inactive
and the Agent Acreage/Inventory Value Signature
Date is less than the inactive date.

"*" = Output Only
2/22/2012

P11

8

AIP Yield Key

Character

15

P11

9

Basic Unit Number

Character

4

Page 1 of 36

Y

Y

AIP Yield Key must exist on a previously submitted
Yield, "P15" record;edit with the Yield
Requirement ICE, "D00066".
AIP Yield Key must be empty when a Yield, "P15"
record cannot be submitted for the Insurance
Plan Code and Commodity Code.
AIP Yield Keys must match when reporting Cotton
Lint and Cottonseed records.
Basic Unit Number must be a unique number
identifying the Policy Producer’s Basic Unit and is
used in conjunction with the Unit Structure Code
of Basic Unit, “BU”.
Basic Unit Number must be greater than '0000'
when Unit Structure Code equal "BU".
Basic Unit Number is Required when Non
Premium Acreage Code is empty or equals Zero
Unit Acres, "X".

Record
Number

P11

Output

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

10

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

Acreage
P11
Max

Field Name

Optional Unit Number

Data Type Length

Character

4

Format

BUS
Key Req?

Y

Y

Rules
Optional Unit Number must be a unique number
identifying the Policy Producer’s Optional Unit
and is used in conjunction with the Unit Structure
Codes of Optional Unit, “OU”, “UA” or “UD”.
Optional Unit Number must be greater than
'0000' when Unit Structure Code equals "OU",
"UA" or "UD"'.
Optional Unit Number must equal "0000" when
Non Premium Acreage Code equals Uninsured,
"U" and Commodity Code equals Burley Tobacco,
"0073" or Mint, "0074", Location State Code
equals Washington, "53", Location County Code
equals Yakima, "077" or Grant, "025" and Type
Code equals "084", "085","086" or "087".

P11

11

Unit Structure Code

Character

2

Y

Optional Unit Number is Required when Non
Premium Acreage Code is empty or equals Zero
Unit Acres, "X".
Unit Structure Code must be valid for the
reporting Unit; edit with the Unit Structure ICE,
"D00095".
Unit Structure Code must be valid; edit with
Insurance Plan Commodity Unit Structure ICE
"D00092" record.
Unit Structure Code is required when Insurance
Plan Code is not equal to; Group Risk Plan, "04",
Group Risk Income Protection with Harvest Price
Option, "05", Group Risk Income Protection, "06",
Rainfall Index, "13" or Vegetation Index, "14" and
Non Premium Acreage Code is empty or Non
Premium Acreage Code equals "H", "X" or "'U".

"*" = Output Only
2/22/2012

Page 2 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Unit Structure Code must be empty when
Insurance Plan Code equals Group Risk Plan, "04",
Group Risk Income Protection with Harvest Price
Option, "05", Group Risk Income Protection, "06",
Rainfall Index, "13" or Vegetation Index, "14".
Unit Structure Code must be valid; edit with
Insurance Plan Commodity Unit Structure ICE
"D00092" record.
Unit Structure Code must equal Basic Unit, "BU"
for Malting Barley.
Unit Structure Code is Required when Commodity
Price Processing Code is empty or is equal to "S"
or when Commodity Price Processing Code equals
"M" and Contract Liability Record Flag equals Yes,
"Y" or when Contract Liability Record Flag equals
No, "N" the Commodity Code equals Peanuts,
"0075", the Non Premium Acreage Code is empty
or equals "H", "X" or "U".
Unit Structure Code must be empty when
Commodity Code equals Peanuts, "0075" and
Commodity Price Processing Code equals "M" and
the Contract Liability Record Flag is empty.

P11

12

APH Procedural Exception Number

Character

3

The APH Procedural Exception Number is a
unique three digit number used only when
reporting multiple “APH Databases” is allowed.
The APH Procedural Exception Number must be
greater than zero when required to uniquely
identify which Yield, "P15" record set should be
used by the Acreage, "P11" record; otherwise
empty.

"*" = Output Only
2/22/2012

Page 3 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
The APH Procedural Exception Number value on
the Yield, "P15" record set must match the APH
Procedural Exception Number value on the
corresponding Acreage, "P11" record set.

P11

13

APH Procedural Exception Code

Character

APH Procedural Exception Code must be valid;
edit with the APH Procedural Exception ICE,
"D00096" otherwise the APH Procedural
Exception Code and the APH Procedural
Exception Number must be empty.

1

The APH Procedural Exception Code value on the
Yield, "P15" record must match the APH
Procedural Exception Code value on the
corresponding Acreage, "P11" record.

P11

P11

14

15

Contract Liability Record Flag

Type Code

Character

Character

Contract Liability Record Flag is required and must
be Yes, "Y" when Commodity Price Processing
Code equals Multiple Prices, "M" and the
Commodity Code equals Peanuts, "0075" and
Contract Price is greater than zero.

1

3

Y

Contract Liability Record Flag must be No, "N"
when Commodity Price Processing Code equals
Multiple Prices, "M" and the Commodity Code
equals Peanuts, "0075" and Contract Price is
equal to zero.
Contract Liability Record Flag must be empty
when Commodity Code does not equal Peanuts,
"0075", the Commodity Price Processing Code is
not Multiple, "M".
Type Code is required; edit with the Insurance
Offer ADM, "A00030".
Type Code is Required when Non Premium
Acreage Code equals "Z" and Commodity Code
equals Table Grapes, "0053" or Grapes, "0052",
Non Premium Acreage Code is empty or equals
"C" or "I" and Type Practice Use Code in the Type
Practice ICE is not equal to Implemented, "I".

"*" = Output Only
2/22/2012

Page 4 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Type Code must be empty when Type Practice
Use Code in the Type Practice ICE equals
Implemented, 'I'.
Type Code is Required when Non Premium
Acreage Code equals "U" and the Commodity
Code equals Table Grapes, "0052" or Grapes,
"0053" with a Location State Code equal to
Arizona, "04" or California, "06" or the
Commodity Code equals Tangerine Trees, "0193",
Orange Trees, "0207" or Grapefruit Tree, "0208"
with a Location State Code equal to Texas, "48" or
the Non Premium Acreage Code is empty or
equals "C" or "I".

P11

16

Practice Code

Character

3

Y

Practice Code is required; edit with the Insurance
Offer ADM, "A00030".
Practice Code is required when Non Premium
Acreage Code is empty or when Non Premium
Acreage Code equlas "C" or "I" and Type Practice
Use Code in the Type Practice ICE is not equal to
Implemented "I".
Practice code must be empty when Type Practice
Use Code equals "I".
Practice Coe must be valid; edit with Practice
ADM, "A00510"

P11

P11

"*" = Output Only
2/22/2012

17

18

Commodity Type Code

Class Code

Character

Character

3

Commodity Type Code must be valid; edit with
the Commodity Type ADM, "A00430". When
Commodity Type Code is not valid and Type
Practice Use Code equals Implemented, "I",
record will be rejected, otherwise record will be
accepted with a warning.

3

Class Code must be valid; edit with the Class
ADM, "A00410". When Class Code is not valid and
Type Practice Use Code equals Implemented, "I",
record will be rejected, otherwise record will be
accepted with a warning.

Page 5 of 36

Record
Number

P11

P11

P11

P11

P11

P11

"*" = Output Only
2/22/2012

Output

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

19

20

21

22

23

24

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

Acreage
P11
Max

Field Name

Sub Class Code

Intended Use Code

Irrigation Practice Code

Cropping Practice Code

Organic Practice Code

Interval Code

Data Type Length

Character

Character

Character

Character

Character

Character

Format

BUS
Key Req?

Rules

3

Sub Class Code must be valid; edit with the Sub
Class ADM, "A00530". When Sub Class Code is not
valid and Type Practice Use Code equals
Implemented, "I", record will be rejected,
otherwise record will be accepted with a warning.

3

Intended Use Code must be valid; edit with the
Intended Use ADM, "A00470". When Intended
Use Code is not valid and Type Practice Use Code
equals Implemented, "I", record will be rejected,
otherwise record will be accepted with a warning.

3

Irrigation Practice Code must be valid; edit with
the Irrigation Practice ADM, "A00490". When
Irrigation Practice Code is not valid and Type
Practice Use Code equals Implemented, "I",
record will be rejected, otherwise record will be
accepted with a warning.

3

Cropping Practice Code must be valid; edit with
the Cropping Practice ADM, "A00450". When
Cropping Practice Code is not valid and Type
Practice Use Code equals Implemented, "I",
record will be rejected, otherwise record will be
accepted with a warning.

3

Organic Practice Code must be valid; edit with the
Organic Practice ADM, "A00500". When Organic
Practice Code is not valid and Type Practice Use
Code equals Implemented, "I", record will be
rejected, otherwise record will be accepted with a
warning.

3

Interval Code must be valid; edit with the Interval
ADM, "A00480". When Interval Code is not valid
and Type Practice Use Code equals Implemented,
"I", record will be rejected, otherwise record will
be accepted with a warning.

Page 6 of 36

Record
Number

P11

Output

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

25

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

Acreage
P11
Max

Field Name

Range Class Code

Data Type Length

Character

Format

BUS
Key Req?

Rules
Range Class Code must be valid; edit with the
Price ADM, "A00810" record when Insurance Plan
Code equals Tree Based Dollar Amount of
Insurance, "40" or Dollar Amount of Insurance,
"50".

3

Range Class Code must be valid; edit with the
Base Rate ADM, "A01010" when Insurance Plan
Code equals Pecan Revenue, "41".
Range Class Code is required when Insurance Plan
Code is one of the following values: Tree Based
Dollar Amount of Insurance, "40", Pecan
Revenue, "41" or Dollar Amount of Insurance,
"50" and Non Premium Acreage Code is empty
and Range Class is necessary to determine Prices
and Rates.
P11

P11

26

27

Reference Commodity Year

Non Premium Acreage Code

Numeric

4

Character

1

CCYY

Reference Commodity Year is required when
Commodity Code equals Pecans, "0020".
Reference Commodity Year must equal the first
year of the current 2 year module.
Non Premium Acreage Code must be valid; edit
with the Non Premium Acreage ICE, "D00050".
See P11- 1 Non Premium Acreage Reporting
Requirements exhibit.
Non Premium Acreage Code must be valid; for the
Insurance Plan Code and Commodity Code when
submitted; edit with the Non Premium Acreage
Insurance Commodity ICE, "D00049".
Non Premium Acreage Code must equal High Risk
Land excluded from the policy and not insured,
"H" when the Cotton Lint is excluded from
Insurance and the Insurance Option Code List on
the Insurance in Force, "P14" record equals
Cottonseed Endorsement, "SE".

"*" = Output Only
2/22/2012

Page 7 of 36

Record
Number
P11

Output

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

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

Acreage
P11
Max

Field Name
WA Number

Data Type Length
Character

Format

BUS
Key Req?

Rules
WA Number must be valid; edit with the ICE
Written Agreement Table.
WA Number can not be changed after the Fund
Designation Cutoff Date.
WA Number must contain only numeric
characters.
WA Number must not equal "000000000".

9

WA Number must be empty when the
Commodity Price Processing Code equals "M" and
Contract Liability Record Flag is empty.

P11

P11

29

30

WA Land ID

Sub County Code

Numeric

3

Character

8

999

WA Land ID must be empty when the Commodity
Price Processing Code equals "M" and Contract
Liability Record Flag is empty.
WA Land ID must be empty when Contract
Liability Record Flag equals Yes, "Y".
Sub County Code is required when Insurance Plan
Code equals Rainfall Index, "13" or Vegetation
Index, "14".
Sub County Code must be valid; edit with Sub
County Rate ADM, "A01050", otherwise empty.
Sub County Code must be empty when Non
Premium Acreage Code equals "C".
Sub County Code must be valid when the
Insurance Plan Code equals Rainfall Index, "13" or
Vegetation Index, "14" and the Non Premium
Acreage Code is greater than zero; edit with Area
Risk Rate ADM, "A01005", otherwise empty.

"*" = Output Only
2/22/2012

P11

31

Measurement Service Code

Character

1

P11

32

Insurance Option Code List

Character

29

Page 8 of 36

Measurement Service Code must be valid edit
with the Measurement Service ICE, "D00093",
otherwise empty.
Insurance Option Code List must contain only
unique delimited values.

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Insurance Option Code List must be valid for each
delimited value; edit with Option Rate ADM,
"A01060".
Insurance Option Code List must not contain "PF"
when the Commodity Code equals Onions,
"0013".
Insurance Option Code List must not equal "BE"
when the Sub County Code is High Risk; edit with
the Sub County ADM, "A00045".
Insurance Option Code List must not equal "PT"
when the Commodity Code equals Onions,
"0013".
Insurance Option Code List must be valid when
the High Risk Flag equals "Y", the Sub County
Code is not empty, the Insurance Option Code List
contains "BE" and the Insurance Plan Code equals
Yield Protection, "01", Revenue Protection, "02"
or Revenue Protection with Harvest Price
Exclusion. "03"; edit with the Sub county Rate
ADM, "A01050".
Insurance Option Code List cannot equal Biotech
Endorsement, "BE" when the Sub County Code is
High Risk.
Insurance Option Code List must contain only
"MA" or "MB" for Malting Barley.
Insurance Option Code List must equal
Cottonseed Endorsement, "SE" on the Acreage,
"P11" Cottonseed records when Insurance Option
Code List on the corresponding Insurance in
Force, "P14" contains Cottonseed Endorsement,
"SE".
Insurance Option Code List must be empty when
Contract Liability Record Flag equals No, "N".

"*" = Output Only
2/22/2012

Page 9 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
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.
Insurance Option Code List must contain "YA"
when the corresponding previously accepted
Yield, "P15" record contains the "YA" option and
the Yield Limitation Code equals "09" or "12".
Insurance Option Code List must contain "YA"
when the corresponding Yield, "P15" record in
this batch contains the "YA" option and the Yield
Limitation Code equals "09" or "12".

P11

33

Insured Acreage Signature Date

Date

8

CCYYMMDD

Y

Insured Acreage Signature Date must not be less
than the Reinsurance Year minus 1 or greater
than the submission date.
Insured Acreage Signature Date is required when
Non Premium Acreage Code is empty.
Insured Acreage Signature Date is greater than or
equal to the Contract Change Date and less than
or equal to the Batch Received Date.
Insured Acreage Signature Date must be empty
when the Contract Liability Record Flag equals
Yes, "Y" or Reported Pounds is greater than zero
and Commodity Code equals Peanuts, "0075".

P11

"*" = Output Only
2/22/2012

34

Agent Acreage Signature Date

Date

8

CCYYMMDD

Page 10 of 36

Y

Agent Acreage Signature Date must not be less
than the Reinsurance Year minus 1 or greater
than the submission date.

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Agent Acreage Signature Date is Required when
Non Premium Acreage Code is empty or Non
Premium Acreage Code equals "U" and the
Contract Liability Record Flag is empty.
Agent Acreage Signature Date must be empty
when the Contract Liability Record Flag equals
Yes, "Y".
Agent Acreage Signature Date must be greater
than 7/1/2010 and less than Batch Received Date.

P11

35

Reported Tree Count

Numeric

10

9999999999

Agent Acreage Signature Date must be less than
Inactive Date from the Agent, "P55" record when
the Inactive Date exists.
Reported Tree Count is required and must equal
the estimated number of trees when the
Insurance Plan Code equal Tree Based Dollar
Amount of Insurance, "40" or Pecan Revenue,
"41"; otherwise empty.
Reported Tree Count must be greater than 0
when Non Premium Acreage Code equals 'U' and
((Insurance Plan Code equals Tree Based Dollar
Amount of Insurance, "40" or Pecan Revenue,
"41".
Reported Tree Count must be less than or equal
to the Base Policy's Reported Tree Count when
the Insurance Option Code List contains "OX" or
"CV".

P11

36

Reported Pounds

Numeric

10

9999999999

Reported Pounds must equal the number of
contracted pounds for Commodity Code Peanuts,
"0075" by Contract Price.
Reported Pounds when greater than zero for
Commodity Code Peanuts, "0075" requires
Contract Price to be greater than zero.

"*" = Output Only
2/22/2012

Page 11 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Reported Pounds must equal the number of
pounds (Apportioned Landings) for Commodity
Code Oysters, "0115", otherwise empty.
Reported Pounds must be empty when the
Commodity Code does not equal Peanuts, "0075"
or Oysters, "0115" or the Contract Liability Record
Flag equals No, "N".

P11

37

AIP Total Premium Amount

Numeric

10

9999999999

Y

AIP Total Premium Amount must equal the RMA
calculated Total Premium Amount when this
record is not a Non Premium Acreage record.
When AIP AIP Total Premium Amount is less than
$1.00, round to $1.00.
AIP Total Premium Amount must be submitted on
both the Cotton Lint and Cottonseed records.
AIP Total Premium Amount must be empty when
the Contract Liability Record Flag equals No, "N"
and this is not a Non Premium Acreage record.

P11

38

AIP Liability Amount

Numeric

10

9999999999

AIP Liability Amount must equal the RMA
calculated Liability Amount.
AIP Liability Amount must be submitted on both
the Cotton Lint and Cottonseed records.
AIP Liability Amount must be empty when the
Contract Liability Record Flag equals No, "N" and
this is not a Non Premium acreage record.
AIP Liability Amount must equal LiabilityAmount
when Non Premium Acreage Code is empty.

P11

"*" = Output Only
2/22/2012

39

AIP Subsidy Amount

Numeric

10

9999999999

Page 12 of 36

AIP Subsidy Amount must equal RMA calculated
Subsidy Amount. When AIP Subsidy Amount is
less than $1.00, round to $1.00.

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
AIP Subsidy Amount must be submitted on both
the Cotton Lint and Cottonseed records.
AIP Subsidy Amount must be empty when the
Contract Liability Record Flag equals No, "N" and
the Non Premium Acreage Code is empty.
AIP Subsidy Amount must equal SubsidyAmount
when Non Premium Acreage Code is empty.

P11
P11

40
41

Additional Subsidy Flag
State Private Subsidy Flag

Character
Character

1
1

P11

42

Guarantee Adjustment Type Code

Character

1

Reserved.
Reserved.
Guarantee Adjustment Type Code must be valid;
edit with the Guarantee Adjustment Type ICE,
"D00051".
Guarantee Adjustment Type Code must be empty
when Commodity Code equals Pumpkins, "0147".
Guarantee Adjustment Type Code equal to "D" is
only valid when the Commodity Code equals
Citrus I, "0245", Citrus II, "0246", Citrus III,
"0247", Citrus IV, "0248", Citrus V, "0249", Citrus
VI, "0250", Citrus VII, "0251" or Citrus VIII,
"0252"."
Guarantee Adjustment Type Code must not equal
First Year thinning for Pecans, "F" or Amount of
Insurance Reduction for Fixed Dollar Citrus (0215)
in California, "C" when Insurance Plan Code
equals Dollar Amount of Insurance, "50".
Guarantee Adjustment Type Code must be valid;
edit with the Guarantee Adjustment Type
Insurance Plan ICE, "D00072"
Guarantee Adjustment Type Code must not equal
one of the following values: Late Planting, "L" or
Maximum Late Planted Reduction, "M" when
Insurance Option Code List contains 'WO' and
Commodity Code equals Wheat, "0011" or
Barley, "0091".

"*" = Output Only
2/22/2012

Page 13 of 36

Record
Number

P11

Output

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

43

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

Acreage
P11
Max

Field Name

Guarantee Adjustment Qualifying
Commodity Code

Data Type Length

Character

Format

BUS
Key Req?

Rules
Guarantee Adjustment Qualifying Commodity
Code must equal the Commodity Code for the
qualifying commodity when the Guarantee
Adjustment Type Code equals Company verified
eligible PP acres, "E", otherwise empty.

4

Guarantee Adjustment Qualifying Commodity
Code must be valid; edit with the Guarantee
Adjustment ADM, "A00420".

P11

P11

P11

44

45

46

Guarantee Adjustment Qualifying Basic
Unit Number

Guarantee Adjustment Qualifying
Optional Unit Number

Approved Yield

Character

Character

Numeric

4

Guarantee Adjustment Qualifying Basic Unit
Number equals the qualifying Basic Unit Number
associated with the Producer's acreage when the
Unit Structure Code equals Basic Units, "BU".

4

Guarantee Adjustment Qualifying Optional Unit
Number equals the qualifying Optional Unit
Number associated with the Producer's acreage
when the Unit Structure Code equals Optional
Units, "OU", "UA" or "UD".

11

Approved Yield must equal reduced Approved
Yield when Yield Limitation Code equal Approved
Yield Reduced Inconsistent Approved Yields, "10"
or Approved Yield Reduced Different Production
Methods, "11".

99999999.99

Y

Approved Yield must equal the approved
revenue per acre (in whole dollars) calculated
from the Annual Yield when the Insurance Plan
Code equals Actual Revenue History, "47".
Approved Yield must equal the Average Landing
when Commodity Code equals Oysters, "0115"
and Insurance Plan Code equals Area Yield
Protection, "04".
Approved Yield must be in whole dollars when
Commodity Code equals Beans Dry "0047" and
Type Code equals Contract, "62".

"*" = Output Only
2/22/2012

Page 14 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Approved Yield must be in whole dollars when
Commodity Code equals Peas Dry, "0067" and
Type Code equals Spring Contract, "98".
Approved Yield must be in whole dollars when
Commodity Code equals Pecans, "0020".
Approved Yield when reporting barrels or tons
must be submitted in the 9999999.9 format.
Approved Yield must be a whole number
between 1 and 999999999 when the Unit of
Measure Abbreviation is not "BBL" (Barrels) and
not "TON" (Tons).
Approved Yield must have one significant digit to
the right of the decimal point and be between 0.1
and 9999 when Unit of Measure Abbreviation is
"BBL" (Barrels) or "TON" (Tons).
Approved Yield must equal the Approved Yield
from the corresponding Yield, "P15" record in the
same batch when the associated Yield, "P15"
record was submitted in the same batch and the
Commodity Code does not equal Cotton, "0021",
ELS Cotton, "0022", Dry Beans, "0047" or Dry
Peas, "0067" and Type Code does not equal "062"
or "098".
Approved Yield must equal the Approved Yield on
the corresponding Yield, "P15" record /Contract
Price when the Commodity Code equals, Dry
Beans, "0047" and Type Code equals "062" or
Commodity Code equals Dry Peas, "0067" and
Type Code equals "098".

"*" = Output Only
2/22/2012

Page 15 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Approved Yield must equal the Approved Yield on
the corresponding Yield, "P15" record * Yield
Conversion Factor when the Commodity Code
equals Cotton, "0021" or ELS Cotton, "0022" and
the Skip Row Code is not empty.
Approved Yield must be empty when the
Insurance Option Code List on the Acreage, "P11",
Cottonseed record contains Cottonseed
Endorsement, "SE".
Approved Yield must be empty when the Contract
Liability Record Flag equals Yes, "Y".

P11

47

Insured Share Percent

Numeric

5

Insured Share Percent must be greater than zero
and less than or equal to "1.000".

9.999

Insured Share Percent must be less than "1.0"
when the Uninsurable SBI Flag equals “Y” on the
Policy Producer, “P10” record.
Insured Share Percent must be empty when the
Insurance Option Code List on the Acreage, "P11",
Cottonseed record contains Cottonseed
Endorsement, "SE".
Insured Share Percent is required when Contract
Liability Record Flag does not equal Yes, "Y".
Insured Share Percent must be empty when the
Contract Liability Record Flag equals Yes, "Y".

P11

48

Modified Acreage Code

Character

2

Y

Insured Share Percent must have no more than 1
number on the left of the decimal point and 3
numbers after the decimal point, in the format of
9.999.
Modified Acreage Code must be valid, edit with
the Modified Acreage ICE, "D00052".
Modified Acreage Code must be empty when the
Contract Liability Record Flag equals No, "N".

"*" = Output Only
2/22/2012

Page 16 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Modified Acreage Code must equal "00" when the
Non Premium Acreage Code equals "C" or "I".

P11

49

Price Election Amount

Numeric

9

9999.9999

Y

Price Election Amount is required when the
Insurance Option Code List contains Malting
Barley Option A, "MA", Malting Barley Option B,
"MB" or Cottonseed Endorsement, "SE"; edit with
the Price ADM, "A00810", otherwise empty.
Price Election Amount is equal to Established
Price, Additional Price, or Projected Price when
the Option Code equals "SE"; otherwise, Price
Election Amount equals the appropriate price
times the Price Election Percent.

P11

50

Contract Price

Numeric

9

9999.9999

Contract Price must be valid; edit with the ADM,
"A00810" when the Contract Liability Flag equals
Yes, “Y” or is blank.
Contract Price must be empty for Malting Barley
or when Contract Liability Record Flag equals No,
"N" or when Commodity Code equals Peanuts,
"0075" and Commodity Price Processing Code is
empty.
Contract Price must be empty when the Contract
Liability Record Flag equals No, "N".
Contract Price must be equal to or less than the
Maximum Contract Amount; edit with the
Contract Price Limit ICE, "D00109" when amount
is greater than Maximum Contract Amount on
ADM, "A00810"; otherwise the associated
Acreage, "P11" will not be processed.

"*" = Output Only
2/22/2012

Page 17 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Contract Price must equal the Contract Price on
other policies containing the same AIP Policy
Producer Key and AIP Insurance in Force Key
when the Commodity Code equals Grapes, "0053"
and Location State Code equals Arizona, "04" or
California, "06".

P11

51

Experience Factor

Numeric

5

Experience Factor must be valid for the
Commodity Code/Insurance Plan Code/Location
State Code/Location County Code.

9.999

Experience Factor must be empty when the
Commodity Code equals Peanuts, "0075" and
Commodity Price Processing Code equals "M" and
the Contract Liability Record Flag is empty.
Experience Factor must be empty when Contract
Liability Record Flag equals No, "N".

P11

"*" = Output Only
2/22/2012

52

Reported Acreage

Numeric

9

Page 18 of 36

999999.99

Y

Reported Acreage is required except when
Commodity Code equals "Tangerine Trees,
"0193", Orange Trees, "0207", Grapefruit Trees,
"0208", Hawaii Tropical Trees, "0265 thru 0267",
and Oysters, "0115".
Reported Acreage must equal the net planted
acre after applying the Skip Row planting pattern
Factor for Skip Row Cotton, "0021" and ELS
Cotton, "0022".
Reported Acreage must equal the sum of all
Reported Acreage from the Land, "P27" records
corresponding to this policy.

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Reported Acreage can have no more than two
significant digit greater than zero to the right of
the decimal point when Commodity Code equals
Flue Cured Tobacco, "0229", Fire Cured Tobacco,
"0230", Burley Tobacco, "0231", Maryland
Tobacco, "0232", Dark Air Tobacco, "0233", Cigar
Filler Tobacco, "0234", Cigar Binder Tobacco,
"0235" and Cigar Wrapper Tobacco, "0236". For
all other Commodities, Reported Acreage can
have no more than one significant digit greater
than zero to the right of the decimal.
Reported Acreage must be empty when the
Insurance Option Code List on the Acreage, "P11",
Cottonseed record contains Cottonseed
Endorsement, "SE".
Reported Acreage must be empty when the
Contract Liability Record Flag equals Yes, "Y".

P11

53

Reported Tons

Numeric

9

999999.99

Y

Reported Tons must equal the number of tons, to
the nearest hundredth for Commodity Code equal
Raisins, "0037".

P11

54

Reported Colonies

Numeric

9

999999.99

Y

Reported Colonies must equal the number of
colonies, for Commodity Code equal Apiculture,
"1191"; otherwise empty.
Reported Colonies sum must be greater than or
equal to the Minimum Acre Percent and less than
or equal to the Maximum Acre Percent; edit with
the AdmPrice, A00810", when Commodity Code
equals Apiculture, "1191", otherwise empty."

P11

"*" = Output Only
2/22/2012

55

Section Count

Numeric

2

Page 19 of 36

99

Section Count must equal the number of Sections
for the entire unit when Unit Structure
Code equals Enterprise Unit, "EU" or Whole Farm,
"WU", otherwise empty."

Record
Number
P11

Output

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

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

Acreage
P11
Max

Field Name
Planted Date

Data Type Length
Date

8

Format
CCYYMMDD

BUS
Key Req?

Rules
Planted Date must be a valid date for when the
Commodity was planted.
Planted Date must not be greater than the Batch
Received Date.
Planted Date must be greater than the Final
Planting Date when ((Seed Cycle Code equals 'F'
and Commodity Code equals Wheat, "0011"') or
(Commodity Code equals ELS Cotton, "0022"'))
and Guarantee Adjustment Type Code equals
'P'and the Non Premium Acrage Code does not
equal 'U'.
Planted Date must be less than or equal to the
Extended Final Planting Date when the Guarantee
Adjustment Type Code is empty and Non
Premium Acreage Code does not equal 'U'.
Planted Date must be greater than or equal to the
Final Planting Date from the ADM, "A00200" + 26
when Guarantee Adjustment Type Code is empty.
Planted Date must be greater than or equal to the
Final Planting Date from the ADM, "A00200" + 26
when ((Seed Cycle Code is not equal to 'F' or
Commodity Code is not equal to Wheat, "0011")
and (Commodity Code is not equal to ELS Cotton,
"0022")) and Guarantee Adjustment Type Code is
'P' and Non Premium Acreage does not equal 'U'.
Planted Date must equal zeros when the
commodity has not been planted or the
Commodity Code requires zeros for Planted Date;
edit with Planted Date Exclusion ICE, "D00055".
Planted Date must be empty when the Contract
Liability Record Flag equals Yes, "Y".

"*" = Output Only
2/22/2012

Page 20 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Planted Date must be empty when the Guarantee
Adjustment Type Code equals "E" or "P" and the
Non Premium Acrage Code does not equal "U".

P11

57

Skip Row Code

Character

3

Skip Row Code must equal the applicable Skip
Row Code for the planting pattern when
Commodity Code equals Cotton, "0021" or Corn,
"0041"; edit with the Skip Row ICE, "D00039",
otherwise empty.
Skip Row Code must be empty when Commodity
Code equals: Cotton, "0021" and Practice Code
does not equal a valid skip row code (063, 073,
083, 729, 730, 731, 732, 733, 734).

P11

58

Skip Row Width

Numeric

2

Skip Row Width is the actual row width in the skiprow planting pattern and not the width of the
skipped area in the planting pattern and must
equal the applicable Skip Row Width for the
planting pattern when Commodity Code equals
Cotton, "0021" or Corn, "0041" ; edit with the Skip
Row ICE, "D00039", otherwise empty.

P11

59

Premium Multiple Cropping Code

Character

2

Premium Multiple Cropping Code must be empty
for original first crop.
Premium Multiple Cropping Code must be valid;
edit with the Multiple Cropping ICE, "D00063".
Premium Multiple Cropping Code must be empty
when the Commodity Code equals Peanuts,
"0075", the Commodity Price Processing Code
equals "M" and the Contract Liability Record Flag
is empty.
Premium Multiple Cropping Code must be empty
when Contract Liability Record Flag equals No,
"N".

P11

"*" = Output Only
2/22/2012

60

Commodity Cropping Status Code

Character

1

Page 21 of 36

Commodity Cropping Status Code must be valid;
edit with the Commodity Status ICE, "D00117".

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules

P11

61

Commodity Planting Status Code

Character

1

Commodity Planting Status Code must be valid;
edit with the Commodity Planting Status ICE,
"D00118".

P11

62

Commodity Multiple Planting Status Code Character

1

Commodity Multiple Planting Code must equal
"M" when there are multiple plantings on the
same field, otherwise empty.

5

Yield Conversion Factor must be valid; edit with
the Skip Row Yield Conversion ICE, "D00064",
when Commodity Code equals Cotton, "0021" or
ELS Cotton, "0022".

P11

63

Yield Conversion Factor

Numeric

9.999

Yield Conversion Factor will be set by PASS to
Approved Yield divided by 3000, capped at 2.000
when Commodity Code equals Macadamia Trees,
"0024" and Approved Yield is greater than 3000.
Yield Conversion Factor is the factor used to
reduce the production guarantee with the 125%
acreage limitation when the Commodity Code
equals Cabbage, "0072" (except processing),
Onions, "0013" (when provided by Special
Provisions), Potatoes "0084" (Certified Seed),
Silage Sorghum, "0059" and Hawaii Tropical Fruit,
"0265", "0266" and "0267".
Yield Conversion Factor is the factor used to
reduce the Total Guarantee with the 125% tree
limitation for Hawaii Tropical Trees, Commodity
Codes, "0265", "0266" and "0267".
Yield Conversion Factor equals the expected
revenue factor when Insurance Plan Code equals
Actual Revenue History (ARH), "47".
Yield Conversion Factor must be greater than zero
when submitted.

"*" = Output Only
2/22/2012

Page 22 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Yield Conversion Factor equals the agent provided
overplanted factor when the Commodity Code
equals Sweet Potatoes, “0156” and the
overplanted acres are being used to reduce the
Acre Guarantee Quantity. When no overplanting
factor applies the 1.000 Yield Conversion Factor
will be used.
Yield Conversion Factor must be empty when the
Contract Liability Record Flag equals Yes, "Y".

P11

P11

P11

64

65

66

Surcharge Applied Flag

Seed Company Code

CEO Coverage Level Percent

Character

Character

Numeric

Surcharge Applied Flag must equal Yes, "Y" and a
5% premium surcharge is applied when APF Yield
was cupped or floored, for non-yield-span
commodities, or cupped for yield-span
commodities.
Surcharge Applied Flag must equal No, "N" when
there is no premium surcharge.

1

3

Seed Company Code must be valid when
Commodity Code equal, Hybrid Sorghum Seed,
"0050" or Hybrid Corn Seed, "0062", edit with the
Seed Company ICE, "D00057", otherwise empty.

6

CEO Coverage Level Percent must be greater than
Coverage Level Percent when the Commodity
Code equals Tangerine Trees, "0193"; Orange
Trees, "0207"; Grapefruit Trees, "0208";
otherwise empty.

9.9999

CEO Coverage Level Percent is required when
Insurance Option Code Lists contains Coverage
Enhancement Option, "CE", otherwise empty.
CEO Coverage Level Percent must be empty when
Coverage Type Code equal Catastrophic, "C".

"*" = Output Only
2/22/2012

Page 23 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
CEO Coverage Level Percent must be valid when
the Coverage Type Code equals Actual, "A"; edit
with the Coverage Level ICE, "D00024".

P11

67

Settlement Flag

Character

1

Settlement Flag must equal Yes, "Y" if there is a
Settlement or Finding, otherwise empty.
Settlement Flag must be empty when the
Contract Liability Record Flag equals Yes, "Y".

P11

68

Private Policy Code

Character

3

Private Policy Code must be valid, edit with
Private Policy Code ICE, "D00059".
Private Policy Code must be empty when the
Contract Liability Record Flag equals Yes, "Y".

P11

69

Warehouse Code

Character

5

Warehouse Code is required when Contract Price
is greater than 0, Commodity Code equals
Pumpkins, "0147" and Non Premium Acreage
Code is empty.
Warehouse Code is Required when Commodity
Code equals Peanuts, "0075" and Commodity
Price Processing Code equals "S" or "M" or when
Commodity Code equals Pumpkins, "0147", the
Contract Price is greater than zero, the Contract
Liability Record Flag is empty or equals Yes, "Y"
and the Non Premium Acreage Code is empty.
Warehouse Code must be empty when the
Contract Liability Record Flag equals No, "N".

P11

"*" = Output Only
2/22/2012

70

Commodity Price Processing Code

Character

1

Page 24 of 36

Commodity Price Processing Code must be equal
to Multiple Prices, "M", Single Price, "S", or empty
when Commodity Code equals Peanuts, "0075";
otherwise, empty.
Commodity Price Processing Code may not be
empty when all records for the same policy,
commodity and Basic/Optional Unit Number are
not empty.

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Commodity Price Processing Code may not equal
Single Price, "S" when all records for the same
policy, commodity and Basic/Optional Unit
Number are not Single Price, "S" .
Commodity Price Processing Code may not equal
Multiple Prices, "M" when all records for the
same policy, commodity and Basic/Optional Unit
Number are not Multiple Prices, "M".
Commodity Price Processing Code equal to Single
Price, "S" with Commodity Code equal to Peanuts,
"0075" indicates there must be only one Contract
Price.
Commodity Price Processing Code equal to
Multiple Prices, "M" with Commodity Code equal
Peanuts, "0075" and Contract Liability Record Flag
existing, at least one Contract Price and one
Established Price are required.

"*" = Output Only
2/22/2012

P11

71

Prevented Planting Commodity Code

Character

4

P11

72

Prevented Planting Processing Code

Character

1

P11

73

Acreage Group Key

Character

15

Page 25 of 36

Prevented Planting Commodity Code must equal
the Commodity Code for the acres used to qualify
for a prevented planting payment.
Prevented Planting Processing Code must be
valid; edit with the Prevented Planting Processing
ICE, "D00038".
Acreage Group Key is required and must be the
same number for matching Cottonseed and
Cotton Lint records when the Insurance Option
Code List on the corresponding Insurance in
Force, "P14" record contains Cottonseed
Endorsement, "SE".
Acreage Group Key must be empty for a nonCottonseed record if there is no corresponding
Cottonseed record.

Record
Number
P11

Output

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

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

Acreage
P11
Max

Field Name
Adjusted Total Guarantee Amount

Data Type Length
Numeric

12

Format
999999999.99

BUS
Key Req?

Rules
Adjusted Total Guarantee Amount must be empty
when Commodity Code does not equal Peanuts,
"0075".
Adjusted Total Guarantee Amount must be empty
when Commodity Code equals Peanuts, "0075"
and the Contract Liability Record Flag is empty.
Adjusted Total Guarantee Amount is Required
when Commodity Code equals Peanuts, "0075"
and the Contract Liability Record Flag equals Yes,
"Y" or No, "N".

P11

75

Guarantee Adjustment Factor

Numeric

5

9.999

Guarantee Adjustment Factor is required when
Guarantee Adjustment Type Code equals
Insurance reduction for Fixed Dollar FL Citrus, "D".
Guarantee Adjustment Factor must be empty
when Guarantee Adjustment Type Code is not
equal to Insurance reduction for Fixed Dollar FL
Citrus, "D" or the Guarantee Adjustment Type
Code is empty.
Guarantee Adjustment Factor must be valid, edit
with the Guarantee Adjustment ICE, "D00068".
Guarantee Adjustment Factor will equal the
Guarantee Adjustment factor calculated by Pass.
Guarantee Adjustment Factor will equal Fixed
Guarantee Adjustment Factor when the
Guarantee Adjustment Type Code equals
Maximum Late Planted Reduction, "M",
Prevented Planting, "P", Eligible PP acres from
another unit "E", or First Year Thinning for Pecans,
"F"; edit with the Guarantee Adjustment ICE,
"D00068".
Guarantee Adjustment Factor must be between
"0.001" and "1" when Guarantee Adjustment
Factor exists.

"*" = Output Only
2/22/2012

Page 26 of 36

Record
Number

Output

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

P11

"*" = Output Only
2/22/2012

Field
Number

76

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

Acreage
P11
Max

Field Name

StandPercent

Data Type Length

Numeric

Format

4

9.99

BUS
Key Req?

Rules
Stand Percent must be empty when Commodity
Code is not one of the following values: '0024',
'0240', '0241', '0242', '0243', '0244'.
Stand Percent must be Numeric when Stand
Percent exists.
Stand Percent must have no more than 1 number
on the left of the decimal point and 2 numbers
after the decimal point, in the format of 9.99
when Stand Percent exists.
Stand Percent must be between 0.01 and 1 when
Stand Percent exists.
CAT Loss Adjustment Expense Amount equals 6%
of the Total Premium paid to the AIP on CAT
policies.
Proration Percent applies only to Florida fruit
trees and is determined by the signature date
plus 45 days.
Valid Commodity Type Code is populated from
the Valid Commodity Type Code in the Insurance
Offer ADM, "A00030".

P11

*

77

CAT Loss Adjustment Expense Amount

Numeric

13

9999999999.99

P11

*

78

Proration Percent

Numeric

4

9.99

P11

*

79

Valid Commodity Type Code

Character

3

P11

*

80

Valid Class Code

Character

3

Valid Class Code is populated from the Class Code
in the Insurance Offer ADM, "A00030".

P11

*

81

Valid Sub Class Code

Character

3

Valid Sub Class Code is populated from the Sub
Class Code in the Insurance Offer ADM, "A00030".

P11

*

82

Valid Intended Use Code

Character

3

P11

*

83

Valid Irrigation Practice Code

Character

3

P11

*

84

Valid Cropping Practice Code

Character

3

Page 27 of 36

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

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

Acreage
P11

Record
Number

Output

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

P11

*

85

Valid Organic Practice Code

Character

3

Valid Organic Practice Code is populated from
ADM Insurance Offer Organic Practice Code

P11

*

86

Valid Interval Code

Character

3

Valid Interval Code is populated from the Interval
Code in the Insurance Offer ADM, "A00030".

P11

*

87

Seed Cycle Code

Character

1

Seed Cycle Code specifies the cycle in which the
crop was planted.
Residual Factor is used to determine Total
Premium for Insurance Plan Codes, Yield
Protection, "01", Revenue Protection, "02",
Revenue Protection with Harvest Price Exclusion,
"03" and Actual Production History, "90".

Max

Field Name

Data Type Length

Format

P11

*

88

Residual Factor

Numeric

5

9.999

P11

*

89

Unit Liability Amount

Numeric

10

9999999999

P11

*

90

Subsidy Amount

Numeric

10

9999999999

P11

*

91

Liability Amount

Numeric

10

9999999999

P11

*

92

Total Premium Amount

Numeric

10

9999999999

BUS
Key Req?

Y

Y

Rules

Unit Liability Amount is the sum of the Liability
reported on the unit by Seed Cycle Code.
Subsidy Amount is the dollar amount of the
Subsidy for the Commodity Code and the
Insurance Plan Code. When Subsidy Amount is
less than $1.00, round to $1.00.
Liability Amount is the sum of the Total
Guarantee times the Price Election Amount times
the Insured Share Percent.
Total Premium Amount is the premium amount
calculated for the Commodity Code and Insurance
Plan Code.
Total Premium Amount is based on the CEO
Coverage Level, when elected for Commodity
Code equal Tangerine Trees, "0193"; Orange
Trees, "0207" or Grapefruit Trees, "0208".
Total Premium Amount must be rounded to $1.00
when any Total Premium is less than $1.00.

"*" = Output Only
2/22/2012

Page 28 of 36

Record
Number

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Total Premium Amount must be greater than zero
when Commodity Code equal Peanuts, "0075"
and the Base Premium Rate is greater than zero.

P11

"*" = Output Only
2/22/2012

*

93

Producer Premium Amount

Numeric

10

9999999999

Producer Premium Amount equals the Total
Premium Amount minus the Subsidy Amount.
When Producer Premium Amount is less than
$1.00 and Coverage Type Code not equal to , “C”,
round to $1.00.
Base Premium Rate equals the lower of Current
Year's Continuous Rating Base Premium Rate,
Capped Adjusted Yield Span Base Premium Rate,
Capped Prior Year's Adjusted Continuous Rating
Base Premium Rate or ".999".

P11

*

94

Base Premium Rate

Numeric

15

999999.99999999

P11

*

95

Preliminary Base Rate

Numeric

15

999999.99999999

P11

*

96

Acre Loaded Premium Amount

Numeric

9

9999.9999

P11
P11

*
*

97
98

Additional Subsidy Amount
State Private Subsidy Amount

Numeric
Numeric

10
10

9999999999
9999999999

P11

*

99

A&O Expense Subsidy Amount

Numeric

13

9999999999.99

P11

*

100

Total Guarantee Amount

Numeric

12

999999999.99

P11

*

101

Unit Structure Discount Factor

Numeric

10

9.99999999

Page 29 of 36

Y

Preliminary Base rate is the value used to
determine the reported Base Premium Rate.
Acre Loaded Premium Amount is the result of the
Base Premium Rate times the Optional Coverage
Factor times Dollar Amount of Insurance times
Residual Factor.
Reserved.
Reserved.
A & O Expense Subsidy Amount must be valid.
Edit with the A&O Expense Subsidy ICE, "D00097".
Total Guarantee Amount must be valid for the
Commodity Code/Insurance Plan Code; edit
according to Total Guarantee Calculations. See
P11 Calculation Exhibit (11-11)
Unit Structure Discount Factor is the value
returned from the Unit Discount ADM, "A01090".

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

Acreage
P11

Record
Number

Output

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

P11

*

102

Dollar Amount of Insurance

Numeric

11

99999999.99

P11

*

103

Acre Guarantee Quantity

Numeric

11

99999999.99

P11

*

104

Initial Accepted Batch Number

Numeric

4

9999

P11

*

105

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.

P11

*

106

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

P11

*

107

Batch Number

Numeric

4

9999

P11

*

108

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.

P11

*

109

Process Result Code

Character

1

Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules
Dollar Amount of Insurance is the selected dollar
amount of protection per acre including coverage
level and/or price election factors.
Acre Guarantee Quantity is the adjusted
guarantee for late or prevented planting.
Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.

Process Result Code equals the final result code
as determined by PASS processing, refer to the
Process Result ICE, "D00002" for values.

Record Level Rules

"*" = Output Only
2/22/2012

1

When the COI Questionnaire Completion Date on
the Insurance Agent, "P55" record is empty, the
associated Acreage, "P11" and Inventory Value,
"P13" records will be rejected.

2

The Acreage, "P11" record will not be processed
when processing has been supspended for this

3

The Acreage, "P11" record must be submitted
between 7/1/2011 and 2/12/2015.

Page 30 of 36

Record
Number

"*" = Output Only
2/22/2012

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules

4

The preceeding Insurance In Force, "P14" record
in this batch must be accepted for the Acreage,
"P11" record to be accepted.

5

“The child record Land, "P27" must be accepted in
the batch for the Acreage, "P11" record to be
accepted except when the Acreage, “P11” record
is a Non-premium Acreage record.”

6

Basic Unit Number, Optional Unit Number, Type
Code and Practice Code must match the values on
the corresponding P15 record submitted in this
batch.

7

When determining the Guarantee Adjustment,
PASS will reference the SPOI Guarantee
Adjustment YTD ICE, “D00268” first. If a match for
the submitted data is found in the D00268 ICE
data file, that Guarantee Adjustment will be
applied to the submitted data. If no match for the
submitted data is found in the SPOI ICE file, PASS
will look at the PASS Guarantee Adjustment YTD
ICE, “D00068” for a Guarantee Adjustment that
matches the submitted data. When a match is
located that Guarantee Adjustment amount will
be used.

8

Unable to perform the Combo Premium
Corporate Calculation, because one or more of
the following fields has failed validation:
Commodity Year, Coverage Level Percent, Price
Election Percent, Price Election Amount, Reported
Acreage, Approved Yield, Rate Yield, Insured
Share Percent, Acreage Group Key or Unit
Structure Code.

Page 31 of 36

Record
Number

"*" = Output Only
2/22/2012

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules

9

Unable to perform the Group Protection Premium
Corporate Calculation, because one or more of
the following fields has failed validation:
Applicable Reported Value (Acreage, Pounds,
Tons or Colonies), Dollar Amount of Insurance,
Commodity Year or Insured Share Percent.

10

Unable to perform the Tree Based Dollar Amount
of Insurance Premium Corporate Calculation,
because one or more of the following fields has
failed validation: Commodity Year, Coverage Level
Percent, Insured Share Percent, CEO Coverage
Level Percent, Price Election Amount, Insured
Acreage Signature Date, Reported Tree Count or
Yield Conversion Factor.

11

Unable to perform the Pecan Revenue Premium
Corporate Calculation, because one or more of
the following fields has failed validation:
Commodity Year, Coverage Level Percent, Insured
Share Percent, Reference Commodity Year,
Applicable Reported Value (Pounds) or Dollar
Amount of Insurance.

12

Unable to perform the Actual Revenue History
Premium Corporate Calculation, because one or
more of the following fields has failed validation:
Commodity Year, Type Code, Price Election
Percent, Coverage Level Percent, Approved Yield,
Rate Yield, Applicable Reported Value (Acreage,
Pounds or Tons ) or Insured Share Percent.

Page 32 of 36

Record
Number

"*" = Output Only
2/22/2012

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules

13

Unable to perform the Dollar Amount of
Insurance Premium Corporate Calculation,
because one or more of the following fields has
failed validation: Experience Factor, Stand
Percent, Guarantee Adjustment Factor, Coverage
Level Percent, Dollar Amount of Insurance,
Commodity Year, Applicable Reported Value
(Acreage, Pounds or Tons) or Insured Share
Percent.

14

Unable to perform the Fixed Dollar Amount of
Insurance Premium Corporate Calculation,
because one or more of the following fields has
failed validation: Commodity Year, Insured Share
Percent, Coverage Level Percent, Guarantee
Adjustment Factor, Base Rate, Rate Differential
Factor, Subsidy Percent, Dollar Amount Of
Insurance, Price Election Percent or Applicable
Reported Value (Acreage, Pounds or Tons).

15

Unable to perform the Yield Based Dollar Amount
of Insurance Premium Corporate Calculation,
because one or more of the following fields has
failed validation: Commodity Year, Minimum
Payment Quantity, Coverage Level Percent,
Experience Factor, Price Election Amount,
Approved Yield, Applicable Reported Value
(Acreage, Pounds, Tons) or Insured Share Percent.

Page 33 of 36

Record
Number

"*" = Output Only
2/22/2012

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules

16

Unable to perform the APH Premium Corporate
Calculation, because one or more of the following
fields has failed validation: Approved Yield,
Commodity Year, Coverage Level Percent, Insured
Share Percent, Price Election Amount, Rate Yield,
Applicable Reported Value (Acreage, Pounds or
Tons), Acreage Group Key or Yield Conversion
Factor.

17

Unable to perform the WA Combo Premium
Corporate Calculation, because one or more of
the following fields has failed validation:
Coverage Level Percent, Unit Structure Code,
Reported Acreage, Insured Share Percent,
Approved Yield, Commodity Year or Price Election
Amount.

18

For Cottonseed records all fields must match the
corresponding Cotton Lint record with the
exception of AIP Acreage Key, Non Premium
Acreage Code, Insurance Option Codes List, AIP
Total Premium Amount, AIP Liability Amount, AIP
Subsidy Amount, Approved Yield, Insured Share
Percent, Price Election Amount and Reported
Acreage. Approved Yield, Insured Share Percent,
and Reported Acreage must be Null on the
Cottonseed records. For Cotton Lint excluded
from insurance with an "H" in the Non-Premium
Acreage Code, the non-premium acres are
excluded from the Unit Discount Factor
computation. The Price Election Percent for all
Cottonseed records is 1.00.

Page 34 of 36

Record
Number

"*" = Output Only
2/22/2012

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules

19

For Cottonseed records, there must be a
corresponding Cotton Lint record. The following
fields must match between the rows: Aip Policy
Producer Key, Aip Insurance In Force Key, Type
Code, Practice Code, Basic Unit Number, Optional
Unit Number, Acreage Group Key, Unit Structure
Code, Sub County Code, Guarantee Adjustment
Type Code, Premium Rate Surcharge Flag,
Multiple Cropping Code.

20

Sum (Reported Pounds) must equal Sum
(Unadjusted Total Guarantee Amount) when the
Commodity Price Processing Code is 'S'.

21

Sum (Reported Pounds) on Liability record must
equal to Sum (Unadjusted Total Guarantee
Amount) on Guarantee record when the
Commodity Price Processing Code is 'M'.

22

Sum (Reported Pounds) cannot exceed Sum (Total
Guarantee Amount for timely planted acreas)
when the Commodity Price Processing Code
equals "S".

23

Sum (Adjusted Total Guarantee Amount) on
Liability record must equal to Sum (Adjusted Total
Guarantee Amount) on Guarantee record when
the Commodity Price Processing Code is 'M'.

24

When Sub County equals "MMA" is submitted,
PASS cannot validate the rate. In order for PASS
to validate the rate, the Sub County Codes must
be submitted in the format of "AAA", "BBB".

Page 35 of 36

Record
Number

"*" = Output Only
2/22/2012

Output

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

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

Acreage
P11
Max

Field Name

Data Type Length

Format

BUS
Key Req?

Rules

25

When processing Acreage, "P11" records for
Speciality Type Commodities, multiple Insurance
In Force, "P14" record submission is allowed as
long as the Acreage, "P11" indicates it is a
Speciality Type Commodity, the exact Speciality
Type does not need to match on the Insurance In
Force, "P14" and the Acreage, "P11" records.

26

When the Insurance Option Code List contains
Malting Barley Option A, "MA", the Basic Unit
Number and Optional Unit Number must match
the values submitted on a corresponding
previously accepted, Yield, "P15" record or a
corresponding, Yield, "P15" record submitted in
this batch.

Page 36 of 36