USDA Image
TO:
All Insurance Providers
Zachary White
/s/ Scott Paschen
FROM:
Chief, Actuarial Branch
SUBJECT:
Actuarial Release 16-029 - Actuarial Information Available
As of August 01, 2016 the following information is now available on the FTP site:
•
2016 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
•
2017 Actuarial Data Master for the 6/30, 8/31, 9/30, 10/31 Filing Date, YTD, and Daily Files.
•
2017 Special Provisions for the 8/31, 9/30, 10/31 Filing Date.
Users can find this information in the following directories:
•
2016 Actuarial Data Master are in the References/Actuarial_Data_Master/2016 directory.
•
2017 Actuarial Data Master are in the References/Actuarial_Data_Master/2017 directory.
•
2017 Special Provisions are in the Special_Provisions/2017 directory.
Additional notes and details regarding this data release:
2016 ADM Price updated for the harvest price announcement, PM-16-041, 6/30 and 11/30 filings.
2017 SCO canola and SCO dry peas ADM now includes rates and yields populated for canola and dry peas removed extra rate rows for a given price volatility, 6/30 filing.
2017 Special Provisions and ADM are now issued for the 8/31, 9/30, and 10/31 filings except for PRF/API, olives, and Whole Farm Revenue Protection (WFRP).
Please notify your data processing representative that this information is available for downloading. For questions regarding the actuarial information, please contact Ron Tilly by phone at (816) 926-1337, or via email to
ronald.tilly@rma.usda.gov.
Archived release bulletins are located online at
https://www.rma.usda.gov/bulletins/actuarial/.
 
File Name
Contains
Record Count
     
2016_ADM_Daily_160801.zip
A00810_Price_Daily.txt
27,090
     
     
2016_ADM_Filing_0630.zip
A00030_InsuranceOffer_Filing.txt
166,919
 
A00045_Map_Filing.txt
38,297
 
A00200_Date_Filing.txt
172,925
 
A00810_Price_Filing.txt
168,737
 
A01005_AreaRiskRate_Filing.txt
11,310,055
 
A01010_BaseRate_Filing.txt
81,159
 
A01040_CoverageLevelDifferential_Filing.txt
1,469,809
 
A01050_SubCountyRate_Filing.txt
23,625
 
A01060_OptionRate_Filing.txt
570,178
 
A01100_YieldAndTyield_Filing.txt
1,372,480
 
A01105_YieldExclusion_Filing.txt
120,786
 
A01110_HistoricalRevenueCapping_Filing.txt
17,742
 
A01200_DocumentBuilder_Filing.txt
1,587,211
     
     
2016_ADM_Filing_1130.zip
A00030_InsuranceOffer_Filing.txt
886,327
 
A00045_Map_Filing.txt
214,856
 
A00200_Date_Filing.txt
886,978
 
A00810_Price_Filing.txt
962,662
 
A01005_AreaRiskRate_Filing.txt
68,327,558
 
A01010_BaseRate_Filing.txt
418,887
 
A01040_CoverageLevelDifferential_Filing.txt
8,123,808
 
A01050_SubCountyRate_Filing.txt
146,647
 
A01060_OptionRate_Filing.txt
3,205,652
 
A01100_YieldAndTyield_Filing.txt
6,836,241
 
A01105_YieldExclusion_Filing.txt
466,461
 
A01110_HistoricalRevenueCapping_Filing.txt
138,738
 
A01200_DocumentBuilder_Filing.txt
8,887,029
     
     
2016_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
1,072
 
A00030_InsuranceOffer_YTD.txt
1,474,169
 
A00045_Map_YTD.txt
1,954,672
 
A00050_Quality_YTD.txt
538
 
A00070_SubsidyPercent_YTD.txt
480
 
A00200_Date_YTD.txt
1,480,826
 
A00400_AgrCommodity_YTD.txt
400
 
A00410_Class_YTD.txt
24
 
A00420_Commodity_YTD.txt
131
 
A00430_CommodityType_YTD.txt
360
 
A00440_County_YTD.txt
3,190
 
A00450_CroppingPractice_YTD.txt
77
 
A00460_InsurancePlan_YTD.txt
25
 
A00470_IntendedUse_YTD.txt
12
 
A00480_Interval_YTD.txt
47
 
A00490_IrrigationPractice_YTD.txt
3
 
A00500_OrganicPractice_YTD.txt
3
 
A00510_Practice_YTD.txt
1,072
 
A00520_State_YTD.txt
50
 
A00530_SubClass_YTD.txt
6
 
A00540_Type_YTD.txt
547
 
A00550_DocumentStructure_YTD.txt
20
 
A00560_EndorsementLength_YTD.txt
1
 
A00570_InsuranceOption_YTD.txt
46
 
A00580_RateMethod_YTD.txt
4
 
A00590_SpoiGroup_YTD.txt
92
 
A00615_Draw_YTD.txt
74,100
 
A00810_Price_YTD.txt
1,511,463
 
A01000_AgrRate_YTD.txt
9,263,808
 
A01005_AreaRiskRate_YTD.txt
87,253,282
 
A01010_BaseRate_YTD.txt
755,783
 
A01020_Beta_YTD.txt
121,500
 
A01030_ComboRevenueFactor_YTD.txt
2,827,170
 
A01040_CoverageLevelDifferential_YTD.txt
12,312,223
 
A01050_SubCountyRate_YTD.txt
177,454
 
A01060_OptionRate_YTD.txt
4,543,545
 
A01070_Proration_YTD.txt
2,739,624
 
A01090_UnitDiscount_YTD.txt
2,801
 
A01100_YieldAndTyield_YTD.txt
10,558,009
 
A01105_YieldExclusion_YTD.txt
599,718
 
A01110_HistoricalRevenueCapping_YTD.txt
156,480
 
A01115_HistoricalYieldTrend_YTD.txt
23,482
 
A01200_DocumentBuilder_YTD.txt
17,395,677
 
A01210_Statement_YTD.txt
22,016
     
     
2017_ADM_Daily_160801.zip
A00030_InsuranceOffer_Daily.txt
43,238
 
A00045_Map_Daily.txt
12,222
 
A00050_Quality_Daily.txt
21
 
A00070_SubsidyPercent_Daily.txt
38
 
A00200_Date_Daily.txt
43,238
 
A00410_Class_Daily.txt
3
 
A00420_Commodity_Daily.txt
39
 
A00430_CommodityType_Daily.txt
178
 
A00450_CroppingPractice_Daily.txt
18
 
A00460_InsurancePlan_Daily.txt
2
 
A00470_IntendedUse_Daily.txt
1
 
A00510_Practice_Daily.txt
228
 
A00530_SubClass_Daily.txt
2
 
A00540_Type_Daily.txt
235
 
A00550_DocumentStructure_Daily.txt
1
 
A00570_InsuranceOption_Daily.txt
4
 
A00810_Price_Daily.txt
2,844
 
A01010_BaseRate_Daily.txt
24,812
 
A01040_CoverageLevelDifferential_Daily.txt
351,782
 
A01050_SubCountyRate_Daily.txt
5,133
 
A01060_OptionRate_Daily.txt
103,267
 
A01070_Proration_Daily.txt
384
 
A01090_UnitDiscount_Daily.txt
1
 
A01100_YieldAndTyield_Daily.txt
2,465,052
 
A01105_YieldExclusion_Daily.txt
13,248
 
A01115_HistoricalYieldTrend_Daily.txt
20,277
 
A01120_AreaDataSource_Daily.txt
21
 
A01125_ProductionArea_Daily.txt
6,895
 
A01130_AreaCoverageLevel_Daily.txt
152,070
 
A01135_AreaRate_Daily.txt
48,846
 
A01200_DocumentBuilder_Daily.txt
204,365
 
A01210_Statement_Daily.txt
313
     
     
2017_ADM_Filing_0630.zip
A00030_InsuranceOffer_Filing.txt
170,930
 
A00045_Map_Filing.txt
38,187
 
A00200_Date_Filing.txt
176,783
 
A00810_Price_Filing.txt
104,745
 
A01010_BaseRate_Filing.txt
82,470
 
A01040_CoverageLevelDifferential_Filing.txt
1,463,639
 
A01050_SubCountyRate_Filing.txt
23,787
 
A01060_OptionRate_Filing.txt
585,850
 
A01100_YieldAndTyield_Filing.txt
1,483,536
 
A01105_YieldExclusion_Filing.txt
127,068
 
A01110_HistoricalRevenueCapping_Filing.txt
17,706
 
A01130_AreaCoverageLevel_Filing.txt
655,422
 
A01200_DocumentBuilder_Filing.txt
1,107,631
     
     
2017_ADM_Filing_0831.zip
A00030_InsuranceOffer_Filing.txt
35,123
 
A00045_Map_Filing.txt
4,878
 
A00200_Date_Filing.txt
35,123
 
A01010_BaseRate_Filing.txt
19,322
 
A01040_CoverageLevelDifferential_Filing.txt
275,111
 
A01050_SubCountyRate_Filing.txt
3,432
 
A01060_OptionRate_Filing.txt
85,864
 
A01070_Proration_Filing.txt
384
 
A01100_YieldAndTyield_Filing.txt
2,380,332
 
A01105_YieldExclusion_Filing.txt
11,685
 
A01130_AreaCoverageLevel_Filing.txt
107,682
 
A01200_DocumentBuilder_Filing.txt
156,827
     
     
2017_ADM_Filing_0930.zip
A00030_InsuranceOffer_Filing.txt
1,383
 
A00045_Map_Filing.txt
45
 
A00200_Date_Filing.txt
1,383
 
A01010_BaseRate_Filing.txt
1,239
 
A01040_CoverageLevelDifferential_Filing.txt
11,424
 
A01050_SubCountyRate_Filing.txt
45
 
A01060_OptionRate_Filing.txt
4,884
 
A01100_YieldAndTyield_Filing.txt
18,864
 
A01105_YieldExclusion_Filing.txt
438
 
A01130_AreaCoverageLevel_Filing.txt
1,152
 
A01200_DocumentBuilder_Filing.txt
12,303
     
     
2017_ADM_Filing_1031.zip
A00030_InsuranceOffer_Filing.txt
6,732
 
A00045_Map_Filing.txt
7,299
 
A00200_Date_Filing.txt
6,732
 
A01010_BaseRate_Filing.txt
4,251
 
A01040_CoverageLevelDifferential_Filing.txt
65,247
 
A01050_SubCountyRate_Filing.txt
1,656
 
A01060_OptionRate_Filing.txt
12,519
 
A01100_YieldAndTyield_Filing.txt
65,856
 
A01105_YieldExclusion_Filing.txt
1,125
 
A01130_AreaCoverageLevel_Filing.txt
19,020
 
A01200_DocumentBuilder_Filing.txt
35,235
     
     
2017_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
1,112
 
A00030_InsuranceOffer_YTD.txt
229,223
 
A00045_Map_YTD.txt
152,736
 
A00050_Quality_YTD.txt
253
 
A00070_SubsidyPercent_YTD.txt
311
 
A00200_Date_YTD.txt
235,076
 
A00410_Class_YTD.txt
14
 
A00420_Commodity_YTD.txt
75
 
A00430_CommodityType_YTD.txt
244
 
A00440_County_YTD.txt
3,166
 
A00450_CroppingPractice_YTD.txt
50
 
A00460_InsurancePlan_YTD.txt
19
 
A00470_IntendedUse_YTD.txt
6
 
A00480_Interval_YTD.txt
39
 
A00490_IrrigationPractice_YTD.txt
3
 
A00500_OrganicPractice_YTD.txt
3
 
A00510_Practice_YTD.txt
531
 
A00520_State_YTD.txt
50
 
A00530_SubClass_YTD.txt
5
 
A00540_Type_YTD.txt
340
 
A00550_DocumentStructure_YTD.txt
20
 
A00560_EndorsementLength_YTD.txt
1
 
A00570_InsuranceOption_YTD.txt
29
 
A00580_RateMethod_YTD.txt
4
 
A00590_SpoiGroup_YTD.txt
21
 
A00810_Price_YTD.txt
117,531
 
A01010_BaseRate_YTD.txt
109,193
 
A01020_Beta_YTD.txt
37,500
 
A01030_ComboRevenueFactor_YTD.txt
889,110
 
A01040_CoverageLevelDifferential_YTD.txt
1,873,030
 
A01050_SubCountyRate_YTD.txt
29,523
 
A01060_OptionRate_YTD.txt
692,656
 
A01070_Proration_YTD.txt
384
 
A01090_UnitDiscount_YTD.txt
817
 
A01100_YieldAndTyield_YTD.txt
3,954,972
 
A01105_YieldExclusion_YTD.txt
140,316
 
A01110_HistoricalRevenueCapping_YTD.txt
17,706
 
A01115_HistoricalYieldTrend_YTD.txt
167,835
 
A01120_AreaDataSource_YTD.txt
51
 
A01125_ProductionArea_YTD.txt
58,548
 
A01130_AreaCoverageLevel_YTD.txt
1,233,768
 
A01135_AreaRate_YTD.txt
2,409,144
 
A01200_DocumentBuilder_YTD.txt
1,413,221
 
A01210_Statement_YTD.txt
715
     
     
2017_SPOI_0831.zip
2017 Special Provisions 08/31 Filing Date
1,026
     
     
2017_SPOI_0930.zip
2017 Special Provisions 09/30 Filing Date
84
     
     
2017_SPOI_1031.zip
2017 Special Provisions 10/31 Filing Date
342
     
 
RMA Image