AGR & AGR-L Indemnity - Exhibit 151-2

June 28, 2007

Exhibit 151-2

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
ACTUAL COMMODITY REPORT/INDEMNITY REQUIREMENTS FOR eDAS
Format/Edits

Section/Attribute

INDEMNITY

Description/Edit

“INDEMNITY” is the title of this section. It identifies the opening and closing
of this xml section. This document provides additional reporting requirements
of data under this section.
Crop Policy precedes Indemnity.
The process flag and/or change flag submitted for this section will be inherited
unless otherwise indicated. Example: .
Reporting of Indemnity Detail information required for AGR-L (plan 61)
and optional for AGR (plan 63).

CHANGE_FLAG (ATTRIBUTE)

If Process Flag = 2 or 5 certain data will be allowed to change after initial
acceptance. Tags have been identified by flags below. Flag of ‘1’ will only be
allowed to change data identified by ‘1’. Flag of ‘2’ will be allowed to change
data identified by ‘1 or 2’. Flag of ‘3’ will be allowed to change any data.
Valid flags:
1 = general
2 = company approval
3 = RMA approval
Change flag will default to 2 unless otherwise indicated.

PROCESS_FLAG (ATTRIBUTE)

Valid flags:
1 = original
2 = modify
3 = delete
4 = validate (original)
5 = validate (modify)
6 = quote (only applicable for premium)
7 = retrieve
8 = cancel (only applicable for Livestock crop policy)
9 = re-instate (only applicable for Livestock crop policy)
Process flag will default to 1 unless otherwise indicated.

FCIC-APPENDIX III

151-2 - 1

RY 2008

June 28, 2007

Exhibit 151-2

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
ACTUAL COMMODITY REPORT/INDEMNITY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

1

2

Y/Y

REQ

8

9(08)

2

2

Y/Y

REQ

10

X(10)

3

2

Y/Y

REQ

9

X(09)

4

2

Y/Y

REQ

10

X(10)

5

2

Y/Y

REQ

10

X(10)

6

2

Y/Y

CON

10

X(10)

7

2

Y/Y

REQ

10

X(10)

8

2

Y/Y

REQ

2

9(02)

9

2

Y/Y

REQ

4

9.99

FCIC-APPENDIX III

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

151-2 - 2

Max
Size

Picture

Description/Edit

Claim number assigned by
company and has a matching
Disbursement.
Insured Signature Date for this
indemnity. Format
MM/DD/YYYY. Numeric with
slashes. Cannot exceed current
date.
Adjuster ID Code of the adjuster
that is responsible for this
information and accepted on the
database.
Adjuster Signature Date for this
indemnity. Format
MM/DD/YYYY. Numeric with
slashes. Cannot exceed current
date.
First Notice of Loss Date for this
indemnity. Format
MM/DD/YYYY. Numeric with
slashes. Cannot exceed current
date.
Last Notice of Loss Date for this
indemnity. Format
MM/DD/YYYY. If more than
one notice of loss is given this
field will be used to submit the
last notice of loss date. Numeric
with slashes. Cannot exceed
current date.
Primary Date of Damage for this
indemnity. If a specific day is
not reported use ‘01’ as the day
of the damage, format is
MM/01/YYYY. Numeric with
slashes. Cannot exceed current
date. If cause of loss = ‘13, 14,
21, 41, 42, 51, 63, 64, 91, 92, 97,
or 98’ enter MM/DD/YYYY
Primary Cause of Loss for this
indemnity. Must be a valid
cause of loss for the insurance
plan. See exhibit 21-2.
Primary Percent for this
indemnity. Must be zero if the
primary cause = zero.
Otherwise, must be 0.50 – 1.00.

RY 2008

June 28, 2007

Exhibit 151-2

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
ACTUAL COMMODITY REPORT/INDEMNITY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

10

2

Y/Y

OPT

10

X(10)

11

2

Y/Y

CON

2

9(02)

12

2

Y/Y

REQ

10

9(10)

NA

N/Y

REQ

5

9.999

NA

N/Y

REQ

4

.999

NA

N/Y

REQ

10

9(10)

NA

N/Y

REQ

10

9(10)

NA

N/Y

REQ

10

9(10)

2

Y/Y

REQ

10

9(10)

2

Y/Y

REQ

10

(+/-)
9(10)

20

2

Y/Y

REQ

10

(+/-)
9(10)

21

NA

N/Y

REQ

10

(+/-)
9(10)

13
14
15
16
17
18
19

FCIC-APPENDIX III

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

151-2 - 3

Max
Size

Picture

Description/Edit

Secondary Date of Damage for
this indemnity. Optional if
primary percent < 1.00. If a
specific day is not reported use
‘01’ as the day of the damage,
format is MM/01/YYYY.
Numeric with slashes. Cannot
exceed current date. If
secondary cause of loss = ‘13,
14, 21, 41, 42, 51, 63, 64, 91, 92,
97, or 98’ enter MM/DD/YYYY.
Secondary Cause of Loss for this
indemnity. Must be a valid
cause of loss for the insurance
plan. Required if entry for
secondary date of damage.
See exhibit 21-2.
Expenses for Insurance Year for
this indemnity.
Calculated Expense Percentage.
See Exhibit 151-3.
Calculated Expense Reduction
Percentage. See Exhibit 151-3.
Expense Reduction Dollar
Amount. See Exhibit 151-3.
Adjusted AGR for Expenses.
See Exhibit 151-3.
Adjusted AGR for Coverage
Level. See Exhibit 151-3.
Revenue to Count for the
insurance year.
Inventory Adjustment. The total
dollar value of adjustment(s)
made for the current insurance
year as reported on the
indemnity worksheet. Only the
negative symbol ( - ) will appear
if applicable.
Accounts Receivable
Adjustment. The total dollar
value of adjustment(s) made for
the current insurance year as
reported on the indemnity
worksheet. Only the negative
symbol ( - ) will appear if
applicable.
Adjustment to Revenue to
Count. Only the negative
symbol ( - ) will appear if
applicable. See Exhibit 151-3.
RY 2008

June 28, 2007

Exhibit 151-2

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
ACTUAL COMMODITY REPORT/INDEMNITY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

22

NA

N/Y

REQ

10

9(10)

2

Y/Y

REQ

10

9(10)

24

2

Y/Y

CON

9

X(09)

25

2

Y/Y

CON

10

X(10)

26

2

Y/Y

CON

1

X(01)

27

2

Y/Y

CON

5

9(05)

28

2

Y/Y

CON

1

X(01)

29

2

Y/Y

CON

1

X(01)

30

NA

N/Y

REQ

1

X(01)

23

FCIC-APPENDIX III

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

151-2 - 4

Max
Size

Picture

Description/Edit

Revenue Deficiency. See
Exhibit 151-3.
Net indemnity amount payable.
Cannot be negative or greater
than Adjusted AGR for coverage
level times payment rate. Edit
according to Exhibit 151-3.
If reviewed, Reviewer SSN.
Matching Reviewer information
must be accepted on the database
before indemnity will be
accepted.
Reviewer Signature Date if
reviewer SSN has been provided.
Format MM/DD/YYYY.
Numeric with slashes. Cannot
exceed current date.
Error detected flag if reviewer
SSN has been provided.
Valid flags:
Y = Yes
N= No
Authorization Number provided
by Reinsurance Services
Division (RSD) approving the
original, change, or deletion.
Change Flag must = 3 and
Process Flag must = 1, 2, 3, 4, or
5. If changing a “Key” field
with Level of Change = 2,
Authorization Number assigned
by administrative screen and
Change Flag must = 2.
Large Claim Flag required if
indemnity exceeds $500,000.
Valid flags:
N = AIP notified RMA of
large claim;
R = RMA participated or
reviewed large claim.
Settlement Flag required if claim
settlement included arbitration,
mediation or other process.
Valid flags:
A = settlement by arbitration
M = settlement by mediation
O = settlement by other process
If transaction accepted, flag = Y.
If rejected, flag = N. If deleted,
flag = D. If cancel, flag = C.
RY 2008

June 28, 2007

Exhibit 151-2

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
ACTUAL COMMODITY REPORT/INDEMNITY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

Key

**

**

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

Picture

Description/Edit

The beginning of commodity
information at a detail level.
For AGR-L (plan 61), all detail
information must be submitted
each time any information is
updated.
For AGR (plan 63), this
information is not required to be
submitted (optional). If it is
submitted, it must be complete
according to the requirements
below.

31

32
33
34

35

NA

Y/Y

REQ

3

9(03)

2

Y/Y

REQ

4

X(04)

2
2

Y/Y
Y/Y

REQ
REQ

9
13

9(06).99
9(10).99

2

Y/Y

REQ

2

X(02)

36

2

Y/Y

REQ

8

9999.999

37

2

Y/Y

REQ

10

9(10)

1

Y/Y

CON

1

X(01)

39

2

Y/Y

CON

5

9(05)

40

NA

N/Y

REQ

1

X(01)

38

FCIC-APPENDIX III

Y

151-2 - 5

Commodity Detail Number.
Multiple records with an unique
number. Must be ≥ 1 or ≤ 999.
Commodity code reported on the
actual commodity report
Acres, etc. for the commodity.
Yield produced in the unit of
measure for the commodity.
Numeric unit of measure (UOM)
for the commodity. See Exhibit
151-1.
Average value in the unit of
measure in which the commodity
was marketed.
Total dollars for the commodity
according to crop handbook.
If commodity value was based
on weighted average then flag =
‘Y’.
Authorization Number provided
by Reinsurance Services
Division (RSD) approving the
original, change, or deletion.
Change Flag must = 3 and
Process Flag must = 1, 2, 3, 4, or
5. If changing a “Key” field
with Level of Change = 2,
Authorization Number assigned
by administrative screen and
Change Flag must = 2.
If transaction accepted, flag = Y.
If rejected, flag = N. If deleted,
flag = D. If cancel, flag = C.
RY 2008

June 28, 2007

Exhibit 151-2

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
ACTUAL COMMODITY REPORT/INDEMNITY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

Key

**

**

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

Picture

Description/Edit

End of commodity information
at a detail level.

Notes: Information regarding column headers:
1) ‘Tag’ identifies the naming convention used in creation of XML.
2) ‘Key’ identifies the tags that are key to the validation/storage of data.
3) ‘Level of Change’ identifies the data that is allowed to change and at what level according to Change
Flag.
4) ‘IN/OUT’ identifies the direction of data, IN for input and OUT for output with flags ‘N’ (NO) and ‘Y’
(YES).
5) ‘REQ/OPT/CON’ identifies if the data is required (REQ), optional (OPT), or conditional (CON). If
optional or conditional and there is no data to report the tag is not used.
6) ‘Max Size’ is the maximum size of data allowed for that tag.
7) ‘Picture’ identifies the type of data expected. If field identified with ( + / - ) then it’s a signed field. If
negative symbol ( - ) is applicable it will appear at the beginning of the value. Example: 23.24 (value
as positive) and –23.24 (value as negative).
8) ‘Description/Edit’ gives additional information.
On an update, only the key fields that define the sections are required plus any changed fields or new
sections.

FCIC-APPENDIX III

151-2 - 6

RY 2008