Date
To
All Insurance Providers
From
Chris Aulbur, Chief, Actuarial Branch /s/ Chris Aulbur
Subject
Actuarial Release 15-049 - Actuarial Information Available
As of December 16, 2015 the following information is now available on the FTP site:
- 2015 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
- 2016 Actuarial Data Master for the 8/31, 12/31, 1/31 Filing Date, YTD, and Daily Files.
- 2016 Special Provisions for the 1/31 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 Price updated for dry pea and dry bean revenue endorsement harvest prices, reference PM-15-062, 6/30 and 11/30 filings.
2016 Special Provisions, ADM, and related files are now released for the 1/31 filing. The ADM Price will be issued later for Florida citrus and Florida fruit trees.
2016 ADM Price now issued for the December 31 contract change commodities of fresh market tomatoes and safflower.
2016 WFRP additional commodities added to California's Sacramento Valley region 6 expansion counties (011, 021, 067, 095, 101, and 103) to match Butte, Yolo, and Yuba counties (14,686 inserted rows into ADM AGR-Rate), 8/31 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_151216.zip | A00810_Price_Daily.txt | 9,342 |
| 2015_ADM_Filing_0630.zip | A00030_InsuranceOffer_Filing.txt | 103,257 |
| A00045_Map_Filing.txt | 38,037 | |
| A00200_Date_Filing.txt | 109,245 | |
| A00810_Price_Filing.txt | 104,901 | |
| A01005_AreaRiskRate_Filing.txt | 3,592,206 | |
| A01010_BaseRate_Filing.txt | 77,706 | |
| A01040_CoverageLevelDifferential_Filing.txt | 892,896 | |
| A01050_SubCountyRate_Filing.txt | 23,655 | |
| A01060_OptionRate_Filing.txt | 337,586 | |
| A01100_YieldAndTyield_Filing.txt | 1,232,154 | |
| A01110_HistoricalRevenueCapping_Filing.txt | 17,190 | |
| A01200_DocumentBuilder_Filing.txt | 1,093,065 | |
| 2015_ADM_Filing_1130.zip | A00030_InsuranceOffer_Filing.txt | 745,769 |
| A00045_Map_Filing.txt | 232,040 | |
| A00200_Date_Filing.txt | 746,420 | |
| A00810_Price_Filing.txt | 808,088 | |
| A01005_AreaRiskRate_Filing.txt | 50,758,986 | |
| A01010_BaseRate_Filing.txt | 415,784 | |
| A01040_CoverageLevelDifferential_Filing.txt | 7,110,613 | |
| A01050_SubCountyRate_Filing.txt | 144,166 | |
| A01060_OptionRate_Filing.txt | 2,972,066 | |
| A01100_YieldAndTyield_Filing.txt | 6,593,468 | |
| A01105_YieldExclusion_Filing.txt | 420,588 | |
| A01110_HistoricalRevenueCapping_Filing.txt | 139,614 | |
| A01200_DocumentBuilder_Filing.txt | 6,892,284 | |
| 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_151216.zip | A00030_InsuranceOffer_Daily.txt | 228,468 |
| A00045_Map_Daily.txt | 1,296 | |
| A00200_Date_Daily.txt | 228,468 | |
| A00420_Commodity_Daily.txt | 11 | |
| A00430_CommodityType_Daily.txt | 20 | |
| A00450_CroppingPractice_Daily.txt | 2 | |
| A00510_Practice_Daily.txt | 51 | |
| A00540_Type_Daily.txt | 42 | |
| A00570_InsuranceOption_Daily.txt | 3 | |
| A00810_Price_Daily.txt | 9,291 | |
| A01000_AgrRate_Daily.txt | 14,688 | |
| A01010_BaseRate_Daily.txt | 228,468 | |
| A01040_CoverageLevelDifferential_Daily.txt | 1,605,849 | |
| A01050_SubCountyRate_Daily.txt | 1,296 | |
| A01060_OptionRate_Daily.txt | 658,572 | |
| A01070_Proration_Daily.txt | 2,739,240 | |
| A01090_UnitDiscount_Daily.txt | 1 | |
| A01200_DocumentBuilder_Daily.txt | 5,818,401 | |
| A01210_Statement_Daily.txt | 72 | |
| 2016_ADM_Filing_0131.zip | A00030_InsuranceOffer_Filing.txt | 228,468 |
| A00045_Map_Filing.txt | 1,296 | |
| A00200_Date_Filing.txt | 228,468 | |
| A00810_Price_Filing.txt | 8,397 | |
| A01010_BaseRate_Filing.txt | 228,468 | |
| A01040_CoverageLevelDifferential_Filing.txt | 1,605,849 | |
| A01050_SubCountyRate_Filing.txt | 1,296 | |
| A01060_OptionRate_Filing.txt | 658,572 | |
| A01070_Proration_Filing.txt | 2,739,240 | |
| A01200_DocumentBuilder_Filing.txt | 5,818,401 | |
| 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,255,456 | |
| 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_1231.zip | A00030_InsuranceOffer_Filing.txt | 894 |
| A00045_Map_Filing.txt | 453 | |
| A00200_Date_Filing.txt | 894 | |
| A00810_Price_Filing.txt | 894 | |
| A01005_AreaRiskRate_Filing.txt | 2,412 | |
| A01010_BaseRate_Filing.txt | 492 | |
| A01040_CoverageLevelDifferential_Filing.txt | 6,192 | |
| A01050_SubCountyRate_Filing.txt | 144 | |
| A01060_OptionRate_Filing.txt | 3,214 | |
| A01100_YieldAndTyield_Filing.txt | 10,260 | |
| A01105_YieldExclusion_Filing.txt | 402 | |
| A01200_DocumentBuilder_Filing.txt | 8,065 | |
| 2016_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,072 |
| A00030_InsuranceOffer_YTD.txt | 1,474,160 | |
| A00045_Map_YTD.txt | 1,954,672 | |
| A00050_Quality_YTD.txt | 538 | |
| A00070_SubsidyPercent_YTD.txt | 480 | |
| A00200_Date_YTD.txt | 1,480,817 | |
| A00400_AgrCommodity_YTD.txt | 400 | |
| A00410_Class_YTD.txt | 24 | |
| A00420_Commodity_YTD.txt | 130 | |
| 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,071 | |
| A00520_State_YTD.txt | 50 | |
| A00530_SubClass_YTD.txt | 6 | |
| A00540_Type_YTD.txt | 546 | |
| 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 | 28,500 | |
| A00810_Price_YTD.txt | 694,834 | |
| A01000_AgrRate_YTD.txt | 9,255,456 | |
| A01005_AreaRiskRate_YTD.txt | 85,979,182 | |
| 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,169 | |
| 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,084 | |
| A01200_DocumentBuilder_YTD.txt | 17,379,135 | |
| A01210_Statement_YTD.txt | 22,011 | |
| 2016_SPOI_0131.zip | 2016 Special Provisions 01/31 Filing Date | 3,040 |