ACTUARIAL RELEASE: Actuarial Release–20-028
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 20, 2020
To:
All Insurance Providers
From:
Megan Heyns, Chief, Filing Branch /s/ 7/20/2020
Subject:
Actuarial Release 20-028 - Actuarial Information Available
-
As of July 20, 2020 the following information is now available on the FTP site:
- 2020 Actuarial Data Master for the 6/30 Filing Date, YTD, and Daily Files.
- 2021 Actuarial Data Master for the 4/30 Filing Date, YTD, and Daily Files.
- 2021 Special Provisions for the 4/30 Filing Date.
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.
- 2021 Special Provisions are in the Special_Provisions/2021 directory.
Additional notes and details regarding this data release:
2021 RY ADM Date and ADM Subsidy Percent refiled to add subsidy for LGM cattle and swine and move premium billing to end of endorsement for LGM cattle, reference PM-20-048, 4/30 filing.
2021 RY ADM Date refiled to correct Cancellation Date for forage seeding in CO, KS, and NE, 4/30 filing.
2020 RY ADM Price refiled to populate CP flag for malting barley in OH, 6/30 filing.
2020 RY ADM Coverage Level Differential updated to populate missing records for Margin Protection, 6/30 filing.
2021 RY ADM and Special Provisions are now issued for Production Revenue History (PRH), new insurance plans 21, 22, and 23, Strawberries in FL, reference PM-20-049, 4/30 filing.Please 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_200720.zip A00810_Price_Daily.txt
A01040_CoverageLevelDifferential_Daily.txt
210
72
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_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,831,970
412
28
135
376
3,191
94
27
14
54
3
3
1,212
50
6
583
21
1
56
4
106
4,481,700
3,693,114
11,331,024
862,976
121,500
2,867,130
14,511,346
217,929
5,722,078
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_200720.zip A00030_InsuranceOffer_Daily.txt
A00070_SubsidyPercent_Daily.txt
A00200_Date_Daily.txt
A00450_CroppingPractice_Daily.txt
A00460_InsurancePlan_Daily.txt
A00510_Practice_Daily.txt
A00590_SpoiGroup_Daily.txt
A00810_Price_Daily.txt
A01010_BaseRate_Daily.txt
A01030_ComboRevenueFactor_Daily.txt
A01040_CoverageLevelDifferential_Daily.txt
A01060_OptionRate_Daily.txt
A01100_YieldAndTyield_Daily.txt
A01200_DocumentBuilder_Daily.txt
A01210_Statement_Daily.txt
36
76
2,364
1
3
3
3
36
36
9,990
300
108
1,440
144
3
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
2021_SPOI_0430.zip 2021 Special Provisions 04/30 Filing Date 1,968