CAT Fee Receivable Record - Type 65 - Format - Edits

June 28, 2007

Exhibit 65

FCIC-Appendix III

(CAT FEE RECEIVABLE RECORD)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

1
2
3

Record Type
Approved Insurance Provider
Reinsurance Year

1
3
5

2
2
4

9(02)
X(02)
9(04)

4

ID Type

9

1

9(01)

5

ID Number

10

9

9(09)

6
7
8

Reserved Filler
Location State
Policy Issuing Company

19
27
29

8
2
3

X(08)
9(02)
9(03)

9
10
11

Policy Number
Filler
Debt Delinquency Date

32
39
41

7
2
8

9(07)
X(02)
9(08)

12

49

6

9(04)V9(02)

13
14

Uncollected Fee Amount 1st crop
Filler
1st Bill Date

55
57

2
8

X(02)
9(08)

15

1st Pre-term Letter Date

65

8

9(08)

16

1st Crop Year

73

4

9(04)

17
18

1st Crop Code
1st Crop Type

77
81

4
3

9(04)
9(03)

19
20

1st Loc County
Uncollected Fee Amount 2nd crop
Filler
2nd Bill Date

84
87

3
6

9(03)
9(04)V9(02)

93
95

2
8

X(02)
9(08)

21
22

FCIC-APPENDIX III

65 - 1

Field Edits

Required. Must be 65.
Required. Edit with AIP/Company table.
Required. Reinsurance year of the contract
with the debt.
Required. ID Type for the Primary Insured.
Must be: 1 = SSN
2 = EIN
5 = BIA Number
Required. ID Number for the Primary
Insured.
If ID Type eq “1” - Valid SSN
If ID Type eq “2” - Numeric > 0
If ID Type eq “5” - First 5 digits are FIPS
State and County Code
Must be spaces.
Required. Edit with States FIPS table.
Edit with Company table. Must be valid Pic
code for reinsurance year.
Must be > zeroes.
Must be spaces.
Required. Must be a valid date in
YYYYMMDD format and must be the same
Debt Delinquency Date used in the Record
Type 60. (Reference the ITS Handbook)
Amount must be > 0, principle only,
excluding any accrued interest.
Must be spaces.
Must be a valid date in YYYYMMDD
format of the date the first bill was issued.
Must be a valid date in YYYYMMDD
format and ≥ First Bill Date. Must be at
least 30 days < RM Data Receipt Date in
Record 60. (Reference the ITS Handbook)
Crop year of the 1st Uncollected Fee
Amount.
Edit with ADM.
Required for Arizona and California
Grapes. Zero fill if not required.
Edit with FIPS County Table.
Amount must be > 0, principle only,
excluding any accrued interest.
Must be spaces.
Must be a valid date in YYYYMMDD
format that represents the date that the first
bill was issued.

RY 2008

June 28, 2007

Exhibit 65

FCIC-Appendix III

(CAT FEE RECEIVABLE RECORD)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

23

2nd Pre-term Letter Date

103

8

9(08)

24

2nd Crop Year

111

4

9(04)

25
26

2nd Crop Code
2nd Crop Type

115
119

4
3

9(04)
9(03)

27
28

122
125

3
6

9(03)
9(04)V9(02)

29
30

2nd Loc County
Uncollected Fee Amount 3rd crop
Filler
3rd Bill Date

131
133

2
8

X(02)
9(08)

31

3rd Pre-term Letter Date

141

8

9(08)

32

3rd Crop Year

149

4

9(04)

33
34

3rd Crop Code
3rd Crop Type

153
157

4
3

9(04)
9(03)

35
36

160
163

3
6

9(03)
9(04)V9(02)

37
38

3rd Loc County
Uncollected Fee Amount 4th crop
Filler
4th Bill Date

169
171

2
8

X(02)
9(08)

39

4th Pre-term Letter Date

179

8

9(08)

40

4th Crop Year

187

4

9(04)

41
42

4th Crop Code
4th Crop Type

191
195

4
3

9(04)
9(03)

43
44

4th Loc County
Uncollected Fee Amount 5th crop

198
201

3
6

9(03)
9(04)V9(02)

FCIC-APPENDIX III

65 - 2

Field Edits

Must be a valid date in YYYYMMDD
format and ≥ First Bill Date. Must be at
least 30 days < RM Data Receipt Date in
Record 60.(Reference the ITS Handbook)
Crop year of the 2nd Uncollected Fee
Amount.
Edit with ADM.
Required for Arizona and California
Grapes. Zero fill if not required.
Edit with FIPS County Table.
Amount must be > 0, principle only,
excluding any accrued interest.
Must be spaces.
Must be a valid date in YYYYMMDD
format of the date the first bill was issued.
Must be a valid date in YYYYMMDD
format and ≥ First Bill Date. Must be at
least 30 days < RM Data Receipt Date in
Record 60. (Reference the ITS Handbook)
Crop year of the 3rd Uncollected Fee
Amount.
Edit with ADM.
Required for Arizona and California
Grapes. Zero fill if not required.
Edit with FIPS County Table.
Amount must be > 0, principle only,
excluding any accrued interest.
Must be spaces.
Must be a valid date in YYYYMMDD
format of the date the first bill was issued.
Must be a valid date in YYYYMMDD
format and ≥ First Bill Date. Must be at
least 30 days < RM Data Receipt Date in
Record 60. (Reference the ITS Handbook)
Crop year of the 4th Uncollected Fee
Amount.
Edit with ADM.
Required for Arizona and California
Grapes. Zero fill if not required.
Edit with FIPS County Table.
Amount must be > 0, principle only,
excluding any accrued interest.

RY 2008

June 28, 2007

Exhibit 65

FCIC-Appendix III

(CAT FEE RECEIVABLE RECORD)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

45
46

Filler
5th Bill Date

207
209

2
8

X(02)
9(08)

47

5th Pre-term Letter Date

217

8

9(08)

48

5th Crop Year

225

4

9(04)

49
50

5th Crop Code
5th Crop Type

229
233

4
3

9(04)
9(03)

51
52

236
239

3
6

9(03)
9(04)V9(02)

53
54

5th Loc County
Uncollected Fee Amount 6th crop
Filler
6th Bill Date

245
247

2
8

X(02)
9(08)

55

6th Pre-term Letter Date

255

8

9(08)

56

6th Crop Year

263

4

9(04)

57
58

6th Crop Code
6th Crop Type

267
271

4
3

9(04)
9(03)

59
60
61
62

6th Loc County
Filler
Reserved (Accept Flag)
Filler

274
277
292
293

3
15
1
8

9(03)
X(15)
X(01)
X(08)

FCIC-APPENDIX III

65 - 3

Field Edits

Must be spaces.
Must be a valid date in YYYYMMDD
format of the date the first bill was issued.
Must be a valid date in YYYYMMDD
format and ≥ First Bill Date. Must be at
least 30 days < RM Data Receipt Date in
Record 60. (Reference the ITS Handbook)
Crop year of the 5th Uncollected Fee
Amount.
Edit with ADM.
Required for Arizona and California
Grapes. Zero fill if not required.
Edit with FIPS County Table.
Amount must be > 0, principle only,
excluding any accrued interest.
Must be spaces.
Must be a valid date in YYYYMMDD
format of the date the first bill was issued.
Must be a valid date in YYYYMMDD
format and ≥ First Bill Date. Must be at
least 30 days < RM Data Receipt Date in
Record 60. (Reference the ITS Handbook)
Crop year of the 6th Uncollected Fee
Amount.
Edit with ADM.
Required for Arizona and California
Grapes. Zero fill if not required.
Edit with FIPS County Table.
Must be spaces.
For FCIC use only. u=update, d=duplicate
Must be spaces.

RY 2008