Inventory Loss Record Type 22

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

P22

1

AIP Code

Character

2

P22
P22

2
3

Reinsurance Year
Record Type Code

Numeric
Character

4
6

P22

4

AIP Policy Producer Key

Character

15

P22

5

AIP Insurance In Force Key

Character

15

Y

Y

P22

6

AIP Inventory Value Key

Character

15

Y

Y

P22

7

AIP Inventory Loss Detail Key

Character

15

Y

Y

P22

8

AIP Adjuster Key

Character

15

P22
P22

9
10

Claim Number
First Damage Cause Code

Numeric
Character

8
2

CCYY

Y

Y

Y
Y

Y
Y
Y

Y
99999999
Y

Delimited
2016
Approved
7/1/2015

Rules
AIP Code must be valid; edit with AIP ICE
"D00100".
Reinsurance Year must be "2016".
Record Type Code must be "P22".
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 must match the
corresponding Inventory Value, "P13" record.
AIP Inventory Loss Detail Key must be unique
within the submitted Inventory Loss Detail, "P22"
records.
AIP Adjuster Key must match the corresponding
Adjuster, "P56" record.
Claim Number must be greater than zero.
First Damage Cause Code cannot equal "00".
First Damage Cause Code must be valid edit with
the Damage Cause Commodity ICE, "D00077".

P22

11

"*" = Output Only
6/29/2015

First Damage Date

Date

8

Page 1 of 27

CCYYMMDD

Y

First Damage Date must be less than or equal to
the First Notice of Loss Date.

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
First Damage Date must be less than or equal to
Batch Received Date when the First Damage
Cause Code is not empty.

P22

12

First Damage Percent

Numeric

4

9.99

First Damage Percent must equal ".01" to "1.00"
when the First Damage Cause Code is not empty.
First Damage Percent plus Second Damage
Percent plus Third Damage Percent cannot be
greater than "1.00".
First Damage Percent must equal "1.00" when
Second Damage Percent and Third Damage
Percent are empty.

P22

13

Second Damage Cause Code

P22

14

Second Damage Date

P22

15

Second Damage Percent

"*" = Output Only
6/29/2015

2

Second Damage Cause Code cannot equal “00”
when Second Damage Cause Code exists.

Date

8

CCYYMMDD

Numeric

4

9.99

Second Damage Cause Code must be valid edit
with the Damage Cause Commodity ICE,
"D00077".
Second Damage Date must be less than or equal
to Batch Received Date when the Second Damage
Cause Code is not empty.
Second Damage Percent must equal ".01" to
"0.99" when the Second Damage Cause Code is
not empty.

Character

Page 2 of 27

Record
Number

P22

Output

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

16

Field Name

Third Damage Cause Code

Inventory Loss Detail
P22

Data Type

Character

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Second Damage Percent plus First Damage
Percent plus Third Damage Percent cannot be
greater than "1.00".
Second Damage Percent must be empty when
First Damage Percent equals "1.00" or when First
Damage Percent is empty.
Third Damage Cause Code cannot equal “00”
when Third Damage Cause Code exists.

2

Third Damage Cause Code must be valid edit with
the Damage Cause Commodity ICE, "D00077".
P22

17

Third Damage Date

P22

18

Third Damage Percent

Date

8

CCYYMMDD

Third Damage Date must be less than or equal to
Batch Received Date when the Third Damage
Cause Code is not empty.

Numeric

4

9.99

Third Damage Percent must equal ".01" to "0.98"
when the Third Damage Cause Code is not empty.
Third Damage Percent plus Second Damage
Percent plus First Damage Percent cannot be
greater than "1.00".
Third Damage Percent must be empty when First
Damage Percent plus Second Damage Percent
equals "1.00" or when First Damage Percent is
empty.

"*" = Output Only
6/29/2015

Page 3 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Format

P22

19

Inventory Inspection Number

Numeric

2

99

P22

20

Basic Unit Value

Numeric

10

9999999999

BUS
Key Req?
Y

Delimited
2016
Approved
7/1/2015

Rules
Inventory Inspection Number must equal the
Inspection Number and must be the same within
a claim number.
Basic Unit Value equals the Inventory Value
Amount for the Basic Unit without price percent
coverage level of share when Commodity Code
equals Nursery, "0073".
Basic Unit Value equals the Basic Unit Field
Market Value A when Commodity Code equals
Clams, "0116".
Basic Unit Value equals the Basic Unit PIVR
Amount when the Insurance Option Code List
equals, Rehab Endorsement, "RH".
Basic Unit Value is Required when Commodity
Code equals Nursery, "0073" or Clams, "0116"
and must be greater than zero.

"*" = Output Only
6/29/2015

Page 4 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Basic Unit Value must be equal across all
Inventory Loss Detail, "P22" records with the
same AIP Policy Producer Key, Commodity Year,
Practice Code, Claim Number, Inventory
Inspection Number and Basic Unit Number when
the Commodity Code equals Nursery, "0073" and
the Unit Structure Code equals Basic Unit, "BU",
the Unit Division Code equals Units by Share, "S"
and Insurance Option Code List does not contain
"RH".

P22

21

"*" = Output Only
6/29/2015

Effective Insurance Amount

Numeric

10

Page 5 of 27

9999999999

Basic Unit Value must be equal across all
Inventory Loss Detail, "P22" records with the
same AIP Policy Producer Key, Commodity Year,
Claim Number, Inventory Inspection Number and
Basic Unit Number when the Commodity Code
equals Clams, "0116" and the Unit Structure Code
equals Basic Unit, "BU" and the Coverage Type
Code equals Catastrophic, "C".
Effective Insurance Amount equals the remaining
insurance amount after previous losses for the
basic unit when Commodity Code equals Clams,
"0116".

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Effective Insurance Amount is required for when
Commodity Code equals Clams, "0116";
otherwise empty.
Effective Insurance Amount must be equal across
all Inventory Loss Detail, "P22" records with the
same AIP Policy Producer Key, Commodity Year,
Claim Number, Inventory Inspection Number and
Basic Unit Number when the Commodity Code
equals Clams, "0116" and the Unit Structure Code
equals Basic Unit, "BU" and the Coverage Type
Code equals Catastrophic, "C".

P22

22

XPS Effective Insurance Amount

Numeric

10

9999999999

XPS Effective Insurance Amount must be empty
when Commodity Code does not equal Nursery,
"0073".
XPS Effective Insurance Amount equals the Basic
Unit Value minus any previous Basic Unit
Indemnities when Commodity Code equals
Nursery, "0073".
XPS Effective Insurance Amount for CAT or Buy-up
by Share (Unit Division Code = S) must have the
same value on all records for the Unit within the
same Commodity Year, Practice Code, Claim
Number and Inventory Inspection Number.

"*" = Output Only
6/29/2015

Page 6 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
XPS Effective Insurance Amount is required when
Commodity Code equals Nursery, "0073" and the
Insurance Option Code List does not contain
Rehab Endorsement, "RH".
XPS Effective Insurance Amount must be between
1 and 9999999999 when XPS Effective Insurance
Amount exists.
XPS Effective Insurance Amount must be equal
across all Inventory Loss Detail, "P22" records
with the same AIP Policy Producer Key,
Commodity Year, Practice Code, Claim Number,
Inventory Inspection Number and Basic Unit
Number when the Commodity Code equals
Nursery, "0073" and the Unit Structure Code
equals Basic Unit, "BU", the Unit Division Code
equals Units by Share, "S" and Insurance Option
Code List does not contain "RH".

P22

23

"*" = Output Only
6/29/2015

Over Under Reporting Factor

Numeric

5

Page 7 of 27

9.999

Over Under Reporting Factor is Required when
Over Under Reporting Factor Code exists.

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Over Under Reporting Factor must equal the
lesser of 1.000 or the Basic Unit Value minus any
previous losses as adjusted by any previous Over
Under Reporting Factor, divided by Field Market
Value A when Commodity Code equal Nursery,
"0073" and Over Under Reporting Factor Code
equals "U".
Over Under Reporting Factor must equal the Basic
Unit Value minus any previous losses as adjusted
by any previous Over Under Reporting Factor,
divided by the sum of Field Market Value A plus
the insured value of the plants listed on the
verified sales records minus 1.100 when the
Commodity Code equal Nursery, "0073" and Over
Under Reporting Factor equals "O". Value must
be greater than "0.000".
Over Under Reporting Factor must equal the
value from item 11 of the Rehab worksheet when
Option Code equal Rehab Endorsement, "RH".

"*" = Output Only
6/29/2015

Page 8 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Over Under Reporting Factor must equal the
lesser of 1.000 or the sum of all Stage values
minus all previous losses divided Basic Unit Value
minus any previous losses divided by the basic
unit value before loss when Commodity Code
equal Clams, "0116".
Over Under Reporting Factor must be the same
within the same Record Type Code, AIP Policy
Producer Key, Commodity Year, Practice Code,
Claim Number, Inventory Inspection Number and
Basic Unit Number when Unit Structure Code
equals Basic Unit, "BU" the Unit Division Code
equals "S", the Commodity Code equals Nursery,
"0073" and the Over Under Reporting Factor
exists.

"*" = Output Only
6/29/2015

Page 9 of 27

Record
Number

P22

Output

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

24

Field Name

Field Market Value A

Inventory Loss Detail
P22

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

Over Under Reporting Factor must be equal the
same within the same AIP Policy Producer Key,
Commodity Year, Claim Number, Inventory
Inspection Number and Basic Unit Number when
the Unit Structure Code equals Basic Unit, "BU",
the Commodity Code equals Clams, "0116", the
Coverage Type Code equals Catastrophic, "C" and
the Over Under Reporting Factor exists.
Field Market Value A is required when
Commodity Code equals Nursery, "0073".
Field Market Value A must be greater than zero
when required.
Field Market Value A must be empty when
Commodity Code equals Clams, "0116".
Field Market Value A must equal the value of all
insurable plants based on the plant price schedule
(or the prices in your catalog/price list) before any
loss occurrence, when Commodity Code equal
Nursery, "0073".

"*" = Output Only
6/29/2015

Page 10 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Field Market Value A for CAT and Buy-up by Share
(Unit Division Code = S) must be the value of this
field for each individual record when Commodity
Code equal Nursery, "0073".
Field Market Value A must equal the value from
item 7 of the Rehab worksheet when Option Code
equal Rehab Endorsement, "RH".

P22

25

Field Market Value B

Numeric

9

999999999

Field Market Value B is required when Commodity
Code equals Nursery, "0073" and the Insurance
Option Code List does not contain Rehab
Endorsement, "RH".
Field Market Value B may equal zero when
required.
Field Market Value B must be empty when
commodity code equals Clams, "0116".
Field Market Value B must equal the value of all
insurable plants based on the plant price schedule
(or the prices in your catalog/price list) before any
loss occurrence, when Commodity Code equal
Nursery, "0073".

"*" = Output Only
6/29/2015

Page 11 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Field Market Value B for CAT and Buy-up by Share
(Unit Division Code = S) must be the value of this
field for each individual record when Commodity
Code equal Nursery, "0073".

P22

26

Unit Value Before Loss

Numeric

9

999999999

Field Market Value B must equal the value from
item 7 of the Rehab worksheet when Insurance
Option Code List equals Rehab Endorsement,
"RH".
Unit Value Before Loss is Required when
Commodity Code equals Clams, "0116".
Unit Value Before Loss must be empty when
Commodity Code does not equal Clams, "0116".
Unit Value Before Loss must be the same within
the same Claim Number and Inventory Inspection
Number when Commodity Code equals Clams,
"0116" and Coverage Type Code equals CAT, "C".
Unit Value Before Loss equals the unit value
before loss in whole dollars for the record when
Commodity Code equal Clams, "0116".

"*" = Output Only
6/29/2015

Page 12 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Unit Value Before Loss must be between 1 and
999999999 when Unit Value Before Loss exists.
Unit Value Before Loss must be equal across all
Inventory Loss Detail, "P22" records with the
same AIP Policy Producer Key, Commodity Year,
Claim Number, Inventory Inspection Number and
Basic Unit Number when the Commodity Code
equals Clams, "0116" and the Unit Structure Code
equals Basic Unit, "BU" and the Coverage Type
Code equals Catastrophic, "C".

P22

27

Unit Value After Loss

Numeric

9

999999999

Unit Value After Loss is Required when
Commodity Code equals Clams, "0116".
Unit Value After Loss must be empty when
Commodity Code does not equal Clams, "0116".
Unit Value After Loss must be the same within the
same Claim Number and Inventory Inspection
Number when Commodity Code equals Clams,
"0116" and Coverage Type Code equals
Catastrophic, "C".

"*" = Output Only
6/29/2015

Page 13 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Unit Value After Loss equals the unit value after
loss in whole dollars for the record when
Commodity Code equal Clams, "0116".
Unit Value After Loss must be between 0 and
999999999 when Unit Value After Loss exists.
Unit Value After Loss must be equal across all
Inventory Loss Detail, "P22" records with the
same AIP Policy Producer Key, Commodity Year,
Claim Number, Inventory Inspection Number and
Basic Unit Number when the Commodity Code
equals Clams, "0116" and the Unit Structure Code
equals Basic Unit, "BU" and the Coverage Type
Code equals Catastrophic, "C".

P22

28

Occurrence Deductible Amount

Numeric

9

999999999

Occurrence Deductible Amount must be the same
within the same Claim Number and Inventory
Inspection Number when Commodity Code equals
Clams, "0116" and Coverage Type Code equals
Catastrophic, "C".
Occurrence Deductible Amount must be greater
than or equal to "0" when Occurrence Deductible
Amount exists.

"*" = Output Only
6/29/2015

Page 14 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Occurrence Deductible Amount must be equal
across all Inventory Loss Detail, "P22" records
with the same AIP Policy Producer Key,
Commodity Year, Practice Code, Claim Number,
Inventory Inspection Number and Basic Unit
Number when the Commodity Code equals
Nursery, "0073" and the Unit Structure Code
equals Basic Unit, "BU", the Unit Division Code
equals Units by Share, "S" and Insurance Option
Code List does not contain "RH".
Occurrence Deductible Amount must be equal
across all Inventory Loss Detail, "P22" records
with the same AIP Policy Producer Key,
Commodity Year, Claim Number, Inventory
Inspection Number and Basic Unit Number when
the Commodity Code equals Clams, "0116" and
the Unit Structure Code equals Basic Unit, "BU"
and the Coverage Type Code equals Catastrophic,
"C".

"*" = Output Only
6/29/2015

Page 15 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Occurrence Deductible Amount when populated,
and with a Commodity Code equal to Nursery,
"0073" must equal the lesser of Field Market
Value A * (1.000 - Coverage Level Percent ) *
Under Reporting Factor OR Commodity Year
Deductible Amount for Under Reporting.
Occurrence Deductible Amount when populated,
and with a Commodity Code equal to Nursery,
"0073" must equal lesser of: Field Market Value A
* (1.000 - Coverage Level Percent) * (1 + Over
Reporting Factor) OR Commodity Year Deductible
Amount for Over Reporting.
Occurrence Deductible Amount when populated,
and with a Commodity Code equal to Clams,
"0116" must equal lesser of: Round(Unit Value
Before Loss * (1 - Coverage Level Percent) * Over
Under Reporting Factor, 0) or Commodity Year
Deductible Amount.

"*" = Output Only
6/29/2015

Page 16 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Occurrence Deductible Amount for Over
Reporting when the Commodity Code equals
Nursery, "0073" and the Unit Division Code equals
"S" must equal lesser of: Sum of all Inventory
Loss Detail, "P22" records for the same AIP Policy
Producer Key, Commodity Year, Practice Code,
Claim Number, Inventory Inspection Number, and
Basic Unit Number (Round (Field Market Value A
* (1 - Coverage Level Percent) * (1 + Over Under
Reporting Factor), 0)) or Sum across all Inventory
Loss Detail, "P22" records for the same AIP Policy
Producer Key, Commodity Year, Practice Code,
Claim Number, Inventory Inspection Number, and
Basic Unit Number (Commodity Year Deductible
Amount).

"*" = Output Only
6/29/2015

Page 17 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Occurrence Deductible Amount for Under
Reporting factor when the Commodity Code
equals Nursery, "0073" and the Unit Division Code
equals "S" must equal the lesser of the Sum
across all Inventory Loss Detail, "P22" records for
the same AIP Policy Producer Key, Commodity
Year, Practice Code, Claim Number, Inventory
Inspection Number, and Basic Unit Number
(Round (Field Market Value A * (1 - Coverage
Level Percent) * Over Under Reporting Factor, 0))
or the Sum across all Inventory Loss Detail, "P22"
records for the same AIP Policy Producer Key,
Commodity Year, Practice Code, Claim Number,
Inventory Inspection Number, and Basic Unit
Number (Commodity Year Deductible Amount).

P22

29

"*" = Output Only
6/29/2015

Insured Share Percent

Numeric

5

Page 18 of 27

9.999

Y

If previous losses have occurred then Occurrence
Deductible Amount may be less than the results
as covered above.
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 Loss Detail
P22

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 1 when
Insured Share Percent exists and the Uninsurable
SBI Flag equals Yes, "Y".
Insured Share Percent must be equal across all
Inventory Loss Detail, "P22" records with the
same AIP Policy Producer Key, Commodity Year,
Practice Code, Claim Number, Inventory
Inspection Number and Basic Unit Number when
the Commodity Code equals Nursery, "0073" and
the Unit Structure Code equals Basic Unit, "BU",
the Unit Division Code equals Units by Share, "S"
and Insurance Option Code List does not contain
"RH".

P22

30

"*" = Output Only
6/29/2015

AIP Indemnity Amount

Numeric

11

Page 19 of 27

S9999999999

Y

Insured Share Percent must be equal across all
Inventory Loss Detail, "P22" records with the
same AIP Policy Producer Key, Commodity Year,
Claim Number, Inventory Inspection Number and
Basic Unit Number when the Commodity Code
equals Clams, "0116" and the Unit Structure Code
equals Basic Unit, "BU" and the Coverage Type
Code equals Catastrophic, "C".
AIP Indemnity Amount must equal the RMA
calculated Indemnity Amount.

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
AIP Indemnity Amount must be the same within
the same Claim Number and Inventory Inspection
Number when Commodity Code equals Clams,
"0116" and Coverage Type Code equals
Catastrophic, "C".

P22

31

Adjuster Signature Date

Date

8

CCYYMMDD

P22

32

Notice of Loss Date

Date

8

CCYYMMDD

P22

33

Insured Claim Signature Date

Date

8

CCYYMMDD

"*" = Output Only
6/29/2015

Page 20 of 27

Y

Y

Adjuster Signature Date must equal the date the
Adjuster settled the claim, except when Claim
Process Code equals Simplified Claim, "S" or SelfCertified Replant Claim, "R"; otherwise, empty.
Adjuster Signature Date must be less than Inactive
Date on the Adjuster, "P56" record when the
Inactive Date exists.
Notice of Loss Date must not be greater than the
Batch Received Date.
Insured Claim Signature Date is the date that the
Insured signed the claim.

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

P22

34

Large Claim Code

Character

1

Large Claim Code must equal AIP notified RMA of
excessive Indemnity and RMA did not participate
in loss determinations, "N" or RMA participated in
loss determinations, "R" when the record is part
of a potential claim on the eligible crop insurance
contract, which is likely to exceed $500,000;
otherwise, empty.

P22

35

Settlement Flag

Character

1

Settlement Flag must equal Yes, "Y" if there is a
Settlement or Finding; otherwise, empty.
Settlement Flag is required when the record exists
in the Settlement table.

P22

36

Rehabilitation Plant Amount

Numeric

10

P22

37

Insurance Option Code List

Character

29

"*" = Output Only
6/29/2015

Page 21 of 27

9999999999

Rehabilitation Plant Amount is Required, must be
greater than zero and must equal the dollar value
amount of the plants to be rehabilitated when the
Insurance Option Code List contains Rehab
Endorsement, "RH"; otherwise empty.
Insurance Option Code List must be valid; edit
with Option Rate ADM, "A01060".

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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

P22

38

Multiple Rehab Payment Flag

Character

1

Y

Multiple Rehab Payment Flag is Required when
Commodity Code equals Nursery, "0073" and
must equal Yes, "Y" when there are Multiple
Rehab Payments, otherwise, No, "N".
Multiple Rehab Payment Flag must be empty
when Commodity Code does not equal Nursery,
"0073".

P22

39

Actual Rehab Amount

Numeric

10

P22

40

Over Under Reporting Factor Code

Character

1

"*" = Output Only
6/29/2015

Page 22 of 27

9999999999

Y

Actual Rehab Amount is Required and equals the
actual dollar amount to rehabilitate plants when
the Insurance Option Code List equals Rehab
Endorsement, "RH".
Over Under Reporting Factor Code must equal
Over Reporting, "O" or Under Reporting, "U".

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Over Under Reporting Factor Code is optional
when Commodity Code equals Nursery, "0073".

P22

*

41

Indemnity Amount

Numeric

10

P22

*

42

Valid Escrow Flag

Character

1

P22

*

43

Eligibility Code

Character

8

P22

*

44

Adjusted Loss Amount

Numeric

10

"*" = Output Only
6/29/2015

Page 23 of 27

S9999999999

9999999999

Over Under Reporting Factor Code must equal
Under Reporting, "U" when Commodity Code
equals Clams, "0116".
Over Under Reporting Factor Code is Required
when Over Under Reporting Factor exists and is
not equal to "1".
The sum of Indemnity Amount for a Claim
Number must equal the Total Disbursement
Amount for the same claim number on the Loss
total "P20" Record.
Valid Escrow Flag is for internal use and will be
Yes. "Y" when the record passed edits necessary
for Escrow Processing; otherwise, No, "N"
indicating the record did not pass the edits for
Escrow Processing.
Eligiblity Code is the returned values from the
Ineligible Tracking System.
Adjusted Loss Amount is the result after Over
Under Reporting Factor has been applied. See
P22 Calculation Exhibit.

Record
Number

Output

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

P22

*

45

P22

*

46

Inventory Loss Detail
P22

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Format

Unadjusted Indemnity Amount

Numeric

10

S9999999999

Preliminary Indemnity Amount

Numeric

10

S9999999999

Field Name

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Unadjusted Indemnity Amount is the result after
Occurrence Deductible Amount has been applied.
See P22 Calculation Exhibit.
Preliminary Indemnity Amount is the lesser of XPS
Effective Insurance Amount or Unadjusted
Indemnity Amount. See P22 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.

49

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

*

50

Batch Number

Numeric

4

9999

P22

*

51

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.

P22

*

52

Process Result Code

Character

1

P22

*

47

Initial Accepted Batch Number

P22

*

48

P22

*

P22

"*" = Output Only
6/29/2015

Page 24 of 27

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

Record
Number

Output

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

"*" = Output Only
6/29/2015

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

Page 25 of 27

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

Record Level Rules

"*" = Output Only
6/29/2015

1

When the COI Questionnaire Completion Date on
the Adjuster, "P56" record is empty, the
associated Production Loss Detail, "P21" and
Inventory Loss Detail, "P22" records will be
rejected.

2

The corresponding Loss Total "P20" record must
be free of errors for this record to be accepted.

3

Unable to perform the Aquaculture Dollar
Indemnity Corporate Calculation, because one or
more of the following fields has failed validation:
Unit Value Before Loss, Unit Value After Loss,
Over Under Reporting Factor, Insured Share
Percent, Commodity Year, Coverage Level Percent

4

If the Insured Claim Signature Date on the
Production Loss Detail, "P22" record is less than
the Inactive Date on the Adjuster, "P56" record
for the Adjuster provided on the Inventory Loss
Detail, "P22" record, the Adjuster will be
accepted.

Page 26 of 27

Record
Number

Output

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Unable to perform the Nursery Indemnity
Corporate Calculation, because one or more of
the following fields has failed validation: Field
Market Value A, Field Market Value B, Over Under
Reporting Factor, Occurrence Deductible Amount,
XPS Effective Insurance Amount, Actual Rehab
Amount, Rehabilitation Plant Amount or Insured
Share Percent.

5

All Inventory Loss Detail, "P22" records for the
corresponding Loss Total "P20" record must be
accepted.
For the P22 record to be accepted there must be
a corresponding P14 record accepted in this
batch.

6

7

"*" = Output Only
6/29/2015

File Type:
Reinsurance Year:
Version:
Release Date:

8

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

9

If Insurance Option Code List from the
corresponding "P13" record contains, "HF", "PE"
or "PO", the Insurance Option Code List on the
"P22" record should also contain "HF", "PE" or
"PO".
Page 27 of 27