Fund Designation Record - Type 09 - Fund Designation Guidelines

June18, 2004

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

June18, 2004

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.
Must be Y or N if there is a RMA approved
written agreement on the eligible crop
insurance contract. Spaces if no written
agreement.
Y - This is the initial year of the written
agreement or the written agreement must be
renewed or approved annually and the WA
approval date is used to calculate fund cutoff.
N – This is not the initial year of the 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 Year
Flag

94

1

X(01)

21

Alternate Crop Designation

95

1

X(01)

FCIC-APPENDIX III

9-2

RY 2005

June18, 2004

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. 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: HR, LS,
NB, OC, OP, OT, PT, RE, SC, SG, SM,
SP, TC, TD, TP, TS, UA, UC, XC and 33.
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 2005

June18, 2004

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

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)

31

Added County Flag

138

1

X(01)

FCIC-APPENDIX III

9-4

RY 2005

June18, 2004

Exhibit 09

FCIC-Appendix III

(FUND DESIGNATION RECORD – TYPE 09)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

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)

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)

FCIC-APPENDIX III

9-5

Field Edits

“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
multi 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.
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
RY 2005

June18, 2004

Exhibit 09

FCIC-Appendix III

(FUND DESIGNATION RECORD – TYPE 09)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

AIP to FCIC/RMA.

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)

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.

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

FCIC-APPENDIX III

9-6

RY 2005