Fund Designation Record - Type 09 - Format-Edits

June 28, 2007

Exhibit 09

FCIC-Appendix III

(FUND DESIGNATION RECORD – TYPE 09)
Format/Edits

Field
No.

1
2

Field Name

Begin
Pos

Size

Picture

Field Edits

1
3

2
2

9(02)
X(02)

Required. Must be 09. See Note 1.
Required. Edit with AIP/Company table.

3
4
5
6

Record Type
Approved Insurance
Provider
Location State
Filler
Policy Number
Crop Year

5
7
10
17

2
3
7
4

9(02)
X(03)
9(07)
9(04)

7
8
9
10
11

Crop Code
Insurance Plan Code
Location County
Filler
Type Code

21
25
27
30
35

4
2
3
5
3

9(04)
9(02)
9(03)
X(05)
9(03)

12

Practice Code

38

3

9(03)

13
14

Filler
Type 09 Key Reserve

41
42

1
34

X(01)
X(34)

15

Record Number

76

3

9(03)

16

Primary Fund Designation
Flag

79

1

X(01)

Required. Edit with FIPS State table.
Must be spaces.
Required. Must be > zeros.
Required. Must be the crop year of the crops
reported under the policy. This will equal the
Reinsurance Year or Reinsurance Year +/- 1
for applicable crop code.
Required. Edit with ADM2.
Required. Edit with ADM2.
Required; Edit with FIPS County Table.
Must be Spaces.
Optional for new or carryover policies.
Required for California Grapes (0052 &
0053) and Arizona Grapes (0052). (See Note
2) Will be edited against ADM2. For crops
with more than one sales closing date, type
code may be required for determining fund
designation cutoff date based on the sales
closing date. A spring type is required when
changing fund designation where there is
multiple sales closing dates by types and the
insured does not plant fall type. (see Note 5).
Required for Nursery (0073).
Optional for new or carryover policies (See
Note 2) edited with ADM2. For crops with
more than one sales closing date, practice
code may be required for determining fund
designation cutoff date based on the sales
closing date.
Must be Spaces.
Space Reserved for Additional key data
required in the future or for other record
types. Must be spaces or blanks.
Must be > zero and unique within a Crop
Policy (fields 2 thru 9) and field 11 for
California Grapes (0052 & 0053) and
Arizona Grapes (0052).
Required; must be one of the following:
A = Assigned Risk Fund
C = Commercial Fund
D = Development Fund

FCIC-APPENDIX III

9-1

RY 2008

June 28, 2007

Exhibit 09

FCIC-Appendix III

(FUND DESIGNATION RECORD – TYPE 09)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

Required if fund is different than primary
fund designation.
A = Assigned Risk Fund
C = Commercial Fund
D = Development Fund
Otherwise, spaces.
If High Risk land is insured under a separate
CAT policy, field 17 should be spaces.
Must be spaces.
For any agriculture commodity without a
fixed sales closing date, signature date is used
to determine fund designation cutoff for new
policies.
Required for new Florida Fruit Trees and
Nursery policies. Otherwise, zero fill.
Internal Use. Must be a space.
Will be populated with Y, N or a space if
there is no Written agreement.
Y - This is the initial year of the multi year
written agreement and the WA approval date
is used to calculate fund cutoff.
N – This is not the initial year of the multi
year written agreement and the sales closing
date will be used to calculate fund cutoff.
A = Designated with Alternate Crop
Extension to Assigned Risk Fund
Coverage flag on 14 Record must be
“C” (Cat). Allowed only after normal
cutoff date, with RMA approval, no
modification after acceptance.
Else spaces.

17

High Risk CAT Fund Flag

80

1

X(01)

18
19

Filler
Insured’s Signature Date for
the Crop

81
86

5
8

X(05)
9(08)

20

Written Agreement Multi
Year Flag

94

1

X(01)

21

Alternate Crop Designation

95

1

X(01)

FCIC-APPENDIX III

9-2

RY 2008

June 28, 2007

Exhibit 09

FCIC-Appendix III

(FUND DESIGNATION RECORD – TYPE 09)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

0 = For new contracts
1 = Contract carried over from previous year.
A carryover contract is defined in the SRA as
one in which the entity had insurance on the
same crop and plan code with the same
company in the state and county the previous
year.
Florida Fruit Trees and Nursery required;
otherwise spaces.
For RMA issued Written Agreements enter
the identification number for the approved
written agreement for the RO, state, county
and crop.
The first 3 digits identify the issuing RSO
and must be valid for the location state.
Enter spaces if No Written Agreement exists.
Format is MMDDCCYY, RMA Approved
Date (print date). Required if fund cutoff
date is later due to written agreement or if
sales closing date does not exist for crop
location state/county or rate state/county
(written agreement processing flags W, NC
or NT). Cannot Exceed Transmission Date.
Else, zero fill.
Valid Written Agreement types are: GP, HR,
NB, OC, OP, PE, RE, SC, SG, SM, SP, TC,
TD, TL, TP, UA, UC, XC and 33. Written
Agreements types of: GP, HR, UA and SP
do not extend fund cutoff.
Enter ‘33’ if the insurance rate is provided on
a FCI-33 (rules page, map or supplement).
All entries, except a “33” require a valid
Written Agreement Number in field 23.
All single values must be left justified.
Nursery and Aquaculture = spaces. Enter
spaces if NO Written agreement is in effect.

22

Contract Fund Flag

96

1

X(01)

23

Written Agreement Number

97

8

X(08)

24

Written Agreement Date

105

8

9(08)

25

Written Agreement Type

113

2

X(02)

FCIC-APPENDIX III

9-3

RY 2008

June 28, 2007

Exhibit 09

FCIC-Appendix III

(FUND DESIGNATION RECORD – TYPE 09)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

Must be:
H = ONLY for High Risk land
WITH a FCI-2 Agreement that
changes the High Risk rate or .factor
USE the High Risk Classification
Premium Calculation Worksheet to
calculate the premium.
P = FCI-2 Dollar Amount of Insurance
exception for Macadamia Trees.
R = FCI-2 Agreement with a Reference
County.
W = FCI-2 Agreement with no Reference
County
3 = FCI-33 (rules page, map or
Supplement) Rates
RC = Certified organic acreage with a
location or reference county
RT = Transitional acreage with a location
or reference county
NC = Certified organic acreage with no
reference county
NT = Transitional acreage with no
reference county
Otherwise, spaces.
See Exhibit 11-8 for edit details.
Required. Edit with FIPS State Table. See
Note 4.
Required. Edit with FIPS County Table. See
Note 4.
RMA Internal use only: Cutoff date
determined by DAS for the primary fund.
Format is: CCYYMMDD. Zero Fill.
RMA Internal use only: Cutoff date
determined by DAS. Format is:
CCYYMMDD. Zero Fill.

26

Written Agreement
Processing Flag

115

2

X(02)

27

Rate State

117

2

9(02)

28

Rate County

119

3

9(03)

29

Fund Designation Cutoff
Date

122

8

9(08)

30

HRC Cutoff Date

130

8

9(08)

FCIC-APPENDIX III

9-4

RY 2008

June 28, 2007

Exhibit 09

FCIC-Appendix III

(FUND DESIGNATION RECORD – TYPE 09)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

Applicable if producer selected added county
option on application. Otherwise, spaces.
Enter ‘P’ on the primary (designated) record
for the policy crop/plan county within a state.
This will establish the fund for subsequent
policy state crop/plan fund records. Primary
(designated) record cannot be changed after
the cutoff date. Only one “P” record is
allowed per state/crop/plan.
Enter ‘S’ on subsequent policy crop county
records submitted after the fund cutoff date.
“S” is only allowed if insured has no previous
insurance in the county for any crop for
current crop year.
Enter “N” on the primary (designated) record
for the policy crop/plan nationwide. This
will establish the fund for subsequent policy
crop/plan. Primary (designated) record
cannot be changed after the cutoff date. Only
one “N” record is allowed per
policy/crop/plan. *Only Category B crops
(excluding Forage Production) qualify for
added county.
Must be spaces.
Required if added county flag equals “S”,
otherwise must equal zeros. Enter the state
code for the policy to be referenced for added
county edit. Must be numeric. If this field is
filled reference the 9 record ISAM for added
county flag of ‘P’ or ‘N’.
Enter the policy number for the policy to be
referenced for added county edit. Must be
numeric.
Enter the crop year for the policy to be
referenced for added county edit. Must be
numeric.
Enter the crop code for the policy to be
referenced for added county edit. Must be
numeric.
Enter the location county for the policy to be
referenced for added county edit. Must be
numeric.

31

Added County Flag

138

1

X(01)

32
33

Filler
Added County Reference
State

139
146

7
2

X(07)
9(02)

34

Added County Reference
Policy Number

148

7

9(07)

35

Added County Reference
Crop Year

155

4

9(04)

36

Added County Reference
Crop Code

159

4

9(04)

37

Added County Reference
Location County

163

3

9(03)

FCIC-APPENDIX III

9-5

RY 2008

June 28, 2007

Exhibit 09

FCIC-Appendix III

(FUND DESIGNATION RECORD – TYPE 09)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

Enter the type code for the policy to be
referenced for added county edit. Must be
numeric. Required only for CA Grapes
(0052 and 0053) and AZ Grapes (0052);
else zero fill.
Must be spaces.
Internal Use. The time the transaction batch
file was received. (From when transmission
started) HHMM Format.
Internal Use. The date the transaction batch
file was received. (From when transmission
started) MMDDCCYY Format.
Internal Use. The Reinsurance Year. CCYY
format.
Internal Use. The sequential number
identifying the file that was submitted by the
AIP to FCIC/RMA.
Internal Use. The sequential number
assigned to each transaction number
processed by DAS after it has been sorted
Internal. Reserved.
Internal. Reserved.
Internal Use. The date this record was
initially accepted by DAS. MMDDCCYY
format.
RMA Internal Use. The sequential number
identifying the file that was initially
submitted by the AIP to FCIC/RMA and
accepted by DAS.
Internal.

38

Added County Reference
Type Code

166

3

9(03)

39
40

Filler
FCIC Control Time

169
551

382
4

X(382)
9(04)

41

FCIC Control Date

555

8

9(08)

42

Reinsurance Year

563

4

9(04)

43

Batch Number

567

4

9(04)

44

Transaction Sequence
Number

571

8

9(08)

45
46
47

Transaction Rejected Flag
Transaction Source Flag
FCIC Initially Accepted
Date

579
580
581

1
1
8

X(01)
X(01)
9(08)

48

FCIC Initially Accepted
Batch

589

4

9(04)

49

Filler

593

8

X(08)

FCIC-APPENDIX III

9-6

RY 2008

June 28, 2007

Exhibit 09

FCIC-Appendix III

(FUND DESIGNATION RECORD – TYPE 09)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

Notes:
1.
The type 9 record must pass all edits and be accepted to establish the fund designation for the eligible
crop insurance contract. The type 9 record will be processed independently from all other record types.
Once a type 9 is accepted for policy/crop/county into a fund it doesn’t need to be resent, unless to timely
modify the fund designation.
2.

If the Sales Closing Date used for fund designations varies by Plan, Type or
Practice, the DAS lookup will use them to determine the Sales Closing Date if submitted, otherwise
DAS will use the earliest Sales Closing Date for the county/crop/plan code to establish the fund
cutoff date.

3.

If the Fund Designation cutoff date is later than the ‘normal’ cutoff date due to: a written
agreement, a written agreement date (field 27), written agreement number, written agreement type,
written agreement processing flag and written agreement year flag of “Y” are required. All written
agreement information must be correct to be accepted into the ISAM.
Rate State and Rate County can only be different from Location State and County if a written agreement
is in effect. ADM 3 lookup is based on Rate State/Rate County.

4.

Accepted Type 9 Records will be in the “.acp” and “.fun” output files.

5.

A change in fund designation will be allowed for spring crops before the spring cutoff date if:
The state/county/crop has multiple sales closing dates by spring or fall types and the AIP
submitted a 9 record before fall cutoff date (with or without a fall type) and insured is not planting the fall
type. Resubmitting the 9 record with a spring type will be allowed and the fund designation cutoff
will be calculated from the spring sales closing date. Also, a zero acreage report for the fall type needs to
sent.

FCIC-APPENDIX III

9-7

RY 2008