Actuarial Release Bulletin 17-031

TO:

All Insurance Providers

Zachary White

/s/ Zachary White

FROM:

Chief, Actuarial Branch

SUBJECT:

Actuarial Release 17-031 - Actuarial Information Available

As of September 20, 2017 the following information is now available on the FTP site:


•	2018 Actuarial Data Master for the 6/30 Filing Date, YTD, and Daily Files.

Users can find this information in the following directories:


•	2018 Actuarial Data Master are in the References/Actuarial_Data_Master/2018 directory.

Additional notes and details regarding this data release:

2018 ADM Price updated for Malting Barley Endorsement (ME insurance option code), reference PM-17-056, 6/30 filing.
2018 Margin Protection ADM information (Insurance Offer, Area Coverage Level, Area Data Source, Area Rate, Draw, Historical Yield Trend, Production Area, Price, "Statement, and Document Builder", no SPOI impact as just for “Margins and Yields” tab in AIB) now issued for the September 30 SCD, reference PM-17-056, 6/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-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

2018_ADM_Daily_170920.zip	A00030_InsuranceOffer_Daily.txt	9,424
	A00615_Draw_Daily.txt	23,912,500
	A00810_Price_Daily.txt	10,054
	A01115_HistoricalYieldTrend_Daily.txt	89,257
	A01120_AreaDataSource_Daily.txt	5
	A01125_ProductionArea_Daily.txt	621
	A01130_AreaCoverageLevel_Daily.txt	56,544
	A01135_AreaRate_Daily.txt	39,564
	A01200_DocumentBuilder_Daily.txt	14,236
	A01210_Statement_Daily.txt	2


2018_ADM_Filing_0630.zip	A00030_InsuranceOffer_Filing.txt	182,975
	A00045_Map_Filing.txt	40,221
	A00200_Date_Filing.txt	189,158
	A00810_Price_Filing.txt	170,159
	A01010_BaseRate_Filing.txt	85,407
	A01040_CoverageLevelDifferential_Filing.txt	1,558,642
	A01050_SubCountyRate_Filing.txt	25,389
	A01060_OptionRate_Filing.txt	615,971
	A01100_YieldAndTyield_Filing.txt	1,628,226
	A01105_YieldExclusion_Filing.txt	131,439
	A01110_HistoricalRevenueCapping_Filing.txt	17,688
	A01130_AreaCoverageLevel_Filing.txt	713,790
	A01200_DocumentBuilder_Filing.txt	1,248,466
	A01220_GuaranteeAdjustment_Filing.txt	181,947


2018_ADM_YTD.zip	A00010_AdmLayout_YTD.txt	1,140
	A00030_InsuranceOffer_YTD.txt	462,669
	A00045_Map_YTD.txt	4,308,711
	A00050_Quality_YTD.txt	258
	A00070_SubsidyPercent_YTD.txt	358
	A00200_Date_YTD.txt	468,852
	A00400_AgrCommodity_YTD.txt	435
	A00410_Class_YTD.txt	14
	A00420_Commodity_YTD.txt	80
	A00430_CommodityType_YTD.txt	248
	A00440_County_YTD.txt	3,190
	A00450_CroppingPractice_YTD.txt	58
	A00460_InsurancePlan_YTD.txt	21
	A00470_IntendedUse_YTD.txt	11
	A00480_Interval_YTD.txt	41
	A00490_IrrigationPractice_YTD.txt	3
	A00500_OrganicPractice_YTD.txt	3
	A00510_Practice_YTD.txt	642
	A00520_State_YTD.txt	50
	A00530_SubClass_YTD.txt	5
	A00540_Type_YTD.txt	354
	A00550_DocumentStructure_YTD.txt	20
	A00560_EndorsementLength_YTD.txt	1
	A00570_InsuranceOption_YTD.txt	30
	A00580_RateMethod_YTD.txt	4
	A00590_SpoiGroup_YTD.txt	27
	A00615_Draw_YTD.txt	23,912,500
	A00810_Price_YTD.txt	2,323,761
	A01000_AgrRate_YTD.txt	10,747,343
	A01010_BaseRate_YTD.txt	116,585
	A01020_Beta_YTD.txt	37,500
	A01030_ComboRevenueFactor_YTD.txt	1,108,890
	A01040_CoverageLevelDifferential_YTD.txt	3,101,432
	A01050_SubCountyRate_YTD.txt	29,364
	A01060_OptionRate_YTD.txt	731,899
	A01070_Proration_YTD.txt	384
	A01090_UnitDiscount_YTD.txt	818
	A01100_YieldAndTyield_YTD.txt	3,798,987
	A01105_YieldExclusion_YTD.txt	145,518
	A01110_HistoricalRevenueCapping_YTD.txt	17,688
	A01115_HistoricalYieldTrend_YTD.txt	263,761
	A01120_AreaDataSource_YTD.txt	57
	A01125_ProductionArea_YTD.txt	59,325
	A01130_AreaCoverageLevel_YTD.txt	11,270,179
	A01135_AreaRate_YTD.txt	4,122,638
	A01200_DocumentBuilder_YTD.txt	2,350,578
	A01210_Statement_YTD.txt	764
	A01220_GuaranteeAdjustment_YTD.txt	183,822