P09 Fund Designation Record

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

P09

1

AIP Code

Character

2

P09
P09

2
3

Reinsurance Year
Record Type Code

Numeric
Character

4
6

P09

4

AIP Fund Designation Key

Character

15

P09

5

Policy Number

Character

7

Y

Y

P09

6

Location State Code

Character

2

Y

Y

P09

7

Location County Code

Character

3

Y

Y

P09

8

Insurance Plan Code

Character

2

Y

Y

P09

9

Commodity Code

Character

4

Y

Y

P09

10

Commodity Year

Numeric

4

"*" = Output Only
2/17/2012

Page 1 of 30

CCYY

Y

Y

Y

Y
Y
Y

CCYY

Y

Rules
AIP Code must be valid; edit with AIP ICE
"D00100".
Reinsurance Year must equal "2012".
Record Type Code must equal "P09".
AIP Fund Designation Key must be unique within
the submitted Fund Designation, "P09" records.
Policy Number must be exactly 7 characters in
length.
Policy Number must contain only numeric
characters.
Policy Number must not equal "0000000".
Location State Code must be valid; edit with the
State ADM, "A00520".
Location State Code must be valid for the AIP/PIC
Code; edit with the AIP State table.
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
P09

Output

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

Field
Number
11

Field Name
Type Code

Fund Designation
P09

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 is required when Commodity Code
equals Table Grapes, "0052", or Grapes, "0053".
Type Code must be valid; edit with Type ADM
"A00540".
Type Code is required if necessary to determine
the Sales Closing Date; if not submitted the
earliest Sales Closing Date for the Location County
Code/Commodity Code/Insurance Plan Code will
be used to establish the Fund Cut Off Date.
Type Code is Required when Commodity Code
equals Table Grapes, "0052" or Grapes, "0053"
and the Location State Code equals Arizona, "04"
or California, "06" or the Commodity Code equals
Tangerine Trees, "0193", Orange Trees, "0207" or
Grapefruit Trees, "0208" and the Extended
Type/Practice Codes have not been implemented.

"*" = Output Only
2/17/2012

Page 2 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
Type Code is Required when Commodity Code
equals Table Grapes, "0052", Grapes, "0053" and
the Location State Code equals California, "06" or
the Commodity Code equals Tangerine Trees,
"0193", Orange Trees, "0207" or Grapefruit Trees,
"0208" and the Extended Type/Practice Codes are
in transition, and any of the Extended Type Codes
have been omitted.

P09

12

Practice Code

Character

3

Y

Practice Code is required when Commodity Code
equals Nursery, "0073".
Practice Code must be valid; edit with 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.

"*" = Output Only
2/17/2012

Page 3 of 30

Record
Number

P09

Output

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

Field
Number

13

Field Name

Commodity Type Code

Fund Designation
P09

Data Type

Character

Max
Length

3

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

Format

BUS
Key Req?

Rules
Commodity Type Code must be valid; edit with
the Commodity Type ADM, "A00430". When
Commodity Type Code is not valid and Type
Practice Use Code equals Implemented, "I",
record will be rejected, otherwise record will be
accepted with a warning.
Commodity Type Code is Required when the
Commodity Code equals Table Grapes, "0052", or
Grapes, "0053" and the Location State Code
equals California, "06" or or the Commodity
Code equals Tangerine Trees, "0193", Orange
Trees, "0207" or Grapefruit Trees, "0208" and the
Extended Type/Practice Codes have not been
implemented.
Commodity Type Code is Required when the
Commodity Code equals Table Grapes, "0052", or
Grapes, "0053" and the Location State Code
equals California, "06" or or the Commodity
Code equals Tangerine Trees, "0193", Orange
Trees, "0207" or Grapefruit Trees, "0208" and the
Extended Type/Practice Codes are in transition,
and the Type Code has been omitted.

"*" = Output Only
2/17/2012

Page 4 of 30

Record
Number

P09

Output

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

Field
Number

14

Field Name

Class Code

Fund Designation
P09

Data Type

Character

Max
Length

3

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

Format

BUS
Key Req?

Rules
Class Code must be valid; edit with the Class
ADM, "A00410". When Class Code is not valid and
Type Practice Use Code equals Implemented, "I",
record will be rejected, otherwise record will be
accepted with a warning.

Class Code is Required when the Commodity Code
equals Table Grapes, "0052", or Grapes, "0053"
and the Location State Code equals California,
"06" or the Commodity Code equals Tangerine
Trees, "0193", Orange Trees, "0207" or Grapefruit
Trees, "0208" and the Extended Type/Practice
Codes have been implemented.
Class Code is Required when the Commodity Code
equals Table Grapes, "0052", or Grapes, "0053"
and the Location State Code equals California,
"06" or the Commodity Code equals Tangerine
Trees, "0193", Orange Trees, "0207" or Grapefruit
Trees, "0208" and the Extended Type /Practice
Codes are in transition, and the Type Code has
been omitted.
"*" = Output Only
2/17/2012

Page 5 of 30

Record
Number

P09

Output

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

Field
Number

15

Field Name

Sub Class Code

Fund Designation
P09

Data Type

Character

Max
Length

3

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

Format

BUS
Key Req?

Rules
Sub Class Code must be valid; edit with the Sub
Class ADM, "A00530". When Sub Class Code is not
valid and Type Practice Use Code equals
Implemented, "I", record will be rejected,
otherwise record will be accepted with a warning.
Sub Class Code is Required when the Commodity
Code equals Table Grapes, "0052", or Grapes,
"0053" and the Location State Code equals
California, "06" or the Commodity Code equals
Tangerine Trees, "0193", Orange Trees, "0207" or
Grapefruit Trees, "0208" and the Extended
Type/Practice Codes have been implemented.
Sub Class Code is Required when the Commodity
Code equals Table Grapes, "0052", or Grapes,
"0053" and the Location State Code equals
California, "06" or the Commodity Code equals
Tangerine Trees, "0193", Orange Trees, "0207" or
Grapefruit Trees, "0208" and the Extended Type
/Practice Codes are in transition, and the Type
Code has been omitted.

"*" = Output Only
2/17/2012

Page 6 of 30

Record
Number

P09

Output

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

Field
Number

16

Field Name

Intended Use Code

Fund Designation
P09

Data Type

Character

Max
Length

3

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

Format

BUS
Key Req?

Rules
Intended Use Code must be valid; edit with the
Intended Use ADM, "A00470". When Intended
Use Code is not valid and Type Practice Use Code
equals Implemented, "I", record will be rejected,
otherwise record will be accepted with a warning.
Intended Use Code is Required when the
Commodity Code equals Table Grapes, "0052", or
Grapes, "0053" and the Location State Code
equals California, "06" or the Commodity Code
equals Tangerine Trees, "0193", Orange Trees,
"0207" or Grapefruit Trees, "0208" and the
Extended Type/Practice Codes have been
implemented.
Intended Use Code is Required when the
Commodity Code equals Table Grapes, "0052", or
Grapes, "0053" and the Location State Code
equals California, "06" or the Commodity Code
equals Tangerine Trees, "0193", Orange Trees,
"0207" or Grapefruit Trees, "0208" and the
Extended Type /Practice Codes are in transition,
and the Type Code has been omitted.

"*" = Output Only
2/17/2012

Page 7 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

P09

17

Irrigation Practice Code

Character

3

P09

18

Cropping Practice Code

Character

3

P09

P09

19

20

"*" = Output Only
2/17/2012

Organic Practice Code

Interval Code

Character

Character

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

Format

BUS
Key Req?

Rules
Irrigation Practice Code must be valid; edit with
the Irrigation Practice ADM, "A00490". When
Irrigation Practice Code is not valid and Type
Practice Use Code equals Implemented, "I",
record will be rejected, otherwise record will be
accepted with a warning.
Cropping Practice Code must be valid; edit with
the Cropping Practice ADM, "A00450". When
Cropping Practice Code is not valid and Type
Practice Use Code equals Implemented, "I",
record will be rejected, otherwise record will be
accepted with a warning.

3

Organic Practice Code must be valid; edit with the
Organic Practice ADM, "A00500". When Organic
Practice Code is not valid and Type Practice Use
Code equals Implemented, "I", record will be
rejected, otherwise record will be accepted with a
warning.

3

Interval Code must be valid; edit with the Interval
ADM, "A00480". When Interval Code is not valid
and Type Practice Use Code equals Implemented,
"I", record will be rejected, otherwise record will
be accepted with a warning.

Page 8 of 30

Record
Number
P09

Output

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

Field
Number
21

Field Name
Primary Fund Code

Fund Designation
P09

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
Primary Fund Code must be valid; edit with the
Fund ICE, "D00009".
Primary Fund Code must equal Commercial, "C" if
the Batch Received Date is after the Fund
Designation Cutoff Date.
Primary Fund Code can be changed after the Fund
Designation Cutoff Date with RMA approval when
the Coverage Code equals Catastrophic, "C" on
the corresponding Insurance In Force, "P14" and
the Alternate Commodity Designation Code
equals Alternate, "A", otherwise empty.
Primary Fund Code can be changed to an Assigned
Risk Fund, "A" after the Fund Designation Cutoff
Date only by RMA approval.

"*" = Output Only
2/17/2012

Page 9 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
Primary Fund Code must equal the Primary Fund
Code on the corresponding Fund Designation,
"P09", when Added County Indicator Code equals
Subsequent, "S". The corresponding Fund
Designation "P09" is determined by either a
match on the Primary Producer/Commodity
Code/Location State Code/Location County Code
and a Primary, "P" in the Added County Indicator
Code or a match on the Primary
Producer/Commodity Code and a National, "N" in
the Added County Indicator Code.

P09

22

HRC Fund Code

Character

HRC Fund Code is required when the HRC Fund
Code is different from the Primary Fund Code;
edit with the Fund ICE, "D00009", otherwise
empty.
HRC Fund Code must be empty when the
Commodity Code equals Nursery, "0073".

1

HRC Fund Code must be empty when the
Coverage Code equals Catastrophic, "C" on the
corresponding Insurance In Force, "P14" record.
P09

23

"*" = Output Only
2/17/2012

WA Number

Character

9

Page 10 of 30

999999999

WA Number must be valid; edit with the ICE
Written Agreement Table.

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
WA Number can not be changed after the Fund
Designation Cutoff Date.
WA Number must not equal "000000000".

P09

24

Insured Commodity Signature Date

Date

8

CCYYMMDD

Insured Commodity Signature Date is required
when an Insurance In Force, "P14" record does
not exist for the AIP Code/Policy
Producer/Commodity Code/Insurance Plan Code/
Location State Code/Location County Code in the
previous year and Commodity Code equals
Florida Fruit Trees, "0207, 0208, 0209, 0210,
0211, 0212, 0213, 0214" and Nursery, "0073",
otherwise empty.
Insured Commodity Signature Date must be
empty when Contract Carryover Flag equals "Y".
Insured Commodity Signature Date is used to
determine Fund Designation Cutoff Date for any
Commodity Code without a fixed sales closing
date when an Insurance In Force, "P14" record
does not exist for the AIP Code/Policy
Producer/Commodity Code/Insurance Plan Code/
Location State Code/Location County Code in the
previous year.

"*" = Output Only
2/17/2012

Page 11 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

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 the Reinsurance Year minus one and the
Batch Received Date.

P09

25

Alternate Commodity Designation Code

Character

1

Alternate Commodity Designation Code must be
Alternate, "A" when the Coverage Code equals
Catastrophic, "C" on the corresponding Insurance
In Force, "P14" record, the Batch Received Date is
after the Fund Designation Cut-off Date, and RMA
has pre-approved, otherwise empty.

P09

26

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 Commodity
Category ICE , "D00047".
Added County Indicator Code equal Primary, "P"
is allowed only once per Policy Producer/Location
State Code/Commodity Code/Insurance Plan
Code, per State, and where no National, "N"
record has been identified for the Policy
Producer/Commodity Code/Insurance Plan Code.

"*" = Output Only
2/17/2012

Page 12 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

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 Subsequent,
"S" is allowed only when the record is submitted
with a corresponding Primary, "P" record for the
Location State Code/Commodity Code/Insurance
Plan Code after the Fund Designation Cutoff Date.
Added County Indicator Code equal Subsequent,
"S" is allowed only when there is no Insurance In
Force, "P14" record for the Locati+J68on State
Code/Location County Code for the current
Commodity Year and the record is submitted after
the Sales Closing Date.
Added County Indicator Code equal Subsequent,
"S" is allowed only when a Primary Fund Code
has previously been accepted.
Added County Indicator Code equal National, "N",
is allowed for only one AIP Code/Policy
Number/Commodity Code/Insurance Plan Code.

"*" = Output Only
2/17/2012

Page 13 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

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 National, "N"
or Primary, "P" is allowed only when the record is
submitted on or before the Fund Designation
Cutoff Date and cannot be changed after the Fund
Designation Cutoff Date.

P09

27

Added County AIP Fund Designation Key

Character

15

Added County Indicator Code cannot equal "S"
when the Insurance Policy is carried over from the
previous year.
Added County AIP Fund Designation Key must
equal the corresponding AIP Fund Designation
Key for the Primary "P" or National, "N" Fund
Designation, "P09" record when Added County
Indicator Code equals Subsequent, "S", otherwise
empty.
Valid Commodity Type Code is populated from
the Valid Commodity Type Code in the Insurance
Offer ADM, "A00030".

P09

*

28

Valid Commodity Type Code

Character

3

P09

*

29

Valid Class Code

Character

3

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

P09

*

30

Valid Sub Class Code

Character

3

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

"*" = Output Only
2/17/2012

Page 14 of 30

Record
Number

Output

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

Field
Number

P09

*

31

P09

*

P09

Fund Designation
P09

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

Data Type

Max
Length

Valid Intended Use Code

Character

3

32

Valid Irrigation Practice Code

Character

3

*

33

Valid Cropping Practice Code

Character

3

P09

*

34

Valid Organic Practice Code

Character

3

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

P09

*

35

Valid Interval Code

Character

3

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

8

Fund Designation Cutoff Date equals the cutoff
date for the Primary Fund as determined by the
LRR Fund Cutoff ICE, "D00018".

P09

*

36

Field Name

Fund Designation Cutoff Date

Date

Format

BUS
Key Req?

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

CCYYMMDD

Fund Designation Cutoff Date equals the earliest
Sales Closing Date plus thirty days when the
Commodity Code does not equal Nursery, "0073",
or Grapes, "0052" and "0053", or

"*" = Output Only
2/17/2012

Page 15 of 30

Record
Number

Output

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

Field
Number

P09

*

37

Field Name
HRC Cutoff Date

Fund Designation
P09

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

Data Type

Max
Length

Format

Date

8

CCYYMMDD

BUS
Key Req?

Rules
HRC Cutoff Date equals the HRC Cutoff Date for
the Primary Fund as determined by the LRR Fund
Cutoff ICE, "D00018".
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".

P09

*

38

Contract Carryover Flag

Character

1

P09

*

39

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.

P09

*

40

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.

P09

*

41

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

P09

*

42

Batch Number

Numeric

4

9999

P09

*

43

Batch Record ID

Numeric

15

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

"*" = Output Only
2/17/2012

Page 16 of 30

Record
Number

Output

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

Field
Number

P09

*

44

"*" = Output Only
2/17/2012

Field Name
Process Result Code

Fund Designation
P09

Data Type

Max
Length

Character

1

Page 17 of 30

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

Format

BUS
Key Req?

Rules
Process Result Code equals the final result code as
determined by PASS processing, refer to the
Process Result ICE , "D00002".

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules

Record Level Rules
The Fund Designation, "P09" record will not be
accepted when processing has been suspended
for this record type per RMA directive.
The Fund Designation, "P09" record must be
submitted between 7/1/2011 and 2/12/2015.
The Fund Designation, "P09" 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, Practice Code when Commodity Code is
'0073'.
For the record key AIP Code, Reinsurance Year,
AIP Fund Designation Key, the following values
must be the same as prior submission: AIP Code,
Reinsurance Year, Policy Number, Location State
Code, Location County Code, Commodity Code.
After Fund Designation Cutoff, every value on the
P09 must be the same as the prior submission.

"*" = Output Only
2/17/2012

Page 18 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
The Fund Designations, "P09" record must pass all
edits and be accepted to establish the fund
designation for the eligible commodity insurance
contract.
Once a Fund Designation, "P09" is accepted for a
policy/commmodity/county into a fund it doesn't
need to be resent, unless to timely modify the
fund designation.
Fund Designation, "P09" will be accepted
independently of any other record types.
A Fund Designation, "P09" record must have been
previously accepted with the following matching
values: InsurancePlanCode AND
CoverageTypeCode AND AipCode AND
ReinsuranceYear AND
AddedCountyAipPolicyProducerKey AND
AddedCountyAipInsuranceInForceKey AND
CommodityYear AND CommodityCode AND
CoverageLevelPercent AND PriceElectionPercent
AND PriceIndicatorCode when WA Number is
empty and Coverage Type Code does not equal
"C" and the Added County Indicator Code equals
"S".

"*" = Output Only
2/17/2012

Page 19 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
A change to the Fund Designation,"P09" will be
accepted for Spring Commodity prior to Spring
cutoff date when AIP Code/Location State
Code/Location County Code/Commodity Code
contains multiple Sales Closing Dates for Spring or
Fall type and Fund Designation, "P09" was
reported to the RMA before Fall Cutoff Date for
Commodities with or without Fall type.
Resubmission of the Fund Designation, "P09" with
a Spring type will be accepted and the Fund
Designation Cutoff Date will be calculated from
the Spring Sales Closing Date.
When multiple Sales Closing Dates exist for a AIP
Code/Location State Code/Location County
Code/Commodity Code, the submission of a Fund
Designation, "P09" record containing valid a Type
Code and Practice Code will be used to designate
the correct Sales Closing Date.

"*" = Output Only
2/17/2012

Page 20 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
When multiple Sales Closing Date exist for a AIP
Code/Location State Code/Location County
Code/Commodity Code and the submitted Fund
Designation, "P09" record does not contain a valid
Type Code or Practice Code, the earliest Sales
Closing Date for the Location County
Code/Commodity Code, Insurance Plan Code will
be used to determine the Fund Designation Cutoff
Date.
If the Sales Closing Date used for fund
designations varies by Insursnce Plan Code, Type
Code or Practice, the PASS lookup will use them
to determine the Sales Closing Date if submitted,
otherwise PASS will use the earliest Sales Closing
Date for the Location County Code/Commodity
Code/Insurance Plan Code to establish the fund
cutoff date.

"*" = Output Only
2/17/2012

Page 21 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
A change in fund designation will be allowed for
spring commodities before the spring cutoff date
if: The state/county/commodity has multiple sales
closing dates by spring or fall types and the AIP
submitted a Fund Designation, "P09" record
before fall cutoff date (with or without a fall type)
and insured is not planting the fall type.
Resubmitting the Fund Designation, "P09" record
with a spring type will be allowed and the fund
designation cutoff sent.
This 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, and Commodity Year
except when Commodity Code equal Grapes
"0052", "0053", Nursery "0073", and Specialty
Types.

"*" = Output Only
2/17/2012

Page 22 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
This 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, and Type Code when
Commodity Code equal to Grapes "0052", "0053".
For the record key AIP Code, Reinsurance Year,
AIP Fund Designation Key, the following values
must be the same as prior submission: AIP Code,
Reinsurance Year, Policy Number, Location State
Code, Location County Code, Commodity Code,
Commodity Year when Commodity Code is not
equal to Table Grapes "0052", Grapes, "0053",
Nursery, "0073" or a Specialty Type.
The business key AIP Code, Reinsurance Year,
Policy Number, Location State Code, Location
County Code, Commodity Code, Commodity Year
must not have already been accepted for a
different record key: AIP Code, Reinsurance Year,
AIP Fund Designation Key when Commodity Code
is not equal to Table Grapes "0052", Grapes,
"0053", Nursery, "0073" or a Specialty Type.

"*" = Output Only
2/17/2012

Page 23 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
For the record key AIP Code, Reinsurance Year,
AIP Fund Designation Key, the following values
must be the same as prior submission: AIP Code,
Reinsurance Year, Policy Number, Location State
Code, Location County Code, Commodity Code,
Type Code when Commodity Code equal Grapes
"0052" or "0053".
For the record key AIP Code, Reinsurance Year,
AIP Fund Designation Key, the following values
must be the same as prior submission: AIP Code,
Reinsurance Year, Policy Number, Location State
Code, Location County Code, Commodity Code,
Practice Code when Commodity Code equal
Nursery, "0073".
For the record key AIP Code, Reinsurance Year,
AIP Fund Designation Key, the following values
must be the same as prior submission: AIP Code,
Reinsurance Year, Policy Number, Location State
Code, Location County Code, Commodity Code,
Insurance Plan Code when Commodity is a
Specialty Type.

"*" = Output Only
2/17/2012

Page 24 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
The business key AIP Code, Reinsurance Year,
Policy Number, Location State Code, Location
County Code, Commodity Code, Commodity Year
must not have already been accepted for a
different record key: AIP Code, Reinsurance Year,
AIP Fund Designation Key when Commodity Code
equals Table Grapes "0052" or Grapes, "0053".
The business key AIP Code, Reinsurance Year,
Policy Number, Location State Code, Location
County Code, Commodity Code, Commodity Year
must not have already been accepted for a
different record key: AIP Code, Reinsurance Year,
AIP Fund Designation Key when Commodity Code
is equals Nursery, "0073".
The business key AIP Code, Reinsurance Year,
Policy Number, Location State Code, Location
County Code, Commodity Code, Commodity Year
must not have already been accepted for a
different record key: AIP Code, Reinsurance Year,
AIP Fund Designation Key when Commodity is a
Specialty Type.

"*" = Output Only
2/17/2012

Page 25 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
Insurance Plan Code may not be changed if the
Primary Fund Code does not equal the previously
submitted Primary Fund Code and Batch Received
Date is greater than Fund Designation Cutoff
Date.
Fund Designation Cutoff Date was not able to be
determined.
Previously Accepted Policy submissions must be
accepted before the Fund Cutoff date.
Record must be accepted before the Fund Cutoff
date when Added County Indicator Code is not
equal to 'S' or Primary Fund Code is not equal to
'C'.
Insurance Offer must be valid when both Type
Code and Practice Code have been submitted,
edit with the Insurance Offer ADM, "A00030".
Insurance Offer must be valid when Type Code
has been submitted and no Practice Code has
been submitted, edit with Insurance Offer ADM,
"A00030".

"*" = Output Only
2/17/2012

Page 26 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
Insurance Offer must be valid when Practice Code
has been submitted and no Type Code has been
submitted, edit with Insurance Offer ADM,
"A00030".
Insurance Offer must be valid when both Type
Code and Practice Code have not been submitted,
edit with the Insurance Offer ADM, "A00030".
For the record key AIP Code, Reinsurance Year,
AIP Fund Designation Key, the following values
must be the same as prior submission: AIP Code,
Reinsurance Year, Policy Number, Location State
Code, Location County Code, Commodity Code,
and Commodity Year when Commodity Code is
not Table Grapes "0052" or Grapes "0053"and the
Location State Code equals Arizona, "04" or
California, "06", or the Commodity Code is not
Tangerine Trees, "0193", Orange Trees, "0207" or
Grapefruit Trees, "208".

"*" = Output Only
2/17/2012

Page 27 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
For the record key AIP Code, Reinsurance Year,
AIP Fund Designation Key, the following values
must be the same as prior submission: AIP Code,
Reinsurance Year, Policy Number, Location State
Code, Location County Code, Commodity Code,
and Type Code when Commodity Code is Grapes,
"0053" and the Location State Code equals
Arizona, "04" or California, "06" or the
Commodity Code equals Texas Citrus, Tangerine
Trees, "0193", Orange Trees, "0207" or Grapefruit
Trees, "0208".
This 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, and Commodity Year for
everything except Grapes, "0053" and Table
Grapes "0052" with a Location State Code equal
to Arizona, "04" or California, "06" or Commodity
Codes equal to Nursery, "0073", or Texas Citrus,
Tangerine Trees, "0193", Orange Trees, "0207",
Grapefruit Trees, "0208" or a Specialty Types.

"*" = Output Only
2/17/2012

Page 28 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
For the record key AIP Code, Reinsurance Year,
AIP Fund Designation Key, the following values
must be the same as prior submission: AIP Code,
Reinsurance Year, Policy Number, Location State
Code, Location County Code, Commodity Code,
and Commodity Year when Commodity Code is
not Commodity Code is not Table Grapes "0052"
or Grapes "0053"and the Location State Code
equals Arizona, "04" or California, "06", or the
Commodity Code is not Tangerine Trees, "0193",
Orange Trees, "0207" or Grapefruit Trees, "208".
For the record key AIP Code, Reinsurance Year,
AIP Fund Designation Key, the following values
must be the same as prior submission: AIP Code,
Reinsurance Year, Policy Number, Location State
Code, Location County Code, Commodity Code,
and Type Code when Commodity Code is Table
Grapes "0052" or Grapes "0053" with a Location
State Code equal to Arizona, "04" or California,
"06", or the Commodity Code equals Tangerine
Trees, "0193", Orange Trees, "0207" or Grapefruit
Trees, "208".

"*" = Output Only
2/17/2012

Page 29 of 30

Record
Number

Output

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

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

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

Format

BUS
Key Req?

Rules
This 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, and Commodity Year for
everything except Commodity Codeequal to Table
Grapes "0052" or Grapes "0053" with a Location
State Code equal to Arizona, "04" or California,
"06", or a Commodity Code equal to Tangerine
Trees, "0193", Orange Trees, "0207" or Grapefruit
Trees, "208".

This 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, and Type Code for
California grapes (0052,0053), Arizona grapes
(0052), and Texas Citrus (0193,0207,0208).|

"*" = Output Only
2/17/2012

Page 30 of 30