ACTUARIAL RELEASE: Actuarial Release–18-029
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 24, 2018
To:
All Insurance Providers
From:
Zachary White, Chief, Actuarial Branch /s/ Zachary White 8/24/2018
Subject:
Actuarial Release 18-029 - Actuarial Information Available
-
As of August 24, 2018 the following information is now available on the FTP site:
- 2018 Actuarial Data Master for the 11/30 Filing Date, YTD, and Daily Files.
- 2019 Actuarial Data Master for the 6/30, 8/31, 9/30, 10/31 Filing Date, YTD, and Daily Files.
- 2019 Special Provisions for the 8/31, 9/30, 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.
- 2019 Actuarial Data Master are in the References/Actuarial_Data_Master/2019 directory.
- 2019 Special Provisions are in the Special_Provisions/2019 directory.
Additional notes and details regarding this data release:
2019 Special Provisions and ADM are now issued for the 8/31, 9/30, and 10/31 filings except for PRF/API, Pecans, and Whole Farm Revenue Protection (WFRP) along with prices to be issued later.
2019 ADM Price updated for contract price indicator flag set to 'CP' on Alfalfa Seed (0107/plan 90 & 31), 6/30 filing.
2018 Margin Protection (MP) now has "yield year" of 2017 records populated on ADM Historical Yield Trend (61 rows) for Rice, 11/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 www.rma.usda.gov/Policy-and-Procedure/Bulletins-and-Memos/Actuarial-Releases.
-
File Name Contains Record Count 2018_ADM_Daily_180824.zip A01115_HistoricalYieldTrend_Daily.txt 61 2018_ADM_Filing_1130.zip A00030_InsuranceOffer_Filing.txt
A00045_Map_Filing.txt
A00200_Date_Filing.txt
A00810_Price_Filing.txt
A01010_BaseRate_Filing.txt
A01040_CoverageLevelDifferential_Filing.txt
A01050_SubCountyRate_Filing.txt
A01060_OptionRate_Filing.txt
A01100_YieldAndTyield_Filing.txt
A01105_YieldExclusion_Filing.txt
A01110_HistoricalRevenueCapping_Filing.txt
A01130_AreaCoverageLevel_Filing.txt
A01200_DocumentBuilder_Filing.txt
A01220_GuaranteeAdjustment_Filing.txt
887,120
213,653
887,771
961,343
419,549
8,412,792
160,795
3,243,686
7,581,728
478,074
138,498
3,985,032
5,880,385
813,1872018_ADM_YTD.zip A00010_AdmLayout_YTD.txt
A00030_InsuranceOffer_YTD.txt
A00045_Map_YTD.txt
A00050_Quality_YTD.txt
A00070_SubsidyPercent_YTD.txt
A00200_Date_YTD.txt
A00400_AgrCommodity_YTD.txt
A00410_Class_YTD.txt
A00420_Commodity_YTD.txt
A00430_CommodityType_YTD.txt
A00440_County_YTD.txt
A00450_CroppingPractice_YTD.txt
A00460_InsurancePlan_YTD.txt
A00470_IntendedUse_YTD.txt
A00480_Interval_YTD.txt
A00490_IrrigationPractice_YTD.txt
A00500_OrganicPractice_YTD.txt
A00510_Practice_YTD.txt
A00520_State_YTD.txt
A00530_SubClass_YTD.txt
A00540_Type_YTD.txt
A00550_DocumentStructure_YTD.txt
A00560_EndorsementLength_YTD.txt
A00570_InsuranceOption_YTD.txt
A00580_RateMethod_YTD.txt
A00590_SpoiGroup_YTD.txt
A00615_Draw_YTD.txt
A00810_Price_YTD.txt
A01000_AgrRate_YTD.txt
A01010_BaseRate_YTD.txt
A01020_Beta_YTD.txt
A01030_ComboRevenueFactor_YTD.txt
A01040_CoverageLevelDifferential_YTD.txt
A01050_SubCountyRate_YTD.txt
A01060_OptionRate_YTD.txt
A01070_Proration_YTD.txt
A01090_UnitDiscount_YTD.txt
A01100_YieldAndTyield_YTD.txt
A01105_YieldExclusion_YTD.txt
A01110_HistoricalRevenueCapping_YTD.txt
A01115_HistoricalYieldTrend_YTD.txt
A01120_AreaDataSource_YTD.txt
A01125_ProductionArea_YTD.txt
A01130_AreaCoverageLevel_YTD.txt
A01135_AreaRate_YTD.txt
A01200_DocumentBuilder_YTD.txt
A01210_Statement_YTD.txt
A01220_GuaranteeAdjustment_YTD.txt
1,140
1,585,673
4,524,059
531
501
1,592,507
435
24
128
364
3,190
82
25
12
41
3
3
1,114
50
6
552
21
1
49
4
103
24,022,100
3,495,091
10,747,415
771,607
121,500
2,857,140
13,210,970
191,605
4,764,292
2,738,688
2,851
11,391,731
624,090
156,186
801,190
128
177,946
15,257,677
11,507,018
13,720,315
1,292
997,825
2019_ADM_Daily_180824.zip A00030_InsuranceOffer_Daily.txt
A00045_Map_Daily.txt
A00050_Quality_Daily.txt
A00070_SubsidyPercent_Daily.txt
A00200_Date_Daily.txt
A00410_Class_Daily.txt
A00420_Commodity_Daily.txt
A00430_CommodityType_Daily.txt
A00450_CroppingPractice_Daily.txt
A00460_InsurancePlan_Daily.txt
A00470_IntendedUse_Daily.txt
A00510_Practice_Daily.txt
A00530_SubClass_Daily.txt
A00540_Type_Daily.txt
A00550_DocumentStructure_Daily.txt
A00570_InsuranceOption_Daily.txt
A00810_Price_Daily.txt
A01010_BaseRate_Daily.txt
A01040_CoverageLevelDifferential_Daily.txt
A01050_SubCountyRate_Daily.txt
A01060_OptionRate_Daily.txt
A01070_Proration_Daily.txt
A01090_UnitDiscount_Daily.txt
A01100_YieldAndTyield_Daily.txt
A01105_YieldExclusion_Daily.txt
A01115_HistoricalYieldTrend_Daily.txt
A01120_AreaDataSource_Daily.txt
A01125_ProductionArea_Daily.txt
A01130_AreaCoverageLevel_Daily.txt
A01135_AreaRate_Daily.txt
A01200_DocumentBuilder_Daily.txt
A01210_Statement_Daily.txt
A01220_GuaranteeAdjustment_Daily.txt
47,621
10,158
21
32
47,621
3
38
175
20
1
3
228
2
237
1
4
684
28,985
378,026
3,405
140,805
384
1
2,168,598
15,588
22,043
21
6,960
129,396
5,230
224,813
317
1,128
2019_ADM_Filing_0630.zip A00030_InsuranceOffer_Filing.txt
A00045_Map_Filing.txt
A00200_Date_Filing.txt
A00810_Price_Filing.txt
A01010_BaseRate_Filing.txt
A01040_CoverageLevelDifferential_Filing.txt
A01050_SubCountyRate_Filing.txt
A01060_OptionRate_Filing.txt
A01100_YieldAndTyield_Filing.txt
A01105_YieldExclusion_Filing.txt
A01110_HistoricalRevenueCapping_Filing.txt
A01130_AreaCoverageLevel_Filing.txt
A01200_DocumentBuilder_Filing.txt
A01220_GuaranteeAdjustment_Filing.txt
184,025
38,038
190,244
108,950
86,145
1,582,984
24,501
635,912
1,715,274
136,737
17,688
668,430
1,149,357
122,145
2019_ADM_Filing_0831.zip A00030_InsuranceOffer_Filing.txt
A00045_Map_Filing.txt
A00200_Date_Filing.txt
A01010_BaseRate_Filing.txt
A01040_CoverageLevelDifferential_Filing.txt
A01050_SubCountyRate_Filing.txt
A01060_OptionRate_Filing.txt
A01070_Proration_Filing.txt
A01100_YieldAndTyield_Filing.txt
A01105_YieldExclusion_Filing.txt
A01130_AreaCoverageLevel_Filing.txt
A01200_DocumentBuilder_Filing.txt
A01220_GuaranteeAdjustment_Filing.txt
39,839
4,707
39,839
23,909
315,716
3,327
119,879
384
2,074,962
13,533
108,576
182,198
132
2019_ADM_Filing_0930.zip A00030_InsuranceOffer_Filing.txt
A00045_Map_Filing.txt
A00200_Date_Filing.txt
A01010_BaseRate_Filing.txt
A01040_CoverageLevelDifferential_Filing.txt
A01050_SubCountyRate_Filing.txt
A01060_OptionRate_Filing.txt
A01100_YieldAndTyield_Filing.txt
A01105_YieldExclusion_Filing.txt
A01130_AreaCoverageLevel_Filing.txt
A01200_DocumentBuilder_Filing.txt
A01220_GuaranteeAdjustment_Filing.txt
1,389
18
1,389
1,245
11,241
18
5,779
21,330
630
1,152
11,916
996
2019_ADM_Filing_1031.zip A00030_InsuranceOffer_Filing.txt
A00045_Map_Filing.txt
A00200_Date_Filing.txt
A01010_BaseRate_Filing.txt
A01040_CoverageLevelDifferential_Filing.txt
A01050_SubCountyRate_Filing.txt
A01060_OptionRate_Filing.txt
A01100_YieldAndTyield_Filing.txt
A01105_YieldExclusion_Filing.txt
A01130_AreaCoverageLevel_Filing.txt
A01200_DocumentBuilder_Filing.txt
6,393
5,433
6,393
3,831
51,069
60
15,147
72,306
1,425
19,668
30,699
2019_ADM_YTD.zip A00010_AdmLayout_YTD.txt
A00030_InsuranceOffer_YTD.txt
A00045_Map_YTD.txt
A00050_Quality_YTD.txt
A00070_SubsidyPercent_YTD.txt
A00200_Date_YTD.txt
A00410_Class_YTD.txt
A00420_Commodity_YTD.txt
A00430_CommodityType_YTD.txt
A00440_County_YTD.txt
A00450_CroppingPractice_YTD.txt
A00460_InsurancePlan_YTD.txt
A00470_IntendedUse_YTD.txt
A00480_Interval_YTD.txt
A00490_IrrigationPractice_YTD.txt
A00500_OrganicPractice_YTD.txt
A00510_Practice_YTD.txt
A00520_State_YTD.txt
A00530_SubClass_YTD.txt
A00540_Type_YTD.txt
A00550_DocumentStructure_YTD.txt
A00560_EndorsementLength_YTD.txt
A00570_InsuranceOption_YTD.txt
A00580_RateMethod_YTD.txt
A00590_SpoiGroup_YTD.txt
A00810_Price_YTD.txt
A01010_BaseRate_YTD.txt
A01020_Beta_YTD.txt
A01030_ComboRevenueFactor_YTD.txt
A01040_CoverageLevelDifferential_YTD.txt
A01050_SubCountyRate_YTD.txt
A01060_OptionRate_YTD.txt
A01070_Proration_YTD.txt
A01090_UnitDiscount_YTD.txt
A01100_YieldAndTyield_YTD.txt
A01105_YieldExclusion_YTD.txt
A01110_HistoricalRevenueCapping_YTD.txt
A01115_HistoricalYieldTrend_YTD.txt
A01120_AreaDataSource_YTD.txt
A01125_ProductionArea_YTD.txt
A01130_AreaCoverageLevel_YTD.txt
A01135_AreaRate_YTD.txt
A01200_DocumentBuilder_YTD.txt
A01210_Statement_YTD.txt
A01220_GuaranteeAdjustment_YTD.txt
1,274
257,113
474,117
259
319
263,332
14
76
243
3,191
58
20
9
49
3
3
571
50
5
349
20
1
30
4
30
324,456
117,041
37,500
1,108,890
2,066,799
28,479
780,536
384
817
3,891,054
152,325
17,688
173,843
52
58,937
1,732,076
2,678,998
1,552,618
740
123,396
2019_SPOI_0831.zip 2019 Special Provisions 08/31 Filing Date 1,065 2019_SPOI_0930.zip 2019 Special Provisions 09/30 Filing Date 86 2019_SPOI_1031.zip 2019 Special Provisions 10/31 Filing Date 222