P27 Land Record

Status: Original and derived artifacts are available for this document.

Download: pdf

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

Data Type

Max
Length

Format

BUS
Key Req?

P27

1

AIP Code

Character

2

Y

P27
P27

2
3

Reinsurance Year
Record Type Code

Numeric
Character

4
6

P27

4

AIP Policy Producer Key

Character

15

Y

P27

5

AIP Insurance in Force Key

Character

15

Y

P27

6

AIP Acreage Key

Character

15

Y

CCYY

Y
Y

Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Current Reinsurance Year.
Record Type Code must be "P27".
AIP Policy Producer Key must match the parent
primary Policy Producer, "P10" record.
AIP Insurance In Force Key must match the
primary Insurance in Force, "P14" record.
AIP Acreage Key is required when AIP Inventory
Value Key is empty.
AIP Acreage Key must be empty when AIP
Inventory Value Key is populated.
AIP Acreage Key is the value used to identify each
Acreage, "P11" record and must be unique within
the Reinsurance Year and the parent Insurance In
Force, "P14" record.

P27

7

AIP Inventory Value Key

Character

15

Page 1 of 15

Y

AIP Inventory Value Key is required when AIP
Acreage Key is empty.
AIP Inventory Value Key must be empty when AIP
Acreage Key is populated.
AIP Inventory Value Key is the value used to
identify each Inventory Value, "P13" record and
must be unique within the Reinsurance Year and
the parent Insurance In Force, "P14" record.

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

Data Type

Max
Length

P27

8

AIP Land Key

Character

15

P27

9

Reported Land Type Code

Character

1

Format

BUS
Key Req?

Y

Rules
AIP Land Key is the value used to identify each
Land, "P27" record and must be unique within the
Reinsurance Year and the parent Insurance In
Force, "P14" record. (Note: For split land, the AIP
Land Key must be reported once for each AIP
Acreage Key).
Reported Land Type Code is required and must be
valid; edit with the Reported Land Identifier Type
ICE, "D00061".
Reported Land Type Code must equal PRF, "P"
when the Insurance Plan Code equals Rainfall
Index, "13" except for PRF and Apiculture.

P27

10

Land Identifier

Character

18

Page 2 of 15

Reported Land Type Code must equal "C" or "R"
when the associated Acreage, "P11" record
contains "NS" or "N8" in the Program Indicator
Code List.
Reported Land Type Codes "C", "F" or "R" are
allowed for Insurance Plan Codes "31", "32", "33",
"35", and "36".
Land Identifier is required when Reported Land
Type Code contains one of the following values,
Legal, "L", Aquaculture, "A" or Other, "O",
otherwise empty.
Land Identifier format must equal "ssss-tttd-rrrd"
where "s" equal Section, "t" equals Township, "r"
equals Range and "d" equals Direction when the
Land Identifier Type Code equals Legal
Description, "L".

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Land Identifier must be valid when the Reported
Land Type Code equals Legal Description, "L"; edit
with the Legal Description ICE, "D00062".
Land Identifier is required and must be a valid
growing location such as lease, parcel, permit or
license number when Reported Land Type Code
equals Aquaculture, "A".
Land Identifier is required and must be a valid
growing location when Reported Land Type Code
equals Other, "O".
Land Identifier must be empty when Reported
Land Type Code is FSN, "F" or CLU, "C" or Annual
Forage/PRF, "P".

P27

P27

11

12

CLU ID

FSA Farm Number

Character

Character

36

7

CLU ID must match the value in the CLU Table.
CLU ID must be empty when FSA Farm Number,
FSA Tract Number and FSA Field Number are
empty.
A valid CLU ID is required and the Reported Land
Type Code must equal "C" when the associated
Acreage, "P11" record contains "NS" in the
Program Indicator Code List.
FSA Farm Number must be populated when
Reported Land Type Code equal FSN, "F", CLU, "C"
or Annual Forage/PRF, "P".
FSA Farm Number is required when the Insurance
Plan Code equals Rainfall Index, "13" except when
Commodity Code equals Apiculture, "1191".

Page 3 of 15

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

Data Type

Max
Length

Format

BUS
Key Req?

Rules
FSA Farm Number must not be found; edit with
the ICE ARC Election table when Non Premium
Acreage Code is not equal to 'J' and Insurance
Plan Code is one of the following values: '31', '32',
'33'.
FSA Farm Number must be valid; edit with the ICE
ARC Election table when Non Premium Acreage
Code is 'J' and Insurance Plan Code is one of the
following values: '31', '32', '33'.

P27

13

FSA Tract Number

Character

7

FSA Tract number must be populated when
Reported Land Type Code equal CLU, "C" or
Annual Forage/PRF, "P".
FSA Tract Number is required when the Insurance
Plan Code equals Rainfall Index, "13" except when
Commodity Code equals Apiculture, "1191".

P27

14

FSA Field Number

Character

7

FSA Field Number must be populated when
Reported Land Type Code equal CLU, "C" or
Annual Forage/PRF, "P".
FSA Field Number is required when the Insurance
Plan Code equals Rainfall Index, "13" except when
Commodity Code equals Apiculture, "1191".

P27

15

FSA Sub Field Identifier

Character

3

P27

16

FSA Intended Use

Character

2

Page 4 of 15

FSA Sub Field Identifier when submitted must
contain only alphanumeric or numeric characters
when Reported Land Type Code equals CLU, "C".
FSA Intended Use must be valid for the
commodity being grown and produced; edit with
the FSA Intended Use ICE, "D00111".

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number
P27

Output

Application Source:
File Group:
Record Name: Land
Record Code: P27
Field
Number
17

Field Name
FSA Administrative State Code

Data Type

Max
Length

Character

2

Format

BUS
Key Req?
Y

Rules
FSA Administrative State Code is required when
the FSA Administrative State does not equal the
Location State Code and the Reported Land Type
Code equal FSN, "F" or CLU, "C".
FSA Administrative State Code is Required when
FSA Administrative County Code exists.
FSA Administrative State Code must be empty
when Reported Land Type Code does not equal,
CLU, "C", PRF, "P" or FSN, "F".
FSA Administrative State Code must be empty
when FSA Administrative County Code is empty.

P27

18

FSA Administrative County Code

Character

3

Y

FSA Administrative County Code is required when
the FSA Administrative County does not equal the
Location County Code and the Reported Land
Type Code equal FSN, "F" or CLU, "C".
FSA Administrative County Code must be empty
when Reported Land Type Code does not equal,
CLU, "C", Annual Forage/PRF, "P" or FSN, "F".
FSA Administrative County Code is required when
the FSA Administrative State Code exists.

P27

19

CLU Determination Code

Character

1

Page 5 of 15

CLU Determination Code must be valid; edit with
the CLU Determination ICE, "D00122".
CLU Determination Code must be empty when
Reported Land Type Code does not equal CLU, "C"
or Annual Forage/PRF, "P".

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

P27

20

CIMS CLU Release Date

P27

21

Latitude

Data Type

Max
Length

Format

Date

6

MMYYYY

Character

10

BUS
Key Req?

Rules
When the CIMS CLU Release is populated, the
CLU ID must be valid and the date must use a
CimsAsOfDate within June 1st of the Prior
Reinsurance Year (06/01/Prior RY) through
December 1st of the Current Reinsurance Year
(12/01/Current RY).
Latitude is required when Reported Land Type
Code equals Aquaculture, "A", and for Apiculture
(1191) and PRF (0088).
Latitude format must equal "DDDXMM.ddd"
where "DDD" equal the Degrees, "X" equal
Direction, "MM" equals the Minutes and "ddd"
equals the decimal minutes rounded to three
positions or "DDDMMddd" where "DDD" equals
the Degrees, "MM" equals the Minutes and "ddd"
equals the decimal minutes rounded to three
positions.
For PRF and Apiculture, Latitude may be
submitted in the decimal degree format.
"DDD.xxxxx." For the decimal degree format, do
not submit negative values or the degree symbol.
Latitude must be empty when Insurance Plan
Code equals Rainfall Index, "13" or Vegetation
Index, "14" except for PRF and Apiculture.

P27

22

Longitude

Character

10

Page 6 of 15

Longitude is required when Reported Land Type
Code equals Aquaculture, "A", and for Apiculture
(1191) and PRF (0088).

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

Data Type

Max
Length

Format

BUS
Key Req?

Rules
Longitude format must equal "DDDXMM.ddd"
where "DDD" equal the Degrees, "X" equals
Direction, "MM" equals the Minutes and "ddd"
equals the decimal minutes rounded to three
positions or "DDDMMddd" where "DDD" equals
the Degrees, "MM" equals the Minutes and "ddd"
equals the decimal minutes rounded to three
positions.
For PRF and Apiculture, Longitude may be
submitted in the decimal degree format.
"DDD.xxxxx." For the decimal degree format, do
not submit negative values or the degree symbol.
Longitude must be empty when Insurance Plan
Code equals Rainfall Index, "13" except for PRF
and Apiculture.

P27

23

Reported Acreage

Numeric

11

Page 7 of 15

99999999.99

Reported Acreage must be empty when Reported
Land Type Code does not equal CLU, "C", PRF, "P"
or AIP RLU, "R". Reported Acreage must equal the
planted or insured acreage for the Land Identifier
and the Commodity Code. The sum of the
Reported Acreage must be within the greater of
three acres from the corresponding Acreage,
"P11" Reported Acres or within 1% when
comparing the Reported Acreage on the Acreage,
"P11" record to the sum of the Reported Acreage
on the Land, "P27" record(s). If the tolerance is
exceeded the Land, "P27" record will be rejected.

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

P27

Output

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

24

Field Name

Actual Planted Date

Data Type

Max
Length

Format

Date

8

YYYYMMDD

BUS
Key Req?

Rules
For PRF, the Reported Acreage on the P27
records must be equal to or greater than the
Reported Acreage of its associated P11, Acreage
record.
Reported Acreage is required when Insurance
Plan Code is one of the following values: "31",
"32", "33" and Reported Land Type Code is "C",
"F" or "R".
Reported Acreage is required when Non Premium
Acreage Code is empty and Commodity Code
equals Annual Forage, "0332".
Actual Planted Date must be a valid year and date
within the planting period for the Commodity
when planted on the acreage covered by this land
record.
Actual Planted Date must be less than or equal to
the Planted Date on the Acreage, "P11" record.
For Annual Forage, the Actual Planted Date must
be NULL on the P11. The Actual Planted Date is
required on the P11A, Acreage Detail record. The
Planted Date must not be greater than the Batch
Received Date and must fall on or after Sales
Closing Date and on or before the Final Planting
Date.

P27

25

FSA RMA Acreage Difference Code

Character

2

Page 8 of 15

FSA RMA Acreage Difference Code must be valid;
edit with the FSA RMA CLU Difference ICE,
"D00113".

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

Data Type

Max
Length

Format

BUS
Key Req?

Rules

P27

26

Acreage Type Code

Character

1

Acreage Type Code must be valid; edit with the
Acreage Type ICE, "D00142" record when the
Acreage Type Code exists otherwise, empty.

P27

27

RLU ID

Character

10

RLU ID must match the value in the RLU Table or
a warning will be issued.

13

Section Equivalent ID must be valid; edit with ICE
Section Equivalent, D00187; Section Equivalent ID
must use format XX-XXXXXXX-XX.

P27

28

Section Equivalent ID

Character

Required when parent P11 contains "UG" in
Insurance Option Code List; otherwise empty.
Valid CLU ID is the value returned from the CLU
Table.
High Risk Land Code is set to High Risk, "V" when
Mapped Legal Description Status Code equals
partial, "P" or Mapped CLU Status Code equals
partial, "P".
Valid RLU ID is the value returned from the RLU
Table.
Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.

P27

*

29

Valid CLU ID

Character

36

P27

*

30

Valid RLU ID

Character

10

P27

*

31

Initial Accepted Batch Number

Numeric

5

P27

*

32

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.

P27

*

33

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

P27

*

34

Batch Number

Numeric

5

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.

Page 9 of 15

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

P27

*

35

P27

*

36

Field Name
Batch Record ID

Process Result Code

Data Type

Max
Length

Numeric

15

Character

1

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

Record Level Rules
The Land, "P27" record must be unique in the
batch using the following key: AIP Code,
Reinsurance Year, AIP Policy Producer Key, AIP
Insurance In Force Key, AIP Land Key.
Land, "P27" records will not be accepted when
processing has been suspended for this record
type.

1

2

3

The following child records must be accepted in
the batch for the Land, "P27" record to be
accepted: Land Other Person Sharing, "P27A".

4

A Land, "P27" record must not be submitted
when the Submission Indicator Code in the Land
Requirement ICE, "D00116" equals not allowed,
"N" for a specific Commodity Code; edit with the
Land Requirement ICE, "D00116".

Page 10 of 15

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

Data Type

Max
Length

Format

BUS
Key Req?

Rules
A Land, "P27" record must be submitted when
the Submission Indicator Code in the Land
Requirement ICE, "D00116" equals required, "R"
for a specific Commodity Code; edit with the Land
Requirement ICE, "D00116".

5

Land ID Type Code must be empty when FSA
Farm Serial Number, FSA Tract Number and FSA
Field Number is not empty.
CLU ID must be empty if Land Identifier Type
Code is not empty.
FSA Farm Number, FSA Tract Number and FSA
Field Number must be a valid FSA Farm Number,
FSA Tract Number and FSA Field Number; edit
with the CLU table.
The corresponding P11 records must be free of
errors for this record to be accepted.

6
7

8

9

10

All Land, "P27" records with Commodity Codes
equal to PRF, "0088" and Annual Forage, "0332"
must be submitted as linked to only one of the
intervals under a certain Grid ID by AIP Acreage
Key and Insured Share Percent.

11

The sum of Reported Acres must be greater than
or equal to the Total Insured Acreage from the
corresponding Acreage, "P11" record when the
Reported Land Type Code equals "P" except when
Commodity Code equals Annual Forage, "0332".

Page 11 of 15

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

Data Type

Max
Length

Format

BUS
Key Req?

Rules

12

CLU ID is required and must be found in ADM
Land Description, A00040, for the given offer
when the parent Acreage, P11, record is for a
Written Agreement and the WA's Land Level
Code is CLU. CLU ID must be empty for WA
records if Land Level Code is not CLU. The
Reported Acreage must be less than Maximum
Allowed Acreage from the A00040 record.

13

FSA Farm Number and FSA Tract Number are
required and must be found in ADM Land
Description, A00040, for the given offer when the
parent Acreage, P11, record is for a Written
Agreement and the WA's Land Level Code is NCL
or FSU. FSA Farm Number and FSA Tract Number
must be empty for WA records if Land Level Code
is not NCL or FSU. The Reported Acreage must be
less than Maximum Allowed Acreage from the
A00040 record.

14

FSA Field Number is required and must be found
in ADM Land Description, A00040, for the given
offer when the parent Acreage, P11, record is for
a Written Agreement and the WA's Land Level
Code is NCL. FSA Field Number must be empty for
WA records if Land Level Code is not NCL. The
Reported Acreage must be less than Maximum
Allowed Acreage from the A00040 record.

Page 12 of 15

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

Data Type

Max
Length

15

Format

BUS
Key Req?

Rules
Land Identifier is required and must be found in
ADM Land Description, A00040, for the given
offer when the parent Acreage, P11, record is for
a Written Agreement and the WA's Land Level
Code is SEC. Land Identifier must be empty for
WA records if Land Level Code is not SEC. The
Reported Acreage must be less than Maximum
Allowed Acreage from the A00040 record.

16

Sub County Code from the parent P11 must be
found in ADM Land Description, A00040, for the
given offer when the parent Acreage, P11, record
is for a Written Agreement and the WA's Land
Level Code is SUB.

17

No validation is performed against ADM Land
Description, A00040, for the given offer when the
parent Acreage, P11, record is for a Written
Agreement and the WA's Land Level Code is DES.

18

A record must not exist in ADM Land Description,
A00040, for the given offer when the parent
Acreage, P11, record is for a Written Agreement
and the WA's Land Level Code is CTY.

Page 13 of 15

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

Data Type

Max
Length

Format

BUS
Key Req?

Rules

19

When Commodity Code equals Annual Forage,
"0332" and the Land, "P27" records are in
Growing Seasons 1, 2, or 3, then another P27
record cannot exist in the next Growing Season
with the same following values: Reinsurance Year,
Location State Code, Location County Code, FSA
Farm Number, FSA Tract Number, FSA Field
Number.

20

When Commodity Code equals Annual Forage,
"0332" and the Land, "P27" records are in
Growing Seasons 2, 3, or 4, then another P27
record cannot exist in the previous Growing
Season with the same following values:
Reinsurance Year, Location State Code, Location
County Code, FSA Farm Number, FSA Tract
Number, FSA Field Number.

21

When Commodity Code equals Annual Forage,
"0332" and the Land, "P27" records are in
Growing Season 1, then another P27 record
cannot exist in the previous Growing Season with
the same following values: Reinsurance Year - 1,
Location State Code, Location County Code, FSA
Farm Number, FSA Tract Number, FSA Field
Number.

Page 14 of 15

File Type: Delimited
Reinsurance Year: 2026
Version: Approved
Release Date: 7/1/2025

Record
Number

Output

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

Field Name

Data Type

Max
Length

22

Format

BUS
Key Req?

Rules
When Commodity Code equals Annual Forage,
"0332" and the Land, "P27" records are in
Growing Season 4, then another P27 record
cannot exist in the next Growing Season with the
same following values: Reinsurance Year + 1,
Location State Code, Location County Code, FSA
Farm Number, FSA Tract Number, FSA Field
Number.
When Commodity Code equals Annual Forage,
"0332" and the Land, "P27" records are in
Growing Seasons 1, 2, or 3, then another P27
record cannot exist in the next Growing Season
with the same following values: Reinsurance Year
+ 1, Location State Code, Location County Code,
FSA Farm Number, FSA Tract Number, FSA Field
Number.

23

Page 15 of 15