Common Land Record Type 27

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

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

Delimited
2019
Approved
4/4/2019

Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must be "2019".
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

"*" = Output Only
3/20/2019

7

AIP Inventory Value Key

Character

15

Page 1 of 16

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.

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

P27

8

AIP Land Key

Character

15

P27

9

Reported Land Type Code

Character

1

Format

BUS
Key Req?

Y

Delimited
2019
Approved
4/4/2019

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" or Vegetation Index, "14".
Reported Land Type Code must equal "C" or "R"
when the associated Acreage, "P11" record
contains "NS" in the Program Indicator Code List.

P27

10

"*" = Output Only
3/20/2019

Land Identifier

Character

18

Page 2 of 16

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

Record
Number

P27

Output

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

11

"*" = Output Only
3/20/2019

Field Name

CLU ID

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Character

Max
Length

36

Page 3 of 16

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

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 must be valid High Risk Land when
High Risk Land Code equals High Risk, "H" or
Verified Standard Areas in Partial High Risk
Sections, "V" and the Reported Land Type Code
equals Legal, "L"; edit with the "2011 RY EDIT All
Areas PLSS" file and the Sub County Rate ADM,
"A01050".
Land Identifier must not be High Risk Land when
the High Risk Land Code is empty and the Land
Identifier Type Code equals Legal, "L"; edit with
the "2011 RY EDIT All Areas PLSS" file and the Sub
County Rate ADM, "A01050".
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".
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.

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

P27

12

FSA Farm Number

Character

7

P27

13

FSA Tract Number

Character

7

P27
14
"*" = Output Only
3/20/2019

FSA Field Number

Character

7

Page 4 of 16

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

Rules
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" or
Vegetation Index, "14" except when Commodity
Code equals Apiculture, "1191".
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'.
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" or
Vegetation Index, "14" except when Commodity
Code equals Apiculture, "1191".
FSA Field Number must be populated when
Reported Land Type Code equal CLU, "C" or
Annual Forage/PRF, "P".

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

Rules
FSA Field Number is required when the Insurance
Plan Code equals Rainfall Index, "13" or
Vegetation Index, "14" except when Commodity
Code equals Apiculture, "1191".

P27

15

FSA Sub Field Identifier

Character

P27

16

FSA Intended Use

Character

2

P27

17

FSA Administrative State Code

Character

2

P27

18

"*" = Output Only
3/20/2019

FSA Administrative County Code

Character

FSA Sub Field Identifier when submitted must
contain only alphanumeric or numeric characters
when Reported Land Type Code equals CLU, "C".

3

3

Page 5 of 16

Y

Y

FSA Intended Use must be valid for the
commodity being grown and produced; edit with
the FSA Intended Use ICE, "D00111".
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.
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".

Record
Number

Output

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

Field Name

P27

19

CLU Determination Code

P27

20

CIMS CLU Release Date

P27

21

P27

22

"*" = Output Only
3/20/2019

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

Character

1

Date

6

Latitude

Character

10

Longitude

Character

10

Page 6 of 16

Format

MMYYYY

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

Rules
FSA Administrative County Code is required when
the FSA Administrative State Code exists.
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"
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".
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.
Latitude must be empty when Insurance Plan
Code equals Rainfall Index, "13" or Vegetation
Index, "14".
Longitude is required when Reported Land Type
Code equals Aquaculture, "A".

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

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.
Longitude must be empty when Insurance Plan
Code equals Rainfall Index, "13" or Vegetation
Index, "14".

P27

23

Reported Acreage

Numeric

10

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

"*" = Output Only
3/20/2019

Page 7 of 16

Record
Number

P27

Output

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

24

Field Name

Actual Planted Date

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Date

Max
Length

8

Format

YYYYMMDD

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

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

P27

25

FSA RMA Acreage Difference Code

Character

2

P27

26

Acreage Type Code

Character

1

RLU ID

Character

10

P27
27
"*" = Output Only
3/20/2019

Page 8 of 16

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.
FSA RMA Acreage Difference Code must be valid;
edit with the FSA RMA CLU Difference ICE,
"D00113".
Acreage Type Code must be valid; edit with the
Acreage Type ICE, "D00142" record when the
Acreage Type Code exists otherwise, empty.
RLU ID must match the value in the RLU Table or a
warning will be issued.

Record
Number

Output

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

P27

*

28

P27

*

29

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

Valid CLU ID

Character

36

Valid CLU ID is the value returned from the CLU
Table.

Survey Status Code

Character

1

Survey Status Code is the value returned from the
County Survey Status ICE, "D00115".

Field Name

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

Rules

High Risk Land Code is set to High Risk, "H" when
Mapped Legal Description Status Code equals
complete, "C" or Mapped CLU Status Code equals
complete, "C".
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

*

30

High Risk Land Code

Character

1

P27

*

31

Valid RLU ID

Character

10

P27

*

32

Initial Accepted Batch Number

Numeric

5

P27

*

33

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

*

34

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

P27

*

35

Batch Number

Numeric

5

P27

*

36

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
3/20/2019

Page 9 of 16

Record
Number
P27

Output

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

*

Field
Number
37

Field Name
Process Result Code

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type
Character

Max
Length
1

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

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

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.

2

Land, "P27" records will not be accepted when
processing has been suspended for this record
type.

3

The following child records must be accepted in
the batch for the Land, "P27" record to be
accepted: Land Other Person Sharing, "P27A".
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".
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".

4

5

"*" = Output Only
3/20/2019

Page 10 of 16

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

Rules

6

Land Identifier must be a valid Township and
Range when the Survey Status Code equals entire
County Surveyed to township level, "Y" for the
Location State Code and Location County Code
containing the Land Identifier; edit with the Legal
Description ICE, "D00062".

7

Land Identifier must be a valid Section, Township
and Range when the Survey Status Code equals
Sections, "S" for the Location State Code and
Location County Code containing the Land
Identifier; edit with the Legal Description ICE,
"D00062".
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 valid High Risk Land when High
Risk Land Code equals Full, "F" or Partial, "P" and
the Farm Serial Number, FSA Tract Number and
FSA Field Number is populated; edit with the
"2011 RY EDIT All Areas CLU JAN2010" file.
CLU ID must not be High Risk Land when the High
Risk Land Code is empty and CLU ID is populated;
edit with the "2011 RY EDIT All Areas CLU
JAN2010" file.
CLU ID must be empty if Land Identifier Type
Code is not empty.

8

9

10

11

"*" = Output Only
3/20/2019

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

Page 11 of 16

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

Rules
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.
Where Survey Status Code does not equal Not
Surveyed, "N" in the County Survey Status ICE,
"D00115" for the Location State Code and
Location County, Land must be reported as either
PLSS or FSA Farm Number, FSA Tract Number &
FSA Field Number except when Commodity Code
equals Aquaculture, "0116".
The corresponding P11 records must be free of
errors for this record to be accepted.
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.

12

13

14

15

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

16

"*" = Output Only
3/20/2019

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

Page 12 of 16

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

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

17

18

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.

19

"*" = Output Only
3/20/2019

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

Page 13 of 16

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

Rules

20

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.

21

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.

22

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.

23

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.

"*" = Output Only
3/20/2019

Page 14 of 16

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

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

24

25

26

"*" = Output Only
3/20/2019

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

Page 15 of 16

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

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.

27

28

"*" = Output Only
3/20/2019

Format

BUS
Key Req?

Delimited
2019
Approved
4/4/2019

Page 16 of 16