1.  

ACTUARIAL RELEASE: Actuarial Release–17-027

United States Department of Agriculture


Farm and Foreign Agricultural Services


Risk Management Agency


1400 Independence Avenue, SW
Stop 0801
Washington, DC  20250-0801

Date

August 28, 2017

To:

All Insurance Providers

From:

Zachary White Chief, Actuarial Branch /s/ Zachary White    8/28/2017

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 Actuarial Bulletins. 

Action
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
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
USDA is an Equal Opportunity Employer and Provider

   Office

  • USDA, Office of the Assistant Secretary for Civil Rights, Office of Adjudication
    1400 Independence Ave., SW
    Washington, DC 20250-9410
  • Phone: 866-632-9992
  • Fax: 800-877-8339