AGR & AGR-L Fund Requirement for eDAS - Exhibit 131

June 28, 2007

Exhibit 131

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR/AGR-L)
FUND REQUIREMENTS FOR eDAS
Format/Edits

Section/Attribute

FUND

Description/Edit

“FUND” 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.
Policy precedes Fund.
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

131 - 1

RY 2008

June 28, 2007

Exhibit 131

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR/AGR-L)
FUND REQUIREMENTS FOR eDAS
Format/Edits

No.

Tag

Key

Level of
Change

1

Y

2

Y/Y

REQ

2

Y

2

Y/Y

3

NA

4

5

6

IN/
OUT

REQ/
OPT/
CON

Max
Size

Picture

Description/Edit

4

X(04)

REQ

2

9(02)

Y/Y

REQ

4

9(04)

NA

N/Y

REQ

3

9(03)

NA

N/Y

REQ

3

9(03)

Crop/Commodity Code. Valid
codes are:
0061 = AGR-Lite;
0063 = AGR.
Insurance Plan Code. Must =
’61 or 63’.
Must = Reinsurance Year
AGR/AGR-L. Format YYYY.
Type Code. Valid codes are:
0061 and 0063 = ‘997’.
Must = ‘997’.

2

Y/Y

REQ

10

X(10)

7

2

Y/Y

REQ

1

X(01)

8

2

Y/Y

CON

5

9(05)

9

NA

N/Y

REQ

10

X(10)

NA

N/Y

REQ

1

X(01)

10

FCIC-APPENDIX III

131 - 2

Insured Signature Date of the
current application. Format
MM/DD/YYYY. Numeric with
slashes. Cannot exceed current
date or modified sales closing
date, which ever is applicable.
Fund Designation Flag. Valid
flag:
A = Assigned Risk Fund
C = Commercial Fund
D = Development Fund
Authorization Number provided
by RMA approving the
acceptance or change of fund
designation after cutoff. Change
Flag must = 3 and Process Flag
must = 1, 2, 4 or 5. If changing a
“Key” field with Level of
Change = 2, Authorization
Number assigned by
administrative screen and
Change Flag must = 2.
Cutoff date determined for fund.
Format MM/DD/YYYY.
If transaction accepted, flag = Y.
If rejected, flag = N. If deleted,
flag = D. If cancel, flag = C.

RY 2008

June 28, 2007

Exhibit 131

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR/AGR-L)
FUND REQUIREMENTS FOR eDAS
Format/Edits

No.

Tag

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

Picture

Description/Edit

Notes: Key fields are: Crop/Commodity Code (field 1), Insurance Plan Code (field 2)
Key fields with Level of Change = 2 requiring a change to that field, company will use an
administrative screen to identify this change. eDAS will use this information to verify the data when
submitted.
eDAS will use the applicable date for the crop/plan code to establish the fund cutoff date. See the
Narrative.
A carryover for AGR/AGR-Lite is defined as ‘an entity having insurance on the same crop/plan code with
the same insurance provider the previous year.’
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.
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

131 - 3

RY 2008