ACTUARIAL RELEASE: Actuarial Release–20-030
United States Department of Agriculture
Farm and Foreign Agricultural Services
Risk Management Agency
1400 Independence Avenue, SW
Stop 0801
Washington, DC 20250-0801
Date
July 28, 2020
To:
All Insurance Providers
From:
Megan Heyns, Chief, Filing Branch /s/ Megan Heyns 7/28/2020
Subject:
Actuarial Release 20-030 - Actuarial Information Available
-
As of July 28, 2020 the following information is now available on the FTP site:
- 2020 Actuarial Data Master for the 6/30, 8/31, 11/30 Filing Date, YTD, and Daily Files.
- 2021 Actuarial Data Master for the 4/30 Filing Date, YTD, and Daily Files.
Users can find this information in the following directories:
- 2020 Actuarial Data Master are in the References/Actuarial_Data_Master/2020 directory.
- 2021 Actuarial Data Master are in the References/Actuarial_Data_Master/2021 directory.
Additional notes and details regarding this data release:
2020 RY ADM Insurance Option, ADM Date, and ADM Option Rate are released to issue the new HIP-WI Extension (HE) insurance option and associated information reference PM-20-051, 8/31 filing.
2020 RY ADM Option Rate is reissued to delete Winter Coverage Option (WO) records for durum wheat in MT, 6/30 filing.
2020 RY ADM Price is reissued to update the Contract Price Code to null for ELS cotton SE option, 11/30 filing.
2021 RY ADM Insurance Offer is reissued to change Type Practice Use Code to “T” for PRH Strawberries, 4/30 filingPlease notify your data processing representative that this information is available for downloading. For questions regarding the actuarial information, please contact Megan Heyns by phone at (816) 926-5636, or via email to megan.heyns@rma.usda.gov
Archived release bulletins are located online at https://www.rma.usda.gov/Policy-and-Procedure/Bulletins-and-Memos/Actuarial-Releases
-
File Name Contains Record Count 2020_ADM_Daily_200728.zip A00200_Date_Daily.txt
A00570_InsuranceOption_Daily.txt
A00810_Price_Daily.txt
A01060_OptionRate_Daily.txt
3,654
1
133
3,816
2020_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
190,205
38,613
196,460
187,538
87,582
1,604,374
25,059
719,581
1,837,851
139,539
17,604
725,130
1,219,151
124,863
2020_ADM_Filing_0831.zip A00030_InsuranceOffer_Filing.txt
A00045_Map_Filing.txt
A00200_Date_Filing.txt
A00810_Price_Filing.txt
A01000_AgrRate_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
255,616
3,817,935
259,270
1,947,818
11,331,024
24,770
1,396,672
3,273
158,270
384
2,216,220
14,169
9,641,763
1,209,788
132
2020_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
1,027,730
234,337
1,028,111
1,068,266
497,075
9,403,571
186,696
3,954,845
9,157,164
536,646
137,256
4,220,868
6,893,323
873,664
2020_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
A01140_HipRate_YTD.txt
A01200_DocumentBuilder_YTD.txt
A01210_Statement_YTD.txt
A01220_GuaranteeAdjustment_YTD.txt
A01230_ContiguousCounty_YTD.txt
1,307
1,825,334
4,524,603
555
904
1,835,624
412
28
135
376
3,191
94
27
14
54
3
3
1,212
50
6
583
21
1
57
4
106
4,481,700
3,693,114
11,331,024
862,976
121,500
2,867,130
14,511,346
217,929
5,725,732
2,747,436
4,181
13,335,105
693,135
154,860
636,463
96
179,727
15,545,369
11,959,682
5,639
14,197,790
1,368
1,000,756
15,958
2021_ADM_Daily_200728.zip A00030_InsuranceOffer_Daily.txt 36 2021_ADM_Filing_0430.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
A01070_Proration_Filing.txt
A01100_YieldAndTyield_Filing.txt
A01130_AreaCoverageLevel_Filing.txt
A01200_DocumentBuilder_Filing.txt
A01220_GuaranteeAdjustment_Filing.txt
54,447
429,473
54,447
267,650
18,929
257,869
4,125
71,928
5,100
9,420
934,250
494,111
123
2021_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
A01140_HipRate_YTD.txt
A01200_DocumentBuilder_YTD.txt
A01210_Statement_YTD.txt
A01220_GuaranteeAdjustment_YTD.txt
A01230_ContiguousCounty_YTD.txt
1,319
252,726
469,886
250
481
259,089
11
41
82
3,191
41
24
6
71
3
3
415
50
3
132
20
1
32
4
33
415,226
110,219
37,500
1,118,880
1,928,108
30,522
957,991
5,100
819
2,022,720
146,712
17,604
138,855
20
52,117
1,631,756
3,106,860
913
1,749,795
480
125,562
13,607