Common Land Unit Identifier Record - Type 27 - Format - Edits

June 28, 2007

Exhibit 27

FCIC-Appendix III

(COMMON LAND UNIT IDENTIFIER RECORD – TYPE 27)
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 27.
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
15

Filler
Sub Type/Variety

42
50

8
3

X(08)
9(03)

16

Grid ID

53

8

9(08)

17

Type 27 Key Reserve

61

15

X(15)

18
19

Record Number
Type 11Record Number

76
79

3
3

9(03)
9(03)

20
21

Land Identifier Type 1
Farm Serial Number 1

82
83

1
7

X(01)
X(07)

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’.
Must be spaces.
Sub Type/Variety Code if applicable.
The subtype/variety code from the ADM is
applicable for option lines only for Florida
Fruit Trees. If not applicable, zero fill.
Grid ID from Map for Pasture Rangeland and
Forage Products. Right justify with leading
zeros. If not applicable, zero fill.
Space Reserved for Additional key data
required in the future or for other record types.
Must be spaces or blanks.
Must be > 000 and unique within a policy.
Required; The record number of the Type 11
record that established the 27 record
“C” for Common Land Unit.
Valid FSA Farm Serial Number, FSN is 7
bytes and must include leading zeros (i.e.
0001546)

FCIC-APPENDIX III

Begin
Pos

27 - 1

RY 2008

June 28, 2007

Exhibit 27

FCIC-Appendix III

(COMMON LAND UNIT IDENTIFIER RECORD – TYPE 27)
Format/Edits

Field
No.

Field Name

22

Tract Number 1

23

Size

Picture

Field Edits

90

7

X(07)

Field Number 1

97

4

X(04)

24

Sub Field Identifier 1

101

3

X(03)

25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61

Reported Acres 1
Land Identifier Type 2
Farm Serial Number 2
Tract Number 2
Field Number 2
Sub Field Identifier 2
Reported Acres 2
Land Identifier Type 3
Farm Serial Number 3
Tract Number 3
Field Number 3
Sub Field Identifier 3
Reported Acres 3
Land Identifier Type 4
Farm Serial Number 4
Tract Number 4
Field Number 4
Sub Field Identifier 4
Reported Acres 4
Land Identifier Type 5
Farm Serial Number 5
Tract Number 5
Field Number 5
Sub Field Identifier 5
Reported Acres 5
Land Identifier Type 6
Farm Serial Number 6
Tract Number 6
Field Number 6
Sub Field Identifier 6
Reported Acres 6
Land Identifier Type 7
Farm Serial Number 7
Tract Number 7
Field Number 7
Sub Field Identifier 7
Reported Acres 7

104
112
113
120
127
131
134
142
143
150
157
161
164
172
173
180
187
191
194
202
203
210
217
221
224
232
233
240
247
251
254
262
263
270
277
281
284

8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8

9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)

Tract Number is 7 bytes and must include
leading zeros if applicable.
Field Number is 4 bytes and must include
Leading zeros if applicable.
Optional. Report the sub field identifier used
by FSA for the common land unit
Total number of acres for the CLU.

FCIC-APPENDIX III

Begin
Pos

27 - 2

RY 2008

June 28, 2007

Exhibit 27

FCIC-Appendix III

(COMMON LAND UNIT IDENTIFIER RECORD – TYPE 27)
Format/Edits

Field
No.

Field Name

62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104

Land Identifier Type 8
Farm Serial Number 8
Tract Number 8
Field Number 4
Sub Field Identifier 8
Reported Acres 8
Land Identifier Type 9
Farm Serial Number 9
Tract Number 9
Field Number 9
Sub Field Identifier 9
Reported Acres 9
Land Identifier Type 10
Farm Serial Number 10
Tract Number 10
Field Number 10
Sub Field Identifier 10
Reported Acres 10
Land Identifier Type 11
Farm Serial Number 11
Tract Number 11
Field Number 11
Sub Field Identifier 11
Reported Acres 11
Land Identifier Type 12
Farm Serial Number 12
Tract Number 12
Field Number 12
Sub Field Identifier 12
Reported Acres 12
Land Identifier Type 13
Farm Serial Number 13
Tract Number 13
Field Number 13
Sub Field Identifier 13
Reported Acres 13
Land Identifier Type 14
Farm Serial Number 14
Tract Number 14
Field Number 14
Sub Field Identifier 14
Reported Acres 14
Filler

FCIC-APPENDIX III

Begin
Pos

Size

Picture

Field Edits

292
293
300
307
311
314
322
323
330
337
341
344
352
353
360
367
371
374
382
383
390
397
401
404
412
413
420
427
431
434
442
443
450
457
461
464
472
473
480
487
491
494
502

1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
1
7
7
4
3
8
49

X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(071)
X(04)
X(03)
9(06)V9(02)
X(01)
X(07)
X(07)
X(04)
X(03)
9(06)V9(02)
X(49)

Must be spaces.

27 - 3

RY 2008

June 28, 2007

Exhibit 27

FCIC-Appendix III

(COMMON LAND UNIT IDENTIFIER RECORD – TYPE 27)
Format/Edits

Field
No.

Field Name

104

FCIC Control Time

105

Begin
Pos

Size

Picture

Field Edits

551

4

9(04)

FCIC Control Date

555

8

9(08)

106

Reinsurance Year

563

4

9(04)

107

Batch Number

567

4

9(04)

108

Transaction Sequence
Number

571

8

9(08)

109
110
111

Transaction Rejected Flag
Transaction Source Flag
Filler

579
580
581

1
1
19

X(01)
X(01)
X(19)

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 27 record.
Land Identifier Type 1 (field 20) and Tract Number 1 (field 22) cannot be blank.

FCIC-APPENDIX III

27 - 4

RY 2008