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?

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

Y

AIP WFRP Indemnity Key must be unique within
the submitted Indemnity, "P23" records.

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/25/2015

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Page 1 of 15

CCYY

Y

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

P23

Output

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

10

Field Name

Insured Loss Signature Date

P23

11

Adjuster Signature Date

P23

12

Claim Number

Data Type

Date

Max
Length

8

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Format

BUS
Key Req?

Insured Loss Signature Date is required and
cannot be greater than the Batch Submission Date
or less than the First Notice of Loss Date.

CCYYMMDD

Date

8

CCYYMMDD

Numeric

8

99999999

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.

Y

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/25/2015

AIP Indemnity Amount

Numeric

11

Page 2 of 15

S9999999999

AIP Indemnity Amount must equal RMA
calculated Indemnity Amount.

Record
Number

Output

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

Field Name

Data Type

Max
Length

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

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Format

9999999999

BUS
Key Req?

Rules
AIP Indemnity Amount must equal zero when
Stage Code, "DC".
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".

P23

18

"*" = Output Only
6/25/2015

Allowable Revenue Insurance Year
Amount

Numeric

11

Page 3 of 15

99999999.99

Allowable Revenue Insurance Year Amount can be
greater than zero when Insurance Plan Code
equal WFRP, "76".

Record
Number

Output

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

Field Name

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Format

BUS
Key Req?

Rules
Allowable Revenue Insurance Year Amount must
be empty when Stage Code is "R" or "DC".

P23

19

Inventory Adjustment Amount

Numeric

11

S9999999999

P23

20

Accounts Receivable Adjustment Amount

Numeric

11

S9999999999

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

P23

21

Market Animal and Nursery Adjustment
Amount

Numeric

11

S9999999999

Market Animal and Nursery Adjustment Amount
for WFRP. The total value of adjustments made
for market animals and nursery on the indemnity
worksheet.
Market Animal and Nursery Adjustment Amount
must be empty when Stage Code is "R" or "DC".

"*" = Output Only
6/25/2015

Page 4 of 15

Record
Number

Output

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

Field Name

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Data Type

Max
Length

Format
S9999999999

P23

22

All Other Adjustment Amount

Numeric

11

P23

23

Stage Code

Character

2

BUS
Key Req?

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

P23

24

First Damage Cause Code

Character

2

First Damage Cause Code cannot equal "00".
First Damage Cause Code must be valid; edit with
the Damage Cause Commodity ICE, "D00077".

P23

25

First Damage Date

Date

8

CCYYMMDD

Y

First Damage Cause Code is optional.
First Damage Cause Code must be empty when
Stage Code, "DC".
First or Second Damage Date must be less than
the First Notice of Loss Date.
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.

"*" = Output Only
6/25/2015

Page 5 of 15

Record
Number

P23

Output

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

26

Field Name

First Damage Percent

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Data Type

Max
Length

Format

BUS
Key Req?

Numeric

4

9.99

Y

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

P23

27

Second Damage Cause Code

Character

2

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.
Second Damage Cause Code is required when
Second Damage Percent exists and Stage Code is
not "DC".

"*" = Output Only
6/25/2015

Page 6 of 15

Record
Number

P23

Output

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

28

Field Name

Second Damage Date

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Data Type

Max
Length

Format

Date

8

CCYYMMDD

BUS
Key Req?

Rules
Second Damage Cause Code must be empty when
Stage Code, "DC".
First or Second Damage Date must be less than
the First Notice of Loss Date.
Second Damage Date must be less than First
Notice Of Loss Date when (Second Damage Date
is greater than or equal to First Damage Date) or
(First Notice Of Loss Date is greater than or equal
to First Damage Date).

P23

29

"*" = Output Only
6/25/2015

Second Damage Percent

Numeric

4

Page 7 of 15

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

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

Format

BUS
Key Req?

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

"*" = Output Only
6/25/2015

Third Damage Date

Date

8

Page 8 of 15

CCYYMMDD

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

Record
Number
P23

Output

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

Field Name
Third Damage Percent

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Data Type

Max
Length

Format

Numeric

4

9.99

P23

33

First Notice of Loss Date

Date

8

CCYYMMDD

P23

34

Last Notice of Loss Date

Date

8

CCYYMMDD

"*" = Output Only
6/25/2015

Page 9 of 15

BUS
Key Req?

Rules
Third Damage Percent must equal ".01" to "0.98"
when the Third Damage Cause Code is not empty.

Y

Third Damage Percent plus First Damage Percent
plus Second Damage Percent must not be greater
than "1.00".
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".

Record
Number

Output

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

P23

Field
Number
35

Field Name
Audit Correction Flag

Data Type

Max
Length

Character

1

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Format

*

36

Unit Deficiency Quantity

Numeric

12

S99999999.99

P23

*

37

Loss Guarantee Amount

Numeric

11

99999999.99

P23

*

38

Preliminary Indemnity Amount

Numeric

11

S9999999999

*

39

"*" = Output Only
6/25/2015

Indemnity Amount

Numeric

Rules
Audit Correction Flag must equal Yes, "Y"
indicating that the Audit is Corrected or No, "N"
indicating the Audit Correction is not applicable.

P23

P23

BUS
Key Req?

11

Page 10 of 15

S9999999999

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

Record
Number

Output

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

P23

*

40

P23

*

P23

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Data Type

Max
Length

Format

Expense Percentage

Numeric

5

9.999

41

Expense Reduction Amount

Numeric

10

9999999999

*

42

Adjusted Revenue Amount

Numeric

10

9999999999

P23

*

43

Revenue to Count Amount

Numeric

11

S9999999999

P23

*

44

Valid Escrow Flag

Character

1

P23

*

45

Initial Accepted Batch Number

Numeric

4

9999

P23

*

46

Initial Accepted Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

"*" = Output Only
6/25/2015

Field Name

Page 11 of 15

BUS
Key Req?

Rules
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.
Expense Reduction Amount determined for
WFRP. See Exhibit P23-1.
Adjusted Revenue Amount for expenses
determined for WFRP.
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.
Initial Accepted Date is the original date 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

P23

*

47

Batch Received Date

P23

*

48

P23

*

P23

*

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Data Type

Max
Length

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

Batch Number

Numeric

4

9999

49

Batch Record ID

Numeric

15

50

Process Result Code

Character

1

"*" = Output Only
6/25/2015

Field Name

Page 12 of 15

Format

BUS
Key Req?

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

Record
Number

Output

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

Field Name

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Format

BUS
Key Req?

Rules

Record Level Rules

1

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.

2

The Indemnity, "P23" record requires a previously
accepted Farm Report, "P19" record.

3

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.
Record must be submitted between 7/1/2014 and
10/12/2019.
The Indemnity, "P23" record will not be accepted
when processing has been suspended on this
record type.

4
5

"*" = Output Only
6/25/2015

Page 13 of 15

Record
Number

Output

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

Field Name

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Format

BUS
Key Req?

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

6

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.

7

8

9

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

10

First Damage Percent + Second Damage Percent +
Third Damage Percent cannot be greater than 1.

11

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.

"*" = Output Only
6/25/2015

Page 14 of 15

Record
Number

Output

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

Field Name

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2016
Version: Approved
Release Date: 7/1/2015

Format

BUS
Key Req?

Rules

12

A P20 record with the same Claim Number must
exist in this batch when Stage Code is not "DC".

13

No corresponding P20 records may be submitted
when Stage Code is "DC".

14

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.

"*" = Output Only
6/25/2015

Page 15 of 15