P22 Inventory Loss Record

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

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

9

Claim Number

Numeric

8

P22

10

First Damage Cause Code

Character

2

P22

11

First Damage Date

Date

8

"*" = Output Only
2/17/2012

Page 1 of 13

CCYY

Y

Y

Y
Y

Y
Y
Y

Y
99999999

Rules
AIP Code must be valid; edit with AIP ICE
"D00100".
Reinsurance Year must be "2012".
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 must be valid edit with
the Damage Cause Commodity ICE, "D00077".

CCYYMMDD

Y

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

Record
Number
P22

Output

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

Field
Number
12

Field Name
First Damage Percent

P22

13

Second Damage Cause Code

P22

14

Second Damage Date

P22

15

P22

Inventory Loss Detail
P22

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

Data Type

Max
Length

Format

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".
Second Damage Cause Code must be valid edit
with the Damage Cause Commodity ICE,
"D00077".
Second Damage Date must be less than the First
Notice of Loss Date.
Second Damage Percent must equal ".01" to
"0.99" when the Second Damage Cause Code is
not empty.
Second Damage Percent plus First Damage
Percent plus Third Damage Percent cannot be
greater than "1.00".

Character

2

Date

8

CCYYMMDD

Second Damage Percent

Numeric

4

9.99

16

Third Damage Cause Code

Character

2

P22

17

Third Damage Date

Date

8

CCYYMMDD

P22

18

Third Damage Percent

Numeric

4

9.99

"*" = Output Only
2/17/2012

Page 2 of 13

BUS
Key Req?

Rules

Third Damage Cause Code must be valid edit with
the Damage Cause Commodity ICE, "D00077".
Third Damage Date is required and must be less
than the First Notice of Loss Date.
Third Damage Percent must equal ".01" to "0.98"
when the Third Damage Cause Code is not empty.

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

P22

19

Inventory Inspection Number

Numeric

2

99

P22

20

Basic Unit Value

Numeric

10

9999999999

P22

21

Effective Insurance Amount

Numeric

10

9999999999

P22

22

XPS Effective Insurance Amount

Numeric

10

9999999999

"*" = Output Only
2/17/2012

Page 3 of 13

BUS
Key Req?

Rules
Third Damage Percent plus Second Damage
Percent plus First Damage Percent cannot be
greater than "1.00".
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
Markey 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".
Effective Insurance Amount equals the remaining
insurance amount after previous losses for the
basic unit when Commodity Code equals Clams,
"0116".
XPS Effective Insurance Amount equals the Basic
Unit Value minus any previous Basic Unit
Indemnities when Commodity Code equals
Nursery, "0073".

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
XPS Effective Insurance Amount for CAT or Buy-up
by Share must have the same value on all records
for the Unit within the same Commodity
Year/Practice Code/Claim and Inventory
Inspection Number.

P22

23

Over Under Reporting Factor

Numeric

5

9.999

Over Under Reporting Factor must equal the
lesser of 1.000 or the Basic Unit Value minus any
previous losses divided by Field Market Value A
when Commodity Code equal Nursery, "0073".
Over Under Reporting Factor for CAT or Buy-up by
Share must have the same value on all records for
the Unit within the same Commodity
Year/Practice Code/Claim and Inventory
Inspection Number.
Over Under Reporting Factor must equal the
value from item 11 of the Rehab worksheet when
Option Code equal Rehab Endorsement, "RH".

"*" = Output Only
2/17/2012

Page 4 of 13

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

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

P22

24

Field Market Value A

Numeric

9

999999999

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".
Field Market Value A for CAT and Buy-up by Share
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".

"*" = Output Only
2/17/2012

Page 5 of 13

Record
Number

P22

Output

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

Field
Number

25

Field Name

Field Market Value B

Inventory Loss Detail
P22

Data Type

Numeric

Max
Length

9

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

Format

999999999

BUS
Key Req?

Rules
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".
Field Market Value B for CAT and Buy-up by Share
must be the value of this field for each individual
record when Commodity Code equal Nursery,
"0073".
Field Market Value B must equal the value from
item 7 of the Rehab worksheet when Option Code
equal Rehab Endorsement, "RH".

P22

26

Unit Value Before Loss

Numeric

9

999999999

Unit Value Before Loss is Required when
Commodity Code equals 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
2/17/2012

Page 6 of 13

Record
Number
P22

Output

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

Field
Number
27

Field Name
Unit Value After Loss

Inventory Loss Detail
P22

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

Data Type

Max
Length

Format

Numeric

9

999999999

BUS
Key Req?

Rules
Unit Value After Loss is Required when
Commodity Code equals Clams, "0116".
Unit Value After Loss must be the samewithin the
same Claim Number and Inventory Inspection
Number when Commodity Code equals Clams,
"0116" and Coverage Type Code equals CAT, "C".
Unit Value After Loss equals the unit value after
loss in whole dollars for the record when
Commodity Code equal Clams, "0116".

P22

28

Occurrence Deductible Amount

Numeric

9

999999999

P22

29

Insured Share Percent

Numeric

5

9.999

"*" = Output Only
2/17/2012

Page 7 of 13

Y

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
CAT, "C".
Insured Share Percent must be greater than zero
and less than or equal to "1.000".

Record
Number

P22

Output

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

Field
Number

30

Field Name

AIP Indemnity Amount

Inventory Loss Detail
P22

Data Type

Numeric

Max
Length

11

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

Format

S9999999999

BUS
Key Req?

Y

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 “Y” and the
Ineligible SBI Share Percent on the Policy
Producer Other Person, “P10B” record is greater
than zero.
AIP Indemnity Amount must equal the RMA
calculated Indemnity Amount.
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 CAT, "C".

P22

P22

31

32

"*" = Output Only
2/17/2012

Adjuster Signature Date

Notice of Loss Date

Date

Date

8

8

Page 8 of 13

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.

CCYYMMDD

CCYYMMDD

Y

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.

Record
Number

P22

Output

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

Field
Number

33

Field Name

Insured Claim Signature Date

Inventory Loss Detail
P22

Data Type

Date

Max
Length

8

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

Format

CCYYMMDD

BUS
Key Req?

Rules
Last Notice of Loss Date must equal zero when
the 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".
Insured Claim Signature Date is the date that the
Insured signed the claim.

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.

P22

36

Rehabilitation Plant Amount

Numeric

10

P22

37

Insurance Option Code List

Character

29

"*" = Output Only
2/17/2012

Page 9 of 13

9999999999

Rehabilitation Plant Amount must equal the
dollar value amount of the plants to be
rehabilitated when Option Code contains Rehab
Endorsement, "RH".
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

P22

38

Multiple Rehab Payment Flag

Character

1

P22

39

Actual Rehab Amount

Numeric

10

P22

40

Over Under Reporting Factor Code

Character

1

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

Format

BUS
Key Req?

Rules
Multiple Rehab Payment Flag must equal Yes, "Y"
when there are Multiple Rehab Payments,
otherwise, No, "N".

9999999999

Actual Rehab Amount equals the actual dollar
amount to rehabilitate plants when Option Code
equals Rehab Endorsement, "RH".
Over Under Reporting Factor Code must equal
Over Reporting, "O" or Under Reporting, "U".
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

"*" = Output Only
2/17/2012

Page 10 of 13

S9999999999

Over Under Reporting Factor Code must equal
Under Reporting, "U" when Commodity Code
equals Clams, "0116".
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.

Record
Number

Output

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

Field
Number

P22
P22
P22
P22

*
*
*
*

43
44

45
46

Field Name
Eligibility Code
Adjusted Loss Amount
Unadjusted Indemnity Amount
Preliminary Indemnity Amount

Data Type

Max
Length

Character
Numeric
Numeric
Numeric

8
10
10
10

Format

BUS
Key Req?

Rules

9999999999
S9999999999
S9999999999

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

*

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

*

47

Initial Accepted Batch Number

P22

*

48

P22

*

P22

P22

P22

Inventory Loss Detail
P22

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

*

52

"*" = Output Only
2/17/2012

Process Result Code

Character

1

Page 11 of 13

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

Field Name

Inventory Loss Detail
P22

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules

Record Level Rules
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.
The corresponding P20 record must be free of
errors for this record to be accepted.
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
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.

"*" = Output Only
2/17/2012

Page 12 of 13

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

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.
All P22 records for the corresponding P20 record
must be accepted.

"*" = Output Only
2/17/2012

Page 13 of 13