Inventory Value Record - Type 13 - Format/Edits

June 18, 2004

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

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
7

Policy Number
Crop Year
Crop Code

10
17
21

7
4
4

9(07)
9(04)
9(04)

8

Insurance Plan Code

25

2

9(02)

9
10
11

Location County
Unit Numb er
Type Code

27
30
35

3
5
3

9(03)
9(05)
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)

For RMA issued Written Agreements enter the
identification number for the approved written
agreement for the AIP, state, county and crop.
The first 3 digits identify the issuing RSO and
must be valid for the location state.
Enter spaces if No Written Agreement exists or
not applicable.

18

Written Agreement
Processing Flag

89

2

X(02)

Must be spaces.

FCIC-APPENDIX III

13 - 1

Required. Must be 13.
Required. Edit with AIP/Company table.
Required. Edit with FIPS State table.
Required. Edit with comp any table. Must be
valid Pic code for reinsurance year.
Required. Must be > zeros.
Required. This will equal the Reinsurance Year.
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.
Required; Enter 997 for Crop 0073. Edit with
ADM1 for Crop 0116.
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, must be:
NL = unrated plant materials or
Spaces = Not Applicable
Any entry requires a valid Written Agreement
Number in field 17.
Crop 0116 = Spaces.

RY 2005

June 18, 2004

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

19

Agent SSN

91

9

9(09)

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

Enter the SSN of the agent responsible for the
inventory report.
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,
insurance attaches on the 31st day after the
signature date.
Enter “1” for Revised Inventory Report.
Insurance attaches on the 31st day after
the signature date.
Enter “2” for Acquired Interest Report.
Insurance attaches on the 31st day after the
signature date.
Required for Crop 0073: Inventory Value in
dollars for the Basic Unit.
For CAT the value cannot be > 150% for
practice 008 or 250% for practice 007 of
previous year sales amount.
If field 46 = ‘W’, limitation percents do not
apply.
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%.
If field 46 = ‘W’, limitation percents do not
apply.
Required if Crop = 0073 or 0116 and Coverage
Flag = ‘C’. Must = Dollar Amount of previous
year’s sales. For Buy-up - zero fill.
Must match Coverage Level Percent
(field 35) 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 2005

9(09)

June 18, 2004

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

129
133

4
10

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

27
28

Insured Share
Amount of Insurance
(Actual Liability)
Filler
Unit Option Code

143
147

4
2

X(04)
X(02)

29

Common Option Codes

149

20

X(20)

30

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 36) on the 14 record.
If coverage flag (field 13) equals ‘C’, this field
must = 0.5500.
If coverage flag (field 13) equals ‘A’ and
coverage level (field 23) equals:
1.) 0.5000 this field must = 1.0000
2.) 0.5500 this field must be = 0.9100
3.) 0.6000 this field must be = 0.8400
4.) 0.6500 this field must be = 0.7700
5.) 0.7000 this field must be = 0.7200
6.) 0.7500 this field must be = 0.6700
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 the calculation page for required
calculation. (actual liability) (See exhibit 13-1)
Must be spaces.
Enter “BU” for Basic Unit Discount;
Spaces = optional units.
Must be left justified.
Crop 0073 = ‘PE’
Use only for Peak Endorsement.
Crop 0116 = Spaces.
Required; Edit with the ADM ‘1’ Record.

RY 2005

June 18, 2004

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

31

Proration Factor

177

3

9(01)V9(02)

32

Total Premium

180

10

9(10)

33

Subsidy

190

10

9(10)

34
35
36
37
38

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)

39

Insured’s Inventory
Signature Date

232

8

9(08)

40

Peak Commencement Date

240

8

9(08)

41

Peak Termination Date

248

8

9(08)

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 30th
calendar day after the Signature Date.
For Crop 0073; For Plant Inventory Report Enter factor from ADM ‘N’ Record for the
month of the signature date plus 30 days.
For Peak Endorsement - Enter the proration
factor determined from the ADM ‘N’ Record by
subtracting the factor for the month after the
termination month from the factor for the
commencement month. (Note, if termination
month is September, factor = commencement
month factor.) For a new policy enter the
proration factor for the month containing the
30th calendar day after the signature date. For
carryover policies, enter 1.00.
For a revised report, enter 1.00.
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.
Reserved; must be a space.
Reserved; 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.
Crop 0116=zeros.
For Crop 0073: Peak only - commencement date
of coverage (MMDDCCYY). Valid for Buy-up
only. If not applicable, zero fill.
Crop 0116=zeros.
Peak only - termination date of coverage
(MMDDCCYY). Valid for Buy-up only. If not
applicable, zero fill.

RY 2005

June 18, 2004

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

42

Liability Excluding Price &
Share (XPS)

256

10

9(10)

43

Crop Year Deductible

266

10

9(10)

44
45
46

Appendix IV Review Flag
Filler
Previous Year Sales Flag

276
278
279

2
1
1

9(02)
X(01)
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)

FCIC-APPENDIX III

13 - 5

Field Edits

Crop 0116 = zeros.
For Crop 0073: Inventory value * coverage
level.
For Crop 0073: Buy up =
Practice value * (1 - Coverage Level) for
the line. For Peak records this field is
calculated using the original Inventory
Value + the Peak Inventory Value. For
overlapping Peaks this field will not include
both Peak Inventory Values.
CAT =
Practice value for the basic unit * (1 –
Coverage Level) for CAT this field must be
the same on all lines for the basic unit.
For Crop 0016: 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.
Must be zeros.
Must be spaces
For crop 0073 or 0116 use ‘W’ if Coverage Flag
= ‘C’ and previous year sales limit requirement
is waived.
Buy-up = Spaces.
Must be spaces.
Crop 0073 = Spaces.
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.
Crop 0073 = Spaces.
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.

RY 2005

June 18, 2004

Exhibit 13

FCIC-Appendix III

(INVENTORY VALUE RECORD – TYPE 13)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

51

Price Election Amount

301

8

9(04)V9(04)

52

Weeks Late

309

2

9(02)

53
54

First Submission Flag
Agent’s Signature Date

311
312

1
8

X(01)
9(08)

55

Original Inventory Value

320

9

9(09)

56

Ineligible Tracking Validation
Flag
Filler

329

8

X(08)

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.
Required. Valid format is MMDDCCYY.
This date cannot be less than the Reinsurance
Year – 1 or greater than the submission date.
For Crop 0073 use for Peak Endorsement
records and Revised Inventory report. Must =
the original 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 2005

June 18, 2004

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:
A 10 and 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 2005