Inventory Value Record - Type 13 - Format - Edits

June 28, 2007

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

1
2
3
4

Record Type
Approved Insurance Provider
Location State
Policy Issuing Company

1
3
5
7

2
2
2
3

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

5
6

Policy Number
Crop Year

10
17

7
4

9(07)
9(04)

7

Crop Code

21

4

9(04)

8

Insurance Plan Code

25

2

9(02)

9
10

Location County
Unit Number

27
30

3
5

9(03)
9(05)

11

Type Code

35

3

9(03)

12
13

Practice Code
Coverage Flag

38
41

3
1

9(03)
X(01)

14

Type 13 Key Reserve

42

34

X(34)

15

Record Number

76

3

9(03)

16

Written Agreement Type

79

2

X(02)

17

Written Agreement Number

81

8

X(08)

18

Written Agreement
Processing Flag
Agent SSN

89

2

X(02)

91

9

9(09)

19

FCIC-APPENDIX III

13 - 1

Field Edits
Required. Must be 13.
Required. Edit with AIP/Company table.
Required. Edit with FIPS State table.
Required. Edit with company table. Must be
valid Pic code for reinsurance year.
Required. Must be > zeros.
Required. This will equal the Reinsurance
Year for Aquaculture (0116). This will equal
Reinsurance Year + 1 for Nursery (0073).
Required; Edit with ADM2 for Nursery (0073).
Required; Edit with ADM1 for
Aquaculture (0116).
Required; Edit with ADM2 for Nursery (50).
Required; Edit with ADM1 for Aquaculture
(43).
Required; Edit with FIPS County Table.
Required; Must be > zeros. For Crop 0073,
optional units are not allowed.
Required for Crop 0073 & 0116.
Edit with ADM-2
Required; Edit with ADM2.
Required; Must be:
C = Catastrophic ‘Cat’ Coverage
A = Additional Coverage
Space Reserved for Additional key data
required in the future or for other record types.
Must be spaces.
Must be > zero and unique within a Crop
Policy (fields 2 thru 9).
Crop 0116 = Spaces.
For Crop 0073:
NL = unrated plant materials or
Spaces = Not Applicable
Any entry requires a valid Written Agreement
Number in field 17.
For RMA issued Written Agreements enter the
identification number for the approved written
agreement for the RO, state, county and crop.
The first 3 digits identify the issuing RO and
must be valid for the location state.
Enter spaces if No Written Agreement exists or
not applicable.
Must be spaces.
Enter the SSN of the agent responsible for the
inventory report.

RY 2008

June 28, 2007

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

20

Revised Report

100

1

X(01)

21

Value/Inventory Value

101

9

9(09)

22

Previous Year Sales

110

9

9(09)

23

Coverage Level

119

5

9(01)V9(04)

FCIC-APPENDIX III

13 - 2

Field Edits

For Crop 0073:
Enter “1” if Plant Inventory report is revised.
Enter “0” for Original report.
For Crop 0116:
Enter “0” for Original Inventory Report. If
the signature date is between 11/1 and 11/30.
Enter “1” for Revised Inventory Report.
Enter “2” for Acquired Interest Report.
Required for Crop 0073: Inventory Value in
dollars by Type from inventory reports for
initial, revised or peak.
For CAT, Inventory Values cannot be greater
than 110% of Previous Year Sales (field 22) or
Actual Inventory Value (Original Inventory
Value, field 55).
Required for Crop 0116: Inventory Value in
dollars.
For CAT Inventory Values cannot be greater
than the Previous Year Sales (field 22) percent
limitation shown on the Special Provisions.
The percent limitations vary by state: Florida,
200%; Massachusetts and Virginia, 300%;
South Carolina, 250%.
For Crop 0116: If field 46 = ‘W’, limitation
percents do not apply.
Required if Coverage Flag = ‘C’. If Crop
0116, Dollar Amount of previous year’s sales.
If Crop 0073, highest amount of plant sales
from any of the 3 previous years. For Buy-up
- zero fill.
Must match Coverage Level Percent
(field 36) on the 14 record.
Valid coverage levels for Crop 0073 and
Crop 0116 are {0.5000,0.5500, 0.6000,
0.6500, 0.7000, 0.7500}.

RY 2008

June 28, 2007

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

24

Price Election Factor

124

5

9(01)V9(04)

25
26

Insured Share
Amount of Insurance
(Actual Liability)

129
133

4
10

9(01)V9(03)
9(10)

27

Unit Division

143

1

X(01)

28
29

Filler
Unit Option Code

144
147

3
2

X(03)
X(02)

30

Common Option Codes

149

20

X(20)

31

Base Premium Rate

169

8

V9(08)

FCIC-APPENDIX III

13 - 3

Field Edits

Required field for Nursery & Clams.
For Crop 0073: Must match Price Election
Factor (field 37) on the 14 record.
If coverage flag (field 13) = ‘A’, this field
must = 1.0000.
If coverage flag (field 13) = ‘C’, this field must
= 0.5500.
For Crop 0116, CAT & Buy-up = Ref Price
Factor from ADM-1 by Stage/Type.
For 0116, Price Election Factor on the T-14
will always = 1.000.
Must be > zero and ≤ 1.000.
Required. See Exhibit 13-1 for calculation. For
Crop 0073 Peak records, this field can not
exceed 200% of field 55 (Original Amount of
Insurance).
For Crop 0073 the values are:
S = Units by Share (CAT and Buyup)
T = Units by Type (NA for CAT)
For Crop 0116 = Space.
Must be spaces.
“BU” = Basic Unit Discount;
Spaces = No Discount
Nursery has no optional units.
Must be left justified.
Crop 0073:
PE = Peak Endorsement
PO = Price Endorsement
RH = Rehabilitation Endorsement
Only use with Practice ‘007’
OC = Organic Certified
OT = Organic Transitional
Spaces = Not Applicable
Crop 0116 = Spaces.
Required; Edit with the ADM ‘1’ Record.

RY 2008

June 28, 2007

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

32

Proration Factor

177

3

9(01)V9(02)

33

Total Premium

180

10

9(10)

34

Subsidy

190

10

9(10)

35
36
37
38
39

Additional Subsidy Flag
Additional Subsidy
State/Private Subsidy Flag
State/Private Subsidy
Producer Premium

200
201
211
212
222

1
10
1
10
10

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

40

Insured’s Inventory Signature
Date

232

8

9(08)

41

Peak Commencement Date

240

8

9(08)

42

Peak Termination Date

248

8

9(08)

43

Filler

256

10

X(10)

FCIC-APPENDIX III

13 - 4

Field Edits

For Crop 0116; If the Revised Report field =
‘0’, then this factor must = 1.00. If the Revised
Report field = ‘1’ or ‘2’, then this field must =
the factor for the month containing the 31st
calendar day after the Signature Date.
For Crop 0073;
Carryover Policies = Use the Proration Factor
for the month of June from the ADM-N unless
field 40 (signature date) is after 5/1. If date is
after 5/1 then factor from ADM-N for month in
which the 31st day after signature date falls.
New Policies and Revised Reports = Factor
from ADM-N for month in which the 31st day
after Signature Date falls.
Peak Endorsement = Commencement Month
Factor – Factor for Month following
Termination Month.
Peak Endorsement Terminating in May =
Commencement Month Factor.
Required; edit according to the premium
calculation for the crop and insurance plan. If
any total premium is less than $1, round to $1.
Required; enter dollar amount of subsidy for
the crop and insurance plan. If less than $1.00
round to $1.00. For CAT, subsidy must equal
Total Premium.
Must be a space.
Must be zeros.
Reserved. Must be a space.
Reserved. Must be zeros.
Edit according to producer premium
calculations for the crop and insurance plan.
‘CAT’ coverage policies zero fill.
Required. Format=MMDDCCYY. This date
cannot be less than the Reinsurance Year – 1
or greater than the Submission Date. For crop
0073, this date cannot be less than the Crop
Year -1 or greater than the Submission Date.
Crop 0116=zeros.
For Crop 0073: Peak only - commencement
date of coverage (MMDDCCYY). Valid for
Buy-up only. If not applicable, zero fill.
For crop 0073 must be <= 5/1/2009.
Crop 0116=zeros.
Peak only - termination date of coverage
(MMDDCCYY). Valid for Buy-up only. If
not applicable, zero fill. For crop 0073 must
be <= 5/31/2009.
Must be spaces.
RY 2008

June 28, 2007

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

44

Crop Year Deductible

266

10

9(10)

For Crop 0073:
Inventory value * (1 - Coverage Level) for
the record line. For type 071 (liners):
Inventory value * Survival Factor * (1Coverage Level) for the record line.
For Crop 0116: Buy up & CAT =
Inventory Value for the basic unit * (1 –
Coverage Level)
Must be the same on all lines for the basic unit
for CAT & Buy-up.

45

Filler

276

3

X(03)

46

Previous Year Sales Flag

279

1

X(01)

47
48

Filler
Survival Factor

280
288

8
4

X(08)
9(01)V9(03)

49

Survival Factor Flag

292

1

X(01)

50

Number of Clams

293

8

9(08)

51

Price Election Amount

301

8

9(04)V9(04)

52

Weeks Late

309

2

9(02)

53

First Submission Flag

311

1

X(01)

Must be spaces.
For crop 0073, must be a space.
For crop 0116 use ‘W’ if Coverage Flag = ‘C’
and previous year sales limit requirement is
waived.
Buy-up = Spaces.
Must be spaces.
For Crop 0073 with Type 071 (Liners), factor
from SPOI. Otherwise zero fill.
For Crop 0116:
If Survival Factor Flag = “A”, match to
ADM2 for type/stage and practice.
If Survival Factor Flag = “E”, factor will be
0.500.
If Survival Factor Flag = “I”, enter survival
factor for the unit.
For Crop 0073 must be a Space.
For Crop 0116, enter “A” if inventory value
uses ADM2 survival factor. Enter “I” if
individual survival factor was used. Enter
“E” if inventory value uses survival factor for
grow-out bags exceeding 1200 clams.
Crop 0073 = Zeros.
Enter the total number of clams by stage.
Crop 0073 = Zeros.
For Crop 0116:
CAT = ADM-1 REF MAX CAT Price *
Stage Price Factor
Buy-up = ADM-1 REF MAX Price *
Stage Price Factor
Internal Use. The number of weeks late this
acreage line was originally submitted based on
latest acreage reporting date for the 14 records
submitted within the batch.
Internal Use. Must be spaces.

FCIC-APPENDIX III

13 - 5

RY 2008

June 28, 2007

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

54

Agent’s Signature Date

312

8

9(08)

55

Original Inventory Value

320

9

9(09)

56

Ineligible Tracking
Validation Flag
Filler

329

8

X(08)

Required. Valid format is MMDDCCYY.
For crop 0116, this date cannot be less than
the Reinsurance Year – 1 or greater than the
submission date. For crop 0073, this date
cannot be less than Crop Year -1 or greater
than the submission date.
For Crop 0073 use for Peak Endorsement
records and Inventory report for CAT. For
Peak Endorsements, must = the original
Amount of Insurance for the unit. For crop
0073 CAT, this will be the Actual Inventory
Value for the unit.
For Crop 0116 use for Revised Inventory
Report and Acquired Interest report. Must =
Original Inventory Value for the unit.
Internal Use. Reserved.

337

214

X(214)

Must be spaces.

57

FCIC-APPENDIX III

13 - 6

RY 2008

June 28, 2007

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

58

FCIC Control Time

551

4

9(04)

59

FCIC Control Date

555

8

9(08)

60

Reinsurance Year

563

4

9(04)

61

Batch Number

567

4

9(04)

62

Transaction Sequence
Number

571

8

9(08)

63
64
65

Transaction Rejected Flag
Transaction Source Flag
FCIC Initially Accepted Date

579
580
581

1
1
8

X(01)
X(01)
9(08)

66

FCIC Initially Accepted
Batch

589

4

9(04)

67

Filler

593

8

X(08)

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 Use. Reserved
Internal Use. Reserved
Internal Use. The date this record was initially
accepted by DAS. MMDDCCYY format.
RMA Internal Use. The sequential number
identifying the file that was initially submitted
by the AIP to FCIC/RMA and accepted by
DAS.
Internal Use.

Notes:
An accepted T-10 and T-14 record must exist for each crop policy. The Type 14 must match the
Type 13 records on:
Fields 2 thru 9 and Fields 11 and 13.
If these matching records are not found, the type 13 record will be rejected.

FCIC-APPENDIX III

13 - 7

RY 2008