Insurance In Force - Type 14 - Exhibits

June 28, 2007

Exhibit 14-1

FCIC-Appendix III

CROPS WHICH ALLOW MULTIPLE TYPE 14 RECORDS
(Different Coverage Levels and/or Price Election Factors by Type)

Crop Name
Grapes

Crop
Code

Ins
Plan
Plan

States(s)

0053

90

Idaho
Oregon
Washington

If the producer selects a different
Coverage Level or Price Election
Factor by variety group, a separate
type 14 record is required.

0053
0052

90

California

Submit a separate type 14 record
for each Grape type insured.

0052

90

Arizona

Nursery

0073

50

All

Submit a separate type 14 record
for each Nursery type insured.

Dry Beans
Dry Peas

0047
0067

90
90

All
All

If the producer selects a different
Coverage Level or Price Election
Factor by Dry Bean or Dry Pea type,
a separate type 14 record is required.

Florida Citrus

0245
0246
0247
0248
0249
0250
0251

50

12

If the producer selects a different
Price Election Factor by type a
separate type 14 record is required.

Wheat
Cotton
Corn
Forage Production
Grain Sorghum
Rangeland
Peanuts
Soybeans
Barley

0011
0021
0041
0033
0051
0048
0075
0081
0091

12

All

If the producer selects a different
Coverage Level or Price Election
Factor by type or practice a
separate type 14 record is required.

PRF

0088

13&14

All

If a producer selects a different
Coverage Level or Productivity
Factor by type, a separate type 14
record is required.

Corn
Cotton
Grain Sorghum
Soybeans
Wheat

0041
0021
0051
0081
0011

73

All

If the producer selects a different
Coverage Level or Price Election
Factor by type or practice a
separate type 14 record is required.

FCIC-APPENDIX III

1

RY 2008

June 28, 2007

Exhibit 14-2

FCIC-Appendix III

----- RESERVED -----

FCIC-APPENDIX III

2

RY 2008

June 28, 2007

Exhibit 14-3

FCIC-Appendix III

Duplicate Edits
1. General Duplicate Edits:
a. Edits use Primary Tax ID type and number.
b. DAS identifies potential duplicate policies by identifying policies with
the Same ID Number, ID Type, Location State, Location County, Crop Code
and Type (note: type is applicable for California and Arizona Grapes
(crop code 0052/0053) which allow policies by grape type)
c. DAS will determine policy ownership by comparing the signature date &
transfer flag fields on 14 record
i. If any of the duplicate policies are indicated as a “transfer and
cancellation” policy on the 14 record, the duplicate process will
use the earliest signature date for the current sales period to
determine ownership.
1. The sales period starts the day following the earliest sales
closing date for the previous crop year and continues
through the latest sales closing date for the current crop
year.
ii. If none of the duplicate policies are indicated as being a
“transfer and cancellation” policy, then ownership is determined
by the earliest signature date without regard to the sales period.
iii. DAS will flag the duplicate ISAM with the appropriate flag of
owner & duplicate policy.
d. The duplicate edits are not performed when:
i. The entity type is equal to “B” Bureau of Indian Affairs
ii. The crop code is hybrid seed (0050/0062)
iii. If the duplicates occur for the same RO and one policy is cat
coverage for high risk land (Record type 14, dual coverage flag).
e. The duplicate edits contain “crop code” in the key for determination of
whether there is a duplicate policy.
f. DAS will reject premium records for both the owner and duplicate policy:
i. Premium records for both policies (owner & duplicate) will be
rejected by DAS, as well as any dependent records.
1. DAS will reject the premium records for the incoming
duplicate record and dependent record types.
2. DAS will populate the duplicate ISAM and will flag the ISAM
with a code indicating record was rejected/deleted.
3. If the other duplicate policy record was previously
accepted, then DAS will flag the duplicate ISAM with a flag
indicating that the record was deleted from the database.
a. The Saturday process will build a file from the
flagged policies on the ISAM for the deleted policies.
When the database loads are performed, the policies
contained in this file will be processed and policy
records will be removed from the database. A report
will be built for the weekly deleted policies and
available to companies via the RO server to provide a
weekly listing of those duplicate policies removed
from the database.

FCIC-APPENDIX III

3

RY 2008

June 28, 2007

Exhibit 14-3

FCIC-Appendix III

2. SAME ENTITY TYPE:
a. If the AIP is the same: DAS will reject the duplicate (non-owner) policy
with a 14090 error. All dependent records will be rejected (9 record
will not be rejected).
The duplicate record will be rejected (not
accepted) therefore; Item 1f won’t apply, because the duplicate record
was not accepted.
b. AIP is different: DAS will accept the owner & duplicate policy (policy
will be in both the .rej and .acp files) as a duplicate, but issue
warning to the company (14091).
Exception to item 2a & 2b: Entity
type of “J”, “T” or “R” can contain multiple policies with the same ID
number and ID type. Therefore, DAS should accept the records for the
same AIP or different AIP’s and issue a potential duplicate warning
message to the company – the company should not have premium or loss
records rejected if the duplicated policy information is for entity type
“J”, “T” or “R”. Item 1f will NOT apply, except if the entities equal
“J” and the id type is the same and equal to 2(EIN) – Item 1f would then
apply. If the entity type is “C”
Corporation, “P” Partnership, “E” Associations, Clubs, Private Schools,
and/or Tax Exempt Organization (including religious groups), “G”
Government Receiver or Liquidator, “H” Public Agency State, “V” Public
Agency County, “W” Public Agency City, or “A” Public Schools, another
entity type should not contain the same ID Number and type. Item 1f
will apply.
3. DIFFERENT ENTITY TYPE a. AIP is the same OR different: DAS will accept the duplicate policy as a
possible duplicate, but issue 14092 warning. Policy data will appear on
both the .acp and .rej files. Item 1f will not apply.
b. Entity types: “I”, “S”, “J”, “X”, “U”, “D”, “T” or “R” are allowed to
report policy information using an SSN. The same ID number, and ID type
may be used for each of these entity types which is acceptable within
the guidelines of the Crop Insurance Handbook. Therefore, DAS will not
reject premium or loss data. DAS will provide a warning message to the
company that a possible duplicate policy situation exists yet accept the
records. Item 1f will NOT apply.
i. Warnings are generated because entity types for Individuals (I),
Spouses (S), Individual Operating as Company (X), Joint Ventures
(J), Undivided Interest (U), Estates (D), Revocable Trusts (R) and
Irrevocable Trusts (T) may have the same duplicate key because an
entity may use the SSN and have a separate policy for each type of
entity.
c. If the entity type is “C” Corporation, “P” Partnership, “E”
Associations, Clubs, Private Schools, and/or Tax Exempt Organization
(including religious groups), “G” Government Receiver or Liquidator, “H”
Public Agency State, “V” Public Agency County, “W” Public Agency City,
or “A” Public Schools another entity type should not contain the same ID
number and type. Company will receive a warning message unless the
entity type is C, J or P and the Id Number is an EIN, then item 1f will
apply.

FCIC-APPENDIX III

4

RY 2008

June 28, 2007

Exhibit 14-3

FCIC-Appendix III

Duplicate Error Numbers:
14090: Duplicate policy with submitting AIP
14091: Warning: Duplicate Policy with another AIP with Duplicate flag = “D” or “O”
14092: Warning: Duplicate Policy with another AIP or within same AIP with
duplicate flag = “P”
14094: dup error – ensures that policy goes through the Dup process
Note: For DAS Warning messages, policy data will appear on .rej and .acp file

Duplicate Policy Removal Process:
After weekly cutoff, the IPRYOWN and IPYDUP reports will be generated from the
duplicate policy information captured during DAS processing. RMA will remove DAS
determined duplicate crop/county policy records, in the IPRYDUP report from the Dup
ISAM and the policy database.
Once this weekend process is
in the DAS System and should
Approved Insurance Providers
listed in the IPRYDUP report

FCIC-APPENDIX III

complete, the DAS determined 'owner' policy will remain
not receive a duplicate error when re-transmitted.
must take action to ensure that duplicate policies
are NOT re-transmitted to DAS.

5

RY 2008

June 28, 2007

Exhibit 14-4

FCIC-Appendix III

----RESERVED-----

FCIC-APPENDIX III

6

RY 2008

June 28, 2007

Exhibit 14-5

FCIC-Appendix III

2008 Crops by Plan Code for which “CAT” Coverage is NOT AVAILABLE:
Plan
Code

Crop
Code

Crop

GRIP
(73)

0011
0021
0041
0051
0081

Wheat
Cotton
Corn
Grain Sorghum
Soybeans

RA
(25)

0011
0015
0018
0021
0041
0078
0081
0091

Wheat
Canola
Rice
Cotton
Corn
Sunflowers
Soybeans
Barley

CRC
(44)

0011
0018
0021
0041
0051
0081

Wheat
Rice
Cotton
Corn
Grain Sorghum
Soybeans

PRF
(13&14)

0088

Pasture, Rangeland, and Forage

FCIC-APPENDIX III

7

RY 2008