AGR & AGR-L Farm Report - Premium Requirements for eDAS - Exhibit 151

June 28, 2007

Exhibit 151-0

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
FARM REPORT/PREMIUM REQUIREMENTS FOR eDAS
Format/Edits

Section/Attribute

PREMIUM

Description/Edit

“PREMIUM” 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 Premium.
The process flag and/or change flag submitted for this section will be inherited
unless otherwise indicated. Example: .

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-0 - 1

RY 2008

June 28, 2007

Exhibit 151-0

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
FARM REPORT/PREMIUM REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

1

1

Y/Y

CON

7

X(07)

2

1

Y/Y

CON

7

X(07)

3

1

Y/Y

REQ

10

X(10)

4

2

Y/Y

REQ

9

X(09)

5

1

Y/Y

REQ

10

X(10)

6

1

Y/Y

REQ

4

9(04)

7

1

Y/Y

REQ

10

9(10)

For a Fiscal Tax year, the month
and year the fiscal year begins,
format MM/YYYY.
For a Fiscal Tax year, the month
and year the fiscal year ends,
format MM/YYYY.
Insured Signature Date of the
farm report. Format
MM/DD/YYYY. Numeric with
slashes. Must have a valid year
(2007 or 2008). Cannot exceed
current date.
Agent ID Code of the agent that
is responsible for this
information and accepted on the
database.
Agent Signature Date of the farm
report. Format MM/DD/YYYY.
Numeric with slashes. Must
have a valid year (2007 or 2008).
Cannot exceed current date.
Consecutive tax year (last year
used), YYYY format.
Income for the tax year.

1

Y/Y

REQ

10

9(10)

Expense for the tax year.

9

1

Y/Y

REQ

4

9(04)

10

1

Y/Y

REQ

10

9(10)

Consecutive tax year, YYYY
format.
Income for the tax year.

1

Y/Y

REQ

10

9(10)

Expense for the tax year.

12

1

Y/Y

REQ

4

9(04)

13

1

Y/Y

REQ

10

9(10)

Consecutive tax year, YYYY
format.
Income for the tax year.

1

Y/Y

REQ

10

9(10)

Expense for the tax year.

15

1

Y/Y

REQ

4

9(04)

16

1

Y/Y

REQ

10

9(10)

Consecutive tax year, YYYY
format.
Income for the tax year.

1

Y/Y

REQ

10

9(10)

Expense for the tax year.

18

1

Y/Y

REQ

4

9(04)

19

1

Y/Y

REQ

10

9(10)

Consecutive tax year, YYYY
format.
Income for the tax year.

8

11

14

17

FCIC-APPENDIX III

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

151-0 - 2

Max
Size

Picture

Description/Edit

RY 2008

June 28, 2007

Exhibit 151-0

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
FARM REPORT/PREMIUM REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

20

1

Y/Y

REQ

10

9(10)

Expense for the tax year.

NA

N/Y

REQ

10

9(10)

NA

N/Y

REQ

10

9(10)

NA

N/Y

REQ

10

9(10)

NA

N/Y

REQ

10

9(10)

1

Y/Y

REQ

6

9.9999

1

Y/Y

REQ

3

9(03)

1

Y/Y

REQ

1

X(01)

1

Y/Y

REQ

10

9(10)

Sum of 5 years of allowable
income.
Sum of 5 years of allowable
expense.
Total allowable income divided
by 5.
Total allowable expense divided
by 5.
Valid payment rates 0.7500 or
0.9000.
Total number of commodities
reported.
If Approved AGR was
determined using alternate
bearing procedures then flag =
‘Y’, else ‘N’.
Sum of commodity values.

NA

N/Y

REQ

5

9.999

30

NA

N/Y

REQ

5

9.999

31

1

Y/Y

REQ

10

9(10)

21
22
23
24
25
26
27

28
29

FCIC-APPENDIX III

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

151-0 - 3

Max
Size

Picture

Description/Edit

According to AGR Standards
Handbook. The factor used to
determine index average AGR.
Default is 1.000.
According to AGR Standards
Handbook. If Approved AGR:
1. = average allowable income
then expense trend factor =
1.000.
2. = indexed average AGR then
expense trend factor ≥ 1.000.
If expense trend factor is <
1.000 then default to 1.000.
3. < average allowable income
then expense trend factor ≤
1.000 (factored down). If
expense trend factor is >
1.000 then default to 1.000.
4. > average allowable income
but < index AGR then
expense trend factor ≥ 1.000
(factored up). If expense
trend factor is < 1.000 then
default to 1.000.
Value will equal average,
indexed, factored down, or
factored up expenses.

RY 2008

June 28, 2007

Exhibit 151-0

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
FARM REPORT/PREMIUM REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

32

1

Y/Y

REQ

10

9(10)

33

1

Y/Y

REQ

10

9(10)

34

1

Y/Y

REQ

10

9(10)

35

NA

N/Y

REQ

6

99.999

NA

N/Y

REQ

5

9.999

NA

N/Y

REQ

4

.999

38

1

Y/Y

REQ

10

9(10)

39

NA

N/Y

REQ

10

9(10)

40

NA

N/Y

CON

1

X(01)

NA
NA

N/Y
N/Y

CON
CON

10
1

9(10)
X(01)

NA
1

N/Y
Y/Y

CON
REQ

10
10

9(10)
9(10)

2

Y/Y

CON

9

X(09)

36
37

41
42
43
44
45

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

Picture

46

2

Y/Y

CON

10

X(10)

47

2

Y/Y

CON

1

X(01)

FCIC-APPENDIX III

151-0 - 4

Description/Edit

Value will equal average AGR,
indexed AGR, or expected
income.
MPCI Liability, must have
MPCI crops listed as commodity
code.
Cannot exceed $6.5 million for
AGR and $1 million for AGR-L
(Liability cap).
Calculated total weighted farm
rate. See Exhibit 151-1.
Calculated diversity factor. See
Exhibit 151-1.
Calculated premium rate. See
Exhibit 151-1.
Edit according to Exhibit 151-1.
If any total premium is less than
$1, round to $1.
Edit according to Exhibit 151-1.
If less than $1.00 round to $1.00.
Additional Subsidy Flag.
Reserved.
Additional Subsidy. Reserved.
State/Private Subsidy Flag.
Reserved.
State/Private Subsidy. Reserved.
Edit according to Exhibit 151-1.
If reviewed, Reviewer SSN.
Matching Reviewer information
must be accepted on the database
before premium 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

RY 2008

June 28, 2007

Exhibit 151-0

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
FARM REPORT/PREMIUM REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

48

2

Y/Y

CON

5

9(05)

49

NA

N/Y

REQ

8

9(08)

50

NA

N/Y

REQ

1

X(01)

51

NA

N/Y

CON

12

9 (09).99

**

52

53

54
55

FCIC-APPENDIX III

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

Picture

**

Y

Description/Edit

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.
For AGR-Lite policy with
livestock commodity.
Approval Number assigned by
UCM.
If transaction accepted, flag = Y.
If rejected, flag = N. If deleted,
flag = D. If cancel, flag = C.
For AGR-Lite policy with
livestock commodity.
Remaining Fiscal Year
Underwriting Capacity at the
time of this premium if the data
passes basic validation.
Excludes this premium if
rejected.
The beginning of commodity
information at a detail level.

NA

Y/Y

REQ

3

9(03)

1

Y/Y

REQ

4

X(04)

1

Y/Y

REQ

1

9(01)

1

Y/Y

REQ

9

9(06).99

151-0 - 5

For AGR/AGR-L, all detail
information must be submitted
each time any information is
updated. The detail section
contains information that’s used
in the validation and
determination of premium.
Commodity Detail Number.
Multiple records with an unique
number. Must be ≥ 1 or ≤ 999.
Commodity code reported on the
farm report. Edit with ADM 9.
Number of years the commodity
was produced in the previous six
insurance years.
Acres, etc. for the commodity.

RY 2008

June 28, 2007

Exhibit 151-0

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
FARM REPORT/PREMIUM REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

56

1

Y/Y

REQ

13

9(10).99

57

1

Y/Y

REQ

2

X(02)

58

1

Y/Y

REQ

8

9999.999

59

1

Y/Y

REQ

10

9(10)

60

1

Y/Y

CON

1

X(01)

61

2

Y/Y

CON

5

9(05)

62

NA

N/Y

REQ

1

X(01)

**

**

Max
Size

Picture

Description/Edit

Yield to be produced in the unit
of measure for the commodity.
Numeric unit of measure (UOM)
for the commodity. See Exhibit
151-1.
Average expected value in the
unit of measure in which the
commodity will be marketed.
Total dollars for the commodity
For AGR, the calculation is
Round (Round (acres_etc *
yield, 1) * expected_value 0).
For AGR-Lite, the calculation is
Round (acres_etc * yield *
expected_value, 0).
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.
End of commodity information
at a detail level.

Notes: SSN of producer, SBI and agent will be validated to Ineligible Tracking System before premium is
accepted.
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).

FCIC-APPENDIX III

151-0 - 6

RY 2008

June 28, 2007

Exhibit 151-0

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR)/LITE (AGR-L)
FARM REPORT/PREMIUM REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

Picture

Description/Edit

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

RY 2008