file type: reinsurance year: version: release date: bus

Application Source: Delimited

File Group: 2014

Record Name: Draft 1

Record Code: 2/20/2013

Record

Number Ou

tpu

t

Field

Number Field Name Data Type

Max

Length Format

BUS

Key Req? Rules

E11 1 Reinsurance Year Numeric 4 CCYY Y Reinsurance Year must be "2014".

E11 2 Record Type Code Character 6 Y

E11 3 State Code Character 2 Y

E11 4 County Code Character 3 Y

E11 5 Client Id Character 100

E11 6 Group Number Numeric 9 999999999 Y

E11 7 Coverage Type Code Character 1 Y

E11 8 Commodity Year Numeric 4 CCYY Y

E11 9 Commodity Code Character 4 Y

E11 10 Insurance Plan Code Character 2 Y

E11 11 EU or WU Number Character 1

E11 12 Basic Unit Number Character 4

E11 13 Optional Unit Number Character 4

E11 14 Unit Structure Code Character 2 Y

E11 15Type Code

Character 3 YRequired when Extended Type/Practices are not

implemented for the commodity.

E11 16Practice Code



E11 17Commodity Type Code



E11 18Class Code



E11 19Sub Class Code



E11 Release Date:

File Type:

Reinsurance Year:

Acreage Premium Version:

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 20Intended Use Code



E11 21Cropping Practice Code



E11 22Irrigation Practice Code



E11 23Organic Practice Code



E11 24Interval Code



E11 25 Reference Commodity Year Numeric 4 CCYY

E11 26 Sub County Code Character 8

E11 27Insurance Option Code List

Character 29Insurance Option Code List must be valid; edit

with Option Rate ADM, "A01060".

E11 28 Reported Tree Count Numeric 10 9999999999

E11 29 Reported Pounds Numeric 10 999999999

E11 30Price Election Percent

Numeric 6 9.9999 YPrice Election Percent must be valid, edit with the

Price Election Percent ICE, "D00007".

E11 31 Price Election Amount Numeric 9 9999.9999

E11 32 Additional Subsidy Flag Character 1

E11 33 State Private Subsidy Flag Character 1

E11 34 Guarantee Adjustment Type Code Character 1

E11 35 Premium Rate Surcharge Flag Character 1

E11 36 Approved Yield Numeric 11 99999999.99

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 37 Insured Share Percent Numeric 5 9.999

E11 38 Price Indicator Code Character 1

E11 39 Contract Price Numeric 10 99999.9999

E11 40 Experience Factor Numeric 6 9.9999

E11 41 Reported Acreage Numeric 9 999999.99

E11 42 Reported Tons Numeric 10 9999999.99

E11 43 Reported Colonies Numeric 9 999999999

E11 44 Section Count Numeric 2 99

E11 45 Yield Conversion Factor Numeric 5 9.999

E11 46 Coverage Level Percent Numeric 6 9.9999

E11 47 CEO Coverage Level Percent Numeric 6 9.9999

E11 48 Dollar Amount Of Insurance Numeric 13 9999999.9999

E11 49 Projected Price Numeric 9 99999.9999

E11 50 Price Volatility Factor Numeric 4 9.99

E11 51 Crush District Code Character 2

E11 52 Minimum Payment Quantity Numeric 8 999999.9

E11 53 Rate Yield Numeric 11 99999999.99

E11 54 Density Quantity Numeric 9 999999999

E11 55 Tree Age Numeric 5 99999

E11 56 Month Number Numeric 0

E11 57 Growth Stage Code Character 3

E11 58 Farm Serial Number Count Numeric 11 99999999999

E11 59 Planted Date Date 8 CCYYMMDD

E11 60 Multiple Cropping Code Character 2

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 61 Acreage Number Numeric 9 999999999

E11 62 Guarantee Adjustment Factor Numeric 5 9.999

E11 63 Stand Percent Numeric 3 2

E11 64 Adjusted Yield Numeric 11 99999999.99

E11 65 Landings Year 1 Pounds Numeric 8 99999999



E11 68 Percent of Value Numeric 4 9.99

E11 69 Total Insured Acreage Numeric 10 9999999.99

E11 70 Total Insured Colonies Numeric 10 9999999.99

E11 * 71 Additional Subsidy Amount Numeric 10 9999999999

E11 * 72 State Private Subsidy Amount Numeric 10 9999999999

E11 * 73 Unit Premium Adjustment Factor Numeric 6 9.9999

E11 * 74 Proration Factor Numeric 5 9.999

E11 * 75 Unit Liability Amount Numeric 10 9999999999

E11 * 76 Residual Factor Numeric 5 9.999

E11 * 77 Subsidy Amount Numeric 10 9999999999

E11 * 78 Liability Amount Numeric 10 9999999999

E11 * 79 Total Premium Amount Numeric 10 9999999999

E11 * 80 Producer Premium Amount Numeric 10 9999999999

E11 * 81 Base Premium Rate Numeric 11 9.999999999

E11 * 82 Preliminary Base Rate Numeric 11 9.999999999

E11 * 83 Acre Loaded Premium Amount Numeric 9 9999.9999

E11 * 84 AO Expense Subsidy Amount Numeric 13 9999999999.99

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 * 85 CAT Loss Adjustment Expense Amount Numeric 13 9999999999.99

E11 * 86 Unit Structure Discount Factor Numeric 10 9.99999999

E11 * 87 Variable Unit Structure Disount Factor Numeric 10 9.99999999

E11 * 88 Acre Guarantee Quantity Numeric 11 99999999.99

E11 * 89 Historical Packout Factor Numeric 5 9.999

E11 * 90 Guarantee Per Acre Amount Numeric 11 99999999.99

E11 * 91 Premium Liability Amount Numeric 10 9999999999

E11 * 92 Prior Year Yield Ratio Numeric 4 9.99

E11 * 93 Rate Method Code Character 1

E11 * 94 Fixed Rate Numeric 5 9.999

E11 * 95 Additive Optional Rate Adjustment Factor Numeric 11 99999999.99

E11 * 96 CEO Coverage Factor Numeric 7 9.99999

E11 * 97 CEO Premium Liability Amount Numeric 10 9999999999

E11 * 98 CEO Liability Amount Numeric 10 9999999999

E11 * 99 Current Year Yield Ratio Numeric 4 9.99

E11 * 100 Current Year Base Rate Numeric 19 9999999999.99999

E11 * 101 Prior Year Base Rate Numeric 19 9999999999.99999

E11 * 102 Combo Prior Year Base Rate Numeric 19 9999999999.99999

E11 * 103 Prior Year Fixed Rate Numeric 5 9.999

E11 * 104 Rate Differential Factor Numeric 11 9.999999999

E11 * 105 Unit Residual Factor Numeric 7 999.999

E11 * 106 Prior Year Unit Residual Factor Numeric 5 9.999

E11 * 107 Current Year Base Premium Rate Numeric 19 9999999999.99999

E11 * 108 Prior Year Base Premium Rate Numeric 19 9999999999.99999

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 * 109 Enterprise Unit Residual Factor Numeric 5 9.999

E11 * 110 Prior Year Enterprise Unit Residual Factor Numeric 5 9.999

E11 * 111 Multiplicative Optional Rate Adjustment FactorNumeric 11 999999.9999

E11 * 112 Premium Rate Numeric 11 99.99999999

E11 * 113 Basic Unit Discount Factor Numeric 5 9.999

E11 * 114 Enterprise Unit Discount Factor Numeric 5 9.999

E11 * 115 Preliminary Liability Amount Numeric 10 9999999999

E11 * 116 Multiple Commodity Adjustment Factor Numeric 5 9.999

E11 * 117 Subsidy Percent Numeric 5 9.999

E11 * 118 Raw Rate Numeric 17 99999999.9999999

E11 * 119 Base Rate Numeric 8 999.9999

E11 * 120 Combo Base Rate Numeric 19 9999999999.99999

E11 * 121 Revenue Lookup Rate Numeric 15 9999999999.9999

E11 * 122 Proportional Liability Type Amount Numeric 15 999999.99999999

E11 * 123 Proportional Liability Practice Amount Numeric 15 999999.99999999

E11 * 124 Proportional Liability Unit Amount Numeric 15 999999.99999999

E11 * 125 Average Raw Rate Numeric 17 99999999.9999999

E11 * 126 Average Base Rate Numeric 17 99999999.9999999

E11 * 127 Average Base Premium Rate Numeric 17 99999999.9999999

E11 * 128 Predicted Value Quantity Numeric 15 9999999999.9999

E11 * 129 Intercept Coefficient Numeric 6 9.9999

E11 * 130 Total Unit Size Coefficient Numeric 9 9.9999999

E11 * 131 Average County Base Rate Coefficient Numeric 7 99.9999

E11 * 132 Type Coefficient Numeric 6 9.9999

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 * 133 Practice Coefficient Numeric 6 9.9999

E11 * 134 Standard Normal Cumulative Distribution Function QuantityNumeric 15 9999999999.9999

E11 * 135 Standard Normal Probability Distribution Function QuantityNumeric 15 9999999999.9999

E11 * 136 Expected Normalized LCR Difference Quantity Numeric 19 9999999999.99999

E11 * 137 Yield Protection LCR Difference Quantity Numeric 15 9999999999.9999

E11 * 138 Mean Quantity Numeric 13 999.999999999

E11 * 139 Adjusted Mean Quantity Numeric 15 9999999999.9999

E11 * 140 Log Mean Quantity Numeric 15 9999999999.9999

E11 * 141 Log Variance Quantity Numeric 15 9999999999.9999

E11 * 142 Yield Draw Quantity Numeric 12 99.999999999

E11 * 143 Price Draw Quantity Numeric 12 99.999999999

E11 * 144 Simulated Yield Protection Losses Quantity Numeric 28 12

E11 * 145 Simulated Yield Protection Base Premium RateNumeric 15 9999999999.9999

E11 * 146 Simulated Revenue Protection Base Premium RateNumeric 15 9999999999.9999

E11 * 147 Simulated Revenue Protection With Harvest Price Exclusion Base Premium RateNumeric 15 9999999999.9999

E11 * 148 Preliminary Revenue Protection Add On Rate Numeric 15 9999999999.9999

E11 * 149 Preliminary Revenue Protection With Harvest Price Exclusion Add On RateNumeric 15 9999999999.9999

E11 * 150 Capping Yield Ratio Numeric 4 9.99

E11 * 151 Prior Capping Yield Ratio Numeric 4 9.99

E11 * 152 Capping Reference Rate Numeric 6 9.9999

E11 * 153 Prior Capping Reference Rate Numeric 6 9.9999

E11 * 154 Capping Reference Yield Numeric 8 99999.99

E11 * 155 Prior Capping Reference Yield Numeric 8 99999.99

E11 * 156 Capping Rate Multiplier Numeric 15 9999999999.9999

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 * 157 Prior Capping Rate Multiplier Numeric 15 9999999999.9999

E11 * 158 Capping Exponent Value Numeric 6 99.999

E11 * 159 Prior Capping Exponent Value Numeric 6 99.999

E11 * 160 Historical Capping Base Rate Numeric 15 999999.99999999

E11 * 161 Historical Prior Capping Base Rate Numeric 15 999999.99999999

E11 * 162 Capping Fixed Rate Numeric 5 9.999

E11 * 163 Prior Capping Fixed Rate Numeric 5 9.999

E11 * 164 Historical Basic Unit Base Rate Numeric 15 999999.99999999

E11 * 165 Historical Revenue Protection Base Premium RateNumeric 199999999999.99999

999

E11 * 166 Historical Revenue Protection With Harvest Price Exclusion Base Premium RateNumeric 199999999999.99999

999

E11 * 167 Capped Revenue Protection Add On Rate Numeric 199999999999.99999

99

E11 * 168 Capped Revenue Protection With Harvest Price Exclusion Add On RateNumeric 199999999999.99999

99

E11 * 169 Capping Year Numeric 4 9999

E11 * 170 Simulated Revenue Protection Losses Whole FarmNumeric 2999999999999999.9

9999999999999

E11 * 171 Simulated Revenue Protection Losses With Harvest Price Exclusion Whole FarmNumeric 2999999999999999.9

9999999999999

E11 * 172 Whole Farm Base Premium Rate Numeric 199999999999.99999

999

E11 * 173 Capped Revenue Add On Factor Numeric 199999999999.99999

999

E11 * 174 Reference Maximum Dollar Amount Numeric 10 99999.9999

E11 * 175 Survival Percent Numeric 5 9.999

E11 * 176 Inventory Value Amount Numeric 9 999999999

E11 * 177 First Year Thinning Factor Numeric 4 9.99

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 * 178 Yield Price Factor Numeric 6 99.999

E11 * 179 Proration Percent Numeric 4 9.99

E11 * 180 Modified Yield Numeric 13 99999999999.9

E11 * 181 Reference Amount Numeric 8 99999.99

E11 * 182 Prior Year Reference Amount Numeric 8 99999.99

E11 * 183 Current Year Rate Multiplier Numeric 13 9999.99999999

E11 * 184 Prior Year Rate Multiplier Numeric 13 9999.99999999

E11 * 185 Sub County Rate Numeric 6 99.999

E11 * 186 Total Guarantee Amount Numeric 12 999999999.99

E11 * 187 Whole Farm Discount Factor Numeric 7 99.9999

E11 * 188 Premium Guarantee Per Acre Amount Numeric 11 99999999.99

E11 * 189 Premium Total Guarantee Amount Numeric 12 999999999.99

E11 * 190 Exponent Value Numeric 6 999.99

E11 * 191 Prior Year Exponent Value Numeric 6 99.999

E11 * 192 Standard Deviation Quantity Numeric 13 9999999999.99

E11 * 193 Combo Standard Deviation Quantity Numeric 13 9999999999.99

E11 * 194 Adjusted Standard Deviation Quantity Numeric 18 9999999999.99999

E11 * 195 Prior Year Rate Differential Factor Numeric 11 9.999999999

E11 * 196 Unit Of Measure Abbreviation Character 5

E11 * 197 Reference Rate Numeric 6 9.9999

E11 * 198 Prior Year Reference Rate Numeric 6 9.9999

E11 * 199 Premium Surcharge Percent Numeric 4 9.99

E11 * 200 Preliminary Total Premium Numeric 10 9999999999

E11 * 201 Range Class Code Character 3

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 * 202 Sales Closing Date Date 8 CCYYMMDD

E11 * 203 Acreage Reporting Date Date 8 CCYYMMDD

E11 * 204 Administrative Fee Amount Numeric 0

E11 * 205 Beta0 Factor Numeric 12 99.999999999















E11 * 220 Area Low Quantity Numeric 8 99999999

E11 * 221 Area High Quantity Numeric 8 99999999

E11 * 222 Total Liability Amount Character 20

E11 * 223Simulated Revenue Protection Losses

QuantityNumeric 29

9999999999999999.99999

9999999

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 * 224Simulated Revenue Protection With

Harvest Price Exclusion Losses QuantityNumeric 29

9999999999999999.99999

9999999

E11 * 225 Revenue Protection Whole Farm Rate Numeric 199999999999.99999

999

E11 * 226Revenue Protection With Harvest Price

Exclusion Whole Farm RateNumeric 19

9999999999.99999

999

E11 * 227 Minimum Dollar Amount Numeric 0

E11 * 228 Maximum Dollar Amount Numeric 0

E11 * 229 Catastrophic Dollar Amount Numeric 10 99999.9999

E11 * 230 Age Low Count Numeric 0

E11 * 231 Age High Count Numeric 0

E11 * 232 Density Low Quantity Numeric 0

E11 * 233 Density High Quantity Numeric 0

E11 * 234 Catastrophic Factor Numeric 4 9.99

E11 * 235 Maximum Liability Amount Numeric 8 99999.99

E11 * 236 Minimum Liability Amount Numeric 8 99999.99

E11 * 237 Biotech Reported Acreage Percentage Numeric 3 2

E11 * 237 County Base Value Numeric 7 9999.99

E11 * 238 Whole Farm Unit Residual Factor Numeric 5 9.999

E11 * 239 Prior Year Whole Farm Unit Residual Factor Numeric 5 9.999

E11 * 240 Fixed Optional Rate Numeric 11 999999.9999

E11 * 241 Expected Revenue Factor Numeric 6 9.9999

E11 * 242 Optional Unit Discount Factor Numeric 5 9.999

E11 * 243 Unadjusted Approved Revenue Amount Numeric 10 9999999999

E11 * 244 County Yield Numeric 6 9999.9

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 * 245 Maximum Minimum Payment Quantity Numeric 8 999999.9

E11 * 246 Option Conversion Factor Numeric 8 999.9999

E11 * 247 Premium Acre Guarantee Quantity Numeric 11 99999999.99

E11 * 248 Short Rate Adjustment Rate Numeric 6 9.9999

E11 * 249 Enterprise Unit Discount 65 Factor Numeric 5 9.999

E11 * 250 Basic Unit Discount 65 Factor Numeric 5 9.999

E11 * 251 Revenue Lookup Adjustment Factor Numeric 5 9.999

E11 * 252Total Premium Multiplicative Optional

Rate Adjustment FactorNumeric 7 99.9999

E11 * 253 Lookup Rate Numeric 15 9999999999.9999

E11 * 254 Maximum Coverage Level Percent Numeric 6 9.9999

E11 * 255 Effective Coverage Level Percent Numeric 6 9.9999

E11 * 256 Floored Effective Coverage Level Percent Numeric 6 9.9999

E11 * 257 Base Coverage Level Percent Numeric 6 9.9999

E11 * 258 Lower Bound Coverage Level Percent Numeric 6 9.9999

E11 * 259 Upper Bound Coverage Level Percent Numeric 6 9.9999

E11 * 260 Base Rate Differential Factor Numeric 11 9.999999999

E11 * 261 Base Prior Year Rate Differential Factor Numeric 11 9.999999999

E11 * 262 Base Unit Residual Factor Numeric 7 999.999

E11 * 263 Base Enterprise Unit Residual Factor Numeric 5 9.999

E11 * 264 Base Whole Farm Unit Residual Factor Numeric 5 9.999

E11 * 265 Base Prior Year Unit Residual Factor Numeric 5 9.999

E11 * 266Base Prior Year Enterprise Unit Residual

FactorNumeric 5 9.999

"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 * 267Base Prior Year Whole Farm Unit Residual


E11 * 268 Lower Bound Rate Differential Factor Numeric 11 9.999999999

E11 * 269Lower Bound Prior Year Rate Differential


E11 * 270 Lower Bound Unit Residual Factor Numeric 5 9.999

E11 * 271Lower Bound Enterprise Unit Residual


E11 * 272Lower Bound Whole Farm Unit Residual


E11 * 273Lower Bound Prior Year Unit Residual


E11 * 274Lower Bound Prior Year Enterprise Unit

Residual FactorNumeric 5 9.999

E11 * 275Lower Bound Prior Year Whole Farm Unit


E11 * 276 Upper Bound Rate Differential Factor Numeric 10 9.999999999

E11 * 277Upper Bound Prior Year Rate Differential


E11 * 278 Upper Bound Unit Residual Factor Numeric 5 9.999

E11 * 279Upper Bound Enterprise Unit Residual


E11 * 280Upper Bound Whole Farm Unit Residual


"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 * 281Upper Bound Prior Year Unit Residual


E11 * 282Upper Bound Prior Year Enterprise Unit


E11 * 283Upper Bound Prior Year Whole Farm Unit


E11 * 284 Base Optional Unit Discount Factor Numeric 5 9.999

E11 * 285 Base Basic Unit Discount Factor Numeric 5 9.999

E11 * 286 Base Enterprise Unit Discount Factor Numeric 5 9.999

E11 * 287Lower Bound Optional Unit Discount


E11 * 288 Lower Bound Basic Unit Discount Factor Numeric 5 9.999

E11 * 289Lower Bound Enterprise Unit Discount


E11 * 290Upper Bound Optional Unit Discount


E11 * 291 Upper Bound Basic Unit Discount Factor Numeric 5 9.999

E11 * 292Upper Bound Enterprise Unit Discount


E11 * 293 Maximum Unit Residual Factor Numeric 7 999.999

E11 * 294Maximum Enterprise Unit Residual Factor

Numeric 5 9.999

E11 * 295Maximum Whole Farm Unit Residual


"*" = Output Only

3/4/2013 of 15 Draft


File Group: 2014



Record

Number Ou

tpu

t

Field


Max

Length Format

BUS

Key Req? Rules

E11 Release Date:

File Type:

Reinsurance Year:


E11 * 296 Maximum Prior Year Residual Factor Numeric 5 9.999

E11 * 297Maximum Prior Year Enterprise Unit


E11 * 298Maximum Prior Year Whole Farm Unit


E11 * 299 Average Landings Pounds Numeric 10 9999999999

E11 * 300 Apportionment Factor Numeric 9 9999.9999

E11 * 301Adjusted Expected County Landings

PoundsNumeric 10 999999999

E11 * 302 Average Index Value Numeric 13 99999999.9999

E11 * 303 Expected Index Value Numeric 13 99999999.9999

E11 * 304Expected County Landing Adjustment


E11 * 305 Total Planted Acreage Numeric 13 9999999999.99

E11 * 306 Process Result Code Character 1

E11 * 307 Batch Number Numeric 4 9999

"*" = Output Only

3/4/2013 of 15 Draft

file type: reinsurance year: version: release date: bus

Documents