ACTUARIAL RELEASE: Actuarial Release–17-038
United States Department of Agriculture
Farm and Foreign Agricultural Services
Risk Management Agency
1400 Independence Avenue, SW
Stop 0801
Washington, DC 20250-0801
Date
November 30, 2017
To:
All Insurance Providers
From:
Zachary White Chief, Actuarial Branch /s/ Zachary White 11/30/2017
Subject:
Actuarial Release 17-038 - Actuarial Information Available
-
As of November 30, 2017 the following information is now available on the FTP site:
- 2018 Actuarial Data Master for the 6/30, 11/30, 12/31 Filing Date, YTD, and Daily Files.
- 2018 Special Provisions for the 11/30, 12/31 Filing Date.
- 2018 Actuarial Data Master are in the References/Actuarial_Data_Master/2018 directory.
- 2018 Special Provisions are in the Special_Provisions/2018 directory.
2018 Special Provisions, ADM, and related files are now released for the 11/30 & 12/31 filings including applicable prices for both filings and 6/30 dry peas. 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 NameContainsRecord Count2018_ADM_Daily_171130.zipA00030_InsuranceOffer_Daily.txt888,014A00045_Map_Daily.txt214,046A00050_Quality_Daily.txt273A00070_SubsidyPercent_Daily.txt124A00200_Date_Daily.txt888,665A00410_Class_Daily.txt10A00420_Commodity_Daily.txt35A00430_CommodityType_Daily.txt91A00450_CroppingPractice_Daily.txt22A00460_InsurancePlan_Daily.txt4A00470_IntendedUse_Daily.txt1A00510_Practice_Daily.txt414A00530_SubClass_Daily.txt1A00540_Type_Daily.txt152A00570_InsuranceOption_Daily.txt15A00590_SpoiGroup_Daily.txt76A00810_Price_Daily.txt676,816A01010_BaseRate_Daily.txt420,041A01020_Beta_Daily.txt84,000A01030_ComboRevenueFactor_Daily.txt1,748,250A01040_CoverageLevelDifferential_Daily.txt8,418,984A01050_SubCountyRate_Daily.txt160,939A01060_OptionRate_Daily.txt3,247,014A01090_UnitDiscount_Daily.txt2,031A01100_YieldAndTyield_Daily.txt7,592,438A01105_YieldExclusion_Daily.txt478,572A01110_HistoricalRevenueCapping_Daily.txt138,498A01115_HistoricalYieldTrend_Daily.txt532,064A01120_AreaDataSource_Daily.txt69A01125_ProductionArea_Daily.txt118,261A01130_AreaCoverageLevel_Daily.txt3,984,204A01135_AreaRate_Daily.txt7,380,218A01200_DocumentBuilder_Daily.txt5,883,838A01210_Statement_Daily.txt436A01220_GuaranteeAdjustment_Daily.txt814,0032018_ADM_Filing_0630.zipA00030_InsuranceOffer_Filing.txt182,975A00045_Map_Filing.txt40,221A00200_Date_Filing.txt189,158A00810_Price_Filing.txt171,752A01010_BaseRate_Filing.txt85,407A01040_CoverageLevelDifferential_Filing.txt1,558,642A01050_SubCountyRate_Filing.txt25,389A01060_OptionRate_Filing.txt615,971A01100_YieldAndTyield_Filing.txt1,628,226A01105_YieldExclusion_Filing.txt131,439A01110_HistoricalRevenueCapping_Filing.txt17,688A01130_AreaCoverageLevel_Filing.txt713,790A01200_DocumentBuilder_Filing.txt1,248,502A01220_GuaranteeAdjustment_Filing.txt181,9472018_ADM_Filing_1130.zipA00030_InsuranceOffer_Filing.txt887,120A00045_Map_Filing.txt213,653A00200_Date_Filing.txt887,771A00810_Price_Filing.txt675,511A01010_BaseRate_Filing.txt419,549A01040_CoverageLevelDifferential_Filing.txt8,412,792A01050_SubCountyRate_Filing.txt160,795A01060_OptionRate_Filing.txt3,243,686A01100_YieldAndTyield_Filing.txt7,581,422A01105_YieldExclusion_Filing.txt478,074A01110_HistoricalRevenueCapping_Filing.txt138,498A01130_AreaCoverageLevel_Filing.txt3,981,792A01200_DocumentBuilder_Filing.txt5,878,873A01220_GuaranteeAdjustment_Filing.txt813,1872018_ADM_Filing_1231.zipA00030_InsuranceOffer_Filing.txt894A00045_Map_Filing.txt393A00200_Date_Filing.txt894A00810_Price_Filing.txt894A01010_BaseRate_Filing.txt492A01040_CoverageLevelDifferential_Filing.txt6,192A01050_SubCountyRate_Filing.txt144A01060_OptionRate_Filing.txt3,328A01100_YieldAndTyield_Filing.txt11,016A01105_YieldExclusion_Filing.txt498A01130_AreaCoverageLevel_Filing.txt2,412A01200_DocumentBuilder_Filing.txt4,965A01220_GuaranteeAdjustment_Filing.txt8162018_ADM_YTD.zipA00010_AdmLayout_YTD.txt1,140A00030_InsuranceOffer_YTD.txt1,350,683A00045_Map_YTD.txt4,522,763A00050_Quality_YTD.txt530A00070_SubsidyPercent_YTD.txt482A00200_Date_YTD.txt1,357,517A00400_AgrCommodity_YTD.txt435A00410_Class_YTD.txt24A00420_Commodity_YTD.txt115A00430_CommodityType_YTD.txt339A00440_County_YTD.txt3,190A00450_CroppingPractice_YTD.txt80A00460_InsurancePlan_YTD.txt25A00470_IntendedUse_YTD.txt12A00480_Interval_YTD.txt41A00490_IrrigationPractice_YTD.txt3A00500_OrganicPractice_YTD.txt3A00510_Practice_YTD.txt1,056A00520_State_YTD.txt50A00530_SubClass_YTD.txt6A00540_Type_YTD.txt506A00550_DocumentStructure_YTD.txt20A00560_EndorsementLength_YTD.txt1A00570_InsuranceOption_YTD.txt45A00580_RateMethod_YTD.txt4A00590_SpoiGroup_YTD.txt103A00615_Draw_YTD.txt23,912,500A00810_Price_YTD.txt3,010,495A01000_AgrRate_YTD.txt10,747,415A01010_BaseRate_YTD.txt536,626A01020_Beta_YTD.txt121,500A01030_ComboRevenueFactor_YTD.txt2,857,140A01040_CoverageLevelDifferential_YTD.txt11,520,416A01050_SubCountyRate_YTD.txt190,309A01060_OptionRate_YTD.txt3,978,913A01070_Proration_YTD.txt384A01090_UnitDiscount_YTD.txt2,849A01100_YieldAndTyield_YTD.txt11,391,425A01105_YieldExclusion_YTD.txt624,090A01110_HistoricalRevenueCapping_YTD.txt156,186A01115_HistoricalYieldTrend_YTD.txt795,825A01120_AreaDataSource_YTD.txt126A01125_ProductionArea_YTD.txt177,586A01130_AreaCoverageLevel_YTD.txt15,254,383A01135_AreaRate_YTD.txt11,502,856A01200_DocumentBuilder_YTD.txt8,234,503A01210_Statement_YTD.txt1,201A01220_GuaranteeAdjustment_YTD.txt997,8252018_SPOI_1130.zip2018 Special Provisions 11/30 Filing Date15,9702018_SPOI_1231.zip2018 Special Provisions 12/31 Filing Date92