P14 Insurance in Force

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

P14

1

AIP Code

Character

2

P14
P14

2
3

Reinsurance Year
Record Type Code

Numeric
Character

4
6

P14

4

AIP Policy Producer Key

Character

15

P14

5

AIP Insurance In Force Key

Character

15

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

CCYY

BUS
Key Req?
Y

Y

Y

Y
Y

Y

Y
Y

Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must equal "2012".
Record Type Code must equal "P14".
AIP Policy Producer Key must match the
corresponding primary Policy Producer, "P10"
record.
AIP Insurance In Force Key must be unique within
the AIP Policy Producer Key.
AIP Insurance In Force Key must not be reassigned
once used within the AIP Policy Producer Key.

P14

6

AIP Insurance Agent Key

Character

15

P14

7

Location County Code

Character

3

Y

Y

P14

8

Insurance Plan Code

Character

2

Y

Y

P14

9

Commodity Code

Character

4

Y

Y

P14

10

Commodity Year

Numeric

4

Y

Y

"*" = Output Only
3/6/2012

Page 1 of 24

Y

CCYY

AIP Insurance Agent Key must match the
corresponding Insurance Agent, "P55" record.
AIP Insurance Agent Key must refer to an active
Agent “P55” record.
Location County Code must be valid: edit with the
County ADM, "A00440".
Insurance Plan Code must be valid; edit with the
Insurance Plan ADM, "A00460".
Commodity Code must be valid; edit with the
Commodity ADM, "A00420".
Commodity Year must be between the
Reinsurance Year plus one and the Reinsurance
Year minus one.

Record
Number
P14

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number
11

Field Name
Type Code

Insurance In Force
P14

Data Type

Max
Length

Character

3

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?
Y

Rules
Type Code must be valid; edit with Type ADM
"A00540".
Type Code is required when Commodity Code
equals Table Grapes,"0052" or Grapes, "0053".
Type Code is required if necessary to allow
multiple Coverage Level Percents or Price Election
Percents for the Location State Code/Location
County Code/Commodity Code.
Type Code is required when Commodity Code
equals Nursery, "0073", Grapes, "0053" or PRF,
"0088" or when the Location State Code equals
Arizona, "04" or California, "06" and the
Commodity Code equals "0052" or the Location
State Code equals Texas, "48" and the Commodity
Code equals Tangerine Trees, "0193", Orange
Trees, "207" or Grapefruit Trees, "208" and Type
Practice Use Code equals "N".

"*" = Output Only
3/6/2012

Page 2 of 24

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Type Code for commodities with more than one
sales closing date may be used to determine
eligibility and LRR transaction cutoff date based
on sales closing date where multiple dates exist.

P14

12

Practice Code

Character

3

Y

Practice Code is required when Commodity Code
equals Nursery, "0073".
Practice Code must be valid; edit with the Practice
ADM, "A00510".
Practice Code is required if necessary to
determine the Sales Closing Date; if not submitted
the earliest Sales Closing Date for the Location
State Code/Location County Code/Commodity
Code/Insurance Plan Code will be used to
establish the Fund Cut Off Date.

P14

13

Commodity Type Code

Character

3

P14

14

Class Code

Character

3

P14

15

Sub Class Code

Character

3

P14

16

Intended Use Code

Character

3

"*" = Output Only
3/6/2012

Page 3 of 24

Commodity Type Code must be valid; edit with
the Commodity Type ADM, "A00430".
Class Code must be valid; edit with the Class
ADM, "A00410".
Sub Class Code must be valid; edit with the Sub
Class ADM, "A00530".
Intended Use Code must be valid; edit with the
Intended Use ADM, "A00470".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

P14

17

Irrigation Practice Code

Character

3

P14

18

Cropping Practice Code

Character

3

P14

19

Organic Practice Code

Character

3

P14

20

Interval Code

Character

3

P14

21

WA Number

Character

9

P14

22

Coverage Type Code

Character

1

"*" = Output Only
3/6/2012

Page 4 of 24

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

999999999

Y

Y

Rules
Irrigation Practice Code must be valid; edit with
the Irrigation Practice ADM, "A00490".
Cropping Practice Code must be valid; edit with
the Cropping Practice ADM, "A00450".
Organic Practice Code must be valid; edit with the
Organic Practice ADM, "A00500".
Interval Code must be valid; edit with the Interval
ADM, "A00480".
WA Number must be valid; edit with the ICE
Written Agreement Table.
WA Number must be empty when Commodity
Code equals Nursery "0073" or Clams, "0116" or
Avocados, "0119".
WA Number can not be changed after the Fund
Designation Cutoff Date.
WA Number must contain only numeric
characters.
WA Number must not equal "000000000".
CoverageType Code must be valid; edit with
Coverage ICE "D00016".
Coverage Type Codes for the entire County must
be designated as CAT when CAT is selected for
Non Californial grapes (0053).

Record
Number
P14

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number
23

Insurance In Force
P14

Field Name

Data Type

Max
Length

Late Reported Reason Code

Character

2

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Late Reported Reason Code must be valid; edit
with Late Reported Reason ICE, "D00006".
Late Reported Reason Code is required if
submitted after LRR Cutoff Date.
Late Reported Reason Code must be valid; edit
with Late Reported Reason ICE "D00006" when
Timely Submission Flag equals "N" and the LRR
Code is not equal to "00"."
Late Reported Reason Code equal Alternative
Commodity, "05" requires that the Alternative
Commodity, Coverage Code must equal
Catastrophic, "C".

"*" = Output Only
3/6/2012

Page 5 of 24

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Late Reported Reason Code equal Changes to
Price or Coverage Level when insured did not
plant fall type, "06" requires that the Commodity
has Spring & Fall Sales Closing Dates; edit with the
ADM Date A00200. An Insurance In Force, "P14"
record with a Fall Sales Closing Date was accepted
but the fall commodity was not planted and no
Acreage, "P11" record was accepted for the
commodity. A new Insurance In Force, "P14"
record may be submitted for the spring
commodity with changes to the Price Indicator
Code or Coverage Level Percent.
Late Reported Reason Code equal Subsequent
Application For Multiple County, "07" requires
that the Added County Indicator Code must equal
Subsequent County, "S".
Late Reported Reason Code, equals multiple
Insurance In Force, "P14" records submitted, "08"
requires that multiple Insurance In Force, "P14"
records exist for the Policy/Location County
Code/Commodity Code.

"*" = Output Only
3/6/2012

Page 6 of 24

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Late Reported Reason Code equal Revised
Coverage Level, Market Price Indicator Code or
Price Election Percent, "10", allows changes only
to Coverage Level Percent, Market Price Indicator
Code, or Price Election Percent after the LRR
Transaction Cutoff Date.
Late Reported Reason Code is Required when LRR
Transaction Code is not one of the following
values: Timely Accepted, "01" or Modified after
Lockdown to Lockdown Price Election, Coverage
Level and Price Indicator, "07".
Late Reported Reason Code equal to Contract
Change, "11" cannot be changed once accepted.
Late Reported Reason Code must not equal "00"
when the Batch Received Date is greater than or
equal to the LRR Transaction Cutoff Date and the
LRR Code is not equal to "00".

P14

24

"*" = Output Only
3/6/2012

Dual Coverage Flag

Character

1

Page 7 of 24

Y

Dual Coverage Flag must be Yes, "Y" when the
Coverage Code equals Catastrophic, "C" and a nonhigh risk buy-up policy exists for the Primary
Producer, otherwise No, "N".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Dual Coverage Flag must equal No, "N" when the
Commodity Code equals Nursery, "0073".

P14

25

Insured Commodity Signature Date

Date

8

CCYYMMDD

Y

Insured Commodity Signature Date must not be
less than 1991.
Insured Commodity Signature Date must not be
greater than the Batch Received Date.
Insured Commodity Signature Date must not be
greater than the Modified Sales Closing Date
unless Late Reported Reason Code does not equal
Timely Processed, "00".
Insured Commodity Signature Date must be
between the Contract Change Date minus one
year and Batch Received Date when Contract
Carryover Flag equals "N" and the Insurance Plan
Code equals "40".
Insured Commodity Signature Date must not be
greater than the Modified Sales Closing Date
unless a Late Reported Reason equal to "01" is
submitted, or the Commodity Code equals New
Florida Fruit Trees or Nursery, "0073".

"*" = Output Only
3/6/2012

Page 8 of 24

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Insured Commodity Signature Date must be
between Contract Change Date minus one year
and Batch Received Date when Contract
Carryover Flag equals "N", the Location State
Code equals "12" and the Commodity Code
equals Orange Trees, "0207", Grapefruit Trees,
"0208", Lemon Trees, "0209", Lime Trees,
"0210"', Other Citrus Trees, "0211", Avocado
Trees, "0212", Crambola Trees, "0213" or Mango
Trees, "0214".
Insured Commodity Signature Date must be
between March 14, 2010 and April 17 of the
CommodityYear when the Location State Code
equals "12" and the Commodity Code equals
Orange Trees, "0207", Grapefruit Trees, "0208",
Lemon Trees, "0209", Lime Trees, "0210"', Other
Citrus Trees, "0211", Avocado Trees, "0212",
Crambola Trees, "0213" or Mango Trees, "0214"
and the Contract Carryover Flag equals "Y".

P14

26

"*" = Output Only
3/6/2012

Agent Commodity Signature Date

Date

8

Page 9 of 24

CCYYMMDD

Y

Agent Commodity Signature Date must not be
less than 1991.
Agent Commodity Signature Date must not be
greater than the Batch Received Date.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Agent Commodity Signature Date must not be
greater than the Modified Sales Closing Date
unless Late Reported Reason Code does not equal
Timely Processed, "00".
Agent Commodity Signature Date must be less
than the Inactive Date from the Agent, "P55"
record when the Inactive Date exists.
Agent Commodity Signature Date must be less
than or equal to the Sales Closing Date when the
Commodity Code does not equal: Nursery,
"0073", Orange Trees, "0207", Grapefruit Trees,
"0208", Lemon Trees, "0209", Lime Trees,
"0210", Other Citrus Trees, "0211", Avocado
Trees, "0212", Carambola Trees,"0213" or Mango
Trees, "0214" or when the Contract Carryover
Flag equals Yes, "Y" and the Commodity Code
equals Nursery, "0073", Orange Trees, "0207",
Grapefruit Trees, "0208", Lemon Trees, "0209",
Lime Trees, "0210", Other Citrus Trees, "0211",
Avocado Trees, "0212", Carambola Trees,"0213"
or Mango Trees, "0214" and the Late Reported
Reason Code is empty.

"*" = Output Only
3/6/2012

Page 10 of 24

Record
Number
P14

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number
27

Field Name
Fee Prepaid Flag

Insurance In Force
P14

Data Type

Max
Length

Character

1

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?
Y

Rules
Fee Prepaid Flag must be Yes, "Y" when fees were
prepaid before the due date, otherwise No, "N".
Fee Prepaid Flag must be No, "N" when Coverage
Code equals Catastrophic, "C".
FSA Administrative State Code must be valid; edit
with the State ADM, "A00520".
FSA Administrative County Code must be valid;
edit with the County ADM, "A00440".
FSA RMA Entity Difference Code must be valid;
edit with the FSA RMA Entity Difference ICE,
"D00112".

P14

28

FSA Administrative State Code

Character

2

P14

29

FSA Administrative County Code

Character

3

P14

30

FSA RMA Entity Difference Code

Character

2

P14

31

CIMS Information Code

Character

1

Reserved

P14

32

Administrative Fee Waiver Code

Character

1

Administrative Fee Waiver Code must be valid;
edit with the Administrative Fee Waiver ICE,
"D00030".

P14

33

Cancellation Transfer Signed Flag

Character

1

P14

34

Coverage Level Percent

Numeric

6

"*" = Output Only
3/6/2012

Page 11 of 24

9.9999

Y

Cancellation Transfer Signed Flag must be Yes, "Y"
if the Primary Producer signed a Cancellation and
Transfer Application, otherwise No, "N".

Y

Coverage Level Percent must be valid; edit with
the Coverage Level ICE, "D00024".

Record
Number
P14

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number
35

Field Name
Price Election Percent

Insurance In Force
P14

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Data Type

Max
Length

Format

Numeric

6

9.9999

BUS
Key Req?
Y

Rules
Price Election Percent must be valid; edit with
Price Election Percent ICE, "D00007".
Price Election Percent must equal 1.00 when the
Insurance Option Code List contains "CE", "CL",
"CH", "CV" or "HF".

P14

36

Dispute Settlement Code

Character

1

P14

37

Dispute Notification Date

Date

8

P14

38

Insurance Option Code List

Character

29

P14

39

Price Indicator Code

Character

1

"*" = Output Only
3/6/2012

Page 12 of 24

Dispute Settlement Code must be valid; edit with
the Dispute Settlement ICE, "D00013".
CCYYMMDD

Y

Dispute Notification Date is required when
Dispute Settlement Code is not empty.
Dispute Notification Date must be empty when
Dispute Settlement Code is empty.
Dispute Notification Date must equal a valid date
within the Reinsurance Year.
Insurance Option Code List must be valid; edit
with the Option Rate ADM, “A01060”.
Insurance Option Code List must be a
combination of "FR" and/or "YA" where Coverage
Type Code equals Catastrophic, "C" and
Commodity Code does not equal Silage Sorghum,
"0059"; otherwise empty.
Price Indicator Code must be valid; edit with the
Price Indicator ICE, "D00034".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Price Indicator Code must equal Additional Price,
"A" or Established Price, "E" when the Insurance
Plan Code equals Yield Based Dollar Amount of
Insurance, "55".
Price Indicator Code must equal Additional Price,
"A" or Established Price, "E" when the Insurance
Plan Code equals APH for Non-Combo
Commodites, "90" except when Commodity Code
equals Peanuts, "0075" or Hawaii Tropical Fruit
Trees, (0255, 0256, and 0257) which require Price
Indicator Code equal to Established Price, "E".

P14

40

Added County Indicator Code

Character

1

Added County Indicator Code must be valid; edit
with the Added County Indicator ICE, "D00003".
Added County Indicator Code is only valid with
Category "B" Commodity Codes excluding Forage
Production, "0033"; edit with the Commodity
Category ICE, "D00047".
Added County Indicator Code equal National "N"
is allowed for only one AIP Code/Commodity
Code/Insurance Plan Code.

"*" = Output Only
3/6/2012

Page 13 of 24

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Added County Indicator Code equal Primary, "P"
is allowed only once per Location State
Code/Commodity Code/Insurance Plan Code and
when no National "N" exists for the Commodity
Code/Insurance Plan Code.
Added County Indicator Code equal Subsequent,
"S" is allowed only with a corresponding Primary,
"P" record for the Location State
Code/Commodity Code/Insurance Plan Code.
Added County Indicator Code equal Subsequent,
"S" is allowed only when there is no Insurance In
Force "P14" record for the Location State
Code/Location County Code for the current
Commodity Year.
Added County Indicator Code equal Subsequent,
"S" is allowed only when a Primary Fund Code
has been previously accepted, the Coverage Type
Code does not equal Catastrophic, "C" and WA
Number is empty.
Added County Indicator Code is used to
determine LRR and can be added after Sales
Closing Date.

"*" = Output Only
3/6/2012

Page 14 of 24

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Added County Indicator Code must have a
previously accepted Primary Insurance In Force,
"P14" record.
Added County Indicator Code does not allow for
another Insurance In Force, "P14" record with a
different Commodity for the same Reinsurance
Year, AIP Code, Policy Number, Commodity Year,
State Code and County Code as this would not
qualify for Added County.
Added County Indicator Code allows only one
Insurance in Force, "P14" record when the Added
County Indicator Code equals Primary, "P" or
National, "N" or is empty and the Commodity
Code does not equal Grapes, "0053", Dry Beans,
"0047", Dry Peas "0067", Nursery, "0073",
Pasture, Rangeland and Forage (PRF), "0088",
Florida Citrus Trees or a Speciality Type and the
Location State Code does not equal "04" or "06"
and the Commodity Code equals "0052" when
one Type Code/Practice Code is submitted for
Group Plans ("04","05" and "06").

"*" = Output Only
3/6/2012

Page 15 of 24

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

P14

Field
Number
41

Field Name
Added County AIP Policy Producer Key

Insurance In Force
P14

Data Type

Max
Length

Character

15

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Added County AIP Policy Producer Key is required
when Added County Indicator Code equals
Subsequent "S", otherwise empty.
Added County AIP Policy Producer Key must equal
the corresponding Primary "P" or National "N"
Policy Producer, "P10" when Added County
Indicator Code equals Subsequent, "S".

P14

42

Added County AIP Insurance In Force Key

Character

15

P14

43

Policy History Request Code

Character

1

P14

*

44

Valid Commodity Type Code

Character

3

P14

*

45

Valid Class Code

Character

3

"*" = Output Only
3/6/2012

Page 16 of 24

Added County AIP Insurance In Force Key is
required when the Added County Indicator Code
equals Subsequent "S", otherwise empty.
Policy History Request Code must equal Yes, "Y"
for one year of history or Five, "F" for five years of
history.
Valid Commodity Type Code is populated from
the Valid Commodity Type Code in the Insurance
Offer ADM, "A00030".
Valid Class Code is populated from the Class Code
in the Insurance Offer ADM, "A00030".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

P14

*

46

P14

*

P14

Insurance In Force
P14

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Data Type

Max
Length

Valid Sub Class Code

Character

3

47

Valid Intended Use Code

Character

3

*

48

Valid Irrigation Practice Code

Character

3

P14

*

49

Valid Cropping Practice Code

Character

3

P14

*

50

Valid Organic Practice Code

Character

3

Valid Organic Practice Code is populated from
ADM Insurance Offer Organic Practice Code

P14

*

51

Valid Interval Code

Character

3

Valid Interval Code is populated from the Interval
Code in the Insurance Offer ADM, "A00030".

2

Lockdown Insurance Plan Code will be the
Insurance Plan Code submitted by the AIP at the
later of the LRR Lockdown Date or the Initial
Accepted Date.

P14

*

52

"*" = Output Only
3/6/2012

Field Name

Lockdown Insurance Plan Code

Character

Page 17 of 24

Format

BUS
Key Req?

Rules
Valid Sub Class Code is populated from the Sub
Class Code in the Insurance Offer ADM, "A00030".
Valid Intended Use Code is populated from the
Intended Use Code in the Insurance Offer ADM,
"A00030".
Valid Irrigation Practice Code is populated from
the Irrigation Practice Code in the Insurance Offer
ADM, "A00030".
Valid Cropping Practice Code is populated from
the cropping Practice Code in the Insurance Offer
ADM, "A00030".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Insurance In Force
P14

Data Type

Max
Length

Format

P14

*

53

Lockdown Price Election Percent

Numeric

6

9.9999

P14

*

54

Lockdown Coverage Level Percent

Numeric

6

9.9999

P14

*

55

LRR Percent

Numeric

4

9.99

P14

*

56

Lockdown Price Indicator Code

Character

1

P14

*

57

LRR Code

Character

2

P14

*

58

LRR Transaction Cutoff Date

Date

8

"*" = Output Only
3/6/2012

Page 18 of 24

CCYYMMDD

BUS
Key Req?

Rules
Lockdown Price Election Percent will be the Price
Election Percent submitted by the AIP at the later
of the LRR Lockdown Date or the Initial Accepted
Date.
Lockdown Coverage Level Percent will be the
Coverage Level Percent submitted by the AIP at
the later of the LRR Lockdown Date or the Initial
Accepted Date.
LRR Percent is the reduction percent for the later
of the Lockdown Date or Batch Received Date,
otherwise empty.
Lockdown Price Indicator Code will be the Price
Indicator Code submitted by the AIP at the later
of the LRR Lockdown Date or the Initial Accepted
Date.
LRR Code must be valid; edit with the LRR ICE,
"D00014".
LRR Transaction Cutoff Date is the Transaction
Cutoff Date for the week containing the 30th day
of the month after the Transaction Cutoff Date.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

P14

*

59

LRR Change Date

P14

*

60

LRR Transaction Code

Insurance In Force
P14

Data Type

Max
Length

Date

8

Character

2

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

CCYYMMDD

*

61

LRR Record Accepted Date

Date

8

CCYYMMDD

P14

*

62

Ineligible SBI Share Percent

Numeric

5

9.999

P14

*

63

Duplicate Policy Code

Character

1

P14

*

64

Duplicate AIP Code

Character

2

P14

*

65

Duplicate PIC Code

Character

3

P14

*

66

Duplicate Policy Number

Character

7

Page 19 of 24

Rules
LRR Change Date is the last date the Price Election
Percent, Price Indicator Code or Coverage Level
Percent was modified on the Insurance In Force,
"P14" or the Tax ID, Tax ID Type Code or Entity
Type Code was modified on the Policy Producer,
"P10" after the LRR Transaction Cutoff Date.
LRR Transaction Code must be valid; edit with the
LRR Transaction Code ICE, "D00046".

P14

"*" = Output Only
3/6/2012

BUS
Key Req?

LRR Record Accepted Date is the date this
Insurance In Force, "P14" record was accepted for
LRR edits.
Ineligible SBI Share Percent must be greater than
zero when SBI is ineligible.
Duplicate Policy Code must be valid; edit with the
Duplicate Policy ICE, "D00010".
Duplicate AIP Code is the code for the AIP with
the corresponding duplicate policy.
Duplicate PIC Code is the PIC Code on the
corresponding duplicate policy.
Duplicate Policy Number is the Policy Number of
the corresponding duplicate policy.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules

P14

*

67

Contract Carryover Flag

Character

1

Contract Carryover Flag equals Yes, "Y" when the
producer was insured for the AIP Code/Location
State Code/Location County Code/Commodity
Code/Insurance Plan Code in the previous year,
otherwise it equals No, "N".

P14

*

68

Eligibility Code

Character

8

Eligibility Code is the returned values from the
Ineligible Tracking System.

P14

*

69

Producer History Code

Character

6

Producer History Code must be valid; edit with
the Producer History ICE, "D00031".
Primary Fund Code must equal the Primary Fund
Code from the Fund Designation, "P09" record if
submitted; otherwise, Commercial "C".

P14

*

70

Primary Fund Code

Character

1

P14

*

71

Initial Accepted Batch Number

Numeric

4

9999

Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.

P14

*

72

Initial Accepted Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

Initial Accepted Date is the original date assigned
when this record was first received at RMA.

P14

*

73

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

P14

*

74

Batch Number

Numeric

4

9999

Batch Received Date is the date that the AIP file is
received by RMA.
Batch Number is a sequential number assigned
when an AIP file is received.

"*" = Output Only
3/6/2012

Page 20 of 24

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

P14

*

75

Batch Record ID

Numeric

15

P14

*

76

Process Result Code

Character

1

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Batch Record ID is a sequential number assigned
to each record in the AIP file by RMA during
processing. Batch Record ID is unique within the
record type for the batch.
Process Result Code equals the final result code as
determined by PASS processing, refer to the
Process Result ICE , "D00002".

Record Level Rules
Insurance in Force "P14" records will be rejected
if there is no accepted corresponding Policy
Producer, "P10" record.
To avoid incurring LRR, an Insurance In Force,
"P14" with the following elements must be
accepted before the LRR Cutoff Date: AIP Code,
Location State Code, Policy Number, Commodity
Code, Commodity Year, Insurance Plan Code,
Location County Code, Coverage Type Code, Late
Reported Reason Code, Dual Coverage Flag,
Contract Carryover Flag, Coverage Level Percent,
Price Election Percent, and Price Indicator Code.

"*" = Output Only
3/6/2012

Page 21 of 24

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
The Added County information contained on the
Insurance In Force, "P14" record is for
determining LRR, Added County reference can be
added after Sales Closing Date.
When the Insurance In Force, "P14" record is
submitted without a corresponding Fund
Designation, "P09", the record will be assigned to
the commercial fund.
A separate MPCI policy is allowed for acreage
grown under contract with different seed
companies for hybrid seed corn or hybrid
sorghum seed.
An Insurance In Force, "P14" record must be
submitted between 200100701 and 20150212
An Insurance In Force, "P14" record will not be
accepted when processing has been suspended
for this record type per RMA directive.
A proceeding Policy Producer, "P10" record in this
batch must be accepted for the Insurance In
Force, "P14" record to be accepted.
The count of Record Type Code must be less than
or equal to 2.

"*" = Output Only
3/6/2012

Page 22 of 24

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
Type Code or Practice Code must not be empty
when multiple rows are submitted by AIP Policy
Producer Key, Commodity Code, Location State
Code, Location County Code, and Commodity
Year with a varying Coverage Level Percent or
Price Election Percent when the insurance plan
Code equals Area Yield Protection "04", Area
Revenue Protection "05", Area Revenue
Protection with Harvest Price Exclusion "06".

The P14 record must be unique in the batch using
the following key: AIP Code, Reinsurance Year,
Policy Number, Location State Code, Location
County Code, Commodity Code, Coverage Type
Code, Dual Coverage Flag and Type Code for
Apples "0054" only if Type Code is not empty,
Grapes "0053", CA/AZ Table Grapes, "0052",
Tangerine Trees, "0193", Orange Trees, "0207",
Grapefruit Trees, "0208" and PRF "0088".

"*" = Output Only
3/6/2012

Page 23 of 24

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

Field
Number

Field Name

Insurance In Force
P14

Data Type

Max
Length

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules
When processing Insurance In Force, "P14"
records for Speciality Type Commodities, multiple
Insurance In Force, "P14" record submission is
allowed as long as the Acreage, "P11" indicates it
is a Speciality Type Commodity, the exact
Speciality Type does not need to match on the
Insurance In Force, "P14" and the Acreage, "P11"
records.
When processing Insurance In Force, "P14"
records for Speciality Type Commodities, multiple
Insurance In Force, "P14" record submission is
allowed as long as the Yield, "P15" indicates it is a
Speciality Type Commodity, the exact Speciality
Type does not need to match on the Insurance In
Force, "P14" and the Yield, "P15" records.

"*" = Output Only
3/6/2012

Page 24 of 24