P15 Yield History Record

P15 Yield History Record.pdf

Multiple Peril Crop Insurance

P15 Yield History Record

OMB: 0563-0053

Document [pdf]
Download: pdf | pdf
Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

P15

1

AIP Code

Character

2

P15
P15

2
3

Reinsurance Year
Record Type Code

Numeric
Character

4
6

P15

4

AIP Policy Producer Key

Character

P15

5

AIP Insurance In Force Key

P15

6

AIP Yield Key

P15

7

Basic Unit Number

P15

P15

"*" = Output Only
2/23/2012

8

9

Optional Unit Number

APH Procedural Exception Number

Format

BUS
Key Req?
Y

Y

Y

Y
Y

15

Y

Y

Character

15

Y

Y

Character

15

Character

4

Character

4

Character

3

Page 1 of 30

CCYY

Y

Y

Y

Y

Y

Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must equal "2012".
Record Type Code must equal "P15".
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 Yield Key must be unique within the AIP
Insurance In Force Key.
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”.
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”.
The APH Procedural Exception Number is a
unique three digit number used only when
reporting multiple “APH Databases” is allowed.

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

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

P15

10

APH Procedural Exception Code

Character

1

P15

11

Type Code

Character

3

Y

Y

P15

12

Practice Code

Character

3

Y

Y

"*" = Output Only
2/23/2012

Page 2 of 30

Type Code is required; edit with the Type ADM,
"A00540".
Type Code must be empty when Type Practice
Use Code equals Implemented, "I".
Practice Code is required; edit with the Practice
ADM, "A00510".
Practice Code must be empty when Type Practice
Use Code equals Implemented, "I".

Record
Number

P15

P15

P15

P15

Output

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

Field
Number

13

14

15

16

"*" = Output Only
2/23/2012

Field Name

Commodity Type Code

Class Code

Sub Class Code

Intended Use Code

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

Yield
P15

Data Type

Character

Character

Character

Character

Max
Length

Format

BUS
Key Req?

Rules

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.

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.

Page 3 of 30

Record
Number

P15

P15

P15

Output

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

Field
Number

17

18

19

"*" = Output Only
2/23/2012

Field Name

Irrigation Practice Code

Cropping Practice Code

Organic Practice Code

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

Yield
P15

Data Type

Character

Character

Character

Max
Length

Format

BUS
Key Req?

Rules

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.

Page 4 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

P15

20

Interval Code

Character

3

P15

21

WA Number

Character

9

"*" = Output Only
2/23/2012

Page 5 of 30

Format

BUS
Key Req?

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

Record
Number

P15

P15

Output

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

Field
Number

22

23

Field Name

Actual Yield Year Count

Perennial Set Out Year Month Number

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

Yield
P15

Data Type

Numeric

Character

Max
Length

2

6

Format

99

BUS
Key Req?

Rules
Actual Yield Year Count must equal the number of
reference Yield History, "P15A" records with
actual yields, (Yield Type = A) required to calculate
the variable T-Yield where Yield Type values on
the corresponding Yield History, "P15A" records
equal 65% T Yield, "S", 80% T Yield, "E", 90% T
Yield, "N" or Transitional T Yield, "T" (used for
Added Land with a P/T/V that is not an simple
average T Yield). Year values must be from one to
ten, otherwise empty. NOTE: PASS will validate
only where P15 and P15A records are available.
Perennial Set Out Year Month Number is required
for T Yield validation when the Leaf Year in the
ADM Yield and T Yield Table, "A01100" is
populated for the Location State Code/Location
County Code/Commodity Type Code, otherwise
empty.
Perennial Set Out Year Month Number when
required must equal the actual calendar month
and year the acreage was planted when the set
out month number is prior to July, "07".

"*" = Output Only
2/23/2012

Page 6 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Perennial Set Out Year Month Number when
required must equal the actual calendar month
and year plus one when the set out month
number is after June, "06".
Perennial Set Out Year Month Number must
represent a date later than January 1900. The first
four characters must be a valid year and the last 2
characters must be a valid month or "00".
Perennial Set Out Year Month Number is
Required for perennial commodities when Leaf
Year exists for the offer in the ADM Yield and
Tyield, "A01100" record and Yield Indicator Code
does not equal "W"."
Perennial Set Out Year Month Number must not
be within the current Reinsurance Year.
Perennial Set Out Year Month Number must be
less than Perennial Grafting Year Month Number
when the right 2 characters in Perennial Set Out
Year Month Number are not equal to "00" and
the right 2 characters in Perennial Grafting Year
Month Number are not equal to "00".

"*" = Output Only
2/23/2012

Page 7 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Perennial Set Out Year Month Number must not
have a month number equal to "00" when the
Yield Indicator Code does not equal "W".
Perennial Set Out Year Month Number equals
zeroes in the last two characters indicates the first
four characters must equal the Reinsurance Year.
Perennial Set Out Year Month Number or
Perennial Grafting Year Month Number
containing "00" in the last two characters
indicates the first 4 characters of the Perennial
Grafting Year Month Number must be greater
than or equal to the first 4 characters in Perennial
Set Out Year Month Number.
If Perennial Leaf Year Count is populated, either
Perennial Graft Year or Perennial Set Out Year
must be populated, or the Yield Indicator Code
must equal 'W'.

"*" = Output Only
2/23/2012

Page 8 of 30

Record
Number

P15

Output

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

Field
Number

24

Field Name

Perennial Leaf Year Count

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

Yield
P15

Data Type

Numeric

Max
Length

3

Format

999

BUS
Key Req?

Rules
Perennial Leaf Year Count is required for T Yield
validation when the Leaf Year in the ADM Yield
and T Yield Table, "A01100" is populated for the
Location State Code/Location County
Code/Commodity Type Code, otherwise empty.
Perennial Leaf Year Count must be valid when
Perennial Set Out Year Month Number or
Perennial Grafting Year Month Number contain a
value, otherwise empty.
Perennial Leaf Year Count when the Perennial
Commodity has a Commodity Year equal to the
current Reinsurance Year plus one (AZ, CA, & TX
Citrus & CA Avocados) equals the Commodity
Year minus the greater of Perennial Set Out Year
Month Number or the Perennial Grafting Year
Month Number when the appropriate Perennial
Set Out Year Month Number or perennial Grafting
Year Month Number is prior to July, month "07"
except when Commodity Type Code equals
Macadamia Nuts, "0023".

"*" = Output Only
2/23/2012

Page 9 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Perennial Leaf Year Count for Macadamia Nuts,
"0023" with a Commodity Year equal to the
Reinsurance Year plus one, equals the Commodity
Year minus the greater of Perennial Set Out Year
Month Number or the Perennial Grafting Year
Month Number minus two.
Perennial Leaf Year Count for all other Perennial
Commodities equals the Commodity Year minus
the year corresponding to the greater of the
Perennial Set Out Year Month Number or the
Grafting Year Month Number plus one, when the
appropriate Perennial Set Out Year Month
Number or Grafting Year Month Number is prior
to July, month "07".

"*" = Output Only
2/23/2012

Page 10 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Perennial Leaf Year Count for all other Perennial
Commodities equals the Commodity Year minus
the year corresponding to the greater of the
Perennial Set Out Year Month Number or the
Grafting Year Month Number, when the
appropriate Perennial Set Out Year Month
Number or Grafting Year Month Number is after
June, month "06".
Perennial Leaf Year Count for Commodity Code
Blueberries, "0012" when State Code equals
Mississippi, "28" equals the Commodity Year
minus the year corresponding to the greater of
the Perennial Set Out Year Month Number or the
Grafting Year Month Number plus one, when the
appropriate Perennial Set Out Year Month
Number or Grafting Year Month Number is prior
to April, month "04".

"*" = Output Only
2/23/2012

Page 11 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Perennial Leaf Year Count for Commodity Code
Blueberries, "0012" when State Code equals
Mississippi, "28" equals the Commodity Year
minus the year corresponding to the greater of
the Perennial Set Out Year Month Number or the
Grafting Year Month Number, when the
appropriate Perennial Set Out Year Month
Number or Grafting Year Month Number is after
March, month "03".
Perennial Leaf Year Count is Required for
Perennial commodities, when Leaf Year exists for
the offer in the ADM Yield and T Yield, "A01100"
record and the Yield Indicator Code does not
equal "W"."
Perennial Leaf Year Count must equal the
Commodity Year equal to the greater of Perennial
Set Out Year Month Number and Grafting Year
Month Number, plus one for perennial
commodities other than Macadamia Nuts,
Arizona-California Citrus, Texas Citrus Fruit, and
Hawaii Tropical fruit.

"*" = Output Only
2/23/2012

Page 12 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Perennial Leaf Year Count must equal the
Commodity Year minus the greater of the
Perennial Set Out Year Month Number and
Grafting Year Month Number, plus one for
perennial commodities other than Macadamia
Nuts, "0023", Arizona-California Citrus, Texas
Citrus Fruit, and Hawaii Tropical Fruit.
Perennial Leaf Year Count must equal the
Commodity Year minus the greater of the
Perennial Set Out Year Month Number and
Grafting Year Month Number for Arizona,
California or Texas Citrus Fruit.
Perennial Leaf Year Count must equal: 1 if Months
After Set Out are less than or equal to 12, 2 if
Months After Set Out is between 13 and 24, 3 if
Months After Set Out is between 25 and 36, and 4
if Months After Set Out is greater than 36 months
when Commodity Code is Hawii Tropical Fruit.
Perennial Leaf Year Count must be less than or
equal to (Perennial Graft Year - 1900) + 1 when
the Yield Indicator Code does not equal "W" and
the Perennial Graft Year is specified.

"*" = Output Only
2/23/2012

Page 13 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Perennial Leaf Year Count is Required when Yield
Indicator Code does not equal "W", the Perennial
Grafting Year Month Number is empty and the
Perennial Leaf Year Count is greater than
(Perennial Set Out Year Month Number - 1900) +
1.
Perennial Leaf Year Count must be less than or
equal to (Commodity Year - 1900) + 1.
Perennial Leaf Year Count must be greater than or
equal to 10 when Commodity Code equals
Pistachios, "0470".

P15

25

Perennial Density Quantity

Numeric

4

9999

Perennial Density Quantity must be greater than
zero and less than ten-thousand when Perennial
Set Out Year Month Number is greater than zero
except when Commodity Code equal Cranberries,
"0058" or Low Bush Blueberries, "0012", with a
Type Code equal to "04", otherwise empty.
Perennial Density Quantity must be empty for
non-Perennial commodities. For Perennial
commodities, the Perennial Density Quantity
must be empty when Leaf Year is empty in the
ADM Yield and T Yield, "A01100" record for this
offer.

"*" = Output Only
2/23/2012

Page 14 of 30

Record
Number

P15

P15

P15

Output

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

Field
Number

26

27

28

Field Name

Perennial Block Number

Perennial T Yield Factor

Perennial Special Case Code

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

Yield
P15

Data Type

Numeric

Numeric

Character

Max
Length

3

3

2

Format

999

9.99

BUS
Key Req?

Rules
Perennial Density Quantity is Required when the
Yield Indicator Code is empty or is not equal to
"W", the Leaf Year exists, the Perennial Flag
equals "Y" and Commodity Code does not equal
Cranberries, "0058" or Low Bush Blueberries,
"0012".
Perennial Block Number when required to
calculate T Yield must be greater than zero,
otherwise empty.
Perennial Block Number must be between 1 and
999.
Perennial T Yield Factor must be greater than zero
where Sub County Code is not empty and
Perennial Set Out Year Month Number is greater
than zero, otherwise empty.
Perennial Special Case Code is required when
necessary to identify special cases for Perennial
Commodities; edit with the Perennial Special Case
ICE, "D00045", otherwise empty.
Perennial Special Case Code must equal "NS"
when the Yield Limitation Code equals "03" or
"09".

"*" = Output Only
2/23/2012

Page 15 of 30

Record
Number
P15

P15

Output

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

Field
Number
29

30

Field Name
Perennial Other Characteristics Code

Perennial Grafting Year Month Number

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

Yield
P15

Data Type

Max
Length

Character

1

Character

6

Format

BUS
Key Req?

Rules
Perennial Other Characteristics Code must be
valid; edit with Yield and T Yield ADM "A01100"
record.
Perennial Other Characteristics Code is only valid
for perennial crops.
Perennial Grafting Year Month Number is
required for T Yield validation when the Leaf Year
in the ADM Yield and T Yield Table, "A01100" is
populated for the Location State Code/Location
County Code/Commodity Code, otherwise empty.
Perennial Grafting Year Month Number when
required must equal the actual calendar month
and year the acreage was grafted when the set
out month number is prior to July, "07".
Perennial Grafting Year Month Number when
required must equal the actual calendar month
and year plus one, when the set out month
number is after June, "06".

"*" = Output Only
2/23/2012

Page 16 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Perennial Grafting Year Month Number when
required cannot be prior to January 1, 1900
"190001", the first four characters must be a valid
year and the last 2 characters must be a valid
month or "00".
Perennial Grafting Year Month Number must not
be in the current Reinsurance Year.
Perennial Grafting Year Month Number must not
contain "00" in the last two characters when the
Yield Indicator Code does not equal "W".

P15

31

Yield Limitation Code

Character

2

Y

Perennial Grafting Year Month Number is
Required when Commodity Code equals
Pistachios, "0470" or Olives, "0501" and
Perennial Set Out Year Month Number is empty.
Yield Limitation Code must be valid; edit with
Yield Limitation ICE, "D00035". See P15-4 Yield
Limitation Code Exhibit.
Yield Limitation Code must not equal "03" or "09"
when Commodity Code equals Pecans, "0020"."

"*" = Output Only
2/23/2012

Page 17 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

P15

32

Previous Year Yield Limitation Code

Character

2

P15

33

Previous Year Approved Yield

Numeric

11

Format

99999999.99

BUS
Key Req?

Rules
Yield Limitation Code must equal "01", "04" or
"09" when the Trend Adjustment option is
available for this offer and has been elected on
the associated P14 record.
Previous Year Yield Limitation Code must be valid;
edit with the Previous Yield Limitation ICE,
"D00091".
Previous Year Approved Yield is required if the
Yield Limitation Code equals "01, 03, 05, 07, 10,
11, 13" or if any yield type is based on the
previous approved yield (Yield Type Code equal
"P"), otherwise empty.
Previous Year Approved Yield must be less than or
equal to the maximum allowable yield for the
submitted Location State Code and Commodity
Code, as defined by the Maximum Yield ICE,
“D00120”, unless at least one Yield History,
“P15A”, record has been submitted with an
Excessive Yield Review Flag of "Y".

P15

34

"*" = Output Only
2/23/2012

Transitional Yield

Numeric

11

Page 18 of 30

99999999.99

Transitional Yield when required must be valid;
edit with the Yield Type, Yield Limitation, Yield
Type Limit ICE, "D00040", otherwise empty.

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Transitional Yield must be valid; edit with Yield
And Tyield ADM A01100" record when Yield
Indicator Code does not equal "A", "AL", "C", "K"
or "W", Perennial Flag does not equal "Y", and
Yield Limitation Code does not equal "09" or
when the Perennial Special Case Code exists and
is not equal to "F" or when the Commodity Code
equals Cherries, "0057", Navel Oranges, "0251" or
Strawberries, "0154" and the Yield Limitation
Code does not equal "09" and the Yield Indicator
Code does not equal "A", "AL", "F", "K", "W" or
when the Yield Indicator Code is empty or equal
to "C" and the Yield Ty+J95pe Code equal to "C",
count is greater than "0".
Transitional Yield is required when the Yield
Indicator Code equals "A", "AL", "F", "K", "W" or
when the Yield Indicator Code equals "C" or is
empty and the number of associated Yield
History, P15A records with Yield Type Code equal
to '"C", count is greater than 0.

"*" = Output Only
2/23/2012

Page 19 of 30

Record
Number
P15

Output

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

Field
Number
35

Field Name
Rate Yield

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

Yield
P15

Data Type
Numeric

Max
Length
11

Format
99999999.99

BUS
Key Req?
Y

Rules
Rate Yield must equal Average Yield if Yield
Limitation Code equals "01, 05, 06, 07, 08, 09 or
12".
Rate Yield must equal Approved Yield if Yield
Limitation Code equal "03, 04, 10, 11 or 13".
Rate Yield must equal the average solid planted
yield before the skip row factor for Cotton,
"0021", Corn, "0041" or Grain Sorghum, "0051".

P15

P15

36

37

"*" = Output Only
2/23/2012

Average Yield

Approved Yield

Numeric

Numeric

11

11

Page 20 of 30

99999999.99

99999999.99

Y

Average Yield must equal the sum of all Annual
Yield divided by the number of Annual Yield
reported on the Yield History, "P15A" records
attached to this Yield record, excluding Yield
History, "P15A" records with a Yield Type equal
Zero Acres Planted, "Z" or Uninsured Acres, "U".

Y

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

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Approved Yield must equal the approved revenue
per acre (in whole dollars) calculated from the
Annual Yield where Commodity Code equals
Cherries, "0057", Navel Oranges, "0251" or
Strawberries, "0154" and 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, "062".
Approved Yield must be in whole dollars when
Commodity Type Code equals Peas Dry "0067"
and Type Code equals Contract, "098".
Approved Yield must be in whole dollars when
Commodity Type Code equals Pecans "0020".

"*" = Output Only
2/23/2012

Page 21 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Approved Yield must equal Average Yield * 0.8
when Perennial Special Case Code equals "DF"
and Yield Limitation Code does not equals "09".
Yield value should be rounded to a whole number
for commodities measured in Barrels or Tons.
Approved Yield must be less than or equal to the
maximum allowable yield for the submitted
Location State Code and Commodity Code, as
defined by the Maximum Yield ICE, “D00120”,
unless at least one Yield History, “P15A”, record
has been submitted with an Sanity Yield Check
Flag of "Y".
Approved Yield must equal the unit APH
multiplied by the Variability Adjustment Factor
when the Commodity Code equals Pistachios,
"0470" and the Perennial Leaf Year Count is
greater than or equal to "12" or when the
Commodity Code equals Olives, "0501" in any leaf
year.

"*" = Output Only
2/23/2012

Page 22 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Approved Yield must equal the simple average of
the 4 most recent years of history when the
Commodity Code equals Pistachios, "0470" and
the Perennial Leaf Year Count equals "10" or "11".
Approved Yield must be greater than or equal to
Adjusted Yield when Yield Trend Flag equals Yes,
"Y".

P15

38

Yield Indicator Code

Character

2

Yield Indicator Code must be valid; edit with Yield
Indicator ICE, "D00033", otherwise empty. See
P15-5 Yield Indicator Code Exhibit.
Yield Indicator Code must equal the Yield
Indicator Code as defined in the ICE Yield
Variability Adjustment, "D00141" record, where
the Variability Index for this record falls within the
range of Yield Variability Index Low Quantity and
Yield Variability Index High Quantity when the
Commodity Code equals Pistachios, "0470" or
Olives, "0501".
Yield Indicator Code is Required when Commodity
Code equals Pistachios, "0470" or Olives, "0501"
or when Insurance Option Code List contains 'PY'.

"*" = Output Only
2/23/2012

Page 23 of 30

Record
Number
P15

Output

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

Field
Number
39

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

Yield
P15

Field Name

Data Type

Max
Length

Insurance Option Code List

Character

29

Format

BUS
Key Req?

Rules
Insurance Option Code List must be valid; edit
with ADM Option Rate, "A01060". See P15-3
Insurance Option Code List Exhibit.
Insurance Option Code List must not contain
duplicate Option Codes.
Insurance Option Code List must be empty when
Insurance Plan Code equals Area Yield Protection
"04", Area Revenue Protection "05", Area
Revenue Protection with Harvest Price Exclusion
"06", Rainfall Index "13", or Vegetation Index
"14".
Insurance Option Code List must contain APH
Adjustment Election, "YA" when Yield Limitation
Code equal Yield Adjustment Election, "09",
except when Insurance Plan Code is Actual
Revenue History "47", and Commodity Type Code
is Cherries "0057", Navel Oranges, "0251" or
Strawberries, "0154".

"*" = Output Only
2/23/2012

Page 24 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Insurance Option Code List must contain Revenue
Substitution, "RS" when Yield Limitation Code
equal Yield Adjustment Election, "09", Insurance
Plan Code is Actual Revenue History "47", and
Commodity Type Code equal Cherries "0057",
Navel Oranges, "0251" or Strawberries, "0154".
Insurance Option Code List may only contain
Personal T-Yield, "PY" when Location State Code
equal North Dakota "38", and Yield Indicator Code
equal Added Land, "B" or Personal Transitional
Yield, "K".
Insurance Option Code List must equal "MA"
when Commodity Type Code equal Barley "0091".
Yield Option Code List "MA" can not be combined
with any other value.
Insurance Option Code List must contain the "TA"
option when the Trend Adjustment Option is
available on this offer and was elected on the P14
record, and if this APH database contains actual
yield information that qualifies it for Trend.

P15

40

"*" = Output Only
2/23/2012

Yield Option Code List

Character

29

Page 25 of 30

Yield Option Code lList must be valid; edit with
the Yield Option ICE, "D00128".

Record
Number
P15

P15

P15

Output

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

Field
Number
41

42

43

Field Name
Sub County Code

FSA Yield

FSA Farm Number

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

Yield
P15

Data Type

Max
Length

Character

8

Numeric

Character

11

Format

BUS
Key Req?
Y

99999999999

7

Rules
Sub County Code must be valid; edit with Sub
County Rate ADM, "A01050", otherwise empty.
FSA Yield must equal the Average Yield (adjusted
if applicable) in pounds as calculated from the
Average Acre Production, "P15A" where
Commodity Type Code equal Cherries "0057",
Navel Oranges, "0215" or Strawberries, "0154"
and Insurance Plan Code is Actual Revenue
History "47", otherwise empty.
FSA Farm Number is required when Commodity
Code equals Flue Cured Tobacco, "0229", Fire
Cured Tobacco, "0230", Burley tobacco, "0231",
Maryland Tobacco, "0232", Dark Air Tobacco,
"0233", Cigar Fill Tobacco, "0234", Cigar Binder
Tobacco, "0235", Cigar Wraper Tobacco, "0236"
or Peanuts, "0075".
FSA Farm Number, Unit and Type Code must
reference only one Yield, "P15" record when the
Commodity Code equals Tobacco, "0071".

"*" = Output Only
2/23/2012

Page 26 of 30

Record
Number

Output

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

P15

Field
Number
44

Field Name
Adjusted Yield

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

Yield
P15

Data Type

Max
Length

Format

Numeric

11

99999999.99

BUS
Key Req?

Rules
Adjusted Yield is required when Insurance Option
Code List contains Trend Adjusted, “TA”,
otherwise empty.
Adjusted Yield must equal the Average Yield if
Insurance Option Code List does not contain APH
Adjustment Election, “YA”.
Adjusted Yield must equal the average of the
adjusted Annual Yields on the associated Yield
History, “P15A” records for yield substitution
when Insurance Option Code List contains APH
Adjustment Election, “YA”.

P15

*

45

Valid Commodity Type Code

Character

3

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

P15

*

46

Valid Class Code

Character

3

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

P15

*

47

Valid Sub Class Code

Character

3

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

3

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

P15

*

48

"*" = Output Only
2/23/2012

Valid Intended Use Code

Character

Page 27 of 30

Record
Number

Output

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

Field
Number

P15

*

49

P15

*

P15

P15

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

Yield
P15

Data Type

Max
Length

Valid Irrigation Practice Code

Character

3

50

Valid Cropping Practice Code

Character

3

*

51

Valid Organic Practice Code

Character

3

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

*

52

Valid Interval Code

Character

3

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

Numeric

4

9999

Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.

Field Name

Format

BUS
Key Req?

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

P15

*

53

Initial Accepted Batch Number

P15

*

54

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.

P15

*

55

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

P15

*

56

Batch Number

Numeric

4

9999

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

Page 28 of 30

Record
Number

Output

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

Field
Number

Field Name

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

Yield
P15

Data Type

Max
Length

P15

*

57

Batch Record ID

Numeric

15

P15

*

58

Process Result Code

Character

1

"*" = Output Only
2/23/2012

Page 29 of 30

Format

BUS
Key Req?

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

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

Yield
P15

Data Type

Max
Length

Format

BUS
Key Req?

Rules

Record Level Rules
The Yield, "P15" record must be submitted
between 20100701 and 20150212.
The Yield, "P15" record will not be accepted when
processing has been suspended for this record
type per RMA directive.
The proceeding Insurance In Force, "P14" record
in this batch must be accepted for the Yield, "P15"
record to be accpted.
The child record Yield History, "P15A" must be
accepted in this batch for the Yield, "P15" record
to be accepted.
Actual Yield Year Count for Cherries, "0057" must
be reported in Commodity Units.
Yield Limitation Code values of "2" and "6" do not
apply to any Commodity Types.
When processing Insurance In Force, "P14"
records for Speciality Type Commodities, multiple
Insurance In Force, "P14" record submission is
allowed as long as the Yield, "P15" indicates it is a
Speciality Type Commodity, the exact Speciality
Type does not need to match on the Insurance In
Force, "P14" and the Yield, "P15" records.
"*" = Output Only
2/23/2012

Page 30 of 30


File Typeapplication/pdf
AuthorTodd Stinson
File Modified2012-02-23
File Created2012-02-23

© 2024 OMB.report | Privacy Policy