Date
To
All Insurance Providers
From
Zachary White, Chief, Actuarial Branch /s/ Zachary White
Subject
Actuarial Release 16-031 - Actuarial Information Available
As of August 25, 2016 the following information is now available on the FTP site:
- 2016 Actuarial Data Master for the 4/30, 8/31 Filing Date, YTD, and Daily Files.
- 2017 Actuarial Data Master for the 8/31, 10/31 Filing Date, YTD, and Daily Files.
- 2017 Special Provisions for the 8/31, 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 Area Risk Rate updated final indices on intervals with an ending month of June for PRF/Apiculture and Annual Forage respectively, reference PM-16-044.
2017 Special Provisions and ADM are now issued for PRF/API (8/31 filing) and Olives (10/31 filing).
2017 ADM prices issued for insurance plans 13, 14, 31, 43, 47, 50, and 90 commodities, 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-1337, or via email to ronald.tilly@rma.usda.gov. Archived release bulletins are located online at Actuarial Bulletins.
| File Name | Contains | Record Count |
|---|---|---|
2016_ADM_Daily_160825.zip | A01005_AreaRiskRate_Daily.txt | 737,885 |
2016_ADM_Filing_0430.zip | A00030_InsuranceOffer_Filing.txt | 14,944 |
A00045_Map_Filing.txt | 102,327 | |
A00200_Date_Filing.txt | 14,944 | |
A00810_Price_Filing.txt | 12,675 | |
A01005_AreaRiskRate_Filing.txt | 450,492 | |
A01010_BaseRate_Filing.txt | 1,800 | |
A01040_CoverageLevelDifferential_Filing.txt | 56,706 | |
A01050_SubCountyRate_Filing.txt | 603 | |
A01060_OptionRate_Filing.txt | 3,252 | |
A01100_YieldAndTyield_Filing.txt | 4,275 | |
A01200_DocumentBuilder_Filing.txt | 100,572 | |
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,263,808 | |
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_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_160825.zip | A00030_InsuranceOffer_Daily.txt | 121,555 |
A00045_Map_Daily.txt | 1,586,083 | |
A00070_SubsidyPercent_Daily.txt | 24 | |
A00200_Date_Daily.txt | 121,502 | |
A00420_Commodity_Daily.txt | 3 | |
A00430_CommodityType_Daily.txt | 1 | |
A00450_CroppingPractice_Daily.txt | 1 | |
A00460_InsurancePlan_Daily.txt | 1 | |
A00470_IntendedUse_Daily.txt | 4 | |
A00480_Interval_Daily.txt | 8 | |
A00510_Practice_Daily.txt | 61 | |
A00540_Type_Daily.txt | 6 | |
A00810_Price_Daily.txt | 325,462 | |
A01010_BaseRate_Daily.txt | 231 | |
A01040_CoverageLevelDifferential_Daily.txt | 607,972 | |
A01060_OptionRate_Daily.txt | 360 | |
A01090_UnitDiscount_Daily.txt | 1 | |
A01100_YieldAndTyield_Daily.txt | 3,696 | |
A01105_YieldExclusion_Daily.txt | 303 | |
A01130_AreaCoverageLevel_Daily.txt | 7,019,755 | |
A01135_AreaRate_Daily.txt | 3,842,020 | |
A01200_DocumentBuilder_Daily.txt | 364,597 | |
A01210_Statement_Daily.txt | 10 | |
2017_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt | 156,394 |
A00045_Map_Filing.txt | 1,590,961 | |
A00200_Date_Filing.txt | 156,394 | |
A00810_Price_Filing.txt | 325,462 | |
A01010_BaseRate_Filing.txt | 19,322 | |
A01040_CoverageLevelDifferential_Filing.txt | 881,466 | |
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 | 7,127,437 | |
A01200_DocumentBuilder_Filing.txt | 519,213 | |
2017_ADM_Filing_1031.zip | A00030_InsuranceOffer_Filing.txt | 6,963 |
A00045_Map_Filing.txt | 7,299 | |
A00200_Date_Filing.txt | 6,963 | |
A01010_BaseRate_Filing.txt | 4,482 | |
A01040_CoverageLevelDifferential_Filing.txt | 66,864 | |
A01050_SubCountyRate_Filing.txt | 1,656 | |
A01060_OptionRate_Filing.txt | 12,879 | |
A01100_YieldAndTyield_Filing.txt | 69,552 | |
A01105_YieldExclusion_Filing.txt | 1,428 | |
A01130_AreaCoverageLevel_Filing.txt | 19,020 | |
A01200_DocumentBuilder_Filing.txt | 37,446 | |
2017_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,112 |
A00030_InsuranceOffer_YTD.txt | 350,725 | |
A00045_Map_YTD.txt | 1,738,819 | |
A00050_Quality_YTD.txt | 253 | |
A00070_SubsidyPercent_YTD.txt | 335 | |
A00200_Date_YTD.txt | 356,578 | |
A00410_Class_YTD.txt | 14 | |
A00420_Commodity_YTD.txt | 78 | |
A00430_CommodityType_YTD.txt | 245 | |
A00440_County_YTD.txt | 3,166 | |
A00450_CroppingPractice_YTD.txt | 51 | |
A00460_InsurancePlan_YTD.txt | 20 | |
A00470_IntendedUse_YTD.txt | 10 | |
A00480_Interval_YTD.txt | 47 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 592 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 5 | |
A00540_Type_YTD.txt | 346 | |
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 | 444,274 | |
A01010_BaseRate_YTD.txt | 109,424 | |
A01020_Beta_YTD.txt | 37,500 | |
A01030_ComboRevenueFactor_YTD.txt | 889,110 | |
A01040_CoverageLevelDifferential_YTD.txt | 2,481,002 | |
A01050_SubCountyRate_YTD.txt | 29,523 | |
A01060_OptionRate_YTD.txt | 693,016 | |
A01070_Proration_YTD.txt | 384 | |
A01090_UnitDiscount_YTD.txt | 818 | |
A01100_YieldAndTyield_YTD.txt | 3,958,668 | |
A01105_YieldExclusion_YTD.txt | 140,619 | |
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 | 8,253,523 | |
A01135_AreaRate_YTD.txt | 6,251,164 | |
A01200_DocumentBuilder_YTD.txt | 1,777,818 | |
A01210_Statement_YTD.txt | 725 | |
2017_SPOI_0831.zip | 2017 Special Provisions 08/31 Filing Date | 6,154 |
2017_SPOI_1031.zip | 2017 Special Provisions 10/31 Filing Date | 355 |