AGR & AGR-L Crop Policy Requirements for eDAS - Exhibit 123

June 28, 2007

Exhibit 123

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR/AGR-L)
CROP POLICY REQUIREMENTS FOR eDAS
Format/Edits
Section/Attribute

CROP_POLICY

Description/Edit

“CROP_POLICY” 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 Crop_Policy.
The process flag and/or change flag submitted for this section will be inherited
unless otherwise indicated. Example: .
For AGR/AGR-Lite, only 1 crop policy per Tax ID (Entity) nationwide.
Cannot have both insurance plans.

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

123 - 1

RY 2008

June 28, 2007

Exhibit 123

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR/AGR-L)
CROP POLICY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

Key

Level of
Change

1*

Y

2

Y/Y

REQ

4

X(04)

2*

Y

2

Y/Y

REQ

2

9(02)

NA

Y/Y

REQ

4

9(04)

2

Y/Y

REQ

3

9(03)

NA

N/Y

REQ

3

9(03)

NA

N/Y

REQ

3

9(03)

2

Y/Y

REQ

8

9.999999

8*

2

Y/Y

REQ

10

X(10)

9

1

Y/Y

REQ

9

X(09)

10

1

Y/Y

REQ

10

X(10)

3*
4*
5

6
7*

FCIC-APPENDIX III

IN/
OUT

REQ/
OPT/
CON

Max
Size

123 - 2

Picture

Description/Edit

Crop/Commodity Code, edit
with ADM 2. Valid codes are:
0061 = AGR-Lite;
0063 = AGR.
Insurance Plan Code. Must =
’61 or 63’, edit with ADM 2.
Must = Reinsurance Year
AGR/AGR-L. Format YYYY.
Edit with FIPS County Table.
Type Code, edit with ADM2.
Valid codes are:
0061 and 0063 = ‘997’.
Must = ‘997’.
Valid coverage levels are 0.6500,
0.7500, or 0.8000. Higher
coverage amount only available
for insureds who qualify. See
Special Provisions, Underwriting
Rules, AGR Standards
Handbook, AGR-L Standards
Handbook, and Exhibit 123-1
(AGR-L only) for additional
information.
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.
Agent ID Code of the agent that
is responsible for this
information and accepted on the
agent database for the above
insurance plan.
Agent Signature Date of the
current application. Format
MM/DD/YYYY. Numeric with
slashes. Cannot exceed current
date.

RY 2008

June 28, 2007

Exhibit 123

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR/AGR-L)
CROP POLICY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

11
*

2

Y/Y

REQ

2

9(02)

12

1

Y/Y

OPT

1

X(01)

13

1

Y/Y

OPT

1

X(01)

14

1

Y/Y

OPT

1

X(01)

15

1

Y/Y

OPT

7

X(07)

16

2

Y/Y

CON

5

9(05)

FCIC-APPENDIX III

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

123 - 3

Picture

Description/Edit

Late Processed Flag. Must be:
00 = Timely-Processed
01 = Company Approved LateFiled Application
02 = Company Delayed
03 = Agent Delayed
04 = FCIC Delayed
05 = Not applicable
06 = Not applicable
07 = Not applicable
08 = Reserved
09 = Successor-in-Interest –
requires entry in Successor
In Interest Date field for
Policy Section.
10 = Revised Coverage Level
Must be:
P = Fees prepaid before due date.
Blank = No Prepayment
Administrative Fee Exception
Flag. Must be:
W = Limited resource waiver
approved.
Cancellation Transfer
Application. Enter “Y” if the
producer signed a cancellation
and transfer application. Used
to determine “owner” in the
duplicate process.
Marketing Activity Type. Assigned
code if policy was sold under
Marketing Agreement.
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.

RY 2008

June 28, 2007

Exhibit 123

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR/AGR-L)
CROP POLICY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

17

1

Y/Y

CON

1

X(01)

18

1

Y/Y

CON

10

X(10)

NA

N/Y

REQ

1

X(01)

NA

N/Y

REQ

2

9(02)

19
20

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

Picture

Description/Edit

Dispute Notification Flag.
Values:
A = Arbitration
M = Mediation
L = Litigation
O = Legal Action
Else a space. See Note at end of
exhibit.
Date AIP notified of dispute.
Format MM/DD/YYYY.
Coverage flag will equal “A” for
additional.
Late Sales Reduction (LSR) Flag
will equal:
Code “00” = No Reduction
(accepted less than or equal to
the LSR Lockdown Date)
Code “01” = 1% Reduction
(accepted after LSR Lockdown
and up to the transaction cutoff
date for the week containing the
60th day after the SCD)
Code “02” = 3% Reduction
(accepted greater than 60 days
after LSR Lockdown date up to
the transaction cutoff date for the
week containing the 90th day
after the SCD)
Code “03” = 6% Reduction
(accepted more than 90 days
after the LSR Lockdown Date)
Note: If the AIP retransmits to
lockdown Coverage Level
Percent, the late sales reduction
will revert to lockdown reduction
flag.

FCIC-APPENDIX III

123 - 4

RY 2008

June 28, 2007

Exhibit 123

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR/AGR-L)
CROP POLICY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

Picture

Description/Edit

21

NA

N/Y

REQ

10

X(10)

Late Sales Reduction cutoff date.
Transaction cutoff for the week
containing the 30th day after the
applicable date. For AGR-Lite
the sales closing date of 3/15 will
be used for new insureds. For
carryover AGR-Lite insureds the
cancellation date of 1/31 will be
used. For AGR the sales closing
date of 1/31 will be used for all
insureds. See Notes.

22

NA

N/Y

REQ

10

X(10)

Late Sales Reduction change
date. The last date the coverage
level, entity ID type, entity ID
number, or entity type was
modified by the AIP after LSR
lockdown. Format
MM/DD/YYYY.

Format MM/DD/YYYY.

FCIC-APPENDIX III

123 - 5

RY 2008

June 28, 2007

Exhibit 123

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR/AGR-L)
CROP POLICY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

23

NA

N/Y

REQ

2

9(02)

24

NA

N/Y

REQ

2

9(02)

FCIC-APPENDIX III

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

123 - 6

Picture

Description/Edit

Late Sales Reduction
Transaction Code. ISAM will
equal:
01: Timely Accepted
02: Not applicable
03: Coverage Level change after
lockdown
04: Not applicable
05: Not applicable
06: Initially Accepted after
lockdown
07: Not applicable
08: Not applicable
09: Not applicable
10: Not applicable
12: ID Type on Entity Section,
changed after lockdown.
13: ID Number on Entity
Section, changed after
lockdown.
14: Entity Type on Entity
Section, changed after
lockdown.
15: ID Type and ID Number on
Entity Section, changed after
lockdown.
16: ID Type and Entity Type on
Entity Section, changed after
lockdown.
17: ID Number and Entity Type
on Entity Section, changed
after lockdown.
18: ID Type, ID Number, and
Entity Type on Entity
Section, changed after
lockdown.
19: Not applicable
20: Not applicable
Lockdown Reduction Flag.
Original transaction reduction
flag (LSR) for the later of
Lockdown Date or FCIC
accepted date. Timely accepted
would equal zeros.

RY 2008

June 28, 2007

Exhibit 123

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR/AGR-L)
CROP POLICY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

Picture

25

NA

N/Y

REQ

8

9.999999

26

NA

N/Y

REQ

2

9(02)

27

NA

N/Y

REQ

1

9(01)

28

NA

N/Y

REQ

9

X(09)

29

NA

N/Y

REQ

1

X(01)

30

NA

N/Y

REQ

1

X(01)

Description/Edit

Lockdown Coverage Level.
Coverage Level submitted by the
AIP at the later of the LSR
Lockdown date (timely
submitted) or date accepted by
FCIC (originally
submitted/accepted late).
Plan code submitted by the AIP
at the later of the LSR Lockdown
date (timely submitted) or date
accepted by FCIC (originally
submitted/accepted late).
ID Type submitted by the AIP at
the later of the LSR Lockdown
(timely submitted) or date
accepted by FCIC (originally
submitted/accepted late).
ID Number submitted by the AIP
at the later of the LSR Lockdown
(timely submitted) or date
accepted by FCIC (originally
submitted/accepted late).
Entity Type submitted by the
AIP at the later of the LSR
Lockdown (timely submitted) or
date accepted by FCIC
(originally submitted/accepted
late).
If section accepted, flag = Y. If
rejected, flag = N. If deleted,
flag = D. If cancel, flag = C.

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.
* Data elements that must be accepted to meet timely reporting of an eligible crop insurance contract for
AGR/AGR-L.
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.’
Dispute Notification Flag
SRA section IV, R, 3. The Company shall report to FCIC in accordance with established procedures,
disputes with policyholders in mediation, arbitration, litigation or legal action, within 30 days after the
Company has been notified of such dispute.

FCIC-APPENDIX III

123 - 7

RY 2008

June 28, 2007

Exhibit 123

FCIC-Appendix III

ADJUSTED GROSS REVENUE (AGR/AGR-L)
CROP POLICY REQUIREMENTS FOR eDAS
Format/Edits
No.

Tag

Key

Level of
Change

IN/
OUT

REQ/
OPT/
CON

Max
Size

Picture

Description/Edit

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

123 - 8

RY 2008