Date
To
All Insurance Providers
From
Chris Aulbur, Chief, Actuarial Branch /s/ Chris Aulbur
Subject
Actuarial Release 15-047 - Actuarial Information Available
As of November 27, 2015 the following information is now available on the FTP site:
- 2015 Actuarial Data Master for the 4/30, 8/31 Filing Date, YTD, and Daily Files.
- 2016 Actuarial Data Master for the 6/30, 8/31, 9/30, 10/31, 11/30 Filing Date, YTD, and Daily Files.
- 2016 Special Provisions for the 11/30 Filing Date.
Users can find this information in the following directories:
- 2015 Actuarial Data Master are in the References/Actuarial_Data_Master/2015 directory.
- 2016 Actuarial Data Master are in the References/Actuarial_Data_Master/2016 directory.
- 2016 Special Provisions are in the Special_Provisions/2016 directory.
Additional notes and details regarding this data release:
2015 ADM Area Risk Rate updated final indices on intervals with an ending month of September for PRF/Apiculture and Annual Forage respectively, reference PM-15-056.
2016 Special Provisions and ADM are released for tobacco, 11/30 filing.
2016 Special Provisions and ADM Document Builder revised to re-add statement code 00218 for combo rice in AR, LA, and MS, 11/30 filing.
2016 ADM Insurance Offer unit of measure (UOM) fixed on selected corn counties in IA and MN silage to be ton, 11/30 filing.
2016 ADM Price is now released for all plan 90/31 (silage sorghum will be based on corn so issued late January), 50, 51, and 55 commodities; combo cotton for cottonseed, combo rice for option DC; zero volatilities for: corn silage and blue corn (plans 2/3/5/6/32/33), canola-rapeseed (plans 2/3/32/33), 11/30 filing.
2016 ADM Price updated for PNW dry peas spring type 089, 6/30 filing.
2016 ADM Price updated to null out CAT price on SCO plan 31 on numerous crops on prior filings (6/30 through the 10/31 filings).
2016 ELS cotton plan 31 added ADM Area Risk Rate & Option Rate records for "SE", 11/30 filing.
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-1137, or via email to ronald.tilly@rma.usda.gov.
Archived release bulletins are located online at Actuarial Bulletins.
File Name | Contains | Record Count |
|---|---|---|
2015_ADM_Daily_151127.zip | A01005_AreaRiskRate_Daily.txt | 832,029 |
2015_ADM_Filing_0430.zip | A00030_InsuranceOffer_Filing.txt | 14,053 |
A00045_Map_Filing.txt | 89,279 | |
A00200_Date_Filing.txt | 14,053 | |
A00810_Price_Filing.txt | 11,784 | |
A01005_AreaRiskRate_Filing.txt | 785,416 | |
A01010_BaseRate_Filing.txt | 1,791 | |
A01040_CoverageLevelDifferential_Filing.txt | 52,734 | |
A01050_SubCountyRate_Filing.txt | 603 | |
A01060_OptionRate_Filing.txt | 3,153 | |
A01100_YieldAndTyield_Filing.txt | 3,738 | |
A01200_DocumentBuilder_Filing.txt | 83,086 | |
2015_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt | 93,557 |
A00045_Map_Filing.txt | 1,317,572 | |
A00200_Date_Filing.txt | 93,557 | |
A00810_Price_Filing.txt | 86,063 | |
A01000_AgrRate_Filing.txt | 6,241,608 | |
A01005_AreaRiskRate_Filing.txt | 6,564,892 | |
A01010_BaseRate_Filing.txt | 19,154 | |
A01040_CoverageLevelDifferential_Filing.txt | 589,076 | |
A01050_SubCountyRate_Filing.txt | 6,249 | |
A01060_OptionRate_Filing.txt | 51,406 | |
A01070_Proration_Filing.txt | 384 | |
A01100_YieldAndTyield_Filing.txt | 2,378,097 | |
A01200_DocumentBuilder_Filing.txt | 470,423 | |
2015_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,049 |
A00030_InsuranceOffer_YTD.txt | 1,191,404 | |
A00045_Map_YTD.txt | 1,684,344 | |
A00050_Quality_YTD.txt | 518 | |
A00070_SubsidyPercent_YTD.txt | 464 | |
A00200_Date_YTD.txt | 1,198,043 | |
A00400_AgrCommodity_YTD.txt | 405 | |
A00410_Class_YTD.txt | 27 | |
A00420_Commodity_YTD.txt | 126 | |
A00430_CommodityType_YTD.txt | 359 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 76 | |
A00460_InsurancePlan_YTD.txt | 24 | |
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,043 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 4 | |
A00540_Type_YTD.txt | 542 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 47 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 83 | |
A00810_Price_YTD.txt | 1,034,566 | |
A01000_AgrRate_YTD.txt | 6,241,608 | |
A01005_AreaRiskRate_YTD.txt | 61,701,500 | |
A01010_BaseRate_YTD.txt | 749,203 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,827,170 | |
A01040_CoverageLevelDifferential_YTD.txt | 10,312,176 | |
A01050_SubCountyRate_YTD.txt | 177,763 | |
A01060_OptionRate_YTD.txt | 4,040,002 | |
A01070_Proration_YTD.txt | 2,739,732 | |
A01090_UnitDiscount_YTD.txt | 2,669 | |
A01100_YieldAndTyield_YTD.txt | 10,293,875 | |
A01105_YieldExclusion_YTD.txt | 420,588 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,804 | |
A01200_DocumentBuilder_YTD.txt | 13,962,997 | |
A01210_Statement_YTD.txt | 2,916 | |
2016_ADM_Daily_151127.zip | A00030_InsuranceOffer_Daily.txt | 4,713 |
A00045_Map_Daily.txt | 3 | |
A00050_Quality_Daily.txt | 89 | |
A00200_Date_Daily.txt | 3,201 | |
A00420_Commodity_Daily.txt | 8 | |
A00430_CommodityType_Daily.txt | 19 | |
A00510_Practice_Daily.txt | 39 | |
A00540_Type_Daily.txt | 19 | |
A00810_Price_Daily.txt | 208,661 | |
A01005_AreaRiskRate_Daily.txt | 10,218 | |
A01010_BaseRate_Daily.txt | 1,677 | |
A01040_CoverageLevelDifferential_Daily.txt | 21,660 | |
A01050_SubCountyRate_Daily.txt | 3 | |
A01060_OptionRate_Daily.txt | 5,747 | |
A01090_UnitDiscount_Daily.txt | 4 | |
A01100_YieldAndTyield_Daily.txt | 25,155 | |
A01105_YieldExclusion_Daily.txt | 981 | |
A01200_DocumentBuilder_Daily.txt | 31,899 | |
A01210_Statement_Daily.txt | 495 | |
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 | 145,694 | |
A01005_AreaRiskRate_Filing.txt | 11,219,335 | |
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_0831.zip | A00030_InsuranceOffer_Filing.txt | 168,244 |
A00045_Map_Filing.txt | 1,590,039 | |
A00200_Date_Filing.txt | 168,244 | |
A00810_Price_Filing.txt | 341,100 | |
A01000_AgrRate_Filing.txt | 9,240,768 | |
A01005_AreaRiskRate_Filing.txt | 7,142,467 | |
A01010_BaseRate_Filing.txt | 19,247 | |
A01040_CoverageLevelDifferential_Filing.txt | 971,310 | |
A01050_SubCountyRate_Filing.txt | 3,432 | |
A01060_OptionRate_Filing.txt | 85,388 | |
A01070_Proration_Filing.txt | 384 | |
A01100_YieldAndTyield_Filing.txt | 2,252,082 | |
A01105_YieldExclusion_Filing.txt | 11,238 | |
A01200_DocumentBuilder_Filing.txt | 918,792 | |
2016_ADM_Filing_0930.zip | A00030_InsuranceOffer_Filing.txt | 1,383 |
A00045_Map_Filing.txt | 45 | |
A00200_Date_Filing.txt | 1,383 | |
A00810_Price_Filing.txt | 1,587 | |
A01005_AreaRiskRate_Filing.txt | 1,152 | |
A01010_BaseRate_Filing.txt | 1,239 | |
A01040_CoverageLevelDifferential_Filing.txt | 11,424 | |
A01050_SubCountyRate_Filing.txt | 45 | |
A01060_OptionRate_Filing.txt | 4,692 | |
A01100_YieldAndTyield_Filing.txt | 17,685 | |
A01105_YieldExclusion_Filing.txt | 54 | |
A01200_DocumentBuilder_Filing.txt | 17,094 | |
2016_ADM_Filing_1031.zip | A00030_InsuranceOffer_Filing.txt | 6,981 |
A00045_Map_Filing.txt | 7,359 | |
A00200_Date_Filing.txt | 6,981 | |
A00810_Price_Filing.txt | 7,119 | |
A01005_AreaRiskRate_Filing.txt | 19,092 | |
A01010_BaseRate_Filing.txt | 4,491 | |
A01040_CoverageLevelDifferential_Filing.txt | 67,071 | |
A01050_SubCountyRate_Filing.txt | 1,662 | |
A01060_OptionRate_Filing.txt | 12,597 | |
A01100_YieldAndTyield_Filing.txt | 64,986 | |
A01105_YieldExclusion_Filing.txt | 777 | |
A01200_DocumentBuilder_Filing.txt | 58,486 | |
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 | 177,368 | |
A01005_AreaRiskRate_Filing.txt | 67,144,232 | |
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,870,514 | |
2016_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,072 |
A00030_InsuranceOffer_YTD.txt | 1,245,692 | |
A00045_Map_YTD.txt | 1,953,376 | |
A00050_Quality_YTD.txt | 538 | |
A00070_SubsidyPercent_YTD.txt | 480 | |
A00200_Date_YTD.txt | 1,252,349 | |
A00400_AgrCommodity_YTD.txt | 400 | |
A00410_Class_YTD.txt | 24 | |
A00420_Commodity_YTD.txt | 119 | |
A00430_CommodityType_YTD.txt | 340 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 75 | |
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,020 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 6 | |
A00540_Type_YTD.txt | 504 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 43 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 92 | |
A00615_Draw_YTD.txt | 28,500 | |
A00810_Price_YTD.txt | 685,543 | |
A01000_AgrRate_YTD.txt | 9,240,768 | |
A01005_AreaRiskRate_YTD.txt | 85,979,182 | |
A01010_BaseRate_YTD.txt | 527,315 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,827,170 | |
A01040_CoverageLevelDifferential_YTD.txt | 10,706,320 | |
A01050_SubCountyRate_YTD.txt | 176,158 | |
A01060_OptionRate_YTD.txt | 3,884,973 | |
A01070_Proration_YTD.txt | 384 | |
A01090_UnitDiscount_YTD.txt | 2,800 | |
A01100_YieldAndTyield_YTD.txt | 10,558,009 | |
A01105_YieldExclusion_YTD.txt | 599,718 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,480 | |
A01115_HistoricalYieldTrend_YTD.txt | 23,084 | |
A01200_DocumentBuilder_YTD.txt | 11,560,734 | |
A01210_Statement_YTD.txt | 21,939 | |
2016_SPOI_1130.zip | 2016 Special Provisions 11/30 Filing Date | 15,894 |