Inventory Value Record Type 13

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

P13

1

AIP Code

Character

2

P13
P13

2
3

Reinsurance Year
Record Type Code

Numeric
Character

4
6

P13

4

AIP Policy Producer Key

Character

15

P13

5

AIP Insurance In Force Key

Character

15

P13

6

AIP Inventory Value Key

Character

15

P13

7

AIP Insurance Agent Key

Character

15

File Type:
Reinsurance Year:
Version:
Release Date:

Format

CCYY

BUS
Key Req?
Y

Y

Y

Y
Y
Y

Y

Y

Y

Y

Delimited
2016
Approved
7/1/2015

Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must be "2016".
Record Type Code must be "P13".
AIP Policy Producer Key must match the Parent
corresponding primary Policy Producer, "P10"
record.
AIP Insurance In Force Key must be unique within
the AIP Policy Producer Key.
AIP Inventory Value Key is the value used to
identify each Inventory Value, "P13" record and
must be unique within the Reinsurance Year and
the parent Insurance In Force, "P14" record.
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.

P13

"*" = Output Only
6/29/2015

8

Basic Unit Number

Character

4

Page 1 of 28

Y

Y

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

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

Basic Unit Number must be equal across all
Inventory Value, "P13" records with the same AIP
Code, Policy Producer Key, AIP Insurance in Force
Key, Practice Code, and Insured Share Percent
when the Commodity Code equals Nursery,
"0073", the Unit Structure Code equals Basic Unit,
"BU", the Unit Division Code equals Units by
Type, "T" and the Coverage Type Code equals Buyup, "A". Non Premium Inventory Code rows are
excluded from this check.
Basic Unit Number must be equal across all
Inventory Value, "P13" records with the same AIP
Policy Producer Key, Commodity Year, Commodity
Code, Insurance Plan Code, Location County
Code, Coverage Level Percent, Coverage Type
Code, Practice Code, and Insured Share Percent
when the Commodity Code equals Nursery,
"0073", the Unit Structure Code equals Basic Unit,
"BU", the Unit Division Code equals Units by
Share, "S". Non Premium Inventory Code rows are
excluded from this check.

"*" = Output Only
6/29/2015

Page 2 of 28

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

P13

9

Optional Unit Number

Character

4

Y

P13

10

Unit Structure Code

Character

2

Y

P13

11

Type Code

Character

3

Y

Y

Delimited
2016
Approved
7/1/2015

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 Units are not allowed when Commodity
Code equals Nursery, "0073".
Unit Structure Code must be valid for the
reporting Unit; edit with the Unit Structure ICE,
"D00095".
Type Code must be valid; edit with the Type ADM
"A00540".
Type Code must be equal across all Inventory
Value, "P13" records with the same AIP Code,
Policy Producer Key, AIP Insurance in Force Key,
Practice Code and Basic Unit Number when the
Commodity Code equals Nursery, "0073", the Unit
Structure Code equals Basic Unit, "BU", the Unit
Division Code equals Units by Type, "T" and the
Coverage Type Code equals Buy-up, "A". Non
Premium Inventory Code rows are excluded from
this check.

"*" = Output Only
6/29/2015

Page 3 of 28

Record
Number

Output

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

P13

P13

P13

P13

"*" = Output Only
6/29/2015

12

13

14

15

Field Name
Practice Code

Commodity Type Code

Class Code

Sub Class Code

Inventory Value
P13

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Character

3

Practice Code is required when Commodity Code
equals Nursery, "0073"; edit with the Practice
ADM, "A00510".

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.

Character

Character

Character

Page 4 of 28

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

Record
Number

Output

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

P13

P13

P13

"*" = Output Only
6/29/2015

16

17

18

Field Name

Intended Use Code

Irrigation Practice Code

Cropping Practice Code

Inventory Value
P13

Data Type

Character

Character

Character

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

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.

Page 5 of 28

Record
Number

Output

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

P13

19

Field Name

Organic Practice Code

Inventory Value
P13

Data Type

Character

Max
Length

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

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

P13

20

Interval Code

Character

3

P13

21

WA Number

Character

9

P13

22

Settlement Flag

Character

1

P13

23

Revised Report Code

Character

1

"*" = Output Only
6/29/2015

File Type:
Reinsurance Year:
Version:
Release Date:

Page 6 of 28

999999999

WA Number must be valid.
WA Number must not equal "000000000".
WA Number must be empty when Coverage Type
Code equals Catastrophic, "C".
Settlement Flag must equal Yes, "Y" if there is
Settlement or Finding, otherwise empty.
Settlement Flag is required when the record exists
in the Settlement table.
Revised Report Code must be valid; edit with the
Revised Report ICE, "D00083".

Record
Number

Output

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

P13

24

Field Name

Inventory Value Amount

Inventory Value
P13

Data Type

Numeric

Max
Length

9

File Type:
Reinsurance Year:
Version:
Release Date:

Format

999999999

BUS
Key Req?

Y

Delimited
2016
Approved
7/1/2015

Rules
Inventory Value Amount must be reported in
whole dollars by Type from the inventory reports
for initial, revised or peak and is required when
Commodity Code equal Nursery, "0073".
Inventory Value Amount is Required when Non
Premium Inventory Code is empty and
Commodity Code equals Nursery, "0073".
Inventory Value Amount must be empty when
NOT (Non Premium Inventory Code is empty and
Commodity Code equals '0073') and NOT
(Insurance Plan Code equals '43' and Commodity
Code equals '0116' and Revised Report Code
equals '3').
Inventory Value Amount is required when
Insurance Plan Code is '43' and Commodity Code
is '0116' and Revised Report Code is '3'.

P13

25

Previous Year Sales Amount

Numeric

9

999999999

P13

26

Insured Share Percent

Numeric

5

9.999

"*" = Output Only
6/29/2015

Page 7 of 28

Previous Year Sales Amount is required when
Coverage Type Code equal Catastrophic, "C".
Insured Share Percent must be greater than zero
and less than or equal to 1.000.

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Insured Share Percent must be less than or equal
to 1 minus the Ineligible SBI Share Percent on the
Policy Producer Other Person, “P10B” record
when the Ineligible SBI Flag equals Yes, “Y” and
the Ineligible SBI Share Percent on the Policy
Producer Other Person, “P10B” record is greater
than zero.
Insured Share Percent must be equal across all
Inventory Value, "P13" records with the same AIP
Policy Producer Key, Commodity Year, Commodity
Code, Insurance Plan Code, Location County
Code, Coverage Level Percent, Coverage Type
Code, Practice Code, and Basic Unit Number when
the Commodity Code equals Nursery, "0073", the
Unit Structure Code equals, Basic Unit, "BU" and
the Unit Division Code equals Units by Share, "S".
Non Premium Inventory Code rows are excluded
from this check.

"*" = Output Only
6/29/2015

Page 8 of 28

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Insured Share Percent must be equal across all
Inventory Value, "P13" records with the same AIP
Policy Producer Key, AIP Insurance in Force Key
and Basic Unit Number when the Commodity
Code equals Clams, "0116", the Unit Structure
Code equals, Basic Unit, "BU" and the Coverage
Type Code equals Catastrophic, "C". Non Premium
Inventory Code rows are excluded from this
check.

P13

27

Unit Division Code

Character

1

P13

28

Insurance Option Code List

Character

29

"*" = Output Only
6/29/2015

Page 9 of 28

Unit Division Code must equal Units by Share (Cat
& Buy-up), "S" or Units by Type (NA for CAT), "T"
when the Commodity Code equal Nursery,
"0073", otherwise empty.
Insurance Option Code List must contain only
unique delimited values.
Insurance Option Code List must be valid; edit
with Option Rate ADM, "A01060".
Insurance Option Code List must contain Peak
Endorsement, "PE" when the Peak
Commencement Date is not empty or the Peak
Termination Date is not empty and the
Commodity Code equals Nursery, "0073".

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Insurance Option Code List must be empty when
Coverage Type Code equals Catastrophic, "C".
Insurance Option Code List must contain ALL
Option Codes that must be elected before the
Sales Closing Date when they exist on the parent,
Insurance in Force, "P14" record.
The Insurance Option Code List must contain valid
combinations of Insurance Option Codes. Review
ADM Option Rate (A01060) to determine which
Insurance Option Codes cannot be combined and
which Insurance Option Codes have to be
submitted together.

P13

29

AIP Total Premium Amount

Numeric

10

9999999999

P13

30

AIP Liability Amount

Numeric

10

9999999999

"*" = Output Only
6/29/2015

Page 10 of 28

Y

AIP Total Premium Amount is the premium
amount calculated for the Commodity Code and
Insurance Plan Code. When AIP Total Premium
Amount is less than $1.00, round to $1.00.
AIP Liability Amount must equal RMA calculated
Liability Amount.

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

P13

31

AIP Subsidy Amount

Numeric

10

P13
P13
P13
P13

32
33
34
35

Additional Subsidy Flag
Additional Subsidy Amount
State Private Subsidy Flag
State Private Subsidy Amount

Character
Numeric
Character
Numeric

1
10
1
10

P13

36

Insured Inventory Signature Date

Date

8

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

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

9999999999

Reserved must be empty.
Reserved must be empty.
Reserved must be empty.
Reserved must be empty.

9999999999
9999999999

CCYYMMDD

Delimited
2016
Approved
7/1/2015

Y

Insured Inventory Signature Date cannot be less
than the Reinsurance Year minus (-) one or
greater than the Batch Received Date when
Commodity Code equal Clams, "0116".
Insured Inventory Signature Date must not be
greater than Commodity Year minus
(-) one or greater than the Batch Received Date
when Commodity Code equal Nursery, "0073".

P13

"*" = Output Only
6/29/2015

37

Peak Commencement Date

Date

8

Page 11 of 28

CCYYMMDD

Peak Commencement Date is valid for Coverage
Type Code equal Buy-up, "A" only and must equal
the commencement date of coverage and must
be less than or equal to 5/31/2016 when
Commodity Code equal Nursery, "0073" and the
Insurance Option Code List equals "PE", otherwise
empty.

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Peak Commencement Date must be empty when
Coverage Type Code equals Catastrophic, "C" or
Commodity Code equals Clams, "0116" or the or
Insurance Option Code List does not contain “PE”
or the Non Premium Inventory Code exists or
Insurance Option Code List does not contain “PE”.
Peak Commencement Date must be less than or
equal to 5/31 of the Commodity Year.
Peak Commencement Date must be less than the
Peak Termination Date.
Peak Commencement Date must be greater than
or equal to the Insured Acreage Signature Date.

P13

38

Peak Termination Date

Date

8

CCYYMMDD

Peak Termination Date is valid for Coverage Type
Code equal Buy-up, "A" only and must equal the
termination date of coverage when Commodity
Code equal Nursery, "0073", and Insurance
Option Code List equals "PE", otherwise empty.
Peak Termination Date must be earlier than 6/1
of the Commodity Year.

"*" = Output Only
6/29/2015

Page 12 of 28

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

P13

39

Previous Year Sales Code

Character

1

P13

40

Survival Percent

Numeric

5

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Previous Year Sales Code must equal Previous
Year Sales Amount limit requirement is waived,
"W" when Coverage Type Code equals
Catastrophic, "C" and the previous year sales limit
requirement is waived for Commodity Code equal
Clams, "0116", otherwise empty.

9.999

Survival Percent must be valid; edit with the Price
ADM, "A00810".
Survival Percent is required when Commodity
Code equals Clams, "0116" and Survival Percent
Source Code does not equal "A" and Non
Premium Inventory Code is empty.

P13

41

Survival Percent Source Code

Character

1

Survival Percent Source Code must be valid; when
Commodity Code equals Clams, "0116"; edit with
the Survival Percent Source ICE, "D00084".
Survival Percent Source Code is Required when
Commodity Code equals Clams, "0116" and Non
Premium Inventory Code is empty.
Survival Percent Source Code must be empty
when Commodity Code equals Nursery, "0073".

"*" = Output Only
6/29/2015

Page 13 of 28

Record
Number

Output

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

P13

42

Field Name
Reported Clam Count

Inventory Value
P13

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Format

Numeric

8

99999999

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Reported Clam Count equal the Total Number of
Clams by Stage.
Reported Clam Count must be between 1 and
99999999.
Reported Clam Count is Required when Insurance
Plan Code equals Aquaculture Dollar, "43".
Reported Clam Count must be empty when
Insurance Plan Code does not equal Aquaculture
Dollar, "43".
Reported Clam Count must be empty when
Insurance Plan Code equal Aquaculture Dollar,
"43", and Revised Report Code contains "3"
(increase value).

P13

43

Agent Inventory Value Signature Date

Date

8

CCYYMMDD

Agent Inventory Value Signature Date must be
between the Contract Change Date minus one
year and the Batch Received Date.
Agent Inventory Value Signature Date must be
less than the Inactive Date from the Agent, "P55"
record when the Inactive Date exists.

"*" = Output Only
6/29/2015

Page 14 of 28

Record
Number

Output

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

P13

44

Field Name

Original Inventory Amount

Inventory Value
P13

Data Type

Numeric

Max
Length

9

File Type:
Reinsurance Year:
Version:
Release Date:

Format

999999999

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Original Inventory Amount must be reported in
whole dollars by Unit from the inventory reports
when the Insurance Option Code List equals Peak
Endorsement, "PE" and the Commodity Code
equal Nursery, "0073".
Original Inventory Value Amount must be
reported in whole dollars by Unit and is required
when the Commodity Code equals Nursery,
"0073" and the Coverage Type Code equal
Catastrophic, "C".
Original Inventory Value Amount must be
reported in whole dollars by Unit and is required
when Commodity Code equals Clams, "0116" and
Revised Report Code equals Revised, "1" or
Acquired, "2".
Original Inventory Value Amount must be empty
when the Commodity Code equals Nursery,
"0073", the Coverage Type Codes does not equal
Catastrophic, "C" and the Insurance Option Code
List does not contain "Peak Endorsement, "PE" or
when the Commodity Code equals Clams, "0116"
and the Revised Report Code equals "0".

"*" = Output Only
6/29/2015

Page 15 of 28

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Original Inventory Value Amount must be less
than or equal to the Sum Liability Amount (for
Reinsurance Year, AIP Insurance in Force Key,
Location State Code, Location County Code, Unit
Number and Commodity Year) when the
Insurance Option Code List does not contain Peak
Endorsement, "PE".

P13

45

Non Premium Inventory Code

Character

1

Non Premium Inventory Code must be valid; edit
with the Non Premium Acreage ICE, "D00050".
Non Premium Inventory Code must be valid; edit
with Non Premium Acreage Insurance Plan
Commodity ICE, "D00049".

P13

P13

"*" = Output Only
6/29/2015

46

47

Premium Multiple Cropping Code

Inventory Value Group Key

Character

Character

2

Premium Multiple Cropping Code must be valid;
edit with the Multiple Cropping ICE, "D00063".

15

Inventory Value Group Key is required when
Insurance Plan Code is '43' and Commodity Code
is '0116' and Revised Report Code is '3'.

Page 16 of 28

Record
Number

Output

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

P13

48

Field Name

CC Subsidy Reduction Percent

Inventory Value
P13

Data Type

Numeric

Max
Length

5

File Type:
Reinsurance Year:
Version:
Release Date:

Format

9.999

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
CC Subsidy Reduction Percent is required when
Applied Program Indicator Code List contains 'CC'
on the Policy Producer, "P10" record or any
associated Policy Producer Other Person, "P10B"
record.
CC Subsidy Reduction Percent must be empty
when Applied Program Indicator Code List does
not contain 'CC' on the Policy Producer, "P10"
record and any associated Policy Producer Other
Person, "P10B" record.
CC Subsidy Reduction Percent must be numeric
when CC Subsidy Reduction Percent exists.
CC Subsidy Reduction Percent must have no more
than one (1) number on the left of the decimal
point and three (3) numbers after the decimal
point, in the format of 9.999 when CC Subsidy
Reduction Percent exists.
CC Subsidy Reduction Percent must be greater
than zero (0) and less than or equal to one (1)
when CC Subsidy Reduction Percent exists.

"*" = Output Only
6/29/2015

Page 17 of 28

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
CC Subsidy Reduction Percent must equal 1.000
when Policy Producer, "P10" record's Applied
Program Indicator Code List contains 'CC' and CC
Subsidy Reduction Percent exists.
CC Subsidy Reduction Percent must be equal on
all associated Inventory Value, "P13" records,
unless at least one of the associated Policy
Producer Other Person, "P10B" records contain
an Entity Type Code equal to "F", when CC
Subsidy Reduction Percent exists.

P13

P13

*

*

"*" = Output Only
6/29/2015

49

50

Base Premium Rate

Proration Percent

Numeric

Numeric

9

4

Page 18 of 28

.99999999

9.99

Y

Base Premium Rate is the rate used in the RMA
calculation.
Proration Percent when Commodity Code equal
Clams, "0116" must equal "1.00" when the
Revised Report Code equal zero otherwise when
the Revised Report Code equal "1" or "2", the
Proration Percent must equal the rate for the
month containing the 31st calendar day following
the Insured Inventory Value Signature Date; edit
with the Proration ADM, "A01070".

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Proration Percent when Commodity Code equal
Nursery, "0073, Contract Carryover Flag equal
Yes, "Y" and the Insured Inventory Signature Date
is less than or equal to 05/01 of the Reinsurance
Year must equal the Proration Percent for the
month of June from the Proration ADM,
"A01070"; otherwise, the Proration Percent must
equal the Proration Percent from the Proration
ADM, "A01070" for the month of the Insured
inventory Signature Date plus 31 days.
Proration Percent when Commodity Code equal
Nursery, "0073 and the policy is a "new" or
"revised" policy must equal the Proration Percent
from the Proration ADM "A01070" for the month
in which the 31st day after the Insured Inventory
Value Signature Date falls.

"*" = Output Only
6/29/2015

Page 19 of 28

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Proration Percent when Commodity Code equal
Nursery, "0073" and the Insurance Option Code
List contains Peak Endorsement, "PE" must equal
the Commencement Month Factor minus the
month following the Termination month; edit
with the Proration ADM, "A01070".
Proration Percent when Commodity Code equal
Nursery, "0073" and the Insurance Option Code
List contains Peak Endorsement, "PE" must equal
the Proration Percent for the month in which the
Peak Commencement Date falls from the
Proration ADM, “A01070”, minus the Proration
Percent for the month following the month in
which the Peak Termination Date falls from the
Proration ADM, “A01070”.

P13

*

"*" = Output Only
6/29/2015

51

Total Premium Amount

Numeric

10

Page 20 of 28

9999999999

Total Premium Amount is the amount returned
from the RMA calculation. See Exhibit P13-1, Plan
Aquaculture Dollar, "43" and Exhibit P13-2, Plan
Dollar Amount of Insurance, "50". When AIP Total
Premium Amount is less than $1.00, round to
$1.00.

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Subsidy Amount is the dollar amount of the
Subsidy for the Commodity Code and Insurance
Plan Code. When Subsidy Amount is less than
$1.00, round to $1.00.
Liability Amount is the amount returned from the
RMA calculation. See Exhibit P13-1, Plan
Aquaculture Dollar, "43" and
Exhibit P13-2, Plan Dollar Amount of Insurance,
"50".
Liability Amount must be less than or equal to
200% of the Original Inventory Value Amount
when Commodity Code equals Nursery, “0073”
and the Insurance Option Code List contains Peak
Endorsement, “PE”.

P13

*

52

Subsidy Amount

Numeric

10

9999999999

Y

P13

*

53

Liability Amount

Numeric

10

9999999999

Y

P13

*

54

Producer Premium Amount

Numeric

10

9999999999

Producer Premium Amount equals the Total
Premium Amount minus the Subsidy Amount.

55

Commodity Year Deductible Amount

Numeric

10

9999999999

Commodity Year Deductible Amount is the
deductible per commodity year.

P13

P13

*

*

"*" = Output Only
6/29/2015

56

Weeks Late

Numeric

2

Page 21 of 28

99

The number of weeks late this acreage line was
originally submitted based on latest acreage
reporting date for the Insurance in Force, "P14"
records submitted within the batch.

Record
Number

Output

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

Field Name

Inventory Value
P13

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Format

P13

*

57

A&O Expense Subsidy Amount

Numeric

13

9999999999.99

P13

*

58

CAT Loss Adjustment Expense Amount

Numeric

13

9999999999.99

P13

*

59

Eligibility Code

Character

8

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
A & O Expense Subsidy Amount must be valid.
Edit with the Commodity Reference Price ICE,
"D00089".
CAT Loss Adjustment Expense Amount is the
amount used in the RMA calculation.
Reserved.
Valid Commodity Type Code is populated from
the Valid Commodity Type Code in the Insurance
Offer ADM, "A00030".

P13

*

60

Valid Commodity Type Code

Character

3

P13

*

61

Valid Class Code

Character

3

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

P13

*

62

Valid Sub Class Code

Character

3

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

P13

*

63

Valid Intended Use Code

Character

3

P13

*

64

Valid Irrigation Practice Code

Character

3

P13

*

65

Valid Cropping Practice Code

Character

3

"*" = Output Only
6/29/2015

Page 22 of 28

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

Inventory Value
P13

File Type:
Reinsurance Year:
Version:
Release Date:

Delimited
2016
Approved
7/1/2015

Output

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

Field Name

Data Type

Max
Length

*

66

Valid Organic Practice Code

Character

3

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

67

Valid Interval Code

Character

3

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

Record
Number
P13

P13

*

Format

BUS
Key Req?

Rules

P13

*

68

BFR Subsidy Amount

Numeric

10

9999999999

Beginning Farmer Rancher Subsidy Amount. 0.10
(10%) of the Total Premium Amount added to the
base Subsidy Amount to arrive at the new
'Subsidy Amount'. See P11 Calculation Exhibits.

P13

*

69

CC Subsidy Reduction Amount

Numeric

10

9999999999

CC Subsidy Reduction Amount is the amount of
subsidy reduced due to Conservation Compliance.
See P13 Calculation Exhibit.

Numeric

4

9999

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

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.

72

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

Batch Received Date is the date that the AIP file is
received by RMA.

73

Batch Number

Numeric

4

9999

P13

*

70

Initial Accepted Batch Number

P13

*

71

P13

*

P13

*

"*" = Output Only
6/29/2015

Page 23 of 28

Batch Number is a sequential number assigned
when an AIP file is received.

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

P13

*

74

Batch Record ID

Numeric

15

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.

P13

*

75

Process Result Code

Character

1

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

"*" = Output Only
6/29/2015

Page 24 of 28

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

Record Level Rules
1

Inventory Value, "P13" records will not be
accepted when processing has been suspended
for this record type per RMA directive.

2

The related Land, "P27" record must be free of
errors for the Inventory Value, "P13" record to be
accepted.

3

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.
All Inventory Value, "P13" records for the
corresponding Insurance in Force, "P14" record
must be accepted.
For the P13 record to be accepted there must be
a corresponding P14 record accepted in this
batch.

4
5

When a parent record type fails with established
LRR or Escrow Fund recorded (where Process
Result Code equals "K") the child record type will
also fail (with Process Result Code equals "R").

6

"*" = Output Only
6/29/2015

Page 25 of 28

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

7

A Maximum of 4, Inventory Value, "P13" records
are allowed for an AIP Policy Producer Key, AIP
Insurance In Force Key, Type Code, Practice Code
and (Basic Unit Number (if Unit Structure Code =
BU) or Optional Unit Number (if Unit Structure
Code = OU)).

8

The Inventory Value, "P13" record allows one and
only one Base record.  A Base Inventory Value,
"P13" record is identified by the Revised Report
Code, Peak Commencement Date and Peak
Termination Date equal to null.

9

Unable to perform the Aquaculture Dollar
Premium Corporate Calculation, because one or
more of the following fields has failed validation:
Commodity Year, Survival Percent, Reported Clam
Count, Insured Share Percent or Coverage Level
Percent.

10

Unable to perform the Nursery Dollar Premium
Corporate Calculation, because one or more of
the following fields has failed validation:
Commodity Year, Insured Share Percent,
Coverage Level Percent, Inventory Value Amount.

"*" = Output Only
6/29/2015

Page 26 of 28

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

11

A Base Inventory Value record must have already
been submitted and accepted (in the ODS13
table) or exist in the current batch for this Revised
Inventory Value record when Commodity Code is
'0116' and Insurance Plan Code is '43' and Revised
Report Code is '3'. Join the Revised record to the
Base record using AIP Policy Producer Key, AIP
Insurance In Force Key, Basic Unit Number,
Optional Unit Number, and Inventory Value
Group Key.

12

SUM(Inventory Value Amount) for the Unit must
be less than or equal to Previous Year Sales
Amount * 2.0 when Commodity Code is '0116'
and Coverage Type Code is 'C' and Location State
Code is '12' and Previous Year Sales Code is not
'W'.

13

SUM(Inventory Value Amount) for the Unit must
be less than or equal to Previous Year Sales
Amount * 3.0 when Commodity Code is '0116'
and Coverage Type Code is 'C' and Location State
Code is one of the following values: '25', '51' and
Previous Year Sales Code is not 'W'.

"*" = Output Only
6/29/2015

Page 27 of 28

Record
Number

Output

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

Field Name

Inventory Value
P13

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

14

SUM(Inventory Value Amount) for the Unit must
be less than or equal to Previous Year Sales
Amount * 2.5 when Commodity Code '0116' and
Coverage Type Code is 'C' and Location State Code
is '45' and Previous Year Sales Code is not 'W'.

15

SUM(Inventory Value Amount) for the Unit
cannot be greater than 110% of Previous Year
Sales Amount or 110% of Original Inventory Value
Amount when Commodity Code '0073' and
Coverage Type Code is 'C'.

"*" = Output Only
6/29/2015

Page 28 of 28