Actuarial Release Bulletin 17-027

TO:

All Insurance Providers

Zachary White

/s/ Zachary White

FROM:

Chief, Actuarial Branch

SUBJECT:

Actuarial Release 17-027 - Actuarial Information Available

As of August 28, 2017 the following information is now available on the FTP site:


•	2018 Actuarial Data Master for the 6/30, 8/31, 9/30, 10/31 Filing Date, YTD, and Daily Files.
•	2018 Special Provisions for the 6/30, 8/31, 10/31 Filing Date.

Users can find this information in the following directories:


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

Additional notes and details regarding this data release:

2018 ADM for applicable plan 31 SCO commodities are now released for the 8/31, 9/30, and 10/31 filings.
2018 Special Provisions and ADM are now issued for almonds, apples, olives, and PRF/API.
2018 ADM Price records are issued for the 8/31 filing.
2018 Special Provisions for 3 California pistachios counties (Kern, Madera, Tulare) revised to add a new unique variability adjustment factor statement to each (ADM Document Builder updated), 8/31 filing.
2018 Special Provisions are re-issued for selected counties in Oklahoma and Texas were Actuarial maps where removed for barley, canola, or oats, but did not remove HR statement code 00008, (ADM Document Builder records now marked with a deleted date for statement 00008), 6/30 filing. The AIB "Rates" tab will no longer display map statement 00050 for these counties.

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_170826.zip	A00030_InsuranceOffer_Daily.txt	225,618
	A00045_Map_Daily.txt	3,820,731
	A00070_SubsidyPercent_Daily.txt	19
	A00200_Date_Daily.txt	225,618
	A00420_Commodity_Daily.txt	5
	A00430_CommodityType_Daily.txt	4
	A00450_CroppingPractice_Daily.txt	1
	A00470_IntendedUse_Daily.txt	4
	A00510_Practice_Daily.txt	87
	A00540_Type_Daily.txt	12
	A00570_InsuranceOption_Daily.txt	1
	A00810_Price_Daily.txt	1,946,024
	A01010_BaseRate_Daily.txt	8,550
	A01040_CoverageLevelDifferential_Daily.txt	1,187,301
	A01050_SubCountyRate_Daily.txt	924
	A01060_OptionRate_Daily.txt	48,263
	A01090_UnitDiscount_Daily.txt	1
	A01100_YieldAndTyield_Daily.txt	995,061
	A01105_YieldExclusion_Daily.txt	4,899
	A01115_HistoricalYieldTrend_Daily.txt	21,159
	A01120_AreaDataSource_Daily.txt	21
	A01125_ProductionArea_Daily.txt	6,914
	A01130_AreaCoverageLevel_Daily.txt	9,661,779
	A01135_AreaRate_Daily.txt	1,455,270
	A01200_DocumentBuilder_Daily.txt	670,365
	A01210_Statement_Daily.txt	45


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	107,212
	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	657,246
	A01200_DocumentBuilder_Filing.txt	1,234,230
	A01220_GuaranteeAdjustment_Filing.txt	181,947


2018_ADM_Filing_0831.zip	A00030_InsuranceOffer_Filing.txt	237,788
	A00045_Map_Filing.txt	3,819,012
	A00200_Date_Filing.txt	237,788
	A00810_Price_Filing.txt	1,946,024
	A01010_BaseRate_Filing.txt	23,426
	A01040_CoverageLevelDifferential_Filing.txt	1,304,000
	A01050_SubCountyRate_Filing.txt	3,294
	A01060_OptionRate_Filing.txt	94,395
	A01070_Proration_Filing.txt	384
	A01100_YieldAndTyield_Filing.txt	2,072,562
	A01105_YieldExclusion_Filing.txt	12,228
	A01130_AreaCoverageLevel_Filing.txt	9,640,959
	A01200_DocumentBuilder_Filing.txt	774,380
	A01220_GuaranteeAdjustment_Filing.txt	198


2018_ADM_Filing_0930.zip	A00030_InsuranceOffer_Filing.txt	1,383
	A00045_Map_Filing.txt	18
	A00200_Date_Filing.txt	1,383
	A01010_BaseRate_Filing.txt	1,239
	A01040_CoverageLevelDifferential_Filing.txt	11,199
	A01050_SubCountyRate_Filing.txt	18
	A01060_OptionRate_Filing.txt	4,884
	A01100_YieldAndTyield_Filing.txt	20,043
	A01105_YieldExclusion_Filing.txt	438
	A01130_AreaCoverageLevel_Filing.txt	1,152
	A01200_DocumentBuilder_Filing.txt	12,315
	A01220_GuaranteeAdjustment_Filing.txt	1,494


2018_ADM_Filing_1031.zip	A00030_InsuranceOffer_Filing.txt	7,164
	A00045_Map_Filing.txt	8,037
	A00200_Date_Filing.txt	7,164
	A01010_BaseRate_Filing.txt	4,602
	A01040_CoverageLevelDifferential_Filing.txt	56,466
	A01050_SubCountyRate_Filing.txt	60
	A01060_OptionRate_Filing.txt	13,110
	A01100_YieldAndTyield_Filing.txt	71,373
	A01105_YieldExclusion_Filing.txt	1,413
	A01130_AreaCoverageLevel_Filing.txt	19,668
	A01200_DocumentBuilder_Filing.txt	37,941


2018_ADM_YTD.zip	A00010_AdmLayout_YTD.txt	1,140
	A00030_InsuranceOffer_YTD.txt	453,249
	A00045_Map_YTD.txt	4,308,711
	A00050_Quality_YTD.txt	258
	A00070_SubsidyPercent_YTD.txt	338
	A00200_Date_YTD.txt	459,432
	A00410_Class_YTD.txt	14
	A00420_Commodity_YTD.txt	79
	A00430_CommodityType_YTD.txt	245
	A00440_County_YTD.txt	3,166
	A00450_CroppingPractice_YTD.txt	58
	A00460_InsurancePlan_YTD.txt	20
	A00470_IntendedUse_YTD.txt	11
	A00480_Interval_YTD.txt	41
	A00490_IrrigationPractice_YTD.txt	3
	A00500_OrganicPractice_YTD.txt	3
	A00510_Practice_YTD.txt	641
	A00520_State_YTD.txt	50
	A00530_SubClass_YTD.txt	5
	A00540_Type_YTD.txt	351
	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
	A00810_Price_YTD.txt	2,260,814
	A01010_BaseRate_YTD.txt	116,585
	A01020_Beta_YTD.txt	37,500
	A01030_ComboRevenueFactor_YTD.txt	1,108,890
	A01040_CoverageLevelDifferential_YTD.txt	3,026,120
	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	174,504
	A01120_AreaDataSource_YTD.txt	52
	A01125_ProductionArea_YTD.txt	58,704
	A01130_AreaCoverageLevel_YTD.txt	11,213,635
	A01135_AreaRate_YTD.txt	4,083,074
	A01200_DocumentBuilder_YTD.txt	2,213,621
	A01210_Statement_YTD.txt	750
	A01220_GuaranteeAdjustment_YTD.txt	183,822


2018_SPOI_0630.zip	2018 Special Provisions 06/30 Filing Date	6,479


2018_SPOI_0831.zip	2018 Special Provisions 08/31 Filing Date	7,189


2018_SPOI_1031.zip	2018 Special Provisions 10/31 Filing Date	361