Fund Designation Record Type 09

Fund Designation Record Type 09.pdf

Multiple Peril Crop Insurance

Fund Designation Record Type 09

OMB: 0563-0053

Document [pdf]
Download: pdf | pdf
Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

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

CCYY

Y

Y

Y

Y
Y
Y

Delimited
2016
Approved
7/1/2015

Rules
AIP Code must be valid; edit with AIP ICE
"D00100".
Reinsurance Year must equal "2016".
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".
Insurance Plan Code must not equal "81" or "82".

P09

9

Commodity Code

Character

4

P09

10

Commodity Year

Numeric

4

"*" = Output Only
6/25/2015

Page 1 of 36

Y
CCYY

Y
Y

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

Character

Max
Length

3

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Y

Delimited
2016
Approved
7/1/2015

Rules
Type Code must be valid; edit with Type ADM
"A00540" record, when Type Code is required or
when the Extended Type/Practice Codes are in
transition and the Type Code has been submitted.
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", 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", the Location State Code equals Texas,
"48" and the Extended Type/Practice Codes are in
transition, and any of the Extended Type Codes
have been omitted.

"*" = Output Only
6/25/2015

Page 2 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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" the Location State Code equals Texas,
"48" and the Extended Type/Practice Codes have
not been implemented.
Type Code must be empty when the Extended
Type/Practice Codes have been implemented.
Type Code must be empty when the Extended
Type/Practice Code fields are in transition, and
any of the Extended Type or Practice Codes have
been submitted.
Type Code is required when Commodity Code
equals Grapefruit, "0201", Lemons, "0202",
Tangelos, "0203", Oranges, "0227",
Mandarins/Tangerines, "0309", Tangors, "1302"
and Limes, "9936" and part of an Insurance Offer
Group and Location State Code equals Florida,
"12", Arizona, "04" and California, "06".

"*" = Output Only
6/25/2015

Page 3 of 36

Record
Number
P09

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number
12

Field Name
Practice Code

Fund Designation
P09

Data Type
Character

Max
Length
3

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?
Y

Delimited
2016
Approved
7/1/2015

Rules
Practice Code is required when Commodity Code
equals Nursery, "0073" and the Extended
Type/Practice Codes have not been implemented.
Practice Code is Required when Commodity Code
equals Nursery, "0073", the Extended
Type/Practice Codes are in transition, and any of
the Extended Type Codes have been omitted.
Practice Code must be empty when the Extended
Type/Practice Codes have been implemented.
Practice Code must be empty when the Extended
Type/Practice Code fields are in transition, and
any of the Extended Type or Practice Codes have
been submitted.
Practice Code must be valid; edit with Practice
ADM "A00510" record when Practice Code is
required or when the Extended Type/Practice
Codes are in transition and the Practice Code has
been submitted.

"*" = Output Only
6/25/2015

Page 4 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
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.
Practice Code cannot change between
submissions if it affects the Fund Cutoff Date.

P09

13

"*" = Output Only
6/25/2015

Commodity Type Code

Character

3

Page 5 of 36

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.

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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

P09

14

"*" = Output Only
6/25/2015

Class Code

Character

3

Page 6 of 36

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.

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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

P09

15

"*" = Output Only
6/25/2015

Sub Class Code

Character

3

Page 7 of 36

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.

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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

P09

16

"*" = Output Only
6/25/2015

Intended Use Code

Character

3

Page 8 of 36

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.

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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

P09

17

"*" = Output Only
6/25/2015

Irrigation Practice Code

Character

3

Page 9 of 36

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.

Record
Number

P09

P09

Output

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

18

19

Field Name

Cropping Practice Code

Organic Practice Code

Fund Designation
P09

Data Type

Character

Character

Max
Length

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

3

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

P09

20

Interval Code

Character

3

P09

21

Primary Fund Code

Character

1

"*" = Output Only
6/25/2015

File Type:
Reinsurance Year:
Version:
Release Date:

Page 10 of 36

Y

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.

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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

"*" = Output Only
6/25/2015

Page 11 of 36

Record
Number

P09

Output

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

22

Field Name

HR Fund Code

Fund Designation
P09

Data Type

Character

Max
Length

1

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
HR Fund Code is required when the HR Fund Code
is different from the Primary Fund Code for all
High Risk Land options; edit with the Fund ICE,
"D00009", otherwise empty.
HR Fund Code must be empty when the
Commodity Code equals Nursery, "0073".
HR Fund Code must equal Commercial, "C" if the
Batch Received Date is after the Fund Designation
Cutoff Date.
HR 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.
HR Fund Code can be changed to an Assigned Risk
Fund, "A" after the Fund Designation Cutoff Date
only by RMA approval.

"*" = Output Only
6/25/2015

Page 12 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
HR 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.
HR Fund Code must be empty when the
Commodity Code equals Cherries, "0057" and the
Type Code equals Tart Cherries, "416".

P09

23

"*" = Output Only
6/25/2015

WA Number

Character

9

Page 13 of 36

999999999

WA Number must be valid.
WA Number must not equal "000000000".

Record
Number

P09

Output

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

24

Field Name

Insured Commodity Signature Date

Fund Designation
P09

Data Type

Date

Max
Length

8

File Type:
Reinsurance Year:
Version:
Release Date:

Format

CCYYMMDD

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
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.
Insured Commodity Signature Date must be
between the Reinsurance Year minus one and the
Batch Received Date.

"*" = Output Only
6/25/2015

Page 14 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

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
6/25/2015

Page 15 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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 or National, "N" record for the AIP
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 Location 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.

"*" = Output Only
6/25/2015

Page 16 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Added County Indicator Code equal to
Subsequent, "S" is not allowed for Carryover
Policies where a Location County Code has been
insured for another Commodity Code in the
Current Year or the same Commodity Code in the
previous year.
Added County Indicator Code equal National, "N",
is allowed for only one AIP Code/Policy
Number/Commodity Code/Insurance Plan Code.
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.
Added County Indicator Code cannot equal "S"
when the Insurance Policy is carried over from the
previous year.
Added County Indicator Code equal to
Subsequent, "S" means that the Fund
Designation, "P09" record may not be submitted
before the Sales Closing Date.

"*" = Output Only
6/25/2015

Page 17 of 36

Record
Number

Output

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

P09

Field
Number

Field Name

Fund Designation
P09

Data Type

Max
Length

27

Added County AIP Fund Designation Key

Character

15

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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

P09

*

31

Valid Intended Use Code

Character

3

P09

*

32

Valid Irrigation Practice Code

Character

3

P09

*

33

Valid Cropping Practice Code

Character

3

"*" = Output Only
6/25/2015

Page 18 of 36

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
P09

P09

P09

Fund Designation
P09

File Type:
Reinsurance Year:
Version:
Release Date:

Delimited
2016
Approved
7/1/2015

Output

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

Field Name

Data Type

Max
Length

*

34

Valid Organic Practice Code

Character

3

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

*

35

Valid Interval Code

Character

3

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

*

36

Fund Designation Cutoff Date

Date

8

Format

CCYYMMDD

BUS
Key Req?

Rules

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

P09

P09

*

*

37

38

"*" = Output Only
6/25/2015

HR Cutoff Date

Contract Carryover Flag

Date

8

Character

1

Page 19 of 36

CCYYMMDD

HR Cutoff Date equals the HR 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".

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

Numeric

4

9999

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

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.

41

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

*

42

Batch Number

Numeric

4

9999

P09

*

43

Batch Record ID

Numeric

15

P09

*

44

Process Result Code

Character

1

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.
Process Result Code equals the final result code as
determined by PASS processing, refer to the
Process Result ICE , "D00002".

P09

*

39

Initial Accepted Batch Number

P09

*

40

P09

*

P09

"*" = Output Only
6/25/2015

Page 20 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

Record Level Rules

"*" = Output Only
6/25/2015

1

The Fund Designation, "P09" record will not be
accepted when processing has been suspended
for this record type per RMA directive.

2

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

3

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.

4

After Fund Designation Cutoff, every value on the
P09 must be the same as the prior submission.

5

The Fund Designations, "P09" record must pass all
edits and be accepted to establish the fund
designation for the eligible commodity insurance
contract.

Page 21 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Once a Fund Designation, "P09" is accepted for a
policy/commodity/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.

6

7

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

8

"*" = Output Only
6/25/2015

File Type:
Reinsurance Year:
Version:
Release Date:

Page 22 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

9

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.

10

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
6/25/2015

Page 23 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

11

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.

12

If the Sales Closing Date used for fund
designations varies by Insurance 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
6/25/2015

Page 24 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

13

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.

14

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
6/25/2015

Page 25 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

15

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

16

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.

17

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
6/25/2015

Page 26 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

18

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

19

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 Practice Code when Commodity Code equals
Nursery, "0073".

20

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
6/25/2015

Page 27 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

21

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

22

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 Nursery, "0073".

23

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
6/25/2015

Page 28 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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.

24

25
26

Previously Accepted Policy submissions must be
accepted before the Fund Cutoff date.

27

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

28

Insurance Offer must be valid when both Type
Code and Practice Code have been submitted,
edit with the Insurance Offer ADM, "A00030".

29

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
6/25/2015

Page 29 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

30

Insurance Offer must be valid when Practice Code
has been submitted and no Type Code has been
submitted, edit with Insurance Offer ADM,
"A00030".

31

Insurance Offer must be valid when both Type
Code and Practice Code have not been submitted,
edit with the Insurance Offer ADM, "A00030".

32

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
6/25/2015

Page 30 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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

33

"*" = Output Only
6/25/2015

File Type:
Reinsurance Year:
Version:
Release Date:

Page 31 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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 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", Florida, Arizona
and California Citrus Fruit Groups
(0201,0202,0203,0227,0309,1302,9936) or Texas
Citrus, Tangerine Trees, "0193", Orange Trees,
"0207", Grapefruit Trees, "0208" or Specialty
Types or commodities for the underlying policy,
SCO policy and STAX policy.

34

"*" = Output Only
6/25/2015

File Type:
Reinsurance Year:
Version:
Release Date:

Page 32 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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,
Commodity Year and Type Code when the
Commodity Code equals Table Grapes, "0052"
and the Location State Code equals Arizona, "04"
or when the Commodity Code equals Table
Grapes, "0052" or Grapes, "0053" and the
Location State Code equals California, "06" or
when the Commodity Code equals Tangerine
Trees, "0193", Orange Trees, "0207" or Grapefruit
Trees, "208" and the Location State Code equals
Texas, "48" or commodities for the underlying
policy, SCO policy and STAX policy.

35

"*" = Output Only
6/25/2015

File Type:
Reinsurance Year:
Version:
Release Date:

Page 33 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
For the record key AIP Code, AIP Fund
Designation Key, Reinsurance Year, the following
values must be the same as prior submission: AIP
Code, Commodity Code, Commodity Year,
Location County Code, Location State Code, Policy
Number, Reinsurance Year and Type Code when
the Commodity Code equals 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"
with a Location State Code equal to Texas, "48".

36

"*" = Output Only
6/25/2015

File Type:
Reinsurance Year:
Version:
Release Date:

Page 34 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

37

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 Code equal 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".

38

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 Duplicate Group
Code (Type Code) for California Grapes
(0052,0053), Arizona Grapes (0052), Cherries
(0057), Florida, Arizona and California Citrus Fruit
Groups (0201,0202,0203,0227,0309,1302,9936)
and Texas Citrus (0193,0207,0208).

"*" = Output Only
6/25/2015

Page 35 of 36

Record
Number

Output

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

Field Name

Fund Designation
P09

Data Type

Max
Length

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules

39

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 Practice Code when
the Commodity Code equals Nursery, "0073".

40

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 the
Commodity Code equals Table Grapes, "0052"
with a Location State Code equal to Arizona, "04"
or the Commodity Code equals Table Grapes,
"0052" or Grapes "0053" with a Location State
Code equal to California, "06", or the Commodity
Code equals Tangerine Trees, "0193", Orange
Trees, "0207" or Grapefruit Trees, "208" with a
Location State Code equal to Texas, "48".

"*" = Output Only
6/25/2015

Page 36 of 36


File Typeapplication/pdf
File TitleP09 Fund Designation Record
AuthorTodd Stinson
File Modified2015-06-25
File Created2015-06-25

© 2024 OMB.report | Privacy Policy