Policy Record - Type 10 - Format/Edits

June 18, 2004

Exhibit 10

FCIC-Appendix III

(POLICY RECORD – TYPE 10)
Format/Edits

Field
No.

1
2*

Field Name

Begin
Pos.

Size

Picture

Field Edits

1
3

2
2

9(02)
X(02)

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

3*
4

Record Type
Approved Insurance
Provider
Location State
Policy Issuing Company

5
7

2
3

9(02)
9(03)

5*
6*

Policy Number
Crop Year

10
17

7
4

9(07)
9(04)

7

Type 10 Key Reserve

21

55

X(55)

8

Record Number

76

3

9(03)

9

Branch Office

79

2

X(02)

10*

Id Type

81

1

9(01)

11*

Id Number

82

9

9(09)

Required. Edit with FIPS State table.
Required. 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 Ye ar or Reinsurance Year +/- 1
for the applicable crop code.
Space Reserved for Additional key data
required in the future or for other record
types.
Required. Must be > zero. Only one record
number “001” is permitted. Record numbers
002-999 are used to report SBI entities.
Required Reinsured organization branch
office for Record 001. Record 002 or greater
must be spaces.
Required; must be one of the following:
1 = SSN,
2 = EIN,
5 = BIA Number.
(See Exhibit 10-1 for valid combinations)
Required; must be one of the following:
1 Social Security Number
2 EIN Number (Numeric, > zero)
5 A valid Bureau of Indian Affairs No.
(See Exhibit 10-1 for valid combinations)

FCIC-APPENDIX III

10 - 1

RY 2005

June 18, 2004

Exhibit 10

FCIC-Appendix III

(POLICY RECORD – TYPE 10)
Format/Edits

Field
No.

Field Name

Begin
Pos.

12*

Entity Type

91

1

X(01)

13

Producer Last Name

92

20

X(20)

14

Producer First Name

112

10

X(10)

15

Producer Middle Name

122

10

X(10)

16

Producer Name Suffix

132

5

X(05)

FCIC-APPENDIX III

Size

10 - 2

Picture

Field Edits

Required; Must be one of the following:
I = Individual- Only “L” SBI Records
C = Corporation
K = Corporation without SBI
E = Religious, Charitable, Educational,
Associations, Clubs, or Other TaxExempt Organizations – No SBI
records allowed
G = Public Entities, State or Local
Government – No SBI records allowed
J = Co-Owner/Joint Operators
L = Landlord/Tenant – Only used as SBI
M = Tobacco Marketing Card (One Entity for
a group of people operating under one card)
Valid for Cat Coverage Only.
N=Enterprise
P = Partnership
Q = Partnership with less than 2 SBI’s
S = Spousal Husband/Wife
T = Trusts
D = Estates
O = Other (Non-US Citizens)
B = Bureau of Indian Affairs
U = Undivided Interests Valid for Cat
Coverage Only.
(See Exhibit 10-1 for valid combinations)
Required if field 18 (Bus. Name) is blank. Left
Justify. Use for persons names only Any
entry requires a minimum of 2 characters.
Only one name per field. Alpha with (-), (.), (
), (‘), (,).
Required if field 13 is not blank. Left Justify.
Use for persons names only. Only one name
per field. For Entity Type of ‘J’ there can be 2
First Names. Alpha with (-), (.), ( ), (‘), (,).
Optional; Left Justify if reported. Alpha with
(-), (.), (‘), (,). Leave blank if not reported.
Optional; Left Justify if reported. The name
suffix of the producer (e.g. SR, JR, II, etc.).
Alphabetic except for (-), (.), ( ) (‘) or (,).
Otherwise; spaces.

RY 2005

June 18, 2004

Exhibit 10

FCIC-Appendix III

(POLICY RECORD – TYPE 10)
Format/Edits

Field
No.

Field Name

Begin
Pos.

Size

Picture

Field Edits

17

Producer Title

137

4

X(04)

18

Business Name

141

35

X(35)

19
20
21

Address Line 1
Address Line 2
City

176
211
246

35
35
35

X(35)
X(35)
X(35)

22

Address State

281

2

X(02)

23

Zip Code

283

5

9(05)

24
25
26

Zip Extension
Phone Number
Employee

288
292
302

4
10
1

9(04)
9(10)
X(01)

27

Ineligible SBI Flag

303

1

X(01)

For SBI records only. Record number must
be equal to or greater than 002. Enter Y if SBI
Entity is ineligible and share has been
reduced. Otherwise, blank.

28

Appendix IV Review Flag

304

2

9(02)

Must be zeros.

29

Ineligible SBI Share

306

4

9(01)V9(03)

Required: For SBI records only with an
Ineligible SBI Flag of Y. Must be > 0%
and = 1.000. Record number must be = 002.
Must be zeros if not applicable.

30

USDA Common Customer
ID

310

6

X(06)

Reserved.

31
32

Filler
SSN Validation Flag

316
347

31
2

X(31)
X(02)

33

Filler

349

202

X(202)

Must be Spaces.
Internal Use. Will be populated during SSN
edit.
Must be Spaces.

FCIC-APPENDIX III

10 - 3

Optional; Left Justify if reported. The title of
the producer (e.g. MR, MRS, DR, etc.).
Alphabetic except for (-), (.), ( ) or (“).
Otherwise; spaces.
Required if field 13 is blank. Left Justify. Use
for all Entity Types except individual persons.
May contain: alpha, number, (-), (,),( ), (‘),
(&), (.), (%), (*) or (#).
Required. Left Justify.
Optional. Left Justify. Otherwise; spaces.
Required; If State code = ZZ enter foreign city
and country. Left Justify.
Required; Enter Alpha state abbreviation. If a
foreign country, enter ZZ.
Required if State NE ZZ; Must be a valid US
zip code.
Optional. Otherwise; zero fill.
Required. If no phone number enter all fives.
Required. For Record Number 001 must be:
C = Insurance Provider Employee
E = RMA Employee/FCIC
R = Relative of Insurance Provider Employee
A = Agency Owner, Agent or Adjuster
N = None of the Above
Optional for Records 002-999 or blank.

RY 2005

June 18, 2004

Exhibit 10

FCIC-Appendix III

(POLICY RECORD – TYPE 10)
Format/Edits

Field
No.

Field Name

Begin
Pos.

Size

Picture

34

FCIC Control Time

551

4

9(04)

35

FCIC Control Date

555

8

9(08)

36

Reinsurance Year

563

4

9(04)

37

Batch Number

567

4

9(04)

38

Transaction Sequence
Number

571

8

9(08)

39
40
41

Transaction Rejected Flag
Transaction Source Flag
Filler

579
580
581

1
1
20

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

Field Edits

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
AIP to FCIC/RMA.
Internal Use. The sequential number
assigned to each transaction number
processed by DAS after it has been sorted.
Internal. Reserved
Internal. Reserved
Internal.

* Data elements that must be accepted to meet timely reporting of an eligible crop insurance contract.
Notes:
A 10 record always requires a T-14 record.
Contract number/Policy consists of AIP, Location State, Company, Policy number and Crop year.
If any type 10 record is rejected, then all records for the contract (except the T-09) will be rejected.

FCIC-APPENDIX III

10 - 4

RY 2005