WFRP Indemnity Record Type 23

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

Data Type

Max
Length

P23

1

AIP Code

Character

2

P23
P23

2
3

Reinsurance Year
Record Type Code

Numeric
Character

4
6

P23

4

AIP Policy Producer Key

Character

P23

5

AIP Insurance In Force Key

Character

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must be "2019".
Record Type Code must be "P23".

Y

Y

Y
Y

Y
Y

15

Y

Y

AIP Policy Producer Key must match the parent
primary Policy Producer, "P10" record.

15

Y

Y

AIP Insurance In Force Key must be unique within
the AIP Policy Producer Key.

Y

AIP WFRP Farm Reports key is the value used to
identify each WFRP Farm Reports, "P19" record
and must be unique within the Reinsurance Year
and the parent Insurance In Force, "P14" record.

P23

6

AIP WFRP Farm Reports Key

Character

15

P23

7

AIP WFRP Indemnity Key

Character

15

P23

8

AIP Adjuster Key

Character

15

P23

9

AIP Employee Key

Character

15

"*" = Output Only
6/28/2018

File Type:
Reinsurance Year:
Version:
Release Date:

Page 1 of 14

CCYY

Y

Y

AIP WFRP Indemnity Key must be unique within
the submitted Indemnity, "P23" records.
AIP Adjuster Key must match the corresponding
Adjuster, "P56" record when AIP Adjuster Key
exists.
AIP Adjuster Key must be empty when AIP
Employee Key exists.
AIP Adjuster Key is required when Stage Code,
"DC".
AIP Employee Key is required when AIP Adjuster
Key is empty.

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

P23

10

Insured Loss Signature Date

Date

8

CCYYMMDD

P23

11

Adjuster Signature Date

Date

8

CCYYMMDD

P23

12

Claim Number

Numeric

8

99999999

BUS
Key Req?

Y

Delimited
2019
Approved
7/1/2018

Rules
AIP Employee Key must be valid; edit with ODS,
Employee ODS "ODS54" record.
AIP Employee Key must be empty when AIP
Adjuster Key exists.
Insured Loss Signature Date is required and
cannot be greater than the Batch Submission
Date or less than the First Notice of Loss Date.
Insured Loss Signature Date must be empty when
Stage Code, "DC".
Adjuster Signature Date is required.
Adjuster Signature Date must be less than or
equal to the Batch Received Date.
Adjuster Signature Date must be less than the
Inactive Date from the Adjuster, "P56" record
when the Inactive Date exists.
Adjuster Signature Date is required when Stage
Code, "DC".
Claim Number must equal the Claim Number
from the Loss Total, "P20" record.
Claim Number is required when Stage Code, "DC".

P23

13

"*" = Output Only
6/28/2018

AIP Indemnity Amount

Numeric

11

Page 2 of 14

S9999999999

AIP Indemnity Amount must equal RMA
calculated Indemnity Amount.
AIP Indemnity Amount must equal zero when
Stage Code, "DC".

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

P23

14

Large Claim Code

Character

1

P23

15

Settlement Flag

Character

1

P23

16

Claim Process Code

Character

1

P23

17

Allowable Expenses Insurance Year
Amount

Numeric

10

9999999999

P23

18

Allowable Revenue Insurance Year
Amount

Numeric

11

99999999.99

"*" = Output Only
6/28/2018

Page 3 of 14

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Large Claim Code must be valid; edit with Large
Claim ICE "D00102".
Large Claim Code must be empty when Stage
Code, "DC".
Settlement Flag equals Yes, "Y" if there is a
Settlement or Finding; otherwise, empty.
Settlement Flag is required when the record exists
in the Settlement table.
Settlement Flag must be empty when Stage Code,
"DC".
Claim Process Code must be valid; edit with the
Claim Process ICE, "D00071".
Claim Process Code must be empty when Stage
Code is "DC".
Allowable Expenses for Insurance Year Amount
for this WFRP indemnity.
Allowable Expenses for Insurance Year Amount
must be empty when Stage Code is "R" or "DC".
Allowable Revenue Insurance Year Amount can be
greater than zero when Insurance Plan Code
equal WFRP, "76".
Allowable Revenue Insurance Year Amount must
be empty when Stage Code is "R" or "DC".

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

P23

19

Inventory Adjustment Amount

Numeric

11

S9999999999

P23

20

Accounts Receivable Adjustment Amount

Numeric

11

S9999999999

P23

21

Market Animal and Nursery Adjustment
Amount

Numeric

11

S9999999999

"*" = Output Only
6/28/2018

Page 4 of 14

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Allowable Revenue Insurance Year Amount is
required when Stage Code is not equal to "R" or
"DC". If no value to report zero fill.
Inventory Adjustment Amount for WFRP. The
total value of adjustments made for the current
insurance year as reported on the indemnity
worksheet.
Inventory Adjustment Amount must be empty
when Stage Code is "R" or "DC".
Inventory Adjustment Amount is required when
Stage Code is not equal to "R" or "DC". If no value
to report zero fill.
Accounts Receivable Adjustment Amount for
WFRP. The total value of adjustments made for
the current insurance year as reported on the
indemnity worksheet.
Accounts Receivable Adjustment Amount must be
empty when Stage Code is "R" or "DC".
Accounts Receivable Adjustment Amount is
required when Stage Code is not equal to "R" or
"DC". If no value to report zero fill.
Market Animal and Nursery Adjustment Amount
for WFRP. The total value of adjustments made
for market animals and nursery on the indemnity
worksheet.

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Market Animal and Nursery Adjustment Amount
must be empty when Stage Code is "R" or "DC".
Market Animal and Nursery Adjustment Amount
is required when Stage Code is not equal to "R" or
"DC". If no value to report zero fill.

P23

22

All Other Adjustment Amount

Numeric

11

P23

23

Stage Code

Character

2

P23

24

First Damage Cause Code

Character

2

S9999999999

All Other Adjustment Amount for WFRP. The
total value of other adjustments made on the
indemnity worksheet.
All Other Adjustment Amount must be empty
when Stage Code is "R" or "DC".
All Other Adjustment Amount is required when
Stage Code is not equal to "R" or "DC". If no value
to report zero fill.
Stage code for replant payment. Must equal 'R' if
this is a replant payment and P23A is submitted.
Stage Code for denied claim must equal "DC".
First Damage Cause Code cannot equal "00".
First Damage Cause Code must be valid; edit with
the Damage Cause Commodity ICE, "D00077".
First Damage Cause Code is optional.
First Damage Cause Code must be empty when
Stage Code, "DC".

"*" = Output Only
6/28/2018

Page 5 of 14

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

P23

25

First Damage Date

P23

26

First Damage Percent

P23

27

"*" = Output Only
6/28/2018

Second Damage Cause Code

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

Date

8

CCYYMMDD

Numeric

4

9.99

Character

2

Page 6 of 14

BUS
Key Req?
Y

Y

Delimited
2019
Approved
7/1/2018

Rules
First Damage Date must be less than or equal to
Adjuster Signature Date when Second Damage
Date is greater than Adjuster Signature Date.
First Damage Date is optional.
First Damage Date must be empty when Stage
Code, "DC".
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 is required when First
Damage Cause Code exists and First Damage
Cause Code is not equal to "00".
First Damage Percent must be empty when Stage
Code, "DC".
Second Damage Cause Code cannot equal "00"
when Second Damage Cause Code exists.
Second Damage Cause Code must be valid; edit
with the Damage Cause Commodity ICE,
"D00077".
Second Damage Cause Code must be empty when
Second Damage Percent is empty.

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Second Damage Cause Code is required when
Second Damage Percent exists and Stage Code is
not "DC".
Second Damage Cause Code must be empty when
Stage Code, "DC".

P23

P23

28

29

"*" = Output Only
6/28/2018

Second Damage Date

Second Damage Percent

Date

8

Numeric

4

Page 7 of 14

CCYYMMDD

9.99

Second Damage Date must be less than or equal
to Batch Received Date.
Second Damage Date is required when Second
Damage Percent exists and Stage Code is not
"DC".
Second Damage Date must be empty when
Second Damage Percent is empty or Stage Code
equals "DC".
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".
Second Damage Percent is required when Second
Damage Cause Code exists and Stage Code is not
"DC".
Second Damage Percent must be empty when
Stage Code, "DC".

Record
Number
P23

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number
30

Field Name
Third Damage Cause Code

Data Type

Max
Length

Character

2

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Third Damage Cause Code cannot equal "00"
when Third Damage Cause Code exists.
Third Damage Cause Code must be valid; edit with
the Damage Cause Commodity ICE, "D00077".

P23

31

Third Damage Date

P23

32

Third Damage Percent

Date

8

CCYYMMDD

Numeric

4

9.99

Third Damage Cause Code must equal zero when
First Damage Percent equal "1.00".
Third Damage Cause Code must be empty when
Third Damage Percent is empty.
Third Damage Cause Code is required when Third
Damage Percent exists.
Third Damage Cause Code must be empty when
Stage Code, "DC".
Third Damage Date is required when Third
Damage Percent exists.
Third Damage Date must be empty when Third
Damage Percent is empty.
Third Damage Date must be empty when Stage
Code, "DC".
Third Damage Percent must equal ".01" to "0.98"
when the Third Damage Cause Code is not empty.
Third Damage Percent plus First Damage Percent
plus Second Damage Percent must not be greater
than "1.00".

"*" = Output Only
6/28/2018

Page 8 of 14

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

P23

33

First Notice of Loss Date

Date

8

CCYYMMDD

P23

34

Last Notice of Loss Date

Date

8

CCYYMMDD

P23

35

Audit Correction Flag

Character

1

36

Unit Deficiency Quantity

Numeric

12

P23

*

"*" = Output Only
6/28/2018

Page 9 of 14

S99999999.99

BUS
Key Req?

Y

Delimited
2019
Approved
7/1/2018

Rules
Third Damage Percent is required when Third
Damage Cause Code exists.
Third Damage Percent must be empty when Stage
Code, "DC".
First Notice of Loss Date must not be greater than
the Batch Received Date.
First Notice of Loss Date must equal the date the
insured provided the first notice of loss.
First Notice of Loss Date is required when Stage
Code is empty.
First Notice of Loss Date is required when Stage
Code, "DC".
Last Notice of Loss Date must not be greater than
the Batch Received Date.
Last Notice of Loss Date must be empty when
Stage Code, "DC".
Audit Correction Flag must equal Yes, "Y"
indicating that the Audit is Corrected or No, "N"
indicating the Audit Correction is not applicable.
Audit Correction Flag must be empty when Stage
Code, "DC".
Unit Deficiency Quantity less than or equal to zero
indicates that the Indemnity is less than or equal
to zero.

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

P23

*

37

Loss Guarantee Amount

Numeric

11

99999999.99

P23

*

38

Preliminary Indemnity Amount

Numeric

11

S9999999999

P23

*

39

Indemnity Amount

Numeric

11

S9999999999

P23

*

40

Expense Percentage

Numeric

5

9.999

P23

*

41

Adjusted Revenue Amount

Numeric

10

9999999999

"*" = Output Only
6/28/2018

Page 10 of 14

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Unit Deficiency Quantity not applicable when
Stage Code, "DC".
Revenue Guarantee for coverage level
determined for WFRP.
Loss Guarantee Amount not applicable when
Stage Code, "DC".
Preliminary Indemnity Amount is the calculated
Indemnity.
Preliminary Indemnity Amount must be zero
when Stage Code equal "R" or "DC".

Y

Indemnity Amount is the total of all Indemnity,
"P23", Indemnity Fields for a given Claim Number
and must equal the sum of the Total fields for all
of the corresponding Loss Total "P20" records.
Indemnity Amount is the sum of all P23A
Indemnity Detail Amount when Stage Code equal
"R".
Indemnity Amount must be zero when Stage
Code equal "DC".
Expense Percentage determined for WFRP. See
Exhibit P23-1.
Adjusted Revenue Amount for expenses
determined for WFRP.

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

P23

*

42

P23

*

P23

File Type:
Reinsurance Year:
Version:
Release Date:

Data Type

Max
Length

Format

Revenue to Count Amount

Numeric

11

S9999999999

43

Valid Escrow Flag

Character

1

*

44

Initial Accepted Batch Number

Numeric

5

99999

P23

*

45

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.

P23

*

46

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

P23

*

47

Batch Number

Numeric

5

99999

P23

*

48

Batch Record ID

Numeric

15

P23

*

49

Process Result Code

Character

1

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.
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/28/2018

Field Name

Page 11 of 14

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Revenue to Count Amount as determined for
WFRP.
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.
Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules

Record Level Rules
When the COI Questionnaire Completion Date on
the Adjuster, "P56" record or on the Employee,
"P54" record is empty, the associated Production
Loss Detail, "P21", Inventory Loss Detail, "P22",
and Indemnity, "P23" records will be rejected.

1

The Indemnity, "P23" record requires a previously
accepted Farm Report, "P19" record.
The Indemnity, "P23" record date entries in field
31, First Notice of Loss Date and field 32, Last
Notice of Loss Date are required only for the
cause(s) of loss reported on the record. One of
the Dates of Damage must be greater than or
equal to field 31, First Notice of Loss Date.
The Indemnity, "P23" record will not be accepted
when processing has been suspended on this
record type.
A Related Loss Total, "P20" record must be free of
errors for the Indemnity, "P23" record to be
accepted when Stage Code is not "DC".

2

3

4

5

"*" = Output Only
6/28/2018

Page 12 of 14

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
All Indemnity, "P23" records for the
corresponding Loss Total, "P20" record must be
accepted when Stage Code is not "DC".
For the P23 record to be accepted there must be
a corresponding P14 record accepted in this
batch.

6

7

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

First Damage Percent + Second Damage Percent +
Third Damage Percent cannot be greater than 1.
If the Insured Loss Signature Date on the
Indemnity, “P23” record is less than the Inactive
Date on the Adjuster, “P56” record for the
Adjuster provided on the Indemnity, “P23”
record, the Adjuster will be accepted.
A P20 record with the same Claim Number must
exist in this batch when Stage Code is not "DC".
No corresponding P20 records may be submitted
when Stage Code is "DC".

10

11
12

"*" = Output Only
6/28/2018

File Type:
Reinsurance Year:
Version:
Release Date:

Page 13 of 14

Record
Number

Output

Application Source:
File Group:
Record Name: WFRP Indemnity
Record Code: P23
Field
Number

Field Name

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
For a denied WFRP Indemnity, "P23" Record
being submitted to RMA the following fields must
be populated: Fields 1 - 8 (AIP Code, Reinsurance
Year, Record Type Code, AIP Policy Producer Key,
AIP Insurance In Force Key, AIP Farm Report Key,
AIP Indemnity Key, AIP Adjuster Key), Adjuster
Signature Date, Claim Number, Stage Code (DC =
Any claim inspected by the adjuster and denied,
resulting in no indemnity payment), and First
Notice of Loss Date.

13

"*" = Output Only
6/28/2018

File Type:
Reinsurance Year:
Version:
Release Date:

Page 14 of 14