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

P27

7

AIP Inventory Value Key

Character

15

Y

CCYY

Y
Y

Delimited
2016
Approved
7/1/2015

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

"*" = Output Only
6/26/2015

Page 1 of 15

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
2016
Approved
7/1/2015

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" when
the associated Acreage, "P11" record contains
"NS" in the Program Indicator Code List.

P27

10

"*" = Output Only
6/26/2015

Land Identifier

Character

18

Page 2 of 15

Reported Land Type Code must equal "F" when
Insurance Plan Code is one of the following
values: "31", "32", "33".
Reported Land Type Codes "C" or "F" 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.

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
2016
Approved
7/1/2015

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

"*" = Output Only
6/26/2015

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".
Page 3 of 15

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

11

CLU ID

Character

36

P27

12

FSA Farm Number

Character

7

P27

13

FSA Tract Number

Character

7

P27

14

FSA Field Number

Character

7

"*" = Output Only
6/26/2015

Page 4 of 15

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
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 or a
warning will be issued.
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" or
Vegetation Index, "14" except when Commodity
Code equals Apiculture, "1191".
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

P27

Output

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

15

Field Name

FSA Sub Field Identifier

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Character

Max
Length

Format

BUS
Key Req?

16

FSA Intended Use

Character

2

P27

17

FSA Administrative State Code

Character

2

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".
FSA Sub Field Identifier when submitted must
contain only alphanumeric or numeric characters
when Reported Land Type Code equals CLU, "C".

3

P27

Delimited
2016
Approved
7/1/2015

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 must be valid; edit
with the State ICE, "D00106".
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
Output Only18
6/26/2015

FSA Administrative County Code

Character
3
Page 5 of 15

Y

FSA Administrative County Code must be valid;
edit with the County ICE, "D00107".

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
2016
Approved
7/1/2015

Rules
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

P27

19

20

"*" = Output Only
6/26/2015

CLU Determination Code

CIMS CLU Release Date

Character

Date

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

1

6

MMYYYY

When the CIMS CLU Release Date is required it
must be the date of the CIMS CLU validation file
that the FSA Farm Number, FSA Tract Number and
FSA Field Number were validated against.
CIMS CLU Release Date is required when CLU
Determination Code equals "A", "G" or "R" and
the Reported Land Type Code equals CLU, "C".

Page 6 of 15

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
2016
Approved
7/1/2015

Rules
CIMS CLU Release Date must be empty when
Reported Land Type Code equals CLU, "C" and the
CLU Determination Code equals "P" or "F".

P27

21

Latitude

Character

10

P27

22

Longitude

Character

10

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

"*" = Output Only
6/26/2015

Page 7 of 15

Record
Number

P27

Output

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

23

Field Name

Reported Acreage

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Numeric

Max
Length

10

Format

9999999.99

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

Rules
Longitude must be empty when Insurance Plan
Code equals Rainfall Index, "13" or Vegetation
Index, "14".
Reported Acreage must be empty when Reported
Land Type Code does not equal CLU, "C" or PRF,
"P". 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
Reported Acreage is required when Insurance
Plan Code is one of the following values: "31",
"32,", "33" and Reported Land Type Code is "F".

P27

24

"*" = Output Only
6/26/2015

Actual Planted Date

Date

8
Page 8 of 15

YYYYMMDD

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.

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
2016
Approved
7/1/2015

Rules
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

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.

P27

26

Acreage Type Code

Character

1

P27

27

RLU ID

Character

10

RLU ID must match the value in the RLU Table or a
warning will be issued.
Valid CLU ID is the value returned from the CLU
Table.

P27

*

28

Valid CLU ID

Character

36

P27

*

29

Survey Status Code

Character

1

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

1

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

P27

*

30

"*" = Output Only
6/26/2015

High Risk Land Code

Character

Page 9 of 15

Record
Number

Output

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

P27

*

31

P27

*

P27

File Type:
Reinsurance Year:
Version:
Release Date:

Land
P27

Data Type

Max
Length

Valid RLU ID

Character

10

32

Initial Accepted Batch Number

Numeric

4

*

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

4

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.

P27

*

37

Field Name

Process Result Code

Character

1

Record Level Rules
"*" = Output Only
6/26/2015

Page 10 of 15

Format

BUS
Key Req?

Delimited
2016
Approved
7/1/2015

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

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

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

BUS
Key Req?

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

"*" = Output Only
6/26/2015

Format

Delimited
2016
Approved
7/1/2015

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

5

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

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".
Page 11 of 15

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

BUS
Key Req?

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

7

8

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.

9

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

10

11

12

"*" = Output Only
6/26/2015

Format

Delimited
2016
Approved
7/1/2015

Page 12 of 15

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
2016
Approved
7/1/2015

Rules

13

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

14

The corresponding P11 records must be free of
errors for this record to be accepted.

15

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.

16

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

"*" = Output Only
6/26/2015

Page 13 of 15

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
2016
Approved
7/1/2015

Rules

17

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.

18

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.

19

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.

"*" = Output Only
6/26/2015

Page 14 of 15

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
2016
Approved
7/1/2015

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.

24

The sum of Reported Acres must be equal to
Reported Acreage from the corresponding
Acreage, "P11" record when Insurance Plan Code
is one of the following values: "31", "32", "33".

"*" = Output Only
6/26/2015

Page 15 of 15