Land Identifier Record - Type 17 - Format-Edits

June 28 2007

Exhibit 17

FCIC-Appendix III

(LAND IDENTIFIER RECORD – TYPE 17)
Format/Edits

Field
No.

Field Name

1
2
3
4

Record Type
Approved Insurance
Provider
Location State
Policy Issuing Company

5
6

Size

Picture

Field Edits

1
3

2
2

9(02)
X(02)

Required. Must be 17.
Required. Edit with AIP/Company table.

5
7

2
3

9(02)
9(03)

Policy Number
Crop Year

10
17

7
4

9(07)
9(04)

7
8
9
10

Crop Code
Insurance Plan Code
Location County
Unit Number

21
25
27
30

4
2
3
5

9(04)
9(02)
9(03)
9(05)

11
12
13

Type Code
Practice Code
Coverage Flag

35
38
41

3
3
1

9(03)
9(03)
X(01)

14

Type 17 Key Reserve

42

34

X(34)

15
16

Record Number
Type 11/13/15 Record
Number

76
79

3
3

9(03)
9(03)

17

Land Identifier Type 1

82

1

X(01)

Required. Edit with FIPS State table.
For Reinsured edit with company table. Must
be valid Pic code for reinsurance year.
Required. Must be > zeros.
Required. Must be the crop year of the crops
reported under the policy. This will equal the
Reinsurance Year or Reinsurance Year +/- 1
for applicable crop code.
Required; Edit with ADM2. See Exhibit 99-a.
Required; Edit with ADM2. See Exhibit 99-a.
Required; Edit with FIPS County Table.
Required; Must be > zeros. Unit Number must
end in ‘00’ for Enterprise and Whole Farm
Units (i.e. 00100).
Required. Zero fill or must match ADM.
Required. Zero fill or must match ADM.
Required; Must be:
C = Catastrophic “CAT” Coverage
A = Additional Coverage
For CRC and Revenue Assurance must
be ‘A’.
Space Reserved for Additional key data
required in the future or for other record types.
Must be > 000 and unique within a policy.
Required; The record number of the Type 11,
13 or Type 15 record that established the 17
record. If crop requires a yield record use 15
record number; otherwise use 11 or 13 record
number. See Exhibit 15-4 for a list of crops
requiring a yield record.
Use “L” for Legal Description, “F” for FSA
Farm Serial Number, “C” for Common Land
Unit, “H” for Legal Descriptions within a high
risk area designation or “O” for other. Use “A”
for Aquaculture (Clams).

FCIC-APPENDIX III

Begin
Pos

17 - 1

RY 2008

June 28 2007

Exhibit 17

FCIC-Appendix III

(LAND IDENTIFIER RECORD – TYPE 17)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

18

Land Identifier 1

83

18

X(18)

If ID Type = “L” or “H”, must be a valid
Legal Description for the state/county with a
format of SSS-TTTD-RRRD. Must be left
justified with trailing spaces.
If ID Type = “F”, must be a valid FSA Farm
Serial Number and left justified with trailing
spaces.
If ID Type = “C”, must be a valid Common
Land Unit number based on a valid FSA Farm
Serial Number, Tract Number And Field
Number. FSA FSN and Tract Number are
both 7 bytes and must include leading zeros
(i.e. 00015460000134); Field Number must be
4 bytes and include leading zeros if applicable
and/or alpha characters at the end, if
applicable.
If ID Type = “O”, must be left justified with
trailing spaces.
If ID Type = “A”, must be a valid growing
location (lease, parcel, permit, or license
number) and left justified with trailing spaces.
See State/County Cross Reference File for
reporting requirements for Legal Descriptions,
Farm Serial Numbers, Common Land Units
and Others.

19

Land Identifier Type 2

101

1

X(01)

20
21

Land Identifier 2
Land Identifier Type 3

102
120

18
1

X(18)
X(01)

22
23

Land Identifier 3
Land Identifier Type 4

121
139

18
1

X(18)
X(01)

24
25

Land Identifier 4
Land Identifier Type 5

140
158

18
1

X(18)
X(01)

26
27

Land Identifier 5
Land Identifier Type 6

159
177

18
1

X(18)
X(01)

28
29

Land Identifier 6
Land Identifier Type 7

178
196

18
1

X(18)
X(01)

30
31

Land Identifier 7
Land Identifier Type 8

197
215

18
1

X(18)
X(01)

32
33

Land Identifier 8
Land Identifier Type 9

216
234

18
1

X(18)
X(01)

34
35

Land Identifier 9
Land Identifier Type 10

235
253

18
1

X(18)
X(01)

36

Land Identifier 10

254

18

X(18)

FCIC-APPENDIX III

17 - 2

RY 2008

June 28 2007

Exhibit 17

FCIC-Appendix III

(LAND IDENTIFIER RECORD – TYPE 17)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

37

Person Sharing 1

272

35

X(35)

38
39
40
41

Person Sharing 2
Person Sharing 3
Filler
Latitude 1

307
342
377
387

35
35
10
8

X(35)
X(35)
X(10)
X(08)

Left justify with trailing spaces. Use First &
Last Name for individuals.
F/L = Alpha characters and (-), (,), ( ), (.), (‘).
Bus name, Trusts, Estates = Alpha/Numeric
characters and (-), (,), ( ), (&), (+), (.), (‘), (%),
(*), (#).
Only one name per field.
See Field 37.
See Field 37.
Must be spaces.
Optional, enter Latitude/Longitude of Land
Identifier field, if not spaces, then must be
valid for location state/location county if Land
Identifier type = ‘A’, ‘F’, or ‘O’. For ‘L’ must
be valid for location state/location county,
section and township.

42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61

Longitude 1
Latitude 2
Longitude 2
Latitude 3
Longitude 3
Latitude 4
Longitude 4
Latitude 5
Longitude 5
Latitude 6
Longitude 6
Latitude 7
Longitude 7
Latitude 8
Longitude 8
Latitude 9
Longitude 9
Latitude 10
Longitude 10
Filler

395
403
411
419
427
435
443
451
459
467
475
483
491
499
507
515
523
531
539
547

8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
4

X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(08)
X(04)

FCIC-APPENDIX III

17 - 3

Must be spaces.

RY 2008

June 28 2007

Exhibit 17

FCIC-Appendix III

(LAND IDENTIFIER RECORD – TYPE 17)
Format/Edits

Field
No.

Field Name

62

FCIC Control Time

63

Begin
Pos

Size

Picture

Field Edits

551

4

9(04)

FCIC Control Date

555

8

9(08)

64

Reinsurance Year

563

4

9(04)

65

Batch Number

567

4

9(04)

66

Transaction Sequence
Number

571

8

9(08)

67
68
69

Transaction Rejected Flag
Transaction Source Flag
Filler

579
580
581

1
1
20

X(01)
X(01)
X(20)

Internal Use. The time the transaction batch
file was received. (From when transmission
started) HHMM Format.
Internal Use. The date the transaction batch
file was received. (From when transmission
started) MMDDCCYY Format.
Internal Use. The Reinsurance Year. CCYY
format.
Internal Use. The sequential number
identifying the file that was submitted by the
IP to FCIC/RMA.
Internal Use. The sequential number assigned
to each transaction number processed by DAS
after it has been sorted.
Internal Use. Reserved.
Internal Use. Reserved.
Internal Use.

Notes:
Information on Land Identifier fields cannot be duplicated per 17 record.
Land Identifier Type 1 (field 17) and Land Identifier 1 (field 18) cannot be blank.
Land Identifier 1 must have two or more characters.
For ‘Other’ enter description such as: grant, number, parish number or other alpha numeric description.
For ‘Aquaculture’ enter a growing location such as: L6011, parcel 17, NE75AQ000, or alpha numeric description.
The Reported Land Identifier (Legal) must be valid for location state/location county section/township. A legal
validation file will be made available via the IP server.

FCIC-APPENDIX III

17 - 4

RY 2008